GET https://search.jues.net/search/embeds?q=missionary%20hard%20sex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
77.26 ms
(48.11%)
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
  403808
  434009
  449454
  476623
  487557
  505584
  505639
  512970
  520323
  521374
  524094
  525241
  528748
  568332
  575684
  579507
  580449
  585175
  585214
  585222
  587617
  594271
  601678
  609930
  612161
  612169
  612240
  612281
  612289
  612298
  612311
  617783
  623254
  624990
  626858
  628956
  634699
  705230
  715113
  716920
  724054
  733184
  748406
  750820
  750940
  768952
  809813
  813669
  813703
]
64.68 ms
(40.28%)
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:
[
  "missionary hard sex"
  "missionary hard sex"
  "missionary hard sex"
  20
]
8.37 ms
(5.21%)
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
  716920
  705230
  585214
  748406
  579507
  612289
  585222
  634699
  575684
  733184
  809813
  813703
  612298
  580449
  612169
  612161
  434009
  612281
  813669
  724054
  612311
  594271
  768952
  750820
  715113
  750940
  449454
  403808
  609930
  521374
  568332
  585175
  587617
  623254
  617783
  612240
  487557
  601678
  626858
  524094
  520323
  528748
  624990
  476623
  505639
  628956
  525241
  512970
  505584
]
2.73 ms
(1.70%)
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
  403808
  434009
  449454
  476623
  487557
  505584
  505639
  512970
  520323
  521374
  524094
  525241
  528748
  568332
  575684
  579507
  580449
  585175
  585214
  585222
  587617
  594271
  601678
  609930
  612161
  612169
  612240
  612281
  612289
  612298
  612311
  617783
  623254
  624990
  626858
  628956
  634699
  705230
  715113
  716920
  724054
  733184
  748406
  750820
  750940
  768952
  809813
  813669
  813703
]
2.17 ms
(1.35%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "missionary hard секс"
]
2.14 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "missionary hard sex"
]
1.64 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "missionary hard секс"
]

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.