Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
170.55 ms
(86.89%)
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
  2291
  13428
  31015
  45799
  188389
  188462
  188501
  233617
  345630
  388500
  390045
  390508
  390794
  391917
  394152
  396981
  397167
  411688
  417789
  418954
  420300
  420903
  421795
  423095
  424118
  424124
  424547
  424765
  425984
  428115
  428610
  428840
  432438
  440755
  442070
  446750
  450287
  452189
  452810
  453323
  453334
  453562
  453571
  453719
  454461
  454958
  460368
  461902
  462605
  462707
  467016
  467837
  469393
  472403
  473376
  473384
  479261
  480903
  481747
  484181
  484561
  491860
  492005
  496512
  501553
  502827
  505833
  507167
  508422
  508653
  510334
  517705
  518399
  518975
  519333
  519751
  520114
  522211
  522218
  522486
  524803
  524991
  528581
  529166
  531566
  532341
  536430
  541850
  543404
  544109
  549689
  549727
  557605
  558755
  561506
  563724
  565632
  570177
  573196
  581013
  582262
  602704
  602753
  607576
  613117
  630142
  650664
  664241
  665113
  665142
  668807
  690882
  728009
  728469
  730994
  748521
  749248
  758278
  766248
  815051
]
15.84 ms
(8.07%)
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
  730994
  758278
  728009
  748521
  728469
  749248
  766248
  602704
  602753
  607576
  613117
  630142
  233617
  394152
  462605
  188462
  2291
  421795
  424118
  462707
  467016
  479261
  345630
  418954
  428840
  452810
  472403
  188389
  388500
  390794
  440755
  453562
  454461
  467837
  473376
  480903
  424124
  481747
  510334
  520114
  484181
  502827
  519751
  496512
  518399
  522211
  508653
  519333
  522218
  524991
  528581
  536430
  188501
  391917
  45799
  13428
  31015
  390045
  390508
  396981
  397167
  411688
  423095
  428610
  432438
  442070
  425984
  428115
  417789
  420300
  420903
  424547
  424765
  815051
  450287
  453323
  446750
  453719
  461902
  473384
  491860
  492005
  452189
  453334
  453571
  454958
  469393
  484561
  507167
  505833
  517705
  531566
  532341
  508422
  524803
  501553
  518975
  522486
  529166
  460368
  549689
  549727
  558755
  561506
  565632
  570177
  581013
  582262
  541850
  543404
  544109
  563724
  573196
  557605
  650664
  664241
  668807
  665113
  690882
  665142
]
2.90 ms
(1.48%)
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
  2291
  13428
  31015
  45799
  188389
  188462
  188501
  233617
  345630
  388500
  390045
  390508
  390794
  391917
  394152
  396981
  397167
  411688
  417789
  418954
  420300
  420903
  421795
  423095
  424118
  424124
  424547
  424765
  425984
  428115
  428610
  428840
  432438
  440755
  442070
  446750
  450287
  452189
  452810
  453323
  453334
  453562
  453571
  453719
  454461
  454958
  460368
  461902
  462605
  462707
  467016
  467837
  469393
  472403
  473376
  473384
  479261
  480903
  481747
  484181
  484561
  491860
  492005
  496512
  501553
  502827
  505833
  507167
  508422
  508653
  510334
  517705
  518399
  518975
  519333
  519751
  520114
  522211
  522218
  522486
  524803
  524991
  528581
  529166
  531566
  532341
  536430
  541850
  543404
  544109
  549689
  549727
  557605
  558755
  561506
  563724
  565632
  570177
  573196
  581013
  582262
  602704
  602753
  607576
  613117
  630142
  650664
  664241
  665113
  665142
  668807
  690882
  728009
  728469
  730994
  748521
  749248
  758278
  766248
  815051
]
1.97 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "riding chubby"
]
1.96 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "riding chubby"
]
1.60 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "riding chubby"
]
1.47 ms
(0.75%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.