Query Metrics
7
Database Queries
7
Different statements
162.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.40 ms (84.70%) |
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 38909 73503 183401 432398 464803 487570 514282 560912 574524 577550 597106 624465 625907 626793 627961 635133 643918 650551 664993 671894 677893 683679 693852 701059 707583 715469 715687 717697 722151 722444 724092 725260 725333 726428 728868 734453 734801 734922 734934 736330 743846 743967 750671 751228 753239 753304 755866 757301 760529 763370 764264 764326 767903 768542 769178 770086 772797 774919 775187 778012 779086 779123 779132 779827 780877 781125 782111 784086 784426 785735 786700 787167 787415 788962 789380 790948 790970 791158 792010 792260 792327 793484 794664 794912 795929 797342 797744 798525 799856 801304 801859 802092 802787 802972 805106 807193 807380 814458 816584 817723 818416 818437 818763 819404 820534 820561 820576 821124 822435 822677 822686 823650 823737 823748 823876 823977 824542 825401 827141 827834 ] |
||||||||||||||||||||||||||||||
|
12.99 ms (8.01%) |
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 767903 769178 734922 743846 724092 728868 736330 768542 770086 726428 734934 751228 753239 763370 764264 764326 772797 715687 722151 779827 795929 797744 807193 38909 73503 183401 432398 814458 816584 817723 820561 824542 825401 823876 818416 818437 819404 820534 821124 822677 823650 823737 823748 823977 827141 818763 822435 820576 822686 827834 514282 464803 487570 664993 683679 693852 701059 722444 707583 715469 650551 671894 677893 717697 560912 574524 577550 635133 597106 624465 643918 627961 625907 626793 779086 779132 787167 788962 789380 790948 791158 792010 792260 793484 794912 797342 774919 775187 778012 779123 780877 781125 782111 784426 785735 787415 790970 801859 802092 805106 807380 725333 734801 750671 755866 757301 760529 784086 786700 792327 794664 798525 799856 801304 802787 802972 725260 734453 743967 753304 ] |
||||||||||||||||||||||||||||||
|
3.91 ms (2.41%) |
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 38909 73503 183401 432398 464803 487570 514282 560912 574524 577550 597106 624465 625907 626793 627961 635133 643918 650551 664993 671894 677893 683679 693852 701059 707583 715469 715687 717697 722151 722444 724092 725260 725333 726428 728868 734453 734801 734922 734934 736330 743846 743967 750671 751228 753239 753304 755866 757301 760529 763370 764264 764326 767903 768542 769178 770086 772797 774919 775187 778012 779086 779123 779132 779827 780877 781125 782111 784086 784426 785735 786700 787167 787415 788962 789380 790948 790970 791158 792010 792260 792327 793484 794664 794912 795929 797342 797744 798525 799856 801304 801859 802092 802787 802972 805106 807193 807380 814458 816584 817723 818416 818437 818763 819404 820534 820561 820576 821124 822435 822677 822686 823650 823737 823748 823876 823977 824542 825401 827141 827834 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hot sperm"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hot сперм"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hot сперм"
]
|
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.