묻고답하기
쿼리가 발생하고있습니다.
2012.02.04 18:29
Query_time: 4 Lock_time: 0 Rows_sent: 5 Rows_examined: 448547
select member.*,count(*) as `count` from `xe_documents` as documents,`xe_modules` as modules,`xe_member` as member,`xe_member_group_
member` as member_group where (member_group.site_srl = 274333 and modules.site_srl = 274333 and modules.module_srl = documents.mod
ule_srl and documents.member_srl = member.member_srl and member_group.member_srl = member.member_srl) group by documents.member_srl
order by count desc limit 5;
이게 해당글을 읽지도 않았는데 1번 조회수로 기록한다고 엄청나게 홈페이지가 느려졌는데요
이걸 처리하려면 어딜 어떻게 수정해야 하나요..
아무리 봐도 모르겠네요 ㅠㅠ
