GET https://search.jues.net/search/embeds?q=beautiful%20face%20solo

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
81.68 ms
(64.16%)
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
  404101
  443287
  448199
  450211
  467051
  473410
  475404
  486852
  500803
  515939
  547751
  547754
  547756
  551051
  552092
  567042
  568310
  584303
  592523
  600512
  602342
  603124
  611204
  617633
  618415
  618424
  624691
  629971
  638727
  639253
  666982
  667082
  668285
  684666
  685495
  687299
  696499
  712879
  712880
  722315
  722407
  742326
  746201
  755173
  766415
  777935
  781265
  782675
  785102
  786024
  792073
  793211
  799212
  803600
  806854
  808842
  811230
  812142
]
26.97 ms
(21.19%)
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:
[
  "beautiful face solo"
  "beautiful face solo"
  "beautiful face solo"
  20
]
8.76 ms
(6.88%)
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
  712880
  712879
  792073
  638727
  786024
  722315
  584303
  551051
  666982
  668285
  629971
  811230
  781265
  793211
  812142
  486852
  567042
  639253
  473410
  667082
  777935
  600512
  552092
  722407
  592523
  624691
  404101
  782675
  806854
  685495
  443287
  515939
  602342
  618415
  568310
  687299
  611204
  803600
  755173
  808842
  742326
  746201
  785102
  799212
  684666
  547756
  547751
  766415
  450211
  467051
  475404
  500803
  448199
  547754
  618424
  617633
  696499
  603124
]
2.71 ms
(2.13%)
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
  404101
  443287
  448199
  450211
  467051
  473410
  475404
  486852
  500803
  515939
  547751
  547754
  547756
  551051
  552092
  567042
  568310
  584303
  592523
  600512
  602342
  603124
  611204
  617633
  618415
  618424
  624691
  629971
  638727
  639253
  666982
  667082
  668285
  684666
  685495
  687299
  696499
  712879
  712880
  722315
  722407
  742326
  746201
  755173
  766415
  777935
  781265
  782675
  785102
  786024
  792073
  793211
  799212
  803600
  806854
  808842
  811230
  812142
]
2.14 ms
(1.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "красивая face соло"
]
1.87 ms
(1.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beautiful face solo"
]
1.78 ms
(1.40%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.40 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая face соло"
]

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.