Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
143.06 ms
(83.91%)
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
  25053
  47689
  48235
  96200
  96800
  123010
  123994
  129857
  152276
  209726
  382702
  383105
  385590
  388366
  388782
  388793
  388886
  389014
  390472
  392760
  393314
  394646
  394700
  395580
  395754
  396571
  396595
  398243
  398492
  399628
  399889
  409725
  411953
  420383
  422331
  427258
  430467
  443954
  444830
  461384
  477230
  515723
  551070
  580705
  596105
  600370
  603340
  609855
  612419
  612430
  613163
  615900
  618965
  622656
  623517
  628038
  630306
  633171
  641628
  646448
  670051
  671714
  672765
  673366
  692419
  694053
  694507
  697368
  705144
  713133
  722545
  723714
  727415
  728038
  731805
  732406
  735852
  746533
  746735
  748209
  748221
  749401
  759624
  760928
  768352
  773997
  775776
  775850
  775864
  775942
  784621
  787364
  787686
  788270
  788930
  796450
  798427
  801482
  802610
  804459
  814037
  815331
  815479
  815498
  817351
  817446
  818470
  818519
  818543
  819320
  819623
  820331
  820841
  821316
  822093
  822696
  822845
  824130
  827201
  827206
]
15.05 ms
(8.83%)
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
  692419
  694053
  694507
  705144
  713133
  722545
  670051
  671714
  672765
  673366
  697368
  551070
  580705
  612419
  615900
  633171
  596105
  600370
  603340
  612430
  609855
  618965
  622656
  628038
  641628
  775942
  788930
  798427
  775850
  775864
  796450
  801482
  802610
  723714
  746735
  748209
  748221
  773997
  787364
  787686
  727415
  749401
  759624
  746533
  760928
  731805
  732406
  735852
  728038
  768352
  613163
  623517
  630306
  775776
  784621
  788270
  804459
  396571
  129857
  427258
  152276
  390472
  461384
  646448
  477230
  515723
  385590
  96200
  383105
  123010
  123994
  209726
  393314
  394646
  394700
  392760
  395580
  395754
  382702
  47689
  25053
  48235
  96800
  388366
  388782
  388793
  388886
  389014
  396595
  398243
  399889
  398492
  399628
  409725
  420383
  444830
  430467
  422331
  443954
  411953
  815331
  817351
  817446
  818543
  822093
  822696
  822845
  824130
  815498
  819623
  827206
  827201
  819320
  820331
  820841
  821316
  814037
  815479
  818470
  818519
]
4.44 ms
(2.60%)
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
  25053
  47689
  48235
  96200
  96800
  123010
  123994
  129857
  152276
  209726
  382702
  383105
  385590
  388366
  388782
  388793
  388886
  389014
  390472
  392760
  393314
  394646
  394700
  395580
  395754
  396571
  396595
  398243
  398492
  399628
  399889
  409725
  411953
  420383
  422331
  427258
  430467
  443954
  444830
  461384
  477230
  515723
  551070
  580705
  596105
  600370
  603340
  609855
  612419
  612430
  613163
  615900
  618965
  622656
  623517
  628038
  630306
  633171
  641628
  646448
  670051
  671714
  672765
  673366
  692419
  694053
  694507
  697368
  705144
  713133
  722545
  723714
  727415
  728038
  731805
  732406
  735852
  746533
  746735
  748209
  748221
  749401
  759624
  760928
  768352
  773997
  775776
  775850
  775864
  775942
  784621
  787364
  787686
  788270
  788930
  796450
  798427
  801482
  802610
  804459
  814037
  815331
  815479
  815498
  817351
  817446
  818470
  818519
  818543
  819320
  819623
  820331
  820841
  821316
  822093
  822696
  822845
  824130
  827201
  827206
]
2.20 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "boobs group"
]
1.99 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.88 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "boobs group"
]
1.88 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "boobs group"
]

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.