Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
163.71 ms
(85.70%)
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
  79388
  191093
  191487
  391076
  396688
  398764
  399332
  399738
  415188
  418079
  419123
  432945
  444206
  444750
  446258
  448471
  456540
  457002
  458059
  462222
  468655
  469187
  471834
  476264
  477581
  477587
  479676
  485266
  486562
  486675
  488663
  488812
  489170
  489721
  491943
  496080
  497369
  501480
  501498
  504876
  505807
  506769
  510058
  511154
  514618
  516037
  516773
  517184
  519421
  520816
  521492
  524078
  524505
  526540
  527686
  529188
  529949
  532836
  533352
  536394
  536653
  536901
  536928
  537888
  537916
  539116
  541225
  542817
  542854
  543884
  543892
  544409
  546828
  548552
  549858
  556961
  559327
  560639
  560899
  567014
  568536
  569929
  570150
  570168
  570176
  570999
  571065
  572126
  573309
  574047
  575524
  576696
  577545
  580122
  580277
  581727
  583982
  584337
  584451
  588499
  589484
  591637
  591874
  597258
  598546
  600030
  602985
  603252
  604496
  604528
  605288
  605553
  611551
  615961
  621083
  649162
  659793
  678439
  688232
  689376
]
17.30 ms
(9.05%)
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
  605288
  569929
  468655
  488812
  496080
  501498
  526540
  584451
  580277
  570168
  581727
  588499
  598546
  603252
  79388
  444750
  432945
  536901
  486675
  527686
  539116
  529188
  533352
  479676
  489721
  544409
  560639
  567014
  574047
  577545
  543892
  584337
  549858
  556961
  572126
  575524
  580122
  597258
  604496
  602985
  591874
  621083
  448471
  391076
  398764
  476264
  486562
  511154
  505807
  516037
  519421
  191093
  399738
  399332
  469187
  510058
  532836
  524078
  536928
  471834
  559327
  570150
  678439
  649162
  659793
  689376
  611551
  396688
  462222
  514618
  489170
  517184
  591637
  444206
  418079
  485266
  536394
  520816
  497369
  571065
  568536
  688232
  560899
  456540
  458059
  504876
  491943
  516773
  543884
  573309
  548552
  604528
  419123
  521492
  446258
  537888
  583982
  501480
  529949
  537916
  536653
  576696
  570999
  589484
  615961
  605553
  600030
  542854
  546828
  570176
  191487
  415188
  488663
  477587
  457002
  506769
  524505
  477581
  541225
  542817
]
2.50 ms
(1.31%)
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
  79388
  191093
  191487
  391076
  396688
  398764
  399332
  399738
  415188
  418079
  419123
  432945
  444206
  444750
  446258
  448471
  456540
  457002
  458059
  462222
  468655
  469187
  471834
  476264
  477581
  477587
  479676
  485266
  486562
  486675
  488663
  488812
  489170
  489721
  491943
  496080
  497369
  501480
  501498
  504876
  505807
  506769
  510058
  511154
  514618
  516037
  516773
  517184
  519421
  520816
  521492
  524078
  524505
  526540
  527686
  529188
  529949
  532836
  533352
  536394
  536653
  536901
  536928
  537888
  537916
  539116
  541225
  542817
  542854
  543884
  543892
  544409
  546828
  548552
  549858
  556961
  559327
  560639
  560899
  567014
  568536
  569929
  570150
  570168
  570176
  570999
  571065
  572126
  573309
  574047
  575524
  576696
  577545
  580122
  580277
  581727
  583982
  584337
  584451
  588499
  589484
  591637
  591874
  597258
  598546
  600030
  602985
  603252
  604496
  604528
  605288
  605553
  611551
  615961
  621083
  649162
  659793
  678439
  688232
  689376
]
2.09 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сосет в черный"
]
2.02 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "сосет в черном"
]
1.79 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сосет в черный"
]
1.62 ms
(0.85%)
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.