GET https://search.jues.net/search/embeds/4?q=bed%20hidden

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
77.94 ms
(68.30%)
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
  409001
  426998
  432631
  432650
  440767
  457523
  458883
  461116
  465173
  468957
  469473
  470089
  474777
  474782
  481177
  483598
  487067
  489061
  491119
  492329
  492670
  493163
  495712
  496119
  496959
  499407
  502858
  504137
  504141
  504768
  508217
  511040
  522362
  523253
  525358
  525753
  528144
  528379
  529236
  547993
  554812
  566196
  575289
  582449
  585797
  587884
  590974
  591158
  598569
  601229
  603594
  606837
  617234
  617641
  623678
  623736
  623883
  624005
  628273
  637404
]
14.32 ms
(12.55%)
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
  522362
  525358
  483598
  487067
  492670
  499407
  426998
  489061
  623736
  623883
  468957
  504141
  504137
  495712
  511040
  491119
  409001
  502858
  481177
  547993
  575289
  591158
  603594
  432631
  461116
  590974
  601229
  529236
  554812
  440767
  508217
  525753
  585797
  598569
  587884
  457523
  628273
  617641
  624005
  432650
  465173
  458883
  528379
  474782
  496959
  528144
  492329
  469473
  582449
  496119
  504768
  623678
  566196
  474777
  470089
  606837
  617234
  637404
  523253
  493163
]
11.89 ms
(10.42%)
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:
[
  "bed hidden"
  "bed hidden"
  "bed hidden"
  20
]
2.61 ms
(2.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
  409001
  426998
  432631
  432650
  440767
  457523
  458883
  461116
  465173
  468957
  469473
  470089
  474777
  474782
  481177
  483598
  487067
  489061
  491119
  492329
  492670
  493163
  495712
  496119
  496959
  499407
  502858
  504137
  504141
  504768
  508217
  511040
  522362
  523253
  525358
  525753
  528144
  528379
  529236
  547993
  554812
  566196
  575289
  582449
  585797
  587884
  590974
  591158
  598569
  601229
  603594
  606837
  617234
  617641
  623678
  623736
  623883
  624005
  628273
  637404
]
2.07 ms
(1.81%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.98 ms
(1.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bed hidden"
]
1.78 ms
(1.56%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "постел скрыт"
]
1.52 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.