GET https://search.jues.net/search/embeds/2?q=pissing%20cum

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
206.89 ms
(57.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pissing cum"
]
105.77 ms
(29.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
  541207
  541863
  545355
  545373
  545409
  545418
  545469
  599875
  599914
  599955
  599961
  599969
  600297
  618378
  627807
  628332
  628371
  628383
  630552
  631194
  633451
  633491
  633742
  633819
  634140
  634218
  634472
  634790
  634801
  639292
  639719
  639767
  639818
  641700
  642006
  642041
  646427
  648854
  666850
  666892
  666902
  675000
  676428
  676641
  707391
]
26.83 ms
(7.50%)
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:
[
  "pissing cum"
  "pissing cum"
  "pissing cum"
  20
]
10.09 ms
(2.82%)
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
  633819
  599875
  599914
  634790
  642041
  627807
  541207
  541863
  545373
  648854
  666892
  666902
  676641
  634472
  641700
  599955
  599961
  599969
  618378
  633491
  633742
  633451
  631194
  639292
  646427
  639818
  600297
  634801
  545409
  676428
  707391
  675000
  545469
  628332
  634140
  628383
  639719
  639767
  628371
  630552
  634218
  642006
  545418
  666850
  545355
]
2.90 ms
(0.81%)
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
  541207
  541863
  545355
  545373
  545409
  545418
  545469
  599875
  599914
  599955
  599961
  599969
  600297
  618378
  627807
  628332
  628371
  628383
  630552
  631194
  633451
  633491
  633742
  633819
  634140
  634218
  634472
  634790
  634801
  639292
  639719
  639767
  639818
  641700
  642006
  642041
  646427
  648854
  666850
  666892
  666902
  675000
  676428
  676641
  707391
]
1.92 ms
(0.54%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(0.47%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pissing cum"
]
1.64 ms
(0.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pissing cum"
]

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.