GET https://search.jues.net/search/embeds?q=flash%20ass

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
61.66 ms
(61.19%)
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
  406340
  418952
  419987
  420144
  422024
  469255
  485056
  487102
  489772
  493420
  516220
  529148
  530317
  533711
  535396
  537240
  544686
  545240
  547073
  578705
  582045
  592752
  597738
  601598
  608716
  615082
  618806
  618965
  621230
  625655
  642982
  673941
  690364
  696892
  713493
  721998
  756001
  775738
  800567
  807406
  808291
  809363
  810902
  811797
  817485
  821159
  824787
  826030
  827354
  828248
]
19.55 ms
(19.40%)
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:
[
  "flash ass"
  "flash ass"
  "flash ass"
  20
]
10.86 ms
(10.78%)
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
  642982
  826030
  811797
  756001
  828248
  827354
  469255
  601598
  800567
  544686
  817485
  713493
  775738
  406340
  690364
  824787
  807406
  535396
  582045
  696892
  721998
  592752
  533711
  809363
  621230
  808291
  420144
  530317
  547073
  615082
  419987
  529148
  545240
  618965
  487102
  489772
  578705
  597738
  422024
  821159
  485056
  537240
  673941
  516220
  810902
  418952
  625655
  493420
  608716
  618806
]
2.45 ms
(2.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "flash ass"
]
1.98 ms
(1.97%)
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
  406340
  418952
  419987
  420144
  422024
  469255
  485056
  487102
  489772
  493420
  516220
  529148
  530317
  533711
  535396
  537240
  544686
  545240
  547073
  578705
  582045
  592752
  597738
  601598
  608716
  615082
  618806
  618965
  621230
  625655
  642982
  673941
  690364
  696892
  713493
  721998
  756001
  775738
  800567
  807406
  808291
  809363
  810902
  811797
  817485
  821159
  824787
  826030
  827354
  828248
]
1.74 ms
(1.73%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.36 ms
(1.35%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "flash жоп"
]
1.15 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "flash жоп"
]

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.