Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
148.94 ms
(86.81%)
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
  385241
  419162
  456142
  461111
  481357
  485923
  494952
  515300
  540642
  544879
  556130
  571993
  577294
  577718
  584970
  585790
  585998
  607866
  616082
  624684
  630846
  633109
  633671
  652665
  658099
  658157
  661921
  668447
  668554
  668613
  668988
  671419
  674825
  712085
  716010
  716050
  717285
  717984
  718960
  720576
  727610
  728151
  729200
  729863
  733253
  733330
  733346
  734705
  736139
  737121
  741854
  743111
  745231
  747563
  748717
  750592
  751828
  761123
  762476
  763159
  763166
  763717
  764956
  765755
  767365
  767501
  768089
  769340
  769354
  770065
  771761
  771804
  772837
  772968
  777217
  777477
  777568
  778383
  778428
  779030
  779066
  779085
  779685
  780036
  781405
  781575
  781900
  782503
  783838
  786143
  786705
  786713
  786791
  786980
  787050
  787082
  787760
  788979
  789012
  789891
  790761
  794992
  795606
  795669
  795673
  797267
  798623
  799528
  802174
  807273
  809726
  809887
  810414
  811137
  811641
  812508
  813310
  814731
  821799
]
13.44 ms
(7.83%)
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
  718960
  720576
  585998
  777568
  786143
  787050
  795606
  781575
  734705
  737121
  772837
  789891
  809726
  771804
  772968
  728151
  743111
  736139
  763159
  769340
  779085
  419162
  814731
  717285
  779066
  794992
  795673
  798623
  811137
  812508
  779030
  729863
  733253
  750592
  795669
  763717
  729200
  788979
  802174
  809887
  658099
  481357
  540642
  515300
  652665
  661921
  668447
  668554
  668613
  712085
  658157
  668988
  674825
  607866
  585790
  741854
  770065
  772131
  624684
  633671
  733330
  556130
  571993
  779685
  783838
  385241
  778428
  786791
  821799
  671419
  716010
  630846
  778383
  786705
  786980
  790761
  777217
  789012
  813310
  733346
  769354
  787760
  799528
  810414
  761123
  767501
  751828
  764956
  727610
  765755
  767365
  768089
  633109
  716050
  781900
  786713
  811641
  747563
  485923
  494952
  544879
  717984
  616082
  782503
  797267
  780036
  807273
  763166
  781405
  787082
  748717
  762476
  745231
  771761
  777477
  456142
  461111
  577718
  584970
  577294
]
3.00 ms
(1.75%)
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
  385241
  419162
  456142
  461111
  481357
  485923
  494952
  515300
  540642
  544879
  556130
  571993
  577294
  577718
  584970
  585790
  585998
  607866
  616082
  624684
  630846
  633109
  633671
  652665
  658099
  658157
  661921
  668447
  668554
  668613
  668988
  671419
  674825
  712085
  716010
  716050
  717285
  717984
  718960
  720576
  727610
  728151
  729200
  729863
  733253
  733330
  733346
  734705
  736139
  737121
  741854
  743111
  745231
  747563
  748717
  750592
  751828
  761123
  762476
  763159
  763166
  763717
  764956
  765755
  767365
  767501
  768089
  769340
  769354
  770065
  771761
  771804
  772837
  772968
  777217
  777477
  777568
  778383
  778428
  779030
  779066
  779085
  779685
  780036
  781405
  781575
  781900
  782503
  783838
  786143
  786705
  786713
  786791
  786980
  787050
  787082
  787760
  788979
  789012
  789891
  790761
  794992
  795606
  795669
  795673
  797267
  798623
  799528
  802174
  807273
  809726
  809887
  810414
  811137
  811641
  812508
  813310
  814731
  821799
]
1.78 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "facial homemade"
]
1.56 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "facial домашн любительск"
]
1.52 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.33 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "facial домашн любительск"
]

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.