GET https://search.jues.net/search/embeds/2?q=first%20video

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
63.23 ms
(62.54%)
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
  446993
  455897
  456572
  457809
  460335
  500766
  502480
  513344
  515030
  521858
  525921
  528999
  529092
  535251
  558496
  561851
  567326
  580623
  597282
  598805
  601444
  613035
  615487
  620468
  621419
  621958
  624122
  624430
  625437
  625985
  639222
  669343
  678698
  687453
  687896
  699274
  708301
  708919
  710202
  712560
  721073
  725313
  733106
  737240
  760461
  761970
  778180
  781579
  781950
  798948
  804796
  808153
  810698
  823720
  824227
  824349
]
16.70 ms
(16.51%)
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:
[
  "first video"
  "first video"
  "first video"
  20
]
11.82 ms
(11.69%)
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
  824349
  725313
  781579
  528999
  669343
  620468
  712560
  613035
  615487
  778180
  761970
  824227
  823720
  760461
  737240
  781950
  708301
  708919
  621958
  625985
  699274
  808153
  687896
  687453
  457809
  558496
  598805
  639222
  621419
  446993
  455897
  515030
  678698
  500766
  535251
  567326
  710202
  561851
  798948
  804796
  733106
  460335
  513344
  521858
  529092
  580623
  601444
  810698
  721073
  456572
  502480
  624122
  525921
  624430
  625437
  597282
]
2.45 ms
(2.42%)
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
  446993
  455897
  456572
  457809
  460335
  500766
  502480
  513344
  515030
  521858
  525921
  528999
  529092
  535251
  558496
  561851
  567326
  580623
  597282
  598805
  601444
  613035
  615487
  620468
  621419
  621958
  624122
  624430
  625437
  625985
  639222
  669343
  678698
  687453
  687896
  699274
  708301
  708919
  710202
  712560
  721073
  725313
  733106
  737240
  760461
  761970
  778180
  781579
  781950
  798948
  804796
  808153
  810698
  823720
  824227
  824349
]
2.06 ms
(2.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "first video"
]
2.01 ms
(1.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(1.52%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "first video"
]
1.31 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "first video"
]

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.