Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.14 ms
(83.30%)
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
  402772
  417259
  417790
  418797
  418996
  425541
  426014
  426701
  427472
  428457
  428466
  428734
  429738
  437325
  442410
  442464
  442465
  446042
  446914
  447188
  450765
  451636
  452676
  455177
  458332
  459676
  464475
  464485
  475105
  475815
  482305
  484153
  499993
  500670
  508690
  508946
  513364
  522841
  526423
  527769
  539628
  546142
  546906
  549148
  553031
  554579
  556325
  557688
  558583
  559443
  565043
  566293
  572261
  572899
  574618
  584739
  585761
  591351
  602671
  609151
  613784
  626299
  626366
  668457
  677135
  680852
  684852
  690942
  692180
  692372
  693355
  726790
  734932
  737983
  759105
  761101
  761959
  762090
  764621
  766370
  768155
  768527
  768818
  772850
  777755
  778326
  778927
  781073
  783794
  784762
  788374
  791644
  794712
  797837
  798869
  802491
  802510
  802752
  803727
  810880
  818295
  818709
  819367
  819825
  819865
  819916
  819918
  819919
  819933
  820403
  820516
  821170
  821750
  824571
  824643
  824890
  825708
  825852
  827470
]
16.86 ms
(10.02%)
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
  584739
  475105
  553031
  591351
  499993
  427472
  459676
  446042
  692180
  418797
  526423
  418996
  437325
  417259
  513364
  761101
  539628
  819933
  827470
  428466
  508946
  820516
  426701
  451636
  429738
  508690
  484153
  802752
  821170
  819916
  819825
  585761
  759105
  768527
  737983
  428457
  442464
  455177
  450765
  574618
  426014
  775265
  802491
  609151
  559443
  464475
  522841
  572261
  556325
  626366
  602671
  464485
  425541
  819918
  680852
  546142
  797837
  803727
  766370
  772850
  402772
  810880
  802510
  452676
  819865
  820403
  824643
  818295
  821750
  825852
  447188
  692372
  668457
  781073
  791644
  798869
  764621
  626299
  777755
  572899
  554579
  734932
  442465
  428734
  442410
  475815
  458332
  500670
  546906
  417790
  446914
  482305
  558583
  565043
  824571
  824890
  819919
  825708
  819367
  818709
  527769
  549148
  557688
  566293
  693355
  677135
  684852
  690942
  613784
  778927
  783794
  778326
  794712
  784762
  788374
  726790
  761959
  762090
  768818
  768155
]
2.70 ms
(1.61%)
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
  402772
  417259
  417790
  418797
  418996
  425541
  426014
  426701
  427472
  428457
  428466
  428734
  429738
  437325
  442410
  442464
  442465
  446042
  446914
  447188
  450765
  451636
  452676
  455177
  458332
  459676
  464475
  464485
  475105
  475815
  482305
  484153
  499993
  500670
  508690
  508946
  513364
  522841
  526423
  527769
  539628
  546142
  546906
  549148
  553031
  554579
  556325
  557688
  558583
  559443
  565043
  566293
  572261
  572899
  574618
  584739
  585761
  591351
  602671
  609151
  613784
  626299
  626366
  668457
  677135
  680852
  684852
  690942
  692180
  692372
  693355
  726790
  734932
  737983
  759105
  761101
  761959
  762090
  764621
  766370
  768155
  768527
  768818
  772850
  777755
  778326
  778927
  781073
  783794
  784762
  788374
  791644
  794712
  797837
  798869
  802491
  802510
  802752
  803727
  810880
  818295
  818709
  819367
  819825
  819865
  819916
  819918
  819919
  819933
  820403
  820516
  821170
  821750
  824571
  824643
  824890
  825708
  825852
  827470
]
2.56 ms
(1.52%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.23 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pov sleeping"
]
2.03 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов спящ"
]
1.71 ms
(1.02%)
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.