Query Metrics
7
Database Queries
7
Different statements
208.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
183.29 ms (87.76%) |
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 418381 437367 446586 498760 529674 532592 537487 542002 567800 573212 591943 604635 711438 713727 715810 722937 723794 723917 728375 732393 732604 732945 733213 733520 735134 735205 735213 735233 742888 743609 745542 746072 748783 749648 749655 750245 750893 751671 752025 752029 759350 760497 762363 762622 763752 764293 764353 764368 764461 764464 764845 765159 765373 765638 765706 765957 765980 766962 767849 769160 773312 774061 777006 777257 778670 782033 782380 782384 782388 784062 784741 785517 786177 788341 789389 790119 790121 792262 792315 794764 795097 798505 799176 799673 800652 803845 804259 804963 805455 806929 810855 811455 811752 812875 813136 813155 813184 814729 816175 818838 819364 820193 821790 823900 825332 825654 825707 826494 826796 827317 827525 828108 828169 828235 ] |
||||||||||||||||||||||||||||||
|
13.33 ms (6.38%) |
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 591943 804259 804963 799176 732604 765638 604635 786177 798505 813136 816175 823900 826494 828108 828235 532592 782033 788341 764866 790119 567800 715810 782384 759350 765706 778670 537487 418381 529674 542002 812875 828169 573212 437367 825332 826796 820193 825707 803845 792315 762622 810855 735233 764845 765957 764464 764910 722937 825386 790121 814729 713727 785517 777006 784741 789389 764368 769160 782388 813155 732393 762363 765159 767849 723917 745542 748783 765373 733520 750893 752029 764353 784062 806929 794764 800652 795097 752025 764293 766962 827525 825666 811752 733213 818838 711438 792262 782380 811455 723794 735205 749655 799673 805455 735213 749648 766664 746072 750245 751671 742888 743609 732945 763752 764461 498760 446586 764465 765980 773312 735134 813184 774061 819364 777257 728375 827317 760497 821790 825654 ] |
||||||||||||||||||||||||||||||
|
4.44 ms (2.13%) |
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 418381 437367 446586 498760 529674 532592 537487 542002 567800 573212 591943 604635 711438 713727 715810 722937 723794 723917 728375 732393 732604 732945 733213 733520 735134 735205 735213 735233 742888 743609 745542 746072 748783 749648 749655 750245 750893 751671 752025 752029 759350 760497 762363 762622 763752 764293 764353 764368 764461 764464 764845 765159 765373 765638 765706 765957 765980 766962 767849 769160 773312 774061 777006 777257 778670 782033 782380 782384 782388 784062 784741 785517 786177 788341 789389 790119 790121 792262 792315 794764 795097 798505 799176 799673 800652 803845 804259 804963 805455 806929 810855 811455 811752 812875 813136 813155 813184 814729 816175 818838 819364 820193 821790 823900 825332 825654 825707 826494 826796 827317 827525 828108 828169 828235 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tiktok ass"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"тикток социальн сет жоп"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"тикток социальн сет жоп"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.84%) |
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.