GET https://search.jues.net/search/embeds?q=cassidy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
52.42 ms
(65.58%)
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
  30636
  382149
  386190
  388378
  395544
  405850
  414211
  429175
  432081
  451199
  507078
  507666
  522786
  527063
  578418
  603248
  610284
  623884
  631988
  642527
  647076
  660300
  660307
  671649
  692386
  727196
  731947
  760068
  760967
  786523
  787294
  792611
  804756
  806126
  809122
  814816
  815581
  816209
  820965
  821210
  822011
  822360
  822565
  822646
  822948
]
11.41 ms
(14.28%)
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
  30636
  671649
  631988
  623884
  822646
  787294
  806126
  382149
  809122
  660307
  727196
  578418
  660300
  760068
  804756
  760967
  814816
  610284
  786523
  731947
  522786
  822565
  820965
  821210
  792611
  647076
  388378
  815581
  822948
  816209
  692386
  642527
  386190
  429175
  822360
  822011
  451199
  603248
  527063
  395544
  414211
  405850
  432081
  507078
  507666
]
4.69 ms
(5.86%)
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:
[
  "cassidy"
  "cassidy"
  "cassidy"
  20
]
2.93 ms
(3.66%)
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
  30636
  382149
  386190
  388378
  395544
  405850
  414211
  429175
  432081
  451199
  507078
  507666
  522786
  527063
  578418
  603248
  610284
  623884
  631988
  642527
  647076
  660300
  660307
  671649
  692386
  727196
  731947
  760068
  760967
  786523
  787294
  792611
  804756
  806126
  809122
  814816
  815581
  816209
  820965
  821210
  822011
  822360
  822565
  822646
  822948
]
2.46 ms
(3.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cassidy"
]
2.17 ms
(2.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cassidy"
]
2.07 ms
(2.59%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cassidy"
]
1.78 ms
(2.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.