Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
162.81 ms
(83.50%)
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
  387742
  416632
  418440
  420849
  420877
  421189
  427539
  428695
  435401
  443198
  445470
  446063
  448519
  451372
  451907
  453583
  461707
  462791
  464811
  465269
  465468
  465548
  471532
  474913
  485031
  487359
  487414
  488454
  492750
  498260
  498305
  498666
  500240
  500965
  502779
  503836
  508072
  508885
  516434
  518147
  519772
  521219
  526608
  526766
  528052
  533540
  534587
  540945
  541274
  550919
  552566
  555387
  555873
  556206
  566863
  570716
  571086
  584228
  585356
  591736
  592712
  593768
  595573
  601333
  604286
  604366
  613004
  628097
  628553
  655275
  660367
  662165
  687083
  692038
  692767
  695900
  696598
  704178
  704184
  704186
  712633
  712877
  717366
  717873
  722516
  722934
  725622
  726596
  726858
  728771
  729167
  729287
  732067
  740489
  743611
  744653
  748981
  749694
  751727
  752636
  752940
  756693
  758790
  761018
  761048
  765465
  769071
  775239
  790459
  793013
  796204
  796297
  798775
  799949
  800604
  800766
  803108
  804568
  805300
  813122
]
21.24 ms
(10.89%)
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
  687083
  585356
  793013
  796204
  800766
  749694
  744653
  796297
  435401
  498260
  418440
  492750
  704186
  712877
  592712
  761018
  508885
  570716
  453583
  748981
  500965
  695900
  722516
  448519
  474913
  717366
  740489
  726858
  550919
  591736
  765465
  798775
  445470
  421189
  503836
  516434
  471532
  533540
  540945
  662165
  704184
  595573
  804568
  799949
  743611
  728771
  732067
  726596
  803108
  462791
  427539
  604366
  813122
  752940
  805300
  729287
  502779
  420849
  420877
  534587
  556206
  692038
  761048
  769071
  461707
  528052
  660367
  704178
  613004
  628097
  790459
  756693
  758790
  751727
  519772
  526766
  717873
  800604
  712633
  729167
  464811
  451372
  485031
  541274
  555387
  692767
  593768
  752636
  387742
  443198
  498305
  498666
  521219
  500240
  508072
  722934
  566863
  775239
  428695
  487359
  488454
  465269
  571086
  655275
  526608
  416632
  451907
  487414
  465468
  552566
  628553
  725622
  696598
  555873
  601333
  584228
  604286
  518147
  446063
  465548
]
2.67 ms
(1.37%)
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
  387742
  416632
  418440
  420849
  420877
  421189
  427539
  428695
  435401
  443198
  445470
  446063
  448519
  451372
  451907
  453583
  461707
  462791
  464811
  465269
  465468
  465548
  471532
  474913
  485031
  487359
  487414
  488454
  492750
  498260
  498305
  498666
  500240
  500965
  502779
  503836
  508072
  508885
  516434
  518147
  519772
  521219
  526608
  526766
  528052
  533540
  534587
  540945
  541274
  550919
  552566
  555387
  555873
  556206
  566863
  570716
  571086
  584228
  585356
  591736
  592712
  593768
  595573
  601333
  604286
  604366
  613004
  628097
  628553
  655275
  660367
  662165
  687083
  692038
  692767
  695900
  696598
  704178
  704184
  704186
  712633
  712877
  717366
  717873
  722516
  722934
  725622
  726596
  726858
  728771
  729167
  729287
  732067
  740489
  743611
  744653
  748981
  749694
  751727
  752636
  752940
  756693
  758790
  761018
  761048
  765465
  769071
  775239
  790459
  793013
  796204
  796297
  798775
  799949
  800604
  800766
  803108
  804568
  805300
  813122
]
2.30 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.15 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fuck my asshole"
]
1.92 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс my asshole"
]
1.91 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс my asshole"
]

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.