Query Metrics
7
Database Queries
7
Different statements
193.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.58 ms (88.05%) |
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 404434 434458 460827 509997 510012 518403 530463 530546 530564 532058 532112 532134 533474 535653 537127 551717 557262 581885 584106 584160 586269 587479 589199 593972 596686 597766 599368 602066 602734 610826 613383 616524 619970 620637 622560 624021 630149 637586 639893 641327 648144 650545 652109 653065 653102 653126 653127 660601 660622 661944 666369 672676 673818 678224 678229 680297 680830 688862 690672 691819 693668 695128 697553 697848 703099 703766 707425 708913 709363 709440 711712 712041 713371 714121 714893 718459 723956 725718 732980 737697 741268 762634 762706 769939 775608 776116 778617 779388 788393 789951 791260 794604 794664 796638 800795 802077 803782 805608 807232 807736 808103 811132 814204 816135 817736 818126 819109 819420 819889 820364 821774 823781 823918 824231 827046 827882 827885 828540 ] |
||||||||||||||||||||||||||||||
|
12.99 ms (6.71%) |
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 789951 518403 509997 680297 819420 530564 712041 827885 827882 530463 532134 533474 530546 532112 510012 532058 551717 557262 584106 584160 581885 653102 666369 672676 678224 678229 680830 690672 697848 714121 650545 652109 653126 653127 660601 691819 697553 703766 708913 709440 718459 648144 653065 660622 661944 673818 688862 693668 695128 709363 711712 713371 587479 589199 610826 639893 593972 619970 596686 602066 613383 616524 622560 624021 630149 641327 597766 805608 775608 778617 803782 741268 732980 737697 725718 620637 621128 637586 703099 707425 434458 599368 602734 404434 819109 823781 824231 817736 818126 827046 816135 821774 814204 819889 820364 823918 828540 535653 537127 460827 714893 586269 779388 781201 788393 791260 794604 808103 811132 776116 796638 800795 807232 807736 762706 769939 794664 802077 762634 723956 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (1.66%) |
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 404434 434458 460827 509997 510012 518403 530463 530546 530564 532058 532112 532134 533474 535653 537127 551717 557262 581885 584106 584160 586269 587479 589199 593972 596686 597766 599368 602066 602734 610826 613383 616524 619970 620637 622560 624021 630149 637586 639893 641327 648144 650545 652109 653065 653102 653126 653127 660601 660622 661944 666369 672676 673818 678224 678229 680297 680830 688862 690672 691819 693668 695128 697553 697848 703099 703766 707425 708913 709363 709440 711712 712041 713371 714121 714893 718459 723956 725718 732980 737697 741268 762634 762706 769939 775608 776116 778617 779388 788393 789951 791260 794604 794664 796638 800795 802077 803782 805608 807232 807736 808103 811132 814204 816135 817736 818126 819109 819420 819889 820364 821774 823781 823918 824231 827046 827882 827885 828540 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"step любительск"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"step amateur"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"step любительск"
]
|
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.