Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.19 ms
(82.18%)
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
  4208
  78620
  82143
  82217
  82289
  309276
  389668
  390214
  393469
  397569
  398604
  401727
  417751
  418999
  441181
  446345
  446350
  460962
  471110
  488797
  492147
  510660
  511613
  512004
  522148
  536110
  540581
  550638
  550941
  552206
  556390
  558375
  559604
  561725
  563356
  571390
  573349
  576307
  585784
  585896
  587331
  589377
  590211
  593983
  595613
  599903
  600475
  603082
  603430
  604084
  605850
  605930
  606227
  608426
  616007
  618919
  621161
  621653
  622607
  623960
  626453
  626609
  627636
  632279
  635153
  652129
  653229
  654413
  654419
  655359
  656732
  657066
  658091
  659221
  663973
  664433
  672890
  672992
  676579
  676769
  680749
  680753
  683720
  684307
  685399
  701131
  713684
  719210
  720168
  721417
  725110
  728814
  731893
  733911
  735528
  740449
  740503
  740653
  746075
  748042
  748561
  753478
  754199
  757586
  757886
  768010
  773580
  780867
  781068
  783630
  784513
  784708
  786928
  791303
  798265
  798665
  799980
  819624
  821487
  826309
]
13.87 ms
(7.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
  654419
  659221
  713684
  571390
  585784
  590211
  635153
  593983
  621161
  784708
  798665
  748561
  783630
  757886
  746075
  728814
  791303
  401727
  664433
  488797
  82217
  78620
  4208
  389668
  819624
  826309
  446345
  536110
  540581
  511613
  512004
  460962
  550638
  552206
  654413
  672890
  720168
  683720
  719210
  563356
  585896
  599903
  616007
  621653
  589377
  600475
  603082
  605930
  627636
  622607
  781068
  798265
  725110
  786928
  753478
  757586
  773580
  740503
  731893
  733911
  754199
  618919
  626453
  82289
  82143
  393469
  397569
  441181
  471110
  309276
  398604
  510660
  390214
  417751
  418999
  821487
  446350
  492147
  522148
  550941
  558375
  561725
  556390
  559604
  655359
  663973
  672992
  680753
  684307
  685399
  653229
  656732
  657066
  658091
  676579
  676769
  652129
  680749
  721417
  573349
  576307
  605850
  608426
  587331
  595613
  604084
  626609
  632279
  603430
  606227
  623960
  799980
  780867
  735528
  748042
  784513
  740449
  740653
  768010
  701131
]
9.96 ms
(5.56%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.67 ms
(1.49%)
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
  4208
  78620
  82143
  82217
  82289
  309276
  389668
  390214
  393469
  397569
  398604
  401727
  417751
  418999
  441181
  446345
  446350
  460962
  471110
  488797
  492147
  510660
  511613
  512004
  522148
  536110
  540581
  550638
  550941
  552206
  556390
  558375
  559604
  561725
  563356
  571390
  573349
  576307
  585784
  585896
  587331
  589377
  590211
  593983
  595613
  599903
  600475
  603082
  603430
  604084
  605850
  605930
  606227
  608426
  616007
  618919
  621161
  621653
  622607
  623960
  626453
  626609
  627636
  632279
  635153
  652129
  653229
  654413
  654419
  655359
  656732
  657066
  658091
  659221
  663973
  664433
  672890
  672992
  676579
  676769
  680749
  680753
  683720
  684307
  685399
  701131
  713684
  719210
  720168
  721417
  725110
  728814
  731893
  733911
  735528
  740449
  740503
  740653
  746075
  748042
  748561
  753478
  754199
  757586
  757886
  768010
  773580
  780867
  781068
  783630
  784513
  784708
  786928
  791303
  798265
  798665
  799980
  819624
  821487
  826309
]
2.32 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny cute"
]
1.88 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые cute"
]
1.20 ms
(0.67%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "худые cute"
]

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.