GET https://search.jues.net/search/embeds?q=smooth%20vagina

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
86.45 ms
(79.02%)
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
  382294
  384393
  388191
  388760
  400425
  410132
  447783
  457625
  459383
  461651
  464379
  465583
  483686
  484425
  484516
  492410
  494302
  494486
  514292
  527964
  528158
  533226
  550564
  554133
  556168
  564811
  565298
  569265
  569820
  576414
  576896
  585920
  591089
  593725
  598059
  598807
  601090
  614701
  635153
  643458
  650617
  656252
  673127
  683488
  689576
  691619
  704280
  723335
  736230
  739408
  746181
  747969
  755368
  768834
  773980
  775974
  776642
  819304
  820162
  825795
]
8.65 ms
(7.90%)
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
  614701
  601090
  576896
  484425
  384393
  382294
  689576
  533226
  656252
  683488
  550564
  768834
  691619
  585920
  773980
  819304
  825795
  569265
  736230
  643458
  746181
  591089
  739408
  388191
  650617
  484516
  723335
  776642
  820162
  514292
  556168
  554133
  564811
  635153
  593725
  492410
  494302
  457625
  673127
  528158
  704280
  388760
  465583
  598059
  494486
  569820
  527964
  747969
  755368
  775974
  576414
  400425
  565298
  483686
  447783
  459383
  464379
  410132
  461651
  598807
]
4.77 ms
(4.36%)
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:
[
  "smooth vagina"
  "smooth vagina"
  "smooth vagina"
  20
]
3.12 ms
(2.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
  382294
  384393
  388191
  388760
  400425
  410132
  447783
  457625
  459383
  461651
  464379
  465583
  483686
  484425
  484516
  492410
  494302
  494486
  514292
  527964
  528158
  533226
  550564
  554133
  556168
  564811
  565298
  569265
  569820
  576414
  576896
  585920
  591089
  593725
  598059
  598807
  601090
  614701
  635153
  643458
  650617
  656252
  673127
  683488
  689576
  691619
  704280
  723335
  736230
  739408
  746181
  747969
  755368
  768834
  773980
  775974
  776642
  819304
  820162
  825795
]
1.94 ms
(1.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "smooth vagina"
]
1.64 ms
(1.49%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "smooth вагин"
]
1.48 ms
(1.35%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.37 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "smooth вагин"
]

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.