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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
83.42 ms
(78.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
  83037
  421874
  432482
  432524
  432584
  433385
  433413
  433453
  433550
  444168
  444794
  485163
  499861
  502519
  511844
  513500
  513551
  516047
  517941
  548892
  560799
  565688
  569443
  571670
  579984
  584211
  588693
  593364
  602203
  613778
  615248
  665957
  666016
  670368
  677854
  702625
  758305
  768600
  779512
  789884
  810479
  824303
]
9.61 ms
(9.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
  565688
  779512
  83037
  584211
  579984
  702625
  593364
  789884
  548892
  758305
  768600
  432482
  824303
  810479
  433385
  499861
  432584
  433550
  432524
  560799
  569443
  677854
  613778
  433413
  433453
  485163
  666016
  670368
  444168
  517941
  602203
  516047
  502519
  513551
  665957
  421874
  511844
  571670
  588693
  615248
  513500
  444794
]
3.12 ms
(2.92%)
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
  83037
  421874
  432482
  432524
  432584
  433385
  433413
  433453
  433550
  444168
  444794
  485163
  499861
  502519
  511844
  513500
  513551
  516047
  517941
  548892
  560799
  565688
  569443
  571670
  579984
  584211
  588693
  593364
  602203
  613778
  615248
  665957
  666016
  670368
  677854
  702625
  758305
  768600
  779512
  789884
  810479
  824303
]
3.06 ms
(2.87%)
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:
[
  "shoes"
  "shoes"
  "shoes"
  20
]
2.00 ms
(1.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "shoes"
]
1.99 ms
(1.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.89 ms
(1.77%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "shoes"
]
1.73 ms
(1.62%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "shoes"
]

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.