Query Metrics
7
Database Queries
7
Different statements
154.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.59 ms (85.63%) |
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 397406 417328 418226 431592 431718 441476 450473 450721 451410 473529 480976 483378 493083 493543 495389 499069 505670 508909 509557 511478 518887 518959 531849 542059 542411 543703 549100 549106 549538 553687 556652 577970 578337 584865 585605 586011 590241 594553 607985 616053 616449 616829 619358 623085 623277 626327 632095 632868 641458 648917 651901 670248 676205 698091 706467 712642 715795 718582 726082 726736 731827 738505 738841 739584 739587 741239 743766 747222 750115 750788 750789 751702 757941 759049 761584 764154 764562 767042 767141 767183 777320 778470 784294 784770 785166 785477 787600 789763 793113 793114 793383 793934 794096 794962 794969 794971 794980 794981 795005 795684 796732 796980 797098 797115 797122 800236 801045 804307 805335 809112 809797 809811 809813 809816 810065 817025 817139 817206 817758 820365 ] |
||||||||||||||||||||||||||||||
|
12.73 ms (8.22%) |
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 418226 417328 778470 797122 809797 796732 809813 817139 616449 718582 651901 767141 801045 549106 739587 577970 804307 789763 698091 759049 578337 585605 616829 809112 757941 495389 796980 623277 590241 793113 738505 820365 794096 676205 793383 739584 518887 809816 743766 787600 670248 810065 741239 777320 556652 793934 531849 761584 784770 731827 794980 797098 553687 623085 632095 431592 480976 706467 751702 794962 607985 797115 800236 616053 750789 431718 817206 632868 726736 795005 626327 805335 794971 499069 817758 794969 397406 549538 795684 518959 794981 543703 586011 764154 726082 785477 549100 483378 809811 750115 750788 505670 542411 619358 793114 784294 450473 493083 747222 817025 542059 450721 509557 493543 441476 785166 508909 712642 738841 767042 764562 473529 584865 511478 594553 641458 715795 767183 451410 648917 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.65%) |
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 397406 417328 418226 431592 431718 441476 450473 450721 451410 473529 480976 483378 493083 493543 495389 499069 505670 508909 509557 511478 518887 518959 531849 542059 542411 543703 549100 549106 549538 553687 556652 577970 578337 584865 585605 586011 590241 594553 607985 616053 616449 616829 619358 623085 623277 626327 632095 632868 641458 648917 651901 670248 676205 698091 706467 712642 715795 718582 726082 726736 731827 738505 738841 739584 739587 741239 743766 747222 750115 750788 750789 751702 757941 759049 761584 764154 764562 767042 767141 767183 777320 778470 784294 784770 785166 785477 787600 789763 793113 793114 793383 793934 794096 794962 794969 794971 794980 794981 795005 795684 796732 796980 797098 797115 797122 800236 801045 804307 805335 809112 809797 809811 809813 809816 810065 817025 817139 817206 817758 820365 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"связала мужа и трахае%…"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бдсм жен секс"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"бдсм жен секс"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.