GET https://search.jues.net/search/embeds?q=mature%20drilling

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
60.57 ms
(63.76%)
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
  193666
  407586
  415004
  462461
  468100
  468359
  469568
  492992
  499077
  501997
  511855
  514594
  527923
  533586
  555789
  556759
  590079
  593606
  610042
  614231
  665892
  667665
  668528
  677303
  680704
  681297
  706888
  707322
  716218
  721955
  734373
  797443
  800384
  800426
  802514
  805706
  806201
  811649
  812834
  817537
  817687
]
16.31 ms
(17.17%)
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:
[
  "mature drilling"
  "mature drilling"
  "mature drilling"
  20
]
7.18 ms
(7.56%)
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
  817687
  680704
  706888
  811649
  805706
  721955
  556759
  802514
  667665
  734373
  716218
  800426
  468359
  800384
  499077
  806201
  610042
  501997
  817537
  665892
  593606
  492992
  681297
  614231
  797443
  193666
  533586
  407586
  468100
  511855
  812834
  527923
  462461
  469568
  707322
  590079
  415004
  668528
  514594
  677303
  555789
]
3.14 ms
(3.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
  193666
  407586
  415004
  462461
  468100
  468359
  469568
  492992
  499077
  501997
  511855
  514594
  527923
  533586
  555789
  556759
  590079
  593606
  610042
  614231
  665892
  667665
  668528
  677303
  680704
  681297
  706888
  707322
  716218
  721955
  734373
  797443
  800384
  800426
  802514
  805706
  806201
  811649
  812834
  817537
  817687
]
2.37 ms
(2.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature drilling"
]
1.95 ms
(2.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature drilling"
]
1.87 ms
(1.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(1.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature drilling"
]

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.