GET https://search.jues.net/search/embeds?q=housewife%20cheats

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
73.73 ms
(74.76%)
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
  266134
  382881
  385341
  399323
  399633
  425727
  431476
  436868
  447275
  452577
  455539
  455593
  473315
  480858
  481157
  481665
  483451
  485025
  486946
  501907
  507521
  511897
  517065
  520009
  527297
  528581
  552048
  553292
  560941
  579364
  599720
  638560
  638576
  658124
  671660
  693420
  716586
  720462
  731090
  734189
  745830
  758046
  759576
  781747
  788798
  797383
  801760
  803294
  813118
  818268
  818885
  819849
  820380
]
10.93 ms
(11.08%)
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
  266134
  801760
  399323
  658124
  447275
  452577
  819849
  818268
  818885
  758046
  638560
  797383
  781747
  716586
  693420
  745830
  820380
  731090
  803294
  579364
  734189
  473315
  671660
  813118
  759576
  788798
  483451
  399633
  455593
  385341
  552048
  720462
  455539
  425727
  436868
  486946
  382881
  527297
  485025
  480858
  501907
  517065
  507521
  520009
  528581
  553292
  599720
  481665
  511897
  431476
  481157
  560941
  638576
]
4.49 ms
(4.56%)
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:
[
  "housewife cheats"
  "housewife cheats"
  "housewife cheats"
  20
]
2.23 ms
(2.26%)
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
  266134
  382881
  385341
  399323
  399633
  425727
  431476
  436868
  447275
  452577
  455539
  455593
  473315
  480858
  481157
  481665
  483451
  485025
  486946
  501907
  507521
  511897
  517065
  520009
  527297
  528581
  552048
  553292
  560941
  579364
  599720
  638560
  638576
  658124
  671660
  693420
  716586
  720462
  731090
  734189
  745830
  758046
  759576
  781747
  788798
  797383
  801760
  803294
  813118
  818268
  818885
  819849
  820380
]
2.18 ms
(2.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "housewife cheats"
]
1.89 ms
(1.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "housewife cheats"
]
1.60 ms
(1.63%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(1.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "housewife cheats"
]

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.