Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
238.88 ms
(90.29%)
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
  278428
  400955
  412101
  413808
  419312
  419471
  421550
  425207
  426080
  433925
  441249
  444035
  444939
  445838
  445954
  446606
  447334
  450129
  450130
  450154
  450867
  452185
  452375
  454471
  454622
  455331
  456153
  456694
  457895
  459959
  461751
  462782
  463460
  471460
  475816
  476086
  476781
  478343
  480664
  480892
  490263
  490707
  491331
  496687
  497077
  497234
  499514
  500095
  501507
  502368
  505061
  507249
  514234
  514946
  522084
  526508
  526684
  530103
  536419
  536441
  539940
  545821
  546308
  553256
  556199
  557433
  560260
  563301
  565964
  582592
  584501
  585586
  586047
  592644
  605905
  606268
  606974
  617672
  624196
  626245
  631301
  637488
  639648
  639666
  639669
  639702
  650082
  659262
  675686
  675690
  680443
  708457
  720459
  723209
  726974
  727745
  727778
  731111
  738892
  742288
  742653
  756535
  756640
  758992
  765250
  770116
  770958
  780771
  784740
  787214
  788497
  788828
  791246
  791567
  792390
  795918
  797191
  797231
  805254
  807392
]
14.18 ms
(5.36%)
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
  770116
  742288
  770958
  738892
  742653
  758992
  631301
  780771
  784740
  455331
  461751
  447334
  462782
  441249
  480892
  475816
  476086
  500095
  400955
  659262
  708457
  791246
  278428
  421550
  413808
  450154
  452185
  450130
  499514
  536441
  539940
  560260
  563301
  545821
  584501
  675690
  650082
  680443
  720459
  586047
  606268
  637488
  592644
  617672
  639648
  639666
  791567
  795918
  805254
  787214
  797231
  726974
  727745
  765250
  797191
  756535
  756640
  639669
  788828
  792390
  452375
  456694
  433925
  454622
  445954
  480664
  526684
  497077
  501507
  502368
  490263
  497234
  412101
  444035
  419471
  425207
  426080
  419312
  450129
  471460
  491331
  457895
  463460
  476781
  445838
  526508
  505061
  496687
  507249
  514234
  514946
  522084
  530103
  536419
  490707
  553256
  557433
  565964
  546308
  556199
  675686
  723209
  582592
  585586
  605905
  624196
  626245
  639702
  807392
  731111
  727778
  606974
  788497
  446606
  478343
  459959
  450867
  444939
  454471
  456153
]
3.97 ms
(1.50%)
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
  278428
  400955
  412101
  413808
  419312
  419471
  421550
  425207
  426080
  433925
  441249
  444035
  444939
  445838
  445954
  446606
  447334
  450129
  450130
  450154
  450867
  452185
  452375
  454471
  454622
  455331
  456153
  456694
  457895
  459959
  461751
  462782
  463460
  471460
  475816
  476086
  476781
  478343
  480664
  480892
  490263
  490707
  491331
  496687
  497077
  497234
  499514
  500095
  501507
  502368
  505061
  507249
  514234
  514946
  522084
  526508
  526684
  530103
  536419
  536441
  539940
  545821
  546308
  553256
  556199
  557433
  560260
  563301
  565964
  582592
  584501
  585586
  586047
  592644
  605905
  606268
  606974
  617672
  624196
  626245
  631301
  637488
  639648
  639666
  639669
  639702
  650082
  659262
  675686
  675690
  680443
  708457
  720459
  723209
  726974
  727745
  727778
  731111
  738892
  742288
  742653
  756535
  756640
  758992
  765250
  770116
  770958
  780771
  784740
  787214
  788497
  788828
  791246
  791567
  792390
  795918
  797191
  797231
  805254
  807392
]
2.10 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "doggystyle ass"
]
1.97 ms
(0.75%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "doggystyle жоп"
]
1.75 ms
(0.66%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(0.65%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "doggystyle жоп"
]

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.