GET https://search.jues.net/search/embeds?q=extreme%20stretch

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
60.68 ms
(72.85%)
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
  400802
  415957
  416527
  416688
  435521
  450557
  459429
  477084
  493272
  494530
  495568
  520775
  524799
  531175
  532854
  534530
  537653
  556906
  559783
  572655
  575859
  597502
  610475
  642706
  662850
  665950
  666876
  667747
  676026
  707571
  713192
  735120
  735129
  735703
  740926
  742320
  744047
  744408
  745126
  745874
  745921
  751773
  752683
  752704
  752753
  777337
  780541
  784622
  796694
  797311
  801639
  803824
  811690
  812562
]
9.04 ms
(10.85%)
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
  667747
  524799
  735129
  745921
  665950
  780541
  735120
  744408
  796694
  812562
  797311
  784622
  459429
  575859
  707571
  572655
  740926
  597502
  801639
  416527
  493272
  744047
  752753
  610475
  534530
  556906
  559783
  803824
  742320
  751773
  735703
  745874
  435521
  494530
  400802
  662850
  752683
  745126
  416688
  450557
  477084
  811690
  752704
  777337
  531175
  532854
  713192
  495568
  415957
  666876
  676026
  520775
  642706
  537653
]
4.50 ms
(5.41%)
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:
[
  "extreme stretch"
  "extreme stretch"
  "extreme stretch"
  20
]
2.20 ms
(2.64%)
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
  400802
  415957
  416527
  416688
  435521
  450557
  459429
  477084
  493272
  494530
  495568
  520775
  524799
  531175
  532854
  534530
  537653
  556906
  559783
  572655
  575859
  597502
  610475
  642706
  662850
  665950
  666876
  667747
  676026
  707571
  713192
  735120
  735129
  735703
  740926
  742320
  744047
  744408
  745126
  745874
  745921
  751773
  752683
  752704
  752753
  777337
  780541
  784622
  796694
  797311
  801639
  803824
  811690
  812562
]
1.99 ms
(2.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "extreme stretch"
]
1.72 ms
(2.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "хардкор stretch"
]
1.59 ms
(1.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "хардкор stretch"
]
1.57 ms
(1.88%)
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.