Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.24 ms
(88.27%)
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
  81656
  396115
  402676
  431953
  436820
  470711
  482687
  488935
  513696
  513771
  521833
  522132
  530259
  530737
  531160
  533649
  534227
  534287
  540051
  545766
  552606
  556919
  558372
  562114
  564583
  568236
  572681
  578512
  582383
  585734
  609858
  611723
  613972
  615386
  615517
  615579
  616243
  624172
  625372
  632114
  633139
  638184
  639258
  639934
  640909
  644656
  647311
  650060
  651173
  656533
  660260
  661649
  671677
  673358
  678561
  678568
  679080
  679124
  679128
  682405
  689145
  692324
  694114
  694482
  695192
  695278
  695280
  695338
  695930
  697262
  697263
  697372
  697806
  697973
  698009
  698597
  699762
  700282
  700617
  702769
  707629
  713023
  714138
  716667
  722448
  722548
  722731
  724011
  725293
  726520
  731317
  733881
  735938
  736881
  737594
  741947
  743120
  743130
  746991
  749390
  765773
  770581
  772026
  777639
  779187
  784716
  786919
  790200
  791205
  796301
  798599
  799672
  799722
  800305
  801728
  809459
  809512
  810694
  811770
  812141
]
11.43 ms
(6.76%)
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
  647311
  746991
  692324
  695280
  695278
  556919
  698009
  698597
  436820
  811770
  809459
  699762
  702769
  722448
  616243
  638184
  779187
  749390
  640909
  673358
  513771
  644656
  799672
  585734
  678568
  611723
  741947
  722548
  694482
  724011
  540051
  700282
  697372
  533649
  552606
  695338
  615386
  737594
  736881
  558372
  679124
  656533
  801728
  661649
  810694
  682405
  697262
  531160
  650060
  695192
  564583
  772026
  791205
  431953
  639934
  633139
  697973
  572681
  396115
  694114
  725293
  530259
  689145
  707629
  625372
  735938
  513696
  671677
  733881
  521833
  81656
  562114
  639258
  812141
  534287
  679128
  545766
  488935
  697263
  660260
  714138
  716667
  777639
  731317
  765773
  695930
  700617
  678561
  651173
  770581
  743130
  578512
  470711
  784716
  530737
  568236
  632114
  786919
  534227
  722731
  615579
  713023
  624172
  790200
  798599
  615517
  743120
  613972
  796301
  726520
  482687
  800305
  697806
  799722
  402676
  582383
  679080
  609858
  522132
  809512
]
2.16 ms
(1.28%)
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
  81656
  396115
  402676
  431953
  436820
  470711
  482687
  488935
  513696
  513771
  521833
  522132
  530259
  530737
  531160
  533649
  534227
  534287
  540051
  545766
  552606
  556919
  558372
  562114
  564583
  568236
  572681
  578512
  582383
  585734
  609858
  611723
  613972
  615386
  615517
  615579
  616243
  624172
  625372
  632114
  633139
  638184
  639258
  639934
  640909
  644656
  647311
  650060
  651173
  656533
  660260
  661649
  671677
  673358
  678561
  678568
  679080
  679124
  679128
  682405
  689145
  692324
  694114
  694482
  695192
  695278
  695280
  695338
  695930
  697262
  697263
  697372
  697806
  697973
  698009
  698597
  699762
  700282
  700617
  702769
  707629
  713023
  714138
  716667
  722448
  722548
  722731
  724011
  725293
  726520
  731317
  733881
  735938
  736881
  737594
  741947
  743120
  743130
  746991
  749390
  765773
  770581
  772026
  777639
  779187
  784716
  786919
  790200
  791205
  796301
  798599
  799672
  799722
  800305
  801728
  809459
  809512
  810694
  811770
  812141
]
1.63 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "2 girls blowjob"
]
1.63 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.51 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "два девушк минет оральн секс"
]
1.46 ms
(0.86%)
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.