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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
57.26 ms
(58.79%)
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
  61536
  88286
  343227
  382304
  384940
  398089
  401520
  403690
  410227
  412810
  413084
  414077
  417609
  423663
  428062
  428148
  443317
  447022
  447952
  448874
  454524
  475046
  485848
  493561
  508940
  513979
  550561
  567008
  604444
  700869
  720194
  720970
  728756
  730364
  745962
  758119
  793438
  800906
  811450
  817336
  826859
]
23.37 ms
(23.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:
[
  "milf brutal fuck"
  "milf brutal fuck"
  "milf brutal fuck"
  20
]
7.07 ms
(7.26%)
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
  817336
  410227
  720194
  493561
  550561
  700869
  720970
  428062
  508940
  826859
  730364
  61536
  343227
  567008
  728756
  417609
  793438
  447022
  758119
  513979
  475046
  800906
  412810
  811450
  384940
  485848
  403690
  382304
  398089
  448874
  401520
  428148
  443317
  745962
  604444
  454524
  88286
  423663
  414077
  413084
  447952
]
2.26 ms
(2.32%)
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
  61536
  88286
  343227
  382304
  384940
  398089
  401520
  403690
  410227
  412810
  413084
  414077
  417609
  423663
  428062
  428148
  443317
  447022
  447952
  448874
  454524
  475046
  485848
  493561
  508940
  513979
  550561
  567008
  604444
  700869
  720194
  720970
  728756
  730364
  745962
  758119
  793438
  800906
  811450
  817336
  826859
]
2.25 ms
(2.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf brutal fuck"
]
1.80 ms
(1.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf brutal секс"
]
1.72 ms
(1.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf brutal секс"
]
1.66 ms
(1.71%)
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.