Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.64 ms
(83.84%)
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
  233018
  367962
  388557
  391557
  391597
  411419
  420486
  420591
  420598
  423483
  423867
  424102
  424415
  426407
  428839
  431465
  438028
  443117
  443408
  443428
  443692
  443698
  443720
  443756
  443815
  444104
  444121
  444147
  444259
  445136
  445720
  448890
  448896
  452905
  452963
  454559
  454560
  455297
  460759
  460898
  461810
  462299
  462594
  462605
  462658
  464538
  465671
  466043
  466199
  466357
  466478
  470024
  470050
  470143
  470192
  470316
  470499
  472139
  472409
  472421
  474213
  474323
  474480
  475878
  476258
  476268
  476515
  477933
  477934
  479084
  479136
  479995
  481096
  485425
  487318
  488953
  490930
  491124
  494573
  498169
  506422
  509145
  509179
  509253
  509491
  509515
  509966
  510775
  516690
  520622
  520859
  520860
  523592
  526726
  528339
  534503
  543991
  544021
  549777
  550216
  553957
  554034
  562312
  565302
  571792
  577433
  578010
  582198
  597123
  615693
  662557
  681798
  683297
  691179
  741699
  741773
  790193
  814985
  814986
  814987
]
17.24 ms
(9.86%)
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
  550216
  554034
  565302
  391597
  431465
  448890
  465671
  470143
  476515
  391557
  424102
  426407
  444259
  452905
  466478
  474323
  438028
  466357
  472139
  477933
  420591
  423483
  470024
  475878
  477934
  445136
  462658
  466043
  509145
  491124
  494573
  498169
  520622
  528339
  509253
  509966
  485425
  577433
  578010
  452963
  474480
  444121
  411419
  444147
  466199
  487318
  490930
  509491
  510775
  520860
  444104
  814986
  814987
  814985
  455297
  461810
  464538
  488953
  516690
  520859
  509515
  523592
  534503
  506422
  509179
  526726
  479084
  553957
  582198
  543991
  544021
  549777
  562312
  662557
  691179
  681798
  683297
  571792
  597123
  790193
  741773
  741699
  615693
  233018
  388557
  423867
  428839
  443117
  443698
  443756
  443815
  445720
  448896
  460759
  462299
  462594
  462605
  470050
  420486
  420598
  424415
  443408
  443428
  443720
  454560
  460898
  470499
  472421
  476258
  476268
  479136
  479995
  481096
  454559
  470192
  470316
  472409
  474213
  367962
  443692
]
3.39 ms
(1.94%)
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
  233018
  367962
  388557
  391557
  391597
  411419
  420486
  420591
  420598
  423483
  423867
  424102
  424415
  426407
  428839
  431465
  438028
  443117
  443408
  443428
  443692
  443698
  443720
  443756
  443815
  444104
  444121
  444147
  444259
  445136
  445720
  448890
  448896
  452905
  452963
  454559
  454560
  455297
  460759
  460898
  461810
  462299
  462594
  462605
  462658
  464538
  465671
  466043
  466199
  466357
  466478
  470024
  470050
  470143
  470192
  470316
  470499
  472139
  472409
  472421
  474213
  474323
  474480
  475878
  476258
  476268
  476515
  477933
  477934
  479084
  479136
  479995
  481096
  485425
  487318
  488953
  490930
  491124
  494573
  498169
  506422
  509145
  509179
  509253
  509491
  509515
  509966
  510775
  516690
  520622
  520859
  520860
  523592
  526726
  528339
  534503
  543991
  544021
  549777
  550216
  553957
  554034
  562312
  565302
  571792
  577433
  578010
  582198
  597123
  615693
  662557
  681798
  683297
  691179
  741699
  741773
  790193
  814985
  814986
  814987
]
2.26 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian saggy"
]
1.88 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск saggy"
]
1.82 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск saggy"
]

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.