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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
53.43 ms
(59.99%)
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
  454292
  539210
  540330
  540574
  540608
  541854
  541863
  544366
  545600
  559163
  559924
  562051
  562054
  565277
  565566
  565997
  579675
  580129
  581972
  585812
  605432
  619455
  624814
  628379
  630521
  633511
  638761
  646457
  649107
  651620
  678159
  680189
  688677
  692714
  697284
  699562
  702164
  714119
  737857
  740268
  750533
  751453
  781488
  784161
  788257
  795416
  795723
  800504
  803450
]
17.32 ms
(19.44%)
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:
[
  "asian piss"
  "asian piss"
  "asian piss"
  20
]
7.86 ms
(8.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
  562051
  781488
  702164
  649107
  678159
  619455
  579675
  651620
  630521
  697284
  540608
  562054
  633511
  540574
  638761
  680189
  454292
  646457
  788257
  784161
  565277
  559163
  545600
  751453
  628379
  688677
  539210
  585812
  795416
  581972
  714119
  565997
  692714
  580129
  800504
  750533
  559924
  699562
  803450
  541863
  624814
  605432
  795723
  737857
  565566
  540330
  541854
  544366
  740268
]
2.49 ms
(2.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
  454292
  539210
  540330
  540574
  540608
  541854
  541863
  544366
  545600
  559163
  559924
  562051
  562054
  565277
  565566
  565997
  579675
  580129
  581972
  585812
  605432
  619455
  624814
  628379
  630521
  633511
  638761
  646457
  649107
  651620
  678159
  680189
  688677
  692714
  697284
  699562
  702164
  714119
  737857
  740268
  750533
  751453
  781488
  784161
  788257
  795416
  795723
  800504
  803450
]
2.34 ms
(2.63%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "asian piss"
]
1.96 ms
(2.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "азиатк писсинг"
]
1.89 ms
(2.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.77 ms
(1.99%)
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.