GET https://search.jues.net/search/embeds?q=pumped%20pussy%20webcam

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
55.10 ms
(63.26%)
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
  365056
  388672
  391674
  409075
  434382
  455037
  464494
  498391
  499772
  499789
  508603
  511372
  521625
  526191
  529922
  569283
  575378
  575583
  581092
  584099
  588760
  592576
  602379
  609139
  615925
  620957
  630732
  640317
  650511
  666069
  720071
  736706
  748635
  750896
  756973
  758787
  763775
  771894
  772866
  773687
  774674
  777276
  777332
  780328
  784065
  788530
  788531
  795420
  802914
  804696
  818557
]
14.64 ms
(16.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:
[
  "pumped pussy webcam"
  "pumped pussy webcam"
  "pumped pussy webcam"
  20
]
7.93 ms
(9.11%)
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
  818557
  777332
  763775
  772866
  529922
  777276
  771894
  780328
  575378
  720071
  788530
  788531
  784065
  365056
  508603
  666069
  620957
  773687
  630732
  748635
  774674
  581092
  391674
  388672
  409075
  756973
  804696
  575583
  592576
  434382
  521625
  464494
  650511
  640317
  609139
  795420
  750896
  498391
  526191
  569283
  584099
  588760
  736706
  602379
  802914
  455037
  499789
  758787
  499772
  615925
  511372
]
2.33 ms
(2.67%)
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
  365056
  388672
  391674
  409075
  434382
  455037
  464494
  498391
  499772
  499789
  508603
  511372
  521625
  526191
  529922
  569283
  575378
  575583
  581092
  584099
  588760
  592576
  602379
  609139
  615925
  620957
  630732
  640317
  650511
  666069
  720071
  736706
  748635
  750896
  756973
  758787
  763775
  771894
  772866
  773687
  774674
  777276
  777332
  780328
  784065
  788530
  788531
  795420
  802914
  804696
  818557
]
2.31 ms
(2.65%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pumped pussy webcam"
]
1.77 ms
(2.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(1.83%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pumped pussy вебкамер"
]
1.42 ms
(1.63%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pumped pussy вебкамер"
]

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.