GET https://search.jues.net/search/embeds?q=masturbation%20blonde%20spandex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
88.91 ms
(74.49%)
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
  133695
  176298
  313463
  346188
  383440
  385564
  389700
  389921
  407387
  410796
  418934
  421051
  425398
  427263
  428241
  430875
  435826
  436230
  439405
  444069
  446764
  452565
  453809
  457204
  463384
  464062
  468818
  471165
  471338
  476605
  506168
  513816
  517710
  518599
  520763
  521924
  536490
  544959
  547789
  572245
  575392
  591692
  606202
  618422
  627841
  654048
  654080
  735498
  754577
  765222
  770280
  770689
  773259
  784143
  784379
  786274
  787618
  810444
  828195
]
11.50 ms
(9.63%)
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:
[
  "masturbation blonde spandex"
  "masturbation blonde spandex"
  "masturbation blonde spandex"
  20
]
9.07 ms
(7.60%)
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
  385564
  471338
  313463
  446764
  513816
  754577
  346188
  786274
  618422
  627841
  536490
  773259
  828195
  784379
  735498
  770689
  430875
  133695
  654080
  784143
  654048
  770280
  547789
  463384
  439405
  383440
  810444
  787618
  544959
  572245
  468818
  410796
  457204
  176298
  575392
  517710
  407387
  435826
  765222
  452565
  421051
  436230
  506168
  425398
  428241
  521924
  591692
  476605
  389921
  606202
  389700
  444069
  418934
  427263
  471165
  518599
  453809
  520763
  464062
]
2.78 ms
(2.33%)
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
  133695
  176298
  313463
  346188
  383440
  385564
  389700
  389921
  407387
  410796
  418934
  421051
  425398
  427263
  428241
  430875
  435826
  436230
  439405
  444069
  446764
  452565
  453809
  457204
  463384
  464062
  468818
  471165
  471338
  476605
  506168
  513816
  517710
  518599
  520763
  521924
  536490
  544959
  547789
  572245
  575392
  591692
  606202
  618422
  627841
  654048
  654080
  735498
  754577
  765222
  770280
  770689
  773259
  784143
  784379
  786274
  787618
  810444
  828195
]
1.94 ms
(1.62%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "masturbation blonde spandex"
]
1.88 ms
(1.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мастурбац беловолосая лосин"
]
1.72 ms
(1.44%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мастурбац беловолосая лосин"
]
1.57 ms
(1.31%)
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.