|
楼主 |
发表于 2019-4-9 10:26:18
|
显示全部楼层
打印的sql语句没看到有orgFilter读取哪个表
2019-04-09 10:22:06 [SQL Time]sql 执行时间:17ms, exec KSQL: SELECT SKS_DailyListMgr.* FROM SKS_DailyListMgr SKS_DailyListMgr ORDER BY fValidDate DESC LIMIT 0, 20
--> sql:SELECT SKS_DailyListMgr.VERSION AS version, SKS_DailyListMgr.FNAME AS fName, SKS_DailyListMgr.FDEPTNAME AS fDeptName, SKS_DailyListMgr.FVALIDDATE AS fValidDate, SKS_DailyListMgr.FWORKPLANCONTENT AS fWorkPlanContent, SKS_DailyListMgr.FACTUALCOMPLETECONTENT AS fActualCompleteContent, SKS_DailyListMgr.FATTACHMENTS AS fAttachments, SKS_DailyListMgr.FCREATESFID AS fCreateSfid, SKS_DailyListMgr.FCREATESID AS fCreateSid, SKS_DailyListMgr.fID AS SKS_DailyListMgr FROM SKS_DAILYLISTMGR SKS_DailyListMgr ORDER BY fValidDate DESC
--> binds:[]
2019-04-09 10:22:06 [SQL Time]sql 执行时间:2ms, exec KSQL:
--> sql:SELECT count(*) FROM SKS_DAILYLISTMGR SKS_DailyListMgr
--> binds:[]
2019-04-09 10:22:06 [SQL Time]sql 执行时间:35ms, exec KSQL: SELECT SA_DocNode.* FROM SA_DocNode SA_DocNode WHERE ((SA_DocNode.sData1='C76E96910E174E609A87A897B0131681')) ORDER BY sLastWriteTime DESC,sCreateTime DESC LIMIT 0, -1
--> sql:SELECT SA_DocNode.sParentID AS sParentID, SA_DocNode.SDOCNAME AS sDocName, SA_DocNode.SSEQUENCE AS sSequence, SA_DocNode.SSIZE AS sSize, SA_DocNode.SKIND AS sKind, SA_DocNode.SDOCPATH AS sDocPath, SA_DocNode.SDOCDISPLAYPATH AS sDocDisplayPath, SA_DocNode.SCREATORFID AS sCreatorFID, SA_DocNode.SCREATORNAME AS sCreatorName, SA_DocNode.SCREATORDEPTNAME AS sCreatorDeptName, SA_DocNode.SCREATETIME AS sCreateTime, SA_DocNode.SEDITORFID AS sEditorFID, SA_DocNode.SEDITORNAME AS sEditorName, SA_DocNode.SEDITORDEPTNAME AS sEditorDeptName, SA_DocNode.SLASTWRITERFID AS sLastWriterFID, SA_DocNode.SLASTWRITERNAME AS sLastWriterName, SA_DocNode.SLASTWRITERDEPTNAME AS sLastWriterDeptName, SA_DocNode.SLASTWRITETIME AS sLastWriteTime, SA_DocNode.SFILEID AS sFileID, SA_DocNode.SDESCRIPTION AS sDescription, SA_DocNode.SDOCLIVEVERSIONID AS sDocLiveVersionID, SA_DocNode.SDOCSERIALNUMBER AS sDocSerialNumber, SA_DocNode.SKEYWORDS AS sKeywords, SA_DocNode.SCLASSIFICATION AS sClassification, SA_DocNode.SFINISHTIME AS sFinishTime, SA_DocNode.SNAMESPACE AS sNameSpace, SA_DocNode.SFLAG AS sFlag, SA_DocNode.VERSION AS version, SA_DocNode.SCACHENAME AS sCacheName, SA_DocNode.SREVISIONCACHENAME AS sRevisionCacheName, SA_DocNode.SACTIVITY AS sActivity, SA_DocNode.SACTIVITYNAME AS sActivityName, SA_DocNode.SPROCESS AS sProcess, SA_DocNode.SPROCESSNAME AS sProcessName, SA_DocNode.SDATA1 AS sData1, SA_DocNode.SEURL AS sEURL, SA_DocNode.STASKID AS sTaskID, SA_DocNode.SEXECUTORFID AS sExecutorFID, SA_DocNode.sID AS SA_DocNode FROM SA_DocNode SA_DocNode WHERE SA_DocNode.SDATA1 = ? ORDER BY sLastWriteTime DESC, sCreateTime DESC
--> binds:[C76E96910E174E609A87A897B0131681]
2019-04-09 10:22:06 加载模块:/SA/doc/system ...
2019-04-09 10:22:06 加载模块:/SA/doc ...
2019-04-09 10:22:06 加载模块:/SA/doc/data ...
2019-04-09 10:22:06 加载模块:/SA/doc/logic/action ...
2019-04-09 10:22:06 加载模块:/SA/doc/logic ...
2019-04-09 10:22:06 加载模块:/SA/doc/logic/code ...
2019-04-09 10:22:07 [SQL Time]sql 执行时间:2ms, exec KSQL: select SA_DocLinkDefine,SA_DocLinkDefine.sDefineItems,SA_DocLinkDefine.sActivity,SA_DocLinkDefine.sPersonFID from SA_DocLinkDefine SA_DocLinkDefine where (SA_DocLinkDefine.sProcess='/SKS/generalBiz/process/dailyListMgr/dailyListMgrProcess' and (SA_DocLinkDefine.sActivity='' or SA_DocLinkDefine.sActivity IS NULL)) or (SA_DocLinkDefine.sProcess='/SKS/generalBiz/process/dailyListMgr/dailyListMgrProcess' and SA_DocLinkDefine.sActivity='mainActivity') order by SA_DocLinkDefine.sActivity desc
--> sql:SELECT SA_DocLinkDefine.sID, SA_DocLinkDefine.SDEFINEITEMS AS sDefineItems, SA_DocLinkDefine.SACTIVITY AS sActivity, SA_DocLinkDefine.SPERSONFID AS sPersonFID FROM SA_DocLinkDefine SA_DocLinkDefine WHERE ( (SA_DocLinkDefine.SPROCESS = ?) AND ( (SA_DocLinkDefine.SACTIVITY = ?) OR (SA_DocLinkDefine.SACTIVITY IS NULL) ) ) OR ( (SA_DocLinkDefine.SPROCESS = ?) AND (SA_DocLinkDefine.SACTIVITY = ?) ) ORDER BY SA_DocLinkDefine.SACTIVITY DESC
--> binds:[/SKS/generalBiz/process/dailyListMgr/dailyListMgrProcess, , /SKS/generalBiz/process/dailyListMgr/dailyListMgrProcess, mainActivity]
2019-04-09 10:22:07 [SQL Time]sql 执行时间:7ms, exec KSQL: SELECT SKS_DailyListMgr.* FROM SKS_DailyListMgr SKS_DailyListMgr WHERE (((SKS_DailyListMgr.fCreateSid LIKE '12B723351ED64077B18F3AC395049BDB%'))) ORDER BY fValidDate DESC LIMIT 0, 20
--> sql:SELECT SKS_DailyListMgr.VERSION AS version, SKS_DailyListMgr.FNAME AS fName, SKS_DailyListMgr.FDEPTNAME AS fDeptName, SKS_DailyListMgr.FVALIDDATE AS fValidDate, SKS_DailyListMgr.FWORKPLANCONTENT AS fWorkPlanContent, SKS_DailyListMgr.FACTUALCOMPLETECONTENT AS fActualCompleteContent, SKS_DailyListMgr.FATTACHMENTS AS fAttachments, SKS_DailyListMgr.FCREATESFID AS fCreateSfid, SKS_DailyListMgr.FCREATESID AS fCreateSid, SKS_DailyListMgr.fID AS SKS_DailyListMgr FROM SKS_DAILYLISTMGR SKS_DailyListMgr WHERE SKS_DailyListMgr.FCREATESID LIKE ? ORDER BY fValidDate DESC
--> binds:[12B723351ED64077B18F3AC395049BDB%]
2019-04-09 10:22:07 [SQL Time]sql 执行时间:4ms, exec KSQL:
--> sql:SELECT count(*) FROM SKS_DAILYLISTMGR SKS_DailyListMgr WHERE SKS_DailyListMgr.FCREATESID LIKE ?
--> binds:[12B723351ED64077B18F3AC395049BDB%]
2019-04-09 10:22:07 [SQL Time]sql 执行时间:19ms, exec KSQL: SELECT SA_DocNode.* FROM SA_DocNode SA_DocNode WHERE ((SA_DocNode.sData1='007D356199404106B45EB7A0D850ED1B')) ORDER BY sLastWriteTime DESC,sCreateTime DESC LIMIT 0, -1
--> sql:SELECT SA_DocNode.sParentID AS sParentID, SA_DocNode.SDOCNAME AS sDocName, SA_DocNode.SSEQUENCE AS sSequence, SA_DocNode.SSIZE AS sSize, SA_DocNode.SKIND AS sKind, SA_DocNode.SDOCPATH AS sDocPath, SA_DocNode.SDOCDISPLAYPATH AS sDocDisplayPath, SA_DocNode.SCREATORFID AS sCreatorFID, SA_DocNode.SCREATORNAME AS sCreatorName, SA_DocNode.SCREATORDEPTNAME AS sCreatorDeptName, SA_DocNode.SCREATETIME AS sCreateTime, SA_DocNode.SEDITORFID AS sEditorFID, SA_DocNode.SEDITORNAME AS sEditorName, SA_DocNode.SEDITORDEPTNAME AS sEditorDeptName, SA_DocNode.SLASTWRITERFID AS sLastWriterFID, SA_DocNode.SLASTWRITERNAME AS sLastWriterName, SA_DocNode.SLASTWRITERDEPTNAME AS sLastWriterDeptName, SA_DocNode.SLASTWRITETIME AS sLastWriteTime, SA_DocNode.SFILEID AS sFileID, SA_DocNode.SDESCRIPTION AS sDescription, SA_DocNode.SDOCLIVEVERSIONID AS sDocLiveVersionID, SA_DocNode.SDOCSERIALNUMBER AS sDocSerialNumber, SA_DocNode.SKEYWORDS AS sKeywords, SA_DocNode.SCLASSIFICATION AS sClassification, SA_DocNode.SFINISHTIME AS sFinishTime, SA_DocNode.SNAMESPACE AS sNameSpace, SA_DocNode.SFLAG AS sFlag, SA_DocNode.VERSION AS version, SA_DocNode.SCACHENAME AS sCacheName, SA_DocNode.SREVISIONCACHENAME AS sRevisionCacheName, SA_DocNode.SACTIVITY AS sActivity, SA_DocNode.SACTIVITYNAME AS sActivityName, SA_DocNode.SPROCESS AS sProcess, SA_DocNode.SPROCESSNAME AS sProcessName, SA_DocNode.SDATA1 AS sData1, SA_DocNode.SEURL AS sEURL, SA_DocNode.STASKID AS sTaskID, SA_DocNode.SEXECUTORFID AS sExecutorFID, SA_DocNode.sID AS SA_DocNode FROM SA_DocNode SA_DocNode WHERE SA_DocNode.SDATA1 = ? ORDER BY sLastWriteTime DESC, sCreateTime DESC
--> binds:[007D356199404106B45EB7A0D850ED1B]
2019-04-09 10:23:07 加载模块:/SKS/highChamber/data ...
2019-04-09 10:23:07 [SQL Time]sql 执行时间:48ms, exec sql:{ORACLE=select ftasktypename from SKS_REMINDER where instr(fuserid,:fuserid)>0 and fcreatetime >= (sysdate - interval '3' MINUTE) group by ftasktypename}
--> binds:[12B723351ED64077B18F3AC395049BDB]
|
|