GET https://search.jues.net/search/embeds/2?q=coming

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
54.66 ms
(69.21%)
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
  461061
  464702
  466838
  481167
  491943
  495629
  499695
  500493
  518441
  524817
  525844
  527608
  531225
  532245
  533367
  534823
  535505
  540410
  548519
  554210
  559936
  564825
  576219
  581165
  581749
  587235
  598605
  599867
  599965
  600029
  600363
  630526
  631200
  641700
  646025
  646849
  651209
  667817
  687257
  687551
  696579
  793470
]
11.72 ms
(14.83%)
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
  793470
  481167
  495629
  525844
  499695
  491943
  500493
  524817
  581165
  559936
  581749
  687551
  466838
  531225
  533367
  534823
  554210
  667817
  587235
  464702
  535505
  548519
  564825
  576219
  646025
  687257
  696579
  651209
  630526
  631200
  461061
  540410
  646849
  598605
  599867
  600029
  641700
  599965
  600363
  532245
  518441
  527608
]
3.39 ms
(4.30%)
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:
[
  "coming"
  "coming"
  "coming"
  20
]
2.38 ms
(3.01%)
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
  461061
  464702
  466838
  481167
  491943
  495629
  499695
  500493
  518441
  524817
  525844
  527608
  531225
  532245
  533367
  534823
  535505
  540410
  548519
  554210
  559936
  564825
  576219
  581165
  581749
  587235
  598605
  599867
  599965
  600029
  600363
  630526
  631200
  641700
  646025
  646849
  651209
  667817
  687257
  687551
  696579
  793470
]
2.12 ms
(2.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "coming"
]
1.67 ms
(2.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "coming"
]
1.60 ms
(2.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(1.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "coming"
]

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.