Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.25 ms
(83.18%)
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
  24993
  247381
  266330
  395669
  401013
  408380
  443719
  462506
  465617
  545959
  568578
  581667
  589616
  598989
  601657
  612436
  614427
  614523
  615730
  617363
  618774
  618916
  619417
  620103
  620770
  621067
  621309
  621578
  622977
  623963
  624357
  624470
  625815
  626735
  633516
  634192
  644291
  649190
  650432
  655827
  663439
  666141
  681879
  682152
  683454
  684949
  685588
  685686
  692880
  694422
  696969
  697230
  698557
  699056
  699140
  702628
  704547
  708823
  709536
  710001
  711661
  712905
  712907
  715138
  716236
  716326
  716835
  717641
  718558
  718657
  721369
  721519
  725138
  726640
  726876
  728328
  728483
  732127
  733181
  737161
  737168
  737910
  741906
  746158
  748138
  748171
  752132
  752538
  753279
  756097
  759567
  760567
  762559
  765907
  766030
  766570
  766575
  767155
  770011
  774927
  775284
  775843
  775988
  776442
  776468
  778364
  780713
  781912
  784925
  788134
  790394
  791355
  800074
  802397
  802654
  804748
  808114
  808294
  808474
  811624
]
14.08 ms
(9.82%)
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
  682152
  683454
  685588
  685686
  692880
  694422
  696969
  697230
  698557
  699056
  709536
  710001
  712905
  716236
  716326
  716835
  649190
  650432
  655827
  663439
  666141
  681879
  684949
  702628
  704547
  708823
  711661
  712907
  718558
  718657
  721519
  545959
  568578
  581667
  615730
  617363
  623963
  633516
  644291
  598989
  618916
  621309
  621578
  622977
  624470
  589616
  601657
  619417
  620103
  620770
  626735
  612436
  614427
  618774
  775988
  776468
  778364
  780713
  791355
  802397
  808474
  774927
  781912
  788134
  790394
  804748
  811624
  733181
  737910
  748171
  752132
  759567
  767155
  784925
  800074
  808294
  732127
  741906
  748138
  766570
  766575
  770011
  726876
  728328
  762559
  728483
  737161
  752538
  725138
  726640
  737168
  746158
  753279
  756097
  760567
  765907
  766030
  614523
  621067
  624357
  625815
  634192
  699140
  715138
  717641
  721369
  775284
  775843
  776442
  802654
  808114
  401013
  408380
  443719
  247381
  462506
  465617
  24993
  266330
  395669
]
2.70 ms
(1.88%)
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
  24993
  247381
  266330
  395669
  401013
  408380
  443719
  462506
  465617
  545959
  568578
  581667
  589616
  598989
  601657
  612436
  614427
  614523
  615730
  617363
  618774
  618916
  619417
  620103
  620770
  621067
  621309
  621578
  622977
  623963
  624357
  624470
  625815
  626735
  633516
  634192
  644291
  649190
  650432
  655827
  663439
  666141
  681879
  682152
  683454
  684949
  685588
  685686
  692880
  694422
  696969
  697230
  698557
  699056
  699140
  702628
  704547
  708823
  709536
  710001
  711661
  712905
  712907
  715138
  716236
  716326
  716835
  717641
  718558
  718657
  721369
  721519
  725138
  726640
  726876
  728328
  728483
  732127
  733181
  737161
  737168
  737910
  741906
  746158
  748138
  748171
  752132
  752538
  753279
  756097
  759567
  760567
  762559
  765907
  766030
  766570
  766575
  767155
  770011
  774927
  775284
  775843
  775988
  776442
  776468
  778364
  780713
  781912
  784925
  788134
  790394
  791355
  800074
  802397
  802654
  804748
  808114
  808294
  808474
  811624
]
1.97 ms
(1.37%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.97 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big ass young"
]
1.73 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большая большие жоп young"
]
1.66 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большая большие жоп young"
]

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.