Query Metrics
7
Database Queries
7
Different statements
150.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.64 ms (84.98%) |
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 74842 100075 250587 263868 269974 349193 382501 383797 384282 384551 384892 385222 385754 387115 387265 391302 391545 392825 393458 395189 395320 395717 395755 395794 395809 396093 396361 396772 397101 397474 397635 398742 400417 400930 402980 405805 407130 410265 412326 412432 413663 416882 416883 417100 418797 419248 419940 420624 422207 423899 425541 425547 426091 429015 429738 434070 435130 435289 436952 437255 442447 446042 447013 447753 447757 447966 448089 451511 453766 453902 454497 455096 456186 459676 460159 473068 474389 475005 475054 479350 488929 489668 490221 492813 494543 496115 498178 502636 508981 515217 516724 521050 521494 525400 547259 551160 553102 559443 564463 567203 572489 572645 578825 579192 584689 601164 668451 701132 701805 703293 705799 705985 726555 730115 748404 753783 761112 766484 799783 826542 ] |
||||||||||||||||||||||||||||||
|
12.60 ms (8.39%) |
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 502636 479350 460159 730115 584689 392825 349193 384892 405805 423899 748404 250587 456186 705985 703293 385754 429015 420624 701132 437255 459676 397101 387265 382501 395189 416883 508981 407130 416882 395755 397474 384551 413663 525400 426091 753783 400930 396361 384282 396772 402980 269974 74842 425547 447013 496115 263868 567203 397635 490221 383797 799783 435289 446042 442447 601164 396093 572645 447757 489668 826542 515217 391302 395717 578825 434070 492813 454497 475054 398742 395794 418797 553102 436952 385222 412326 453902 417100 447753 447966 435130 564463 516724 453766 412432 498178 400417 559443 761112 429738 474389 579192 726555 391545 488929 451511 448089 395809 419940 395320 393458 455096 419248 521494 100075 387115 766484 473068 422207 494543 475005 705799 521050 547259 701805 572489 551160 668451 410265 425541 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.95%) |
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 74842 100075 250587 263868 269974 349193 382501 383797 384282 384551 384892 385222 385754 387115 387265 391302 391545 392825 393458 395189 395320 395717 395755 395794 395809 396093 396361 396772 397101 397474 397635 398742 400417 400930 402980 405805 407130 410265 412326 412432 413663 416882 416883 417100 418797 419248 419940 420624 422207 423899 425541 425547 426091 429015 429738 434070 435130 435289 436952 437255 442447 446042 447013 447753 447757 447966 448089 451511 453766 453902 454497 455096 456186 459676 460159 473068 474389 475005 475054 479350 488929 489668 490221 492813 494543 496115 498178 502636 508981 515217 516724 521050 521494 525400 547259 551160 553102 559443 564463 567203 572489 572645 578825 579192 584689 601164 668451 701132 701805 703293 705799 705985 726555 730115 748404 753783 761112 766484 799783 826542 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sleeping girl fuck"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"спящ девушк секс"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (1.07%) |
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.