Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
94.22 ms
(52.92%)
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
  424263
  465746
  466329
  483177
  487372
  488423
  501036
  501473
  514013
  526338
  526780
  528285
  537400
  544927
  545029
  552380
  555067
  563672
  566908
  569249
  569626
  579029
  587709
  594933
  597182
  600186
  602540
  608541
  609883
  612933
  614747
  620211
  627001
  655539
  678722
  679537
  682866
  688967
  691758
  697720
  699844
  734129
  741886
  764627
  766143
  766463
  767329
  775834
  777564
  784700
  786694
  787543
  787598
  793765
  795615
  796726
  809979
]
64.80 ms
(36.40%)
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.51 ms
(4.78%)
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
  787598
  787543
  579029
  587709
  514013
  784700
  766463
  526338
  627001
  569626
  563672
  809979
  734129
  777564
  795615
  424263
  552380
  465746
  555067
  678722
  767329
  544927
  691758
  679537
  545029
  793765
  796726
  501473
  688967
  766143
  699844
  655539
  786694
  602540
  620211
  741886
  466329
  526780
  487372
  697720
  764627
  483177
  609883
  501036
  528285
  775834
  597182
  612933
  488423
  608541
  537400
  682866
  594933
  569249
  600186
  614747
  566908
]
3.13 ms
(1.76%)
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
  424263
  465746
  466329
  483177
  487372
  488423
  501036
  501473
  514013
  526338
  526780
  528285
  537400
  544927
  545029
  552380
  555067
  563672
  566908
  569249
  569626
  579029
  587709
  594933
  597182
  600186
  602540
  608541
  609883
  612933
  614747
  620211
  627001
  655539
  678722
  679537
  682866
  688967
  691758
  697720
  699844
  734129
  741886
  764627
  766143
  766463
  767329
  775834
  777564
  784700
  786694
  787543
  787598
  793765
  795615
  796726
  809979
]
2.06 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "русскую шлюху в рот"
]
1.84 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск шлюх в рот"
]
1.82 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(0.93%)
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.