Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
275.72 ms
(91.74%)
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
  27635
  29242
  282652
  387074
  396319
  413245
  417722
  417756
  420426
  427092
  429254
  429261
  443361
  450646
  451453
  451580
  451585
  451605
  452621
  453156
  453680
  454075
  454335
  456359
  461772
  462165
  462964
  464582
  469326
  469802
  472344
  474102
  474860
  478086
  478261
  479996
  481140
  491372
  494046
  497103
  497112
  500886
  501306
  504564
  504591
  510145
  513292
  519657
  520461
  523086
  524536
  525642
  528341
  528901
  541190
  550166
  551173
  551189
  551221
  559022
  560493
  561620
  562319
  564092
  564445
  565368
  569899
  570037
  570595
  570609
  571537
  571575
  571596
  571923
  572483
  572818
  578059
  589357
  590606
  598789
  606114
  623450
  650037
  691223
  691603
  691834
  693126
  695605
  695665
  695969
  696049
  696050
  696062
  696613
  696617
  696687
  699005
  702476
  704551
  719889
  719905
  720510
  723148
  731031
  731711
  735817
  735977
  737569
  742126
  746092
  748126
  768456
  773360
  777155
  793687
  817455
  818806
  820673
  821740
  822193
]
14.56 ms
(4.84%)
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
  696687
  420426
  429261
  474860
  478261
  504591
  528901
  569899
  572818
  571923
  571575
  565368
  453680
  462165
  452621
  472344
  500886
  494046
  513292
  501306
  282652
  429254
  453156
  451585
  413245
  570609
  551173
  454335
  723148
  387074
  27635
  462964
  562319
  570037
  469802
  820673
  818806
  550166
  702476
  735817
  773360
  704551
  696050
  696617
  768456
  693126
  691834
  699005
  561620
  598789
  720510
  793687
  737569
  504564
  551189
  571596
  589357
  478086
  523086
  541190
  650037
  497112
  491372
  564092
  570595
  461772
  451453
  464582
  450646
  417722
  451580
  396319
  695605
  735977
  822193
  821740
  510145
  525642
  691603
  691223
  696613
  777155
  742126
  748126
  731711
  623450
  551221
  560493
  696049
  719889
  695665
  695969
  696062
  606114
  590606
  731031
  817455
  746092
  417756
  571537
  443361
  497103
  564445
  578059
  29242
  559022
  519657
  520461
  528341
  719905
  474102
  469326
  427092
  481140
  451605
  456359
  524536
  454075
  572483
  479996
]
2.99 ms
(0.99%)
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
  27635
  29242
  282652
  387074
  396319
  413245
  417722
  417756
  420426
  427092
  429254
  429261
  443361
  450646
  451453
  451580
  451585
  451605
  452621
  453156
  453680
  454075
  454335
  456359
  461772
  462165
  462964
  464582
  469326
  469802
  472344
  474102
  474860
  478086
  478261
  479996
  481140
  491372
  494046
  497103
  497112
  500886
  501306
  504564
  504591
  510145
  513292
  519657
  520461
  523086
  524536
  525642
  528341
  528901
  541190
  550166
  551173
  551189
  551221
  559022
  560493
  561620
  562319
  564092
  564445
  565368
  569899
  570037
  570595
  570609
  571537
  571575
  571596
  571923
  572483
  572818
  578059
  589357
  590606
  598789
  606114
  623450
  650037
  691223
  691603
  691834
  693126
  695605
  695665
  695969
  696049
  696050
  696062
  696613
  696617
  696687
  699005
  702476
  704551
  719889
  719905
  720510
  723148
  731031
  731711
  735817
  735977
  737569
  742126
  746092
  748126
  768456
  773360
  777155
  793687
  817455
  818806
  820673
  821740
  822193
]
2.14 ms
(0.71%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pickup public"
]
1.99 ms
(0.66%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пикап на улиц"
]
1.68 ms
(0.56%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.49%)
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.