Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
206.11 ms
(65.40%)
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
  182154
  381967
  388110
  389832
  429563
  460446
  465467
  476651
  493338
  493909
  497920
  508694
  514229
  538714
  540747
  541418
  544788
  556000
  568483
  568899
  585550
  585826
  586189
  586404
  599171
  601766
  605232
  605240
  613604
  613800
  615447
  616048
  624201
  637469
  639861
  663154
  664594
  675055
  704218
  704222
  710638
  710685
  715451
  718063
  740553
  748690
  770107
  770197
  777721
  786432
  787212
  789259
  790748
  792996
  799646
  808947
  808990
  811336
]
76.69 ms
(24.34%)
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
  182154
  381967
  388110
  389832
  429563
  460446
  465467
  476651
  493338
  493909
  497920
  508694
  514229
  538714
  540747
  541418
  544788
  556000
  568483
  568899
  585550
  585826
  586189
  586404
  599171
  601766
  605232
  605240
  613604
  613800
  615447
  616048
  624201
  637469
  639861
  663154
  664594
  675055
  704218
  704222
  710638
  710685
  715451
  718063
  740553
  748690
  770107
  770197
  777721
  786432
  787212
  789259
  790748
  792996
  799646
  808947
  808990
  811336
]
16.38 ms
(5.20%)
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:
[
  "stockings solo heels"
  "stockings solo heels"
  "stockings solo heels"
  20
]
9.42 ms
(2.99%)
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
  599171
  811336
  605232
  613604
  605240
  381967
  787212
  789259
  710685
  182154
  799646
  770197
  770107
  476651
  715451
  786432
  538714
  664594
  790748
  493338
  777721
  586404
  675055
  568899
  639861
  508694
  808947
  740553
  637469
  388110
  748690
  718063
  792996
  586189
  585550
  493909
  616048
  465467
  615447
  568483
  663154
  808990
  497920
  460446
  540747
  613800
  514229
  541418
  429563
  556000
  710638
  601766
  585826
  389832
  624201
  704222
  544788
  704218
]
1.85 ms
(0.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "stockings solo heels"
]
1.73 ms
(0.55%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "чулк нижн бел соло heels"
]
1.51 ms
(0.48%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(0.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "чулк нижн бел соло heels"
]

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.