Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.27 ms
(83.88%)
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
  16946
  33756
  74239
  102702
  105317
  132988
  142823
  151113
  185589
  365546
  379619
  382942
  385737
  386680
  389195
  391064
  391427
  397843
  399627
  402965
  414618
  415806
  418773
  419253
  420749
  423890
  425358
  425401
  426456
  426686
  433867
  435351
  435413
  438371
  439578
  441923
  443506
  444370
  444586
  445343
  445484
  445669
  447297
  447386
  448346
  449906
  452364
  452856
  453034
  455730
  457253
  461212
  462039
  463772
  466193
  466806
  469688
  469884
  474039
  476992
  479042
  479370
  480968
  481036
  482806
  482949
  488191
  488293
  494886
  494976
  495234
  504721
  506259
  507715
  508253
  514274
  516791
  520532
  523169
  525325
  525349
  525398
  528048
  538172
  539790
  546745
  553621
  556506
  559837
  563004
  563994
  566244
  567856
  570613
  570622
  572363
  572513
  577458
  580088
  584310
  586121
  600560
  600833
  622252
  645194
  650867
  652617
  660863
  677088
  707692
  709482
  754186
  759884
  760851
  771544
  803957
  807953
  808101
  825898
  825907
]
12.61 ms
(8.44%)
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
  397843
  415806
  418773
  425401
  469884
  102702
  386680
  419253
  425358
  474039
  481036
  495234
  504721
  494886
  482949
  488293
  33756
  825898
  389195
  426456
  426686
  455730
  523169
  525398
  525349
  572513
  707692
  559837
  600833
  622252
  807953
  414618
  439578
  444586
  438371
  463772
  506259
  516791
  525325
  563994
  760851
  185589
  142823
  435413
  385737
  382942
  151113
  132988
  379619
  365546
  74239
  391427
  444370
  420749
  435351
  423890
  445343
  825907
  482806
  445669
  447386
  448346
  469688
  449906
  480968
  445484
  452364
  453034
  457253
  488191
  520532
  528048
  539790
  494976
  507715
  514274
  538172
  508253
  466806
  546745
  572363
  556506
  567856
  563004
  566244
  577458
  584310
  652617
  645194
  660863
  677088
  709482
  650867
  553621
  570613
  570622
  580088
  586121
  600560
  808101
  759884
  771544
  754186
  803957
  462039
  479042
  105317
  391064
  433867
  461212
  466193
  479370
  16946
  452856
  399627
  402965
  441923
  443506
  447297
  476992
]
5.03 ms
(3.37%)
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
  16946
  33756
  74239
  102702
  105317
  132988
  142823
  151113
  185589
  365546
  379619
  382942
  385737
  386680
  389195
  391064
  391427
  397843
  399627
  402965
  414618
  415806
  418773
  419253
  420749
  423890
  425358
  425401
  426456
  426686
  433867
  435351
  435413
  438371
  439578
  441923
  443506
  444370
  444586
  445343
  445484
  445669
  447297
  447386
  448346
  449906
  452364
  452856
  453034
  455730
  457253
  461212
  462039
  463772
  466193
  466806
  469688
  469884
  474039
  476992
  479042
  479370
  480968
  481036
  482806
  482949
  488191
  488293
  494886
  494976
  495234
  504721
  506259
  507715
  508253
  514274
  516791
  520532
  523169
  525325
  525349
  525398
  528048
  538172
  539790
  546745
  553621
  556506
  559837
  563004
  563994
  566244
  567856
  570613
  570622
  572363
  572513
  577458
  580088
  584310
  586121
  600560
  600833
  622252
  645194
  650867
  652617
  660863
  677088
  707692
  709482
  754186
  759884
  760851
  771544
  803957
  807953
  808101
  825898
  825907
]
1.76 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "порно позы"
]
1.67 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "порн поз"
]
1.55 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(0.98%)
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.