Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.62 ms
(83.41%)
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
  69739
  131517
  382203
  387413
  398199
  412287
  421691
  424187
  425573
  446510
  458806
  475199
  488510
  500519
  525128
  526079
  530419
  530445
  550570
  555765
  574499
  579206
  588937
  592958
  595117
  600515
  605589
  612963
  614550
  615694
  616085
  619036
  619670
  619881
  625753
  630718
  633060
  639153
  644069
  647797
  654137
  655524
  666347
  692904
  704346
  705806
  712143
  715037
  716960
  722031
  722171
  723766
  729677
  730805
  734108
  734716
  736070
  737983
  739140
  742918
  748884
  751496
  753773
  761122
  761520
  761523
  764280
  765495
  768633
  768804
  773532
  778194
  780290
  780881
  782051
  783881
  785189
  786488
  786994
  787078
  787288
  787851
  787958
  787994
  789065
  789908
  789990
  791658
  792681
  794871
  800353
  800765
  801541
  802052
  804885
  809625
  810315
  810857
  813768
  818933
  819406
  823723
  824044
  824318
  824774
  824798
  824813
  825083
  825101
  825303
  825576
  826110
  826565
  826579
  826923
  826979
  827049
  827272
  827479
  827544
]
12.63 ms
(8.88%)
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
  716960
  778194
  780881
  792681
  794871
  809625
  810315
  424187
  131517
  823723
  824044
  824318
  824813
  826110
  826565
  819406
  824774
  825303
  826923
  827049
  827272
  827479
  827544
  813768
  818933
  824798
  825101
  825576
  825083
  826979
  526079
  530419
  550570
  574499
  647797
  666347
  704346
  715037
  705806
  654137
  692904
  722031
  619881
  614550
  633060
  644069
  600515
  780290
  782051
  787958
  791658
  810857
  786994
  789908
  801541
  723766
  742918
  748884
  761523
  768633
  761122
  768804
  729677
  730805
  751496
  765495
  734716
  737983
  761520
  639153
  783881
  785189
  786488
  787288
  789990
  800765
  802052
  804885
  398199
  655524
  800353
  753773
  555765
  630718
  412287
  458806
  592958
  605589
  736070
  382203
  69739
  425573
  826579
  530445
  712143
  787078
  734108
  789065
  739140
  446510
  475199
  421691
  488510
  625753
  387413
  525128
  500519
  579206
  722171
  588937
  612963
  619670
  595117
  615694
  616085
  619036
  787851
  787994
  773532
  764280
]
3.00 ms
(2.11%)
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
  69739
  131517
  382203
  387413
  398199
  412287
  421691
  424187
  425573
  446510
  458806
  475199
  488510
  500519
  525128
  526079
  530419
  530445
  550570
  555765
  574499
  579206
  588937
  592958
  595117
  600515
  605589
  612963
  614550
  615694
  616085
  619036
  619670
  619881
  625753
  630718
  633060
  639153
  644069
  647797
  654137
  655524
  666347
  692904
  704346
  705806
  712143
  715037
  716960
  722031
  722171
  723766
  729677
  730805
  734108
  734716
  736070
  737983
  739140
  742918
  748884
  751496
  753773
  761122
  761520
  761523
  764280
  765495
  768633
  768804
  773532
  778194
  780290
  780881
  782051
  783881
  785189
  786488
  786994
  787078
  787288
  787851
  787958
  787994
  789065
  789908
  789990
  791658
  792681
  794871
  800353
  800765
  801541
  802052
  804885
  809625
  810315
  810857
  813768
  818933
  819406
  823723
  824044
  824318
  824774
  824798
  824813
  825083
  825101
  825303
  825576
  826110
  826565
  826579
  826923
  826979
  827049
  827272
  827479
  827544
]
2.71 ms
(1.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ð╝ð░ÐüÐéÐâÐÇð▒ð░Ðåð©ÐÅ Ðüð┐ðÁÐÇð╝ð░ ðÂð%ÔǪ"
]
1.80 ms
(1.27%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мастурбац сперм"
]
1.72 ms
(1.21%)
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.