Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
55.51 ms
(61.88%)
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
  275948
  382885
  401601
  419455
  428602
  449068
  455015
  467024
  472395
  474289
  484569
  484779
  487352
  487788
  513148
  513949
  523045
  524276
  526794
  526930
  527199
  527763
  530528
  534535
  555269
  565557
  566688
  572031
  575050
  580138
  584703
  640894
  640964
  641997
  668688
  671052
  675374
  715366
  751587
  777405
  797678
  805146
  811393
  812490
]
17.78 ms
(19.82%)
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
]
7.31 ms
(8.15%)
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
  487788
  715366
  428602
  777405
  797678
  275948
  467024
  534535
  449068
  487352
  401601
  419455
  455015
  640964
  641997
  484569
  640894
  751587
  671052
  527763
  811393
  526930
  382885
  572031
  805146
  484779
  668688
  555269
  526794
  575050
  812490
  566688
  565557
  580138
  472395
  530528
  513148
  584703
  523045
  474289
  675374
  527199
  513949
  524276
]
2.36 ms
(2.64%)
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
  275948
  382885
  401601
  419455
  428602
  449068
  455015
  467024
  472395
  474289
  484569
  484779
  487352
  487788
  513148
  513949
  523045
  524276
  526794
  526930
  527199
  527763
  530528
  534535
  555269
  565557
  566688
  572031
  575050
  580138
  584703
  640894
  640964
  641997
  668688
  671052
  675374
  715366
  751587
  777405
  797678
  805146
  811393
  812490
]
1.78 ms
(1.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин больш вагин"
]
1.77 ms
(1.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ð╝ð░ð╝ð║ð© Ðü ð▒ð¥ð╗ÐîÐêðÁð© ð┐ð©ðÀð┤ð¥ðÔǪ"
]
1.71 ms
(1.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мам женщин больш вагин"
]
1.48 ms
(1.65%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.