GET https://search.jues.net/search/embeds?q=mom%20enjoy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
53.24 ms
(50.36%)
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
  407324
  414184
  492309
  498030
  512960
  522883
  525024
  540153
  540155
  576725
  590719
  623262
  624290
  627728
  631243
  641079
  647932
  704928
  707356
  720925
  734038
  739125
  752135
  769595
  774740
  775833
  785423
  785479
  788157
  800206
  800208
  803328
  805558
  809479
  810669
  810992
  814736
  815790
  818466
  818882
  818895
  820743
  822278
  824563
]
32.44 ms
(30.69%)
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:
[
  "mom enjoy"
  "mom enjoy"
  "mom enjoy"
  20
]
9.48 ms
(8.97%)
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
  818882
  815790
  788157
  822278
  818466
  752135
  769595
  818895
  824563
  525024
  627728
  803328
  774740
  785479
  800206
  775833
  800208
  707356
  704928
  810992
  512960
  820743
  810669
  739125
  720925
  407324
  814736
  492309
  576725
  631243
  809479
  641079
  734038
  785423
  414184
  590719
  805558
  522883
  624290
  540155
  498030
  647932
  623262
  540153
]
2.59 ms
(2.45%)
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
  407324
  414184
  492309
  498030
  512960
  522883
  525024
  540153
  540155
  576725
  590719
  623262
  624290
  627728
  631243
  641079
  647932
  704928
  707356
  720925
  734038
  739125
  752135
  769595
  774740
  775833
  785423
  785479
  788157
  800206
  800208
  803328
  805558
  809479
  810669
  810992
  814736
  815790
  818466
  818882
  818895
  820743
  822278
  824563
]
2.16 ms
(2.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom enjoy"
]
2.07 ms
(1.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom enjoy"
]
1.92 ms
(1.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom enjoy"
]
1.80 ms
(1.71%)
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.