GET https://search.jues.net/search/embeds/9?q=anal%20compilation%20stockings

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
55.61 ms
(44.14%)
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:
[
  "anal compilation stockings"
  "anal compilation stockings"
  "anal compilation stockings"
  20
]
51.87 ms
(41.17%)
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
  81734
  405921
  410959
  443112
  455898
  457963
  458619
  461937
  466989
  489831
  510108
  533014
  541630
  541633
  541643
  541644
  541656
  541667
  541671
  541751
  542193
  544800
  550633
  564203
  565281
  583080
  591959
  599987
  601094
  619407
  628332
  630756
  633445
  636033
  639722
  642746
  650380
  652542
  665768
  666850
  676428
  695127
  695181
  801907
]
9.54 ms
(7.57%)
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
  443112
  541633
  628332
  461937
  81734
  457963
  466989
  533014
  541751
  544800
  665768
  630756
  633445
  636033
  455898
  650380
  695181
  652542
  666850
  541630
  542193
  541644
  541667
  676428
  695127
  541643
  642746
  550633
  510108
  639722
  410959
  801907
  619407
  541671
  489831
  601094
  405921
  565281
  564203
  541656
  458619
  583080
  599987
  591959
]
2.29 ms
(1.82%)
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
  81734
  405921
  410959
  443112
  455898
  457963
  458619
  461937
  466989
  489831
  510108
  533014
  541630
  541633
  541643
  541644
  541656
  541667
  541671
  541751
  542193
  544800
  550633
  564203
  565281
  583080
  591959
  599987
  601094
  619407
  628332
  630756
  633445
  636033
  639722
  642746
  650380
  652542
  665768
  666850
  676428
  695127
  695181
  801907
]
1.96 ms
(1.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal compilation stockings"
]
1.82 ms
(1.44%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал подборк чулк нижн бел"
]
1.49 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.42 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал подборк чулк нижн бел"
]

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.