Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
50.05 ms
(45.68%)
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
  421839
  424663
  428053
  442555
  443503
  445320
  447780
  455922
  460596
  463862
  476448
  478774
  484355
  486277
  525441
  529226
  529228
  560786
  563446
  577435
  584521
  586289
  594437
  599803
  600071
  602880
  603850
  606012
  608041
  608928
  614747
  615449
  619099
  620048
  620249
  620641
  624779
  657287
  661396
]
38.49 ms
(35.13%)
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:
[
  b"Ðüð║ð░Ðçð░ÐéÐî ÐÇÐâÐüÐüð║ð©ð╣ Ðüð¥Ðüð║ð%ÔǪ"
  b"Ðüð║ð░Ðçð░ÐéÐî ÐÇÐâÐüÐüð║ð©ð╣ Ðüð¥Ðüð║ð%ÔǪ"
  b"Ðüð║ð░Ðçð░ÐéÐî ÐÇÐâÐüÐüð║ð©ð╣ Ðüð¥Ðüð║ð%ÔǪ"
  20
]
10.44 ms
(9.53%)
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
  442555
  443503
  428053
  445320
  460596
  463862
  484355
  478774
  486277
  661396
  620249
  599803
  620048
  619099
  624779
  529228
  657287
  603850
  600071
  608041
  455922
  424663
  525441
  586289
  447780
  560786
  577435
  608928
  614747
  594437
  421839
  476448
  602880
  563446
  584521
  606012
  620641
  529226
  615449
]
2.81 ms
(2.57%)
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
  421839
  424663
  428053
  442555
  443503
  445320
  447780
  455922
  460596
  463862
  476448
  478774
  484355
  486277
  525441
  529226
  529228
  560786
  563446
  577435
  584521
  586289
  594437
  599803
  600071
  602880
  603850
  606012
  608041
  608928
  614747
  615449
  619099
  620048
  620249
  620641
  624779
  657287
  661396
]
2.17 ms
(1.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"Ðüð║ð░Ðçð░ÐéÐî ÐÇÐâÐüÐüð║ð©ð╣ Ðüð¥Ðüð║ð%ÔǪ"
]
1.94 ms
(1.77%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.90 ms
(1.73%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "скача русск соск"
]
1.75 ms
(1.60%)
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.