Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.37 ms
(85.76%)
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
  338311
  381919
  386796
  387446
  407592
  423922
  478348
  495201
  521969
  530346
  532038
  542479
  547339
  549781
  565991
  566419
  568312
  577308
  594547
  603690
  609643
  610421
  610862
  612763
  615256
  619393
  621615
  627618
  632784
  643765
  650881
  652658
  654239
  660622
  665827
  668133
  670712
  673488
  676775
  679375
  680096
  683484
  687021
  690012
  691497
  691998
  692463
  694073
  694555
  695236
  695242
  695247
  695620
  695928
  696687
  698421
  698476
  699779
  707076
  709425
  710410
  710620
  712582
  714596
  714947
  715964
  718687
  722179
  723902
  727951
  728480
  730052
  731361
  732216
  732840
  740147
  740673
  740770
  740839
  740893
  744610
  745440
  745859
  745884
  747426
  748117
  757934
  759608
  762764
  764245
  764699
  765751
  765993
  766062
  770423
  772672
  778839
  779436
  780764
  781100
  782613
  784480
  787330
  788464
  791010
  794752
  795833
  799968
  800600
  801538
  802483
  803425
  810262
  810904
  812178
  812267
  817264
  824804
  828110
]
12.42 ms
(7.76%)
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
  795833
  778839
  782613
  810904
  723902
  732216
  740770
  745884
  764699
  772672
  784480
  787330
  745859
  759608
  762764
  728480
  767117
  744610
  696687
  698476
  791010
  799968
  801538
  802483
  423922
  495201
  824804
  676775
  690012
  692463
  603690
  695236
  691497
  694555
  695620
  699779
  765751
  718687
  386796
  817264
  532038
  566419
  568312
  654239
  673488
  683484
  712582
  695928
  710620
  714596
  668133
  691998
  694073
  709425
  710410
  714947
  610421
  609643
  780764
  810262
  740147
  766062
  794752
  800600
  757934
  745440
  731361
  612763
  643765
  722179
  781100
  407592
  547339
  652658
  679375
  670712
  687021
  727951
  765993
  779436
  387446
  828110
  530346
  478348
  577308
  542479
  695242
  650881
  660622
  665827
  707076
  610862
  627618
  619393
  621615
  594547
  788464
  803425
  812178
  732840
  747426
  770423
  748117
  730052
  740673
  764245
  615256
  632784
  698421
  812267
  381919
  521969
  338311
  549781
  565991
  695247
  680096
  715964
  740839
  740893
]
2.70 ms
(1.69%)
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
  338311
  381919
  386796
  387446
  407592
  423922
  478348
  495201
  521969
  530346
  532038
  542479
  547339
  549781
  565991
  566419
  568312
  577308
  594547
  603690
  609643
  610421
  610862
  612763
  615256
  619393
  621615
  627618
  632784
  643765
  650881
  652658
  654239
  660622
  665827
  668133
  670712
  673488
  676775
  679375
  680096
  683484
  687021
  690012
  691497
  691998
  692463
  694073
  694555
  695236
  695242
  695247
  695620
  695928
  696687
  698421
  698476
  699779
  707076
  709425
  710410
  710620
  712582
  714596
  714947
  715964
  718687
  722179
  723902
  727951
  728480
  730052
  731361
  732216
  732840
  740147
  740673
  740770
  740839
  740893
  744610
  745440
  745859
  745884
  747426
  748117
  757934
  759608
  762764
  764245
  764699
  765751
  765993
  766062
  770423
  772672
  778839
  779436
  780764
  781100
  782613
  784480
  787330
  788464
  791010
  794752
  795833
  799968
  800600
  801538
  802483
  803425
  810262
  810904
  812178
  812267
  817264
  824804
  828110
]
2.20 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс секс video"
]
1.92 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс секс video"
]
1.79 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fuck sex 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.