Query Metrics
7
Database Queries
7
Different statements
193.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.55 ms (88.66%) |
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 611236 622624 627200 628987 629539 637542 697007 700329 701158 702340 705956 714141 714637 718033 721102 723011 724715 726624 727495 728597 728938 730930 731094 731235 731399 731608 732904 734081 735396 735425 735917 737208 737326 737426 737936 737944 739048 739233 739555 739734 739840 740974 740979 741797 742210 742562 742607 743256 743544 744680 745279 746310 746721 747527 748413 748983 750002 750396 750500 750901 751323 751490 752186 753953 754342 754605 755175 755320 755856 756267 756328 757227 757832 758005 758029 758410 759161 759626 759815 760490 761239 761279 761288 761328 761407 762334 764419 766289 766393 766527 766926 767290 767422 767551 768535 769093 769208 770282 770616 771027 773151 774185 774736 777117 778630 780394 783949 788648 790693 791334 792401 792763 793112 798717 803705 803961 804348 810959 811939 ] |
||||||||||||||||||||||||||||||
|
11.49 ms (5.94%) |
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 737208 737326 737936 746721 747527 756267 757227 758410 766289 766393 766527 767422 768535 769187 769208 770616 771027 788648 790693 791334 792401 792763 793112 798717 803705 803961 804348 810959 811939 728597 728938 731094 731399 739048 743256 750002 750500 750901 755175 759161 761239 761288 761328 762334 724715 726624 727495 730930 731608 734081 735396 737426 739555 739840 741797 743544 748413 752186 754342 755320 756328 759626 764419 773151 774185 732904 735425 735917 739734 745279 748983 751490 754605 757832 758029 759815 766926 767290 769093 731235 737944 739233 740974 740979 742210 742562 742607 744680 746310 750396 751323 753953 755856 758005 760490 761279 761407 767551 770282 611236 622624 627200 628987 629539 637542 697007 700329 701158 702340 705956 714141 714637 718033 721102 723011 774736 777117 778630 780394 783949 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.41%) |
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 611236 622624 627200 628987 629539 637542 697007 700329 701158 702340 705956 714141 714637 718033 721102 723011 724715 726624 727495 728597 728938 730930 731094 731235 731399 731608 732904 734081 735396 735425 735917 737208 737326 737426 737936 737944 739048 739233 739555 739734 739840 740974 740979 741797 742210 742562 742607 743256 743544 744680 745279 746310 746721 747527 748413 748983 750002 750396 750500 750901 751323 751490 752186 753953 754342 754605 755175 755320 755856 756267 756328 757227 757832 758005 758029 758410 759161 759626 759815 760490 761239 761279 761288 761328 761407 762334 764419 766289 766393 766527 766926 767290 767422 767551 768535 769093 769208 770282 770616 771027 773151 774185 774736 777117 778630 780394 783949 788648 790693 791334 792401 792763 793112 798717 803705 803961 804348 810959 811939 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"свое"
]
|
||||||||||||||||||||||||||||||
|
2.13 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сво"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 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.