Query Metrics
7
Database Queries
7
Different statements
147.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.11 ms (81.90%) |
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 546292 551977 558895 559878 583417 590297 591836 591904 596820 598182 599138 599798 602218 603219 603315 605226 608026 618295 619459 622201 622651 626665 630444 634694 638058 640868 642216 658180 658951 668950 705052 705804 707452 707544 709878 709916 711994 713113 714126 717282 725087 725298 725439 726309 726623 726928 727042 727169 727437 728630 730379 731007 732200 732760 734069 734301 734461 735029 738160 738191 739541 740771 741045 741266 742590 743147 747861 756868 758110 759374 761171 761527 763373 763629 764565 765007 765215 767289 767443 768172 769119 769189 769220 769688 770951 779716 783024 783963 784340 785690 788385 788449 788646 789704 794990 795606 796018 796493 796811 797884 799739 799889 801221 801554 802137 802363 803351 803840 805103 806737 807305 808751 809740 809745 810565 811504 812148 812150 812314 812837 ] |
||||||||||||||||||||||||||||||
|
15.68 ms (10.60%) |
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 705052 707544 709878 709916 713113 714126 717282 658180 658951 668950 705804 707452 711994 546292 551977 558895 559878 583417 591836 603315 605226 640868 642216 590297 599138 619459 622201 602218 608026 622651 626665 634694 591904 596820 598182 599798 603219 618295 630444 638058 783963 788385 788646 789704 794990 795606 796493 802137 803840 808751 811504 812314 779716 785690 788449 796018 797884 799889 803351 805103 806737 809745 810565 812837 725087 725439 726928 727169 727437 731007 734301 734461 740771 743147 756868 765007 769220 770951 783024 784340 796811 799739 801221 801554 802363 807305 809740 812148 812150 725298 726309 732760 734069 741266 758110 761171 761527 763373 767289 769119 728630 735029 738191 742590 747861 764565 769189 726623 730379 732200 738160 739541 741045 759374 763629 765215 767443 768172 769688 727042 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.84%) |
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 546292 551977 558895 559878 583417 590297 591836 591904 596820 598182 599138 599798 602218 603219 603315 605226 608026 618295 619459 622201 622651 626665 630444 634694 638058 640868 642216 658180 658951 668950 705052 705804 707452 707544 709878 709916 711994 713113 714126 717282 725087 725298 725439 726309 726623 726928 727042 727169 727437 728630 730379 731007 732200 732760 734069 734301 734461 735029 738160 738191 739541 740771 741045 741266 742590 743147 747861 756868 758110 759374 761171 761527 763373 763629 764565 765007 765215 767289 767443 768172 769119 769189 769220 769688 770951 779716 783024 783963 784340 785690 788385 788449 788646 789704 794990 795606 796018 796493 796811 797884 799739 799889 801221 801554 802137 802363 803351 803840 805103 806737 807305 808751 809740 809745 810565 811504 812148 812150 812314 812837 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"у тебя такой маленький"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.39%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"маленький"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.