GET https://search.jues.net/search/embeds/2?q=russian%20doctor

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
66.75 ms
(65.52%)
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
  422729
  424401
  439535
  452553
  454238
  455459
  458878
  458895
  460863
  469914
  472438
  480104
  481977
  484573
  485442
  489097
  489471
  491395
  498222
  502899
  506659
  512436
  515280
  515290
  519642
  522040
  526901
  529245
  534208
  548545
  548569
  552362
  555118
  555993
  563050
  563489
  564685
  574836
  593487
  603167
  609297
  625861
  640690
  641732
  675541
]
15.00 ms
(14.72%)
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:
[
  "russian doctor"
  "russian doctor"
  "russian doctor"
  20
]
10.41 ms
(10.22%)
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
  422729
  472438
  460863
  502899
  522040
  484573
  529245
  515280
  526901
  458895
  515290
  512436
  563050
  555993
  564685
  552362
  574836
  455459
  481977
  458878
  469914
  491395
  555118
  640690
  452553
  534208
  548569
  548545
  480104
  485442
  489471
  498222
  675541
  439535
  454238
  489097
  519642
  593487
  424401
  506659
  641732
  609297
  563489
  603167
  625861
]
2.66 ms
(2.61%)
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
  422729
  424401
  439535
  452553
  454238
  455459
  458878
  458895
  460863
  469914
  472438
  480104
  481977
  484573
  485442
  489097
  489471
  491395
  498222
  502899
  506659
  512436
  515280
  515290
  519642
  522040
  526901
  529245
  534208
  548545
  548569
  552362
  555118
  555993
  563050
  563489
  564685
  574836
  593487
  603167
  609297
  625861
  640690
  641732
  675541
]
2.18 ms
(2.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian doctor"
]
1.66 ms
(1.63%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(1.59%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск доктор"
]
1.59 ms
(1.56%)
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.