Query Metrics
7
Database Queries
7
Different statements
168.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.70 ms (86.84%) |
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 6696 6715 6741 7615 11051 13543 13646 16897 54378 91458 91541 96521 97571 114153 117388 118086 130054 146800 150336 239808 249788 282652 307633 346188 357442 373724 381966 383880 385112 386673 386771 386793 388169 388772 388857 388862 391267 393693 395929 396106 396192 399378 400957 401287 401628 402438 402859 403151 404276 404554 408502 410623 413165 416242 416707 417701 417716 431911 444853 447137 447912 454304 456103 457518 459740 461713 463943 466104 466614 468587 472773 474596 474670 484279 492112 536236 549550 557328 561649 568524 574089 579011 598788 605791 614244 652927 653533 654359 656562 665511 668100 686091 690326 692502 693209 693536 698840 713014 716998 718366 720967 721322 728675 742234 742458 747582 754220 758482 763519 766604 770287 777053 778886 782544 783197 791521 793228 793319 800421 809757 ] |
||||||||||||||||||||||||||||||
|
13.25 ms (7.84%) |
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 693209 417701 386793 391267 91541 118086 16897 447912 401287 386673 146800 13646 54378 150336 386771 713014 6715 605791 388772 568524 402859 396106 393693 404276 492112 778886 381966 383880 763519 403151 466614 388169 457518 239808 282652 454304 249788 716998 698840 346188 574089 114153 91458 474596 579011 396192 656562 791521 728675 400957 6696 447137 686091 461713 459740 809757 549550 401628 307633 747582 766604 463943 11051 413165 117388 720967 557328 654359 742234 96521 444853 410623 416707 484279 385112 404554 665511 754220 652927 742458 130054 7615 357442 388862 13543 468587 417716 474670 408502 416242 472773 456103 598788 6741 388857 770287 690326 692502 693536 782544 793319 777053 793228 402438 653533 758482 561649 395929 668100 783197 97571 399378 431911 466104 614244 536236 718366 373724 721322 800421 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.50%) |
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 6696 6715 6741 7615 11051 13543 13646 16897 54378 91458 91541 96521 97571 114153 117388 118086 130054 146800 150336 239808 249788 282652 307633 346188 357442 373724 381966 383880 385112 386673 386771 386793 388169 388772 388857 388862 391267 393693 395929 396106 396192 399378 400957 401287 401628 402438 402859 403151 404276 404554 408502 410623 413165 416242 416707 417701 417716 431911 444853 447137 447912 454304 456103 457518 459740 461713 463943 466104 466614 468587 472773 474596 474670 484279 492112 536236 549550 557328 561649 568524 574089 579011 598788 605791 614244 652927 653533 654359 656562 665511 668100 686091 690326 692502 693209 693536 698840 713014 716998 718366 720967 721322 728675 742234 742458 747582 754220 758482 763519 766604 770287 777053 778886 782544 783197 791521 793228 793319 800421 809757 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blonde girl anal"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая девушк анал"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"беловолосая девушк анал"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.80%) |
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.