GET https://search.jues.net/search/embeds?q=chloe%20cherry

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
56.46 ms
(70.40%)
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
  414068
  415188
  421181
  429985
  432115
  445575
  463199
  465575
  477068
  491999
  492106
  494771
  495399
  518052
  523174
  544841
  557517
  563854
  566991
  584491
  601053
  605122
  606738
  626892
  674430
  681437
  683470
  688035
  688105
  688660
  691235
  705572
  746417
  805670
  805841
  820388
]
7.84 ms
(9.78%)
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
  746417
  805841
  681437
  805670
  688660
  688105
  705572
  674430
  683470
  518052
  584491
  688035
  557517
  563854
  463199
  606738
  601053
  445575
  492106
  544841
  523174
  626892
  691235
  605122
  820388
  465575
  414068
  415188
  477068
  494771
  432115
  495399
  421181
  429985
  491999
  566991
]
4.45 ms
(5.55%)
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:
[
  "chloe cherry"
  "chloe cherry"
  "chloe cherry"
  20
]
2.57 ms
(3.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
  414068
  415188
  421181
  429985
  432115
  445575
  463199
  465575
  477068
  491999
  492106
  494771
  495399
  518052
  523174
  544841
  557517
  563854
  566991
  584491
  601053
  605122
  606738
  626892
  674430
  681437
  683470
  688035
  688105
  688660
  691235
  705572
  746417
  805670
  805841
  820388
]
1.97 ms
(2.46%)
1
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
  b"\x01”-j\Ýsɪ™\x07¦NΆl"
]
1.93 ms
(2.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "chloe cherry"
]
1.81 ms
(2.25%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "chloecherry"
]
1.62 ms
(2.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "chloecherry"
]
1.55 ms
(1.93%)
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.