Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.21 ms
(83.62%)
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
  25788
  111756
  318700
  385385
  394152
  401657
  401796
  415635
  419640
  422264
  422286
  433419
  433531
  436463
  437385
  439761
  440828
  442410
  443518
  443771
  444139
  445920
  452651
  453489
  460010
  463152
  464486
  464928
  467851
  472119
  476961
  488130
  495808
  496593
  509251
  509290
  510567
  511101
  511599
  516274
  522331
  522450
  522961
  527973
  528208
  545881
  546137
  547048
  548408
  557247
  585964
  591118
  591741
  625150
  636892
  644813
  658431
  661507
  664286
  664305
  664368
  664813
  665442
  665455
  666159
  666778
  667636
  668886
  669768
  702400
  709878
  724793
  725459
  726604
  731018
  731050
  731122
  731151
  731153
  731229
  735882
  736010
  740112
  741768
  742765
  744101
  744414
  744435
  744709
  746147
  746691
  749604
  749616
  755057
  758157
  775140
  776448
  781826
  781885
  781892
  789160
  800741
  801500
  807016
  807757
  807991
  812370
  817548
  823959
  825326
  825395
  825424
  825972
  826168
  826203
  826481
  826757
  826819
  827098
  828811
]
14.73 ms
(9.53%)
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
  522450
  664286
  665455
  669768
  664813
  664368
  666778
  625150
  591741
  775140
  781885
  781892
  807757
  731018
  731229
  807991
  437385
  453489
  433419
  415635
  440828
  445920
  522331
  826481
  826757
  817548
  825972
  488130
  546137
  740112
  744414
  746147
  746691
  726604
  731153
  735882
  742765
  749604
  758157
  801500
  812370
  826819
  825424
  828811
  496593
  439761
  444139
  509290
  528208
  318700
  452651
  464486
  433531
  463152
  472119
  511101
  591118
  25788
  827098
  825395
  547048
  401796
  548408
  661507
  709878
  789160
  731050
  755057
  545881
  111756
  658431
  800741
  807016
  725459
  744435
  731151
  736010
  741768
  731122
  702400
  385385
  823959
  826203
  826168
  825326
  557247
  636892
  724793
  744709
  443771
  443518
  436463
  422286
  442410
  644813
  476961
  460010
  664305
  665442
  667636
  668886
  666159
  585964
  781826
  776448
  394152
  419640
  464928
  467851
  401657
  422264
  509251
  522961
  495808
  510567
  511599
  527973
  516274
  749616
  744101
]
3.01 ms
(1.95%)
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
  25788
  111756
  318700
  385385
  394152
  401657
  401796
  415635
  419640
  422264
  422286
  433419
  433531
  436463
  437385
  439761
  440828
  442410
  443518
  443771
  444139
  445920
  452651
  453489
  460010
  463152
  464486
  464928
  467851
  472119
  476961
  488130
  495808
  496593
  509251
  509290
  510567
  511101
  511599
  516274
  522331
  522450
  522961
  527973
  528208
  545881
  546137
  547048
  548408
  557247
  585964
  591118
  591741
  625150
  636892
  644813
  658431
  661507
  664286
  664305
  664368
  664813
  665442
  665455
  666159
  666778
  667636
  668886
  669768
  702400
  709878
  724793
  725459
  726604
  731018
  731050
  731122
  731151
  731153
  731229
  735882
  736010
  740112
  741768
  742765
  744101
  744414
  744435
  744709
  746147
  746691
  749604
  749616
  755057
  758157
  775140
  776448
  781826
  781885
  781892
  789160
  800741
  801500
  807016
  807757
  807991
  812370
  817548
  823959
  825326
  825395
  825424
  825972
  826168
  826203
  826481
  826757
  826819
  827098
  828811
]
2.05 ms
(1.33%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.94 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "пышка дрочит"
]
1.89 ms
(1.23%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "полная дрочк"
]
1.68 ms
(1.08%)
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.