Query Metrics
7
Database Queries
7
Different statements
204.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
181.14 ms (88.50%) |
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 9021 55349 393497 395534 398543 400479 401223 401902 403651 404664 409233 413111 421833 421922 422151 430424 433234 449243 449699 450803 460088 460179 461358 466041 466710 469317 479493 482328 484615 515047 516209 516211 516229 517278 520693 542908 543774 549656 573749 586150 605362 606684 609422 619122 623759 636039 638426 643384 683770 687505 687605 694105 709396 709416 712625 714049 714283 714750 714886 714916 716023 716090 721754 725199 725352 726593 731444 731464 733514 734556 735518 735836 736130 736880 738009 747284 756402 757288 758171 760733 765306 771490 776933 777230 777739 779902 780930 786269 788583 792287 792538 793781 797350 800085 800097 800934 801346 801357 802595 803080 803363 805199 805690 808452 809791 810062 811314 813264 813628 814295 816476 816695 817692 817725 817869 819919 820127 824247 824585 824994 ] |
||||||||||||||||||||||||||||||
|
12.38 ms (6.05%) |
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 714283 714916 716023 792538 725199 733514 735518 714750 721754 797350 409233 400479 421922 422151 813628 819919 816695 817692 820127 687605 605362 643384 800085 777230 801346 803080 760733 788583 802595 731444 738009 810062 393497 404664 449243 413111 401902 520693 484615 421833 816476 824247 824994 824585 461358 466710 709416 712625 716090 776933 801357 805690 792287 757288 786269 803363 805199 811314 813264 726593 756402 638426 709396 793781 809791 395534 542908 543774 573749 731464 460179 401223 450803 517278 516209 403651 433234 817869 466041 479493 516211 714049 694105 714886 683770 687505 606684 636039 619122 623759 586150 609422 800097 808452 725352 735836 736130 736880 747284 765306 771490 734556 758171 777739 779902 780930 800934 482328 55349 449699 9021 398543 430424 817725 814295 515047 516229 460088 469317 549656 ] |
||||||||||||||||||||||||||||||
|
3.44 ms (1.68%) |
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 9021 55349 393497 395534 398543 400479 401223 401902 403651 404664 409233 413111 421833 421922 422151 430424 433234 449243 449699 450803 460088 460179 461358 466041 466710 469317 479493 482328 484615 515047 516209 516211 516229 517278 520693 542908 543774 549656 573749 586150 605362 606684 609422 619122 623759 636039 638426 643384 683770 687505 687605 694105 709396 709416 712625 714049 714283 714750 714886 714916 716023 716090 721754 725199 725352 726593 731444 731464 733514 734556 735518 735836 736130 736880 738009 747284 756402 757288 758171 760733 765306 771490 776933 777230 777739 779902 780930 786269 788583 792287 792538 793781 797350 800085 800097 800934 801346 801357 802595 803080 803363 805199 805690 808452 809791 810062 811314 813264 813628 814295 816476 816695 817692 817725 817869 819919 820127 824247 824585 824994 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stepson with mom"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"stepson mom"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"stepson mom"
]
|
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.