GET https://search.jues.net/search/embeds/3?q=college%20anal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
420.44 ms
(77.84%)
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
  387576
  388175
  419455
  427804
  439845
  441039
  448522
  457793
  465449
  468010
  483788
  489280
  495103
  502384
  507646
  513141
  521576
  521866
  526104
  526199
  528483
  541832
  562258
  598745
  598795
  601010
  609906
  617023
  710647
]
51.62 ms
(9.56%)
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:
[
  "college anal"
  "college anal"
  "college anal"
  20
]
49.97 ms
(9.25%)
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
  387576
  388175
  419455
  427804
  439845
  441039
  448522
  457793
  465449
  468010
  483788
  489280
  495103
  502384
  507646
  513141
  521576
  521866
  526104
  526199
  528483
  541832
  562258
  598745
  598795
  601010
  609906
  617023
  710647
]
7.36 ms
(1.36%)
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
  465449
  507646
  468010
  528483
  710647
  601010
  439845
  521866
  598745
  617023
  388175
  495103
  609906
  457793
  526199
  521576
  541832
  441039
  489280
  502384
  598795
  419455
  427804
  387576
  448522
  562258
  526104
  483788
  513141
]
2.43 ms
(0.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "college анал"
]
2.30 ms
(0.43%)
1
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
  b"\x01•Ö"PÌpøˆM°Þu™M¶"
]
2.11 ms
(0.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "college anal"
]
1.96 ms
(0.36%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "college анал"
]
1.90 ms
(0.35%)
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.