Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.72 ms
(82.52%)
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
  388366
  390173
  396970
  398613
  399889
  406081
  414026
  415450
  416795
  445332
  458614
  464355
  467978
  468515
  478839
  482172
  484542
  490589
  494269
  496280
  496284
  496294
  496296
  496305
  496311
  513805
  517652
  521826
  524868
  526560
  528051
  531791
  532372
  534257
  534287
  542519
  549400
  554759
  556585
  562350
  565335
  580500
  580758
  584693
  586672
  586677
  589146
  589234
  589654
  591701
  592210
  593444
  593497
  594077
  595722
  597849
  601006
  601905
  605058
  606873
  608444
  609993
  610292
  612348
  618965
  630460
  636599
  638550
  641109
  644453
  649381
  650915
  651084
  664368
  667742
  667842
  670276
  672622
  682076
  693956
  714089
  714654
  715853
  716112
  720815
  732754
  738674
  740903
  775662
  787608
  792637
  792819
  792884
  795522
  796237
  799616
  799619
  800016
  800959
  801064
  801850
  802458
  805164
  806103
  808262
  810233
  814834
  814848
  815154
  815226
  815429
  815555
  815829
  815831
  815880
  818470
  821312
  821656
  822093
  824405
]
21.38 ms
(11.95%)
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
  649381
  714089
  714654
  720815
  682076
  609993
  593444
  630460
  636599
  594077
  618965
  641109
  589654
  610292
  805164
  775662
  792819
  795522
  806103
  740903
  787608
  796237
  799616
  800016
  801850
  808262
  810233
  732754
  738674
  644453
  792637
  799619
  800959
  801064
  415450
  396970
  398613
  406081
  490589
  478839
  484542
  458614
  542519
  605058
  494269
  612348
  517652
  388366
  390173
  399889
  414026
  416795
  445332
  822093
  814834
  814848
  815429
  815555
  815829
  815831
  815154
  815226
  815880
  818470
  821312
  821656
  824405
  467978
  482172
  464355
  496284
  496294
  496296
  513805
  521826
  528051
  534287
  496305
  524868
  531791
  526560
  532372
  496280
  496311
  534257
  468515
  556585
  565335
  549400
  554759
  562350
  584693
  580758
  693956
  650915
  672622
  715853
  716112
  651084
  664368
  667742
  667842
  670276
  580500
  608444
  586672
  591701
  595722
  601905
  589146
  589234
  592210
  593497
  601006
  586677
  597849
  606873
  638550
  792884
  802458
]
3.07 ms
(1.71%)
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
  388366
  390173
  396970
  398613
  399889
  406081
  414026
  415450
  416795
  445332
  458614
  464355
  467978
  468515
  478839
  482172
  484542
  490589
  494269
  496280
  496284
  496294
  496296
  496305
  496311
  513805
  517652
  521826
  524868
  526560
  528051
  531791
  532372
  534257
  534287
  542519
  549400
  554759
  556585
  562350
  565335
  580500
  580758
  584693
  586672
  586677
  589146
  589234
  589654
  591701
  592210
  593444
  593497
  594077
  595722
  597849
  601006
  601905
  605058
  606873
  608444
  609993
  610292
  612348
  618965
  630460
  636599
  638550
  641109
  644453
  649381
  650915
  651084
  664368
  667742
  667842
  670276
  672622
  682076
  693956
  714089
  714654
  715853
  716112
  720815
  732754
  738674
  740903
  775662
  787608
  792637
  792819
  792884
  795522
  796237
  799616
  799619
  800016
  800959
  801064
  801850
  802458
  805164
  806103
  808262
  810233
  814834
  814848
  815154
  815226
  815429
  815555
  815829
  815831
  815880
  818470
  821312
  821656
  822093
  824405
]
1.87 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ebony boobs"
]
1.81 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "чернокожая boobs"
]
1.57 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "чернокожая boobs"
]

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.