GET https://search.jues.net/search/embeds?q=piss%20drink%20cum

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
82.96 ms
(69.35%)
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
  428517
  541197
  542583
  542595
  543627
  545355
  545373
  545409
  545469
  550124
  582323
  599875
  599914
  599961
  601579
  601583
  601584
  627807
  628332
  628371
  628383
  630552
  631194
  632562
  633451
  633491
  634140
  634218
  634787
  634790
  634801
  637043
  639292
  639719
  639767
  639818
  641700
  646427
  648854
  650127
  651599
  666850
  666892
  666901
  666902
  676428
  707391
]
18.79 ms
(15.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:
[
  "piss drink cum"
  "piss drink cum"
  "piss drink cum"
  20
]
8.37 ms
(7.00%)
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
  634218
  428517
  599961
  639292
  632562
  650127
  634787
  648854
  550124
  543627
  601579
  637043
  639818
  634801
  582323
  666901
  601584
  599875
  599914
  634790
  628383
  628371
  545373
  666892
  666902
  641700
  633491
  633451
  631194
  545355
  646427
  545409
  676428
  707391
  628332
  634140
  639719
  630552
  542583
  542595
  666850
  541197
  651599
  627807
  601583
  545469
  639767
]
2.33 ms
(1.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "piss drink cum"
]
2.22 ms
(1.86%)
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
  428517
  541197
  542583
  542595
  543627
  545355
  545373
  545409
  545469
  550124
  582323
  599875
  599914
  599961
  601579
  601583
  601584
  627807
  628332
  628371
  628383
  630552
  631194
  632562
  633451
  633491
  634140
  634218
  634787
  634790
  634801
  637043
  639292
  639719
  639767
  639818
  641700
  646427
  648854
  650127
  651599
  666850
  666892
  666901
  666902
  676428
  707391
]
1.78 ms
(1.49%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "писсинг drink cum"
]
1.59 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "писсинг drink cum"
]
1.57 ms
(1.32%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.