2026-02-09 10:35:02 [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 2026-02-09 11:04:11 [96] 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-02-09 11:04:12 [89] ERROR lp.shop.core.LogBase [{"FileResourceId":"5d9d74f4-ea3d-4d67-b7e4-79bd8cd99313"}] [{"id":"5d9d74f4-ea3d-4d67-b7e4-79bd8cd99313","FileType":1,"FileFullName":"202112281134556816.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-28T11:34:56","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/28/202112281134556816.jpg"}] 2026-02-09 11:04:12 [93] ERROR lp.shop.core.LogBase [{"FileResourceId":"9502da74-8029-4043-b726-f88a4a250be0"}] [{"id":"9502da74-8029-4043-b726-f88a4a250be0","FileType":1,"FileFullName":"202112281220450430.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-28T12:20:45","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/28/202112281220450430.jpg"}] 2026-02-09 11:04:12 [84] ERROR lp.shop.core.LogBase [{"FileResourceId":"6fd89f59-f0f7-4f8f-939e-7281a922fb4c"}] [{"id":"6fd89f59-f0f7-4f8f-939e-7281a922fb4c","FileType":1,"FileFullName":"202112281136038122.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-28T11:36:04","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/28/202112281136038122.jpg"}] 2026-02-09 11:04:12 [90] ERROR lp.shop.core.LogBase [{"FileResourceId":"7c0f7031-0035-4159-a131-b3c1fd4d2a9a"}] [{"id":"7c0f7031-0035-4159-a131-b3c1fd4d2a9a","FileType":1,"FileFullName":"202112281136288903.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-28T11:36:29","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/28/202112281136288903.jpg"}] 2026-02-09 11:04:12 [83] ERROR lp.shop.core.LogBase [{"FileResourceId":"1538710e-677d-415c-a3e2-7f686136b046"}] [{"id":"1538710e-677d-415c-a3e2-7f686136b046","FileType":1,"FileFullName":"202112281137082750.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-28T11:37:08","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/28/202112281137082750.jpg"}] 2026-02-09 11:04:12 [87] ERROR lp.shop.core.LogBase [{"FileResourceId":"66ae563a-3e72-4850-9b31-fba4d657ef5a"}] [{"id":"66ae563a-3e72-4850-9b31-fba4d657ef5a","FileType":1,"FileFullName":"202112281137256344.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-28T11:37:26","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/28/202112281137256344.jpg"}] 2026-02-09 11:04:12 [77] ERROR lp.shop.core.LogBase [{"FileResourceId":"67d44eab-2daa-4e6e-bd0b-1164afaa91fd"}] [{"id":"67d44eab-2daa-4e6e-bd0b-1164afaa91fd","FileType":1,"FileFullName":"202112281137012438.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-28T11:37:01","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/28/202112281137012438.jpg"}] 2026-02-09 11:04:12 [96] ERROR lp.shop.core.LogBase [{"FileResourceId":"94c32d8d-6ccc-485e-88fc-ada0761ed347"}] [{"id":"94c32d8d-6ccc-485e-88fc-ada0761ed347","FileType":1,"FileFullName":"202112281138288288.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-28T11:38:29","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/28/202112281138288288.jpg"}] 2026-02-09 11:04:12 [76] ERROR lp.shop.core.LogBase [{"FileResourceId":"efbda49b-97d2-4ad6-a15d-66fbf82c4e61"}] [{"id":"efbda49b-97d2-4ad6-a15d-66fbf82c4e61","FileType":1,"FileFullName":"202112281139063151.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-28T11:39:06","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/28/202112281139063151.jpg"}] 2026-02-09 11:04:12 [71] ERROR lp.shop.core.LogBase [{"FileResourceId":"28e60878-7162-4908-8913-d849ecec9c18"}] [{"id":"28e60878-7162-4908-8913-d849ecec9c18","FileType":1,"FileFullName":"202112281138499088.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-28T11:38:50","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/28/202112281138499088.jpg"}] 2026-02-09 11:04:12 [86] ERROR lp.shop.core.LogBase [{"FileResourceId":"0be4d4c3-5b5c-4798-9789-de613a21b453"}] [{"id":"0be4d4c3-5b5c-4798-9789-de613a21b453","FileType":1,"FileFullName":"202112281137472663.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202112/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-12-28T11:37:47","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202112/28/202112281137472663.jpg"}] 2026-02-09 11:04:12 [94] 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-02-09 11:04:12 [77] 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-02-09 11:04:12 [91] 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-02-09 11:04:12 [89] 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-02-09 11:04:12 [96] 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-02-09 11:04:12 [87] 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-02-09 11:04:13 [90] 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-02-09 11:04:13 [71] 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-02-09 11:04:13 [83] 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-02-09 11:04:13 [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-02-09 11:04: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-02-09 11:04:13 [76] 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-02-09 11:04:13 [93] 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-02-09 11:04:13 [86] 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-02-09 11:04:13 [94] 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-02-09 11:04:13 [84] 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-02-09 11:04:14 [83] 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-02-09 11:04:14 [77] 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-02-09 11:04:14 [89] 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-02-09 11:04:14 [91] 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-02-09 11:04:14 [96] 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-02-09 11:04:14 [76] 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-02-09 11:04:14 [90] 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-02-09 11:04:14 [87] 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-02-09 11:04:14 [71] 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-02-09 11:04:14 [76] 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-02-09 11:04:14 [93] 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-02-09 11:04:14 [86] 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-02-09 11:04:14 [94] 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-02-09 11:04:14 [90] 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-02-09 11:04:14 [77] 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-02-09 11:04:15 [84] 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-02-09 11:04:15 [96] 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-02-09 11:04:16 [76] 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-02-09 11:04:16 [93] 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-02-09 11:04:17 [86] ERROR lp.shop.core.LogBase [{"FileResourceId":"1a79dee4-12d4-4d65-ab03-ce27cd03db2e"}] [{"id":"1a79dee4-12d4-4d65-ab03-ce27cd03db2e","FileType":1,"FileFullName":"202307061450357757.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202307/06/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-07-06T14:50:36","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202307/06/202307061450357757.jpg"}] 2026-02-09 11:04:17 [90] ERROR lp.shop.core.LogBase [{"FileResourceId":"fa95cd68-c14f-4e52-af74-0346cb9ed2f2"}] [{"id":"fa95cd68-c14f-4e52-af74-0346cb9ed2f2","FileType":1,"FileFullName":"202401020944081178.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202401/02/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-01-02T09:44:08","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202401/02/202401020944081178.jpg"}] 2026-02-09 11:04:17 [83] ERROR lp.shop.core.LogBase [{"FileResourceId":"3e856a1a-da5e-4bee-8c30-86c50812051f"}] [{"id":"3e856a1a-da5e-4bee-8c30-86c50812051f","FileType":1,"FileFullName":"202306281807362942.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202306/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-06-28T18:07:36","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202306/28/202306281807362942.jpg"}] 2026-02-09 11:04:18 [77] ERROR lp.shop.core.LogBase [{"FileResourceId":"a9ef0f11-f896-4eb7-9d20-b8992d1f01cc"}] [{"id":"a9ef0f11-f896-4eb7-9d20-b8992d1f01cc","FileType":1,"FileFullName":"202208252118471300.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202208/25/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2022-08-25T21:18:47","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202208/25/202208252118471300.jpg"}] 2026-02-09 11:04:18 [71] ERROR lp.shop.core.LogBase [{"FileResourceId":"e8b1bafe-5015-4f83-a123-6bd1700d2f71"}] [{"id":"e8b1bafe-5015-4f83-a123-6bd1700d2f71","FileType":1,"FileFullName":"202306271129467149.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202306/27/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-06-27T11:29:47","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202306/27/202306271129467149.jpg"}] 2026-02-09 11:04:18 [84] ERROR lp.shop.core.LogBase [{"FileResourceId":"f679cb36-2f6b-4783-af93-ab95f510aa94"}] [{"id":"f679cb36-2f6b-4783-af93-ab95f510aa94","FileType":1,"FileFullName":"202306281607547211.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202306/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-06-28T16:07:55","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202306/28/202306281607547211.jpg"}] 2026-02-09 11:04:18 [96] ERROR lp.shop.core.LogBase [{"FileResourceId":"87134f8b-10d4-49e6-9c06-b1520cb040cc"}] [{"id":"87134f8b-10d4-49e6-9c06-b1520cb040cc","FileType":1,"FileFullName":"202111291446405200.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202111/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-11-29T14:46:41","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202111/29/202111291446405200.jpg"}] 2026-02-09 11:04:18 [76] ERROR lp.shop.core.LogBase [{"FileResourceId":"9061850e-8fae-4736-aac8-ad0796e70083"}] [{"id":"9061850e-8fae-4736-aac8-ad0796e70083","FileType":1,"FileFullName":"202108241600034784.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202108/24/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2021-08-24T16:00:03","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202108/24/202108241600034784.jpg"}] 2026-02-09 11:04:18 [93] ERROR lp.shop.core.LogBase [{"FileResourceId":"8f83b6a9-b631-4add-a431-efdb93ff3d11"}] [{"id":"8f83b6a9-b631-4add-a431-efdb93ff3d11","FileType":1,"FileFullName":"202206271155057494.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202206/27/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2022-06-27T11:55:06","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202206/27/202206271155057494.jpg"}] 2026-02-09 11:04:19 [94] ERROR lp.shop.core.LogBase [{"FileResourceId":"ed09457e-0353-43a9-9cbc-1fa34d238b93"}] [{"id":"ed09457e-0353-43a9-9cbc-1fa34d238b93","FileType":1,"FileFullName":"202306281350285264.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202306/28/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-06-28T13:50:29","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202306/28/202306281350285264.jpg"}] 2026-02-09 11:04:20 [77] 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 ='cc6e8dc2-875f-4ef3-835c-61bc59081124' and FIND_IN_SET('3a24265b-7ec3-442a-ae4c-473211d8c064',f.categoryid) group by a.spuid order by createdate desc limit 0,12 2026-02-09 11:04:20 [76] ERROR lp.shop.core.LogBase [{"FileResourceId":"bc2c9b89-b45d-44e9-8e80-a6ec53cedf07"}] [{"id":"bc2c9b89-b45d-44e9-8e80-a6ec53cedf07","FileType":1,"FileFullName":"202410291130342714.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:30:34","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291130342714.jpg"}] 2026-02-09 11:04:20 [96] ERROR lp.shop.core.LogBase [{"FileResourceId":"7a4959aa-a228-4ef6-8f95-65d3c717cefd"}] [{"id":"7a4959aa-a228-4ef6-8f95-65d3c717cefd","FileType":1,"FileFullName":"202410291130344433.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:30:34","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291130344433.jpg"}] 2026-02-09 11:04:20 [93] ERROR lp.shop.core.LogBase [{"FileResourceId":"f1e928fc-21b7-47d5-942b-ec128675715c"}] [{"id":"f1e928fc-21b7-47d5-942b-ec128675715c","FileType":1,"FileFullName":"202410291130343652.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:30:34","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291130343652.jpg"}] 2026-02-09 11:04:20 [86] ERROR lp.shop.core.LogBase [{"FileResourceId":"96b0055c-a666-4c0f-9c0a-9304ebddb933"}] [{"id":"96b0055c-a666-4c0f-9c0a-9304ebddb933","FileType":1,"FileFullName":"202410291130347089.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:30:35","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291130347089.jpg"}] 2026-02-09 11:04:20 [94] ERROR lp.shop.core.LogBase [{"FileResourceId":"00766ac7-4750-434c-8534-2db32582e450"}] [{"id":"00766ac7-4750-434c-8534-2db32582e450","FileType":1,"FileFullName":"202410291130346152.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202410/29/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-10-29T11:30:35","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202410/29/202410291130346152.jpg"}] 2026-02-09 11:04:20 [90] ERROR lp.shop.core.LogBase [{"FileResourceId":"eb3fb6b1-ac2b-4588-8fec-71f2f577a0d4"}] [{"id":"eb3fb6b1-ac2b-4588-8fec-71f2f577a0d4","FileType":1,"FileFullName":"202506301120525027.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202506/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2025-06-30T11:20:53","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202506/30/202506301120525027.jpg"}] 2026-02-09 11:04:20 [84] ERROR lp.shop.core.LogBase [{"FileResourceId":"cd562c9a-8fc6-4043-b6a5-6745e080afeb"}] [{"id":"cd562c9a-8fc6-4043-b6a5-6745e080afeb","FileType":1,"FileFullName":"202401172055182954.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202401/17/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-01-17T20:55:18","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202401/17/202401172055182954.jpg"}] 2026-02-09 11:04:20 [77] ERROR lp.shop.core.LogBase [{"FileResourceId":"b13f6c85-735d-4c60-a67f-b9e3550df059"}] [{"id":"b13f6c85-735d-4c60-a67f-b9e3550df059","FileType":1,"FileFullName":"202401172055181079.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202401/17/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-01-17T20:55:18","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202401/17/202401172055181079.jpg"}] 2026-02-09 11:04:20 [91] ERROR lp.shop.core.LogBase [{"FileResourceId":"766dc1ee-a657-48c7-b537-9218394f5b9d"}] [{"id":"766dc1ee-a657-48c7-b537-9218394f5b9d","FileType":1,"FileFullName":"202401020959193259.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202401/02/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-01-02T09:59:19","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202401/02/202401020959193259.jpg"}] 2026-02-09 11:04:20 [76] ERROR lp.shop.core.LogBase [{"FileResourceId":"d0c45142-65fe-46ed-96f3-53999e301d83"}] [{"id":"d0c45142-65fe-46ed-96f3-53999e301d83","FileType":1,"FileFullName":"202401172055184829.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202401/17/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-01-17T20:55:18","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202401/17/202401172055184829.jpg"}] 2026-02-09 11:04:20 [87] ERROR lp.shop.core.LogBase [{"FileResourceId":"e1c217ac-86a9-4b8a-840d-25e1d57ddcf8"}] [{"id":"e1c217ac-86a9-4b8a-840d-25e1d57ddcf8","FileType":1,"FileFullName":"202401020958166948.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202401/02/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-01-02T09:58:17","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202401/02/202401020958166948.jpg"}] 2026-02-09 11:04:20 [93] ERROR lp.shop.core.LogBase [{"FileResourceId":"669a56a8-2894-4256-a491-65c0309b15ab"}] [{"id":"669a56a8-2894-4256-a491-65c0309b15ab","FileType":1,"FileFullName":"202306271653259416.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202306/27/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-06-27T16:53:26","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202306/27/202306271653259416.jpg"}] 2026-02-09 11:04:22 [83] 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 ='cc6e8dc2-875f-4ef3-835c-61bc59081124' and FIND_IN_SET('3a24265b-7ec3-442a-ae4c-473211d8c064',f.categoryid) group by a.spuid order by createdate desc limit 12,12 2026-02-09 11:04:23 [86] ERROR lp.shop.core.LogBase [{"FileResourceId":"3ed0acc2-58ea-44d7-94b8-d26c5dae9f03"}] [{"id":"3ed0acc2-58ea-44d7-94b8-d26c5dae9f03","FileType":1,"FileFullName":"202311201133592470.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202311/20/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-11-20T11:33:59","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202311/20/202311201133592470.jpg"}] 2026-02-09 11:04:23 [84] ERROR lp.shop.core.LogBase [{"FileResourceId":"d2a057a7-2fb7-4357-a761-449873ab406f"}] [{"id":"d2a057a7-2fb7-4357-a761-449873ab406f","FileType":1,"FileFullName":"202306271054568225.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202306/27/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-06-27T10:54:57","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202306/27/202306271054568225.jpg"}] 2026-02-09 11:04:23 [94] ERROR lp.shop.core.LogBase [{"FileResourceId":"29fc99dc-6e79-4441-8e81-54ff06562c16"}] [{"id":"29fc99dc-6e79-4441-8e81-54ff06562c16","FileType":1,"FileFullName":"202310301003266475.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/uploadstream/202310/30/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-10-30T10:03:27","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/uploadstream/202310/30/202310301003266475.jpg"}] 2026-02-09 11:04:23 [87] ERROR lp.shop.core.LogBase [{"FileResourceId":"9a388109-ed5f-4f74-aae6-bf613989ac6f"}] [{"id":"9a388109-ed5f-4f74-aae6-bf613989ac6f","FileType":1,"FileFullName":"202311201131173251.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202311/20/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-11-20T11:31:17","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202311/20/202311201131173251.jpg"}] 2026-02-09 11:04:23 [89] ERROR lp.shop.core.LogBase [{"FileResourceId":"c1b9106d-5ba5-4104-b683-f8028daaddb0"}] [{"id":"c1b9106d-5ba5-4104-b683-f8028daaddb0","FileType":1,"FileFullName":"202306271059118791.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202306/27/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-06-27T10:59:12","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202306/27/202306271059118791.jpg"}] 2026-02-09 11:04:23 [93] ERROR lp.shop.core.LogBase [{"FileResourceId":"aeb15b65-c1b2-426a-83ca-4fc4f5186574"}] [{"id":"aeb15b65-c1b2-426a-83ca-4fc4f5186574","FileType":1,"FileFullName":"202306271653042316.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202306/27/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-06-27T16:53:04","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202306/27/202306271653042316.jpg"}] 2026-02-09 11:04:23 [71] ERROR lp.shop.core.LogBase [{"FileResourceId":"a086cc72-bf8c-4c55-a025-7973a9bd0c3e"}] [{"id":"a086cc72-bf8c-4c55-a025-7973a9bd0c3e","FileType":1,"FileFullName":"202306271648457892.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202306/27/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-06-27T16:48:46","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202306/27/202306271648457892.jpg"}] 2026-02-09 11:04:23 [90] ERROR lp.shop.core.LogBase [{"FileResourceId":"cf5635da-1096-4aea-ad63-aa1eed9116a6"}] [{"id":"cf5635da-1096-4aea-ad63-aa1eed9116a6","FileType":1,"FileFullName":"202306271650096232.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202306/27/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-06-27T16:50:10","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202306/27/202306271650096232.jpg"}] 2026-02-09 11:04:23 [77] ERROR lp.shop.core.LogBase [{"FileResourceId":"87a8ba5a-da6e-4e46-8386-da573156ef82"}] [{"id":"87a8ba5a-da6e-4e46-8386-da573156ef82","FileType":1,"FileFullName":"202306271648254689.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202306/27/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-06-27T16:48:25","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202306/27/202306271648254689.jpg"}] 2026-02-09 11:04:23 [83] ERROR lp.shop.core.LogBase [{"FileResourceId":"31d8f56b-1b79-435c-8878-0396f8e91246"}] [{"id":"31d8f56b-1b79-435c-8878-0396f8e91246","FileType":1,"FileFullName":"202306271647584377.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202306/27/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-06-27T16:47:58","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202306/27/202306271647584377.jpg"}] 2026-02-09 11:04:23 [84] ERROR lp.shop.core.LogBase [{"FileResourceId":"87980e4b-d868-4ed9-90b6-85e253655f5c"}] [{"id":"87980e4b-d868-4ed9-90b6-85e253655f5c","FileType":1,"FileFullName":"202306271647404610.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202306/27/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-06-27T16:47:40","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202306/27/202306271647404610.jpg"}] 2026-02-09 11:04:23 [86] ERROR lp.shop.core.LogBase [{"FileResourceId":"e924a4d9-0035-4404-9068-0768227bdb82"}] [{"id":"e924a4d9-0035-4404-9068-0768227bdb82","FileType":1,"FileFullName":"202306271647156329.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202306/27/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-06-27T16:47:16","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202306/27/202306271647156329.jpg"}] 2026-02-09 11:04:31 [86] 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 ='281d832c-f2fd-4f6b-930e-0e3cb3be83a4' group by a.spuid order by createdate desc limit 0,10 2026-02-09 11:04:32 [76] ERROR lp.shop.core.LogBase [{"FileResourceId":"780b31e6-1dfb-45d4-b86d-bfe27b0eccb9"},{"FileResourceId":"1709c041-4487-4268-915e-8db42ef70931"},{"FileResourceId":"4712da4a-21ae-435f-95b1-c914b3945a23"},{"FileResourceId":"8345b25e-3514-460e-b23d-7fff4645d514"},{"FileResourceId":"8f3eb2a1-7355-4da5-bc63-669802417de6"}] [{"id":"780b31e6-1dfb-45d4-b86d-bfe27b0eccb9","FileType":1,"FileFullName":"202204061015229691.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202204/06/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2022-04-06T10:15:23","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202204/06/202204061015229691.jpg"},{"id":"1709c041-4487-4268-915e-8db42ef70931","FileType":1,"FileFullName":"202204061015229847.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202204/06/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2022-04-06T10:15:23","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202204/06/202204061015229847.jpg"},{"id":"4712da4a-21ae-435f-95b1-c914b3945a23","FileType":1,"FileFullName":"202204061015230159.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202204/06/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2022-04-06T10:15:23","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202204/06/202204061015230159.jpg"},{"id":"8345b25e-3514-460e-b23d-7fff4645d514","FileType":1,"FileFullName":"202311201355063701.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202311/20/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-11-20T13:55:06","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202311/20/202311201355063701.jpg"},{"id":"8f3eb2a1-7355-4da5-bc63-669802417de6","FileType":1,"FileFullName":"202311201355064013.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202311/20/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-11-20T13:55:06","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202311/20/202311201355064013.jpg"}] 2026-02-09 11:04:32 [96] 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='281d832c-f2fd-4f6b-930e-0e3cb3be83a4' 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='dca989d4-ccc9-4eba-bb16-fd6a7403e119' and s.spuid='281d832c-f2fd-4f6b-930e-0e3cb3be83a4' and s.spuid='281d832c-f2fd-4f6b-930e-0e3cb3be83a4' group by s.id order by s.createdate DESC limit 0,1 2026-02-09 11:04:32 [71] 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'%GN112%' order by createdate desc limit 0,999 2026-02-09 11:04:33 [83] ERROR lp.shop.core.LogBase [{"FileResourceId":"309eb407-2bef-48aa-bd8a-62878d335b1a"},{"FileResourceId":"b47c006f-cc77-4a9d-b2e1-a60df642b4ad"},{"FileResourceId":"d599bab3-58fd-4fe6-b667-1caeb9f927f1"},{"FileResourceId":"72fe00d3-0fbe-439c-b63f-25f8510425fe"},{"FileResourceId":"b9f84f76-5cc5-4504-976c-50354cc75444"},{"FileResourceId":"b614f307-c491-43b8-b9a8-e65fb3f81e31"},{"FileResourceId":"b3d392bd-f8a2-414e-a11c-116730b913d0"},{"FileResourceId":"5a910b58-c3dd-4d99-86d5-677f201affce"},{"FileResourceId":"92645034-a9ce-4f99-92aa-3c586cdf0055"}] [{"id":"309eb407-2bef-48aa-bd8a-62878d335b1a","FileType":1,"FileFullName":"202311201354038789.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202311/20/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-11-20T13:54:04","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202311/20/202311201354038789.jpg"},{"id":"b47c006f-cc77-4a9d-b2e1-a60df642b4ad","FileType":1,"FileFullName":"202311201354038321.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202311/20/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-11-20T13:54:04","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202311/20/202311201354038321.jpg"},{"id":"d599bab3-58fd-4fe6-b667-1caeb9f927f1","FileType":1,"FileFullName":"202311201354039101.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202311/20/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-11-20T13:54:04","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202311/20/202311201354039101.jpg"},{"id":"72fe00d3-0fbe-439c-b63f-25f8510425fe","FileType":1,"FileFullName":"202311201354039414.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202311/20/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-11-20T13:54:04","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202311/20/202311201354039414.jpg"},{"id":"b9f84f76-5cc5-4504-976c-50354cc75444","FileType":1,"FileFullName":"202311201354040195.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202311/20/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-11-20T13:54:04","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202311/20/202311201354040195.jpg"},{"id":"b614f307-c491-43b8-b9a8-e65fb3f81e31","FileType":1,"FileFullName":"202311201354039727.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202311/20/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-11-20T13:54:04","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202311/20/202311201354039727.jpg"},{"id":"b3d392bd-f8a2-414e-a11c-116730b913d0","FileType":1,"FileFullName":"202311201354040977.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202311/20/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-11-20T13:54:04","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202311/20/202311201354040977.jpg"},{"id":"5a910b58-c3dd-4d99-86d5-677f201affce","FileType":1,"FileFullName":"202311201354040508.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202311/20/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-11-20T13:54:04","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202311/20/202311201354040508.jpg"},{"id":"92645034-a9ce-4f99-92aa-3c586cdf0055","FileType":1,"FileFullName":"202307211116476773.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202307/21/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2023-07-21T11:16:48","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202307/21/202307211116476773.jpg"}] 2026-02-09 11:04:33 [91] 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 ='281d832c-f2fd-4f6b-930e-0e3cb3be83a4' and a.enable ='1' order by a.createdate desc limit 0,10 2026-02-09 11:04:33 [84] 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 ='281d832c-f2fd-4f6b-930e-0e3cb3be83a4' and a.enable ='1' order by a.createdate desc limit 0,10 2026-02-09 11:04:33 [87] 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='281d832c-f2fd-4f6b-930e-0e3cb3be83a4' and a.status='1' order by a.createdate desc limit 0,10 2026-02-09 11:04:33 [89] 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'%GN112%' order by model ASC limit 0,8 2026-02-09 11:04:33 [76] 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 ='62a579e9-ad8e-48bf-8cab-426ac9387c8c' group by a.spuid order by createdate desc limit 0,6 2026-02-09 11:04:33 [77] ERROR lp.shop.core.LogBase [{"FileResourceId":"e806786c-e607-4e52-95c2-575a677db5ae"}] [{"id":"e806786c-e607-4e52-95c2-575a677db5ae","FileType":1,"FileFullName":"202210311654330088.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202210/31/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2022-10-31T16:54:33","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202210/31/202210311654330088.jpg"}] 2026-02-09 11:04:34 [71] ERROR lp.shop.core.LogBase [{"FileResourceId":"5313cc44-5deb-4406-977c-f770210d7597"}] [{"id":"5313cc44-5deb-4406-977c-f770210d7597","FileType":1,"FileFullName":"202210311643536301.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202210/31/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2022-10-31T16:43:54","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202210/31/202210311643536301.jpg"}] 2026-02-09 11:04:34 [83] ERROR lp.shop.core.LogBase [{"FileResourceId":"8d8f7529-ee1d-4849-b599-d9c6d77530d9"}] [{"id":"8d8f7529-ee1d-4849-b599-d9c6d77530d9","FileType":1,"FileFullName":"202210311750330410.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202210/31/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2022-10-31T17:50:33","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202210/31/202210311750330410.jpg"}] 2026-02-09 11:04:34 [91] ERROR lp.shop.core.LogBase [{"FileResourceId":"6aad8553-376b-484c-b0a7-6b279ba95135"}] [{"id":"6aad8553-376b-484c-b0a7-6b279ba95135","FileType":1,"FileFullName":"202210311623572616.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202210/31/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2022-10-31T16:23:57","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202210/31/202210311623572616.jpg"}] 2026-02-09 11:04:34 [84] ERROR lp.shop.core.LogBase [{"FileResourceId":"4fb1605f-daf1-4575-b595-27a75db382ed"}] [{"id":"4fb1605f-daf1-4575-b595-27a75db382ed","FileType":1,"FileFullName":"202401021030045877.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202401/02/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-01-02T10:30:05","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202401/02/202401021030045877.jpg"}] 2026-02-09 11:04:34 [86] ERROR lp.shop.core.LogBase [{"FileResourceId":"8bdf695d-04f5-4c30-8a96-155433aaccce"}] [{"id":"8bdf695d-04f5-4c30-8a96-155433aaccce","FileType":1,"FileFullName":"202401021029336512.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202401/02/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-01-02T10:29:34","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202401/02/202401021029336512.jpg"}] 2026-02-09 11:04:34 [87] ERROR lp.shop.core.LogBase [{"FileResourceId":"43bf1679-cf67-4000-8e0f-43cc138a0c13"}] [{"id":"43bf1679-cf67-4000-8e0f-43cc138a0c13","FileType":1,"FileFullName":"202401021022493139.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202401/02/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-01-02T10:22:49","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202401/02/202401021022493139.jpg"}] 2026-02-09 11:04:34 [93] ERROR lp.shop.core.LogBase [{"FileResourceId":"03e702f6-3c38-41e2-861c-9f853e714bf8"}] [{"id":"03e702f6-3c38-41e2-861c-9f853e714bf8","FileType":1,"FileFullName":"202401021022043110.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202401/02/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-01-02T10:22:04","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202401/02/202401021022043110.jpg"}] 2026-02-09 11:04:34 [89] ERROR lp.shop.core.LogBase [{"FileResourceId":"e517d9fe-6cbf-436d-b081-62eee88c1469"}] [{"id":"e517d9fe-6cbf-436d-b081-62eee88c1469","FileType":1,"FileFullName":"202401021030561053.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202401/02/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-01-02T10:30:56","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202401/02/202401021030561053.jpg"}] 2026-02-09 11:04:34 [96] ERROR lp.shop.core.LogBase [{"FileResourceId":"6df40403-73f5-4fa6-8e50-88ee1e38cbc0"}] [{"id":"6df40403-73f5-4fa6-8e50-88ee1e38cbc0","FileType":1,"FileFullName":"202210311654316963.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202210/31/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2022-10-31T16:54:32","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202210/31/202210311654316963.jpg"}] 2026-02-09 11:04:34 [91] ERROR lp.shop.core.LogBase [{"FileResourceId":"893f4740-b7cc-4b79-b26b-f34d97ca2fff"}] [{"id":"893f4740-b7cc-4b79-b26b-f34d97ca2fff","FileType":1,"FileFullName":"202401021026059838.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202401/02/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2024-01-02T10:26:06","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202401/02/202401021026059838.jpg"}] 2026-02-09 11:04:34 [76] ERROR lp.shop.core.LogBase [{"FileResourceId":"603452cf-aaad-4b47-9192-cf8f06e06b6b"}] [{"id":"603452cf-aaad-4b47-9192-cf8f06e06b6b","FileType":1,"FileFullName":"202210311647350471.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202210/31/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2022-10-31T16:47:35","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202210/31/202210311647350471.jpg"}] 2026-02-09 11:04:34 [94] ERROR lp.shop.core.LogBase [{"FileResourceId":"dbb02d14-9bc9-4588-8988-6ebd6e8d9b92"}] [{"id":"dbb02d14-9bc9-4588-8988-6ebd6e8d9b92","FileType":1,"FileFullName":"202210311857031100.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202210/31/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2022-10-31T18:57:03","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202210/31/202210311857031100.jpg"}] 2026-02-09 11:04:34 [77] ERROR lp.shop.core.LogBase [{"FileResourceId":"2c6cefac-0230-4144-a502-8d5e8e33c23e"}] [{"id":"2c6cefac-0230-4144-a502-8d5e8e33c23e","FileType":1,"FileFullName":"202210311750323691.jpg","FileExtension":"jpg","FileMD5":null,"FileIOPath":"/upload/202210/31/","FileSize":null,"UserId":"10000","Remarks":null,"createdate":"2022-10-31T17:50:32","updateuid":null,"updatedate":null,"FileIoFullPath":"https://shopapi.tsopsoft.com/upload/202210/31/202210311750323691.jpg"}]