Query Metrics
7
Database Queries
7
Different statements
416.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.39 ms (51.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum пов"
]
|
||||||||||||||||||||||||||||||
|
178.95 ms (42.97%) |
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 124519 419281 421144 458995 459368 459404 462616 463501 465405 499995 506246 517908 519173 523154 529460 540429 545254 547372 557922 559317 560793 564336 567081 572956 577676 578207 582832 590604 597187 599448 606886 614597 614832 614847 617061 641764 666683 687140 703699 710108 720057 720337 724698 727984 727985 761307 763413 763955 765267 765365 766966 767339 767449 767652 767678 768533 771324 776030 778634 781553 782661 785996 786681 787071 787693 789352 792462 793028 794117 796008 796046 796735 797208 797283 797307 797668 800608 800840 803181 804132 808104 808840 808908 809309 809486 813112 814325 816811 817447 819312 819758 819793 819828 820207 821533 823546 823981 824140 824323 824334 825352 825464 825850 826252 826346 826580 828121 828193 828235 828351 828439 828704 828778 828781 828806 828811 ] |
||||||||||||||||||||||||||||||
|
14.02 ms (3.37%) |
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 606886 599448 617061 597187 797668 808840 763955 419281 459368 828806 797283 804132 767652 767678 462616 517908 540429 564336 557922 720057 614847 796008 800608 808908 771324 614597 614832 809486 421144 641764 821533 817447 824323 828351 828580 547372 529460 820207 814325 780811 800840 787693 796735 766966 823546 823981 828811 828121 828704 794117 796046 808104 825850 823840 824746 809309 819793 825464 828778 828235 828439 710108 782661 793028 761307 776030 559317 720337 797307 727985 767449 781553 792462 797208 803181 763413 767339 768533 787071 463501 572956 567081 578207 560793 590604 765267 724698 778634 813112 458995 459404 465405 499995 519173 506246 816811 826252 824140 826580 819758 819828 825352 828781 828193 582832 703699 786681 727984 785996 789352 826346 824334 819312 124519 765365 523154 577676 545254 687140 666683 ] |
||||||||||||||||||||||||||||||
|
3.18 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 124519 419281 421144 458995 459368 459404 462616 463501 465405 499995 506246 517908 519173 523154 529460 540429 545254 547372 557922 559317 560793 564336 567081 572956 577676 578207 582832 590604 597187 599448 606886 614597 614832 614847 617061 641764 666683 687140 703699 710108 720057 720337 724698 727984 727985 761307 763413 763955 765267 765365 766966 767339 767449 767652 767678 768533 771324 776030 778634 781553 782661 785996 786681 787071 787693 789352 792462 793028 794117 796008 796046 796735 797208 797283 797307 797668 800608 800840 803181 804132 808104 808840 808908 809309 809486 813112 814325 816811 817447 819312 819758 819793 819828 820207 821533 823546 823981 824140 824323 824334 825352 825464 825850 826252 826346 826580 828121 828193 828235 828351 828439 828704 828778 828781 828806 828811 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum пов"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum pov"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.46%) |
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.