Query Metrics
7
Database Queries
7
Different statements
133.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
113.15 ms (84.75%) |
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 394224 395833 399209 399456 401559 403556 405107 406072 426427 430713 432122 446089 448060 448068 452488 465128 467387 474842 493188 511889 512088 515161 515215 519967 527002 530511 530516 531430 531462 536387 540912 542942 545959 550094 559128 560583 565826 569659 575514 576380 591726 601657 611922 612083 617363 619417 620302 621578 621664 622682 624664 625826 627803 632025 632042 650432 651165 659605 660150 663226 664801 665475 667316 669193 671396 674740 678802 681879 682071 682152 682514 683541 683598 684060 684949 685686 686082 688577 694422 698451 699056 704547 710001 712712 712905 712907 713527 714478 714780 716236 716326 716450 718264 719144 727526 732029 732466 733181 743371 745203 776468 781912 784925 788134 792812 800074 802397 804373 807698 807772 815988 817902 819596 820420 821610 822042 822228 823075 823180 824996 ] |
||||||||||||||||||||||||||||||
|
11.36 ms (8.51%) |
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 540912 403556 426427 824996 446089 515215 511889 530516 719144 684060 686082 632042 591726 620302 807772 727526 732029 401559 448060 448068 536387 512088 399209 678802 659605 714478 612083 611922 432122 804373 624664 627803 395833 405107 467387 632025 465128 575514 569659 576380 683598 560583 622682 621664 674740 743371 792812 625826 394224 399456 406072 430713 817902 819596 820420 821610 823075 823180 815988 822042 822228 452488 474842 493188 530511 515161 519967 527002 531462 531430 542942 550094 559128 565826 663226 664801 665475 669193 682514 683541 688577 698451 712712 713527 714780 716450 718264 651165 660150 667316 671396 682071 682152 685686 694422 699056 710001 712905 716236 716326 650432 681879 684949 704547 712907 545959 617363 621578 601657 619417 776468 802397 781912 788134 732466 733181 745203 784925 800074 807698 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.51%) |
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 394224 395833 399209 399456 401559 403556 405107 406072 426427 430713 432122 446089 448060 448068 452488 465128 467387 474842 493188 511889 512088 515161 515215 519967 527002 530511 530516 531430 531462 536387 540912 542942 545959 550094 559128 560583 565826 569659 575514 576380 591726 601657 611922 612083 617363 619417 620302 621578 621664 622682 624664 625826 627803 632025 632042 650432 651165 659605 660150 663226 664801 665475 667316 669193 671396 674740 678802 681879 682071 682152 682514 683541 683598 684060 684949 685686 686082 688577 694422 698451 699056 704547 710001 712712 712905 712907 713527 714478 714780 716236 716326 716450 718264 719144 727526 732029 732466 733181 743371 745203 776468 781912 784925 788134 792812 800074 802397 804373 807698 807772 815988 817902 819596 820420 821610 822042 822228 823075 823180 824996 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass young girl"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп young девушк"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп young девушк"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.19%) |
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.