GET https://search.jues.net/search/embeds/2?q=young%2018yo

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.69 ms
(60.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young 18yo"
]
95.42 ms
(27.05%)
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
  403924
  421562
  429049
  429084
  429143
  429153
  448706
  452237
  452245
  455876
  458703
  474025
  502326
  508438
  517554
  517589
  518031
  529846
  530762
  532644
  556014
  556017
  560450
  562373
  563884
  570708
  571476
  577778
  580669
  586695
  594431
  596739
  597253
  597262
  597265
  597266
  603878
  608431
  610049
  614058
  622398
  622401
  624173
  624833
  628368
  628380
  632689
  633114
  637093
  637123
  637134
  647847
  652125
  668525
  680116
  680159
  684265
  732482
  801226
]
25.25 ms
(7.16%)
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:
[
  "young 18yo"
  "young 18yo"
  "young 18yo"
  20
]
12.01 ms
(3.41%)
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
  647847
  652125
  624833
  637134
  597266
  622401
  597253
  628368
  508438
  518031
  452237
  517589
  684265
  610049
  801226
  732482
  448706
  429049
  529846
  562373
  571476
  680116
  556014
  556017
  614058
  632689
  633114
  421562
  628380
  403924
  586695
  455876
  429153
  570708
  668525
  680159
  594431
  637093
  452245
  474025
  458703
  517554
  597265
  502326
  563884
  597262
  622398
  608431
  560450
  580669
  624173
  637123
  603878
  577778
  596739
  532644
  429143
  530762
  429084
]
2.42 ms
(0.69%)
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
  403924
  421562
  429049
  429084
  429143
  429153
  448706
  452237
  452245
  455876
  458703
  474025
  502326
  508438
  517554
  517589
  518031
  529846
  530762
  532644
  556014
  556017
  560450
  562373
  563884
  570708
  571476
  577778
  580669
  586695
  594431
  596739
  597253
  597262
  597265
  597266
  603878
  608431
  610049
  614058
  622398
  622401
  624173
  624833
  628368
  628380
  632689
  633114
  637093
  637123
  637134
  647847
  652125
  668525
  680116
  680159
  684265
  732482
  801226
]
2.17 ms
(0.61%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young 18yo"
]
2.08 ms
(0.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young 18yo"
]
1.66 ms
(0.47%)
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.