Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
163.86 ms
(87.73%)
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
  401101
  424125
  425990
  426529
  426552
  426988
  433066
  433291
  433350
  442107
  443896
  446500
  450854
  453265
  453377
  455407
  456603
  457441
  460305
  464132
  464484
  464705
  464884
  470459
  475489
  482549
  484633
  486046
  486610
  486903
  492714
  493426
  496975
  501733
  511015
  513687
  513971
  515018
  516328
  517528
  519766
  522041
  527986
  535638
  536956
  537464
  546638
  549108
  555114
  555124
  555233
  556806
  557240
  560666
  562964
  563175
  566854
  573388
  579586
  580628
  580750
  584034
  586293
  586376
  591968
  602959
  604138
  604658
  623211
  680328
  698733
  708865
  719968
  731126
  737561
  758075
  760953
  762915
  765359
  765493
  765835
  767061
  767078
  767135
  767701
  770331
  770417
  777359
  778949
  784225
  787013
  787155
  788011
  791270
  796048
  796527
  800429
  800600
  803347
  804927
  805434
  805557
  810305
  813422
  813627
  814359
  814386
  814417
  815022
  815118
  815121
  815366
  816596
  817255
  817283
  817785
  818948
  820550
  820656
  823510
]
13.60 ms
(7.28%)
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
  796048
  719968
  767061
  464705
  814417
  511015
  537464
  549108
  708865
  584034
  604658
  787155
  778949
  791270
  765493
  424125
  820656
  813627
  817283
  817785
  820550
  815022
  815118
  817255
  815366
  816596
  818948
  522041
  535638
  698733
  546638
  777359
  784225
  803347
  767135
  787013
  788011
  800600
  810305
  760953
  765835
  770417
  758075
  762915
  765359
  767078
  770331
  426988
  731126
  426529
  555124
  486903
  516328
  517528
  527986
  555233
  556806
  562964
  580750
  602959
  433291
  464484
  433350
  456603
  464132
  496975
  484633
  623211
  815121
  591968
  805557
  804927
  513971
  426552
  455407
  453265
  425990
  482549
  501733
  515018
  555114
  563175
  566854
  579586
  560666
  573388
  586293
  470459
  457441
  493426
  513687
  492714
  433066
  475489
  464884
  401101
  486610
  443896
  442107
  814359
  814386
  823510
  446500
  450854
  486046
  453377
  519766
  536956
  460305
  580628
  557240
  680328
  586376
  604138
  805434
  813422
  737561
  767701
  796527
  800429
]
2.80 ms
(1.50%)
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
  401101
  424125
  425990
  426529
  426552
  426988
  433066
  433291
  433350
  442107
  443896
  446500
  450854
  453265
  453377
  455407
  456603
  457441
  460305
  464132
  464484
  464705
  464884
  470459
  475489
  482549
  484633
  486046
  486610
  486903
  492714
  493426
  496975
  501733
  511015
  513687
  513971
  515018
  516328
  517528
  519766
  522041
  527986
  535638
  536956
  537464
  546638
  549108
  555114
  555124
  555233
  556806
  557240
  560666
  562964
  563175
  566854
  573388
  579586
  580628
  580750
  584034
  586293
  586376
  591968
  602959
  604138
  604658
  623211
  680328
  698733
  708865
  719968
  731126
  737561
  758075
  760953
  762915
  765359
  765493
  765835
  767061
  767078
  767135
  767701
  770331
  770417
  777359
  778949
  784225
  787013
  787155
  788011
  791270
  796048
  796527
  800429
  800600
  803347
  804927
  805434
  805557
  810305
  813422
  813627
  814359
  814386
  814417
  815022
  815118
  815121
  815366
  816596
  817255
  817283
  817785
  818948
  820550
  820656
  823510
]
1.82 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature anal pov"
]
1.68 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature анал пов"
]
1.57 ms
(0.84%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature анал пов"
]

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.