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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
86.58 ms
(47.37%)
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
  396707
  416364
  417801
  419370
  423329
  428276
  428353
  433339
  448811
  452097
  452136
  452895
  457064
  463842
  466404
  476098
  476106
  476299
  476706
  477210
  478930
  484673
  486788
  487746
  490684
  512447
  516291
  521850
  530061
  530377
  532849
  533042
  534316
  534823
  537661
  541588
  541614
  541643
  541667
  541683
  542195
  549173
  559183
  563535
  593992
  603241
  607261
  607707
  639712
  646884
  650380
  666528
  676023
  737127
  808579
  811826
]
74.62 ms
(40.82%)
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:
[
  "interracial anal ffm"
  "interracial anal ffm"
  "interracial anal ffm"
  20
]
11.30 ms
(6.18%)
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
  476299
  808579
  486788
  534823
  737127
  603241
  534316
  646884
  457064
  448811
  516291
  416364
  417801
  521850
  563535
  396707
  490684
  478930
  676023
  666528
  477210
  537661
  607707
  452895
  476706
  476098
  650380
  419370
  487746
  559183
  532849
  639712
  428276
  541667
  423329
  811826
  476106
  593992
  549173
  541643
  428353
  433339
  607261
  484673
  452097
  530061
  530377
  533042
  542195
  541614
  452136
  541683
  463842
  466404
  541588
  512447
]
2.56 ms
(1.40%)
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
  396707
  416364
  417801
  419370
  423329
  428276
  428353
  433339
  448811
  452097
  452136
  452895
  457064
  463842
  466404
  476098
  476106
  476299
  476706
  477210
  478930
  484673
  486788
  487746
  490684
  512447
  516291
  521850
  530061
  530377
  532849
  533042
  534316
  534823
  537661
  541588
  541614
  541643
  541667
  541683
  542195
  549173
  559183
  563535
  593992
  603241
  607261
  607707
  639712
  646884
  650380
  666528
  676023
  737127
  808579
  811826
]
2.21 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "interracial anal ffm"
]
2.11 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "межрасов анал жмж секс втро"
]
1.83 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "межрасов анал жмж секс втро"
]
1.57 ms
(0.86%)
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.