Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
78.35 ms
(52.15%)
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
  392418
  400684
  412367
  413280
  416970
  422288
  427550
  458697
  470289
  476510
  476748
  480238
  492407
  495376
  498402
  498417
  507916
  509691
  510296
  514955
  515433
  518786
  518864
  519594
  520686
  522250
  522998
  524262
  525158
  526547
  527681
  529905
  544753
  545292
  545300
  569198
  586858
  589968
  591647
  607139
  612074
  620798
  623805
  629045
  629363
  650218
  674081
  719407
  757436
  771517
  787313
  792612
  803106
  803317
  813073
  813917
  814741
  814870
  815714
  817298
]
52.26 ms
(34.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:
[
  "mom big body"
  "mom big body"
  "mom big body"
  20
]
9.21 ms
(6.13%)
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
  803106
  495376
  525158
  526547
  519594
  607139
  813917
  817298
  480238
  803317
  413280
  476510
  492407
  815714
  757436
  392418
  470289
  518786
  507916
  476748
  674081
  586858
  787313
  458697
  589968
  416970
  814741
  510296
  422288
  520686
  400684
  814870
  524262
  623805
  612074
  629363
  529905
  545292
  544753
  719407
  771517
  522250
  514955
  527681
  569198
  620798
  518864
  813073
  427550
  522998
  792612
  498417
  412367
  498402
  509691
  650218
  515433
  629045
  545300
  591647
]
2.81 ms
(1.87%)
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
  392418
  400684
  412367
  413280
  416970
  422288
  427550
  458697
  470289
  476510
  476748
  480238
  492407
  495376
  498402
  498417
  507916
  509691
  510296
  514955
  515433
  518786
  518864
  519594
  520686
  522250
  522998
  524262
  525158
  526547
  527681
  529905
  544753
  545292
  545300
  569198
  586858
  589968
  591647
  607139
  612074
  620798
  623805
  629045
  629363
  650218
  674081
  719407
  757436
  771517
  787313
  792612
  803106
  803317
  813073
  813917
  814741
  814870
  815714
  817298
]
2.07 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom big body"
]
2.03 ms
(1.35%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.91 ms
(1.27%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom большие body"
]
1.61 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom большие body"
]

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.