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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
110.47 ms
(51.26%)
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:
[
  "hard anal riding"
  "hard anal riding"
  "hard anal riding"
  20
]
83.84 ms
(38.90%)
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
  327170
  382971
  386456
  388059
  389500
  389966
  390508
  396975
  419319
  419590
  423095
  441022
  449021
  452189
  453032
  465148
  466200
  466369
  469597
  470910
  473552
  478596
  483742
  486182
  491169
  495890
  499628
  510553
  520753
  521792
  525243
  528929
  530268
  543275
  552623
  555116
  559123
  565241
  565254
  571726
  591870
  593656
  599345
  600114
  600123
  606549
  618460
  702061
  775976
  790397
  797541
  810826
]
11.07 ms
(5.13%)
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
  571726
  521792
  390508
  555116
  473552
  483742
  591870
  419319
  559123
  600123
  618460
  465148
  593656
  510553
  530268
  797541
  423095
  452189
  810826
  775976
  466200
  543275
  606549
  790397
  396975
  419590
  599345
  327170
  382971
  495890
  600114
  470910
  449021
  386456
  478596
  499628
  491169
  389966
  486182
  565241
  702061
  466369
  525243
  552623
  389500
  565254
  520753
  453032
  469597
  528929
  388059
  441022
]
2.93 ms
(1.36%)
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
  327170
  382971
  386456
  388059
  389500
  389966
  390508
  396975
  419319
  419590
  423095
  441022
  449021
  452189
  453032
  465148
  466200
  466369
  469597
  470910
  473552
  478596
  483742
  486182
  491169
  495890
  499628
  510553
  520753
  521792
  525243
  528929
  530268
  543275
  552623
  555116
  559123
  565241
  565254
  571726
  591870
  593656
  599345
  600114
  600123
  606549
  618460
  702061
  775976
  790397
  797541
  810826
]
1.93 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hard anal riding"
]
1.81 ms
(0.84%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hard анал riding"
]
1.73 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hard анал riding"
]

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.