GET https://search.jues.net/search/embeds?q=vanessa%20cage

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
42.40 ms
(61.78%)
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
  421788
  424864
  425549
  430309
  430349
  430357
  433070
  433669
  433699
  434087
  434089
  434155
  451703
  453660
  457654
  465731
  466721
  466734
  486523
  510105
  524309
  527757
  528842
  555921
  556508
  562062
  586986
  593346
  682138
  719707
  755411
  807366
  814548
  814575
  821663
]
6.02 ms
(8.77%)
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
  814548
  528842
  814575
  807366
  425549
  682138
  434155
  719707
  755411
  486523
  451703
  465731
  421788
  527757
  510105
  555921
  562062
  424864
  556508
  821663
  434087
  433699
  593346
  466734
  430309
  434089
  466721
  586986
  457654
  433070
  453660
  430349
  433669
  430357
  524309
]
5.63 ms
(8.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "vanessa cage"
]
5.42 ms
(7.90%)
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:
[
  "vanessa cage"
  "vanessa cage"
  "vanessa cage"
  20
]
2.19 ms
(3.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "vanessa cage"
]
2.14 ms
(3.11%)
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
  421788
  424864
  425549
  430309
  430349
  430357
  433070
  433669
  433699
  434087
  434089
  434155
  451703
  453660
  457654
  465731
  466721
  466734
  486523
  510105
  524309
  527757
  528842
  555921
  556508
  562062
  586986
  593346
  682138
  719707
  755411
  807366
  814548
  814575
  821663
]
1.72 ms
(2.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "vanessa cage"
]
1.56 ms
(2.27%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(2.26%)
1
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
  b"\x01öB░u;q ╗O4│t\x15ɨ"
]

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.