GET https://search.jues.net/search/embeds?q=sucking%20after%20cum

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.67 ms
(71.52%)
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
  452621
  452725
  460112
  477831
  478126
  480223
  488767
  491175
  502582
  508468
  517831
  523793
  524143
  551604
  557770
  565859
  584087
  584688
  594638
  596533
  598672
  600762
  602927
  675190
  679863
  682857
  721240
  722091
  723538
  752067
  758447
  759736
  763223
  763777
  773725
  774715
  782989
  784241
  786701
  790757
  791413
  792188
]
52.64 ms
(17.70%)
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
  452621
  452725
  460112
  477831
  478126
  480223
  488767
  491175
  502582
  508468
  517831
  523793
  524143
  551604
  557770
  565859
  584087
  584688
  594638
  596533
  598672
  600762
  602927
  675190
  679863
  682857
  721240
  722091
  723538
  752067
  758447
  759736
  763223
  763777
  773725
  774715
  782989
  784241
  786701
  790757
  791413
  792188
]
16.99 ms
(5.71%)
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:
[
  "sucking after cum"
  "sucking after cum"
  "sucking after cum"
  20
]
6.82 ms
(2.29%)
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
  790757
  596533
  763777
  773725
  723538
  452725
  584688
  491175
  508468
  523793
  782989
  722091
  763223
  786701
  721240
  784241
  682857
  598672
  774715
  758447
  759736
  791413
  460112
  675190
  792188
  752067
  551604
  602927
  452621
  480223
  557770
  565859
  600762
  594638
  502582
  488767
  679863
  478126
  524143
  477831
  517831
  584087
]
2.23 ms
(0.75%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.23 ms
(0.75%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "sucking after cum"
]
2.02 ms
(0.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sucking after cum"
]
1.74 ms
(0.58%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "sucking after cum"
]

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.