Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.12 ms
(85.29%)
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
  7365
  351702
  382318
  404386
  409494
  415736
  436985
  457248
  462989
  534451
  535522
  535734
  539784
  544979
  547086
  548825
  582534
  585529
  596245
  596428
  617368
  622389
  624085
  624413
  630212
  635073
  644696
  644855
  645962
  651651
  653813
  661438
  661444
  663972
  668760
  668995
  675715
  684320
  696400
  697639
  698210
  701530
  702501
  708495
  709360
  712813
  713363
  713999
  714169
  715069
  720341
  730766
  739951
  740844
  741056
  742045
  742051
  743141
  743990
  744689
  745284
  746409
  746942
  748340
  748382
  749710
  750481
  755256
  759542
  760112
  763952
  764240
  764260
  765797
  769280
  769383
  771485
  774204
  775652
  778338
  780159
  780233
  780628
  780636
  783079
  783813
  786149
  787473
  788622
  791475
  791750
  792328
  796727
  796857
  797109
  797484
  800204
  803721
  804485
  804705
  804827
  809810
  810164
  817475
  818081
  818095
  818464
  818473
  818776
  819651
  821666
  823230
  823828
  824373
  824663
  824884
  826623
  826942
]
13.58 ms
(8.51%)
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
  780159
  780233
  788622
  404386
  824373
  644855
  826623
  826942
  818464
  535734
  547086
  684320
  702501
  713363
  645962
  653813
  668995
  698210
  701530
  715069
  556243
  644696
  624413
  596245
  630212
  624085
  783813
  786149
  787473
  804705
  783079
  796857
  797109
  742051
  745284
  769383
  771485
  760112
  764240
  764260
  730766
  739951
  741056
  743141
  743990
  744689
  746409
  746942
  748340
  765797
  774204
  712813
  778338
  810164
  382318
  351702
  415736
  818473
  821666
  824663
  818095
  818776
  817475
  819651
  462989
  534451
  539784
  544979
  548825
  582534
  651651
  713999
  661444
  696400
  714169
  661438
  663972
  668760
  675715
  720341
  585529
  596428
  617368
  622389
  775652
  791475
  797484
  800204
  780628
  791750
  792328
  796727
  803721
  804485
  804827
  749710
  769280
  763952
  748382
  759542
  740844
  742045
  750481
  755256
  635073
  697639
  708495
  709360
  780636
  787390
  809810
  7365
  409494
  436985
  818081
  823230
  824884
  823828
  457248
  535522
]
2.77 ms
(1.74%)
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
  7365
  351702
  382318
  404386
  409494
  415736
  436985
  457248
  462989
  534451
  535522
  535734
  539784
  544979
  547086
  548825
  582534
  585529
  596245
  596428
  617368
  622389
  624085
  624413
  630212
  635073
  644696
  644855
  645962
  651651
  653813
  661438
  661444
  663972
  668760
  668995
  675715
  684320
  696400
  697639
  698210
  701530
  702501
  708495
  709360
  712813
  713363
  713999
  714169
  715069
  720341
  730766
  739951
  740844
  741056
  742045
  742051
  743141
  743990
  744689
  745284
  746409
  746942
  748340
  748382
  749710
  750481
  755256
  759542
  760112
  763952
  764240
  764260
  765797
  769280
  769383
  771485
  774204
  775652
  778338
  780159
  780233
  780628
  780636
  783079
  783813
  786149
  787473
  788622
  791475
  791750
  792328
  796727
  796857
  797109
  797484
  800204
  803721
  804485
  804705
  804827
  809810
  810164
  817475
  818081
  818095
  818464
  818473
  818776
  819651
  821666
  823230
  823828
  824373
  824663
  824884
  826623
  826942
]
2.02 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "likes"
]
1.91 ms
(1.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "likes"
]
1.56 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "likes"
]

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.