Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.18 ms
(85.70%)
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
  205809
  384285
  384503
  384880
  385303
  386207
  386470
  386860
  387857
  392716
  393737
  398731
  399230
  399554
  399865
  400435
  400450
  400460
  400465
  400469
  403331
  403496
  413208
  417220
  418407
  418449
  419027
  443967
  446254
  453621
  453668
  463265
  464317
  468772
  470707
  470711
  470738
  470855
  473239
  503958
  515177
  519976
  522443
  524120
  530358
  530362
  530961
  537568
  541912
  544241
  549290
  549940
  549991
  556031
  557300
  562312
  571218
  581691
  593394
  597195
  607173
  618893
  621620
  622198
  624299
  624850
  625490
  628330
  641439
  656474
  657270
  658367
  663460
  665883
  676536
  676968
  677681
  678011
  682180
  684205
  684980
  685587
  693074
  694075
  701501
  712825
  716613
  716659
  717887
  722706
  722889
  722897
  723492
  730575
  730851
  731810
  732116
  732396
  738256
  743130
  744279
  744324
  748139
  752523
  755213
  775578
  775781
  788582
  788595
  789304
  789433
  792822
  812010
  812141
  812153
  818920
  823700
  824824
  825119
  827523
]
15.91 ms
(8.84%)
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
  716659
  722897
  812141
  446254
  470711
  473239
  384285
  418407
  470707
  470738
  503958
  818920
  824824
  823700
  625490
  775578
  544241
  657270
  549991
  205809
  399230
  443967
  515177
  684980
  701501
  622198
  624850
  792822
  732116
  744279
  744324
  775781
  400450
  399865
  393737
  386207
  384880
  392716
  400435
  400465
  403496
  417220
  419027
  413208
  825119
  468772
  470855
  463265
  581691
  571218
  677681
  694075
  722706
  557300
  597195
  607173
  618893
  788582
  812153
  743130
  731810
  732396
  755213
  723492
  400460
  399554
  418449
  400469
  453621
  398731
  530362
  530961
  549290
  665883
  658367
  678011
  682180
  685587
  656474
  812010
  730851
  730575
  621620
  387857
  384503
  530358
  541912
  684205
  712825
  628330
  641439
  738256
  789433
  537568
  549940
  789304
  624299
  722889
  788595
  386470
  386860
  385303
  403331
  827523
  453668
  464317
  522443
  524120
  519976
  562312
  676536
  676968
  716613
  693074
  717887
  663460
  556031
  593394
  748139
  752523
]
2.87 ms
(1.59%)
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
  205809
  384285
  384503
  384880
  385303
  386207
  386470
  386860
  387857
  392716
  393737
  398731
  399230
  399554
  399865
  400435
  400450
  400460
  400465
  400469
  403331
  403496
  413208
  417220
  418407
  418449
  419027
  443967
  446254
  453621
  453668
  463265
  464317
  468772
  470707
  470711
  470738
  470855
  473239
  503958
  515177
  519976
  522443
  524120
  530358
  530362
  530961
  537568
  541912
  544241
  549290
  549940
  549991
  556031
  557300
  562312
  571218
  581691
  593394
  597195
  607173
  618893
  621620
  622198
  624299
  624850
  625490
  628330
  641439
  656474
  657270
  658367
  663460
  665883
  676536
  676968
  677681
  678011
  682180
  684205
  684980
  685587
  693074
  694075
  701501
  712825
  716613
  716659
  717887
  722706
  722889
  722897
  723492
  730575
  730851
  731810
  732116
  732396
  738256
  743130
  744279
  744324
  748139
  752523
  755213
  775578
  775781
  788582
  788595
  789304
  789433
  792822
  812010
  812141
  812153
  818920
  823700
  824824
  825119
  827523
]
2.16 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girl young"
]
1.76 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк young"
]
1.63 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.39 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк young"
]

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.