关于附件

ljdkzd

2019-09-06 11:03:03 [SQL Time]sql 执行时间：5ms, exec KSQL: select SA_DocLinkDefine,SA_DocLinkDefine.sDefineItems,SA_DocLinkDefine.sActivity,SA_DocLinkDefine.sPersonFID from SA_DocLinkDefine SA_DocLinkDefine where (SA_DocLinkDefine.sProcess='/HR/entryInformation/process/entryInfo/entryInfoProcess' and (SA_DocLinkDefine.sActivity='' or SA_DocLinkDefine.sActivity IS NULL)) or (SA_DocLinkDefine.sProcess='/HR/entryInformation/process/entryInfo/entryInfoProcess' and SA_DocLinkDefine.sActivity='entryInfoInfo')  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:[/HR/entryInformation/process/entryInfo/entryInfoProcess, , /HR/entryInformation/process/entryInfo/entryInfoProcess, entryInfoInfo]





页面上有附件就会执行大量的上面的这种SQL，导致页面加载很慢，请问页面有附件为什么要执行这些SQL？有没有办法不执行？

jishuang

要查找数据拼接url进行显示啊

ljdkzd

这个不是查找数据的URL的，没有数据的时候也会执行这些SQL，页面上只要有一个附件组件就会执行一次

jishuang

不是说你自己拼接url，附件组件中显示附件的时候要拼接啊