Query Metrics
7
Database Queries
7
Different statements
159.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.64 ms (82.76%) |
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 425981 466612 476904 482630 498342 500004 500056 506775 517638 521763 523943 524394 528281 532781 553722 559846 565140 569845 570248 572103 572171 572442 573430 573899 574636 576266 578190 580623 585417 585518 589437 589729 602563 603723 606595 607371 610226 613017 614967 615287 615312 616790 619774 620785 621220 623165 625598 630679 633637 635306 637106 638248 639924 642781 649297 649702 671470 678798 680161 683963 684902 685588 685873 702628 703472 703586 704161 705789 710953 713867 718631 718637 718668 722056 722061 722258 723074 725113 725115 725390 726179 730764 735703 736445 739652 739978 741279 742416 743068 743760 744266 748438 751971 753279 753814 758190 758252 761717 761790 766570 768157 771682 773906 774176 777411 780597 780713 790394 790542 791844 792183 792532 793716 803679 806672 807637 809121 811093 813020 814606 ] |
||||||||||||||||||||||||||||||
|
16.42 ms (10.32%) |
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 680161 683963 685588 704161 649297 649702 671470 678798 685873 702628 718631 722056 722061 559846 565140 589437 615287 615312 635306 638248 589729 610226 613017 616790 623165 639924 614967 585417 602563 606595 607371 625598 637106 642781 780597 780713 792532 790394 807637 741279 748438 751971 773906 791844 725115 725390 739652 761717 766570 771682 736445 742416 743068 758190 758252 768157 774176 735703 739978 753279 761790 621220 633637 705789 710953 718668 777411 793716 803679 811093 813020 523943 524394 500056 466612 572442 573430 573899 553722 570248 572171 574636 703586 572103 619774 603723 790542 725113 730764 792183 806672 809121 726179 753814 744266 743760 620785 718637 580623 425981 814606 498342 521763 506775 532781 517638 528281 476904 576266 578190 684902 713867 722258 723074 585518 630679 703472 500004 482630 569845 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.65%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"перв жоп"
]
|
||||||||||||||||||||||||||||||
|
2.39 ms (1.50%) |
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 425981 466612 476904 482630 498342 500004 500056 506775 517638 521763 523943 524394 528281 532781 553722 559846 565140 569845 570248 572103 572171 572442 573430 573899 574636 576266 578190 580623 585417 585518 589437 589729 602563 603723 606595 607371 610226 613017 614967 615287 615312 616790 619774 620785 621220 623165 625598 630679 633637 635306 637106 638248 639924 642781 649297 649702 671470 678798 680161 683963 684902 685588 685873 702628 703472 703586 704161 705789 710953 713867 718631 718637 718668 722056 722061 722258 723074 725113 725115 725390 726179 730764 735703 736445 739652 739978 741279 742416 743068 743760 744266 748438 751971 753279 753814 758190 758252 761717 761790 766570 768157 771682 773906 774176 777411 780597 780713 790394 790542 791844 792183 792532 793716 803679 806672 807637 809121 811093 813020 814606 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"первый попу"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"перв жоп"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.