登录名或密码错误

xiaoxunv

控制台输出结果：
为什么一个登录会执行那么多sql语句？？？，这么多sql语句加起来，就导致登陆过程很慢

2018-08-22 18:03:29 [SQL Time]sql 执行时间：40ms, exec KSQL: select case when UPPER(p.sLoginName)=:name then 1 when UPPER(p.sCode)=:name then 2 else 3 end as odr , mo, mo.sFID, mo.sFName, mo.sFCode, p.* from SA_OPPerson p join SA_OPOrg mo ON p.sMainOrgID = mo where (UPPER(p.sLoginName)=:name or UPPER(p.sCode)=:name) and p.sValidState=1 order by odr

2018-08-22 18:03:30 [SQL Time]sql 执行时间：5ms, exec KSQL: SELECT p, p.sName AS pname, p.sCode AS pcode, mo, mo.sFID as m_sfid, mo.sFName as m_sfname, mo.sFCode as m_sfcode , a.sOrgFName as agt_fname, a.sOrgFID as agt_fid, a.sProcess as agt_process  FROM SA_OPPerson p JOIN SA_OPOrg mo ON p.sMainOrgID = mo JOIN SA_OPOrg pm ON pm.sValidState = 1 AND pm.sPersonID = p AND pm.sOrgKindID = 'psm' JOIN SA_OPAgent a ON a.sOrgFID = pm.sFID AND a.sAgentID = '81E94563C7BE411BACACE5E5506CDF38' AND a.sValidState = 1 AND :now >= a.sStartTime AND (a.sFinishTime IS NULL OR a.sFinishTime >= :now)

2018-08-22 18:03:30 [SQL Time]sql 执行时间：93ms, exec KSQL: select pm.sFID AS pm_fid,pm.sFName AS pm_fname,pm.sFCode AS pm_fcode, r, perm1.*  from SA_OPOrg pm OPTIONAL JOIN  SA_OPAuthorize au JOIN SA_OPRole r ON au.sAuthorizeRoleID=r AND r.sValidState = 1 OPTIONAL JOIN SA_OPPermission perm1 ON perm1.sPermissionRoleID=r  and perm1.sValidState=1  ON pm.sFID like concat(au.sOrgFID, '%') WHERE pm.sValidState=1 and pm.sPersonID=:personId and pm.sOrgKindID=:kind

2018-08-22 18:03:36 [SQL Time]sql 执行时间：12ms, exec KSQL: select r,par,p.* from SA_OPRole par optional join SA_OPPermission p on p.sPermissionRoleID=par and par.sValidState = 1 and p.sValidState=1 join SA_OPRole r on par=r.sParentRole AND r IN ('1BF621C69FC849B59C52D7E40AC48B67', '941BFF1D949444179864EEEE30EDE168', 'D037C4EC0F574EDCAB443AD1B2BB70A4', 'FF471F51D2A54E229C44EA9C41CE45D6', 'A4E2D13E44B040E0BBFE9645C1370CB5', '35C42021E32240538F91393982C44EC4', 'CE4D9CCC693E4E96BE5B56FEBD5003D3', '898C39D4DD454D1193D29C9EBFA71E6F', 'RL-SYSTEM-GRADE', 'AEAECFE8A2D24C3F94B1FDA9F1633EBC', 'EF60D96D2CB9464AAEC329F622E6EB99', '2C12FA9823A3468D8163BD07588406C3', '499D622209964B5F9938F3B611EAEF67', '9C64C919964E4926BBD463B23BF338A3', '44E8FD1C573048A4B71C33CC8AB0B4A0', '98594424404747A28D68D67A62D85DFF)

2018-08-22 18:03:37 [SQL Time]sql 执行时间：4ms, exec KSQL: select r,par,p.* from SA_OPRole par optional join SA_OPPermission p on p.sPermissionRoleID=par and par.sValidState = 1 and p.sValidState=1 join SA_OPRole r on par=r.sParentRole AND r IN ('BD6D2E44AE22477580798D9E030E71D8', 'BBBB25C3E8054234A7FEFE7A02BFB23C', '06E9040B951849EF938482E514D26E14', '09955B64F15C49C59DA6AFD55BC0CA81', 'FF471F51D2A54E229C44EA9C41CE45D6', '0BC78E62041847D0B6C87CD9CF083E7C', '9C938DEC45A8435D8286EEEAA5494C37', '86213FB8C26E44AE935E2852A7C05B20', '77B6ADFBCA0449628564643FB1CC7F66', '46EE6E3793A64F0B9CB67CAFEAE45A0B')

2018-08-22 18:03:37 [SQL Time]sql 执行时间：2ms, exec KSQL: select m.*,mt.sCode from SA_OPManagement m optional join SA_OPManageType mt on m.sManageTypeID=mt where '/A100100000000.ogn/81E94563C7BE411BACACE5E5506CDF38@A100100000000.psm' like concat(m.sOrgFID, '%')

2018-08-22 18:03:38 [SQL Time]sql 执行时间：1ms, exec KSQL: select SA_OPPerson, SA_OPPerson.sName from SA_OPPerson SA_OPPerson where SA_OPPerson.sValidState=1

2018-08-22 18:03:38 [SQL Time]sql 执行时间：2ms, exec KSQL: select DISTINCT o.sPersonID as SA_OPPerson, o.sName from SA_OPOrg o where o.sValidState=1 and o.sOrgKindID='psm'

2018-08-22 18:03:38 [SQL Time]sql 执行时间：2ms, exec KSQL: select SA_OPPerson, SA_OPPerson.sName from SA_OPPerson SA_OPPerson where SA_OPPerson.sValidState > 0

2018-08-22 18:03:40 [SQL Time]sql 执行时间：3ms, exec KSQL: select t, t.sName, t.sCURL, t.sProcess, t.sActivity, t.sCreateTime, t.sExecutorFName, t.sExecutorNames, t.sEURL, t.sCreatorFName, t.sShortcut, t.sHints, t.sCreatorFID, t.sExecutorFID, t.sKindID  from SA_Task t  where (t.sCreatorFID = '/A100100000000.ogn/81E94563C7BE411BACACE5E5506CDF38@A100100000000.psm' ) and (t.sKindID='tkTask' or t.sKindID='tkNotice')  and (t.sTypeID IS NULL or t.sTypeID <> 'WORKREMIND') and (t.sStatusID='tesReady' or t.sStatusID='tesExecuting')  order by t.sCreateTime desc  limit 0,8

2018-08-22 18:03:41 [SQL Time]sql 执行时间：232ms, exec KSQL: select t, t.sName, t.sCURL, t.sProcess, t.sActivity, t.sCreateTime, t.sExecutorFName, t.sExecutorNames, t.sEURL, t.sCreatorFName, t.sShortcut, t.sHints, t.sCreatorFID, t.sExecutorFID, t.sKindID  from SA_Task t  where (t.sKindID='tkTask' or t.sKindID='tkExecutor' or t.sKindID='tkNotice' or t.sKindID IS NULL)  and (t.sStatusID='tesReady' or t.sStatusID='tesExecuting')  and (t.sTypeID IS NULL or t.sTypeID <> 'WORKREMIND') and (('/A100100000000.ogn/81E94563C7BE411BACACE5E5506CDF38@A100100000000.psm' like concat(t.sExecutorFID, '%')) and (t.sExecutorFID like '/%')) order by  t.sCreateTime desc  limit 0,8

jishuang

这些都是毫秒的，加起来也不到1秒，有些是登录后首页显示的widget的查的数据，不是登录查的