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

Query Metrics

9 Database Queries
9 Different statements
82.65 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
58.17 ms
(70.38%)
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
  14508
  385034
  386565
  446740
  467030
  471393
  473755
  483401
  488543
  499818
  514095
  543710
  548259
  549434
  557241
  563868
  565155
  576806
  593165
  596021
  596191
  598855
  601658
  602981
  606742
  606807
  607325
  612183
  633830
  641686
  671334
  708577
  729749
  758926
  806374
  811036
  813786
  814835
]
7.74 ms
(9.37%)
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
  612183
  549434
  543710
  593165
  811036
  565155
  729749
  758926
  386565
  806374
  606742
  14508
  596191
  813786
  467030
  708577
  633830
  598855
  473755
  514095
  576806
  548259
  596021
  601658
  499818
  814835
  671334
  563868
  641686
  385034
  557241
  606807
  488543
  483401
  471393
  607325
  446740
  602981
]
4.42 ms
(5.35%)
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.92 ms
(3.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "америк"
]
2.20 ms
(2.66%)
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
  14508
  385034
  386565
  446740
  467030
  471393
  473755
  483401
  488543
  499818
  514095
  543710
  548259
  549434
  557241
  563868
  565155
  576806
  593165
  596021
  596191
  598855
  601658
  602981
  606742
  606807
  607325
  612183
  633830
  641686
  671334
  708577
  729749
  758926
  806374
  811036
  813786
  814835
]
1.94 ms
(2.35%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "америк"
]
1.82 ms
(2.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "америка"
]
1.82 ms
(2.20%)
1
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
  b"\x01–´â‚órŸ‚\x01L¡2þ´"
]
1.61 ms
(1.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.