GET https://search.jues.net/search/embeds?q=girlfriend%20squirt

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
226.42 ms
(39.10%)
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
  751868
  434368
  610680
  577608
  500875
  533276
  753724
  766347
  766721
  734017
  473607
  827901
  517846
  731835
  438878
  693024
  790198
  651912
  636487
  787480
  535279
  516652
  823833
  602627
  779194
  402848
  563719
  801966
  646669
  619885
  427248
  448097
  552585
  498033
  467888
  460857
  628463
  564551
  742865
  533275
  784519
  742817
  595369
  579512
  580880
  596235
]
218.03 ms
(37.66%)
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:
[
  "girlfriend squirt"
  "girlfriend squirt"
  "girlfriend squirt"
  20
]
124.68 ms
(21.53%)
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
  402848
  427248
  434368
  438878
  448097
  460857
  467888
  473607
  498033
  500875
  516652
  517846
  533275
  533276
  535279
  552585
  563719
  564551
  577608
  579512
  580880
  595369
  596235
  602627
  610680
  619885
  628463
  636487
  646669
  651912
  693024
  731835
  734017
  742817
  742865
  751868
  753724
  766347
  766721
  779194
  784519
  787480
  790198
  801966
  823833
  827901
]
2.70 ms
(0.47%)
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
  402848
  427248
  434368
  438878
  448097
  460857
  467888
  473607
  498033
  500875
  516652
  517846
  533275
  533276
  535279
  552585
  563719
  564551
  577608
  579512
  580880
  595369
  596235
  602627
  610680
  619885
  628463
  636487
  646669
  651912
  693024
  731835
  734017
  742817
  742865
  751868
  753724
  766347
  766721
  779194
  784519
  787480
  790198
  801966
  823833
  827901
]
2.09 ms
(0.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girlfriend squirt"
]
1.95 ms
(0.34%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "girlfriend сквирт оргазм"
]
1.45 ms
(0.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "girlfriend сквирт оргазм"
]

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.