GET https://search.jues.net/search/embeds?q=anal%20brutal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
216.70 ms
(57.92%)
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
  387026
  445431
  448874
  447640
  446257
  817336
  742846
  717221
  493561
  428062
  508940
  730364
  6958
  447022
  758119
  410227
  826170
  400967
  61536
  398089
  389997
  714140
  720281
  758579
  424593
  384593
  382304
  811450
  403690
  811822
  390472
  448880
  462287
  401625
  793438
  443317
  446673
  670227
  748538
  209664
  454524
  447298
  423663
  414048
  88286
  414077
  383375
  405712
  448873
  431540
  391450
  632601
  628093
  388059
]
84.69 ms
(22.64%)
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
  6958
  61536
  88286
  209664
  382304
  383375
  384593
  387026
  388059
  389997
  390472
  391450
  398089
  400967
  401625
  403690
  405712
  410227
  414048
  414077
  423663
  424593
  428062
  431540
  443317
  445431
  446257
  446673
  447022
  447298
  447640
  448873
  448874
  448880
  454524
  462287
  493561
  508940
  628093
  632601
  670227
  714140
  717221
  720281
  730364
  742846
  748538
  758119
  758579
  793438
  811450
  811822
  817336
]
61.57 ms
(16.46%)
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:
[
  "anal brutal"
  "anal brutal"
  "anal brutal"
  20
]
3.08 ms
(0.82%)
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
  6958
  61536
  88286
  209664
  382304
  383375
  384593
  387026
  388059
  389997
  390472
  391450
  398089
  400967
  401625
  403690
  405712
  410227
  414048
  414077
  423663
  424593
  428062
  431540
  443317
  445431
  446257
  446673
  447022
  447298
  447640
  448873
  448874
  448880
  454524
  462287
  493561
  508940
  628093
  632601
  670227
  714140
  717221
  720281
  730364
  742846
  748538
  758119
  758579
  793438
  811450
  811822
  817336
]
2.30 ms
(0.61%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.21 ms
(0.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal brutal"
]
1.91 ms
(0.51%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал brutal"
]
1.67 ms
(0.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал brutal"
]

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.