Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.81 ms
(57.12%)
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
  423644
  443977
  458098
  470760
  542477
  547686
  548679
  550498
  552804
  553556
  555011
  556766
  560477
  564804
  564818
  568369
  569969
  570365
  570399
  572295
  573308
  573699
  574192
  574634
  577091
  578366
  580195
  580564
  590827
  595063
  595992
  596131
  596566
  597169
  597901
  601369
  603683
  603867
  607922
  609524
  614523
  615538
  616924
  624116
  626324
  627540
  632294
  635856
  639155
  641158
  641897
  651765
  657493
  657505
  662427
  682464
  683331
  684479
  687950
  693278
  698883
  705737
  707676
  708292
  709981
  714700
  717669
  720095
  721382
  726470
  730664
  731244
  732964
  740610
  742226
  742869
  743531
  744184
  748325
  756247
  756950
  758560
  759579
  766892
  767130
  771068
  771564
  771841
  772590
  772833
  772884
  774050
  774545
  776305
  780340
  780584
  784948
  787209
  787754
  790744
  793699
  794251
  795417
  796115
  797161
  797673
  800346
  800475
  800510
  802741
  802841
  803122
  803160
  803415
  807353
  807401
  807968
  810198
  812588
  813538
]
137.06 ms
(36.96%)
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
  423644
  443977
  458098
  470760
  542477
  547686
  548679
  550498
  552804
  553556
  555011
  556766
  560477
  564804
  564818
  568369
  569969
  570365
  570399
  572295
  573308
  573699
  574192
  574634
  577091
  578366
  580195
  580564
  590827
  595063
  595992
  596131
  596566
  597169
  597901
  601369
  603683
  603867
  607922
  609524
  614523
  615538
  616924
  624116
  626324
  627540
  632294
  635856
  639155
  641158
  641897
  651765
  657493
  657505
  662427
  682464
  683331
  684479
  687950
  693278
  698883
  705737
  707676
  708292
  709981
  714700
  717669
  720095
  721382
  726470
  730664
  731244
  732964
  740610
  742226
  742869
  743531
  744184
  748325
  756247
  756950
  758560
  759579
  766892
  767130
  771068
  771564
  771841
  772590
  772833
  772884
  774050
  774545
  776305
  780340
  780584
  784948
  787209
  787754
  790744
  793699
  794251
  795417
  796115
  797161
  797673
  800346
  800475
  800510
  802741
  802841
  803122
  803160
  803415
  807353
  807401
  807968
  810198
  812588
  813538
]
15.15 ms
(4.09%)
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
  570399
  577091
  548679
  550498
  556766
  560477
  564804
  570365
  580564
  542477
  553556
  564818
  569969
  572295
  573699
  574192
  580195
  682464
  683331
  684479
  698883
  708292
  721382
  657493
  657505
  687950
  693278
  720095
  651765
  662427
  707676
  714700
  547686
  552804
  555011
  568369
  573308
  574634
  578366
  595063
  597169
  597901
  615538
  596131
  601369
  603867
  635856
  595992
  603683
  607922
  609524
  616924
  590827
  596566
  624116
  626324
  627540
  639155
  641897
  776305
  780584
  787754
  790744
  795417
  797161
  797673
  800346
  803415
  807353
  807401
  812588
  784948
  793699
  794251
  796115
  800475
  803160
  813538
  740610
  744184
  758560
  802841
  807968
  810198
  730664
  748325
  771841
  726470
  732964
  766892
  772590
  742226
  742869
  743531
  756247
  759579
  771068
  771564
  772884
  774050
  731244
  756950
  767130
  772833
  614523
  632294
  641158
  705737
  709981
  717669
  774545
  780340
  787209
  800510
  802741
  803122
  443977
  458098
  470760
  423644
]
1.99 ms
(0.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "дену"
]
1.89 ms
(0.51%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ден"
]
1.48 ms
(0.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "ден"
]
1.45 ms
(0.39%)
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.