Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
148.59 ms
(85.53%)
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
  87974
  88476
  248347
  352189
  369221
  382158
  382670
  387337
  387941
  393836
  396784
  397882
  398122
  401813
  403973
  410962
  412855
  413392
  414050
  414137
  414292
  415885
  416614
  428171
  429861
  432674
  439151
  441250
  444064
  444485
  444490
  448854
  455915
  456117
  465125
  465148
  465647
  468146
  469221
  477021
  483735
  483737
  493838
  499872
  506105
  511240
  511857
  513977
  515992
  518508
  524215
  526180
  526653
  531855
  532652
  547556
  548525
  552069
  552704
  565036
  567127
  571726
  581645
  585680
  586113
  587306
  589185
  592046
  592259
  592773
  594143
  594619
  595860
  596252
  600144
  607706
  608076
  609890
  609920
  616454
  624399
  624682
  628105
  628106
  630091
  639024
  656856
  725400
  730060
  735703
  739119
  745874
  749090
  750426
  751609
  752648
  752679
  758343
  768508
  770814
  782057
  782854
  783261
  788027
  788863
  788908
  793151
  795404
  795420
  796333
  796647
  796650
  796703
  796939
  797341
  798599
  803534
  806938
  811512
  826384
]
13.62 ms
(7.84%)
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
  585680
  592773
  595860
  639024
  589185
  594619
  608076
  624682
  628105
  609920
  624399
  586113
  594143
  600144
  616454
  782057
  795404
  796650
  796703
  798599
  782854
  793151
  795420
  796333
  796647
  803534
  749090
  770814
  797341
  806938
  739119
  750426
  752679
  725400
  735703
  751609
  745874
  752648
  758343
  628106
  788863
  788908
  796939
  87974
  387941
  414050
  465125
  248347
  456117
  352189
  396784
  382670
  403973
  428171
  444490
  465647
  493838
  515992
  526653
  499872
  524215
  826384
  532652
  811512
  730060
  768508
  783261
  412855
  432674
  414292
  415885
  448854
  455915
  477021
  483737
  513977
  511240
  469221
  567127
  571726
  547556
  552704
  552069
  587306
  592046
  592259
  609890
  607706
  630091
  410962
  413392
  414137
  465148
  429861
  439151
  416614
  468146
  483735
  506105
  511857
  369221
  382158
  387337
  401813
  441250
  444485
  518508
  526180
  531855
  581645
  548525
  565036
  596252
  88476
  393836
  397882
  398122
  444064
  656856
  788027
]
3.76 ms
(2.17%)
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
  87974
  88476
  248347
  352189
  369221
  382158
  382670
  387337
  387941
  393836
  396784
  397882
  398122
  401813
  403973
  410962
  412855
  413392
  414050
  414137
  414292
  415885
  416614
  428171
  429861
  432674
  439151
  441250
  444064
  444485
  444490
  448854
  455915
  456117
  465125
  465148
  465647
  468146
  469221
  477021
  483735
  483737
  493838
  499872
  506105
  511240
  511857
  513977
  515992
  518508
  524215
  526180
  526653
  531855
  532652
  547556
  548525
  552069
  552704
  565036
  567127
  571726
  581645
  585680
  586113
  587306
  589185
  592046
  592259
  592773
  594143
  594619
  595860
  596252
  600144
  607706
  608076
  609890
  609920
  616454
  624399
  624682
  628105
  628106
  630091
  639024
  656856
  725400
  730060
  735703
  739119
  745874
  749090
  750426
  751609
  752648
  752679
  758343
  768508
  770814
  782057
  782854
  783261
  788027
  788863
  788908
  793151
  795404
  795420
  796333
  796647
  796650
  796703
  796939
  797341
  798599
  803534
  806938
  811512
  826384
]
2.17 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "xxx dildo"
]
2.01 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "xxx дилд"
]
1.96 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "xxx дилд"
]
1.62 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.