GET https://search.jues.net/search/embeds/6?q=first%20handjob

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
54.33 ms
(61.66%)
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
  401127
  421704
  424360
  445643
  475144
  489325
  498036
  500477
  504450
  506195
  507884
  512539
  513751
  515568
  516073
  523924
  526553
  527967
  537212
  537663
  540559
  545081
  565245
  566789
  566960
  567346
  576264
  591680
  595931
  599826
  600011
  600297
  603009
  609275
  618887
  628380
  633449
  634218
  637036
  643103
  646851
  653455
  667736
  677364
  678097
  680186
]
12.36 ms
(14.03%)
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:
[
  "first handjob"
  "first handjob"
  "first handjob"
  20
]
11.13 ms
(12.63%)
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
  576264
  677364
  475144
  424360
  401127
  445643
  566789
  565245
  637036
  421704
  591680
  643103
  646851
  600297
  513751
  537212
  667736
  540559
  567346
  489325
  678097
  680186
  634218
  633449
  507884
  516073
  628380
  504450
  545081
  618887
  595931
  515568
  506195
  527967
  653455
  599826
  512539
  603009
  500477
  537663
  498036
  526553
  566960
  609275
  523924
  600011
]
2.62 ms
(2.98%)
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
  401127
  421704
  424360
  445643
  475144
  489325
  498036
  500477
  504450
  506195
  507884
  512539
  513751
  515568
  516073
  523924
  526553
  527967
  537212
  537663
  540559
  545081
  565245
  566789
  566960
  567346
  576264
  591680
  595931
  599826
  600011
  600297
  603009
  609275
  618887
  628380
  633449
  634218
  637036
  643103
  646851
  653455
  667736
  677364
  678097
  680186
]
2.23 ms
(2.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "first handjob"
]
1.95 ms
(2.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.86 ms
(2.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "first дрочк член"
]
1.64 ms
(1.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "first дрочк член"
]

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.