Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.87 ms
(83.77%)
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
  388290
  391545
  392554
  396215
  396235
  397353
  400026
  561906
  574813
  585781
  592357
  594162
  594267
  594430
  595446
  595447
  595515
  596594
  597552
  597553
  597801
  598001
  598451
  598476
  598489
  598508
  598712
  600104
  602014
  604143
  604259
  605329
  609645
  610688
  620554
  620904
  620978
  629243
  629598
  636530
  645202
  653229
  659324
  659432
  660342
  662047
  662204
  663231
  669288
  671660
  686387
  692259
  695264
  696107
  696111
  709037
  712174
  718656
  718693
  719640
  720386
  720388
  721417
  721424
  722782
  722899
  725133
  730764
  731984
  735085
  735112
  735930
  736682
  736887
  737298
  737553
  738818
  740373
  740651
  742188
  743391
  744270
  746423
  747402
  747447
  747574
  749328
  752673
  752725
  753155
  753302
  753800
  753911
  758887
  760942
  761482
  765278
  765573
  766788
  766844
  771134
  772991
  777138
  779010
  781052
  786522
  786963
  788540
  792485
  793663
  794809
  795858
  796731
  797389
  799785
  799862
  800575
  805669
  810210
  812288
]
15.44 ms
(9.45%)
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
  722899
  645202
  653229
  659432
  662204
  669288
  671660
  692259
  695264
  696107
  696111
  709037
  720386
  721424
  659324
  660342
  662047
  663231
  686387
  720388
  721417
  561906
  574813
  585781
  596594
  597552
  597801
  604143
  610688
  620554
  629598
  595446
  595447
  597553
  598001
  598451
  598476
  598489
  602014
  605329
  620904
  620978
  594267
  598508
  636530
  592357
  594162
  594430
  595515
  598712
  600104
  604259
  779010
  786963
  795858
  796731
  800575
  781052
  799785
  799862
  725133
  730764
  735930
  737553
  740373
  740651
  743391
  752673
  753302
  753800
  761482
  772991
  788540
  792485
  793663
  794809
  805669
  812288
  736887
  744270
  752725
  735085
  735112
  736682
  737298
  747574
  753911
  758887
  760942
  765278
  765573
  731984
  738818
  742188
  747402
  766844
  746423
  747447
  749328
  753155
  766788
  771134
  609645
  629243
  712174
  718656
  718693
  719640
  722782
  777138
  786522
  797389
  810210
  388290
  391545
  392554
  396215
  396235
  397353
  400026
]
3.22 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
  388290
  391545
  392554
  396215
  396235
  397353
  400026
  561906
  574813
  585781
  592357
  594162
  594267
  594430
  595446
  595447
  595515
  596594
  597552
  597553
  597801
  598001
  598451
  598476
  598489
  598508
  598712
  600104
  602014
  604143
  604259
  605329
  609645
  610688
  620554
  620904
  620978
  629243
  629598
  636530
  645202
  653229
  659324
  659432
  660342
  662047
  662204
  663231
  669288
  671660
  686387
  692259
  695264
  696107
  696111
  709037
  712174
  718656
  718693
  719640
  720386
  720388
  721417
  721424
  722782
  722899
  725133
  730764
  731984
  735085
  735112
  735930
  736682
  736887
  737298
  737553
  738818
  740373
  740651
  742188
  743391
  744270
  746423
  747402
  747447
  747574
  749328
  752673
  752725
  753155
  753302
  753800
  753911
  758887
  760942
  761482
  765278
  765573
  766788
  766844
  771134
  772991
  777138
  779010
  781052
  786522
  786963
  788540
  792485
  793663
  794809
  795858
  796731
  797389
  799785
  799862
  800575
  805669
  810210
  812288
]
2.18 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen 2023"
]
2.01 ms
(1.23%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.01 ms
(1.23%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen"
]
1.65 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen"
]

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.