Query Metrics
7
Database Queries
7
Different statements
595.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
360.97 ms (60.61%) |
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 37365 393476 402339 441530 441666 442069 459194 475327 479982 484153 511906 521182 533230 542252 543142 543904 544173 544909 553806 585227 586732 589243 592851 599909 601328 604323 606524 606881 609625 611282 615197 620968 631218 633885 637579 641372 642226 649072 666683 681463 687728 688268 691611 697937 723667 728075 735965 737943 742518 750966 755748 761671 764207 764913 766922 768468 769406 773330 774762 774975 775374 775700 776317 778074 778601 780512 780720 781819 782809 783080 786093 786983 792654 794291 796076 796445 796598 797451 798811 799354 799742 801315 802752 804024 804506 807924 808844 810431 811458 811680 813042 813722 816180 816676 817201 817400 818187 819007 819314 819712 819829 820099 820624 823467 824186 824669 825271 825814 826529 826605 826819 827880 828039 828545 828582 ] |
||||||||||||||||||||||||||||||
|
210.54 ms (35.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие жоп пов"
]
|
||||||||||||||||||||||||||||||
|
14.76 ms (2.48%) |
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 479982 475327 484153 533230 553806 649072 688268 691611 666683 697937 592851 601328 642226 620968 606881 609625 611282 599909 604323 631218 641372 780512 782809 786983 796598 799742 811458 778601 797451 807924 808844 796076 802752 810431 750966 755748 764207 735965 768468 774762 774975 778074 787390 804024 780720 393476 511906 441530 723667 783080 442069 459194 637579 585227 775700 794291 804506 813042 786093 773330 728075 606524 775374 441666 589243 816180 813722 825271 819829 817201 776317 615197 799354 820099 543904 544173 544909 586732 796445 801315 792654 521182 817400 819712 828039 798811 37365 402339 819007 826529 816676 818187 824669 824677 826819 819314 820624 823262 823467 825814 824186 826605 827880 828545 828582 543142 542252 681463 687728 633885 780741 781819 737943 742518 761671 769406 811680 764913 766922 767592 ] |
||||||||||||||||||||||||||||||
|
3.62 ms (0.61%) |
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 37365 393476 402339 441530 441666 442069 459194 475327 479982 484153 511906 521182 533230 542252 543142 543904 544173 544909 553806 585227 586732 589243 592851 599909 601328 604323 606524 606881 609625 611282 615197 620968 631218 633885 637579 641372 642226 649072 666683 681463 687728 688268 691611 697937 723667 728075 735965 737943 742518 750966 755748 761671 764207 764913 766922 768468 769406 773330 774762 774975 775374 775700 776317 778074 778601 780512 780720 781819 782809 783080 786093 786983 792654 794291 796076 796445 796598 797451 798811 799354 799742 801315 802752 804024 804506 807924 808844 810431 811458 811680 813042 813722 816180 816676 817201 817400 818187 819007 819314 819712 819829 820099 820624 823467 824186 824669 825271 825814 826529 826605 826819 827880 828039 828545 828582 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass pov"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.28%) |
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.