Query Metrics
7
Database Queries
7
Different statements
153.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.49 ms (81.92%) |
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 384124 388785 397905 411334 411704 437530 439752 444145 448708 451469 451498 457460 457515 458000 460762 464339 464521 465399 465947 466244 466801 467469 467489 467540 469372 469403 470018 470768 471449 472688 473133 473829 474113 477961 479024 479100 479102 479103 479104 479112 484399 496873 503580 505690 506212 512608 516043 522486 522589 523164 526208 531989 532876 533607 534336 536444 536458 544468 544489 546113 546119 546715 546716 548182 549221 549224 549842 549846 550220 552286 554323 554542 559071 560943 562958 563025 563090 563173 563640 566327 566940 569943 573918 579613 585158 590941 591260 591977 607258 609689 624821 632268 665319 678767 696308 699707 710560 717935 724252 725561 726587 727449 727769 727898 728317 728385 741764 746686 748236 748256 759946 781914 788543 790885 799360 806084 807326 810774 810834 811475 ] |
||||||||||||||||||||||||||||||
|
17.66 ms (11.53%) |
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 464339 466801 473133 473829 484399 512608 516043 522589 523164 534336 536444 496873 531989 526208 536458 503580 505690 506212 522486 532876 533607 460762 465947 469403 544468 546113 549221 554542 563025 563173 566940 569943 546119 546715 546716 548182 554323 559071 544489 552286 563090 573918 710560 678767 696308 665319 717935 549224 549842 549846 550220 560943 562958 563640 566327 579613 585158 591977 609689 590941 607258 632268 591260 624821 790885 806084 810774 811475 807326 724252 727449 727898 746686 748256 725561 728317 727769 741764 748236 726587 728385 759946 699707 781914 788543 799360 810834 411334 448708 457515 470018 470768 472688 479102 388785 439752 451498 465399 467489 479104 397905 437530 451469 457460 467469 467540 469372 471449 474113 477961 479024 384124 411704 444145 458000 464521 466244 479100 479103 479112 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (1.98%) |
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 384124 388785 397905 411334 411704 437530 439752 444145 448708 451469 451498 457460 457515 458000 460762 464339 464521 465399 465947 466244 466801 467469 467489 467540 469372 469403 470018 470768 471449 472688 473133 473829 474113 477961 479024 479100 479102 479103 479104 479112 484399 496873 503580 505690 506212 512608 516043 522486 522589 523164 526208 531989 532876 533607 534336 536444 536458 544468 544489 546113 546119 546715 546716 548182 549221 549224 549842 549846 550220 552286 554323 554542 559071 560943 562958 563025 563090 563173 563640 566327 566940 569943 573918 579613 585158 590941 591260 591977 607258 609689 624821 632268 665319 678767 696308 699707 710560 717935 724252 725561 726587 727449 727769 727898 728317 728385 741764 746686 748236 748256 759946 781914 788543 790885 799360 806084 807326 810774 810834 811475 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature hair"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature hair"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature hair"
]
|
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.