Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
381.60 ms
(93.04%)
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
  387394
  396699
  402953
  404125
  405897
  407008
  422310
  426947
  432711
  438744
  443164
  444226
  445322
  448943
  457309
  460630
  460905
  462080
  467596
  469380
  470634
  471164
  473211
  476240
  477576
  479988
  484174
  488891
  489721
  490752
  494255
  494737
  494756
  503743
  503996
  505304
  507186
  511269
  511901
  513027
  514126
  515491
  516891
  517262
  517597
  518479
  521705
  522367
  523216
  523563
  524618
  533125
  533352
  539561
  543084
  543253
  543474
  543786
  543792
  544316
  545511
  549463
  550361
  551491
  552249
  552856
  554478
  554508
  555053
  555886
  557806
  558609
  558641
  558861
  559200
  563539
  563666
  564485
  566371
  566978
  567016
  569208
  571465
  574308
  574355
  578025
  578584
  582064
  584448
  584903
  586700
  588010
  595436
  596176
  599332
  599695
  600389
  601901
  611932
  618954
  619312
  619816
  620653
  622264
  622795
  622893
  629004
  636254
  657804
  661271
  662376
  662865
  665325
  671864
  672251
  679166
  682524
  684250
  690832
  769667
]
17.31 ms
(4.22%)
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
  513027
  515491
  584903
  586700
  595436
  622893
  601901
  422310
  539561
  511901
  558609
  665325
  619816
  622264
  387394
  402953
  443164
  448943
  457309
  477576
  470634
  488891
  479988
  484174
  521705
  507186
  517597
  523216
  494756
  522367
  460630
  471164
  552856
  554508
  555886
  566978
  569208
  543786
  543792
  544316
  545511
  563539
  574308
  584448
  662865
  657804
  672251
  682524
  684250
  555053
  563666
  599332
  622795
  596176
  599695
  611932
  618954
  636254
  600389
  620653
  769667
  619312
  629004
  404125
  460905
  426947
  444226
  407008
  438744
  396699
  405897
  432711
  445322
  588010
  473211
  462080
  469380
  490752
  494255
  518479
  494737
  503743
  517262
  503996
  505304
  514126
  533352
  511269
  516891
  523563
  524618
  533125
  467596
  476240
  489721
  543084
  550361
  559200
  578025
  543253
  543474
  549463
  551491
  554478
  564485
  567016
  571465
  574355
  578584
  557806
  566371
  582064
  662376
  671864
  679166
  690832
  661271
  552249
  558641
  558861
]
3.36 ms
(0.82%)
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
  387394
  396699
  402953
  404125
  405897
  407008
  422310
  426947
  432711
  438744
  443164
  444226
  445322
  448943
  457309
  460630
  460905
  462080
  467596
  469380
  470634
  471164
  473211
  476240
  477576
  479988
  484174
  488891
  489721
  490752
  494255
  494737
  494756
  503743
  503996
  505304
  507186
  511269
  511901
  513027
  514126
  515491
  516891
  517262
  517597
  518479
  521705
  522367
  523216
  523563
  524618
  533125
  533352
  539561
  543084
  543253
  543474
  543786
  543792
  544316
  545511
  549463
  550361
  551491
  552249
  552856
  554478
  554508
  555053
  555886
  557806
  558609
  558641
  558861
  559200
  563539
  563666
  564485
  566371
  566978
  567016
  569208
  571465
  574308
  574355
  578025
  578584
  582064
  584448
  584903
  586700
  588010
  595436
  596176
  599332
  599695
  600389
  601901
  611932
  618954
  619312
  619816
  620653
  622264
  622795
  622893
  629004
  636254
  657804
  661271
  662376
  662865
  665325
  671864
  672251
  679166
  682524
  684250
  690832
  769667
]
2.39 ms
(0.58%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в голову"
]
2.19 ms
(0.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "в голов"
]
1.79 ms
(0.44%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "в голов"
]
1.50 ms
(0.37%)
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.