Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
189.53 ms
(88.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
  383016
  395803
  396869
  398436
  406340
  408532
  410328
  412776
  414635
  427540
  458396
  460782
  477247
  484245
  492164
  498922
  504259
  524648
  540708
  541102
  541986
  541996
  542721
  542972
  543710
  545078
  545869
  551175
  554560
  554734
  555661
  556093
  557349
  562054
  566729
  567130
  567133
  567891
  570087
  579127
  580721
  580984
  581038
  590606
  609496
  614849
  617242
  618005
  618302
  623236
  627655
  632065
  637988
  639525
  648485
  649866
  661329
  661353
  665067
  668403
  673996
  685525
  691125
  691846
  692436
  693174
  695660
  695962
  696051
  696432
  696688
  697934
  705104
  713145
  717600
  721810
  721899
  721956
  731641
  734542
  734650
  744011
  744568
  745628
  745986
  748126
  749054
  749860
  755183
  768770
  773275
  774495
  778597
  779820
  780734
  780797
  782119
  782133
  784050
  785533
  789632
  795732
  798200
  798706
  798964
  805228
  811886
  812225
  812230
  812238
  813324
  814166
  820655
  825558
  826148
  828068
  828127
  828133
  828174
  828358
]
12.78 ms
(6.00%)
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
  648485
  705104
  721956
  668403
  696051
  545078
  639525
  782119
  789632
  744011
  721899
  813324
  637988
  609496
  412776
  498922
  398436
  410328
  541986
  541996
  692436
  784050
  773275
  396869
  562054
  492164
  618005
  542721
  782133
  551175
  580721
  570087
  414635
  477247
  504259
  785533
  780797
  427540
  566729
  826148
  828174
  691125
  734650
  542972
  524648
  460782
  731641
  778597
  567133
  567130
  541102
  632065
  798200
  734542
  828068
  811886
  749054
  745628
  721810
  695660
  695962
  554734
  820655
  828358
  543710
  755183
  745986
  825558
  828127
  828133
  484245
  545869
  665067
  691846
  567891
  661353
  673996
  590606
  623236
  780734
  805228
  749860
  617242
  779820
  383016
  661329
  795732
  406340
  814166
  812230
  812238
  744568
  627655
  812225
  557349
  540708
  556093
  768770
  618302
  580984
  581038
  395803
  693174
  649866
  798706
  748126
  696432
  696688
  717600
  408532
  774495
  554560
  579127
  555661
  614849
  458396
  685525
  713145
  697934
  798964
]
3.71 ms
(1.74%)
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
  383016
  395803
  396869
  398436
  406340
  408532
  410328
  412776
  414635
  427540
  458396
  460782
  477247
  484245
  492164
  498922
  504259
  524648
  540708
  541102
  541986
  541996
  542721
  542972
  543710
  545078
  545869
  551175
  554560
  554734
  555661
  556093
  557349
  562054
  566729
  567130
  567133
  567891
  570087
  579127
  580721
  580984
  581038
  590606
  609496
  614849
  617242
  618005
  618302
  623236
  627655
  632065
  637988
  639525
  648485
  649866
  661329
  661353
  665067
  668403
  673996
  685525
  691125
  691846
  692436
  693174
  695660
  695962
  696051
  696432
  696688
  697934
  705104
  713145
  717600
  721810
  721899
  721956
  731641
  734542
  734650
  744011
  744568
  745628
  745986
  748126
  749054
  749860
  755183
  768770
  773275
  774495
  778597
  779820
  780734
  780797
  782119
  782133
  784050
  785533
  789632
  795732
  798200
  798706
  798964
  805228
  811886
  812225
  812230
  812238
  813324
  814166
  820655
  825558
  826148
  828068
  828127
  828133
  828174
  828358
]
1.84 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк на улиц вмашин"
]
1.79 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girl public car"
]
1.74 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк на улиц вмашин"
]
1.58 ms
(0.74%)
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.