Query Metrics
7
Database Queries
7
Different statements
164.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.40 ms (84.61%) |
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 31941 88274 136157 172556 382168 384576 389460 389560 401564 410312 416943 428911 438025 446446 469592 479041 496508 531520 534644 536468 536493 536567 537827 543940 550046 551819 551967 553163 558123 560337 580333 580387 580503 582426 582452 585840 591476 604261 605024 609721 609784 615985 620219 628112 629813 630068 639315 639652 658850 661694 661709 664394 666070 666077 668700 671032 672926 673216 686937 687325 694650 700985 713145 714365 720529 722340 726634 731787 735558 735810 739937 740423 743610 744030 744202 744206 744797 749015 753699 754583 754656 755000 755342 757433 762208 765688 770108 770168 770244 776404 777775 782943 782953 785136 785605 788128 789183 790396 791303 795221 799171 800739 800744 803684 806642 806658 807858 807884 810649 811060 813720 816382 818551 819628 824685 825324 825437 827184 827668 827693 ] |
||||||||||||||||||||||||||||||
|
13.99 ms (8.49%) |
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 664394 673216 686937 553163 580503 639315 609721 620219 629813 630068 639652 585840 591476 604261 615985 782953 789183 790396 810649 776404 785605 799171 735810 744030 744797 749015 753699 754656 782943 788128 795221 800739 803684 806658 731787 755000 755342 770168 735558 739937 770244 740423 744202 754583 757433 770108 726634 744206 762208 765688 605024 628112 714365 720529 722340 777775 785136 791303 800744 806642 807858 807884 811060 401564 172556 88274 416943 479041 31941 389460 384576 743610 446446 551819 609784 136157 382168 389560 438025 410312 428911 816382 825437 825324 827184 827693 813720 818551 819628 824685 827668 469592 531520 537827 534644 536493 536468 536567 496508 560337 582452 543940 550046 580387 582426 551967 558123 580333 658850 661709 666070 668700 671032 672926 700985 661694 666077 687325 694650 713145 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.68%) |
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 31941 88274 136157 172556 382168 384576 389460 389560 401564 410312 416943 428911 438025 446446 469592 479041 496508 531520 534644 536468 536493 536567 537827 543940 550046 551819 551967 553163 558123 560337 580333 580387 580503 582426 582452 585840 591476 604261 605024 609721 609784 615985 620219 628112 629813 630068 639315 639652 658850 661694 661709 664394 666070 666077 668700 671032 672926 673216 686937 687325 694650 700985 713145 714365 720529 722340 726634 731787 735558 735810 739937 740423 743610 744030 744202 744206 744797 749015 753699 754583 754656 755000 755342 757433 762208 765688 770108 770168 770244 776404 777775 782943 782953 785136 785605 788128 789183 790396 791303 795221 799171 800739 800744 803684 806642 806658 807858 807884 810649 811060 813720 816382 818551 819628 824685 825324 825437 827184 827668 827693 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (1.52%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"соло короткая стрижка…"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло короткостриженная"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.15%) |
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.