GET https://search.jues.net/search/embeds/4?q=fuck%20baby

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
50.94 ms
(55.81%)
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
  395571
  395856
  397548
  408306
  418704
  449799
  454998
  460296
  463016
  472962
  476908
  482910
  490218
  493951
  504189
  513006
  519492
  522089
  523205
  524628
  536584
  537199
  567901
  583448
  590878
  597233
  597266
  599545
  608431
  616036
  628368
  633446
  635220
  637460
  641983
  647952
  650767
  651647
  677672
  724921
  733870
  815963
]
19.20 ms
(21.03%)
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:
[
  "fuck baby"
  "fuck baby"
  "fuck baby"
  20
]
10.81 ms
(11.84%)
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
  460296
  597233
  449799
  454998
  519492
  493951
  482910
  418704
  724921
  490218
  472962
  395856
  463016
  408306
  815963
  650767
  677672
  628368
  597266
  513006
  397548
  583448
  641983
  522089
  504189
  635220
  476908
  733870
  567901
  647952
  395571
  633446
  537199
  616036
  523205
  608431
  651647
  637460
  524628
  536584
  599545
  590878
]
2.63 ms
(2.88%)
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
  395571
  395856
  397548
  408306
  418704
  449799
  454998
  460296
  463016
  472962
  476908
  482910
  490218
  493951
  504189
  513006
  519492
  522089
  523205
  524628
  536584
  537199
  567901
  583448
  590878
  597233
  597266
  599545
  608431
  616036
  628368
  633446
  635220
  637460
  641983
  647952
  650767
  651647
  677672
  724921
  733870
  815963
]
2.31 ms
(2.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fuck baby"
]
2.13 ms
(2.33%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(1.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс baby"
]
1.60 ms
(1.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс baby"
]

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.