Query Metrics
7
Database Queries
7
Different statements
156.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.18 ms (85.21%) |
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 207775 385181 395263 397190 398674 400396 407940 417921 423646 423811 424284 428835 434688 435732 437809 441804 442164 447234 447792 458072 459055 466041 467355 470415 476637 481121 499169 501105 506978 508035 518383 524787 530831 556716 559727 564652 567738 587747 593171 594617 594632 601588 601970 602768 624684 624961 627335 627656 631116 634950 635123 635172 639092 645391 663160 675160 675180 675628 692651 693398 699892 706754 714527 714756 717615 722877 725122 728667 733176 734445 739460 751322 753457 754180 754986 758545 758816 763946 765365 766519 767020 768983 769043 772404 772523 773463 776189 779688 779721 781591 783146 783584 783943 784356 784970 785447 787312 787442 787579 787605 787611 790498 791263 793237 793589 793700 798618 799446 800953 804053 805235 807464 809462 810972 811042 814090 814974 818552 823361 ] |
||||||||||||||||||||||||||||||
|
13.68 ms (8.75%) |
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 787611 624684 424284 814090 567738 559727 624961 783584 768983 810972 442164 466041 524787 675180 675628 627656 799446 776189 754180 772404 772523 787312 787605 763946 766519 706754 784356 787579 423811 693398 594617 602768 627335 395263 407940 818552 506978 530831 634950 779688 793237 805235 773463 437809 499169 645391 699892 556716 631116 639092 594632 779721 791263 800953 728667 793700 733176 734445 754986 769043 751322 728648 428835 481121 675160 783943 722877 459055 435732 717615 798618 765365 787442 207775 385181 823361 714756 663160 793589 753457 804053 807464 809462 400396 447234 398674 423646 447792 635123 601588 601970 781591 790498 783146 739460 714527 785447 811042 417921 508035 434688 564652 587747 635172 397190 441804 467355 518383 692651 593171 784970 725122 758816 767020 758545 476637 458072 501105 814974 470415 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.62%) |
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 207775 385181 395263 397190 398674 400396 407940 417921 423646 423811 424284 428835 434688 435732 437809 441804 442164 447234 447792 458072 459055 466041 467355 470415 476637 481121 499169 501105 506978 508035 518383 524787 530831 556716 559727 564652 567738 587747 593171 594617 594632 601588 601970 602768 624684 624961 627335 627656 631116 634950 635123 635172 639092 645391 663160 675160 675180 675628 692651 693398 699892 706754 714527 714756 717615 722877 725122 728667 733176 734445 739460 751322 753457 754180 754986 758545 758816 763946 765365 766519 767020 768983 769043 772404 772523 773463 776189 779688 779721 781591 783146 783584 783943 784356 784970 785447 787312 787442 787579 787605 787611 790498 791263 793237 793589 793700 798618 799446 800953 804053 805235 807464 809462 810972 811042 814090 814974 818552 823361 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex passionate"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс passionate"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс passionate"
]
|
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.