GET https://search.jues.net/search/embeds/2?q=german%20masturbation

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
271.19 ms
(88.52%)
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
  383943
  384745
  388036
  390818
  395666
  410781
  418713
  428522
  432299
  460808
  471012
  472618
  473203
  482086
  495878
  505910
  509321
  523461
  538817
  563134
  569050
  583387
  583681
  590696
  592778
  596960
  597878
  599609
  602024
  603610
  603685
  606605
  606608
  618139
  619612
  624084
  624925
  630405
  631878
  756920
  758397
  765640
  780690
]
13.03 ms
(4.25%)
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
  592778
  618139
  619612
  590696
  384745
  388036
  410781
  523461
  418713
  495878
  758397
  596960
  756920
  390818
  471012
  569050
  602024
  606608
  597878
  780690
  432299
  538817
  583681
  563134
  631878
  603610
  460808
  765640
  583387
  630405
  428522
  606605
  473203
  603685
  624925
  509321
  395666
  472618
  505910
  599609
  624084
  482086
  383943
]
12.82 ms
(4.18%)
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:
[
  "german masturbation"
  "german masturbation"
  "german masturbation"
  20
]
2.32 ms
(0.76%)
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
  383943
  384745
  388036
  390818
  395666
  410781
  418713
  428522
  432299
  460808
  471012
  472618
  473203
  482086
  495878
  505910
  509321
  523461
  538817
  563134
  569050
  583387
  583681
  590696
  592778
  596960
  597878
  599609
  602024
  603610
  603685
  606605
  606608
  618139
  619612
  624084
  624925
  630405
  631878
  756920
  758397
  765640
  780690
]
1.98 ms
(0.65%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "german мастурбац"
]
1.75 ms
(0.57%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "german masturbation"
]
1.53 ms
(0.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "german мастурбац"
]

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.