Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
178.22 ms
(86.25%)
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
  8824
  53805
  322773
  357302
  371263
  382652
  383659
  384015
  386071
  386636
  391175
  393767
  395978
  396605
  397371
  400984
  402721
  406501
  409410
  410867
  417884
  450833
  456978
  457155
  458127
  458573
  470693
  514715
  515198
  529742
  530731
  539228
  539516
  543177
  560263
  566522
  581981
  582934
  594347
  597972
  604536
  608398
  625370
  650099
  652903
  664618
  668479
  675160
  675173
  677046
  678977
  683560
  684208
  684267
  694214
  713098
  715415
  719827
  723123
  728173
  733007
  734500
  735404
  736917
  740603
  744260
  744331
  748427
  748747
  752154
  755784
  755935
  763239
  764519
  766698
  767928
  767950
  770343
  771159
  772319
  773490
  774079
  774160
  774595
  776879
  780491
  780498
  784439
  786071
  788000
  789679
  790388
  794600
  795074
  798907
  798980
  800119
  800506
  800943
  802417
  803263
  807638
  810399
  810622
  810989
  811488
  813721
  814977
  816026
  817044
  818123
  818430
  819490
  819508
  819911
  821645
  822003
  823813
  824490
  826070
]
18.53 ms
(8.97%)
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
  776879
  780491
  450833
  675173
  771159
  786071
  733007
  748747
  755935
  764519
  773490
  470693
  406501
  357302
  457155
  694214
  784439
  748427
  529742
  581981
  798907
  417884
  788000
  8824
  456978
  458127
  539516
  664618
  650099
  322773
  393767
  53805
  566522
  800119
  810989
  770343
  386636
  402721
  400984
  715415
  736917
  774160
  774079
  409410
  766698
  814977
  594347
  386071
  384015
  515198
  790388
  803263
  822003
  543177
  391175
  813721
  798980
  802417
  810399
  767950
  800943
  382652
  677046
  744260
  604536
  560263
  582934
  723123
  772319
  794600
  795074
  734500
  763239
  740603
  810622
  530731
  668479
  678977
  625370
  774595
  800506
  755784
  752154
  397371
  396605
  410867
  819911
  826070
  817044
  819490
  819508
  458573
  652903
  684208
  713098
  683560
  684267
  719827
  597972
  608398
  789679
  811488
  767928
  728173
  735404
  744331
  807638
  395978
  383659
  539228
  675160
  780498
  514715
  371263
  821645
  818123
  818430
  824490
  816026
  823813
]
2.41 ms
(1.16%)
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
  8824
  53805
  322773
  357302
  371263
  382652
  383659
  384015
  386071
  386636
  391175
  393767
  395978
  396605
  397371
  400984
  402721
  406501
  409410
  410867
  417884
  450833
  456978
  457155
  458127
  458573
  470693
  514715
  515198
  529742
  530731
  539228
  539516
  543177
  560263
  566522
  581981
  582934
  594347
  597972
  604536
  608398
  625370
  650099
  652903
  664618
  668479
  675160
  675173
  677046
  678977
  683560
  684208
  684267
  694214
  713098
  715415
  719827
  723123
  728173
  733007
  734500
  735404
  736917
  740603
  744260
  744331
  748427
  748747
  752154
  755784
  755935
  763239
  764519
  766698
  767928
  767950
  770343
  771159
  772319
  773490
  774079
  774160
  774595
  776879
  780491
  780498
  784439
  786071
  788000
  789679
  790388
  794600
  795074
  798907
  798980
  800119
  800506
  800943
  802417
  803263
  807638
  810399
  810622
  810989
  811488
  813721
  814977
  816026
  817044
  818123
  818430
  819490
  819508
  819911
  821645
  822003
  823813
  824490
  826070
]
2.10 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "минет оральн секс оральн секс"
]
1.88 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "минет оральный секс"
]
1.71 ms
(0.83%)
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.