Index로 성능 개선하기

select song.id, song.album_cover_url, song.created_at, song.length, song.singer, song.title, song.video_id, sum(coalesce(kp.like_count,0)) 
from song  
left join killing_part kp on song.id=kp.song_id  
group by song.id  

select comment.killing_part_id, comment.id, comment.content, comment.created_at, comment.member_id, m.id, m.created_at, m.email, m.nickname  
from killing_part_comment comment  
left join member m on m.id=comment.member_id  
where comment.killing_part_id=? 

select * from song s where s.id=? // 기준 song 조회 

// 기준 노래보다 좋아요가 많은 노래 10개 조회
select * from song s1_0 
left join killing_part k1_0 on s1_0.id=k1_0.song_id 
group by s1_0.id 
having ( 
// 좋아요 개수 값이 클 때 sum(coalesce(k1_0.like_count,0))> ( 
		select sum(coalesce(k2_0.like_count,0)) 
		from killing_part k2_0 where k2_0.song_id=? 
	) 
	or 
// 좋아요 개수 같으면 id 가 큰 순으로 정렬 
	( 
		sum(coalesce(k1_0.like_count,0))= ( 
			select sum(coalesce(k3_0.like_count,0)) 
			from killing_part k3_0  
			where k3_0.song_id=? 
		) and s1_0.id>? 
	) 
) 
order by sum(coalesce(k1_0.like_count,0)), s1_0.id // 좋아요 순 → id 작은 순 
offset ? rows fetch first ? rows only 

// 아래쪽 조회하는 쿼리  
select * 
from song s1_0 
left join killing_part k1_0 on s1_0.id=k1_0.song_id 
group by s1_0.id 
having 
sum(coalesce(k1_0.like_count,0))< 
	( 
	select sum(coalesce(k2_0.like_count,0)) 
	from killing_part k2_0 
	where k2_0.song_id=? 
	) 
or 
( sum(coalesce(k1_0.like_count,0))= 
	( 
		select sum(coalesce(k3_0.like_count,0)) 
		from killing_part k3_0 
		where k3_0.song_id=? 
	) 
	and s1_0.id<? 
) 
order by sum(coalesce(k1_0.like_count,0)) desc, s1_0.id desc 
offset ? rows fetch first ? rows only 

// 기준 노래의 킬링파트 조회하는 로직 
select * from killing_part k1_0 where k1_0.song_id=?