Query Metrics
7
Database Queries
7
Different statements
188.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.21 ms (86.15%) |
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 405682 413463 505561 508719 534183 541116 543998 548921 562416 564466 578614 585879 587295 588117 588119 588162 588171 588191 590656 594985 603173 606919 608155 608319 614665 616571 617760 618039 619084 626274 631870 632987 635693 635789 639361 641490 642854 664175 665966 665970 671692 680358 697199 700871 703347 712687 718913 723433 724184 724359 725186 725373 726173 727583 728912 730154 730921 730924 731131 732016 732789 732849 732850 732874 734185 734700 739898 740543 742113 744500 746106 748371 748840 749629 750552 751946 752115 754505 757706 758017 764433 766388 766702 771288 771584 774012 778112 778145 778396 780378 783843 785158 786565 787054 787302 794354 794419 794631 796688 797019 801312 802855 804854 809904 812181 813565 816194 817658 818095 820103 824122 824912 824998 825217 825325 825394 825842 826685 ] |
||||||||||||||||||||||||||||||
|
15.72 ms (8.35%) |
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 594985 603173 626274 631870 635789 585879 588117 606919 614665 616571 618039 588119 590656 608155 608319 619084 635693 639361 641490 642854 731131 724184 617760 632987 700871 703347 505561 508719 813565 824912 578614 541116 548921 680358 671692 665970 588162 786565 732850 726173 748371 413463 817658 820103 826685 818095 816194 825842 825217 562416 543998 564466 712687 718913 664175 588171 588191 587295 780378 783843 785158 794419 801312 812181 787054 794631 796688 797019 802855 809904 725186 734185 758017 774012 730921 732016 732789 732849 732874 734700 742113 744500 757706 766388 771288 749629 750552 751946 764433 774309 724359 730154 730924 740543 746106 748840 752115 771584 725373 727583 728912 739898 754505 723433 776114 778112 778396 787302 778145 804854 766702 794354 665966 534183 697199 405682 824122 825394 825325 824998 ] |
||||||||||||||||||||||||||||||
|
3.08 ms (1.64%) |
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 405682 413463 505561 508719 534183 541116 543998 548921 562416 564466 578614 585879 587295 588117 588119 588162 588171 588191 590656 594985 603173 606919 608155 608319 614665 616571 617760 618039 619084 626274 631870 632987 635693 635789 639361 641490 642854 664175 665966 665970 671692 680358 697199 700871 703347 712687 718913 723433 724184 724359 725186 725373 726173 727583 728912 730154 730921 730924 731131 732016 732789 732849 732850 732874 734185 734700 739898 740543 742113 744500 746106 748371 748840 749629 750552 751946 752115 754505 757706 758017 764433 766388 766702 771288 771584 774012 778112 778145 778396 780378 783843 785158 786565 787054 787302 794354 794419 794631 796688 797019 801312 802855 804854 809904 812181 813565 816194 817658 818095 820103 824122 824912 824998 825217 825325 825394 825842 826685 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск friend"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"home made friend"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск friend"
]
|
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.