How to make this query faster......?

See more:

SQL

Hi
I writing code here i am executing this query it take 10 sec time. present in my db only 4 thousand records are there....in future 50 thousand records in db it will take more time to execute how can i solve query faster ....?
this is my select query.... is there any chance to optimization this query...?

CREATE TABLE #Temp(UserId int);
INSERT INTO #Temp(UserId) SELECT DISTINCT(UserId) FROM tblUserPost WHERE visibility=2;

SELECT 
    UP.UserId,
    UP.FileId,
    UP.Text,
    UP.FileType,
    UP.IsChekin,
    UP.CreatedOn,
    UP.ModifiedOn,
    UP.ID ,
    UF.FileName,
    UF.MimeType,
    UF.FileSize,
    UF.MediaType,
    UF.FilePath,
    UF.ThumbnailUrl,
    (SELECT COUNT(*) FROM tblLike L WHERE L.PostId=UP.ID),
    (SELECT COUNT(*) FROM tblComment C WHERE C.PostId =UP.ID),
    (CASE
    WHEN (SELECT COUNT(*) FROM tblLike LK WHERELK.PostId= UP.ID AND LK.UserId = @UserId ) > 0 THEN  CAST(1 as bit) 
    ELSE CAST(0 as bit)  END) AS IsLike ,
    UP.isShare,
    UP.ShareText,
    UP.OwnerId,
    UP.ShareTime,
    UP.CheckinLatitude,
    UP.CheckinLongitude,
    UP.Address,
    UP.Checkinurl,0,0,UF.ThumbHeight,UF.ThumbWidth

FROM #Temp T 

INNER JOIN tblUserPost UP ON UP.UserId=T.UserId
LEFT JOIN OUTER JOIN tblPostFile UF ON UF.ID =UP.FileId

WHERE  UP.visibility=2

ORDER BY UP.ID DESC;