Query Metrics
7
Database Queries
7
Different statements
161.34 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.59 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.68 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"да тише"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.09 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 395727 395846 396670 446222 452171 396249 401307 395609 396238 401278 457889 463954 489108 500924 516449 519569 395547 395620 395826 395968 395970 396253 401305 419888 428631 459807 554780 561412 760958 395552 395812 396005 463873 475410 395674 395738 477859 395622 395687 395981 395856 395913 395984 396012 408283 428494 519549 509940 395751 468612 524530 565163 558119 664632 395648 396020 401091 463298 402008 411201 519560 490143 519553 523396 393076 395719 459804 415658 419872 419867 419880 395818 565156 598657 602966 395718 512094 527416 565169 605521 395696 418686 514070 624226 ] |
||||||||||||||||||||||||||||||
| 4 | 2.84 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 393076 395547 395552 395609 395620 395622 395648 395674 395687 395696 395718 395719 395727 395738 395751 395812 395818 395826 395846 395856 395913 395968 395970 395981 395984 396005 396012 396020 396238 396249 396253 396670 401091 401278 401305 401307 402008 408283 411201 415658 418686 419867 419872 419880 419888 428494 428631 446222 452171 457889 459804 459807 463298 463873 463954 468612 475410 477859 489108 490143 500924 509940 512094 514070 516449 519549 519553 519560 519569 523396 524530 527416 554780 558119 561412 565156 565163 565169 598657 602966 605521 624226 664632 760958 ] |
||||||||||||||||||||||||||||||
| 5 | 137.21 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 393076 395547 395552 395609 395620 395622 395648 395674 395687 395696 395718 395719 395727 395738 395751 395812 395818 395826 395846 395856 395913 395968 395970 395981 395984 396005 396012 396020 396238 396249 396253 396670 401091 401278 401305 401307 402008 408283 411201 415658 418686 419867 419872 419880 419888 428494 428631 446222 452171 457889 459804 459807 463298 463873 463954 468612 475410 477859 489108 490143 500924 509940 512094 514070 516449 519549 519553 519560 519569 523396 524530 527416 554780 558119 561412 565156 565163 565169 598657 602966 605521 624226 664632 760958 ] |
||||||||||||||||||||||||||||||
| 6 | 1.52 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"tushy"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.40 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"tushy"
]
|
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.