GET https://search.jues.net/search/embeds/2?q=swap%20sex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
83.87 ms
(52.58%)
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
  425300
  432787
  449032
  449562
  450386
  452034
  452048
  454456
  459565
  466733
  472503
  472518
  482243
  484017
  493219
  495691
  495703
  495712
  495744
  496098
  496118
  499636
  502819
  504133
  504137
  504521
  512578
  516819
  519093
  519245
  522902
  524896
  525263
  543422
  543917
  552306
  568061
  569448
  591761
  595821
  600218
  622218
  637461
  640001
  642006
  642037
  670564
  675000
  676354
  676638
  752163
  807399
]
53.19 ms
(33.34%)
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:
[
  "swap sex"
  "swap sex"
  "swap sex"
  20
]
11.47 ms
(7.19%)
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
  676354
  425300
  495691
  496098
  472503
  591761
  595821
  752163
  472518
  449032
  637461
  495744
  622218
  499636
  516819
  519245
  519093
  459565
  512578
  807399
  496118
  504137
  449562
  454456
  495712
  502819
  543917
  640001
  504521
  543422
  482243
  670564
  493219
  522902
  432787
  524896
  525263
  495703
  466733
  450386
  676638
  452034
  504133
  552306
  600218
  452048
  642006
  642037
  675000
  568061
  569448
  484017
]
3.30 ms
(2.07%)
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
  425300
  432787
  449032
  449562
  450386
  452034
  452048
  454456
  459565
  466733
  472503
  472518
  482243
  484017
  493219
  495691
  495703
  495712
  495744
  496098
  496118
  499636
  502819
  504133
  504137
  504521
  512578
  516819
  519093
  519245
  522902
  524896
  525263
  543422
  543917
  552306
  568061
  569448
  591761
  595821
  600218
  622218
  637461
  640001
  642006
  642037
  670564
  675000
  676354
  676638
  752163
  807399
]
2.25 ms
(1.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "swap sex"
]
2.02 ms
(1.27%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "swap секс"
]
1.74 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "swap секс"
]
1.69 ms
(1.06%)
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.