Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
170.85 ms
(87.25%)
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
  4229
  175985
  387379
  388523
  390954
  391884
  393188
  398972
  401427
  417601
  418621
  419354
  421639
  423593
  424072
  424337
  425248
  426771
  427267
  436450
  438621
  441301
  441742
  443178
  446419
  448573
  449076
  449469
  449490
  449668
  450061
  450852
  451334
  452349
  452356
  453917
  454570
  455184
  455887
  455949
  456310
  457925
  458083
  458190
  458819
  464068
  465068
  465232
  466393
  468249
  469068
  469833
  470033
  470564
  471052
  471471
  471987
  472314
  474768
  475297
  477129
  478148
  482573
  487871
  488260
  488693
  489765
  491109
  492091
  492426
  492640
  493813
  493823
  497596
  498378
  500877
  502999
  503738
  506306
  510942
  513835
  514239
  515976
  516159
  516458
  517317
  526169
  538781
  548477
  550041
  550045
  550891
  554852
  560337
  562708
  564100
  564652
  568178
  568213
  585067
  600213
  620267
  629407
  631067
  631649
  646656
  686410
  692459
  728993
  744354
  757225
  758231
  763444
  771939
  793115
  793480
  804094
  824056
  828436
]
14.11 ms
(7.21%)
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
  418621
  419354
  441301
  417601
  421639
  424337
  425248
  585067
  482573
  449076
  449469
  449490
  450061
  452349
  468249
  488693
  492426
  446419
  452356
  457925
  471987
  450852
  455887
  455949
  456310
  477129
  487871
  489765
  500877
  516458
  506306
  526169
  538781
  502999
  513835
  469068
  471471
  488260
  493823
  560337
  568213
  548477
  550891
  554852
  646656
  550041
  550045
  564652
  620267
  631649
  600213
  793115
  763444
  771939
  757225
  629407
  448573
  453917
  458190
  387379
  401427
  464068
  175985
  388523
  390954
  436450
  451334
  465232
  471052
  424072
  426771
  427267
  438621
  449668
  454570
  441742
  466393
  470033
  516159
  497596
  498378
  491109
  510942
  517317
  492091
  514239
  515976
  568178
  692459
  793480
  744354
  728993
  631067
  804094
  686410
  4229
  824056
  826360
  828436
  455184
  469833
  470564
  391884
  474768
  493813
  458083
  475297
  503738
  564100
  562708
  758231
  393188
  398972
  423593
  465068
  472314
  443178
  458819
  478148
  492640
]
3.66 ms
(1.87%)
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
  4229
  175985
  387379
  388523
  390954
  391884
  393188
  398972
  401427
  417601
  418621
  419354
  421639
  423593
  424072
  424337
  425248
  426771
  427267
  436450
  438621
  441301
  441742
  443178
  446419
  448573
  449076
  449469
  449490
  449668
  450061
  450852
  451334
  452349
  452356
  453917
  454570
  455184
  455887
  455949
  456310
  457925
  458083
  458190
  458819
  464068
  465068
  465232
  466393
  468249
  469068
  469833
  470033
  470564
  471052
  471471
  471987
  472314
  474768
  475297
  477129
  478148
  482573
  487871
  488260
  488693
  489765
  491109
  492091
  492426
  492640
  493813
  493823
  497596
  498378
  500877
  502999
  503738
  506306
  510942
  513835
  514239
  515976
  516159
  516458
  517317
  526169
  538781
  548477
  550041
  550045
  550891
  554852
  560337
  562708
  564100
  564652
  568178
  568213
  585067
  600213
  620267
  629407
  631067
  631649
  646656
  686410
  692459
  728993
  744354
  757225
  758231
  763444
  771939
  793115
  793480
  804094
  824056
  828436
]
2.10 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam wife"
]
1.95 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вебкамер жен"
]
1.67 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(0.76%)
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.