Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.96 ms
(85.63%)
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
  170225
  459708
  464801
  465591
  490849
  492966
  494894
  496261
  516119
  523045
  528314
  546629
  551594
  563284
  565105
  573354
  584869
  584964
  588058
  588858
  593745
  599318
  605534
  615533
  616133
  618495
  619854
  621600
  622286
  623108
  623280
  627077
  636925
  637210
  637347
  637481
  639111
  641128
  647108
  658939
  661320
  672310
  676673
  678249
  678858
  679499
  680268
  681514
  684433
  685509
  691466
  693669
  693677
  693695
  693765
  706024
  708594
  711094
  712574
  712939
  715118
  716934
  716952
  719573
  720547
  720579
  723293
  724961
  728652
  729069
  731267
  733412
  736702
  739798
  740883
  748693
  748747
  748773
  749046
  749427
  749542
  750391
  763431
  763876
  765678
  765940
  767716
  769043
  772262
  773368
  773761
  774667
  774671
  775590
  777815
  777836
  779889
  779946
  780219
  781132
  786088
  786729
  790829
  790929
  791542
  792340
  792341
  792487
  793186
  795099
  795247
  795257
  796351
  796988
  800636
  801478
  804932
  808529
  808601
  812282
]
13.24 ms
(7.56%)
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
  678858
  693677
  637210
  773368
  588858
  615533
  170225
  693669
  716952
  775590
  605534
  563284
  588058
  801478
  748693
  573354
  623108
  680268
  715118
  731267
  639111
  684433
  693695
  676673
  720579
  636925
  627077
  637347
  616133
  465591
  551594
  767716
  637481
  565105
  516119
  781132
  779889
  772262
  792341
  796988
  729069
  681514
  792340
  584964
  678249
  711094
  647108
  739798
  599318
  584869
  716934
  774671
  749046
  748773
  800636
  777836
  790929
  496261
  774667
  779946
  740883
  808529
  720547
  621600
  619854
  706024
  792487
  733412
  749427
  723293
  765678
  750391
  786729
  712574
  658939
  790829
  812282
  804932
  808601
  793186
  736702
  763431
  795099
  693765
  622286
  672310
  712939
  786088
  773761
  780219
  795247
  749542
  777815
  679499
  523045
  728652
  494894
  593745
  618495
  691466
  528314
  748747
  769043
  459708
  492966
  641128
  719573
  661320
  708594
  546629
  685509
  796351
  763876
  795257
  791542
  724961
  765940
  623280
  490849
  464801
]
3.73 ms
(2.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"крупный план домашнеÐâ…"
]
3.50 ms
(2.00%)
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
  170225
  459708
  464801
  465591
  490849
  492966
  494894
  496261
  516119
  523045
  528314
  546629
  551594
  563284
  565105
  573354
  584869
  584964
  588058
  588858
  593745
  599318
  605534
  615533
  616133
  618495
  619854
  621600
  622286
  623108
  623280
  627077
  636925
  637210
  637347
  637481
  639111
  641128
  647108
  658939
  661320
  672310
  676673
  678249
  678858
  679499
  680268
  681514
  684433
  685509
  691466
  693669
  693677
  693695
  693765
  706024
  708594
  711094
  712574
  712939
  715118
  716934
  716952
  719573
  720547
  720579
  723293
  724961
  728652
  729069
  731267
  733412
  736702
  739798
  740883
  748693
  748747
  748773
  749046
  749427
  749542
  750391
  763431
  763876
  765678
  765940
  767716
  769043
  772262
  773368
  773761
  774667
  774671
  775590
  777815
  777836
  779889
  779946
  780219
  781132
  786088
  786729
  790829
  790929
  791542
  792340
  792341
  792487
  793186
  795099
  795247
  795257
  796351
  796988
  800636
  801478
  804932
  808529
  808601
  812282
]
1.90 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "крупныйпла домашн любительск"
]
1.29 ms
(0.73%)
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.