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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
255.05 ms
(52.12%)
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
  418591
  424686
  439151
  441920
  445689
  457461
  459141
  460710
  471319
  487758
  490447
  493954
  494118
  499349
  506866
  507873
  511171
  516481
  523212
  526384
  541575
  543508
  543771
  550475
  554444
  555979
  555983
  567134
  570928
  572683
  574768
  583062
  600781
  602102
  603684
  606002
  619725
  637650
  808579
]
212.34 ms
(43.39%)
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:
[
  "window"
  "window"
  "window"
  20
]
9.38 ms
(1.92%)
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
  570928
  602102
  600781
  441920
  424686
  490447
  493954
  445689
  460710
  511171
  541575
  555983
  574768
  554444
  555979
  603684
  637650
  471319
  439151
  457461
  499349
  487758
  506866
  459141
  507873
  572683
  583062
  567134
  808579
  418591
  516481
  494118
  526384
  523212
  543508
  543771
  550475
  619725
  606002
]
2.72 ms
(0.56%)
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
  418591
  424686
  439151
  441920
  445689
  457461
  459141
  460710
  471319
  487758
  490447
  493954
  494118
  499349
  506866
  507873
  511171
  516481
  523212
  526384
  541575
  543508
  543771
  550475
  554444
  555979
  555983
  567134
  570928
  572683
  574768
  583062
  600781
  602102
  603684
  606002
  619725
  637650
  808579
]
2.33 ms
(0.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "window"
]
2.27 ms
(0.46%)
1
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
  b"\x01–_”*âs_˜\eEËùOe+"
]
1.93 ms
(0.39%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.85 ms
(0.38%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "window"
]
1.47 ms
(0.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "window"
]

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.