GET https://search.jues.net/search/embeds/3?q=rus%20anal%20porn

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
78.85 ms
(50.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:
[
  "rus anal porn"
  "rus anal porn"
  "rus anal porn"
  20
]
57.45 ms
(36.56%)
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
  387846
  417396
  424523
  435550
  444606
  445644
  446112
  452644
  457974
  477114
  484724
  491717
  497921
  497923
  513017
  516802
  517833
  521975
  523996
  525464
  533477
  542954
  574519
  575162
  575469
  575479
  575810
  576412
  597580
  598466
  599478
  605746
  621259
  623678
  625437
  629021
  633732
  636801
  636869
  652907
  653567
  659419
  671863
  733886
  762213
  770148
  786552
]
11.05 ms
(7.03%)
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
  733886
  786552
  446112
  424523
  497923
  387846
  452644
  417396
  575479
  575162
  762213
  659419
  633732
  517833
  435550
  523996
  516802
  533477
  599478
  525464
  484724
  513017
  636869
  445644
  497921
  576412
  575810
  623678
  636801
  629021
  598466
  491717
  770148
  653567
  605746
  542954
  621259
  652907
  521975
  575469
  625437
  597580
  671863
  444606
  457974
  477114
  574519
]
2.65 ms
(1.69%)
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
  387846
  417396
  424523
  435550
  444606
  445644
  446112
  452644
  457974
  477114
  484724
  491717
  497921
  497923
  513017
  516802
  517833
  521975
  523996
  525464
  533477
  542954
  574519
  575162
  575469
  575479
  575810
  576412
  597580
  598466
  599478
  605746
  621259
  623678
  625437
  629021
  633732
  636801
  636869
  652907
  653567
  659419
  671863
  733886
  762213
  770148
  786552
]
2.05 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "rus anal porn"
]
1.75 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск анал porn"
]
1.63 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск анал porn"
]

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.