Query Metrics

7 Database Queries
7 Different statements
150.98 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
119.26 ms
(78.99%)
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
  155175
  416581
  416652
  416700
  417198
  418886
  420203
  420886
  421157
  421366
  421569
  421570
  421974
  422044
  422208
  422513
  423480
  424265
  424482
  426592
  427112
  428055
  428761
  428986
  429890
  434369
  435449
  439233
  439264
  442673
  443219
  445787
  446002
  446030
  446964
  447519
  447847
  448522
  448825
  450792
  452796
  452837
  455980
  460015
  460314
  461606
  461612
  462233
  462777
  464366
  464368
  466443
  471012
  476729
  476887
  477435
  478025
  478090
  485061
  485374
  489315
  491056
  499111
  499789
  500292
  502793
  504450
  508985
  509800
  511825
  512503
  513640
  513697
  514236
  514940
  515086
  532300
  549549
  550035
  552608
  555118
  558176
  558951
  562585
  567685
  569154
  571194
  572640
  575366
  576690
  583501
  623713
  624127
  652289
  660370
  669332
  678794
  679019
  704205
  712881
  737127
  808579
]
20.40 ms
(13.51%)
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
  515086
  555118
  418886
  421569
  426592
  513697
  447847
  455980
  513640
  434369
  576690
  448825
  422513
  704205
  460015
  491056
  508985
  461612
  450792
  808579
  737127
  421974
  424482
  462777
  446964
  428055
  446030
  558951
  499111
  569154
  422208
  509800
  532300
  583501
  623713
  499789
  416652
  445787
  549549
  562585
  571194
  416700
  452796
  452837
  477435
  478090
  417198
  421157
  464368
  464366
  428761
  669332
  485374
  461606
  446002
  500292
  442673
  422044
  502793
  466443
  660370
  471012
  423480
  420886
  504450
  421570
  476887
  552608
  447519
  678794
  416581
  514236
  421366
  624127
  448522
  511825
  512503
  429890
  514940
  712881
  550035
  575366
  460314
  567685
  652289
  428986
  478025
  489315
  155175
  443219
  485061
  420203
  476729
  439233
  439264
  427112
  558176
  462233
  424265
  435449
  679019
  572640
]
3.23 ms
(2.14%)
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
  155175
  416581
  416652
  416700
  417198
  418886
  420203
  420886
  421157
  421366
  421569
  421570
  421974
  422044
  422208
  422513
  423480
  424265
  424482
  426592
  427112
  428055
  428761
  428986
  429890
  434369
  435449
  439233
  439264
  442673
  443219
  445787
  446002
  446030
  446964
  447519
  447847
  448522
  448825
  450792
  452796
  452837
  455980
  460015
  460314
  461606
  461612
  462233
  462777
  464366
  464368
  466443
  471012
  476729
  476887
  477435
  478025
  478090
  485061
  485374
  489315
  491056
  499111
  499789
  500292
  502793
  504450
  508985
  509800
  511825
  512503
  513640
  513697
  514236
  514940
  515086
  532300
  549549
  550035
  552608
  555118
  558176
  558951
  562585
  567685
  569154
  571194
  572640
  575366
  576690
  583501
  623713
  624127
  652289
  660370
  669332
  678794
  679019
  704205
  712881
  737127
  808579
]
2.30 ms
(1.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dildo anal close-up"
]
2.14 ms
(1.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "дилд анал close up"
]
2.04 ms
(1.35%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дилд анал close up"
]
1.61 ms
(1.07%)
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.