Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
79.17 ms
(67.69%)
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
  381846
  381982
  396486
  403054
  409930
  421062
  424435
  439135
  469274
  475066
  482375
  485075
  497262
  502807
  504820
  513520
  514188
  514741
  524670
  529390
  547781
  554915
  555688
  564502
  564901
  567326
  569975
  575510
  577711
  590258
  590705
  603977
  606958
  611028
  619216
  624109
  624821
  630187
  642093
  682263
  712073
  714640
  718517
  745728
  747077
  777203
  793884
  814011
]
21.38 ms
(18.28%)
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
]
8.14 ms
(6.96%)
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
  747077
  497262
  569975
  567326
  403054
  524670
  396486
  564502
  642093
  603977
  814011
  504820
  714640
  624967
  577711
  718517
  793884
  555688
  409930
  712073
  777203
  547781
  745728
  381846
  475066
  469274
  575510
  590258
  590705
  381982
  424435
  439135
  502807
  624821
  514188
  513520
  682263
  619216
  606958
  514741
  485075
  482375
  630187
  529390
  611028
  421062
  554915
  564901
  624109
]
1.92 ms
(1.65%)
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
  381846
  381982
  396486
  403054
  409930
  421062
  424435
  439135
  469274
  475066
  482375
  485075
  497262
  502807
  504820
  513520
  514188
  514741
  524670
  529390
  547781
  554915
  555688
  564502
  564901
  567326
  569975
  575510
  577711
  590258
  590705
  603977
  606958
  611028
  619216
  624109
  624821
  630187
  642093
  682263
  712073
  714640
  718517
  745728
  747077
  777203
  793884
  814011
]
1.82 ms
(1.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "долги в очках"
]
1.55 ms
(1.33%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "долг очкастые"
]
1.52 ms
(1.30%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.45 ms
(1.24%)
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.