Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.11 ms
(83.01%)
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
  3561
  11947
  44871
  59488
  309991
  310190
  365893
  383098
  385031
  385380
  388261
  392675
  393418
  398824
  401398
  409045
  413700
  423944
  428684
  428702
  432358
  433418
  437657
  440802
  443975
  448114
  464357
  465673
  466492
  466868
  469324
  472907
  477262
  478382
  479587
  481257
  484962
  485089
  487860
  489222
  492754
  499874
  503487
  514766
  515915
  522438
  526437
  526508
  526555
  528500
  529008
  529654
  531317
  533270
  537549
  540474
  541167
  544801
  546076
  548458
  554405
  562603
  563168
  568181
  568899
  569320
  570115
  571312
  573243
  577052
  577182
  577204
  578768
  579547
  580248
  580577
  582292
  582558
  602832
  606337
  607029
  607269
  611795
  639861
  666439
  675310
  715473
  725473
  728224
  728295
  729640
  732793
  744200
  745461
  745844
  752950
  755952
  758809
  759554
  760777
  763141
  764234
  770241
  772557
  774761
  781856
  786470
  788365
  794213
  796494
  798087
  800239
  801704
  802150
  803512
  806473
  808958
  811705
  818009
  819237
]
17.24 ms
(11.09%)
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
  802150
  788365
  801704
  755952
  763141
  772557
  781856
  728224
  744200
  764234
  770241
  806473
  401398
  546076
  554405
  528500
  544801
  666439
  811705
  758809
  725473
  526508
  579547
  569320
  423944
  44871
  428702
  537549
  529008
  499874
  465673
  573243
  580248
  808958
  385031
  432358
  437657
  477262
  365893
  388261
  515915
  492754
  526555
  484962
  464357
  481257
  443975
  819237
  548458
  577204
  578768
  582292
  602832
  607269
  611795
  803512
  752950
  798087
  800239
  728295
  745461
  729640
  715473
  794213
  796494
  469324
  568181
  570115
  759554
  59488
  818009
  472907
  563168
  571312
  580577
  675310
  774761
  732793
  745844
  478382
  479587
  485089
  503487
  489222
  487860
  309991
  310190
  11947
  398824
  433418
  529654
  582558
  568899
  639861
  760777
  392675
  409045
  522438
  607029
  385380
  606337
  786470
  577182
  466868
  440802
  428684
  383098
  393418
  3561
  413700
  448114
  466492
  531317
  514766
  526437
  540474
  533270
  562603
  577052
  541167
]
2.25 ms
(1.45%)
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
  3561
  11947
  44871
  59488
  309991
  310190
  365893
  383098
  385031
  385380
  388261
  392675
  393418
  398824
  401398
  409045
  413700
  423944
  428684
  428702
  432358
  433418
  437657
  440802
  443975
  448114
  464357
  465673
  466492
  466868
  469324
  472907
  477262
  478382
  479587
  481257
  484962
  485089
  487860
  489222
  492754
  499874
  503487
  514766
  515915
  522438
  526437
  526508
  526555
  528500
  529008
  529654
  531317
  533270
  537549
  540474
  541167
  544801
  546076
  548458
  554405
  562603
  563168
  568181
  568899
  569320
  570115
  571312
  573243
  577052
  577182
  577204
  578768
  579547
  580248
  580577
  582292
  582558
  602832
  606337
  607029
  607269
  611795
  639861
  666439
  675310
  715473
  725473
  728224
  728295
  729640
  732793
  744200
  745461
  745844
  752950
  755952
  758809
  759554
  760777
  763141
  764234
  770241
  772557
  774761
  781856
  786470
  788365
  794213
  796494
  798087
  800239
  801704
  802150
  803512
  806473
  808958
  811705
  818009
  819237
]
2.10 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "чулки большие попы"
]
1.95 ms
(1.25%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.45 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "чулк нижн бел большая большие жоп"
]
1.42 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.