Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
366.93 ms
(92.89%)
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
  398394
  400126
  400171
  403109
  404644
  406968
  413164
  415926
  417990
  421492
  422255
  422261
  422498
  426940
  430832
  430834
  431511
  431750
  432368
  433718
  434189
  434239
  434251
  434257
  435768
  437336
  437338
  442380
  442410
  442469
  442991
  443151
  445302
  446087
  446183
  446967
  449716
  449893
  450175
  450804
  450848
  451423
  452338
  457463
  460248
  461350
  461727
  464332
  464442
  468945
  472166
  474776
  487435
  496112
  497517
  498342
  505518
  506127
  507895
  508436
  513121
  516637
  517933
  518856
  518859
  519016
  519826
  521410
  524171
  524910
  529722
  532044
  533963
  542090
  545492
  546116
  546199
  546622
  547909
  548844
  549236
  549836
  549844
  550330
  551028
  551923
  555803
  556966
  557557
  560392
  561447
  561467
  562993
  563208
  563643
  564565
  570405
  571746
  574231
  580956
  589682
  591144
  591356
  595956
  598375
  598483
  606791
  609825
  621676
  621734
  644189
  680838
  714457
  714752
  748241
  770127
  796184
  799951
  814912
  816073
]
16.77 ms
(4.25%)
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
  644189
  595956
  591144
  796184
  609825
  400126
  442991
  415926
  437338
  413164
  816073
  457463
  449893
  472166
  446967
  452338
  498342
  516637
  521410
  545492
  571746
  546622
  563208
  564565
  570405
  555803
  680838
  549836
  556966
  591356
  621676
  598375
  598483
  589682
  799951
  748241
  770127
  621734
  404644
  432368
  431750
  437336
  468945
  426940
  450804
  513121
  497517
  518859
  550330
  714752
  519016
  430834
  464442
  487435
  431511
  549844
  563643
  606791
  714457
  398394
  400171
  403109
  430832
  422255
  434189
  434239
  442380
  406968
  434257
  435768
  421492
  443151
  417990
  422261
  422498
  433718
  434251
  442410
  442469
  445302
  814912
  446183
  450175
  474776
  446087
  449716
  460248
  461350
  450848
  451423
  507895
  508436
  518856
  519826
  506127
  517933
  529722
  496112
  505518
  524171
  524910
  532044
  533963
  461727
  464332
  542090
  549236
  561447
  546116
  547909
  548844
  551028
  551923
  574231
  580956
  546199
  557557
  560392
  561467
  562993
]
3.44 ms
(0.87%)
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
  398394
  400126
  400171
  403109
  404644
  406968
  413164
  415926
  417990
  421492
  422255
  422261
  422498
  426940
  430832
  430834
  431511
  431750
  432368
  433718
  434189
  434239
  434251
  434257
  435768
  437336
  437338
  442380
  442410
  442469
  442991
  443151
  445302
  446087
  446183
  446967
  449716
  449893
  450175
  450804
  450848
  451423
  452338
  457463
  460248
  461350
  461727
  464332
  464442
  468945
  472166
  474776
  487435
  496112
  497517
  498342
  505518
  506127
  507895
  508436
  513121
  516637
  517933
  518856
  518859
  519016
  519826
  521410
  524171
  524910
  529722
  532044
  533963
  542090
  545492
  546116
  546199
  546622
  547909
  548844
  549236
  549836
  549844
  550330
  551028
  551923
  555803
  556966
  557557
  560392
  561447
  561467
  562993
  563208
  563643
  564565
  570405
  571746
  574231
  580956
  589682
  591144
  591356
  595956
  598375
  598483
  606791
  609825
  621676
  621734
  644189
  680838
  714457
  714752
  748241
  770127
  796184
  799951
  814912
  816073
]
2.15 ms
(0.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "step mom ass"
]
2.04 ms
(0.52%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.03 ms
(0.51%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "step mom жоп"
]
1.64 ms
(0.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "step mom жоп"
]

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.