GET https://search.jues.net/search/embeds/10?q=huge%20cock%20interracial

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
67.91 ms
(62.10%)
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
  427174
  466404
  469534
  478672
  484673
  497452
  512447
  512527
  527273
  528361
  529792
  529794
  530369
  530777
  531105
  532666
  533013
  544472
  545614
  597216
  598105
  599865
  599927
  600021
  600252
  601578
  614029
  617423
  617427
  623168
  628371
  630533
  630869
  634140
  634780
  635975
  636306
  641978
  642016
  642037
  642044
  642660
  645861
  646255
  651601
  675008
  675012
  677784
  695127
]
18.82 ms
(17.21%)
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:
[
  "huge cock interracial"
  "huge cock interracial"
  "huge cock interracial"
  20
]
12.32 ms
(11.26%)
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
  645861
  646255
  651601
  677784
  695127
  599927
  600252
  630533
  634140
  636306
  642044
  642660
  600021
  635975
  599865
  617427
  630869
  601578
  628371
  634780
  642037
  642016
  484673
  512447
  529794
  530777
  531105
  533013
  528361
  529792
  544472
  545614
  675012
  675008
  597216
  641978
  623168
  617423
  469534
  466404
  497452
  512527
  527273
  532666
  530369
  614029
  598105
  427174
  478672
]
3.09 ms
(2.82%)
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
  427174
  466404
  469534
  478672
  484673
  497452
  512447
  512527
  527273
  528361
  529792
  529794
  530369
  530777
  531105
  532666
  533013
  544472
  545614
  597216
  598105
  599865
  599927
  600021
  600252
  601578
  614029
  617423
  617427
  623168
  628371
  630533
  630869
  634140
  634780
  635975
  636306
  641978
  642016
  642037
  642044
  642660
  645861
  646255
  651601
  675008
  675012
  677784
  695127
]
2.09 ms
(1.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "huge cock interracial"
]
2.02 ms
(1.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "огромные cock межрасов"
]
1.72 ms
(1.57%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.39 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "огромные cock межрасов"
]

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.