Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.19 ms
(81.64%)
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
  381819
  388401
  389980
  392404
  395871
  396002
  399922
  400382
  401336
  401582
  401944
  404633
  408439
  410776
  414956
  427970
  430920
  437668
  447445
  448587
  449118
  454835
  458017
  461423
  461644
  462687
  463945
  464598
  465808
  468574
  470137
  482073
  482084
  489168
  493218
  494695
  495670
  501647
  501831
  505977
  506299
  510687
  511063
  513307
  517663
  527856
  529034
  541782
  557086
  561694
  565158
  565959
  566022
  570705
  575430
  575464
  575804
  576314
  579976
  582708
  589720
  590413
  591841
  592071
  592358
  593878
  595412
  596995
  597048
  597472
  598471
  598587
  598695
  604255
  610421
  623195
  629092
  634517
  643462
  644246
  649121
  650118
  650187
  652605
  652882
  655058
  655090
  662200
  670989
  673711
  692422
  693111
  698101
  699587
  715710
  717499
  719214
  720506
  722563
  725409
  731485
  741539
  743232
  746157
  746979
  747147
  753262
  753307
  753333
  753395
  753908
  756106
  757915
  775939
  778644
  778647
  779737
  813903
  822717
]
17.31 ms
(11.76%)
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
  505977
  510687
  565158
  566022
  575464
  575804
  557086
  561694
  565959
  570705
  582708
  576314
  650187
  575430
  592071
  592358
  593878
  595412
  597048
  634517
  590413
  597472
  598695
  598471
  604255
  725409
  741539
  396002
  408439
  462687
  449118
  465808
  470137
  395871
  427970
  437668
  458017
  461423
  461644
  482084
  392404
  399922
  401944
  447445
  454835
  463945
  468574
  448587
  482073
  513307
  493218
  501647
  501831
  527856
  529034
  489168
  495670
  506299
  511063
  517663
  464598
  389980
  494695
  404633
  589720
  610421
  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
  579976
  381819
  813903
  541782
  655090
  673711
  717499
  655058
  692422
  623195
  643462
  778644
]
2.68 ms
(1.82%)
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
  381819
  388401
  389980
  392404
  395871
  396002
  399922
  400382
  401336
  401582
  401944
  404633
  408439
  410776
  414956
  427970
  430920
  437668
  447445
  448587
  449118
  454835
  458017
  461423
  461644
  462687
  463945
  464598
  465808
  468574
  470137
  482073
  482084
  489168
  493218
  494695
  495670
  501647
  501831
  505977
  506299
  510687
  511063
  513307
  517663
  527856
  529034
  541782
  557086
  561694
  565158
  565959
  566022
  570705
  575430
  575464
  575804
  576314
  579976
  582708
  589720
  590413
  591841
  592071
  592358
  593878
  595412
  596995
  597048
  597472
  598471
  598587
  598695
  604255
  610421
  623195
  629092
  634517
  643462
  644246
  649121
  650118
  650187
  652605
  652882
  655058
  655090
  662200
  670989
  673711
  692422
  693111
  698101
  699587
  715710
  717499
  719214
  720506
  722563
  725409
  731485
  741539
  743232
  746157
  746979
  747147
  753262
  753307
  753333
  753395
  753908
  756106
  757915
  775939
  778644
  778647
  779737
  813903
  822717
]
1.93 ms
(1.31%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.92 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen beautiful"
]
1.64 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen красивая"
]
1.55 ms
(1.05%)
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.