Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.76 ms
(83.04%)
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
  15129
  134947
  187843
  233617
  271496
  383235
  391048
  397531
  397605
  405966
  410073
  411628
  411686
  411716
  411777
  411837
  411923
  411936
  411939
  413283
  413714
  415781
  416855
  422264
  422278
  422286
  422426
  425959
  426452
  426812
  427220
  432494
  433418
  433740
  435382
  435929
  437323
  437333
  437341
  437634
  439701
  440390
  440798
  441838
  442011
  442051
  442101
  442402
  443130
  443622
  443771
  445637
  445774
  446107
  448466
  449894
  450249
  450555
  450796
  452347
  452350
  453122
  453244
  453991
  454463
  454474
  454476
  455123
  455757
  455991
  456034
  456061
  458362
  460010
  461404
  462075
  462568
  463940
  464015
  470302
  471067
  474124
  476952
  477710
  479261
  482835
  484329
  487307
  489926
  490653
  491337
  492292
  493134
  499539
  501169
  501342
  503104
  503471
  509225
  514760
  514761
  517674
  519579
  520140
  520186
  522337
  524907
  525510
  527147
  550514
  563673
  567414
  569138
  574421
  605409
  624787
  756252
  813791
  814037
  814289
]
18.71 ms
(11.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
  462568
  391048
  462075
  413714
  476952
  461404
  490653
  492292
  519579
  499539
  522337
  501169
  187843
  411628
  411777
  433740
  437333
  422286
  450796
  456061
  460010
  514761
  520186
  509225
  517674
  524907
  527147
  574421
  550514
  567414
  756252
  233617
  443130
  479261
  422264
  432494
  471067
  426812
  442402
  484329
  525510
  503104
  503471
  443622
  456034
  569138
  624787
  520140
  425959
  443771
  439701
  470302
  477710
  445637
  813791
  514760
  563673
  415781
  501342
  605409
  383235
  134947
  271496
  15129
  397531
  397605
  405966
  411686
  411716
  411837
  411936
  413283
  422278
  437323
  441838
  410073
  433418
  442011
  442051
  442101
  427220
  411939
  422426
  435382
  437341
  440798
  411923
  416855
  426452
  435929
  437634
  440390
  814289
  814037
  445774
  446107
  449894
  450249
  450555
  452347
  453122
  453244
  453991
  454474
  454476
  455123
  455757
  455991
  458362
  463940
  464015
  474124
  482835
  487307
  489926
  491337
  493134
  448466
  452350
  454463
]
3.16 ms
(1.89%)
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
  15129
  134947
  187843
  233617
  271496
  383235
  391048
  397531
  397605
  405966
  410073
  411628
  411686
  411716
  411777
  411837
  411923
  411936
  411939
  413283
  413714
  415781
  416855
  422264
  422278
  422286
  422426
  425959
  426452
  426812
  427220
  432494
  433418
  433740
  435382
  435929
  437323
  437333
  437341
  437634
  439701
  440390
  440798
  441838
  442011
  442051
  442101
  442402
  443130
  443622
  443771
  445637
  445774
  446107
  448466
  449894
  450249
  450555
  450796
  452347
  452350
  453122
  453244
  453991
  454463
  454474
  454476
  455123
  455757
  455991
  456034
  456061
  458362
  460010
  461404
  462075
  462568
  463940
  464015
  470302
  471067
  474124
  476952
  477710
  479261
  482835
  484329
  487307
  489926
  490653
  491337
  492292
  493134
  499539
  501169
  501342
  503104
  503471
  509225
  514760
  514761
  517674
  519579
  520140
  520186
  522337
  524907
  525510
  527147
  550514
  563673
  567414
  569138
  574421
  605409
  624787
  756252
  813791
  814037
  814289
]
1.80 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм полная"
]
1.55 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сперм полная"
]
1.49 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
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.