Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.16 ms
(86.38%)
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
  10934
  154257
  397655
  401239
  416568
  416682
  416691
  416692
  416701
  416708
  420193
  441078
  441093
  441149
  442086
  443198
  447985
  450572
  452885
  453585
  455010
  456238
  457478
  457483
  459203
  461612
  462580
  465144
  465454
  466633
  466636
  467584
  470428
  470479
  471664
  471669
  471674
  475336
  480206
  482813
  483738
  487286
  487287
  487428
  493691
  493734
  496149
  497691
  497697
  500336
  502287
  505638
  505661
  508888
  510800
  512941
  514744
  515053
  516676
  525603
  527926
  533554
  533596
  534540
  543329
  546171
  548157
  548444
  548457
  548692
  550815
  550926
  553789
  554208
  556287
  556900
  556902
  556904
  556908
  561763
  566820
  566827
  568258
  573184
  573195
  575366
  576444
  576494
  576848
  578003
  580069
  580973
  583665
  586113
  590255
  592650
  597160
  597534
  605143
  605711
  623187
  626044
  634738
  643100
  643235
  662046
  704352
  711725
  735131
  780650
  788506
  792725
  794292
  794321
  794323
  812560
  816094
  824675
  825840
  827326
]
15.21 ms
(8.63%)
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
  643100
  442086
  554208
  416691
  512941
  447985
  462580
  508888
  576494
  10934
  443198
  525603
  527926
  548157
  578003
  583665
  626044
  597534
  505661
  533554
  459203
  812560
  487286
  416692
  441149
  493691
  497697
  416708
  456238
  590255
  420193
  482813
  534540
  550926
  556904
  735131
  397655
  441093
  487287
  465454
  467584
  471674
  475336
  556908
  568258
  573184
  580973
  580069
  586113
  605143
  471664
  154257
  471669
  461612
  493734
  548457
  566827
  543329
  573195
  550815
  566820
  634738
  441078
  816094
  502287
  497691
  505638
  466633
  466636
  416701
  465144
  452885
  487428
  510800
  788506
  794292
  401239
  457478
  704352
  457483
  483738
  556900
  576444
  548692
  576848
  592650
  597160
  780650
  450572
  455010
  515053
  514744
  827326
  453585
  416682
  470479
  470428
  500336
  516676
  480206
  575366
  662046
  623187
  416568
  496149
  605711
  533596
  553789
  548444
  556902
  711725
  546171
  794323
  643235
  825840
  824675
  556287
  561763
  794321
  792725
]
2.61 ms
(1.48%)
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
  10934
  154257
  397655
  401239
  416568
  416682
  416691
  416692
  416701
  416708
  420193
  441078
  441093
  441149
  442086
  443198
  447985
  450572
  452885
  453585
  455010
  456238
  457478
  457483
  459203
  461612
  462580
  465144
  465454
  466633
  466636
  467584
  470428
  470479
  471664
  471669
  471674
  475336
  480206
  482813
  483738
  487286
  487287
  487428
  493691
  493734
  496149
  497691
  497697
  500336
  502287
  505638
  505661
  508888
  510800
  512941
  514744
  515053
  516676
  525603
  527926
  533554
  533596
  534540
  543329
  546171
  548157
  548444
  548457
  548692
  550815
  550926
  553789
  554208
  556287
  556900
  556902
  556904
  556908
  561763
  566820
  566827
  568258
  573184
  573195
  575366
  576444
  576494
  576848
  578003
  580069
  580973
  583665
  586113
  590255
  592650
  597160
  597534
  605143
  605711
  623187
  626044
  634738
  643100
  643235
  662046
  704352
  711725
  735131
  780650
  788506
  792725
  794292
  794321
  794323
  812560
  816094
  824675
  825840
  827326
]
1.79 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск девушк фистинг"
]
1.51 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateurs girl fisting"
]
1.48 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск девушк фистинг"
]
1.39 ms
(0.79%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.