GET https://search.jues.net/search/embeds?q=enema%20sex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
66.40 ms
(46.10%)
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:
[
  "enema sex"
  "enema sex"
  "enema sex"
  20
]
61.62 ms
(42.78%)
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
  414104
  460323
  469080
  475707
  504093
  506149
  514946
  517636
  520764
  521294
  530692
  546211
  547496
  550948
  551988
  565110
  565119
  568532
  576583
  578642
  581050
  583355
  590410
  596569
  601203
  602782
  604640
  604939
  636471
  648395
  650139
  652878
  652881
  659033
  664191
  666422
  683897
  686712
  704478
  705438
  710435
  729698
  752545
  752553
  791896
  796081
  796092
  804417
  818291
]
7.30 ms
(5.07%)
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
  520764
  752545
  683897
  796081
  729698
  664191
  652878
  652881
  596569
  752553
  530692
  705438
  791896
  818291
  704478
  796092
  648395
  475707
  576583
  666422
  804417
  659033
  551988
  550948
  636471
  686712
  469080
  514946
  517636
  581050
  650139
  602782
  414104
  460323
  565110
  565119
  583355
  590410
  604640
  546211
  568532
  578642
  601203
  506149
  521294
  547496
  504093
  710435
  604939
]
2.40 ms
(1.67%)
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
  414104
  460323
  469080
  475707
  504093
  506149
  514946
  517636
  520764
  521294
  530692
  546211
  547496
  550948
  551988
  565110
  565119
  568532
  576583
  578642
  581050
  583355
  590410
  596569
  601203
  602782
  604640
  604939
  636471
  648395
  650139
  652878
  652881
  659033
  664191
  666422
  683897
  686712
  704478
  705438
  710435
  729698
  752545
  752553
  791896
  796081
  796092
  804417
  818291
]
1.86 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "enema sex"
]
1.59 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "enema секс"
]
1.45 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.40 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "enema секс"
]

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.