GET https://search.jues.net/search/embeds?q=fucks%20big%20woman

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
64.42 ms
(60.54%)
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
  386350
  400361
  420903
  429089
  440631
  449086
  451627
  460204
  464299
  465628
  467255
  474722
  484556
  499990
  501066
  503933
  512533
  515914
  525941
  538835
  542507
  550983
  573451
  582578
  584679
  598045
  610600
  620662
  663982
  665096
  665102
  665429
  667025
  679441
  702232
  705999
  710026
  710348
  723867
  726592
  730408
  735851
  735893
  744585
  749621
  797499
  810954
]
25.16 ms
(23.65%)
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:
[
  "fucks big woman"
  "fucks big woman"
  "fucks big woman"
  20
]
6.86 ms
(6.44%)
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
  538835
  723867
  702232
  730408
  665429
  598045
  735851
  710026
  710348
  620662
  810954
  744585
  749621
  797499
  582578
  550983
  667025
  451627
  474722
  679441
  735893
  705999
  665096
  386350
  503933
  460204
  584679
  663982
  542507
  726592
  400361
  420903
  665102
  573451
  610600
  429089
  501066
  440631
  467255
  464299
  499990
  465628
  515914
  484556
  449086
  525941
  512533
]
2.70 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
  386350
  400361
  420903
  429089
  440631
  449086
  451627
  460204
  464299
  465628
  467255
  474722
  484556
  499990
  501066
  503933
  512533
  515914
  525941
  538835
  542507
  550983
  573451
  582578
  584679
  598045
  610600
  620662
  663982
  665096
  665102
  665429
  667025
  679441
  702232
  705999
  710026
  710348
  723867
  726592
  730408
  735851
  735893
  744585
  749621
  797499
  810954
]
2.00 ms
(1.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fucks big woman"
]
1.90 ms
(1.78%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "fucks большие woman"
]
1.81 ms
(1.70%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(1.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "fucks большие woman"
]

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.