Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.09 ms
(85.80%)
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
  401811
  497055
  545813
  548499
  551118
  552590
  552906
  562451
  566570
  581980
  584042
  584475
  606767
  611193
  614033
  617602
  619443
  620431
  627554
  632763
  635608
  636400
  636930
  649245
  653174
  656622
  657227
  661908
  665307
  666686
  667473
  671242
  676617
  690198
  702332
  702995
  708086
  710996
  712183
  714965
  715002
  722920
  724021
  729723
  731133
  733316
  733933
  734202
  736254
  737277
  740022
  740730
  742070
  743973
  745616
  748458
  750507
  756716
  760690
  761511
  762596
  763570
  764456
  764520
  767771
  768237
  769935
  773407
  777980
  778009
  779265
  780237
  783055
  783354
  783699
  784024
  784339
  785918
  786677
  787745
  787923
  788648
  788742
  790325
  791651
  791822
  792227
  793946
  795258
  795601
  797297
  797490
  798984
  799482
  802985
  803536
  803809
  804749
  808893
  813392
  814414
  815223
  815242
  815452
  815749
  816020
  816246
  816542
  816554
  816695
  816925
  816932
  817951
  819667
  823243
  823274
  825277
  826998
]
11.89 ms
(7.84%)
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
  635608
  786677
  799482
  804749
  788648
  793946
  736254
  764520
  765378
  731133
  784339
  653174
  661908
  816246
  816542
  815749
  562451
  671242
  552906
  632763
  740022
  769935
  734202
  767771
  708086
  714965
  791822
  816925
  566570
  665307
  657227
  710996
  656622
  636930
  620431
  636400
  795258
  745616
  606767
  815223
  816020
  545813
  614033
  798984
  729723
  733933
  768237
  764456
  742070
  627554
  803809
  401811
  823243
  814414
  817951
  816554
  584042
  584475
  666686
  712183
  690198
  617602
  785918
  778009
  787923
  788742
  802985
  808893
  762596
  783354
  783699
  790325
  792227
  795601
  740730
  743973
  761511
  779265
  783055
  797297
  797490
  667473
  676617
  722920
  733316
  748458
  813392
  826998
  815452
  548499
  823274
  815242
  825277
  497055
  552590
  702995
  551118
  619443
  777980
  780237
  784024
  791651
  737277
  763570
  756716
  715002
  803536
  581980
  649245
  724021
  787745
  762326
  773407
  750507
  760690
  611193
  702332
  819667
  816695
  816932
]
2.91 ms
(1.92%)
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
  401811
  497055
  545813
  548499
  551118
  552590
  552906
  562451
  566570
  581980
  584042
  584475
  606767
  611193
  614033
  617602
  619443
  620431
  627554
  632763
  635608
  636400
  636930
  649245
  653174
  656622
  657227
  661908
  665307
  666686
  667473
  671242
  676617
  690198
  702332
  702995
  708086
  710996
  712183
  714965
  715002
  722920
  724021
  729723
  731133
  733316
  733933
  734202
  736254
  737277
  740022
  740730
  742070
  743973
  745616
  748458
  750507
  756716
  760690
  761511
  762596
  763570
  764456
  764520
  767771
  768237
  769935
  773407
  777980
  778009
  779265
  780237
  783055
  783354
  783699
  784024
  784339
  785918
  786677
  787745
  787923
  788648
  788742
  790325
  791651
  791822
  792227
  793946
  795258
  795601
  797297
  797490
  798984
  799482
  802985
  803536
  803809
  804749
  808893
  813392
  814414
  815223
  815242
  815452
  815749
  816020
  816246
  816542
  816554
  816695
  816925
  816932
  817951
  819667
  823243
  823274
  825277
  826998
]
1.91 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "on work sex"
]
1.85 ms
(1.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "work секс"
]
1.41 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "work секс"
]

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.