Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.17 ms
(86.60%)
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
  2291
  53396
  239677
  370875
  383343
  383373
  383638
  384285
  395170
  410318
  416708
  425564
  433561
  435321
  435724
  440897
  448512
  453032
  455782
  455967
  457820
  458124
  458995
  461232
  461813
  464116
  466562
  469519
  477892
  481757
  483209
  485225
  486288
  487359
  490074
  495239
  498903
  504131
  504208
  504280
  506077
  509217
  511820
  512143
  512626
  512636
  514210
  518600
  520829
  522445
  522491
  525324
  526444
  527301
  527305
  532309
  536207
  540428
  542097
  542831
  546381
  550357
  553964
  556403
  556880
  559216
  559441
  560302
  562410
  566573
  568445
  570197
  573395
  574544
  576445
  577058
  577534
  579128
  582336
  583645
  584463
  584619
  588170
  592719
  595275
  597258
  598033
  599155
  601210
  602753
  605683
  606649
  607262
  611005
  624222
  629940
  630909
  645971
  650757
  661915
  677942
  684383
  694154
  703212
  703494
  712636
  720878
  730072
  732648
  736369
  738532
  741578
  757110
  785110
  792088
  809076
  813227
  814958
  814987
  820780
]
14.50 ms
(8.04%)
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
  457820
  481757
  504131
  509217
  512636
  518600
  483209
  486288
  498903
  504280
  512143
  512626
  514210
  522491
  525324
  495239
  522445
  527305
  504208
  383343
  383373
  239677
  395170
  370875
  53396
  425564
  435321
  410318
  440897
  814987
  820780
  814958
  448512
  453032
  455967
  469519
  487359
  466562
  477892
  485225
  490074
  506077
  520829
  526444
  527301
  536207
  540428
  532309
  511820
  464116
  542831
  546381
  556403
  559216
  560302
  568445
  576445
  577534
  584463
  542097
  559441
  573395
  574544
  566573
  570197
  583645
  677942
  650757
  703212
  712636
  645971
  661915
  684383
  694154
  703494
  720878
  550357
  553964
  556880
  562410
  577058
  579128
  582336
  584619
  592719
  601210
  611005
  597258
  624222
  605683
  588170
  595275
  598033
  599155
  606649
  607262
  785110
  792088
  809076
  757110
  732648
  736369
  738532
  730072
  741578
  602753
  629940
  630909
  813227
  416708
  435724
  458124
  458995
  2291
  383638
  384285
  433561
  455782
  461232
  461813
]
3.04 ms
(1.69%)
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
  2291
  53396
  239677
  370875
  383343
  383373
  383638
  384285
  395170
  410318
  416708
  425564
  433561
  435321
  435724
  440897
  448512
  453032
  455782
  455967
  457820
  458124
  458995
  461232
  461813
  464116
  466562
  469519
  477892
  481757
  483209
  485225
  486288
  487359
  490074
  495239
  498903
  504131
  504208
  504280
  506077
  509217
  511820
  512143
  512626
  512636
  514210
  518600
  520829
  522445
  522491
  525324
  526444
  527301
  527305
  532309
  536207
  540428
  542097
  542831
  546381
  550357
  553964
  556403
  556880
  559216
  559441
  560302
  562410
  566573
  568445
  570197
  573395
  574544
  576445
  577058
  577534
  579128
  582336
  583645
  584463
  584619
  588170
  592719
  595275
  597258
  598033
  599155
  601210
  602753
  605683
  606649
  607262
  611005
  624222
  629940
  630909
  645971
  650757
  661915
  677942
  684383
  694154
  703212
  703494
  712636
  720878
  730072
  732648
  736369
  738532
  741578
  757110
  785110
  792088
  809076
  813227
  814958
  814987
  820780
]
1.84 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hot riding"
]
1.77 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hot riding"
]
1.66 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.36 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hot riding"
]

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.