Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.15 ms
(86.07%)
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
  97823
  384948
  388762
  396758
  397421
  398947
  400507
  401949
  412078
  415894
  419013
  421844
  421861
  422299
  424145
  426127
  426796
  427057
  427148
  435324
  439584
  439753
  443019
  443785
  444187
  444991
  446646
  450674
  452666
  454356
  455324
  457340
  459474
  459727
  461571
  461787
  463490
  463637
  464268
  465870
  465990
  466019
  466361
  466462
  467628
  470260
  470387
  470617
  473679
  473975
  478021
  483238
  484394
  484447
  485870
  494671
  497809
  499836
  501904
  504188
  504352
  506732
  507637
  508048
  511635
  513258
  516382
  520398
  523450
  526234
  526527
  541018
  545994
  550495
  552594
  559580
  569637
  573824
  596997
  597545
  609505
  624128
  649269
  653273
  655295
  669515
  688922
  703650
  703689
  704599
  711362
  714602
  714922
  736392
  736960
  737563
  744404
  754759
  760463
  766180
  766376
  768978
  769059
  774065
  782225
  782526
  782751
  786320
  787340
  791463
  793011
  796459
  797315
  799769
  802100
  804829
  805145
  818778
  823822
  825904
]
13.86 ms
(8.00%)
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
  419013
  426127
  464268
  513258
  520398
  825904
  653273
  704599
  782526
  796459
  774065
  711362
  427148
  427057
  455324
  466361
  552594
  649269
  655295
  669515
  782225
  805145
  799769
  736392
  744404
  766376
  768978
  766180
  737563
  793011
  384948
  412078
  398947
  466462
  470387
  507637
  467628
  396758
  444991
  450674
  459727
  545994
  791463
  446646
  454356
  401949
  573824
  97823
  415894
  501904
  818778
  823822
  541018
  703689
  714922
  714602
  782751
  786320
  787340
  769059
  754759
  736960
  473975
  484447
  465990
  559580
  463637
  421844
  461571
  485870
  506732
  508048
  511635
  526234
  499836
  504188
  523450
  526527
  463490
  470617
  494671
  597545
  397421
  426796
  443019
  452666
  388762
  435324
  459474
  465870
  466019
  473679
  422299
  439584
  461787
  424145
  439753
  443785
  444187
  457340
  421861
  478021
  484394
  483238
  516382
  504352
  400507
  470260
  497809
  569637
  550495
  688922
  703650
  609505
  596997
  624128
  804829
  797315
  802100
  760463
]
3.17 ms
(1.83%)
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
  97823
  384948
  388762
  396758
  397421
  398947
  400507
  401949
  412078
  415894
  419013
  421844
  421861
  422299
  424145
  426127
  426796
  427057
  427148
  435324
  439584
  439753
  443019
  443785
  444187
  444991
  446646
  450674
  452666
  454356
  455324
  457340
  459474
  459727
  461571
  461787
  463490
  463637
  464268
  465870
  465990
  466019
  466361
  466462
  467628
  470260
  470387
  470617
  473679
  473975
  478021
  483238
  484394
  484447
  485870
  494671
  497809
  499836
  501904
  504188
  504352
  506732
  507637
  508048
  511635
  513258
  516382
  520398
  523450
  526234
  526527
  541018
  545994
  550495
  552594
  559580
  569637
  573824
  596997
  597545
  609505
  624128
  649269
  653273
  655295
  669515
  688922
  703650
  703689
  704599
  711362
  714602
  714922
  736392
  736960
  737563
  744404
  754759
  760463
  766180
  766376
  768978
  769059
  774065
  782225
  782526
  782751
  786320
  787340
  791463
  793011
  796459
  797315
  799769
  802100
  804829
  805145
  818778
  823822
  825904
]
1.99 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "русское душ"
]
1.81 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск ван"
]
1.53 ms
(0.88%)
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.