Query Metrics
7
Database Queries
7
Different statements
142.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.94 ms (86.34%) |
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 420614 427408 428087 476539 507136 530029 539235 543167 543274 547898 548267 557269 564820 572243 578732 578783 578807 579558 581977 583352 586216 591999 592379 594561 594572 597108 605628 606844 606922 616661 618260 620513 627206 632113 633838 633856 634275 636334 637299 638097 638396 639610 641213 642186 651040 651128 653780 661589 666009 668798 687121 692733 695773 702382 709434 710686 712952 716090 720086 725219 727406 728650 731197 731400 733032 733151 733185 739883 740310 742763 744087 744093 744777 745314 745601 745872 752056 752115 752734 759798 763820 768468 771487 777951 778490 779829 782130 782455 784274 784292 787286 788592 789498 790899 791722 794720 795752 796597 796749 798754 802394 802410 803763 804123 805239 812461 812881 818832 818907 820156 820159 820178 820218 823648 824489 824546 824760 826204 826492 ] |
||||||||||||||||||||||||||||||
|
10.82 ms (7.60%) |
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 428087 824489 826204 820156 581977 745314 745601 733185 476539 710686 709434 578732 578807 616661 636334 731197 627206 789498 543274 572243 784292 744777 791722 803763 784274 744087 579558 594561 823648 824760 824546 547898 642186 796749 771487 725219 752115 606844 796597 802394 818907 820218 804123 651128 702382 661589 666009 687121 586216 597108 638097 633856 548267 632113 728650 790899 740310 733032 778490 812461 733151 732108 712952 530029 605628 787286 578783 594572 641213 420614 818832 820178 826492 820159 779829 782455 782130 802410 739883 759798 763820 768468 745872 812881 692733 695773 668798 653780 591999 638396 727406 618260 592379 637299 744093 788592 752056 731400 742763 795752 620513 507136 543167 720086 777951 794720 798754 805239 752734 633838 539235 557269 564820 583352 651040 716090 606922 639610 634275 427408 ] |
||||||||||||||||||||||||||||||
|
2.34 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 420614 427408 428087 476539 507136 530029 539235 543167 543274 547898 548267 557269 564820 572243 578732 578783 578807 579558 581977 583352 586216 591999 592379 594561 594572 597108 605628 606844 606922 616661 618260 620513 627206 632113 633838 633856 634275 636334 637299 638097 638396 639610 641213 642186 651040 651128 653780 661589 666009 668798 687121 692733 695773 702382 709434 710686 712952 716090 720086 725219 727406 728650 731197 731400 733032 733151 733185 739883 740310 742763 744087 744093 744777 745314 745601 745872 752056 752115 752734 759798 763820 768468 771487 777951 778490 779829 782130 782455 784274 784292 787286 788592 789498 790899 791722 794720 795752 796597 796749 798754 802394 802410 803763 804123 805239 812461 812881 818832 818907 820156 820159 820178 820218 823648 824489 824546 824760 826204 826492 ] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur cheating wife"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск cheating жен"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск cheating жен"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (1.03%) |
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.