GET https://search.jues.net/search/embeds?q=tied%20and%20fucked

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
62.80 ms
(57.71%)
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
  417955
  426177
  428250
  429668
  435702
  448498
  465869
  478832
  479345
  484431
  488030
  489621
  494999
  496429
  511478
  513573
  521092
  522272
  522757
  542754
  543552
  546784
  559140
  569778
  569779
  570919
  570927
  570930
  579941
  604729
  637630
  703687
  704999
  706457
  716744
  764500
  765752
  767042
  783237
  784286
  794971
  794976
  794993
  795919
  797110
  798200
  800125
  802947
  816768
  817168
  825781
]
28.23 ms
(25.94%)
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:
[
  "tied and fucked"
  "tied and fucked"
  "tied and fucked"
  20
]
7.71 ms
(7.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
  637630
  570930
  703687
  484431
  569779
  579941
  429668
  569778
  559140
  478832
  522757
  716744
  795919
  570927
  511478
  543552
  494999
  816768
  794976
  817168
  794971
  767042
  704999
  570919
  798200
  825781
  546784
  604729
  794993
  800125
  426177
  465869
  784286
  802947
  764500
  706457
  479345
  435702
  521092
  428250
  783237
  417955
  489621
  765752
  797110
  496429
  448498
  522272
  542754
  488030
  513573
]
2.85 ms
(2.62%)
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
  417955
  426177
  428250
  429668
  435702
  448498
  465869
  478832
  479345
  484431
  488030
  489621
  494999
  496429
  511478
  513573
  521092
  522272
  522757
  542754
  543552
  546784
  559140
  569778
  569779
  570919
  570927
  570930
  579941
  604729
  637630
  703687
  704999
  706457
  716744
  764500
  765752
  767042
  783237
  784286
  794971
  794976
  794993
  795919
  797110
  798200
  800125
  802947
  816768
  817168
  825781
]
2.14 ms
(1.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "tied and fucked"
]
1.80 ms
(1.65%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(1.58%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "tied fucked"
]
1.57 ms
(1.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "tied fucked"
]

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.