GET https://search.jues.net/search/embeds?q=%D0%B0%D0%BA%D1%82%D0%B5%D1%80

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
102.01 ms
(78.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
  29971
  142823
  382567
  385036
  385318
  393473
  397303
  403285
  403401
  413049
  417865
  421363
  425410
  426197
  429244
  434439
  434642
  435497
  438909
  443424
  444786
  445279
  446293
  446337
  455876
  467861
  468156
  468590
  469518
  472589
  474483
  502778
  513649
  521344
  526447
  546544
  565522
  566856
  580614
  587960
  593858
  606641
  619870
  625363
  626894
  642693
  644015
  647933
  653870
  663740
  666180
  716866
  743293
  798969
  801289
  802284
  802293
  812104
]
12.00 ms
(9.26%)
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
  663740
  142823
  385318
  587960
  812104
  393473
  626894
  467861
  403401
  443424
  606641
  801289
  743293
  802293
  434439
  565522
  644015
  798969
  716866
  802284
  403285
  546544
  382567
  385036
  29971
  438909
  417865
  666180
  397303
  429244
  566856
  580614
  593858
  619870
  468590
  513649
  445279
  521344
  468156
  413049
  425410
  444786
  446293
  455876
  472589
  502778
  435497
  642693
  426197
  446337
  526447
  647933
  625363
  474483
  434642
  469518
  421363
  653870
]
5.50 ms
(4.24%)
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:
[
  "актер"
  "актер"
  "актер"
  20
]
2.97 ms
(2.29%)
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
  29971
  142823
  382567
  385036
  385318
  393473
  397303
  403285
  403401
  413049
  417865
  421363
  425410
  426197
  429244
  434439
  434642
  435497
  438909
  443424
  444786
  445279
  446293
  446337
  455876
  467861
  468156
  468590
  469518
  472589
  474483
  502778
  513649
  521344
  526447
  546544
  565522
  566856
  580614
  587960
  593858
  606641
  619870
  625363
  626894
  642693
  644015
  647933
  653870
  663740
  666180
  716866
  743293
  798969
  801289
  802284
  802293
  812104
]
1.90 ms
(1.47%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.89 ms
(1.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "актер"
]
1.81 ms
(1.39%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "актер"
]
1.60 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.