Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
63.02 ms
(65.40%)
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
  423821
  426484
  442896
  444574
  450828
  451011
  455147
  455859
  456567
  461262
  466706
  469022
  477870
  478182
  485061
  486540
  491732
  491733
  491739
  491742
  506156
  512551
  513289
  524651
  529188
  537140
  565559
  567068
  569389
  576579
  585345
  587329
  587920
  589242
  594615
  598277
  601900
  602981
  603927
  604353
  639049
  639459
  643315
  644039
  662066
  762886
  783992
  789039
  806030
  811095
  813284
  821492
  821526
  822482
  822668
  822985
]
16.69 ms
(17.32%)
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:
[
  "pov blue"
  "pov blue"
  "pov blue"
  20
]
7.58 ms
(7.86%)
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
  423821
  806030
  594615
  529188
  513289
  821526
  639049
  822668
  821492
  576579
  455147
  822482
  822985
  789039
  813284
  662066
  644039
  604353
  537140
  426484
  442896
  783992
  585345
  639459
  587329
  811095
  762886
  477870
  456567
  491739
  450828
  466706
  469022
  643315
  598277
  603927
  461262
  506156
  491733
  491742
  565559
  567068
  444574
  478182
  451011
  491732
  589242
  524651
  455859
  587920
  512551
  601900
  569389
  485061
  602981
  486540
]
2.12 ms
(2.20%)
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
  423821
  426484
  442896
  444574
  450828
  451011
  455147
  455859
  456567
  461262
  466706
  469022
  477870
  478182
  485061
  486540
  491732
  491733
  491739
  491742
  506156
  512551
  513289
  524651
  529188
  537140
  565559
  567068
  569389
  576579
  585345
  587329
  587920
  589242
  594615
  598277
  601900
  602981
  603927
  604353
  639049
  639459
  643315
  644039
  662066
  762886
  783992
  789039
  806030
  811095
  813284
  821492
  821526
  822482
  822668
  822985
]
2.09 ms
(2.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pov blue"
]
1.90 ms
(1.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов blue"
]
1.50 ms
(1.56%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(1.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "пов blue"
]

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.