GET https://search.jues.net/search/embeds/10?q=my%20husband

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.51 ms
(83.71%)
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
  426547
  435642
  439566
  440901
  443080
  452763
  453576
  456745
  459513
  470103
  478723
  479292
  481043
  484222
  486125
  487872
  488249
  489623
  492958
  499754
  505231
  506565
  511152
  514997
  518603
  520468
  522322
  536154
  542084
  542746
  550882
  552808
  565220
  566413
  566771
  567073
  587855
  587928
  591958
  595763
  596910
  599525
  599533
  603608
  603618
  608744
  608930
  613808
  614565
  618596
  627674
  637247
  644056
  659391
  707557
  722014
  735871
  736798
  739916
  755011
  757724
  796143
  802474
  808077
]
10.12 ms
(6.39%)
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
  470103
  492958
  506565
  478723
  489623
  552808
  722014
  565220
  599525
  603608
  637247
  591958
  596910
  608744
  796143
  802474
  736798
  757724
  755011
  735871
  481043
  453576
  522322
  520468
  505231
  536154
  542084
  566413
  567073
  587928
  595763
  627674
  739916
  644056
  479292
  456745
  486125
  499754
  487872
  426547
  452763
  518603
  566771
  550882
  707557
  603618
  808077
  443080
  439566
  440901
  435642
  488249
  511152
  542746
  614565
  618596
  659391
  613808
  484222
  459513
  608930
  599533
  587855
  514997
]
6.10 ms
(3.85%)
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:
[
  "my husband"
  "my husband"
  "my husband"
  20
]
2.55 ms
(1.61%)
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
  426547
  435642
  439566
  440901
  443080
  452763
  453576
  456745
  459513
  470103
  478723
  479292
  481043
  484222
  486125
  487872
  488249
  489623
  492958
  499754
  505231
  506565
  511152
  514997
  518603
  520468
  522322
  536154
  542084
  542746
  550882
  552808
  565220
  566413
  566771
  567073
  587855
  587928
  591958
  595763
  596910
  599525
  599533
  603608
  603618
  608744
  608930
  613808
  614565
  618596
  627674
  637247
  644056
  659391
  707557
  722014
  735871
  736798
  739916
  755011
  757724
  796143
  802474
  808077
]
2.41 ms
(1.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "my husband"
]
1.72 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "my husband"
]
1.56 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "my husband"
]
1.33 ms
(0.84%)
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.