GET https://search.jues.net/search/embeds?q=camping%20fuck

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
74.79 ms
(67.62%)
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
  404552
  417283
  429585
  430572
  435016
  448213
  458334
  488995
  522677
  522864
  523950
  535060
  554751
  555874
  575125
  577474
  579681
  581405
  588494
  589391
  591446
  608946
  609063
  609066
  627886
  632788
  634696
  644764
  645043
  647999
  713305
  715018
  719901
  736483
  738695
  741587
  765464
  777294
  777589
  785204
  789608
  792768
  792782
  805178
  810338
  819374
]
18.34 ms
(16.58%)
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:
[
  "camping fuck"
  "camping fuck"
  "camping fuck"
  20
]
8.48 ms
(7.67%)
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
  810338
  741587
  608946
  789608
  647999
  609063
  819374
  792782
  738695
  792768
  777589
  777294
  634696
  632788
  719901
  805178
  579681
  765464
  645043
  627886
  715018
  736483
  581405
  575125
  591446
  554751
  417283
  404552
  429585
  713305
  609066
  785204
  522677
  589391
  458334
  435016
  555874
  535060
  430572
  644764
  588494
  448213
  577474
  522864
  488995
  523950
]
2.50 ms
(2.26%)
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
  404552
  417283
  429585
  430572
  435016
  448213
  458334
  488995
  522677
  522864
  523950
  535060
  554751
  555874
  575125
  577474
  579681
  581405
  588494
  589391
  591446
  608946
  609063
  609066
  627886
  632788
  634696
  644764
  645043
  647999
  713305
  715018
  719901
  736483
  738695
  741587
  765464
  777294
  777589
  785204
  789608
  792768
  792782
  805178
  810338
  819374
]
1.74 ms
(1.57%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "camping секс"
]
1.69 ms
(1.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "camping fuck"
]
1.67 ms
(1.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "camping секс"
]
1.40 ms
(1.26%)
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.