GET https://search.jues.net/search/embeds?q=chinese%20girls%20anal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
65.47 ms
(44.51%)
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
  20907
  61051
  396784
  398354
  418053
  418844
  419139
  419906
  421056
  422543
  422958
  423280
  425435
  443523
  447273
  448536
  458094
  487188
  504963
  508926
  518011
  527011
  527484
  534023
  541084
  541849
  542904
  544964
  554425
  568034
  583468
  583491
  587545
  609121
  623261
  672248
  677712
  682936
  692714
  695725
  709688
  756113
  779560
  785525
  815137
]
58.88 ms
(40.03%)
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:
[
  "chinese girls anal"
  "chinese girls anal"
  "chinese girls anal"
  20
]
13.30 ms
(9.04%)
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
  398354
  61051
  448536
  709688
  527011
  487188
  692714
  672248
  518011
  583468
  542904
  418053
  587545
  20907
  443523
  418844
  419139
  396784
  419906
  458094
  422543
  423280
  422958
  421056
  568034
  779560
  527484
  682936
  583491
  815137
  695725
  425435
  785525
  504963
  447273
  534023
  544964
  609121
  554425
  756113
  677712
  508926
  541849
  541084
  623261
]
2.66 ms
(1.81%)
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
  20907
  61051
  396784
  398354
  418053
  418844
  419139
  419906
  421056
  422543
  422958
  423280
  425435
  443523
  447273
  448536
  458094
  487188
  504963
  508926
  518011
  527011
  527484
  534023
  541084
  541849
  542904
  544964
  554425
  568034
  583468
  583491
  587545
  609121
  623261
  672248
  677712
  682936
  692714
  695725
  709688
  756113
  779560
  785525
  815137
]
1.88 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "chinese girls anal"
]
1.73 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "китаянк азиатк девушк анал"
]
1.58 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.