Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.38 ms
(88.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
  2808
  51972
  233500
  366284
  389749
  397388
  401575
  404178
  417293
  423527
  424146
  443436
  443950
  461974
  464775
  465428
  469696
  470101
  470107
  470637
  477970
  489728
  490479
  494835
  495308
  509246
  531553
  533580
  533779
  534117
  535604
  537971
  537983
  543533
  543540
  543670
  543714
  560005
  560339
  560433
  571432
  590970
  597978
  598028
  600119
  600142
  601565
  601986
  603834
  608188
  608945
  616682
  616771
  617654
  623155
  628804
  639156
  653371
  659212
  660283
  661512
  661534
  661909
  662147
  663842
  667186
  672809
  673170
  675876
  680676
  687426
  689161
  689217
  695788
  696330
  700476
  702283
  703948
  704673
  705111
  709511
  711716
  713768
  714615
  715628
  717654
  731197
  731659
  732171
  733644
  733695
  736675
  742405
  747429
  758182
  760382
  760520
  764176
  765877
  766162
  767972
  768163
  768491
  776121
  778206
  779255
  780218
  782307
  782678
  786094
  788381
  793063
  793195
  794073
  803232
  803233
  804863
  804904
]
10.48 ms
(5.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
  766162
  767972
  732171
  717654
  778206
  786094
  788381
  793063
  804904
  389749
  397388
  469696
  601565
  617654
  736675
  464775
  401575
  533779
  535604
  477970
  543714
  663842
  661534
  695788
  623155
  779255
  764176
  794073
  768491
  747429
  758182
  793195
  443436
  2808
  417293
  495308
  494835
  776121
  804863
  765877
  733695
  715628
  366284
  233500
  461974
  667186
  424146
  470637
  703948
  779905
  51972
  742405
  443950
  543533
  733644
  571432
  661909
  537971
  780218
  543540
  608945
  560433
  782307
  489728
  531553
  537983
  470101
  543670
  560339
  659212
  675876
  702283
  661512
  672809
  673170
  680676
  696330
  653371
  660283
  687426
  689161
  689217
  711716
  597978
  598028
  616771
  590970
  600142
  608188
  600119
  616682
  628804
  639156
  642091
  760520
  768163
  731197
  760382
  731659
  713768
  470107
  423527
  465428
  490479
  509246
  662147
  704673
  705111
  714615
  560005
  603834
  601986
  700476
  709511
  534117
  533580
  782678
  803232
  803233
  404178
]
2.66 ms
(1.51%)
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
  51972
  233500
  366284
  389749
  397388
  401575
  404178
  417293
  423527
  424146
  443436
  443950
  461974
  464775
  465428
  469696
  470101
  470107
  470637
  477970
  489728
  490479
  494835
  495308
  509246
  531553
  533580
  533779
  534117
  535604
  537971
  537983
  543533
  543540
  543670
  543714
  560005
  560339
  560433
  571432
  590970
  597978
  598028
  600119
  600142
  601565
  601986
  603834
  608188
  608945
  616682
  616771
  617654
  623155
  628804
  639156
  653371
  659212
  660283
  661512
  661534
  661909
  662147
  663842
  667186
  672809
  673170
  675876
  680676
  687426
  689161
  689217
  695788
  696330
  700476
  702283
  703948
  704673
  705111
  709511
  711716
  713768
  714615
  715628
  717654
  731197
  731659
  732171
  733644
  733695
  736675
  742405
  747429
  758182
  760382
  760520
  764176
  765877
  766162
  767972
  768163
  768491
  776121
  778206
  779255
  780218
  782307
  782678
  786094
  788381
  793063
  793195
  794073
  803232
  803233
  804863
  804904
]
1.98 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "домашние порно русски…"
]
1.59 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск порн русск"
]
1.40 ms
(0.79%)
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.