|
楼主 |
发表于 2019-2-20 16:09:34
|
显示全部楼层
这是控制台打印的
2019-02-20 16:08:50 exec KSQL: SELECT Wl_customerinfo.fCustomerName as fCustomerName,Wl_customerinfo.fCertNo as fCertNo,Wl_businessapplication.fDocumentSequence as fDocumentSequence,Wl_businessapplication.fBusinessDate as fBusinessDate,Wl_businessapplication.fDealers as fDealers,Wl_businessapplication.fSalesman as fSalesman,Wl_businessapplication FROM Wl_businessapplication Wl_businessapplication join Wl_customerinfo Wl_customerinfo on Wl_customerinfo.fCustomerinfoParentlink = Wl_businessapplication WHERE (Wl_businessapplication.fOrgID = :currentOgnID()) ORDER BY fBusinessDate DESC LIMIT 0, 20
--> sql:SELECT Wl_businessapplication.fID, Wl_businessapplication.FBUSINESSDATE AS fBusinessDate, Wl_customerinfo.FCERTNO AS fCertNo, Wl_customerinfo.FCUSTOMERNAME AS fCustomerName, Wl_businessapplication.FDEALERS AS fDealers, Wl_businessapplication.FDOCUMENTSEQUENCE AS fDocumentSequence, Wl_businessapplication.FSALESMAN AS fSalesman FROM wl_businessapplication Wl_businessapplication JOIN wl_customerinfo Wl_customerinfo ON Wl_customerinfo.FCUSTOMERINFOPARENTLINK = Wl_businessapplication.fID WHERE Wl_businessapplication.FORGID = ? ORDER BY fBusinessDate DESC
--> binds:[ORG01]
--> dataModel|M|/SAAS/common/data
--> fnModelnull
2019-02-20 16:08:50
exec KSQL: SELECT Wl_customerinfo.fCustomerName as fCustomerName,Wl_customerinfo.fCertNo as fCertNo,Wl_businessapplication.fDocumentSequence as fDocumentSequence,Wl_businessapplication.fBusinessDate as fBusinessDate,Wl_businessapplication.fDealers as fDealers,Wl_businessapplication.fSalesman as fSalesman,Wl_businessapplication FROM Wl_businessapplication Wl_businessapplication join Wl_customerinfo Wl_customerinfo on Wl_customerinfo.fCustomerinfoParentlink = Wl_businessapplication WHERE (Wl_businessapplication.fOrgID = :currentOgnID()) ORDER BY fBusinessDate DESC LIMIT 0, 20
--> sql:SELECT ROWNUM AS JUSTEP_RN__, JUSTEP_TABLE__.* FROM (SELECT Wl_businessapplication.fID, Wl_businessapplication.FBUSINESSDATE AS fBusinessDate, Wl_customerinfo.FCERTNO AS fCertNo, Wl_customerinfo.FCUSTOMERNAME AS fCustomerName, Wl_businessapplication.FDEALERS AS fDealers, Wl_businessapplication.FDOCUMENTSEQUENCE AS fDocumentSequence, Wl_businessapplication.FSALESMAN AS fSalesman FROM wl_businessapplication Wl_businessapplication JOIN wl_customerinfo Wl_customerinfo ON Wl_customerinfo.FCUSTOMERINFOPARENTLINK = Wl_businessapplication.fID WHERE Wl_businessapplication.FORGID = ? ORDER BY fBusinessDate DESC) JUSTEP_TABLE__ WHERE ROWNUM<21
--> binds:[ORG01]
2019-02-20 16:08:50 Connection product name:Oracle
2019-02-20 16:08:50 Connection product version:Oracle Database 11g Release 11.1.0.0.0 - Production
处理隔离字段前:SELECT ROWNUM AS JUSTEP_RN__, JUSTEP_TABLE__.* FROM (SELECT Wl_businessapplication.fID, Wl_businessapplication.FBUSINESSDATE AS fBusinessDate, Wl_customerinfo.FCERTNO AS fCertNo, Wl_customerinfo.FCUSTOMERNAME AS fCustomerName, Wl_businessapplication.FDEALERS AS fDealers, Wl_businessapplication.FDOCUMENTSEQUENCE AS fDocumentSequence, Wl_businessapplication.FSALESMAN AS fSalesman FROM wl_businessapplication Wl_businessapplication JOIN wl_customerinfo Wl_customerinfo ON Wl_customerinfo.FCUSTOMERINFOPARENTLINK = Wl_businessapplication.fID WHERE Wl_businessapplication.FORGID = ? ORDER BY fBusinessDate DESC) JUSTEP_TABLE__ WHERE ROWNUM<21
处理隔离字段后:SELECT ROWNUM AS JUSTEP_RN__, JUSTEP_TABLE__.* FROM (SELECT Wl_businessapplication.fID, Wl_businessapplication.FBUSINESSDATE AS fBusinessDate, Wl_customerinfo.FCERTNO AS fCertNo, Wl_customerinfo.FCUSTOMERNAME AS fCustomerName, Wl_businessapplication.FDEALERS AS fDealers, Wl_businessapplication.FDOCUMENTSEQUENCE AS fDocumentSequence, Wl_businessapplication.FSALESMAN AS fSalesman FROM wl_businessapplication Wl_businessapplication JOIN wl_customerinfo Wl_customerinfo ON Wl_customerinfo.FCUSTOMERINFOPARENTLINK = Wl_businessapplication.fID WHERE Wl_businessapplication.FORGID = ? ORDER BY fBusinessDate DESC) JUSTEP_TABLE__ WHERE ROWNUM<21
2019-02-20 16:08:50 Connection product name:Oracle
2019-02-20 16:08:50 Connection product version:Oracle Database 11g Release 11.1.0.0.0 - Production
|
|