Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.01 ms
(83.13%)
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
  383217
  383500
  385618
  389703
  390615
  393836
  401367
  401810
  403973
  412721
  414099
  415879
  416157
  416174
  416537
  424765
  427132
  431439
  438880
  442337
  443260
  444064
  444537
  444896
  448791
  449921
  452800
  454368
  454590
  455080
  456117
  460765
  469737
  476656
  476658
  483730
  498720
  500338
  505356
  518508
  518550
  524215
  526180
  529617
  529713
  530402
  531834
  531877
  532634
  534447
  534545
  534563
  534574
  536129
  540868
  545439
  545459
  548153
  552069
  561019
  564289
  568501
  574375
  574377
  574391
  580130
  583472
  586402
  586507
  589185
  592773
  594619
  595149
  598692
  609920
  616454
  616850
  624682
  628095
  628105
  628106
  640052
  648704
  648705
  648716
  648784
  660369
  660380
  662448
  670360
  671002
  672952
  676689
  681196
  708577
  712268
  715244
  721257
  728635
  735703
  739119
  739123
  749090
  750426
  751609
  752679
  758343
  759324
  770386
  788863
  791132
  792712
  792726
  794303
  806834
  806938
  814140
  814151
]
15.54 ms
(9.72%)
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
  598692
  415879
  443260
  438880
  424765
  444537
  452800
  455080
  448791
  460765
  469737
  483730
  505356
  534574
  500338
  662448
  648716
  586402
  416157
  427132
  518550
  401367
  412721
  431439
  416174
  414099
  540868
  476656
  454590
  534545
  531834
  531877
  532634
  529617
  534563
  536129
  530402
  574375
  574377
  583472
  545459
  561019
  574391
  660380
  660369
  670360
  672952
  715244
  580130
  592773
  589185
  594619
  624682
  628105
  609920
  616454
  749090
  806938
  739119
  750426
  752679
  735703
  751609
  758343
  628106
  788863
  456117
  403973
  524215
  588152
  628095
  444896
  721257
  739123
  766362
  759324
  548153
  545439
  518508
  526180
  393836
  444064
  385618
  401810
  728635
  712268
  794303
  416537
  442337
  814140
  814151
  449921
  476658
  529713
  568501
  671002
  648704
  708577
  564289
  792726
  770386
  791132
  792712
  806834
  383500
  390615
  389703
  454368
  498720
  534447
  616850
  552069
  383217
  648784
  648705
  676689
  681196
  586507
  640052
  595149
]
3.72 ms
(2.32%)
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
  383217
  383500
  385618
  389703
  390615
  393836
  401367
  401810
  403973
  412721
  414099
  415879
  416157
  416174
  416537
  424765
  427132
  431439
  438880
  442337
  443260
  444064
  444537
  444896
  448791
  449921
  452800
  454368
  454590
  455080
  456117
  460765
  469737
  476656
  476658
  483730
  498720
  500338
  505356
  518508
  518550
  524215
  526180
  529617
  529713
  530402
  531834
  531877
  532634
  534447
  534545
  534563
  534574
  536129
  540868
  545439
  545459
  548153
  552069
  561019
  564289
  568501
  574375
  574377
  574391
  580130
  583472
  586402
  586507
  589185
  592773
  594619
  595149
  598692
  609920
  616454
  616850
  624682
  628095
  628105
  628106
  640052
  648704
  648705
  648716
  648784
  660369
  660380
  662448
  670360
  671002
  672952
  676689
  681196
  708577
  712268
  715244
  721257
  728635
  735703
  739119
  739123
  749090
  750426
  751609
  752679
  758343
  759324
  770386
  788863
  791132
  792712
  792726
  794303
  806834
  806938
  814140
  814151
]
2.13 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur dildo"
]
2.10 ms
(1.31%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск дилд"
]
1.75 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.