Query Metrics
7
Database Queries
7
Different statements
233.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.62 ms (90.53%) |
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 457011 490908 490934 492645 492681 518846 520864 527314 538798 552210 557326 563182 570131 579397 580241 596660 596662 597585 598894 600042 601885 612022 617440 627141 654151 654881 655718 655752 656728 657025 657030 657643 660513 668648 676489 704942 705040 705054 710957 714504 717699 720824 721454 721489 721552 722281 722443 725914 728351 729738 733254 735594 735982 736258 738310 740494 741029 742195 744507 744508 745760 746048 746229 747476 749896 749940 753815 757982 758033 766043 769766 772660 777167 777186 778456 779523 779894 781649 781669 781682 781707 781755 781766 782148 782186 782198 782223 782234 782249 782272 782276 785490 785940 788098 788394 788411 788680 789202 789401 789829 789885 794667 794697 807886 809857 812996 814091 817660 817891 818083 819047 819870 820079 820309 823910 824806 824909 825682 827347 827978 ] |
||||||||||||||||||||||||||||||
|
12.42 ms (5.31%) |
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 490908 492645 492681 490934 518846 520864 527314 817891 818083 824806 824909 814091 819047 820309 827347 817660 819870 820079 823910 825682 827978 457011 538798 563182 579397 580241 570131 552210 654151 657030 657025 657643 660513 704942 705040 705054 710957 721454 721489 721552 722281 654881 655718 655752 656728 668648 676489 717699 720824 722443 557326 596662 600042 601885 596660 598894 597585 612022 778456 779894 781649 781755 781766 782223 782249 788411 788680 794697 777167 781707 782272 785940 788394 789885 794667 807886 809857 812996 729738 742195 772660 781682 782186 782198 782234 782276 789202 789401 736258 738310 741029 749940 757982 725914 728351 740494 744508 745760 746229 753815 758033 769766 735594 744507 766043 733254 735982 746048 747476 749896 617440 627141 714504 777186 779523 781669 782148 785490 788098 789829 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.10%) |
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 457011 490908 490934 492645 492681 518846 520864 527314 538798 552210 557326 563182 570131 579397 580241 596660 596662 597585 598894 600042 601885 612022 617440 627141 654151 654881 655718 655752 656728 657025 657030 657643 660513 668648 676489 704942 705040 705054 710957 714504 717699 720824 721454 721489 721552 722281 722443 725914 728351 729738 733254 735594 735982 736258 738310 740494 741029 742195 744507 744508 745760 746048 746229 747476 749896 749940 753815 757982 758033 766043 769766 772660 777167 777186 778456 779523 779894 781649 781669 781682 781707 781755 781766 782148 782186 782198 782223 782234 782249 782272 782276 785490 785940 788098 788394 788411 788680 789202 789401 789829 789885 794667 794697 807886 809857 812996 814091 817660 817891 818083 819047 819870 820079 820309 823910 824806 824909 825682 827347 827978 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск old"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск old"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian old"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.63%) |
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.