Query Metrics
7
Database Queries
7
Different statements
157.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.34 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 553367 557690 575400 589818 590092 591770 596011 598358 600783 606939 607993 613109 615453 618763 624899 625925 626133 630316 643919 644126 644187 646726 651696 662877 667350 673835 696088 703800 704111 710674 712446 720527 727981 736972 738932 741365 744175 744176 744967 745173 745213 749567 751595 753108 754976 755193 758228 758242 758271 758272 758294 761974 763794 764348 768054 769435 769528 769989 769995 770128 770168 770231 770252 770400 771939 771944 771945 771949 771951 772169 772175 772229 772396 772465 772672 774782 776868 777102 777378 777413 777422 777429 781270 781275 781645 782475 782648 784678 784863 785326 789832 791724 791726 795527 797333 797346 799039 799159 799705 802907 803130 803136 803575 803915 804426 806561 806658 807824 809049 809068 809072 809348 810444 810494 810535 811242 811294 812631 812870 813190 ] |
||||||||||||||||||||||||||||||
|
13.60 ms (8.64%) |
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 696088 712446 589818 777422 782648 813190 710674 704111 673835 703800 590092 596011 624899 810444 812631 803136 806561 744176 770231 772672 625925 804426 811242 806658 557690 618763 774782 745173 751595 754976 799159 626133 606939 781270 810535 769995 772175 736972 763794 785326 662877 720527 598358 600783 776868 753108 771944 770252 727981 770128 758271 809049 575400 646726 643919 644187 784863 795527 797346 799705 799039 744175 811294 758228 770168 771945 758294 769989 771949 772229 797333 807824 749567 761974 770400 777429 803130 553367 607993 613109 630316 777102 791724 810494 781275 769435 784678 809072 771939 738932 768054 745213 772396 803915 771951 755193 777378 791726 667350 651696 615453 591770 777413 802907 803575 782475 764348 772169 772465 781645 741365 769528 809348 744967 809068 644126 812870 789832 758242 758272 ] |
||||||||||||||||||||||||||||||
|
3.36 ms (2.14%) |
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 553367 557690 575400 589818 590092 591770 596011 598358 600783 606939 607993 613109 615453 618763 624899 625925 626133 630316 643919 644126 644187 646726 651696 662877 667350 673835 696088 703800 704111 710674 712446 720527 727981 736972 738932 741365 744175 744176 744967 745173 745213 749567 751595 753108 754976 755193 758228 758242 758271 758272 758294 761974 763794 764348 768054 769435 769528 769989 769995 770128 770168 770231 770252 770400 771939 771944 771945 771949 771951 772169 772175 772229 772396 772465 772672 774782 776868 777102 777378 777413 777422 777429 781270 781275 781645 782475 782648 784678 784863 785326 789832 791724 791726 795527 797333 797346 799039 799159 799705 802907 803130 803136 803575 803915 804426 806561 806658 807824 809049 809068 809072 809348 810444 810494 810535 811242 811294 812631 812870 813190 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo girl joi"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло девушк joi"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло девушк joi"
]
|
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.