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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
217.77 ms
(65.57%)
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:
[
  "rebecca"
  "rebecca"
  "rebecca"
  20
]
92.88 ms
(27.97%)
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
  233143
  383211
  388712
  389980
  400739
  401095
  413827
  414784
  415734
  421006
  425878
  428302
  429766
  430836
  445039
  446518
  446731
  446739
  447458
  449872
  451262
  452082
  459565
  464188
  472503
  472518
  479803
  484460
  503419
  505822
  507678
  517792
  518846
  535009
  539465
  616097
  639741
  639783
  646849
  646896
  688007
  702622
]
10.48 ms
(3.16%)
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
  401095
  233143
  389980
  428302
  518846
  415734
  414784
  479803
  449872
  445039
  507678
  517792
  539465
  383211
  429766
  446518
  446731
  472503
  505822
  702622
  421006
  472518
  484460
  535009
  400739
  459565
  464188
  646896
  616097
  451262
  447458
  446739
  425878
  413827
  430836
  388712
  452082
  503419
  646849
  688007
  639783
  639741
]
2.53 ms
(0.76%)
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
  233143
  383211
  388712
  389980
  400739
  401095
  413827
  414784
  415734
  421006
  425878
  428302
  429766
  430836
  445039
  446518
  446731
  446739
  447458
  449872
  451262
  452082
  459565
  464188
  472503
  472518
  479803
  484460
  503419
  505822
  507678
  517792
  518846
  535009
  539465
  616097
  639741
  639783
  646849
  646896
  688007
  702622
]
2.11 ms
(0.64%)
1
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
  b"\x01öºnØ(rª╝Gµ¸X┼v{"
]
1.87 ms
(0.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "rebecca"
]
1.64 ms
(0.49%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "rebecca"
]
1.43 ms
(0.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "rebecca"
]
1.42 ms
(0.43%)
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.