Query Metrics
7
Database Queries
7
Different statements
183.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.75 ms (85.26%) |
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 11160 318318 321285 385342 395533 397019 398882 402991 406071 413947 414708 417495 424937 428856 432631 434786 438200 438532 445135 445566 445939 447806 450992 451638 453232 454040 454057 456694 457898 458370 459065 460159 460318 463367 463557 465119 469486 473868 478148 479656 485284 486617 502368 507472 511229 512899 516002 516642 521699 521716 522032 524337 524820 527171 528569 530328 531964 537022 543199 543238 546126 546472 547903 548843 550494 554326 559704 560079 560932 561276 562461 565009 565242 566070 570175 589507 591820 594463 600958 606268 614142 614535 641212 644192 662042 664504 695179 703949 720616 726582 745415 748336 761134 774687 774688 777420 778427 779684 781823 784198 785559 789491 800228 800344 800488 800990 803706 805184 808450 808683 812735 817957 818201 818486 820560 821691 822008 823143 824745 825373 ] |
||||||||||||||||||||||||||||||
|
16.17 ms (8.80%) |
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 507472 460159 463557 479656 565009 543238 547903 695179 591820 777420 745415 785559 438200 454057 457898 450992 478148 516002 522032 486617 761134 11160 445135 485284 823143 398882 402991 561276 644192 589507 726582 521716 543199 554326 560932 562461 565242 546472 600958 808683 800990 808450 720616 559704 594463 434786 463367 432631 424937 465119 458370 453232 459065 528569 560079 570175 662042 546126 550494 641212 779684 800344 774687 778427 781823 800488 784198 805184 774688 789491 800228 812735 417495 406071 438532 321285 428856 414708 824745 460318 451638 511229 521699 530328 537022 703949 664504 606268 614142 614535 803706 748336 456694 445566 502368 385342 395533 318318 397019 413947 817957 818486 820560 822008 821691 818201 825373 445939 447806 454040 469486 473868 512899 516642 524820 531964 524337 527171 566070 548843 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (1.74%) |
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 11160 318318 321285 385342 395533 397019 398882 402991 406071 413947 414708 417495 424937 428856 432631 434786 438200 438532 445135 445566 445939 447806 450992 451638 453232 454040 454057 456694 457898 458370 459065 460159 460318 463367 463557 465119 469486 473868 478148 479656 485284 486617 502368 507472 511229 512899 516002 516642 521699 521716 522032 524337 524820 527171 528569 530328 531964 537022 543199 543238 546126 546472 547903 548843 550494 554326 559704 560079 560932 561276 562461 565009 565242 566070 570175 589507 591820 594463 600958 606268 614142 614535 641212 644192 662042 664504 695179 703949 720616 726582 745415 748336 761134 774687 774688 777420 778427 779684 781823 784198 785559 789491 800228 800344 800488 800990 803706 805184 808450 808683 812735 817957 818201 818486 820560 821691 822008 823143 824745 825373 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass horny"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп horny"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие жоп horny"
]
|
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.