Query Metrics
7
Database Queries
7
Different statements
207.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
185.15 ms (89.11%) |
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 415837 445053 448898 465506 472064 479514 479564 480032 480836 487821 498264 500089 511421 515652 520967 523166 524981 527174 527709 530667 535222 535451 537632 543069 545994 546275 547643 547661 548428 549833 550589 552299 554806 558471 559674 559723 560282 561617 562429 564326 565032 565370 565734 566332 566893 566920 567833 567927 570607 570832 571933 573301 573502 575278 577125 578101 578133 578217 578335 581109 584152 584316 586237 586255 586279 588290 588326 588486 589106 589342 591300 591461 591508 592056 592089 593024 597039 601751 602052 602073 604028 605803 606043 606683 607074 607201 608103 608542 610054 611347 613663 617899 618031 618046 618141 620281 621367 621713 622911 626945 627578 628431 634526 642177 651084 655268 663772 663887 664595 666358 668821 673150 681404 686578 686648 687937 698230 775708 776141 781651 ] |
||||||||||||||||||||||||||||||
|
13.03 ms (6.27%) |
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 547643 552299 564326 567833 567927 570607 573301 543069 549833 554806 558471 559674 560282 562429 577125 584152 663887 668821 663772 664595 666358 681404 686648 651084 655268 673150 687937 546275 547661 548428 559723 561617 565032 565370 565734 566893 566920 570832 573502 575278 578101 578133 578217 578335 584316 586237 586255 589106 592089 593024 597039 602052 607201 588290 588326 589342 592056 601751 604028 606043 606683 618141 621713 622911 586279 588486 591461 611347 613663 642177 591300 591508 605803 617899 620281 621367 626945 628431 775708 776141 781651 602073 608103 610054 618031 618046 627578 445053 415837 465506 480032 511421 524981 523166 527174 515652 520967 527709 530667 472064 479564 480836 500089 535222 537632 535451 550589 566332 581109 571933 686578 545994 607074 634526 608542 698230 448898 479514 498264 487821 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.30%) |
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 415837 445053 448898 465506 472064 479514 479564 480032 480836 487821 498264 500089 511421 515652 520967 523166 524981 527174 527709 530667 535222 535451 537632 543069 545994 546275 547643 547661 548428 549833 550589 552299 554806 558471 559674 559723 560282 561617 562429 564326 565032 565370 565734 566332 566893 566920 567833 567927 570607 570832 571933 573301 573502 575278 577125 578101 578133 578217 578335 581109 584152 584316 586237 586255 586279 588290 588326 588486 589106 589342 591300 591461 591508 592056 592089 593024 597039 601751 602052 602073 604028 605803 606043 606683 607074 607201 608103 608542 610054 611347 613663 617899 618031 618046 618141 620281 621367 621713 622911 626945 627578 628431 634526 642177 651084 655268 663772 663887 664595 666358 668821 673150 681404 686578 686648 687937 698230 775708 776141 781651 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"с зади стоя"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп сто"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.71%) |
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.