Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
173.04 ms
(87.70%)
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
  117806
  233521
  301402
  317898
  385479
  388709
  390955
  391820
  396832
  402611
  403685
  415344
  420319
  420326
  420332
  425268
  428064
  429614
  441892
  444670
  453487
  453850
  453871
  461997
  470079
  471576
  475875
  476989
  477638
  479377
  480973
  490325
  496625
  497971
  500389
  504212
  506241
  511425
  513451
  523464
  530070
  530639
  537625
  537626
  537628
  537630
  541000
  547967
  553154
  557311
  566267
  566500
  568753
  570677
  578808
  591096
  601225
  606784
  611382
  614004
  614937
  618749
  622688
  622841
  631294
  633989
  634397
  637727
  637828
  645071
  654865
  669277
  673175
  674494
  675885
  680537
  687847
  688405
  701243
  701453
  707239
  707865
  710178
  712172
  715442
  716612
  721957
  721961
  729124
  733065
  733458
  734690
  740894
  744923
  746037
  747618
  747627
  748408
  750292
  750352
  754022
  756290
  757795
  762945
  763310
  767771
  767973
  769011
  782306
  783692
  795035
  795298
  795653
  795866
  795947
  798864
  801690
  811804
  812096
  817649
]
13.64 ms
(6.91%)
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
  746037
  748408
  633989
  637828
  707865
  712172
  715442
  541000
  767973
  317898
  385479
  428064
  530070
  537628
  566500
  611382
  733065
  537630
  480973
  801690
  762945
  795035
  769011
  754022
  721961
  795653
  420319
  388709
  420332
  233521
  402611
  470079
  453850
  453487
  622841
  674494
  747618
  500389
  403685
  537626
  669277
  425268
  471576
  496625
  537625
  557311
  566267
  570677
  673175
  675885
  701453
  645071
  688405
  710178
  654865
  687847
  568753
  606784
  631294
  634397
  614937
  618749
  744923
  750352
  637727
  701243
  716612
  461997
  477638
  578808
  591096
  614004
  783692
  729124
  530639
  497971
  601225
  733458
  513451
  453871
  301402
  429614
  511425
  795866
  795947
  734690
  811804
  812096
  756290
  740894
  750292
  757795
  767771
  747627
  763310
  721957
  782306
  444670
  420326
  396832
  817649
  798864
  795298
  117806
  506241
  490325
  475875
  415344
  390955
  441892
  547967
  553154
  479377
  391820
  523464
  680537
  622688
  707239
  476989
  504212
]
3.14 ms
(1.59%)
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
  117806
  233521
  301402
  317898
  385479
  388709
  390955
  391820
  396832
  402611
  403685
  415344
  420319
  420326
  420332
  425268
  428064
  429614
  441892
  444670
  453487
  453850
  453871
  461997
  470079
  471576
  475875
  476989
  477638
  479377
  480973
  490325
  496625
  497971
  500389
  504212
  506241
  511425
  513451
  523464
  530070
  530639
  537625
  537626
  537628
  537630
  541000
  547967
  553154
  557311
  566267
  566500
  568753
  570677
  578808
  591096
  601225
  606784
  611382
  614004
  614937
  618749
  622688
  622841
  631294
  633989
  634397
  637727
  637828
  645071
  654865
  669277
  673175
  674494
  675885
  680537
  687847
  688405
  701243
  701453
  707239
  707865
  710178
  712172
  715442
  716612
  721957
  721961
  729124
  733065
  733458
  734690
  740894
  744923
  746037
  747618
  747627
  748408
  750292
  750352
  754022
  756290
  757795
  762945
  763310
  767771
  767973
  769011
  782306
  783692
  795035
  795298
  795653
  795866
  795947
  798864
  801690
  811804
  812096
  817649
]
2.07 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hidden amateur"
]
2.01 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "скрыт любительск"
]
1.60 ms
(0.81%)
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.