Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
206.33 ms
(88.64%)
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
  6651
  24255
  26026
  154112
  246509
  308331
  382935
  383734
  384889
  385481
  386821
  388113
  448195
  479533
  498849
  509008
  510323
  514405
  525310
  528930
  541172
  546274
  546293
  559399
  559657
  566774
  571143
  575195
  581606
  590982
  591022
  591035
  591558
  597972
  603747
  605719
  608058
  608477
  610005
  620023
  625772
  627648
  640321
  642165
  642232
  642254
  642286
  644119
  650312
  664747
  664810
  667208
  668972
  669706
  671149
  678628
  682235
  682724
  684961
  686079
  688534
  689055
  697605
  704391
  705334
  705375
  705376
  705458
  708746
  710248
  712693
  714554
  716106
  719225
  721816
  726681
  726808
  728094
  736036
  738226
  739963
  744735
  749634
  750693
  753950
  757531
  758088
  758976
  761726
  761890
  767850
  768001
  770987
  779899
  786080
  789447
  789609
  789617
  790400
  791736
  792288
  792522
  793281
  793303
  796027
  796568
  798059
  804923
  805037
  805848
  808162
  808561
  809487
  810180
  810674
  810867
  813710
  813745
  814113
]
14.83 ms
(6.37%)
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
  591022
  591035
  448195
  385481
  386821
  384889
  382935
  383734
  154112
  246509
  308331
  24255
  26026
  6651
  388113
  814113
  813745
  813710
  509008
  510323
  514405
  528930
  498849
  525310
  479533
  546274
  541172
  559399
  559657
  566774
  575195
  650312
  664810
  689055
  712693
  664747
  668972
  669706
  671149
  682724
  686079
  688534
  705375
  708746
  710248
  716106
  719225
  667208
  678628
  682235
  684961
  705334
  714554
  721816
  546293
  571143
  581606
  590982
  603747
  605719
  610005
  642232
  597972
  608477
  640321
  644119
  627648
  642165
  642254
  591558
  620023
  779899
  789609
  789617
  790400
  792288
  793281
  805037
  808561
  810674
  786080
  789447
  792522
  793303
  796027
  796568
  798059
  809487
  810180
  750693
  758976
  791736
  804923
  805848
  808162
  810867
  728094
  732108
  761726
  736036
  739963
  753950
  757531
  761890
  768001
  726681
  726808
  738226
  744735
  749634
  758088
  767850
  770987
  608058
  625772
  642286
  697605
  704391
  705376
  705458
]
3.62 ms
(1.55%)
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
  6651
  24255
  26026
  154112
  246509
  308331
  382935
  383734
  384889
  385481
  386821
  388113
  448195
  479533
  498849
  509008
  510323
  514405
  525310
  528930
  541172
  546274
  546293
  559399
  559657
  566774
  571143
  575195
  581606
  590982
  591022
  591035
  591558
  597972
  603747
  605719
  608058
  608477
  610005
  620023
  625772
  627648
  640321
  642165
  642232
  642254
  642286
  644119
  650312
  664747
  664810
  667208
  668972
  669706
  671149
  678628
  682235
  682724
  684961
  686079
  688534
  689055
  697605
  704391
  705334
  705375
  705376
  705458
  708746
  710248
  712693
  714554
  716106
  719225
  721816
  726681
  726808
  728094
  736036
  738226
  739963
  744735
  749634
  750693
  753950
  757531
  758088
  758976
  761726
  761890
  767850
  768001
  770987
  779899
  786080
  789447
  789609
  789617
  790400
  791736
  792288
  792522
  793281
  793303
  796027
  796568
  798059
  804923
  805037
  805848
  808162
  808561
  809487
  810180
  810674
  810867
  813710
  813745
  814113
]
2.28 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "кухн"
]
2.10 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.04 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "кухн"
]
1.59 ms
(0.68%)
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.