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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
77.90 ms
(65.09%)
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
  154195
  420700
  426696
  428647
  449086
  473533
  488796
  489579
  492906
  493788
  496725
  499942
  504661
  507031
  509598
  510938
  511856
  518326
  531351
  537377
  553517
  555131
  563350
  567062
  567860
  568310
  568603
  571349
  575699
  580403
  582576
  583180
  589972
  598923
  600700
  601358
  603124
  605274
  605867
  613791
  617633
  621252
  624095
  624755
  624779
  687299
  704615
  770395
  774771
  781354
  799212
  803600
  806327
  806385
]
21.27 ms
(17.77%)
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:
[
  "pretty solo"
  "pretty solo"
  "pretty solo"
  20
]
9.98 ms
(8.34%)
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
  507031
  580403
  583180
  555131
  568310
  575699
  687299
  582576
  598923
  600700
  605274
  781354
  803600
  770395
  799212
  806385
  420700
  428647
  154195
  492906
  496725
  509598
  518326
  568603
  553517
  704615
  613791
  806327
  426696
  488796
  489579
  499942
  473533
  510938
  511856
  567062
  563350
  567860
  589972
  601358
  624755
  774771
  537377
  493788
  571349
  449086
  621252
  504661
  605867
  617633
  531351
  603124
  624095
  624779
]
3.36 ms
(2.81%)
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
  154195
  420700
  426696
  428647
  449086
  473533
  488796
  489579
  492906
  493788
  496725
  499942
  504661
  507031
  509598
  510938
  511856
  518326
  531351
  537377
  553517
  555131
  563350
  567062
  567860
  568310
  568603
  571349
  575699
  580403
  582576
  583180
  589972
  598923
  600700
  601358
  603124
  605274
  605867
  613791
  617633
  621252
  624095
  624755
  624779
  687299
  704615
  770395
  774771
  781354
  799212
  803600
  806327
  806385
]
1.91 ms
(1.60%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pretty соло"
]
1.90 ms
(1.59%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(1.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pretty solo"
]
1.55 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pretty соло"
]

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.