GET https://search.jues.net/search/embeds/2?q=bikini%20sex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
85.92 ms
(53.63%)
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
  35344
  383266
  414164
  418906
  423418
  434107
  440822
  440937
  445778
  447636
  450533
  456138
  458461
  458686
  459357
  460326
  463057
  466664
  471798
  486414
  489998
  490867
  492783
  497892
  512551
  513544
  517716
  528149
  531481
  532251
  537130
  538542
  543100
  544788
  558194
  559161
  562953
  568617
  574040
  579422
  582227
  585083
  592380
  595804
  602972
  604549
  617984
  620067
  633085
  642662
  644276
  647305
  649586
  650016
  653580
  694945
  752151
  755554
  785213
  805149
  815232
]
54.63 ms
(34.10%)
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:
[
  "bikini sex"
  "bikini sex"
  "bikini sex"
  20
]
10.85 ms
(6.77%)
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
  434107
  752151
  604549
  492783
  574040
  568617
  592380
  805149
  755554
  785213
  35344
  595804
  414164
  471798
  653580
  694945
  383266
  617984
  440937
  537130
  440822
  447636
  513544
  466664
  543100
  633085
  463057
  458686
  460326
  497892
  445778
  649586
  459357
  490867
  585083
  450533
  486414
  456138
  538542
  528149
  815232
  458461
  489998
  620067
  647305
  423418
  512551
  418906
  579422
  517716
  650016
  559161
  644276
  562953
  582227
  558194
  544788
  532251
  531481
  642662
  602972
]
2.45 ms
(1.53%)
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
  35344
  383266
  414164
  418906
  423418
  434107
  440822
  440937
  445778
  447636
  450533
  456138
  458461
  458686
  459357
  460326
  463057
  466664
  471798
  486414
  489998
  490867
  492783
  497892
  512551
  513544
  517716
  528149
  531481
  532251
  537130
  538542
  543100
  544788
  558194
  559161
  562953
  568617
  574040
  579422
  582227
  585083
  592380
  595804
  602972
  604549
  617984
  620067
  633085
  642662
  644276
  647305
  649586
  650016
  653580
  694945
  752151
  755554
  785213
  805149
  815232
]
1.86 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bikini sex"
]
1.74 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "bikini секс"
]
1.50 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.25 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "bikini секс"
]

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.