Query Metrics
7
Database Queries
7
Different statements
358.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
205.34 ms (57.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"POV(ПОВ)"
]
|
||||||||||||||||||||||||||||||
|
133.49 ms (37.22%) |
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 208400 385678 391470 539271 542252 543142 544370 573148 615763 618309 633885 639881 643880 655428 672379 681463 687728 735655 737943 738154 742518 761671 762286 763016 764913 766922 767600 768605 769141 769406 774051 774648 781616 781819 787091 787257 789315 789324 790307 794117 795195 797582 801324 802257 804924 809780 811680 815009 816136 816162 816648 816676 817778 818063 818187 818244 818579 818989 819007 819314 820624 821103 821951 823102 823467 823546 823573 823851 823966 823981 824186 824359 824669 824697 824901 824959 825383 825417 825575 825616 825726 825814 825817 825888 825965 826050 826277 826294 826529 826548 826605 826819 827880 827986 828121 828127 828240 828268 828545 828563 828582 828704 828720 828811 ] |
||||||||||||||||||||||||||||||
|
11.73 ms (3.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 826050 828268 828586 385678 208400 391470 818063 818579 819007 823966 824625 824828 825726 825817 826294 826529 826548 816648 816676 818187 823573 824074 824192 824669 824677 824697 826008 826277 826819 815009 816136 816162 817778 818244 818989 819314 820624 821103 822993 823102 823188 823262 823467 823851 824901 825575 825616 825814 825965 821951 823546 823981 824359 824959 825353 825383 825417 825421 825888 828127 828240 828811 824186 826605 828121 827986 827880 828230 828720 828704 828702 828545 828582 828563 539271 543142 542252 573148 544370 681463 655428 672379 687728 639881 618309 633885 780741 789315 790307 804924 781819 794117 797582 801324 802257 737943 742518 761671 762286 768605 769141 769406 787091 809780 811680 735655 738154 764913 763016 766922 767600 767592 774051 615763 643880 774648 781616 787257 789324 795195 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (0.76%) |
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 208400 385678 391470 539271 542252 543142 544370 573148 615763 618309 633885 639881 643880 655428 672379 681463 687728 735655 737943 738154 742518 761671 762286 763016 764913 766922 767600 768605 769141 769406 774051 774648 781616 781819 787091 787257 789315 789324 790307 794117 795195 797582 801324 802257 804924 809780 811680 815009 816136 816162 816648 816676 817778 818063 818187 818244 818579 818989 819007 819314 820624 821103 821951 823102 823467 823546 823573 823851 823966 823981 824186 824359 824669 824697 824901 824959 825383 825417 825575 825616 825726 825814 825817 825888 825965 826050 826277 826294 826529 826548 826605 826819 827880 827986 828121 828127 828240 828268 828545 828563 828582 828704 828720 828811 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.52%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов пов"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.49%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.49%) |
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.