GET https://search.jues.net/search/embeds?q=anal%20teen%20drunk

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
73.50 ms
(50.89%)
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:
[
  "anal teen drunk"
  "anal teen drunk"
  "anal teen drunk"
  20
]
52.46 ms
(36.32%)
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
  100616
  342206
  365995
  383748
  392554
  395935
  396753
  398745
  401631
  402722
  404150
  426693
  428033
  443482
  443555
  448543
  453365
  454268
  454269
  462937
  469909
  471593
  484827
  488717
  514772
  517864
  518240
  518424
  521970
  523306
  523508
  530386
  543821
  559127
  560646
  561813
  562265
  578382
  578392
  579899
  621397
  698124
  761614
]
9.10 ms
(6.30%)
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
  530386
  404150
  523508
  342206
  392554
  469909
  761614
  396753
  428033
  484827
  398745
  462937
  401631
  395935
  578392
  578382
  561813
  100616
  426693
  518424
  562265
  365995
  517864
  454269
  454268
  443555
  521970
  448543
  579899
  488717
  383748
  543821
  471593
  518240
  453365
  443482
  523306
  514772
  621397
  698124
  560646
  402722
  559127
]
2.50 ms
(1.73%)
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
  100616
  342206
  365995
  383748
  392554
  395935
  396753
  398745
  401631
  402722
  404150
  426693
  428033
  443482
  443555
  448543
  453365
  454268
  454269
  462937
  469909
  471593
  484827
  488717
  514772
  517864
  518240
  518424
  521970
  523306
  523508
  530386
  543821
  559127
  560646
  561813
  562265
  578382
  578392
  579899
  621397
  698124
  761614
]
2.10 ms
(1.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal teen drunk"
]
1.75 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал teen пьян"
]
1.56 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал 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.