GET https://search.jues.net/search/embeds?q=luna%20wife

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
54.83 ms
(59.35%)
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
  386320
  415784
  420560
  425530
  426512
  426524
  478861
  499718
  516335
  520231
  544844
  544849
  563811
  578442
  588642
  589212
  590879
  601726
  601736
  603655
  610080
  618476
  636503
  636507
  641227
  662927
  681211
  738065
  741265
  742739
  743015
  757006
  763168
  773924
  788536
  791652
  798469
  801562
  809279
  812201
  813528
  814967
  814975
  814978
  818782
]
17.49 ms
(18.93%)
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:
[
  "luna wife"
  "luna wife"
  "luna wife"
  20
]
9.98 ms
(10.80%)
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
  812201
  813528
  757006
  738065
  791652
  601736
  814967
  544844
  801562
  814978
  563811
  662927
  798469
  544849
  601726
  590879
  478861
  588642
  814975
  516335
  788536
  763168
  743015
  641227
  741265
  818782
  742739
  809279
  425530
  636503
  589212
  603655
  426512
  681211
  636507
  773924
  420560
  415784
  426524
  578442
  386320
  610080
  520231
  499718
  618476
]
2.77 ms
(3.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
  386320
  415784
  420560
  425530
  426512
  426524
  478861
  499718
  516335
  520231
  544844
  544849
  563811
  578442
  588642
  589212
  590879
  601726
  601736
  603655
  610080
  618476
  636503
  636507
  641227
  662927
  681211
  738065
  741265
  742739
  743015
  757006
  763168
  773924
  788536
  791652
  798469
  801562
  809279
  812201
  813528
  814967
  814975
  814978
  818782
]
2.52 ms
(2.73%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.00 ms
(2.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "luna wife"
]
1.49 ms
(1.61%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "luna жен"
]
1.30 ms
(1.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "luna жен"
]

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.