Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.27 ms
(83.96%)
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
  53305
  383320
  384593
  385984
  386813
  396687
  415053
  415220
  418487
  419600
  424622
  426044
  426433
  434709
  441004
  443657
  446725
  447659
  449358
  452618
  453791
  454139
  455108
  458612
  458917
  458918
  460770
  461742
  461933
  463179
  463920
  463945
  464172
  465817
  468020
  468462
  470525
  470531
  472339
  473914
  474496
  476084
  476295
  478200
  478462
  478464
  479221
  479678
  480803
  484434
  487979
  489355
  489524
  489561
  490862
  491944
  492717
  494374
  512426
  513466
  519002
  519083
  519252
  526766
  535465
  536278
  542092
  545701
  548254
  548994
  551199
  552064
  552390
  566033
  569070
  571900
  571929
  572307
  579358
  596648
  596993
  598571
  603432
  609277
  622397
  624220
  634187
  634510
  636813
  637077
  638985
  644021
  652978
  653216
  653284
  656175
  665762
  678557
  679050
  680172
  680183
  691567
  705813
  714629
  720033
  720792
  722593
  730692
  737114
  738528
  740710
  753259
  754017
  775978
  786374
  788800
  788805
  801927
  811850
  817451
]
15.82 ms
(10.12%)
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
  461933
  548994
  786374
  740710
  385984
  545701
  634510
  638985
  551199
  569070
  622397
  383320
  384593
  434709
  461742
  447659
  474496
  487979
  479221
  478464
  479678
  476084
  463179
  419600
  455108
  415053
  489561
  468020
  691567
  458917
  817451
  652978
  720033
  609277
  788800
  424622
  443657
  458612
  470525
  453791
  454139
  460770
  465817
  490862
  478200
  535465
  470531
  473914
  463920
  464172
  415220
  426433
  452618
  468462
  446725
  512426
  526766
  484434
  489355
  491944
  513466
  536278
  492717
  519002
  441004
  634187
  548254
  680183
  571929
  552064
  571900
  653216
  653284
  656175
  678557
  720792
  665762
  679050
  680172
  705813
  722593
  598571
  596648
  596993
  636813
  637077
  788805
  730692
  737114
  753259
  754017
  624220
  644021
  714629
  775978
  801927
  811850
  458918
  542092
  552390
  572307
  603432
  738528
  53305
  396687
  386813
  476295
  566033
  478462
  480803
  418487
  426044
  449358
  463945
  472339
  494374
  519083
  519252
  489524
  579358
]
2.55 ms
(1.63%)
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
  53305
  383320
  384593
  385984
  386813
  396687
  415053
  415220
  418487
  419600
  424622
  426044
  426433
  434709
  441004
  443657
  446725
  447659
  449358
  452618
  453791
  454139
  455108
  458612
  458917
  458918
  460770
  461742
  461933
  463179
  463920
  463945
  464172
  465817
  468020
  468462
  470525
  470531
  472339
  473914
  474496
  476084
  476295
  478200
  478462
  478464
  479221
  479678
  480803
  484434
  487979
  489355
  489524
  489561
  490862
  491944
  492717
  494374
  512426
  513466
  519002
  519083
  519252
  526766
  535465
  536278
  542092
  545701
  548254
  548994
  551199
  552064
  552390
  566033
  569070
  571900
  571929
  572307
  579358
  596648
  596993
  598571
  603432
  609277
  622397
  624220
  634187
  634510
  636813
  637077
  638985
  644021
  652978
  653216
  653284
  656175
  665762
  678557
  679050
  680172
  680183
  691567
  705813
  714629
  720033
  720792
  722593
  730692
  737114
  738528
  740710
  753259
  754017
  775978
  786374
  788800
  788805
  801927
  811850
  817451
]
1.93 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "маленькая большие анал"
]
1.86 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "small big anal"
]
1.55 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.36 ms
(0.87%)
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.