Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.37 ms
(83.86%)
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
  187595
  188266
  232940
  233179
  274930
  305626
  382518
  385163
  386205
  386544
  388291
  388765
  390567
  390653
  393705
  396982
  398244
  398560
  398561
  402906
  405810
  406567
  407705
  407761
  407773
  407790
  407804
  411628
  411723
  411769
  411810
  411967
  420154
  432249
  443681
  449078
  451797
  453106
  460141
  462080
  462099
  462183
  466257
  468828
  471713
  474876
  475039
  476338
  479084
  482389
  483090
  483142
  483146
  487340
  487931
  488953
  499656
  502024
  506832
  511559
  515067
  524017
  525077
  526507
  534581
  545926
  548068
  549240
  554500
  557436
  561567
  563430
  582784
  598949
  605460
  610067
  620202
  623483
  624789
  647617
  663451
  663965
  664823
  665187
  665227
  665288
  665448
  667196
  667290
  667474
  667859
  667899
  668676
  678738
  692225
  712035
  712822
  715662
  719903
  725369
  728328
  728445
  739687
  741433
  748151
  748220
  770179
  774176
  780704
  780724
  781927
  781980
  782281
  789693
  802233
  802657
  806311
  807991
  816771
  818229
]
17.30 ms
(10.05%)
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
  789693
  725369
  748220
  770179
  802233
  802657
  739687
  748151
  728328
  774176
  741433
  781927
  781980
  782281
  806311
  807991
  187595
  407790
  476338
  233179
  386544
  460141
  466257
  474876
  411723
  462099
  232940
  388765
  398560
  411769
  386205
  385163
  188266
  393705
  274930
  305626
  382518
  388291
  390567
  390653
  396982
  398244
  398561
  402906
  405810
  406567
  407705
  407804
  411628
  432249
  407761
  420154
  443681
  407773
  411967
  411810
  816771
  818229
  453106
  482389
  483142
  487931
  449078
  451797
  462080
  475039
  488953
  468828
  483090
  502024
  511559
  515067
  534581
  499656
  524017
  525077
  506832
  526507
  462183
  471713
  479084
  483146
  487340
  557436
  561567
  563430
  582784
  545926
  549240
  554500
  665288
  665448
  667290
  667474
  668676
  678738
  712035
  715662
  647617
  664823
  665227
  667196
  667859
  667899
  712822
  663451
  663965
  665187
  692225
  719903
  548068
  610067
  623483
  624789
  605460
  620202
  598949
  780724
  780704
  728445
]
3.20 ms
(1.86%)
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
  187595
  188266
  232940
  233179
  274930
  305626
  382518
  385163
  386205
  386544
  388291
  388765
  390567
  390653
  393705
  396982
  398244
  398560
  398561
  402906
  405810
  406567
  407705
  407761
  407773
  407790
  407804
  411628
  411723
  411769
  411810
  411967
  420154
  432249
  443681
  449078
  451797
  453106
  460141
  462080
  462099
  462183
  466257
  468828
  471713
  474876
  475039
  476338
  479084
  482389
  483090
  483142
  483146
  487340
  487931
  488953
  499656
  502024
  506832
  511559
  515067
  524017
  525077
  526507
  534581
  545926
  548068
  549240
  554500
  557436
  561567
  563430
  582784
  598949
  605460
  610067
  620202
  623483
  624789
  647617
  663451
  663965
  664823
  665187
  665227
  665288
  665448
  667196
  667290
  667474
  667859
  667899
  668676
  678738
  692225
  712035
  712822
  715662
  719903
  725369
  728328
  728445
  739687
  741433
  748151
  748220
  770179
  774176
  780704
  780724
  781927
  781980
  782281
  789693
  802233
  802657
  806311
  807991
  816771
  818229
]
2.00 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "старые бабки"
]
1.97 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "старые бабушк"
]
1.81 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.51 ms
(0.88%)
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.