GET https://search.jues.net/search/embeds/3?q=masturbation%20cum%20teen

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
78.60 ms
(57.13%)
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
  417198
  418165
  423424
  428257
  432478
  433584
  446356
  462784
  466611
  467744
  467910
  469749
  473413
  474901
  475411
  477812
  479820
  486871
  495140
  505129
  505614
  505905
  511455
  514660
  516584
  517836
  519849
  537648
  548538
  553031
  554292
  567046
  583448
  596856
  618381
  624127
  626364
  628402
  632707
  635258
  637063
  639760
  644276
  666902
  666904
  675000
  675012
  676638
  748046
]
38.84 ms
(28.23%)
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:
[
  "masturbation cum teen"
  "masturbation cum teen"
  "masturbation cum teen"
  20
]
11.04 ms
(8.02%)
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
  511455
  462784
  475411
  505905
  423424
  428257
  473413
  446356
  495140
  477812
  583448
  637063
  644276
  624127
  418165
  474901
  505614
  666904
  417198
  479820
  514660
  519849
  548538
  666902
  567046
  628402
  632707
  635258
  626364
  516584
  553031
  748046
  432478
  537648
  676638
  596856
  639760
  486871
  675000
  467910
  433584
  466611
  467744
  554292
  469749
  517836
  675012
  618381
  505129
]
2.53 ms
(1.84%)
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
  417198
  418165
  423424
  428257
  432478
  433584
  446356
  462784
  466611
  467744
  467910
  469749
  473413
  474901
  475411
  477812
  479820
  486871
  495140
  505129
  505614
  505905
  511455
  514660
  516584
  517836
  519849
  537648
  548538
  553031
  554292
  567046
  583448
  596856
  618381
  624127
  626364
  628402
  632707
  635258
  637063
  639760
  644276
  666902
  666904
  675000
  675012
  676638
  748046
]
1.93 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "masturbation cum teen"
]
1.66 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мастурбац cum teen"
]
1.50 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мастурбац cum teen"
]
1.49 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.