Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.06 ms
(84.46%)
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
  55910
  133943
  191610
  196306
  233215
  281801
  327421
  383191
  383747
  384422
  385373
  385477
  386596
  386756
  386767
  386828
  387682
  388361
  390125
  390388
  390738
  391225
  391428
  392169
  394487
  395225
  395557
  396279
  396380
  398154
  400967
  401245
  401322
  404522
  406629
  410057
  412702
  415148
  415577
  418039
  419063
  419248
  421127
  422308
  422734
  426457
  431558
  433920
  440655
  441647
  443031
  444937
  446043
  446340
  450438
  451815
  456224
  459002
  463884
  466263
  466945
  476058
  476148
  476468
  483450
  484285
  486879
  489342
  489627
  498358
  499004
  499825
  501048
  508508
  508530
  509726
  510107
  510118
  513379
  513692
  515306
  515843
  518733
  520040
  521382
  522081
  523182
  526789
  526834
  527177
  528726
  529569
  531532
  531541
  539662
  540343
  553629
  554256
  575882
  580138
  591593
  606843
  623126
  625242
  629201
  666912
  704357
  711357
  711884
  715128
  715696
  720073
  755030
  761124
  775790
  805707
  808214
  809376
  810653
  828112
]
14.93 ms
(9.85%)
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
  761124
  606843
  623126
  629201
  704357
  711357
  711884
  715696
  720073
  808214
  810653
  400967
  133943
  446340
  281801
  395557
  55910
  233215
  401245
  828112
  383747
  395225
  392169
  327421
  391428
  390388
  390738
  387682
  396380
  396279
  404522
  406629
  418039
  441647
  410057
  415148
  419248
  421127
  422734
  422308
  528726
  451815
  476058
  484285
  489342
  456224
  459002
  466945
  446043
  476148
  526834
  509726
  510107
  522081
  531541
  499004
  521382
  527177
  531532
  539662
  540343
  499825
  513692
  526789
  529569
  463884
  575882
  553629
  554256
  715128
  666912
  580138
  591593
  625242
  775790
  809376
  805707
  755030
  391225
  412702
  415577
  431558
  440655
  450438
  466263
  386596
  386767
  388361
  401322
  419063
  426457
  443031
  476468
  384422
  390125
  398154
  433920
  444937
  523182
  483450
  489627
  498358
  501048
  508508
  515843
  518733
  520040
  508530
  510118
  513379
  515306
  486879
  385477
  386756
  386828
  383191
  385373
  196306
  191610
  394487
]
2.52 ms
(1.66%)
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
  55910
  133943
  191610
  196306
  233215
  281801
  327421
  383191
  383747
  384422
  385373
  385477
  386596
  386756
  386767
  386828
  387682
  388361
  390125
  390388
  390738
  391225
  391428
  392169
  394487
  395225
  395557
  396279
  396380
  398154
  400967
  401245
  401322
  404522
  406629
  410057
  412702
  415148
  415577
  418039
  419063
  419248
  421127
  422308
  422734
  426457
  431558
  433920
  440655
  441647
  443031
  444937
  446043
  446340
  450438
  451815
  456224
  459002
  463884
  466263
  466945
  476058
  476148
  476468
  483450
  484285
  486879
  489342
  489627
  498358
  499004
  499825
  501048
  508508
  508530
  509726
  510107
  510118
  513379
  513692
  515306
  515843
  518733
  520040
  521382
  522081
  523182
  526789
  526834
  527177
  528726
  529569
  531532
  531541
  539662
  540343
  553629
  554256
  575882
  580138
  591593
  606843
  623126
  625242
  629201
  666912
  704357
  711357
  711884
  715128
  715696
  720073
  755030
  761124
  775790
  805707
  808214
  809376
  810653
  828112
]
1.64 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большой большие"
]
1.58 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большой большие"
]
1.45 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "для нее большой"
]
1.44 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.