Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.14 ms
(81.57%)
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
  254390
  433721
  434003
  442652
  448968
  450654
  454084
  460577
  463094
  463826
  464561
  465608
  469366
  469686
  472544
  472669
  475677
  489325
  491525
  504908
  510774
  519215
  519497
  520405
  521287
  523907
  525149
  525156
  525551
  525864
  526096
  528088
  528119
  528197
  529341
  529952
  531510
  532273
  532572
  535486
  535878
  538695
  539121
  539147
  541158
  541167
  541467
  543144
  549101
  554143
  557471
  561121
  563538
  564562
  566016
  568136
  568138
  568377
  569019
  569041
  570822
  571666
  577119
  580300
  587232
  589365
  591688
  593098
  593144
  593146
  593340
  595323
  596033
  596115
  597908
  598328
  603351
  603396
  604465
  605340
  605581
  606618
  616205
  618960
  619495
  623650
  624263
  627064
  629417
  629882
  633171
  635280
  637207
  652544
  674683
  694203
  695613
  696553
  710917
  726800
  751012
  755343
  758119
  772410
  773000
  774393
  775508
  783405
  785119
  789760
  790124
  790170
  794606
  798600
  799440
  802445
  804689
  815269
  817131
  827080
]
20.02 ms
(12.65%)
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
  525149
  525551
  566016
  541167
  557471
  563538
  674683
  696553
  554143
  561121
  568136
  568138
  589365
  596033
  624263
  629417
  635280
  637207
  587232
  593146
  597908
  598328
  603396
  623650
  591688
  605340
  627064
  799440
  775508
  798600
  802445
  773000
  783405
  789760
  790124
  751012
  758119
  772410
  774393
  726800
  755343
  710917
  785119
  790170
  794606
  804689
  254390
  472669
  464561
  580300
  532572
  652544
  629882
  616205
  504908
  519497
  525864
  442652
  434003
  475677
  535486
  539147
  528088
  472544
  491525
  569041
  543144
  604465
  454084
  463094
  465608
  469686
  519215
  523907
  528119
  529341
  489325
  521287
  541467
  520405
  528197
  529952
  531510
  433721
  817131
  827080
  815269
  463826
  450654
  469366
  448968
  526096
  538695
  539121
  510774
  525156
  532273
  535878
  460577
  541158
  568377
  569019
  570822
  577119
  694203
  695613
  549101
  564562
  571666
  606618
  633171
  596115
  593098
  603351
  605581
  593144
  593340
  595323
  618960
  619495
]
2.35 ms
(1.49%)
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
  254390
  433721
  434003
  442652
  448968
  450654
  454084
  460577
  463094
  463826
  464561
  465608
  469366
  469686
  472544
  472669
  475677
  489325
  491525
  504908
  510774
  519215
  519497
  520405
  521287
  523907
  525149
  525156
  525551
  525864
  526096
  528088
  528119
  528197
  529341
  529952
  531510
  532273
  532572
  535486
  535878
  538695
  539121
  539147
  541158
  541167
  541467
  543144
  549101
  554143
  557471
  561121
  563538
  564562
  566016
  568136
  568138
  568377
  569019
  569041
  570822
  571666
  577119
  580300
  587232
  589365
  591688
  593098
  593144
  593146
  593340
  595323
  596033
  596115
  597908
  598328
  603351
  603396
  604465
  605340
  605581
  606618
  616205
  618960
  619495
  623650
  624263
  627064
  629417
  629882
  633171
  635280
  637207
  652544
  674683
  694203
  695613
  696553
  710917
  726800
  751012
  755343
  758119
  772410
  773000
  774393
  775508
  783405
  785119
  789760
  790124
  790170
  794606
  798600
  799440
  802445
  804689
  815269
  817131
  827080
]
2.21 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "compilation mom"
]
1.73 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "подборк mom"
]
1.47 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.39 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "подборк mom"
]

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.