Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.04 ms
(87.23%)
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
  381783
  391275
  399511
  409596
  419804
  422307
  424199
  434670
  436139
  443480
  443590
  444279
  445879
  447125
  451999
  453125
  454101
  454676
  455351
  455485
  456722
  458578
  459316
  459389
  460854
  462481
  462991
  463344
  464024
  464133
  465773
  466165
  466610
  470509
  471508
  472284
  472439
  472906
  479644
  483966
  484342
  486304
  487189
  487917
  489279
  489283
  490268
  491679
  492538
  496478
  499043
  499581
  500469
  503468
  503730
  504250
  504684
  504780
  505627
  507101
  508246
  509322
  510591
  510832
  511464
  513909
  516919
  518252
  518456
  520057
  520870
  522126
  522839
  523823
  524283
  524344
  524567
  525261
  525994
  526397
  527088
  527495
  527885
  528699
  530741
  539771
  543883
  548704
  552067
  554262
  555716
  556703
  557648
  558804
  562734
  564420
  564860
  565411
  565953
  567362
  568618
  572469
  578477
  580299
  594866
  596407
  598417
  599140
  603902
  615587
  618673
  622406
  630243
  647678
  652526
  653547
  654369
  655582
  672574
  676154
]
12.39 ms
(6.88%)
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
  618673
  526397
  451999
  447125
  496478
  527088
  543883
  455485
  443590
  486304
  504250
  487917
  445879
  483966
  399511
  548704
  557648
  580299
  564420
  654369
  630243
  594866
  599140
  489279
  524567
  596407
  565411
  524283
  556703
  652526
  672574
  572469
  491679
  647678
  622406
  464133
  443480
  455351
  530741
  523823
  520870
  381783
  419804
  436139
  466610
  454676
  500469
  539771
  518456
  503730
  513909
  479644
  522839
  524344
  525261
  422307
  472284
  520057
  503468
  504684
  578477
  552067
  564860
  655582
  676154
  554262
  567362
  615587
  499581
  653547
  598417
  568618
  558804
  444279
  460854
  490268
  507101
  508246
  528699
  462991
  391275
  453125
  459316
  499043
  511464
  565953
  555716
  603902
  458578
  466165
  424199
  459389
  434670
  472439
  505627
  518252
  487189
  525994
  527885
  510832
  527495
  454101
  472906
  456722
  462481
  522126
  562734
  409596
  465773
  470509
  471508
  463344
  464024
  509322
  516919
  484342
  489283
  492538
  510591
  504780
]
4.18 ms
(2.32%)
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
  381783
  391275
  399511
  409596
  419804
  422307
  424199
  434670
  436139
  443480
  443590
  444279
  445879
  447125
  451999
  453125
  454101
  454676
  455351
  455485
  456722
  458578
  459316
  459389
  460854
  462481
  462991
  463344
  464024
  464133
  465773
  466165
  466610
  470509
  471508
  472284
  472439
  472906
  479644
  483966
  484342
  486304
  487189
  487917
  489279
  489283
  490268
  491679
  492538
  496478
  499043
  499581
  500469
  503468
  503730
  504250
  504684
  504780
  505627
  507101
  508246
  509322
  510591
  510832
  511464
  513909
  516919
  518252
  518456
  520057
  520870
  522126
  522839
  523823
  524283
  524344
  524567
  525261
  525994
  526397
  527088
  527495
  527885
  528699
  530741
  539771
  543883
  548704
  552067
  554262
  555716
  556703
  557648
  558804
  562734
  564420
  564860
  565411
  565953
  567362
  568618
  572469
  578477
  580299
  594866
  596407
  598417
  599140
  603902
  615587
  618673
  622406
  630243
  647678
  652526
  653547
  654369
  655582
  672574
  676154
]
1.73 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большой большие член в шорт"
]
1.71 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большой большие член в шорт"
]
1.36 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
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.