Query Metrics
7
Database Queries
7
Different statements
190.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.09 ms (85.58%) |
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 73672 73724 168297 382378 386876 391949 398548 421561 445668 454274 462690 462709 475658 475918 485691 504414 515196 520855 523172 525890 529698 531554 533786 536745 539238 543694 550617 551157 551891 552530 553863 554848 557617 560414 561586 563053 569679 583531 589709 592326 599058 603374 603689 612270 616701 621664 625295 626024 628143 631220 635533 636713 640281 642221 649285 653078 661957 663489 663916 665435 666071 668857 670081 680745 683359 690177 693852 700691 712828 716753 717668 721561 728948 732820 738328 738343 739730 742953 742986 743013 744370 744477 745336 745987 760334 766475 768418 778205 781683 783141 784274 788948 789113 789331 790070 792577 795704 796614 797041 797176 797216 797371 803899 804015 805649 812323 817261 818713 823578 824066 825064 825136 825158 825260 825835 826125 826888 826914 827861 ] |
||||||||||||||||||||||||||||||
|
17.73 ms (9.30%) |
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 668857 73672 824066 649285 642221 792577 525890 625295 742986 743013 742953 665435 475658 475918 626024 603374 805649 382378 680745 663489 818713 824264 826125 539238 560414 640281 797216 745336 803899 523172 398548 825136 531554 635533 796614 732820 825064 825835 825158 533786 536745 557617 666071 717668 553863 628143 603689 778205 783141 789331 797176 804015 812323 738328 768418 738343 744370 760334 745987 700691 790070 621664 462690 515196 563053 712828 445668 504414 589709 462709 454274 485691 569679 391949 716753 592326 728948 168297 583531 789113 784274 421561 386876 663916 781683 73724 817261 826888 826914 823578 825260 827861 520855 529698 543694 551157 561586 552530 693852 721561 653078 661957 690177 670081 683359 550617 551891 554848 612270 616701 636713 599058 631220 788948 797371 797041 795704 739730 744477 766475 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (1.55%) |
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 73672 73724 168297 382378 386876 391949 398548 421561 445668 454274 462690 462709 475658 475918 485691 504414 515196 520855 523172 525890 529698 531554 533786 536745 539238 543694 550617 551157 551891 552530 553863 554848 557617 560414 561586 563053 569679 583531 589709 592326 599058 603374 603689 612270 616701 621664 625295 626024 628143 631220 635533 636713 640281 642221 649285 653078 661957 663489 663916 665435 666071 668857 670081 680745 683359 690177 693852 700691 712828 716753 717668 721561 728948 732820 738328 738343 739730 742953 742986 743013 744370 744477 745336 745987 760334 766475 768418 778205 781683 783141 784274 788948 789113 789331 790070 792577 795704 796614 797041 797176 797216 797371 803899 804015 805649 812323 817261 818713 823578 824066 825064 825136 825158 825260 825835 826125 826888 826914 827861 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old wife"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old жен"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"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.