Query Metrics
7
Database Queries
7
Different statements
208.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
182.65 ms (87.71%) |
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 183552 186294 203995 366053 382512 386027 391499 393581 395172 395788 401960 411776 417419 417621 419273 420012 428220 428366 431078 432380 434854 449511 452879 453980 454045 458042 461709 463691 465896 472812 485089 489014 490792 492651 492973 494866 503472 507248 513067 513202 516626 521387 521400 529770 530144 532312 532319 532451 536439 537780 538069 542467 552042 552716 554648 555663 555835 559210 559257 560331 560457 561969 563033 579410 584084 590105 592897 593598 618415 620992 624418 625282 627794 631394 640514 649867 650540 662086 669370 672925 679618 698356 699197 701231 701705 702613 711589 713134 725501 725513 728174 731416 735850 738596 740975 741529 753692 758070 758633 759610 759955 759975 761788 761890 764097 766306 766779 774883 775297 779145 780887 783214 791381 795416 796495 796953 797906 807206 807406 814677 ] |
||||||||||||||||||||||||||||||
|
15.02 ms (7.21%) |
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 590105 620992 640514 627794 774883 779145 780887 795416 807406 797906 741529 759610 761890 740975 791381 472812 366053 490792 419273 454045 458042 538069 521400 532451 536439 579410 559210 679618 701705 713134 593598 592897 631394 783214 759975 728174 753692 764097 725501 759955 731416 758633 417419 465896 395788 395172 420012 516626 513202 485089 186294 393581 401960 428366 411776 492651 494866 521387 542467 552042 554648 555835 649867 672925 669370 699197 618415 624418 625282 796495 775297 796953 725513 807206 766306 735850 738596 758070 761788 766779 382512 432380 183552 503472 386027 203995 391499 434854 431078 417621 428220 814677 461709 463691 492973 452879 449511 453980 530144 532312 529770 537780 507248 513067 532319 489014 552716 559257 560331 563033 555663 560457 561969 584084 662086 701231 711589 650540 698356 702613 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.43%) |
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 183552 186294 203995 366053 382512 386027 391499 393581 395172 395788 401960 411776 417419 417621 419273 420012 428220 428366 431078 432380 434854 449511 452879 453980 454045 458042 461709 463691 465896 472812 485089 489014 490792 492651 492973 494866 503472 507248 513067 513202 516626 521387 521400 529770 530144 532312 532319 532451 536439 537780 538069 542467 552042 552716 554648 555663 555835 559210 559257 560331 560457 561969 563033 579410 584084 590105 592897 593598 618415 620992 624418 625282 627794 631394 640514 649867 650540 662086 669370 672925 679618 698356 699197 701231 701705 702613 711589 713134 725501 725513 728174 731416 735850 738596 740975 741529 753692 758070 758633 759610 759955 759975 761788 761890 764097 766306 766779 774883 775297 779145 780887 783214 791381 795416 796495 796953 797906 807206 807406 814677 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"юбках"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"юбк"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.83%) |
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.