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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
113.26 ms
(69.95%)
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
  383367
  389458
  394447
  395531
  395560
  396934
  396962
  397023
  412261
  412262
  413090
  421838
  429675
  435934
  446284
  446297
  446306
  446313
  446625
  453013
  453721
  462322
  476276
  484775
  486902
  486915
  486958
  492137
  506824
  518944
  518954
  521807
  523905
  524286
  525154
  526181
  527017
  528355
  531935
  532001
  537126
  547601
  552762
  559048
  565730
  624003
  644027
  664975
  726403
  731204
  732358
  746638
  782153
  796202
  811263
]
29.63 ms
(18.30%)
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:
[
  "son fuck mommy"
  "son fuck mommy"
  "son fuck mommy"
  20
]
9.21 ms
(5.69%)
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
  532001
  732358
  746638
  396962
  397023
  644027
  531935
  396934
  394447
  726403
  518954
  811263
  552762
  664975
  782153
  476276
  383367
  518944
  526181
  523905
  446284
  395560
  524286
  446625
  446297
  796202
  446306
  731204
  453013
  395531
  547601
  565730
  421838
  492137
  559048
  527017
  486902
  389458
  429675
  537126
  506824
  446313
  413090
  486958
  486915
  435934
  484775
  624003
  412262
  462322
  528355
  412261
  453721
  521807
  525154
]
2.72 ms
(1.68%)
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
  383367
  389458
  394447
  395531
  395560
  396934
  396962
  397023
  412261
  412262
  413090
  421838
  429675
  435934
  446284
  446297
  446306
  446313
  446625
  453013
  453721
  462322
  476276
  484775
  486902
  486915
  486958
  492137
  506824
  518944
  518954
  521807
  523905
  524286
  525154
  526181
  527017
  528355
  531935
  532001
  537126
  547601
  552762
  559048
  565730
  624003
  644027
  664975
  726403
  731204
  732358
  746638
  782153
  796202
  811263
]
1.91 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.91 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "son fuck mommy"
]
1.73 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "son секс mommy"
]
1.55 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "son секс mommy"
]

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.