GET https://search.jues.net/search/embeds?q=teen%20rubbing

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
241.54 ms
(73.23%)
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:
[
  "teen rubbing"
  "teen rubbing"
  "teen rubbing"
  20
]
70.60 ms
(21.41%)
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
  392303
  397542
  397680
  406095
  441678
  442467
  442481
  475173
  484510
  520829
  537774
  565492
  576444
  582836
  584304
  592325
  594255
  605462
  608007
  620992
  622290
  661421
  662833
  664105
  670811
  671070
  690218
  694407
  702980
  706436
  716941
  723072
  739305
  745715
  746292
  762651
  765660
  773164
  777882
  792165
  798673
  803134
  814683
  819857
]
6.97 ms
(2.11%)
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
  397680
  739305
  565492
  716941
  392303
  442467
  441678
  746292
  690218
  765660
  773164
  694407
  594255
  662833
  814683
  792165
  762651
  702980
  537774
  582836
  664105
  592325
  706436
  620992
  798673
  745715
  723072
  484510
  670811
  608007
  803134
  475173
  442481
  397542
  584304
  671070
  777882
  406095
  819857
  661421
  520829
  576444
  622290
  605462
]
2.77 ms
(0.84%)
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
  392303
  397542
  397680
  406095
  441678
  442467
  442481
  475173
  484510
  520829
  537774
  565492
  576444
  582836
  584304
  592325
  594255
  605462
  608007
  620992
  622290
  661421
  662833
  664105
  670811
  671070
  690218
  694407
  702980
  706436
  716941
  723072
  739305
  745715
  746292
  762651
  765660
  773164
  777882
  792165
  798673
  803134
  814683
  819857
]
2.16 ms
(0.65%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen rubbing"
]
2.14 ms
(0.65%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.96 ms
(0.59%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen rubbing"
]
1.68 ms
(0.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen rubbing"
]

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.