GET https://search.jues.net/search/embeds/2?q=beach%20man

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
71.44 ms
(68.41%)
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
  28382
  195676
  262418
  396456
  414184
  417363
  417473
  418868
  420011
  426218
  428963
  430949
  435277
  435479
  441546
  441640
  442617
  447742
  453064
  453069
  454333
  455016
  455798
  457595
  457667
  457668
  457780
  458442
  458489
  459163
  475062
  478947
  479928
  486962
  488236
  494126
  509802
  514980
  515153
  515167
  515179
  523050
  524205
  541606
  541877
  549327
  559069
  564092
  580969
  605396
  650950
]
14.27 ms
(13.67%)
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:
[
  "beach man"
  "beach man"
  "beach man"
  20
]
9.36 ms
(8.96%)
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
  514980
  486962
  457668
  455798
  459163
  488236
  650950
  428963
  418868
  426218
  458489
  447742
  195676
  28382
  262418
  454333
  478947
  430949
  564092
  420011
  457780
  453064
  494126
  414184
  457667
  479928
  455016
  515179
  396456
  417363
  442617
  523050
  541606
  515167
  453069
  458442
  524205
  509802
  435277
  457595
  549327
  605396
  441546
  475062
  417473
  559069
  515153
  441640
  435479
  541877
  580969
]
2.39 ms
(2.29%)
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
  28382
  195676
  262418
  396456
  414184
  417363
  417473
  418868
  420011
  426218
  428963
  430949
  435277
  435479
  441546
  441640
  442617
  447742
  453064
  453069
  454333
  455016
  455798
  457595
  457667
  457668
  457780
  458442
  458489
  459163
  475062
  478947
  479928
  486962
  488236
  494126
  509802
  514980
  515153
  515167
  515179
  523050
  524205
  541606
  541877
  549327
  559069
  564092
  580969
  605396
  650950
]
1.95 ms
(1.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beach man"
]
1.88 ms
(1.80%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(1.68%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пляж природ мужчин"
]
1.38 ms
(1.32%)
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.