GET https://search.jues.net/search/embeds?q=young%20daughter%20sleeping

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
89.64 ms
(68.58%)
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
  38313
  392775
  395755
  396172
  400718
  403906
  420635
  430144
  430190
  430570
  433669
  433688
  433703
  434182
  451696
  453006
  454250
  457654
  457682
  473980
  481799
  485782
  486198
  487718
  488929
  510586
  516782
  517273
  518559
  519319
  519976
  550614
  550630
  560511
  563917
  563930
  622197
  623616
  667244
  682071
  683460
  790877
]
21.70 ms
(16.61%)
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:
[
  "young daughter sleeping"
  "young daughter sleeping"
  "young daughter sleeping"
  20
]
9.83 ms
(7.52%)
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
  667244
  395755
  38313
  517273
  396172
  400718
  481799
  683460
  519976
  510586
  682071
  433688
  488929
  487718
  550630
  622197
  790877
  392775
  454250
  453006
  518559
  430144
  485782
  519319
  403906
  451696
  434182
  457654
  457682
  516782
  550614
  563917
  563930
  433703
  430570
  433669
  473980
  430190
  623616
  486198
  420635
  560511
]
2.32 ms
(1.77%)
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
  38313
  392775
  395755
  396172
  400718
  403906
  420635
  430144
  430190
  430570
  433669
  433688
  433703
  434182
  451696
  453006
  454250
  457654
  457682
  473980
  481799
  485782
  486198
  487718
  488929
  510586
  516782
  517273
  518559
  519319
  519976
  550614
  550630
  560511
  563917
  563930
  622197
  623616
  667244
  682071
  683460
  790877
]
2.04 ms
(1.56%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(1.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young daughter sleeping"
]
1.74 ms
(1.33%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young daughter спящ"
]
1.69 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young daughter спящ"
]

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.