Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.49 ms
(88.67%)
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
  24211
  66217
  102026
  196240
  381773
  382108
  385010
  387143
  391101
  391306
  391405
  395472
  396101
  398037
  398433
  398606
  398882
  399598
  399647
  401789
  403601
  403616
  403678
  404478
  408898
  413077
  416041
  417916
  418970
  419463
  421968
  422816
  424851
  427845
  432168
  447818
  447860
  450793
  452258
  453542
  454462
  454817
  454891
  455796
  456033
  456645
  457090
  457917
  457925
  457926
  457970
  458526
  458557
  458565
  459549
  461053
  464071
  464400
  465095
  467257
  469153
  469945
  472176
  473065
  477528
  479788
  480353
  481267
  483991
  486710
  487228
  489897
  497599
  502756
  514826
  516922
  518026
  520230
  523323
  523531
  527262
  529817
  532648
  533305
  537026
  540021
  568654
  574113
  578253
  580038
  584936
  586985
  602351
  608296
  611117
  611181
  631982
  636063
  667822
  681389
  693643
  747784
  748154
  761801
  767595
  774578
  774975
  775725
  777148
  786324
  786343
  788153
  799652
  802979
  803548
  812533
  812578
  827555
]
15.36 ms
(6.44%)
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
  456645
  457926
  419463
  777148
  413077
  459549
  452258
  398037
  453542
  399647
  764021
  477528
  387143
  667822
  611117
  786324
  799652
  812578
  802979
  774578
  803548
  66217
  533305
  761801
  467257
  401789
  385010
  447818
  450793
  465095
  611181
  432168
  469945
  396101
  481267
  457970
  693643
  586985
  775725
  788153
  422816
  602351
  455796
  461053
  469153
  767595
  403616
  520230
  514826
  584936
  631982
  786343
  381773
  580038
  398433
  102026
  391306
  418970
  812533
  748154
  196240
  464400
  472176
  417916
  456033
  827555
  458557
  578253
  382108
  395472
  391405
  416041
  457090
  457925
  747784
  403678
  454817
  464071
  457917
  523531
  497599
  24211
  391101
  398606
  424851
  574113
  681389
  608296
  774975
  403601
  454891
  447860
  518026
  483991
  487228
  523323
  427845
  516922
  529817
  826033
  532648
  479788
  398882
  489897
  568654
  454462
  502756
  527262
  486710
  458565
  473065
  480353
  540021
  636063
  399598
  408898
  537026
  404478
  421968
  458526
]
4.28 ms
(1.80%)
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
  24211
  66217
  102026
  196240
  381773
  382108
  385010
  387143
  391101
  391306
  391405
  395472
  396101
  398037
  398433
  398606
  398882
  399598
  399647
  401789
  403601
  403616
  403678
  404478
  408898
  413077
  416041
  417916
  418970
  419463
  421968
  422816
  424851
  427845
  432168
  447818
  447860
  450793
  452258
  453542
  454462
  454817
  454891
  455796
  456033
  456645
  457090
  457917
  457925
  457926
  457970
  458526
  458557
  458565
  459549
  461053
  464071
  464400
  465095
  467257
  469153
  469945
  472176
  473065
  477528
  479788
  480353
  481267
  483991
  486710
  487228
  489897
  497599
  502756
  514826
  516922
  518026
  520230
  523323
  523531
  527262
  529817
  532648
  533305
  537026
  540021
  568654
  574113
  578253
  580038
  584936
  586985
  602351
  608296
  611117
  611181
  631982
  636063
  667822
  681389
  693643
  747784
  748154
  761801
  767595
  774578
  774975
  775725
  777148
  786324
  786343
  788153
  799652
  802979
  803548
  812533
  812578
  827555
]
2.01 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп спортивная"
]
1.92 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ass sport"
]
1.75 ms
(0.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жоп спортивная"
]
1.70 ms
(0.71%)
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.