GET https://search.jues.net/search/embeds?q=sucking%20black%20big

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
102.54 ms
(60.72%)
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
  79388
  316911
  379330
  386728
  511499
  518587
  518975
  519766
  531082
  537840
  552958
  557243
  565372
  572901
  593279
  598020
  599631
  603623
  604295
  651003
  663321
  664260
  665004
  667826
  668145
  688222
  691724
  697062
  715833
  716882
  718203
  720176
  720253
  725058
  725451
  730769
  741296
  746999
  748437
  769700
  772681
  785661
  785688
  804647
  805474
  816862
  821916
  822961
]
47.76 ms
(28.28%)
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:
[
  "sucking black big"
  "sucking black big"
  "sucking black big"
  20
]
8.71 ms
(5.16%)
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
  697062
  816862
  805474
  821916
  725058
  665004
  518975
  785661
  748437
  668145
  688222
  785688
  746999
  379330
  599631
  664379
  730769
  664260
  769700
  804647
  552958
  741296
  519766
  772681
  537840
  718203
  822961
  663321
  720176
  386728
  725451
  715833
  511499
  691724
  651003
  316911
  518587
  720253
  79388
  531082
  572901
  598020
  593279
  565372
  667826
  716882
  603623
  604295
  557243
]
2.84 ms
(1.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sucking black big"
]
2.43 ms
(1.44%)
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
  79388
  316911
  379330
  386728
  511499
  518587
  518975
  519766
  531082
  537840
  552958
  557243
  565372
  572901
  593279
  598020
  599631
  603623
  604295
  651003
  663321
  664260
  665004
  667826
  668145
  688222
  691724
  697062
  715833
  716882
  718203
  720176
  720253
  725058
  725451
  730769
  741296
  746999
  748437
  769700
  772681
  785661
  785688
  804647
  805474
  816862
  821916
  822961
]
1.62 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "sucking black большие"
]
1.41 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "sucking black большие"
]

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.