GET https://search.jues.net/search/embeds/2?q=slender%20girl

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
84.34 ms
(70.01%)
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
  419492
  427248
  429272
  444048
  455473
  455595
  456331
  464952
  465946
  472678
  472722
  480315
  483288
  483550
  487219
  487891
  490521
  492518
  493469
  498022
  498961
  500658
  505225
  505648
  509640
  514404
  520002
  521386
  524611
  525559
  526470
  528452
  529105
  554226
  555017
  560777
  561834
  563975
  565324
  577177
  579534
  590228
  596991
  599534
  599553
  600097
  603154
  603583
  619858
  619894
  620786
  628431
  669324
  676463
  747966
]
15.60 ms
(12.95%)
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:
[
  "slender girl"
  "slender girl"
  "slender girl"
  20
]
11.09 ms
(9.20%)
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
  560777
  628431
  487891
  509640
  669324
  455595
  524611
  561834
  579534
  599553
  603583
  472722
  487219
  747966
  483288
  500658
  490521
  456331
  555017
  480315
  493469
  596991
  472678
  505648
  429272
  521386
  563975
  577177
  498961
  464952
  505225
  590228
  620786
  525559
  419492
  565324
  427248
  603154
  619858
  444048
  455473
  529105
  554226
  676463
  520002
  492518
  514404
  600097
  619894
  526470
  465946
  528452
  498022
  599534
  483550
]
2.26 ms
(1.88%)
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
  419492
  427248
  429272
  444048
  455473
  455595
  456331
  464952
  465946
  472678
  472722
  480315
  483288
  483550
  487219
  487891
  490521
  492518
  493469
  498022
  498961
  500658
  505225
  505648
  509640
  514404
  520002
  521386
  524611
  525559
  526470
  528452
  529105
  554226
  555017
  560777
  561834
  563975
  565324
  577177
  579534
  590228
  596991
  599534
  599553
  600097
  603154
  603583
  619858
  619894
  620786
  628431
  669324
  676463
  747966
]
1.99 ms
(1.65%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "slender девушк"
]
1.96 ms
(1.63%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "slender girl"
]
1.66 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "slender девушк"
]
1.56 ms
(1.30%)
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.