Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
80.22 ms
(57.69%)
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
  81412
  129810
  366296
  384972
  389640
  419242
  420632
  429775
  451737
  452545
  458638
  460710
  465850
  469609
  472486
  493250
  494199
  507678
  510025
  518511
  519500
  521141
  521779
  523878
  526542
  529244
  533996
  548251
  556553
  557805
  558180
  558839
  564013
  565825
  568169
  569065
  573479
  574783
  576308
  586526
  588897
  597147
  598537
  599485
  601991
  605543
  614080
  617616
  618460
  622067
  648575
  741329
  767960
  781289
  810916
]
37.76 ms
(27.16%)
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
]
11.59 ms
(8.34%)
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
  557805
  605543
  781289
  129810
  767960
  810916
  574783
  366296
  556553
  465850
  568169
  558839
  597147
  598537
  420632
  493250
  452545
  599485
  451737
  507678
  519500
  521779
  618460
  548251
  564013
  565825
  429775
  529244
  586526
  573479
  494199
  601991
  569065
  617616
  622067
  518511
  533996
  614080
  472486
  389640
  384972
  81412
  741329
  526542
  458638
  469609
  419242
  523878
  460710
  588897
  558180
  510025
  648575
  576308
  521141
]
2.84 ms
(2.04%)
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
  81412
  129810
  366296
  384972
  389640
  419242
  420632
  429775
  451737
  452545
  458638
  460710
  465850
  469609
  472486
  493250
  494199
  507678
  510025
  518511
  519500
  521141
  521779
  523878
  526542
  529244
  533996
  548251
  556553
  557805
  558180
  558839
  564013
  565825
  568169
  569065
  573479
  574783
  576308
  586526
  588897
  597147
  598537
  599485
  601991
  605543
  614080
  617616
  618460
  622067
  648575
  741329
  767960
  781289
  810916
]
1.71 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "открыт рот"
]
1.70 ms
(1.23%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "открыт рот"
]
1.52 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
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.