From a8d116b381ec9c28c5da5c8ee39a3699f568130d Mon Sep 17 00:00:00 2001 From: Christopher Speller Date: Mon, 10 Sep 2018 06:20:01 -0700 Subject: Speed up search results post selection. (#9380) --- store/sqlstore/post_store.go | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'store/sqlstore') diff --git a/store/sqlstore/post_store.go b/store/sqlstore/post_store.go index 14a6039bc..9cf33888d 100644 --- a/store/sqlstore/post_store.go +++ b/store/sqlstore/post_store.go @@ -1156,7 +1156,7 @@ func (s *SqlPostStore) GetPostsByIds(postIds []string) store.StoreChannel { params[key] = postId } - query := `SELECT * FROM Posts WHERE Id in (` + keys.String() + `) and DeleteAt = 0 ORDER BY CreateAt DESC` + query := `SELECT * FROM Posts WHERE Id in (` + keys.String() + `) ORDER BY CreateAt DESC` var posts []*model.Post _, err := s.GetReplica().Select(&posts, query, params) -- cgit v1.2.3-1-g7c22