Query Metrics
7
Database Queries
7
Different statements
974.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
632.87 ms (64.96%) |
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 794422 804148 734817 755175 762854 763487 767718 762040 769570 733279 763144 763782 763787 779930 789454 790184 826598 826718 819324 824504 718396 713842 776660 783508 757924 772725 794692 812524 760172 747183 737138 740116 753154 787335 814434 719407 737198 762400 776209 776398 780788 781303 812897 782588 758669 752080 711498 799163 799175 825370 826656 824564 825426 813866 828343 551772 775523 786712 795428 744180 794653 736183 746221 748063 750882 767715 742454 747171 748393 762628 766127 733425 751403 790991 807063 807214 782385 728957 736912 715267 774012 808396 824119 825335 818182 823902 826398 826509 823633 825797 825800 828254 542136 668316 706385 717573 678672 718035 615906 774651 784008 784021 799691 802358 799923 729367 733363 733773 734273 750574 790106 806605 812134 724661 754066 762008 762471 763920 726430 729797 ] |
||||||||||||||||||||||||||||||
|
216.94 ms (22.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"тикток социальн сет сиськ"
]
|
||||||||||||||||||||||||||||||
|
115.93 ms (11.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 542136 551772 615906 668316 678672 706385 711498 713842 715267 717573 718035 718396 719407 724661 726430 728957 729367 729797 733279 733363 733425 733773 734273 734817 736183 736912 737138 737198 740116 742454 744180 746221 747171 747183 748063 748393 750574 750882 751403 752080 753154 754066 755175 757924 758669 760172 762008 762040 762400 762471 762628 762854 763144 763787 763920 767715 767718 769570 772725 774012 774651 775523 776209 776398 776660 779930 780788 781303 782385 782588 783508 784008 784021 786712 787335 789454 790106 790184 790991 794422 794653 794692 795428 799163 799175 799691 799923 802358 804148 806605 807063 807214 808396 812134 812524 812897 813866 814434 818182 819324 823633 823902 824119 824504 824564 825335 825370 825426 825797 825800 826509 826598 826656 826718 828254 828343 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (0.31%) |
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 542136 551772 615906 668316 678672 706385 711498 713842 715267 717573 718035 718396 719407 724661 726430 728957 729367 729797 733279 733363 733425 733773 734273 734817 736183 736912 737138 737198 740116 742454 744180 746221 747171 747183 748063 748393 750574 750882 751403 752080 753154 754066 755175 757924 758669 760172 762008 762040 762400 762471 762628 762854 763144 763787 763920 767715 767718 769570 772725 774012 774651 775523 776209 776398 776660 779930 780788 781303 782385 782588 783508 784008 784021 786712 787335 789454 790106 790184 790991 794422 794653 794692 795428 799163 799175 799691 799923 802358 804148 806605 807063 807214 808396 812134 812524 812897 813866 814434 818182 819324 823633 823902 824119 824504 824564 825335 825370 825426 825797 825800 826509 826598 826656 826718 828254 828343 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (0.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tiktok tits"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"тикток социальн сет сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.15%) |
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.