Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.97 ms
(85.05%)
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
  389683
  390907
  392086
  400883
  418565
  441808
  446345
  462681
  463312
  474816
  479324
  487205
  510637
  510788
  520856
  526351
  531394
  543702
  546273
  547917
  566287
  578722
  581739
  590328
  595538
  600874
  608545
  615184
  616379
  616604
  620974
  622853
  625937
  639243
  641153
  647119
  652169
  658837
  659324
  662443
  664473
  668085
  668099
  668944
  678711
  678876
  680370
  684477
  684487
  689994
  690931
  691527
  695552
  696198
  697496
  701897
  704169
  705139
  707148
  708578
  710015
  710092
  710893
  712386
  713335
  715800
  716359
  716994
  717758
  718614
  719225
  719280
  720026
  721091
  722434
  723010
  727564
  730858
  733176
  734277
  734330
  734401
  737856
  739324
  742069
  742121
  744060
  747368
  748334
  756144
  765099
  765456
  770810
  776042
  777875
  778155
  782297
  784292
  784883
  786056
  787252
  791246
  791538
  792683
  796382
  796916
  798834
  800975
  806681
  806821
  818826
  820757
  822651
  822838
  823359
  825645
  825794
  825996
  827784
]
12.37 ms
(8.56%)
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
  792683
  723010
  778155
  510788
  659324
  652169
  595538
  791538
  739324
  756144
  742069
  744060
  717758
  668085
  696198
  668944
  705139
  647119
  668099
  715800
  608545
  641153
  616604
  796916
  784292
  791246
  734330
  734401
  737856
  747368
  625937
  776042
  441808
  474816
  487205
  446345
  479324
  719225
  765099
  390907
  392086
  418565
  547917
  566287
  678876
  684477
  689994
  708578
  710092
  691527
  712386
  546273
  581739
  590328
  639243
  777875
  784883
  786056
  787252
  798834
  806821
  796382
  782297
  806681
  742121
  730858
  734277
  389683
  713335
  658837
  620974
  800975
  770810
  772131
  733176
  765456
  727564
  748334
  510637
  526351
  695552
  600874
  823359
  462681
  463312
  684487
  400883
  820757
  822838
  825996
  822651
  825645
  825794
  818826
  827784
  531394
  520856
  578722
  543702
  664473
  697496
  707148
  720026
  721091
  701897
  704169
  716994
  718614
  719280
  662443
  678711
  680370
  690931
  710015
  710893
  716359
  722434
  615184
  616379
  622853
]
2.81 ms
(1.95%)
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
  389683
  390907
  392086
  400883
  418565
  441808
  446345
  462681
  463312
  474816
  479324
  487205
  510637
  510788
  520856
  526351
  531394
  543702
  546273
  547917
  566287
  578722
  581739
  590328
  595538
  600874
  608545
  615184
  616379
  616604
  620974
  622853
  625937
  639243
  641153
  647119
  652169
  658837
  659324
  662443
  664473
  668085
  668099
  668944
  678711
  678876
  680370
  684477
  684487
  689994
  690931
  691527
  695552
  696198
  697496
  701897
  704169
  705139
  707148
  708578
  710015
  710092
  710893
  712386
  713335
  715800
  716359
  716994
  717758
  718614
  719225
  719280
  720026
  721091
  722434
  723010
  727564
  730858
  733176
  734277
  734330
  734401
  737856
  739324
  742069
  742121
  744060
  747368
  748334
  756144
  765099
  765456
  770810
  776042
  777875
  778155
  782297
  784292
  784883
  786056
  787252
  791246
  791538
  792683
  796382
  796916
  798834
  800975
  806681
  806821
  818826
  820757
  822651
  822838
  823359
  825645
  825794
  825996
  827784
]
1.79 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "real teen girl"
]
1.63 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "real молодая девушк"
]
1.51 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "real молодая девушк"
]
1.49 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.