Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
76.35 ms
(68.57%)
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
  425537
  433373
  442697
  446259
  459210
  460922
  463133
  468446
  476091
  483280
  485286
  485407
  491039
  491313
  508380
  514673
  519914
  520005
  521374
  528280
  543970
  552055
  552570
  557716
  558127
  561001
  565474
  567735
  567837
  569096
  569817
  570221
  575128
  577362
  584921
  589721
  592936
  602715
  612261
  617040
  620239
  646233
  659715
  663475
  687348
]
15.48 ms
(13.91%)
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.26 ms
(7.42%)
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
  483280
  687348
  459210
  433373
  592936
  575128
  491313
  521374
  557716
  528280
  446259
  485286
  569817
  543970
  584921
  561001
  491039
  485407
  508380
  552055
  567735
  460922
  514673
  646233
  476091
  570221
  612261
  425537
  519914
  659715
  569096
  617040
  565474
  663475
  620239
  442697
  567837
  520005
  577362
  552570
  589721
  602715
  463133
  558127
  468446
]
2.95 ms
(2.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
  425537
  433373
  442697
  446259
  459210
  460922
  463133
  468446
  476091
  483280
  485286
  485407
  491039
  491313
  508380
  514673
  519914
  520005
  521374
  528280
  543970
  552055
  552570
  557716
  558127
  561001
  565474
  567735
  567837
  569096
  569817
  570221
  575128
  577362
  584921
  589721
  592936
  602715
  612261
  617040
  620239
  646233
  659715
  663475
  687348
]
2.56 ms
(2.30%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "бок сзад"
]
1.96 ms
(1.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "боком сзади"
]
1.93 ms
(1.74%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.85 ms
(1.66%)
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.