Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
261.92 ms
(92.22%)
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
  30883
  197599
  230821
  346150
  361382
  413076
  420703
  442037
  450835
  451309
  457721
  478804
  479682
  487604
  488342
  490291
  501541
  503020
  506306
  511870
  511950
  524212
  524744
  535688
  539078
  540766
  541963
  542464
  544540
  544550
  544552
  545679
  548412
  549065
  551660
  551689
  552429
  554479
  555302
  555443
  556172
  556404
  558799
  559473
  559890
  559895
  560304
  560686
  562032
  562299
  562450
  563709
  563710
  564789
  567750
  568042
  569811
  570296
  577084
  580953
  582056
  583439
  584773
  587026
  587060
  592271
  595326
  596884
  602177
  607340
  607533
  611518
  612516
  616519
  622309
  622579
  626213
  635212
  636049
  636050
  640503
  645260
  647534
  647586
  648378
  654794
  655628
  655760
  656027
  659105
  659250
  662807
  666966
  675473
  679078
  684430
  685926
  687506
  689113
  689743
  701188
  704351
  719033
  722928
  723071
  748901
  755000
  763840
  763861
  766584
  771951
  779275
  782597
  785326
  787585
  790323
  793782
  797926
  800900
  810535
]
11.58 ms
(4.08%)
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
  552429
  562450
  635212
  636050
  587026
  587060
  592271
  595326
  612516
  596884
  622579
  626213
  787585
  790323
  793782
  779275
  763840
  763861
  766584
  771951
  782597
  797926
  810535
  755000
  748901
  607340
  607533
  640503
  704351
  722928
  723071
  785326
  800900
  197599
  230821
  361382
  346150
  30883
  420703
  442037
  413076
  450835
  479682
  457721
  487604
  490291
  451309
  503020
  524744
  540766
  511870
  524212
  535688
  506306
  501541
  511950
  539078
  478804
  488342
  541963
  548412
  551689
  558799
  562032
  562299
  567750
  580953
  583439
  542464
  544540
  544552
  545679
  551660
  555302
  555443
  556172
  556404
  559473
  559895
  563710
  564789
  582056
  544550
  549065
  559890
  560304
  560686
  568042
  569811
  577084
  584773
  648378
  655628
  659105
  659250
  662807
  679078
  689113
  689743
  701188
  647534
  655760
  675473
  684430
  685926
  687506
  719033
  645260
  647586
  654794
  656027
  666966
  554479
  563709
  570296
  602177
  616519
  636049
  611518
  622309
]
3.31 ms
(1.17%)
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
  30883
  197599
  230821
  346150
  361382
  413076
  420703
  442037
  450835
  451309
  457721
  478804
  479682
  487604
  488342
  490291
  501541
  503020
  506306
  511870
  511950
  524212
  524744
  535688
  539078
  540766
  541963
  542464
  544540
  544550
  544552
  545679
  548412
  549065
  551660
  551689
  552429
  554479
  555302
  555443
  556172
  556404
  558799
  559473
  559890
  559895
  560304
  560686
  562032
  562299
  562450
  563709
  563710
  564789
  567750
  568042
  569811
  570296
  577084
  580953
  582056
  583439
  584773
  587026
  587060
  592271
  595326
  596884
  602177
  607340
  607533
  611518
  612516
  616519
  622309
  622579
  626213
  635212
  636049
  636050
  640503
  645260
  647534
  647586
  648378
  654794
  655628
  655760
  656027
  659105
  659250
  662807
  666966
  675473
  679078
  684430
  685926
  687506
  689113
  689743
  701188
  704351
  719033
  722928
  723071
  748901
  755000
  763840
  763861
  766584
  771951
  779275
  782597
  785326
  787585
  790323
  793782
  797926
  800900
  810535
]
2.02 ms
(0.71%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "обратно"
]
1.98 ms
(0.70%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "обратн"
]
1.69 ms
(0.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "обратн"
]
1.51 ms
(0.53%)
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.