GET https://search.jues.net/search/embeds/2?q=solo%20milf%20dress

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
58.31 ms
(55.82%)
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
  469171
  472185
  483259
  489075
  495377
  495491
  523181
  526561
  535393
  546028
  547473
  547494
  564227
  584980
  601950
  603286
  603768
  604849
  604994
  605026
  605074
  605096
  605108
  605117
  605133
  605152
  605183
  605199
  605219
  605247
  605255
  618291
  660416
  669017
  669030
  669071
  669361
  675435
  675660
  675696
  695868
  755022
  760687
  807262
]
29.66 ms
(28.39%)
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:
[
  "solo milf dress"
  "solo milf dress"
  "solo milf dress"
  20
]
7.45 ms
(7.13%)
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
  605247
  618291
  807262
  755022
  760687
  601950
  483259
  526561
  495377
  495491
  584980
  546028
  669030
  669071
  695868
  669017
  604849
  603768
  605183
  605108
  605199
  469171
  489075
  535393
  605096
  472185
  564227
  675660
  660416
  605133
  605219
  605255
  605074
  605026
  604994
  605152
  547494
  675696
  669361
  523181
  547473
  605117
  675435
  603286
]
1.91 ms
(1.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.89 ms
(1.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "solo milf dress"
]
1.83 ms
(1.75%)
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
  469171
  472185
  483259
  489075
  495377
  495491
  523181
  526561
  535393
  546028
  547473
  547494
  564227
  584980
  601950
  603286
  603768
  604849
  604994
  605026
  605074
  605096
  605108
  605117
  605133
  605152
  605183
  605199
  605219
  605247
  605255
  618291
  660416
  669017
  669030
  669071
  669361
  675435
  675660
  675696
  695868
  755022
  760687
  807262
]
1.79 ms
(1.71%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло milf dress"
]
1.61 ms
(1.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "соло milf dress"
]

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.