GET https://search.jues.net/search/embeds?q=toyboy%20mature

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
84.95 ms
(68.04%)
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
  398530
  398555
  409374
  419061
  425992
  443943
  468635
  477704
  477708
  480809
  482495
  483138
  483446
  489396
  490890
  490940
  491410
  502733
  502737
  502740
  503584
  505641
  506832
  510363
  514331
  516093
  518826
  518956
  524882
  528093
  551115
  678738
  710551
  744991
  756058
  766597
  770112
  772124
  773543
  779224
  779227
  781932
  781967
  786163
  786179
  804216
  806907
  818665
  819481
  826235
]
21.36 ms
(17.11%)
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:
[
  "toyboy mature"
  "toyboy mature"
  "toyboy mature"
  20
]
8.94 ms
(7.16%)
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
  744991
  818665
  756058
  804216
  781932
  710551
  490890
  398555
  786163
  766597
  773543
  518956
  781967
  826235
  483138
  398530
  779227
  806907
  409374
  770112
  502737
  443943
  819481
  772124
  786179
  483446
  779224
  468635
  489396
  502733
  505641
  490940
  506832
  678738
  477704
  491410
  528093
  482495
  503584
  551115
  425992
  518826
  480809
  516093
  502740
  477708
  514331
  510363
  524882
  419061
]
2.46 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
  398530
  398555
  409374
  419061
  425992
  443943
  468635
  477704
  477708
  480809
  482495
  483138
  483446
  489396
  490890
  490940
  491410
  502733
  502737
  502740
  503584
  505641
  506832
  510363
  514331
  516093
  518826
  518956
  524882
  528093
  551115
  678738
  710551
  744991
  756058
  766597
  770112
  772124
  773543
  779224
  779227
  781932
  781967
  786163
  786179
  804216
  806907
  818665
  819481
  826235
]
1.98 ms
(1.58%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "toyboy mature"
]
1.85 ms
(1.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "toyboy mature"
]
1.80 ms
(1.44%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.51 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "toyboy mature"
]

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.