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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
47.02 ms
(67.73%)
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
  53499
  53962
  91754
  186823
  412601
  413485
  415874
  422832
  462651
  467068
  483491
  486858
  512694
  513309
  524565
  526363
  546958
  557876
  564327
  581706
  587357
  618559
  628712
  661064
  673149
  677296
  678138
  716901
  724460
  724540
  750897
  781828
  803360
  808071
  818592
]
6.47 ms
(9.32%)
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
  818592
  628712
  618559
  186823
  661064
  781828
  557876
  808071
  803360
  724540
  724460
  53499
  53962
  750897
  91754
  513309
  483491
  462651
  412601
  467068
  524565
  413485
  512694
  486858
  673149
  587357
  678138
  546958
  581706
  422832
  415874
  564327
  716901
  526363
  677296
]
3.67 ms
(5.29%)
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:
[
  "spunk"
  "spunk"
  "spunk"
  20
]
2.60 ms
(3.74%)
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
  53499
  53962
  91754
  186823
  412601
  413485
  415874
  422832
  462651
  467068
  483491
  486858
  512694
  513309
  524565
  526363
  546958
  557876
  564327
  581706
  587357
  618559
  628712
  661064
  673149
  677296
  678138
  716901
  724460
  724540
  750897
  781828
  803360
  808071
  818592
]
2.34 ms
(3.37%)
1
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
  b"\x01“}Ou5r\x03…Óìó7üD!"
]
2.22 ms
(3.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "spunk"
]
1.77 ms
(2.55%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "spunk"
]
1.74 ms
(2.51%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(2.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "spunk"
]

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.