|
![](template/yudi_2016_bbs/ybimg/common/ico_lz.png)
楼主 |
发表于 2018-2-7 17:41:53
|
显示全部楼层
2018-02-07 17:28:36 [KSQL Time]sql 执行时间:106566ms, ksql:select pm.sFID AS pm_fid,pm.sFName AS pm_fname,pm.sFCode AS pm_fcode, r, r.sCode as r_sCode, r.sName as r_sName, perm1.* from SA_OPOrg pm OPTIONAL JOIN SA_OPAuthorize au ON pm.sFID like concat(au.sOrgFID, '%') 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) WHERE pm.sValidState=1 and pm.sPersonID=:personId and pm.sOrgKindID=:kind
2018-02-07 17:28:49 [KSQL Time]sql 执行时间:12375ms, ksql:select SA_OPPerson, SA_OPPerson.sName from SA_OPPerson SA_OPPerson where SA_OPPerson.sValidState=1
2018-02-07 17:29:00 [KSQL Time]sql 执行时间:11070ms, ksql:select DISTINCT o.sPersonID as SA_OPPerson, o.sName from SA_OPOrg o where o.sValidState=1 and o.sOrgKindID='psm'
2018-02-07 17:29:11 [KSQL Time]sql 执行时间:11487ms, ksql:select SA_OPPerson, SA_OPPerson.sName from SA_OPPerson SA_OPPerson where SA_OPPerson.sValidState > 0
|
|