Query Metrics
7
Database Queries
7
Different statements
180.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.25 ms (87.66%) |
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 574065 588067 588279 595695 595997 599646 601469 602495 603196 605001 615492 622969 626821 626825 629518 635182 637929 639217 653517 655058 655371 656011 657289 657337 658380 659830 660104 663356 663907 665504 666019 668126 674616 674635 677513 680405 687525 688121 689371 692070 693553 698930 707552 716601 716604 716763 720044 724743 725377 726215 726308 726350 729729 733108 733720 735559 741090 745557 747288 749185 750028 751713 755264 755433 755595 759174 763198 763299 763325 763642 766543 768803 771351 771871 772823 774005 774623 774713 776887 777508 778911 779819 779850 779935 779977 780853 781242 782509 782600 782787 783440 786070 786397 789334 789339 789907 790117 790349 790947 792079 793351 793354 793433 795637 796015 796854 797548 799388 800183 802989 803674 804775 804818 805306 806257 806846 807811 811811 812431 812514 ] |
||||||||||||||||||||||||||||||
|
11.60 ms (6.43%) |
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 658380 659830 660104 663356 666019 674616 674635 680405 692070 693553 698930 707552 716604 716763 653517 655058 655371 656011 657289 657337 663907 665504 668126 677513 687525 688121 689371 720044 574065 601469 602495 615492 629518 588279 599646 622969 588067 603196 635182 637929 639217 595997 626821 626825 774713 776887 777508 782509 790349 793354 793433 796854 804775 806846 812431 779850 781242 783440 786070 790947 792079 793351 796015 797548 799388 811811 725377 755595 763198 763299 763642 782600 782787 786397 789334 789339 789907 790117 803674 807811 724743 729729 733108 733720 766543 726308 745557 755264 771351 774005 726215 726350 735559 747288 749185 751713 768803 771871 741090 750028 755433 759174 763325 772823 605001 774623 778911 779819 779935 779977 795637 800183 802989 804818 805306 806257 812514 716601 595695 780853 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (1.64%) |
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 574065 588067 588279 595695 595997 599646 601469 602495 603196 605001 615492 622969 626821 626825 629518 635182 637929 639217 653517 655058 655371 656011 657289 657337 658380 659830 660104 663356 663907 665504 666019 668126 674616 674635 677513 680405 687525 688121 689371 692070 693553 698930 707552 716601 716604 716763 720044 724743 725377 726215 726308 726350 729729 733108 733720 735559 741090 745557 747288 749185 750028 751713 755264 755433 755595 759174 763198 763299 763325 763642 766543 768803 771351 771871 772823 774005 774623 774713 776887 777508 778911 779819 779850 779935 779977 780853 781242 782509 782600 782787 783440 786070 786397 789334 789339 789907 790117 790349 790947 792079 793351 793354 793433 795637 796015 796854 797548 799388 800183 802989 803674 804775 804818 805306 806257 806846 807811 811811 812431 812514 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"deepthroat blow job"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"глубокийминет минет оральн секс минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.99%) |
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.