Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.42 ms
(84.46%)
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
  33001
  390663
  396929
  417284
  422139
  423322
  423468
  423529
  425916
  426147
  427041
  434581
  443848
  450148
  450155
  461241
  469944
  477126
  481639
  483296
  485672
  501482
  503825
  504559
  511672
  518800
  527252
  527697
  540664
  552562
  559452
  561247
  574000
  578226
  591015
  602547
  603847
  608753
  616691
  616826
  622796
  623422
  624081
  626182
  630296
  630347
  631876
  634617
  636186
  639984
  641026
  643573
  650274
  653004
  659698
  671245
  693327
  697135
  699237
  700868
  722323
  731396
  755737
  756829
  761777
  762989
  763561
  764266
  764703
  765827
  766139
  767419
  769265
  775799
  777463
  777499
  777794
  779803
  780381
  780742
  780783
  780830
  780965
  781578
  781814
  783003
  783271
  783922
  784564
  784682
  786694
  786774
  787455
  788387
  788606
  790529
  790578
  791219
  791635
  792175
  792990
  794060
  794836
  795498
  796488
  797765
  798327
  799045
  799514
  800523
  800921
  802335
  804191
  805117
  807314
  808768
  809972
  810171
  812841
  819141
]
12.95 ms
(8.38%)
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
  477126
  426147
  33001
  396929
  425916
  434581
  819141
  461241
  469944
  450155
  450148
  485672
  503825
  511672
  527252
  540664
  481639
  483296
  559452
  561247
  552562
  659698
  653004
  699237
  722323
  650274
  671245
  693327
  697135
  574000
  578226
  616826
  634617
  636186
  626182
  639984
  643573
  591015
  608753
  630296
  630347
  616691
  622796
  624081
  631876
  641026
  777499
  780381
  783003
  783271
  788387
  790578
  792175
  792990
  795498
  796488
  797765
  802335
  805117
  777794
  780742
  781814
  784682
  786694
  791219
  800523
  808768
  731396
  755737
  761777
  762989
  781578
  784564
  786774
  788606
  794836
  800921
  807314
  810171
  812841
  764703
  765827
  769265
  763561
  764266
  766139
  767419
  603847
  775799
  777463
  779803
  780783
  780830
  780965
  783922
  787455
  790529
  791635
  794060
  798327
  799045
  804191
  809972
  427041
  423322
  417284
  443848
  504559
  527697
  501482
  623422
  602547
  518800
  700868
  756829
  799514
  390663
  422139
  423468
  423529
]
3.84 ms
(2.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mouth пов"
]
2.67 ms
(1.73%)
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
  33001
  390663
  396929
  417284
  422139
  423322
  423468
  423529
  425916
  426147
  427041
  434581
  443848
  450148
  450155
  461241
  469944
  477126
  481639
  483296
  485672
  501482
  503825
  504559
  511672
  518800
  527252
  527697
  540664
  552562
  559452
  561247
  574000
  578226
  591015
  602547
  603847
  608753
  616691
  616826
  622796
  623422
  624081
  626182
  630296
  630347
  631876
  634617
  636186
  639984
  641026
  643573
  650274
  653004
  659698
  671245
  693327
  697135
  699237
  700868
  722323
  731396
  755737
  756829
  761777
  762989
  763561
  764266
  764703
  765827
  766139
  767419
  769265
  775799
  777463
  777499
  777794
  779803
  780381
  780742
  780783
  780830
  780965
  781578
  781814
  783003
  783271
  783922
  784564
  784682
  786694
  786774
  787455
  788387
  788606
  790529
  790578
  791219
  791635
  792175
  792990
  794060
  794836
  795498
  796488
  797765
  798327
  799045
  799514
  800523
  800921
  802335
  804191
  805117
  807314
  808768
  809972
  810171
  812841
  819141
]
1.67 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mouth pov"
]
1.46 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.41 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mouth пов"
]

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.