GET https://search.jues.net/search/embeds/3?q=chubby%20hairy%20anal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
63.08 ms
(43.84%)
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:
[
  "chubby hairy anal"
  "chubby hairy anal"
  "chubby hairy anal"
  20
]
62.83 ms
(43.66%)
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
  397392
  405061
  405074
  408214
  411737
  413454
  413461
  414131
  419956
  422192
  423332
  426294
  428103
  439801
  441853
  442128
  444003
  444916
  444918
  445641
  445868
  447276
  454188
  456516
  463976
  466885
  466982
  466989
  468630
  480059
  483152
  485454
  485711
  494985
  506081
  515723
  515964
  519942
  524882
  525499
  526052
  549225
  549233
  549239
  556797
  558176
  558490
  559132
  583913
  584352
  612434
  614737
  731158
  788776
]
9.14 ms
(6.35%)
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
  454188
  413454
  445868
  525499
  731158
  444003
  556797
  411737
  483152
  485711
  519942
  405074
  583913
  558176
  480059
  515964
  447276
  414131
  558490
  468630
  444918
  466982
  456516
  405061
  524882
  788776
  419956
  422192
  549233
  466885
  397392
  426294
  494985
  612434
  526052
  442128
  485454
  515723
  428103
  614737
  445641
  463976
  413461
  441853
  444916
  439801
  423332
  584352
  408214
  506081
  549239
  466989
  559132
  549225
]
2.46 ms
(1.71%)
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
  397392
  405061
  405074
  408214
  411737
  413454
  413461
  414131
  419956
  422192
  423332
  426294
  428103
  439801
  441853
  442128
  444003
  444916
  444918
  445641
  445868
  447276
  454188
  456516
  463976
  466885
  466982
  466989
  468630
  480059
  483152
  485454
  485711
  494985
  506081
  515723
  515964
  519942
  524882
  525499
  526052
  549225
  549233
  549239
  556797
  558176
  558490
  559132
  583913
  584352
  612434
  614737
  731158
  788776
]
1.83 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "chubby hairy anal"
]
1.72 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "chubby волосатая анал"
]
1.45 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "chubby волосатая анал"
]
1.38 ms
(0.96%)
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.