GET https://search.jues.net/search/embeds?q=watch%20friend

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
56.05 ms
(72.07%)
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
  398620
  453600
  462886
  467545
  482371
  483244
  493361
  500530
  502541
  504768
  517598
  542754
  579853
  598859
  635822
  648948
  665990
  674474
  704314
  717614
  720215
  725401
  726173
  728460
  732602
  732916
  734700
  743870
  750581
  768718
  771795
  773945
  782298
  788573
  797532
  802068
  803742
  813072
  813315
  813426
  816710
  824072
  825102
]
6.93 ms
(8.91%)
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
  579853
  725401
  482371
  467545
  824072
  635822
  803742
  743870
  813315
  648948
  734700
  768718
  728460
  813426
  732916
  726173
  816710
  717614
  782298
  802068
  720215
  825102
  750581
  704314
  398620
  813072
  773945
  732602
  771795
  797532
  453600
  500530
  665990
  674474
  517598
  788573
  462886
  493361
  502541
  542754
  483244
  598859
  504768
]
5.70 ms
(7.32%)
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:
[
  "watch friend"
  "watch friend"
  "watch friend"
  20
]
2.51 ms
(3.22%)
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
  398620
  453600
  462886
  467545
  482371
  483244
  493361
  500530
  502541
  504768
  517598
  542754
  579853
  598859
  635822
  648948
  665990
  674474
  704314
  717614
  720215
  725401
  726173
  728460
  732602
  732916
  734700
  743870
  750581
  768718
  771795
  773945
  782298
  788573
  797532
  802068
  803742
  813072
  813315
  813426
  816710
  824072
  825102
]
1.82 ms
(2.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "watch friend"
]
1.78 ms
(2.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "watch friend"
]
1.52 ms
(1.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(1.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "watch friend"
]

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.