Query Metrics
7
Database Queries
7
Different statements
238.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.69 ms (88.16%) |
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 31503 32999 85250 152882 187775 187973 188118 188437 189743 325648 358437 366010 382134 387377 388776 391287 391703 396287 397896 398933 400858 406062 406070 406593 408245 409312 411352 411468 411708 411766 439574 439662 439722 439724 439778 439791 439821 440868 444255 448996 451498 451499 460015 462607 465953 466088 466218 466247 470158 470446 472608 472891 474095 474648 474810 478378 479049 484730 484735 484763 486341 486350 490783 510879 522508 523842 525133 536433 538006 543535 544190 547422 549846 557244 571144 591977 623493 627361 650388 665264 683052 696308 707316 710560 714909 715786 721004 721983 723984 727737 727800 727863 728348 728406 728452 730370 733319 735032 738000 740791 741764 742704 742722 745517 772472 781648 790009 790813 796164 799360 800370 802138 802142 805813 816609 823686 824075 825114 826046 827147 ] |
||||||||||||||||||||||||||||||
|
16.87 ms (7.06%) |
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 439662 439724 439722 439791 439821 466247 31503 816609 714909 728348 745517 411766 543535 727800 366010 188118 536433 444255 790009 484730 479049 557244 591977 451498 538006 544190 683052 772472 187973 486350 188437 382134 406593 408245 825114 472608 484763 474810 387377 448996 440868 32999 409312 710560 696308 715786 627361 478378 522508 325648 826046 547422 85250 827147 451499 805813 790813 735032 665264 490783 465953 466218 411468 439778 472891 510879 398933 824075 727863 721004 802142 740791 152882 187775 802138 474095 439574 486341 396287 411708 462607 571144 721983 400858 391703 397896 523842 474648 358437 707316 796164 742722 823686 406070 727737 470446 800370 728406 730370 738000 388776 466088 484735 525133 728452 189743 650388 723984 742704 623493 781648 460015 391287 406062 549846 733319 741764 799360 411352 470158 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.18%) |
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 31503 32999 85250 152882 187775 187973 188118 188437 189743 325648 358437 366010 382134 387377 388776 391287 391703 396287 397896 398933 400858 406062 406070 406593 408245 409312 411352 411468 411708 411766 439574 439662 439722 439724 439778 439791 439821 440868 444255 448996 451498 451499 460015 462607 465953 466088 466218 466247 470158 470446 472608 472891 474095 474648 474810 478378 479049 484730 484735 484763 486341 486350 490783 510879 522508 523842 525133 536433 538006 543535 544190 547422 549846 557244 571144 591977 623493 627361 650388 665264 683052 696308 707316 710560 714909 715786 721004 721983 723984 727737 727800 727863 728348 728406 728452 730370 733319 735032 738000 740791 741764 742704 742722 745517 772472 781648 790009 790813 796164 799360 800370 802138 802142 805813 816609 823686 824075 825114 826046 827147 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature анал секс"
]
|
||||||||||||||||||||||||||||||
|
2.30 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature anal fuck"
]
|
||||||||||||||||||||||||||||||
|
2.17 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature анал секс"
]
|
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.