GET https://search.jues.net/search/embeds?q=milks%20boobs

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.88 ms
(71.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milks boobs"
]
58.72 ms
(19.84%)
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
  133598
  173865
  192223
  399178
  409233
  443173
  446044
  451526
  459247
  474154
  481313
  492393
  504791
  518192
  530512
  532673
  532695
  545922
  546870
  568110
  581487
  581620
  590138
  590150
  596908
  601618
  605156
  608938
  618610
  668971
  673862
  698158
  721062
  731177
  746138
  756237
  763024
  774319
  775268
  797069
  801210
  804377
  808132
  824740
  828486
]
10.10 ms
(3.41%)
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:
[
  "milks boobs"
  "milks boobs"
  "milks boobs"
  20
]
6.57 ms
(2.22%)
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
  504791
  192223
  828486
  797069
  774319
  173865
  824740
  545922
  698158
  808132
  409233
  532673
  443173
  532695
  568110
  763024
  804377
  746138
  756237
  459247
  601618
  608938
  668971
  721062
  399178
  446044
  518192
  605156
  590138
  775268
  801210
  731177
  133598
  581487
  546870
  673862
  492393
  474154
  530512
  618610
  451526
  481313
  596908
  581620
  590150
]
2.62 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
  133598
  173865
  192223
  399178
  409233
  443173
  446044
  451526
  459247
  474154
  481313
  492393
  504791
  518192
  530512
  532673
  532695
  545922
  546870
  568110
  581487
  581620
  590138
  590150
  596908
  601618
  605156
  608938
  618610
  668971
  673862
  698158
  721062
  731177
  746138
  756237
  763024
  774319
  775268
  797069
  801210
  804377
  808132
  824740
  828486
]
2.10 ms
(0.71%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milks boobs"
]
1.54 ms
(0.52%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(0.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milks boobs"
]

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.