Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
76.33 ms
(45.64%)
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
  397940
  418068
  421077
  423633
  429805
  429817
  433231
  434874
  437504
  444838
  447722
  447898
  448414
  449115
  452097
  452456
  465354
  469200
  472286
  478065
  482559
  483567
  496756
  511266
  514241
  519299
  525440
  532876
  534166
  540167
  541635
  552623
  553480
  555317
  573212
  597170
  602928
  604109
  608414
  611567
  613515
  616822
  620163
  631171
  634178
  639301
  641644
  647995
  666850
  676428
  688369
  695123
  695127
  695181
  711283
  716394
  723287
  729344
  766694
  786463
  816007
]
72.52 ms
(43.36%)
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:
[
  "best anal compilation"
  "best anal compilation"
  "best anal compilation"
  20
]
9.46 ms
(5.66%)
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
  452456
  447898
  469200
  444838
  472286
  716394
  434874
  602928
  447722
  437504
  483567
  766694
  429805
  449115
  433231
  723287
  553480
  631171
  397940
  482559
  448414
  552623
  604109
  620163
  639301
  729344
  421077
  418068
  511266
  597170
  616822
  514241
  532876
  519299
  688369
  423633
  786463
  608414
  465354
  540167
  429817
  541635
  816007
  534166
  647995
  613515
  478065
  525440
  452097
  496756
  711283
  641644
  555317
  611567
  695123
  634178
  695181
  666850
  676428
  695127
  573212
]
2.27 ms
(1.35%)
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
  397940
  418068
  421077
  423633
  429805
  429817
  433231
  434874
  437504
  444838
  447722
  447898
  448414
  449115
  452097
  452456
  465354
  469200
  472286
  478065
  482559
  483567
  496756
  511266
  514241
  519299
  525440
  532876
  534166
  540167
  541635
  552623
  553480
  555317
  573212
  597170
  602928
  604109
  608414
  611567
  613515
  616822
  620163
  631171
  634178
  639301
  641644
  647995
  666850
  676428
  688369
  695123
  695127
  695181
  711283
  716394
  723287
  729344
  766694
  786463
  816007
]
1.90 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "best anal compilation"
]
1.67 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "best анал подборк"
]
1.65 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.45 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "best анал подборк"
]

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.