Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.34 ms
(85.21%)
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
  4375
  48547
  68421
  79567
  97765
  234736
  389708
  390838
  391490
  391773
  395993
  398121
  401614
  403984
  429707
  435581
  441068
  444197
  457935
  475611
  480593
  487570
  500094
  504175
  521036
  530462
  531739
  535725
  542886
  544053
  547087
  548155
  551734
  558610
  560555
  562691
  566997
  582529
  583528
  584026
  585523
  586711
  589199
  591063
  595229
  596286
  600158
  608273
  610741
  614281
  614498
  617145
  623951
  626096
  626804
  644613
  653336
  653479
  659168
  664498
  671419
  675630
  679242
  681748
  689684
  693011
  696753
  699194
  700039
  700357
  701000
  701613
  706545
  717801
  719302
  723196
  737177
  738256
  740520
  743745
  750392
  750623
  751088
  753053
  754994
  755006
  758449
  762240
  763956
  764246
  766301
  766420
  772605
  778734
  779595
  782998
  783131
  786405
  786589
  786851
  787334
  787679
  789477
  789803
  790293
  790511
  791764
  791913
  791961
  792288
  792672
  798898
  803161
  803638
  804857
  807048
  808562
  810799
  814241
]
13.59 ms
(8.25%)
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
  535725
  480593
  487570
  679242
  706545
  585523
  614498
  644613
  530462
  671419
  719302
  562691
  626096
  755006
  772605
  403984
  4375
  738256
  758449
  547087
  551734
  566997
  789477
  521036
  542886
  701613
  689684
  596286
  600158
  608273
  753053
  737177
  457935
  531739
  803638
  763956
  772628
  584026
  79567
  435581
  814241
  475611
  786589
  790293
  807048
  786405
  766420
  750392
  390838
  398121
  582529
  664498
  791913
  791961
  808562
  787334
  790511
  750623
  751088
  700357
  779595
  444197
  391773
  681748
  500094
  544053
  548155
  659168
  675630
  653336
  653479
  693011
  700039
  583528
  589199
  617145
  623951
  591063
  595229
  586711
  791764
  786851
  614281
  699194
  97765
  504175
  610741
  626804
  558610
  696753
  401614
  389708
  68421
  783131
  792288
  395993
  792672
  740520
  804857
  762240
  766301
  754994
  717801
  723196
  782998
  787679
  803161
  48547
  429707
  560555
  789803
  743745
  778734
  798898
  810799
  234736
  391490
  764246
  701000
  441068
]
3.06 ms
(1.86%)
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
  4375
  48547
  68421
  79567
  97765
  234736
  389708
  390838
  391490
  391773
  395993
  398121
  401614
  403984
  429707
  435581
  441068
  444197
  457935
  475611
  480593
  487570
  500094
  504175
  521036
  530462
  531739
  535725
  542886
  544053
  547087
  548155
  551734
  558610
  560555
  562691
  566997
  582529
  583528
  584026
  585523
  586711
  589199
  591063
  595229
  596286
  600158
  608273
  610741
  614281
  614498
  617145
  623951
  626096
  626804
  644613
  653336
  653479
  659168
  664498
  671419
  675630
  679242
  681748
  689684
  693011
  696753
  699194
  700039
  700357
  701000
  701613
  706545
  717801
  719302
  723196
  737177
  738256
  740520
  743745
  750392
  750623
  751088
  753053
  754994
  755006
  758449
  762240
  763956
  764246
  766301
  766420
  772605
  778734
  779595
  782998
  783131
  786405
  786589
  786851
  787334
  787679
  789477
  789803
  790293
  790511
  791764
  791913
  791961
  792288
  792672
  798898
  803161
  803638
  804857
  807048
  808562
  810799
  814241
]
2.03 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "брюнетка дома частное…"
]
1.99 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "черноволосая домашн любительск любительск"
]
1.95 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(1.06%)
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.