Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.70 ms
(84.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
  31708
  61051
  118098
  118316
  185334
  185563
  205011
  205251
  322773
  383162
  384460
  385105
  386068
  386953
  389346
  390185
  390219
  390249
  401871
  404817
  406578
  408043
  411009
  412749
  413302
  415950
  416144
  419139
  419729
  421310
  422658
  423023
  423042
  423258
  423261
  423283
  425452
  427299
  428960
  429660
  431427
  431716
  435727
  443992
  448328
  448353
  451890
  451961
  460951
  464616
  469549
  493852
  496441
  497448
  497453
  509776
  510589
  511837
  515884
  516452
  538333
  539192
  543501
  545484
  551999
  552000
  552198
  556374
  557266
  557820
  559160
  559919
  564797
  565479
  565943
  565945
  565946
  582908
  583213
  593227
  593481
  600602
  610201
  610365
  612210
  615923
  618319
  619427
  619487
  621025
  622646
  623509
  623543
  623955
  628175
  634755
  634756
  653240
  669216
  670526
  673971
  702582
  708301
  708768
  712166
  713474
  713477
  718994
  730875
  737132
  743426
  761580
  768391
  772394
  803896
  810016
  815015
  816830
  816856
  819172
]
15.60 ms
(9.48%)
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
  435727
  427299
  565946
  539192
  552198
  628175
  384460
  429660
  118316
  511837
  819172
  509776
  493852
  61051
  389346
  205011
  416144
  386953
  390185
  386068
  390249
  401871
  593481
  118098
  713477
  404817
  516452
  185334
  412749
  469549
  772394
  713474
  718994
  619427
  622646
  185563
  464616
  618319
  451890
  815015
  515884
  669216
  712166
  623955
  623509
  816856
  497448
  413302
  408043
  448328
  423023
  583213
  634756
  810016
  737132
  322773
  460951
  390219
  205251
  31708
  451961
  543501
  565945
  612210
  615923
  653240
  593227
  743426
  552000
  708301
  551999
  610365
  634755
  557820
  621025
  673971
  816830
  431427
  406578
  565943
  702582
  423261
  443992
  582908
  619487
  761580
  510589
  415950
  423283
  623543
  385105
  423258
  411009
  557266
  600602
  428960
  383162
  497453
  496441
  559160
  670526
  545484
  565479
  610201
  730875
  448353
  425452
  559919
  708768
  538333
  419139
  421310
  422658
  431716
  564797
  803896
  768391
  556374
  419729
  423042
]
2.59 ms
(1.57%)
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
  31708
  61051
  118098
  118316
  185334
  185563
  205011
  205251
  322773
  383162
  384460
  385105
  386068
  386953
  389346
  390185
  390219
  390249
  401871
  404817
  406578
  408043
  411009
  412749
  413302
  415950
  416144
  419139
  419729
  421310
  422658
  423023
  423042
  423258
  423261
  423283
  425452
  427299
  428960
  429660
  431427
  431716
  435727
  443992
  448328
  448353
  451890
  451961
  460951
  464616
  469549
  493852
  496441
  497448
  497453
  509776
  510589
  511837
  515884
  516452
  538333
  539192
  543501
  545484
  551999
  552000
  552198
  556374
  557266
  557820
  559160
  559919
  564797
  565479
  565943
  565945
  565946
  582908
  583213
  593227
  593481
  600602
  610201
  610365
  612210
  615923
  618319
  619427
  619487
  621025
  622646
  623509
  623543
  623955
  628175
  634755
  634756
  653240
  669216
  670526
  673971
  702582
  708301
  708768
  712166
  713474
  713477
  718994
  730875
  737132
  743426
  761580
  768391
  772394
  803896
  810016
  815015
  816830
  816856
  819172
]
2.39 ms
(1.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "asian oil"
]
1.87 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "азиатк масл"
]
1.83 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.