Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.26 ms
(84.96%)
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
  2808
  233498
  233500
  366284
  389749
  391966
  392077
  397388
  401575
  417293
  424099
  424146
  426707
  443436
  443889
  443898
  443950
  444236
  448412
  451517
  461974
  464775
  469696
  470637
  477970
  479422
  485862
  487246
  495308
  498171
  506486
  513811
  533779
  534046
  534084
  534393
  535604
  538239
  543533
  543655
  543682
  543714
  543734
  547983
  549610
  552816
  561250
  563599
  565003
  567240
  571460
  575667
  576244
  578348
  590452
  600098
  601606
  608108
  608529
  608814
  612574
  617654
  637454
  644014
  661534
  661554
  667186
  672881
  683305
  685381
  687940
  695788
  701888
  702277
  703948
  711149
  712948
  717654
  729345
  731652
  731669
  732131
  732171
  733644
  736675
  740632
  742405
  743634
  747429
  749769
  758182
  761607
  764173
  764176
  765877
  766162
  767972
  769136
  769196
  774653
  776121
  779255
  783658
  786094
  788032
  788381
  793063
  793195
  794073
  794128
  802893
  803231
  803235
  804863
  804888
  804904
  809645
  809958
]
15.44 ms
(9.03%)
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
  543734
  547983
  571460
  576244
  578348
  672881
  683305
  685381
  701888
  561250
  567240
  644014
  600098
  608108
  608529
  601606
  590452
  608814
  637454
  731652
  809645
  761607
  764173
  443889
  534084
  444236
  498171
  565003
  575667
  563599
  702277
  711149
  687940
  612574
  794128
  391966
  233498
  803231
  803235
  552816
  424099
  451517
  448412
  485862
  729345
  732131
  534393
  443898
  487246
  774653
  788032
  479422
  743634
  513811
  543655
  661554
  694097
  712948
  506486
  749769
  426707
  392077
  534046
  538239
  549610
  543682
  783658
  731669
  769136
  769196
  802893
  804888
  809958
  740632
  766162
  767972
  732171
  717654
  786094
  788381
  793063
  804904
  389749
  397388
  469696
  617654
  736675
  401575
  464775
  533779
  535604
  477970
  543714
  661534
  695788
  779255
  764176
  794073
  747429
  758182
  793195
  443436
  2808
  417293
  495308
  776121
  804863
  765877
  366284
  233500
  461974
  667186
  424146
  470637
  703948
  779905
  742405
  443950
  543533
  733644
]
3.21 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
  2808
  233498
  233500
  366284
  389749
  391966
  392077
  397388
  401575
  417293
  424099
  424146
  426707
  443436
  443889
  443898
  443950
  444236
  448412
  451517
  461974
  464775
  469696
  470637
  477970
  479422
  485862
  487246
  495308
  498171
  506486
  513811
  533779
  534046
  534084
  534393
  535604
  538239
  543533
  543655
  543682
  543714
  543734
  547983
  549610
  552816
  561250
  563599
  565003
  567240
  571460
  575667
  576244
  578348
  590452
  600098
  601606
  608108
  608529
  608814
  612574
  617654
  637454
  644014
  661534
  661554
  667186
  672881
  683305
  685381
  687940
  695788
  701888
  702277
  703948
  711149
  712948
  717654
  729345
  731652
  731669
  732131
  732171
  733644
  736675
  740632
  742405
  743634
  747429
  749769
  758182
  761607
  764173
  764176
  765877
  766162
  767972
  769136
  769196
  774653
  776121
  779255
  783658
  786094
  788032
  788381
  793063
  793195
  794073
  794128
  802893
  803231
  803235
  804863
  804888
  804904
  809645
  809958
]
2.03 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.02 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "русское домашнее с же%…"
]
1.54 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск домашн любительск"
]
1.48 ms
(0.86%)
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.