Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.86 ms
(85.90%)
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
  70150
  147173
  383325
  396829
  407637
  417034
  419258
  419275
  422483
  424739
  425479
  426134
  428269
  428446
  428517
  435351
  437260
  442039
  442257
  443344
  444007
  444986
  445989
  446898
  448227
  449478
  449490
  451271
  452558
  457656
  463219
  464508
  465015
  465026
  466531
  468625
  469185
  470573
  471587
  471929
  472334
  474355
  477925
  478295
  479595
  480094
  484061
  484594
  485671
  486094
  486979
  487037
  488000
  488493
  488512
  489785
  496416
  497544
  497808
  500076
  508999
  509954
  511749
  512644
  513321
  513516
  514256
  516599
  521711
  522229
  526150
  528280
  529309
  531072
  536872
  539907
  548753
  551604
  553239
  553714
  560807
  563396
  567096
  568231
  570862
  570864
  573791
  576289
  585701
  597136
  605213
  618797
  619929
  626112
  654514
  655751
  656465
  657287
  658583
  663386
  666769
  673547
  687506
  701255
  738268
  761843
  767619
  768074
  774350
  777548
  778039
  781032
  783729
  789203
  792404
  795132
  800042
  806356
  808859
  813318
]
14.02 ms
(7.77%)
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
  435351
  428517
  446898
  451271
  488493
  469185
  485671
  663386
  806356
  383325
  424739
  500076
  522229
  487037
  147173
  417034
  444986
  449490
  465026
  465015
  529309
  489785
  687506
  701255
  795132
  792404
  800042
  808859
  466531
  496416
  513516
  516599
  477925
  666769
  789203
  425479
  444007
  442039
  422483
  464508
  478295
  470573
  457656
  497808
  539907
  570862
  551604
  573791
  553239
  597136
  605213
  774350
  445989
  472334
  479595
  396829
  448227
  419258
  426134
  443344
  468625
  508999
  488000
  488512
  484061
  509954
  521711
  428446
  463219
  513321
  560807
  576289
  626112
  761843
  767619
  70150
  480094
  471929
  437260
  528280
  656465
  442257
  618797
  428269
  486094
  585701
  511749
  531072
  419275
  514256
  781032
  778039
  768074
  449478
  512644
  548753
  536872
  497544
  407637
  484594
  673547
  486979
  563396
  657287
  526150
  568231
  655751
  654514
  658583
  619929
  813318
  783729
  738268
  777548
  452558
  570864
  553714
  567096
  471587
  474355
]
3.40 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
  70150
  147173
  383325
  396829
  407637
  417034
  419258
  419275
  422483
  424739
  425479
  426134
  428269
  428446
  428517
  435351
  437260
  442039
  442257
  443344
  444007
  444986
  445989
  446898
  448227
  449478
  449490
  451271
  452558
  457656
  463219
  464508
  465015
  465026
  466531
  468625
  469185
  470573
  471587
  471929
  472334
  474355
  477925
  478295
  479595
  480094
  484061
  484594
  485671
  486094
  486979
  487037
  488000
  488493
  488512
  489785
  496416
  497544
  497808
  500076
  508999
  509954
  511749
  512644
  513321
  513516
  514256
  516599
  521711
  522229
  526150
  528280
  529309
  531072
  536872
  539907
  548753
  551604
  553239
  553714
  560807
  563396
  567096
  568231
  570862
  570864
  573791
  576289
  585701
  597136
  605213
  618797
  619929
  626112
  654514
  655751
  656465
  657287
  658583
  663386
  666769
  673547
  687506
  701255
  738268
  761843
  767619
  768074
  774350
  777548
  778039
  781032
  783729
  789203
  792404
  795132
  800042
  806356
  808859
  813318
]
2.45 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ð┤ðÁð▓ÐâÐêð║ð░ ð┤ÐÇð¥Ðçð©Ðé ð┐ð░ÐÇð¢ÐÅð%ÔǪ"
]
2.00 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.97 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк дрочк парен"
]
1.61 ms
(0.89%)
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.