Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.51 ms
(85.97%)
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
  147400
  148793
  191470
  381764
  381941
  383362
  383394
  383926
  384507
  386366
  386697
  391340
  393087
  395145
  396365
  396571
  397648
  397807
  398518
  398613
  399247
  399273
  399356
  401379
  401517
  402350
  404237
  406191
  409066
  416931
  443965
  447795
  453134
  456991
  463845
  467105
  467601
  472575
  479703
  479708
  493806
  498485
  529254
  533306
  538158
  538440
  545433
  554525
  556826
  566054
  575446
  582445
  601039
  604498
  609840
  609993
  613625
  634216
  634645
  635356
  636539
  637754
  641075
  641548
  643964
  644375
  663367
  663438
  673624
  682076
  682248
  687532
  689642
  690884
  697262
  698027
  705629
  709309
  715553
  717313
  717509
  722549
  723751
  734794
  744607
  747729
  754170
  757458
  761385
  761563
  770904
  774243
  774601
  775607
  775662
  776599
  783276
  792572
  792816
  795522
  800016
  802688
  803449
  803669
  805302
  807774
  808056
  810233
  811867
  820662
  822153
  823401
  824464
  825241
  827875
]
15.55 ms
(8.77%)
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
  717509
  399356
  404237
  147400
  825241
  538440
  698027
  802688
  770904
  467105
  811867
  397648
  399273
  401379
  582445
  637754
  386366
  406191
  409066
  472575
  463845
  493806
  479703
  554525
  774243
  705629
  381941
  396365
  148793
  792572
  467601
  795522
  800016
  810233
  697262
  383394
  824464
  538158
  663438
  682248
  663367
  682076
  717313
  545433
  609993
  643964
  604498
  613625
  644375
  601039
  634645
  776599
  807774
  774601
  723751
  744607
  761385
  792816
  709309
  715553
  805302
  383362
  393087
  395145
  398518
  416931
  822153
  820662
  823401
  827875
  529254
  540323
  556826
  566054
  689642
  673624
  634216
  641075
  775607
  783276
  803449
  803669
  747729
  754170
  757458
  761563
  609840
  641548
  722549
  808056
  479708
  575446
  383926
  381764
  95990
  687532
  635356
  191470
  384507
  399247
  386697
  498485
  80900
  82252
  31604
  391340
  397807
  402350
  401517
  447795
  456991
  690884
  636539
  775662
  734794
  396571
  398613
  443965
  453134
  533306
]
3.08 ms
(1.74%)
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
  147400
  148793
  191470
  381764
  381941
  383362
  383394
  383926
  384507
  386366
  386697
  391340
  393087
  395145
  396365
  396571
  397648
  397807
  398518
  398613
  399247
  399273
  399356
  401379
  401517
  402350
  404237
  406191
  409066
  416931
  443965
  447795
  453134
  456991
  463845
  467105
  467601
  472575
  479703
  479708
  493806
  498485
  529254
  533306
  538158
  538440
  545433
  554525
  556826
  566054
  575446
  582445
  601039
  604498
  609840
  609993
  613625
  634216
  634645
  635356
  636539
  637754
  641075
  641548
  643964
  644375
  663367
  663438
  673624
  682076
  682248
  687532
  689642
  690884
  697262
  698027
  705629
  709309
  715553
  717313
  717509
  722549
  723751
  734794
  744607
  747729
  754170
  757458
  761385
  761563
  770904
  774243
  774601
  775607
  775662
  776599
  783276
  792572
  792816
  795522
  800016
  802688
  803449
  803669
  805302
  807774
  808056
  810233
  811867
  820662
  822153
  823401
  824464
  825241
  827875
]
1.89 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "interracial tits"
]
1.60 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.83%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "межрасов сиськ"
]
1.31 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.