GET https://search.jues.net/search/embeds/2?q=sperm%20pussy%20eating

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
64.16 ms
(54.58%)
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
  421603
  426551
  445108
  446861
  449296
  449305
  449333
  452399
  458986
  459828
  462844
  467573
  472128
  493196
  493810
  494015
  496086
  500687
  501603
  501724
  502274
  503009
  504592
  508537
  514940
  517414
  518811
  519864
  524435
  527207
  533195
  540073
  541081
  542082
  556797
  587125
  587257
  588877
  592108
  596856
  601699
  604413
  612434
  621027
  635783
  637679
  647026
  649578
  707692
  719139
  724247
  733143
  810970
]
29.95 ms
(25.48%)
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:
[
  "sperm pussy eating"
  "sperm pussy eating"
  "sperm pussy eating"
  20
]
12.49 ms
(10.62%)
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
  445108
  519864
  647026
  449333
  503009
  587125
  621027
  449296
  733143
  527207
  446861
  604413
  637679
  452399
  500687
  504592
  719139
  533195
  449305
  501603
  810970
  540073
  592108
  472128
  524435
  421603
  494015
  518811
  467573
  493196
  502274
  508537
  462844
  493810
  724247
  517414
  459828
  514940
  501724
  601699
  496086
  707692
  458986
  542082
  426551
  649578
  588877
  587257
  596856
  556797
  541081
  635783
  612434
]
2.70 ms
(2.30%)
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
  421603
  426551
  445108
  446861
  449296
  449305
  449333
  452399
  458986
  459828
  462844
  467573
  472128
  493196
  493810
  494015
  496086
  500687
  501603
  501724
  502274
  503009
  504592
  508537
  514940
  517414
  518811
  519864
  524435
  527207
  533195
  540073
  541081
  542082
  556797
  587125
  587257
  588877
  592108
  596856
  601699
  604413
  612434
  621027
  635783
  637679
  647026
  649578
  707692
  719139
  724247
  733143
  810970
]
2.43 ms
(2.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sperm pussy eating"
]
2.21 ms
(1.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.02 ms
(1.72%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм pussy eating"
]
1.59 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сперм pussy eating"
]

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.