Query Metrics
7
Database Queries
7
Different statements
167.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.46 ms (87.67%) |
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 427005 429937 432426 433145 446076 447187 458891 462277 478917 483242 486886 505075 509144 509743 513405 524392 525888 537850 541301 544515 548555 553249 564715 568227 568727 588764 602372 605649 610835 614617 614946 615346 628213 628229 670736 678596 718026 744417 763859 764790 766056 766112 766448 767332 769186 769188 770578 771769 772256 772321 772645 772822 772963 773414 775672 777542 777564 777579 777616 777621 777628 777699 777808 777956 778840 778855 778990 779084 779538 779554 779828 780081 781036 781531 782326 782922 782928 783027 783259 783359 783736 783800 784222 785987 786739 786796 787493 788005 789147 789199 789445 789912 790299 790767 791017 791143 791174 791465 791616 792238 792976 794068 795355 795568 795641 802026 807279 808351 809345 811589 812625 812872 816173 818100 819873 820086 825510 825706 ] |
||||||||||||||||||||||||||||||
|
11.89 ms (7.12%) |
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 777542 777579 782922 785987 787493 789199 791465 792976 807279 777616 777628 778840 779554 781036 783736 786739 787572 789912 790299 791143 795641 766056 769186 769188 772256 772645 773414 783027 783800 784222 792238 772822 772963 766112 767332 771769 775672 777564 777621 777808 778855 778990 779828 781531 782928 783359 787389 789445 790767 791174 791616 794068 795568 802026 811589 812872 544515 509144 548555 605649 447187 458891 427005 446076 478917 486886 610835 795355 779538 564715 568727 433145 432426 505075 483242 602372 537850 513405 553249 588764 462277 429937 524392 525888 509743 816173 818100 825706 819873 820086 825510 541301 568227 678596 670736 718026 615346 628229 614946 628213 614617 777956 788005 812625 777699 779084 780081 786796 791017 808351 766448 782326 783259 789147 809345 744417 764790 770578 772321 763859 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.28%) |
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 427005 429937 432426 433145 446076 447187 458891 462277 478917 483242 486886 505075 509144 509743 513405 524392 525888 537850 541301 544515 548555 553249 564715 568227 568727 588764 602372 605649 610835 614617 614946 615346 628213 628229 670736 678596 718026 744417 763859 764790 766056 766112 766448 767332 769186 769188 770578 771769 772256 772321 772645 772822 772963 773414 775672 777542 777564 777579 777616 777621 777628 777699 777808 777956 778840 778855 778990 779084 779538 779554 779828 780081 781036 781531 782326 782922 782928 783027 783259 783359 783736 783800 784222 785987 786739 786796 787493 788005 789147 789199 789445 789912 790299 790767 791017 791143 791174 791465 791616 792238 792976 794068 795355 795568 795641 802026 807279 808351 809345 811589 812625 812872 816173 818100 819873 820086 825510 825706 ] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск дрочк член пов"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian handjob pov"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск дрочк член пов"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.95%) |
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.