Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.49 ms
(86.96%)
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
  4324
  47128
  351702
  354774
  381919
  385788
  386796
  423922
  457230
  458524
  478767
  495201
  505706
  513184
  521969
  530563
  537619
  546150
  551009
  553206
  567477
  574964
  594118
  594547
  598028
  602366
  606670
  610862
  612577
  615256
  616783
  618729
  619393
  620685
  621615
  626678
  627618
  628184
  630222
  630345
  630920
  632784
  639111
  639895
  649034
  650881
  660622
  662860
  665827
  672867
  678850
  679564
  687665
  690946
  691155
  692248
  693028
  695283
  696354
  696665
  696687
  696698
  698421
  698476
  707076
  707214
  707512
  712166
  715872
  717137
  722336
  723902
  728480
  729354
  730052
  732216
  732840
  734461
  736112
  738121
  741877
  744610
  745859
  745884
  748117
  759608
  760461
  764245
  764699
  770423
  772672
  778075
  778839
  782613
  783752
  784130
  784480
  784844
  787330
  788464
  791010
  795833
  800380
  801538
  802483
  803162
  803425
  810904
  811468
  812178
  812267
  817264
  818005
  820666
  822991
  823088
  823089
  823720
  828845
]
11.21 ms
(6.99%)
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
  650881
  660622
  665827
  707076
  610862
  627618
  619393
  621615
  594547
  788464
  803425
  812178
  732840
  770423
  748117
  730052
  764245
  615256
  632784
  698421
  812267
  381919
  521969
  351702
  4324
  818005
  820666
  823088
  823089
  530563
  505706
  513184
  478767
  574964
  551009
  692248
  696698
  707214
  707512
  672867
  678850
  687665
  696665
  712166
  722336
  662860
  693028
  695283
  546150
  553206
  567477
  602366
  612577
  606670
  639111
  620685
  626678
  639895
  594118
  618729
  784844
  795833
  778839
  782613
  810904
  723902
  732216
  745884
  764699
  772672
  784480
  787330
  745859
  759608
  728480
  767117
  744610
  696687
  698476
  791010
  801538
  802483
  423922
  495201
  47128
  628184
  823720
  800380
  630222
  630920
  457230
  458524
  760461
  822991
  828845
  537619
  690946
  679564
  715872
  649034
  691155
  696354
  598028
  616783
  630345
  778075
  803162
  811468
  734461
  784130
  741877
  729354
  736112
  738121
  717137
  783752
  385788
  354774
  386796
  817264
]
2.73 ms
(1.70%)
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
  4324
  47128
  351702
  354774
  381919
  385788
  386796
  423922
  457230
  458524
  478767
  495201
  505706
  513184
  521969
  530563
  537619
  546150
  551009
  553206
  567477
  574964
  594118
  594547
  598028
  602366
  606670
  610862
  612577
  615256
  616783
  618729
  619393
  620685
  621615
  626678
  627618
  628184
  630222
  630345
  630920
  632784
  639111
  639895
  649034
  650881
  660622
  662860
  665827
  672867
  678850
  679564
  687665
  690946
  691155
  692248
  693028
  695283
  696354
  696665
  696687
  696698
  698421
  698476
  707076
  707214
  707512
  712166
  715872
  717137
  722336
  723902
  728480
  729354
  730052
  732216
  732840
  734461
  736112
  738121
  741877
  744610
  745859
  745884
  748117
  759608
  760461
  764245
  764699
  770423
  772672
  778075
  778839
  782613
  783752
  784130
  784480
  784844
  787330
  788464
  791010
  795833
  800380
  801538
  802483
  803162
  803425
  810904
  811468
  812178
  812267
  817264
  818005
  820666
  822991
  823088
  823089
  823720
  828845
]
1.96 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fuck video"
]
1.80 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс video"
]
1.46 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс video"
]

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.