Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
110.99 ms
(85.56%)
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
  13450
  30310
  76981
  170225
  235677
  266369
  298529
  310725
  384065
  385674
  386622
  398924
  477355
  478570
  478902
  490198
  515006
  529346
  533549
  533986
  539455
  540106
  543939
  569727
  578337
  583033
  595217
  605605
  606606
  606663
  619073
  625739
  641856
  646191
  659602
  660250
  667681
  671078
  671892
  678779
  678818
  684989
  687755
  687802
  692462
  693540
  695054
  695353
  695359
  702896
  705887
  707379
  721670
  738349
  747072
  747770
  751713
  753615
  754756
  756135
  756311
  760761
  764648
  774119
  774567
  776535
  777710
  782366
  782368
  791779
  792026
  794854
  796657
  799009
  803008
  803254
  811467
  813950
  815401
  817315
  817572
  817588
  817856
  818990
  819241
  820040
  820078
  820180
  820694
  821711
  821766
  822572
  823057
  823450
  823862
  823954
  824008
  824234
  824288
  824903
  824932
  825142
  825226
  825737
  825985
  826113
  826613
  826680
  826987
  827585
  828202
  828445
  828499
  828548
  828654
  828755
  828785
]
10.40 ms
(8.01%)
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
  754756
  398924
  490198
  687755
  777710
  796657
  824234
  820040
  825737
  828445
  828654
  774119
  310725
  625739
  747770
  477355
  583033
  678779
  641856
  13450
  235677
  386622
  298529
  815401
  817856
  821711
  824903
  826613
  819241
  821766
  822572
  823954
  813950
  823057
  823450
  824288
  825928
  826522
  817315
  823797
  823862
  825226
  826113
  828755
  828785
  828499
  478570
  533986
  515006
  543939
  578337
  646191
  695359
  721670
  605605
  619073
  606606
  606663
  791779
  803008
  803254
  774567
  794854
  799009
  756135
  792026
  811467
  764648
  738349
  751713
  753615
  760761
  747072
  756311
  702896
  776535
  782366
  782368
  384065
  170225
  828548
  595217
  385674
  266369
  76981
  30310
  817572
  817588
  818990
  820180
  824008
  824932
  826680
  820078
  820694
  825142
  825985
  826987
  827585
  828202
  539455
  529346
  533549
  540106
  478902
  569727
  660250
  687802
  707379
  667681
  671892
  692462
  659602
  671078
  678818
  684989
  693540
  695054
  695353
  705887
]
2.11 ms
(1.62%)
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
  13450
  30310
  76981
  170225
  235677
  266369
  298529
  310725
  384065
  385674
  386622
  398924
  477355
  478570
  478902
  490198
  515006
  529346
  533549
  533986
  539455
  540106
  543939
  569727
  578337
  583033
  595217
  605605
  606606
  606663
  619073
  625739
  641856
  646191
  659602
  660250
  667681
  671078
  671892
  678779
  678818
  684989
  687755
  687802
  692462
  693540
  695054
  695353
  695359
  702896
  705887
  707379
  721670
  738349
  747072
  747770
  751713
  753615
  754756
  756135
  756311
  760761
  764648
  774119
  774567
  776535
  777710
  782366
  782368
  791779
  792026
  794854
  796657
  799009
  803008
  803254
  811467
  813950
  815401
  817315
  817572
  817588
  817856
  818990
  819241
  820040
  820078
  820180
  820694
  821711
  821766
  822572
  823057
  823450
  823862
  823954
  824008
  824234
  824288
  824903
  824932
  825142
  825226
  825737
  825985
  826113
  826613
  826680
  826987
  827585
  828202
  828445
  828499
  828548
  828654
  828755
  828785
]
1.97 ms
(1.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "чулки и белье"
]
1.45 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "чулк нижн бел бел"
]
1.43 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.39 ms
(1.07%)
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.