Query Metrics
7
Database Queries
7
Different statements
146.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.33 ms (82.74%) |
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 4266 54085 233618 384342 391571 391873 402032 422350 423983 429825 432598 433352 434848 441530 461009 462334 466202 467268 502551 518818 541662 546674 563291 589525 597553 616778 626793 631246 635133 668842 668978 670815 671125 671894 672885 674873 675041 689212 689908 690878 697763 698233 708149 711378 715055 717675 722803 723196 724829 731094 740082 741710 742562 744713 746391 751972 754432 754605 755866 758988 759506 760677 763524 765027 766370 767908 768634 772651 774919 777873 778084 779142 779331 780051 780061 781125 781316 781491 781706 782111 783178 784086 784426 785735 787161 787592 790948 792327 792728 793952 794889 795243 795337 797357 799544 800717 800840 801308 801690 801805 802092 804840 805389 805394 811819 813941 816712 818372 818763 819978 820009 820197 820218 820729 821039 823650 826674 827141 827432 827725 ] |
||||||||||||||||||||||||||||||
|
14.69 ms (10.02%) |
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 827432 689212 631246 466202 826674 819978 823650 827141 818763 820197 541662 546674 563291 675041 697763 708149 711378 668842 668978 674873 690878 715055 670815 671125 671894 672885 689908 698233 717675 635133 589525 626793 778084 779142 779331 790948 795337 801308 801690 804840 805389 774919 780061 781125 781316 782111 784426 785735 787592 794889 800840 802092 805394 811819 754432 755866 772651 781491 784086 792327 792728 793952 795243 800717 801805 731094 746391 765027 766370 768634 724829 751972 767908 754605 759506 760677 763524 740082 742562 744713 758988 723196 777873 783178 787161 797357 799544 422350 467268 233618 616778 518818 391873 722803 402032 423983 441530 429825 4266 432598 384342 434848 597553 781706 741710 780051 391571 461009 462334 54085 433352 502551 818372 816712 827725 813941 820009 820729 820218 821039 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.86%) |
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 4266 54085 233618 384342 391571 391873 402032 422350 423983 429825 432598 433352 434848 441530 461009 462334 466202 467268 502551 518818 541662 546674 563291 589525 597553 616778 626793 631246 635133 668842 668978 670815 671125 671894 672885 674873 675041 689212 689908 690878 697763 698233 708149 711378 715055 717675 722803 723196 724829 731094 740082 741710 742562 744713 746391 751972 754432 754605 755866 758988 759506 760677 763524 765027 766370 767908 768634 772651 774919 777873 778084 779142 779331 780051 780061 781125 781316 781491 781706 782111 783178 784086 784426 785735 787161 787592 790948 792327 792728 793952 794889 795243 795337 797357 799544 800717 800840 801308 801690 801805 802092 804840 805389 805394 811819 813941 816712 818372 818763 819978 820009 820197 820218 820729 821039 823650 826674 827141 827432 827725 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hot russian"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hot русск"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.05%) |
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.