Query Metrics
7
Database Queries
7
Different statements
176.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.12 ms (84.42%) |
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 101353 190876 197345 278236 282099 325910 373724 381742 382025 382371 382907 383635 386300 386965 387207 389511 390980 390994 392623 393050 393684 396617 397427 398486 400470 400956 401279 401588 401932 402147 407492 407561 407796 410663 414069 416647 423654 425661 443116 456117 461275 462337 462495 464120 465130 465174 465297 468800 470651 477587 478463 478779 492246 495736 497731 499743 505094 508561 508888 510820 512032 512346 514863 516551 519765 519971 523255 529311 530854 532906 536266 536909 537920 538513 544477 544835 544848 546315 564463 578233 584903 594415 623154 630511 633474 633512 634148 637026 637042 640801 641685 651168 673217 674110 678015 694116 708153 716828 719794 720614 724509 728730 735554 747776 749282 760507 761513 795194 809175 810914 817422 818377 824919 825120 827853 827872 827874 827877 827892 827899 ] |
||||||||||||||||||||||||||||||
|
16.58 ms (9.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 407492 425661 508561 495736 510820 536909 508888 470651 694116 809175 795194 810914 761513 465130 190876 392623 461275 282099 410663 499743 197345 325910 382371 389511 407796 818377 544848 674110 716828 673217 708153 719794 720614 623154 641685 749282 724509 728730 735554 747776 760507 401588 387207 456117 416647 383635 390994 401279 462337 478779 478463 532906 537920 519765 530854 536266 523255 651168 544835 634148 637026 637042 630511 640801 401932 397427 423654 516551 386300 382025 396617 400470 402147 414069 443116 817422 465174 492246 465297 468800 505094 497731 529311 538513 512032 519971 393050 278236 382907 407561 400956 393684 514863 544477 546315 477587 512346 462495 564463 584903 578233 678015 594415 633474 633512 390980 101353 373724 381742 386965 398486 824919 825120 827877 827872 827874 827853 827899 827892 464120 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (1.82%) |
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 101353 190876 197345 278236 282099 325910 373724 381742 382025 382371 382907 383635 386300 386965 387207 389511 390980 390994 392623 393050 393684 396617 397427 398486 400470 400956 401279 401588 401932 402147 407492 407561 407796 410663 414069 416647 423654 425661 443116 456117 461275 462337 462495 464120 465130 465174 465297 468800 470651 477587 478463 478779 492246 495736 497731 499743 505094 508561 508888 510820 512032 512346 514863 516551 519765 519971 523255 529311 530854 532906 536266 536909 537920 538513 544477 544835 544848 546315 564463 578233 584903 594415 623154 630511 633474 633512 634148 637026 637042 640801 641685 651168 673217 674110 678015 694116 708153 716828 719794 720614 724509 728730 735554 747776 749282 760507 761513 795194 809175 810914 817422 818377 824919 825120 827853 827872 827874 827877 827892 827899 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"extreme dick"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хардкор член"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"хардкор член"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.01%) |
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.