GET https://search.jues.net/search/embeds?q=watches%20her%20husband

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
51.67 ms
(62.01%)
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
  395563
  447670
  452277
  471322
  479217
  479889
  510874
  515645
  515709
  519927
  543425
  545216
  557027
  577155
  578631
  581673
  591415
  599292
  604952
  618214
  641901
  647097
  653823
  654270
  666406
  666457
  705118
  705398
  712278
  714429
  716378
  721109
  727040
  730215
  732623
  741303
  749465
  753501
  755918
  757776
  759580
  824600
  826087
  828220
]
13.24 ms
(15.88%)
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:
[
  "watches her husband"
  "watches her husband"
  "watches her husband"
  20
]
7.98 ms
(9.58%)
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
  759580
  577155
  727040
  712278
  557027
  666406
  578631
  395563
  824600
  730215
  828220
  741303
  618214
  757776
  647097
  732623
  826087
  653823
  705398
  749465
  753501
  755918
  714429
  716378
  604952
  666457
  705118
  471322
  479889
  654270
  479217
  510874
  599292
  721109
  452277
  447670
  519927
  581673
  641901
  515709
  515645
  543425
  545216
  591415
]
3.12 ms
(3.74%)
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
  395563
  447670
  452277
  471322
  479217
  479889
  510874
  515645
  515709
  519927
  543425
  545216
  557027
  577155
  578631
  581673
  591415
  599292
  604952
  618214
  641901
  647097
  653823
  654270
  666406
  666457
  705118
  705398
  712278
  714429
  716378
  721109
  727040
  730215
  732623
  741303
  749465
  753501
  755918
  757776
  759580
  824600
  826087
  828220
]
2.18 ms
(2.61%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "watches her husband"
]
1.78 ms
(2.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "watches her husband"
]
1.77 ms
(2.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(1.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "watches her husband"
]

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.