GET https://search.jues.net/search/embeds?q=busty%20friend

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.51 ms
(67.62%)
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
  387422
  408423
  409367
  418017
  441326
  446743
  448794
  451788
  452585
  453307
  453454
  471435
  480792
  498043
  498352
  505657
  519016
  525624
  542754
  543998
  547261
  584329
  619399
  625467
  625770
  651285
  665970
  693273
  719350
  722707
  723986
  731661
  742636
  769641
  772011
  774287
  787002
  790962
  793223
  798317
  807544
  807944
  812674
  824935
  828194
  828289
]
75.31 ms
(24.07%)
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
  387422
  408423
  409367
  418017
  441326
  446743
  448794
  451788
  452585
  453307
  453454
  471435
  480792
  498043
  498352
  505657
  519016
  525624
  542754
  543998
  547261
  584329
  619399
  625467
  625770
  651285
  665970
  693273
  719350
  722707
  723986
  731661
  742636
  769641
  772011
  774287
  787002
  790962
  793223
  798317
  807544
  807944
  812674
  824935
  828194
  828289
]
9.06 ms
(2.90%)
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:
[
  "busty friend"
  "busty friend"
  "busty friend"
  20
]
8.86 ms
(2.83%)
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
  722707
  543998
  731661
  418017
  719350
  693273
  723986
  451788
  441326
  446743
  828289
  828194
  772011
  665970
  798317
  387422
  793223
  769641
  547261
  807544
  787002
  408423
  409367
  824935
  448794
  584329
  625467
  453454
  480792
  790962
  807944
  812674
  774287
  505657
  471435
  452585
  498352
  542754
  651285
  619399
  742636
  453307
  519016
  525624
  625770
  498043
]
2.19 ms
(0.70%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.16 ms
(0.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "busty friend"
]
2.03 ms
(0.65%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "busty friend"
]
1.68 ms
(0.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "busty friend"
]

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.