GET https://search.jues.net/search/embeds?q=tall%20skinny%20anal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
87.20 ms
(51.45%)
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:
[
  "tall skinny anal"
  "tall skinny anal"
  "tall skinny anal"
  20
]
63.46 ms
(37.44%)
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
  389585
  422565
  422646
  422653
  422908
  425206
  426417
  428605
  429379
  443120
  445279
  446105
  464916
  466987
  470458
  471495
  471919
  473066
  476012
  477079
  493234
  503934
  530384
  533065
  534748
  541770
  560639
  562825
  580646
  584710
  589968
  592770
  601766
  621389
  624030
  642012
  660467
  680200
  692045
  729829
  740651
  742932
  747377
  810032
  813553
]
8.83 ms
(5.21%)
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
  742932
  747377
  389585
  813553
  692045
  660467
  621389
  642012
  560639
  740651
  534748
  533065
  445279
  429379
  601766
  810032
  471919
  443120
  680200
  464916
  422646
  584710
  729829
  476012
  493234
  422908
  422565
  470458
  466987
  428605
  425206
  426417
  473066
  530384
  446105
  503934
  624030
  477079
  589968
  422653
  580646
  541770
  592770
  471495
  562825
]
2.72 ms
(1.60%)
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
  389585
  422565
  422646
  422653
  422908
  425206
  426417
  428605
  429379
  443120
  445279
  446105
  464916
  466987
  470458
  471495
  471919
  473066
  476012
  477079
  493234
  503934
  530384
  533065
  534748
  541770
  560639
  562825
  580646
  584710
  589968
  592770
  601766
  621389
  624030
  642012
  660467
  680200
  692045
  729829
  740651
  742932
  747377
  810032
  813553
]
2.25 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "tall skinny anal"
]
1.77 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.77 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "высокие худые анал"
]
1.50 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.