Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.39 ms
(83.60%)
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
  402683
  407067
  409886
  410940
  411787
  416841
  421214
  425050
  426026
  428970
  429409
  430827
  431446
  437811
  437815
  443320
  449784
  452048
  452084
  456885
  457793
  461576
  462698
  466065
  471475
  471824
  477079
  481134
  482388
  494983
  497870
  498329
  500039
  502482
  502995
  503984
  508445
  514782
  515459
  518931
  522865
  523290
  523354
  523780
  528030
  528116
  529555
  540686
  540925
  545519
  548340
  548490
  548548
  551254
  558244
  560006
  562246
  565096
  567145
  567154
  568072
  568573
  568720
  569094
  570068
  570631
  575794
  577403
  578859
  579194
  586665
  589107
  592346
  595383
  597126
  597501
  597559
  598760
  598770
  599103
  600149
  601314
  601379
  601856
  601918
  603816
  605105
  605416
  608448
  609234
  611416
  611791
  614729
  618371
  618787
  618806
  618943
  619216
  620052
  620493
  621465
  621992
  623206
  624314
  624473
  634134
  634208
  634231
  639460
  647693
  652610
  652893
  653244
  653249
  653458
  654352
  654374
  654390
  661510
  755967
]
21.57 ms
(11.46%)
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
  755967
  652893
  502482
  654374
  598770
  437811
  528030
  618806
  647693
  540925
  618943
  409886
  471475
  498329
  551254
  568573
  579194
  548548
  562246
  565096
  634231
  428970
  410940
  518931
  529555
  508445
  452048
  609234
  503984
  523354
  494983
  421214
  416841
  462698
  620052
  589107
  597559
  437815
  482388
  426026
  457793
  570631
  661510
  569094
  618787
  456885
  514782
  558244
  598760
  624314
  500039
  653244
  578859
  634134
  611416
  595383
  614729
  443320
  528116
  429409
  452084
  548340
  568720
  592346
  567154
  653458
  545519
  570068
  597501
  411787
  407067
  540686
  586665
  430827
  471824
  477079
  502995
  623206
  605105
  466065
  425050
  577403
  515459
  575794
  624473
  605416
  619216
  523780
  548490
  654390
  449784
  481134
  654352
  611791
  600149
  618371
  461576
  497870
  568072
  634208
  639460
  621992
  560006
  603816
  653249
  652610
  601856
  608448
  621465
  522865
  620493
  599103
  601918
  601379
  431446
  402683
  523290
  567145
  597126
  601314
]
2.36 ms
(1.25%)
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
  402683
  407067
  409886
  410940
  411787
  416841
  421214
  425050
  426026
  428970
  429409
  430827
  431446
  437811
  437815
  443320
  449784
  452048
  452084
  456885
  457793
  461576
  462698
  466065
  471475
  471824
  477079
  481134
  482388
  494983
  497870
  498329
  500039
  502482
  502995
  503984
  508445
  514782
  515459
  518931
  522865
  523290
  523354
  523780
  528030
  528116
  529555
  540686
  540925
  545519
  548340
  548490
  548548
  551254
  558244
  560006
  562246
  565096
  567145
  567154
  568072
  568573
  568720
  569094
  570068
  570631
  575794
  577403
  578859
  579194
  586665
  589107
  592346
  595383
  597126
  597501
  597559
  598760
  598770
  599103
  600149
  601314
  601379
  601856
  601918
  603816
  605105
  605416
  608448
  609234
  611416
  611791
  614729
  618371
  618787
  618806
  618943
  619216
  620052
  620493
  621465
  621992
  623206
  624314
  624473
  634134
  634208
  634231
  639460
  647693
  652610
  652893
  653244
  653249
  653458
  654352
  654374
  654390
  661510
  755967
]
2.03 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "кончил попу студентки"
]
1.92 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм жоп студентк"
]
1.55 ms
(0.82%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.45 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.