Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
190.57 ms
(88.94%)
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
  453462
  470400
  497365
  510303
  511199
  514920
  516214
  523134
  536245
  538705
  554121
  559062
  574967
  579546
  579553
  595580
  598762
  599639
  602789
  604287
  610792
  617552
  618778
  620912
  626177
  627768
  630552
  632111
  634218
  636300
  637148
  637741
  639767
  641026
  641452
  655132
  662142
  666974
  669003
  670904
  675628
  684672
  686079
  689542
  699225
  702636
  707673
  708520
  708680
  709901
  712491
  712987
  714566
  718089
  719128
  719923
  721096
  722206
  724442
  725252
  728538
  731511
  736285
  736882
  741785
  742011
  743340
  743905
  746594
  747170
  747675
  749605
  749741
  750195
  761302
  761619
  764004
  764114
  766223
  768615
  768902
  770958
  771045
  774833
  778034
  779365
  779951
  781187
  781772
  783194
  783823
  785443
  787356
  787442
  788515
  789827
  790708
  792420
  792700
  793062
  793771
  795315
  795628
  795858
  795998
  796027
  797082
  797210
  800314
  801316
  802605
  803057
  804065
  805536
  806025
  807734
  809729
  810996
  812624
  814424
]
13.34 ms
(6.22%)
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
  636300
  639767
  630552
  634218
  637148
  516214
  559062
  523134
  579546
  637741
  814424
  497365
  511199
  536245
  538705
  554121
  709901
  722206
  686079
  708680
  655132
  675628
  617552
  604287
  626177
  632111
  627768
  783823
  788515
  795628
  806025
  779365
  781187
  789827
  790708
  795315
  796027
  764114
  783194
  785443
  797210
  809729
  724442
  728538
  736882
  747675
  749605
  761302
  764004
  749741
  750195
  618778
  702636
  778034
  787356
  793062
  812624
  470400
  453462
  510303
  514920
  579553
  574967
  662142
  666974
  669003
  712987
  719128
  719923
  670904
  684672
  712491
  689542
  707673
  708520
  714566
  718089
  595580
  598762
  599639
  620912
  641026
  641452
  774833
  781772
  792420
  793771
  795858
  803057
  807734
  797082
  725252
  731511
  742011
  743340
  743905
  746594
  795998
  802605
  804065
  736285
  747170
  768615
  768902
  770958
  741785
  771045
  761619
  766223
  602789
  610792
  699225
  721096
  779951
  787442
  792700
  800314
  801316
  805536
  810996
]
2.78 ms
(1.30%)
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
  453462
  470400
  497365
  510303
  511199
  514920
  516214
  523134
  536245
  538705
  554121
  559062
  574967
  579546
  579553
  595580
  598762
  599639
  602789
  604287
  610792
  617552
  618778
  620912
  626177
  627768
  630552
  632111
  634218
  636300
  637148
  637741
  639767
  641026
  641452
  655132
  662142
  666974
  669003
  670904
  675628
  684672
  686079
  689542
  699225
  702636
  707673
  708520
  708680
  709901
  712491
  712987
  714566
  718089
  719128
  719923
  721096
  722206
  724442
  725252
  728538
  731511
  736285
  736882
  741785
  742011
  743340
  743905
  746594
  747170
  747675
  749605
  749741
  750195
  761302
  761619
  764004
  764114
  766223
  768615
  768902
  770958
  771045
  774833
  778034
  779365
  779951
  781187
  781772
  783194
  783823
  785443
  787356
  787442
  788515
  789827
  790708
  792420
  792700
  793062
  793771
  795315
  795628
  795858
  795998
  796027
  797082
  797210
  800314
  801316
  802605
  803057
  804065
  805536
  806025
  807734
  809729
  810996
  812624
  814424
]
2.13 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "extreme cum"
]
2.02 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "хардкор cum"
]
1.65 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "хардкор cum"
]

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.