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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
91.39 ms
(72.26%)
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
  538868
  538915
  541337
  541586
  541774
  541885
  542189
  542482
  542798
  544281
  550589
  558428
  562842
  562848
  566011
  566485
  574603
  580255
  583851
  584008
  586015
  590919
  592422
  596336
  601846
  608040
  609208
  621025
  628170
  648598
  650363
  652187
  652252
  652547
  653192
  669570
  671724
  672717
  677712
  678419
  687130
  693059
  694192
  694194
  694195
  694197
  694563
  695278
  695941
  695948
  697282
  697354
  697369
  698513
  699694
  699755
  706610
  706946
  712722
  717947
  722197
]
14.86 ms
(11.75%)
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 retro"
  "asian retro"
  "asian retro"
  20
]
9.05 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
  566485
  694195
  694197
  672717
  652252
  722197
  621025
  694194
  653192
  706610
  558428
  678419
  697282
  574603
  648598
  671724
  609208
  706946
  590919
  566011
  698513
  608040
  541586
  695941
  717947
  538868
  550589
  687130
  695278
  542482
  697354
  693059
  699755
  652187
  712722
  694192
  694563
  695948
  697369
  652547
  669570
  592422
  650363
  584008
  699694
  562848
  586015
  562842
  541337
  538915
  542798
  580255
  628170
  583851
  596336
  544281
  541885
  541774
  542189
  601846
  677712
]
2.92 ms
(2.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "asian retro"
]
2.85 ms
(2.25%)
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
  538868
  538915
  541337
  541586
  541774
  541885
  542189
  542482
  542798
  544281
  550589
  558428
  562842
  562848
  566011
  566485
  574603
  580255
  583851
  584008
  586015
  590919
  592422
  596336
  601846
  608040
  609208
  621025
  628170
  648598
  650363
  652187
  652252
  652547
  653192
  669570
  671724
  672717
  677712
  678419
  687130
  693059
  694192
  694194
  694195
  694197
  694563
  695278
  695941
  695948
  697282
  697354
  697369
  698513
  699694
  699755
  706610
  706946
  712722
  717947
  722197
]
2.06 ms
(1.63%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(1.34%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "азиатк ретр"
]
1.65 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "азиатк ретр"
]

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.