Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.64 ms
(90.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
  184735
  311176
  365839
  383045
  386678
  392579
  398057
  403778
  416240
  418862
  419201
  420327
  421940
  423949
  424146
  425814
  437568
  441249
  442136
  444858
  447149
  450136
  450193
  453990
  454127
  462303
  470000
  470951
  471897
  472064
  478274
  479514
  479564
  483093
  487309
  490736
  496781
  498954
  506743
  514205
  514602
  520987
  521400
  522344
  525308
  526020
  529136
  535176
  535222
  535227
  538117
  538674
  542766
  542940
  543166
  543289
  544153
  545994
  546535
  552245
  552844
  553331
  554326
  555655
  556670
  557011
  557277
  557367
  563514
  566335
  567019
  567740
  567854
  568783
  571725
  571933
  574751
  575183
  576245
  577052
  577638
  578079
  584214
  589137
  589766
  589837
  591031
  591556
  591700
  591990
  593111
  598597
  600197
  601725
  605510
  607074
  608542
  611918
  613858
  614205
  615143
  615513
  623320
  624292
  626356
  628497
  629276
  634526
  641548
  646052
  654126
  662865
  676687
  685533
  686578
  723092
  736785
  783981
  794923
]
12.42 ms
(5.32%)
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
  567740
  567854
  576245
  591031
  589137
  593111
  629276
  311176
  365839
  441249
  487309
  471897
  472064
  535176
  535222
  506743
  514602
  526388
  529136
  521400
  526020
  557011
  563514
  577052
  574751
  542940
  543289
  566335
  568783
  577638
  676687
  545994
  591556
  607074
  614205
  623320
  634526
  589837
  600197
  608542
  783981
  601725
  421940
  392579
  490736
  403778
  419201
  420327
  418862
  424146
  416240
  447149
  450136
  450193
  470000
  479564
  483093
  453990
  538117
  496781
  546535
  542766
  553331
  578079
  544153
  557367
  571933
  686578
  556670
  557277
  591990
  598597
  613858
  615143
  591700
  605510
  736785
  641548
  479514
  423949
  425814
  444858
  498954
  514205
  454127
  522344
  398057
  442136
  646052
  723092
  383045
  478274
  437568
  470951
  525308
  628497
  554326
  543166
  552245
  571725
  589766
  611918
  386678
  520987
  538674
  535227
  555655
  575183
  584214
  552844
  662865
  654126
  685533
  567019
  624292
  626356
  794923
  615513
  462303
  184735
]
2.63 ms
(1.13%)
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
  184735
  311176
  365839
  383045
  386678
  392579
  398057
  403778
  416240
  418862
  419201
  420327
  421940
  423949
  424146
  425814
  437568
  441249
  442136
  444858
  447149
  450136
  450193
  453990
  454127
  462303
  470000
  470951
  471897
  472064
  478274
  479514
  479564
  483093
  487309
  490736
  496781
  498954
  506743
  514205
  514602
  520987
  521400
  522344
  525308
  526020
  529136
  535176
  535222
  535227
  538117
  538674
  542766
  542940
  543166
  543289
  544153
  545994
  546535
  552245
  552844
  553331
  554326
  555655
  556670
  557011
  557277
  557367
  563514
  566335
  567019
  567740
  567854
  568783
  571725
  571933
  574751
  575183
  576245
  577052
  577638
  578079
  584214
  589137
  589766
  589837
  591031
  591556
  591700
  591990
  593111
  598597
  600197
  601725
  605510
  607074
  608542
  611918
  613858
  614205
  615143
  615513
  623320
  624292
  626356
  628497
  629276
  634526
  641548
  646052
  654126
  662865
  676687
  685533
  686578
  723092
  736785
  783981
  794923
]
1.86 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "стоят секс"
]
1.83 ms
(0.78%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сто секс"
]
1.68 ms
(0.72%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.66%)
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.