Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.58 ms
(78.86%)
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
  96347
  187851
  202032
  365885
  390518
  390980
  395707
  396647
  413642
  414177
  421318
  424701
  430311
  434310
  436178
  438067
  448840
  452014
  454210
  468035
  475916
  483319
  484667
  484731
  489424
  493122
  494952
  495273
  517464
  522138
  525287
  530659
  533372
  533928
  536248
  537648
  539203
  540511
  541329
  542397
  544816
  544840
  545501
  551736
  557942
  559378
  564894
  566079
  582189
  593815
  593840
  599966
  599983
  600249
  600337
  600415
  600418
  603240
  603244
  605333
  612399
  613832
  631162
  631243
  632601
  634780
  639716
  639760
  640222
  642069
  642660
  644324
  647972
  649546
  649953
  650817
  653870
  663412
  663968
  664306
  664827
  665288
  665294
  666528
  667290
  667316
  667543
  669736
  674066
  674968
  677516
  678504
  698102
  699358
  699397
  713156
  721203
  722692
  728768
  734825
  734832
  740639
  741538
  741541
  745548
  751565
  752538
  770298
  776285
  776307
  777241
  787716
  789666
  799591
  807923
  809723
  814935
  815451
  819520
  819571
]
19.23 ms
(12.79%)
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
  593815
  483319
  613832
  721203
  533928
  544816
  545501
  678504
  666528
  631162
  600415
  612399
  600337
  664306
  745548
  582189
  454210
  600249
  468035
  663412
  663968
  644324
  533372
  699397
  665288
  667290
  669736
  593840
  734832
  599983
  642069
  667543
  728768
  722692
  202032
  542397
  787716
  807923
  776307
  390518
  395707
  819520
  677516
  600418
  789666
  740639
  809723
  713156
  665294
  674066
  770298
  741541
  776285
  365885
  664827
  777241
  734825
  752538
  699358
  475916
  667316
  605333
  649546
  632601
  544840
  674968
  541329
  603240
  489424
  653870
  599966
  639716
  522138
  517464
  536248
  537648
  647972
  493122
  495273
  421318
  438067
  603244
  484667
  650817
  448840
  551736
  639760
  557942
  559378
  494952
  413642
  424701
  640222
  741538
  814935
  631243
  390980
  414177
  484731
  187851
  396647
  698102
  525287
  799591
  436178
  642660
  815451
  539203
  649953
  634780
  751565
  430311
  564894
  434310
  452014
  540511
  530659
  566079
  96347
  819571
]
5.62 ms
(3.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dildo threesome"
]
2.46 ms
(1.63%)
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
  96347
  187851
  202032
  365885
  390518
  390980
  395707
  396647
  413642
  414177
  421318
  424701
  430311
  434310
  436178
  438067
  448840
  452014
  454210
  468035
  475916
  483319
  484667
  484731
  489424
  493122
  494952
  495273
  517464
  522138
  525287
  530659
  533372
  533928
  536248
  537648
  539203
  540511
  541329
  542397
  544816
  544840
  545501
  551736
  557942
  559378
  564894
  566079
  582189
  593815
  593840
  599966
  599983
  600249
  600337
  600415
  600418
  603240
  603244
  605333
  612399
  613832
  631162
  631243
  632601
  634780
  639716
  639760
  640222
  642069
  642660
  644324
  647972
  649546
  649953
  650817
  653870
  663412
  663968
  664306
  664827
  665288
  665294
  666528
  667290
  667316
  667543
  669736
  674066
  674968
  677516
  678504
  698102
  699358
  699397
  713156
  721203
  722692
  728768
  734825
  734832
  740639
  741538
  741541
  745548
  751565
  752538
  770298
  776285
  776307
  777241
  787716
  789666
  799591
  807923
  809723
  814935
  815451
  819520
  819571
]
1.65 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дилд секс втро"
]
1.44 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.39 ms
(0.92%)
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.