GET https://search.jues.net/search/embeds?q=hobby%20teen

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
59.80 ms
(55.54%)
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
  385721
  447925
  453812
  457578
  549099
  549105
  557186
  568507
  568981
  568999
  569021
  569047
  569071
  569091
  569118
  569126
  569131
  569137
  569142
  569156
  569159
  569174
  569193
  569204
  569223
  576076
  588288
  592335
  603913
  606049
  606164
  606165
  606178
  606648
  606652
  618833
  629619
  692045
  710286
  752652
  753423
  766609
  807918
]
28.98 ms
(26.91%)
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:
[
  "hobby teen"
  "hobby teen"
  "hobby teen"
  20
]
8.89 ms
(8.26%)
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
  569142
  576076
  569118
  618833
  447925
  629619
  606652
  606049
  606178
  569071
  568981
  588288
  606164
  569047
  569204
  606165
  568999
  692045
  606648
  766609
  603913
  752652
  753423
  569174
  710286
  549099
  807918
  385721
  569021
  569137
  549105
  569193
  592335
  569126
  457578
  568507
  569131
  557186
  569159
  453812
  569223
  569091
  569156
]
3.07 ms
(2.85%)
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
  385721
  447925
  453812
  457578
  549099
  549105
  557186
  568507
  568981
  568999
  569021
  569047
  569071
  569091
  569118
  569126
  569131
  569137
  569142
  569156
  569159
  569174
  569193
  569204
  569223
  576076
  588288
  592335
  603913
  606049
  606164
  606165
  606178
  606648
  606652
  618833
  629619
  692045
  710286
  752652
  753423
  766609
  807918
]
2.05 ms
(1.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hobby teen"
]
1.88 ms
(1.75%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hobby teen"
]
1.50 ms
(1.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hobby teen"
]
1.49 ms
(1.39%)
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.