2026-02-15 04:51:21 [17] ERROR lp.shop.core.LogBase [{"FileResourceId":"a055329a-6e1d-4eab-993c-6e8f55f66a6f"}] [{"id":"a055329a-6e1d-4eab-993c-6e8f55f66a6f","FileType":1,"FileFullName":"202306021513417043.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202306/02/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-06-02T15:13:42","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202306/02/202306021513417043.jpg"}] 2026-02-15 04:51:21 [43] ERROR lp.shop.core.LogBase [{"FileResourceId":"a055329a-6e1d-4eab-993c-6e8f55f66a6f"}] [{"id":"a055329a-6e1d-4eab-993c-6e8f55f66a6f","FileType":1,"FileFullName":"202306021513417043.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202306/02/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-06-02T15:13:42","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202306/02/202306021513417043.jpg"}] 2026-02-15 04:51:21 [71] ERROR lp.shop.core.LogBase [{"FileResourceId":"5d9d74f4-ea3d-4d67-b7e4-79bd8cd99313"}] [{"id":"5d9d74f4-ea3d-4d67-b7e4-79bd8cd99313","FileType":1,"FileFullName":"202112281134556816.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-28T11:34:56","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/28/202112281134556816.jpg"}] 2026-02-15 04:51:21 [84] ERROR lp.shop.core.LogBase [{"FileResourceId":"9502da74-8029-4043-b726-f88a4a250be0"}] [{"id":"9502da74-8029-4043-b726-f88a4a250be0","FileType":1,"FileFullName":"202112281220450430.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-28T12:20:45","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/28/202112281220450430.jpg"}] 2026-02-15 04:51:21 [58] ERROR lp.shop.core.LogBase [{"FileResourceId":"6fd89f59-f0f7-4f8f-939e-7281a922fb4c"}] [{"id":"6fd89f59-f0f7-4f8f-939e-7281a922fb4c","FileType":1,"FileFullName":"202112281136038122.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-28T11:36:04","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/28/202112281136038122.jpg"}] 2026-02-15 04:51:21 [17] ERROR lp.shop.core.LogBase [{"FileResourceId":"7c0f7031-0035-4159-a131-b3c1fd4d2a9a"}] [{"id":"7c0f7031-0035-4159-a131-b3c1fd4d2a9a","FileType":1,"FileFullName":"202112281136288903.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-28T11:36:29","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/28/202112281136288903.jpg"}] 2026-02-15 04:51:21 [71] ERROR lp.shop.core.LogBase [{"FileResourceId":"1538710e-677d-415c-a3e2-7f686136b046"}] [{"id":"1538710e-677d-415c-a3e2-7f686136b046","FileType":1,"FileFullName":"202112281137082750.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-28T11:37:08","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/28/202112281137082750.jpg"}] 2026-02-15 04:51:21 [43] ERROR lp.shop.core.LogBase [{"FileResourceId":"67d44eab-2daa-4e6e-bd0b-1164afaa91fd"}] [{"id":"67d44eab-2daa-4e6e-bd0b-1164afaa91fd","FileType":1,"FileFullName":"202112281137012438.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-28T11:37:01","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/28/202112281137012438.jpg"}] 2026-02-15 04:51:21 [60] ERROR lp.shop.core.LogBase [{"FileResourceId":"94c32d8d-6ccc-485e-88fc-ada0761ed347"}] [{"id":"94c32d8d-6ccc-485e-88fc-ada0761ed347","FileType":1,"FileFullName":"202112281138288288.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-28T11:38:29","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/28/202112281138288288.jpg"}] 2026-02-15 04:51:21 [84] ERROR lp.shop.core.LogBase [{"FileResourceId":"66ae563a-3e72-4850-9b31-fba4d657ef5a"}] [{"id":"66ae563a-3e72-4850-9b31-fba4d657ef5a","FileType":1,"FileFullName":"202112281137256344.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-28T11:37:26","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/28/202112281137256344.jpg"}] 2026-02-15 04:51:21 [87] ERROR lp.shop.core.LogBase [{"FileResourceId":"28e60878-7162-4908-8913-d849ecec9c18"}] [{"id":"28e60878-7162-4908-8913-d849ecec9c18","FileType":1,"FileFullName":"202112281138499088.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-28T11:38:50","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/28/202112281138499088.jpg"}] 2026-02-15 04:51:21 [71] ERROR lp.shop.core.LogBase [{"FileResourceId":"efbda49b-97d2-4ad6-a15d-66fbf82c4e61"}] [{"id":"efbda49b-97d2-4ad6-a15d-66fbf82c4e61","FileType":1,"FileFullName":"202112281139063151.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-28T11:39:06","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/28/202112281139063151.jpg"}] 2026-02-15 04:51:21 [60] ERROR lp.shop.core.LogBase [{"FileResourceId":"0be4d4c3-5b5c-4798-9789-de613a21b453"}] [{"id":"0be4d4c3-5b5c-4798-9789-de613a21b453","FileType":1,"FileFullName":"202112281137472663.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-28T11:37:47","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/28/202112281137472663.jpg"}] 2026-02-15 04:51:24 [60] INFO lp.shop.core.LogBase ¡¾SQL¡¿======set @rowindex = 0; select sql_calc_found_rows @rowindex:=@rowindex+1 as rownumber,s.id,s.price*o.price_coefficient_forstored as price,d.price_coefficient,a.id as programmeid,s.spuid,c.YS_NAME,s.skusn,s.sku_specs,s.name,s.skuimage, s.enable,b.model,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,lb.dic_name as programmenolb,a.programmenoimages,a.content,c.*,ps.quantity from shop_sku s LEFT JOIN shop_package_programme_sku ps on ps.skuid=s.id LEFT JOIN shop_programme a on a.programmeno=ps.programmeno 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_dictionary_data lb on lb.id=a.programmenolb LEFT JOIN t_bd_item_ys c on c.ID=s.erp_sku_id LEFT JOIN shop_spu b on b.id=s.spuid LEFT JOIN shop_product_authorize d on d.proid=s.id and d.stored_id='202109111439453356' LEFT JOIN system_stored o on o.id='202109111439453356' where 1=1 and a.is_up=1 and a.programmeno is not null and d.stored_id ='202109111439453356' and a.programmenotype =0 order by a.createdate desc limit 0,9999 2026-02-15 04:51:31 [49] 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 group by a.spuid order by createdate desc limit 0,10