Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
67.43 ms
(61.18%)
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
  413255
  419351
  434077
  435027
  449925
  451727
  452849
  456377
  457059
  457950
  459461
  462373
  470726
  472185
  475715
  475756
  510912
  515947
  517879
  525729
  530996
  531004
  533148
  533884
  537028
  538708
  548140
  555657
  556202
  557486
  559430
  559978
  564630
  566597
  571224
  574700
  580246
  584558
  586868
  590956
  591985
  593965
  594262
  599145
  601388
  601621
  602165
  603277
  609111
  626066
  704615
  711480
  731600
  783343
  802905
  805129
  810527
]
24.37 ms
(22.11%)
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:
[
  "dance solo tits"
  "dance solo tits"
  "dance solo tits"
  20
]
9.72 ms
(8.82%)
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
  591985
  475756
  531004
  571224
  599145
  805129
  810527
  783343
  731600
  459461
  533148
  802905
  533884
  564630
  704615
  510912
  538708
  601388
  470726
  559978
  711480
  590956
  609111
  475715
  517879
  413255
  586868
  451727
  530996
  580246
  584558
  452849
  626066
  602165
  472185
  457059
  556202
  559430
  557486
  601621
  419351
  462373
  435027
  456377
  548140
  525729
  594262
  434077
  603277
  555657
  457950
  566597
  593965
  537028
  449925
  515947
  574700
]
1.99 ms
(1.81%)
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
  413255
  419351
  434077
  435027
  449925
  451727
  452849
  456377
  457059
  457950
  459461
  462373
  470726
  472185
  475715
  475756
  510912
  515947
  517879
  525729
  530996
  531004
  533148
  533884
  537028
  538708
  548140
  555657
  556202
  557486
  559430
  559978
  564630
  566597
  571224
  574700
  580246
  584558
  586868
  590956
  591985
  593965
  594262
  599145
  601388
  601621
  602165
  603277
  609111
  626066
  704615
  711480
  731600
  783343
  802905
  805129
  810527
]
1.95 ms
(1.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dance solo tits"
]
1.79 ms
(1.62%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(1.39%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "танец соло сиськ"
]
1.44 ms
(1.31%)
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.