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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
67.86 ms
(73.11%)
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
  566
  32637
  78824
  143515
  185567
  396507
  396588
  396606
  396706
  410353
  415435
  418399
  418448
  418450
  418451
  418452
  425477
  435882
  445601
  457165
  457401
  475231
  475280
  481664
  481675
  491239
  501480
  504980
  520029
  543005
  587598
  592728
  593157
  599987
  603735
  604490
  604960
  605553
  605617
  633077
  720249
  720295
  728887
  800228
  828871
]
11.43 ms
(12.31%)
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
  828871
  566
  185567
  633077
  143515
  728887
  445601
  593157
  418451
  457401
  800228
  475231
  78824
  396507
  396706
  410353
  418452
  491239
  435882
  504980
  396606
  418448
  720295
  604490
  415435
  32637
  396588
  418450
  425477
  603735
  520029
  720249
  481664
  475280
  605617
  418399
  457165
  587598
  501480
  592728
  605553
  481675
  604960
  543005
  599987
]
4.68 ms
(5.05%)
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:
[
  "sessions"
  "sessions"
  "sessions"
  20
]
2.26 ms
(2.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sessions"
]
1.88 ms
(2.03%)
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
  566
  32637
  78824
  143515
  185567
  396507
  396588
  396606
  396706
  410353
  415435
  418399
  418448
  418450
  418451
  418452
  425477
  435882
  445601
  457165
  457401
  475231
  475280
  481664
  481675
  491239
  501480
  504980
  520029
  543005
  587598
  592728
  593157
  599987
  603735
  604490
  604960
  605553
  605617
  633077
  720249
  720295
  728887
  800228
  828871
]
1.82 ms
(1.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(1.72%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "sessions"
]
1.28 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "sessions"
]

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.