Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
170.78 ms
(87.58%)
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
  424284
  427233
  434688
  437809
  442472
  449854
  457571
  480314
  481121
  499169
  503999
  514627
  518383
  527052
  539797
  556716
  558865
  564652
  566393
  587747
  590042
  594632
  595716
  596450
  601588
  601970
  602768
  616236
  624684
  624961
  627656
  627754
  627758
  631116
  634892
  634950
  635125
  635129
  639092
  645391
  671193
  675160
  675180
  675618
  675628
  675828
  680573
  681952
  682376
  692651
  693398
  696231
  699892
  706754
  718351
  720010
  723227
  723264
  723713
  723817
  728667
  734445
  735307
  736252
  739140
  740220
  741266
  751322
  753099
  753998
  754986
  762739
  763946
  765197
  766519
  768983
  769043
  769258
  772280
  772404
  772523
  773463
  779619
  779688
  779721
  781188
  781591
  784356
  786355
  787312
  787579
  787611
  787842
  789120
  790188
  791263
  791873
  792730
  793199
  793237
  793289
  793700
  795471
  799446
  800180
  800953
  801074
  801182
  803648
  805235
  808107
  812860
  813647
  814090
  816132
  817263
  818552
  819372
]
15.38 ms
(7.89%)
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
  595716
  602768
  616236
  635125
  590042
  793289
  675628
  556716
  675618
  753099
  799446
  723264
  442472
  427233
  816132
  817263
  813647
  539797
  514627
  558865
  634892
  723713
  769258
  772280
  803648
  812860
  740220
  723817
  753998
  735307
  765197
  635129
  720010
  779619
  457571
  763946
  819372
  566393
  693398
  718351
  800180
  781188
  789120
  791873
  793199
  795471
  741266
  787842
  801074
  681952
  675180
  675828
  564652
  587747
  624961
  631116
  639092
  594632
  627754
  627656
  634950
  766519
  624684
  706754
  503999
  596450
  671193
  801182
  736252
  434688
  499169
  627758
  779721
  786355
  791263
  779688
  787611
  792730
  728667
  772404
  772523
  787312
  793700
  734445
  754986
  768983
  769043
  773463
  751322
  728648
  437809
  741836
  601588
  424284
  814090
  818552
  645391
  699892
  800953
  793237
  805235
  808107
  739140
  784356
  787579
  481121
  675160
  696231
  692651
  790188
  449854
  518383
  682376
  680573
  601970
  781591
  762739
  723227
  480314
  527052
]
2.61 ms
(1.34%)
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
  424284
  427233
  434688
  437809
  442472
  449854
  457571
  480314
  481121
  499169
  503999
  514627
  518383
  527052
  539797
  556716
  558865
  564652
  566393
  587747
  590042
  594632
  595716
  596450
  601588
  601970
  602768
  616236
  624684
  624961
  627656
  627754
  627758
  631116
  634892
  634950
  635125
  635129
  639092
  645391
  671193
  675160
  675180
  675618
  675628
  675828
  680573
  681952
  682376
  692651
  693398
  696231
  699892
  706754
  718351
  720010
  723227
  723264
  723713
  723817
  728667
  734445
  735307
  736252
  739140
  740220
  741266
  751322
  753099
  753998
  754986
  762739
  763946
  765197
  766519
  768983
  769043
  769258
  772280
  772404
  772523
  773463
  779619
  779688
  779721
  781188
  781591
  784356
  786355
  787312
  787579
  787611
  787842
  789120
  790188
  791263
  791873
  792730
  793199
  793237
  793289
  793700
  795471
  799446
  800180
  800953
  801074
  801182
  803648
  805235
  808107
  812860
  813647
  814090
  816132
  817263
  818552
  819372
]
1.75 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.79%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск passionate"
]
1.53 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade passionate"
]
1.42 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск passionate"
]

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.