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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
75.75 ms
(61.71%)
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
  540330
  541853
  542864
  545389
  545409
  545418
  545480
  545600
  550207
  550705
  565276
  580264
  582179
  586587
  601856
  627808
  631196
  631202
  632689
  632706
  633435
  634769
  637080
  637086
  637093
  639741
  640797
  642774
  645019
  647893
  648543
  666535
  675008
  680116
  680118
  680159
  680176
  680186
  701310
  702163
  702168
  702677
  707391
  748957
  800588
  820759
]
21.86 ms
(17.81%)
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 old"
  "pissing old"
  "pissing old"
  20
]
15.46 ms
(12.59%)
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
  680116
  680118
  632689
  637080
  640797
  800588
  748957
  820759
  550705
  645019
  648543
  666535
  702168
  702677
  680159
  580264
  637093
  637086
  631202
  627808
  701310
  550207
  542864
  702163
  582179
  586587
  634769
  631196
  545389
  541853
  545409
  545600
  565276
  707391
  680186
  680176
  601856
  632706
  540330
  545418
  675008
  639741
  642774
  633435
  647893
  545480
]
2.49 ms
(2.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pissing old"
]
2.27 ms
(1.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
  540330
  541853
  542864
  545389
  545409
  545418
  545480
  545600
  550207
  550705
  565276
  580264
  582179
  586587
  601856
  627808
  631196
  631202
  632689
  632706
  633435
  634769
  637080
  637086
  637093
  639741
  640797
  642774
  645019
  647893
  648543
  666535
  675008
  680116
  680118
  680159
  680176
  680186
  701310
  702163
  702168
  702677
  707391
  748957
  800588
  820759
]
1.68 ms
(1.37%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(1.36%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pissing old"
]
1.59 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pissing old"
]

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.