Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.28 ms
(54.36%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
156.00 ms
(40.33%)
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
  539328
  540103
  540126
  540127
  540158
  540165
  540171
  541789
  542438
  542459
  542716
  546218
  546291
  547413
  547415
  547443
  547445
  550786
  552314
  554379
  554572
  554690
  554729
  554735
  555205
  555210
  555224
  555601
  555761
  560854
  561039
  562157
  567500
  567518
  570091
  574926
  575253
  576482
  576562
  576592
  577032
  580903
  581549
  581551
  583301
  584341
  592833
  599242
  600778
  611117
  611133
  614277
  615830
  622078
  629646
  629666
  629671
  634363
  635823
  636439
  640046
  641604
  642103
  643690
  643698
  647025
  649348
  651101
  651158
  661265
  664477
  668678
  670448
  670453
  670804
  672029
  690173
  696303
  710478
  723541
  725539
  726320
  726359
  727510
  729236
  734360
  740265
  742726
  743689
  744810
  745992
  746102
  752622
  757257
  768680
  789438
  794998
  795004
  795017
  795728
  796075
  798315
  801776
  810073
  810141
  812252
  814162
  814163
  814166
  814208
  818573
  819228
  819424
  820150
  825824
  826321
  826408
  826541
  827402
  827681
]
12.55 ms
(3.24%)
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
  547413
  615830
  634363
  611133
  636439
  794998
  801776
  726359
  740265
  743689
  814162
  814163
  541789
  560854
  570091
  584341
  583301
  542716
  550786
  554572
  670448
  575253
  641604
  642103
  599242
  629646
  796075
  727510
  757257
  725539
  746102
  640046
  542438
  629671
  826541
  818573
  540158
  540165
  554690
  555601
  577032
  580903
  562157
  789438
  798315
  729236
  734360
  814208
  819228
  827402
  540126
  540103
  540171
  547445
  552314
  554729
  576562
  576482
  542459
  546291
  547415
  555205
  555210
  555761
  561039
  567518
  649348
  651158
  664477
  668678
  672029
  710478
  647025
  690173
  696303
  651101
  670453
  546218
  574926
  576592
  581549
  600778
  614277
  629666
  635823
  643690
  592833
  611117
  810073
  812252
  768680
  795017
  795728
  810141
  745992
  752622
  726320
  744810
  742726
  622078
  643698
  581551
  795004
  539328
  547443
  554379
  567500
  670804
  661265
  723541
  826408
  825824
  814166
  819424
  820150
  826321
  827681
  540127
  554735
  555224
]
3.14 ms
(0.81%)
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
  539328
  540103
  540126
  540127
  540158
  540165
  540171
  541789
  542438
  542459
  542716
  546218
  546291
  547413
  547415
  547443
  547445
  550786
  552314
  554379
  554572
  554690
  554729
  554735
  555205
  555210
  555224
  555601
  555761
  560854
  561039
  562157
  567500
  567518
  570091
  574926
  575253
  576482
  576562
  576592
  577032
  580903
  581549
  581551
  583301
  584341
  592833
  599242
  600778
  611117
  611133
  614277
  615830
  622078
  629646
  629666
  629671
  634363
  635823
  636439
  640046
  641604
  642103
  643690
  643698
  647025
  649348
  651101
  651158
  661265
  664477
  668678
  670448
  670453
  670804
  672029
  690173
  696303
  710478
  723541
  725539
  726320
  726359
  727510
  729236
  734360
  740265
  742726
  743689
  744810
  745992
  746102
  752622
  757257
  768680
  789438
  794998
  795004
  795017
  795728
  796075
  798315
  801776
  810073
  810141
  812252
  814162
  814163
  814166
  814208
  818573
  819228
  819424
  820150
  825824
  826321
  826408
  826541
  827402
  827681
]
1.71 ms
(0.44%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "писсинг pissing"
]
1.68 ms
(0.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ссыт pissing"
]
1.50 ms
(0.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "писсинг pissing"
]

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.