Query Metrics
7
Database Queries
7
Different statements
199.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.95 ms (87.72%) |
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 6602 66611 118109 187516 187636 187709 187938 187996 188335 382947 384279 385974 386866 388784 388862 389639 390303 391565 396941 396956 408207 411385 411773 411907 411944 411960 412015 413474 442912 458716 470446 486253 530326 536539 542206 543694 544503 547018 548081 551507 574449 576594 603379 616594 636586 643081 650388 651114 664290 665095 665890 667199 667291 668888 702158 702955 712332 713635 714156 714909 715107 718549 718559 723984 724302 726588 726902 727050 727513 728142 728240 728340 728443 731686 732356 739734 746619 746890 749907 758280 758500 759113 759761 760738 761326 761563 769491 770126 770139 776865 777656 781930 789528 789693 790813 794854 804211 805813 807376 807546 807600 808015 808456 808500 808506 808558 810830 815860 818630 818660 818811 818814 819117 819241 819353 825248 825274 826655 828760 ] |
||||||||||||||||||||||||||||||
|
13.72 ms (6.88%) |
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 382947 777656 412015 411944 819353 458716 544503 667199 789693 810830 758280 807546 390303 391565 470446 442912 486253 726902 389639 388784 384279 187636 396941 408207 411907 818660 818814 826655 665890 702158 714156 616594 807600 808015 746890 726588 728240 731686 727513 759761 761563 728443 808500 808506 188335 536539 574449 643081 187996 819117 819241 825248 818811 825274 530326 543694 551507 542206 576594 715107 651114 702955 547018 548081 603379 805813 776865 794854 759113 728340 758500 728142 739734 746619 770126 760738 804211 6602 815860 828044 828760 636586 385974 386866 118109 187709 187938 388862 396956 413474 411773 411960 818630 714909 650388 664290 667291 665095 668888 712332 713635 718549 789528 790813 807376 723984 770139 808456 808558 732356 749907 727050 724302 769491 761326 718559 781930 411385 66611 187516 ] |
||||||||||||||||||||||||||||||
|
4.29 ms (2.15%) |
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 6602 66611 118109 187516 187636 187709 187938 187996 188335 382947 384279 385974 386866 388784 388862 389639 390303 391565 396941 396956 408207 411385 411773 411907 411944 411960 412015 413474 442912 458716 470446 486253 530326 536539 542206 543694 544503 547018 548081 551507 574449 576594 603379 616594 636586 643081 650388 651114 664290 665095 665890 667199 667291 668888 702158 702955 712332 713635 714156 714909 715107 718549 718559 723984 724302 726588 726902 727050 727513 728142 728240 728340 728443 731686 732356 739734 746619 746890 749907 758280 758500 759113 759761 760738 761326 761563 769491 770126 770139 776865 777656 781930 789528 789693 790813 794854 804211 805813 807376 807546 807600 808015 808456 808500 808506 808558 810830 815860 818630 818660 818811 818814 819117 819241 819353 825248 825274 826655 828760 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boobs mature"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.77%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"boobs mature"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"boobs mature"
]
|
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.