Query Metrics
7
Database Queries
7
Different statements
145.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.03 ms (83.18%) |
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 6640 31503 67242 172420 185353 188293 213692 346188 389527 396627 441419 474261 502043 538760 576605 581251 582277 604140 604141 604287 605320 616457 658772 660340 665712 670765 671748 672184 672629 673459 673947 674120 679801 687560 699548 703534 709594 709965 712518 717947 720087 720362 720798 721004 721338 721429 722403 722701 722719 727643 727770 728284 729236 732514 735462 735866 740637 740791 740893 742491 742928 743914 744390 744976 747154 747533 748322 748965 748970 753473 754195 756826 761555 761954 763061 765252 765584 766669 766798 766801 766811 766817 766846 768041 768756 769100 769802 769868 771138 774087 775852 779695 780368 782041 783194 786330 786351 786762 787550 789971 791681 793313 797728 801909 804014 804335 805848 811629 813883 815804 816618 818226 818322 818924 820686 820840 822363 825273 826784 ] |
||||||||||||||||||||||||||||||
|
13.98 ms (9.61%) |
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 823492 672629 674120 687560 576605 787550 754195 766669 729236 732514 761954 774087 748970 779695 789971 185353 213692 172420 31503 389527 818226 818322 820686 822363 826784 825273 815804 816618 818924 581251 699548 658772 722403 604141 780368 756826 765252 763061 742491 744390 743914 801909 188293 679801 582277 502043 346188 67242 6640 396627 441419 813883 820840 474261 538760 670765 673459 709594 712518 720087 720362 720798 721338 721429 660340 665712 671748 672184 673947 709965 721004 722701 722719 703534 717947 616457 604287 604140 605320 782041 786330 811629 775852 786351 791681 793313 804335 740893 742928 748322 766798 769802 771138 783194 786762 797728 804014 805848 728284 735866 753473 766801 768756 769100 769868 727643 735462 744976 747154 765584 768041 727770 740637 747533 748965 761555 766811 766817 766846 740791 ] |
||||||||||||||||||||||||||||||
|
3.08 ms (2.12%) |
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 6640 31503 67242 172420 185353 188293 213692 346188 389527 396627 441419 474261 502043 538760 576605 581251 582277 604140 604141 604287 605320 616457 658772 660340 665712 670765 671748 672184 672629 673459 673947 674120 679801 687560 699548 703534 709594 709965 712518 717947 720087 720362 720798 721004 721338 721429 722403 722701 722719 727643 727770 728284 729236 732514 735462 735866 740637 740791 740893 742491 742928 743914 744390 744976 747154 747533 748322 748965 748970 753473 754195 756826 761555 761954 763061 765252 765584 766669 766798 766801 766811 766817 766846 768041 768756 769100 769802 769868 771138 774087 775852 779695 780368 782041 783194 786330 786351 786762 787550 789971 791681 793313 797728 801909 804014 804335 805848 811629 813883 815804 816618 818226 818322 818924 820686 820840 822363 825273 826784 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal and pussy"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал pussy"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал pussy"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (1.01%) |
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.