Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.79 ms
(82.22%)
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
  233333
  233532
  382808
  386973
  391149
  392603
  398999
  409291
  411366
  411421
  418792
  422197
  425482
  427135
  433599
  438607
  444106
  444147
  448975
  454265
  456724
  458488
  459747
  462156
  463504
  466079
  466285
  469896
  469937
  470316
  470499
  470706
  473673
  474194
  477610
  479959
  483055
  483286
  483600
  484381
  484781
  485223
  485425
  486375
  486385
  502938
  504194
  505068
  506356
  506670
  513336
  514464
  526111
  538603
  545662
  546448
  549642
  549785
  568847
  570314
  572662
  575160
  586603
  589560
  595459
  596579
  598665
  598815
  616958
  623936
  656737
  657367
  657587
  659401
  659803
  659849
  660892
  660901
  660921
  663260
  667025
  673550
  675860
  683278
  695087
  695109
  696449
  701247
  704021
  704174
  716013
  716583
  719443
  722434
  731216
  735567
  737028
  739956
  741042
  741588
  743479
  745949
  749951
  758175
  766523
  788377
  793592
  796300
  803639
  806973
  811275
  818084
  818089
  819884
  825172
  826379
  828540
  828544
]
17.31 ms
(11.05%)
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
  444106
  466079
  486375
  505068
  514464
  483055
  484781
  470499
  470316
  454265
  502938
  485223
  696449
  391149
  485425
  818084
  819884
  745949
  484381
  572662
  456724
  386973
  411421
  444147
  568847
  575160
  596579
  589560
  506670
  473673
  418792
  448975
  463504
  469937
  474194
  422197
  433599
  459747
  486385
  504194
  513336
  483286
  483600
  506356
  470706
  788377
  427135
  438607
  458488
  466285
  479959
  526111
  546448
  657367
  663260
  673550
  695109
  656737
  660921
  735567
  545662
  722434
  818089
  716583
  586603
  825172
  826379
  828544
  828540
  549642
  570314
  660892
  660901
  683278
  659803
  704021
  657587
  659849
  616958
  741042
  382808
  462156
  549785
  659401
  667025
  695087
  719443
  662145
  675860
  701247
  704174
  716013
  595459
  598665
  598815
  803639
  766523
  749951
  739956
  743479
  751259
  758175
  731216
  737028
  741588
  425482
  469896
  538603
  623936
  796300
  806973
  793592
  811275
  398999
  477610
  392603
  409291
  411366
  233333
  233532
]
2.70 ms
(1.72%)
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
  233333
  233532
  382808
  386973
  391149
  392603
  398999
  409291
  411366
  411421
  418792
  422197
  425482
  427135
  433599
  438607
  444106
  444147
  448975
  454265
  456724
  458488
  459747
  462156
  463504
  466079
  466285
  469896
  469937
  470316
  470499
  470706
  473673
  474194
  477610
  479959
  483055
  483286
  483600
  484381
  484781
  485223
  485425
  486375
  486385
  502938
  504194
  505068
  506356
  506670
  513336
  514464
  526111
  538603
  545662
  546448
  549642
  549785
  568847
  570314
  572662
  575160
  586603
  589560
  595459
  596579
  598665
  598815
  616958
  623936
  656737
  657367
  657587
  659401
  659803
  659849
  660892
  660901
  660921
  663260
  667025
  673550
  675860
  683278
  695087
  695109
  696449
  701247
  704021
  704174
  716013
  716583
  719443
  722434
  731216
  735567
  737028
  739956
  741042
  741588
  743479
  745949
  749951
  758175
  766523
  788377
  793592
  796300
  803639
  806973
  811275
  818084
  818089
  819884
  825172
  826379
  828540
  828544
]
2.57 ms
(1.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big natural russian"
]
1.94 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие натуральная натуральные русск"
]
1.77 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(0.99%)
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.