GET https://search.jues.net/search/embeds/2?q=boyfriend%20and%20mom

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
61.73 ms
(43.74%)
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
  400237
  413890
  415566
  416165
  418596
  425214
  425490
  425609
  437587
  439726
  443150
  448694
  464328
  471639
  487693
  490916
  495418
  499336
  504102
  504922
  505018
  507557
  513431
  513837
  513845
  516543
  523045
  523404
  525651
  526057
  526920
  565631
  565927
  568641
  570840
  573304
  573361
  583329
  586043
  587192
  590221
  591646
  596235
  602492
  606774
  612439
  639972
  677097
  744639
  785437
  792599
  809931
  814845
  816086
]
57.05 ms
(40.43%)
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:
[
  "boyfriend and mom"
  "boyfriend and mom"
  "boyfriend and mom"
  20
]
11.47 ms
(8.13%)
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
  792599
  809931
  744639
  785437
  448694
  443150
  526057
  516543
  413890
  415566
  425609
  495418
  499336
  513837
  507557
  568641
  570840
  583329
  573304
  677097
  565631
  573361
  612439
  639972
  586043
  400237
  437587
  504102
  523404
  487693
  439726
  416165
  816086
  814845
  490916
  591646
  602492
  596235
  606774
  513431
  526920
  425214
  418596
  505018
  471639
  587192
  504922
  565927
  590221
  425490
  523045
  525651
  513845
  464328
]
3.13 ms
(2.22%)
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
  400237
  413890
  415566
  416165
  418596
  425214
  425490
  425609
  437587
  439726
  443150
  448694
  464328
  471639
  487693
  490916
  495418
  499336
  504102
  504922
  505018
  507557
  513431
  513837
  513845
  516543
  523045
  523404
  525651
  526057
  526920
  565631
  565927
  568641
  570840
  573304
  573361
  583329
  586043
  587192
  590221
  591646
  596235
  602492
  606774
  612439
  639972
  677097
  744639
  785437
  792599
  809931
  814845
  816086
]
2.43 ms
(1.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "boyfriend and mom"
]
1.93 ms
(1.37%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "boyfriend mom"
]
1.69 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "boyfriend mom"
]
1.68 ms
(1.19%)
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.