Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
172.85 ms
(86.92%)
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
  365978
  381791
  397130
  398874
  408810
  484245
  487661
  491579
  539030
  543542
  545946
  547356
  554120
  557617
  562392
  564357
  569093
  569912
  584109
  596186
  612656
  624238
  629124
  631356
  634289
  635742
  637630
  638101
  644675
  645721
  650030
  650032
  650238
  652553
  654405
  662786
  675862
  684183
  688127
  688706
  689323
  696975
  700497
  701794
  702008
  702674
  703775
  704480
  704984
  705223
  707808
  711117
  712791
  713974
  715828
  717109
  718583
  720505
  720664
  721200
  722350
  723916
  723970
  725764
  730275
  735421
  736610
  736842
  738419
  740762
  741889
  743033
  745848
  748694
  749006
  753266
  755733
  757895
  759228
  759385
  764049
  764810
  765883
  771200
  772859
  774079
  774635
  781051
  782763
  783002
  786824
  789450
  789867
  791660
  795112
  795660
  797569
  801219
  802632
  803707
  811818
  812258
  816749
  816768
  818109
  818254
  818379
  820146
  823908
  824426
  824616
  824693
  825785
  825883
  826076
  826146
  826411
  826553
  826565
]
16.20 ms
(8.15%)
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
  820146
  826644
  818254
  554120
  645721
  701794
  711117
  650032
  712791
  721200
  638101
  782763
  735421
  740762
  801219
  757895
  764810
  753266
  764049
  743033
  795660
  824426
  487661
  543542
  704480
  684183
  707808
  596186
  791660
  730275
  736842
  408810
  397130
  741889
  720505
  654405
  781051
  826553
  824693
  824616
  825883
  484245
  688706
  700497
  650030
  650238
  713974
  720664
  637630
  789867
  774635
  795112
  797569
  723916
  736610
  759228
  765883
  803707
  365978
  381791
  826565
  818109
  825785
  826076
  826411
  826146
  545946
  569912
  584109
  562392
  557617
  564357
  662786
  702008
  705223
  652553
  675862
  722350
  688127
  703775
  547356
  612656
  634289
  635742
  629124
  738419
  755733
  749006
  723970
  745848
  748694
  759385
  725764
  772859
  644675
  715828
  718583
  812258
  818379
  539030
  491579
  717109
  689323
  702674
  704984
  569093
  624238
  631356
  783002
  786824
  789450
  811818
  771200
  774079
  696975
  802632
  398874
  823908
  816749
  816768
]
2.77 ms
(1.39%)
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
  365978
  381791
  397130
  398874
  408810
  484245
  487661
  491579
  539030
  543542
  545946
  547356
  554120
  557617
  562392
  564357
  569093
  569912
  584109
  596186
  612656
  624238
  629124
  631356
  634289
  635742
  637630
  638101
  644675
  645721
  650030
  650032
  650238
  652553
  654405
  662786
  675862
  684183
  688127
  688706
  689323
  696975
  700497
  701794
  702008
  702674
  703775
  704480
  704984
  705223
  707808
  711117
  712791
  713974
  715828
  717109
  718583
  720505
  720664
  721200
  722350
  723916
  723970
  725764
  730275
  735421
  736610
  736842
  738419
  740762
  741889
  743033
  745848
  748694
  749006
  753266
  755733
  757895
  759228
  759385
  764049
  764810
  765883
  771200
  772859
  774079
  774635
  781051
  782763
  783002
  786824
  789450
  789867
  791660
  795112
  795660
  797569
  801219
  802632
  803707
  811818
  812258
  816749
  816768
  818109
  818254
  818379
  820146
  823908
  824426
  824616
  824693
  825785
  825883
  826076
  826146
  826411
  826553
  826565
]
2.02 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fucked teen girl"
]
1.89 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "fucked молодая девушк"
]
1.65 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "fucked молодая девушк"
]
1.48 ms
(0.75%)
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.