제작 의뢰
slow Query 수정가능하신분 -.-a 의뢰합니다.
2011.01.19 11:03
# User@Host: bbulsori[bbulsori] @ localhost []
# Query_time: 7.670148 Lock_time: 1.519027 Rows_sent: 5 Rows_examined: 2890
SET timestamp=1295355282;
select modules.site_srl as `site_srl`,modules.mid as `mid`,documents.* from `xe_modules` as modules,`xe_documents` as documents where (documents.module_srl in (12139,12140,1004,12141,12142) and modules.module
_srl = documents.module_srl) order by documents.list_order asc limit 5;
# Time: 110118 21:54:43
# User@Host: bbulsori[bbulsori] @ localhost []
# Query_time: 7.775343 Lock_time: 1.524465 Rows_sent: 5 Rows_examined: 2890
SET timestamp=1295355283;
select modules.site_srl as `site_srl`,modules.mid as `mid`,documents.* from `xe_modules` as modules,`xe_documents` as documents where (documents.module_srl in (12139,12140,1004,12141,12142) and modules.module
_srl = documents.module_srl) order by documents.list_order asc limit 5;
# User@Ho! st: bbulsori[bbulsori] @ localhost []
# Query_time: 7.661413 Lock_time: 1.394974 Rows_sent: 5 Rows_examined: 2890
SET timestamp=1295355283;
select modules.site_srl as `site_srl`,modules.mid as `mid`,documents.* from `xe_modules` as modules,`xe_documents` as documents where (documents.module_srl in (12139,12140,1004,12141,12142) and modules.module
_srl = documents.module_srl) order by documents.list_order asc limit 5;
# Time: 110118 21:54:44
# User@Host: bbulsori[bbulsori] @ localhost []
# Query_time: 9.158039 Lock_time: 1.863302 Rows_sent: 5 Rows_examined: 2890
SET timestamp=1295355284;
select modules.site_srl as `site_srl`,modules.mid as `mid`,documents.* from `xe_modules` as modules,`xe_documents` as documents where (documents.module_srl in (12139,12140,1004,12141,12142) and modules.module
_srl = documents.module_srl) order by documents.list_order asc limit 5;
# Time: 110118 21:54! :45
# User@Host: bbulsori[bbulsori] @ localhost []
#! Query_t ime: 10.193045 Lock_time: 1.694183 Rows_sent: 5 Rows_examined: 2890
SET timestamp=1295355285;
select modules.site_srl as `site_srl`,modules.mid as `mid`,documents.* from `xe_modules` as modules,`xe_documents` as documents where (documents.module_srl in (12139,12140,1004,12141,12142) and modules.module
_srl = documents.module_srl) order by documents.list_order asc limit 5;
# Time: 110118 21:54:47
# User@Host: bbulsori[bbulsori] @ localhost []
# Query_time: 6.631137 Lock_time: 0.000051 Rows_sent: 0 Rows_examined: 0
SET timestamp=1295355287;
update `xe_counter_status` as counter_status set `pageview` = pageview+1 where (regdate = 20110118);
# User@Host: bbulsori[bbulsori] @ localhost []
# Query_time: 12.200232 Lock_time: 1.289961 Rows_sent: 5 Rows_examined: 2890
SET timestamp=1295355287;
select modules.site_srl as `site_srl`,modules.mid as `mid`,documents.* from `xe_modu! les` as modules,`xe_documents` as documents where (documents.module_srl in (12139,12140,1004,12141,12142) and modules.module
_srl = documents.module_srl) order by documents.list_order asc limit 5;
# Time: 110118 21:54:53
# User@Host: bbulsori[bbulsori] @ localhost []
# Query_time: 3.329191 Lock_time: 0.230304 Rows_sent: 5 Rows_examined: 2890
SET timestamp=1295355293;
select modules.site_srl as `site_srl`,modules.mid as `mid`,documents.* from `xe_modules` as modules,`xe_documents` as documents where (documents.module_srl in (12139,12140,1004,12141,12142) and modules.module
_srl = documents.module_srl) order by documents.list_order asc limit 5;
# User@Host: bbulsori[bbulsori] @ localhost []
# Query_time: 3.117900 Lock_time: 0.000098 Rows_sent: 5 Rows_examined: 2890
SET timestamp=1295355293;
select modules.site_srl as `site_srl`,modules.mid as `mid`,documents.* from `xe_modules` as mod! ules,`xe_documents` as documents where (documents.modul! e_srl in (12139,12140,1004,12141,12142) and modules.module
_srl = documents.module_srl) order by documents.list_order asc limit 5;
# User@Host: bbulsori[bbulsori] @ localhost []
# Query_time: 3.475760 Lock_time: 0.000069 Rows_sent: 5 Rows_examined: 2890
SET timestamp=1295355293;
select modules.site_srl as `site_srl`,modules.mid as `mid`,documents.* from `xe_modules` as modules,`xe_documents` as documents where (documents.module_srl in (12139,12140,1004,12141,12142) and modules.module
_srl = documents.module_srl) order by documents.list_order asc limit 5;
# Time: 110118 21:57:36
# User@Host: bbulsori[bbulsori] @ localhost []
# Query_time: 3.010258 Lock_time: 0.000092 Rows_sent: 5 Rows_examined: 2890
SET timestamp=1295355456;
select modules.site_srl as `site_srl`,modules.mid as `mid`,documents.* from `xe_modules` as modules,`xe_documents` as documents where (documents.module_srl in (12139,1214! 0,1004,12141,12142) and modules.module
_srl = documents.module_srl) order by documents.list_order asc limit 5;
# User@Host: dwu2009[dwu2009] @ localhost []
# Query_time: 4.727551 Lock_time: 0.000084 Rows_sent: 1 Rows_examined: 87969
use dwu2009;
SET timestamp=1295355456;
select * from `xe_member_message` as member_message,`xe_member` as member where (member_message.receiver_srl = 3182 and member_message.readed = ''N'' and member_message.sender_srl = member.member_srl) order by
member_message.list_order desc limit 0, 1;
제사이트가 이상하게 동접이좀만 발생해도 슬로우쿼리문제로 - -
다른서버에 지장을주게되고.. 사이트가 뻗거든요..
그래서 cafe24 쪽에서 이 소스를 수정하라는데...
전 소스에대한 개념도 잘모르고해서 의뢰한번 해봅니다.
가격이랑 연락처 댓글로 달아주시면 감사하겠습니다.
제목 | 글쓴이 | 날짜 |
---|---|---|
공지 피해 사례 공유 게시물 관련 안내 [2] | XE | 2017.07.29 |
학원 홈페이지 결제시스템 의뢰합니다. [7] | 디자인로그 | 2013.02.07 |
컨텐츠 자동으로 긁어오는 서버 프로그램 의뢰
![]() | enrjek241 | 2013.02.07 |
확장변수 관련 제작의뢰입니다. [2] | 리안리 | 2013.02.07 |
무보수 명예직/X베의 기술XX 같은 역할해 주실 분 구합니다. [2] | 신병※2중대 | 2013.02.07 |
xe를 커스터마이징을 통해 같이 사업하실 분을 찾습니다. [3] | 리안리 | 2013.02.07 |
XE 싸이트 언어셋 작업. [3] | xe전문가 | 2013.02.07 |
홈페이지 리뉴얼을 할려고 합니다. [7] | 그렌라간원 | 2013.02.08 |
제작의뢰 합니다. [2] | 돈돈돈돈12 | 2013.02.08 |
인터넷족보 웹프로그램 제안 요청
[1]
![]() | dbaseman | 2013.02.12 |
모바일 웹페이지(db입력폼) 제작의뢰
[1]
![]() | 곽태영1 | 2013.02.12 |
홈페이지 리뉴얼 의뢰합니다. [7] | 버디구루 | 2013.02.12 |
XE프로그램 의뢰합니다. [7] | KTK | 2013.02.12 |
게시판 제작 의뢰 합니다. [1] | AndrewAhn | 2013.02.12 |
게시판 날짜순 정렬 왜 안되나요? [1] | joynemo | 2013.02.13 |
홈페이지 수정 가능 하신분 찾아요~ [4] | 컨닝소녀 | 2013.02.13 |
간단한 게시판만 들어가는 홈피 제작의뢰
[4]
![]() | rkskekrkfdjs | 2013.02.13 |
카페 24를 통한 홈페이지 디자인 제작문의드립니다. | 돈돈돈돈12 | 2013.02.13 |
게시판 삭제좀 부탁합니다. | 깨비마마 | 2013.02.13 |
홈페이지 제작 의뢰해봅니다. [5] | 김호석355 | 2013.02.13 |
위젯 및 스킨 제작 의뢰합니다.
[5]
![]() | 살림 | 2013.02.13 |