Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
56.94 ms
(61.34%)
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
  454704
  454945
  454950
  472488
  497317
  507797
  507798
  507799
  507803
  507810
  514263
  514264
  514265
  515982
  515984
  516013
  516014
  516016
  516069
  518536
  518537
  518543
  547658
  549080
  549087
  549095
  556104
  578156
  587523
  587898
  589769
  592052
  611013
  612985
  617921
  628916
  647186
  681379
  687130
  687468
  715409
  724627
  727209
  758899
  789887
  798988
  800514
]
17.19 ms
(18.52%)
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:
[
  "asia amateur"
  "asia amateur"
  "asia amateur"
  20
]
8.32 ms
(8.96%)
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
  681379
  715409
  549087
  628916
  578156
  724627
  592052
  549095
  587898
  516069
  687468
  612985
  611013
  514264
  515984
  516016
  516014
  758899
  507803
  515982
  518537
  556104
  617921
  507797
  507798
  514265
  516013
  514263
  647186
  547658
  454945
  727209
  587523
  798988
  454704
  549080
  789887
  518543
  687130
  507799
  518536
  800514
  507810
  497317
  454950
  472488
  589769
]
2.73 ms
(2.94%)
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
  454704
  454945
  454950
  472488
  497317
  507797
  507798
  507799
  507803
  507810
  514263
  514264
  514265
  515982
  515984
  516013
  516014
  516016
  516069
  518536
  518537
  518543
  547658
  549080
  549087
  549095
  556104
  578156
  587523
  587898
  589769
  592052
  611013
  612985
  617921
  628916
  647186
  681379
  687130
  687468
  715409
  724627
  727209
  758899
  789887
  798988
  800514
]
2.16 ms
(2.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "asia amateur"
]
1.89 ms
(2.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "asia любительск"
]
1.81 ms
(1.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(1.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "asia любительск"
]

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.