Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.14 ms
(86.31%)
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
  390929
  393742
  396887
  397473
  400672
  418484
  439142
  451595
  464280
  473955
  480420
  492649
  495158
  512762
  514470
  515158
  515193
  515290
  518933
  522695
  524312
  527536
  530809
  542976
  545357
  550602
  552599
  563961
  569427
  569674
  575636
  578498
  583696
  590328
  595538
  604417
  604467
  620333
  620801
  622303
  624238
  626543
  626755
  628851
  636405
  646343
  655062
  657434
  664794
  670074
  670762
  671819
  675514
  675742
  678763
  678897
  683524
  683536
  683774
  684187
  684211
  684224
  684238
  684943
  685562
  685612
  687187
  687461
  687796
  698657
  699009
  702087
  702461
  706321
  708955
  709703
  715326
  716468
  718627
  719129
  720328
  720376
  720505
  721223
  726284
  731098
  737417
  738274
  738320
  744316
  750352
  750638
  751500
  755100
  756090
  760466
  760481
  766858
  770061
  776028
  779014
  786491
  788963
  793588
  800119
  800761
  801281
  803181
  805591
  814490
  817410
  817630
  817701
  817702
  817713
  819550
  819605
  820086
  820205
  826942
]
11.77 ms
(7.75%)
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
  439142
  512762
  396887
  826942
  817701
  819550
  530809
  527536
  542976
  698657
  670074
  671819
  678897
  683524
  684224
  684238
  684943
  687796
  718627
  721223
  626543
  626755
  793588
  776028
  786491
  788963
  751500
  800761
  801281
  803181
  805591
  726284
  750638
  755100
  760466
  766858
  731098
  738274
  738320
  750352
  756090
  760481
  770061
  702461
  708955
  393742
  418484
  492649
  524312
  518933
  515193
  550602
  569427
  569674
  578498
  684211
  664794
  687461
  583696
  604467
  620801
  744316
  604417
  480420
  390929
  473955
  451595
  464280
  515290
  515158
  495158
  397473
  400672
  814490
  817410
  817713
  819605
  820205
  817630
  817702
  820086
  522695
  514470
  552599
  563961
  575636
  545357
  655062
  657434
  675514
  683536
  683774
  685612
  699009
  715326
  716468
  720376
  720505
  646343
  670762
  675742
  678763
  684187
  685562
  706321
  687187
  702087
  709703
  719129
  720328
  590328
  622303
  624238
  628851
  595538
  620333
  636405
  800119
  779014
  737417
]
2.24 ms
(1.48%)
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
  390929
  393742
  396887
  397473
  400672
  418484
  439142
  451595
  464280
  473955
  480420
  492649
  495158
  512762
  514470
  515158
  515193
  515290
  518933
  522695
  524312
  527536
  530809
  542976
  545357
  550602
  552599
  563961
  569427
  569674
  575636
  578498
  583696
  590328
  595538
  604417
  604467
  620333
  620801
  622303
  624238
  626543
  626755
  628851
  636405
  646343
  655062
  657434
  664794
  670074
  670762
  671819
  675514
  675742
  678763
  678897
  683524
  683536
  683774
  684187
  684211
  684224
  684238
  684943
  685562
  685612
  687187
  687461
  687796
  698657
  699009
  702087
  702461
  706321
  708955
  709703
  715326
  716468
  718627
  719129
  720328
  720376
  720505
  721223
  726284
  731098
  737417
  738274
  738320
  744316
  750352
  750638
  751500
  755100
  756090
  760466
  760481
  766858
  770061
  776028
  779014
  786491
  788963
  793588
  800119
  800761
  801281
  803181
  805591
  814490
  817410
  817630
  817701
  817702
  817713
  819550
  819605
  820086
  820205
  826942
]
1.96 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen and old"
]
1.77 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen old"
]
1.57 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen old"
]

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.