Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.46 ms
(85.41%)
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
  43564
  386620
  386701
  396685
  401121
  401480
  404731
  414956
  463991
  493256
  494976
  497453
  497467
  506066
  541686
  547471
  547476
  548460
  549048
  550925
  554215
  554280
  561653
  564300
  566416
  568485
  570135
  570310
  570469
  571904
  572709
  572755
  573078
  573083
  573191
  574623
  574848
  576505
  576523
  581264
  584287
  585968
  587573
  589243
  589729
  591747
  591992
  592322
  592330
  592410
  595403
  596594
  596619
  596995
  597987
  598478
  598599
  598796
  598874
  603464
  604259
  604447
  605256
  605326
  606618
  609645
  610657
  616046
  623175
  623429
  623608
  627362
  629092
  643602
  648648
  652612
  652898
  652939
  653215
  653229
  657556
  659324
  665737
  671659
  674688
  696989
  702162
  708438
  711698
  714431
  714458
  722621
  723421
  724170
  724707
  726040
  729176
  730751
  731485
  735324
  735957
  737140
  738216
  747442
  747447
  748658
  750301
  753435
  753456
  758188
  767023
  767201
  787283
  791627
  796077
  796879
  807510
  808101
  810706
  826286
]
11.61 ms
(7.91%)
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
  598796
  629092
  596995
  598478
  605256
  791627
  724707
  735957
  726040
  731485
  735324
  711698
  714458
  723421
  414956
  493256
  506066
  570135
  702162
  598874
  623429
  796879
  810706
  807510
  826286
  796077
  43564
  463991
  497467
  494976
  547476
  570469
  573083
  572709
  574848
  550925
  573078
  584287
  648648
  652939
  674688
  722621
  696989
  652612
  652898
  653215
  714431
  570310
  574623
  592322
  597987
  606618
  623175
  585968
  589243
  603464
  623608
  587573
  591747
  598599
  604447
  605326
  610657
  808101
  747442
  724170
  729176
  737140
  738216
  748658
  750301
  753435
  753456
  643602
  787283
  396685
  386620
  548460
  554215
  554280
  576523
  566416
  573191
  653229
  659324
  665737
  708438
  596594
  592330
  604259
  730751
  747447
  758188
  767023
  767201
  609645
  401121
  386701
  401480
  404731
  497453
  571904
  549048
  564300
  572755
  581264
  541686
  561653
  568485
  576505
  657556
  671659
  547471
  595403
  589729
  591992
  592410
  596619
  616046
  627362
]
2.92 ms
(1.99%)
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
  43564
  386620
  386701
  396685
  401121
  401480
  404731
  414956
  463991
  493256
  494976
  497453
  497467
  506066
  541686
  547471
  547476
  548460
  549048
  550925
  554215
  554280
  561653
  564300
  566416
  568485
  570135
  570310
  570469
  571904
  572709
  572755
  573078
  573083
  573191
  574623
  574848
  576505
  576523
  581264
  584287
  585968
  587573
  589243
  589729
  591747
  591992
  592322
  592330
  592410
  595403
  596594
  596619
  596995
  597987
  598478
  598599
  598796
  598874
  603464
  604259
  604447
  605256
  605326
  606618
  609645
  610657
  616046
  623175
  623429
  623608
  627362
  629092
  643602
  648648
  652612
  652898
  652939
  653215
  653229
  657556
  659324
  665737
  671659
  674688
  696989
  702162
  708438
  711698
  714431
  714458
  722621
  723421
  724170
  724707
  726040
  729176
  730751
  731485
  735324
  735957
  737140
  738216
  747442
  747447
  748658
  750301
  753435
  753456
  758188
  767023
  767201
  787283
  791627
  796077
  796879
  807510
  808101
  810706
  826286
]
1.94 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal butt"
]
1.79 ms
(1.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал butt"
]
1.41 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал butt"
]

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.