GET https://search.jues.net/search/embeds?q=snow%20white

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
53.83 ms
(65.31%)
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
  411384
  419127
  426248
  428481
  438042
  452300
  460710
  461234
  475338
  479322
  487872
  503388
  504722
  504729
  504745
  507595
  507771
  508368
  511207
  511564
  513645
  519437
  520433
  523408
  529833
  530765
  537207
  538665
  545451
  545621
  582417
  582619
  584817
  657545
  753155
  761468
  771792
  778201
  778239
  780247
  785024
  811033
]
9.69 ms
(11.75%)
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:
[
  "snow white"
  "snow white"
  "snow white"
  20
]
8.04 ms
(9.76%)
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
  778201
  780247
  778239
  811033
  582619
  657545
  753155
  419127
  461234
  411384
  582417
  584817
  507595
  771792
  504729
  785024
  529833
  761468
  504722
  475338
  545621
  538665
  426248
  504745
  511207
  513645
  545451
  438042
  460710
  428481
  479322
  508368
  487872
  530765
  452300
  520433
  503388
  519437
  507771
  523408
  537207
  511564
]
2.72 ms
(3.30%)
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
  411384
  419127
  426248
  428481
  438042
  452300
  460710
  461234
  475338
  479322
  487872
  503388
  504722
  504729
  504745
  507595
  507771
  508368
  511207
  511564
  513645
  519437
  520433
  523408
  529833
  530765
  537207
  538665
  545451
  545621
  582417
  582619
  584817
  657545
  753155
  761468
  771792
  778201
  778239
  780247
  785024
  811033
]
2.23 ms
(2.71%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "snow white"
]
2.13 ms
(2.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "snow white"
]
2.08 ms
(2.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "snow white"
]
1.71 ms
(2.07%)
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.