GET https://search.jues.net/search/embeds/4?q=step%20mother%20sister

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
78.85 ms
(62.77%)
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
  435244
  446633
  453732
  456453
  456888
  457562
  463215
  467981
  477890
  479629
  482610
  485180
  489712
  494642
  497167
  497935
  500010
  503106
  509384
  510256
  510445
  511327
  518820
  519392
  520885
  521797
  522663
  526805
  528838
  531920
  541551
  542284
  548870
  559696
  560197
  564122
  564701
  582330
  584382
  584752
  586734
  588600
  588992
  597240
  599803
  602981
  603053
  605205
  608245
  614060
  619935
  621140
  621353
  650806
  723352
  792651
]
24.29 ms
(19.34%)
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:
[
  "step mother sister"
  "step mother sister"
  "step mother sister"
  20
]
12.33 ms
(9.81%)
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
  605205
  792651
  456453
  500010
  456888
  453732
  608245
  446633
  509384
  497167
  584382
  588992
  435244
  494642
  520885
  511327
  541551
  582330
  542284
  588600
  614060
  619935
  621353
  723352
  503106
  559696
  584752
  457562
  482610
  485180
  510256
  510445
  528838
  564701
  621140
  518820
  463215
  522663
  599803
  477890
  489712
  564122
  586734
  603053
  479629
  602981
  531920
  467981
  519392
  526805
  650806
  548870
  521797
  497935
  560197
  597240
]
3.00 ms
(2.39%)
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
  435244
  446633
  453732
  456453
  456888
  457562
  463215
  467981
  477890
  479629
  482610
  485180
  489712
  494642
  497167
  497935
  500010
  503106
  509384
  510256
  510445
  511327
  518820
  519392
  520885
  521797
  522663
  526805
  528838
  531920
  541551
  542284
  548870
  559696
  560197
  564122
  564701
  582330
  584382
  584752
  586734
  588600
  588992
  597240
  599803
  602981
  603053
  605205
  608245
  614060
  619935
  621140
  621353
  650806
  723352
  792651
]
2.33 ms
(1.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "step mother sister"
]
1.76 ms
(1.40%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "step мам женщин sister"
]
1.56 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "step мам женщин sister"
]
1.48 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.