Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
150.49 ms
(83.39%)
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
  395742
  424862
  425512
  426294
  428126
  433339
  435454
  450687
  470436
  475986
  485149
  490797
  507944
  522409
  528096
  535559
  548637
  549270
  573382
  578108
  586672
  586677
  589146
  591701
  592189
  592210
  593497
  593781
  595722
  597849
  604068
  606873
  607926
  608428
  608444
  612346
  615895
  617472
  637418
  638248
  638550
  642190
  644813
  655833
  657529
  664368
  667842
  670276
  672622
  675638
  676427
  678908
  695347
  704339
  708909
  709705
  711673
  711946
  715853
  716112
  718203
  718264
  718311
  720037
  726196
  726812
  726836
  727673
  730422
  732256
  732262
  732293
  732782
  737728
  738758
  738771
  742579
  750603
  750608
  754774
  757042
  757329
  763559
  766745
  766760
  767252
  770520
  771155
  775090
  775175
  775195
  776602
  776857
  777073
  781959
  788251
  788808
  792602
  792630
  792884
  792892
  802458
  805876
  806050
  806072
  807692
  808447
  811451
  813382
  813388
  815357
  815451
  815592
  815699
  815847
  815875
  815897
  816547
  817928
  820578
]
17.88 ms
(9.91%)
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
  711673
  711946
  718264
  672622
  675638
  695347
  708909
  715853
  716112
  718311
  655833
  657529
  664368
  667842
  670276
  676427
  678908
  704339
  548637
  573382
  578108
  608444
  638248
  586672
  591701
  595722
  604068
  637418
  589146
  592210
  593497
  615895
  586677
  592189
  593781
  597849
  606873
  607926
  638550
  775090
  776857
  792884
  802458
  806072
  775175
  792892
  806050
  811451
  813388
  727673
  732262
  754774
  757042
  781959
  805876
  807692
  808447
  813382
  726812
  732256
  732782
  750608
  757329
  766745
  737728
  766760
  771155
  726196
  730422
  732293
  763559
  726836
  738758
  738771
  742579
  750603
  767252
  770520
  608428
  617472
  642190
  709705
  718203
  720037
  775195
  776602
  777073
  788251
  788808
  792602
  792630
  395742
  435454
  522409
  428126
  485149
  433339
  507944
  528096
  535559
  549270
  612346
  424862
  425512
  426294
  815357
  815897
  644813
  815592
  820578
  815451
  815699
  816547
  817928
  815847
  815875
  450687
  470436
  475986
  490797
]
4.49 ms
(2.49%)
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
  395742
  424862
  425512
  426294
  428126
  433339
  435454
  450687
  470436
  475986
  485149
  490797
  507944
  522409
  528096
  535559
  548637
  549270
  573382
  578108
  586672
  586677
  589146
  591701
  592189
  592210
  593497
  593781
  595722
  597849
  604068
  606873
  607926
  608428
  608444
  612346
  615895
  617472
  637418
  638248
  638550
  642190
  644813
  655833
  657529
  664368
  667842
  670276
  672622
  675638
  676427
  678908
  695347
  704339
  708909
  709705
  711673
  711946
  715853
  716112
  718203
  718264
  718311
  720037
  726196
  726812
  726836
  727673
  730422
  732256
  732262
  732293
  732782
  737728
  738758
  738771
  742579
  750603
  750608
  754774
  757042
  757329
  763559
  766745
  766760
  767252
  770520
  771155
  775090
  775175
  775195
  776602
  776857
  777073
  781959
  788251
  788808
  792602
  792630
  792884
  792892
  802458
  805876
  806050
  806072
  807692
  808447
  811451
  813382
  813388
  815357
  815451
  815592
  815699
  815847
  815875
  815897
  816547
  817928
  820578
]
2.47 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "негритянки длинные во…"
]
1.89 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "чернокожая длинные"
]
1.69 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "чернокожая длинные"
]
1.56 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.