제작 의뢰
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 |
견적문의() [2] | 김태헌687 | 2011.01.18 |
홈페이지 제작 의뢰합니다. [10] | 최종요 | 2011.01.18 |
사이트 제작 (디자인+프로그램) 의뢰 [4] | 지눈 | 2011.01.18 |
제작의뢰 입니다 | 윈시스 | 2011.01.18 |
cakephp 작업 가능하신분 구합니다. | 윤영준715 | 2011.01.19 |
slow Query 수정가능하신분 -.-a 의뢰합니다. [1] | 서민석203 | 2011.01.19 |
디아이진 사이트 리뉴얼 제작의뢰 [1] | 한동훈641 | 2011.01.19 |
db 데이타 마이그레이션 가능하신분 찾습니다. [1] | 디자인키 | 2011.01.19 |
레이아웃 제작의뢰 | 봉인 | 2011.01.19 |
시민사회단체 홈페이지 구축 및 관리 [3] | 산그림자 | 2011.01.19 |
프로그램 의뢰받습니다 | Software2 | 2011.01.19 |
제로보드4 홈페이지 DQ스킨재설치및 수정의뢰 | wlswls | 2011.01.20 |
제로보드4로 된 사이트를 XE로 변환해 주실 분이나 업체분.... [1] | 강현철119 | 2011.01.20 |
데이타 mysql 마이그레이션 도와주세요 [1] | 디자인키 | 2011.01.20 |
공연 홈페이지 제작의뢰[급구] [2] | 훈킹 | 2011.01.20 |
XE모듈개발,레이아웃디자인,통합프로그래밍 각 분야 프리랜서 및 전문업체 구해봅니다. | 김재문725 | 2011.01.20 |
Site 관리 [2] | Hyonpa | 2011.01.21 |
제작문의 드립니다~ [2] | 고미현513 | 2011.01.21 |
오픈마켓솔루션 설치하였는데 사이트 수정 좀 하고 싶네요... [1] | 신창윤783 | 2011.01.21 |
XE, 코딩 가능하신 프리랜서 프로그래머 구합니다. [2] | 크리스리 | 2011.01.21 |