GET https://search.jues.net/search/embeds?q=play%20games

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
65.10 ms
(64.65%)
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
  391717
  403074
  464989
  465033
  467684
  503032
  504080
  507670
  514800
  515805
  516514
  517340
  521017
  521294
  522114
  524534
  534814
  535808
  547371
  550556
  557106
  559790
  568679
  572701
  583098
  584819
  595963
  605065
  621351
  623484
  630476
  657545
  714508
  744750
  746523
  751094
  766448
  784755
  797000
  803807
  805413
  811150
  815194
  819879
  825681
]
12.92 ms
(12.83%)
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:
[
  "play games"
  "play games"
  "play games"
  20
]
9.48 ms
(9.42%)
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
  534814
  797000
  583098
  517340
  825681
  595963
  559790
  819879
  572701
  623484
  766448
  744750
  605065
  403074
  630476
  746523
  803807
  584819
  391717
  815194
  522114
  503032
  568679
  805413
  504080
  521017
  507670
  514800
  784755
  550556
  547371
  811150
  657545
  557106
  751094
  516514
  515805
  464989
  521294
  714508
  621351
  467684
  524534
  465033
  535808
]
4.26 ms
(4.23%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "play games"
]
3.04 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
  391717
  403074
  464989
  465033
  467684
  503032
  504080
  507670
  514800
  515805
  516514
  517340
  521017
  521294
  522114
  524534
  534814
  535808
  547371
  550556
  557106
  559790
  568679
  572701
  583098
  584819
  595963
  605065
  621351
  623484
  630476
  657545
  714508
  744750
  746523
  751094
  766448
  784755
  797000
  803807
  805413
  811150
  815194
  819879
  825681
]
2.27 ms
(2.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "play games"
]
1.93 ms
(1.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "play games"
]
1.70 ms
(1.69%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.