GET https://search.jues.net/search/embeds?q=friends%20teen%20amateur

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.27 ms
(61.25%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "friends teen любительск"
]
74.21 ms
(21.41%)
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
  397915
  399412
  402015
  412208
  420726
  421172
  427530
  428028
  428033
  431965
  432771
  432883
  434000
  443565
  443870
  444692
  446086
  446894
  452768
  459965
  460107
  460361
  469689
  483788
  484110
  485155
  508421
  524527
  525030
  536665
  544196
  550667
  552628
  564390
  565224
  568110
  574935
  577323
  603906
  603913
  608301
  632568
  646338
  670719
  671255
  682530
  730372
  732822
  760192
  763437
  765221
  765296
  775896
  792139
  793448
  810512
  817275
]
42.67 ms
(12.31%)
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:
[
  "friends teen amateur"
  "friends teen amateur"
  "friends teen amateur"
  20
]
9.90 ms
(2.86%)
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
  671255
  817275
  646338
  565224
  760192
  792139
  568110
  412208
  397915
  603913
  810512
  765296
  775896
  670719
  484110
  732822
  608301
  632568
  399412
  428033
  443870
  574935
  460107
  765221
  469689
  564390
  459965
  446086
  402015
  793448
  730372
  443565
  544196
  763437
  428028
  508421
  525030
  552628
  452768
  460361
  432883
  421172
  446894
  536665
  432771
  444692
  431965
  420726
  434000
  485155
  524527
  427530
  550667
  577323
  682530
  603906
  483788
]
2.92 ms
(0.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
  397915
  399412
  402015
  412208
  420726
  421172
  427530
  428028
  428033
  431965
  432771
  432883
  434000
  443565
  443870
  444692
  446086
  446894
  452768
  459965
  460107
  460361
  469689
  483788
  484110
  485155
  508421
  524527
  525030
  536665
  544196
  550667
  552628
  564390
  565224
  568110
  574935
  577323
  603906
  603913
  608301
  632568
  646338
  670719
  671255
  682530
  730372
  732822
  760192
  763437
  765221
  765296
  775896
  792139
  793448
  810512
  817275
]
1.63 ms
(0.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "friends teen amateur"
]
1.61 ms
(0.46%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.38 ms
(0.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "friends teen любительск"
]

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.