Query Metrics
7
Database Queries
7
Different statements
148.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.90 ms (80.88%) |
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 11377 107060 159380 384445 394391 400311 401660 402164 403678 404087 406799 412432 417907 419062 421235 432601 435872 444474 446093 451389 466437 472888 472957 477190 480721 482115 484158 486726 489863 490479 496514 514917 523282 523434 525466 536702 537045 538172 539262 539881 540459 540730 550410 551728 557747 558264 559334 562243 563482 563685 588082 589402 592490 598310 600512 602967 608606 611116 621872 641516 644734 648527 648659 649107 665717 677726 679512 681756 690461 691600 695158 698575 701479 702176 704211 708131 710333 718965 724433 725183 736185 739042 739081 742131 747410 752587 753610 756197 756671 757286 759029 759696 759829 764107 773296 774632 778086 778761 781343 784581 785490 787880 788908 789489 789592 789926 790236 791525 795054 795570 797045 797229 800902 802947 803810 805776 811075 811319 813500 813566 ] |
||||||||||||||||||||||||||||||
|
16.63 ms (11.22%) |
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 756671 558264 551728 641516 800902 742131 400311 677726 419062 444474 539881 472888 704211 592490 789592 784581 795054 811319 725183 791525 803810 724433 759696 797045 402164 401660 446093 536702 486726 797229 778086 759829 773296 417907 490479 785490 107060 602967 482115 588082 813500 753610 774632 789489 159380 484158 538172 802947 480721 406799 489863 523282 523434 540730 550410 648659 679512 649107 681756 691600 710333 690461 702176 644734 778761 795570 781343 790236 759029 739081 757286 736185 756197 764107 611116 621872 562243 563482 557747 752587 403678 412432 435872 432601 451389 496514 466437 404087 477190 665717 598310 788908 813566 514917 695158 600512 472957 11377 525466 559334 563685 718965 701479 708131 805776 747410 540459 539262 608606 811075 421235 537045 648527 698575 589402 739042 789926 787880 384445 394391 ] |
||||||||||||||||||||||||||||||
|
4.28 ms (2.88%) |
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 11377 107060 159380 384445 394391 400311 401660 402164 403678 404087 406799 412432 417907 419062 421235 432601 435872 444474 446093 451389 466437 472888 472957 477190 480721 482115 484158 486726 489863 490479 496514 514917 523282 523434 525466 536702 537045 538172 539262 539881 540459 540730 550410 551728 557747 558264 559334 562243 563482 563685 588082 589402 592490 598310 600512 602967 608606 611116 621872 641516 644734 648527 648659 649107 665717 677726 679512 681756 690461 691600 695158 698575 701479 702176 704211 708131 710333 718965 724433 725183 736185 739042 739081 742131 747410 752587 753610 756197 756671 757286 759029 759696 759829 764107 773296 774632 778086 778761 781343 784581 785490 787880 788908 789489 789592 789926 790236 791525 795054 795570 797045 797229 800902 802947 803810 805776 811075 811319 813500 813566 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass beautiful"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие жоп красивая"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.