Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
172.11 ms
(88.14%)
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
  118008
  118227
  387720
  401204
  401768
  412779
  412830
  413687
  414050
  416597
  417246
  421740
  424370
  426816
  429609
  429938
  432255
  439038
  441864
  442511
  443568
  443865
  445533
  448559
  452643
  452815
  459201
  459778
  460070
  461612
  465454
  465497
  468348
  470404
  470405
  471669
  471693
  474580
  475319
  475947
  477055
  477760
  489014
  489311
  493237
  493618
  493679
  500787
  502462
  505109
  514849
  521241
  529597
  534554
  541277
  547422
  548260
  580069
  613518
  623130
  623171
  630039
  630096
  691511
  696871
  699415
  715877
  717664
  720067
  720224
  724118
  724240
  728518
  731234
  731327
  731482
  734346
  736356
  737852
  742916
  745112
  747633
  748068
  754207
  759796
  760888
  765334
  765555
  773912
  775543
  777013
  777029
  780665
  783180
  783275
  783428
  783718
  784298
  788193
  788786
  790637
  792671
  793138
  794765
  794859
  795425
  795704
  795706
  796532
  799917
  800566
  803243
  805651
  806046
  815266
  817194
  817218
  818959
  819749
  826154
]
13.04 ms
(6.68%)
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
  775543
  783718
  790637
  792671
  795706
  796532
  799917
  803243
  806046
  731482
  734346
  754207
  760888
  783180
  784298
  794765
  800566
  731234
  737852
  765555
  724118
  728518
  736356
  742916
  745112
  759796
  773912
  724240
  731327
  747633
  613518
  623130
  630039
  699415
  777029
  780665
  783275
  788786
  793138
  795425
  805651
  717664
  720067
  630096
  777013
  794859
  765334
  696871
  529597
  715877
  783428
  521241
  118008
  401768
  432255
  441864
  443865
  417246
  429609
  477760
  493618
  445533
  459778
  460070
  470404
  474580
  493679
  459201
  465454
  500787
  477055
  489014
  541277
  580069
  623171
  414050
  475947
  412779
  412830
  471669
  475319
  452815
  461612
  471693
  421740
  470405
  514849
  505109
  493237
  489311
  502462
  118227
  817194
  817218
  826154
  818959
  819749
  815266
  534554
  547422
  548260
  691511
  720224
  788193
  795704
  748068
  387720
  401204
  439038
  443568
  413687
  424370
  429938
  416597
  426816
  442511
  452643
  465497
  468348
  448559
]
2.94 ms
(1.50%)
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
  118008
  118227
  387720
  401204
  401768
  412779
  412830
  413687
  414050
  416597
  417246
  421740
  424370
  426816
  429609
  429938
  432255
  439038
  441864
  442511
  443568
  443865
  445533
  448559
  452643
  452815
  459201
  459778
  460070
  461612
  465454
  465497
  468348
  470404
  470405
  471669
  471693
  474580
  475319
  475947
  477055
  477760
  489014
  489311
  493237
  493618
  493679
  500787
  502462
  505109
  514849
  521241
  529597
  534554
  541277
  547422
  548260
  580069
  613518
  623130
  623171
  630039
  630096
  691511
  696871
  699415
  715877
  717664
  720067
  720224
  724118
  724240
  728518
  731234
  731327
  731482
  734346
  736356
  737852
  742916
  745112
  747633
  748068
  754207
  759796
  760888
  765334
  765555
  773912
  775543
  777013
  777029
  780665
  783180
  783275
  783428
  783718
  784298
  788193
  788786
  790637
  792671
  793138
  794765
  794859
  795425
  795704
  795706
  796532
  799917
  800566
  803243
  805651
  806046
  815266
  817194
  817218
  818959
  819749
  826154
]
2.16 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "анал дыры"
]
1.73 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал дырк"
]
1.64 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.