Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
176.89 ms
(87.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
  6965
  249773
  358453
  365992
  373859
  381885
  384338
  392525
  395985
  396080
  396113
  396211
  396619
  397193
  402024
  410299
  439868
  446160
  451727
  457451
  461090
  474588
  475965
  476120
  478463
  489522
  490093
  516336
  518472
  519551
  530018
  530319
  530661
  531208
  536712
  538805
  539030
  540334
  540608
  541718
  546310
  548994
  554868
  565552
  568500
  572020
  590842
  593223
  596871
  597251
  598360
  602866
  604199
  619042
  620488
  626316
  626880
  629172
  639555
  642335
  657230
  658630
  659394
  665511
  668372
  675762
  680202
  684312
  686581
  693325
  694582
  707164
  715806
  720641
  722891
  724722
  725640
  727905
  729826
  731990
  734922
  736356
  742234
  742458
  742713
  748340
  752611
  752987
  753470
  757038
  758970
  759796
  766797
  766799
  769101
  769811
  777120
  778875
  778970
  781366
  782087
  788553
  789193
  790239
  791190
  791663
  800798
  811863
  813553
  817451
  820565
  820839
  825930
  825933
  826024
  826299
  826674
  827324
  827359
  828483
]
14.86 ms
(7.37%)
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
  629172
  778875
  396113
  791663
  734922
  826299
  827324
  791190
  439868
  817451
  451727
  540334
  680202
  659394
  693325
  597251
  788553
  731990
  729826
  725640
  722891
  790239
  811863
  778970
  531208
  530018
  540608
  684312
  446160
  476120
  518472
  626316
  742713
  396619
  538805
  568500
  657230
  665511
  686581
  720641
  694582
  715806
  707164
  546310
  604199
  619042
  620488
  602866
  642335
  590842
  598360
  626880
  639555
  789193
  800798
  781366
  782087
  766799
  736356
  759796
  769101
  727905
  748340
  752611
  757038
  596871
  554868
  536712
  373859
  381885
  396080
  826674
  827359
  828483
  752987
  742458
  766797
  365992
  396211
  461090
  478463
  519551
  475965
  490093
  489522
  516336
  826024
  825933
  675762
  724722
  742234
  530661
  397193
  825930
  530319
  668372
  658630
  758970
  777120
  457451
  474588
  769811
  6965
  384338
  392525
  813553
  593223
  753470
  249773
  395985
  358453
  402024
  410299
  820839
  820565
  539030
  541718
  548994
  565552
  572020
]
2.67 ms
(1.33%)
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
  6965
  249773
  358453
  365992
  373859
  381885
  384338
  392525
  395985
  396080
  396113
  396211
  396619
  397193
  402024
  410299
  439868
  446160
  451727
  457451
  461090
  474588
  475965
  476120
  478463
  489522
  490093
  516336
  518472
  519551
  530018
  530319
  530661
  531208
  536712
  538805
  539030
  540334
  540608
  541718
  546310
  548994
  554868
  565552
  568500
  572020
  590842
  593223
  596871
  597251
  598360
  602866
  604199
  619042
  620488
  626316
  626880
  629172
  639555
  642335
  657230
  658630
  659394
  665511
  668372
  675762
  680202
  684312
  686581
  693325
  694582
  707164
  715806
  720641
  722891
  724722
  725640
  727905
  729826
  731990
  734922
  736356
  742234
  742458
  742713
  748340
  752611
  752987
  753470
  757038
  758970
  759796
  766797
  766799
  769101
  769811
  777120
  778875
  778970
  781366
  782087
  788553
  789193
  790239
  791190
  791663
  800798
  811863
  813553
  817451
  820565
  820839
  825930
  825933
  826024
  826299
  826674
  827324
  827359
  828483
]
1.87 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в жопу худых"
]
1.87 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.84 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал худые"
]
1.55 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.