Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
148.28 ms
(85.12%)
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
  122062
  233570
  391076
  391703
  394195
  395921
  400689
  405707
  417428
  418407
  432794
  439570
  443165
  453480
  454224
  454237
  455197
  462038
  462291
  462328
  462702
  463161
  463165
  464307
  465980
  466215
  466920
  470735
  470816
  471309
  473924
  474109
  474479
  475505
  476264
  476272
  477735
  477926
  479190
  481322
  484828
  485882
  490918
  491067
  491688
  496818
  501874
  503901
  503917
  505086
  512336
  513950
  515290
  523025
  524146
  524706
  526018
  526841
  529194
  545535
  545999
  550452
  559060
  560387
  567240
  567391
  570638
  574839
  575728
  576020
  576027
  576038
  576071
  577117
  580678
  595451
  595511
  595654
  595869
  597223
  598014
  598498
  598679
  598731
  600894
  601877
  603003
  603991
  626330
  672449
  703101
  712907
  714432
  714463
  714490
  714948
  718708
  721298
  722645
  723933
  727400
  728359
  732171
  736866
  740300
  749911
  749919
  782217
  782278
  791362
  800332
  800563
  805162
  805504
  807514
  807518
  820298
  820924
  823648
  825836
]
16.57 ms
(9.51%)
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
  432794
  462291
  463161
  471309
  477926
  391076
  391703
  470735
  476272
  481322
  503901
  491067
  529194
  550452
  466215
  474479
  439570
  464307
  496818
  718708
  712907
  714948
  603003
  595869
  598679
  600894
  626330
  595451
  595654
  805162
  736866
  749911
  749919
  466920
  417428
  503917
  559060
  603991
  233570
  823648
  825836
  820298
  782217
  820924
  574839
  576020
  576027
  576038
  576071
  577117
  570638
  575728
  714490
  714463
  722645
  545999
  567391
  580678
  597223
  598014
  598731
  601877
  595511
  800563
  723933
  791362
  805504
  727400
  728359
  740300
  703101
  714432
  800332
  395921
  400689
  473924
  475505
  462328
  465980
  454237
  462038
  476264
  443165
  524146
  501874
  513950
  485882
  490918
  491688
  524706
  526018
  484828
  523025
  526841
  394195
  122062
  672449
  418407
  598498
  560387
  453480
  477735
  479190
  462702
  405707
  782278
  454224
  515290
  463165
  455197
  474109
  505086
  512336
  567240
  545535
  732171
  807518
  470816
  807514
  721298
]
2.97 ms
(1.70%)
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
  122062
  233570
  391076
  391703
  394195
  395921
  400689
  405707
  417428
  418407
  432794
  439570
  443165
  453480
  454224
  454237
  455197
  462038
  462291
  462328
  462702
  463161
  463165
  464307
  465980
  466215
  466920
  470735
  470816
  471309
  473924
  474109
  474479
  475505
  476264
  476272
  477735
  477926
  479190
  481322
  484828
  485882
  490918
  491067
  491688
  496818
  501874
  503901
  503917
  505086
  512336
  513950
  515290
  523025
  524146
  524706
  526018
  526841
  529194
  545535
  545999
  550452
  559060
  560387
  567240
  567391
  570638
  574839
  575728
  576020
  576027
  576038
  576071
  577117
  580678
  595451
  595511
  595654
  595869
  597223
  598014
  598498
  598679
  598731
  600894
  601877
  603003
  603991
  626330
  672449
  703101
  712907
  714432
  714463
  714490
  714948
  718708
  721298
  722645
  723933
  727400
  728359
  732171
  736866
  740300
  749911
  749919
  782217
  782278
  791362
  800332
  800563
  805162
  805504
  807514
  807518
  820298
  820924
  823648
  825836
]
1.94 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian fuck young"
]
1.52 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск секс young"
]
1.50 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск секс young"
]
1.42 ms
(0.81%)
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.