Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.87 ms
(85.54%)
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
  382460
  396570
  406957
  410687
  414001
  442418
  445946
  448722
  452391
  457301
  459764
  464426
  466709
  467638
  468556
  493201
  524755
  532952
  533983
  534848
  546308
  546785
  566318
  567360
  568560
  569929
  569973
  570150
  570171
  570175
  575909
  580653
  583947
  583948
  585573
  589551
  589754
  593608
  594583
  595421
  596061
  601544
  601599
  604517
  604575
  604614
  604905
  605581
  606725
  607012
  607080
  610563
  610615
  612125
  612855
  613122
  614022
  617157
  618402
  619487
  620173
  623910
  624436
  624653
  627372
  629965
  631214
  632261
  633171
  633423
  634471
  637687
  638533
  638555
  640008
  640798
  644967
  648925
  650011
  651166
  656321
  663254
  665930
  669566
  671745
  676427
  689376
  690105
  691254
  697368
  710259
  714900
  716292
  717770
  718388
  719838
  721062
  723584
  725596
  728571
  740617
  743822
  744651
  745051
  790894
  797659
  802682
  805112
  806089
  807766
  808775
  811840
  813074
  814638
  814664
  815201
  815396
  815525
  816441
  817781
]
12.15 ms
(8.32%)
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
  468556
  583948
  569973
  566318
  570175
  669566
  671745
  656321
  697368
  719838
  610563
  633171
  607012
  620173
  631214
  593608
  596061
  605581
  619487
  623910
  634471
  637687
  617157
  618402
  805112
  813074
  740617
  802682
  807766
  808775
  728571
  725596
  743822
  744651
  745051
  624653
  629965
  721062
  790894
  797659
  806089
  811840
  396570
  414001
  406957
  467638
  569929
  612125
  632261
  633423
  604517
  382460
  442418
  410687
  815201
  815525
  723584
  644967
  814638
  816441
  817781
  814664
  815396
  448722
  452391
  459764
  445946
  457301
  464426
  466709
  493201
  524755
  532952
  533983
  534848
  570171
  570150
  580653
  546308
  567360
  568560
  663254
  665930
  710259
  718388
  648925
  650011
  651166
  714900
  716292
  717770
  676427
  689376
  690105
  691254
  546785
  575909
  583947
  589754
  604905
  607080
  638555
  585573
  589551
  594583
  604575
  604614
  606725
  613122
  614022
  624436
  640008
  640798
  601599
  610615
  612855
  627372
  638533
  595421
  601544
]
2.67 ms
(1.83%)
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
  382460
  396570
  406957
  410687
  414001
  442418
  445946
  448722
  452391
  457301
  459764
  464426
  466709
  467638
  468556
  493201
  524755
  532952
  533983
  534848
  546308
  546785
  566318
  567360
  568560
  569929
  569973
  570150
  570171
  570175
  575909
  580653
  583947
  583948
  585573
  589551
  589754
  593608
  594583
  595421
  596061
  601544
  601599
  604517
  604575
  604614
  604905
  605581
  606725
  607012
  607080
  610563
  610615
  612125
  612855
  613122
  614022
  617157
  618402
  619487
  620173
  623910
  624436
  624653
  627372
  629965
  631214
  632261
  633171
  633423
  634471
  637687
  638533
  638555
  640008
  640798
  644967
  648925
  650011
  651166
  656321
  663254
  665930
  669566
  671745
  676427
  689376
  690105
  691254
  697368
  710259
  714900
  716292
  717770
  718388
  719838
  721062
  723584
  725596
  728571
  740617
  743822
  744651
  745051
  790894
  797659
  802682
  805112
  806089
  807766
  808775
  811840
  813074
  814638
  814664
  815201
  815396
  815525
  816441
  817781
]
1.97 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom and bbc"
]
1.60 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom bbc"
]
1.24 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom bbc"
]

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.