GET https://search.jues.net/search/embeds?q=long%20boots

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
71.58 ms
(72.69%)
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
  397834
  426426
  431452
  461699
  510780
  515418
  520816
  523928
  527904
  560281
  569034
  575315
  590406
  591065
  591993
  611683
  630393
  630887
  656886
  697917
  712882
  732889
  734639
  734679
  740665
  742305
  743908
  745074
  746052
  757562
  760768
  767984
  770200
  780788
  781645
  787073
  788974
  791694
  799638
  801080
  801268
  809087
  810499
  819043
  828310
  828743
  828851
]
8.86 ms
(8.99%)
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
  426426
  780788
  760768
  828851
  712882
  828743
  734679
  801080
  828310
  630393
  740665
  809087
  732889
  611683
  810499
  791694
  799638
  745074
  757562
  734639
  746052
  801268
  781645
  767984
  397834
  575315
  697917
  742305
  788974
  819043
  523928
  591993
  787073
  743908
  515418
  656886
  590406
  770200
  461699
  510780
  560281
  630887
  431452
  527904
  520816
  569034
  591065
]
8.82 ms
(8.96%)
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:
[
  "long boots"
  "long boots"
  "long boots"
  20
]
2.49 ms
(2.53%)
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
  397834
  426426
  431452
  461699
  510780
  515418
  520816
  523928
  527904
  560281
  569034
  575315
  590406
  591065
  591993
  611683
  630393
  630887
  656886
  697917
  712882
  732889
  734639
  734679
  740665
  742305
  743908
  745074
  746052
  757562
  760768
  767984
  770200
  780788
  781645
  787073
  788974
  791694
  799638
  801080
  801268
  809087
  810499
  819043
  828310
  828743
  828851
]
2.15 ms
(2.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "long boots"
]
1.65 ms
(1.67%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "длинные boots"
]
1.50 ms
(1.53%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.42 ms
(1.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "длинные boots"
]

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.