Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
299.55 ms
(91.68%)
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
  24855
  383148
  391482
  391939
  392807
  396052
  397695
  398011
  399039
  400235
  403153
  412136
  419102
  438540
  443878
  445755
  447234
  450148
  451613
  454016
  456185
  457646
  458594
  458903
  459038
  459445
  466597
  467930
  469207
  469382
  469402
  472763
  473620
  478727
  480561
  480836
  483962
  485328
  485672
  498289
  507183
  528859
  538420
  538790
  542812
  543196
  545060
  546876
  547654
  549323
  550214
  551463
  552726
  556294
  559247
  559604
  563679
  564559
  564781
  565344
  566258
  566746
  568550
  569573
  570167
  570974
  573818
  574993
  575070
  576575
  577284
  579375
  584102
  591700
  593101
  593111
  593408
  593590
  595422
  596438
  596625
  597990
  599111
  600887
  601665
  602934
  603303
  605642
  605714
  613301
  613858
  618473
  627180
  628552
  630257
  631898
  636497
  637251
  642413
  652548
  656803
  660102
  672404
  672417
  673572
  674391
  680768
  684281
  697962
  698230
  707630
  763251
  763298
  763327
  774842
  780051
  792643
  793379
  803841
  811777
]
17.13 ms
(5.24%)
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
  457646
  459038
  469382
  480836
  450148
  456185
  458594
  458903
  480561
  483962
  485328
  485672
  498289
  507183
  538790
  538420
  528859
  469402
  473620
  552726
  559247
  564781
  566258
  570167
  577284
  584102
  546876
  549323
  551463
  556294
  564559
  570974
  573818
  574993
  579375
  542812
  543196
  559604
  565344
  568550
  575070
  576575
  684281
  656803
  660102
  672417
  680768
  652548
  672404
  673572
  674391
  697962
  707630
  545060
  547654
  550214
  563679
  566746
  569573
  593408
  595422
  600887
  603303
  605642
  613858
  630257
  593111
  593590
  596438
  618473
  631898
  636497
  642413
  591700
  596625
  613301
  628552
  593101
  597990
  599111
  601665
  602934
  605714
  627180
  637251
  774842
  793379
  803841
  792643
  811777
  763251
  763298
  763327
  698230
  780051
  383148
  391482
  396052
  397695
  400235
  419102
  438540
  445755
  447234
  451613
  454016
  469207
  24855
  391939
  392807
  398011
  399039
  403153
  412136
  443878
  459445
  466597
  467930
  472763
  478727
]
2.59 ms
(0.79%)
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
  24855
  383148
  391482
  391939
  392807
  396052
  397695
  398011
  399039
  400235
  403153
  412136
  419102
  438540
  443878
  445755
  447234
  450148
  451613
  454016
  456185
  457646
  458594
  458903
  459038
  459445
  466597
  467930
  469207
  469382
  469402
  472763
  473620
  478727
  480561
  480836
  483962
  485328
  485672
  498289
  507183
  528859
  538420
  538790
  542812
  543196
  545060
  546876
  547654
  549323
  550214
  551463
  552726
  556294
  559247
  559604
  563679
  564559
  564781
  565344
  566258
  566746
  568550
  569573
  570167
  570974
  573818
  574993
  575070
  576575
  577284
  579375
  584102
  591700
  593101
  593111
  593408
  593590
  595422
  596438
  596625
  597990
  599111
  600887
  601665
  602934
  603303
  605642
  605714
  613301
  613858
  618473
  627180
  628552
  630257
  631898
  636497
  637251
  642413
  652548
  656803
  660102
  672404
  672417
  673572
  674391
  680768
  684281
  697962
  698230
  707630
  763251
  763298
  763327
  774842
  780051
  792643
  793379
  803841
  811777
]
2.26 ms
(0.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "колени"
]
1.98 ms
(0.61%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "колен"
]
1.66 ms
(0.51%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.47%)
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.