GET https://search.jues.net/search/embeds?q=foreskin%20dick

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
107.45 ms
(77.10%)
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
  397502
  398139
  398602
  399893
  399899
  399917
  411501
  411513
  411518
  411520
  422259
  424539
  457522
  463801
  465735
  465743
  465761
  465796
  472564
  488774
  513321
  515260
  528263
  530104
  530111
  530114
  530116
  530117
  533441
  561809
  592974
  609935
  616783
  616995
  624599
  627074
  644214
  655456
  673869
  697392
  704145
  710292
  719219
  723457
  723464
  725055
  728633
  730991
  741266
  743902
  746854
  767485
  772349
  780270
  791634
  795797
  795804
  797964
  809888
  809916
  809922
]
12.57 ms
(9.02%)
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:
[
  "foreskin dick"
  "foreskin dick"
  "foreskin dick"
  20
]
9.47 ms
(6.79%)
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
  422259
  399917
  399893
  530117
  746854
  723464
  644214
  795797
  533441
  795804
  772349
  730991
  743902
  728633
  530114
  725055
  399899
  723457
  780270
  809888
  697392
  609935
  515260
  616783
  397502
  741266
  398602
  472564
  465796
  465743
  411501
  704145
  710292
  465761
  513321
  561809
  719219
  411520
  465735
  424539
  398139
  530116
  797964
  809922
  767485
  463801
  616995
  488774
  411513
  809916
  624599
  457522
  791634
  411518
  530111
  530104
  673869
  655456
  592974
  528263
  627074
]
2.96 ms
(2.13%)
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
  397502
  398139
  398602
  399893
  399899
  399917
  411501
  411513
  411518
  411520
  422259
  424539
  457522
  463801
  465735
  465743
  465761
  465796
  472564
  488774
  513321
  515260
  528263
  530104
  530111
  530114
  530116
  530117
  533441
  561809
  592974
  609935
  616783
  616995
  624599
  627074
  644214
  655456
  673869
  697392
  704145
  710292
  719219
  723457
  723464
  725055
  728633
  730991
  741266
  743902
  746854
  767485
  772349
  780270
  791634
  795797
  795804
  797964
  809888
  809916
  809922
]
2.21 ms
(1.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "foreskin dick"
]
1.72 ms
(1.24%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(1.23%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "foreskin член"
]
1.27 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "foreskin член"
]

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.