GET https://search.jues.net/search/embeds/2?q=hairy%20asian%20anal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
100.21 ms
(53.68%)
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
  338587
  402626
  414126
  418057
  418188
  420050
  422546
  422599
  422604
  422618
  422633
  422638
  422652
  423267
  425365
  425993
  429608
  431540
  448811
  448821
  449435
  451259
  463798
  464651
  468705
  469520
  469527
  469576
  478437
  532838
  535039
  536216
  538270
  540195
  543872
  543874
  547241
  550618
  550750
  551987
  552010
  554425
  566007
  579389
  583468
  583501
  586619
  600492
  604429
  614401
  619439
  621029
  622204
  622990
  642063
  650380
  662197
  663537
  680498
  694563
  788187
  803450
  818442
  823174
]
65.74 ms
(35.22%)
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:
[
  "hairy asian anal"
  "hairy asian anal"
  "hairy asian anal"
  20
]
10.68 ms
(5.72%)
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
  422604
  422652
  469520
  469576
  448811
  788187
  422638
  451259
  621029
  422546
  803450
  429608
  551987
  543872
  538270
  579389
  586619
  449435
  422618
  583501
  818442
  540195
  694563
  600492
  422633
  422599
  431540
  338587
  425365
  478437
  583468
  619439
  418188
  536216
  550618
  420050
  662197
  402626
  550750
  566007
  469527
  464651
  468705
  535039
  463798
  414126
  547241
  554425
  823174
  680498
  622990
  423267
  532838
  418057
  614401
  552010
  448821
  642063
  622204
  543874
  663537
  425993
  650380
  604429
]
2.37 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy asian anal"
]
2.27 ms
(1.22%)
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
  338587
  402626
  414126
  418057
  418188
  420050
  422546
  422599
  422604
  422618
  422633
  422638
  422652
  423267
  425365
  425993
  429608
  431540
  448811
  448821
  449435
  451259
  463798
  464651
  468705
  469520
  469527
  469576
  478437
  532838
  535039
  536216
  538270
  540195
  543872
  543874
  547241
  550618
  550750
  551987
  552010
  554425
  566007
  579389
  583468
  583501
  586619
  600492
  604429
  614401
  619439
  621029
  622204
  622990
  642063
  650380
  662197
  663537
  680498
  694563
  788187
  803450
  818442
  823174
]
1.92 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая азиатк анал"
]
1.77 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "волосатая азиатк анал"
]
1.73 ms
(0.93%)
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.