Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
327.46 ms
(92.47%)
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
  82281
  401228
  432136
  432250
  454345
  454362
  473549
  474415
  476438
  479177
  484244
  485302
  487902
  489595
  490208
  491647
  495152
  503802
  512246
  512336
  513888
  515170
  515171
  515175
  515177
  515902
  519927
  519929
  519936
  520714
  520722
  529300
  548655
  574476
  575087
  575088
  575115
  575488
  576074
  576080
  576416
  578071
  581673
  595869
  596659
  597135
  604709
  605565
  606783
  609682
  611820
  613166
  614849
  615433
  615705
  621025
  621196
  624255
  641120
  644660
  644698
  652892
  654764
  654775
  655050
  655071
  655121
  655417
  655655
  655940
  656761
  657079
  657325
  658065
  658631
  659693
  659858
  660512
  660918
  663936
  663952
  685767
  686057
  688083
  698089
  708476
  712905
  712907
  715083
  723675
  725138
  725401
  725987
  727330
  729588
  731736
  737571
  738855
  741433
  741602
  742174
  742209
  742211
  744930
  745015
  745844
  766570
  777203
  781651
  781656
  781671
  781712
  781727
  788134
  788481
  789656
  789973
  790896
  804964
  807493
]
17.27 ms
(4.88%)
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
  644660
  614849
  804964
  727330
  788481
  725401
  729588
  742211
  745844
  742174
  454345
  401228
  474415
  575087
  575115
  575488
  576416
  548655
  575088
  581673
  663952
  609682
  519929
  490208
  489595
  519936
  82281
  578071
  654764
  655655
  655940
  655050
  657325
  658631
  685767
  659858
  686057
  597135
  604709
  777203
  781656
  781712
  737571
  723675
  725987
  731736
  615705
  715083
  789656
  790896
  529300
  520714
  596659
  515171
  487902
  515170
  515175
  432250
  476438
  515902
  576074
  503802
  513888
  519927
  491647
  512336
  520722
  484244
  515177
  495152
  485302
  574476
  652892
  654775
  656761
  659693
  655071
  655121
  658065
  660918
  663936
  712905
  655417
  657079
  660512
  688083
  698089
  708476
  712907
  595869
  613166
  615433
  644698
  605565
  606783
  621025
  621196
  641120
  781651
  781727
  789973
  788134
  766570
  738855
  741602
  744930
  741433
  725138
  742209
  745015
  624255
  781671
  807493
  473549
  432136
  479177
  454362
  512246
  576080
  611820
]
2.50 ms
(0.71%)
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
  82281
  401228
  432136
  432250
  454345
  454362
  473549
  474415
  476438
  479177
  484244
  485302
  487902
  489595
  490208
  491647
  495152
  503802
  512246
  512336
  513888
  515170
  515171
  515175
  515177
  515902
  519927
  519929
  519936
  520714
  520722
  529300
  548655
  574476
  575087
  575088
  575115
  575488
  576074
  576080
  576416
  578071
  581673
  595869
  596659
  597135
  604709
  605565
  606783
  609682
  611820
  613166
  614849
  615433
  615705
  621025
  621196
  624255
  641120
  644660
  644698
  652892
  654764
  654775
  655050
  655071
  655121
  655417
  655655
  655940
  656761
  657079
  657325
  658065
  658631
  659693
  659858
  660512
  660918
  663936
  663952
  685767
  686057
  688083
  698089
  708476
  712905
  712907
  715083
  723675
  725138
  725401
  725987
  727330
  729588
  731736
  737571
  738855
  741433
  741602
  742174
  742209
  742211
  744930
  745015
  745844
  766570
  777203
  781651
  781656
  781671
  781712
  781727
  788134
  788481
  789656
  789973
  790896
  804964
  807493
]
2.08 ms
(0.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cuckold old"
]
1.76 ms
(0.50%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "куколд old"
]
1.42 ms
(0.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "куколд old"
]

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.