GET https://search.jues.net/search/embeds?q=small%20and%20giant

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
205.40 ms
(58.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
108.08 ms
(30.64%)
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
  387936
  398740
  420363
  420439
  427128
  431082
  431772
  443301
  446267
  447890
  448869
  454834
  460765
  468783
  497693
  500288
  504233
  511858
  517819
  531915
  536927
  537251
  545392
  552069
  556903
  571928
  573268
  575197
  576225
  581505
  587501
  590161
  598113
  598233
  602024
  607039
  609890
  615636
  618280
  633085
  636053
  660380
  675051
  675460
  676570
  747004
  761459
  770797
  772114
  774770
  805346
  812314
  824754
]
22.72 ms
(6.44%)
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:
[
  "small and giant"
  "small and giant"
  "small and giant"
  20
]
8.62 ms
(2.44%)
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
  675051
  675460
  824754
  531915
  587501
  571928
  805346
  590161
  468783
  420363
  431772
  556903
  576225
  761459
  770797
  602024
  747004
  454834
  497693
  536927
  660380
  676570
  504233
  774770
  812314
  581505
  398740
  427128
  598113
  636053
  448869
  618280
  443301
  460765
  511858
  517819
  573268
  615636
  387936
  772114
  545392
  552069
  609890
  431082
  598233
  420439
  447890
  607039
  633085
  446267
  500288
  537251
  575197
]
2.68 ms
(0.76%)
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
  387936
  398740
  420363
  420439
  427128
  431082
  431772
  443301
  446267
  447890
  448869
  454834
  460765
  468783
  497693
  500288
  504233
  511858
  517819
  531915
  536927
  537251
  545392
  552069
  556903
  571928
  573268
  575197
  576225
  581505
  587501
  590161
  598113
  598233
  602024
  607039
  609890
  615636
  618280
  633085
  636053
  660380
  675051
  675460
  676570
  747004
  761459
  770797
  772114
  774770
  805346
  812314
  824754
]
1.98 ms
(0.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "small and giant"
]
1.76 ms
(0.50%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "маленькая giant"
]
1.57 ms
(0.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "маленькая giant"
]

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.