GET https://search.jues.net/search/embeds?q=pussy%20fisting%20orgasm

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
64.07 ms
(59.60%)
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
  415874
  418132
  419609
  420866
  435136
  442510
  445745
  447315
  448077
  449940
  450557
  451358
  455015
  460115
  467875
  475420
  483103
  532727
  540915
  541043
  546987
  548153
  550940
  554930
  563943
  574090
  574391
  579344
  580121
  583347
  584183
  621496
  627162
  637741
  689074
  722390
  722395
  725602
  744408
  745681
  752767
  767462
  784236
  795012
  796939
  798243
  800131
  811125
  827326
]
25.63 ms
(23.84%)
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:
[
  "pussy fisting orgasm"
  "pussy fisting orgasm"
  "pussy fisting orgasm"
  20
]
8.69 ms
(8.09%)
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
  574090
  745681
  627162
  767462
  583347
  827326
  795012
  540915
  550940
  800131
  584183
  563943
  541043
  725602
  442510
  451358
  744408
  580121
  689074
  722390
  784236
  445745
  447315
  574391
  621496
  796939
  548153
  722395
  811125
  752767
  455015
  435136
  450557
  475420
  798243
  467875
  420866
  483103
  460115
  532727
  418132
  448077
  546987
  637741
  415874
  449940
  419609
  554930
  579344
]
2.43 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
  415874
  418132
  419609
  420866
  435136
  442510
  445745
  447315
  448077
  449940
  450557
  451358
  455015
  460115
  467875
  475420
  483103
  532727
  540915
  541043
  546987
  548153
  550940
  554930
  563943
  574090
  574391
  579344
  580121
  583347
  584183
  621496
  627162
  637741
  689074
  722390
  722395
  725602
  744408
  745681
  752767
  767462
  784236
  795012
  796939
  798243
  800131
  811125
  827326
]
1.99 ms
(1.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy фистинг orgasm"
]
1.73 ms
(1.61%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy fisting orgasm"
]
1.58 ms
(1.47%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.38 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy фистинг orgasm"
]

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.