Query Metrics
7
Database Queries
7
Different statements
147.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.77 ms (83.01%) |
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 413898 417068 455423 456167 476582 480256 482844 530181 531587 537294 539228 542673 546434 546872 548512 550687 552363 557862 561041 570701 571947 575579 584840 585329 591721 594495 595730 601945 602575 603032 603828 605437 616525 617072 623398 629265 630238 632755 638106 647183 652665 654891 661924 670066 673504 684093 693843 694945 712541 715746 717757 741832 747527 760512 761301 763148 763168 763655 764544 764610 765987 768106 769656 775199 777616 777801 777946 778015 778222 778671 779042 779539 780509 780599 781284 781561 782608 783066 783298 783521 783783 785049 785988 786714 787658 787765 788350 789147 789901 790175 790184 791031 791274 791449 791695 791749 792827 793351 793433 795154 796357 798301 798724 799901 803701 809614 809636 811596 818013 821830 823650 824081 825144 825588 827319 828777 ] |
||||||||||||||||||||||||||||||
|
14.20 ms (9.60%) |
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 768106 824081 825588 818013 786714 777616 764544 783066 791449 661924 603828 789147 584840 791749 741832 413898 787658 760512 575579 623398 809614 561041 799901 480256 778222 605437 765987 693843 591721 603032 601945 417068 795154 673504 571947 694945 764610 780599 455423 828777 775199 803701 811596 796357 791695 792827 798301 763148 763655 763712 781284 790175 798724 570701 783298 539228 764517 783521 670066 595730 552363 787765 763168 546434 712541 550687 531587 548512 652665 654891 546872 616525 629265 617072 632755 602575 594495 789901 456167 788350 791031 785988 630238 778671 476582 763224 825144 823650 821830 638106 777946 785049 793433 780509 791274 793351 747527 761301 769656 769681 778015 781561 782608 790184 827319 717757 715746 779042 783783 777801 779539 585329 809636 537294 530181 482844 542673 557862 684093 647183 ] |
||||||||||||||||||||||||||||||
|
3.56 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 413898 417068 455423 456167 476582 480256 482844 530181 531587 537294 539228 542673 546434 546872 548512 550687 552363 557862 561041 570701 571947 575579 584840 585329 591721 594495 595730 601945 602575 603032 603828 605437 616525 617072 623398 629265 630238 632755 638106 647183 652665 654891 661924 670066 673504 684093 693843 694945 712541 715746 717757 741832 747527 760512 761301 763148 763168 763655 764544 764610 765987 768106 769656 775199 777616 777801 777946 778015 778222 778671 779042 779539 780509 780599 781284 781561 782608 783066 783298 783521 783783 785049 785988 786714 787658 787765 788350 789147 789901 790175 790184 791031 791274 791449 791695 791749 792827 793351 793433 795154 796357 798301 798724 799901 803701 809614 809636 811596 818013 821830 823650 824081 825144 825588 827319 828777 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur blowjob pov"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск минет оральн секс пов"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.