GET https://search.jues.net/search/embeds/3?q=skinny%20pussy%20fisting

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
75.87 ms
(57.29%)
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
  410051
  427263
  441644
  443323
  452014
  452436
  474539
  484673
  484692
  489424
  491232
  495273
  502575
  514113
  516686
  519592
  520850
  530369
  531123
  532666
  541848
  543659
  545611
  552406
  558719
  561326
  561682
  564007
  565245
  565276
  579344
  582179
  586587
  590526
  593994
  599988
  600011
  600071
  600252
  600257
  600360
  601578
  615716
  617165
  617411
  628117
  628371
  632632
  634208
  634769
  634818
  640813
  648257
  665328
  674994
  679774
]
34.74 ms
(26.23%)
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 pussy fisting"
  "skinny pussy fisting"
  "skinny pussy fisting"
  20
]
12.39 ms
(9.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
  615716
  600071
  628117
  410051
  593994
  502575
  561326
  648257
  443323
  489424
  474539
  564007
  541848
  565245
  582179
  617411
  640813
  586587
  634769
  519592
  514113
  495273
  452014
  531123
  543659
  545611
  565276
  679774
  600252
  634818
  600360
  600257
  601578
  628371
  634208
  484673
  484692
  558719
  561682
  441644
  520850
  674994
  632632
  579344
  452436
  491232
  532666
  530369
  599988
  600011
  516686
  665328
  590526
  427263
  552406
  617165
]
2.31 ms
(1.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny pussy fisting"
]
2.14 ms
(1.61%)
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
  410051
  427263
  441644
  443323
  452014
  452436
  474539
  484673
  484692
  489424
  491232
  495273
  502575
  514113
  516686
  519592
  520850
  530369
  531123
  532666
  541848
  543659
  545611
  552406
  558719
  561326
  561682
  564007
  565245
  565276
  579344
  582179
  586587
  590526
  593994
  599988
  600011
  600071
  600252
  600257
  600360
  601578
  615716
  617165
  617411
  628117
  628371
  632632
  634208
  634769
  634818
  640813
  648257
  665328
  674994
  679774
]
1.86 ms
(1.41%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(1.25%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые pussy фистинг"
]
1.46 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "худые pussy фистинг"
]

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.