GET https://search.jues.net/search/embeds?q=solo%20latin%20girl

Query Metrics

9 Database Queries
9 Different statements
326.45 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
213.83 ms
(65.50%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло latin девушк"
]
49.05 ms
(15.03%)
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
  188450
  340613
  395655
  428710
  433721
  452757
  469084
  471086
  474989
  488817
  500758
  545499
  566596
  568195
  568289
  575624
  578654
  580234
  580522
  584193
  585050
  585483
  585589
  587467
  601807
  602153
  617538
  620480
  632121
  644793
  657543
  667382
  760367
  764361
  796401
  796994
  801016
  809046
]
45.75 ms
(14.01%)
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:
[
  "solo latin girl"
  "solo latin girl"
  "solo latin girl"
  20
]
6.94 ms
(2.13%)
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
  188450
  585483
  796401
  575624
  568289
  796994
  760367
  602153
  617538
  667382
  471086
  566596
  545499
  587467
  644793
  395655
  585589
  764361
  340613
  568195
  801016
  657543
  433721
  584193
  620480
  809046
  601807
  469084
  578654
  580234
  580522
  452757
  474989
  632121
  488817
  428710
  585050
  500758
]
2.73 ms
(0.84%)
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
  188450
  340613
  395655
  428710
  433721
  452757
  469084
  471086
  474989
  488817
  500758
  545499
  566596
  568195
  568289
  575624
  578654
  580234
  580522
  584193
  585050
  585483
  585589
  587467
  601807
  602153
  617538
  620480
  632121
  644793
  657543
  667382
  760367
  764361
  796401
  796994
  801016
  809046
]
2.38 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "solo latin girl"
]
2.31 ms
(0.71%)
1
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
  b"\x01–ø« :sº„h°B¢¸@Ä"
]
1.76 ms
(0.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "соло latin девушк"
]
1.70 ms
(0.52%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.