GET https://search.jues.net/search/embeds?q=%D1%88%D0%BF%D0%B8%D0%BB%D1%8C%D0%BA%D0%B0%D1%85

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
64.91 ms
(72.65%)
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
  403736
  433452
  455543
  459030
  463426
  466279
  467160
  477427
  477754
  479381
  479946
  491988
  492000
  494248
  500299
  501193
  503725
  504638
  504661
  512485
  513427
  515593
  516916
  519969
  538608
  555393
  559793
  560302
  560463
  560639
  590288
  596880
  600952
  619529
  751610
  753504
  758114
  767679
  771867
  786432
  808958
  810479
]
9.01 ms
(10.08%)
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
  560463
  751610
  600952
  753504
  810479
  786432
  459030
  808958
  771867
  477427
  767679
  758114
  467160
  479381
  455543
  477754
  512485
  494248
  555393
  560302
  560639
  619529
  433452
  479946
  403736
  516916
  504638
  519969
  538608
  492000
  559793
  466279
  463426
  503725
  501193
  491988
  500299
  513427
  504661
  515593
  590288
  596880
]
3.94 ms
(4.41%)
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.63 ms
(2.95%)
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
  403736
  433452
  455543
  459030
  463426
  466279
  467160
  477427
  477754
  479381
  479946
  491988
  492000
  494248
  500299
  501193
  503725
  504638
  504661
  512485
  513427
  515593
  516916
  519969
  538608
  555393
  559793
  560302
  560463
  560639
  590288
  596880
  600952
  619529
  751610
  753504
  758114
  767679
  771867
  786432
  808958
  810479
]
2.59 ms
(2.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "шпильк"
]
2.37 ms
(2.65%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "шпильк"
]
2.26 ms
(2.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "шпильках"
]
1.64 ms
(1.84%)
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.