Query Metrics
7
Database Queries
7
Different statements
189.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.11 ms (87.17%) |
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 5852 408508 415860 425396 439090 441284 449144 459207 460242 472564 493064 522248 529676 530029 531895 533994 540412 549205 555503 555661 569701 577334 577704 587988 588284 588531 589346 590105 596833 601208 607253 610393 610422 613240 618259 629166 634253 635283 637309 638788 649230 652829 655003 661374 664607 671861 673825 679472 679704 695775 696764 696812 698818 704955 707183 708063 711225 717984 718365 719030 719978 720013 720118 720761 720864 721303 721420 721659 723820 723946 725600 726747 731679 736745 741365 744823 745262 750316 750706 755489 756234 758995 761085 761093 761123 762547 762934 767793 770374 771984 772575 774684 775926 776570 777235 777315 779203 779687 786856 788280 790681 791073 792510 793188 793892 794343 799348 805035 805251 807685 808343 811047 811235 818447 818866 818912 821165 823489 827611 ] |
||||||||||||||||||||||||||||||
|
14.21 ms (7.50%) |
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 441284 449144 721420 818912 818866 459207 472564 533994 540412 549205 661374 721303 679704 695775 696764 718365 704955 708063 717984 590105 629166 774684 775926 793892 794343 799348 805251 808343 777315 788280 790681 807685 723946 725600 726747 750316 771984 786856 792510 793188 805035 731679 744823 761085 761093 761123 767793 772575 736745 741365 762934 770374 762547 613240 779203 779687 811047 811235 439090 408508 425396 415860 827611 460242 555661 649230 577334 587988 589346 596833 601208 776570 777235 750706 791073 723820 756234 758995 755489 745262 5852 818447 821165 823489 531895 522248 530029 529676 493064 577704 555503 581420 671861 711225 719030 720761 720864 721659 655003 664607 679472 696812 698818 652829 673825 707183 719978 720013 720118 569701 607253 610422 588284 588531 610393 635283 637309 638788 618259 634253 ] |
||||||||||||||||||||||||||||||
|
3.37 ms (1.78%) |
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 5852 408508 415860 425396 439090 441284 449144 459207 460242 472564 493064 522248 529676 530029 531895 533994 540412 549205 555503 555661 569701 577334 577704 587988 588284 588531 589346 590105 596833 601208 607253 610393 610422 613240 618259 629166 634253 635283 637309 638788 649230 652829 655003 661374 664607 671861 673825 679472 679704 695775 696764 696812 698818 704955 707183 708063 711225 717984 718365 719030 719978 720013 720118 720761 720864 721303 721420 721659 723820 723946 725600 726747 731679 736745 741365 744823 745262 750316 750706 755489 756234 758995 761085 761093 761123 762547 762934 767793 770374 771984 772575 774684 775926 776570 777235 777315 779203 779687 786856 788280 790681 791073 792510 793188 793892 794343 799348 805035 805251 807685 808343 811047 811235 818447 818866 818912 821165 823489 827611 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"all girl"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"all девушк"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"all девушк"
]
|
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.