2026-01-28 09:23:12 [41] 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-01-28 09:23:12 [52] ERROR lp.shop.core.LogBase [{"FileResourceId":"1dfbf216-e52a-41f8-b928-3a0337abe211"}] [{"id":"1dfbf216-e52a-41f8-b928-3a0337abe211","FileType":1,"FileFullName":"202109111029008633.png","FileExtension":"png","FileMD5":null,"FileIOPath":"/upload/202109/11/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-09-11T10:29:01","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202109/11/202109111029008633.png"}] 2026-01-28 09:23:12 [57] 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-01-28 09:23:12 [53] 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-01-28 09:23:12 [91] 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-01-28 09:23:12 [41] 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-01-28 09:23:12 [57] 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-01-28 09:23:12 [52] 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-01-28 09:23:12 [53] 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-01-28 09:23:12 [91] 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-01-28 09:23:12 [50] 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-01-28 09:23:12 [63] 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-01-28 09:23:12 [52] ERROR lp.shop.core.LogBase [{"FileResourceId":"36adc816-a925-4b29-b3bd-0c15971159b2"}] [{"id":"36adc816-a925-4b29-b3bd-0c15971159b2","FileType":1,"FileFullName":"202112210844326297.png","FileExtension":"png","FileMD5":null,"FileIOPath":"/upload/202112/21/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-21T08:44:33","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/21/202112210844326297.png"}] 2026-01-28 09:23:12 [53] ERROR lp.shop.core.LogBase [{"FileResourceId":"d60f68e1-5d0e-430e-9414-a2ce787858fb"}] [{"id":"d60f68e1-5d0e-430e-9414-a2ce787858fb","FileType":1,"FileFullName":"202112210844508485.png","FileExtension":"png","FileMD5":null,"FileIOPath":"/upload/202112/21/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-21T08:44:51","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/21/202112210844508485.png"}] 2026-01-28 09:23:12 [50] ERROR lp.shop.core.LogBase [{"FileResourceId":"052bed5a-b60c-427d-8367-d9aef01aa729"}] [{"id":"052bed5a-b60c-427d-8367-d9aef01aa729","FileType":1,"FileFullName":"202112210844593367.png","FileExtension":"png","FileMD5":null,"FileIOPath":"/upload/202112/21/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-21T08:44:59","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/21/202112210844593367.png"}] 2026-01-28 09:23:12 [91] ERROR lp.shop.core.LogBase [{"FileResourceId":"4670d566-7377-48d0-a514-dbc758809bcd"}] [{"id":"4670d566-7377-48d0-a514-dbc758809bcd","FileType":1,"FileFullName":"202112210844420360.png","FileExtension":"png","FileMD5":null,"FileIOPath":"/upload/202112/21/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-21T08:44:42","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/21/202112210844420360.png"}] 2026-01-28 09:23:12 [68] 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 ='20000' and a.stored_id ='202109111029036163' group by a.spuid order by createdate desc limit 0,10 2026-01-28 09:23:12 [57] 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='202109111029036163' LEFT JOIN system_stored o on o.id='202109111029036163' where 1=1 and a.is_up=1 and a.programmeno is not null and d.stored_id ='202109111029036163' and a.programmenotype =0 order by a.createdate desc limit 0,99999 2026-01-28 09:23:13 [53] ERROR lp.shop.core.LogBase [{"FileResourceId":"a122cabd-2e18-4a77-b938-214f69c0a811"}] [{"id":"a122cabd-2e18-4a77-b938-214f69c0a811","FileType":1,"FileFullName":"202506301517292456.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T15:17:29","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301517292456.jpg"}] 2026-01-28 09:23:13 [63] ERROR lp.shop.core.LogBase [{"FileResourceId":"904c10cb-a6d4-4415-b73a-94d6950ce4e6"}] [{"id":"904c10cb-a6d4-4415-b73a-94d6950ce4e6","FileType":1,"FileFullName":"202410291128475660.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:28:48","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291128475660.jpg"}] 2026-01-28 09:23:13 [50] ERROR lp.shop.core.LogBase [{"FileResourceId":"5e3ac0d5-8d6d-4a63-8d8c-093a65c4bde3"}] [{"id":"5e3ac0d5-8d6d-4a63-8d8c-093a65c4bde3","FileType":1,"FileFullName":"202506301714236917.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T17:14:24","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301714236917.jpg"}] 2026-01-28 09:23:13 [41] ERROR lp.shop.core.LogBase [{"FileResourceId":"fef91e55-bdee-43c9-94af-a10ac1ca22c9"}] [{"id":"fef91e55-bdee-43c9-94af-a10ac1ca22c9","FileType":1,"FileFullName":"202410291127218942.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:27:22","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291127218942.jpg"}] 2026-01-28 09:23:13 [91] ERROR lp.shop.core.LogBase [{"FileResourceId":"092c1751-d713-4e84-b47a-f6d86947a115"}] [{"id":"092c1751-d713-4e84-b47a-f6d86947a115","FileType":1,"FileFullName":"202507010933570522.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202507/01/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-07-01T09:33:57","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202507/01/202507010933570522.jpg"}] 2026-01-28 09:23:13 [55] ERROR lp.shop.core.LogBase [{"FileResourceId":"ac3fb6db-efcf-40b9-8658-8f86b9046eaf"}] [{"id":"ac3fb6db-efcf-40b9-8658-8f86b9046eaf","FileType":1,"FileFullName":"202506301712254849.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T17:12:26","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301712254849.jpg"}] 2026-01-28 09:23:13 [68] ERROR lp.shop.core.LogBase [{"FileResourceId":"0c2962ff-97f9-4c9d-94c3-9484e44b7e25"}] [{"id":"0c2962ff-97f9-4c9d-94c3-9484e44b7e25","FileType":1,"FileFullName":"202506301709062165.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T17:09:06","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301709062165.jpg"}] 2026-01-28 09:23:13 [52] ERROR lp.shop.core.LogBase [{"FileResourceId":"ceb49311-b5a0-4461-93cf-5023b09bd63c"}] [{"id":"ceb49311-b5a0-4461-93cf-5023b09bd63c","FileType":1,"FileFullName":"202506301705331067.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T17:05:33","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301705331067.jpg"}] 2026-01-28 09:23:13 [53] ERROR lp.shop.core.LogBase [{"FileResourceId":"03bcf3c5-3579-4604-90ee-718757d2960f"}] [{"id":"03bcf3c5-3579-4604-90ee-718757d2960f","FileType":1,"FileFullName":"202506301702020601.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T17:02:02","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301702020601.jpg"}] 2026-01-28 09:23:13 [63] ERROR lp.shop.core.LogBase [{"FileResourceId":"f1ac6ab9-e0a4-45f6-a41b-b7badfcab882"}] [{"id":"f1ac6ab9-e0a4-45f6-a41b-b7badfcab882","FileType":1,"FileFullName":"202506301658137985.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T16:58:14","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301658137985.jpg"}] 2026-01-28 09:23:14 [41] ERROR lp.shop.core.LogBase [{"FileResourceId":"6ccfaa05-d084-459d-ba07-4fd3a8e13c48"}] [{"id":"6ccfaa05-d084-459d-ba07-4fd3a8e13c48","FileType":1,"FileFullName":"202304131548076157.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202304/13/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-04-13T15:48:08","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202304/13/202304131548076157.jpg"}] 2026-01-28 09:23:14 [91] ERROR lp.shop.core.LogBase [{"FileResourceId":"f77d8dae-8fa6-4790-8679-56de72884de2"}] [{"id":"f77d8dae-8fa6-4790-8679-56de72884de2","FileType":1,"FileFullName":"202304131545196458.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202304/13/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-04-13T15:45:20","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202304/13/202304131545196458.jpg"}] 2026-01-28 09:23:14 [55] ERROR lp.shop.core.LogBase [{"FileResourceId":"bf9510e7-3308-49b6-b682-1fe963c0ea72"}] [{"id":"bf9510e7-3308-49b6-b682-1fe963c0ea72","FileType":1,"FileFullName":"202304131543591047.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202304/13/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-04-13T15:43:59","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202304/13/202304131543591047.jpg"}] 2026-01-28 09:23:14 [68] ERROR lp.shop.core.LogBase [{"FileResourceId":"b9ae91fe-d952-48a4-bfaa-4343bd6926b0"}] [{"id":"b9ae91fe-d952-48a4-bfaa-4343bd6926b0","FileType":1,"FileFullName":"202304131530429011.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202304/13/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-04-13T15:30:43","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202304/13/202304131530429011.jpg"}] 2026-01-28 09:23:14 [52] ERROR lp.shop.core.LogBase [{"FileResourceId":"49c358bd-1977-4e8a-b492-351b5a429142"}] [{"id":"49c358bd-1977-4e8a-b492-351b5a429142","FileType":1,"FileFullName":"202304131546201654.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202304/13/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-04-13T15:46:20","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202304/13/202304131546201654.jpg"}] 2026-01-28 09:23:14 [53] INFO lp.shop.core.LogBase 【SQL】======set @rowindex = 0; select sql_calc_found_rows @rowindex:=@rowindex+1 as rownumber, a.id,a.packageno,a.packagename,a.image,a.price,a.type,a.remark,a.createuid,a.createdate,a.updateuid,a.updatedate,a.is_delete,b.price_coefficient,c.price_coefficient_forstored from shop_package a left join shop_stored_price b on b.storedid='202109111029036163' left join system_stored c on c.id='202109111029036163' where 1=1 and is_delete=0 order by createdate desc limit 0,9999 2026-01-28 09:23:14 [50] ERROR lp.shop.core.LogBase [{"FileResourceId":"c7d242e5-2c95-47ac-828d-4c788dc7e6eb"}] [{"id":"c7d242e5-2c95-47ac-828d-4c788dc7e6eb","FileType":1,"FileFullName":"202507011458362836.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202507/01/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-07-01T14:58:36","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202507/01/202507011458362836.jpg"}] 2026-01-28 09:23:14 [55] ERROR lp.shop.core.LogBase [{"FileResourceId":"b039bae7-7e57-44c1-8000-d63d22ac6e83"}] [{"id":"b039bae7-7e57-44c1-8000-d63d22ac6e83","FileType":1,"FileFullName":"202507011447140793.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202507/01/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-07-01T14:47:14","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202507/01/202507011447140793.jpg"}] 2026-01-28 09:23:14 [68] ERROR lp.shop.core.LogBase [{"FileResourceId":"bc824aae-7b22-4aae-8ddc-0b4f43d619a0"}] [{"id":"bc824aae-7b22-4aae-8ddc-0b4f43d619a0","FileType":1,"FileFullName":"202507011453425554.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202507/01/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-07-01T14:53:43","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202507/01/202507011453425554.jpg"}] 2026-01-28 09:23:14 [41] ERROR lp.shop.core.LogBase [{"FileResourceId":"cb0f28aa-3d7c-434d-a7d5-3de0657a7f7c"}] [{"id":"cb0f28aa-3d7c-434d-a7d5-3de0657a7f7c","FileType":1,"FileFullName":"202303210208548083.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202303/21/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-03-21T02:08:55","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202303/21/202303210208548083.jpg"}] 2026-01-28 09:23:14 [52] ERROR lp.shop.core.LogBase [{"FileResourceId":"b24a72c9-73c5-46d5-b80b-ab5dd8a01380"}] [{"id":"b24a72c9-73c5-46d5-b80b-ab5dd8a01380","FileType":1,"FileFullName":"202112221006470386.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/22/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-22T10:06:47","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/22/202112221006470386.jpg"}] 2026-01-28 09:23:14 [63] ERROR lp.shop.core.LogBase [{"FileResourceId":"13c1fb71-a1e0-40f3-b3e4-05472ab19036"}] [{"id":"13c1fb71-a1e0-40f3-b3e4-05472ab19036","FileType":1,"FileFullName":"202112221153471851.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/22/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-22T11:53:47","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/22/202112221153471851.jpg"}] 2026-01-28 09:23:14 [53] ERROR lp.shop.core.LogBase [{"FileResourceId":"62984bbe-d3a0-4a49-9f4f-2a2c5d61b9b0"}] [{"id":"62984bbe-d3a0-4a49-9f4f-2a2c5d61b9b0","FileType":1,"FileFullName":"202112221008450034.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/22/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-22T10:08:45","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/22/202112221008450034.jpg"}] 2026-01-28 09:23:56 [91] 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 ='20000' and a.stored_id ='202109111029036163' group by a.spuid order by createdate desc limit 10,10 2026-01-28 09:23:57 [52] ERROR lp.shop.core.LogBase [{"FileResourceId":"d67b9a59-05af-4b7b-973b-40b0f74d7333"}] [{"id":"d67b9a59-05af-4b7b-973b-40b0f74d7333","FileType":1,"FileFullName":"202506301637589442.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T16:37:59","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301637589442.jpg"}] 2026-01-28 09:23:57 [41] ERROR lp.shop.core.LogBase [{"FileResourceId":"7f8153e2-9a45-4382-ad23-b763f2bcc6f8"}] [{"id":"7f8153e2-9a45-4382-ad23-b763f2bcc6f8","FileType":1,"FileFullName":"202506301634294943.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T16:34:30","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301634294943.jpg"}] 2026-01-28 09:23:57 [55] ERROR lp.shop.core.LogBase [{"FileResourceId":"18f26afb-491c-4839-a84a-49ec222643bc"}] [{"id":"18f26afb-491c-4839-a84a-49ec222643bc","FileType":1,"FileFullName":"202410291129055093.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:29:06","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291129055093.jpg"}] 2026-01-28 09:23:57 [68] ERROR lp.shop.core.LogBase [{"FileResourceId":"da7e3883-7f3a-4e96-ba30-65bc449bc9ad"}] [{"id":"da7e3883-7f3a-4e96-ba30-65bc449bc9ad","FileType":1,"FileFullName":"202410291129050719.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:29:05","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291129050719.jpg"}] 2026-01-28 09:23:57 [63] ERROR lp.shop.core.LogBase [{"FileResourceId":"ac2c6eda-4210-41f9-91ab-b6c4094bb366"}] [{"id":"ac2c6eda-4210-41f9-91ab-b6c4094bb366","FileType":1,"FileFullName":"202410291129052437.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:29:05","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291129052437.jpg"}] 2026-01-28 09:23:57 [53] ERROR lp.shop.core.LogBase [{"FileResourceId":"e3981e0f-5730-414c-bcc1-4fdd3b68ca61"}] [{"id":"e3981e0f-5730-414c-bcc1-4fdd3b68ca61","FileType":1,"FileFullName":"202410291129044937.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:29:04","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291129044937.jpg"}] 2026-01-28 09:23:57 [50] ERROR lp.shop.core.LogBase [{"FileResourceId":"1763e110-c16b-42c0-9dff-61bbdd0f5eb5"}] [{"id":"1763e110-c16b-42c0-9dff-61bbdd0f5eb5","FileType":1,"FileFullName":"202410291129062437.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:29:06","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291129062437.jpg"}] 2026-01-28 09:23:57 [91] ERROR lp.shop.core.LogBase [{"FileResourceId":"6af1ceb0-9840-463d-8d5a-2f8dcb87de06"}] [{"id":"6af1ceb0-9840-463d-8d5a-2f8dcb87de06","FileType":1,"FileFullName":"202410291129048531.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:29:05","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291129048531.jpg"}] 2026-01-28 09:23:57 [52] ERROR lp.shop.core.LogBase [{"FileResourceId":"cf81a6aa-9977-4fe3-a887-371cb36e135c"}] [{"id":"cf81a6aa-9977-4fe3-a887-371cb36e135c","FileType":1,"FileFullName":"202410291129046656.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:29:05","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291129046656.jpg"}] 2026-01-28 09:23:57 [41] ERROR lp.shop.core.LogBase [{"FileResourceId":"0e7116cb-a47d-4afe-8d4a-54acc5179d95"}] [{"id":"0e7116cb-a47d-4afe-8d4a-54acc5179d95","FileType":1,"FileFullName":"202506301553079869.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T15:53:08","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301553079869.jpg"}] 2026-01-28 09:24:06 [41] INFO lp.shop.core.LogBase 【SQL】======set @rowindex = 0; select sql_calc_found_rows @rowindex:=@rowindex+1 as rownumber, id,userid,receivername,receiverphone,receivermobile,receiverprovince,receivercity,receiverdistrict,receiveraddress,isdefault,createdate,updatedate from shop_address where 1=1 and userid='2afd12aa-e3e3-4b39-b2ac-0664ba762a2d' order by isdefault DESC limit 0,99999 2026-01-28 09:24:08 [56] 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 ='20000' and a.stored_id ='202109111029036163' and a.spuid ='76c37bf8-99b8-4c93-b587-ef28d25782f6' group by a.spuid order by createdate desc limit 0,10 2026-01-28 09:24:08 [52] ERROR lp.shop.core.LogBase [{"FileResourceId":"d1a873ea-3dcc-407a-86e9-22695d30f33b"}] [{"id":"d1a873ea-3dcc-407a-86e9-22695d30f33b","FileType":1,"FileFullName":"202506301702505717.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T17:02:51","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301702505717.jpg"}] 2026-01-28 09:24:08 [55] 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='76c37bf8-99b8-4c93-b587-ef28d25782f6' GROUP BY d.id ) AS f ON f.shop_spu_id = a.spuid where 1=1 and a.companyid='20000' and a.stored_id='202109111029036163' ) x ON s.spuid=x.spuid where 1=1 and x.companyid='20000' and x.stored_id='202109111029036163' and s.memberuserid='2afd12aa-e3e3-4b39-b2ac-0664ba762a2d' and s.spuid='76c37bf8-99b8-4c93-b587-ef28d25782f6' and s.spuid='76c37bf8-99b8-4c93-b587-ef28d25782f6' group by s.id order by s.createdate DESC limit 0,1 2026-01-28 09:24:08 [41] 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 ='20000' and a.stored_id ='202109111029036163' and f.model like'%ZE525%' order by createdate desc limit 0,999 2026-01-28 09:24:09 [53] 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 ='76c37bf8-99b8-4c93-b587-ef28d25782f6' and a.enable ='1' order by a.createdate desc limit 0,10 2026-01-28 09:24:09 [52] 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 ='76c37bf8-99b8-4c93-b587-ef28d25782f6' and a.enable ='1' order by a.createdate desc limit 0,10 2026-01-28 09:24:09 [56] 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='76c37bf8-99b8-4c93-b587-ef28d25782f6' and a.status='1' order by a.createdate desc limit 0,10 2026-01-28 09:24:09 [41] 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'%ZE525%' order by model ASC limit 0,8 2026-01-28 09:24:09 [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 ='20000' and a.stored_id ='202109111029036163' and f.styleid ='edba67a3-7bc5-43b0-818f-99348c097bb4' group by a.spuid order by createdate desc limit 0,6 2026-01-28 09:24:10 [68] ERROR lp.shop.core.LogBase [{"FileResourceId":"ac3fb6db-efcf-40b9-8658-8f86b9046eaf"}] [{"id":"ac3fb6db-efcf-40b9-8658-8f86b9046eaf","FileType":1,"FileFullName":"202506301712254849.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T17:12:26","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301712254849.jpg"}] 2026-01-28 09:24:10 [52] ERROR lp.shop.core.LogBase [{"FileResourceId":"5e3ac0d5-8d6d-4a63-8d8c-093a65c4bde3"}] [{"id":"5e3ac0d5-8d6d-4a63-8d8c-093a65c4bde3","FileType":1,"FileFullName":"202506301714236917.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T17:14:24","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301714236917.jpg"}] 2026-01-28 09:24:10 [57] ERROR lp.shop.core.LogBase [{"FileResourceId":"904c10cb-a6d4-4415-b73a-94d6950ce4e6"}] [{"id":"904c10cb-a6d4-4415-b73a-94d6950ce4e6","FileType":1,"FileFullName":"202410291128475660.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:28:48","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291128475660.jpg"}] 2026-01-28 09:24:10 [56] ERROR lp.shop.core.LogBase [{"FileResourceId":"fef91e55-bdee-43c9-94af-a10ac1ca22c9"}] [{"id":"fef91e55-bdee-43c9-94af-a10ac1ca22c9","FileType":1,"FileFullName":"202410291127218942.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:27:22","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291127218942.jpg"}] 2026-01-28 09:24:10 [50] ERROR lp.shop.core.LogBase [{"FileResourceId":"092c1751-d713-4e84-b47a-f6d86947a115"}] [{"id":"092c1751-d713-4e84-b47a-f6d86947a115","FileType":1,"FileFullName":"202507010933570522.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202507/01/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-07-01T09:33:57","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202507/01/202507010933570522.jpg"}] 2026-01-28 09:24:10 [91] ERROR lp.shop.core.LogBase [{"FileResourceId":"a122cabd-2e18-4a77-b938-214f69c0a811"}] [{"id":"a122cabd-2e18-4a77-b938-214f69c0a811","FileType":1,"FileFullName":"202506301517292456.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T15:17:29","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301517292456.jpg"}] 2026-01-28 09:24:21 [68] 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 ='20000' and a.stored_id ='202109111029036163' and a.spuid ='933e044a-422b-4c85-9dc4-8ce8eb58d1cb' group by a.spuid order by createdate desc limit 0,10 2026-01-28 09:24:21 [56] ERROR lp.shop.core.LogBase [{"FileResourceId":"6fca3efc-e1ac-43ce-b893-2c16b5743596"},{"FileResourceId":"2acb073c-62a3-48be-96a5-e7d93a386fe2"}] [{"id":"6fca3efc-e1ac-43ce-b893-2c16b5743596","FileType":1,"FileFullName":"202506301518217699.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T15:18:22","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301518217699.jpg"},{"id":"2acb073c-62a3-48be-96a5-e7d93a386fe2","FileType":1,"FileFullName":"202506301518218012.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T15:18:22","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301518218012.jpg"}] 2026-01-28 09:24:21 [50] 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='933e044a-422b-4c85-9dc4-8ce8eb58d1cb' GROUP BY d.id ) AS f ON f.shop_spu_id = a.spuid where 1=1 and a.companyid='20000' and a.stored_id='202109111029036163' ) x ON s.spuid=x.spuid where 1=1 and x.companyid='20000' and x.stored_id='202109111029036163' and s.memberuserid='2afd12aa-e3e3-4b39-b2ac-0664ba762a2d' and s.spuid='933e044a-422b-4c85-9dc4-8ce8eb58d1cb' and s.spuid='933e044a-422b-4c85-9dc4-8ce8eb58d1cb' group by s.id order by s.createdate DESC limit 0,1 2026-01-28 09:24:21 [91] 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 ='20000' and a.stored_id ='202109111029036163' and f.model like'%S0723%' order by createdate desc limit 0,999 2026-01-28 09:24:22 [55] 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 ='933e044a-422b-4c85-9dc4-8ce8eb58d1cb' and a.enable ='1' order by a.createdate desc limit 0,10 2026-01-28 09:24:22 [53] 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 ='933e044a-422b-4c85-9dc4-8ce8eb58d1cb' and a.enable ='1' order by a.createdate desc limit 0,10 2026-01-28 09:24:22 [57] 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='933e044a-422b-4c85-9dc4-8ce8eb58d1cb' and a.status='1' order by a.createdate desc limit 0,10 2026-01-28 09:24:22 [41] 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'%S0723%' order by model ASC limit 0,8 2026-01-28 09:24:22 [68] 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 ='20000' and a.stored_id ='202109111029036163' and f.styleid ='edba67a3-7bc5-43b0-818f-99348c097bb4' group by a.spuid order by createdate desc limit 0,6 2026-01-28 09:24:23 [53] ERROR lp.shop.core.LogBase [{"FileResourceId":"092c1751-d713-4e84-b47a-f6d86947a115"}] [{"id":"092c1751-d713-4e84-b47a-f6d86947a115","FileType":1,"FileFullName":"202507010933570522.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202507/01/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-07-01T09:33:57","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202507/01/202507010933570522.jpg"}] 2026-01-28 09:24:23 [55] ERROR lp.shop.core.LogBase [{"FileResourceId":"fef91e55-bdee-43c9-94af-a10ac1ca22c9"}] [{"id":"fef91e55-bdee-43c9-94af-a10ac1ca22c9","FileType":1,"FileFullName":"202410291127218942.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:27:22","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291127218942.jpg"}] 2026-01-28 09:24:23 [57] ERROR lp.shop.core.LogBase [{"FileResourceId":"904c10cb-a6d4-4415-b73a-94d6950ce4e6"}] [{"id":"904c10cb-a6d4-4415-b73a-94d6950ce4e6","FileType":1,"FileFullName":"202410291128475660.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:28:48","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291128475660.jpg"}] 2026-01-28 09:24:23 [52] ERROR lp.shop.core.LogBase [{"FileResourceId":"a122cabd-2e18-4a77-b938-214f69c0a811"}] [{"id":"a122cabd-2e18-4a77-b938-214f69c0a811","FileType":1,"FileFullName":"202506301517292456.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T15:17:29","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301517292456.jpg"}] 2026-01-28 09:24:23 [56] ERROR lp.shop.core.LogBase [{"FileResourceId":"ac3fb6db-efcf-40b9-8658-8f86b9046eaf"}] [{"id":"ac3fb6db-efcf-40b9-8658-8f86b9046eaf","FileType":1,"FileFullName":"202506301712254849.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T17:12:26","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301712254849.jpg"}] 2026-01-28 09:24:23 [41] ERROR lp.shop.core.LogBase [{"FileResourceId":"5e3ac0d5-8d6d-4a63-8d8c-093a65c4bde3"}] [{"id":"5e3ac0d5-8d6d-4a63-8d8c-093a65c4bde3","FileType":1,"FileFullName":"202506301714236917.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T17:14:24","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301714236917.jpg"}] 2026-01-28 09:25:39 [56] 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-01-28 09:25:39 [55] 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-01-28 09:25:39 [62] 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-01-28 09:25:39 [57] 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-01-28 09:25:39 [63] 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-01-28 09:25:39 [53] 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-01-28 09:25:39 [60] 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-01-28 09:25:39 [61] 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-01-28 09:25:39 [68] 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-01-28 09:25:39 [52] 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-01-28 09:25:39 [91] 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-01-28 09:25:39 [62] ERROR lp.shop.core.LogBase [{"FileResourceId":"d60f68e1-5d0e-430e-9414-a2ce787858fb"}] [{"id":"d60f68e1-5d0e-430e-9414-a2ce787858fb","FileType":1,"FileFullName":"202112210844508485.png","FileExtension":"png","FileMD5":null,"FileIOPath":"/upload/202112/21/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-21T08:44:51","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/21/202112210844508485.png"}] 2026-01-28 09:25:39 [57] ERROR lp.shop.core.LogBase [{"FileResourceId":"052bed5a-b60c-427d-8367-d9aef01aa729"}] [{"id":"052bed5a-b60c-427d-8367-d9aef01aa729","FileType":1,"FileFullName":"202112210844593367.png","FileExtension":"png","FileMD5":null,"FileIOPath":"/upload/202112/21/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-21T08:44:59","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/21/202112210844593367.png"}] 2026-01-28 09:25:39 [63] ERROR lp.shop.core.LogBase [{"FileResourceId":"36adc816-a925-4b29-b3bd-0c15971159b2"}] [{"id":"36adc816-a925-4b29-b3bd-0c15971159b2","FileType":1,"FileFullName":"202112210844326297.png","FileExtension":"png","FileMD5":null,"FileIOPath":"/upload/202112/21/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-21T08:44:33","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/21/202112210844326297.png"}] 2026-01-28 09:25:39 [41] ERROR lp.shop.core.LogBase [{"FileResourceId":"4670d566-7377-48d0-a514-dbc758809bcd"}] [{"id":"4670d566-7377-48d0-a514-dbc758809bcd","FileType":1,"FileFullName":"202112210844420360.png","FileExtension":"png","FileMD5":null,"FileIOPath":"/upload/202112/21/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-21T08:44:42","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/21/202112210844420360.png"}] 2026-01-28 09:25:39 [54] 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 ='20000' and a.stored_id ='202109111029036163' group by a.spuid order by createdate desc limit 0,10 2026-01-28 09:25:39 [55] 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='202109111029036163' LEFT JOIN system_stored o on o.id='202109111029036163' where 1=1 and a.is_up=1 and a.programmeno is not null and d.stored_id ='202109111029036163' and a.programmenotype =0 order by a.createdate desc limit 0,99999 2026-01-28 09:25:40 [61] ERROR lp.shop.core.LogBase [{"FileResourceId":"a122cabd-2e18-4a77-b938-214f69c0a811"}] [{"id":"a122cabd-2e18-4a77-b938-214f69c0a811","FileType":1,"FileFullName":"202506301517292456.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T15:17:29","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301517292456.jpg"}] 2026-01-28 09:25:40 [68] ERROR lp.shop.core.LogBase [{"FileResourceId":"904c10cb-a6d4-4415-b73a-94d6950ce4e6"}] [{"id":"904c10cb-a6d4-4415-b73a-94d6950ce4e6","FileType":1,"FileFullName":"202410291128475660.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:28:48","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291128475660.jpg"}] 2026-01-28 09:25:40 [52] ERROR lp.shop.core.LogBase [{"FileResourceId":"092c1751-d713-4e84-b47a-f6d86947a115"}] [{"id":"092c1751-d713-4e84-b47a-f6d86947a115","FileType":1,"FileFullName":"202507010933570522.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202507/01/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-07-01T09:33:57","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202507/01/202507010933570522.jpg"}] 2026-01-28 09:25:40 [91] ERROR lp.shop.core.LogBase [{"FileResourceId":"fef91e55-bdee-43c9-94af-a10ac1ca22c9"}] [{"id":"fef91e55-bdee-43c9-94af-a10ac1ca22c9","FileType":1,"FileFullName":"202410291127218942.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:27:22","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291127218942.jpg"}] 2026-01-28 09:25:40 [50] ERROR lp.shop.core.LogBase [{"FileResourceId":"5e3ac0d5-8d6d-4a63-8d8c-093a65c4bde3"}] [{"id":"5e3ac0d5-8d6d-4a63-8d8c-093a65c4bde3","FileType":1,"FileFullName":"202506301714236917.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T17:14:24","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301714236917.jpg"}] 2026-01-28 09:25:40 [63] ERROR lp.shop.core.LogBase [{"FileResourceId":"ac3fb6db-efcf-40b9-8658-8f86b9046eaf"}] [{"id":"ac3fb6db-efcf-40b9-8658-8f86b9046eaf","FileType":1,"FileFullName":"202506301712254849.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T17:12:26","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301712254849.jpg"}] 2026-01-28 09:25:40 [53] ERROR lp.shop.core.LogBase [{"FileResourceId":"0c2962ff-97f9-4c9d-94c3-9484e44b7e25"}] [{"id":"0c2962ff-97f9-4c9d-94c3-9484e44b7e25","FileType":1,"FileFullName":"202506301709062165.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T17:09:06","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301709062165.jpg"}] 2026-01-28 09:25:40 [41] ERROR lp.shop.core.LogBase [{"FileResourceId":"ceb49311-b5a0-4461-93cf-5023b09bd63c"}] [{"id":"ceb49311-b5a0-4461-93cf-5023b09bd63c","FileType":1,"FileFullName":"202506301705331067.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T17:05:33","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301705331067.jpg"}] 2026-01-28 09:25:40 [54] ERROR lp.shop.core.LogBase [{"FileResourceId":"f1ac6ab9-e0a4-45f6-a41b-b7badfcab882"}] [{"id":"f1ac6ab9-e0a4-45f6-a41b-b7badfcab882","FileType":1,"FileFullName":"202506301658137985.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T16:58:14","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301658137985.jpg"}] 2026-01-28 09:25:40 [60] ERROR lp.shop.core.LogBase [{"FileResourceId":"03bcf3c5-3579-4604-90ee-718757d2960f"}] [{"id":"03bcf3c5-3579-4604-90ee-718757d2960f","FileType":1,"FileFullName":"202506301702020601.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T17:02:02","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301702020601.jpg"}] 2026-01-28 09:25:41 [68] ERROR lp.shop.core.LogBase [{"FileResourceId":"49c358bd-1977-4e8a-b492-351b5a429142"}] [{"id":"49c358bd-1977-4e8a-b492-351b5a429142","FileType":1,"FileFullName":"202304131546201654.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202304/13/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-04-13T15:46:20","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202304/13/202304131546201654.jpg"}] 2026-01-28 09:25:41 [61] ERROR lp.shop.core.LogBase [{"FileResourceId":"bf9510e7-3308-49b6-b682-1fe963c0ea72"}] [{"id":"bf9510e7-3308-49b6-b682-1fe963c0ea72","FileType":1,"FileFullName":"202304131543591047.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202304/13/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-04-13T15:43:59","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202304/13/202304131543591047.jpg"}] 2026-01-28 09:25:41 [52] ERROR lp.shop.core.LogBase [{"FileResourceId":"6ccfaa05-d084-459d-ba07-4fd3a8e13c48"}] [{"id":"6ccfaa05-d084-459d-ba07-4fd3a8e13c48","FileType":1,"FileFullName":"202304131548076157.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202304/13/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-04-13T15:48:08","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202304/13/202304131548076157.jpg"}] 2026-01-28 09:25:41 [56] ERROR lp.shop.core.LogBase [{"FileResourceId":"f77d8dae-8fa6-4790-8679-56de72884de2"}] [{"id":"f77d8dae-8fa6-4790-8679-56de72884de2","FileType":1,"FileFullName":"202304131545196458.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202304/13/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-04-13T15:45:20","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202304/13/202304131545196458.jpg"}] 2026-01-28 09:25:41 [91] ERROR lp.shop.core.LogBase [{"FileResourceId":"b9ae91fe-d952-48a4-bfaa-4343bd6926b0"}] [{"id":"b9ae91fe-d952-48a4-bfaa-4343bd6926b0","FileType":1,"FileFullName":"202304131530429011.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202304/13/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-04-13T15:30:43","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202304/13/202304131530429011.jpg"}] 2026-01-28 09:25:41 [62] INFO lp.shop.core.LogBase 【SQL】======set @rowindex = 0; select sql_calc_found_rows @rowindex:=@rowindex+1 as rownumber, a.id,a.packageno,a.packagename,a.image,a.price,a.type,a.remark,a.createuid,a.createdate,a.updateuid,a.updatedate,a.is_delete,b.price_coefficient,c.price_coefficient_forstored from shop_package a left join shop_stored_price b on b.storedid='202109111029036163' left join system_stored c on c.id='202109111029036163' where 1=1 and is_delete=0 order by createdate desc limit 0,9999 2026-01-28 09:25:41 [41] ERROR lp.shop.core.LogBase [{"FileResourceId":"b039bae7-7e57-44c1-8000-d63d22ac6e83"}] [{"id":"b039bae7-7e57-44c1-8000-d63d22ac6e83","FileType":1,"FileFullName":"202507011447140793.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202507/01/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-07-01T14:47:14","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202507/01/202507011447140793.jpg"}] 2026-01-28 09:25:41 [63] ERROR lp.shop.core.LogBase [{"FileResourceId":"bc824aae-7b22-4aae-8ddc-0b4f43d619a0"}] [{"id":"bc824aae-7b22-4aae-8ddc-0b4f43d619a0","FileType":1,"FileFullName":"202507011453425554.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202507/01/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-07-01T14:53:43","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202507/01/202507011453425554.jpg"}] 2026-01-28 09:25:41 [50] ERROR lp.shop.core.LogBase [{"FileResourceId":"c7d242e5-2c95-47ac-828d-4c788dc7e6eb"}] [{"id":"c7d242e5-2c95-47ac-828d-4c788dc7e6eb","FileType":1,"FileFullName":"202507011458362836.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202507/01/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-07-01T14:58:36","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202507/01/202507011458362836.jpg"}] 2026-01-28 09:25:41 [54] ERROR lp.shop.core.LogBase [{"FileResourceId":"cb0f28aa-3d7c-434d-a7d5-3de0657a7f7c"}] [{"id":"cb0f28aa-3d7c-434d-a7d5-3de0657a7f7c","FileType":1,"FileFullName":"202303210208548083.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202303/21/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-03-21T02:08:55","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202303/21/202303210208548083.jpg"}] 2026-01-28 09:25:41 [60] ERROR lp.shop.core.LogBase [{"FileResourceId":"b24a72c9-73c5-46d5-b80b-ab5dd8a01380"}] [{"id":"b24a72c9-73c5-46d5-b80b-ab5dd8a01380","FileType":1,"FileFullName":"202112221006470386.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/22/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-22T10:06:47","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/22/202112221006470386.jpg"}] 2026-01-28 09:25:41 [68] ERROR lp.shop.core.LogBase [{"FileResourceId":"13c1fb71-a1e0-40f3-b3e4-05472ab19036"}] [{"id":"13c1fb71-a1e0-40f3-b3e4-05472ab19036","FileType":1,"FileFullName":"202112221153471851.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/22/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-22T11:53:47","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/22/202112221153471851.jpg"}] 2026-01-28 09:25:41 [55] ERROR lp.shop.core.LogBase [{"FileResourceId":"62984bbe-d3a0-4a49-9f4f-2a2c5d61b9b0"}] [{"id":"62984bbe-d3a0-4a49-9f4f-2a2c5d61b9b0","FileType":1,"FileFullName":"202112221008450034.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/22/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-22T10:08:45","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/22/202112221008450034.jpg"}] 2026-01-28 09:25:43 [50] ERROR lp.shop.core.LogBase [{"FileResourceId":"f67aadb5-0c92-4b6d-9e71-08fc026743ea"}] [{"id":"f67aadb5-0c92-4b6d-9e71-08fc026743ea","FileType":1,"FileFullName":"202112281141102351.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-28T11:41:10","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/28/202112281141102351.jpg"}] 2026-01-28 09:25:43 [53] ERROR lp.shop.core.LogBase [{"FileResourceId":"ddac28a0-9f57-4fe7-ab77-274e37ced82b"}] [{"id":"ddac28a0-9f57-4fe7-ab77-274e37ced82b","FileType":1,"FileFullName":"202112281130488446.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-28T11:30:49","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/28/202112281130488446.jpg"}] 2026-01-28 09:25:44 [60] ERROR lp.shop.core.LogBase [{"FileResourceId":"b8bf5ac8-df12-4270-a044-a948feeeb8a9"}] [{"id":"b8bf5ac8-df12-4270-a044-a948feeeb8a9","FileType":1,"FileFullName":"202401021007488015.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202401/02/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-01-02T10:07:49","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202401/02/202401021007488015.jpg"}] 2026-01-28 09:25:44 [52] ERROR lp.shop.core.LogBase [{"FileResourceId":"ced25d11-7224-4992-b5d8-850fe72422b0"}] [{"id":"ced25d11-7224-4992-b5d8-850fe72422b0","FileType":1,"FileFullName":"202306261046395029.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202306/26/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-06-26T10:46:40","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202306/26/202306261046395029.jpg"}] 2026-01-28 09:25:44 [55] ERROR lp.shop.core.LogBase [{"FileResourceId":"ecd4644a-41f9-4f5f-9b17-29cbab742c9a"}] [{"id":"ecd4644a-41f9-4f5f-9b17-29cbab742c9a","FileType":1,"FileFullName":"202111291416210062.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202111/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-11-29T14:16:21","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202111/29/202111291416210062.jpg"}] 2026-01-28 09:25:44 [68] ERROR lp.shop.core.LogBase [{"FileResourceId":"18a6ab00-ce04-4085-ae2c-9fc31bae2a56"}] [{"id":"18a6ab00-ce04-4085-ae2c-9fc31bae2a56","FileType":1,"FileFullName":"202306281538097453.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202306/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-06-28T15:38:10","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202306/28/202306281538097453.jpg"}] 2026-01-28 09:25:45 [61] ERROR lp.shop.core.LogBase [{"FileResourceId":"4075c441-b615-4be1-95ea-c1eda923bade"}] [{"id":"4075c441-b615-4be1-95ea-c1eda923bade","FileType":1,"FileFullName":"202109031637546333.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202109/03/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-09-03T16:37:55","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202109/03/202109031637546333.jpg"}] 2026-01-28 09:25:45 [41] ERROR lp.shop.core.LogBase [{"FileResourceId":"e27646c4-80a7-4449-b8d1-1751403fb89f"}] [{"id":"e27646c4-80a7-4449-b8d1-1751403fb89f","FileType":1,"FileFullName":"202204071134158445.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202204/07/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2022-04-07T11:34:16","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202204/07/202204071134158445.jpg"}] 2026-01-28 09:25:45 [63] ERROR lp.shop.core.LogBase [{"FileResourceId":"b7963ee8-d474-4df4-b450-40bf42257949"}] [{"id":"b7963ee8-d474-4df4-b450-40bf42257949","FileType":1,"FileFullName":"202204190945056094.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202204/19/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2022-04-19T09:45:06","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202204/19/202204190945056094.jpg"}] 2026-01-28 09:25:45 [52] ERROR lp.shop.core.LogBase [{"FileResourceId":"1d94a264-d707-44f1-815b-86dd69b65cdf"}] [{"id":"1d94a264-d707-44f1-815b-86dd69b65cdf","FileType":1,"FileFullName":"202111291619534541.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202111/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-11-29T16:19:53","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202111/29/202111291619534541.jpg"}] 2026-01-28 09:25:45 [56] ERROR lp.shop.core.LogBase [{"FileResourceId":"335efc58-dcba-4980-b273-4f8ac0cb3fed"}] [{"id":"335efc58-dcba-4980-b273-4f8ac0cb3fed","FileType":1,"FileFullName":"202306281146228577.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202306/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-06-28T11:46:23","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202306/28/202306281146228577.jpg"}] 2026-01-28 09:25:47 [56] 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 ='20000' and a.stored_id ='202109111029036163' and f.typeid ='ca06dc45-2183-4e98-bb7b-e2ad73c66ddc' and FIND_IN_SET('3cca7164-f2b4-4a3e-aef3-b40f3bc010c3',f.categoryid) group by a.spuid order by createdate desc limit 0,12 2026-01-28 09:25:47 [62] ERROR lp.shop.core.LogBase [{"FileResourceId":"e935abbc-bb02-4b53-af0c-5c484fde8fe8"}] [{"id":"e935abbc-bb02-4b53-af0c-5c484fde8fe8","FileType":1,"FileFullName":"202506301533594998.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T15:34:00","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301533594998.jpg"}] 2026-01-28 09:25:47 [79] ERROR lp.shop.core.LogBase [{"FileResourceId":"e4e6e5e4-271f-4f0a-a2fd-2ac62042a388"}] [{"id":"e4e6e5e4-271f-4f0a-a2fd-2ac62042a388","FileType":1,"FileFullName":"202506291720316852.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-29T17:20:32","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/29/202506291720316852.jpg"}] 2026-01-28 09:25:47 [91] ERROR lp.shop.core.LogBase [{"FileResourceId":"1321b076-b05f-45ad-8e4d-f24746cb679a"}] [{"id":"1321b076-b05f-45ad-8e4d-f24746cb679a","FileType":1,"FileFullName":"202410291132016698.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:32:02","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291132016698.jpg"}] 2026-01-28 09:25:47 [52] ERROR lp.shop.core.LogBase [{"FileResourceId":"9c956add-726c-4bdb-b9a3-17c222f1ae6f"}] [{"id":"9c956add-726c-4bdb-b9a3-17c222f1ae6f","FileType":1,"FileFullName":"202506291655177202.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-29T16:55:18","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/29/202506291655177202.jpg"}] 2026-01-28 09:25:47 [57] ERROR lp.shop.core.LogBase [{"FileResourceId":"172154ef-9cbe-4d8a-aa55-c3dfba54ab65"}] [{"id":"172154ef-9cbe-4d8a-aa55-c3dfba54ab65","FileType":1,"FileFullName":"202506291716528542.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-29T17:16:53","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/29/202506291716528542.jpg"}] 2026-01-28 09:25:47 [53] ERROR lp.shop.core.LogBase [{"FileResourceId":"2a2259f6-3f1f-4217-9730-0f64a2fddb31"}] [{"id":"2a2259f6-3f1f-4217-9730-0f64a2fddb31","FileType":1,"FileFullName":"202410291132017635.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:32:02","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291132017635.jpg"}] 2026-01-28 09:25:47 [50] ERROR lp.shop.core.LogBase [{"FileResourceId":"384daa45-28e5-4a58-a951-69e7b6c4449d"}] [{"id":"384daa45-28e5-4a58-a951-69e7b6c4449d","FileType":1,"FileFullName":"202410291132022948.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:32:02","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291132022948.jpg"}] 2026-01-28 09:25:47 [61] ERROR lp.shop.core.LogBase [{"FileResourceId":"71a888c2-a908-45b1-824e-685c218c425e"}] [{"id":"71a888c2-a908-45b1-824e-685c218c425e","FileType":1,"FileFullName":"202505221632077131.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202505/22/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-05-22T16:32:08","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202505/22/202505221632077131.jpg"}] 2026-01-28 09:25:47 [41] ERROR lp.shop.core.LogBase [{"FileResourceId":"8de63982-c422-4174-a14f-00e98c45c4f7"}] [{"id":"8de63982-c422-4174-a14f-00e98c45c4f7","FileType":1,"FileFullName":"202410291132021229.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:32:02","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291132021229.jpg"}] 2026-01-28 09:25:47 [49] ERROR lp.shop.core.LogBase [{"FileResourceId":"93d0ea0d-d276-44c7-a432-fc9792574128"}] [{"id":"93d0ea0d-d276-44c7-a432-fc9792574128","FileType":1,"FileFullName":"202410291132022010.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:32:02","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291132022010.jpg"}] 2026-01-28 09:25:47 [54] ERROR lp.shop.core.LogBase [{"FileResourceId":"9f029ba2-e61a-4c98-96bd-2eaee87b11eb"}] [{"id":"9f029ba2-e61a-4c98-96bd-2eaee87b11eb","FileType":1,"FileFullName":"202505221118305583.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202505/22/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-05-22T11:18:31","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202505/22/202505221118305583.jpg"}] 2026-01-28 09:25:47 [55] ERROR lp.shop.core.LogBase [{"FileResourceId":"e5c69eec-18c8-4d96-bb6a-18e43922ccff"}] [{"id":"e5c69eec-18c8-4d96-bb6a-18e43922ccff","FileType":1,"FileFullName":"202410291132004354.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:32:00","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291132004354.jpg"}] 2026-01-28 09:25:49 [68] 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 ='20000' and a.stored_id ='202109111029036163' and f.typeid ='ca06dc45-2183-4e98-bb7b-e2ad73c66ddc' and FIND_IN_SET('3cca7164-f2b4-4a3e-aef3-b40f3bc010c3',f.categoryid) group by a.spuid order by createdate desc limit 12,12 2026-01-28 09:25:49 [63] ERROR lp.shop.core.LogBase [{"FileResourceId":"9ab8101a-072e-4c92-be08-a03d279c5fd4"}] [{"id":"9ab8101a-072e-4c92-be08-a03d279c5fd4","FileType":1,"FileFullName":"202505221104286620.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202505/22/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-05-22T11:04:29","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202505/22/202505221104286620.jpg"}] 2026-01-28 09:25:49 [57] ERROR lp.shop.core.LogBase [{"FileResourceId":"51f8d857-43bf-4d07-b4aa-0dc70abfef51"}] [{"id":"51f8d857-43bf-4d07-b4aa-0dc70abfef51","FileType":1,"FileFullName":"202401172056078315.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202401/17/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-01-17T20:56:08","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202401/17/202401172056078315.jpg"}] 2026-01-28 09:25:49 [79] ERROR lp.shop.core.LogBase [{"FileResourceId":"7922975e-1173-46e1-b4dd-18bebe798090"}] [{"id":"7922975e-1173-46e1-b4dd-18bebe798090","FileType":1,"FileFullName":"202401172056076284.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202401/17/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-01-17T20:56:08","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202401/17/202401172056076284.jpg"}] 2026-01-28 09:25:49 [52] ERROR lp.shop.core.LogBase [{"FileResourceId":"80fa2e82-9860-4666-83a1-532542292122"}] [{"id":"80fa2e82-9860-4666-83a1-532542292122","FileType":1,"FileFullName":"202505221107262846.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202505/22/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-05-22T11:07:26","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202505/22/202505221107262846.jpg"}] 2026-01-28 09:25:49 [91] ERROR lp.shop.core.LogBase [{"FileResourceId":"f9679058-efbd-455f-859d-edcfb09a6c4a"}] [{"id":"f9679058-efbd-455f-859d-edcfb09a6c4a","FileType":1,"FileFullName":"202401172056077378.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202401/17/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-01-17T20:56:08","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202401/17/202401172056077378.jpg"}] 2026-01-28 09:25:49 [53] ERROR lp.shop.core.LogBase [{"FileResourceId":"fae0528d-15c5-4ec9-93ae-931031eb6798"}] [{"id":"fae0528d-15c5-4ec9-93ae-931031eb6798","FileType":1,"FileFullName":"202401172056071440.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202401/17/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-01-17T20:56:07","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202401/17/202401172056071440.jpg"}] 2026-01-28 09:25:49 [50] ERROR lp.shop.core.LogBase [{"FileResourceId":"cce213b9-e16e-45cc-aaab-9e422869b893"}] [{"id":"cce213b9-e16e-45cc-aaab-9e422869b893","FileType":1,"FileFullName":"202308020957304930.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202308/02/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-08-02T09:57:31","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202308/02/202308020957304930.jpg"}] 2026-01-28 09:25:49 [61] ERROR lp.shop.core.LogBase [{"FileResourceId":"ea8a53c5-52df-4fc0-9b27-793fa6fe2bf6"}] [{"id":"ea8a53c5-52df-4fc0-9b27-793fa6fe2bf6","FileType":1,"FileFullName":"202306281601429749.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202306/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-06-28T16:01:43","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202306/28/202306281601429749.jpg"}] 2026-01-28 09:25:49 [41] ERROR lp.shop.core.LogBase [{"FileResourceId":"b55bfed7-08ce-4ee9-9542-2ef83fe732e2"}] [{"id":"b55bfed7-08ce-4ee9-9542-2ef83fe732e2","FileType":1,"FileFullName":"202306281601205999.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202306/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-06-28T16:01:21","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202306/28/202306281601205999.jpg"}] 2026-01-28 09:25:49 [49] ERROR lp.shop.core.LogBase [{"FileResourceId":"30158d92-0baa-4d71-a9ed-a42d606cdbab"}] [{"id":"30158d92-0baa-4d71-a9ed-a42d606cdbab","FileType":1,"FileFullName":"202306261012075378.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202306/26/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-06-26T10:12:08","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202306/26/202306261012075378.jpg"}] 2026-01-28 09:25:49 [54] ERROR lp.shop.core.LogBase [{"FileResourceId":"b0e40f4b-531b-4750-a021-705138a49708"}] [{"id":"b0e40f4b-531b-4750-a021-705138a49708","FileType":1,"FileFullName":"202306261019258270.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202306/26/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-06-26T10:19:26","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202306/26/202306261019258270.jpg"}] 2026-01-28 09:25:49 [56] ERROR lp.shop.core.LogBase [{"FileResourceId":"b2df99c7-ff2f-4df3-aee6-b9e1a824ff32"}] [{"id":"b2df99c7-ff2f-4df3-aee6-b9e1a824ff32","FileType":1,"FileFullName":"202306261021177928.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202306/26/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-06-26T10:21:18","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202306/26/202306261021177928.jpg"}] 2026-01-28 09:25:51 [68] 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 ='20000' and a.stored_id ='202109111029036163' and f.typeid ='ca06dc45-2183-4e98-bb7b-e2ad73c66ddc' and FIND_IN_SET('3cca7164-f2b4-4a3e-aef3-b40f3bc010c3',f.categoryid) group by a.spuid order by createdate desc limit 24,12 2026-01-28 09:25:51 [63] ERROR lp.shop.core.LogBase [{"FileResourceId":"e7b94c82-a64e-40d4-ab1b-82458f7c66cd"}] [{"id":"e7b94c82-a64e-40d4-ab1b-82458f7c66cd","FileType":1,"FileFullName":"202306271346076299.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202306/27/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-06-27T13:46:08","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202306/27/202306271346076299.jpg"}] 2026-01-28 09:25:51 [57] ERROR lp.shop.core.LogBase [{"FileResourceId":"c3286622-407f-4530-a045-f304ac81beac"}] [{"id":"c3286622-407f-4530-a045-f304ac81beac","FileType":1,"FileFullName":"202306271730175754.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202306/27/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-06-27T17:30:18","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202306/27/202306271730175754.jpg"}] 2026-01-28 09:25:51 [52] ERROR lp.shop.core.LogBase [{"FileResourceId":"78a10c17-3026-4382-868f-1e03732c6b84"}] [{"id":"78a10c17-3026-4382-868f-1e03732c6b84","FileType":1,"FileFullName":"202306271345113604.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202306/27/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-06-27T13:45:11","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202306/27/202306271345113604.jpg"}] 2026-01-28 09:25:51 [79] ERROR lp.shop.core.LogBase [{"FileResourceId":"f717c7eb-51f0-46b7-8a13-864da02c56b9"}] [{"id":"f717c7eb-51f0-46b7-8a13-864da02c56b9","FileType":1,"FileFullName":"202306281340537403.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202306/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-06-28T13:40:54","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202306/28/202306281340537403.jpg"}] 2026-01-28 09:25:55 [60] 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 ='20000' and a.stored_id ='202109111029036163' and f.typeid ='ca06dc45-2183-4e98-bb7b-e2ad73c66ddc' and FIND_IN_SET('3cca7164-f2b4-4a3e-aef3-b40f3bc010c3',f.categoryid) group by a.spuid order by createdate desc limit 36,12 2026-01-28 10:28:30 [78] ERROR lp.shop.core.LogBase [{"FileResourceId":"1dfbf216-e52a-41f8-b928-3a0337abe211"}] [{"id":"1dfbf216-e52a-41f8-b928-3a0337abe211","FileType":1,"FileFullName":"202109111029008633.png","FileExtension":"png","FileMD5":null,"FileIOPath":"/upload/202109/11/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-09-11T10:29:01","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202109/11/202109111029008633.png"}] 2026-01-28 10:28:30 [66] 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-01-28 10:28:30 [77] 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-01-28 10:28:30 [73] 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-01-28 10:28:30 [84] 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-01-28 10:28:30 [82] 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-01-28 10:28:30 [92] 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-01-28 10:28:30 [78] 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-01-28 10:28:30 [78] 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-01-28 10:28:30 [77] 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-01-28 10:28:30 [50] 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-01-28 10:28:30 [73] 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-01-28 10:28:30 [66] ERROR lp.shop.core.LogBase [{"FileResourceId":"d60f68e1-5d0e-430e-9414-a2ce787858fb"}] [{"id":"d60f68e1-5d0e-430e-9414-a2ce787858fb","FileType":1,"FileFullName":"202112210844508485.png","FileExtension":"png","FileMD5":null,"FileIOPath":"/upload/202112/21/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-21T08:44:51","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/21/202112210844508485.png"}] 2026-01-28 10:28:30 [78] ERROR lp.shop.core.LogBase [{"FileResourceId":"36adc816-a925-4b29-b3bd-0c15971159b2"}] [{"id":"36adc816-a925-4b29-b3bd-0c15971159b2","FileType":1,"FileFullName":"202112210844326297.png","FileExtension":"png","FileMD5":null,"FileIOPath":"/upload/202112/21/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-21T08:44:33","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/21/202112210844326297.png"}] 2026-01-28 10:28:30 [77] ERROR lp.shop.core.LogBase [{"FileResourceId":"4670d566-7377-48d0-a514-dbc758809bcd"}] [{"id":"4670d566-7377-48d0-a514-dbc758809bcd","FileType":1,"FileFullName":"202112210844420360.png","FileExtension":"png","FileMD5":null,"FileIOPath":"/upload/202112/21/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-21T08:44:42","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/21/202112210844420360.png"}] 2026-01-28 10:28:30 [50] ERROR lp.shop.core.LogBase [{"FileResourceId":"052bed5a-b60c-427d-8367-d9aef01aa729"}] [{"id":"052bed5a-b60c-427d-8367-d9aef01aa729","FileType":1,"FileFullName":"202112210844593367.png","FileExtension":"png","FileMD5":null,"FileIOPath":"/upload/202112/21/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-21T08:44:59","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/21/202112210844593367.png"}] 2026-01-28 10:28:31 [88] 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 ='20000' and a.stored_id ='202109111029036163' group by a.spuid order by createdate desc limit 0,10 2026-01-28 10:28:31 [82] 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='202109111029036163' LEFT JOIN system_stored o on o.id='202109111029036163' where 1=1 and a.is_up=1 and a.programmeno is not null and d.stored_id ='202109111029036163' and a.programmenotype =0 order by a.createdate desc limit 0,99999 2026-01-28 10:28:31 [78] ERROR lp.shop.core.LogBase [{"FileResourceId":"904c10cb-a6d4-4415-b73a-94d6950ce4e6"}] [{"id":"904c10cb-a6d4-4415-b73a-94d6950ce4e6","FileType":1,"FileFullName":"202410291128475660.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:28:48","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291128475660.jpg"}] 2026-01-28 10:28:31 [92] ERROR lp.shop.core.LogBase [{"FileResourceId":"a122cabd-2e18-4a77-b938-214f69c0a811"}] [{"id":"a122cabd-2e18-4a77-b938-214f69c0a811","FileType":1,"FileFullName":"202506301517292456.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T15:17:29","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301517292456.jpg"}] 2026-01-28 10:28:31 [77] ERROR lp.shop.core.LogBase [{"FileResourceId":"092c1751-d713-4e84-b47a-f6d86947a115"}] [{"id":"092c1751-d713-4e84-b47a-f6d86947a115","FileType":1,"FileFullName":"202507010933570522.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202507/01/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-07-01T09:33:57","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202507/01/202507010933570522.jpg"}] 2026-01-28 10:28:31 [73] ERROR lp.shop.core.LogBase [{"FileResourceId":"fef91e55-bdee-43c9-94af-a10ac1ca22c9"}] [{"id":"fef91e55-bdee-43c9-94af-a10ac1ca22c9","FileType":1,"FileFullName":"202410291127218942.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:27:22","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291127218942.jpg"}] 2026-01-28 10:28:31 [50] ERROR lp.shop.core.LogBase [{"FileResourceId":"5e3ac0d5-8d6d-4a63-8d8c-093a65c4bde3"}] [{"id":"5e3ac0d5-8d6d-4a63-8d8c-093a65c4bde3","FileType":1,"FileFullName":"202506301714236917.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T17:14:24","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301714236917.jpg"}] 2026-01-28 10:28:32 [88] ERROR lp.shop.core.LogBase [{"FileResourceId":"ac3fb6db-efcf-40b9-8658-8f86b9046eaf"}] [{"id":"ac3fb6db-efcf-40b9-8658-8f86b9046eaf","FileType":1,"FileFullName":"202506301712254849.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T17:12:26","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301712254849.jpg"}] 2026-01-28 10:28:32 [78] ERROR lp.shop.core.LogBase [{"FileResourceId":"0c2962ff-97f9-4c9d-94c3-9484e44b7e25"}] [{"id":"0c2962ff-97f9-4c9d-94c3-9484e44b7e25","FileType":1,"FileFullName":"202506301709062165.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T17:09:06","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301709062165.jpg"}] 2026-01-28 10:28:32 [92] ERROR lp.shop.core.LogBase [{"FileResourceId":"ceb49311-b5a0-4461-93cf-5023b09bd63c"}] [{"id":"ceb49311-b5a0-4461-93cf-5023b09bd63c","FileType":1,"FileFullName":"202506301705331067.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T17:05:33","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301705331067.jpg"}] 2026-01-28 10:28:32 [84] ERROR lp.shop.core.LogBase [{"FileResourceId":"f1ac6ab9-e0a4-45f6-a41b-b7badfcab882"}] [{"id":"f1ac6ab9-e0a4-45f6-a41b-b7badfcab882","FileType":1,"FileFullName":"202506301658137985.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T16:58:14","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301658137985.jpg"}] 2026-01-28 10:28:32 [77] ERROR lp.shop.core.LogBase [{"FileResourceId":"03bcf3c5-3579-4604-90ee-718757d2960f"}] [{"id":"03bcf3c5-3579-4604-90ee-718757d2960f","FileType":1,"FileFullName":"202506301702020601.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T17:02:02","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301702020601.jpg"}] 2026-01-28 10:28:32 [50] ERROR lp.shop.core.LogBase [{"FileResourceId":"bf9510e7-3308-49b6-b682-1fe963c0ea72"}] [{"id":"bf9510e7-3308-49b6-b682-1fe963c0ea72","FileType":1,"FileFullName":"202304131543591047.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202304/13/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-04-13T15:43:59","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202304/13/202304131543591047.jpg"}] 2026-01-28 10:28:32 [78] ERROR lp.shop.core.LogBase [{"FileResourceId":"b9ae91fe-d952-48a4-bfaa-4343bd6926b0"}] [{"id":"b9ae91fe-d952-48a4-bfaa-4343bd6926b0","FileType":1,"FileFullName":"202304131530429011.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202304/13/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-04-13T15:30:43","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202304/13/202304131530429011.jpg"}] 2026-01-28 10:28:32 [92] ERROR lp.shop.core.LogBase [{"FileResourceId":"49c358bd-1977-4e8a-b492-351b5a429142"}] [{"id":"49c358bd-1977-4e8a-b492-351b5a429142","FileType":1,"FileFullName":"202304131546201654.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202304/13/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-04-13T15:46:20","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202304/13/202304131546201654.jpg"}] 2026-01-28 10:28:32 [66] INFO lp.shop.core.LogBase 【SQL】======set @rowindex = 0; select sql_calc_found_rows @rowindex:=@rowindex+1 as rownumber, a.id,a.packageno,a.packagename,a.image,a.price,a.type,a.remark,a.createuid,a.createdate,a.updateuid,a.updatedate,a.is_delete,b.price_coefficient,c.price_coefficient_forstored from shop_package a left join shop_stored_price b on b.storedid='202109111029036163' left join system_stored c on c.id='202109111029036163' where 1=1 and is_delete=0 order by createdate desc limit 0,9999 2026-01-28 10:28:32 [73] ERROR lp.shop.core.LogBase [{"FileResourceId":"f77d8dae-8fa6-4790-8679-56de72884de2"}] [{"id":"f77d8dae-8fa6-4790-8679-56de72884de2","FileType":1,"FileFullName":"202304131545196458.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202304/13/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-04-13T15:45:20","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202304/13/202304131545196458.jpg"}] 2026-01-28 10:28:32 [78] ERROR lp.shop.core.LogBase [{"FileResourceId":"c7d242e5-2c95-47ac-828d-4c788dc7e6eb"}] [{"id":"c7d242e5-2c95-47ac-828d-4c788dc7e6eb","FileType":1,"FileFullName":"202507011458362836.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202507/01/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-07-01T14:58:36","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202507/01/202507011458362836.jpg"}] 2026-01-28 10:28:32 [92] ERROR lp.shop.core.LogBase [{"FileResourceId":"bc824aae-7b22-4aae-8ddc-0b4f43d619a0"}] [{"id":"bc824aae-7b22-4aae-8ddc-0b4f43d619a0","FileType":1,"FileFullName":"202507011453425554.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202507/01/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-07-01T14:53:43","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202507/01/202507011453425554.jpg"}] 2026-01-28 10:28:32 [88] ERROR lp.shop.core.LogBase [{"FileResourceId":"b039bae7-7e57-44c1-8000-d63d22ac6e83"}] [{"id":"b039bae7-7e57-44c1-8000-d63d22ac6e83","FileType":1,"FileFullName":"202507011447140793.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202507/01/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-07-01T14:47:14","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202507/01/202507011447140793.jpg"}] 2026-01-28 10:28:32 [50] ERROR lp.shop.core.LogBase [{"FileResourceId":"13c1fb71-a1e0-40f3-b3e4-05472ab19036"}] [{"id":"13c1fb71-a1e0-40f3-b3e4-05472ab19036","FileType":1,"FileFullName":"202112221153471851.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/22/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-22T11:53:47","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/22/202112221153471851.jpg"}] 2026-01-28 10:28:32 [66] ERROR lp.shop.core.LogBase [{"FileResourceId":"cb0f28aa-3d7c-434d-a7d5-3de0657a7f7c"}] [{"id":"cb0f28aa-3d7c-434d-a7d5-3de0657a7f7c","FileType":1,"FileFullName":"202303210208548083.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202303/21/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-03-21T02:08:55","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202303/21/202303210208548083.jpg"}] 2026-01-28 10:28:32 [77] ERROR lp.shop.core.LogBase [{"FileResourceId":"62984bbe-d3a0-4a49-9f4f-2a2c5d61b9b0"}] [{"id":"62984bbe-d3a0-4a49-9f4f-2a2c5d61b9b0","FileType":1,"FileFullName":"202112221008450034.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/22/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-22T10:08:45","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/22/202112221008450034.jpg"}] 2026-01-28 10:28:32 [78] ERROR lp.shop.core.LogBase [{"FileResourceId":"b24a72c9-73c5-46d5-b80b-ab5dd8a01380"}] [{"id":"b24a72c9-73c5-46d5-b80b-ab5dd8a01380","FileType":1,"FileFullName":"202112221006470386.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/22/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-22T10:06:47","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/22/202112221006470386.jpg"}] 2026-01-28 10:28:32 [84] ERROR lp.shop.core.LogBase [{"FileResourceId":"6ccfaa05-d084-459d-ba07-4fd3a8e13c48"}] [{"id":"6ccfaa05-d084-459d-ba07-4fd3a8e13c48","FileType":1,"FileFullName":"202304131548076157.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202304/13/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-04-13T15:48:08","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202304/13/202304131548076157.jpg"}] 2026-01-28 10:28:43 [92] 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='' LEFT JOIN system_stored o on o.id='' where 1=1 and a.is_up=1 and a.programmeno is not null and a.programmenotype =0 order by a.createdate desc limit 0,99999 2026-01-28 10:28:45 [92] ERROR lp.shop.core.LogBase [{"FileResourceId":"bf9510e7-3308-49b6-b682-1fe963c0ea72"}] [{"id":"bf9510e7-3308-49b6-b682-1fe963c0ea72","FileType":1,"FileFullName":"202304131543591047.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202304/13/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-04-13T15:43:59","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202304/13/202304131543591047.jpg"}] 2026-01-28 10:28:45 [50] ERROR lp.shop.core.LogBase [{"FileResourceId":"49c358bd-1977-4e8a-b492-351b5a429142"}] [{"id":"49c358bd-1977-4e8a-b492-351b5a429142","FileType":1,"FileFullName":"202304131546201654.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202304/13/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-04-13T15:46:20","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202304/13/202304131546201654.jpg"}] 2026-01-28 10:28:45 [77] ERROR lp.shop.core.LogBase [{"FileResourceId":"e9dd6a28-cb10-4cc6-a67c-6f1a5c3d2606"}] [{"id":"e9dd6a28-cb10-4cc6-a67c-6f1a5c3d2606","FileType":1,"FileFullName":"202304131529315340.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202304/13/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-04-13T15:29:32","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202304/13/202304131529315340.jpg"}] 2026-01-28 10:28:45 [82] ERROR lp.shop.core.LogBase [{"FileResourceId":"b9ae91fe-d952-48a4-bfaa-4343bd6926b0"}] [{"id":"b9ae91fe-d952-48a4-bfaa-4343bd6926b0","FileType":1,"FileFullName":"202304131530429011.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202304/13/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-04-13T15:30:43","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202304/13/202304131530429011.jpg"}] 2026-01-28 10:28:45 [73] ERROR lp.shop.core.LogBase [{"FileResourceId":"f77d8dae-8fa6-4790-8679-56de72884de2"}] [{"id":"f77d8dae-8fa6-4790-8679-56de72884de2","FileType":1,"FileFullName":"202304131545196458.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202304/13/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-04-13T15:45:20","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202304/13/202304131545196458.jpg"}] 2026-01-28 10:28:45 [78] ERROR lp.shop.core.LogBase [{"FileResourceId":"6ccfaa05-d084-459d-ba07-4fd3a8e13c48"}] [{"id":"6ccfaa05-d084-459d-ba07-4fd3a8e13c48","FileType":1,"FileFullName":"202304131548076157.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202304/13/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-04-13T15:48:08","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202304/13/202304131548076157.jpg"}] 2026-01-28 10:28:45 [84] ERROR lp.shop.core.LogBase [{"FileResourceId":"c89dffc5-1cd2-44a9-a20e-f030a10eb4c7"}] [{"id":"c89dffc5-1cd2-44a9-a20e-f030a10eb4c7","FileType":1,"FileFullName":"202304131526030143.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202304/13/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-04-13T15:26:03","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202304/13/202304131526030143.jpg"}] 2026-01-28 10:28:45 [50] ERROR lp.shop.core.LogBase [{"FileResourceId":"14a9e214-f7dd-40ef-a310-e14390e36340"}] [{"id":"14a9e214-f7dd-40ef-a310-e14390e36340","FileType":1,"FileFullName":"202304131526277018.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202304/13/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-04-13T15:26:28","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202304/13/202304131526277018.jpg"}] 2026-01-28 10:28:45 [77] ERROR lp.shop.core.LogBase [{"FileResourceId":"c1b108f6-beae-49ac-974c-9ab4c7ca80a4"}] [{"id":"c1b108f6-beae-49ac-974c-9ab4c7ca80a4","FileType":1,"FileFullName":"202304131519406158.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202304/13/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-04-13T15:19:41","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202304/13/202304131519406158.jpg"}] 2026-01-28 10:28:45 [73] ERROR lp.shop.core.LogBase [{"FileResourceId":"65f1c828-4200-4959-ace1-63e313ea4b8c"}] [{"id":"65f1c828-4200-4959-ace1-63e313ea4b8c","FileType":1,"FileFullName":"202304131512553924.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202304/13/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-04-13T15:12:55","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202304/13/202304131512553924.jpg"}] 2026-01-28 10:28:45 [66] ERROR lp.shop.core.LogBase [{"FileResourceId":"0791c35e-0419-4dda-a4cc-5fc146aa0a72"}] [{"id":"0791c35e-0419-4dda-a4cc-5fc146aa0a72","FileType":1,"FileFullName":"202410291127550192.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:27:55","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291127550192.jpg"}] 2026-01-28 10:28:45 [78] ERROR lp.shop.core.LogBase [{"FileResourceId":"02915ded-94d7-4455-90c8-af77c478d0e5"}] [{"id":"02915ded-94d7-4455-90c8-af77c478d0e5","FileType":1,"FileFullName":"202410291130238935.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:30:24","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291130238935.jpg"}] 2026-01-28 10:28:45 [82] ERROR lp.shop.core.LogBase [{"FileResourceId":"dc43edb4-fc1f-4589-a4c5-0097105e237f"}] [{"id":"dc43edb4-fc1f-4589-a4c5-0097105e237f","FileType":1,"FileFullName":"202410291127552692.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:27:55","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291127552692.jpg"}] 2026-01-28 10:28:45 [92] ERROR lp.shop.core.LogBase [{"FileResourceId":"02915ded-94d7-4455-90c8-af77c478d0e5"}] [{"id":"02915ded-94d7-4455-90c8-af77c478d0e5","FileType":1,"FileFullName":"202410291130238935.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:30:24","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291130238935.jpg"}] 2026-01-28 10:28:45 [50] ERROR lp.shop.core.LogBase [{"FileResourceId":"02915ded-94d7-4455-90c8-af77c478d0e5"}] [{"id":"02915ded-94d7-4455-90c8-af77c478d0e5","FileType":1,"FileFullName":"202410291130238935.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:30:24","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291130238935.jpg"}] 2026-01-28 10:28:45 [77] ERROR lp.shop.core.LogBase [{"FileResourceId":"e09f5224-f972-43ab-bf94-c2be0cda6903"}] [{"id":"e09f5224-f972-43ab-bf94-c2be0cda6903","FileType":1,"FileFullName":"202410291127554723.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:27:55","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291127554723.jpg"}] 2026-01-28 10:28:45 [88] ERROR lp.shop.core.LogBase [{"FileResourceId":"27e56f42-cd1e-40f7-984f-13b4dbcd1600"}] [{"id":"27e56f42-cd1e-40f7-984f-13b4dbcd1600","FileType":1,"FileFullName":"202410291127557067.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:27:56","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291127557067.jpg"}] 2026-01-28 10:28:45 [66] ERROR lp.shop.core.LogBase [{"FileResourceId":"02915ded-94d7-4455-90c8-af77c478d0e5"}] [{"id":"02915ded-94d7-4455-90c8-af77c478d0e5","FileType":1,"FileFullName":"202410291130238935.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:30:24","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291130238935.jpg"}] 2026-01-28 10:28:45 [78] ERROR lp.shop.core.LogBase [{"FileResourceId":"2b242d8c-6c6b-4be1-83b5-595cbfb2d53b"}] [{"id":"2b242d8c-6c6b-4be1-83b5-595cbfb2d53b","FileType":1,"FileFullName":"202410291130208466.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:30:21","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291130208466.jpg"}] 2026-01-28 10:28:45 [73] ERROR lp.shop.core.LogBase [{"FileResourceId":"4468c919-6fe2-4c58-ba96-7e3c7e17fc20"}] [{"id":"4468c919-6fe2-4c58-ba96-7e3c7e17fc20","FileType":1,"FileFullName":"202410291128015045.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:28:02","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291128015045.jpg"}] 2026-01-28 10:28:45 [82] ERROR lp.shop.core.LogBase [{"FileResourceId":"a23c7949-31c6-4c59-9e54-23e352db115c"}] [{"id":"a23c7949-31c6-4c59-9e54-23e352db115c","FileType":1,"FileFullName":"202410291129431433.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:29:43","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291129431433.jpg"}] 2026-01-28 10:28:45 [92] ERROR lp.shop.core.LogBase [{"FileResourceId":"dede2eab-626f-41b4-9073-75a2412d73ba"}] [{"id":"dede2eab-626f-41b4-9073-75a2412d73ba","FileType":1,"FileFullName":"202410291130247841.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:30:25","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291130247841.jpg"}] 2026-01-28 10:28:45 [77] ERROR lp.shop.core.LogBase [{"FileResourceId":"1914135b-c884-489b-a064-31e5daef360f"}] [{"id":"1914135b-c884-489b-a064-31e5daef360f","FileType":1,"FileFullName":"202410291130220185.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:30:22","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291130220185.jpg"}] 2026-01-28 10:28:45 [88] ERROR lp.shop.core.LogBase [{"FileResourceId":"6e05109e-c4e9-40fc-9072-fe8cb97503bf"}] [{"id":"6e05109e-c4e9-40fc-9072-fe8cb97503bf","FileType":1,"FileFullName":"202410291130255498.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:30:26","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291130255498.jpg"}] 2026-01-28 10:28:45 [73] ERROR lp.shop.core.LogBase [{"FileResourceId":"a24705ff-b1cb-46ec-88c2-954e4fe42be1"}] [{"id":"a24705ff-b1cb-46ec-88c2-954e4fe42be1","FileType":1,"FileFullName":"202410291127525348.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:27:53","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291127525348.jpg"}] 2026-01-28 10:28:45 [66] ERROR lp.shop.core.LogBase [{"FileResourceId":"51aeee98-585f-4ee3-b6d8-f4596d7df966"}] [{"id":"51aeee98-585f-4ee3-b6d8-f4596d7df966","FileType":1,"FileFullName":"202410291127545192.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:27:55","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291127545192.jpg"}] 2026-01-28 10:28:45 [73] ERROR lp.shop.core.LogBase [{"FileResourceId":"ef2df317-d5be-4016-90c9-ea0274b1967a"}] [{"id":"ef2df317-d5be-4016-90c9-ea0274b1967a","FileType":1,"FileFullName":"202410291127543005.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:27:54","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291127543005.jpg"}] 2026-01-28 10:28:45 [50] ERROR lp.shop.core.LogBase [{"FileResourceId":"6e05109e-c4e9-40fc-9072-fe8cb97503bf"}] [{"id":"6e05109e-c4e9-40fc-9072-fe8cb97503bf","FileType":1,"FileFullName":"202410291130255498.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:30:26","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291130255498.jpg"}] 2026-01-28 10:28:45 [78] ERROR lp.shop.core.LogBase [{"FileResourceId":"8a7e2ff9-468d-4672-8d27-080f0102d728"}] [{"id":"8a7e2ff9-468d-4672-8d27-080f0102d728","FileType":1,"FileFullName":"202410291128029537.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:28:03","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291128029537.jpg"}] 2026-01-28 10:28:45 [82] ERROR lp.shop.core.LogBase [{"FileResourceId":"dede2eab-626f-41b4-9073-75a2412d73ba"}] [{"id":"dede2eab-626f-41b4-9073-75a2412d73ba","FileType":1,"FileFullName":"202410291130247841.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:30:25","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291130247841.jpg"}] 2026-01-28 10:29:07 [50] ERROR lp.shop.core.LogBase [{"FileResourceId":"f67aadb5-0c92-4b6d-9e71-08fc026743ea"}] [{"id":"f67aadb5-0c92-4b6d-9e71-08fc026743ea","FileType":1,"FileFullName":"202112281141102351.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-28T11:41:10","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/28/202112281141102351.jpg"}] 2026-01-28 10:29:07 [82] ERROR lp.shop.core.LogBase [{"FileResourceId":"ddac28a0-9f57-4fe7-ab77-274e37ced82b"}] [{"id":"ddac28a0-9f57-4fe7-ab77-274e37ced82b","FileType":1,"FileFullName":"202112281130488446.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-28T11:30:49","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/28/202112281130488446.jpg"}] 2026-01-28 10:29:08 [92] ERROR lp.shop.core.LogBase [{"FileResourceId":"b8bf5ac8-df12-4270-a044-a948feeeb8a9"}] [{"id":"b8bf5ac8-df12-4270-a044-a948feeeb8a9","FileType":1,"FileFullName":"202401021007488015.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202401/02/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-01-02T10:07:49","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202401/02/202401021007488015.jpg"}] 2026-01-28 10:29:08 [78] ERROR lp.shop.core.LogBase [{"FileResourceId":"ced25d11-7224-4992-b5d8-850fe72422b0"}] [{"id":"ced25d11-7224-4992-b5d8-850fe72422b0","FileType":1,"FileFullName":"202306261046395029.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202306/26/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-06-26T10:46:40","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202306/26/202306261046395029.jpg"}] 2026-01-28 10:29:08 [66] ERROR lp.shop.core.LogBase [{"FileResourceId":"ecd4644a-41f9-4f5f-9b17-29cbab742c9a"}] [{"id":"ecd4644a-41f9-4f5f-9b17-29cbab742c9a","FileType":1,"FileFullName":"202111291416210062.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202111/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-11-29T14:16:21","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202111/29/202111291416210062.jpg"}] 2026-01-28 10:29:08 [77] ERROR lp.shop.core.LogBase [{"FileResourceId":"18a6ab00-ce04-4085-ae2c-9fc31bae2a56"}] [{"id":"18a6ab00-ce04-4085-ae2c-9fc31bae2a56","FileType":1,"FileFullName":"202306281538097453.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202306/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-06-28T15:38:10","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202306/28/202306281538097453.jpg"}] 2026-01-28 10:29:12 [82] 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 ='20000' and a.stored_id ='202109111029036163' and f.typeid ='d0560793-381b-418d-8afe-bafeb7489d78' and FIND_IN_SET('5b40d236-23df-4394-b88e-777830ae6cfb',f.categoryid) group by a.spuid order by createdate desc limit 0,12 2026-01-28 10:29:12 [50] ERROR lp.shop.core.LogBase [{"FileResourceId":"259b44dc-5cd5-4cce-a323-60625dbbf4e9"}] [{"id":"259b44dc-5cd5-4cce-a323-60625dbbf4e9","FileType":1,"FileFullName":"202410291127204724.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:27:20","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291127204724.jpg"}] 2026-01-28 10:29:12 [77] ERROR lp.shop.core.LogBase [{"FileResourceId":"fef91e55-bdee-43c9-94af-a10ac1ca22c9"}] [{"id":"fef91e55-bdee-43c9-94af-a10ac1ca22c9","FileType":1,"FileFullName":"202410291127218942.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:27:22","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291127218942.jpg"}] 2026-01-28 10:29:12 [66] ERROR lp.shop.core.LogBase [{"FileResourceId":"a122cabd-2e18-4a77-b938-214f69c0a811"}] [{"id":"a122cabd-2e18-4a77-b938-214f69c0a811","FileType":1,"FileFullName":"202506301517292456.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T15:17:29","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301517292456.jpg"}] 2026-01-28 10:29:12 [73] ERROR lp.shop.core.LogBase [{"FileResourceId":"2c2a3641-c497-43be-9137-2cb6fd80eab8"}] [{"id":"2c2a3641-c497-43be-9137-2cb6fd80eab8","FileType":1,"FileFullName":"202410291127208318.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:27:21","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291127208318.jpg"}] 2026-01-28 10:29:12 [88] ERROR lp.shop.core.LogBase [{"FileResourceId":"9c6e4659-d225-4bf5-81dc-c9bc308b645d"}] [{"id":"9c6e4659-d225-4bf5-81dc-c9bc308b645d","FileType":1,"FileFullName":"202410291127213005.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:27:21","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291127213005.jpg"}] 2026-01-28 10:29:12 [92] ERROR lp.shop.core.LogBase [{"FileResourceId":"092c1751-d713-4e84-b47a-f6d86947a115"}] [{"id":"092c1751-d713-4e84-b47a-f6d86947a115","FileType":1,"FileFullName":"202507010933570522.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202507/01/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-07-01T09:33:57","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202507/01/202507010933570522.jpg"}] 2026-01-28 10:29:13 [82] ERROR lp.shop.core.LogBase [{"FileResourceId":"aba261a3-e15c-4fa8-b527-8bf126c92fee"}] [{"id":"aba261a3-e15c-4fa8-b527-8bf126c92fee","FileType":1,"FileFullName":"202410291127196130.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:27:20","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291127196130.jpg"}] 2026-01-28 10:29:13 [77] ERROR lp.shop.core.LogBase [{"FileResourceId":"1a60ba88-a96a-4312-a61b-1f7ca8855d52"}] [{"id":"1a60ba88-a96a-4312-a61b-1f7ca8855d52","FileType":1,"FileFullName":"202410291127196911.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:27:20","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291127196911.jpg"}] 2026-01-28 10:29:13 [73] ERROR lp.shop.core.LogBase [{"FileResourceId":"20131ce2-345b-4802-a843-b1209121cc6d"}] [{"id":"20131ce2-345b-4802-a843-b1209121cc6d","FileType":1,"FileFullName":"202506301021244887.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T10:21:24","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301021244887.jpg"}] 2026-01-28 10:29:13 [88] ERROR lp.shop.core.LogBase [{"FileResourceId":"6e01adc9-03df-4bf5-a616-38782c11af65"}] [{"id":"6e01adc9-03df-4bf5-a616-38782c11af65","FileType":1,"FileFullName":"202410291126550339.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:26:55","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291126550339.jpg"}] 2026-01-28 10:29:13 [78] ERROR lp.shop.core.LogBase [{"FileResourceId":"48a8c7af-7a31-4423-917c-0a7a94a10738"}] [{"id":"48a8c7af-7a31-4423-917c-0a7a94a10738","FileType":1,"FileFullName":"202410291127032526.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:27:03","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291127032526.jpg"}] 2026-01-28 10:29:13 [92] ERROR lp.shop.core.LogBase [{"FileResourceId":"bdcd55cf-749d-4d86-b862-ce86db0dfbd0"}] [{"id":"bdcd55cf-749d-4d86-b862-ce86db0dfbd0","FileType":1,"FileFullName":"202410291127030808.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:27:03","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291127030808.jpg"}] 2026-01-28 13:14:40 [70] ERROR lp.shop.core.LogBase 【GetDictionaryList】======System.NullReferenceException: 未将对象引用设置到对象的实例。 在 lp.shop.api.Controllers.app.AppDictionaryController.GetDictionaryList(GetDictionaryListInPut data) 位置 E:\蒋2025\lp_-shop_-hd\lp.shop.api\Controllers\app\AppDictionaryController.cs:行号 85 2026-01-28 13:14:40 [80] ERROR lp.shop.core.LogBase 【GetDictionaryList】======System.NullReferenceException: 未将对象引用设置到对象的实例。 在 lp.shop.api.Controllers.app.AppDictionaryController.GetDictionaryList(GetDictionaryListInPut data) 位置 E:\蒋2025\lp_-shop_-hd\lp.shop.api\Controllers\app\AppDictionaryController.cs:行号 85 2026-01-28 13:20:07 [76] ERROR lp.shop.core.LogBase 【GetDictionaryList】======System.NullReferenceException: 未将对象引用设置到对象的实例。 在 lp.shop.api.Controllers.app.AppDictionaryController.GetDictionaryList(GetDictionaryListInPut data) 位置 E:\蒋2025\lp_-shop_-hd\lp.shop.api\Controllers\app\AppDictionaryController.cs:行号 85