Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.12 ms
(81.68%)
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
  122488
  387347
  396441
  401592
  431515
  432478
  432525
  433024
  433051
  433366
  433429
  435701
  437403
  459068
  460541
  490732
  516413
  530606
  531388
  531526
  538060
  542777
  544073
  554046
  561571
  565227
  570853
  584083
  588347
  592682
  593736
  594238
  595841
  596234
  599798
  608105
  610094
  625086
  630093
  634934
  661507
  664206
  664658
  677994
  695076
  697392
  697893
  698224
  710309
  710900
  714450
  719967
  719972
  724692
  730499
  730693
  731050
  731126
  731256
  733491
  734013
  737613
  739086
  739646
  741665
  745318
  745336
  748443
  751242
  751476
  753676
  755057
  761316
  766400
  767737
  768208
  769176
  774917
  780211
  780244
  781344
  783636
  786994
  787066
  787485
  789160
  792459
  792473
  792495
  792926
  793165
  794299
  794564
  796322
  796741
  796852
  800081
  800482
  800639
  801439
  810503
  813641
  818855
  818922
  819281
  820013
  824137
  824570
  825083
  825881
  826732
  826932
  827013
  827064
  828337
  828455
  828541
  828664
  828677
  828787
]
24.59 ms
(12.70%)
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
  734013
  751476
  761316
  396441
  387347
  774917
  733491
  745318
  435701
  431515
  813641
  588347
  787066
  433429
  122488
  827013
  819281
  828787
  828677
  584083
  800482
  787485
  731126
  794564
  741665
  730499
  767737
  737613
  745336
  792473
  792926
  530606
  538060
  542777
  561571
  570853
  544073
  554046
  565227
  664658
  661507
  710900
  664206
  677994
  697392
  697893
  719972
  592682
  593736
  595841
  608105
  599798
  780244
  794299
  789160
  800081
  731050
  751242
  753676
  769176
  739086
  739646
  755057
  768208
  634934
  714450
  719967
  796852
  433366
  432478
  490732
  698224
  594238
  748443
  433051
  437403
  432525
  433024
  610094
  401592
  460541
  625086
  731256
  796741
  766400
  724692
  730693
  516413
  596234
  459068
  818855
  825881
  826732
  820013
  826932
  827064
  818922
  824137
  824570
  828337
  825083
  828455
  828541
  828664
  531526
  531388
  695076
  710309
  630093
  780211
  792459
  792495
  793165
  796322
  800639
  801439
  810503
  781344
  783636
  786994
]
2.41 ms
(1.24%)
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
  122488
  387347
  396441
  401592
  431515
  432478
  432525
  433024
  433051
  433366
  433429
  435701
  437403
  459068
  460541
  490732
  516413
  530606
  531388
  531526
  538060
  542777
  544073
  554046
  561571
  565227
  570853
  584083
  588347
  592682
  593736
  594238
  595841
  596234
  599798
  608105
  610094
  625086
  630093
  634934
  661507
  664206
  664658
  677994
  695076
  697392
  697893
  698224
  710309
  710900
  714450
  719967
  719972
  724692
  730499
  730693
  731050
  731126
  731256
  733491
  734013
  737613
  739086
  739646
  741665
  745318
  745336
  748443
  751242
  751476
  753676
  755057
  761316
  766400
  767737
  768208
  769176
  774917
  780211
  780244
  781344
  783636
  786994
  787066
  787485
  789160
  792459
  792473
  792495
  792926
  793165
  794299
  794564
  796322
  796741
  796852
  800081
  800482
  800639
  801439
  810503
  813641
  818855
  818922
  819281
  820013
  824137
  824570
  825083
  825881
  826732
  826932
  827013
  827064
  828337
  828455
  828541
  828664
  828677
  828787
]
2.19 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен дрочк"
]
2.17 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "соседка дрочит"
]
2.11 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен дрочк"
]
2.00 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.