Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.40 ms
(85.37%)
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
  384108
  391992
  415879
  416607
  416668
  416682
  416712
  419644
  423787
  424606
  432613
  432673
  439031
  441120
  443236
  443260
  444283
  444537
  448351
  448791
  449406
  451336
  452800
  455080
  459198
  466739
  467633
  467634
  468943
  469737
  470473
  470479
  471074
  476163
  476710
  477506
  477761
  479832
  483730
  485471
  487414
  500338
  507935
  512027
  512442
  514233
  518187
  518884
  522143
  524346
  531583
  531866
  534574
  541394
  541421
  546129
  547854
  550925
  552710
  557720
  560337
  561034
  564291
  567172
  581064
  597691
  604228
  607569
  609889
  622720
  625780
  629602
  632887
  641997
  642022
  655010
  662448
  669057
  670368
  672925
  672939
  680249
  683297
  688990
  696593
  703619
  722395
  724459
  735563
  739145
  748491
  749221
  749255
  752617
  752623
  752636
  752643
  752711
  757466
  764280
  766415
  766433
  766943
  770254
  772579
  776031
  778172
  782050
  796640
  796678
  796695
  801643
  807142
  808548
  809015
  809371
  811696
  816126
  824733
]
15.42 ms
(8.99%)
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
  807147
  808548
  749221
  766943
  748491
  764280
  770254
  752617
  622720
  801643
  809015
  604228
  816126
  541394
  811696
  642022
  432613
  424606
  439031
  416607
  416682
  432673
  470479
  471074
  485471
  487414
  448351
  512442
  518187
  467633
  476163
  567172
  561034
  672939
  722395
  669057
  670368
  680249
  683297
  597691
  641997
  796640
  766415
  739145
  752636
  423787
  468943
  416668
  451336
  470473
  518884
  415879
  443260
  444537
  452800
  455080
  448791
  469737
  483730
  534574
  500338
  662448
  449406
  724459
  524346
  531583
  531866
  522143
  541421
  564291
  547854
  550925
  672925
  703619
  655010
  546129
  552710
  632887
  629602
  607569
  776031
  778172
  796695
  807142
  766433
  772579
  752643
  752711
  752623
  757466
  749255
  609889
  796678
  809371
  824733
  479832
  384108
  441120
  443236
  416712
  444283
  467634
  507935
  514233
  557720
  391992
  477761
  459198
  688990
  560337
  466739
  477506
  625780
  782050
  735563
  419644
  476710
  512027
  581064
  696593
]
2.78 ms
(1.62%)
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
  384108
  391992
  415879
  416607
  416668
  416682
  416712
  419644
  423787
  424606
  432613
  432673
  439031
  441120
  443236
  443260
  444283
  444537
  448351
  448791
  449406
  451336
  452800
  455080
  459198
  466739
  467633
  467634
  468943
  469737
  470473
  470479
  471074
  476163
  476710
  477506
  477761
  479832
  483730
  485471
  487414
  500338
  507935
  512027
  512442
  514233
  518187
  518884
  522143
  524346
  531583
  531866
  534574
  541394
  541421
  546129
  547854
  550925
  552710
  557720
  560337
  561034
  564291
  567172
  581064
  597691
  604228
  607569
  609889
  622720
  625780
  629602
  632887
  641997
  642022
  655010
  662448
  669057
  670368
  672925
  672939
  680249
  683297
  688990
  696593
  703619
  722395
  724459
  735563
  739145
  748491
  749221
  749255
  752617
  752623
  752636
  752643
  752711
  757466
  764280
  766415
  766433
  766943
  770254
  772579
  776031
  778172
  782050
  796640
  796678
  796695
  801643
  807142
  808548
  809015
  809371
  811696
  816126
  824733
]
1.95 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "huge dildo homemade"
]
1.72 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "огромные дилд домашн любительск"
]
1.55 ms
(0.90%)
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.