Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.36 ms
(83.63%)
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
  74434
  100616
  183634
  188437
  233186
  233344
  365912
  365948
  382492
  386973
  389623
  391967
  392028
  392597
  392675
  396563
  397885
  397888
  397911
  398959
  400511
  411365
  411372
  411397
  411419
  411916
  421569
  424000
  424124
  424238
  431585
  432374
  432458
  432509
  433489
  433729
  433792
  435398
  437765
  443724
  443769
  444148
  444615
  447095
  451568
  453610
  455297
  455551
  456078
  456453
  457837
  460285
  462826
  463403
  465926
  466324
  468105
  470656
  472076
  479455
  479955
  482907
  488603
  489579
  491926
  491982
  494943
  499412
  500377
  502333
  503682
  505716
  507323
  509673
  511518
  514441
  515621
  515707
  536888
  537397
  537852
  543646
  553684
  556690
  559270
  588357
  588710
  596169
  608188
  608787
  626083
  630037
  662926
  673204
  678815
  679367
  680021
  688166
  695359
  704149
  707642
  714656
  753615
  754541
  764123
  764648
  773775
  774186
  774211
  776535
  782366
  782368
  786434
  792026
  797958
  798666
  807349
  809348
  821766
  825802
]
16.25 ms
(10.19%)
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
  463403
  543646
  714656
  608188
  397888
  233344
  400511
  453610
  365948
  397885
  365912
  432509
  455297
  392028
  457837
  183634
  233186
  515707
  444148
  596169
  451568
  444615
  397911
  100616
  392675
  433489
  479455
  411372
  466324
  505716
  494943
  500377
  825802
  678815
  537397
  553684
  679367
  688166
  704149
  662926
  673204
  588357
  797958
  786434
  807349
  774186
  774211
  754541
  707642
  432374
  556690
  432458
  515621
  424238
  470656
  382492
  482907
  559270
  433729
  424124
  389623
  386973
  188437
  411419
  74434
  443769
  443724
  536888
  462826
  514441
  798666
  537852
  680021
  630037
  465926
  507323
  626083
  764123
  773775
  809348
  391967
  433792
  499412
  392597
  411916
  435398
  472076
  437765
  511518
  411397
  421569
  460285
  488603
  588710
  424000
  398959
  455551
  456453
  479955
  411365
  456078
  468105
  491982
  503682
  489579
  491926
  502333
  821766
  695359
  792026
  764648
  753615
  776535
  782366
  782368
  431585
  509673
  608787
  447095
  396563
]
3.29 ms
(2.07%)
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
  74434
  100616
  183634
  188437
  233186
  233344
  365912
  365948
  382492
  386973
  389623
  391967
  392028
  392597
  392675
  396563
  397885
  397888
  397911
  398959
  400511
  411365
  411372
  411397
  411419
  411916
  421569
  424000
  424124
  424238
  431585
  432374
  432458
  432509
  433489
  433729
  433792
  435398
  437765
  443724
  443769
  444148
  444615
  447095
  451568
  453610
  455297
  455551
  456078
  456453
  457837
  460285
  462826
  463403
  465926
  466324
  468105
  470656
  472076
  479455
  479955
  482907
  488603
  489579
  491926
  491982
  494943
  499412
  500377
  502333
  503682
  505716
  507323
  509673
  511518
  514441
  515621
  515707
  536888
  537397
  537852
  543646
  553684
  556690
  559270
  588357
  588710
  596169
  608188
  608787
  626083
  630037
  662926
  673204
  678815
  679367
  680021
  688166
  695359
  704149
  707642
  714656
  753615
  754541
  764123
  764648
  773775
  774186
  774211
  776535
  782366
  782368
  786434
  792026
  797958
  798666
  807349
  809348
  821766
  825802
]
2.02 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "stockings russian"
]
1.60 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "чулк нижн бел русск"
]
1.49 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(0.91%)
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.