Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.48 ms
(56.71%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
128.03 ms
(34.66%)
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
  366011
  382610
  385469
  391704
  417692
  425541
  428456
  428539
  429036
  429738
  430393
  435275
  435315
  443712
  443719
  446269
  446622
  446916
  462510
  463225
  463771
  464294
  468013
  468781
  472439
  476352
  478879
  484499
  487718
  490763
  491796
  514789
  515129
  517997
  518865
  519981
  526390
  526483
  526768
  530365
  534025
  540256
  541882
  543825
  544305
  549310
  551042
  562961
  563860
  565650
  566307
  567009
  567628
  569962
  573939
  574216
  576127
  576413
  584524
  586930
  606709
  607215
  620025
  620983
  622622
  623338
  623353
  626330
  633516
  645011
  651165
  652258
  666848
  667013
  671396
  671630
  674731
  676122
  678971
  682071
  683008
  683460
  684223
  684259
  687270
  688592
  694436
  697296
  698045
  705258
  708102
  709428
  716470
  717641
  717681
  724824
  725531
  726555
  726703
  732466
  736696
  737628
  739327
  741467
  741904
  745055
  757367
  759553
  759557
  761103
  773547
  776468
  781709
  788151
  797905
  803144
  808012
  812264
  819916
  824446
]
22.57 ms
(6.11%)
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
  666848
  694436
  697296
  739327
  741904
  573939
  576413
  484499
  726555
  443712
  824446
  819916
  549310
  812264
  725531
  515129
  541882
  652258
  671630
  683460
  705258
  684259
  688592
  623353
  788151
  759557
  797905
  724824
  741467
  759553
  623338
  698045
  717681
  464294
  478879
  462510
  491796
  476352
  490763
  463771
  446622
  517997
  530365
  543825
  551042
  563860
  567628
  678971
  651165
  671396
  674731
  676122
  682071
  684223
  683008
  708102
  633516
  606709
  626330
  622622
  776468
  803144
  726703
  732466
  737628
  757367
  607215
  717641
  430393
  443719
  391704
  468013
  429036
  565650
  429738
  576127
  716470
  586930
  736696
  761103
  435315
  366011
  518865
  382610
  428539
  428456
  446916
  385469
  425541
  435275
  468781
  472439
  526390
  526483
  540256
  781709
  808012
  745055
  773547
  562961
  417692
  446269
  463225
  487718
  519981
  534025
  514789
  526768
  544305
  567009
  569962
  687270
  667013
  709428
  645011
  566307
  574216
  584524
  620025
  620983
]
4.17 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
  366011
  382610
  385469
  391704
  417692
  425541
  428456
  428539
  429036
  429738
  430393
  435275
  435315
  443712
  443719
  446269
  446622
  446916
  462510
  463225
  463771
  464294
  468013
  468781
  472439
  476352
  478879
  484499
  487718
  490763
  491796
  514789
  515129
  517997
  518865
  519981
  526390
  526483
  526768
  530365
  534025
  540256
  541882
  543825
  544305
  549310
  551042
  562961
  563860
  565650
  566307
  567009
  567628
  569962
  573939
  574216
  576127
  576413
  584524
  586930
  606709
  607215
  620025
  620983
  622622
  623338
  623353
  626330
  633516
  645011
  651165
  652258
  666848
  667013
  671396
  671630
  674731
  676122
  678971
  682071
  683008
  683460
  684223
  684259
  687270
  688592
  694436
  697296
  698045
  705258
  708102
  709428
  716470
  717641
  717681
  724824
  725531
  726555
  726703
  732466
  736696
  737628
  739327
  741467
  741904
  745055
  757367
  759553
  759557
  761103
  773547
  776468
  781709
  788151
  797905
  803144
  808012
  812264
  819916
  824446
]
1.84 ms
(0.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young sleep"
]
1.73 ms
(0.47%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young спящ"
]
1.59 ms
(0.43%)
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.