GET https://search.jues.net/search/embeds?q=masturbating%20squirt

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
99.60 ms
(78.54%)
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
  398099
  418035
  419646
  424643
  439260
  478992
  494291
  502877
  514658
  516570
  533785
  538530
  545001
  547543
  561495
  569309
  587244
  603286
  618326
  626576
  643005
  648437
  650511
  650663
  664972
  671560
  678837
  685509
  693502
  701292
  701770
  708226
  711597
  712801
  714927
  725435
  726459
  733518
  736017
  739810
  749081
  751315
  751412
  751645
  753762
  779840
  783218
  784771
  785685
  786339
  787771
  787779
  791857
  793201
  795983
  802243
  802315
  805139
  810165
  811644
  818686
  820311
  824754
  826234
]
9.81 ms
(7.74%)
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
  793201
  725435
  439260
  569309
  650663
  685509
  810165
  820311
  587244
  787771
  751315
  739810
  678837
  791857
  826234
  398099
  701292
  418035
  818686
  824754
  545001
  795983
  502877
  643005
  802243
  533785
  751645
  664972
  516570
  786339
  787779
  749081
  726459
  736017
  618326
  701770
  711597
  783218
  561495
  648437
  802315
  811644
  538530
  671560
  547543
  650511
  784771
  424643
  693502
  733518
  753762
  712801
  785685
  751412
  494291
  708226
  603286
  514658
  478992
  419646
  779840
  714927
  626576
  805139
]
6.67 ms
(5.26%)
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:
[
  "masturbating squirt"
  "masturbating squirt"
  "masturbating squirt"
  20
]
3.47 ms
(2.73%)
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
  398099
  418035
  419646
  424643
  439260
  478992
  494291
  502877
  514658
  516570
  533785
  538530
  545001
  547543
  561495
  569309
  587244
  603286
  618326
  626576
  643005
  648437
  650511
  650663
  664972
  671560
  678837
  685509
  693502
  701292
  701770
  708226
  711597
  712801
  714927
  725435
  726459
  733518
  736017
  739810
  749081
  751315
  751412
  751645
  753762
  779840
  783218
  784771
  785685
  786339
  787771
  787779
  791857
  793201
  795983
  802243
  802315
  805139
  810165
  811644
  818686
  820311
  824754
  826234
]
2.08 ms
(1.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "masturbating squirt"
]
1.77 ms
(1.39%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "masturbating сквирт оргазм"
]
1.73 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "masturbating сквирт оргазм"
]
1.69 ms
(1.33%)
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.