GET https://search.jues.net/search/embeds/4?q=cumshot%20to%20mouth

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
55.06 ms
(67.93%)
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
  402078
  411237
  415095
  418125
  418484
  419950
  427166
  436095
  440571
  443559
  464205
  464994
  478319
  483803
  486870
  495140
  499987
  501641
  501960
  502216
  503125
  510505
  514997
  519266
  521779
  523436
  524532
  525451
  527513
  535805
  535808
  547649
  551886
  579754
  583361
  599392
  614036
  626389
  664777
  670197
  756628
]
8.28 ms
(10.22%)
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
  402078
  483803
  503125
  415095
  464205
  519266
  523436
  583361
  664777
  670197
  626389
  440571
  418125
  478319
  524532
  527513
  499987
  419950
  418484
  464994
  501960
  521779
  547649
  551886
  614036
  756628
  502216
  411237
  436095
  495140
  427166
  525451
  486870
  535805
  443559
  501641
  510505
  535808
  579754
  599392
  514997
]
8.09 ms
(9.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:
[
  "cumshot to mouth"
  "cumshot to mouth"
  "cumshot to mouth"
  20
]
2.73 ms
(3.37%)
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
  402078
  411237
  415095
  418125
  418484
  419950
  427166
  436095
  440571
  443559
  464205
  464994
  478319
  483803
  486870
  495140
  499987
  501641
  501960
  502216
  503125
  510505
  514997
  519266
  521779
  523436
  524532
  525451
  527513
  535805
  535808
  547649
  551886
  579754
  583361
  599392
  614036
  626389
  664777
  670197
  756628
]
2.25 ms
(2.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cumshot to mouth"
]
1.63 ms
(2.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(1.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cumshot mouth"
]
1.43 ms
(1.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cumshot mouth"
]

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.