Query Metrics

8 Database Queries
8 Different statements
88.33 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
56.92 ms
(64.44%)
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
  511464
  522342
  541759
  541872
  542969
  543494
  549976
  551939
  552134
  552136
  555903
  556783
  557209
  557336
  563854
  563860
  565571
  565983
  565993
  566978
  569947
  571664
  571669
  572026
  574298
  576658
  580256
  581157
  581336
  588211
  593465
  601347
  603259
  603344
  603431
  605485
  651641
  674572
  676122
  678008
  681427
  681444
  683438
  684060
  684173
  685667
  688084
  688575
]
10.88 ms
(12.32%)
1
SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?
Parameters:
[
  "фильм сюжет"
  "фильм сюжет"
  "фильм сюжет"
  20
]
9.73 ms
(11.02%)
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
  565993
  678008
  605485
  565571
  566978
  681444
  651641
  674572
  563860
  552136
  676122
  681427
  541872
  571664
  571669
  551939
  684060
  684173
  685667
  688084
  552134
  581336
  576658
  557336
  581157
  593465
  603344
  541759
  542969
  543494
  557209
  563854
  555903
  574298
  603431
  565983
  683438
  688575
  549976
  556783
  588211
  603259
  580256
  601347
  569947
  522342
  511464
  572026
]
3.40 ms
(3.85%)
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
  511464
  522342
  541759
  541872
  542969
  543494
  549976
  551939
  552134
  552136
  555903
  556783
  557209
  557336
  563854
  563860
  565571
  565983
  565993
  566978
  569947
  571664
  571669
  572026
  574298
  576658
  580256
  581157
  581336
  588211
  593465
  601347
  603259
  603344
  603431
  605485
  651641
  674572
  676122
  678008
  681427
  681444
  683438
  684060
  684173
  685667
  688084
  688575
]
2.09 ms
(2.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "фильм сюжет"
]
1.93 ms
(2.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "фильм сюжет"
]
1.88 ms
(2.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(1.69%)
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.