Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.56 ms
(85.43%)
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
  4377
  51456
  152157
  233733
  384403
  392822
  394816
  402393
  402971
  411544
  415376
  415710
  419030
  426525
  426770
  427281
  429299
  432416
  432540
  433707
  434610
  434841
  437242
  437249
  442015
  446200
  446299
  454860
  455107
  456121
  456892
  457061
  457504
  458263
  459301
  459664
  460379
  461831
  464537
  465031
  465420
  465839
  467682
  467808
  470263
  472005
  472014
  472347
  473617
  473905
  474605
  475012
  477186
  477208
  477406
  479225
  480550
  484015
  485959
  486145
  493878
  494543
  496536
  501406
  501539
  503487
  503909
  504752
  507184
  507216
  508657
  508803
  509210
  509250
  509773
  512616
  514489
  516066
  521531
  521806
  537947
  543545
  544513
  546634
  548670
  549350
  552142
  552224
  553014
  555837
  557936
  560807
  561679
  563205
  563750
  565382
  566007
  567042
  567830
  568809
  568908
  569436
  572908
  573634
  573664
  573855
  575085
  575758
  576137
  582665
  594164
  596374
  598374
  614388
  631136
  651315
  708248
  764802
  769013
  802800
]
16.39 ms
(8.88%)
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
  461831
  467682
  557936
  569436
  560807
  553014
  567830
  568809
  427281
  459301
  415710
  467808
  477186
  465031
  473905
  509210
  508803
  493878
  503909
  501539
  537947
  394816
  51456
  4377
  432416
  457061
  494543
  486145
  549350
  567042
  568908
  708248
  573855
  631136
  764802
  614388
  402971
  384403
  426770
  437249
  446200
  465420
  475012
  432540
  433707
  477406
  415376
  496536
  512616
  485959
  508657
  504752
  576137
  472014
  501406
  514489
  507184
  521806
  152157
  392822
  402393
  411544
  426525
  442015
  446299
  456121
  459664
  474605
  507216
  477208
  479225
  480550
  543545
  552142
  555837
  566007
  546634
  563205
  573634
  575085
  544513
  552224
  561679
  563750
  565382
  572908
  573664
  575758
  582665
  651315
  548670
  594164
  596374
  598374
  769013
  802800
  434841
  457504
  233733
  456892
  460379
  470263
  419030
  437242
  458263
  464537
  473617
  429299
  434610
  454860
  455107
  465839
  472005
  472347
  503487
  509250
  509773
  516066
  521531
  484015
]
3.23 ms
(1.75%)
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
  4377
  51456
  152157
  233733
  384403
  392822
  394816
  402393
  402971
  411544
  415376
  415710
  419030
  426525
  426770
  427281
  429299
  432416
  432540
  433707
  434610
  434841
  437242
  437249
  442015
  446200
  446299
  454860
  455107
  456121
  456892
  457061
  457504
  458263
  459301
  459664
  460379
  461831
  464537
  465031
  465420
  465839
  467682
  467808
  470263
  472005
  472014
  472347
  473617
  473905
  474605
  475012
  477186
  477208
  477406
  479225
  480550
  484015
  485959
  486145
  493878
  494543
  496536
  501406
  501539
  503487
  503909
  504752
  507184
  507216
  508657
  508803
  509210
  509250
  509773
  512616
  514489
  516066
  521531
  521806
  537947
  543545
  544513
  546634
  548670
  549350
  552142
  552224
  553014
  555837
  557936
  560807
  561679
  563205
  563750
  565382
  566007
  567042
  567830
  568809
  568908
  569436
  572908
  573634
  573664
  573855
  575085
  575758
  576137
  582665
  594164
  596374
  598374
  614388
  631136
  651315
  708248
  764802
  769013
  802800
]
1.99 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "в ряд"
]
1.86 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в ряд"
]
1.64 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.