GET https://search.jues.net/search/embeds/3?q=monster%20and%20beauty

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
92.41 ms
(62.81%)
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
  416635
  444465
  454583
  477097
  511497
  514113
  521576
  530482
  532816
  533512
  535056
  536645
  540330
  541863
  553280
  565259
  580669
  583700
  597235
  599875
  599912
  600296
  604456
  608658
  613179
  617417
  627806
  628333
  628383
  628384
  628387
  628390
  628406
  632708
  633123
  634116
  637074
  641678
  642018
  642066
  642691
  645997
  666880
  677766
  678063
  678127
  680181
  680195
  680197
  687158
  689006
  702166
  733884
]
35.81 ms
(24.34%)
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:
[
  "monster and beauty"
  "monster and beauty"
  "monster and beauty"
  20
]
10.13 ms
(6.89%)
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
  733884
  444465
  511497
  532816
  533512
  535056
  680181
  702166
  678063
  678127
  677766
  689006
  641678
  642018
  642066
  642691
  599875
  628387
  628390
  628406
  599912
  634116
  632708
  454583
  608658
  604456
  530482
  536645
  541863
  565259
  687158
  645997
  600296
  628384
  597235
  633123
  477097
  583700
  514113
  680195
  666880
  680197
  580669
  628383
  617417
  627806
  416635
  521576
  540330
  628333
  637074
  613179
  553280
]
2.75 ms
(1.87%)
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
  416635
  444465
  454583
  477097
  511497
  514113
  521576
  530482
  532816
  533512
  535056
  536645
  540330
  541863
  553280
  565259
  580669
  583700
  597235
  599875
  599912
  600296
  604456
  608658
  613179
  617417
  627806
  628333
  628383
  628384
  628387
  628390
  628406
  632708
  633123
  634116
  637074
  641678
  642018
  642066
  642691
  645997
  666880
  677766
  678063
  678127
  680181
  680195
  680197
  687158
  689006
  702166
  733884
]
1.66 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "monster and beauty"
]
1.48 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "monster beauty"
]
1.28 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "monster beauty"
]

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.