Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
182.47 ms
(88.07%)
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
  6768
  152973
  249773
  386042
  390019
  391762
  397475
  409189
  416415
  417113
  468399
  483811
  485055
  493968
  494039
  496952
  507549
  514910
  518403
  519392
  523469
  523584
  533387
  536898
  542106
  546564
  555408
  559069
  561241
  562941
  569544
  574169
  583371
  584207
  589686
  590881
  593611
  595501
  597105
  601504
  603317
  605625
  608233
  610215
  612282
  612303
  613920
  616869
  617403
  623616
  633981
  636930
  640334
  641728
  652132
  656183
  665998
  667748
  670550
  674111
  680536
  680913
  687847
  703788
  708683
  710859
  711416
  715027
  716634
  720093
  723233
  723817
  724131
  726749
  734854
  737844
  739521
  741587
  746092
  756292
  756972
  759794
  762706
  767154
  768637
  768983
  769196
  769314
  771898
  773879
  778125
  779730
  781123
  781149
  781359
  783000
  783144
  783581
  783716
  784104
  784575
  785229
  785744
  786089
  787405
  787787
  791052
  791793
  794434
  797898
  799968
  801253
  802831
  803876
  804165
  804868
  809697
  813006
  813912
]
15.31 ms
(7.39%)
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
  523584
  562941
  813912
  665998
  584207
  734854
  803876
  656183
  590881
  485055
  746092
  494039
  559069
  616869
  708683
  493968
  791793
  409189
  603317
  813006
  759794
  617403
  781149
  809697
  703788
  555408
  680913
  612282
  737844
  773879
  536898
  546564
  519392
  561241
  569544
  726749
  715027
  593611
  6768
  483811
  783716
  794434
  762706
  771898
  386042
  670550
  720093
  636930
  597105
  518403
  769196
  390019
  787389
  680536
  613920
  769314
  496952
  507549
  687847
  779730
  781123
  711416
  601504
  633981
  787787
  739521
  667748
  416415
  583371
  783000
  804868
  249773
  781359
  778125
  595501
  710859
  791052
  784575
  397475
  542106
  786089
  767154
  785744
  724131
  756972
  741587
  799968
  768637
  674111
  640334
  785229
  783581
  523469
  612303
  801253
  784104
  802831
  723233
  391762
  783144
  417113
  533387
  652132
  589686
  605625
  610215
  787405
  797898
  804165
  723817
  623616
  152973
  756292
  468399
  716634
  514910
  608233
  641728
  768983
  574169
]
2.78 ms
(1.34%)
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
  6768
  152973
  249773
  386042
  390019
  391762
  397475
  409189
  416415
  417113
  468399
  483811
  485055
  493968
  494039
  496952
  507549
  514910
  518403
  519392
  523469
  523584
  533387
  536898
  542106
  546564
  555408
  559069
  561241
  562941
  569544
  574169
  583371
  584207
  589686
  590881
  593611
  595501
  597105
  601504
  603317
  605625
  608233
  610215
  612282
  612303
  613920
  616869
  617403
  623616
  633981
  636930
  640334
  641728
  652132
  656183
  665998
  667748
  670550
  674111
  680536
  680913
  687847
  703788
  708683
  710859
  711416
  715027
  716634
  720093
  723233
  723817
  724131
  726749
  734854
  737844
  739521
  741587
  746092
  756292
  756972
  759794
  762706
  767154
  768637
  768983
  769196
  769314
  771898
  773879
  778125
  779730
  781123
  781149
  781359
  783000
  783144
  783581
  783716
  784104
  784575
  785229
  785744
  786089
  787405
  787787
  791052
  791793
  794434
  797898
  799968
  801253
  802831
  803876
  804165
  804868
  809697
  813006
  813912
]
1.82 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "creampie fuck"
]
1.79 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.74%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "creampie секс"
]
1.46 ms
(0.71%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "creampie секс"
]

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.