第三方接口,服务端命令增加获取token的http请求,速度要1分多钟,取消速度就很快,请教什么原因怎么解决呢?
执行过程如下:
19:05 执行'getQRCode-bak'命令, 请求方式:测试, 用户:匿名
参数:
client_id = "316952e3-8df1-4e23-b84f-f78a9b15"
client_secret = "e537dfa2-5406-4815-9d90-22e649b9"
scope = "FGC_AllAppsServerCommands"
grant_type = "client_credentials"
流转卡号 = "M-B-B-20240815002"
机台号 = "K001"
gettoken 用时:75590毫秒。
创建变量 client_id = 316952e3-8df1-4e23-b84f-f78a9b15
创建变量 client_secret = e537dfa2-5406-4815-9d90-22e649b9
创建变量 scope = FGC_AllAppsServerCommands
创建变量 grant_type = client_credentials
发送HTTP请求命令 用时:75566毫秒。
请求的URL地址:http://124.70.63.100/RTMES2.0_TEST/ServerCommand/gettoken
Http方法:POST
POST内容:client_id=316952e3-8df1-4e23-b84f-f78a9b15&client_secret=e537dfa2-5406-4815-9d90-22e649b9&scope=FGC_AllAppsServerCommands&grant_type=client_credentials
StatusCode: 200, ReasonPhrase: 'OK', Version: 1.1, Content: System.Net.Http.DecompressionHandler+GZipDecompressedContent, Headers: { Transfer-Encoding: chunked Vary: Accept-Encoding Server: Microsoft-HTTPAPI/2.0 Date: Sun, 25 Aug 2024 11:06:39 GMT Content-Type: application/json;charset=utf-8 }
创建变量 res = {"ErrCode":0}
创建变量 code = 0
创建变量 message = null
条件 用时:2987毫秒。
判断: =code 大于 0 结果为 False
判断: =code 等于 0 结果为 True
设置变量命令 : 校验流转卡 用时:1243毫秒。
SELECT COUNT(*) FROM 二维码信息表 WHERE [流转卡ID]->[流转卡号] = M-B-B-20240815002
创建变量 校验流转卡 = 55
设置变量命令 : 是否生效 用时:123毫秒。
SELECT [生效状态] FROM 流转卡主表 WHERE [流转卡号] = M-B-B-20240815002
创建变量 是否生效 = {"生效状态":"1"}
设置变量命令 : 机台校验 用时:216毫秒。
SELECT COUNT(*) FROM 流转卡子表 WHERE ([流转卡ID]->[流转卡号] = M-B-B-20240815002 and [机台] = K001)
创建变量 机台校验 = 1
设置变量命令 : 操作者 用时:422毫秒。
SELECT [班次ID]->[班次名称], [操作者ID]->[工号], [操作者ID]->[姓名] FROM 流转卡子表 WHERE ([流转卡ID]->[流转卡号] = M-B-B-20240815002 and [机台] = K001)
创建变量 操作者 = {"班次名称":"A","工号":null,"姓名":null}
条件 用时:861毫秒。
判断: (=校验流转卡 等于 0 或者 =校验流转卡 等于 %Null%) 结果为 False
判断: (=机台校验 等于 %Null% 或者 =机台校验 等于 0) 结果为 False
判断: =是否生效.生效状态 不等于 1 结果为 False
判断: (=校验流转卡 大于 0 并且 =机台校验 大于 0 并且 =是否生效.生效状态 等于 1) 结果为 True
执行SQL命令 用时:111毫秒。
参数列表
lzkh = "M-B-B-20240815002"
jth = "K001"
bc = "A"
gh = null
xm = null
SQL语句: SELECT a."流转卡号" as "流转卡号",d."物料名称" as "产品名称",d."物料编码" as "产品编码",d."打刻模板文件名" as "打刻模板文件名",d."二维码规则" as "二维码规则",b."机台" as "机台号",b."操作者ID" as "操作者ID",b."任务数量" as "刻印数量",c."二维码号" as "二维码号",c."产品状态" as "产品状态",c."刻印状态" as "刻印状态",@bc as "班次",@gh as "工号",@xm as "姓名"
FROM "流转卡主表" a ,"流转卡子表" b,"二维码信息表" c,"td_物料档案" d
where a."ID" = b."流转卡ID" and a."ID" = C."流转卡ID" AND "产品ID" = d."ID" and a."生效状态" = '1' and a."流转卡号" = @lzkh AND b."机台" = @jth
创建变量 res = [{"流转卡号":"M-B-B-20240815002","产品名称":"DHT33-2146712E后箱体","产品编码":"13490747","打刻模板文件名":"测试文件名","二维码规则":"153384-13490747-00-[YYYY][MM][DD]-[SN4]","机台号":"K001","操作者ID":null,"刻印数量":55,"二维码号":"153384-13490747-00-20240807-5001","产品状态":"1","刻印状态":"1","班次":"A","工号":null,"姓名":null},{"流转卡号":"M-B-B-20240815002","产品名称":"DHT33-2146712E后箱体","产品编码":"13490747","打刻模板文件名":"测试文件名","二维码规则":"153384-13490747-00-[YYYY][MM][DD]-[SN4]","机台号":"K001","操作者ID":null,"刻印数量":55,"二维码号":"153384-13490747-00-20240807-5002","产品状态":"1","刻印状态":"1","班次":"A","工号":null,"姓名":null},{"流转卡号":"M-B-B-20240815002","产品名称":"DHT33-2146712E后箱体","产品编码":"13490747","打刻模板文件名":"测试文件名","二维码规则":"153384-13490747-00-[YYYY][MM][DD]-[SN4]","机台号":"K001","操作者ID":null,"刻印数量":55,"二维码号":"153384-13490747-00-20240807-5003","产品状态":"1","刻印状态":"1","班次":"A","工号":null,"姓名":null},{"流转卡号":"M-B-B-20240815002","产品名称":"DHT33-2146712E后箱体","产品编码":"13490747","打刻模板文件名":"测试文件名","二维码规则":"153384-13490747-00-[YYYY][MM][DD]-[SN4]","机台号":"K001","操作者ID":null,"刻印数量":5...
数据表操作 : 更新 流转卡子表 用时:729毫秒。
UPDATE 流转卡子表 SET 上线时间 = 45529.79633886574 WHERE ([流转卡ID]->[流转卡号] = M-B-B-20240815002 and [机台] = K001)
返回命令 用时:6毫秒。
错误码: 0
信息: [{"流转卡号":"M-B-B-20240815002","产品名称":"DHT33-2146712E后箱体","产品编码":"13490747","打刻模板文件名":"测试文件名","二维码规则":"153384-13490747-00-[YYYY][MM][DD]-[SN4]","机台号":"K001","操作者ID":null,"刻印数量":55,"二维码号":"153384-13490747-00-20240807-5001","产品状态":"1","刻印状态":"1","班次":"A","工号":null,"姓名":null},{"流转卡号":"M-B-B-20240815002","产品名称":"DHT33-2146712E后箱体","产品编码":"13490747","打刻模板文件名":"测试文件名","二维码规则":"153384-13490747-00-[YYYY][MM][DD]-[SN4]","机台号":"K001","操作者ID":null,"刻印数量":55,"二维码号":"153384-13490747-00-20240807-5002","产品状态":"1","刻印状态":"1","班次":"A","工号":null,"姓名":null},{"流转卡号":"M-B-B-20240815002","产品名称":"DHT33-2146712E后箱体","产品编码":"13490747","打刻模板文件名":"测试文件名","二维码规则":"153384-13490747-00-[YYYY][MM][DD]-[SN4]","机台号":"K001","操作者ID":null,"刻印数量":55,"二维码号":"153384-13490747-00-20240807-5003","产品状态":"1","刻印状态":"1","班次":"A","工号":null,"姓名":null},{"流转卡号":"M-B-B-20240815002","产品名称":"DHT33-2146712E后箱体","产品编码":"13490747","打刻模板文件名":"测试文件名","二维码规则":"153384-13490747-00-[YYYY][MM][DD]-[SN4]","机台号":"K001","操作者ID":null,"刻印数量":55,"二维码号...
msg: "数据下载成功!"
'getQRCode-bak'命令执行结束, 用时:79108毫秒。
服务端命令如下:
|