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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
73.83 ms
(73.02%)
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
  427452
  428420
  437759
  448426
  456354
  466311
  477809
  483626
  487380
  496833
  497700
  503334
  508755
  519905
  519907
  520625
  524098
  524826
  527987
  542061
  544530
  555432
  565536
  574701
  613286
  614755
  618367
  623827
  648653
  696794
  700886
  709204
  714172
  714330
  732090
  732781
  753159
  761522
  764206
  794774
  795840
  798676
  800940
  802186
  802190
  807488
  809333
  809883
  812802
  817991
  821543
  821776
  824433
]
13.48 ms
(13.34%)
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
  821776
  824433
  817991
  802190
  753159
  709204
  648653
  798676
  714172
  714330
  761522
  802186
  700886
  696794
  618367
  809333
  795840
  809883
  732090
  732781
  456354
  614755
  807488
  821543
  812802
  542061
  437759
  555432
  574701
  623827
  764206
  427452
  466311
  503334
  520625
  613286
  794774
  428420
  524826
  508755
  487380
  497700
  524098
  527987
  565536
  800940
  496833
  477809
  519905
  544530
  448426
  483626
  519907
]
3.33 ms
(3.29%)
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
  427452
  428420
  437759
  448426
  456354
  466311
  477809
  483626
  487380
  496833
  497700
  503334
  508755
  519905
  519907
  520625
  524098
  524826
  527987
  542061
  544530
  555432
  565536
  574701
  613286
  614755
  618367
  623827
  648653
  696794
  700886
  709204
  714172
  714330
  732090
  732781
  753159
  761522
  764206
  794774
  795840
  798676
  800940
  802186
  802190
  807488
  809333
  809883
  812802
  817991
  821543
  821776
  824433
]
2.72 ms
(2.69%)
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:
[
  "notice"
  "notice"
  "notice"
  20
]
2.40 ms
(2.38%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.33 ms
(2.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "notice"
]
1.63 ms
(1.61%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "notice"
]
1.39 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "notice"
]

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.