GET https://search.jues.net/search/embeds?q=monster%20young%20skinny

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
230.40 ms
(68.07%)
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 young skinny"
  "monster young skinny"
  "monster young skinny"
  20
]
87.61 ms
(25.89%)
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
  390413
  396554
  399058
  409144
  414091
  414795
  415223
  421072
  427970
  430275
  434001
  445057
  446353
  447560
  453228
  463262
  511497
  514113
  521579
  536872
  540305
  540330
  552203
  553280
  565259
  571999
  580669
  584709
  597139
  597227
  597260
  598675
  606798
  622392
  624829
  627806
  628333
  628376
  628387
  628392
  628406
  637094
  637436
  642691
  645997
  647343
  693554
  702166
  704212
  720056
  733884
  741434
  785421
  788963
]
10.82 ms
(3.20%)
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
  788963
  396554
  741434
  540305
  445057
  693554
  624829
  637436
  704212
  414091
  552203
  453228
  399058
  421072
  446353
  598675
  785421
  622392
  463262
  536872
  702166
  414795
  571999
  390413
  430275
  597260
  415223
  597227
  628376
  597139
  628392
  733884
  447560
  511497
  565259
  427970
  409144
  720056
  584709
  642691
  628387
  628406
  606798
  637094
  521579
  647343
  645997
  514113
  580669
  627806
  434001
  628333
  553280
  540330
]
3.01 ms
(0.89%)
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
  390413
  396554
  399058
  409144
  414091
  414795
  415223
  421072
  427970
  430275
  434001
  445057
  446353
  447560
  453228
  463262
  511497
  514113
  521579
  536872
  540305
  540330
  552203
  553280
  565259
  571999
  580669
  584709
  597139
  597227
  597260
  598675
  606798
  622392
  624829
  627806
  628333
  628376
  628387
  628392
  628406
  637094
  637436
  642691
  645997
  647343
  693554
  702166
  704212
  720056
  733884
  741434
  785421
  788963
]
1.86 ms
(0.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "monster young skinny"
]
1.72 ms
(0.51%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "monster young худые"
]
1.39 ms
(0.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "monster young худые"
]

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.