Query Metrics
7
Database Queries
7
Different statements
145.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.10 ms (84.07%) |
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 150785 154157 208554 387661 391944 395479 402631 467636 471168 476656 485661 494531 499872 499930 507691 516458 529713 529714 530698 540945 541507 547475 561019 573257 580130 580782 580832 590370 596389 600031 600915 602329 616454 628104 648649 648898 660369 660380 660394 666854 670356 671008 671038 672944 672952 697484 714205 718701 718772 723877 735297 745111 748290 749672 750764 751453 751852 752639 752669 752679 753202 753207 756773 756828 758330 760545 761276 762007 762149 765164 769015 770261 772243 772261 772262 774881 776037 777767 778120 778220 779291 780195 780263 781245 781420 782057 782106 782334 782952 783006 783363 786916 788863 788870 789459 791010 791024 791027 791184 791346 791383 791503 792710 793017 793133 796647 796703 796946 797002 798599 800657 803534 803613 803771 806432 806694 806764 809010 810957 812031 ] |
||||||||||||||||||||||||||||||
|
12.78 ms (8.80%) |
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 782952 786916 774881 776037 778220 780263 781245 783006 788870 789459 791184 791383 796946 797002 800657 803771 806694 723877 753207 772261 772262 781420 783363 791346 792710 793017 793133 810957 762007 765164 769015 750764 751453 751852 735297 748290 753202 760545 761276 762149 772243 697484 777767 778120 779291 782106 782334 791010 791024 791027 791503 803613 806764 809010 812031 208554 471168 499930 529713 529714 541507 573257 540945 660394 590370 600915 628104 602329 745111 752669 758330 749672 752639 806432 648898 714205 600031 756828 780195 154157 387661 516458 494531 507691 648649 596389 756773 150785 395479 770261 402631 476656 485661 530698 467636 547475 561019 580782 580832 660380 672944 718772 660369 670356 671008 672952 666854 671038 718701 580130 616454 782057 796703 798599 796647 803534 752679 788863 499872 391944 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (2.12%) |
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 150785 154157 208554 387661 391944 395479 402631 467636 471168 476656 485661 494531 499872 499930 507691 516458 529713 529714 530698 540945 541507 547475 561019 573257 580130 580782 580832 590370 596389 600031 600915 602329 616454 628104 648649 648898 660369 660380 660394 666854 670356 671008 671038 672944 672952 697484 714205 718701 718772 723877 735297 745111 748290 749672 750764 751453 751852 752639 752669 752679 753202 753207 756773 756828 758330 760545 761276 762007 762149 765164 769015 770261 772243 772261 772262 774881 776037 777767 778120 778220 779291 780195 780263 781245 781420 782057 782106 782334 782952 783006 783363 786916 788863 788870 789459 791010 791024 791027 791184 791346 791383 791503 792710 793017 793133 796647 796703 796946 797002 798599 800657 803534 803613 803771 806432 806694 806764 809010 810957 812031 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo dildo girl"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло дилд девушк"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.