GET https://search.jues.net/search/embeds/2?q=femdom%20domina

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
60.92 ms
(68.07%)
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
  383643
  398955
  407011
  419840
  426730
  427171
  439626
  440581
  440966
  441757
  441822
  442239
  442248
  442280
  442587
  442957
  445414
  446090
  448054
  448058
  449301
  452273
  456383
  459471
  478829
  478981
  482609
  482623
  491155
  491442
  503619
  514149
  514746
  516979
  531905
  548879
  548886
  551912
  555479
  580663
  600763
  606867
  606968
  614407
  614627
  642832
  650636
  706933
  711275
  730975
  745306
  770607
  784287
  820147
]
13.55 ms
(15.14%)
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
  441822
  442587
  482609
  482623
  551912
  548886
  606968
  745306
  770607
  784287
  427171
  448058
  448054
  491155
  491442
  441757
  442957
  449301
  452273
  706933
  650636
  548879
  614627
  614407
  606867
  711275
  398955
  426730
  419840
  442280
  820147
  456383
  555479
  642832
  730975
  383643
  459471
  446090
  531905
  516979
  580663
  478829
  442248
  445414
  600763
  440966
  407011
  503619
  514149
  514746
  439626
  442239
  440581
  478981
]
5.33 ms
(5.96%)
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:
[
  "femdom domina"
  "femdom domina"
  "femdom domina"
  20
]
2.23 ms
(2.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "femdom domina"
]
2.13 ms
(2.37%)
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
  383643
  398955
  407011
  419840
  426730
  427171
  439626
  440581
  440966
  441757
  441822
  442239
  442248
  442280
  442587
  442957
  445414
  446090
  448054
  448058
  449301
  452273
  456383
  459471
  478829
  478981
  482609
  482623
  491155
  491442
  503619
  514149
  514746
  516979
  531905
  548879
  548886
  551912
  555479
  580663
  600763
  606867
  606968
  614407
  614627
  642832
  650636
  706933
  711275
  730975
  745306
  770607
  784287
  820147
]
2.11 ms
(2.35%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(1.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "femdom доминирован"
]
1.55 ms
(1.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "femdom доминирован"
]

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.