Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
221.92 ms
(90.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
  583416
  592991
  593065
  602837
  606362
  609829
  611003
  617581
  625488
  628942
  634636
  635404
  636751
  637170
  639647
  640046
  640392
  640489
  643689
  646639
  647453
  648261
  652422
  653307
  655607
  663228
  666053
  694904
  700837
  703764
  706685
  706761
  707481
  707589
  708304
  708588
  708704
  708730
  710352
  714223
  715087
  715384
  716040
  717322
  718051
  718639
  721160
  724634
  727584
  731187
  733131
  734436
  734448
  736808
  737453
  738426
  739245
  740487
  742645
  744140
  746851
  748779
  749043
  750210
  750232
  750794
  751455
  753659
  758654
  759893
  760857
  762305
  762442
  763661
  763870
  765654
  766539
  768509
  769338
  771896
  771979
  771982
  772401
  772411
  773054
  773918
  773929
  778617
  779976
  780427
  782370
  785002
  785649
  788575
  789701
  791728
  793245
  794630
  794723
  795796
  795987
  796739
  796837
  797108
  797454
  799708
  799903
  800614
  801783
  802573
  803116
  803199
  803412
  803724
  804676
  804739
  806369
  809314
  809861
]
14.17 ms
(5.75%)
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
  583416
  648261
  663228
  666053
  707481
  708304
  715087
  715384
  646639
  652422
  653307
  706761
  707589
  708730
  714223
  721160
  647453
  655607
  694904
  703764
  708704
  710352
  716040
  717322
  718051
  611003
  628942
  634636
  592991
  606362
  636751
  643689
  593065
  602837
  617581
  625488
  637170
  639647
  640392
  640489
  780427
  788575
  789701
  791728
  793245
  794723
  795987
  796837
  797454
  799708
  800614
  802573
  803116
  804676
  804739
  806369
  778617
  779976
  785649
  797108
  799903
  803724
  809861
  727584
  733131
  734448
  737453
  738426
  744140
  746851
  758654
  760857
  762305
  771982
  772553
  782370
  785002
  794630
  795796
  796739
  801783
  803199
  803412
  809314
  750794
  772401
  724634
  734436
  736808
  739245
  740487
  742645
  749043
  766539
  769338
  773918
  748779
  753659
  759893
  762442
  763661
  765654
  768509
  771896
  771979
  772411
  773929
  731187
  750210
  750232
  751455
  763870
  773054
  609829
  635404
  640046
  700837
  706685
  708588
  718639
]
2.83 ms
(1.15%)
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
  583416
  592991
  593065
  602837
  606362
  609829
  611003
  617581
  625488
  628942
  634636
  635404
  636751
  637170
  639647
  640046
  640392
  640489
  643689
  646639
  647453
  648261
  652422
  653307
  655607
  663228
  666053
  694904
  700837
  703764
  706685
  706761
  707481
  707589
  708304
  708588
  708704
  708730
  710352
  714223
  715087
  715384
  716040
  717322
  718051
  718639
  721160
  724634
  727584
  731187
  733131
  734436
  734448
  736808
  737453
  738426
  739245
  740487
  742645
  744140
  746851
  748779
  749043
  750210
  750232
  750794
  751455
  753659
  758654
  759893
  760857
  762305
  762442
  763661
  763870
  765654
  766539
  768509
  769338
  771896
  771979
  771982
  772401
  772411
  773054
  773918
  773929
  778617
  779976
  780427
  782370
  785002
  785649
  788575
  789701
  791728
  793245
  794630
  794723
  795796
  795987
  796739
  796837
  797108
  797454
  799708
  799903
  800614
  801783
  802573
  803116
  803199
  803412
  803724
  804676
  804739
  806369
  809314
  809861
]
2.19 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "you wife"
]
2.09 ms
(0.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "you жен"
]
1.73 ms
(0.70%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.62%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "you жен"
]

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.