Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.65 ms
(80.36%)
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
  416382
  419475
  421234
  422159
  425052
  430264
  430437
  431422
  432393
  435700
  452338
  456736
  465641
  472833
  475543
  475984
  477860
  478530
  481359
  481361
  487693
  490894
  495895
  507884
  510518
  511823
  513155
  513374
  515434
  515974
  518072
  520815
  521262
  521306
  524389
  525348
  526005
  526041
  527447
  528001
  529457
  530043
  531089
  531935
  535013
  541740
  542191
  547734
  549027
  550205
  556397
  563547
  565491
  565539
  565581
  565925
  566781
  569132
  570765
  571954
  576623
  576629
  576690
  578606
  579754
  585744
  586485
  587821
  590298
  590505
  591004
  593441
  596075
  596235
  598204
  598845
  599833
  600006
  600258
  600317
  601535
  602880
  604386
  605617
  605636
  606993
  607129
  610668
  612381
  616350
  620031
  621508
  624111
  632642
  633786
  636033
  637036
  637413
  638115
  639060
  640710
  641859
  643523
  646448
  648817
  649106
  651674
  665768
  727812
  763741
  792576
  804464
  807023
  810933
  810976
  811032
  813945
  814991
  815056
  815268
]
19.75 ms
(12.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
  586485
  604386
  598845
  610668
  590298
  596075
  600258
  600317
  810933
  811032
  763741
  621508
  422159
  481359
  416382
  465641
  475543
  425052
  432393
  510518
  525348
  487693
  528001
  530043
  511823
  814991
  472833
  507884
  513155
  565925
  549027
  550205
  556397
  565539
  565581
  649106
  565491
  587821
  590505
  598204
  593441
  643523
  596235
  605617
  810976
  792576
  640710
  419475
  478530
  481361
  435700
  475984
  524389
  490894
  495895
  520815
  521262
  531089
  515974
  569132
  576690
  571954
  648817
  566781
  576629
  591004
  606993
  638115
  633786
  605636
  601535
  804464
  807023
  431422
  531935
  815268
  518072
  576623
  612381
  585744
  624111
  727812
  430437
  421234
  529457
  535013
  456736
  579754
  665768
  563547
  636033
  637036
  599833
  813945
  430264
  477860
  513374
  541740
  651674
  600006
  620031
  616350
  632642
  639060
  527447
  526005
  526041
  641859
  515434
  542191
  570765
  646448
  602880
  607129
  637413
  521306
  815056
  452338
  547734
  578606
]
3.41 ms
(2.18%)
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
  416382
  419475
  421234
  422159
  425052
  430264
  430437
  431422
  432393
  435700
  452338
  456736
  465641
  472833
  475543
  475984
  477860
  478530
  481359
  481361
  487693
  490894
  495895
  507884
  510518
  511823
  513155
  513374
  515434
  515974
  518072
  520815
  521262
  521306
  524389
  525348
  526005
  526041
  527447
  528001
  529457
  530043
  531089
  531935
  535013
  541740
  542191
  547734
  549027
  550205
  556397
  563547
  565491
  565539
  565581
  565925
  566781
  569132
  570765
  571954
  576623
  576629
  576690
  578606
  579754
  585744
  586485
  587821
  590298
  590505
  591004
  593441
  596075
  596235
  598204
  598845
  599833
  600006
  600258
  600317
  601535
  602880
  604386
  605617
  605636
  606993
  607129
  610668
  612381
  616350
  620031
  621508
  624111
  632642
  633786
  636033
  637036
  637413
  638115
  639060
  640710
  641859
  643523
  646448
  648817
  649106
  651674
  665768
  727812
  763741
  792576
  804464
  807023
  810933
  810976
  811032
  813945
  814991
  815056
  815268
]
2.34 ms
(1.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom fetish"
]
1.79 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom фетиш"
]
1.74 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom фетиш"
]

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.