Query Metrics
7
Database Queries
7
Different statements
155.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.20 ms (85.56%) |
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 88286 88591 154463 311897 340635 352189 387480 389794 398230 400948 402105 409060 411260 416704 419640 428235 428874 429601 444743 451687 454909 460765 462848 468766 470405 470428 493838 494540 494781 502205 502894 506115 511302 516619 516676 517873 525822 526905 528104 528929 530050 530698 530790 530953 531134 531869 531888 532483 532634 534777 535707 536503 536550 536620 541103 545454 547028 547235 560180 562004 563267 563728 565111 571826 573462 574375 580069 581348 582794 586572 591427 592673 600476 608076 610716 618565 619123 622459 623934 624276 627076 628097 629281 631203 638885 639335 644876 650177 650845 651693 660417 663263 670356 671008 671356 679761 693185 709729 718701 719573 720186 732293 735906 739125 741878 749909 752676 756025 764321 774699 781826 787510 788315 790231 790696 799542 802337 810839 811051 814975 ] |
||||||||||||||||||||||||||||||
|
13.38 ms (8.59%) |
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 429601 644876 451687 462848 494540 525822 531888 532634 530698 502205 506115 531869 547028 574375 565111 573462 660417 670356 671008 720186 663263 718701 580069 608076 627076 628097 624276 799542 787510 732293 749909 622459 629281 719573 428874 352189 389794 416704 470405 493838 536550 581348 402105 814975 545454 650845 788315 311897 154463 398230 531134 536620 530790 563728 679761 709729 592673 639335 802337 756025 88591 387480 409060 428235 470428 511302 516619 528104 534777 530050 494781 516676 526905 530953 532483 541103 547235 571826 693185 651693 563267 582794 618565 619123 600476 623934 586572 591427 774699 781826 790696 752676 811051 739125 735906 638885 340635 419640 528929 502894 444743 454909 535707 468766 560180 650177 610716 631203 741878 764321 400948 411260 460765 536503 517873 671356 562004 790231 810839 88286 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.65%) |
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 88286 88591 154463 311897 340635 352189 387480 389794 398230 400948 402105 409060 411260 416704 419640 428235 428874 429601 444743 451687 454909 460765 462848 468766 470405 470428 493838 494540 494781 502205 502894 506115 511302 516619 516676 517873 525822 526905 528104 528929 530050 530698 530790 530953 531134 531869 531888 532483 532634 534777 535707 536503 536550 536620 541103 545454 547028 547235 560180 562004 563267 563728 565111 571826 573462 574375 580069 581348 582794 586572 591427 592673 600476 608076 610716 618565 619123 622459 623934 624276 627076 628097 629281 631203 638885 639335 644876 650177 650845 651693 660417 663263 670356 671008 671356 679761 693185 709729 718701 719573 720186 732293 735906 739125 741878 749909 752676 756025 764321 774699 781826 787510 788315 790231 790696 799542 802337 810839 811051 814975 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"huge fuck"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные секс"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.34 ms (0.86%) |
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.