Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
183.70 ms
(83.74%)
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
  188266
  389680
  391583
  393742
  404690
  419793
  426482
  428520
  428663
  431664
  434980
  443928
  449877
  453104
  454633
  460970
  464298
  467368
  469658
  484124
  496607
  497064
  502722
  511503
  511690
  515692
  519140
  520428
  523816
  525795
  528261
  528628
  531185
  549249
  551082
  553254
  562883
  563221
  567863
  569886
  570031
  570086
  579886
  584149
  606718
  609185
  609196
  613489
  671408
  677044
  720351
  731305
  731867
  777920
  792337
  800090
  805460
  806178
  807451
]
14.88 ms
(6.78%)
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
]
10.03 ms
(4.57%)
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
  469658
  453104
  431664
  553254
  609185
  393742
  519140
  188266
  426482
  511690
  496607
  443928
  528261
  731867
  428520
  523816
  777920
  800090
  434980
  807451
  671408
  720351
  806178
  428663
  419793
  606718
  579886
  584149
  531185
  792337
  731305
  460970
  677044
  404690
  805460
  467368
  528628
  464298
  549249
  562883
  391583
  497064
  502722
  570031
  569886
  570086
  389680
  454633
  484124
  563221
  551082
  567863
  449877
  525795
  520428
  511503
  515692
  613489
  609196
]
3.13 ms
(1.43%)
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
  188266
  389680
  391583
  393742
  404690
  419793
  426482
  428520
  428663
  431664
  434980
  443928
  449877
  453104
  454633
  460970
  464298
  467368
  469658
  484124
  496607
  497064
  502722
  511503
  511690
  515692
  519140
  520428
  523816
  525795
  528261
  528628
  531185
  549249
  551082
  553254
  562883
  563221
  567863
  569886
  570031
  570086
  579886
  584149
  606718
  609185
  609196
  613489
  671408
  677044
  720351
  731305
  731867
  777920
  792337
  800090
  805460
  806178
  807451
]
2.41 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "курьер будет лизать"
]
2.12 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "курьер лиза"
]
1.56 ms
(0.71%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "курьер лиза"
]
1.55 ms
(0.70%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.