Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
48.82 ms
(47.26%)
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
  187962
  419628
  439696
  453494
  464594
  467973
  474289
  482704
  489237
  511678
  516890
  520496
  521126
  526211
  527142
  551259
  562271
  562391
  564705
  567347
  567380
  571476
  572053
  576049
  577823
  578458
  581616
  586180
  601856
  603488
  603640
  610046
  616864
  619297
  619783
  621407
  627632
  636283
  654474
  654552
  654617
  655615
  656686
  681514
]
31.80 ms
(30.79%)
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:
[
  "черную раком"
  "черную раком"
  "черную раком"
  20
]
11.90 ms
(11.52%)
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
  453494
  562391
  571476
  562271
  619297
  603640
  511678
  527142
  567347
  578458
  489237
  187962
  482704
  572053
  681514
  654617
  656686
  551259
  627632
  439696
  567380
  581616
  654552
  655615
  586180
  616864
  621407
  467973
  526211
  564705
  576049
  577823
  603488
  636283
  601856
  619783
  521126
  516890
  654474
  419628
  474289
  520496
  610046
  464594
]
2.54 ms
(2.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "черная рак"
]
2.40 ms
(2.32%)
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
  187962
  419628
  439696
  453494
  464594
  467973
  474289
  482704
  489237
  511678
  516890
  520496
  521126
  526211
  527142
  551259
  562271
  562391
  564705
  567347
  567380
  571476
  572053
  576049
  577823
  578458
  581616
  586180
  601856
  603488
  603640
  610046
  616864
  619297
  619783
  621407
  627632
  636283
  654474
  654552
  654617
  655615
  656686
  681514
]
2.15 ms
(2.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "черную раком"
]
2.04 ms
(1.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(1.60%)
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.