Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
159.69 ms
(83.85%)
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
  233608
  389829
  391588
  391941
  398522
  400489
  400493
  400494
  400513
  400988
  400994
  400998
  401005
  405252
  406629
  407903
  408214
  411036
  411704
  419653
  421810
  421837
  421838
  421840
  421847
  421878
  421880
  421899
  421936
  424862
  428108
  428143
  428814
  428884
  438487
  439704
  439776
  439802
  440644
  440687
  440826
  442933
  443105
  452234
  453701
  457468
  460336
  461034
  462268
  464343
  464538
  466719
  467062
  467469
  467540
  469389
  474835
  476260
  476347
  478374
  483637
  483643
  485386
  488747
  492447
  493170
  498422
  499778
  502030
  503169
  504386
  509637
  512067
  515956
  521220
  527418
  530437
  530530
  532624
  532813
  549737
  549739
  549828
  549844
  552080
  559513
  560899
  562178
  562423
  562531
  570841
  570883
  571501
  580048
  587167
  591942
  598877
  599509
  643031
  665492
  667365
  731800
  731802
  732213
  733587
  739576
  741907
  763139
  766236
  775151
  781812
  785330
  786666
  800478
  808069
  810030
  812408
  815358
  817498
  827665
]
15.14 ms
(7.95%)
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
  570883
  800478
  731800
  763139
  766236
  786666
  562531
  408214
  504386
  401005
  406629
  440644
  440687
  440826
  452234
  460336
  474835
  462268
  492447
  499778
  509637
  530437
  532624
  512067
  530530
  549844
  580048
  571501
  665492
  549737
  549739
  560899
  562423
  570841
  785330
  391588
  421840
  428884
  469389
  391941
  400998
  405252
  421899
  428143
  439802
  421847
  467469
  467540
  400994
  411036
  411704
  421936
  439704
  439776
  443105
  453701
  503169
  483637
  485386
  493170
  532813
  483643
  442933
  421878
  424862
  428108
  438487
  461034
  464343
  464538
  466719
  599509
  781812
  775151
  733587
  457468
  400493
  421838
  400489
  400513
  407903
  467062
  498422
  521220
  817498
  815358
  827665
  667365
  643031
  812408
  808069
  739576
  731802
  732213
  741907
  810030
  233608
  398522
  587167
  419653
  476347
  476260
  527418
  502030
  515956
  488747
  562178
  552080
  549828
  559513
  591942
  598877
  389829
  400988
  478374
  400494
  421810
  421837
  421880
  428814
]
6.55 ms
(3.44%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
4.06 ms
(2.13%)
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
  233608
  389829
  391588
  391941
  398522
  400489
  400493
  400494
  400513
  400988
  400994
  400998
  401005
  405252
  406629
  407903
  408214
  411036
  411704
  419653
  421810
  421837
  421838
  421840
  421847
  421878
  421880
  421899
  421936
  424862
  428108
  428143
  428814
  428884
  438487
  439704
  439776
  439802
  440644
  440687
  440826
  442933
  443105
  452234
  453701
  457468
  460336
  461034
  462268
  464343
  464538
  466719
  467062
  467469
  467540
  469389
  474835
  476260
  476347
  478374
  483637
  483643
  485386
  488747
  492447
  493170
  498422
  499778
  502030
  503169
  504386
  509637
  512067
  515956
  521220
  527418
  530437
  530530
  532624
  532813
  549737
  549739
  549828
  549844
  552080
  559513
  560899
  562178
  562423
  562531
  570841
  570883
  571501
  580048
  587167
  591942
  598877
  599509
  643031
  665492
  667365
  731800
  731802
  732213
  733587
  739576
  741907
  763139
  766236
  775151
  781812
  785330
  786666
  800478
  808069
  810030
  812408
  815358
  817498
  827665
]
1.83 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "рыжая пышка"
]
1.70 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рыжая полная"
]
1.48 ms
(0.78%)
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.