Query Metrics
7
Database Queries
7
Different statements
157.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.16 ms (85.10%) |
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 7058 9734 37823 75969 118370 124661 151062 154844 160126 182895 213432 229024 242216 315072 320786 324555 338807 352142 381764 382278 382302 382383 382611 383500 384108 384170 385228 385759 386522 388894 391393 391756 392311 393350 395465 397567 397655 397656 398247 400666 401872 402390 404120 411198 414123 414434 418697 420193 427539 428220 440068 441063 443152 443249 443309 446045 448370 453822 454368 457816 458193 462848 465195 465669 466991 473098 475425 477482 481169 493763 494318 497731 500621 513978 519364 530629 531811 534539 536127 536128 539026 543744 553734 554852 576225 578750 586011 602485 618257 643181 643213 656187 658784 672926 716633 722393 735885 742929 745168 750856 752631 764504 778938 792708 792725 794300 794334 818707 823766 824675 824778 824876 827838 827852 827946 827948 827951 827960 827974 ] |
||||||||||||||||||||||||||||||
|
14.31 ms (9.07%) |
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 213432 37823 7058 553734 716633 618257 229024 118370 75969 824876 643213 745168 534539 539026 554852 672926 742929 722393 384108 388894 443249 392311 418697 519364 536128 385759 386522 391756 352142 381764 382278 9734 397567 397656 398247 402390 411198 420193 440068 500621 465669 602485 383500 391393 404120 414434 446045 454368 457816 473098 481169 494318 530629 750856 778938 160126 242216 315072 823766 656187 382383 382611 382302 400666 543744 643181 792708 752631 735885 764504 124661 497468 536127 576225 658784 458193 393350 338807 824778 818707 824675 827838 827852 827946 827974 827948 827951 827960 531811 578750 586011 794300 792725 794334 384170 401872 385228 154844 151062 182895 395465 324555 320786 397655 414123 443309 427539 428220 441063 443152 448370 493763 453822 462848 465195 466991 475425 477482 497731 513978 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.63%) |
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 7058 9734 37823 75969 118370 124661 151062 154844 160126 182895 213432 229024 242216 315072 320786 324555 338807 352142 381764 382278 382302 382383 382611 383500 384108 384170 385228 385759 386522 388894 391393 391756 392311 393350 395465 397567 397655 397656 398247 400666 401872 402390 404120 411198 414123 414434 418697 420193 427539 428220 440068 441063 443152 443249 443309 446045 448370 453822 454368 457816 458193 462848 465195 465669 466991 473098 475425 477482 481169 493763 494318 497731 500621 513978 519364 530629 531811 534539 536127 536128 539026 543744 553734 554852 576225 578750 586011 602485 618257 643181 643213 656187 658784 672926 716633 722393 735885 742929 745168 750856 752631 764504 778938 792708 792725 794300 794334 818707 823766 824675 824778 824876 827838 827852 827946 827948 827951 827960 827974 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жесткое раком"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хардкор рак"
]
|
||||||||||||||||||||||||||||||
|
1.30 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"хардкор рак"
]
|
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.