GET https://search.jues.net/search/embeds?q=satisfaction

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
61.86 ms
(74.57%)
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
  382456
  411614
  420091
  422590
  467262
  485630
  486403
  491538
  520158
  548162
  552627
  560607
  575120
  575302
  575452
  604184
  606859
  614004
  619458
  637755
  667011
  676939
  677397
  696812
  701469
  702048
  707505
  717842
  727436
  729859
  730616
  734475
  736394
  737208
  743181
  744744
  753455
  756565
  769870
  769872
  785589
  808265
  810918
  810997
  812113
  818213
  828633
]
7.58 ms
(9.13%)
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
  575302
  828633
  734475
  756565
  737208
  614004
  730616
  743181
  818213
  575120
  676939
  606859
  729859
  753455
  696812
  727436
  769872
  701469
  637755
  736394
  810918
  744744
  411614
  548162
  677397
  667011
  707505
  812113
  520158
  382456
  467262
  575452
  702048
  619458
  604184
  785589
  810997
  769870
  717842
  420091
  560607
  808265
  491538
  486403
  552627
  422590
  485630
]
2.67 ms
(3.21%)
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
  382456
  411614
  420091
  422590
  467262
  485630
  486403
  491538
  520158
  548162
  552627
  560607
  575120
  575302
  575452
  604184
  606859
  614004
  619458
  637755
  667011
  676939
  677397
  696812
  701469
  702048
  707505
  717842
  727436
  729859
  730616
  734475
  736394
  737208
  743181
  744744
  753455
  756565
  769870
  769872
  785589
  808265
  810918
  810997
  812113
  818213
  828633
]
2.58 ms
(3.11%)
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:
[
  "satisfaction"
  "satisfaction"
  "satisfaction"
  20
]
2.31 ms
(2.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "satisfaction"
]
2.05 ms
(2.47%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.05 ms
(2.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "satisfaction"
]
1.87 ms
(2.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "satisfaction"
]

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.