Query Metrics
7
Database Queries
7
Different statements
178.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.58 ms (86.66%) |
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 407159 464166 488469 491621 523793 544722 545101 552985 556119 556719 556720 557805 565830 592867 593881 604664 606815 613840 628615 629659 629930 632077 640320 645021 660114 669244 681773 689462 692704 692734 695307 697733 698739 706063 706554 706659 707056 707626 707741 707878 708070 710237 710947 711586 714739 718460 719069 719087 719793 720006 722168 723476 724130 724461 725020 725240 728116 728464 728634 728810 728870 728921 730309 730679 730742 734448 735664 735780 736671 736720 744362 744923 746132 747061 747680 748038 749448 751266 752511 753988 755106 757712 757930 758808 758874 760768 761339 761378 763095 763191 763843 764850 765369 766162 767294 767629 767734 768542 768719 772354 775527 778719 781562 782674 786670 789508 791678 794546 794565 794570 796024 796755 808783 811650 824079 824081 824093 824799 824825 825433 ] |
||||||||||||||||||||||||||||||
|
13.70 ms (7.68%) |
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 706554 707056 707741 711586 660114 681773 689462 692704 698739 707626 645021 669244 692734 707878 708070 710237 710947 714739 719793 720006 544722 556720 592867 593881 628615 640320 604664 613840 629930 606815 749448 763191 736720 744923 767294 728810 763843 632077 697733 706063 706659 789508 695307 824093 464166 488469 545101 565830 629659 791678 794570 728464 768542 719087 824825 796024 523793 407159 824079 825433 824081 824799 491621 556119 556719 557805 552985 722168 723476 718460 719069 778719 794546 775527 782674 794565 796755 728634 734448 736671 752511 755106 758808 758874 760768 761339 761378 764850 767629 772354 781562 786670 808783 811650 725020 725240 728921 730309 744362 747680 748038 751266 767734 724461 746132 747061 757712 757930 766162 724130 728116 728870 730679 730742 735664 735780 753988 763095 765369 768719 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.62%) |
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 407159 464166 488469 491621 523793 544722 545101 552985 556119 556719 556720 557805 565830 592867 593881 604664 606815 613840 628615 629659 629930 632077 640320 645021 660114 669244 681773 689462 692704 692734 695307 697733 698739 706063 706554 706659 707056 707626 707741 707878 708070 710237 710947 711586 714739 718460 719069 719087 719793 720006 722168 723476 724130 724461 725020 725240 728116 728464 728634 728810 728870 728921 730309 730679 730742 734448 735664 735780 736671 736720 744362 744923 746132 747061 747680 748038 749448 751266 752511 753988 755106 757712 757930 758808 758874 760768 761339 761378 763095 763191 763843 764850 765369 766162 767294 767629 767734 768542 768719 772354 775527 778719 781562 782674 786670 789508 791678 794546 794565 794570 796024 796755 808783 811650 824079 824081 824093 824799 824825 825433 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cumshot homemade"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cumshot домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cumshot домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.66 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.