Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
182.57 ms
(87.97%)
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
  65277
  79031
  389033
  389788
  396863
  397808
  441994
  447139
  468408
  478091
  493805
  497382
  498604
  530462
  532708
  543571
  545449
  547380
  547469
  547479
  548443
  566845
  576590
  580119
  588357
  601509
  604240
  624159
  626930
  643671
  644861
  646624
  655247
  656801
  661959
  677203
  680435
  695892
  698230
  699225
  699404
  706133
  707089
  709922
  710736
  713163
  714711
  718041
  720449
  720742
  722998
  727731
  727741
  729073
  729115
  730340
  740241
  742342
  745135
  748362
  752587
  752709
  756351
  757716
  758807
  759759
  759921
  760901
  761085
  761119
  761185
  761614
  762085
  762216
  762805
  764147
  764757
  766087
  766703
  766822
  766910
  766915
  767235
  775211
  778246
  778298
  778731
  778882
  783433
  784170
  784821
  791601
  791681
  793206
  793838
  794124
  794781
  794853
  795300
  795702
  795707
  796149
  796178
  798633
  800569
  800807
  801090
  804899
  805310
  805509
  806622
  807126
  809816
  810125
  811710
  813015
  818635
  826241
]
15.23 ms
(7.34%)
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
  548443
  543571
  547380
  706133
  547469
  580119
  588357
  624159
  793838
  795702
  796149
  791601
  791681
  800807
  730340
  766087
  800569
  805509
  810125
  758807
  766915
  759759
  752709
  718041
  795707
  809816
  532708
  656801
  680435
  397808
  793206
  796178
  804899
  644861
  791945
  396863
  826241
  447139
  497382
  530462
  545449
  547479
  566845
  720742
  655247
  709922
  714711
  576590
  643671
  626930
  778246
  778298
  813015
  752587
  767235
  794853
  811710
  761085
  762216
  762805
  742342
  727741
  729115
  745135
  757716
  764757
  740241
  761119
  775211
  778731
  778882
  79031
  604240
  784821
  646624
  677203
  601509
  389788
  441994
  818635
  478091
  468408
  699404
  661959
  805310
  807126
  795300
  798633
  729073
  759921
  761614
  783433
  794124
  794781
  801090
  806622
  766703
  760901
  762085
  764183
  761185
  766822
  756351
  764147
  784170
  493805
  748362
  389033
  720449
  722998
  766910
  695892
  707089
  713163
  727731
  698230
  699225
  710736
  498604
  65277
]
2.36 ms
(1.14%)
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
  65277
  79031
  389033
  389788
  396863
  397808
  441994
  447139
  468408
  478091
  493805
  497382
  498604
  530462
  532708
  543571
  545449
  547380
  547469
  547479
  548443
  566845
  576590
  580119
  588357
  601509
  604240
  624159
  626930
  643671
  644861
  646624
  655247
  656801
  661959
  677203
  680435
  695892
  698230
  699225
  699404
  706133
  707089
  709922
  710736
  713163
  714711
  718041
  720449
  720742
  722998
  727731
  727741
  729073
  729115
  730340
  740241
  742342
  745135
  748362
  752587
  752709
  756351
  757716
  758807
  759759
  759921
  760901
  761085
  761119
  761185
  761614
  762085
  762216
  762805
  764147
  764757
  766087
  766703
  766822
  766910
  766915
  767235
  775211
  778246
  778298
  778731
  778882
  783433
  784170
  784821
  791601
  791681
  793206
  793838
  794124
  794781
  794853
  795300
  795702
  795707
  796149
  796178
  798633
  800569
  800807
  801090
  804899
  805310
  805509
  806622
  807126
  809816
  810125
  811710
  813015
  818635
  826241
]
2.01 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в попу домашние"
]
1.95 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал домашн любительск"
]
1.67 ms
(0.80%)
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.