GET https://search.jues.net/search/embeds?q=hand%20anal%20fisting

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
61.40 ms
(43.09%)
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
  394620
  427447
  428250
  440079
  441073
  441074
  444281
  447198
  448257
  448431
  455915
  456220
  456240
  462377
  471312
  475947
  479542
  483711
  492215
  500725
  515974
  534557
  534564
  535423
  554530
  555008
  590263
  593105
  597160
  600453
  619108
  629281
  636958
  637034
  639379
  641685
  641830
  641985
  642065
  723094
  735195
  735202
  745104
  745123
  745135
  765822
  786911
  787513
  791550
  792761
  797197
]
59.18 ms
(41.53%)
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:
[
  "hand anal fisting"
  "hand anal fisting"
  "hand anal fisting"
  20
]
10.62 ms
(7.45%)
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
  534564
  394620
  765822
  441073
  619108
  797197
  456220
  534557
  786911
  745123
  723094
  745135
  641685
  792761
  597160
  483711
  444281
  456240
  471312
  462377
  735202
  441074
  641985
  475947
  636958
  639379
  447198
  479542
  745104
  629281
  455915
  791550
  471695
  637034
  492215
  535423
  554530
  600453
  428250
  787513
  641830
  642065
  735195
  448431
  555008
  440079
  590263
  515974
  593105
  500725
  448257
  427447
]
4.90 ms
(3.44%)
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
  394620
  427447
  428250
  440079
  441073
  441074
  444281
  447198
  448257
  448431
  455915
  456220
  456240
  462377
  471312
  475947
  479542
  483711
  492215
  500725
  515974
  534557
  534564
  535423
  554530
  555008
  590263
  593105
  597160
  600453
  619108
  629281
  636958
  637034
  639379
  641685
  641830
  641985
  642065
  723094
  735195
  735202
  745104
  745123
  745135
  765822
  786911
  787513
  791550
  792761
  797197
]
1.74 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hand anal fisting"
]
1.67 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hand анал фистинг"
]
1.57 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.41 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hand анал фистинг"
]

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.