Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
174.64 ms
(86.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
  39356
  81775
  233333
  381819
  386662
  388401
  389980
  392404
  395871
  396002
  398774
  399837
  399922
  400382
  401336
  401582
  401917
  401944
  404188
  404633
  404672
  408439
  410776
  414956
  420607
  425846
  427970
  430920
  431694
  437668
  447445
  448587
  449118
  454835
  458017
  461423
  461448
  461644
  462687
  463945
  464598
  465808
  468574
  470045
  470137
  482073
  482084
  489168
  493218
  494695
  495670
  501647
  501831
  506299
  513307
  517663
  527856
  529034
  529036
  541782
  561893
  589720
  591841
  596860
  596995
  598587
  613129
  623195
  629092
  643462
  644246
  649121
  650118
  652605
  652882
  655058
  655090
  662200
  670989
  673711
  693111
  697322
  698013
  698101
  699587
  715710
  717499
  719214
  720506
  722563
  725409
  728252
  729674
  731485
  736580
  741539
  742225
  743232
  746157
  746979
  747147
  753262
  753307
  753333
  753395
  753908
  756106
  757915
  763533
  775939
  778374
  778644
  778647
  779737
  788906
  795119
  804871
  811626
  813903
  822717
]
16.79 ms
(8.29%)
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
  725409
  741539
  396002
  408439
  462687
  449118
  465808
  470137
  395871
  427970
  437668
  458017
  461423
  461644
  470045
  482084
  392404
  399922
  401944
  431694
  447445
  454835
  463945
  468574
  448587
  482073
  513307
  493218
  501647
  501831
  527856
  529034
  489168
  495670
  506299
  517663
  464598
  389980
  494695
  404633
  589720
  598587
  778647
  401582
  39356
  822717
  650118
  652605
  652882
  715710
  722563
  649121
  670989
  693111
  719214
  720506
  662200
  698101
  699587
  591841
  629092
  644246
  596995
  779737
  775939
  746157
  753307
  753908
  746979
  747147
  753262
  753333
  753395
  757915
  731485
  743232
  756106
  400382
  401336
  410776
  388401
  414956
  430920
  381819
  813903
  541782
  655090
  673711
  717499
  655058
  623195
  643462
  778644
  729674
  736580
  742225
  763533
  788906
  728252
  795119
  386662
  425846
  461448
  613129
  399837
  697322
  698013
  596860
  811626
  804871
  778374
  404672
  81775
  401917
  233333
  420607
  398774
  404188
  529036
  561893
]
3.59 ms
(1.77%)
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
  39356
  81775
  233333
  381819
  386662
  388401
  389980
  392404
  395871
  396002
  398774
  399837
  399922
  400382
  401336
  401582
  401917
  401944
  404188
  404633
  404672
  408439
  410776
  414956
  420607
  425846
  427970
  430920
  431694
  437668
  447445
  448587
  449118
  454835
  458017
  461423
  461448
  461644
  462687
  463945
  464598
  465808
  468574
  470045
  470137
  482073
  482084
  489168
  493218
  494695
  495670
  501647
  501831
  506299
  513307
  517663
  527856
  529034
  529036
  541782
  561893
  589720
  591841
  596860
  596995
  598587
  613129
  623195
  629092
  643462
  644246
  649121
  650118
  652605
  652882
  655058
  655090
  662200
  670989
  673711
  693111
  697322
  698013
  698101
  699587
  715710
  717499
  719214
  720506
  722563
  725409
  728252
  729674
  731485
  736580
  741539
  742225
  743232
  746157
  746979
  747147
  753262
  753307
  753333
  753395
  753908
  756106
  757915
  763533
  775939
  778374
  778644
  778647
  779737
  788906
  795119
  804871
  811626
  813903
  822717
]
2.07 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.99 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beautiful teen"
]
1.80 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая teen"
]
1.77 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "красивая teen"
]

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.