Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.58 ms
(86.08%)
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
  385928
  395465
  398941
  402950
  403973
  414271
  416652
  416737
  418530
  419062
  424581
  427539
  428851
  433295
  441021
  441073
  441093
  441102
  441495
  443496
  444338
  446274
  447600
  449173
  450679
  451121
  451316
  451775
  453678
  463855
  465320
  466563
  468434
  473406
  477118
  477418
  477537
  479821
  488247
  488803
  492286
  493684
  493757
  493778
  493838
  497509
  499211
  499617
  504509
  508666
  511866
  520400
  528474
  534590
  541322
  541328
  541782
  542268
  544108
  547236
  547386
  547848
  548460
  556876
  559406
  564301
  565142
  576564
  597457
  597502
  614957
  619347
  646655
  657505
  670357
  670366
  671038
  673696
  681643
  696236
  708923
  709565
  709850
  710362
  710659
  713185
  716118
  717516
  720065
  723161
  725030
  725115
  728745
  729231
  729301
  733862
  733904
  738826
  749012
  749245
  758799
  770264
  775572
  777847
  778850
  782040
  782090
  782351
  782789
  783382
  791930
  792654
  795689
  796939
  801298
  804230
  805231
  810436
  814232
  817278
]
14.71 ms
(8.14%)
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
  619347
  792654
  416652
  428851
  542268
  681643
  738826
  791930
  402950
  670366
  733904
  770264
  477118
  444338
  433295
  463855
  817278
  511866
  548460
  547236
  670357
  696236
  565142
  782351
  725030
  419062
  564301
  778850
  414271
  614957
  398941
  547848
  597457
  749012
  728745
  782040
  395465
  416737
  441093
  441073
  441495
  427539
  441102
  443496
  814232
  446274
  468434
  473406
  477418
  479821
  488803
  493684
  493757
  450679
  465320
  497509
  534590
  477537
  492286
  544108
  541322
  541328
  710659
  713185
  716118
  657505
  708923
  709850
  671038
  717516
  597502
  777847
  782789
  749245
  758799
  725115
  729231
  796939
  804230
  466563
  385928
  403973
  453678
  424581
  499617
  499211
  508666
  488247
  493778
  493838
  520400
  733862
  449173
  451121
  451316
  447600
  556876
  451775
  418530
  441021
  504509
  528474
  541782
  576564
  710362
  723161
  646655
  673696
  709565
  720065
  547386
  559406
  775572
  782090
  795689
  810436
  783382
  801298
  805231
  729301
]
2.94 ms
(1.63%)
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
  385928
  395465
  398941
  402950
  403973
  414271
  416652
  416737
  418530
  419062
  424581
  427539
  428851
  433295
  441021
  441073
  441093
  441102
  441495
  443496
  444338
  446274
  447600
  449173
  450679
  451121
  451316
  451775
  453678
  463855
  465320
  466563
  468434
  473406
  477118
  477418
  477537
  479821
  488247
  488803
  492286
  493684
  493757
  493778
  493838
  497509
  499211
  499617
  504509
  508666
  511866
  520400
  528474
  534590
  541322
  541328
  541782
  542268
  544108
  547236
  547386
  547848
  548460
  556876
  559406
  564301
  565142
  576564
  597457
  597502
  614957
  619347
  646655
  657505
  670357
  670366
  671038
  673696
  681643
  696236
  708923
  709565
  709850
  710362
  710659
  713185
  716118
  717516
  720065
  723161
  725030
  725115
  728745
  729231
  729301
  733862
  733904
  738826
  749012
  749245
  758799
  770264
  775572
  777847
  778850
  782040
  782090
  782351
  782789
  783382
  791930
  792654
  795689
  796939
  801298
  804230
  805231
  810436
  814232
  817278
]
2.21 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hole anal"
]
1.88 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дырк анал"
]
1.73 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.93%)
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.