GET https://search.jues.net/search/embeds?q=girl%20sex%20horse

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
75.27 ms
(47.48%)
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
  389667
  396730
  405112
  432929
  452800
  471127
  474284
  493467
  497471
  497474
  497692
  528775
  529799
  531839
  531844
  536224
  544132
  544829
  545395
  545407
  545422
  548857
  553946
  559112
  564293
  574388
  580857
  591094
  592259
  599906
  604824
  608773
  614975
  634109
  642076
  666854
  672927
  680252
  686130
  689016
  692100
  695477
  717520
  754012
  759490
  763762
  770818
  782839
  785880
  792279
  808976
]
63.40 ms
(39.99%)
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:
[
  "girl sex horse"
  "girl sex horse"
  "girl sex horse"
  20
]
10.30 ms
(6.50%)
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
  536224
  529799
  599906
  792279
  692100
  754012
  763762
  396730
  808976
  497471
  548857
  689016
  544132
  770818
  642076
  695477
  759490
  680252
  717520
  531839
  545422
  634109
  782839
  553946
  580857
  785880
  544829
  545395
  666854
  531844
  564293
  604824
  672927
  686130
  474284
  471127
  608773
  497474
  389667
  493467
  452800
  559112
  528775
  497692
  545407
  405112
  592259
  574388
  432929
  614975
  591094
]
2.35 ms
(1.48%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.99 ms
(1.25%)
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
  389667
  396730
  405112
  432929
  452800
  471127
  474284
  493467
  497471
  497474
  497692
  528775
  529799
  531839
  531844
  536224
  544132
  544829
  545395
  545407
  545422
  548857
  553946
  559112
  564293
  574388
  580857
  591094
  592259
  599906
  604824
  608773
  614975
  634109
  642076
  666854
  672927
  680252
  686130
  689016
  692100
  695477
  717520
  754012
  759490
  763762
  770818
  782839
  785880
  792279
  808976
]
1.80 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк секс horse"
]
1.79 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girl sex horse"
]
1.62 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк секс horse"
]

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.