Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.48 ms
(85.21%)
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
  154497
  228737
  271001
  383517
  385319
  386017
  418182
  418718
  437121
  445088
  448925
  450671
  471610
  503020
  507261
  513809
  519158
  524258
  535775
  538772
  548425
  549065
  557206
  557870
  564243
  565991
  572219
  588105
  599515
  599843
  600811
  605587
  609423
  610313
  610993
  617143
  621073
  622412
  622427
  625793
  627838
  630920
  634730
  643791
  647147
  648885
  652711
  654602
  658769
  661577
  663883
  667156
  667490
  676713
  678823
  679084
  683303
  687324
  691514
  697666
  698583
  699678
  700296
  712071
  712252
  714419
  715608
  717614
  718305
  720090
  720215
  720595
  726173
  736514
  738868
  739822
  741301
  747082
  748281
  762059
  762449
  764027
  765645
  765676
  765898
  767707
  767991
  768871
  768881
  769275
  773313
  782054
  782298
  784288
  788376
  796730
  798221
  798953
  798960
  799574
  802068
  803471
  803770
  805283
  805544
  807012
  808016
  808154
  808343
  809917
  810838
  811232
  812007
  813489
  814090
  816710
  818010
  818559
  819808
  827628
]
12.52 ms
(8.78%)
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
  767707
  769275
  726173
  739822
  765676
  768881
  622427
  630920
  643791
  715608
  803770
  808016
  809917
  386017
  383517
  154497
  271001
  418182
  445088
  814090
  818010
  818559
  816710
  819808
  827628
  471610
  503020
  513809
  519158
  535775
  538772
  524258
  507261
  565991
  572219
  548425
  549065
  654602
  663883
  667490
  697666
  699678
  712071
  647147
  667156
  676713
  678823
  683303
  687324
  712252
  717614
  720090
  720595
  648885
  652711
  658769
  661577
  679084
  691514
  718305
  557206
  557870
  564243
  605587
  617143
  622412
  625793
  609423
  610313
  588105
  599843
  610993
  621073
  627838
  599515
  600811
  782298
  788376
  798953
  799574
  805283
  807012
  808343
  810838
  812007
  782054
  798960
  803471
  736514
  784288
  796730
  802068
  805544
  808154
  811232
  813489
  741301
  762449
  762059
  764027
  773313
  765645
  765898
  738868
  747082
  748281
  767991
  768871
  634730
  698583
  700296
  714419
  720215
  798221
  448925
  385319
  228737
  418718
  437121
  450671
]
2.81 ms
(1.97%)
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
  154497
  228737
  271001
  383517
  385319
  386017
  418182
  418718
  437121
  445088
  448925
  450671
  471610
  503020
  507261
  513809
  519158
  524258
  535775
  538772
  548425
  549065
  557206
  557870
  564243
  565991
  572219
  588105
  599515
  599843
  600811
  605587
  609423
  610313
  610993
  617143
  621073
  622412
  622427
  625793
  627838
  630920
  634730
  643791
  647147
  648885
  652711
  654602
  658769
  661577
  663883
  667156
  667490
  676713
  678823
  679084
  683303
  687324
  691514
  697666
  698583
  699678
  700296
  712071
  712252
  714419
  715608
  717614
  718305
  720090
  720215
  720595
  726173
  736514
  738868
  739822
  741301
  747082
  748281
  762059
  762449
  764027
  765645
  765676
  765898
  767707
  767991
  768871
  768881
  769275
  773313
  782054
  782298
  784288
  788376
  796730
  798221
  798953
  798960
  799574
  802068
  803471
  803770
  805283
  805544
  807012
  808016
  808154
  808343
  809917
  810838
  811232
  812007
  813489
  814090
  816710
  818010
  818559
  819808
  827628
]
1.61 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "watch"
]
1.49 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "and watch"
]
1.21 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "watch"
]

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.