|
|
楼主 |
发表于 2019-8-21 15:50:39
|
显示全部楼层
2019-08-21 15:46:23 [SQL Time]sql 执行时间：1ms, exec KSQL: SELECT XM_JCXXB.*,XM_JCSJZDB.fMC as FLB FROM XM_JCXXB XM_JCXXB join XM_JCSJZDB XM_JCSJZDB on XM_JCXXB.fFLMC = XM_JCSJZDB.fBM WHERE (XM_JCXXB.fYWLX = '抵押金字典' and XM_JCSJZDB.fYWLX ='XMXMGL-ZJGL-JBSZ-LB') AND ((XM_JCXXB.fSJID='0BA49AA127DC46B1BAE18065BBF1C61D')) LIMIT 0, 20
--> sql:SELECT XM_JCSJZDB.FMC AS FLB, XM_JCXXB.fID AS XM_JCXXB, XM_JCXXB.FBM AS fBM, XM_JCXXB.FBZ AS fBZ, XM_JCXXB.FDW AS fDW, XM_JCXXB.FFLMC AS fFLMC, XM_JCXXB.FGCLB AS fGCLB, XM_JCXXB.FGLFL_ZBHT AS fGLFL_ZBHT, XM_JCXXB.FJB AS fJB, XM_JCXXB.FJDLX AS fJDLX, XM_JCXXB.FMC AS fMC, XM_JCXXB.FPHDW AS fPHDW, XM_JCXXB.FQLJID AS fQLJID, XM_JCXXB.FQLJMC AS fQLJMC, XM_JCXXB.FQYRQ AS fQYRQ, XM_JCXXB.FSJID AS fSJID, XM_JCXXB.FSSQY AS fSSQY, XM_JCXXB.FSXJE AS fSXJE, XM_JCXXB.FSZ AS fSZ, XM_JCXXB.FTBR AS fTBR, XM_JCXXB.FTBRFID AS fTBRFID, XM_JCXXB.FTBRID AS fTBRID, XM_JCXXB.FTBSJ AS fTBSJ, XM_JCXXB.FTYRQ AS fTYRQ, XM_JCXXB.FXH AS fXH, XM_JCXXB.FXMLX AS fXMLX, XM_JCXXB.FXXJE AS fXXJE, XM_JCXXB.FYWLX AS fYWLX, XM_JCXXB.FZBID AS fZBID, XM_JCXXB.FZRBM AS fZRBM, XM_JCXXB.FZRBMID AS fZRBMID, XM_JCXXB.FZT AS fZT, XM_JCXXB.VERSION AS version FROM XM_JCXXB XM_JCXXB JOIN XM_JCSJZDB XM_JCSJZDB ON XM_JCXXB.FFLMC = XM_JCSJZDB.FBM WHERE ( (XM_JCXXB.FYWLX = ?) AND (XM_JCSJZDB.FYWLX = ?) ) AND (XM_JCXXB.FSJID = ?)
--> binds:[抵押金字典, XMXMGL-ZJGL-JBSZ-LB, 0BA49AA127DC46B1BAE18065BBF1C61D]
2019-08-21 15:46:23 [SQL Time]sql 执行时间：0ms, exec KSQL:
--> sql:SELECT count(*) FROM XM_JCXXB XM_JCXXB JOIN XM_JCSJZDB XM_JCSJZDB ON XM_JCXXB.FFLMC = XM_JCSJZDB.FBM WHERE ( (XM_JCXXB.FYWLX = ?) AND (XM_JCSJZDB.FYWLX = ?) ) AND (XM_JCXXB.FSJID = ?)
--> binds:[抵押金字典, XMXMGL-ZJGL-JBSZ-LB, 0BA49AA127DC46B1BAE18065BBF1C61D] |
|
IP卡
狗仔卡
发表于 2019-8-21 14:34:03
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
显身卡
发表于 2019-8-21 15:06:17
