Query Metrics
7
Database Queries
7
Different statements
169.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.70 ms (85.62%) |
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 532577 540764 542001 542039 542138 684806 723541 731598 731602 731650 732945 733667 733682 733702 733709 733721 733722 735253 735264 735309 737020 737039 737045 739231 739255 739276 739313 739333 739379 739384 739447 740049 740656 741366 741373 743452 743535 743572 743609 743620 745776 745801 745846 747035 747787 747914 749806 749826 749828 749843 749898 750338 751820 751918 751957 753997 754006 754024 754028 754059 754068 754088 763633 763752 764461 764760 777333 780142 787859 799926 801919 816151 816174 817277 818052 818105 818312 819755 819875 819885 820132 820381 821790 821805 821824 823158 824117 824576 824739 824756 824907 825031 825244 825330 825372 825374 825408 825473 825520 825632 825654 825930 826076 826088 826256 826403 826451 826658 826699 826717 827199 827267 827351 827503 827600 ] |
||||||||||||||||||||||||||||||
|
13.96 ms (8.26%) |
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 743609 745776 750338 731650 732945 740049 740656 743620 747035 763633 763752 764461 764760 777333 778520 780142 799926 801919 532577 540764 542039 542001 542138 684806 787859 733667 733702 733722 737020 739255 739379 749843 751957 754068 754088 733721 735253 737045 739313 741373 745801 747787 749826 749828 749898 754028 731598 733682 733709 735264 739231 739384 743452 745846 751918 754006 739276 739333 739447 741366 743572 751820 754024 731602 735309 737039 743535 747914 749806 753997 754059 816151 816174 818105 819755 819875 819885 820132 821805 823717 824117 825031 825930 825983 826403 826658 723541 826451 826699 825520 826717 817277 818312 821790 825178 825408 825654 826076 827199 827267 827351 827600 827503 818052 820381 821824 824576 825244 825372 825374 825632 826088 826256 823158 824739 824756 824907 825330 825336 825473 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (1.80%) |
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 532577 540764 542001 542039 542138 684806 723541 731598 731602 731650 732945 733667 733682 733702 733709 733721 733722 735253 735264 735309 737020 737039 737045 739231 739255 739276 739313 739333 739379 739384 739447 740049 740656 741366 741373 743452 743535 743572 743609 743620 745776 745801 745846 747035 747787 747914 749806 749826 749828 749843 749898 750338 751820 751918 751957 753997 754006 754024 754028 754059 754068 754088 763633 763752 764461 764760 777333 780142 787859 799926 801919 816151 816174 817277 818052 818105 818312 819755 819875 819885 820132 820381 821790 821805 821824 823158 824117 824576 824739 824756 824907 825031 825244 825330 825372 825374 825408 825473 825520 825632 825654 825930 826076 826088 826256 826403 826451 826658 826699 826717 827199 827267 827351 827503 827600 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tik tok xxx"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"тикток социальн сет xxx"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"тикток социальн сет xxx"
]
|
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.