Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
195.88 ms
(88.66%)
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
  73727
  390275
  397900
  405903
  406044
  407421
  413195
  416821
  422292
  425601
  438337
  456575
  472212
  477480
  477855
  479284
  479918
  485005
  499815
  505983
  507058
  508131
  513804
  527018
  545394
  557857
  559602
  564046
  584681
  586228
  586329
  591489
  595021
  600372
  606089
  615411
  617044
  617099
  617738
  619187
  638404
  642234
  643327
  645736
  650658
  663935
  665884
  682495
  684503
  685391
  687186
  687928
  688129
  689299
  689394
  689808
  689953
  695415
  695474
  696049
  700924
  701469
  706479
  709150
  710101
  710165
  715167
  719917
  724399
  725156
  730693
  730707
  735530
  735934
  742192
  746715
  748468
  749896
  752122
  753950
  755133
  756063
  758395
  763996
  765518
  767504
  769366
  769820
  771709
  772947
  774090
  774877
  777192
  777320
  779143
  779362
  782506
  783417
  786819
  787252
  787827
  787886
  790463
  792707
  793095
  795207
  796369
  798279
  800121
  800420
  800528
  803445
  804377
  805358
  808295
  808855
  810762
  815540
  820189
  824457
]
14.94 ms
(6.76%)
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
  787886
  800528
  790463
  725156
  783417
  795207
  735530
  617099
  406044
  617738
  564046
  682495
  803445
  413195
  559602
  688129
  689808
  689953
  685391
  782506
  758395
  804377
  709150
  695415
  695474
  615411
  591489
  787252
  800420
  798279
  730707
  792707
  756063
  730693
  769366
  710165
  777192
  507058
  663935
  808855
  763996
  755133
  796369
  438337
  527018
  584681
  696049
  719917
  684503
  643327
  810762
  765518
  774090
  772947
  742192
  724399
  746715
  777320
  390275
  508131
  397900
  710101
  557857
  701469
  600372
  805358
  786819
  485005
  513804
  706479
  700924
  650658
  689299
  586329
  586228
  617044
  595021
  800121
  752122
  749896
  787827
  815540
  687186
  665884
  619187
  753950
  748468
  774877
  499815
  422292
  820189
  479918
  472212
  779143
  779362
  808295
  735934
  771709
  456575
  715167
  769820
  416821
  405903
  689394
  606089
  793095
  477855
  477480
  545394
  687928
  642234
  767504
  638404
  73727
  407421
  425601
  824457
  479284
  505983
  645736
]
2.76 ms
(1.25%)
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
  73727
  390275
  397900
  405903
  406044
  407421
  413195
  416821
  422292
  425601
  438337
  456575
  472212
  477480
  477855
  479284
  479918
  485005
  499815
  505983
  507058
  508131
  513804
  527018
  545394
  557857
  559602
  564046
  584681
  586228
  586329
  591489
  595021
  600372
  606089
  615411
  617044
  617099
  617738
  619187
  638404
  642234
  643327
  645736
  650658
  663935
  665884
  682495
  684503
  685391
  687186
  687928
  688129
  689299
  689394
  689808
  689953
  695415
  695474
  696049
  700924
  701469
  706479
  709150
  710101
  710165
  715167
  719917
  724399
  725156
  730693
  730707
  735530
  735934
  742192
  746715
  748468
  749896
  752122
  753950
  755133
  756063
  758395
  763996
  765518
  767504
  769366
  769820
  771709
  772947
  774090
  774877
  777192
  777320
  779143
  779362
  782506
  783417
  786819
  787252
  787827
  787886
  790463
  792707
  793095
  795207
  796369
  798279
  800121
  800420
  800528
  803445
  804377
  805358
  808295
  808855
  810762
  815540
  820189
  824457
]
2.03 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс table"
]
2.00 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex on table"
]
1.68 ms
(0.76%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс table"
]

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.