Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.33 ms
(87.05%)
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
  65883
  187919
  224641
  304063
  378272
  387653
  391836
  392049
  397680
  398003
  398612
  400409
  400620
  400656
  400855
  403027
  405744
  405974
  415757
  418221
  418324
  423104
  425459
  431677
  434771
  436570
  437374
  437390
  440047
  440892
  441805
  447227
  449283
  449416
  451323
  451865
  455257
  455889
  458189
  458229
  459081
  459638
  460070
  460252
  460683
  460845
  462661
  462665
  463242
  464700
  465930
  466137
  468294
  471982
  476382
  476876
  478986
  479243
  479573
  480815
  480868
  481130
  483868
  488214
  488927
  488946
  489021
  490476
  491038
  492992
  494788
  496670
  499311
  505561
  507480
  511516
  513854
  521008
  523175
  525527
  526945
  533824
  542819
  564252
  569265
  569383
  574199
  575380
  577995
  580016
  584479
  586928
  590264
  593137
  609739
  612976
  613335
  614600
  620119
  628650
  643458
  650500
  664698
  667911
  673345
  681394
  691619
  693668
  741169
  746200
  764264
  785083
  786123
  789565
  796441
  804094
  810797
  819153
  825857
  826441
]
12.87 ms
(7.40%)
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
  458229
  479573
  451865
  460070
  471982
  476382
  483868
  507480
  525527
  533824
  464700
  577995
  575380
  681394
  590264
  593137
  614600
  796441
  746200
  434771
  480815
  418221
  451323
  478986
  449416
  455257
  468294
  526945
  489021
  488214
  490476
  564252
  584479
  613335
  492992
  499311
  65883
  187919
  378272
  397680
  400656
  400855
  405974
  437374
  415757
  440892
  826441
  479243
  542819
  693668
  569383
  609739
  643458
  786123
  764264
  398612
  403027
  458189
  460845
  418324
  460683
  496670
  513854
  494788
  521008
  463242
  574199
  580016
  673345
  586928
  620119
  423104
  447227
  455889
  465930
  511516
  488927
  480868
  462661
  523175
  488946
  667911
  741169
  804094
  224641
  304063
  387653
  400620
  405744
  437390
  431677
  440047
  825857
  819153
  459638
  462665
  460252
  664698
  650500
  691619
  569265
  628650
  612976
  789565
  785083
  810797
  436570
  459081
  392049
  400409
  425459
  441805
  466137
  391836
  398003
  449283
  481130
  476876
  505561
  491038
]
2.43 ms
(1.40%)
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
  65883
  187919
  224641
  304063
  378272
  387653
  391836
  392049
  397680
  398003
  398612
  400409
  400620
  400656
  400855
  403027
  405744
  405974
  415757
  418221
  418324
  423104
  425459
  431677
  434771
  436570
  437374
  437390
  440047
  440892
  441805
  447227
  449283
  449416
  451323
  451865
  455257
  455889
  458189
  458229
  459081
  459638
  460070
  460252
  460683
  460845
  462661
  462665
  463242
  464700
  465930
  466137
  468294
  471982
  476382
  476876
  478986
  479243
  479573
  480815
  480868
  481130
  483868
  488214
  488927
  488946
  489021
  490476
  491038
  492992
  494788
  496670
  499311
  505561
  507480
  511516
  513854
  521008
  523175
  525527
  526945
  533824
  542819
  564252
  569265
  569383
  574199
  575380
  577995
  580016
  584479
  586928
  590264
  593137
  609739
  612976
  613335
  614600
  620119
  628650
  643458
  650500
  664698
  667911
  673345
  681394
  691619
  693668
  741169
  746200
  764264
  785083
  786123
  789565
  796441
  804094
  810797
  819153
  825857
  826441
]
2.17 ms
(1.25%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "бритая жен"
]
1.91 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "бритая жена"
]
1.75 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "бритая жен"
]
1.39 ms
(0.80%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.