Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
161.95 ms
(84.97%)
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
  389590
  400365
  406040
  413288
  417765
  419013
  424054
  429941
  432525
  436476
  436478
  438979
  443867
  445053
  445465
  450383
  455103
  455678
  457133
  457506
  462053
  462338
  463250
  466362
  466922
  469216
  469844
  470238
  470644
  472795
  473947
  474033
  476156
  476161
  477645
  477794
  478852
  479481
  491084
  491104
  491438
  491983
  494656
  510649
  513399
  517548
  522548
  522682
  525908
  526036
  533739
  534124
  534170
  547627
  548676
  548703
  552163
  552183
  552410
  552843
  554877
  558324
  558831
  561718
  561721
  562323
  563417
  563570
  564994
  566088
  567523
  567877
  568304
  569862
  570669
  571591
  571634
  571924
  572515
  572523
  573844
  574732
  579991
  581558
  590406
  603876
  609159
  616699
  621949
  625568
  630904
  634804
  650076
  656077
  678539
  679058
  679098
  682964
  692150
  693145
  694157
  698880
  699248
  715397
  715455
  721421
  721500
  726734
  734192
  739886
  750452
  755101
  781648
  781704
  782204
  782287
  789117
  792214
  804877
  809342
]
18.51 ms
(9.71%)
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
  804877
  417765
  472795
  470644
  558324
  564994
  561721
  566088
  570669
  406040
  476161
  477794
  413288
  432525
  438979
  443867
  445053
  462053
  463250
  478852
  479481
  476156
  491983
  526036
  491104
  469216
  445465
  547627
  656077
  561718
  567877
  436478
  466922
  474033
  400365
  455678
  477645
  455103
  491438
  522548
  457133
  533739
  534124
  517548
  568304
  574732
  389590
  462338
  436476
  473947
  469844
  429941
  450383
  513399
  457506
  579991
  534170
  466362
  491084
  562323
  558831
  572523
  552163
  552183
  552410
  694157
  571634
  590406
  603876
  419013
  470238
  522682
  510649
  525908
  494656
  554877
  571591
  548676
  548703
  563570
  567523
  569862
  571924
  573844
  581558
  679058
  699248
  721500
  650076
  679098
  682964
  692150
  715397
  721421
  678539
  693145
  715455
  552843
  563417
  572515
  621949
  616699
  630904
  625568
  634804
  781704
  782204
  792214
  726734
  734192
  750452
  755101
  782287
  789117
  809342
  739886
  609159
  698880
  781648
  424054
]
2.58 ms
(1.35%)
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
  389590
  400365
  406040
  413288
  417765
  419013
  424054
  429941
  432525
  436476
  436478
  438979
  443867
  445053
  445465
  450383
  455103
  455678
  457133
  457506
  462053
  462338
  463250
  466362
  466922
  469216
  469844
  470238
  470644
  472795
  473947
  474033
  476156
  476161
  477645
  477794
  478852
  479481
  491084
  491104
  491438
  491983
  494656
  510649
  513399
  517548
  522548
  522682
  525908
  526036
  533739
  534124
  534170
  547627
  548676
  548703
  552163
  552183
  552410
  552843
  554877
  558324
  558831
  561718
  561721
  562323
  563417
  563570
  564994
  566088
  567523
  567877
  568304
  569862
  570669
  571591
  571634
  571924
  572515
  572523
  573844
  574732
  579991
  581558
  590406
  603876
  609159
  616699
  621949
  625568
  630904
  634804
  650076
  656077
  678539
  679058
  679098
  682964
  692150
  693145
  694157
  698880
  699248
  715397
  715455
  721421
  721500
  726734
  734192
  739886
  750452
  755101
  781648
  781704
  782204
  782287
  789117
  792214
  804877
  809342
]
2.18 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ÐÇÐâÐüÐüð║ð©ðÁ ð¢ð░ÐéÐâÐÇð░ð╗Ðîð¢ÐïðÁ Ð%ÔǪ"
]
2.02 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск натуральные"
]
1.72 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(0.85%)
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.