Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.01 ms
(87.46%)
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
  388224
  413304
  420769
  422163
  423080
  424628
  429478
  430291
  436848
  440760
  443381
  444241
  451693
  457346
  457844
  458797
  459170
  459663
  461213
  462053
  463674
  464885
  466887
  467131
  467145
  467186
  467404
  467461
  470954
  477232
  478484
  482680
  483184
  483453
  487090
  487095
  496147
  496259
  497057
  497203
  498183
  504572
  508944
  510691
  510721
  511649
  511727
  511748
  512247
  512324
  512326
  512813
  513445
  515589
  516084
  517887
  518595
  518787
  523512
  523820
  524579
  525223
  525996
  528611
  528689
  531113
  532877
  533607
  542066
  543217
  546017
  548654
  549170
  551456
  551620
  553469
  555895
  557120
  557629
  561023
  562813
  564737
  568208
  570090
  572845
  572943
  573483
  578067
  578106
  578128
  580425
  584663
  589758
  591352
  591648
  591791
  594770
  594790
  594814
  594844
  594846
  594874
  594899
  594931
  594933
  594979
  602755
  603973
  605367
  605613
  605615
  606951
  612044
  617111
  619858
  621937
  632336
  732518
  735005
  779003
]
13.20 ms
(7.35%)
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
  444241
  424628
  413304
  457346
  487090
  487095
  528689
  422163
  517887
  578067
  735005
  617111
  512247
  508944
  466887
  467131
  462053
  511727
  515589
  511649
  512813
  557629
  572845
  594814
  594844
  732518
  496147
  512324
  504572
  513445
  568208
  578128
  594874
  594899
  632336
  528611
  467145
  621937
  511748
  591791
  512326
  548654
  603973
  516084
  561023
  483453
  533607
  551620
  591648
  478484
  553469
  482680
  594790
  594931
  510721
  612044
  602755
  436848
  464885
  429478
  496259
  570090
  459170
  518787
  551456
  594770
  388224
  557120
  562813
  542066
  580425
  591352
  423080
  477232
  458797
  524579
  461213
  572943
  779003
  451693
  459663
  510691
  525996
  549170
  605615
  467186
  564737
  420769
  578106
  605613
  605367
  523820
  497057
  573483
  523512
  606951
  525223
  531113
  543217
  546017
  619858
  498183
  470954
  532877
  594979
  594846
  467461
  440760
  457844
  518595
  555895
  584663
  594933
  467404
  463674
  483184
  497203
  443381
  430291
  589758
]
2.49 ms
(1.39%)
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
  388224
  413304
  420769
  422163
  423080
  424628
  429478
  430291
  436848
  440760
  443381
  444241
  451693
  457346
  457844
  458797
  459170
  459663
  461213
  462053
  463674
  464885
  466887
  467131
  467145
  467186
  467404
  467461
  470954
  477232
  478484
  482680
  483184
  483453
  487090
  487095
  496147
  496259
  497057
  497203
  498183
  504572
  508944
  510691
  510721
  511649
  511727
  511748
  512247
  512324
  512326
  512813
  513445
  515589
  516084
  517887
  518595
  518787
  523512
  523820
  524579
  525223
  525996
  528611
  528689
  531113
  532877
  533607
  542066
  543217
  546017
  548654
  549170
  551456
  551620
  553469
  555895
  557120
  557629
  561023
  562813
  564737
  568208
  570090
  572845
  572943
  573483
  578067
  578106
  578128
  580425
  584663
  589758
  591352
  591648
  591791
  594770
  594790
  594814
  594844
  594846
  594874
  594899
  594931
  594933
  594979
  602755
  603973
  605367
  605613
  605615
  606951
  612044
  617111
  619858
  621937
  632336
  732518
  735005
  779003
]
2.08 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "money public sex"
]
1.97 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "money на улиц секс"
]
1.41 ms
(0.78%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.36 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "money на улиц секс"
]

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.