Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.84 ms
(85.68%)
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
  907
  285023
  394130
  405814
  413431
  424762
  483690
  501020
  510566
  512325
  516114
  527274
  538269
  553367
  561341
  584889
  588541
  589218
  598534
  599954
  607098
  609090
  609829
  626571
  629981
  631767
  635404
  636702
  640046
  649768
  656518
  661694
  662844
  671498
  688093
  689771
  696092
  700261
  704915
  706685
  708588
  708647
  709311
  711930
  718639
  718889
  719355
  720215
  720813
  722275
  725580
  726246
  728793
  730334
  731679
  733254
  734998
  735708
  735826
  744871
  746077
  748682
  748901
  750210
  750232
  751383
  752836
  753625
  753681
  753695
  755441
  756094
  756652
  761064
  761757
  762442
  763068
  767211
  768361
  768509
  769892
  770436
  773054
  773919
  773929
  775711
  776533
  776662
  777099
  778597
  779095
  779284
  779351
  779974
  783104
  783232
  788548
  789252
  789921
  789999
  792323
  802273
  802491
  803992
  806651
  807123
  807474
  810755
  813315
  813928
  814509
  814697
  815059
  816737
  817316
  819160
  821650
  826144
  826474
]
12.89 ms
(7.73%)
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
  753625
  753695
  755441
  756652
  762442
  768509
  773929
  750210
  750232
  751383
  772615
  773054
  609829
  635404
  640046
  706685
  708588
  718639
  777099
  778597
  779095
  779284
  792323
  810755
  813315
  285023
  907
  821650
  656518
  688093
  696092
  709311
  711930
  722275
  607098
  775711
  783104
  802491
  756094
  767211
  773919
  761064
  768361
  726246
  735708
  769892
  730334
  748901
  753681
  733254
  761757
  776662
  789252
  589218
  735826
  424762
  817316
  527274
  501020
  538269
  510566
  553367
  561341
  584889
  689771
  700261
  649768
  661694
  671498
  708647
  719355
  662844
  609090
  626571
  599954
  631767
  588541
  598534
  636702
  789921
  789999
  776533
  783232
  802273
  803992
  725580
  728793
  748682
  807474
  731679
  744871
  746077
  752836
  763068
  734998
  629981
  720215
  779351
  779974
  806651
  413431
  512325
  516114
  394130
  704915
  718889
  788548
  807123
  770436
  720813
  483690
  405814
  826474
  815059
  826144
  814509
  814697
  816737
  819160
  813928
]
3.74 ms
(2.24%)
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
  907
  285023
  394130
  405814
  413431
  424762
  483690
  501020
  510566
  512325
  516114
  527274
  538269
  553367
  561341
  584889
  588541
  589218
  598534
  599954
  607098
  609090
  609829
  626571
  629981
  631767
  635404
  636702
  640046
  649768
  656518
  661694
  662844
  671498
  688093
  689771
  696092
  700261
  704915
  706685
  708588
  708647
  709311
  711930
  718639
  718889
  719355
  720215
  720813
  722275
  725580
  726246
  728793
  730334
  731679
  733254
  734998
  735708
  735826
  744871
  746077
  748682
  748901
  750210
  750232
  751383
  752836
  753625
  753681
  753695
  755441
  756094
  756652
  761064
  761757
  762442
  763068
  767211
  768361
  768509
  769892
  770436
  773054
  773919
  773929
  775711
  776533
  776662
  777099
  778597
  779095
  779284
  779351
  779974
  783104
  783232
  788548
  789252
  789921
  789999
  792323
  802273
  802491
  803992
  806651
  807123
  807474
  810755
  813315
  813928
  814509
  814697
  815059
  816737
  817316
  819160
  821650
  826144
  826474
]
2.00 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "18 you"
]
1.93 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "18 you"
]
1.56 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "18 you"
]

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.