Query Metrics
7
Database Queries
7
Different statements
192.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.17 ms (86.72%) |
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 393845 396790 397535 417888 423698 427273 428794 429161 434724 438967 439218 443988 445498 447298 447423 447650 451727 452898 459228 460769 461437 461938 462787 463906 463948 464610 466184 472339 476075 476776 484355 485305 487737 490833 492613 494374 505021 507649 510645 510676 512272 512645 512902 518997 520969 523891 524514 524793 526734 531780 533767 537891 538773 539126 540601 545711 548697 548709 552685 554356 559961 560631 560648 561657 561702 561819 562326 565951 565956 566635 568357 568442 569988 573767 573777 573793 574540 574780 574800 574817 575058 575082 575764 576119 576301 578382 584558 584706 589103 590989 594328 595458 597073 597469 597969 598084 598447 598553 598753 598822 600118 600143 605322 605328 609884 613129 618927 624184 630234 634159 647311 659394 668936 694415 696226 718647 722891 725108 741187 790239 ] |
||||||||||||||||||||||||||||||
|
16.86 ms (8.74%) |
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 523891 490833 510645 512272 512645 485305 539126 540601 487737 428794 618927 452898 538773 548709 566635 594328 423698 427273 429161 476776 438967 461938 466184 507649 396790 447423 533767 576301 524793 445498 463948 492613 476075 451727 512902 531780 552685 559961 574817 565951 573767 573793 545711 561657 562326 568442 573777 574540 574800 696226 647311 659394 668936 694415 718647 548697 560631 561702 565956 584558 584706 597073 624184 634159 589103 598084 598553 600143 600118 609884 597969 605322 605328 630234 725108 741187 722891 790239 459228 460769 393845 397535 447650 443988 462787 439218 510676 526734 518997 505021 524514 520969 613129 434724 484355 537891 574780 561819 568357 575082 578382 554356 569988 575764 560648 575058 576119 598447 598822 595458 597469 598753 590989 463906 461437 464610 472339 417888 447298 494374 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.29%) |
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 393845 396790 397535 417888 423698 427273 428794 429161 434724 438967 439218 443988 445498 447298 447423 447650 451727 452898 459228 460769 461437 461938 462787 463906 463948 464610 466184 472339 476075 476776 484355 485305 487737 490833 492613 494374 505021 507649 510645 510676 512272 512645 512902 518997 520969 523891 524514 524793 526734 531780 533767 537891 538773 539126 540601 545711 548697 548709 552685 554356 559961 560631 560648 561657 561702 561819 562326 565951 565956 566635 568357 568442 569988 573767 573777 573793 574540 574780 574800 574817 575058 575082 575764 576119 576301 578382 584558 584706 589103 590989 594328 595458 597073 597469 597969 598084 598447 598553 598753 598822 600118 600143 605322 605328 609884 613129 618927 624184 630234 634159 647311 659394 668936 694415 696226 718647 722891 725108 741187 790239 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая teen сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful teen tits"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая teen сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.68%) |
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.