GET https://search.jues.net/search/embeds?q=%D1%87%D0%B5%D1%82%D1%8B%D1%80%D0%B5%20%D0%B4%D1%80%D1%83%D0%B3%D0%B0

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
69.86 ms
(62.59%)
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
  47613
  220912
  390378
  406282
  407797
  408458
  413865
  416874
  418230
  424695
  426578
  429943
  430661
  438536
  444150
  450692
  451263
  457331
  470968
  477230
  483550
  484559
  488734
  497326
  497917
  500530
  516313
  520227
  520272
  531187
  532101
  542548
  545608
  549225
  559127
  565096
  578318
  578606
  590437
  591314
  591804
  593008
  603680
  608206
  618094
  636111
  735488
  742683
  795336
]
21.87 ms
(19.59%)
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
]
10.68 ms
(9.57%)
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
  408458
  429943
  636111
  500530
  735488
  795336
  407797
  603680
  578606
  438536
  742683
  549225
  591804
  590437
  516313
  545608
  457331
  488734
  532101
  424695
  444150
  477230
  497917
  220912
  450692
  520227
  578318
  47613
  426578
  390378
  483550
  416874
  418230
  406282
  413865
  520272
  565096
  451263
  484559
  542548
  430661
  470968
  497326
  618094
  531187
  593008
  608206
  591314
  559127
]
2.58 ms
(2.31%)
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
  47613
  220912
  390378
  406282
  407797
  408458
  413865
  416874
  418230
  424695
  426578
  429943
  430661
  438536
  444150
  450692
  451263
  457331
  470968
  477230
  483550
  484559
  488734
  497326
  497917
  500530
  516313
  520227
  520272
  531187
  532101
  542548
  545608
  549225
  559127
  565096
  578318
  578606
  590437
  591314
  591804
  593008
  603680
  608206
  618094
  636111
  735488
  742683
  795336
]
1.90 ms
(1.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "четыре друга"
]
1.71 ms
(1.53%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "четыр друг"
]
1.52 ms
(1.36%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.51 ms
(1.35%)
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.