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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
83.37 ms
(70.63%)
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
  385112
  385257
  387039
  391945
  396742
  397340
  404693
  409506
  414342
  414651
  421234
  423320
  426551
  427508
  428679
  434309
  445661
  446856
  449180
  451372
  467118
  472147
  484283
  484980
  486407
  493206
  494231
  498623
  506125
  507284
  508807
  509802
  512749
  513992
  518147
  522870
  528474
  534553
  545245
  555582
  558175
  584301
  590802
  591736
  599726
  606816
  609885
  639208
  642022
  688581
  695178
  725120
]
15.29 ms
(12.96%)
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:
[
  "hairy asshole fuck"
  "hairy asshole fuck"
  "hairy asshole fuck"
  20
]
10.74 ms
(9.10%)
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
  518147
  590802
  534553
  513992
  555582
  639208
  506125
  609885
  606816
  391945
  528474
  414651
  725120
  545245
  385257
  397340
  493206
  414342
  446856
  695178
  423320
  445661
  484980
  472147
  558175
  642022
  494231
  467118
  404693
  396742
  387039
  409506
  512749
  688581
  591736
  498623
  427508
  449180
  508807
  484283
  486407
  507284
  451372
  522870
  428679
  599726
  385112
  421234
  584301
  434309
  426551
  509802
]
2.42 ms
(2.05%)
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
  385112
  385257
  387039
  391945
  396742
  397340
  404693
  409506
  414342
  414651
  421234
  423320
  426551
  427508
  428679
  434309
  445661
  446856
  449180
  451372
  467118
  472147
  484283
  484980
  486407
  493206
  494231
  498623
  506125
  507284
  508807
  509802
  512749
  513992
  518147
  522870
  528474
  534553
  545245
  555582
  558175
  584301
  590802
  591736
  599726
  606816
  609885
  639208
  642022
  688581
  695178
  725120
]
1.86 ms
(1.58%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy asshole fuck"
]
1.65 ms
(1.40%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая asshole секс"
]
1.23 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "волосатая asshole секс"
]

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.