Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
93.20 ms
(71.60%)
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
  188117
  443635
  444438
  455685
  455912
  457428
  458051
  459512
  465552
  477721
  482094
  482808
  484807
  486408
  486815
  493122
  496802
  502214
  503241
  506269
  514576
  515986
  518131
  520413
  522616
  522783
  526254
  526587
  532701
  535464
  539354
  550647
  553300
  553942
  561936
  569132
  575794
  579493
  581096
  583729
  597975
  599249
  599299
  601677
  603612
  606016
  607413
  615978
  616994
  617116
  623641
  624843
  625140
  625770
  646895
  714511
  814266
]
13.86 ms
(10.64%)
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:
[
  "fat blowjob"
  "fat blowjob"
  "fat blowjob"
  20
]
13.34 ms
(10.25%)
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
  625770
  550647
  532701
  535464
  502214
  486408
  646895
  814266
  625140
  522783
  624843
  617116
  457428
  188117
  714511
  443635
  514576
  486815
  599299
  465552
  482094
  477721
  526254
  607413
  503241
  520413
  444438
  623641
  515986
  518131
  553300
  615978
  597975
  455912
  455685
  569132
  583729
  496802
  603612
  579493
  539354
  581096
  493122
  484807
  482808
  458051
  459512
  599249
  575794
  526587
  553942
  561936
  601677
  522616
  506269
  606016
  616994
]
2.76 ms
(2.12%)
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
  188117
  443635
  444438
  455685
  455912
  457428
  458051
  459512
  465552
  477721
  482094
  482808
  484807
  486408
  486815
  493122
  496802
  502214
  503241
  506269
  514576
  515986
  518131
  520413
  522616
  522783
  526254
  526587
  532701
  535464
  539354
  550647
  553300
  553942
  561936
  569132
  575794
  579493
  581096
  583729
  597975
  599249
  599299
  601677
  603612
  606016
  607413
  615978
  616994
  617116
  623641
  624843
  625140
  625770
  646895
  714511
  814266
]
2.20 ms
(1.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fat blowjob"
]
1.70 ms
(1.31%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(1.27%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "fat минет оральн секс"
]
1.46 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "fat минет оральн секс"
]

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.