GET https://search.jues.net/search/embeds/2?q=bbw%20mature%20pussy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
56.22 ms
(48.51%)
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
  398949
  425503
  428174
  443105
  444918
  448860
  448882
  453190
  455353
  459189
  460969
  464336
  475592
  476229
  476260
  476319
  476321
  504864
  510425
  511086
  514582
  515952
  515986
  523169
  524895
  524903
  525468
  526201
  527415
  527424
  537098
  554770
  562973
  571102
  578395
  584049
  592979
  592985
  603205
  603264
  603672
  614742
  621787
  650806
  651609
  675515
  678764
  771482
]
40.19 ms
(34.69%)
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:
[
  "bbw mature pussy"
  "bbw mature pussy"
  "bbw mature pussy"
  20
]
10.54 ms
(9.09%)
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
  515986
  678764
  504864
  425503
  476319
  455353
  476321
  526201
  592985
  621787
  771482
  444918
  476229
  443105
  525468
  448882
  428174
  464336
  453190
  476260
  515952
  651609
  603264
  614742
  448860
  459189
  475592
  398949
  460969
  511086
  510425
  527424
  523169
  527415
  537098
  524903
  571102
  562973
  675515
  524895
  554770
  603205
  592979
  514582
  650806
  584049
  578395
  603672
]
2.14 ms
(1.85%)
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
  398949
  425503
  428174
  443105
  444918
  448860
  448882
  453190
  455353
  459189
  460969
  464336
  475592
  476229
  476260
  476319
  476321
  504864
  510425
  511086
  514582
  515952
  515986
  523169
  524895
  524903
  525468
  526201
  527415
  527424
  537098
  554770
  562973
  571102
  578395
  584049
  592979
  592985
  603205
  603264
  603672
  614742
  621787
  650806
  651609
  675515
  678764
  771482
]
1.93 ms
(1.67%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bbw mature pussy"
]
1.77 ms
(1.52%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(1.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "bbw mature pussy"
]
1.54 ms
(1.33%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "bbw mature 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.