|
|
楼主 |
发表于 2018-3-26 11:08:09
|
显示全部楼层
本帖最后由 chenweibinx 于 2018-3-26 11:16 编辑
2018-03-26 11:11:56 [SQL Time]sql 执行时间：7ms, exec KSQL: SELECT Dye_PutOutMain.* FROM Dye_PutOutMain Dye_PutOutMain WHERE ((fOrderno='OA180323001')) LIMIT 0, 20
--> sql:SELECT Dye_PutOutMain.fID AS Dye_PutOutMain, Dye_PutOutMain.FAPSTORENO AS fAPStoreNo, Dye_PutOutMain.FAPFULLNAME AS fApFullName, Dye_PutOutMain.FAPPLYCONTENT AS fApplyContent, Dye_PutOutMain.FAPPLYDEPT AS fApplyDept, Dye_PutOutMain.FAPPLYNAME AS fApplyName, Dye_PutOutMain.FBUSMODENAME AS fBusModeName, Dye_PutOutMain.FBUSMODENO AS fBusModeNo, Dye_PutOutMain.FCHECKDATE AS fCheckDate, Dye_PutOutMain.FCHECKNAME AS fCheckName, Dye_PutOutMain.FCOMPANYNO AS fCompanyNo, Dye_PutOutMain.FCOUNTTYPE AS fCountType, Dye_PutOutMain.FCREATEDATE AS fCreateDate, Dye_PutOutMain.FCREATENAME AS fCreateName, Dye_PutOutMain.FEDITDATE AS fEditDate, Dye_PutOutMain.FEDITNAME AS fEditName, Dye_PutOutMain.FORDERNO AS fOrderno, Dye_PutOutMain.FOUTFACTORY AS fOutFactory, Dye_PutOutMain.FPRINT AS fPrint, Dye_PutOutMain.FRECEIPTPLACE AS fReceiptPlace, Dye_PutOutMain.FREMARK AS fRemark, Dye_PutOutMain.FSTATE AS fState, Dye_PutOutMain.FTALLYDATE AS fTallyDate, Dye_PutOutMain.VERSION AS version FROM DYE_PUTOUTMAIN Dye_PutOutMain WHERE fOrderno = ?
--> binds:[OA180323001]
2018-03-26 11:11:56 [SQL Time]sql 执行时间：4ms, exec KSQL:
--> sql:SELECT count(*) FROM DYE_PUTOUTMAIN Dye_PutOutMain WHERE fOrderno = ?
--> binds:[OA180323001]
好像只有主表的sql，没有从表的，然后我发现data的autoLoad选择true就可以了
|
|
IP卡
狗仔卡
发表于 2018-3-26 08:56:35
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
显身卡
发表于 2018-3-26 11:04:45
