GET https://search.jues.net/search/embeds?q=role%20play

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
58.39 ms
(69.29%)
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
  416685
  446595
  446629
  457554
  457804
  458815
  462257
  463305
  464960
  473415
  483957
  503369
  509346
  512377
  519771
  522663
  529453
  533483
  541563
  545900
  558693
  578680
  582531
  603403
  636649
  644849
  674152
  679045
  692732
  696430
  710504
  721112
  721334
  763569
  772904
  775075
  780703
  784382
  805364
  806733
  807403
  809974
  811194
  812317
  819645
  824920
]
7.68 ms
(9.12%)
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
  545900
  775075
  772904
  636649
  784382
  819645
  674152
  811194
  824920
  541563
  807403
  780703
  809974
  812317
  763569
  805364
  509346
  692732
  458815
  416685
  710504
  721112
  721334
  462257
  457804
  483957
  473415
  533483
  696430
  806733
  446595
  644849
  578680
  463305
  464960
  446629
  603403
  519771
  503369
  522663
  558693
  582531
  512377
  529453
  679045
  457554
]
7.67 ms
(9.10%)
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:
[
  "role play"
  "role play"
  "role play"
  20
]
3.73 ms
(4.42%)
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
  416685
  446595
  446629
  457554
  457804
  458815
  462257
  463305
  464960
  473415
  483957
  503369
  509346
  512377
  519771
  522663
  529453
  533483
  541563
  545900
  558693
  578680
  582531
  603403
  636649
  644849
  674152
  679045
  692732
  696430
  710504
  721112
  721334
  763569
  772904
  775075
  780703
  784382
  805364
  806733
  807403
  809974
  811194
  812317
  819645
  824920
]
2.04 ms
(2.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "role play"
]
1.82 ms
(2.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "role play"
]
1.50 ms
(1.79%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(1.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "role play"
]

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.