Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
193.15 ms
(86.01%)
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
  389208
  391386
  393315
  398041
  410959
  414341
  417482
  419740
  419882
  421093
  422049
  423563
  424660
  424675
  430436
  430709
  432787
  437855
  443745
  443796
  444238
  445396
  445737
  446275
  448333
  450386
  452061
  452084
  454802
  454954
  460731
  466097
  466103
  466107
  466111
  466118
  466733
  467043
  467602
  468655
  471357
  473912
  474680
  474827
  476107
  476399
  481688
  483544
  484459
  484472
  484690
  487729
  491446
  492916
  494557
  495608
  495866
  496118
  501242
  504481
  510198
  511816
  512355
  514820
  517842
  524895
  524896
  525393
  531186
  531235
  533802
  534845
  541408
  541592
  541606
  541623
  541698
  541884
  543852
  545305
  546993
  552010
  560190
  566252
  576691
  576711
  577368
  580262
  581902
  586524
  587098
  590362
  605612
  606482
  622979
  630526
  631163
  631972
  639292
  639824
  642063
  644914
  646786
  650127
  651599
  662137
  666901
  666902
  666904
  668549
  671746
  674368
  679826
  685791
  713564
  756395
  804464
  807023
  814934
  815017
]
20.26 ms
(9.02%)
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
  419882
  460731
  466118
  511816
  512355
  495866
  517842
  541606
  484472
  494557
  496118
  484459
  484690
  487729
  495608
  393315
  452084
  410959
  422049
  424675
  414341
  423563
  437855
  814934
  644914
  815017
  473912
  476107
  476399
  483544
  446275
  468655
  467043
  531186
  524895
  531235
  533802
  541884
  543852
  576691
  541408
  552010
  580262
  541592
  546993
  666904
  668549
  674368
  651599
  666901
  679826
  685791
  646786
  650127
  671746
  713564
  576711
  590362
  622979
  631972
  586524
  605612
  587098
  630526
  631163
  804464
  807023
  389208
  430436
  443796
  481688
  445396
  466107
  466111
  424660
  430709
  444238
  448333
  417482
  443745
  466103
  474680
  491446
  541623
  391386
  419740
  450386
  454954
  466733
  467602
  492916
  454802
  510198
  514820
  504481
  501242
  525393
  534845
  541698
  545305
  577368
  581902
  566252
  662137
  666902
  560190
  642063
  639824
  606482
  756395
  639292
  432787
  471357
  398041
  445737
  452061
  421093
  466097
  474827
  524896
]
3.14 ms
(1.40%)
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
  389208
  391386
  393315
  398041
  410959
  414341
  417482
  419740
  419882
  421093
  422049
  423563
  424660
  424675
  430436
  430709
  432787
  437855
  443745
  443796
  444238
  445396
  445737
  446275
  448333
  450386
  452061
  452084
  454802
  454954
  460731
  466097
  466103
  466107
  466111
  466118
  466733
  467043
  467602
  468655
  471357
  473912
  474680
  474827
  476107
  476399
  481688
  483544
  484459
  484472
  484690
  487729
  491446
  492916
  494557
  495608
  495866
  496118
  501242
  504481
  510198
  511816
  512355
  514820
  517842
  524895
  524896
  525393
  531186
  531235
  533802
  534845
  541408
  541592
  541606
  541623
  541698
  541884
  543852
  545305
  546993
  552010
  560190
  566252
  576691
  576711
  577368
  580262
  581902
  586524
  587098
  590362
  605612
  606482
  622979
  630526
  631163
  631972
  639292
  639824
  642063
  644914
  646786
  650127
  651599
  662137
  666901
  666902
  666904
  668549
  671746
  674368
  679826
  685791
  713564
  756395
  804464
  807023
  814934
  815017
]
2.44 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy group"
]
2.08 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая group"
]
1.77 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "волосатая group"
]
1.71 ms
(0.76%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.