Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.37 ms
(85.85%)
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
  3671
  395430
  400713
  427813
  440840
  440932
  451744
  459937
  460081
  460112
  460841
  463872
  469308
  469706
  470136
  488520
  494412
  494541
  494959
  499396
  504181
  505248
  505285
  538407
  542445
  547180
  555161
  555369
  557722
  557726
  568372
  572355
  574940
  578226
  579137
  584017
  585391
  588072
  595314
  601871
  604635
  604724
  607279
  607472
  615451
  624759
  626331
  630876
  632845
  636464
  639375
  647253
  648483
  652999
  664222
  670234
  670257
  672526
  674197
  678334
  679685
  680588
  686590
  697327
  697718
  698228
  698473
  709764
  711577
  712561
  717298
  719124
  721042
  721128
  726314
  726967
  728427
  731135
  732669
  733074
  736838
  737065
  738022
  739986
  740508
  741832
  745360
  763062
  764522
  768939
  769344
  772746
  776151
  778068
  778447
  778514
  779961
  786831
  787799
  789279
  791065
  793571
  794993
  795143
  796048
  798856
  800303
  801399
  802210
  802602
  802867
  805354
  811410
  811435
  811528
  811764
  812373
  812822
  813316
]
12.88 ms
(8.17%)
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
  698473
  709764
  712561
  686590
  697718
  664222
  678334
  585391
  588072
  595314
  607472
  630876
  778068
  732669
  463872
  494412
  499396
  557726
  670257
  680588
  726314
  794993
  504181
  789279
  400713
  427813
  572355
  584017
  674197
  578226
  775358
  778514
  812373
  776151
  779961
  786831
  812822
  736838
  738022
  769344
  733074
  728427
  740508
  737065
  717298
  719124
  800303
  488520
  679685
  647253
  3671
  460112
  542445
  697327
  555161
  805354
  811435
  802867
  772746
  802210
  811764
  768939
  731135
  741832
  787799
  793571
  798856
  801399
  811528
  395430
  469706
  494541
  505248
  538407
  568372
  652999
  670234
  632845
  607279
  615451
  624759
  604724
  440932
  460841
  557722
  648483
  601871
  639375
  636464
  813316
  795143
  796048
  745360
  726967
  604635
  811410
  469308
  440840
  451744
  505285
  494959
  459937
  460081
  470136
  555369
  547180
  579137
  711577
  721128
  698228
  672526
  721042
  574940
  626331
  778447
  791065
  802602
  764522
  763062
  739986
]
3.11 ms
(1.97%)
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
  3671
  395430
  400713
  427813
  440840
  440932
  451744
  459937
  460081
  460112
  460841
  463872
  469308
  469706
  470136
  488520
  494412
  494541
  494959
  499396
  504181
  505248
  505285
  538407
  542445
  547180
  555161
  555369
  557722
  557726
  568372
  572355
  574940
  578226
  579137
  584017
  585391
  588072
  595314
  601871
  604635
  604724
  607279
  607472
  615451
  624759
  626331
  630876
  632845
  636464
  639375
  647253
  648483
  652999
  664222
  670234
  670257
  672526
  674197
  678334
  679685
  680588
  686590
  697327
  697718
  698228
  698473
  709764
  711577
  712561
  717298
  719124
  721042
  721128
  726314
  726967
  728427
  731135
  732669
  733074
  736838
  737065
  738022
  739986
  740508
  741832
  745360
  763062
  764522
  768939
  769344
  772746
  776151
  778068
  778447
  778514
  779961
  786831
  787799
  789279
  791065
  793571
  794993
  795143
  796048
  798856
  800303
  801399
  802210
  802602
  802867
  805354
  811410
  811435
  811528
  811764
  812373
  812822
  813316
]
1.95 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "facial homemade"
]
1.59 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "facial домашн любительск"
]
1.39 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.39 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "facial домашн любительск"
]

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.