GET https://search.jues.net/search/embeds/3?q=fake%20tits%20blowjob

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
68.31 ms
(56.67%)
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
  399591
  420659
  421214
  437810
  440625
  445672
  446977
  458327
  465075
  473472
  473505
  483223
  487072
  492267
  492279
  493420
  502703
  503840
  518108
  518768
  523629
  533799
  534296
  552198
  553446
  553448
  553942
  560198
  560205
  563479
  565539
  565542
  572886
  574777
  581095
  589048
  591216
  603954
  609591
  613014
  613129
  625167
  689614
]
30.13 ms
(25.00%)
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:
[
  "fake tits blowjob"
  "fake tits blowjob"
  "fake tits blowjob"
  20
]
11.47 ms
(9.52%)
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
  533799
  465075
  560198
  553448
  523629
  574777
  625167
  565542
  493420
  518108
  399591
  534296
  445672
  502703
  446977
  553446
  492267
  518768
  473472
  565539
  420659
  581095
  689614
  552198
  492279
  440625
  421214
  437810
  572886
  458327
  563479
  609591
  613014
  613129
  487072
  560205
  591216
  473505
  553942
  503840
  483223
  589048
  603954
]
3.11 ms
(2.58%)
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
  399591
  420659
  421214
  437810
  440625
  445672
  446977
  458327
  465075
  473472
  473505
  483223
  487072
  492267
  492279
  493420
  502703
  503840
  518108
  518768
  523629
  533799
  534296
  552198
  553446
  553448
  553942
  560198
  560205
  563479
  565539
  565542
  572886
  574777
  581095
  589048
  591216
  603954
  609591
  613014
  613129
  625167
  689614
]
2.12 ms
(1.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fake tits blowjob"
]
2.06 ms
(1.71%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(1.42%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "fake сиськ минет оральн секс"
]
1.64 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "fake сиськ минет оральн секс"
]

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.