GET https://search.jues.net/search/embeds?q=real%20fuck%20sister

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
62.69 ms
(56.26%)
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
  417839
  419938
  425319
  427326
  438029
  443038
  445967
  450418
  457146
  464480
  474782
  492135
  501015
  504741
  504748
  509967
  513832
  522642
  523160
  527079
  569989
  574169
  579479
  579532
  595833
  602262
  604384
  608172
  623226
  626342
  645004
  668034
  669504
  695084
  710015
  719321
  727587
  734672
  737126
  737468
  764623
  768472
  769683
  780323
  789437
  791481
  793597
  810178
  827784
]
28.91 ms
(25.95%)
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:
[
  "real fuck sister"
  "real fuck sister"
  "real fuck sister"
  20
]
9.79 ms
(8.79%)
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
  719321
  737468
  764623
  827784
  710015
  734672
  780323
  668034
  791481
  509967
  768472
  737126
  769683
  419938
  623226
  574169
  626342
  810178
  793597
  727587
  669504
  702303
  492135
  504741
  504748
  579532
  789437
  438029
  604384
  457146
  464480
  695084
  595833
  731666
  602262
  443038
  427326
  425319
  569989
  579479
  527079
  474782
  445967
  645004
  501015
  417839
  513832
  608172
  522642
  450418
  523160
]
2.62 ms
(2.35%)
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
  417839
  419938
  425319
  427326
  438029
  443038
  445967
  450418
  457146
  464480
  474782
  492135
  501015
  504741
  504748
  509967
  513832
  522642
  523160
  527079
  569989
  574169
  579479
  579532
  595833
  602262
  604384
  608172
  623226
  626342
  645004
  668034
  669504
  695084
  710015
  719321
  727587
  734672
  737126
  737468
  764623
  768472
  769683
  780323
  789437
  791481
  793597
  810178
  827784
]
2.06 ms
(1.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "real fuck sister"
]
1.87 ms
(1.68%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "real секс sister"
]
1.81 ms
(1.63%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(1.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "real секс sister"
]

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.