GET https://search.jues.net/search/embeds?q=%D0%B2%20%D1%8E%D0%B1%D0%BA%D0%B5%20%D0%B2%20%D0%BF%D0%BE%D0%BB%D0%B5

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
76.25 ms
(74.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
  444997
  464620
  482066
  486441
  496554
  513874
  517248
  522372
  522545
  525485
  526585
  531602
  531612
  538528
  538949
  541796
  546076
  548316
  550427
  551846
  551913
  564311
  565352
  567686
  572808
  578141
  580976
  584709
  591132
  599172
  602545
  609220
  621445
  622371
  635582
  645893
  646202
  650537
  664562
]
10.45 ms
(10.16%)
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
]
6.66 ms
(6.48%)
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
  526585
  548316
  609220
  522545
  522372
  567686
  664562
  538528
  551846
  602545
  550427
  565352
  572808
  531602
  546076
  645893
  541796
  650537
  580976
  482066
  486441
  646202
  578141
  591132
  531612
  635582
  444997
  538949
  513874
  621445
  564311
  622371
  584709
  525485
  517248
  599172
  464620
  496554
  551913
]
2.38 ms
(2.32%)
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
  444997
  464620
  482066
  486441
  496554
  513874
  517248
  522372
  522545
  525485
  526585
  531602
  531612
  538528
  538949
  541796
  546076
  548316
  550427
  551846
  551913
  564311
  565352
  567686
  572808
  578141
  580976
  584709
  591132
  599172
  602545
  609220
  621445
  622371
  635582
  645893
  646202
  650537
  664562
]
1.88 ms
(1.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(1.77%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "в юбк в поле природ"
]
1.71 ms
(1.66%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "в юбк в поле природ"
]
1.67 ms
(1.62%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
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.