Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.65 ms
(87.04%)
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
  403134
  404122
  414762
  441596
  446525
  459638
  493578
  510303
  518366
  541062
  541692
  541719
  549627
  554956
  568976
  569573
  590621
  590832
  593579
  593701
  604226
  604287
  604659
  605128
  618756
  619965
  626317
  634021
  636581
  636943
  637536
  639552
  650263
  655208
  662084
  663208
  668942
  672894
  673229
  680322
  684410
  685819
  687137
  697491
  699225
  704654
  704685
  710902
  712591
  714070
  717913
  719454
  723219
  724105
  726300
  726957
  727507
  727866
  729292
  730340
  730534
  731213
  731311
  736241
  736741
  739210
  740094
  740860
  748815
  750124
  750229
  750271
  750582
  753550
  757388
  757469
  757853
  761302
  762761
  763510
  764231
  764242
  766617
  767058
  769075
  770258
  770267
  770310
  775219
  776992
  777151
  778281
  783194
  783345
  783364
  783567
  784890
  787936
  788565
  788838
  791681
  792970
  795315
  795623
  796141
  796149
  796157
  796899
  796904
  796941
  798799
  800500
  800515
  801630
  813097
  817329
  827431
  827899
]
14.44 ms
(7.92%)
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
  403134
  796141
  795315
  775219
  726300
  762761
  800500
  740860
  723219
  796899
  604659
  792970
  739210
  783345
  769075
  766617
  717913
  798799
  541719
  655208
  704685
  662084
  663208
  680322
  714070
  590832
  626317
  604287
  637536
  605128
  618756
  639552
  736241
  757388
  788838
  549627
  770267
  446525
  604226
  568976
  593579
  699225
  817329
  770310
  787936
  740094
  827431
  493578
  783567
  778281
  813097
  788565
  757469
  727866
  731311
  750124
  827899
  414762
  719454
  634021
  776992
  753550
  763214
  763510
  770258
  726957
  761302
  764242
  724105
  729292
  748815
  750229
  750271
  750582
  757853
  777151
  510303
  673229
  593701
  800515
  801630
  727507
  764231
  731213
  783364
  710902
  518366
  497468
  569573
  736741
  404122
  459638
  795623
  796157
  767058
  784890
  730534
  619965
  541692
  541062
  650263
  704654
  712591
  687137
  697491
  554956
  636581
  590621
  684410
  668942
  672894
  636943
  685819
  441596
  796149
  796904
  796941
  791681
  730340
  783194
]
2.51 ms
(1.38%)
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
  403134
  404122
  414762
  441596
  446525
  459638
  493578
  510303
  518366
  541062
  541692
  541719
  549627
  554956
  568976
  569573
  590621
  590832
  593579
  593701
  604226
  604287
  604659
  605128
  618756
  619965
  626317
  634021
  636581
  636943
  637536
  639552
  650263
  655208
  662084
  663208
  668942
  672894
  673229
  680322
  684410
  685819
  687137
  697491
  699225
  704654
  704685
  710902
  712591
  714070
  717913
  719454
  723219
  724105
  726300
  726957
  727507
  727866
  729292
  730340
  730534
  731213
  731311
  736241
  736741
  739210
  740094
  740860
  748815
  750124
  750229
  750271
  750582
  753550
  757388
  757469
  757853
  761302
  762761
  763510
  764231
  764242
  766617
  767058
  769075
  770258
  770267
  770310
  775219
  776992
  777151
  778281
  783194
  783345
  783364
  783567
  784890
  787936
  788565
  788838
  791681
  792970
  795315
  795623
  796141
  796149
  796157
  796899
  796904
  796941
  798799
  800500
  800515
  801630
  813097
  817329
  827431
  827899
]
2.09 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hard анал домашн любительск"
]
1.59 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hard anal homemade"
]
1.57 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.42 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hard анал домашн любительск"
]

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.