Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.33 ms
(84.78%)
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
  382083
  392540
  396588
  401836
  404276
  405082
  406168
  408319
  410231
  411838
  411846
  416571
  416616
  416634
  416683
  421869
  423039
  423120
  437839
  439452
  443879
  447356
  447906
  447947
  449688
  453597
  453797
  456369
  457189
  459004
  464171
  464614
  470408
  471716
  474600
  477556
  483427
  484931
  487868
  488549
  488852
  488959
  491769
  492557
  493332
  494196
  501230
  502809
  504623
  505155
  505885
  507627
  508605
  511467
  512002
  512652
  514279
  517975
  518323
  519403
  519618
  519652
  520194
  520336
  520483
  520509
  523960
  525680
  525844
  526939
  529075
  531209
  532962
  534665
  540456
  549270
  555140
  556502
  556523
  560393
  560449
  565418
  566059
  573337
  575272
  579624
  580405
  580597
  580914
  586917
  587434
  590813
  592417
  596063
  596753
  598872
  604238
  611562
  614742
  622893
  623623
  623724
  625144
  626243
  634202
  644038
  654591
  680709
  687500
  696202
  704236
  713565
  721728
  725206
  727041
  728324
  743928
  744704
  788543
  789002
]
16.54 ms
(9.99%)
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
  484931
  517975
  519403
  519652
  520336
  520483
  493332
  508605
  382083
  396588
  401836
  423039
  408319
  416634
  423120
  439452
  443879
  411838
  416571
  580597
  457189
  483427
  447356
  464171
  477556
  491769
  456369
  464614
  534665
  504623
  526939
  525680
  511467
  520509
  488852
  573337
  560449
  565418
  566059
  680709
  696202
  713565
  654591
  721728
  549270
  556523
  611562
  587434
  604238
  623623
  586917
  596753
  622893
  626243
  728324
  743928
  788543
  447906
  459004
  411846
  416616
  421869
  471716
  405082
  406168
  416683
  470408
  505885
  512002
  518323
  487868
  494196
  505155
  512652
  525844
  529075
  488959
  501230
  519618
  488549
  492557
  502809
  507627
  514279
  523960
  392540
  410231
  437839
  453797
  447947
  449688
  520194
  532962
  540456
  531209
  575272
  579624
  580914
  560393
  687500
  555140
  556502
  580405
  592417
  634202
  590813
  596063
  598872
  614742
  625144
  623724
  644038
  725206
  727041
  744704
  704236
  789002
  453597
  474600
  404276
]
2.29 ms
(1.38%)
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
  382083
  392540
  396588
  401836
  404276
  405082
  406168
  408319
  410231
  411838
  411846
  416571
  416616
  416634
  416683
  421869
  423039
  423120
  437839
  439452
  443879
  447356
  447906
  447947
  449688
  453597
  453797
  456369
  457189
  459004
  464171
  464614
  470408
  471716
  474600
  477556
  483427
  484931
  487868
  488549
  488852
  488959
  491769
  492557
  493332
  494196
  501230
  502809
  504623
  505155
  505885
  507627
  508605
  511467
  512002
  512652
  514279
  517975
  518323
  519403
  519618
  519652
  520194
  520336
  520483
  520509
  523960
  525680
  525844
  526939
  529075
  531209
  532962
  534665
  540456
  549270
  555140
  556502
  556523
  560393
  560449
  565418
  566059
  573337
  575272
  579624
  580405
  580597
  580914
  586917
  587434
  590813
  592417
  596063
  596753
  598872
  604238
  611562
  614742
  622893
  623623
  623724
  625144
  626243
  634202
  644038
  654591
  680709
  687500
  696202
  704236
  713565
  721728
  725206
  727041
  728324
  743928
  744704
  788543
  789002
]
1.75 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "does"
]
1.71 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "does"
]
1.58 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.33 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "does"
]

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.