Query Metrics
7
Database Queries
7
Different statements
181.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.64 ms (84.18%) |
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 7295 72782 187775 187800 187954 188437 326071 379600 381940 382802 385225 385314 387179 388700 391588 393081 397853 397905 397910 398484 398969 404587 405411 406648 406899 409877 410237 411349 411386 411468 411704 411914 412273 413460 427433 428817 430393 439658 440996 443326 443768 443782 444145 444255 450368 453096 465953 466015 466173 466190 466206 466218 466267 466893 468097 470215 470424 472688 474109 474674 477961 480006 484608 485095 486345 486350 487315 488362 490783 491899 506212 506829 527570 531970 565625 582335 603545 614723 617658 632268 663461 665461 678767 678805 693325 709545 716277 717677 719903 724233 724875 725553 725561 725570 729819 732054 733251 746636 756233 760827 761590 770187 772459 774196 777420 780665 780724 781995 785934 792633 792660 794651 799971 803298 807335 808527 810775 815529 816793 818167 ] |
||||||||||||||||||||||||||||||
|
18.89 ms (10.42%) |
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 785934 725553 724875 733251 725570 709545 792633 397910 430393 393081 480006 816793 756233 770187 774196 614723 388700 385225 187775 410237 663461 799971 188437 444255 453096 486350 439658 488362 72782 815529 818167 527570 716277 803298 780665 810775 603545 678805 474109 466015 470215 487315 187800 413460 490783 465953 470424 466218 7295 387179 411468 440996 491899 405411 531970 693325 665461 719903 565625 582335 780724 781995 807335 746636 792660 772459 729819 724233 411386 382802 411349 466190 381940 617658 187954 406899 506212 678767 632268 794651 808527 725561 391588 466893 472688 443768 397853 397905 398969 477961 379600 398484 406648 411704 443326 444145 466206 466267 428817 443782 450368 466173 468097 474674 484608 486345 506829 385314 326071 404587 409877 411914 412273 427433 485095 717677 777420 761590 732054 760827 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.49%) |
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 7295 72782 187775 187800 187954 188437 326071 379600 381940 382802 385225 385314 387179 388700 391588 393081 397853 397905 397910 398484 398969 404587 405411 406648 406899 409877 410237 411349 411386 411468 411704 411914 412273 413460 427433 428817 430393 439658 440996 443326 443768 443782 444145 444255 450368 453096 465953 466015 466173 466190 466206 466218 466267 466893 468097 470215 470424 472688 474109 474674 477961 480006 484608 485095 486345 486350 487315 488362 490783 491899 506212 506829 527570 531970 565625 582335 603545 614723 617658 632268 663461 665461 678767 678805 693325 709545 716277 717677 719903 724233 724875 725553 725561 725570 729819 732054 733251 746636 756233 760827 761590 770187 772459 774196 777420 780665 780724 781995 785934 792633 792660 794651 799971 803298 807335 808527 810775 815529 816793 818167 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature old anal"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature old анал"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.75%) |
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.