Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
208.87 ms
(53.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "подборки соло нарезка"
]
154.68 ms
(39.31%)
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
  3561
  88182
  175985
  383045
  384759
  413227
  467024
  474315
  503023
  521247
  524480
  524494
  527507
  528034
  528951
  529396
  532581
  533270
  533841
  540560
  547407
  550473
  550677
  554143
  554199
  557450
  557471
  558912
  562603
  565131
  566622
  568136
  579594
  579607
  582010
  583066
  585475
  587232
  589365
  590922
  591688
  592357
  592516
  592948
  593146
  593219
  593232
  595161
  596033
  597908
  598482
  603109
  603396
  608378
  614794
  614798
  614819
  614852
  617817
  618447
  618567
  619656
  619902
  628623
  629356
  633213
  639306
  640514
  642962
  648503
  650453
  661577
  668536
  670278
  672901
  691401
  707900
  709898
  710458
  710800
  731232
  732223
  732926
  735140
  735970
  738093
  739134
  740435
  744871
  750418
  750950
  751012
  751168
  752226
  752405
  752410
  753554
  755741
  758809
  759992
  770155
  771887
  786344
  786611
  788366
  788590
  790124
  790810
  802225
  802317
  803819
  803915
  805359
  805363
  807408
  811802
  812745
  813802
  819237
  826018
]
21.43 ms
(5.45%)
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
  670278
  672901
  691401
  710800
  661577
  710458
  585475
  592516
  593232
  598482
  619656
  628623
  629356
  614794
  619902
  640514
  614798
  614819
  642962
  788590
  802225
  805359
  812745
  788366
  803819
  807408
  731232
  752226
  752410
  753554
  802317
  805363
  739134
  740435
  744871
  750950
  770155
  735970
  633213
  709898
  786611
  803915
  383045
  413227
  175985
  474315
  528034
  88182
  384759
  3561
  826018
  813802
  819237
  467024
  529396
  503023
  528951
  524480
  524494
  527507
  532581
  533841
  540560
  521247
  533270
  550473
  562603
  566622
  579607
  550677
  557450
  557471
  565131
  579594
  547407
  558912
  582010
  648503
  668536
  650453
  554143
  554199
  568136
  583066
  589365
  596033
  608378
  592948
  595161
  618447
  618567
  587232
  593146
  593219
  597908
  603109
  603396
  590922
  591688
  592357
  614852
  617817
  786344
  755741
  758809
  759992
  790124
  790810
  811802
  751012
  735140
  752405
  771887
  732223
  732926
  738093
  750418
  751168
  639306
  707900
]
3.47 ms
(0.88%)
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
  3561
  88182
  175985
  383045
  384759
  413227
  467024
  474315
  503023
  521247
  524480
  524494
  527507
  528034
  528951
  529396
  532581
  533270
  533841
  540560
  547407
  550473
  550677
  554143
  554199
  557450
  557471
  558912
  562603
  565131
  566622
  568136
  579594
  579607
  582010
  583066
  585475
  587232
  589365
  590922
  591688
  592357
  592516
  592948
  593146
  593219
  593232
  595161
  596033
  597908
  598482
  603109
  603396
  608378
  614794
  614798
  614819
  614852
  617817
  618447
  618567
  619656
  619902
  628623
  629356
  633213
  639306
  640514
  642962
  648503
  650453
  661577
  668536
  670278
  672901
  691401
  707900
  709898
  710458
  710800
  731232
  732223
  732926
  735140
  735970
  738093
  739134
  740435
  744871
  750418
  750950
  751012
  751168
  752226
  752405
  752410
  753554
  755741
  758809
  759992
  770155
  771887
  786344
  786611
  788366
  788590
  790124
  790810
  802225
  802317
  803819
  803915
  805359
  805363
  807408
  811802
  812745
  813802
  819237
  826018
]
1.90 ms
(0.48%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "подборк соло подборк"
]
1.53 ms
(0.39%)
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.