GET https://search.jues.net/search/embeds/5?q=russian%20doggystyle

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.01 ms
(73.71%)
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
  415836
  423123
  424261
  429880
  435794
  438372
  443374
  446991
  450851
  451476
  451478
  452363
  455316
  463087
  466010
  469641
  485147
  492972
  493426
  500016
  503336
  503915
  504473
  505639
  507056
  507673
  510321
  513360
  515371
  517123
  519128
  520044
  523171
  524688
  525259
  527370
  527810
  542089
  564980
  564992
  569312
  590488
  598485
  601580
  601630
  603953
  617613
  618711
  619549
  620757
  621171
  627089
  662412
]
27.17 ms
(14.94%)
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:
[
  "russian doggystyle"
  "russian doggystyle"
  "russian doggystyle"
  20
]
11.47 ms
(6.31%)
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
  569312
  564980
  590488
  618711
  621171
  438372
  455316
  451478
  469641
  429880
  446991
  466010
  503336
  503915
  507056
  527370
  500016
  504473
  524688
  492972
  505639
  507673
  519128
  513360
  517123
  520044
  527810
  450851
  510321
  423123
  451476
  424261
  463087
  443374
  493426
  515371
  525259
  542089
  564992
  452363
  619549
  627089
  601580
  435794
  485147
  617613
  415836
  523171
  662412
  598485
  603953
  620757
  601630
]
2.38 ms
(1.31%)
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
  415836
  423123
  424261
  429880
  435794
  438372
  443374
  446991
  450851
  451476
  451478
  452363
  455316
  463087
  466010
  469641
  485147
  492972
  493426
  500016
  503336
  503915
  504473
  505639
  507056
  507673
  510321
  513360
  515371
  517123
  519128
  520044
  523171
  524688
  525259
  527370
  527810
  542089
  564980
  564992
  569312
  590488
  598485
  601580
  601630
  603953
  617613
  618711
  619549
  620757
  621171
  627089
  662412
]
1.81 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian doggystyle"
]
1.80 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск doggystyle"
]
1.64 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск doggystyle"
]

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.