Query Metrics
7
Database Queries
7
Different statements
160.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.15 ms (86.58%) |
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 263296 388780 389389 389860 392554 392952 394154 395724 396110 396215 397436 401108 401109 401976 402226 403965 408278 409820 411451 590063 596653 598018 600283 604327 609875 627759 630289 635250 640526 642012 644326 654332 654439 656621 660342 672112 674216 710368 712174 715453 717921 720103 720787 720813 721426 722555 722782 722847 724023 725113 725606 727416 727653 727654 728240 728260 728424 728447 728451 730764 731360 732036 734662 736394 736601 737079 739460 740373 740653 743197 747384 748339 748927 749328 749669 750702 752627 753454 753474 753477 756841 756973 757276 757514 759005 760916 760942 760991 761482 761483 762163 762980 766588 766690 769904 770441 773577 779069 782405 782428 782539 785321 785335 786768 786942 789532 789950 790371 795977 796343 797505 799349 799375 801213 801344 803673 803941 812343 812351 813534 ] |
||||||||||||||||||||||||||||||
|
12.74 ms (7.92%) |
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 721426 722847 654332 654439 656621 660342 672112 674216 710368 715453 717921 720103 722555 598018 600283 635250 644326 596653 604327 642012 590063 627759 630289 640526 790371 799375 801213 779069 786768 789532 812351 725113 725606 727416 727653 727654 730764 736394 740373 743197 748339 756841 756973 757276 761482 766588 782539 786942 789950 795977 796343 797505 801344 803673 813534 728240 728424 731360 736601 748927 753477 757514 762980 770441 724023 728447 732036 750702 753474 759005 760916 760942 762163 769904 773577 728451 739460 740653 753454 761483 728260 734662 737079 747384 749328 749669 752627 760991 766690 609875 712174 720787 720813 722782 782405 782428 785321 785335 799349 803941 812343 392554 396215 397436 402226 389389 409820 394154 395724 392952 263296 389860 388780 396110 401976 401108 401109 403965 408278 411451 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.64%) |
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 263296 388780 389389 389860 392554 392952 394154 395724 396110 396215 397436 401108 401109 401976 402226 403965 408278 409820 411451 590063 596653 598018 600283 604327 609875 627759 630289 635250 640526 642012 644326 654332 654439 656621 660342 672112 674216 710368 712174 715453 717921 720103 720787 720813 721426 722555 722782 722847 724023 725113 725606 727416 727653 727654 728240 728260 728424 728447 728451 730764 731360 732036 734662 736394 736601 737079 739460 740373 740653 743197 747384 748339 748927 749328 749669 750702 752627 753454 753474 753477 756841 756973 757276 757514 759005 760916 760942 760991 761482 761483 762163 762980 766588 766690 769904 770441 773577 779069 782405 782428 782539 785321 785335 786768 786942 789532 789950 790371 795977 796343 797505 799349 799375 801213 801344 803673 803941 812343 812351 813534 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal pussy"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал pussy"
]
|
||||||||||||||||||||||||||||||
|
1.28 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал pussy"
]
|
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.