2025-11-10 07:33:09 执行时长：5.08秒 sql:SELECT a.id,rolename,a.roleid FROM Base_Role a left join Base_UserRole b on a.roleid=b.roleid where userid=@userID

2025-11-10 07:33:10 执行时长：6.29秒 sql:select TaskName,StartTime,FrequencyType,RunFrequency, RunStoredProcedureName,ExtendMethodName,PartnerApiUrl, PartnerApiMethod,PartnerApiParas from Base_ScheduleTask where IsUse = 1

2025-11-10 07:33:15 执行时长：5.46秒 sql:SELECT a.id,bizentityid,a.dataentityid,isprimary,isapprove,relatedcolumnid,relatedmaincolumnid,dataentityname,a.readonly,b.dataentitycode,notneedsecurity,a.orderno,cardinput,batchupdate,pagesize,a.refbizentityid,a.notallownull,displayinlist,NotCascadeDelete,rowfilter,NotAllowAdd,NotAllowDelete,a.BizDataName   FROM Base_BizData a left join Base_DataEntity b on a.dataentityid=b.id where a.bizentityid=@bizEntityID order by a.orderno,a.id

2025-11-10 07:33:17 执行时长：7.55秒 sql:INSERT INTO Base_Log(id,username,logdate,modulename,operatetype,remark,ipaddress) values  ('63f9f439f4ea789d', @userName,@logDate,@moduleName,@OperateType,@remark,@ip )

2025-11-10 07:33:21 执行时长：5.85秒 sql:select filterexp from Base_BizEntity where id=@bizEntityID

2025-11-10 07:33:27 执行时长：5.42秒 sql:SELECT ID,BizEntityCode,BizEntityName,IsBottom,BizClass,EntityClass,SystemEntity,CardIsMax,filterexp,OnlyOwnerChange,OnlyOwnerDelete,CalendarView, CalendarBeginDate,CalendarEndDate,CalendarItem,CalendarColor,GraphType,LengendPos,ClassFont,ClassColumns,DataColumns,GraphRowCount,Copies, DirectToPrinter,Remark,filter,IgnoreSecurity,ListWithSubData,LengendFont,DisplayOnMobile,CustomDataSource FROM Base_BizEntity WHERE ID like @id+'%' and len(ID)=len(@id)+3 order by id 

2025-11-10 07:33:27 执行时长：5.23秒 sql:select d.dataentityname,b.datacolumncode,a.orderoption,e.dataentityname,f.datacolumncode,b.datacolumnname,b.rsmultiselect as multiselect  from base_bizcolumn a left join base_datacolumn b on a.datacolumnid=b.id  left join base_bizdata c on a.bizdataid=c.id  left join base_dataentity d on c.dataentityid=d.id  left join base_dataentity e on b.rsentity=e.id  left join base_datacolumn f on b.RsDisplayColumn=f.id  where ordercolumn=1 and orderoption<>'' and VisibleInList=1 and a.bizdataid='0132' and b.datacolumncode<>''  order by ordernumber

2025-11-10 07:33:27 执行时长：5.42秒 sql:SELECT a.id,rolename,a.roleid FROM Base_Role a left join Base_UserRole b on a.roleid=b.roleid where userid=@userID

2025-11-10 07:33:34 执行时长：5.53秒 sql:SELECT a.id,rolename,a.roleid FROM Base_Role a left join Base_UserRole b on a.roleid=b.roleid where userid=@userID

2025-11-10 07:33:34 执行时长：5.8秒 sql:select top 12  b.ID,b.BizEntityName,b.BizClass,COUNT(b.ID)  from Base_Log a inner join Base_BizEntity b on a.ModuleName=b.BizEntityName  where UserName = @userName and b.EntityClass = 1 and BizEntityName <> '系统'  group by b.ID, b.BizEntityName, b.BizClass  order by COUNT(b.ID) desc 

2025-11-10 07:33:40 执行时长：5.46秒 sql:SELECT a.id,rolename,a.roleid FROM Base_Role a ,Base_UserRole b ,base_roleaccredit c where a.roleid=b.roleid and b.userid=c.fromuserid and  touserid=@userID and isactivity=1 and startdate<='2025-11-10 07:33:34'

2025-11-10 07:33:46 执行时长：5.52秒 sql:SELECT distinct b.id,a.id as BizEntityID,AllowAdd,allowread,orgsecurity,rolesecurity,usersecurity,allowdelete,allowedit,allowapprove,uidesign,allowoutput,updateFromExcel,importfromexcel,outputtoexcel  FROM Base_bizentity a left join Base_RoleRight b  on a.id=b.bizentityid and roleid=@roleID where a.id not like '000%' or a.id in ('000004','000010') order by a.id

2025-11-10 07:34:08 执行时长：5.57秒 sql:select * from Base_MessageServerPara WITH(NOLOCK)