Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
166.17 ms
(85.92%)
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
  408354
  418921
  419490
  420398
  427878
  429143
  434971
  441017
  446457
  447706
  454217
  466313
  466727
  467441
  467446
  467451
  467485
  467518
  467894
  468957
  470094
  470288
  470749
  472616
  475194
  482101
  482375
  485931
  487067
  487144
  488132
  489120
  489457
  491497
  491885
  491887
  491915
  492515
  492518
  493242
  494768
  494770
  495112
  498022
  498038
  498057
  499814
  501465
  502745
  503953
  503962
  504776
  506146
  506576
  506659
  511528
  511803
  515281
  516442
  517144
  518349
  519061
  521239
  522362
  523737
  523875
  525263
  526545
  526749
  529546
  533608
  548594
  550130
  553703
  553706
  553717
  553720
  560152
  560445
  562882
  564443
  565617
  574179
  579359
  579362
  582790
  586472
  586494
  591077
  591607
  597813
  599826
  600078
  601851
  605365
  605395
  606738
  607344
  620282
  620619
  621504
  623849
  624214
  624511
  662879
  666156
  674064
  681478
  687529
  689634
  699025
  702430
  709543
  721617
  721646
  781669
  782186
  799642
  813922
  817507
]
19.42 ms
(10.04%)
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
  467485
  467441
  467518
  470094
  441017
  420398
  522362
  526749
  491915
  492515
  506146
  517144
  533608
  485931
  487067
  503953
  515281
  523875
  503962
  506659
  624214
  601851
  408354
  482375
  491887
  501465
  519061
  511528
  529546
  467894
  482101
  489457
  550130
  553706
  560445
  574179
  562882
  564443
  553720
  560152
  687529
  721617
  674064
  681478
  689634
  721646
  662879
  699025
  621504
  591607
  597813
  606738
  586472
  586494
  600078
  605395
  620282
  620619
  624511
  702430
  454217
  466313
  467446
  472616
  468957
  499814
  489120
  491885
  493242
  495112
  523737
  487144
  511803
  494768
  782186
  781669
  419490
  434971
  491497
  446457
  470749
  498038
  518349
  506576
  526545
  488132
  565617
  579362
  579359
  582790
  623849
  591077
  599826
  605365
  607344
  427878
  466727
  418921
  467451
  475194
  504776
  502745
  492518
  498057
  516442
  813922
  709543
  666156
  799642
  429143
  817507
  447706
  525263
  498022
  521239
  494770
  470288
  548594
  553703
  553717
]
2.06 ms
(1.06%)
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
  408354
  418921
  419490
  420398
  427878
  429143
  434971
  441017
  446457
  447706
  454217
  466313
  466727
  467441
  467446
  467451
  467485
  467518
  467894
  468957
  470094
  470288
  470749
  472616
  475194
  482101
  482375
  485931
  487067
  487144
  488132
  489120
  489457
  491497
  491885
  491887
  491915
  492515
  492518
  493242
  494768
  494770
  495112
  498022
  498038
  498057
  499814
  501465
  502745
  503953
  503962
  504776
  506146
  506576
  506659
  511528
  511803
  515281
  516442
  517144
  518349
  519061
  521239
  522362
  523737
  523875
  525263
  526545
  526749
  529546
  533608
  548594
  550130
  553703
  553706
  553717
  553720
  560152
  560445
  562882
  564443
  565617
  574179
  579359
  579362
  582790
  586472
  586494
  591077
  591607
  597813
  599826
  600078
  601851
  605365
  605395
  606738
  607344
  620282
  620619
  621504
  623849
  624214
  624511
  662879
  666156
  674064
  681478
  687529
  689634
  699025
  702430
  709543
  721617
  721646
  781669
  782186
  799642
  813922
  817507
]
1.55 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "old hidden"
]
1.46 ms
(0.75%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "old скрыт"
]
1.42 ms
(0.73%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.33 ms
(0.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "old скрыт"
]

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.