GET https://search.jues.net/search/embeds/2?q=%D0%B3%D0%B8%D0%BD%D0%B5%D0%BA%D0%BE%D0%BB%D0%BE%D0%B3%D0%B0

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
63.22 ms
(75.66%)
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
  410003
  480470
  489474
  490153
  491871
  492002
  494770
  498024
  498064
  507375
  512070
  512436
  515258
  515266
  524511
  524544
  541630
  548559
  548582
  560403
  560408
  560428
  560943
  562030
  572003
  581148
  584019
  584680
  593299
  593487
  593504
  593513
  593540
  596586
  598032
  607344
  607737
  641732
  669577
  677387
  688340
  691200
  728386
]
8.70 ms
(10.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
  507375
  480470
  512070
  515258
  560403
  548559
  584019
  584680
  677387
  560943
  593540
  598032
  593504
  593513
  728386
  607737
  498064
  490153
  515266
  498024
  560428
  548582
  688340
  691200
  593299
  410003
  492002
  489474
  512436
  669577
  562030
  524511
  581148
  593487
  607344
  494770
  560408
  641732
  491871
  541630
  572003
  524544
  596586
]
2.99 ms
(3.58%)
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
]
2.43 ms
(2.91%)
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
  410003
  480470
  489474
  490153
  491871
  492002
  494770
  498024
  498064
  507375
  512070
  512436
  515258
  515266
  524511
  524544
  541630
  548559
  548582
  560403
  560408
  560428
  560943
  562030
  572003
  581148
  584019
  584680
  593299
  593487
  593504
  593513
  593540
  596586
  598032
  607344
  607737
  641732
  669577
  677387
  688340
  691200
  728386
]
1.88 ms
(2.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "гинеколога"
]
1.54 ms
(1.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "гинеколог"
]
1.49 ms
(1.78%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.32 ms
(1.58%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.