GET https://search.jues.net/search/embeds/9?q=ass%20gape%20compilation

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
244.08 ms
(68.96%)
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:
[
  "ass gape compilation"
  "ass gape compilation"
  "ass gape compilation"
  20
]
85.79 ms
(24.24%)
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
  410959
  415109
  417212
  419175
  422049
  427263
  429954
  433297
  434642
  439765
  443635
  444069
  448863
  451950
  452311
  453037
  455941
  465844
  469039
  471494
  473539
  475294
  476244
  476709
  481910
  486643
  504446
  509590
  511275
  518614
  525782
  531351
  541588
  541671
  541774
  541821
  541864
  542192
  542193
  542199
  543917
  544381
  544800
  560440
  564203
  568999
  573212
  580613
  583960
  591959
  593992
  597963
  604517
  605182
  612256
  626347
  630756
  632269
  642746
  695123
  803455
]
13.96 ms
(3.94%)
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
  451950
  525782
  509590
  511275
  434642
  439765
  544381
  543917
  583960
  531351
  541671
  573212
  429954
  427263
  433297
  455941
  476244
  518614
  605182
  541588
  612256
  560440
  481910
  422049
  443635
  452311
  469039
  542192
  568999
  544800
  630756
  803455
  604517
  632269
  476709
  473539
  541821
  626347
  542199
  486643
  415109
  417212
  541774
  695123
  593992
  597963
  410959
  448863
  504446
  444069
  642746
  542193
  580613
  475294
  419175
  453037
  541864
  564203
  471494
  465844
  591959
]
2.70 ms
(0.76%)
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
  410959
  415109
  417212
  419175
  422049
  427263
  429954
  433297
  434642
  439765
  443635
  444069
  448863
  451950
  452311
  453037
  455941
  465844
  469039
  471494
  473539
  475294
  476244
  476709
  481910
  486643
  504446
  509590
  511275
  518614
  525782
  531351
  541588
  541671
  541774
  541821
  541864
  542192
  542193
  542199
  543917
  544381
  544800
  560440
  564203
  568999
  573212
  580613
  583960
  591959
  593992
  597963
  604517
  605182
  612256
  626347
  630756
  632269
  642746
  695123
  803455
]
2.18 ms
(0.61%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ass gape compilation"
]
1.85 ms
(0.52%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.77 ms
(0.50%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп большая большие дырк подборк"
]
1.62 ms
(0.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.