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

Query Metrics

9 Database Queries
9 Different statements
75.97 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
39.60 ms
(52.12%)
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
  406339
  418879
  429084
  439679
  439721
  446050
  446544
  455923
  460072
  461520
  461805
  480125
  486897
  502541
  518607
  544050
  549584
  549839
  560006
  591378
  593577
  596235
  603709
  622686
  622704
  690190
  693955
  792910
  810524
]
16.70 ms
(21.98%)
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:
[
  "shy wife"
  "shy wife"
  "shy wife"
  20
]
7.68 ms
(10.11%)
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
  792910
  439721
  518607
  810524
  406339
  461520
  439679
  460072
  593577
  622704
  480125
  461805
  446544
  549839
  544050
  446050
  693955
  596235
  455923
  418879
  690190
  622686
  486897
  549584
  603709
  502541
  591378
  560006
  429084
]
2.41 ms
(3.17%)
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
  406339
  418879
  429084
  439679
  439721
  446050
  446544
  455923
  460072
  461520
  461805
  480125
  486897
  502541
  518607
  544050
  549584
  549839
  560006
  591378
  593577
  596235
  603709
  622686
  622704
  690190
  693955
  792910
  810524
]
2.36 ms
(3.10%)
1
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
  b"\x01”qDäqp•«­ÄìÐ\x0FËÝ"
]
2.13 ms
(2.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "shy wife"
]
1.75 ms
(2.30%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "shy жен"
]
1.70 ms
(2.23%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(2.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "shy жен"
]

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.