Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.54 ms
(82.35%)
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
  7219
  13767
  28397
  81214
  91248
  233915
  386212
  391600
  392902
  395612
  397413
  400428
  401146
  401946
  405777
  409249
  422499
  435530
  443489
  447912
  471759
  472859
  478256
  489648
  492109
  495331
  506518
  531290
  534585
  535754
  541558
  545365
  545765
  546838
  547432
  548785
  550948
  551183
  553472
  554892
  563333
  566763
  566858
  577376
  586939
  593207
  613643
  614237
  614292
  620113
  620240
  637460
  660612
  661283
  662916
  669026
  669045
  670765
  671247
  672095
  674658
  685466
  685524
  686002
  691598
  693103
  694062
  695631
  696522
  699695
  703088
  703534
  708475
  712786
  713486
  715620
  717206
  719940
  725618
  726878
  727689
  729929
  738641
  738674
  742015
  743900
  744270
  745912
  747129
  747335
  747503
  751213
  752625
  757031
  757915
  760827
  761157
  764868
  770304
  779010
  784260
  791101
  793219
  794783
  794852
  798947
  801322
  802552
  803687
  811649
  813549
  814434
  815898
  819053
  820642
  821088
  821182
  821552
  822786
  824198
]
15.69 ms
(10.63%)
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
  566763
  401946
  478256
  553472
  686002
  779010
  435530
  471759
  506518
  472859
  725618
  662916
  13767
  793219
  566858
  670765
  703534
  802552
  233915
  814434
  717206
  794852
  712786
  752625
  409249
  819053
  820642
  824198
  535754
  547432
  694062
  674658
  811649
  685466
  685524
  541558
  798947
  422499
  489648
  563333
  577376
  545765
  747129
  729929
  761157
  784260
  550948
  669045
  669026
  803687
  392902
  586939
  620240
  760827
  801322
  443489
  531290
  671247
  672095
  695631
  713486
  715620
  696522
  699695
  708475
  554892
  614237
  794783
  743900
  747503
  726878
  757031
  764868
  727689
  745912
  747335
  751213
  757915
  770304
  614292
  386212
  495331
  693103
  405777
  813549
  534585
  661283
  738674
  395612
  637460
  703088
  791101
  742015
  744270
  91248
  546838
  691598
  545365
  548785
  551183
  738641
  397413
  391600
  492109
  81214
  447912
  593207
  7219
  28397
  401146
  815898
  821088
  821552
  822786
  821182
  660612
  620113
  613643
  719940
  400428
]
2.78 ms
(1.88%)
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
  7219
  13767
  28397
  81214
  91248
  233915
  386212
  391600
  392902
  395612
  397413
  400428
  401146
  401946
  405777
  409249
  422499
  435530
  443489
  447912
  471759
  472859
  478256
  489648
  492109
  495331
  506518
  531290
  534585
  535754
  541558
  545365
  545765
  546838
  547432
  548785
  550948
  551183
  553472
  554892
  563333
  566763
  566858
  577376
  586939
  593207
  613643
  614237
  614292
  620113
  620240
  637460
  660612
  661283
  662916
  669026
  669045
  670765
  671247
  672095
  674658
  685466
  685524
  686002
  691598
  693103
  694062
  695631
  696522
  699695
  703088
  703534
  708475
  712786
  713486
  715620
  717206
  719940
  725618
  726878
  727689
  729929
  738641
  738674
  742015
  743900
  744270
  745912
  747129
  747335
  747503
  751213
  752625
  757031
  757915
  760827
  761157
  764868
  770304
  779010
  784260
  791101
  793219
  794783
  794852
  798947
  801322
  802552
  803687
  811649
  813549
  814434
  815898
  819053
  820642
  821088
  821182
  821552
  822786
  824198
]
2.11 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public solo anal"
]
1.96 ms
(1.33%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на улиц соло анал"
]
1.81 ms
(1.23%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(1.15%)
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.