Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.84 ms
(85.83%)
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
  373905
  381789
  383360
  384905
  385608
  387650
  388847
  389891
  390717
  395310
  397063
  400668
  401940
  407885
  409590
  428224
  441829
  441847
  441864
  454699
  454784
  456263
  462914
  467952
  468352
  474672
  475482
  478298
  485281
  491583
  510547
  516716
  518504
  519332
  531794
  531882
  541270
  545198
  545217
  546838
  550339
  564731
  566764
  583554
  587755
  588278
  588446
  589079
  592275
  593116
  597700
  605256
  605312
  621066
  621081
  625765
  629194
  630685
  632108
  635124
  636816
  642689
  655184
  660702
  665959
  678959
  682924
  702571
  707616
  711458
  715098
  717545
  719996
  724854
  726926
  727887
  748340
  749457
  750168
  750727
  758495
  758498
  758538
  758567
  760965
  761040
  761066
  765715
  767189
  767220
  767279
  774689
  774698
  774702
  775188
  788176
  788248
  792179
  792180
  793472
  793727
  798365
  800492
  800796
  800856
  801213
  801348
  803327
  804327
  810214
  810249
  810320
  811540
  813879
  814965
  815014
  817246
  817331
  827588
]
13.74 ms
(7.57%)
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
  774702
  468352
  775188
  665959
  519332
  541270
  660702
  774689
  792179
  750727
  804327
  815014
  531794
  726926
  719996
  765715
  767279
  383360
  456263
  395310
  707616
  531882
  801213
  632108
  711458
  588278
  800796
  629194
  491583
  441829
  682924
  583554
  775033
  758567
  625765
  475482
  397063
  748340
  516716
  655184
  605256
  545198
  678959
  454784
  564731
  593116
  636816
  592275
  597700
  792180
  788248
  800492
  758495
  750168
  724854
  758498
  642689
  385608
  381789
  630685
  800856
  441847
  810214
  811540
  400668
  774698
  605312
  621081
  635124
  588446
  749457
  817246
  389891
  550339
  810320
  388847
  390717
  441864
  793472
  761040
  474672
  454699
  510547
  717545
  788176
  793727
  727887
  758538
  407885
  827588
  401940
  428224
  462914
  545217
  546838
  566764
  589079
  587755
  801348
  767220
  810249
  761066
  409590
  485281
  817331
  373905
  467952
  478298
  518504
  384905
  715098
  813879
  814965
  702571
  621066
  798365
  803327
  767189
  760965
  387650
]
3.66 ms
(2.02%)
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
  373905
  381789
  383360
  384905
  385608
  387650
  388847
  389891
  390717
  395310
  397063
  400668
  401940
  407885
  409590
  428224
  441829
  441847
  441864
  454699
  454784
  456263
  462914
  467952
  468352
  474672
  475482
  478298
  485281
  491583
  510547
  516716
  518504
  519332
  531794
  531882
  541270
  545198
  545217
  546838
  550339
  564731
  566764
  583554
  587755
  588278
  588446
  589079
  592275
  593116
  597700
  605256
  605312
  621066
  621081
  625765
  629194
  630685
  632108
  635124
  636816
  642689
  655184
  660702
  665959
  678959
  682924
  702571
  707616
  711458
  715098
  717545
  719996
  724854
  726926
  727887
  748340
  749457
  750168
  750727
  758495
  758498
  758538
  758567
  760965
  761040
  761066
  765715
  767189
  767220
  767279
  774689
  774698
  774702
  775188
  788176
  788248
  792179
  792180
  793472
  793727
  798365
  800492
  800796
  800856
  801213
  801348
  803327
  804327
  810214
  810249
  810320
  811540
  813879
  814965
  815014
  817246
  817331
  827588
]
2.64 ms
(1.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в жопу латинку"
]
1.99 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал латинская"
]
1.90 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал латинская"
]
1.79 ms
(0.98%)
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.