GET https://search.jues.net/search/embeds/4?q=%D1%83%D0%B7%D0%BA%D0%B0%D1%8F

Query Metrics

15 Database Queries
15 Different statements
193.86 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
147.83 ms
(76.25%)
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
  185023
  368215
  382318
  385045
  438212
  492189
  493715
  499578
  527586
  529926
  537447
  539541
  540931
  557265
  561181
  564931
  565696
  565702
  569391
  573062
  574118
  574148
  574340
  576985
  578166
  579646
  581248
  583458
  587271
  592869
  595438
  602472
  602513
  603839
  608643
  615215
  619321
  619689
  620412
  620976
  623068
  628739
  628851
  632993
  634912
  642908
  644072
  648422
  652257
  656285
  658772
  659387
  660317
  660336
  660345
  664175
  664698
  668102
  679274
  679820
  683036
  692345
  696319
  705213
  705861
  707485
  707753
  712217
  712386
  714731
  715035
  715084
  715332
  715489
  720579
  720780
  720826
  721915
  722248
  723217
  723283
  730442
  734851
  734965
  735285
  738571
  738900
  745227
  748032
  748422
  752771
  756387
  757182
  757190
  757324
  758111
  762168
  762197
  764205
  766852
  766986
  768833
  769782
  771903
  771911
  776203
  776361
  784543
  789538
  789553
  789565
  792014
  792067
  792217
  796911
  796931
  803882
  811474
  812410
]
12.76 ms
(6.58%)
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
  730442
  734851
  734965
  738571
  738923
  745227
  748422
  756387
  757182
  757190
  758111
  762168
  762197
  748032
  766852
  768833
  771911
  735285
  738900
  752771
  757324
  764205
  766986
  769782
  771903
  619321
  634912
  707485
  715489
  723217
  776203
  776361
  784543
  789553
  796911
  803882
  811474
  812410
  185023
  382318
  527586
  385045
  368215
  438212
  492189
  493715
  537447
  499578
  529926
  539541
  557265
  561181
  564931
  565702
  574118
  573062
  574148
  579646
  581248
  540931
  565696
  569391
  574340
  578166
  583458
  660336
  668102
  679820
  705213
  715084
  720780
  722248
  656285
  658772
  659387
  664698
  692345
  712217
  714731
  715035
  648422
  652257
  660317
  660345
  664175
  679274
  683036
  696319
  705861
  707753
  712386
  715332
  720579
  720826
  721915
  723283
  576985
  587271
  608643
  615215
  623068
  595438
  602472
  603839
  619689
  620412
  620976
  628851
  644072
  592869
  602513
  628739
  632993
  642908
  789538
  789565
  792014
  792067
  792217
  796931
]
4.50 ms
(2.32%)
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:
[
  "узкая"
  "узкая"
  "узкая"
  20
]
4.19 ms
(2.16%)
1
SELECT COUNT(*) as `total_posts`
            FROM `trend_has_post` as `t0`
            INNER JOIN `post` as `p` ON (trend_id = ? AND p.post_id = t0.post_id)
            WHERE p.type = ? AND `p`.`status` = ?
Parameters:
[
  b"\x01Ư!´5pÉÁ▓7/6$\x03þ"
  0
  10
]
3.56 ms
(1.84%)
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
  185023
  368215
  382318
  385045
  438212
  492189
  493715
  499578
  527586
  529926
  537447
  539541
  540931
  557265
  561181
  564931
  565696
  565702
  569391
  573062
  574118
  574148
  574340
  576985
  578166
  579646
  581248
  583458
  587271
  592869
  595438
  602472
  602513
  603839
  608643
  615215
  619321
  619689
  620412
  620976
  623068
  628739
  628851
  632993
  634912
  642908
  644072
  648422
  652257
  656285
  658772
  659387
  660317
  660336
  660345
  664175
  664698
  668102
  679274
  679820
  683036
  692345
  696319
  705213
  705861
  707485
  707753
  712217
  712386
  714731
  715035
  715084
  715332
  715489
  720579
  720780
  720826
  721915
  722248
  723217
  723283
  730442
  734851
  734965
  735285
  738571
  738900
  745227
  748032
  748422
  752771
  756387
  757182
  757190
  757324
  758111
  762168
  762197
  764205
  766852
  766986
  768833
  769782
  771903
  771911
  776203
  776361
  784543
  789538
  789553
  789565
  792014
  792067
  792217
  796911
  796931
  803882
  811474
  812410
]
3.25 ms
(1.68%)
1
SELECT t0.post_id FROM trend_has_post t0 INNER JOIN post p ON trend_id = ? AND p.post_id = t0.post_id WHERE (p.type = ? AND p.status = ?) AND (t0.is_tested = 0) ORDER BY t0.ctr DESC LIMIT 120 OFFSET 360
Parameters:
[
  b"\x01Ư!´5pÉÁ▓7/6$\x03þ"
  0
  10
]
2.26 ms
(1.17%)
1
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
  b"\x01Ư!´5pÉÁ▓7/6$\x03þ"
]
2.25 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "узкая"
]
2.22 ms
(1.15%)
1
SELECT COUNT(*)
            FROM `trend_has_post` as `t0`
            INNER JOIN `post` as `p` ON (trend_id = ? AND p.post_id = t0.post_id)
            WHERE p.type = ? AND `p`.`status` = ? AND `t0`.`is_tested` = 1
Parameters:
[
  b"\x01Ư!´5pÉÁ▓7/6$\x03þ"
  0
  10
]
2.21 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "узкая"
]
1.98 ms
(1.02%)
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 (NULL)
Parameters:
[
  1
  2
]
1.92 ms
(0.99%)
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 (NULL)
Parameters:
[
  1
  2
]
1.80 ms
(0.93%)
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 (NULL)
Parameters:
[
  1
  2
]
1.58 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "узкая"
]
1.57 ms
(0.81%)
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.