Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
162.22 ms
(87.95%)
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
  232973
  233151
  388261
  389526
  391237
  391502
  392037
  392054
  400842
  400852
  400858
  409843
  420127
  423953
  424273
  426772
  428904
  429800
  432557
  433418
  439650
  439689
  442855
  442932
  451500
  454771
  455877
  459645
  461619
  461983
  462030
  464244
  465746
  466281
  467650
  467928
  475872
  478121
  484664
  485087
  486325
  487217
  488535
  490881
  490892
  490902
  506045
  507487
  511593
  515618
  515855
  528112
  538725
  543733
  543985
  547882
  552095
  554553
  555039
  555096
  556330
  558928
  562910
  568593
  579547
  580248
  590563
  596179
  601981
  620661
  626492
  631260
  635770
  651822
  663192
  672819
  680562
  684714
  686989
  688155
  705408
  724809
  738331
  739250
  741046
  741855
  745742
  746580
  747725
  752077
  754030
  760777
  763435
  764403
  764659
  766787
  768950
  772150
  779577
  781513
  782235
  782495
  783051
  786755
  788100
  788715
  789779
  790459
  791518
  792014
  793143
  795202
  798019
  799730
  800248
  801681
  803091
  803631
  818003
]
13.06 ms
(7.08%)
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
  543985
  400858
  433418
  515618
  538725
  579547
  547882
  555096
  663192
  688155
  672819
  680562
  554553
  620661
  626492
  782235
  790459
  801681
  803091
  803631
  760777
  763435
  766787
  741855
  768950
  724809
  741046
  389526
  391237
  409843
  432557
  490902
  439689
  391502
  459645
  486325
  232973
  426772
  464244
  465746
  420127
  428904
  429800
  467650
  451500
  485087
  818003
  511593
  543733
  558928
  651822
  684714
  686989
  562910
  590563
  623802
  596179
  631260
  779577
  782495
  783051
  788100
  788715
  792014
  795202
  789779
  791518
  798019
  800248
  752077
  781513
  786755
  793143
  772150
  745742
  746580
  764403
  738331
  739250
  747725
  764659
  635770
  705408
  799730
  601981
  442932
  442855
  507487
  467928
  478121
  466281
  515855
  528112
  400842
  461619
  461983
  580248
  424273
  475872
  423953
  388261
  487217
  490892
  488535
  233151
  555039
  556330
  400852
  484664
  568593
  754030
  392037
  490881
  552095
  439650
  392054
  454771
  462030
  455877
  506045
]
2.47 ms
(1.34%)
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
  232973
  233151
  388261
  389526
  391237
  391502
  392037
  392054
  400842
  400852
  400858
  409843
  420127
  423953
  424273
  426772
  428904
  429800
  432557
  433418
  439650
  439689
  442855
  442932
  451500
  454771
  455877
  459645
  461619
  461983
  462030
  464244
  465746
  466281
  467650
  467928
  475872
  478121
  484664
  485087
  486325
  487217
  488535
  490881
  490892
  490902
  506045
  507487
  511593
  515618
  515855
  528112
  538725
  543733
  543985
  547882
  552095
  554553
  555039
  555096
  556330
  558928
  562910
  568593
  579547
  580248
  590563
  596179
  601981
  620661
  626492
  631260
  635770
  651822
  663192
  672819
  680562
  684714
  686989
  688155
  705408
  724809
  738331
  739250
  741046
  741855
  745742
  746580
  747725
  752077
  754030
  760777
  763435
  764403
  764659
  766787
  768950
  772150
  779577
  781513
  782235
  782495
  783051
  786755
  788100
  788715
  789779
  790459
  791518
  792014
  793143
  795202
  798019
  799730
  800248
  801681
  803091
  803631
  818003
]
1.88 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "русский чулках"
]
1.77 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск чулк нижн бел"
]
1.65 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.40 ms
(0.76%)
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.