2022-10-04 00:07:23 [21] ERROR lp.shop.core.LogBase 【GetShopProgrammeListPage】======MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'lp_basic.c' doesn't exist 在 lp.shop.db.SQLHelper.ExecuteScalar(CommandType cmdType, String cmdStr, MySqlParameter[] cmdParams) 位置 E:\Work\lp_-shop_-hd\lp.shop.db\SQLHelper.cs:行号 234 在 lp.shop.db.SQLHelper.ExecuteScalar(CommandType cmdType, String cmdStr) 位置 E:\Work\lp_-shop_-hd\lp.shop.db\SQLHelper.cs:行号 246 在 lp.shop.dal.sqlcore_dal.Allpage(String tblName, String fldname, Int32 pagesize, Int32 pageindex, String orderby, String where, Int32& totalcount, Int32& pagecount, String groupby) 位置 E:\Work\lp_-shop_-hd\lp.shop.dal\sqlcore_dal.cs:行号 70 在 lp.shop.bll.sqlcore_bll.Allpage(String tblName, String fldname, Int32 pagesize, Int32 pageindex, String orderby, String where, Int32& totalcount, Int32& pagecount, String groupby) 位置 E:\Work\lp_-shop_-hd\lp.shop.bll\sqlcore_bll.cs:行号 47 在 lp.shop.bll.lp_shop_programme_bll.get_shop_programme_list(String id, String programmeno, String programmename, String roomid, String styleid, Int32 is_up, Int32 programmenotype, String stored_id, Int32 pageindex, Int32 pagesize, Int32 ispage) 位置 E:\Work\lp_-shop_-hd\lp.shop.bll\lp_shop_programme_bll.cs:行号 77 在 lp.shop.api.Controllers.web.WebShopProgrammeController.GetShopProgrammeListPage(ShopProgrammeListPageInPut input) 位置 E:\Work\lp_-shop_-hd\lp.shop.api\Controllers\web\WebShopProgrammeController.cs:行号 42 2022-10-04 00:07:29 [55] ERROR lp.shop.core.LogBase 【GetShopProgrammeListPage】======MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'lp_basic.c' doesn't exist 在 lp.shop.db.SQLHelper.ExecuteScalar(CommandType cmdType, String cmdStr, MySqlParameter[] cmdParams) 位置 E:\Work\lp_-shop_-hd\lp.shop.db\SQLHelper.cs:行号 234 在 lp.shop.db.SQLHelper.ExecuteScalar(CommandType cmdType, String cmdStr) 位置 E:\Work\lp_-shop_-hd\lp.shop.db\SQLHelper.cs:行号 246 在 lp.shop.dal.sqlcore_dal.Allpage(String tblName, String fldname, Int32 pagesize, Int32 pageindex, String orderby, String where, Int32& totalcount, Int32& pagecount, String groupby) 位置 E:\Work\lp_-shop_-hd\lp.shop.dal\sqlcore_dal.cs:行号 70 在 lp.shop.bll.sqlcore_bll.Allpage(String tblName, String fldname, Int32 pagesize, Int32 pageindex, String orderby, String where, Int32& totalcount, Int32& pagecount, String groupby) 位置 E:\Work\lp_-shop_-hd\lp.shop.bll\sqlcore_bll.cs:行号 47 在 lp.shop.bll.lp_shop_programme_bll.get_shop_programme_list(String id, String programmeno, String programmename, String roomid, String styleid, Int32 is_up, Int32 programmenotype, String stored_id, Int32 pageindex, Int32 pagesize, Int32 ispage) 位置 E:\Work\lp_-shop_-hd\lp.shop.bll\lp_shop_programme_bll.cs:行号 77 在 lp.shop.api.Controllers.web.WebShopProgrammeController.GetShopProgrammeListPage(ShopProgrammeListPageInPut input) 位置 E:\Work\lp_-shop_-hd\lp.shop.api\Controllers\web\WebShopProgrammeController.cs:行号 42 2022-10-04 00:07:36 [21] ERROR lp.shop.core.LogBase 【GetShopProgrammeListPage】======MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'lp_basic.c' doesn't exist 在 lp.shop.db.SQLHelper.ExecuteScalar(CommandType cmdType, String cmdStr, MySqlParameter[] cmdParams) 位置 E:\Work\lp_-shop_-hd\lp.shop.db\SQLHelper.cs:行号 234 在 lp.shop.db.SQLHelper.ExecuteScalar(CommandType cmdType, String cmdStr) 位置 E:\Work\lp_-shop_-hd\lp.shop.db\SQLHelper.cs:行号 246 在 lp.shop.dal.sqlcore_dal.Allpage(String tblName, String fldname, Int32 pagesize, Int32 pageindex, String orderby, String where, Int32& totalcount, Int32& pagecount, String groupby) 位置 E:\Work\lp_-shop_-hd\lp.shop.dal\sqlcore_dal.cs:行号 70 在 lp.shop.bll.sqlcore_bll.Allpage(String tblName, String fldname, Int32 pagesize, Int32 pageindex, String orderby, String where, Int32& totalcount, Int32& pagecount, String groupby) 位置 E:\Work\lp_-shop_-hd\lp.shop.bll\sqlcore_bll.cs:行号 47 在 lp.shop.bll.lp_shop_programme_bll.get_shop_programme_list(String id, String programmeno, String programmename, String roomid, String styleid, Int32 is_up, Int32 programmenotype, String stored_id, Int32 pageindex, Int32 pagesize, Int32 ispage) 位置 E:\Work\lp_-shop_-hd\lp.shop.bll\lp_shop_programme_bll.cs:行号 77 在 lp.shop.api.Controllers.web.WebShopProgrammeController.GetShopProgrammeListPage(ShopProgrammeListPageInPut input) 位置 E:\Work\lp_-shop_-hd\lp.shop.api\Controllers\web\WebShopProgrammeController.cs:行号 42 2022-10-04 00:13:23 [21] ERROR lp.shop.core.LogBase 【GetShopProgrammeListPage】======MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'lp_basic.c' doesn't exist 在 lp.shop.db.SQLHelper.ExecuteScalar(CommandType cmdType, String cmdStr, MySqlParameter[] cmdParams) 位置 E:\Work\lp_-shop_-hd\lp.shop.db\SQLHelper.cs:行号 234 在 lp.shop.db.SQLHelper.ExecuteScalar(CommandType cmdType, String cmdStr) 位置 E:\Work\lp_-shop_-hd\lp.shop.db\SQLHelper.cs:行号 246 在 lp.shop.dal.sqlcore_dal.Allpage(String tblName, String fldname, Int32 pagesize, Int32 pageindex, String orderby, String where, Int32& totalcount, Int32& pagecount, String groupby) 位置 E:\Work\lp_-shop_-hd\lp.shop.dal\sqlcore_dal.cs:行号 70 在 lp.shop.bll.sqlcore_bll.Allpage(String tblName, String fldname, Int32 pagesize, Int32 pageindex, String orderby, String where, Int32& totalcount, Int32& pagecount, String groupby) 位置 E:\Work\lp_-shop_-hd\lp.shop.bll\sqlcore_bll.cs:行号 47 在 lp.shop.bll.lp_shop_programme_bll.get_shop_programme_list(String id, String programmeno, String programmename, String roomid, String styleid, Int32 is_up, Int32 programmenotype, String stored_id, Int32 pageindex, Int32 pagesize, Int32 ispage) 位置 E:\Work\lp_-shop_-hd\lp.shop.bll\lp_shop_programme_bll.cs:行号 77 在 lp.shop.api.Controllers.web.WebShopProgrammeController.GetShopProgrammeListPage(ShopProgrammeListPageInPut input) 位置 E:\Work\lp_-shop_-hd\lp.shop.api\Controllers\web\WebShopProgrammeController.cs:行号 42 2022-10-04 00:13:26 [25] ERROR lp.shop.core.LogBase 【GetShopProgrammeListPage】======MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'lp_basic.c' doesn't exist 在 lp.shop.db.SQLHelper.ExecuteScalar(CommandType cmdType, String cmdStr, MySqlParameter[] cmdParams) 位置 E:\Work\lp_-shop_-hd\lp.shop.db\SQLHelper.cs:行号 234 在 lp.shop.db.SQLHelper.ExecuteScalar(CommandType cmdType, String cmdStr) 位置 E:\Work\lp_-shop_-hd\lp.shop.db\SQLHelper.cs:行号 246 在 lp.shop.dal.sqlcore_dal.Allpage(String tblName, String fldname, Int32 pagesize, Int32 pageindex, String orderby, String where, Int32& totalcount, Int32& pagecount, String groupby) 位置 E:\Work\lp_-shop_-hd\lp.shop.dal\sqlcore_dal.cs:行号 70 在 lp.shop.bll.sqlcore_bll.Allpage(String tblName, String fldname, Int32 pagesize, Int32 pageindex, String orderby, String where, Int32& totalcount, Int32& pagecount, String groupby) 位置 E:\Work\lp_-shop_-hd\lp.shop.bll\sqlcore_bll.cs:行号 47 在 lp.shop.bll.lp_shop_programme_bll.get_shop_programme_list(String id, String programmeno, String programmename, String roomid, String styleid, Int32 is_up, Int32 programmenotype, String stored_id, Int32 pageindex, Int32 pagesize, Int32 ispage) 位置 E:\Work\lp_-shop_-hd\lp.shop.bll\lp_shop_programme_bll.cs:行号 77 在 lp.shop.api.Controllers.web.WebShopProgrammeController.GetShopProgrammeListPage(ShopProgrammeListPageInPut input) 位置 E:\Work\lp_-shop_-hd\lp.shop.api\Controllers\web\WebShopProgrammeController.cs:行号 42 2022-10-04 00:13:33 [12] ERROR lp.shop.core.LogBase 【GetShopProgrammeListPage】======MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'lp_basic.c' doesn't exist 在 lp.shop.db.SQLHelper.ExecuteScalar(CommandType cmdType, String cmdStr, MySqlParameter[] cmdParams) 位置 E:\Work\lp_-shop_-hd\lp.shop.db\SQLHelper.cs:行号 234 在 lp.shop.db.SQLHelper.ExecuteScalar(CommandType cmdType, String cmdStr) 位置 E:\Work\lp_-shop_-hd\lp.shop.db\SQLHelper.cs:行号 246 在 lp.shop.dal.sqlcore_dal.Allpage(String tblName, String fldname, Int32 pagesize, Int32 pageindex, String orderby, String where, Int32& totalcount, Int32& pagecount, String groupby) 位置 E:\Work\lp_-shop_-hd\lp.shop.dal\sqlcore_dal.cs:行号 70 在 lp.shop.bll.sqlcore_bll.Allpage(String tblName, String fldname, Int32 pagesize, Int32 pageindex, String orderby, String where, Int32& totalcount, Int32& pagecount, String groupby) 位置 E:\Work\lp_-shop_-hd\lp.shop.bll\sqlcore_bll.cs:行号 47 在 lp.shop.bll.lp_shop_programme_bll.get_shop_programme_list(String id, String programmeno, String programmename, String roomid, String styleid, Int32 is_up, Int32 programmenotype, String stored_id, Int32 pageindex, Int32 pagesize, Int32 ispage) 位置 E:\Work\lp_-shop_-hd\lp.shop.bll\lp_shop_programme_bll.cs:行号 77 在 lp.shop.api.Controllers.web.WebShopProgrammeController.GetShopProgrammeListPage(ShopProgrammeListPageInPut input) 位置 E:\Work\lp_-shop_-hd\lp.shop.api\Controllers\web\WebShopProgrammeController.cs:行号 42 2022-10-04 00:13:54 [25] ERROR lp.shop.core.LogBase 【GetShopProgrammeListPage】======MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'lp_basic.c' doesn't exist 在 lp.shop.db.SQLHelper.ExecuteScalar(CommandType cmdType, String cmdStr, MySqlParameter[] cmdParams) 位置 E:\Work\lp_-shop_-hd\lp.shop.db\SQLHelper.cs:行号 234 在 lp.shop.db.SQLHelper.ExecuteScalar(CommandType cmdType, String cmdStr) 位置 E:\Work\lp_-shop_-hd\lp.shop.db\SQLHelper.cs:行号 246 在 lp.shop.dal.sqlcore_dal.Allpage(String tblName, String fldname, Int32 pagesize, Int32 pageindex, String orderby, String where, Int32& totalcount, Int32& pagecount, String groupby) 位置 E:\Work\lp_-shop_-hd\lp.shop.dal\sqlcore_dal.cs:行号 70 在 lp.shop.bll.sqlcore_bll.Allpage(String tblName, String fldname, Int32 pagesize, Int32 pageindex, String orderby, String where, Int32& totalcount, Int32& pagecount, String groupby) 位置 E:\Work\lp_-shop_-hd\lp.shop.bll\sqlcore_bll.cs:行号 47 在 lp.shop.bll.lp_shop_programme_bll.get_shop_programme_list(String id, String programmeno, String programmename, String roomid, String styleid, Int32 is_up, Int32 programmenotype, String stored_id, Int32 pageindex, Int32 pagesize, Int32 ispage) 位置 E:\Work\lp_-shop_-hd\lp.shop.bll\lp_shop_programme_bll.cs:行号 77 在 lp.shop.api.Controllers.web.WebShopProgrammeController.GetShopProgrammeListPage(ShopProgrammeListPageInPut input) 位置 E:\Work\lp_-shop_-hd\lp.shop.api\Controllers\web\WebShopProgrammeController.cs:行号 42 2022-10-04 00:17:39 [11] ERROR lp.shop.core.LogBase 【GetShopProgrammeListPage】======MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'lp_basic.c' doesn't exist 在 lp.shop.db.SQLHelper.ExecuteScalar(CommandType cmdType, String cmdStr, MySqlParameter[] cmdParams) 位置 E:\Work\lp_-shop_-hd\lp.shop.db\SQLHelper.cs:行号 234 在 lp.shop.db.SQLHelper.ExecuteScalar(CommandType cmdType, String cmdStr) 位置 E:\Work\lp_-shop_-hd\lp.shop.db\SQLHelper.cs:行号 246 在 lp.shop.dal.sqlcore_dal.Allpage(String tblName, String fldname, Int32 pagesize, Int32 pageindex, String orderby, String where, Int32& totalcount, Int32& pagecount, String groupby) 位置 E:\Work\lp_-shop_-hd\lp.shop.dal\sqlcore_dal.cs:行号 70 在 lp.shop.bll.sqlcore_bll.Allpage(String tblName, String fldname, Int32 pagesize, Int32 pageindex, String orderby, String where, Int32& totalcount, Int32& pagecount, String groupby) 位置 E:\Work\lp_-shop_-hd\lp.shop.bll\sqlcore_bll.cs:行号 47 在 lp.shop.bll.lp_shop_programme_bll.get_shop_programme_list(String id, String programmeno, String programmename, String roomid, String styleid, Int32 is_up, Int32 programmenotype, String stored_id, Int32 pageindex, Int32 pagesize, Int32 ispage) 位置 E:\Work\lp_-shop_-hd\lp.shop.bll\lp_shop_programme_bll.cs:行号 77 在 lp.shop.api.Controllers.web.WebShopProgrammeController.GetShopProgrammeListPage(ShopProgrammeListPageInPut input) 位置 E:\Work\lp_-shop_-hd\lp.shop.api\Controllers\web\WebShopProgrammeController.cs:行号 42 2022-10-04 00:17:44 [13] ERROR lp.shop.core.LogBase 【GetShopProgrammeListPage】======MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'lp_basic.c' doesn't exist 在 lp.shop.db.SQLHelper.ExecuteScalar(CommandType cmdType, String cmdStr, MySqlParameter[] cmdParams) 位置 E:\Work\lp_-shop_-hd\lp.shop.db\SQLHelper.cs:行号 234 在 lp.shop.db.SQLHelper.ExecuteScalar(CommandType cmdType, String cmdStr) 位置 E:\Work\lp_-shop_-hd\lp.shop.db\SQLHelper.cs:行号 246 在 lp.shop.dal.sqlcore_dal.Allpage(String tblName, String fldname, Int32 pagesize, Int32 pageindex, String orderby, String where, Int32& totalcount, Int32& pagecount, String groupby) 位置 E:\Work\lp_-shop_-hd\lp.shop.dal\sqlcore_dal.cs:行号 70 在 lp.shop.bll.sqlcore_bll.Allpage(String tblName, String fldname, Int32 pagesize, Int32 pageindex, String orderby, String where, Int32& totalcount, Int32& pagecount, String groupby) 位置 E:\Work\lp_-shop_-hd\lp.shop.bll\sqlcore_bll.cs:行号 47 在 lp.shop.bll.lp_shop_programme_bll.get_shop_programme_list(String id, String programmeno, String programmename, String roomid, String styleid, Int32 is_up, Int32 programmenotype, String stored_id, Int32 pageindex, Int32 pagesize, Int32 ispage) 位置 E:\Work\lp_-shop_-hd\lp.shop.bll\lp_shop_programme_bll.cs:行号 77 在 lp.shop.api.Controllers.web.WebShopProgrammeController.GetShopProgrammeListPage(ShopProgrammeListPageInPut input) 位置 E:\Work\lp_-shop_-hd\lp.shop.api\Controllers\web\WebShopProgrammeController.cs:行号 42 2022-10-04 00:26:45 [47] INFO lp.shop.core.LogBase 【SQL】======set @rowindex = 0; select sql_calc_found_rows @rowindex:=@rowindex+1 as rownumber, a.id,a.programmeno,a.programmename,a.image,a.number,a.roomid,kj.dict_name as room, a.styleid,fg.dic_name as style,a.remark,a.createuid,a.createdate,a.updateuid,a.updatedate,a.is_up,a.programmenotype,c.name as createcompany,s.id as storedid,s.name as createstored from shop_programme a LEFT JOIN system_dictionary kj on kj.dict_id=a.roomid LEFT JOIN system_dictionary_data fg on fg.id=a.styleid left join system_user u on u.id=a.createuid left join system_company c on u.companyid=c.id left join system_stored s on u.depid=s.id where 1=1 and u.depid ='' order by a.createdate desc limit 0,50 2022-10-04 00:27:19 [18] INFO lp.shop.core.LogBase 【SQL】======set @rowindex = 0; select sql_calc_found_rows @rowindex:=@rowindex+1 as rownumber, a.id,a.senderid,u.name as sendername,a.recipientid,u2.name as recipientname,a.message,a.createdate,a.isread,a.readdate from notify_mailbox a left join system_user u on a.senderid=u.id left join system_user u2 on a.recipientid=u2.id where 1=1 and a.recipientid ='10001' and a.isread=0 order by a.createdate desc limit 0,9999 2022-10-04 00:29:45 [23] INFO lp.shop.core.LogBase 【SQL】======set @rowindex = 0; select sql_calc_found_rows @rowindex:=@rowindex+1 as rownumber, a.id,a.senderid,u.name as sendername,a.recipientid,u2.name as recipientname,a.message,a.createdate,a.isread,a.readdate from notify_mailbox a left join system_user u on a.senderid=u.id left join system_user u2 on a.recipientid=u2.id where 1=1 and a.recipientid ='10001' and a.isread=0 order by a.createdate desc limit 0,9999 2022-10-04 00:29:49 [42] INFO lp.shop.core.LogBase 【SQL】======set @rowindex = 0; select sql_calc_found_rows @rowindex:=@rowindex+1 as rownumber, a.id,a.programmeno,a.programmename,a.image,a.number,a.roomid,kj.dict_name as room, a.styleid,fg.dic_name as style,a.remark,a.createuid,a.createdate,a.updateuid,a.updatedate,a.is_up,a.programmenotype,c.name as createcompany,s.id as storedid,s.name as createstored from shop_programme a LEFT JOIN system_dictionary kj on kj.dict_id=a.roomid LEFT JOIN system_dictionary_data fg on fg.id=a.styleid left join system_user u on u.id=a.createuid left join system_company c on u.companyid=c.id left join system_stored s on u.depid=s.id where 1=1 order by a.createdate desc limit 0,50 2022-10-04 00:30:14 [14] INFO lp.shop.core.LogBase 【SQL】======set @rowindex = 0; select sql_calc_found_rows @rowindex:=@rowindex+1 as rownumber, a.id,a.spuid,a.proid,a.companyid,c.name as companyname,a.stored_id,o.name as storedname,a.price_coefficient,o.price_coefficient_forstored,a.issale,a.waterimage, a.waterskuimage,a.createuid,a.createdate,f.shop_spu_id,f.spusn,f.shop_spu_name,f.caption,f.model, f.iserp,f.typeid,f.typename,f.categoryid,f.roomid,f.roomname,f.styleid,f.stylename,f.brandid,f.brandname, f.unit,f.introduce,f.spuimage,f.images,f.video,f.vrlink,f.vrlink2,f.spec_items,f.para_items,f.shop_spu_status,f.remark,f.is_delete,f.lowest_price*o.price_coefficient_forstored as lowest_price,f.detailimage,f.label,f.copywriting from shop_product_authorize a LEFT JOIN ( SELECT d.id AS shop_spu_id, d.spusn, d.NAME AS shop_spu_name, d.caption, d.model, d.iserp, d.typeid, lx.dict_name AS typename, d.categoryid, d.roomid, fj.dict_name AS roomname, d.styleid, fg.dic_name AS stylename, d.brandid, pp.dic_name AS brandname, d.unit, d.introduce, d.spuimage, d.images, d.video, d.vrlink, d.vrlink2, d.spec_items, d.para_items, d.STATUS AS shop_spu_status, d.remark, d.is_delete, d.lowest_price, d.detailimage, d.label, d.copywriting FROM shop_spu d LEFT JOIN system_dictionary lx ON lx.dict_id = d.typeid LEFT JOIN system_dictionary fj ON fj.dict_id = d.roomid LEFT JOIN system_dictionary_data fg ON d.styleid = fg.id LEFT JOIN system_dictionary_data pp ON d.brandid = pp.id LEFT JOIN shop_collection sc ON d.id = sc.spuid GROUP BY d.id ) AS f ON f.shop_spu_id = a.spuid LEFT JOIN system_company c ON c.id = a.companyid LEFT JOIN system_stored o ON o.id = a.stored_id where 1=1 and f.is_delete=0 and a.companyid ='85f3a074-0ac7-4f3d-a532-8a39f315b224' and a.stored_id ='202109111439453356' and (f.shop_spu_name like'%S0331%' or f.model like'%S0331%') group by a.spuid order by createdate desc limit 0,12 2022-10-04 00:30:17 [55] INFO lp.shop.core.LogBase 【SQL】======set @rowindex = 0; select sql_calc_found_rows @rowindex:=@rowindex+1 as rownumber, a.id,a.spuid,a.proid,a.companyid,c.name as companyname,a.stored_id,o.name as storedname,a.price_coefficient,o.price_coefficient_forstored,a.issale,a.waterimage, a.waterskuimage,a.createuid,a.createdate,f.shop_spu_id,f.spusn,f.shop_spu_name,f.caption,f.model, f.iserp,f.typeid,f.typename,f.categoryid,f.roomid,f.roomname,f.styleid,f.stylename,f.brandid,f.brandname, f.unit,f.introduce,f.spuimage,f.images,f.video,f.vrlink,f.vrlink2,f.spec_items,f.para_items,f.shop_spu_status,f.remark,f.is_delete,f.lowest_price*o.price_coefficient_forstored as lowest_price,f.detailimage,f.label,f.copywriting from shop_product_authorize a LEFT JOIN ( SELECT d.id AS shop_spu_id, d.spusn, d.NAME AS shop_spu_name, d.caption, d.model, d.iserp, d.typeid, lx.dict_name AS typename, d.categoryid, d.roomid, fj.dict_name AS roomname, d.styleid, fg.dic_name AS stylename, d.brandid, pp.dic_name AS brandname, d.unit, d.introduce, d.spuimage, d.images, d.video, d.vrlink, d.vrlink2, d.spec_items, d.para_items, d.STATUS AS shop_spu_status, d.remark, d.is_delete, d.lowest_price, d.detailimage, d.label, d.copywriting FROM shop_spu d LEFT JOIN system_dictionary lx ON lx.dict_id = d.typeid LEFT JOIN system_dictionary fj ON fj.dict_id = d.roomid LEFT JOIN system_dictionary_data fg ON d.styleid = fg.id LEFT JOIN system_dictionary_data pp ON d.brandid = pp.id LEFT JOIN shop_collection sc ON d.id = sc.spuid GROUP BY d.id ) AS f ON f.shop_spu_id = a.spuid LEFT JOIN system_company c ON c.id = a.companyid LEFT JOIN system_stored o ON o.id = a.stored_id where 1=1 and f.is_delete=0 and a.companyid ='85f3a074-0ac7-4f3d-a532-8a39f315b224' and a.stored_id ='202109111439453356' and a.spuid ='27b43c0d-da85-4606-be6f-7248a4e37e20' group by a.spuid order by createdate desc limit 0,10 2022-10-04 00:30:18 [42] INFO lp.shop.core.LogBase 【SQL】======set @rowindex = 0; select sql_calc_found_rows @rowindex:=@rowindex+1 as rownumber, s.id,s.memberuserid,s.spuid,s.iscollection,s.createdate,x.spusn,x.shop_spu_name as proname,x.lowest_price as sales_price,x.price_coefficient,x.waterimage,x.issale,x.companyid,x.stored_id from shop_collection s left join (select a.id,a.spuid,a.proid,a.companyid,a.stored_id,a.price_coefficient,a.issale, a.waterskuimage,a.createuid,a.createdate,f.shop_spu_id,f.spusn,f.shop_spu_name,f.caption,f.model, f.iserp,f.typeid,f.categoryid,f.roomid,f.styleid,f.brandid, f.unit,f.introduce,f.spuimage as waterimage,f.images,f.video,f.vrlink,f.vrlink2,f.spec_items,f.para_items,f.shop_spu_status,f.remark,f.is_delete,f.lowest_price from shop_product_authorize a LEFT JOIN ( SELECT d.id AS shop_spu_id, d.spusn, d.NAME AS shop_spu_name, d.caption, d.model, d.iserp, d.typeid, d.categoryid, d.roomid, d.styleid, d.brandid, d.unit, d.introduce, d.spuimage, d.images, d.video, d.vrlink, d.vrlink2, d.spec_items, d.para_items, d.STATUS AS shop_spu_status, d.remark, d.is_delete, d.lowest_price FROM shop_spu d where 1=1 and d.id='27b43c0d-da85-4606-be6f-7248a4e37e20' GROUP BY d.id ) AS f ON f.shop_spu_id = a.spuid where 1=1 and a.companyid='85f3a074-0ac7-4f3d-a532-8a39f315b224' and a.stored_id='202109111439453356' ) x ON s.spuid=x.spuid where 1=1 and x.companyid='85f3a074-0ac7-4f3d-a532-8a39f315b224' and x.stored_id='202109111439453356' and s.memberuserid='3f189809-1475-4979-9908-706b4d4897dd' and s.spuid='27b43c0d-da85-4606-be6f-7248a4e37e20' and s.spuid='27b43c0d-da85-4606-be6f-7248a4e37e20' group by s.id order by s.createdate DESC limit 0,1 2022-10-04 00:30:18 [55] INFO lp.shop.core.LogBase 【SQL】======set @rowindex = 0; select sql_calc_found_rows @rowindex:=@rowindex+1 as rownumber, a.id,a.spuid,a.proid,a.companyid,c.name as companyname,a.stored_id,o.name as storedname,a.price_coefficient,o.price_coefficient_forstored,a.issale,a.waterimage, a.waterskuimage,a.createuid,a.createdate,f.shop_sku_id,f.shop_sku_spuid,f.sku_specs,f.skusn,f.shop_sku_name,f.erp_sku_id, f.price*o.price_coefficient_forstored as price,f.cost,f.stock,f.orderednum,f.skuimage,f.enable,f.shop_spu_id,f.spusn,f.shop_spu_name,f.caption,f.model, f.iserp,f.typeid,f.typename,f.categoryid,f.roomid,f.roomname,f.styleid,f.stylename,f.brandid,f.brandname, f.unit,f.introduce,f.spuimage,f.images,f.video,f.vrlink,f.vrlink2,f.spec_items,f.para_items,f.shop_spu_status,f.remark,f.is_delete,f.lowest_price,f.detailimage, f.item_ys_id,f.ITEM_CODE,f.ITEM_NAME,f.ITEM_MODEL,f.ITEM_TYPE,f.ITEM_GUIGE,f.ITEM_UNIT,f.YS_CODE,f.YS_NAME,f.item_ys_status,f.SALES_PRICE,f.MAX_STOCK_QTY, f.MIN_STOCK_QTY,f.STOCK_QTY,f.SSO_QTY,f.SSI_WS_QTY,f.PMJ_QTY,f.PPO_QTY,f.COST_PRICE,f.STOCK_PRICE,f.TRADE_PRICE,f.VIP_PRICE,f.AVG_COST_PRICE,f.MIN_SALES_PRICE, f.SALES_QD,f.ZML_CODE,f.ZML,f.ZML_YL,f.FML_CODE,f.FML,f.FML_YL,f.WJ_CODE,f.WJ,f.TM_CODE,f.TM,f.GT_CODE,f.GT,f.IS_ZT_WJ,f.BZ,f.FILE_CODE,f.DOWN_TIME,f.ISUPDATE,f.ZMLFILECODE,f.FMLFILECODE,f.WJFILECODE,f.TMFILECODE,f.GTFILECODE,f.ZML_TRADE_PRICE,f.FML_TRADE_PRICE,f.WJ_TRADE_PRICE,f.TM_TRADE_PRICE,f.GT_TRADE_PRICE,f.LENGTH,f.WIDTH,f.HEIGHT,f.RECORD,f.DZ_ZML,f.DZ_FML,f.DZ_WJ,f.DZ_TM,f.ITEM_PF,f.ITEM_PF_F from shop_product_authorize a LEFT JOIN (select b.id as shop_sku_id,b.spuid as shop_sku_spuid,b.sku_specs,b.skusn,b.name as shop_sku_name,b.erp_sku_id,b.price,b.cost,b.stock,b.orderednum, b.skuimage,b.enable,d.id as shop_spu_id,d.spusn,d.name as shop_spu_name,d.caption,d.model,d.iserp,d.typeid,lx.dict_name as typename,d.categoryid, d.roomid,fj.dict_name as roomname,d.styleid,fg.dic_name as stylename,d.brandid,pp.dic_name as brandname,d.unit,d.introduce, d.spuimage,d.images,d.video,d.vrlink,d.vrlink2,d.spec_items,d.para_items,d.status as shop_spu_status,d.remark,d.is_delete,d.lowest_price,d.detailimage, e.ID as item_ys_id,e.ITEM_CODE,e.ITEM_NAME,e.ITEM_MODEL,e.ITEM_TYPE,e.ITEM_GUIGE,e.ITEM_UNIT,e.YS_CODE,e.YS_NAME,e.STATUS as item_ys_status, e.SALES_PRICE,e.MAX_STOCK_QTY,e.MIN_STOCK_QTY,e.STOCK_QTY,e.SSO_QTY,e.SSI_WS_QTY,e.PMJ_QTY,e.PPO_QTY,e.COST_PRICE,e.STOCK_PRICE,e.TRADE_PRICE, e.VIP_PRICE,e.AVG_COST_PRICE,e.MIN_SALES_PRICE,e.SALES_QD,e.ZML_CODE,e.ZML,zml.FILE_CODE as ZMLFILECODE,zml.TRADE_PRICE as ZML_TRADE_PRICE,e.ZML_YL, e.FML_CODE,fml.FILE_CODE as FMLFILECODE,fml.TRADE_PRICE as FML_TRADE_PRICE,e.FML,e.FML_YL,e.WJ_CODE,wj.FILE_CODE as WJFILECODE,wj.TRADE_PRICE as WJ_TRADE_PRICE,e.WJ, e.TM_CODE,tm.FILE_CODE as TMFILECODE,tm.TRADE_PRICE as TM_TRADE_PRICE,e.TM,e.GT_CODE,gt.FILE_CODE as GTFILECODE,gt.TRADE_PRICE as GT_TRADE_PRICE,e.GT, e.IS_ZT_WJ,e.BZ,e.FILE_CODE,e.DOWN_TIME,e.ISUPDATE,e.LENGTH,e.WIDTH,e.HEIGHT,e.RECORD,e.DZ_ZML,e.DZ_FML,e.DZ_WJ,e.DZ_TM,e.ITEM_PF,e.ITEM_PF_F from shop_sku b LEFT JOIN shop_spu d on d.id=b.spuid LEFT JOIN t_bd_item_ys e on e.ID=b.erp_sku_id LEFT JOIN system_dictionary lx ON lx.dict_id=d.typeid LEFT JOIN system_dictionary fj ON fj.dict_id = d.roomid LEFT JOIN system_dictionary_data fg ON d.styleid = fg.id LEFT JOIN system_dictionary_data pp ON d.brandid = pp.id LEFT JOIN (select PB_CODE as BB_CODE,CATEGORY_CODE,PB_NAME AS BB_NAME,COST_PRICE,TRADE_PRICE,SALES_PRICE,UNIT_CODE,SUPPLIER_CODE,COMPANY_NAME,IS_STOP_USE,BZ,FILE_CODE,FILE_NAME,DIR_PATH,FILE_TYPE,FILE_SIZE from t_bd_item_pb UNION ALL SELECT BB_CODE,CATEGORY_CODE,BB_NAME,COST_PRICE,TRADE_PRICE,SALES_PRICE,UNIT_CODE,SUPPLIER_CODE,COMPANY_NAME,IS_STOP_USE,BZ,FILE_CODE,FILE_NAME,DIR_PATH,FILE_TYPE,FILE_SIZE from t_bd_item_bb) as zml ON zml.BB_CODE = e.ZML_CODE LEFT JOIN (select PB_CODE as BB_CODE,CATEGORY_CODE,PB_NAME AS BB_NAME,COST_PRICE,TRADE_PRICE,SALES_PRICE,UNIT_CODE,SUPPLIER_CODE,COMPANY_NAME,IS_STOP_USE,BZ,FILE_CODE,FILE_NAME,DIR_PATH,FILE_TYPE,FILE_SIZE from t_bd_item_pb UNION ALL SELECT BB_CODE,CATEGORY_CODE,BB_NAME,COST_PRICE,TRADE_PRICE,SALES_PRICE,UNIT_CODE,SUPPLIER_CODE,COMPANY_NAME,IS_STOP_USE,BZ,FILE_CODE,FILE_NAME,DIR_PATH,FILE_TYPE,FILE_SIZE from t_bd_item_bb) as fml ON fml.BB_CODE = e.FML_CODE LEFT JOIN t_bd_item_wj wj ON wj.WJ_CODE = e.WJ_CODE LEFT JOIN t_bd_item_tm tm ON tm.TM_CODE = e.TM_CODE LEFT JOIN t_bd_item_gt gt ON gt.GT_CODE = e.GT_CODE GROUP BY b.id ) as f ON f.shop_sku_id=a.proid LEFT JOIN system_company c on c.id=a.companyid LEFT JOIN system_stored o on o.id=a.stored_id where 1=1 and f.is_delete=0 and a.companyid ='85f3a074-0ac7-4f3d-a532-8a39f315b224' and a.stored_id ='202109111439453356' and f.model like'%S0331%' order by createdate desc limit 0,999 2022-10-04 00:30:19 [16] INFO lp.shop.core.LogBase 【SQL】======set @rowindex = 0; select sql_calc_found_rows @rowindex:=@rowindex+1 as rownumber, a.id,a.spuid,b.model,b.spuimage,a.title,a.link,a.image,a.enable,a.createuid,a.createdate,a.updateuid,a.updatedate,a.remark,u.name as createname from shop_spu_design a left join system_user u on u.id=a.createuid left join shop_spu b on a.spuid=b.id where 1=1 and a.spuid ='27b43c0d-da85-4606-be6f-7248a4e37e20' and a.enable ='1' order by a.createdate desc limit 0,10 2022-10-04 00:30:19 [14] INFO lp.shop.core.LogBase 【SQL】======set @rowindex = 0; select sql_calc_found_rows @rowindex:=@rowindex+1 as rownumber, a.id,a.spuid,b.model,b.spuimage,a.title,a.image,a.videolink,a.enable,a.createuid,a.createdate,a.updateuid,a.updatedate,a.remark,u.name as createname from shop_spu_video a left join system_user u on u.id=a.createuid left join shop_spu b on a.spuid=b.id where 1=1 and a.spuid ='27b43c0d-da85-4606-be6f-7248a4e37e20' and a.enable ='1' order by a.createdate desc limit 0,10 2022-10-04 00:30:19 [16] INFO lp.shop.core.LogBase 【SQL】======set @rowindex = 0; select sql_calc_found_rows @rowindex:=@rowindex+1 as rownumber, a.id,a.spuid,a.content,a.image,a.video,a.status,a.createuid,a.isanonymous,m.phone,a.createdate,b.model,b.name as spuname,b.spuimage,u.depid as storedid,md.name as createstored from shop_evaluate a left join shop_spu b on a.spuid=b.id left join (SELECT id,phone FROM member_user UNION SELECT id,phone FROM system_user) m on m.id=a.createuid left join system_user u on u.id=a.createuid left join system_stored md on md.id=u.depid where 1=1 and a.spuid='27b43c0d-da85-4606-be6f-7248a4e37e20' and a.status='1' order by a.createdate desc limit 0,10 2022-10-04 00:30:19 [14] INFO lp.shop.core.LogBase 【SQL】======set @rowindex = 0; select sql_calc_found_rows @rowindex:=@rowindex+1 as rownumber, id,model,image from shop_spu_zjpic where 1=1 and model like'%S0331%' order by model ASC limit 0,8 2022-10-04 00:30:20 [55] INFO lp.shop.core.LogBase 【SQL】======set @rowindex = 0; select sql_calc_found_rows @rowindex:=@rowindex+1 as rownumber, a.id,a.spuid,a.proid,a.companyid,c.name as companyname,a.stored_id,o.name as storedname,a.price_coefficient,o.price_coefficient_forstored,a.issale,a.waterimage, a.waterskuimage,a.createuid,a.createdate,f.shop_spu_id,f.spusn,f.shop_spu_name,f.caption,f.model, f.iserp,f.typeid,f.typename,f.categoryid,f.roomid,f.roomname,f.styleid,f.stylename,f.brandid,f.brandname, f.unit,f.introduce,f.spuimage,f.images,f.video,f.vrlink,f.vrlink2,f.spec_items,f.para_items,f.shop_spu_status,f.remark,f.is_delete,f.lowest_price*o.price_coefficient_forstored as lowest_price,f.detailimage,f.label,f.copywriting from shop_product_authorize a LEFT JOIN ( SELECT d.id AS shop_spu_id, d.spusn, d.NAME AS shop_spu_name, d.caption, d.model, d.iserp, d.typeid, lx.dict_name AS typename, d.categoryid, d.roomid, fj.dict_name AS roomname, d.styleid, fg.dic_name AS stylename, d.brandid, pp.dic_name AS brandname, d.unit, d.introduce, d.spuimage, d.images, d.video, d.vrlink, d.vrlink2, d.spec_items, d.para_items, d.STATUS AS shop_spu_status, d.remark, d.is_delete, d.lowest_price, d.detailimage, d.label, d.copywriting FROM shop_spu d LEFT JOIN system_dictionary lx ON lx.dict_id = d.typeid LEFT JOIN system_dictionary fj ON fj.dict_id = d.roomid LEFT JOIN system_dictionary_data fg ON d.styleid = fg.id LEFT JOIN system_dictionary_data pp ON d.brandid = pp.id LEFT JOIN shop_collection sc ON d.id = sc.spuid GROUP BY d.id ) AS f ON f.shop_spu_id = a.spuid LEFT JOIN system_company c ON c.id = a.companyid LEFT JOIN system_stored o ON o.id = a.stored_id where 1=1 and f.is_delete=0 and a.companyid ='85f3a074-0ac7-4f3d-a532-8a39f315b224' and a.stored_id ='202109111439453356' and f.styleid ='62a579e9-ad8e-48bf-8cab-426ac9387c8c' group by a.spuid order by createdate desc limit 0,6 2022-10-04 00:30:25 [16] INFO lp.shop.core.LogBase 【SQL】======set @rowindex = 0; select sql_calc_found_rows @rowindex:=@rowindex+1 as rownumber, a.id,a.programmeno,a.programmename,a.image,a.number,a.roomid,kj.dict_name as room, a.styleid,fg.dic_name as style,a.remark,a.createuid,a.createdate,a.updateuid,a.updatedate,a.is_up,a.programmenotype,c.name as createcompany,s.id as storedid,s.name as createstored from shop_programme a LEFT JOIN system_dictionary kj on kj.dict_id=a.roomid LEFT JOIN system_dictionary_data fg on fg.id=a.styleid left join system_user u on u.id=a.createuid left join system_company c on u.companyid=c.id left join system_stored s on u.depid=s.id where 1=1 and u.depid ='' order by a.createdate desc limit 0,50 2022-10-04 10:05:54 [82] INFO lp.shop.core.MsgAPI 发送手机号码：18575796720,短信模板：1,内容：{"phone":"18575796720","code":"3278"} 2022-10-04 10:05:54 [82] INFO lp.shop.core.MsgAPI 18575796720短信执行返回：{"RequestId":"82E8CDCC-9B36-564E-BFA1-F01E87BD2722","BizId":null,"Code":"isv.SMS_SIGNATURE_ILLEGAL","Message":"该账号下找不到对应签名","HttpResponse":{"Status":200,"Headers":{"Connection":"keep-alive","Access-Control-Allow-Origin":"*","x-acs-request-id":"82E8CDCC-9B36-564E-BFA1-F01E87BD2722","x-acs-trace-id":"a24b5a89c39b808b4478b5e23478a4e7","Content-Length":"222","Content-Type":"text/xml;charset=utf-8","Date":"Tue, 04 Oct 2022 02:05:54 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=18575796720&SignName=%E9%AA%8C%E8%AF%81%E7%A0%81%E7%9F%AD%E4%BF%A1&TemplateCode=SMS_254105099&TemplateParam=%7B%22phone%22:%2218575796720%22%2c%22code%22:%223278%22%7D&OutId=202210041005548927&Timestamp=2022-10-04T02:05:54Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=8c7c78f6-27d1-48b7-9e73-27cae1882c05&AccessKeyId=LTAI5tHGNbFjAFgUT7ssbgt3&RegionId=cn-hangzhou&Signature=33aVohwS%2b0HMOIp%2ftWtpg%2bQikqs%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPuivpei0puWPt+S4i+aJvuS4jeWIsOWvueW6lOetvuWQjTwvTWVzc2FnZT48UmVxdWVzdElkPjgyRThDRENDLTlCMzYtNTY0RS1CRkExLUYwMUU4N0JEMjcyMjwvUmVxdWVzdElkPjxDb2RlPmlzdi5TTVNfU0lHTkFUVVJFX0lMTEVHQUw8L0NvZGU+PC9TZW5kU21zUmVzcG9uc2U+","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2022-10-04 10:05:54 [82] ERROR lp.shop.core.MsgAPI {"RequestId":"82E8CDCC-9B36-564E-BFA1-F01E87BD2722","BizId":null,"Code":"isv.SMS_SIGNATURE_ILLEGAL","Message":"该账号下找不到对应签名","HttpResponse":{"Status":200,"Headers":{"Connection":"keep-alive","Access-Control-Allow-Origin":"*","x-acs-request-id":"82E8CDCC-9B36-564E-BFA1-F01E87BD2722","x-acs-trace-id":"a24b5a89c39b808b4478b5e23478a4e7","Content-Length":"222","Content-Type":"text/xml;charset=utf-8","Date":"Tue, 04 Oct 2022 02:05:54 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=18575796720&SignName=%E9%AA%8C%E8%AF%81%E7%A0%81%E7%9F%AD%E4%BF%A1&TemplateCode=SMS_254105099&TemplateParam=%7B%22phone%22:%2218575796720%22%2c%22code%22:%223278%22%7D&OutId=202210041005548927&Timestamp=2022-10-04T02:05:54Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=8c7c78f6-27d1-48b7-9e73-27cae1882c05&AccessKeyId=LTAI5tHGNbFjAFgUT7ssbgt3&RegionId=cn-hangzhou&Signature=33aVohwS%2b0HMOIp%2ftWtpg%2bQikqs%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPuivpei0puWPt+S4i+aJvuS4jeWIsOWvueW6lOetvuWQjTwvTWVzc2FnZT48UmVxdWVzdElkPjgyRThDRENDLTlCMzYtNTY0RS1CRkExLUYwMUU4N0JEMjcyMjwvUmVxdWVzdElkPjxDb2RlPmlzdi5TTVNfU0lHTkFUVVJFX0lMTEVHQUw8L0NvZGU+PC9TZW5kU21zUmVzcG9uc2U+","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2022-10-04 21:48:04 [27] INFO lp.shop.core.MsgAPI 发送手机号码：13366299159,短信模板：1,内容：{"phone":"13366299159","code":"2386"} 2022-10-04 21:48:04 [27] INFO lp.shop.core.MsgAPI 13366299159短信执行返回：{"RequestId":"0E628404-31C0-5890-93A9-FB91C6F667D3","BizId":null,"Code":"isv.SMS_SIGNATURE_ILLEGAL","Message":"该账号下找不到对应签名","HttpResponse":{"Status":200,"Headers":{"Connection":"keep-alive","Access-Control-Allow-Origin":"*","x-acs-request-id":"0E628404-31C0-5890-93A9-FB91C6F667D3","x-acs-trace-id":"867a47070a7ced33f6601a726487588d","Content-Length":"222","Content-Type":"text/xml;charset=utf-8","Date":"Tue, 04 Oct 2022 13:48:04 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=13366299159&SignName=%E9%AA%8C%E8%AF%81%E7%A0%81%E7%9F%AD%E4%BF%A1&TemplateCode=SMS_254105099&TemplateParam=%7B%22phone%22:%2213366299159%22%2c%22code%22:%222386%22%7D&OutId=202210042148043964&Timestamp=2022-10-04T13:48:04Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=08143d59-afd4-4c68-9ee8-b891f5329307&AccessKeyId=LTAI5tHGNbFjAFgUT7ssbgt3&RegionId=cn-hangzhou&Signature=oBMq4TcmXQt%2fn%2fS%2fw3mHEu0ZcAs%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPuivpei0puWPt+S4i+aJvuS4jeWIsOWvueW6lOetvuWQjTwvTWVzc2FnZT48UmVxdWVzdElkPjBFNjI4NDA0LTMxQzAtNTg5MC05M0E5LUZCOTFDNkY2NjdEMzwvUmVxdWVzdElkPjxDb2RlPmlzdi5TTVNfU0lHTkFUVVJFX0lMTEVHQUw8L0NvZGU+PC9TZW5kU21zUmVzcG9uc2U+","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2022-10-04 21:48:04 [27] ERROR lp.shop.core.MsgAPI {"RequestId":"0E628404-31C0-5890-93A9-FB91C6F667D3","BizId":null,"Code":"isv.SMS_SIGNATURE_ILLEGAL","Message":"该账号下找不到对应签名","HttpResponse":{"Status":200,"Headers":{"Connection":"keep-alive","Access-Control-Allow-Origin":"*","x-acs-request-id":"0E628404-31C0-5890-93A9-FB91C6F667D3","x-acs-trace-id":"867a47070a7ced33f6601a726487588d","Content-Length":"222","Content-Type":"text/xml;charset=utf-8","Date":"Tue, 04 Oct 2022 13:48:04 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=13366299159&SignName=%E9%AA%8C%E8%AF%81%E7%A0%81%E7%9F%AD%E4%BF%A1&TemplateCode=SMS_254105099&TemplateParam=%7B%22phone%22:%2213366299159%22%2c%22code%22:%222386%22%7D&OutId=202210042148043964&Timestamp=2022-10-04T13:48:04Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=08143d59-afd4-4c68-9ee8-b891f5329307&AccessKeyId=LTAI5tHGNbFjAFgUT7ssbgt3&RegionId=cn-hangzhou&Signature=oBMq4TcmXQt%2fn%2fS%2fw3mHEu0ZcAs%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPuivpei0puWPt+S4i+aJvuS4jeWIsOWvueW6lOetvuWQjTwvTWVzc2FnZT48UmVxdWVzdElkPjBFNjI4NDA0LTMxQzAtNTg5MC05M0E5LUZCOTFDNkY2NjdEMzwvUmVxdWVzdElkPjxDb2RlPmlzdi5TTVNfU0lHTkFUVVJFX0lMTEVHQUw8L0NvZGU+PC9TZW5kU21zUmVzcG9uc2U+","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2022-10-04 21:48:14 [92] INFO lp.shop.core.MsgAPI 发送手机号码：13366299159,短信模板：1,内容：{"phone":"13366299159","code":"0374"} 2022-10-04 21:48:14 [92] INFO lp.shop.core.MsgAPI 13366299159短信执行返回：{"RequestId":"70847119-15EC-5F91-B743-452AB6B2BA71","BizId":null,"Code":"isv.SMS_SIGNATURE_ILLEGAL","Message":"该账号下找不到对应签名","HttpResponse":{"Status":200,"Headers":{"Connection":"keep-alive","Access-Control-Allow-Origin":"*","x-acs-request-id":"70847119-15EC-5F91-B743-452AB6B2BA71","x-acs-trace-id":"0c1fcc1ee06c2d6e09ec085714787c24","Content-Length":"222","Content-Type":"text/xml;charset=utf-8","Date":"Tue, 04 Oct 2022 13:48:14 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=13366299159&SignName=%E9%AA%8C%E8%AF%81%E7%A0%81%E7%9F%AD%E4%BF%A1&TemplateCode=SMS_254105099&TemplateParam=%7B%22phone%22:%2213366299159%22%2c%22code%22:%220374%22%7D&OutId=202210042148145388&Timestamp=2022-10-04T13:48:14Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=f7bfa997-1463-43b6-8200-4c33385082d3&AccessKeyId=LTAI5tHGNbFjAFgUT7ssbgt3&RegionId=cn-hangzhou&Signature=7PZhCivPko7p%2fKgJfzTEoBcvH9E%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPuivpei0puWPt+S4i+aJvuS4jeWIsOWvueW6lOetvuWQjTwvTWVzc2FnZT48UmVxdWVzdElkPjcwODQ3MTE5LTE1RUMtNUY5MS1CNzQzLTQ1MkFCNkIyQkE3MTwvUmVxdWVzdElkPjxDb2RlPmlzdi5TTVNfU0lHTkFUVVJFX0lMTEVHQUw8L0NvZGU+PC9TZW5kU21zUmVzcG9uc2U+","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2022-10-04 21:48:14 [92] ERROR lp.shop.core.MsgAPI {"RequestId":"70847119-15EC-5F91-B743-452AB6B2BA71","BizId":null,"Code":"isv.SMS_SIGNATURE_ILLEGAL","Message":"该账号下找不到对应签名","HttpResponse":{"Status":200,"Headers":{"Connection":"keep-alive","Access-Control-Allow-Origin":"*","x-acs-request-id":"70847119-15EC-5F91-B743-452AB6B2BA71","x-acs-trace-id":"0c1fcc1ee06c2d6e09ec085714787c24","Content-Length":"222","Content-Type":"text/xml;charset=utf-8","Date":"Tue, 04 Oct 2022 13:48:14 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=13366299159&SignName=%E9%AA%8C%E8%AF%81%E7%A0%81%E7%9F%AD%E4%BF%A1&TemplateCode=SMS_254105099&TemplateParam=%7B%22phone%22:%2213366299159%22%2c%22code%22:%220374%22%7D&OutId=202210042148145388&Timestamp=2022-10-04T13:48:14Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=f7bfa997-1463-43b6-8200-4c33385082d3&AccessKeyId=LTAI5tHGNbFjAFgUT7ssbgt3&RegionId=cn-hangzhou&Signature=7PZhCivPko7p%2fKgJfzTEoBcvH9E%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPuivpei0puWPt+S4i+aJvuS4jeWIsOWvueW6lOetvuWQjTwvTWVzc2FnZT48UmVxdWVzdElkPjcwODQ3MTE5LTE1RUMtNUY5MS1CNzQzLTQ1MkFCNkIyQkE3MTwvUmVxdWVzdElkPjxDb2RlPmlzdi5TTVNfU0lHTkFUVVJFX0lMTEVHQUw8L0NvZGU+PC9TZW5kU21zUmVzcG9uc2U+","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2022-10-04 21:49:07 [90] INFO lp.shop.core.MsgAPI 发送手机号码：13366299159,短信模板：1,内容：{"phone":"13366299159","code":"6082"} 2022-10-04 21:49:07 [90] INFO lp.shop.core.MsgAPI 13366299159短信执行返回：{"RequestId":"72959FCF-8091-59E3-B37B-FCCE6D61D430","BizId":null,"Code":"isv.SMS_SIGNATURE_ILLEGAL","Message":"该账号下找不到对应签名","HttpResponse":{"Status":200,"Headers":{"Connection":"keep-alive","Access-Control-Allow-Origin":"*","x-acs-request-id":"72959FCF-8091-59E3-B37B-FCCE6D61D430","x-acs-trace-id":"38c6ca7883491d7f3345cd1a4d433dc4","Content-Length":"222","Content-Type":"text/xml;charset=utf-8","Date":"Tue, 04 Oct 2022 13:49:07 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=13366299159&SignName=%E9%AA%8C%E8%AF%81%E7%A0%81%E7%9F%AD%E4%BF%A1&TemplateCode=SMS_254105099&TemplateParam=%7B%22phone%22:%2213366299159%22%2c%22code%22:%226082%22%7D&OutId=202210042149074127&Timestamp=2022-10-04T13:49:07Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=a8a52fac-bb65-4083-8ec7-1c404287581e&AccessKeyId=LTAI5tHGNbFjAFgUT7ssbgt3&RegionId=cn-hangzhou&Signature=AxU2FGw0fxPuT7ac178FnbAWDRE%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPuivpei0puWPt+S4i+aJvuS4jeWIsOWvueW6lOetvuWQjTwvTWVzc2FnZT48UmVxdWVzdElkPjcyOTU5RkNGLTgwOTEtNTlFMy1CMzdCLUZDQ0U2RDYxRDQzMDwvUmVxdWVzdElkPjxDb2RlPmlzdi5TTVNfU0lHTkFUVVJFX0lMTEVHQUw8L0NvZGU+PC9TZW5kU21zUmVzcG9uc2U+","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2022-10-04 21:49:07 [90] ERROR lp.shop.core.MsgAPI {"RequestId":"72959FCF-8091-59E3-B37B-FCCE6D61D430","BizId":null,"Code":"isv.SMS_SIGNATURE_ILLEGAL","Message":"该账号下找不到对应签名","HttpResponse":{"Status":200,"Headers":{"Connection":"keep-alive","Access-Control-Allow-Origin":"*","x-acs-request-id":"72959FCF-8091-59E3-B37B-FCCE6D61D430","x-acs-trace-id":"38c6ca7883491d7f3345cd1a4d433dc4","Content-Length":"222","Content-Type":"text/xml;charset=utf-8","Date":"Tue, 04 Oct 2022 13:49:07 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=13366299159&SignName=%E9%AA%8C%E8%AF%81%E7%A0%81%E7%9F%AD%E4%BF%A1&TemplateCode=SMS_254105099&TemplateParam=%7B%22phone%22:%2213366299159%22%2c%22code%22:%226082%22%7D&OutId=202210042149074127&Timestamp=2022-10-04T13:49:07Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=a8a52fac-bb65-4083-8ec7-1c404287581e&AccessKeyId=LTAI5tHGNbFjAFgUT7ssbgt3&RegionId=cn-hangzhou&Signature=AxU2FGw0fxPuT7ac178FnbAWDRE%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPuivpei0puWPt+S4i+aJvuS4jeWIsOWvueW6lOetvuWQjTwvTWVzc2FnZT48UmVxdWVzdElkPjcyOTU5RkNGLTgwOTEtNTlFMy1CMzdCLUZDQ0U2RDYxRDQzMDwvUmVxdWVzdElkPjxDb2RlPmlzdi5TTVNfU0lHTkFUVVJFX0lMTEVHQUw8L0NvZGU+PC9TZW5kU21zUmVzcG9uc2U+","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2022-10-04 21:50:25 [34] INFO lp.shop.core.MsgAPI 发送手机号码：13366299159,短信模板：1,内容：{"phone":"13366299159","code":"5851"} 2022-10-04 21:50:25 [34] INFO lp.shop.core.MsgAPI 13366299159短信执行返回：{"RequestId":"0A2E70BA-3890-514F-A169-BCF44783D7C1","BizId":null,"Code":"isv.SMS_SIGNATURE_ILLEGAL","Message":"该账号下找不到对应签名","HttpResponse":{"Status":200,"Headers":{"Connection":"keep-alive","Access-Control-Allow-Origin":"*","x-acs-request-id":"0A2E70BA-3890-514F-A169-BCF44783D7C1","x-acs-trace-id":"a44461ce654b440c95e2326447018815","Content-Length":"222","Content-Type":"text/xml;charset=utf-8","Date":"Tue, 04 Oct 2022 13:50:25 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=13366299159&SignName=%E9%AA%8C%E8%AF%81%E7%A0%81%E7%9F%AD%E4%BF%A1&TemplateCode=SMS_254105099&TemplateParam=%7B%22phone%22:%2213366299159%22%2c%22code%22:%225851%22%7D&OutId=202210042150253096&Timestamp=2022-10-04T13:50:25Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=33c112ed-ab76-4eb9-8e88-ff649a036a0f&AccessKeyId=LTAI5tHGNbFjAFgUT7ssbgt3&RegionId=cn-hangzhou&Signature=Y00sxodo26BbW9Y5suJsf7v3xdw%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPuivpei0puWPt+S4i+aJvuS4jeWIsOWvueW6lOetvuWQjTwvTWVzc2FnZT48UmVxdWVzdElkPjBBMkU3MEJBLTM4OTAtNTE0Ri1BMTY5LUJDRjQ0NzgzRDdDMTwvUmVxdWVzdElkPjxDb2RlPmlzdi5TTVNfU0lHTkFUVVJFX0lMTEVHQUw8L0NvZGU+PC9TZW5kU21zUmVzcG9uc2U+","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2022-10-04 21:50:25 [34] ERROR lp.shop.core.MsgAPI {"RequestId":"0A2E70BA-3890-514F-A169-BCF44783D7C1","BizId":null,"Code":"isv.SMS_SIGNATURE_ILLEGAL","Message":"该账号下找不到对应签名","HttpResponse":{"Status":200,"Headers":{"Connection":"keep-alive","Access-Control-Allow-Origin":"*","x-acs-request-id":"0A2E70BA-3890-514F-A169-BCF44783D7C1","x-acs-trace-id":"a44461ce654b440c95e2326447018815","Content-Length":"222","Content-Type":"text/xml;charset=utf-8","Date":"Tue, 04 Oct 2022 13:50:25 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=13366299159&SignName=%E9%AA%8C%E8%AF%81%E7%A0%81%E7%9F%AD%E4%BF%A1&TemplateCode=SMS_254105099&TemplateParam=%7B%22phone%22:%2213366299159%22%2c%22code%22:%225851%22%7D&OutId=202210042150253096&Timestamp=2022-10-04T13:50:25Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=33c112ed-ab76-4eb9-8e88-ff649a036a0f&AccessKeyId=LTAI5tHGNbFjAFgUT7ssbgt3&RegionId=cn-hangzhou&Signature=Y00sxodo26BbW9Y5suJsf7v3xdw%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPuivpei0puWPt+S4i+aJvuS4jeWIsOWvueW6lOetvuWQjTwvTWVzc2FnZT48UmVxdWVzdElkPjBBMkU3MEJBLTM4OTAtNTE0Ri1BMTY5LUJDRjQ0NzgzRDdDMTwvUmVxdWVzdElkPjxDb2RlPmlzdi5TTVNfU0lHTkFUVVJFX0lMTEVHQUw8L0NvZGU+PC9TZW5kU21zUmVzcG9uc2U+","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2022-10-04 21:50:48 [34] INFO lp.shop.core.MsgAPI 发送手机号码：18073117588,短信模板：1,内容：{"phone":"18073117588","code":"2158"} 2022-10-04 21:50:48 [34] INFO lp.shop.core.MsgAPI 18073117588短信执行返回：{"RequestId":"7993D6F1-42A4-5041-A858-50D192101257","BizId":null,"Code":"isv.SMS_SIGNATURE_ILLEGAL","Message":"该账号下找不到对应签名","HttpResponse":{"Status":200,"Headers":{"Connection":"keep-alive","Access-Control-Allow-Origin":"*","x-acs-request-id":"7993D6F1-42A4-5041-A858-50D192101257","x-acs-trace-id":"729fb6185e895e34c62f26213184fd32","Content-Length":"222","Content-Type":"text/xml;charset=utf-8","Date":"Tue, 04 Oct 2022 13:50:48 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=18073117588&SignName=%E9%AA%8C%E8%AF%81%E7%A0%81%E7%9F%AD%E4%BF%A1&TemplateCode=SMS_254105099&TemplateParam=%7B%22phone%22:%2218073117588%22%2c%22code%22:%222158%22%7D&OutId=202210042150488743&Timestamp=2022-10-04T13:50:48Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=1f6a00ba-c660-4eb4-8bf9-5be2376783b8&AccessKeyId=LTAI5tHGNbFjAFgUT7ssbgt3&RegionId=cn-hangzhou&Signature=xmo661vfDx8EBOrlhTSf2ua2K%2bQ%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPuivpei0puWPt+S4i+aJvuS4jeWIsOWvueW6lOetvuWQjTwvTWVzc2FnZT48UmVxdWVzdElkPjc5OTNENkYxLTQyQTQtNTA0MS1BODU4LTUwRDE5MjEwMTI1NzwvUmVxdWVzdElkPjxDb2RlPmlzdi5TTVNfU0lHTkFUVVJFX0lMTEVHQUw8L0NvZGU+PC9TZW5kU21zUmVzcG9uc2U+","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2022-10-04 21:50:48 [34] ERROR lp.shop.core.MsgAPI {"RequestId":"7993D6F1-42A4-5041-A858-50D192101257","BizId":null,"Code":"isv.SMS_SIGNATURE_ILLEGAL","Message":"该账号下找不到对应签名","HttpResponse":{"Status":200,"Headers":{"Connection":"keep-alive","Access-Control-Allow-Origin":"*","x-acs-request-id":"7993D6F1-42A4-5041-A858-50D192101257","x-acs-trace-id":"729fb6185e895e34c62f26213184fd32","Content-Length":"222","Content-Type":"text/xml;charset=utf-8","Date":"Tue, 04 Oct 2022 13:50:48 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=18073117588&SignName=%E9%AA%8C%E8%AF%81%E7%A0%81%E7%9F%AD%E4%BF%A1&TemplateCode=SMS_254105099&TemplateParam=%7B%22phone%22:%2218073117588%22%2c%22code%22:%222158%22%7D&OutId=202210042150488743&Timestamp=2022-10-04T13:50:48Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=1f6a00ba-c660-4eb4-8bf9-5be2376783b8&AccessKeyId=LTAI5tHGNbFjAFgUT7ssbgt3&RegionId=cn-hangzhou&Signature=xmo661vfDx8EBOrlhTSf2ua2K%2bQ%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPuivpei0puWPt+S4i+aJvuS4jeWIsOWvueW6lOetvuWQjTwvTWVzc2FnZT48UmVxdWVzdElkPjc5OTNENkYxLTQyQTQtNTA0MS1BODU4LTUwRDE5MjEwMTI1NzwvUmVxdWVzdElkPjxDb2RlPmlzdi5TTVNfU0lHTkFUVVJFX0lMTEVHQUw8L0NvZGU+PC9TZW5kU21zUmVzcG9uc2U+","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2022-10-04 21:51:28 [20] INFO lp.shop.core.MsgAPI 发送手机号码：18073117588,短信模板：1,内容：{"phone":"18073117588","code":"5433"} 2022-10-04 21:51:28 [20] INFO lp.shop.core.MsgAPI 18073117588短信执行返回：{"RequestId":"E3ADEA4D-0589-5968-A48F-833979B51ABA","BizId":null,"Code":"isv.SMS_SIGNATURE_ILLEGAL","Message":"该账号下找不到对应签名","HttpResponse":{"Status":200,"Headers":{"Connection":"keep-alive","Access-Control-Allow-Origin":"*","x-acs-request-id":"E3ADEA4D-0589-5968-A48F-833979B51ABA","x-acs-trace-id":"056f3cba133d96bf180d981bf5bb4536","Content-Length":"222","Content-Type":"text/xml;charset=utf-8","Date":"Tue, 04 Oct 2022 13:51:28 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=18073117588&SignName=%E9%AA%8C%E8%AF%81%E7%A0%81%E7%9F%AD%E4%BF%A1&TemplateCode=SMS_254105099&TemplateParam=%7B%22phone%22:%2218073117588%22%2c%22code%22:%225433%22%7D&OutId=202210042151282123&Timestamp=2022-10-04T13:51:28Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=3f010312-0def-4437-a7e8-faf9abb69742&AccessKeyId=LTAI5tHGNbFjAFgUT7ssbgt3&RegionId=cn-hangzhou&Signature=V5ArXP6EW%2bmIw1p8rKl7UcBpSXk%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPuivpei0puWPt+S4i+aJvuS4jeWIsOWvueW6lOetvuWQjTwvTWVzc2FnZT48UmVxdWVzdElkPkUzQURFQTRELTA1ODktNTk2OC1BNDhGLTgzMzk3OUI1MUFCQTwvUmVxdWVzdElkPjxDb2RlPmlzdi5TTVNfU0lHTkFUVVJFX0lMTEVHQUw8L0NvZGU+PC9TZW5kU21zUmVzcG9uc2U+","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2022-10-04 21:51:28 [20] ERROR lp.shop.core.MsgAPI {"RequestId":"E3ADEA4D-0589-5968-A48F-833979B51ABA","BizId":null,"Code":"isv.SMS_SIGNATURE_ILLEGAL","Message":"该账号下找不到对应签名","HttpResponse":{"Status":200,"Headers":{"Connection":"keep-alive","Access-Control-Allow-Origin":"*","x-acs-request-id":"E3ADEA4D-0589-5968-A48F-833979B51ABA","x-acs-trace-id":"056f3cba133d96bf180d981bf5bb4536","Content-Length":"222","Content-Type":"text/xml;charset=utf-8","Date":"Tue, 04 Oct 2022 13:51:28 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=18073117588&SignName=%E9%AA%8C%E8%AF%81%E7%A0%81%E7%9F%AD%E4%BF%A1&TemplateCode=SMS_254105099&TemplateParam=%7B%22phone%22:%2218073117588%22%2c%22code%22:%225433%22%7D&OutId=202210042151282123&Timestamp=2022-10-04T13:51:28Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=3f010312-0def-4437-a7e8-faf9abb69742&AccessKeyId=LTAI5tHGNbFjAFgUT7ssbgt3&RegionId=cn-hangzhou&Signature=V5ArXP6EW%2bmIw1p8rKl7UcBpSXk%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPuivpei0puWPt+S4i+aJvuS4jeWIsOWvueW6lOetvuWQjTwvTWVzc2FnZT48UmVxdWVzdElkPkUzQURFQTRELTA1ODktNTk2OC1BNDhGLTgzMzk3OUI1MUFCQTwvUmVxdWVzdElkPjxDb2RlPmlzdi5TTVNfU0lHTkFUVVJFX0lMTEVHQUw8L0NvZGU+PC9TZW5kU21zUmVzcG9uc2U+","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2022-10-04 21:53:18 [34] INFO lp.shop.core.MsgAPI 发送手机号码：18073117588,短信模板：1,内容：{"phone":"18073117588","code":"1863"} 2022-10-04 21:53:18 [34] INFO lp.shop.core.MsgAPI 18073117588短信执行返回：{"RequestId":"6331445A-76F9-5464-B547-195A1441A12F","BizId":null,"Code":"isv.SMS_SIGNATURE_ILLEGAL","Message":"该账号下找不到对应签名","HttpResponse":{"Status":200,"Headers":{"Connection":"keep-alive","Access-Control-Allow-Origin":"*","x-acs-request-id":"6331445A-76F9-5464-B547-195A1441A12F","x-acs-trace-id":"89dee25f2ed6abba943492c638bc4b79","Content-Length":"222","Content-Type":"text/xml;charset=utf-8","Date":"Tue, 04 Oct 2022 13:53:18 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=18073117588&SignName=%E9%AA%8C%E8%AF%81%E7%A0%81%E7%9F%AD%E4%BF%A1&TemplateCode=SMS_254105099&TemplateParam=%7B%22phone%22:%2218073117588%22%2c%22code%22:%221863%22%7D&OutId=202210042153188991&Timestamp=2022-10-04T13:53:18Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=a925d54c-a8d0-4484-9ef9-11b2c61a2b6a&AccessKeyId=LTAI5tHGNbFjAFgUT7ssbgt3&RegionId=cn-hangzhou&Signature=64R2zjmDS9KThPawFMrq2gpPCpI%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPuivpei0puWPt+S4i+aJvuS4jeWIsOWvueW6lOetvuWQjTwvTWVzc2FnZT48UmVxdWVzdElkPjYzMzE0NDVBLTc2RjktNTQ2NC1CNTQ3LTE5NUExNDQxQTEyRjwvUmVxdWVzdElkPjxDb2RlPmlzdi5TTVNfU0lHTkFUVVJFX0lMTEVHQUw8L0NvZGU+PC9TZW5kU21zUmVzcG9uc2U+","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2022-10-04 21:53:18 [34] ERROR lp.shop.core.MsgAPI {"RequestId":"6331445A-76F9-5464-B547-195A1441A12F","BizId":null,"Code":"isv.SMS_SIGNATURE_ILLEGAL","Message":"该账号下找不到对应签名","HttpResponse":{"Status":200,"Headers":{"Connection":"keep-alive","Access-Control-Allow-Origin":"*","x-acs-request-id":"6331445A-76F9-5464-B547-195A1441A12F","x-acs-trace-id":"89dee25f2ed6abba943492c638bc4b79","Content-Length":"222","Content-Type":"text/xml;charset=utf-8","Date":"Tue, 04 Oct 2022 13:53:18 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=18073117588&SignName=%E9%AA%8C%E8%AF%81%E7%A0%81%E7%9F%AD%E4%BF%A1&TemplateCode=SMS_254105099&TemplateParam=%7B%22phone%22:%2218073117588%22%2c%22code%22:%221863%22%7D&OutId=202210042153188991&Timestamp=2022-10-04T13:53:18Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=a925d54c-a8d0-4484-9ef9-11b2c61a2b6a&AccessKeyId=LTAI5tHGNbFjAFgUT7ssbgt3&RegionId=cn-hangzhou&Signature=64R2zjmDS9KThPawFMrq2gpPCpI%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPuivpei0puWPt+S4i+aJvuS4jeWIsOWvueW6lOetvuWQjTwvTWVzc2FnZT48UmVxdWVzdElkPjYzMzE0NDVBLTc2RjktNTQ2NC1CNTQ3LTE5NUExNDQxQTEyRjwvUmVxdWVzdElkPjxDb2RlPmlzdi5TTVNfU0lHTkFUVVJFX0lMTEVHQUw8L0NvZGU+PC9TZW5kU21zUmVzcG9uc2U+","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}}