Query Metrics
7
Database Queries
7
Different statements
205.57 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.32 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.18 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"неожидано"
]
|
||||||||||||||||||||||||||||||
| 3 | 13.20 ms |
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 579810 545221 579812 722934 693967 699577 565771 579842 604314 593622 609227 612178 612315 591485 592301 593675 780475 772479 787624 801953 726882 706497 446729 501957 492583 402592 432361 475474 531219 510244 516724 524962 497729 505917 535416 577641 579863 549534 579811 563549 684541 686020 681209 577468 578474 614680 626726 773565 628423 797831 490070 526756 579869 557072 564246 572697 615378 596497 593966 602002 591487 593778 813191 612507 623376 672801 566230 513838 569895 669214 549500 624840 593641 613815 603001 623618 623792 505012 519985 540657 539748 526103 619598 610004 621527 493204 598215 ] |
||||||||||||||||||||||||||||||
| 4 | 2.24 ms |
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 402592 432361 446729 475474 490070 492583 493204 497729 501957 505012 505917 510244 513838 516724 519985 524962 526103 526756 531219 535416 539748 540657 545221 549500 549534 557072 563549 564246 565771 566230 569895 572697 577468 577641 578474 579810 579811 579812 579842 579863 579869 591485 591487 592301 593622 593641 593675 593778 593966 596497 598215 602002 603001 604314 609227 610004 612178 612315 612507 613815 614680 615378 619598 621527 623376 623618 623792 624840 626726 628423 669214 672801 681209 684541 686020 693967 699577 706497 722934 726882 772479 773565 780475 787624 797831 801953 813191 ] |
||||||||||||||||||||||||||||||
| 5 | 183.50 ms |
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 402592 432361 446729 475474 490070 492583 493204 497729 501957 505012 505917 510244 513838 516724 519985 524962 526103 526756 531219 535416 539748 540657 545221 549500 549534 557072 563549 564246 565771 566230 569895 572697 577468 577641 578474 579810 579811 579812 579842 579863 579869 591485 591487 592301 593622 593641 593675 593778 593966 596497 598215 602002 603001 604314 609227 610004 612178 612315 612507 613815 614680 615378 619598 621527 623376 623618 623792 624840 626726 628423 669214 672801 681209 684541 686020 693967 699577 706497 722934 726882 772479 773565 780475 787624 797831 801953 813191 ] |
||||||||||||||||||||||||||||||
| 6 | 1.71 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"неожида"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.42 ms |
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.