Query Metrics
7
Database Queries
7
Different statements
159.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.36 ms (85.32%) |
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 298730 395457 436632 437800 448774 451282 453917 461075 464225 487640 496093 502193 506487 517483 521379 529802 539078 544047 551485 551587 551606 553849 556717 557787 564286 564873 567905 570853 573290 576512 583652 592682 593281 619700 620750 620938 624378 624688 625916 626213 627754 636050 648171 648623 648625 654133 662415 664487 666172 668774 671561 677918 682857 682865 692026 694661 695817 706215 707674 708533 710173 711327 712157 714590 717137 718587 719106 719557 720137 720261 722144 723425 723819 724011 728253 728552 731001 740582 744791 747796 749437 751446 755374 763749 765386 765408 765947 766346 768109 769191 769616 772276 773867 777421 778959 780260 780577 781285 782874 783838 784356 786684 790746 790938 791755 791873 796414 797709 797719 797929 798507 798619 802073 804836 810384 812760 813256 817264 818062 ] |
||||||||||||||||||||||||||||||
|
13.82 ms (8.65%) |
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 556717 664487 666172 648625 668774 695817 707674 567905 636050 593281 592682 619700 626213 797929 620750 798619 451282 564286 671561 810384 722144 694661 298730 724011 718587 723425 583652 723819 749437 781285 744791 747796 751446 765408 728253 755374 802073 461075 539078 437800 817264 551587 570853 654133 720137 620938 782874 786684 791873 766346 791755 796414 765386 772276 717137 780260 780577 436632 395457 573290 624967 487640 551485 544047 682865 710173 711327 648171 662415 706215 712157 720261 648623 682857 624688 627754 624378 731001 708533 502193 521379 464225 564873 783838 517483 551606 553849 719557 677918 625916 790938 777421 804836 812760 763749 769191 768109 728552 740582 765947 769616 773867 719106 778959 790746 797719 813256 557787 692026 818062 448774 506487 496093 576512 798507 714590 784356 797709 453917 529802 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.77%) |
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 298730 395457 436632 437800 448774 451282 453917 461075 464225 487640 496093 502193 506487 517483 521379 529802 539078 544047 551485 551587 551606 553849 556717 557787 564286 564873 567905 570853 573290 576512 583652 592682 593281 619700 620750 620938 624378 624688 625916 626213 627754 636050 648171 648623 648625 654133 662415 664487 666172 668774 671561 677918 682857 682865 692026 694661 695817 706215 707674 708533 710173 711327 712157 714590 717137 718587 719106 719557 720137 720261 722144 723425 723819 724011 728253 728552 731001 740582 744791 747796 749437 751446 755374 763749 765386 765408 765947 766346 768109 769191 769616 772276 773867 777421 778959 780260 780577 781285 782874 783838 784356 786684 790746 790938 791755 791873 796414 797709 797719 797929 798507 798619 802073 804836 810384 812760 813256 817264 818062 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade sensual"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск sensual"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск sensual"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.88%) |
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.