GET https://search.jues.net/search/embeds?q=anal%20hole%20wide

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
76.29 ms
(45.81%)
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
  402450
  405855
  413673
  415319
  426551
  429889
  429890
  429900
  443467
  447153
  464163
  468171
  469567
  479221
  482764
  500734
  503144
  508197
  510002
  512508
  520224
  525026
  560980
  572640
  590418
  597160
  602183
  610517
  636284
  646880
  692723
  692743
  695199
  695337
  704186
  735017
  744453
  749064
  770802
  770946
  785610
  791550
  800584
  821065
]
72.75 ms
(43.68%)
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 hole wide"
  "anal hole wide"
  "anal hole wide"
  20
]
8.56 ms
(5.14%)
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
  791550
  692723
  744453
  704186
  560980
  508197
  735017
  610517
  821065
  415319
  695337
  749064
  770946
  413673
  510002
  800584
  469567
  646880
  482764
  429890
  597160
  402450
  590418
  429889
  695199
  770802
  500734
  692743
  447153
  785610
  479221
  429900
  405855
  468171
  636284
  464163
  520224
  512508
  503144
  443467
  602183
  426551
  572640
  525026
]
2.21 ms
(1.32%)
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
  402450
  405855
  413673
  415319
  426551
  429889
  429890
  429900
  443467
  447153
  464163
  468171
  469567
  479221
  482764
  500734
  503144
  508197
  510002
  512508
  520224
  525026
  560980
  572640
  590418
  597160
  602183
  610517
  636284
  646880
  692723
  692743
  695199
  695337
  704186
  735017
  744453
  749064
  770802
  770946
  785610
  791550
  800584
  821065
]
1.83 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal hole wide"
]
1.68 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал дырк wide"
]
1.43 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал дырк wide"
]

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.