Query Metrics
7
Database Queries
7
Different statements
212.41 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.64 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.10 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"face to face"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.31 ms |
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 791995 792398 793753 794481 795104 798117 801578 807008 808853 810593 811033 729863 734229 734343 739915 742306 744486 750432 752176 752197 754122 757280 760696 761397 762246 767482 783381 783450 783929 785944 786032 787576 788840 789154 789165 790838 791785 794193 799739 800118 803256 803443 733789 734238 738299 748335 771953 724501 724697 727884 734856 746042 747169 759812 765029 768126 768363 771849 726373 728814 734350 734354 741045 744158 744439 746616 749138 749153 762970 763064 763122 763334 769340 772251 729269 731753 740018 748767 758292 765197 765770 768023 769350 772922 773498 773829 612578 624691 697558 701200 701939 709323 719755 774880 776464 777199 777479 777612 778797 778939 779036 779949 782774 782939 783752 788979 790159 790824 790952 791049 791491 792197 793878 795766 800273 800994 802976 808529 332765 444639 ] |
||||||||||||||||||||||||||||||
| 4 | 4.33 ms |
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 332765 444639 612578 624691 697558 701200 701939 709323 719755 724501 724697 726373 727884 728814 729269 729863 731753 733789 734229 734238 734343 734350 734354 734856 738299 739915 740018 741045 742306 744158 744439 744486 746042 746616 747169 748335 748767 749138 749153 750432 752176 752197 754122 757280 758292 759812 760696 761397 762246 762970 763064 763122 763334 765029 765197 765770 767482 768023 768126 768363 769340 769350 771849 771953 772251 772922 773498 773829 774880 776464 777199 777479 777612 778797 778939 779036 779949 782774 782939 783381 783450 783752 783929 785944 786032 787576 788840 788979 789154 789165 790159 790824 790838 790952 791049 791491 791785 791995 792197 792398 793753 793878 794193 794481 795104 795766 798117 799739 800118 800273 800994 801578 802976 803256 803443 807008 808529 808853 810593 811033 ] |
||||||||||||||||||||||||||||||
| 5 | 186.63 ms |
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 332765 444639 612578 624691 697558 701200 701939 709323 719755 724501 724697 726373 727884 728814 729269 729863 731753 733789 734229 734238 734343 734350 734354 734856 738299 739915 740018 741045 742306 744158 744439 744486 746042 746616 747169 748335 748767 749138 749153 750432 752176 752197 754122 757280 758292 759812 760696 761397 762246 762970 763064 763122 763334 765029 765197 765770 767482 768023 768126 768363 769340 769350 771849 771953 772251 772922 773498 773829 774880 776464 777199 777479 777612 778797 778939 779036 779949 782774 782939 783381 783450 783752 783929 785944 786032 787576 788840 788979 789154 789165 790159 790824 790838 790952 791049 791491 791785 791995 792197 792398 793753 793878 794193 794481 795104 795766 798117 799739 800118 800273 800994 801578 802976 803256 803443 807008 808529 808853 810593 811033 ] |
||||||||||||||||||||||||||||||
| 6 | 1.89 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"face face"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.52 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"face face"
]
|
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.