GET https://search.jues.net/search/embeds?q=milf%20creampie%20video

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
56.44 ms
(51.46%)
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
  440393
  452330
  452869
  457946
  466873
  475575
  500916
  512937
  519735
  519738
  526830
  537251
  538924
  538954
  539466
  540095
  564121
  565008
  567399
  567622
  579471
  580113
  597282
  604704
  612068
  625436
  625437
  632295
  635678
  639278
  642389
  643783
  645270
  690050
  714623
  722159
  748014
  756399
  764234
  768032
  775264
  791209
  791561
  794163
  823720
  824190
]
31.23 ms
(28.48%)
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 creampie video"
  "milf creampie video"
  "milf creampie video"
  20
]
11.32 ms
(10.33%)
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
  748014
  538924
  538954
  722159
  791561
  639278
  643783
  632295
  823720
  824190
  539466
  440393
  567622
  775264
  794163
  756399
  540095
  764234
  466873
  452330
  690050
  714623
  604704
  768032
  512937
  579471
  567399
  642389
  519738
  452869
  500916
  564121
  565008
  791209
  612068
  519735
  526830
  597282
  580113
  645270
  625436
  635678
  457946
  475575
  625437
  537251
]
2.78 ms
(2.54%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.41 ms
(2.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf creampie video"
]
2.26 ms
(2.06%)
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
  440393
  452330
  452869
  457946
  466873
  475575
  500916
  512937
  519735
  519738
  526830
  537251
  538924
  538954
  539466
  540095
  564121
  565008
  567399
  567622
  579471
  580113
  597282
  604704
  612068
  625436
  625437
  632295
  635678
  639278
  642389
  643783
  645270
  690050
  714623
  722159
  748014
  756399
  764234
  768032
  775264
  791209
  791561
  794163
  823720
  824190
]
1.83 ms
(1.67%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf creampie video"
]
1.39 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf creampie video"
]

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.