GET https://search.jues.net/search/embeds/2?q=i%20need

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
85.27 ms
(78.41%)
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
  425552
  431749
  444316
  445988
  450495
  457435
  461854
  464721
  467598
  484295
  484618
  488240
  488359
  489612
  490864
  498355
  499159
  500525
  505433
  508429
  508474
  514676
  522831
  524848
  534568
  546478
  567623
  578445
  581532
  588991
  605455
  614768
  616760
  618982
  622454
  623468
  623472
  623972
  627638
  642227
  644015
  660013
  671487
  678893
  678896
  696223
  697000
  711355
  713305
  715020
  717606
  724711
  742791
  749979
  758408
  778888
  780373
  781063
  787455
  794083
  812169
  825710
]
10.66 ms
(9.80%)
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
  467598
  488240
  450495
  514676
  534568
  567623
  614768
  464721
  445988
  616760
  717606
  488359
  508429
  623472
  490864
  444316
  578445
  499159
  780373
  546478
  715020
  711355
  742791
  825710
  696223
  431749
  588991
  644015
  724711
  781063
  671487
  794083
  787455
  623468
  524848
  713305
  484295
  498355
  678896
  623972
  489612
  522831
  461854
  581532
  618982
  508474
  622454
  642227
  778888
  697000
  812169
  749979
  758408
  425552
  505433
  500525
  678893
  605455
  660013
  457435
  484618
  627638
]
3.91 ms
(3.60%)
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:
[
  "i need"
  "i need"
  "i need"
  20
]
2.20 ms
(2.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.96 ms
(1.80%)
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
  425552
  431749
  444316
  445988
  450495
  457435
  461854
  464721
  467598
  484295
  484618
  488240
  488359
  489612
  490864
  498355
  499159
  500525
  505433
  508429
  508474
  514676
  522831
  524848
  534568
  546478
  567623
  578445
  581532
  588991
  605455
  614768
  616760
  618982
  622454
  623468
  623472
  623972
  627638
  642227
  644015
  660013
  671487
  678893
  678896
  696223
  697000
  711355
  713305
  715020
  717606
  724711
  742791
  749979
  758408
  778888
  780373
  781063
  787455
  794083
  812169
  825710
]
1.94 ms
(1.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "i need"
]
1.50 ms
(1.38%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "i need"
]
1.30 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "i need"
]

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.