GET https://search.jues.net/search/embeds?q=teen%20bottle

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
205.38 ms
(57.25%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
101.56 ms
(28.31%)
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
  41776
  159291
  439031
  439158
  450697
  457483
  459198
  462850
  466563
  471688
  476834
  477149
  479542
  493744
  497864
  530956
  531336
  532727
  539026
  539030
  541277
  541278
  544140
  547469
  548947
  550813
  559287
  564514
  568264
  568266
  568267
  573461
  575655
  576225
  584374
  586759
  586760
  592576
  597163
  624925
  632311
  634068
  643619
  651059
  656186
  660362
  726221
  735130
  735133
  735134
  735136
  735152
  735260
  752631
  801313
]
34.47 ms
(9.61%)
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:
[
  "teen bottle"
  "teen bottle"
  "teen bottle"
  20
]
8.53 ms
(2.38%)
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
  735136
  568266
  575655
  541277
  541278
  548947
  539030
  752631
  735152
  531336
  643619
  801313
  159291
  539026
  584374
  547469
  550813
  586759
  726221
  735130
  735133
  735260
  497468
  544140
  559287
  576225
  651059
  564514
  656186
  660362
  592576
  493744
  497864
  530956
  568267
  634068
  586760
  632311
  466563
  41776
  532727
  439031
  457483
  597163
  735134
  476834
  477149
  450697
  568264
  459198
  471688
  479542
  439158
  462850
  573461
  624925
]
2.65 ms
(0.74%)
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
  41776
  159291
  439031
  439158
  450697
  457483
  459198
  462850
  466563
  471688
  476834
  477149
  479542
  493744
  497864
  530956
  531336
  532727
  539026
  539030
  541277
  541278
  544140
  547469
  548947
  550813
  559287
  564514
  568264
  568266
  568267
  573461
  575655
  576225
  584374
  586759
  586760
  592576
  597163
  624925
  632311
  634068
  643619
  651059
  656186
  660362
  726221
  735130
  735133
  735134
  735136
  735152
  735260
  752631
  801313
]
2.17 ms
(0.60%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen bottle"
]
2.13 ms
(0.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen bottle"
]
1.83 ms
(0.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen bottle"
]

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.