Query Metrics
7
Database Queries
7
Different statements
422.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
399.97 ms (94.78%) |
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 540077 540134 540574 541853 542431 542718 544812 547408 547412 547515 552606 552608 553749 554828 557965 559342 563591 571990 573191 574001 576559 577010 578718 585057 588472 597227 598267 598964 599911 602215 606066 613161 618422 619204 622115 627927 628368 629575 629606 630572 632256 632565 632639 632684 635775 637438 637442 640396 641667 645952 646084 646439 649356 651144 651147 651158 652799 659472 661654 664477 664492 668534 670448 670465 671801 671977 671986 676632 677671 677783 678052 678131 678761 678820 679280 679317 679757 679774 680116 680120 680121 680186 680189 680195 680253 683262 689547 702164 707974 708443 710452 720446 726271 738309 741691 744010 746102 757257 757504 758332 768153 768881 786525 788556 788612 789616 795728 796338 796818 800226 800913 809741 811466 812312 813802 814163 814172 814278 823943 827278 ] |
||||||||||||||||||||||||||||||
|
12.06 ms (2.86%) |
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 814163 540077 540134 542431 649356 670448 630572 622115 789616 800226 757257 618422 677783 823943 613161 726271 637438 577010 680120 680121 619204 547408 576559 652799 678820 678761 588472 627927 598267 606066 645952 708443 547412 651158 664477 646439 671801 640396 795728 678131 637442 661654 659472 671977 679280 689547 574001 796338 812312 744010 585057 557965 554828 571990 768153 768881 788612 541853 680195 680186 679774 552608 651144 677671 679317 679757 683262 563591 599911 632256 559342 646084 629606 598964 788556 796818 757504 758332 811466 602215 578718 632684 786525 547515 671986 746102 800913 738309 553749 809741 720446 814172 814278 542718 670465 680253 678052 632639 813802 552606 573191 707974 635775 629575 741691 540574 544812 702164 651147 597227 628368 641667 632565 668534 676632 680189 680116 710452 827278 664492 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (0.72%) |
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 540077 540134 540574 541853 542431 542718 544812 547408 547412 547515 552606 552608 553749 554828 557965 559342 563591 571990 573191 574001 576559 577010 578718 585057 588472 597227 598267 598964 599911 602215 606066 613161 618422 619204 622115 627927 628368 629575 629606 630572 632256 632565 632639 632684 635775 637438 637442 640396 641667 645952 646084 646439 649356 651144 651147 651158 652799 659472 661654 664477 664492 668534 670448 670465 671801 671977 671986 676632 677671 677783 678052 678131 678761 678820 679280 679317 679757 679774 680116 680120 680121 680186 680189 680195 680253 683262 689547 702164 707974 708443 710452 720446 726271 738309 741691 744010 746102 757257 757504 758332 768153 768881 786525 788556 788612 789616 795728 796338 796818 800226 800913 809741 811466 812312 813802 814163 814172 814278 823943 827278 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"писсинг сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"писсинг сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"piss on tits"
]
|
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.