Query Metrics
7
Database Queries
7
Different statements
130.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
109.71 ms (83.84%) |
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 487747 540939 615886 629891 713082 714943 715098 715122 716820 717221 717726 718025 718310 718437 719629 719823 720841 722092 724118 725336 726284 729802 731237 731261 731443 731445 731538 731593 731792 733381 734311 735124 735657 737010 739587 739638 741000 742841 743085 746032 747068 748938 749867 750161 757720 760205 760621 761286 762130 762371 763042 763593 763771 763809 765619 765788 765937 765976 766309 766371 768821 769650 773413 778065 781139 782032 782378 783973 784006 784013 784864 786151 786712 787207 787659 789508 789578 789590 789701 790261 790340 793324 794304 794997 796016 798487 798691 798715 798742 799671 799829 799920 799925 801721 803234 805072 812204 812254 812420 813229 817763 819192 819644 820213 821806 821810 824504 824567 824896 825426 825440 825664 826656 826718 826880 827677 828343 ] |
||||||||||||||||||||||||||||||
|
11.50 ms (8.79%) |
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 773413 750161 763593 763771 789508 793324 794304 799671 824638 821806 826880 817763 824896 820213 715122 713082 719629 715098 720841 784006 789701 798691 812254 731792 739587 741000 742841 746032 784013 801721 731261 749867 762130 766371 735124 735657 747068 762371 763042 765619 724118 748938 765937 768821 769650 731443 731445 765788 766309 717221 782032 786151 813229 487747 629891 819644 826656 826718 825426 821810 824504 824567 819192 825440 825664 826109 828343 827677 540939 714943 716820 717726 718310 718437 718025 719823 722092 615886 776489 781139 786712 787207 789578 794997 798715 798742 799829 778065 782378 784864 787659 796016 798487 799920 799925 803234 812204 812420 725336 729802 733381 734311 737010 739638 743085 757720 760205 760621 761286 763809 765976 783973 789590 790261 790340 805072 726284 731237 731538 731593 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.89%) |
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 487747 540939 615886 629891 713082 714943 715098 715122 716820 717221 717726 718025 718310 718437 719629 719823 720841 722092 724118 725336 726284 729802 731237 731261 731443 731445 731538 731593 731792 733381 734311 735124 735657 737010 739587 739638 741000 742841 743085 746032 747068 748938 749867 750161 757720 760205 760621 761286 762130 762371 763042 763593 763771 763809 765619 765788 765937 765976 766309 766371 768821 769650 773413 778065 781139 782032 782378 783973 784006 784013 784864 786151 786712 787207 787659 789508 789578 789590 789701 790261 790340 793324 794304 794997 796016 798487 798691 798715 798742 799671 799829 799920 799925 801721 803234 805072 812204 812254 812420 813229 817763 819192 819644 820213 821806 821810 824504 824567 824896 825426 825440 825664 826656 826718 826880 827677 828343 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex tik tok"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс тикток социальн сет"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс тикток социальн сет"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.21%) |
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.