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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
51.45 ms
(65.17%)
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
  364718
  445993
  461947
  462299
  467130
  478106
  478109
  483452
  484253
  487650
  494663
  494866
  500469
  503041
  504767
  506571
  513445
  517769
  532189
  534958
  535897
  537290
  544610
  545352
  552716
  553331
  562927
  566091
  579764
  586485
  590499
  591889
  607146
  607227
  617885
  621648
  630818
  656197
  780230
  803214
  828055
]
10.15 ms
(12.86%)
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:
[
  "hidden park"
  "hidden park"
  "hidden park"
  20
]
7.45 ms
(9.44%)
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
  504767
  462299
  534958
  566091
  617885
  544610
  494663
  537290
  494866
  562927
  484253
  552716
  780230
  656197
  487650
  532189
  579764
  591889
  483452
  630818
  828055
  478109
  803214
  513445
  461947
  535897
  553331
  545352
  621648
  506571
  503041
  364718
  478106
  445993
  590499
  467130
  500469
  586485
  607146
  607227
  517769
]
2.64 ms
(3.35%)
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
  364718
  445993
  461947
  462299
  467130
  478106
  478109
  483452
  484253
  487650
  494663
  494866
  500469
  503041
  504767
  506571
  513445
  517769
  532189
  534958
  535897
  537290
  544610
  545352
  552716
  553331
  562927
  566091
  579764
  586485
  590499
  591889
  607146
  607227
  617885
  621648
  630818
  656197
  780230
  803214
  828055
]
2.14 ms
(2.71%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hidden park"
]
1.79 ms
(2.27%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "скрыт парк природ"
]
1.68 ms
(2.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "скрыт парк природ"
]
1.65 ms
(2.09%)
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.