Query Metrics
7
Database Queries
7
Different statements
148.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.34 ms (86.87%) |
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 533335 544431 553090 570364 572634 572876 573087 573912 577115 577677 588665 593237 604149 617179 628295 634064 641439 644338 656796 659652 665258 667537 668866 673044 675042 675790 686044 687123 688639 690762 702620 704409 705365 709337 712790 713983 716488 716491 718497 718501 719283 720625 722198 728176 728502 728900 730326 730763 734366 734415 734681 735501 739069 742159 743548 744148 744830 746660 751163 753298 755404 757282 758499 759577 760634 760918 768247 772603 775995 780372 782295 786218 787649 788698 789646 790919 792204 792939 793322 793554 794518 795006 795083 795849 796620 796645 798101 799576 800220 801901 801945 806530 810330 810930 811465 816741 816749 816768 816929 816997 817724 817907 817909 818250 818252 818407 818966 819080 819143 820694 823258 823691 823800 823842 823917 824125 824243 824796 825065 825900 ] |
||||||||||||||||||||||||||||||
|
9.91 ms (6.65%) |
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 816929 817724 817909 823800 824243 825900 818252 818407 820694 823842 823917 816741 816749 816768 816997 817907 818966 819143 823691 824125 818250 819080 823258 825065 824796 533335 572876 544431 572634 577677 553090 570364 573912 577115 667537 675042 688639 704409 712790 713983 716491 722198 673044 687123 718497 718501 656796 659652 665258 668866 675790 686044 690762 702620 716488 573087 628295 644338 634064 617179 588665 593237 604149 641439 782295 786218 788698 789646 792939 801901 787649 790919 793554 794518 795083 796645 799576 811465 730326 730763 734681 757282 759577 772603 793322 795006 795849 798101 800220 801945 806530 810330 810930 734415 735501 755404 728176 743548 760918 728900 734366 739069 742159 744148 744830 746660 768247 728502 751163 753298 758499 760634 705365 709337 719283 720625 775995 780372 792204 796620 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.60%) |
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 533335 544431 553090 570364 572634 572876 573087 573912 577115 577677 588665 593237 604149 617179 628295 634064 641439 644338 656796 659652 665258 667537 668866 673044 675042 675790 686044 687123 688639 690762 702620 704409 705365 709337 712790 713983 716488 716491 718497 718501 719283 720625 722198 728176 728502 728900 730326 730763 734366 734415 734681 735501 739069 742159 743548 744148 744830 746660 751163 753298 755404 757282 758499 759577 760634 760918 768247 772603 775995 780372 782295 786218 787649 788698 789646 790919 792204 792939 793322 793554 794518 795006 795083 795849 796620 796645 798101 799576 800220 801901 801945 806530 810330 810930 811465 816741 816749 816768 816929 816997 817724 817907 817909 818250 818252 818407 818966 819080 819143 820694 823258 823691 823800 823842 823917 824125 824243 824796 825065 825900 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy-licking"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy лиза"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.