GET https://search.jues.net/search/embeds/2?q=mom%20fuck%20party

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
100.93 ms
(62.08%)
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
  401919
  404925
  424695
  432751
  469030
  472750
  492760
  494430
  500463
  519548
  520448
  526060
  526104
  528698
  530863
  532079
  532676
  533350
  535016
  543419
  544800
  550221
  553912
  568763
  570840
  571018
  572872
  582277
  582540
  583331
  583370
  584737
  586652
  590505
  597240
  598204
  604094
  604409
  611558
  612431
  619468
  622044
  623380
  634472
  634487
  637746
  640022
  641141
  643523
  643935
  647932
  648853
  656862
  662137
  703492
  806078
  813759
  814784
  815490
  820995
]
43.94 ms
(27.02%)
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 fuck party"
  "mom fuck party"
  "mom fuck party"
  20
]
9.88 ms
(6.07%)
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
  528698
  656862
  643935
  637746
  622044
  519548
  820995
  572872
  583370
  584737
  553912
  550221
  586652
  703492
  526060
  530863
  568763
  806078
  814784
  604094
  494430
  815490
  583331
  813759
  619468
  424695
  500463
  532079
  570840
  640022
  404925
  590505
  634487
  641141
  643523
  571018
  612431
  604409
  598204
  533350
  532676
  520448
  492760
  469030
  648853
  582540
  634472
  662137
  401919
  544800
  647932
  623380
  432751
  582277
  611558
  535016
  526104
  472750
  543419
  597240
]
2.21 ms
(1.36%)
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
  401919
  404925
  424695
  432751
  469030
  472750
  492760
  494430
  500463
  519548
  520448
  526060
  526104
  528698
  530863
  532079
  532676
  533350
  535016
  543419
  544800
  550221
  553912
  568763
  570840
  571018
  572872
  582277
  582540
  583331
  583370
  584737
  586652
  590505
  597240
  598204
  604094
  604409
  611558
  612431
  619468
  622044
  623380
  634472
  634487
  637746
  640022
  641141
  643523
  643935
  647932
  648853
  656862
  662137
  703492
  806078
  813759
  814784
  815490
  820995
]
1.55 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom секс party"
]
1.39 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom fuck party"
]
1.26 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom секс party"
]

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.