Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
162.42 ms
(85.00%)
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
  384232
  389642
  397992
  398353
  415280
  416309
  418372
  418383
  419269
  420893
  421712
  424795
  430770
  438712
  443949
  448843
  455951
  459311
  467312
  486489
  487115
  512119
  513746
  517542
  521350
  523075
  524355
  528774
  537849
  539934
  545058
  551078
  556818
  557003
  567116
  582416
  600432
  606831
  607676
  609066
  611294
  613782
  615963
  617936
  620218
  621477
  624026
  638737
  644274
  644995
  662399
  666919
  680860
  688009
  692832
  707698
  710438
  710934
  711552
  726046
  726314
  726496
  726934
  728233
  728478
  730048
  730070
  730317
  732822
  737481
  738464
  740847
  742707
  745550
  755489
  756234
  757175
  757327
  762437
  767004
  767769
  770462
  770787
  772832
  775774
  776607
  776822
  779757
  781671
  781892
  787209
  789594
  790858
  793534
  794436
  795058
  796301
  797102
  797343
  797443
  797517
  799042
  799413
  802746
  803221
  803708
  804056
  804210
  805032
  805962
  806022
  806230
  807299
  808503
  811387
  812979
  813538
  817271
  825563
  827328
]
18.48 ms
(9.67%)
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
  726314
  740847
  757175
  762437
  797102
  802746
  807299
  811387
  730317
  726934
  730070
  732822
  756234
  767004
  730048
  737481
  742707
  755489
  757327
  728478
  613782
  620218
  644274
  710934
  776607
  779757
  790858
  795058
  806230
  384232
  430770
  389642
  397992
  398353
  415280
  825563
  486489
  455951
  448843
  524355
  528774
  521350
  523075
  512119
  517542
  537849
  539934
  582416
  545058
  666919
  707698
  662399
  680860
  688009
  692832
  711552
  551078
  556818
  557003
  567116
  607676
  609066
  617936
  621477
  611294
  600432
  624026
  606831
  615963
  638737
  804210
  805962
  806022
  808503
  775774
  776822
  789594
  796301
  797443
  799413
  803708
  813538
  745550
  772832
  781892
  793534
  797343
  797517
  812979
  728233
  770787
  726496
  767769
  738464
  726046
  770462
  710438
  781671
  787209
  794436
  799042
  803221
  804056
  805032
  418372
  467312
  443949
  418383
  459311
  487115
  513746
  416309
  424795
  438712
  419269
  421712
  420893
  644995
  817271
  827328
]
2.45 ms
(1.28%)
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
  384232
  389642
  397992
  398353
  415280
  416309
  418372
  418383
  419269
  420893
  421712
  424795
  430770
  438712
  443949
  448843
  455951
  459311
  467312
  486489
  487115
  512119
  513746
  517542
  521350
  523075
  524355
  528774
  537849
  539934
  545058
  551078
  556818
  557003
  567116
  582416
  600432
  606831
  607676
  609066
  611294
  613782
  615963
  617936
  620218
  621477
  624026
  638737
  644274
  644995
  662399
  666919
  680860
  688009
  692832
  707698
  710438
  710934
  711552
  726046
  726314
  726496
  726934
  728233
  728478
  730048
  730070
  730317
  732822
  737481
  738464
  740847
  742707
  745550
  755489
  756234
  757175
  757327
  762437
  767004
  767769
  770462
  770787
  772832
  775774
  776607
  776822
  779757
  781671
  781892
  787209
  789594
  790858
  793534
  794436
  795058
  796301
  797102
  797343
  797443
  797517
  799042
  799413
  802746
  803221
  803708
  804056
  804210
  805032
  805962
  806022
  806230
  807299
  808503
  811387
  812979
  813538
  817271
  825563
  827328
]
2.09 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "all big"
]
2.07 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.96 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "all большие"
]
1.62 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "all большие"
]

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.