GET https://search.jues.net/search/embeds?q=hidden%20cam%20pussy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
262.35 ms
(50.40%)
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
  383948
  386297
  397904
  416925
  419198
  426478
  426481
  427406
  438009
  438110
  446264
  451090
  452062
  453609
  466299
  472298
  476428
  486233
  490146
  495487
  495490
  504196
  504272
  504279
  504805
  506565
  516772
  516980
  521172
  526877
  527773
  528669
  537780
  547881
  548756
  550507
  553188
  553197
  553601
  557946
  620756
  641313
  669277
  673574
  681490
  692421
  693234
  804422
  817466
  827025
]
217.61 ms
(41.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "скрыт cam pussy"
]
24.75 ms
(4.75%)
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:
[
  "hidden cam pussy"
  "hidden cam pussy"
  "hidden cam pussy"
  20
]
8.26 ms
(1.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
  669277
  553188
  466299
  827025
  693234
  527773
  416925
  490146
  495487
  453609
  386297
  537780
  495490
  504272
  383948
  438110
  472298
  817466
  641313
  427406
  506565
  553197
  504805
  426481
  452062
  397904
  681490
  620756
  451090
  486233
  426478
  516980
  528669
  673574
  804422
  547881
  692421
  553601
  548756
  521172
  526877
  504279
  476428
  446264
  550507
  504196
  516772
  438009
  557946
  419198
]
2.42 ms
(0.46%)
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
  383948
  386297
  397904
  416925
  419198
  426478
  426481
  427406
  438009
  438110
  446264
  451090
  452062
  453609
  466299
  472298
  476428
  486233
  490146
  495487
  495490
  504196
  504272
  504279
  504805
  506565
  516772
  516980
  521172
  526877
  527773
  528669
  537780
  547881
  548756
  550507
  553188
  553197
  553601
  557946
  620756
  641313
  669277
  673574
  681490
  692421
  693234
  804422
  817466
  827025
]
1.95 ms
(0.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hidden cam pussy"
]
1.76 ms
(0.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "скрыт cam pussy"
]
1.40 ms
(0.27%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.