GET https://search.jues.net/search/embeds?q=sink

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
68.61 ms
(73.99%)
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
  191610
  355550
  425997
  427359
  446276
  448718
  459273
  459932
  467661
  490214
  496192
  502284
  503911
  510517
  517225
  519846
  524267
  527144
  527296
  540077
  549707
  549721
  558260
  586682
  602947
  604352
  615660
  626331
  630728
  636271
  642396
  646339
  648001
  702377
  709471
  710852
  716088
  746243
  755324
  759564
  765301
  778776
  784446
  796613
  810765
  813529
  815792
  817277
  818147
  823456
  824725
  825094
  825298
]
13.66 ms
(14.73%)
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
  586682
  825094
  755324
  642396
  818147
  824725
  817277
  778776
  825298
  540077
  702377
  813529
  648001
  503911
  191610
  709471
  759564
  765301
  355550
  558260
  549721
  784446
  796613
  448718
  459273
  519846
  716088
  746243
  496192
  815792
  446276
  646339
  626331
  524267
  490214
  549707
  615660
  630728
  602947
  427359
  510517
  425997
  823456
  517225
  710852
  502284
  467661
  459932
  527144
  527296
  636271
  604352
  810765
]
2.68 ms
(2.89%)
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:
[
  "sink"
  "sink"
  "sink"
  20
]
2.04 ms
(2.20%)
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
  191610
  355550
  425997
  427359
  446276
  448718
  459273
  459932
  467661
  490214
  496192
  502284
  503911
  510517
  517225
  519846
  524267
  527144
  527296
  540077
  549707
  549721
  558260
  586682
  602947
  604352
  615660
  626331
  630728
  636271
  642396
  646339
  648001
  702377
  709471
  710852
  716088
  746243
  755324
  759564
  765301
  778776
  784446
  796613
  810765
  813529
  815792
  817277
  818147
  823456
  824725
  825094
  825298
]
1.67 ms
(1.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sink"
]
1.46 ms
(1.57%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "sink"
]
1.35 ms
(1.46%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.26 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "sink"
]

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.