Query Metrics
7
Database Queries
7
Different statements
189.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.72 ms (85.34%) |
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 382791 391756 401205 401768 416537 420193 423927 424593 428223 432274 440016 440032 440041 440052 441124 442172 442971 446045 446778 446797 447985 456229 457474 462495 462580 469120 471330 471696 475226 475646 478510 481935 482813 490625 493490 493749 495749 496125 497480 497667 505597 505599 505613 506321 508882 508895 508939 512941 514233 514240 514257 514744 515053 515488 523614 527920 529988 541278 541322 541755 543897 547481 547494 547811 547846 547854 550926 556338 556883 559789 561021 561038 561273 573197 576494 580121 583347 584183 586557 590247 592576 618316 625785 627146 627470 634076 634739 634900 643100 643213 643224 656186 656921 660399 665588 665957 668645 669067 671044 679577 680816 689074 695870 704352 705414 710211 713184 738814 741247 745168 747099 752626 761176 788926 794292 797197 797280 801610 825649 827326 ] |
||||||||||||||||||||||||||||||
|
16.98 ms (8.96%) |
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 584183 634076 797197 761176 442971 523614 505599 514240 508882 432274 428223 446778 493490 475226 475646 481935 478510 515488 527920 514233 462495 580121 668645 671044 695870 669067 689074 556883 788926 469120 456229 471330 496125 497480 643213 665588 680816 541755 747099 794292 447985 490625 462580 713184 559789 576494 586557 505597 745168 704352 440032 440052 440016 457474 541278 547481 556338 547494 561038 561273 573197 660399 643100 752626 741247 420193 482813 495749 543897 550926 547854 656186 656921 710211 592576 618316 797280 446045 401205 679577 512941 825649 634739 634900 643224 627470 625785 627146 382791 401768 827326 541322 529988 391756 423927 416537 441124 424593 471696 493749 506321 508939 514257 547846 583347 547811 590247 442172 505613 446797 515053 514744 508895 665957 561021 738814 801610 440041 497667 705414 ] |
||||||||||||||||||||||||||||||
|
3.57 ms (1.88%) |
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 382791 391756 401205 401768 416537 420193 423927 424593 428223 432274 440016 440032 440041 440052 441124 442172 442971 446045 446778 446797 447985 456229 457474 462495 462580 469120 471330 471696 475226 475646 478510 481935 482813 490625 493490 493749 495749 496125 497480 497667 505597 505599 505613 506321 508882 508895 508939 512941 514233 514240 514257 514744 515053 515488 523614 527920 529988 541278 541322 541755 543897 547481 547494 547811 547846 547854 550926 556338 556883 559789 561021 561038 561273 573197 576494 580121 583347 584183 586557 590247 592576 618316 625785 627146 627470 634076 634739 634900 643100 643213 643224 656186 656921 660399 665588 665957 668645 669067 671044 679577 680816 689074 695870 704352 705414 710211 713184 738814 741247 745168 747099 752626 761176 788926 794292 797197 797280 801610 825649 827326 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fisting homemade"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фистинг домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"фистинг домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.90%) |
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.