Query Metrics
7
Database Queries
7
Different statements
155.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.76 ms (86.70%) |
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 15364 74302 105656 122817 123257 163370 190732 231163 280054 382606 382691 398922 461152 519272 532081 536623 537552 537705 537942 543954 547264 547295 547301 547332 547335 549394 549408 549936 551715 570364 570800 570806 572505 572612 583812 583841 612093 623543 633614 635146 644254 654127 654530 655374 657591 668845 668866 670176 671107 671145 679309 684202 688267 693689 695594 697379 699151 701452 706350 707273 712092 712664 712790 714179 714252 714820 717833 718501 719240 721288 727508 730576 730763 730849 735501 736754 740192 755289 755458 758004 758134 768079 771143 771363 773437 773469 775423 775429 780719 784465 786133 786399 794157 794670 798654 799576 799680 800220 800267 802391 802420 807625 812098 816774 818271 818407 818762 819050 819987 820129 820139 820749 820781 823689 823916 826091 826120 826339 827680 828608 ] |
||||||||||||||||||||||||||||||
|
11.09 ms (7.13%) |
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 697379 644254 786133 786399 818762 712092 780719 768079 668845 820139 547264 570800 684202 583841 799680 231163 826339 572505 730849 633614 519272 280054 398922 816774 802391 15364 123257 190732 701452 572612 802420 570806 549394 657591 794670 727508 717833 820129 827680 536623 122817 826120 671145 758134 771143 800267 807625 547295 547301 551715 671107 693689 714820 719240 655374 688267 714252 547332 549408 583812 812098 771363 773469 74302 163370 823916 612093 773437 755458 714179 798654 382691 828608 537705 537552 712664 679309 635146 775423 740192 707273 699151 818407 819987 735501 820781 537942 670176 695594 706350 730576 623543 775429 382606 823689 819050 532081 570364 712790 718501 668866 799576 730763 800220 758004 105656 820749 826091 461152 543954 547335 549936 654530 784465 736754 818271 654127 721288 794157 755289 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.63%) |
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 15364 74302 105656 122817 123257 163370 190732 231163 280054 382606 382691 398922 461152 519272 532081 536623 537552 537705 537942 543954 547264 547295 547301 547332 547335 549394 549408 549936 551715 570364 570800 570806 572505 572612 583812 583841 612093 623543 633614 635146 644254 654127 654530 655374 657591 668845 668866 670176 671107 671145 679309 684202 688267 693689 695594 697379 699151 701452 706350 707273 712092 712664 712790 714179 714252 714820 717833 718501 719240 721288 727508 730576 730763 730849 735501 736754 740192 755289 755458 758004 758134 768079 771143 771363 773437 773469 775423 775429 780719 784465 786133 786399 794157 794670 798654 799576 799680 800220 800267 802391 802420 807625 812098 816774 818271 818407 818762 819050 819987 820129 820139 820749 820781 823689 823916 826091 826120 826339 827680 828608 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex and kissing"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс kissing"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс kissing"
]
|
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.