GET https://search.jues.net/search/embeds?q=stop%20cumming%20big

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
46.22 ms
(54.72%)
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
  396811
  399222
  425711
  435706
  445384
  447232
  452990
  459793
  461664
  463008
  477243
  487241
  506677
  521545
  545440
  554408
  570862
  575610
  577107
  648900
  697579
  714300
  721503
  745011
  747096
  760592
  763818
  767537
  770663
  779088
  781274
  781308
  784164
  785990
  793298
  794375
  802276
  803664
  804604
  807347
  807351
  808785
]
21.92 ms
(25.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:
[
  "stop cumming big"
  "stop cumming big"
  "stop cumming big"
  20
]
6.89 ms
(8.16%)
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
  803664
  459793
  747096
  760592
  804604
  781274
  745011
  763818
  767537
  802276
  399222
  784164
  807351
  721503
  697579
  577107
  648900
  793298
  781308
  785990
  807347
  714300
  396811
  779088
  452990
  461664
  487241
  570862
  575610
  808785
  794375
  463008
  554408
  477243
  770663
  447232
  445384
  425711
  435706
  506677
  521545
  545440
]
2.14 ms
(2.53%)
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
  396811
  399222
  425711
  435706
  445384
  447232
  452990
  459793
  461664
  463008
  477243
  487241
  506677
  521545
  545440
  554408
  570862
  575610
  577107
  648900
  697579
  714300
  721503
  745011
  747096
  760592
  763818
  767537
  770663
  779088
  781274
  781308
  784164
  785990
  793298
  794375
  802276
  803664
  804604
  807347
  807351
  808785
]
1.89 ms
(2.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "stop cumming big"
]
1.82 ms
(2.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(2.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "stop cumming большие"
]
1.79 ms
(2.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "stop cumming большие"
]

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.