Query Metrics
7
Database Queries
7
Different statements
201.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
176.89 ms (87.77%) |
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 6965 249773 358453 365992 373859 381885 384338 392525 395985 396080 396113 396211 396619 397193 402024 410299 439868 446160 451727 457451 461090 474588 475965 476120 478463 489522 490093 516336 518472 519551 530018 530319 530661 531208 536712 538805 539030 540334 540608 541718 546310 548994 554868 565552 568500 572020 590842 593223 596871 597251 598360 602866 604199 619042 620488 626316 626880 629172 639555 642335 657230 658630 659394 665511 668372 675762 680202 684312 686581 693325 694582 707164 715806 720641 722891 724722 725640 727905 729826 731990 734922 736356 742234 742458 742713 748340 752611 752987 753470 757038 758970 759796 766797 766799 769101 769811 777120 778875 778970 781366 782087 788553 789193 790239 791190 791663 800798 811863 813553 817451 820565 820839 825930 825933 826024 826299 826674 827324 827359 828483 ] |
||||||||||||||||||||||||||||||
|
14.86 ms (7.37%) |
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 629172 778875 396113 791663 734922 826299 827324 791190 439868 817451 451727 540334 680202 659394 693325 597251 788553 731990 729826 725640 722891 790239 811863 778970 531208 530018 540608 684312 446160 476120 518472 626316 742713 396619 538805 568500 657230 665511 686581 720641 694582 715806 707164 546310 604199 619042 620488 602866 642335 590842 598360 626880 639555 789193 800798 781366 782087 766799 736356 759796 769101 727905 748340 752611 757038 596871 554868 536712 373859 381885 396080 826674 827359 828483 752987 742458 766797 365992 396211 461090 478463 519551 475965 490093 489522 516336 826024 825933 675762 724722 742234 530661 397193 825930 530319 668372 658630 758970 777120 457451 474588 769811 6965 384338 392525 813553 593223 753470 249773 395985 358453 402024 410299 820839 820565 539030 541718 548994 565552 572020 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.33%) |
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 6965 249773 358453 365992 373859 381885 384338 392525 395985 396080 396113 396211 396619 397193 402024 410299 439868 446160 451727 457451 461090 474588 475965 476120 478463 489522 490093 516336 518472 519551 530018 530319 530661 531208 536712 538805 539030 540334 540608 541718 546310 548994 554868 565552 568500 572020 590842 593223 596871 597251 598360 602866 604199 619042 620488 626316 626880 629172 639555 642335 657230 658630 659394 665511 668372 675762 680202 684312 686581 693325 694582 707164 715806 720641 722891 724722 725640 727905 729826 731990 734922 736356 742234 742458 742713 748340 752611 752987 753470 757038 758970 759796 766797 766799 769101 769811 777120 778875 778970 781366 782087 788553 789193 790239 791190 791663 800798 811863 813553 817451 820565 820839 825930 825933 826024 826299 826674 827324 827359 828483 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в жопу худых"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал худые"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.77%) |
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.