Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
64.54 ms
(69.51%)
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
  394707
  398199
  416871
  417495
  432540
  433707
  445560
  445566
  449411
  454665
  459871
  472554
  478472
  490312
  497432
  511849
  521043
  522387
  536391
  545104
  566883
  575447
  588510
  598170
  602647
  611342
  629601
  640590
  653115
  707598
  713997
  718069
  740165
  752538
  760694
  769199
  787264
  788046
  791195
  796942
  802577
  803223
  805284
  806279
  807426
  807440
  809994
  812793
  813477
  816679
  821765
]
9.43 ms
(10.15%)
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:
[
  "horny stepsis"
  "horny stepsis"
  "horny stepsis"
  20
]
8.41 ms
(9.06%)
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
  629601
  806279
  398199
  653115
  718069
  787264
  707598
  432540
  478472
  490312
  611342
  813477
  802577
  812793
  796942
  640590
  449411
  394707
  417495
  416871
  545104
  445566
  445560
  511849
  536391
  454665
  472554
  497432
  588510
  816679
  521043
  773238
  433707
  752538
  807426
  809994
  740165
  769199
  566883
  713997
  803223
  791195
  807440
  821765
  805284
  788046
  459871
  760694
  522387
  602647
  598170
  575447
]
2.45 ms
(2.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "horny stepsis"
]
2.39 ms
(2.58%)
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
  394707
  398199
  416871
  417495
  432540
  433707
  445560
  445566
  449411
  454665
  459871
  472554
  478472
  490312
  497432
  511849
  521043
  522387
  536391
  545104
  566883
  575447
  588510
  598170
  602647
  611342
  629601
  640590
  653115
  707598
  713997
  718069
  740165
  752538
  760694
  769199
  787264
  788046
  791195
  796942
  802577
  803223
  805284
  806279
  807426
  807440
  809994
  812793
  813477
  816679
  821765
]
2.35 ms
(2.53%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "horny stepsis"
]
1.65 ms
(1.78%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(1.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "horny stepsis"
]

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.