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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
74.18 ms
(68.02%)
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
  395913
  414315
  416751
  418121
  419200
  426290
  439052
  439059
  439924
  441442
  444851
  445883
  456244
  456478
  464804
  477021
  480399
  483341
  483715
  483735
  485304
  498623
  506787
  511973
  512749
  513992
  515440
  515956
  518597
  519346
  529338
  547764
  555847
  556680
  561995
  564541
  585454
  586838
  590263
  592402
  602165
  602409
  604513
  604790
  605015
  609097
  627361
  639208
  666355
  688581
  731663
  752700
  752704
  758779
]
18.61 ms
(17.07%)
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:
[
  "fuck my asshole"
  "fuck my asshole"
  "fuck my asshole"
  20
]
7.56 ms
(6.93%)
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
  555847
  556680
  758779
  627361
  511973
  439052
  464804
  513992
  586838
  731663
  639208
  439924
  441442
  426290
  605015
  585454
  592402
  604790
  602165
  483715
  418121
  666355
  602409
  752704
  456478
  445883
  547764
  483341
  480399
  477021
  529338
  515956
  439059
  456244
  483735
  515440
  419200
  506787
  512749
  688581
  485304
  498623
  561995
  590263
  395913
  444851
  564541
  519346
  416751
  609097
  752700
  604513
  414315
  518597
]
2.15 ms
(1.97%)
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
  395913
  414315
  416751
  418121
  419200
  426290
  439052
  439059
  439924
  441442
  444851
  445883
  456244
  456478
  464804
  477021
  480399
  483341
  483715
  483735
  485304
  498623
  506787
  511973
  512749
  513992
  515440
  515956
  518597
  519346
  529338
  547764
  555847
  556680
  561995
  564541
  585454
  586838
  590263
  592402
  602165
  602409
  604513
  604790
  605015
  609097
  627361
  639208
  666355
  688581
  731663
  752700
  752704
  758779
]
1.76 ms
(1.61%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fuck my asshole"
]
1.69 ms
(1.55%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс my asshole"
]
1.58 ms
(1.45%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(1.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс my 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.