SELECT * FROM minr_profile WHERE profile_slug=? | gwb (0.183 Sekunden)
SELECT p.*,
SUM(CASE WHEN r.reaction = 'like' THEN 1 ELSE 0 END) AS post_likes,
SUM(CASE WHEN r.reaction = 'dislike' THEN 1 ELSE 0 END) AS post_dislikes,
(SELECT COUNT(*) FROM minr_comment WHERE comment_postid = p.post_id) AS post_commentcount
FROM minr_post p
LEFT JOIN minr_postreaction r ON p.post_id=r.post_id
WHERE p.post_slug=? AND p.post_onprofile=?
GROUP BY p.post_id | sieben,1 (17.61 Sekunden)
SELECT t.*, p2t.post_id FROM minr_tag t JOIN minr_post2tag p2t ON t.tag_id = p2t.tag_id WHERE p2t.post_id IN (?) | 7 (0.245 Sekunden)
SELECT * FROM minr_profile WHERE profile_id IN (?,?) | 1,2 (0.223 Sekunden)
SELECT * FROM minr_comment WHERE comment_postid=? | 7 (0.187 Sekunden)
SELECT * FROM minr_follow WHERE profileid=? OR follows=? | 0,0 (0.068 Sekunden)