GET https://search.jues.net/search/embeds/2?q=erotic%20fuck%20asian

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
91.91 ms
(67.08%)
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
  105093
  384960
  422863
  422997
  423396
  446816
  452781
  455981
  464690
  465234
  468705
  484050
  493852
  500679
  503334
  503479
  510575
  510953
  524369
  527217
  541084
  546783
  547518
  564601
  565978
  565987
  567354
  575715
  581797
  592990
  593506
  596862
  598133
  600577
  601742
  614853
  622106
  622188
  629374
  636442
  645526
  652827
  659025
  680706
  693059
  740268
  790200
]
24.67 ms
(18.00%)
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:
[
  "erotic fuck asian"
  "erotic fuck asian"
  "erotic fuck asian"
  20
]
9.63 ms
(7.03%)
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
  592990
  622106
  565978
  503334
  510953
  547518
  565987
  593506
  422997
  629374
  636442
  564601
  422863
  105093
  601742
  484050
  652827
  510575
  423396
  622188
  680706
  465234
  790200
  575715
  527217
  693059
  614853
  567354
  645526
  596862
  384960
  493852
  500679
  446816
  524369
  468705
  464690
  581797
  740268
  503479
  598133
  541084
  546783
  659025
  452781
  455981
  600577
]
3.19 ms
(2.33%)
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
  105093
  384960
  422863
  422997
  423396
  446816
  452781
  455981
  464690
  465234
  468705
  484050
  493852
  500679
  503334
  503479
  510575
  510953
  524369
  527217
  541084
  546783
  547518
  564601
  565978
  565987
  567354
  575715
  581797
  592990
  593506
  596862
  598133
  600577
  601742
  614853
  622106
  622188
  629374
  636442
  645526
  652827
  659025
  680706
  693059
  740268
  790200
]
2.30 ms
(1.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "erotic fuck asian"
]
1.91 ms
(1.40%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "эротик секс азиатк"
]
1.82 ms
(1.33%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.