Query Metrics
7
Database Queries
7
Different statements
152.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.04 ms (84.45%) |
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 11330 79601 305931 391928 402419 408411 415786 422292 442634 450187 459239 467758 472860 475469 476750 478004 479108 495514 495515 510533 511521 513581 516211 532708 549217 550467 552853 557965 564286 565636 571107 586416 597150 626819 636210 636434 641919 644104 659353 660276 660684 668982 697014 707477 712567 714166 714930 716090 717949 718461 724736 725381 726257 726566 726920 728128 729789 729842 731206 731786 734077 734090 739543 739608 740647 742573 742590 742761 743003 744421 744439 745938 747879 749009 758225 762994 766293 769443 788323 788369 791674 792593 792670 793498 793616 795985 796018 796024 800108 800716 800748 800751 801288 801917 802434 816169 816170 820369 820378 823266 823456 824194 824390 825429 825975 826086 826307 826308 826371 826414 826483 826486 826650 826682 826692 826828 827203 827315 827491 827620 ] |
||||||||||||||||||||||||||||||
|
14.11 ms (9.23%) |
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 800751 391928 442634 408411 823456 450187 475469 476750 478004 510533 513581 697014 707477 636434 740647 745938 801917 726566 792670 467758 415786 511521 479108 79601 816169 823266 825429 826682 826486 826483 826692 820378 827203 816170 826414 826086 826308 827315 826828 495515 495514 557965 564286 550467 660684 714930 668982 714166 716090 718461 549217 565636 571107 597150 644104 791674 796024 800748 788323 796018 800108 729789 743003 744421 801288 802434 725381 726257 726920 734090 728128 742590 742761 758225 729842 744439 766293 724736 731206 734077 739608 742573 749009 793498 305931 11330 402419 422292 820369 824390 826307 826650 827620 827491 824194 825975 826371 459239 532708 516211 472860 552853 712567 659353 660276 717949 636210 641919 586416 626819 792593 793616 788369 795985 731786 739543 762994 769443 800716 747879 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.50%) |
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 11330 79601 305931 391928 402419 408411 415786 422292 442634 450187 459239 467758 472860 475469 476750 478004 479108 495514 495515 510533 511521 513581 516211 532708 549217 550467 552853 557965 564286 565636 571107 586416 597150 626819 636210 636434 641919 644104 659353 660276 660684 668982 697014 707477 712567 714166 714930 716090 717949 718461 724736 725381 726257 726566 726920 728128 729789 729842 731206 731786 734077 734090 739543 739608 740647 742573 742590 742761 743003 744421 744439 745938 747879 749009 758225 762994 766293 769443 788323 788369 791674 792593 792670 793498 793616 795985 796018 796024 800108 800716 800748 800751 801288 801917 802434 816169 816170 820369 820378 823266 823456 824194 824390 825429 825975 826086 826307 826308 826371 826414 826483 826486 826650 826682 826692 826828 827203 827315 827491 827620 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature mouth"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature mouth"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature mouth"
]
|
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.