Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
219.35 ms
(90.00%)
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
  383464
  396881
  403769
  416155
  417562
  418636
  418646
  418795
  420808
  421609
  421806
  422348
  422386
  425299
  425302
  425306
  434887
  436830
  436850
  439480
  449499
  450119
  451655
  452429
  452680
  453833
  454036
  456738
  457545
  459087
  459607
  460685
  460833
  461151
  461166
  461309
  461323
  462259
  464562
  466471
  472850
  474982
  480334
  480697
  499034
  505782
  507674
  509329
  515010
  520437
  522209
  527261
  527596
  533246
  546292
  546568
  548992
  549080
  552638
  556493
  567297
  567872
  574732
  584949
  593795
  602932
  605281
  609422
  610275
  616098
  623037
  628618
  629868
  630351
  630893
  643573
  647916
  661616
  690154
  693103
  716693
  734334
  759417
  760679
  765092
  765102
  766263
  766354
  766668
  770623
  771177
  771657
  773746
  775264
  776161
  778543
  783992
  784981
  788839
  789058
  791688
  792767
  793555
  793663
  793871
  795632
  798045
  799095
  800523
  800554
  802823
  803309
  803806
  805075
  807419
  819857
  823659
  824434
  827825
]
15.27 ms
(6.27%)
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
  456738
  459607
  474982
  383464
  792767
  549080
  799095
  436830
  824434
  567297
  567872
  628618
  609422
  610275
  781177
  798045
  803806
  805075
  789058
  759417
  773746
  760679
  425306
  418646
  629868
  461323
  421806
  434887
  793663
  533246
  734334
  461151
  425302
  693103
  778543
  766354
  766668
  418636
  460685
  690154
  436850
  462259
  459087
  439480
  417562
  630351
  454036
  418795
  795632
  771177
  461166
  453833
  784981
  466471
  480697
  509329
  548992
  556493
  552638
  584949
  800523
  396881
  460833
  522209
  819857
  461309
  403769
  499034
  416155
  450119
  472850
  574732
  593795
  425299
  480334
  507674
  457545
  420808
  452680
  421609
  449499
  823659
  827825
  643573
  775264
  776161
  791688
  802823
  766263
  770623
  765092
  771657
  793871
  422348
  520437
  527596
  616098
  630893
  452429
  464562
  527261
  422386
  515010
  765102
  793555
  451655
  800554
  546292
  546568
  716693
  783992
  505782
  605281
  602932
  647916
  661616
  623037
  788839
  807419
  803309
]
2.94 ms
(1.21%)
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
  383464
  396881
  403769
  416155
  417562
  418636
  418646
  418795
  420808
  421609
  421806
  422348
  422386
  425299
  425302
  425306
  434887
  436830
  436850
  439480
  449499
  450119
  451655
  452429
  452680
  453833
  454036
  456738
  457545
  459087
  459607
  460685
  460833
  461151
  461166
  461309
  461323
  462259
  464562
  466471
  472850
  474982
  480334
  480697
  499034
  505782
  507674
  509329
  515010
  520437
  522209
  527261
  527596
  533246
  546292
  546568
  548992
  549080
  552638
  556493
  567297
  567872
  574732
  584949
  593795
  602932
  605281
  609422
  610275
  616098
  623037
  628618
  629868
  630351
  630893
  643573
  647916
  661616
  690154
  693103
  716693
  734334
  759417
  760679
  765092
  765102
  766263
  766354
  766668
  770623
  771177
  771657
  773746
  775264
  776161
  778543
  783992
  784981
  788839
  789058
  791688
  792767
  793555
  793663
  793871
  795632
  798045
  799095
  800523
  800554
  802823
  803309
  803806
  805075
  807419
  819857
  823659
  824434
  827825
]
1.95 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pov creampie blowjob"
]
1.56 ms
(0.64%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов creampie минет оральн секс"
]
1.36 ms
(0.56%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.30 ms
(0.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "пов creampie минет оральн секс"
]

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.