Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.51 ms
(89.29%)
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
  87363
  312616
  383419
  385454
  385547
  396945
  398314
  402887
  410264
  415280
  417943
  418298
  423682
  423904
  445326
  447951
  449570
  457086
  458285
  462403
  477063
  488855
  502349
  527203
  537247
  545262
  564013
  582457
  592373
  593051
  600724
  615642
  616668
  621796
  624921
  628535
  631120
  638727
  641778
  642662
  650095
  674826
  696472
  707071
  712879
  712880
  713172
  716593
  716611
  716635
  716722
  717259
  718349
  718770
  719787
  721450
  722118
  726928
  729791
  731699
  740045
  742836
  743009
  743684
  749145
  755166
  763270
  764559
  765751
  765763
  766224
  769616
  769646
  769664
  775212
  776787
  777856
  778066
  778634
  779037
  779884
  780077
  780245
  780853
  781815
  783225
  783415
  783440
  783785
  784690
  787202
  787235
  787796
  789127
  792515
  793729
  793756
  793768
  794993
  801705
  807302
  809191
  812514
  814205
  817111
  817148
  817212
  817758
  818222
  823763
  825023
  825177
  825180
  825200
  825848
  826373
  826815
  826831
  826929
]
9.66 ms
(5.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
  716593
  615642
  312616
  719787
  765751
  716722
  729791
  781815
  631120
  582457
  792515
  783415
  488855
  402887
  410264
  445326
  593051
  592373
  457086
  423682
  417943
  537247
  779884
  769616
  769664
  415280
  777856
  418298
  545262
  477063
  696472
  793756
  825180
  712879
  716635
  717259
  718770
  721450
  787202
  794993
  826815
  778066
  638727
  641778
  787235
  642662
  779037
  707071
  423904
  765763
  726928
  809191
  778634
  789127
  743684
  447951
  462403
  674826
  458285
  383419
  775212
  564013
  712880
  743009
  776787
  825177
  398314
  621796
  600724
  766224
  763270
  722118
  616668
  793768
  527203
  713172
  817111
  817148
  780077
  764559
  624921
  818222
  783785
  502349
  385454
  825932
  628535
  807302
  825848
  716611
  718349
  787796
  784690
  731699
  780853
  793729
  814205
  825023
  826373
  817758
  783440
  749145
  812514
  449570
  87363
  396945
  823763
  826929
  783225
  769646
  742836
  817212
  825200
  826831
  650095
  780245
  755166
  801705
  740045
  385547
]
2.32 ms
(1.32%)
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
  87363
  312616
  383419
  385454
  385547
  396945
  398314
  402887
  410264
  415280
  417943
  418298
  423682
  423904
  445326
  447951
  449570
  457086
  458285
  462403
  477063
  488855
  502349
  527203
  537247
  545262
  564013
  582457
  592373
  593051
  600724
  615642
  616668
  621796
  624921
  628535
  631120
  638727
  641778
  642662
  650095
  674826
  696472
  707071
  712879
  712880
  713172
  716593
  716611
  716635
  716722
  717259
  718349
  718770
  719787
  721450
  722118
  726928
  729791
  731699
  740045
  742836
  743009
  743684
  749145
  755166
  763270
  764559
  765751
  765763
  766224
  769616
  769646
  769664
  775212
  776787
  777856
  778066
  778634
  779037
  779884
  780077
  780245
  780853
  781815
  783225
  783415
  783440
  783785
  784690
  787202
  787235
  787796
  789127
  792515
  793729
  793756
  793768
  794993
  801705
  807302
  809191
  812514
  814205
  817111
  817148
  817212
  817758
  818222
  823763
  825023
  825177
  825180
  825200
  825848
  826373
  826815
  826831
  826929
]
2.09 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blowjob face fuck"
]
1.70 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "минет оральн секс face секс"
]
1.48 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "минет оральн секс face секс"
]

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.