Query Metrics
7
Database Queries
7
Different statements
159.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.51 ms (81.04%) |
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 384491 391925 391994 392025 403871 412627 413700 420647 441040 446789 454140 463982 463989 471030 471461 471646 473400 479722 479919 481927 487413 491436 492182 509113 513010 517533 533117 533988 534667 535277 535317 540032 550542 554610 554865 555189 555245 557468 559789 562603 564480 570889 570892 582167 587163 588628 588759 592357 592897 592988 593310 593412 593545 594363 594579 596039 596201 600905 602158 603109 604737 604988 605087 605661 613576 614772 614782 614794 614852 617552 619714 628655 629047 631723 633182 634750 639221 641997 643700 644126 650258 656515 657489 662856 663212 666672 670762 670811 694751 700821 700965 709128 712108 713332 716058 738297 740384 744203 750110 751506 752950 758256 777350 778815 785263 788778 793011 802254 802266 804443 807902 808967 808979 809548 812552 812556 813132 814211 818686 826498 ] |
||||||||||||||||||||||||||||||
|
17.89 ms (11.20%) |
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 594579 604737 604988 617552 593545 631723 593412 614794 634750 588628 614772 778815 788778 802266 804443 785263 808967 813132 740384 750110 738297 744203 751506 758256 605087 614782 633182 643700 716058 793011 812556 392025 517533 384491 588759 391994 479919 471030 540032 557468 666672 709128 670762 596201 596039 492182 641997 441040 454140 473400 446789 463989 471461 535277 487413 656515 657489 391925 509113 513010 592988 605661 613576 663212 491436 629047 570889 582167 619714 594363 802254 807902 713332 463982 471646 412627 403871 413700 420647 826498 814211 818686 479722 481927 535317 533117 533988 534667 562603 554865 570892 555189 564480 694751 700821 650258 662856 670811 700965 712108 550542 554610 555245 559789 628655 587163 602158 644126 592897 600905 603109 592357 593310 614852 639221 812552 777350 808979 809548 752950 ] |
||||||||||||||||||||||||||||||
|
4.50 ms (2.82%) |
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 384491 391925 391994 392025 403871 412627 413700 420647 441040 446789 454140 463982 463989 471030 471461 471646 473400 479722 479919 481927 487413 491436 492182 509113 513010 517533 533117 533988 534667 535277 535317 540032 550542 554610 554865 555189 555245 557468 559789 562603 564480 570889 570892 582167 587163 588628 588759 592357 592897 592988 593310 593412 593545 594363 594579 596039 596201 600905 602158 603109 604737 604988 605087 605661 613576 614772 614782 614794 614852 617552 619714 628655 629047 631723 633182 634750 639221 641997 643700 644126 650258 656515 657489 662856 663212 666672 670762 670811 694751 700821 700965 709128 712108 713332 716058 738297 740384 744203 750110 751506 752950 758256 777350 778815 785263 788778 793011 802254 802266 804443 807902 808967 808979 809548 812552 812556 813132 814211 818686 826498 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass hairy solo"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп волосатая соло"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп волосатая соло"
]
|
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.