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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
69.51 ms
(46.27%)
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
  65760
  396087
  411478
  424232
  434376
  439825
  441022
  441024
  452180
  462450
  463808
  471495
  483978
  486445
  487362
  495400
  508430
  517008
  517836
  519642
  527902
  536397
  536584
  536691
  537199
  537207
  540217
  540339
  541866
  545363
  546654
  552623
  556045
  558584
  565259
  565276
  568596
  570165
  570208
  577435
  588264
  589344
  594231
  598505
  600011
  602620
  610317
  627806
  628363
  628379
  628388
  628389
  631972
  632580
  632649
  642041
  701310
  735778
  810109
  814235
]
61.88 ms
(41.20%)
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:
[
  "skinny hard anal"
  "skinny hard anal"
  "skinny hard anal"
  20
]
10.44 ms
(6.95%)
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
  628379
  628388
  439825
  65760
  483978
  558584
  411478
  610317
  540217
  570208
  589344
  628363
  552623
  628389
  462450
  546654
  508430
  814235
  631972
  632580
  642041
  396087
  537207
  486445
  701310
  463808
  627806
  517008
  577435
  536584
  568596
  735778
  441024
  540339
  537199
  565259
  556045
  632649
  810109
  527902
  487362
  598505
  495400
  545363
  588264
  602620
  424232
  536397
  565276
  519642
  570165
  452180
  517836
  536691
  600011
  594231
  434376
  541866
  441022
  471495
]
2.03 ms
(1.35%)
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
  65760
  396087
  411478
  424232
  434376
  439825
  441022
  441024
  452180
  462450
  463808
  471495
  483978
  486445
  487362
  495400
  508430
  517008
  517836
  519642
  527902
  536397
  536584
  536691
  537199
  537207
  540217
  540339
  541866
  545363
  546654
  552623
  556045
  558584
  565259
  565276
  568596
  570165
  570208
  577435
  588264
  589344
  594231
  598505
  600011
  602620
  610317
  627806
  628363
  628379
  628388
  628389
  631972
  632580
  632649
  642041
  701310
  735778
  810109
  814235
]
1.77 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny hard anal"
]
1.59 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые hard анал"
]
1.58 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.40 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "худые hard анал"
]

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.