Query Metrics

8 Database Queries
8 Different statements
322.69 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
210.40 ms
(65.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "беловолосая group"
]
77.53 ms
(24.02%)
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
  393715
  398426
  401919
  418363
  419740
  421250
  422342
  430404
  430700
  432787
  434192
  436178
  442841
  451563
  452061
  456618
  462698
  464887
  466056
  466979
  471356
  471365
  474654
  477705
  480749
  484693
  494978
  496100
  497870
  498551
  504213
  506801
  516744
  517743
  520731
  522147
  522902
  534845
  542187
  545698
  562814
  575459
  576717
  587864
  591314
  612434
  615881
  637003
  647344
  650633
  667748
  675020
  707391
]
13.98 ms
(4.33%)
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
  451563
  422342
  477705
  442841
  466056
  471365
  522902
  504213
  393715
  398426
  419740
  421250
  462698
  484693
  522147
  534845
  480749
  575459
  545698
  432787
  456618
  418363
  471356
  452061
  496100
  498551
  516744
  494978
  497870
  466979
  667748
  474654
  401919
  464887
  434192
  506801
  650633
  675020
  707391
  587864
  637003
  436178
  430404
  430700
  520731
  517743
  576717
  647344
  615881
  591314
  612434
  542187
  562814
]
12.97 ms
(4.02%)
1
SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?
Parameters:
[
  "blonde group"
  "blonde group"
  "blonde group"
  20
]
2.60 ms
(0.81%)
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
  393715
  398426
  401919
  418363
  419740
  421250
  422342
  430404
  430700
  432787
  434192
  436178
  442841
  451563
  452061
  456618
  462698
  464887
  466056
  466979
  471356
  471365
  474654
  477705
  480749
  484693
  494978
  496100
  497870
  498551
  504213
  506801
  516744
  517743
  520731
  522147
  522902
  534845
  542187
  545698
  562814
  575459
  576717
  587864
  591314
  612434
  615881
  637003
  647344
  650633
  667748
  675020
  707391
]
1.83 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blonde group"
]
1.70 ms
(0.53%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(0.52%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "беловолосая group"
]

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.