GET https://search.jues.net/search/embeds?q=small%20tits%20tied

Query Metrics

9 Database Queries
9 Different statements
89.13 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
52.53 ms
(58.94%)
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
  423930
  425744
  437174
  446054
  464265
  478832
  480774
  497280
  503809
  512857
  516438
  543846
  546465
  558958
  559140
  562066
  569778
  569779
  570919
  570922
  570927
  579166
  579941
  581669
  597963
  601223
  651938
  651944
  653557
  714457
  720164
  787997
  795919
  797110
  798200
  800125
  800759
  817128
  825781
  827073
  828628
]
15.87 ms
(17.80%)
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:
[
  "small tits tied"
  "small tits tied"
  "small tits tied"
  20
]
8.13 ms
(9.12%)
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
  828628
  570919
  827073
  817128
  798200
  651944
  800759
  569779
  787997
  795919
  579941
  581669
  543846
  570922
  437174
  825781
  570927
  601223
  423930
  558958
  569778
  800125
  480774
  579166
  425744
  559140
  516438
  720164
  503809
  714457
  512857
  797110
  562066
  546465
  464265
  497280
  446054
  651938
  478832
  653557
  597963
]
2.76 ms
(3.10%)
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
  423930
  425744
  437174
  446054
  464265
  478832
  480774
  497280
  503809
  512857
  516438
  543846
  546465
  558958
  559140
  562066
  569778
  569779
  570919
  570922
  570927
  579166
  579941
  581669
  597963
  601223
  651938
  651944
  653557
  714457
  720164
  787997
  795919
  797110
  798200
  800125
  800759
  817128
  825781
  827073
  828628
]
2.40 ms
(2.69%)
1
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
  b"\x01–é/^KqvƒGÅC\e\fˆé"
]
1.99 ms
(2.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "small tits tied"
]
1.93 ms
(2.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "маленькая сиськ tied"
]
1.89 ms
(2.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(1.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "маленькая сиськ tied"
]

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.