Query Metrics
7
Database Queries
7
Different statements
202.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.26 ms (86.27%) |
1 |
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id AND f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id` AND `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 130429 311734 370829 391873 402628 402731 418054 418111 419319 421488 432982 435104 439244 439528 439542 439553 441457 442970 443565 444060 446612 448781 452696 453112 454643 455467 456221 464833 464905 465790 465850 465873 465934 468388 470365 478333 484899 488102 499477 502584 503255 503268 504935 509815 511346 512099 516284 516650 517962 528519 528578 529377 533522 535521 542127 547538 549813 558590 559542 562377 564493 564517 578527 580418 581488 584716 599031 602409 603040 609743 610711 613753 615676 616869 618849 619832 627361 630697 632502 651276 661974 663801 672260 674863 690859 692314 700263 712631 717835 719014 720659 720664 721907 727771 735202 736881 737130 746366 757906 761137 761591 761743 762913 777905 782450 785603 785972 790190 792961 794389 796155 800604 803306 805642 811870 814501 818206 821765 823707 ] |
||||||||||||||||||||||||||||||
|
16.73 ms (8.28%) |
1 |
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id` AND `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id` AND `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 418054 528578 719014 757906 468388 512099 444060 488102 516284 547538 599031 630697 402731 465873 484899 517962 528519 581488 584716 448781 443565 465790 580418 618849 465934 454643 503268 672260 790190 761743 785603 761591 762913 735202 805642 610711 559542 402628 821765 823707 700263 613753 603040 796155 727771 737130 794389 435104 470365 535521 627361 439244 578527 439528 814501 455467 663801 619832 785972 761137 504935 529377 602409 439542 558590 792961 564493 439553 509815 465850 452696 564517 562377 721907 464833 478333 511346 499477 533522 615676 782450 446612 421488 746366 616869 651276 811870 391873 432982 818206 692314 736881 717835 690859 777905 419319 453112 130429 311734 456221 502584 720659 609743 442970 516650 549813 674863 712631 800604 803306 632502 720664 418111 464905 503255 542127 661974 370829 441457 465885 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.40%) |
1 |
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 130429 311734 370829 391873 402628 402731 418054 418111 419319 421488 432982 435104 439244 439528 439542 439553 441457 442970 443565 444060 446612 448781 452696 453112 454643 455467 456221 464833 464905 465790 465850 465873 465934 468388 470365 478333 484899 488102 499477 502584 503255 503268 504935 509815 511346 512099 516284 516650 517962 528519 528578 529377 533522 535521 542127 547538 549813 558590 559542 562377 564493 564517 578527 580418 581488 584716 599031 602409 603040 609743 610711 613753 615676 616869 618849 619832 627361 630697 632502 651276 661974 663801 672260 674863 690859 692314 700263 712631 717835 719014 720659 720664 721907 727771 735202 736881 737130 746366 757906 761137 761591 761743 762913 777905 782450 785603 785972 790190 792961 794389 796155 800604 803306 805642 811870 814501 818206 821765 823707 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс me анал"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс me анал"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck me anal"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
No loaded entities.