Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.14 ms
(83.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
  150124
  392214
  425268
  448663
  451608
  453846
  454325
  455596
  461330
  472225
  490237
  497971
  500720
  504786
  507158
  513451
  520879
  521172
  533636
  537634
  543803
  551104
  553560
  554794
  555150
  555644
  558996
  559852
  562168
  563512
  566488
  567126
  570871
  584042
  603288
  611391
  616913
  621353
  621356
  631294
  637450
  644640
  647185
  648246
  655490
  660262
  667246
  671693
  673175
  673531
  679708
  684230
  684248
  689296
  689740
  691969
  699038
  700800
  706995
  712705
  713251
  718908
  723941
  726394
  726899
  727580
  728669
  730825
  732988
  734471
  738121
  738376
  740102
  740633
  740981
  743911
  746057
  746170
  746351
  750092
  750275
  758334
  759445
  759861
  760882
  762882
  766459
  767127
  769388
  779265
  783037
  788514
  789470
  789890
  792759
  792834
  794735
  795241
  795375
  796178
  796350
  796608
  797297
  800188
  801149
  804037
  804535
  805313
  805317
  811554
  812121
  814611
  814613
  817466
  817735
  818727
  820378
  821052
  822339
  826815
]
15.05 ms
(9.28%)
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
  750275
  451608
  453846
  543803
  679708
  655490
  647185
  667246
  689740
  555150
  783037
  789470
  811554
  743911
  769388
  732988
  740102
  734471
  746057
  792834
  794735
  805317
  817466
  689296
  637450
  738121
  767127
  490237
  805313
  800188
  562168
  621356
  455596
  448663
  521172
  425268
  826815
  821052
  504786
  497971
  537634
  553560
  584042
  554794
  563512
  673175
  706995
  712705
  660262
  691969
  700800
  699038
  555644
  631294
  796350
  804535
  723941
  766459
  795241
  796608
  738376
  750092
  726899
  746170
  746351
  760882
  762882
  759861
  603288
  779265
  797297
  804037
  513451
  500720
  566488
  648246
  812121
  567126
  814613
  472225
  551104
  684230
  558996
  611391
  740633
  454325
  820378
  817735
  616913
  788514
  740981
  727580
  730825
  796178
  461330
  570871
  621353
  533636
  814611
  520879
  559852
  684248
  673531
  671693
  644640
  728669
  758334
  801149
  726394
  818727
  507158
  392214
  822339
  713251
  718908
  789890
  759445
  792759
  795375
  150124
]
3.49 ms
(2.15%)
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
  150124
  392214
  425268
  448663
  451608
  453846
  454325
  455596
  461330
  472225
  490237
  497971
  500720
  504786
  507158
  513451
  520879
  521172
  533636
  537634
  543803
  551104
  553560
  554794
  555150
  555644
  558996
  559852
  562168
  563512
  566488
  567126
  570871
  584042
  603288
  611391
  616913
  621353
  621356
  631294
  637450
  644640
  647185
  648246
  655490
  660262
  667246
  671693
  673175
  673531
  679708
  684230
  684248
  689296
  689740
  691969
  699038
  700800
  706995
  712705
  713251
  718908
  723941
  726394
  726899
  727580
  728669
  730825
  732988
  734471
  738121
  738376
  740102
  740633
  740981
  743911
  746057
  746170
  746351
  750092
  750275
  758334
  759445
  759861
  760882
  762882
  766459
  767127
  769388
  779265
  783037
  788514
  789470
  789890
  792759
  792834
  794735
  795241
  795375
  796178
  796350
  796608
  797297
  800188
  801149
  804037
  804535
  805313
  805317
  811554
  812121
  814611
  814613
  817466
  817735
  818727
  820378
  821052
  822339
  826815
]
2.33 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hidden ass fuck"
]
2.21 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "скрыт жоп секс"
]
2.15 ms
(1.32%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "скрыт жоп секс"
]
1.89 ms
(1.17%)
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.