GET https://search.jues.net/search/embeds?q=bulge%20dildo

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
206.93 ms
(59.80%)
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
  86309
  410346
  412721
  432945
  531360
  532729
  542163
  547452
  547468
  547474
  547475
  561015
  561019
  561034
  561038
  561040
  568501
  574388
  590255
  605133
  660373
  660399
  660419
  665957
  668660
  669007
  669038
  669058
  669075
  669079
  671044
  686106
  686130
  695866
  695868
  695870
  713142
  722379
  737578
  738814
  752709
  758343
  788953
  807568
]
105.77 ms
(30.57%)
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
  86309
  410346
  412721
  432945
  531360
  532729
  542163
  547452
  547468
  547474
  547475
  561015
  561019
  561034
  561038
  561040
  568501
  574388
  590255
  605133
  660373
  660399
  660419
  665957
  668660
  669007
  669038
  669058
  669075
  669079
  671044
  686106
  686130
  695866
  695868
  695870
  713142
  722379
  737578
  738814
  752709
  758343
  788953
  807568
]
16.43 ms
(4.75%)
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:
[
  "bulge dildo"
  "bulge dildo"
  "bulge dildo"
  20
]
9.79 ms
(2.83%)
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
  758343
  547468
  547474
  669038
  671044
  86309
  542163
  568501
  412721
  547475
  561019
  722379
  695866
  807568
  737578
  432945
  561034
  668660
  686130
  695868
  660419
  669075
  713142
  686106
  531360
  752709
  695870
  561015
  561040
  605133
  788953
  547452
  660373
  410346
  561038
  669079
  532729
  660399
  665957
  738814
  574388
  590255
  669058
  669007
]
2.14 ms
(0.62%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bulge dildo"
]
1.79 ms
(0.52%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "bulge дилд"
]
1.52 ms
(0.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "bulge дилд"
]

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.