Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
72.83 ms
(60.59%)
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
  389596
  446479
  452731
  461008
  461313
  474264
  475699
  477417
  490967
  499887
  503097
  503722
  505389
  514621
  514921
  522678
  526180
  527256
  536883
  537250
  542710
  544958
  546703
  552659
  555593
  562622
  563026
  568292
  578790
  579856
  582077
  597919
  598233
  607027
  615721
  623959
  630659
  635342
  660572
  668734
  689833
  725082
  737827
  737996
  740119
  742228
  747983
  748908
  750515
  755760
  778223
  796520
  805255
]
29.51 ms
(24.55%)
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
]
7.65 ms
(6.36%)
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
  725082
  568292
  503722
  805255
  536883
  527256
  526180
  579856
  737827
  615721
  750515
  796520
  389596
  490967
  630659
  778223
  747983
  755760
  740119
  660572
  668734
  546703
  748908
  555593
  514621
  446479
  742228
  689833
  461313
  578790
  514921
  635342
  623959
  737996
  461008
  475699
  505389
  562622
  499887
  452731
  477417
  582077
  607027
  544958
  542710
  522678
  503097
  552659
  474264
  537250
  563026
  598233
  597919
]
3.12 ms
(2.59%)
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
  389596
  446479
  452731
  461008
  461313
  474264
  475699
  477417
  490967
  499887
  503097
  503722
  505389
  514621
  514921
  522678
  526180
  527256
  536883
  537250
  542710
  544958
  546703
  552659
  555593
  562622
  563026
  568292
  578790
  579856
  582077
  597919
  598233
  607027
  615721
  623959
  630659
  635342
  660572
  668734
  689833
  725082
  737827
  737996
  740119
  742228
  747983
  748908
  750515
  755760
  778223
  796520
  805255
]
2.78 ms
(2.32%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "камера внутри"
]
1.43 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "камер внутр"
]
1.29 ms
(1.07%)
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.