Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.51 ms
(87.98%)
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
  382665
  391890
  406652
  428544
  472181
  473692
  517539
  519601
  536513
  539881
  540099
  551680
  555021
  560345
  571112
  580896
  587241
  594355
  599211
  607444
  614078
  614657
  622477
  629971
  635332
  641475
  649388
  649435
  649474
  650524
  652881
  658901
  658919
  658931
  658939
  660811
  662212
  664574
  668760
  672354
  678369
  679281
  679283
  683698
  700034
  700815
  701666
  702319
  707425
  707840
  718537
  718684
  723839
  725922
  726110
  729253
  731576
  734432
  736006
  740289
  740442
  742674
  744541
  751383
  753578
  753715
  753732
  758401
  759138
  761868
  762215
  764409
  764453
  765812
  768431
  770693
  771272
  773509
  775585
  777974
  781004
  782739
  783357
  784141
  784305
  785114
  786259
  791308
  794448
  794718
  794888
  795502
  795747
  797500
  799720
  800095
  804456
  811822
  811828
  812001
  812267
  813702
  815844
  816147
  817181
  817752
  817864
  818031
  819423
  819665
  820101
  821819
  824000
  824103
  824319
  824468
  824663
  825582
  827591
  827627
]
11.77 ms
(6.70%)
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
  599211
  629971
  641475
  785114
  786259
  791308
  797500
  800095
  775585
  782739
  794448
  794888
  795747
  723839
  734432
  736006
  753715
  753732
  765812
  770693
  773509
  783357
  784141
  794718
  799720
  804456
  811822
  811828
  759138
  764453
  731576
  740289
  742674
  753578
  761868
  764409
  771272
  725922
  744541
  768431
  726110
  729253
  740442
  751383
  758401
  762215
  607444
  614657
  701666
  707425
  777974
  781004
  784305
  795502
  812001
  812267
  391890
  382665
  472181
  406652
  428544
  815844
  818031
  819423
  824103
  824663
  825582
  816147
  817181
  821819
  827591
  827627
  817752
  819665
  813702
  817864
  820101
  824000
  824319
  824468
  473692
  539881
  517539
  536513
  540099
  519601
  580896
  551680
  560345
  571112
  650524
  652881
  658901
  658939
  662212
  664574
  702319
  707840
  649435
  649474
  672354
  678369
  683698
  700034
  700815
  649388
  658919
  658931
  660811
  668760
  679281
  679283
  718537
  718684
  555021
  587241
  594355
  614078
  622477
  635332
]
2.28 ms
(1.30%)
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
  382665
  391890
  406652
  428544
  472181
  473692
  517539
  519601
  536513
  539881
  540099
  551680
  555021
  560345
  571112
  580896
  587241
  594355
  599211
  607444
  614078
  614657
  622477
  629971
  635332
  641475
  649388
  649435
  649474
  650524
  652881
  658901
  658919
  658931
  658939
  660811
  662212
  664574
  668760
  672354
  678369
  679281
  679283
  683698
  700034
  700815
  701666
  702319
  707425
  707840
  718537
  718684
  723839
  725922
  726110
  729253
  731576
  734432
  736006
  740289
  740442
  742674
  744541
  751383
  753578
  753715
  753732
  758401
  759138
  761868
  762215
  764409
  764453
  765812
  768431
  770693
  771272
  773509
  775585
  777974
  781004
  782739
  783357
  784141
  784305
  785114
  786259
  791308
  794448
  794718
  794888
  795502
  795747
  797500
  799720
  800095
  804456
  811822
  811828
  812001
  812267
  813702
  815844
  816147
  817181
  817752
  817864
  818031
  819423
  819665
  820101
  821819
  824000
  824103
  824319
  824468
  824663
  825582
  827591
  827627
]
2.16 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "shower shower"
]
1.88 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "shower shower"
]
1.57 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "shower shower"
]
1.45 ms
(0.83%)
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.