GET https://search.jues.net/search/embeds/3?q=long%20feet

Query Metrics

9 Database Queries
9 Different statements
107.88 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
77.13 ms
(71.49%)
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
  413909
  420999
  432522
  443430
  449847
  493788
  505619
  505634
  509698
  519257
  524608
  533851
  539029
  540410
  540748
  542975
  545480
  554635
  565218
  572019
  575436
  576386
  580472
  581216
  586118
  588601
  591267
  592921
  598937
  600026
  600798
  612255
  616201
  616205
  639810
  646007
  646849
  696606
  770396
  777125
  779016
]
8.87 ms
(8.22%)
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:
[
  "long feet"
  "long feet"
  "long feet"
  20
]
8.64 ms
(8.00%)
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
  533851
  539029
  554635
  581216
  565218
  588601
  592921
  600798
  616201
  612255
  777125
  779016
  770396
  413909
  432522
  449847
  505634
  493788
  540748
  576386
  443430
  509698
  519257
  505619
  580472
  542975
  598937
  524608
  646007
  600026
  540410
  646849
  639810
  616205
  420999
  575436
  696606
  572019
  591267
  586118
  545480
]
3.22 ms
(2.99%)
1
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
  b"\x01öçF´]pØ×ãh\x7FeÎÃ■"
]
2.66 ms
(2.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "long feet"
]
2.16 ms
(2.00%)
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
  413909
  420999
  432522
  443430
  449847
  493788
  505619
  505634
  509698
  519257
  524608
  533851
  539029
  540410
  540748
  542975
  545480
  554635
  565218
  572019
  575436
  576386
  580472
  581216
  586118
  588601
  591267
  592921
  598937
  600026
  600798
  612255
  616201
  616205
  639810
  646007
  646849
  696606
  770396
  777125
  779016
]
2.00 ms
(1.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "длинные feet"
]
1.63 ms
(1.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "длинные feet"
]
1.58 ms
(1.46%)
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.