GET https://search.jues.net/search/embeds/2?q=solo%20dildo%20asian

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
50.24 ms
(55.47%)
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
  418671
  421298
  425786
  425804
  436074
  452781
  457981
  467096
  467715
  468153
  471092
  473055
  480788
  499885
  508891
  512550
  514248
  534791
  544964
  559782
  577783
  587307
  595165
  596919
  600492
  602132
  606493
  607611
  615983
  620743
  639252
  660763
  712475
  749693
  759365
  761289
  783740
  785568
  792273
  795396
  797010
  824449
]
23.28 ms
(25.70%)
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:
[
  "solo dildo asian"
  "solo dildo asian"
  "solo dildo asian"
  20
]
7.50 ms
(8.28%)
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
  595165
  425786
  418671
  596919
  602132
  785568
  559782
  660763
  749693
  620743
  467096
  512550
  607611
  639252
  600492
  797010
  452781
  468153
  467715
  712475
  795396
  499885
  824449
  783740
  421298
  587307
  615983
  471092
  577783
  759365
  425804
  534791
  792273
  508891
  514248
  473055
  544964
  457981
  606493
  761289
  480788
  436074
]
2.26 ms
(2.50%)
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
  418671
  421298
  425786
  425804
  436074
  452781
  457981
  467096
  467715
  468153
  471092
  473055
  480788
  499885
  508891
  512550
  514248
  534791
  544964
  559782
  577783
  587307
  595165
  596919
  600492
  602132
  606493
  607611
  615983
  620743
  639252
  660763
  712475
  749693
  759365
  761289
  783740
  785568
  792273
  795396
  797010
  824449
]
2.13 ms
(2.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "solo dildo asian"
]
1.77 ms
(1.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло дилд азиатк"
]
1.71 ms
(1.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(1.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "соло дилд азиатк"
]

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.