Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
185.20 ms
(87.91%)
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
  467670
  514823
  514918
  539095
  539151
  545130
  547707
  555338
  562468
  571630
  573600
  576526
  581326
  581569
  582063
  584350
  630143
  630294
  635770
  645518
  646525
  651853
  661422
  662446
  668959
  669622
  669851
  672907
  675425
  683106
  686789
  686830
  688307
  693039
  698619
  698823
  702336
  702889
  705177
  707577
  714198
  717007
  723259
  726263
  727413
  728718
  734638
  735092
  735180
  735254
  735797
  735831
  736618
  736765
  738276
  738534
  739149
  741479
  743876
  743918
  744207
  745375
  745584
  747111
  748041
  753123
  753210
  753573
  756180
  760192
  761437
  761438
  762261
  763758
  766151
  767396
  768613
  769028
  769149
  770747
  771343
  776875
  780420
  781253
  781269
  781627
  784582
  785019
  785747
  787452
  788537
  789429
  790829
  792463
  793132
  793487
  794221
  794779
  796040
  796305
  796526
  799122
  799733
  799981
  802223
  802240
  802410
  802752
  804404
  804470
  807119
  807661
  807831
  809728
  809942
  810807
  811180
  811426
  813190
]
14.60 ms
(6.93%)
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
  796040
  796305
  796526
  802223
  802240
  727413
  743876
  743918
  748041
  760192
  766151
  767396
  769149
  781269
  781627
  790829
  793132
  793487
  799122
  799733
  802410
  802752
  807661
  807831
  810807
  811180
  811426
  813190
  726263
  735797
  736765
  744207
  762261
  770747
  734638
  735092
  735180
  735254
  745375
  745584
  747111
  753210
  753573
  766525
  728718
  735831
  736618
  738276
  756180
  768613
  738534
  739149
  741479
  753123
  761437
  761438
  763758
  769028
  771343
  630143
  630294
  635770
  698619
  707577
  776875
  780420
  781253
  784582
  785019
  785747
  787452
  788537
  789429
  792463
  794221
  794779
  799981
  804404
  804470
  807119
  809728
  809942
  467670
  514918
  539095
  514823
  539151
  571630
  545130
  555338
  562468
  581326
  584350
  547707
  573600
  576526
  581569
  582063
  646525
  661422
  662446
  686830
  693039
  702336
  705177
  651853
  669622
  669851
  672907
  675425
  683106
  686789
  688307
  698823
  702889
  714198
  717007
  723259
  645518
  668959
]
3.02 ms
(1.43%)
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
  467670
  514823
  514918
  539095
  539151
  545130
  547707
  555338
  562468
  571630
  573600
  576526
  581326
  581569
  582063
  584350
  630143
  630294
  635770
  645518
  646525
  651853
  661422
  662446
  668959
  669622
  669851
  672907
  675425
  683106
  686789
  686830
  688307
  693039
  698619
  698823
  702336
  702889
  705177
  707577
  714198
  717007
  723259
  726263
  727413
  728718
  734638
  735092
  735180
  735254
  735797
  735831
  736618
  736765
  738276
  738534
  739149
  741479
  743876
  743918
  744207
  745375
  745584
  747111
  748041
  753123
  753210
  753573
  756180
  760192
  761437
  761438
  762261
  763758
  766151
  767396
  768613
  769028
  769149
  770747
  771343
  776875
  780420
  781253
  781269
  781627
  784582
  785019
  785747
  787452
  788537
  789429
  790829
  792463
  793132
  793487
  794221
  794779
  796040
  796305
  796526
  799122
  799733
  799981
  802223
  802240
  802410
  802752
  804404
  804470
  807119
  807661
  807831
  809728
  809942
  810807
  811180
  811426
  813190
]
2.12 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "твои"
]
1.99 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "тво"
]
1.99 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "тво"
]
1.75 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.