Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.46 ms
(80.81%)
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
  97480
  172164
  172322
  172514
  197711
  338181
  381742
  383604
  386621
  390040
  390858
  391578
  417875
  465749
  478614
  494901
  498943
  511798
  517281
  517691
  519174
  521493
  521501
  522298
  533898
  533899
  540718
  545221
  546291
  546635
  550146
  553203
  555562
  555582
  555593
  556684
  557358
  558160
  560499
  561522
  563067
  564206
  569235
  571766
  574055
  577089
  578933
  579338
  583447
  584397
  590984
  591154
  591474
  591485
  591494
  591519
  591553
  591735
  598254
  602515
  604999
  605169
  606042
  615059
  617999
  631750
  641367
  642241
  642252
  642282
  642292
  642365
  646662
  659168
  660457
  660725
  685478
  691761
  697204
  697222
  702502
  703787
  710498
  711991
  712690
  713432
  714015
  720517
  727047
  734657
  744529
  744762
  746642
  751401
  753737
  758128
  763470
  763868
  765938
  765958
  767755
  773504
  775096
  782172
  786680
  789350
  789601
  789630
  793925
  795046
  796552
  801426
  801429
  801432
  801439
  802074
  802092
  810421
  810816
]
22.25 ms
(12.89%)
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
  642365
  605169
  801439
  789630
  802074
  796552
  763470
  765958
  767755
  773504
  744529
  753737
  763868
  617999
  697204
  786680
  801426
  801432
  810421
  197711
  390040
  558160
  498943
  172164
  519174
  521493
  494901
  511798
  517281
  560499
  571766
  579338
  545221
  563067
  564206
  577089
  569235
  555593
  574055
  598254
  590984
  591519
  602515
  642282
  591735
  631750
  591154
  591485
  591494
  604999
  606042
  417875
  521501
  522298
  97480
  338181
  4329
  478614
  540718
  553203
  546291
  550146
  583447
  584397
  660725
  703787
  713432
  720517
  697222
  712690
  557358
  561522
  591474
  642241
  642252
  642292
  591553
  615059
  782172
  775096
  793925
  795046
  802092
  810816
  727047
  734657
  789350
  744762
  758128
  765938
  746642
  789601
  801429
  386621
  172322
  391578
  711991
  714015
  383604
  390858
  555582
  660457
  578933
  641367
  751401
  710498
  685478
  556684
  172514
  381742
  517691
  533898
  533899
  465749
  555562
  546635
  646662
  659168
  691761
  702502
]
3.35 ms
(1.94%)
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
  97480
  172164
  172322
  172514
  197711
  338181
  381742
  383604
  386621
  390040
  390858
  391578
  417875
  465749
  478614
  494901
  498943
  511798
  517281
  517691
  519174
  521493
  521501
  522298
  533898
  533899
  540718
  545221
  546291
  546635
  550146
  553203
  555562
  555582
  555593
  556684
  557358
  558160
  560499
  561522
  563067
  564206
  569235
  571766
  574055
  577089
  578933
  579338
  583447
  584397
  590984
  591154
  591474
  591485
  591494
  591519
  591553
  591735
  598254
  602515
  604999
  605169
  606042
  615059
  617999
  631750
  641367
  642241
  642252
  642282
  642292
  642365
  646662
  659168
  660457
  660725
  685478
  691761
  697204
  697222
  702502
  703787
  710498
  711991
  712690
  713432
  714015
  720517
  727047
  734657
  744529
  744762
  746642
  751401
  753737
  758128
  763470
  763868
  765938
  765958
  767755
  773504
  775096
  782172
  786680
  789350
  789601
  789630
  793925
  795046
  796552
  801426
  801429
  801432
  801439
  802074
  802092
  810421
  810816
]
2.23 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife kitchen"
]
1.79 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен кухн"
]
1.71 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.