Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.90 ms
(85.74%)
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
  391601
  404394
  423336
  433058
  434781
  439778
  443374
  450913
  459485
  462849
  463091
  464166
  465302
  471700
  475478
  478298
  478643
  479792
  498404
  503201
  504349
  504482
  518739
  522104
  524999
  530100
  534015
  538239
  544428
  553118
  565768
  574969
  577336
  580792
  583743
  596118
  597464
  597905
  612487
  612514
  612521
  615377
  616059
  616653
  616829
  622951
  622952
  623397
  625107
  625562
  626887
  627764
  632077
  634922
  646230
  647005
  647134
  650676
  653039
  660077
  666190
  674282
  674309
  677192
  680298
  681753
  688960
  691928
  691946
  701018
  710289
  712272
  716131
  717196
  723537
  724130
  724966
  726972
  727021
  727153
  736305
  737949
  738071
  739369
  740243
  746105
  746823
  749362
  750616
  755583
  763472
  767681
  768003
  769629
  770075
  770715
  772363
  773680
  778164
  778710
  782149
  783988
  791493
  795654
  795885
  796884
  799377
  799806
  800819
  801146
  808486
  811925
  813735
  814532
  824679
  825049
]
12.86 ms
(8.30%)
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
  504349
  553118
  580792
  465302
  478643
  768003
  522104
  459485
  504482
  462849
  478298
  433058
  801146
  391601
  626887
  450913
  503201
  565768
  439778
  475478
  479792
  825049
  616059
  577336
  463091
  826340
  423336
  443374
  646230
  434781
  471700
  763882
  530100
  518739
  691928
  680298
  701018
  616653
  612487
  612521
  677192
  524999
  783988
  738071
  723537
  647134
  653039
  666190
  650676
  612514
  534015
  583743
  727021
  716131
  404394
  727153
  808486
  796884
  800819
  770075
  746105
  795654
  597905
  622951
  625562
  634922
  764465
  726972
  681753
  674282
  574969
  544428
  710289
  615377
  623397
  596118
  622952
  498404
  799806
  811925
  746823
  740243
  768810
  739369
  717196
  737949
  674309
  647005
  749362
  627764
  691946
  763472
  688960
  616829
  755583
  824679
  799377
  767681
  769629
  772363
  750616
  778164
  770715
  814532
  724130
  660077
  712272
  625107
  597464
  724966
  632077
  795885
  782149
  464166
  813735
  538239
  778710
  791493
  736305
  773680
]
2.53 ms
(1.63%)
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
  391601
  404394
  423336
  433058
  434781
  439778
  443374
  450913
  459485
  462849
  463091
  464166
  465302
  471700
  475478
  478298
  478643
  479792
  498404
  503201
  504349
  504482
  518739
  522104
  524999
  530100
  534015
  538239
  544428
  553118
  565768
  574969
  577336
  580792
  583743
  596118
  597464
  597905
  612487
  612514
  612521
  615377
  616059
  616653
  616829
  622951
  622952
  623397
  625107
  625562
  626887
  627764
  632077
  634922
  646230
  647005
  647134
  650676
  653039
  660077
  666190
  674282
  674309
  677192
  680298
  681753
  688960
  691928
  691946
  701018
  710289
  712272
  716131
  717196
  723537
  724130
  724966
  726972
  727021
  727153
  736305
  737949
  738071
  739369
  740243
  746105
  746823
  749362
  750616
  755583
  763472
  767681
  768003
  769629
  770075
  770715
  772363
  773680
  778164
  778710
  782149
  783988
  791493
  795654
  795885
  796884
  799377
  799806
  800819
  801146
  808486
  811925
  813735
  814532
  824679
  825049
]
2.22 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "большая задница частн…"
]
1.65 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большая большие жоп любительск"
]
1.48 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большая большие жоп любительск"
]
1.37 ms
(0.88%)
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.