Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
190.58 ms
(88.48%)
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
  79683
  385676
  385758
  391455
  398643
  404019
  409846
  412963
  417090
  417693
  417958
  419225
  420869
  422303
  422305
  425494
  425497
  427334
  432754
  438995
  441972
  442922
  443540
  444228
  446228
  447261
  450383
  450860
  451018
  453772
  455214
  456524
  459642
  469867
  470142
  471154
  471163
  471573
  472680
  474336
  476600
  477225
  478280
  478709
  485954
  487615
  488051
  489259
  490516
  495441
  495935
  501579
  504464
  506012
  513243
  516613
  523268
  523277
  527317
  531360
  542085
  544723
  550309
  553343
  557245
  557641
  561352
  569560
  571074
  575236
  582670
  587709
  588708
  589030
  601898
  623436
  624601
  636143
  651795
  652454
  661512
  671686
  676617
  696732
  707480
  722189
  723665
  727423
  729773
  735417
  736468
  738311
  741879
  747236
  747796
  754343
  754821
  757565
  763331
  763629
  765410
  772837
  777198
  777978
  779845
  782914
  785047
  785812
  787585
  788968
  791842
  792124
  792480
  793425
  793722
  794949
  796590
  805066
  810139
  817073
]
14.82 ms
(6.88%)
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
  450383
  456524
  469867
  471163
  490516
  506012
  527317
  425497
  443540
  516613
  476600
  417958
  438995
  444228
  471573
  474336
  504464
  544723
  553343
  582670
  550309
  561352
  671686
  696732
  651795
  661512
  588708
  589030
  777978
  787585
  796590
  788968
  794949
  738311
  772837
  747796
  741879
  736468
  754343
  763629
  765410
  722189
  782914
  420869
  793425
  636143
  477225
  455214
  531360
  419225
  432754
  417693
  623436
  495441
  624601
  785047
  575236
  747236
  785812
  446228
  385676
  587709
  417090
  442922
  792480
  779845
  478709
  487615
  513243
  451018
  488051
  805066
  729773
  453772
  542085
  652454
  707480
  459642
  495935
  398643
  470142
  723665
  817073
  676617
  792124
  793722
  757565
  727423
  735417
  754821
  763331
  777198
  791842
  810139
  391455
  425494
  441972
  422303
  427334
  422305
  447261
  472680
  489259
  557641
  569560
  557245
  571074
  601898
  409846
  412963
  79683
  471154
  478280
  450860
  523277
  523268
  501579
  485954
  385758
  404019
]
2.96 ms
(1.37%)
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
  79683
  385676
  385758
  391455
  398643
  404019
  409846
  412963
  417090
  417693
  417958
  419225
  420869
  422303
  422305
  425494
  425497
  427334
  432754
  438995
  441972
  442922
  443540
  444228
  446228
  447261
  450383
  450860
  451018
  453772
  455214
  456524
  459642
  469867
  470142
  471154
  471163
  471573
  472680
  474336
  476600
  477225
  478280
  478709
  485954
  487615
  488051
  489259
  490516
  495441
  495935
  501579
  504464
  506012
  513243
  516613
  523268
  523277
  527317
  531360
  542085
  544723
  550309
  553343
  557245
  557641
  561352
  569560
  571074
  575236
  582670
  587709
  588708
  589030
  601898
  623436
  624601
  636143
  651795
  652454
  661512
  671686
  676617
  696732
  707480
  722189
  723665
  727423
  729773
  735417
  736468
  738311
  741879
  747236
  747796
  754343
  754821
  757565
  763331
  763629
  765410
  772837
  777198
  777978
  779845
  782914
  785047
  785812
  787585
  788968
  791842
  792124
  792480
  793425
  793722
  794949
  796590
  805066
  810139
  817073
]
1.95 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вебкамер глубокийминет минет оральн секс"
]
1.88 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam deepthroat"
]
1.62 ms
(0.75%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(0.74%)
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.