vendredi 11 octobre 2019

How to improve my query, and maybe convert it to eloquent

I have a query that I hope you could help me convert to eloquent "syntax" since my whole project was written in such a manner. I was also wondering if it's possible to remove subqueries and use only join method since I have read multiple times that performance is better that way.

Here is my query:

select images.*,
users.username,users.profile_picture as user_profile_picture,
(select count(*) from likes where image_id=images.id and user_id={id}) as liked,
(select count(*) from likes where image_id=images.id) as total_likes from images left join
 users on images.user_id = users.id order by images.created_at desc limit 20


via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire