Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
173.90 ms
(87.27%)
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
  7058
  9734
  37823
  75969
  118370
  124661
  151062
  154844
  160126
  182895
  213432
  229024
  242216
  315072
  320786
  324555
  338807
  352142
  381764
  382278
  382302
  382383
  382611
  383500
  384108
  384170
  385228
  385759
  386522
  388894
  391393
  391756
  392311
  393350
  395465
  397567
  397655
  397656
  398247
  400666
  401872
  402390
  404120
  411198
  414123
  414434
  418697
  420193
  427539
  428220
  440068
  441063
  443152
  443249
  443309
  446045
  448370
  453822
  454368
  457816
  458193
  462848
  465195
  465669
  466991
  473098
  475425
  477482
  481169
  493763
  494318
  497731
  500621
  513978
  519364
  530629
  531811
  534539
  536127
  536128
  539026
  543744
  553734
  554852
  576225
  578750
  586011
  602485
  618257
  643181
  643213
  656187
  658784
  672926
  716633
  722393
  735885
  742929
  745168
  750856
  752631
  764504
  778938
  792708
  792725
  794300
  794334
  818707
  823766
  824675
  824778
  824876
  827838
  827852
  827946
  827948
  827951
  827960
  827974
]
13.14 ms
(6.59%)
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
  213432
  37823
  7058
  553734
  716633
  618257
  229024
  118370
  75969
  824876
  643213
  745168
  534539
  539026
  554852
  672926
  742929
  722393
  384108
  388894
  443249
  392311
  418697
  519364
  536128
  385759
  386522
  391756
  352142
  381764
  382278
  9734
  397567
  397656
  398247
  402390
  411198
  420193
  440068
  500621
  465669
  602485
  383500
  391393
  404120
  414434
  446045
  454368
  457816
  473098
  481169
  494318
  530629
  750856
  778938
  160126
  242216
  315072
  823766
  656187
  382383
  382611
  382302
  400666
  543744
  643181
  792708
  752631
  735885
  764504
  124661
  497468
  536127
  576225
  658784
  458193
  393350
  338807
  824778
  818707
  824675
  827838
  827852
  827946
  827974
  827948
  827951
  827960
  531811
  578750
  586011
  794300
  792725
  794334
  384170
  401872
  385228
  154844
  151062
  182895
  395465
  324555
  320786
  397655
  414123
  443309
  427539
  428220
  441063
  443152
  448370
  493763
  453822
  462848
  465195
  466991
  475425
  477482
  497731
  513978
]
4.76 ms
(2.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "жестко раков"
]
2.81 ms
(1.41%)
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
  7058
  9734
  37823
  75969
  118370
  124661
  151062
  154844
  160126
  182895
  213432
  229024
  242216
  315072
  320786
  324555
  338807
  352142
  381764
  382278
  382302
  382383
  382611
  383500
  384108
  384170
  385228
  385759
  386522
  388894
  391393
  391756
  392311
  393350
  395465
  397567
  397655
  397656
  398247
  400666
  401872
  402390
  404120
  411198
  414123
  414434
  418697
  420193
  427539
  428220
  440068
  441063
  443152
  443249
  443309
  446045
  448370
  453822
  454368
  457816
  458193
  462848
  465195
  465669
  466991
  473098
  475425
  477482
  481169
  493763
  494318
  497731
  500621
  513978
  519364
  530629
  531811
  534539
  536127
  536128
  539026
  543744
  553734
  554852
  576225
  578750
  586011
  602485
  618257
  643181
  643213
  656187
  658784
  672926
  716633
  722393
  735885
  742929
  745168
  750856
  752631
  764504
  778938
  792708
  792725
  794300
  794334
  818707
  823766
  824675
  824778
  824876
  827838
  827852
  827946
  827948
  827951
  827960
  827974
]
1.66 ms
(0.83%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "хардкор рак"
]
1.61 ms
(0.81%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.38 ms
(0.69%)
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.