GET https://search.jues.net/search/embeds?q=sleeping%20mom%20cum

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
55.95 ms
(50.21%)
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
  386949
  426535
  439702
  445707
  455788
  466192
  482277
  486536
  521761
  556817
  560511
  562938
  562964
  564647
  571976
  580160
  583294
  584752
  588078
  609827
  613319
  617639
  683978
  712201
  726621
  726882
  742839
  744165
  760684
  764137
  777734
  780427
  785180
  796202
  796212
  796214
  800234
  800934
  805361
  811923
  817728
  824810
]
38.75 ms
(34.77%)
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:
[
  "sleeping mom cum"
  "sleeping mom cum"
  "sleeping mom cum"
  20
]
7.22 ms
(6.48%)
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
  617639
  760684
  386949
  817728
  712201
  780427
  796202
  742839
  726621
  800234
  796212
  583294
  683978
  785180
  805361
  744165
  764137
  796214
  800934
  811923
  482277
  466192
  455788
  777734
  613319
  556817
  609827
  726882
  521761
  580160
  562938
  426535
  562964
  571976
  445707
  584752
  588078
  439702
  486536
  824810
  564647
  560511
]
2.31 ms
(2.07%)
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
  386949
  426535
  439702
  445707
  455788
  466192
  482277
  486536
  521761
  556817
  560511
  562938
  562964
  564647
  571976
  580160
  583294
  584752
  588078
  609827
  613319
  617639
  683978
  712201
  726621
  726882
  742839
  744165
  760684
  764137
  777734
  780427
  785180
  796202
  796212
  796214
  800234
  800934
  805361
  811923
  817728
  824810
]
2.00 ms
(1.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sleeping mom cum"
]
1.81 ms
(1.62%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "спящ mom cum"
]
1.72 ms
(1.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "спящ mom cum"
]
1.68 ms
(1.51%)
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.