Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.38 ms
(83.51%)
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
  385947
  402634
  416170
  416514
  417674
  418145
  418149
  419200
  420295
  421052
  421366
  427027
  427292
  428174
  430374
  431540
  434321
  434325
  434330
  434350
  434352
  434374
  440710
  444322
  444515
  449210
  454004
  457817
  460208
  464971
  467893
  469198
  469221
  473410
  476186
  476654
  477223
  479544
  495566
  496348
  511273
  518210
  519349
  528551
  537250
  540032
  545001
  552745
  553215
  559377
  559787
  561979
  564856
  571316
  576925
  582005
  583734
  584351
  587306
  588449
  590788
  592702
  595049
  606576
  610039
  611216
  629287
  629808
  636666
  642403
  661424
  666988
  668628
  669884
  670210
  680456
  690666
  700997
  708145
  709128
  717620
  726068
  730015
  738827
  739054
  739820
  746084
  751433
  753774
  770515
  776997
  777657
  779870
  780067
  782585
  784792
  784975
  785568
  785614
  786023
  787095
  787532
  788757
  791077
  795434
  803019
  803494
  803635
  803880
  806144
  806580
  806688
  806973
  807251
  807589
  809707
  810896
  811296
  812626
  813899
]
16.90 ms
(10.66%)
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
  571316
  576925
  690666
  708145
  611216
  784792
  787095
  795434
  803019
  809707
  812626
  784975
  791077
  810896
  730015
  746084
  753774
  739820
  770515
  777657
  779870
  782585
  807251
  610039
  519349
  479544
  552745
  553215
  564856
  588449
  444322
  473410
  469221
  587306
  431540
  537250
  545001
  561979
  421366
  449210
  434374
  430374
  806580
  420295
  559787
  460208
  477223
  417674
  670210
  428174
  402634
  807589
  666988
  636666
  595049
  785568
  788757
  806144
  787532
  806973
  739054
  786023
  803635
  751433
  726068
  700997
  776997
  780067
  803494
  418149
  434330
  434350
  583734
  454004
  476186
  496348
  528551
  668628
  669884
  434321
  434325
  476654
  457817
  540032
  584351
  559377
  661424
  592702
  606576
  629287
  629808
  590788
  642403
  785614
  806688
  738827
  709128
  421052
  434352
  511273
  495566
  427027
  803880
  416170
  419200
  464971
  518210
  811296
  467893
  427292
  418145
  469198
  385947
  416514
  444515
  440710
  813899
  582005
  717620
  680456
]
2.53 ms
(1.60%)
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
  385947
  402634
  416170
  416514
  417674
  418145
  418149
  419200
  420295
  421052
  421366
  427027
  427292
  428174
  430374
  431540
  434321
  434325
  434330
  434350
  434352
  434374
  440710
  444322
  444515
  449210
  454004
  457817
  460208
  464971
  467893
  469198
  469221
  473410
  476186
  476654
  477223
  479544
  495566
  496348
  511273
  518210
  519349
  528551
  537250
  540032
  545001
  552745
  553215
  559377
  559787
  561979
  564856
  571316
  576925
  582005
  583734
  584351
  587306
  588449
  590788
  592702
  595049
  606576
  610039
  611216
  629287
  629808
  636666
  642403
  661424
  666988
  668628
  669884
  670210
  680456
  690666
  700997
  708145
  709128
  717620
  726068
  730015
  738827
  739054
  739820
  746084
  751433
  753774
  770515
  776997
  777657
  779870
  780067
  782585
  784792
  784975
  785568
  785614
  786023
  787095
  787532
  788757
  791077
  795434
  803019
  803494
  803635
  803880
  806144
  806580
  806688
  806973
  807251
  807589
  809707
  810896
  811296
  812626
  813899
]
1.80 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "squirt dildo solo"
]
1.75 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сквирт оргазм дилд соло"
]
1.57 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.