Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.87 ms
(57.97%)
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
  321277
  391992
  392015
  400621
  414277
  416036
  416682
  417621
  419167
  420140
  420774
  421838
  436639
  437368
  437733
  438100
  441041
  442548
  450262
  452800
  453390
  457650
  460196
  460351
  461153
  466636
  470479
  471074
  471092
  476646
  476847
  480844
  483684
  491083
  496703
  497691
  499302
  499905
  499921
  502797
  506692
  509329
  511274
  512442
  514233
  526179
  526444
  527217
  528281
  529055
  531347
  536464
  539875
  541413
  542422
  545028
  549554
  553964
  555306
  560679
  568864
  569619
  576981
  577038
  577719
  579173
  580848
  583666
  583689
  584195
  584322
  584362
  585294
  586876
  587291
  589507
  589602
  591962
  598882
  600948
  602467
  602627
  605874
  607560
  608505
  625227
  641649
  644498
  650540
  659199
  663776
  667045
  668620
  671505
  680562
  680816
  688990
  690684
  714203
  751410
  751692
  760659
  772210
  774876
  779769
  783466
  784681
  786005
  786898
  788524
  791385
  793022
  796372
  796705
  796950
  803520
  807244
  807835
  810852
  814418
]
128.08 ms
(34.88%)
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
  321277
  391992
  392015
  400621
  414277
  416036
  416682
  417621
  419167
  420140
  420774
  421838
  436639
  437368
  437733
  438100
  441041
  442548
  450262
  452800
  453390
  457650
  460196
  460351
  461153
  466636
  470479
  471074
  471092
  476646
  476847
  480844
  483684
  491083
  496703
  497691
  499302
  499905
  499921
  502797
  506692
  509329
  511274
  512442
  514233
  526179
  526444
  527217
  528281
  529055
  531347
  536464
  539875
  541413
  542422
  545028
  549554
  553964
  555306
  560679
  568864
  569619
  576981
  577038
  577719
  579173
  580848
  583666
  583689
  584195
  584322
  584362
  585294
  586876
  587291
  589507
  589602
  591962
  598882
  600948
  602467
  602627
  605874
  607560
  608505
  625227
  641649
  644498
  650540
  659199
  663776
  667045
  668620
  671505
  680562
  680816
  688990
  690684
  714203
  751410
  751692
  760659
  772210
  774876
  779769
  783466
  784681
  786005
  786898
  788524
  791385
  793022
  796372
  796705
  796950
  803520
  807244
  807835
  810852
  814418
]
18.58 ms
(5.06%)
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
  814418
  450262
  460196
  527217
  506692
  579173
  568864
  580848
  663776
  650540
  668620
  680562
  714203
  600948
  602627
  605874
  774876
  779769
  796372
  807835
  788524
  793022
  796705
  796950
  772210
  783466
  751692
  751410
  644498
  786005
  786898
  791385
  807244
  414277
  437733
  509329
  419167
  442548
  471074
  560679
  539875
  589602
  591962
  400621
  496703
  491083
  688990
  667045
  553964
  436639
  577038
  461153
  536464
  583666
  526179
  483684
  587291
  441041
  476847
  471092
  497691
  584362
  659199
  586876
  453390
  437368
  499302
  502797
  690684
  585294
  438100
  321277
  416036
  416682
  470479
  457650
  512442
  625227
  810852
  417621
  480844
  476646
  499905
  584322
  576981
  577719
  555306
  584195
  641649
  589507
  760659
  452800
  514233
  391992
  529055
  420774
  499921
  542422
  784681
  607560
  460351
  531347
  598882
  541413
  671505
  803520
  420140
  526444
  511274
  466636
  583689
  680816
  608505
  602467
  392015
  421838
  528281
  545028
  549554
  569619
]
2.18 ms
(0.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "на самотыке"
]
2.05 ms
(0.56%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(0.50%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на дилд"
]
1.62 ms
(0.44%)
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.