Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.59 ms
(87.48%)
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
  391677
  398907
  399986
  400263
  402164
  418665
  429232
  429257
  455917
  457618
  467800
  489155
  490698
  492016
  495599
  500444
  510100
  512647
  533763
  534111
  536217
  536825
  538798
  545167
  547103
  552159
  552210
  554121
  557005
  560984
  569361
  574233
  577813
  582648
  591393
  592141
  594014
  594063
  594072
  597259
  599028
  600439
  603617
  603955
  610504
  616573
  618187
  627141
  628843
  628948
  636486
  649862
  654881
  655184
  657536
  657860
  674600
  679296
  679304
  684812
  690530
  697462
  700052
  701526
  702375
  702382
  707774
  711273
  713684
  714080
  719045
  721771
  723373
  723935
  725141
  732775
  734907
  736022
  736258
  736980
  738618
  739318
  740166
  740597
  743455
  745804
  748416
  748632
  748798
  754205
  755689
  755854
  758540
  758560
  762483
  762855
  763435
  767381
  773533
  774794
  775127
  782387
  785175
  785718
  785728
  787936
  787937
  788282
  788720
  796789
  800284
  804862
  805346
  807886
  809857
  812908
  812955
  814419
  817626
  827347
]
11.95 ms
(6.72%)
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
  723373
  545167
  560984
  592141
  599028
  628948
  597259
  603955
  594014
  600439
  610504
  591393
  594072
  636486
  788720
  804862
  805346
  725141
  736022
  736980
  755854
  758540
  758560
  763435
  785175
  723935
  732775
  743455
  745804
  748632
  754205
  755689
  740597
  762855
  739318
  748416
  719045
  774794
  775127
  785718
  812955
  399986
  429257
  400263
  455917
  457618
  391677
  467800
  512647
  490698
  495599
  510100
  398907
  402164
  827347
  817626
  538798
  574233
  582648
  552210
  557005
  655184
  679304
  684812
  690530
  700052
  702382
  707774
  657860
  679296
  697462
  701526
  711273
  654881
  657536
  713684
  547103
  569361
  577813
  628843
  616573
  603617
  594063
  785728
  800284
  807886
  809857
  767381
  787937
  788282
  796789
  736258
  734907
  738618
  748798
  762483
  740166
  773533
  618187
  627141
  702375
  721771
  782387
  787936
  812908
  418665
  429232
  814419
  489155
  492016
  536217
  534111
  536825
  533763
  500444
  552159
  554121
  649862
  674600
  714080
]
2.66 ms
(1.49%)
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
  391677
  398907
  399986
  400263
  402164
  418665
  429232
  429257
  455917
  457618
  467800
  489155
  490698
  492016
  495599
  500444
  510100
  512647
  533763
  534111
  536217
  536825
  538798
  545167
  547103
  552159
  552210
  554121
  557005
  560984
  569361
  574233
  577813
  582648
  591393
  592141
  594014
  594063
  594072
  597259
  599028
  600439
  603617
  603955
  610504
  616573
  618187
  627141
  628843
  628948
  636486
  649862
  654881
  655184
  657536
  657860
  674600
  679296
  679304
  684812
  690530
  697462
  700052
  701526
  702375
  702382
  707774
  711273
  713684
  714080
  719045
  721771
  723373
  723935
  725141
  732775
  734907
  736022
  736258
  736980
  738618
  739318
  740166
  740597
  743455
  745804
  748416
  748632
  748798
  754205
  755689
  755854
  758540
  758560
  762483
  762855
  763435
  767381
  773533
  774794
  775127
  782387
  785175
  785718
  785728
  787936
  787937
  788282
  788720
  796789
  800284
  804862
  805346
  807886
  809857
  812908
  812955
  814419
  817626
  827347
]
2.27 ms
(1.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.95 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "19 year"
]
1.80 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "19 year"
]
1.64 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "19 year"
]

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.