Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.87 ms
(83.05%)
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
  16808
  30208
  54085
  70167
  79570
  118317
  132836
  150305
  163096
  174164
  184735
  188621
  193837
  222010
  229210
  233433
  261001
  381944
  382098
  383073
  383582
  384594
  385206
  385484
  385619
  386586
  386879
  387275
  387693
  388274
  389091
  390499
  395222
  395806
  396596
  396782
  396949
  397401
  397424
  397591
  400942
  401160
  401250
  407187
  408596
  408905
  409150
  410235
  411913
  413257
  413709
  413731
  415354
  417720
  417807
  422369
  422414
  423129
  426279
  426298
  427162
  427466
  429275
  430380
  430566
  435520
  439011
  441037
  441315
  441921
  445041
  445080
  445509
  445529
  446316
  446643
  449168
  449582
  451106
  452249
  453303
  453573
  454570
  454783
  457558
  457594
  457749
  458042
  458110
  458264
  458272
  458446
  459241
  459247
  461241
  461672
  461676
  464964
  466848
  467105
  467230
  468853
  471600
  473523
  473786
  476892
  478059
  485422
  486508
  488791
  489853
  498155
  512814
  513691
  515408
  515670
  516977
  517355
  536398
  818004
]
17.17 ms
(10.20%)
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
  384594
  385484
  396949
  401160
  415354
  427466
  446643
  16808
  118317
  150305
  229210
  383073
  388274
  395806
  401250
  408905
  413257
  422414
  435520
  445529
  452249
  454570
  467230
  408596
  445080
  464964
  515408
  485422
  513691
  486508
  498155
  516977
  536398
  488791
  512814
  515670
  517355
  417720
  54085
  385619
  386586
  383582
  385206
  222010
  163096
  174164
  132836
  193837
  233433
  188621
  184735
  395222
  261001
  381944
  382098
  70167
  79570
  30208
  389091
  386879
  387275
  390499
  387693
  396596
  396782
  397401
  397424
  397591
  400942
  409150
  426298
  430380
  430566
  445041
  423129
  441921
  407187
  413731
  426279
  441037
  441315
  410235
  422369
  427162
  411913
  413709
  417807
  429275
  439011
  818004
  445509
  453303
  457558
  457594
  458446
  461241
  461676
  468853
  471600
  473786
  476892
  478059
  489853
  449582
  453573
  454783
  458042
  458110
  458264
  459247
  466848
  467105
  446316
  449168
  451106
  457749
  458272
  459241
  461672
  473523
]
3.49 ms
(2.08%)
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
  16808
  30208
  54085
  70167
  79570
  118317
  132836
  150305
  163096
  174164
  184735
  188621
  193837
  222010
  229210
  233433
  261001
  381944
  382098
  383073
  383582
  384594
  385206
  385484
  385619
  386586
  386879
  387275
  387693
  388274
  389091
  390499
  395222
  395806
  396596
  396782
  396949
  397401
  397424
  397591
  400942
  401160
  401250
  407187
  408596
  408905
  409150
  410235
  411913
  413257
  413709
  413731
  415354
  417720
  417807
  422369
  422414
  423129
  426279
  426298
  427162
  427466
  429275
  430380
  430566
  435520
  439011
  441037
  441315
  441921
  445041
  445080
  445509
  445529
  446316
  446643
  449168
  449582
  451106
  452249
  453303
  453573
  454570
  454783
  457558
  457594
  457749
  458042
  458110
  458264
  458272
  458446
  459241
  459247
  461241
  461672
  461676
  464964
  466848
  467105
  467230
  468853
  471600
  473523
  473786
  476892
  478059
  485422
  486508
  488791
  489853
  498155
  512814
  513691
  515408
  515670
  516977
  517355
  536398
  818004
]
2.16 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "порно сочных"
]
1.99 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "порн шикарные"
]
1.89 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "порн шикарные"
]
1.82 ms
(1.08%)
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.