Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.51 ms
(86.28%)
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
  50344
  109176
  389787
  398436
  400563
  401154
  408824
  410328
  446524
  449862
  480552
  488956
  493317
  500778
  513986
  526017
  530092
  530415
  530664
  530698
  537764
  540101
  541166
  541184
  541194
  542443
  542460
  547941
  550107
  550116
  550125
  550595
  554705
  554706
  554709
  554734
  557461
  566737
  570931
  573288
  580379
  580998
  592741
  602251
  607312
  608679
  611541
  618056
  621004
  625778
  627833
  640239
  648295
  649707
  651639
  652779
  652959
  660364
  661327
  661342
  661347
  661377
  661576
  662072
  669357
  669930
  670356
  672938
  680954
  681242
  692683
  692686
  692713
  692721
  692763
  696424
  705736
  708090
  709855
  713094
  732865
  735504
  736031
  738427
  742668
  744568
  746967
  751377
  751422
  754680
  768598
  768669
  770452
  773275
  779605
  780884
  783656
  784050
  784147
  786200
  787021
  787967
  788624
  789650
  792508
  798667
  799683
  805290
  805584
  811790
  812060
  812228
  812230
  812238
  814166
  816816
  819240
  825538
  827454
  827555
]
13.62 ms
(7.71%)
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
  661327
  627833
  602251
  530415
  554705
  692683
  786200
  746967
  480552
  554734
  742668
  681242
  735504
  513986
  573288
  488956
  408824
  692686
  580998
  389787
  672938
  550116
  640239
  449862
  625778
  530698
  580379
  669357
  670356
  410328
  554706
  541184
  705736
  649707
  661347
  680954
  621004
  784050
  773275
  768669
  661377
  692763
  692721
  661342
  669930
  550595
  618056
  738427
  754680
  787021
  812060
  50344
  819240
  540101
  541194
  542460
  708090
  812228
  783656
  799683
  651639
  660364
  805290
  805584
  784147
  652779
  446524
  751422
  770452
  811790
  692713
  816816
  779605
  550107
  570931
  608679
  109176
  652959
  732865
  792508
  400563
  814166
  825538
  530664
  542443
  566737
  547941
  554709
  611541
  592741
  789650
  736031
  812230
  812238
  768598
  744568
  751377
  709855
  780884
  398436
  530092
  526017
  788624
  713094
  401154
  662072
  648295
  550125
  493317
  500778
  557461
  661576
  798667
  827454
  827555
  537764
  541166
  696424
  607312
  787967
]
3.17 ms
(1.79%)
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
  50344
  109176
  389787
  398436
  400563
  401154
  408824
  410328
  446524
  449862
  480552
  488956
  493317
  500778
  513986
  526017
  530092
  530415
  530664
  530698
  537764
  540101
  541166
  541184
  541194
  542443
  542460
  547941
  550107
  550116
  550125
  550595
  554705
  554706
  554709
  554734
  557461
  566737
  570931
  573288
  580379
  580998
  592741
  602251
  607312
  608679
  611541
  618056
  621004
  625778
  627833
  640239
  648295
  649707
  651639
  652779
  652959
  660364
  661327
  661342
  661347
  661377
  661576
  662072
  669357
  669930
  670356
  672938
  680954
  681242
  692683
  692686
  692713
  692721
  692763
  696424
  705736
  708090
  709855
  713094
  732865
  735504
  736031
  738427
  742668
  744568
  746967
  751377
  751422
  754680
  768598
  768669
  770452
  773275
  779605
  780884
  783656
  784050
  784147
  786200
  787021
  787967
  788624
  789650
  792508
  798667
  799683
  805290
  805584
  811790
  812060
  812228
  812230
  812238
  814166
  816816
  819240
  825538
  827454
  827555
]
2.01 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public dildo solo"
]
1.99 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на улиц дилд соло"
]
1.63 ms
(0.92%)
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.