Query Metrics
7
Database Queries
7
Different statements
145.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.96 ms (82.97%) |
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 96231 116603 210281 395332 397904 401264 402060 405048 408143 409846 414845 417731 424825 427487 434817 440805 450160 450646 451494 454654 458044 459569 460324 461300 469170 470609 472551 489293 491336 504805 524206 527711 536690 551993 556961 557728 558570 559657 560182 561442 563834 564533 565284 577543 580294 580408 592787 593075 606022 606557 614018 618816 623515 625435 647606 652121 654256 657735 669347 673860 674127 679306 685823 686416 688203 691688 693236 695310 697203 697296 704187 704673 705111 706754 709427 713335 719225 720124 721793 721978 723189 724781 725352 734611 735839 743892 744585 745974 748334 749172 757506 757715 760123 761650 763529 763589 768700 770810 780085 781785 784288 784661 787605 789754 793279 794009 795003 795919 797719 799446 800863 801290 802800 806741 810856 813833 819613 820164 820882 ] |
||||||||||||||||||||||||||||||
|
14.42 ms (9.89%) |
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 810856 819613 459569 454654 686416 688203 743892 760123 408143 524206 210281 551993 556961 409846 414845 489293 763529 647606 536690 580294 577543 704187 679306 625435 793279 802800 458044 424825 561442 654256 691688 558570 593075 745974 763589 806741 504805 674127 395332 401264 673860 781785 780085 440805 461300 713335 697203 606557 770810 720124 820882 697296 784661 761650 735839 405048 427487 813833 559657 563834 669347 723189 695310 693236 560182 592787 606022 614018 618816 799446 749172 787605 724781 768700 706754 794009 797719 800863 417731 469170 527711 491336 652121 734611 744585 721793 795003 757506 96231 402060 460324 565284 450646 397904 820164 564533 557728 721978 704673 705111 719225 657735 709427 580408 623515 795919 801290 789754 725352 772131 784288 748334 757715 116603 450160 685823 470609 451494 434817 472551 ] |
||||||||||||||||||||||||||||||
|
2.85 ms (1.95%) |
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 96231 116603 210281 395332 397904 401264 402060 405048 408143 409846 414845 417731 424825 427487 434817 440805 450160 450646 451494 454654 458044 459569 460324 461300 469170 470609 472551 489293 491336 504805 524206 527711 536690 551993 556961 557728 558570 559657 560182 561442 563834 564533 565284 577543 580294 580408 592787 593075 606022 606557 614018 618816 623515 625435 647606 652121 654256 657735 669347 673860 674127 679306 685823 686416 688203 691688 693236 695310 697203 697296 704187 704673 705111 706754 709427 713335 719225 720124 721793 721978 723189 724781 725352 734611 735839 743892 744585 745974 748334 749172 757506 757715 760123 761650 763529 763589 768700 770810 780085 781785 784288 784661 787605 789754 793279 794009 795003 795919 797719 799446 800863 801290 802800 806741 810856 813833 819613 820164 820882 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.34%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real минет оральн секс"
]
|
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.