Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.66 ms
(59.26%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
121.24 ms
(33.95%)
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
  31604
  80900
  82252
  95990
  148793
  191470
  381764
  381941
  383362
  383394
  383926
  384507
  386366
  386697
  391340
  393087
  395145
  396365
  396571
  397648
  397807
  398518
  398613
  399247
  399273
  401379
  401517
  402350
  404230
  406191
  409066
  416931
  433863
  447795
  453134
  456991
  463845
  467105
  467601
  472575
  479703
  479708
  493806
  498485
  529254
  538158
  538440
  545433
  554525
  556826
  566054
  575446
  582445
  601039
  604498
  609840
  609993
  613625
  634216
  634645
  635356
  636539
  637754
  641075
  641548
  643964
  644375
  654638
  663367
  663438
  665337
  673624
  682076
  682248
  687532
  689642
  690884
  697262
  698027
  705629
  709309
  715553
  717313
  722549
  723751
  734794
  744607
  747729
  754170
  757458
  761385
  761563
  770904
  770945
  774243
  774601
  775607
  775662
  776599
  783276
  792572
  792595
  792816
  795522
  800016
  803449
  803669
  805302
  807774
  808056
  810233
  811867
  820662
  822153
  823401
  824464
  825241
  827875
  827896
]
16.51 ms
(4.62%)
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
  827896
  654638
  770945
  825241
  538440
  770904
  404230
  698027
  397648
  401379
  467105
  399273
  811867
  386366
  409066
  479703
  406191
  705629
  381941
  396365
  148793
  472575
  463845
  493806
  554525
  774243
  582445
  637754
  792572
  803449
  383362
  395145
  747729
  754170
  757458
  761563
  722549
  795522
  800016
  810233
  467601
  697262
  393087
  822153
  820662
  823401
  827875
  529254
  540323
  556826
  566054
  689642
  673624
  634216
  641075
  803669
  609840
  383394
  538158
  643964
  805302
  824464
  663438
  682248
  663367
  682076
  717313
  545433
  609993
  604498
  613625
  644375
  601039
  634645
  807774
  723751
  744607
  761385
  792816
  709309
  715553
  398518
  416931
  775607
  783276
  641548
  808056
  479708
  383926
  776599
  774601
  191470
  384507
  399247
  95990
  687532
  381764
  635356
  402350
  82252
  398613
  31604
  456991
  690884
  636539
  734794
  80900
  391340
  397807
  401517
  447795
  775662
  396571
  498485
  575446
  792595
  386697
  453134
  665337
  433863
]
2.45 ms
(0.69%)
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
  31604
  80900
  82252
  95990
  148793
  191470
  381764
  381941
  383362
  383394
  383926
  384507
  386366
  386697
  391340
  393087
  395145
  396365
  396571
  397648
  397807
  398518
  398613
  399247
  399273
  401379
  401517
  402350
  404230
  406191
  409066
  416931
  433863
  447795
  453134
  456991
  463845
  467105
  467601
  472575
  479703
  479708
  493806
  498485
  529254
  538158
  538440
  545433
  554525
  556826
  566054
  575446
  582445
  601039
  604498
  609840
  609993
  613625
  634216
  634645
  635356
  636539
  637754
  641075
  641548
  643964
  644375
  654638
  663367
  663438
  665337
  673624
  682076
  682248
  687532
  689642
  690884
  697262
  698027
  705629
  709309
  715553
  717313
  722549
  723751
  734794
  744607
  747729
  754170
  757458
  761385
  761563
  770904
  770945
  774243
  774601
  775607
  775662
  776599
  783276
  792572
  792595
  792816
  795522
  800016
  803449
  803669
  805302
  807774
  808056
  810233
  811867
  820662
  822153
  823401
  824464
  825241
  827875
  827896
]
1.85 ms
(0.52%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "межрасов большие сиськ"
]
1.83 ms
(0.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "межрасов большие сиськ"
]
1.61 ms
(0.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "interracial big tits"
]

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.