Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
160.20 ms
(85.64%)
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
  4329
  172322
  172340
  172514
  197892
  233330
  355579
  382508
  383111
  391683
  396808
  420474
  443538
  446457
  455309
  465749
  478614
  496727
  503321
  511800
  517049
  517691
  520377
  533898
  533899
  540718
  543822
  549717
  550146
  553203
  557358
  560804
  561522
  561886
  568596
  583447
  584397
  586886
  591033
  591525
  591550
  599849
  612656
  614498
  615059
  617999
  627773
  631253
  633258
  634914
  641414
  642252
  642292
  642365
  644341
  659175
  660725
  667886
  682272
  691373
  697204
  702236
  703787
  705313
  712255
  712690
  713432
  714112
  720133
  720517
  721231
  725722
  726609
  727047
  734358
  734657
  736010
  740557
  744529
  744762
  746063
  746642
  754173
  758128
  763470
  763868
  765938
  765958
  767755
  773504
  775096
  778292
  778600
  782169
  782172
  786680
  787146
  789350
  789454
  789464
  789601
  789630
  793925
  795046
  795590
  796535
  796552
  797848
  801426
  801429
  801439
  801781
  802074
  802092
  803140
  804606
  810421
  810816
  812358
  812469
]
15.55 ms
(8.31%)
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
  682272
  705313
  659175
  591525
  612656
  633258
  642365
  644341
  631253
  801439
  778292
  789630
  802074
  796552
  801781
  804606
  725722
  763470
  765958
  767755
  773504
  744529
  726609
  763868
  617999
  697204
  702236
  786680
  801426
  810421
  233330
  355579
  517049
  591033
  443538
  446457
  396808
  549717
  561886
  591550
  782172
  560804
  503321
  197892
  4329
  420474
  478614
  520377
  511800
  540718
  553203
  550146
  583447
  584397
  660725
  703787
  712255
  714112
  667886
  713432
  720133
  720517
  691373
  712690
  721231
  557358
  561522
  599849
  614498
  642252
  642292
  615059
  778600
  812469
  775096
  793925
  795046
  802092
  803140
  810816
  812358
  727047
  734657
  740557
  754173
  789350
  795590
  796535
  744762
  758128
  765938
  746642
  746063
  634914
  787146
  789454
  789464
  789601
  801429
  641414
  782169
  797848
  391683
  586886
  627773
  734358
  736010
  383111
  568596
  455309
  172340
  172322
  172514
  382508
  517691
  533898
  533899
  496727
  465749
  543822
]
4.46 ms
(2.38%)
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
  4329
  172322
  172340
  172514
  197892
  233330
  355579
  382508
  383111
  391683
  396808
  420474
  443538
  446457
  455309
  465749
  478614
  496727
  503321
  511800
  517049
  517691
  520377
  533898
  533899
  540718
  543822
  549717
  550146
  553203
  557358
  560804
  561522
  561886
  568596
  583447
  584397
  586886
  591033
  591525
  591550
  599849
  612656
  614498
  615059
  617999
  627773
  631253
  633258
  634914
  641414
  642252
  642292
  642365
  644341
  659175
  660725
  667886
  682272
  691373
  697204
  702236
  703787
  705313
  712255
  712690
  713432
  714112
  720133
  720517
  721231
  725722
  726609
  727047
  734358
  734657
  736010
  740557
  744529
  744762
  746063
  746642
  754173
  758128
  763470
  763868
  765938
  765958
  767755
  773504
  775096
  778292
  778600
  782169
  782172
  786680
  787146
  789350
  789454
  789464
  789601
  789630
  793925
  795046
  795590
  796535
  796552
  797848
  801426
  801429
  801439
  801781
  802074
  802092
  803140
  804606
  810421
  810816
  812358
  812469
]
1.98 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "на кухня"
]
1.83 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на кухн"
]
1.60 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.78%)
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.