GET https://search.jues.net/search/embeds?q=asian%20love

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
64.83 ms
(67.49%)
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
  386794
  387937
  391186
  391358
  394376
  423027
  423039
  424946
  429479
  431038
  450735
  460211
  460474
  463710
  469802
  473100
  491248
  494432
  499042
  500679
  502779
  508237
  516812
  517687
  539576
  542294
  550778
  558335
  582363
  584336
  585761
  593506
  614851
  625360
  628912
  630192
  632084
  644363
  645593
  658215
  665930
  686997
  687130
  706945
  706949
  747954
  748675
  763068
  771990
  772394
  784161
  787950
  800514
  812083
  815275
]
13.41 ms
(13.96%)
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:
[
  "asian love"
  "asian love"
  "asian love"
  20
]
8.99 ms
(9.36%)
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
  386794
  391358
  516812
  500679
  784161
  460474
  391186
  539576
  630192
  772394
  473100
  582363
  706949
  644363
  494432
  450735
  593506
  585761
  584336
  771990
  463710
  469802
  706945
  632084
  499042
  628912
  658215
  625360
  614851
  645593
  763068
  394376
  424946
  542294
  686997
  687130
  423027
  423039
  429479
  508237
  748675
  665930
  787950
  747954
  550778
  800514
  460211
  431038
  812083
  491248
  517687
  558335
  815275
  502779
  387937
]
2.49 ms
(2.59%)
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
  386794
  387937
  391186
  391358
  394376
  423027
  423039
  424946
  429479
  431038
  450735
  460211
  460474
  463710
  469802
  473100
  491248
  494432
  499042
  500679
  502779
  508237
  516812
  517687
  539576
  542294
  550778
  558335
  582363
  584336
  585761
  593506
  614851
  625360
  628912
  630192
  632084
  644363
  645593
  658215
  665930
  686997
  687130
  706945
  706949
  747954
  748675
  763068
  771990
  772394
  784161
  787950
  800514
  812083
  815275
]
1.95 ms
(2.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "asian love"
]
1.63 ms
(1.70%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "азиатк love"
]
1.46 ms
(1.52%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.30 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "азиатк love"
]

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.