GET https://search.jues.net/search/embeds?q=ginger%20pussy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
95.25 ms
(72.39%)
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
  419407
  442236
  449012
  458419
  467168
  468693
  475056
  505526
  506529
  508493
  509897
  510396
  527447
  527898
  538768
  541369
  541479
  546837
  548028
  553720
  557577
  557707
  562894
  577666
  586307
  588877
  590891
  594179
  596223
  601675
  604580
  607518
  607626
  618916
  625774
  637701
  638576
  641789
  642462
  672622
  686824
  687282
  719333
  721646
  722399
  746487
  753465
  753477
  769532
  797850
  800568
  802640
  802781
  803133
  819043
  823891
]
18.24 ms
(13.86%)
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:
[
  "ginger pussy"
  "ginger pussy"
  "ginger pussy"
  20
]
8.76 ms
(6.66%)
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
  722399
  442236
  557577
  557707
  541479
  607626
  607518
  538768
  746487
  686824
  541369
  672622
  823891
  590891
  604580
  719333
  797850
  546837
  596223
  625774
  803133
  641789
  687282
  548028
  769532
  753477
  819043
  467168
  642462
  618916
  637701
  800568
  753465
  468693
  586307
  802781
  601675
  802640
  509897
  419407
  449012
  505526
  577666
  594179
  475056
  506529
  508493
  553720
  721646
  638576
  588877
  458419
  510396
  562894
  527447
  527898
]
2.26 ms
(1.71%)
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
  419407
  442236
  449012
  458419
  467168
  468693
  475056
  505526
  506529
  508493
  509897
  510396
  527447
  527898
  538768
  541369
  541479
  546837
  548028
  553720
  557577
  557707
  562894
  577666
  586307
  588877
  590891
  594179
  596223
  601675
  604580
  607518
  607626
  618916
  625774
  637701
  638576
  641789
  642462
  672622
  686824
  687282
  719333
  721646
  722399
  746487
  753465
  753477
  769532
  797850
  800568
  802640
  802781
  803133
  819043
  823891
]
1.86 ms
(1.42%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ginger pussy"
]
1.83 ms
(1.39%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ginger pussy"
]
1.61 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "ginger pussy"
]

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.