Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
171.68 ms
(89.47%)
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
  303426
  391649
  394035
  396779
  397499
  398116
  414349
  477606
  510727
  545335
  551003
  553214
  568017
  583695
  589644
  609945
  622850
  635133
  669546
  709487
  711050
  714831
  715621
  718854
  719401
  720169
  720563
  721604
  722315
  723249
  724905
  725722
  729071
  729131
  732952
  733443
  735790
  743511
  743996
  744028
  745996
  748592
  754235
  754696
  756197
  756831
  756993
  757908
  758710
  760506
  762974
  763470
  765958
  765998
  766116
  766125
  767678
  768377
  768726
  768993
  770101
  771394
  773052
  776849
  777244
  777811
  777825
  778108
  778127
  778244
  778890
  782991
  782997
  786584
  787253
  787573
  787607
  787634
  787692
  787770
  787837
  788126
  788724
  789379
  789567
  789577
  789630
  791660
  792758
  793516
  794457
  794535
  794729
  795237
  795347
  795353
  796357
  796552
  797033
  797131
  797567
  797894
  799442
  800280
  801104
  801426
  801671
  801680
  801930
  802074
  803850
  805698
  808439
  808604
  808611
  809052
  810857
  819885
  827455
]
10.73 ms
(5.59%)
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
  553214
  568017
  796552
  778244
  635133
  819885
  827455
  545335
  718854
  719401
  721604
  723249
  711050
  777244
  787692
  791660
  794535
  800280
  810857
  776849
  778108
  787573
  787634
  795347
  797567
  801671
  801930
  729071
  733443
  756993
  782991
  787253
  789379
  725722
  735790
  748592
  754235
  732952
  743511
  743996
  744028
  756197
  760506
  762974
  766116
  768377
  745996
  763261
  766125
  768993
  771394
  722315
  777811
  777825
  778127
  782997
  786584
  787837
  795353
  801426
  414349
  551003
  622850
  609945
  709487
  398116
  477606
  803850
  757908
  754696
  589644
  758710
  394035
  391649
  303426
  397499
  396779
  510727
  583695
  669546
  714831
  715621
  778890
  789577
  794457
  797131
  801104
  808611
  809052
  787607
  787770
  788126
  788724
  789567
  789630
  796357
  797894
  799442
  801680
  802074
  767678
  793516
  797033
  805698
  808439
  808604
  765998
  770101
  763470
  765958
  768726
  773052
  724905
  729131
  756831
  720169
  720563
  792758
  794729
  795237
]
2.99 ms
(1.56%)
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
  303426
  391649
  394035
  396779
  397499
  398116
  414349
  477606
  510727
  545335
  551003
  553214
  568017
  583695
  589644
  609945
  622850
  635133
  669546
  709487
  711050
  714831
  715621
  718854
  719401
  720169
  720563
  721604
  722315
  723249
  724905
  725722
  729071
  729131
  732952
  733443
  735790
  743511
  743996
  744028
  745996
  748592
  754235
  754696
  756197
  756831
  756993
  757908
  758710
  760506
  762974
  763470
  765958
  765998
  766116
  766125
  767678
  768377
  768726
  768993
  770101
  771394
  773052
  776849
  777244
  777811
  777825
  778108
  778127
  778244
  778890
  782991
  782997
  786584
  787253
  787573
  787607
  787634
  787692
  787770
  787837
  788126
  788724
  789379
  789567
  789577
  789630
  791660
  792758
  793516
  794457
  794535
  794729
  795237
  795347
  795353
  796357
  796552
  797033
  797131
  797567
  797894
  799442
  800280
  801104
  801426
  801671
  801680
  801930
  802074
  803850
  805698
  808439
  808604
  808611
  809052
  810857
  819885
  827455
]
1.88 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "на дом"
]
1.80 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на домашн любительск"
]
1.55 ms
(0.81%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.25 ms
(0.65%)
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.