GET https://search.jues.net/search/embeds?q=mother%20and%20sun

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
103.50 ms
(69.96%)
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
  406378
  440261
  454332
  457739
  464708
  472357
  478367
  484520
  488389
  488996
  500644
  501705
  501709
  516883
  517480
  530533
  532355
  532425
  532672
  534959
  536335
  550045
  552980
  562842
  565975
  568147
  568148
  572582
  575703
  582451
  585060
  591177
  594813
  594887
  595899
  599154
  599255
  601246
  631194
  641138
  641924
  650378
  665934
  695941
  702480
  710377
  718015
  718450
  725793
  726432
  745058
  747047
  763168
  766926
  774736
  796806
  813868
  818696
  818758
  819766
  828415
  828856
]
27.76 ms
(18.76%)
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:
[
  "mother and sun"
  "mother and sun"
  "mother and sun"
  20
]
8.01 ms
(5.41%)
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
  818696
  478367
  813868
  818758
  599154
  594813
  562842
  710377
  572582
  828856
  575703
  650378
  582451
  536335
  530533
  599255
  631194
  819766
  665934
  828415
  641924
  774736
  725793
  747047
  718450
  766926
  702480
  532672
  718015
  745058
  472357
  763168
  796806
  440261
  488996
  695941
  484520
  534959
  550045
  454332
  406378
  516883
  726432
  457739
  641138
  517480
  568147
  595899
  501705
  488389
  464708
  532355
  568148
  594887
  500644
  565975
  532425
  552980
  501709
  601246
  591177
  585060
]
2.26 ms
(1.53%)
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
  406378
  440261
  454332
  457739
  464708
  472357
  478367
  484520
  488389
  488996
  500644
  501705
  501709
  516883
  517480
  530533
  532355
  532425
  532672
  534959
  536335
  550045
  552980
  562842
  565975
  568147
  568148
  572582
  575703
  582451
  585060
  591177
  594813
  594887
  595899
  599154
  599255
  601246
  631194
  641138
  641924
  650378
  665934
  695941
  702480
  710377
  718015
  718450
  725793
  726432
  745058
  747047
  763168
  766926
  774736
  796806
  813868
  818696
  818758
  819766
  828415
  828856
]
1.78 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mother and sun"
]
1.65 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин sun"
]
1.54 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мам женщин sun"
]

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.