Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
179.75 ms
(87.45%)
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
  13229
  193761
  390205
  390218
  396428
  396758
  397898
  398947
  401807
  411368
  411394
  426647
  437443
  443387
  443697
  443727
  443743
  443953
  455318
  459024
  460601
  462489
  463159
  465372
  465838
  466149
  466840
  474781
  479023
  482328
  484586
  490419
  490741
  490929
  490949
  493195
  502748
  506227
  514441
  516478
  518999
  520886
  535332
  539487
  541246
  541847
  542370
  543708
  545874
  546957
  547763
  558304
  560866
  562192
  565898
  566659
  577598
  588958
  590441
  594892
  594942
  596653
  598018
  598433
  602806
  611730
  620247
  641718
  644974
  651006
  659986
  666006
  669892
  677862
  693396
  695707
  696322
  702176
  702312
  705317
  705890
  713384
  714320
  716754
  718744
  719977
  721409
  722302
  740975
  741201
  742605
  745462
  751536
  751564
  751803
  753507
  758171
  760875
  764185
  765227
  765806
  765956
  768553
  777739
  777861
  778748
  778774
  779341
  779902
  781673
  791653
  794980
  800934
  801608
  814147
  814295
  816111
  816124
  817725
  825545
]
15.71 ms
(7.64%)
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
  760875
  764185
  745462
  751803
  765227
  768553
  740975
  741201
  742605
  751536
  751564
  753507
  758171
  765806
  765956
  602806
  716754
  777739
  777861
  778748
  778774
  779341
  779902
  781673
  791653
  794980
  800934
  801608
  396428
  397898
  193761
  398947
  459024
  482328
  13229
  443743
  443953
  520886
  401807
  465838
  490419
  543708
  541246
  546957
  659986
  705890
  390218
  437443
  443727
  462489
  463159
  466149
  411394
  443387
  465372
  411368
  443697
  466840
  390205
  396758
  455318
  460601
  474781
  426647
  479023
  516478
  490949
  502748
  514441
  506227
  518999
  484586
  490741
  490929
  493195
  702176
  817725
  644974
  816124
  814147
  816111
  814295
  825545
  539487
  535332
  545874
  560866
  565898
  566659
  577598
  542370
  547763
  558304
  541847
  562192
  696322
  713384
  714320
  718744
  721409
  666006
  677862
  693396
  695707
  702312
  705317
  719977
  722302
  651006
  669892
  590441
  598018
  611730
  620247
  641718
  588958
  594892
  594942
  596653
  598433
]
2.79 ms
(1.36%)
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
  13229
  193761
  390205
  390218
  396428
  396758
  397898
  398947
  401807
  411368
  411394
  426647
  437443
  443387
  443697
  443727
  443743
  443953
  455318
  459024
  460601
  462489
  463159
  465372
  465838
  466149
  466840
  474781
  479023
  482328
  484586
  490419
  490741
  490929
  490949
  493195
  502748
  506227
  514441
  516478
  518999
  520886
  535332
  539487
  541246
  541847
  542370
  543708
  545874
  546957
  547763
  558304
  560866
  562192
  565898
  566659
  577598
  588958
  590441
  594892
  594942
  596653
  598018
  598433
  602806
  611730
  620247
  641718
  644974
  651006
  659986
  666006
  669892
  677862
  693396
  695707
  696322
  702176
  702312
  705317
  705890
  713384
  714320
  716754
  718744
  719977
  721409
  722302
  740975
  741201
  742605
  745462
  751536
  751564
  751803
  753507
  758171
  760875
  764185
  765227
  765806
  765956
  768553
  777739
  777861
  778748
  778774
  779341
  779902
  781673
  791653
  794980
  800934
  801608
  814147
  814295
  816111
  816124
  817725
  825545
]
2.15 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom russian"
]
1.84 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom русск"
]
1.71 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom русск"
]
1.61 ms
(0.78%)
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.