Query Metrics
7
Database Queries
7
Different statements
182.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.15 ms (85.89%) |
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 382491 386880 395218 414516 418607 419567 422288 422953 425602 427553 428931 429247 444660 454822 454902 455912 456070 463077 466410 466700 468217 471673 475078 477339 479873 480242 488236 490063 490068 496571 504993 510321 510769 514955 515554 518118 518786 519609 520877 521021 522998 526241 527268 529306 530756 534413 537208 538161 540026 540823 542155 545363 550606 552281 553272 554207 555970 556017 560048 560508 560781 560837 562049 565978 567178 567272 569260 570708 571834 577326 577391 577540 579624 580669 582678 584199 586858 589900 589942 594236 594422 596478 598029 598031 600627 601827 603922 606508 614058 619175 622392 622398 623616 623805 625164 629129 641171 655582 659409 679957 700820 730862 731472 755838 764213 780419 810408 ] |
||||||||||||||||||||||||||||||
|
16.42 ms (8.98%) |
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 395218 425602 428931 419567 429247 540823 463077 466700 471673 534413 519609 488236 550606 577540 552281 560781 562049 584199 596478 600627 589942 603922 586858 731472 810408 730862 629129 466410 504993 518786 570708 560837 679957 641171 537208 560048 569260 606508 619175 622398 454822 454902 479873 582678 700820 382491 427553 540026 520877 542155 560508 577391 554207 655582 567272 623805 589900 780419 622392 414516 515554 514955 598029 601827 580669 496571 594236 755838 764213 386880 556017 530756 538161 518118 522998 529306 579624 594422 475078 510769 422953 468217 567178 480242 456070 623616 510321 521021 526241 625164 553272 444660 477339 577326 659409 614058 422288 571834 598031 490063 555970 418607 455912 490068 545363 565978 527268 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.51%) |
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 382491 386880 395218 414516 418607 419567 422288 422953 425602 427553 428931 429247 444660 454822 454902 455912 456070 463077 466410 466700 468217 471673 475078 477339 479873 480242 488236 490063 490068 496571 504993 510321 510769 514955 515554 518118 518786 519609 520877 521021 522998 526241 527268 529306 530756 534413 537208 538161 540026 540823 542155 545363 550606 552281 553272 554207 555970 556017 560048 560508 560781 560837 562049 565978 567178 567272 569260 570708 571834 577326 577391 577540 579624 580669 582678 584199 586858 589900 589942 594236 594422 596478 598029 598031 600627 601827 603922 606508 614058 619175 622392 622398 623616 623805 625164 629129 641171 655582 659409 679957 700820 730862 731472 755838 764213 780419 810408 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small body"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая body"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"маленькая body"
]
|
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.