Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.17 ms
(85.17%)
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
  418363
  445946
  448722
  452391
  457301
  464426
  466709
  467638
  493201
  499332
  524755
  525226
  532952
  533007
  533983
  534848
  540511
  546308
  546785
  562376
  562796
  567360
  568560
  570150
  570171
  573309
  575909
  580653
  583947
  585573
  589551
  589754
  593608
  594583
  595421
  596061
  600296
  601544
  601599
  604515
  604575
  604614
  605461
  605581
  606725
  607080
  610615
  612855
  612959
  613122
  614993
  615846
  619487
  623910
  624436
  624653
  627372
  629965
  631194
  631214
  634471
  637687
  638533
  638555
  640008
  640798
  644967
  648925
  650011
  651166
  665930
  676427
  678053
  689376
  690105
  691254
  710259
  714900
  716292
  717770
  718388
  721062
  732547
  743822
  745051
  760676
  765482
  776822
  778055
  784151
  785093
  788924
  790894
  792569
  797659
  798275
  798569
  800288
  802682
  805112
  805424
  805932
  806089
  807641
  807766
  808775
  811840
  813074
  814664
  815201
  815396
  815525
  816441
  817781
  827290
]
16.74 ms
(9.31%)
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
  631214
  593608
  596061
  605581
  619487
  623910
  634471
  637687
  805112
  813074
  802682
  807766
  808775
  743822
  745051
  624653
  629965
  721062
  790894
  797659
  806089
  811840
  396570
  414001
  406957
  467638
  540511
  533007
  573309
  562796
  678053
  600296
  605461
  614993
  631194
  418363
  525226
  499332
  562376
  382460
  410687
  815201
  815525
  644967
  827290
  816441
  817781
  814664
  815396
  448722
  452391
  445946
  457301
  464426
  466709
  493201
  524755
  532952
  533983
  534848
  570171
  570150
  580653
  546308
  567360
  568560
  665930
  710259
  718388
  648925
  650011
  651166
  714900
  716292
  717770
  676427
  689376
  690105
  691254
  546785
  575909
  583947
  589754
  607080
  638555
  585573
  589551
  594583
  604575
  604614
  606725
  613122
  624436
  640008
  640798
  601599
  610615
  612855
  627372
  638533
  595421
  601544
  604515
  612959
  615846
  788924
  805932
  776822
  778055
  800288
  805424
  760676
  784151
  785093
  792569
  798275
  798569
  807641
  732547
  765482
]
2.67 ms
(1.48%)
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
  418363
  445946
  448722
  452391
  457301
  464426
  466709
  467638
  493201
  499332
  524755
  525226
  532952
  533007
  533983
  534848
  540511
  546308
  546785
  562376
  562796
  567360
  568560
  570150
  570171
  573309
  575909
  580653
  583947
  585573
  589551
  589754
  593608
  594583
  595421
  596061
  600296
  601544
  601599
  604515
  604575
  604614
  605461
  605581
  606725
  607080
  610615
  612855
  612959
  613122
  614993
  615846
  619487
  623910
  624436
  624653
  627372
  629965
  631194
  631214
  634471
  637687
  638533
  638555
  640008
  640798
  644967
  648925
  650011
  651166
  665930
  676427
  678053
  689376
  690105
  691254
  710259
  714900
  716292
  717770
  718388
  721062
  732547
  743822
  745051
  760676
  765482
  776822
  778055
  784151
  785093
  788924
  790894
  792569
  797659
  798275
  798569
  800288
  802682
  805112
  805424
  805932
  806089
  807641
  807766
  808775
  811840
  813074
  814664
  815201
  815396
  815525
  816441
  817781
  827290
]
2.09 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom milf bbc"
]
2.01 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom milf bbc"
]
1.43 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom milf 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.