Query Metrics
7
Database Queries
7
Different statements
144.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.90 ms (83.46%) |
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 39843 220876 341753 385347 387326 393761 396785 398005 400179 405894 423177 448400 466354 516432 527787 536260 537710 537729 537740 546098 549407 554310 557529 563912 567954 586831 586842 589298 603455 604149 609818 617639 623756 626559 636575 684205 687663 696314 696321 696586 698607 701785 706350 709798 711251 712621 714996 716002 724748 727153 728507 729326 729619 729959 734932 737955 743033 744540 747628 748120 749053 750444 753521 754482 754530 756434 758580 759361 761101 761121 761307 766181 766365 767993 768077 768175 770742 771139 777897 778157 780469 782038 787882 793554 793626 794177 796546 799576 800220 801055 801945 804946 806320 808251 810632 811545 813083 817662 817989 818134 818392 818748 820214 820516 823554 823600 823724 824125 824717 824775 824877 825176 825208 825278 825599 827133 827254 827580 827634 828168 ] |
||||||||||||||||||||||||||||||
|
14.07 ms (9.71%) |
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 766181 753521 758580 728507 737955 761101 761307 701785 778157 782038 396785 818134 823724 824717 827133 827580 823554 818392 824775 448400 466354 567954 549407 696321 696586 706350 714996 603455 609818 586831 586842 589298 806320 801055 729326 729619 749053 793626 808251 811545 766365 754530 744540 747628 743033 768175 787882 39843 516432 385347 220876 817989 820214 820516 823600 825176 825208 827254 817662 824125 824877 825599 818748 825278 828168 827634 536260 537729 537710 537740 527787 554310 557529 546098 709798 684205 698607 712621 687663 696314 716002 563912 623756 617639 604149 626559 777897 780469 793554 794177 796546 799576 810632 727153 754482 800220 801945 804946 724748 729959 748120 759361 761121 734932 768077 771139 750444 756434 767993 770742 636575 711251 813083 393761 341753 387326 398005 400179 405894 423177 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.76%) |
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 39843 220876 341753 385347 387326 393761 396785 398005 400179 405894 423177 448400 466354 516432 527787 536260 537710 537729 537740 546098 549407 554310 557529 563912 567954 586831 586842 589298 603455 604149 609818 617639 623756 626559 636575 684205 687663 696314 696321 696586 698607 701785 706350 709798 711251 712621 714996 716002 724748 727153 728507 729326 729619 729959 734932 737955 743033 744540 747628 748120 749053 750444 753521 754482 754530 756434 758580 759361 761101 761121 761307 766181 766365 767993 768077 768175 770742 771139 777897 778157 780469 782038 787882 793554 793626 794177 796546 799576 800220 801055 801945 804946 806320 808251 810632 811545 813083 817662 817989 818134 818392 818748 820214 820516 823554 823600 823724 824125 824717 824775 824877 825176 825208 825278 825599 827133 827254 827580 827634 828168 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.54%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"xxx спящ"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"xxx sleep"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"xxx спящ"
]
|
||||||||||||||||||||||||||||||
|
1.17 ms (0.81%) |
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.