Query Metrics
7
Database Queries
7
Different statements
152.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.54 ms (81.77%) |
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 7365 16971 194216 205968 233193 233292 233570 233996 311237 365962 368335 381853 382284 382405 388570 390051 390169 391968 392030 392489 392671 393433 394433 395927 396016 397874 406067 413279 422358 443777 453062 454192 454234 454259 460639 462204 462690 466171 466945 474162 474858 476233 477962 482296 483135 486821 493898 525488 530326 530467 537737 543694 544488 551157 554461 561585 561586 563053 576640 584751 587207 588084 622775 624874 640892 649561 663368 663454 663504 663509 663895 665141 665254 665406 665849 666804 667288 667563 667676 667864 667886 670490 678775 678790 702179 702955 716470 720583 720591 721477 726539 728337 741016 742249 742598 744226 748128 758311 774187 777167 777186 781649 782186 782198 782234 784248 788426 794705 800700 807395 816796 818811 820249 820285 820309 823692 823857 824168 824807 824908 ] |
||||||||||||||||||||||||||||||
|
16.05 ms (10.54%) |
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 397874 205968 396016 820285 816796 537737 530467 584751 721477 667676 576640 807395 758311 728337 742249 742598 744226 391968 382405 7365 406067 413279 824168 820309 702179 665406 720591 588084 781649 794705 777167 782186 782198 782234 726539 777186 392489 233570 392030 392671 395927 233193 368335 233292 233996 311237 365962 388570 649561 665141 788426 784248 800700 678790 422358 16971 443777 390051 823857 678775 720583 774187 382284 390169 462690 474858 482296 462204 466945 454192 476233 525488 460639 474162 493898 563053 544488 554461 663895 663368 663454 666804 667563 667864 670490 663509 665849 667288 624874 640892 587207 622775 741016 748128 381853 454234 454259 466171 453062 477962 486821 483135 194216 393433 394433 820249 824807 823692 824908 818811 530326 543694 551157 561585 561586 665254 667886 702955 716470 663504 ] |
||||||||||||||||||||||||||||||
|
4.15 ms (2.73%) |
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 7365 16971 194216 205968 233193 233292 233570 233996 311237 365962 368335 381853 382284 382405 388570 390051 390169 391968 392030 392489 392671 393433 394433 395927 396016 397874 406067 413279 422358 443777 453062 454192 454234 454259 460639 462204 462690 466171 466945 474162 474858 476233 477962 482296 483135 486821 493898 525488 530326 530467 537737 543694 544488 551157 554461 561585 561586 563053 576640 584751 587207 588084 622775 624874 640892 649561 663368 663454 663504 663509 663895 665141 665254 665406 665849 666804 667288 667563 667676 667864 667886 670490 678775 678790 702179 702955 716470 720583 720591 721477 726539 728337 741016 742249 742598 744226 748128 758311 774187 777167 777186 781649 782186 782198 782234 784248 788426 794705 800700 807395 816796 818811 820249 820285 820309 823692 823857 824168 824807 824908 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature old"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature old"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature old"
]
|
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.