GET https://search.jues.net/search/embeds?q=girls%20cuming

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
206.72 ms
(73.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
49.25 ms
(17.43%)
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
  407045
  445015
  461639
  493230
  521030
  527142
  528640
  543611
  588073
  590803
  597667
  603046
  607180
  630731
  637597
  638544
  652129
  656647
  663222
  682623
  695851
  699543
  702498
  714091
  730503
  733789
  737310
  750276
  761942
  761943
  773786
  778528
  779659
  784097
  785150
  786856
  790630
  790828
  799456
  802009
  810150
  819299
]
10.49 ms
(3.71%)
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
  785150
  652129
  493230
  588073
  778528
  761942
  761943
  819299
  784097
  702498
  810150
  682623
  638544
  750276
  656647
  790630
  699543
  730503
  802009
  733789
  779659
  786856
  603046
  597667
  737310
  790828
  773786
  695851
  521030
  407045
  714091
  607180
  799456
  461639
  590803
  630731
  543611
  637597
  663222
  445015
  528640
  527142
]
8.94 ms
(3.16%)
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:
[
  "girls cuming"
  "girls cuming"
  "girls cuming"
  20
]
2.53 ms
(0.89%)
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
  407045
  445015
  461639
  493230
  521030
  527142
  528640
  543611
  588073
  590803
  597667
  603046
  607180
  630731
  637597
  638544
  652129
  656647
  663222
  682623
  695851
  699543
  702498
  714091
  730503
  733789
  737310
  750276
  761942
  761943
  773786
  778528
  779659
  784097
  785150
  786856
  790630
  790828
  799456
  802009
  810150
  819299
]
1.93 ms
(0.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girls cuming"
]
1.37 ms
(0.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк cuming"
]
1.33 ms
(0.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк cuming"
]

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.