Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
179.62 ms
(87.58%)
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
  6965
  143235
  183074
  191045
  379600
  382735
  388474
  391668
  391926
  394206
  395460
  397861
  400191
  400487
  401480
  404972
  411182
  411213
  412875
  413098
  419144
  420767
  421871
  422172
  424180
  424770
  427115
  428700
  434358
  439776
  440076
  441496
  443807
  444234
  445236
  445351
  445530
  448687
  449020
  449068
  451112
  452274
  452886
  454524
  454943
  455882
  457279
  459200
  463779
  467628
  467897
  467945
  468687
  469084
  469092
  469250
  470446
  472611
  472639
  476055
  477128
  478186
  478261
  478369
  482522
  483150
  483346
  484608
  490106
  500806
  503113
  504738
  509024
  514833
  515511
  515964
  519047
  519085
  526556
  530001
  533655
  544510
  558718
  562938
  563072
  571194
  576622
  582452
  584073
  590410
  597018
  604089
  605129
  669341
  693089
  693535
  705479
  710236
  711628
  715475
  727560
  733454
  754649
  756383
  765367
  769382
  777750
  781326
  782027
  792936
  799641
  799802
  801175
  807402
  817878
  818613
  819190
  819238
  822045
  822930
]
15.43 ms
(7.52%)
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
  530001
  451112
  454524
  412875
  443807
  822045
  693535
  819238
  571194
  605129
  515511
  472611
  400487
  404972
  445236
  584073
  463779
  413098
  582452
  483150
  419144
  422172
  469084
  452274
  469092
  449020
  469250
  590410
  427115
  454943
  391926
  183074
  445351
  769382
  400191
  388474
  817878
  756383
  476055
  391668
  395460
  401480
  468687
  478261
  467945
  482522
  777750
  727560
  382735
  394206
  470446
  490106
  576622
  562938
  379600
  439776
  519047
  484608
  519085
  801175
  6965
  428700
  424770
  526556
  533655
  754649
  421871
  799641
  669341
  445530
  467897
  478186
  509024
  503113
  705479
  765367
  807402
  143235
  411213
  715475
  478369
  799802
  455882
  693089
  604089
  444234
  441496
  467628
  782027
  452886
  472639
  792936
  424180
  477128
  434358
  500806
  514833
  397861
  819190
  457279
  822930
  558718
  710236
  711628
  781326
  733454
  191045
  420767
  504738
  448687
  440076
  459200
  411182
  818613
  597018
  449068
  515964
  483346
  544510
  563072
]
2.90 ms
(1.41%)
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
  6965
  143235
  183074
  191045
  379600
  382735
  388474
  391668
  391926
  394206
  395460
  397861
  400191
  400487
  401480
  404972
  411182
  411213
  412875
  413098
  419144
  420767
  421871
  422172
  424180
  424770
  427115
  428700
  434358
  439776
  440076
  441496
  443807
  444234
  445236
  445351
  445530
  448687
  449020
  449068
  451112
  452274
  452886
  454524
  454943
  455882
  457279
  459200
  463779
  467628
  467897
  467945
  468687
  469084
  469092
  469250
  470446
  472611
  472639
  476055
  477128
  478186
  478261
  478369
  482522
  483150
  483346
  484608
  490106
  500806
  503113
  504738
  509024
  514833
  515511
  515964
  519047
  519085
  526556
  530001
  533655
  544510
  558718
  562938
  563072
  571194
  576622
  582452
  584073
  590410
  597018
  604089
  605129
  669341
  693089
  693535
  705479
  710236
  711628
  715475
  727560
  733454
  754649
  756383
  765367
  769382
  777750
  781326
  782027
  792936
  799641
  799802
  801175
  807402
  817878
  818613
  819190
  819238
  822045
  822930
]
2.11 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "секс с мамой и с девушкой"
]
1.76 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс мам женщин девушк"
]
1.59 ms
(0.77%)
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.