GET https://search.jues.net/search/embeds?q=mixed%20in

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
64.69 ms
(72.27%)
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
  93742
  338316
  390001
  408546
  410381
  410956
  413574
  420377
  427141
  427513
  433679
  450639
  461342
  469159
  485238
  486871
  486954
  489819
  504974
  508487
  509068
  537249
  552034
  573387
  576987
  580287
  581054
  585912
  592703
  593199
  593560
  607728
  613536
  616561
  622613
  639668
  641492
  641587
  648702
  674005
  709669
  761537
  770435
  802574
  815015
  816764
  823148
]
12.61 ms
(14.09%)
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
  338316
  593199
  622613
  770435
  802574
  93742
  485238
  674005
  815015
  450639
  581054
  639668
  408546
  427513
  433679
  410956
  580287
  641587
  413574
  552034
  593560
  607728
  616561
  420377
  816764
  823148
  613536
  641492
  592703
  761537
  427141
  509068
  648702
  709669
  461342
  504974
  469159
  585912
  576987
  390001
  489819
  486954
  537249
  508487
  573387
  410381
  486871
]
3.45 ms
(3.85%)
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:
[
  "mixed in"
  "mixed in"
  "mixed in"
  20
]
2.23 ms
(2.49%)
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
  93742
  338316
  390001
  408546
  410381
  410956
  413574
  420377
  427141
  427513
  433679
  450639
  461342
  469159
  485238
  486871
  486954
  489819
  504974
  508487
  509068
  537249
  552034
  573387
  576987
  580287
  581054
  585912
  592703
  593199
  593560
  607728
  613536
  616561
  622613
  639668
  641492
  641587
  648702
  674005
  709669
  761537
  770435
  802574
  815015
  816764
  823148
]
2.23 ms
(2.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mixed in"
]
1.50 ms
(1.68%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mixed"
]
1.50 ms
(1.68%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.29 ms
(1.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mixed"
]

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.