Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.01 ms
(86.38%)
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
  392765
  488130
  546137
  560377
  576766
  580459
  586978
  601116
  622972
  639209
  639871
  647256
  674101
  694409
  701938
  702360
  704874
  707361
  707600
  708152
  709691
  719032
  721069
  724445
  727422
  732164
  733479
  733491
  736774
  737641
  740112
  741823
  742053
  744414
  745318
  746147
  746581
  746691
  752516
  758107
  761386
  761387
  761403
  761837
  763999
  766931
  766966
  766981
  767570
  767899
  769185
  769226
  773120
  774166
  774334
  774917
  774919
  776865
  778497
  778606
  779742
  779799
  780094
  780210
  781316
  781336
  787482
  787689
  787764
  790649
  790662
  791254
  791779
  792439
  792442
  792476
  794267
  794431
  794579
  795361
  795808
  795852
  795904
  796693
  797289
  797727
  797730
  798142
  800173
  800560
  801486
  802077
  802092
  802285
  802979
  804718
  809708
  809820
  810293
  811406
  817032
  817418
  817548
  817916
  817954
  819284
  819447
  819702
  825972
  826481
  826677
  826757
  826964
  828462
  828544
  828770
  828785
]
9.31 ms
(6.75%)
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
  392765
  826481
  826677
  817032
  826757
  826964
  817548
  817916
  819447
  817418
  817954
  819284
  819702
  825972
  826081
  828770
  828785
  828544
  828462
  488130
  546137
  580459
  560377
  576766
  674101
  701938
  702360
  704874
  647256
  694409
  707600
  707361
  708152
  709691
  719032
  721069
  586978
  622972
  601116
  639871
  639209
  791779
  792439
  794267
  794431
  800560
  801486
  804718
  774917
  774919
  776865
  778497
  778606
  779742
  779799
  780094
  780210
  781316
  781336
  787764
  790649
  791254
  794579
  795361
  795808
  795904
  796693
  797289
  797730
  802092
  802285
  809708
  809820
  810293
  811406
  740112
  741823
  742053
  746581
  752516
  761386
  766931
  766981
  767890
  769185
  769187
  787482
  787689
  790662
  792442
  792476
  795852
  797727
  798142
  800173
  802077
  802979
  724445
  737641
  758107
  761403
  761837
  766966
  767899
  769226
  774166
  727422
  733479
  733491
  744414
  746147
  773120
  774334
  732164
  736774
  745318
  746691
  761387
  763999
  767570
]
2.27 ms
(1.65%)
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
  392765
  488130
  546137
  560377
  576766
  580459
  586978
  601116
  622972
  639209
  639871
  647256
  674101
  694409
  701938
  702360
  704874
  707361
  707600
  708152
  709691
  719032
  721069
  724445
  727422
  732164
  733479
  733491
  736774
  737641
  740112
  741823
  742053
  744414
  745318
  746147
  746581
  746691
  752516
  758107
  761386
  761387
  761403
  761837
  763999
  766931
  766966
  766981
  767570
  767899
  769185
  769226
  773120
  774166
  774334
  774917
  774919
  776865
  778497
  778606
  779742
  779799
  780094
  780210
  781316
  781336
  787482
  787689
  787764
  790649
  790662
  791254
  791779
  792439
  792442
  792476
  794267
  794431
  794579
  795361
  795808
  795852
  795904
  796693
  797289
  797727
  797730
  798142
  800173
  800560
  801486
  802077
  802092
  802285
  802979
  804718
  809708
  809820
  810293
  811406
  817032
  817418
  817548
  817916
  817954
  819284
  819447
  819702
  825972
  826481
  826677
  826757
  826964
  828462
  828544
  828770
  828785
]
2.13 ms
(1.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "сам себе дрочит"
]
1.84 ms
(1.33%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дрочк"
]
1.57 ms
(1.14%)
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.