2025-02-15 23:59:02 -- == sync_order start == 2025-02-15 23:59:02 -- start:2025-02-15,end:2025-02-15 2025-02-15 23:59:02 -- == select june1.order_list == SELECT l.mid,m.uid,l.category_name,l.category_id,l.ordernumber,l.location,l.payway,l.delivery_way,l.pay_status,l.process_status,l.company_number,l.company_title,l.invoice_status,l.etd,l.web_discount,l.class_discount,l.member_discount,l.web_gift,l.freight,l.entity_discount,l.totalprice,l.orderzip,l.orderaddresscity,l.orderaddressarea,l.recipientzip,l.recipientaddresscity,l.recipientaddressarea,l.totalprice_after-web_discount-class_discount-member_discount-entity_discount as totalprice_after,l.create_date FROM `order_list` l LEFT JOIN member_list m on l.mid = m.id WHERE l.create_date like '2025-02-15%' OR l.modify_date like '2025-02-15%'; 2025-02-15 23:59:03 -- == sync omo_order_list == 2025-02-15 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '450477', process_status = '6', pay_status = '0', totalprice_after = '1080', lunar_date = '2024-12-17', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O25010790997' 2025-02-15 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '431123', process_status = '6', pay_status = '0', totalprice_after = '1890', lunar_date = '2024-12-17', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O25010792811' 2025-02-15 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '450585', process_status = '6', pay_status = '0', totalprice_after = '3960', lunar_date = '2024-12-17', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O25010800029' 2025-02-15 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '450592', process_status = '6', pay_status = '0', totalprice_after = '3000', lunar_date = '2024-12-17', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O25010800864' 2025-02-15 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '450607', process_status = '6', pay_status = '0', totalprice_after = '4600', lunar_date = '2024-12-17', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O25010801799' 2025-02-15 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '450453', process_status = '6', pay_status = '0', totalprice_after = '1080', lunar_date = '2024-12-17', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O25010803080' 2025-02-15 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '450453', process_status = '6', pay_status = '0', totalprice_after = '1110', lunar_date = '2024-12-17', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O25010804678' 2025-02-15 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '330450', process_status = '6', pay_status = '0', totalprice_after = '2235', lunar_date = '2024-12-17', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O25010809689' 2025-02-15 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '450821', process_status = '6', pay_status = '0', totalprice_after = '1590', lunar_date = '2024-12-17', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O25010820982' 2025-02-15 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '450821', process_status = '6', pay_status = '0', totalprice_after = '1560', lunar_date = '2024-12-17', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O25010821571' 2025-02-15 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '450813', process_status = '6', pay_status = '0', totalprice_after = '1340', lunar_date = '2024-12-17', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O25010821693' 2025-02-15 23:59:04 -- == update lake.omo_order_list == update omo_order_list set userId = '450835', process_status = '6', pay_status = '0', totalprice_after = '5550', lunar_date = '2024-12-17', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O25010823191' 2025-02-15 23:59:04 -- == update lake.omo_order_list == update omo_order_list set userId = '450859', process_status = '6', pay_status = '0', totalprice_after = '600', lunar_date = '2024-12-17', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O25010826314' 2025-02-15 23:59:04 -- == update lake.omo_order_list == update omo_order_list set userId = '448810', process_status = '6', pay_status = '0', totalprice_after = '2350', lunar_date = '2024-12-17', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O25010829456' 2025-02-15 23:59:04 -- == update lake.omo_order_list == update omo_order_list set userId = '450931', process_status = '6', pay_status = '0', totalprice_after = '1290', lunar_date = '2024-12-17', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O25010833932' 2025-02-15 23:59:04 -- == update lake.omo_order_list == update omo_order_list set userId = '450936', process_status = '6', pay_status = '0', totalprice_after = '1595', lunar_date = '2024-12-17', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O25010834593' 2025-02-15 23:59:04 -- == update lake.omo_order_list == update omo_order_list set userId = '455386', process_status = '1', pay_status = '1', totalprice_after = '1950', lunar_date = '2025-01-12', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'S25020036312' 2025-02-15 23:59:04 -- == update lake.omo_order_list == update omo_order_list set userId = '163565', process_status = '6', pay_status = '0', totalprice_after = '2765', lunar_date = '2025-01-13', invoice_status = '0',category_name = '永康當日宅配', category_id = '19' where ordernumber = 'S25020039496' 2025-02-15 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('284584','322098',1,'','','O25020074339','1','2','1','1','1','','','0','0000-00-00','0','0','0','','150','0','2320','231','新北市','新店區','231','新北市','新店區','2470','2025-02-15 00:17:47','2025-01-18') 2025-02-15 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('145736','113646',1,'','','O25020074492','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','2000','651','雲林縣','北港鎮','651','雲林縣','北港鎮','2150','2025-02-15 01:40:01','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('419828','456049',1,'','','O25020074529','1','1','1','0','0','','','0','0000-00-00','0','0','0','','150','100','2080','108','台北市','萬華區','108','台北市','萬華區','2130','2025-02-15 04:08:09','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('202048','167967',1,'','','O25020074677','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','520','800','高雄市','新興區','800','高雄市','新興區','670','2025-02-15 07:34:10','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('372438','408931',1,'','','O25020074712','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','2760','406','台中市','北屯區','428','台中市','大雅區','2910','2025-02-15 09:58:47','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('216738','227888',1,'','','O25020074885','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1730','242','新北市','新莊區','242','新北市','新莊區','1880','2025-02-15 10:09:23','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('415393','451394',1,'','','O25020074970','1','1','1','0','0','52663423','台灣智論顧問有限公司','0','0000-00-00','0','0','0','','150','0','1485','110','台北市','信義區','110','台北市','信義區','1635','2025-02-15 10:36:22','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('415393','451394',1,'','','O25020075076','1','1','1','1','1','52663423','台湾智論顧問有限公司再來好了','0','0000-00-00','0','0','0','','150','0','1980','110','台北市','信義區','110','台北市','信義區','2130','2025-02-15 10:46:17','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('419852','456071',1,'','','O25020075110','1','2','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1040','813','高雄市','左營區','813','高雄市','左營區','1160','2025-02-15 11:19:27','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('419884','456103',1,'','','O25020075298','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1730','802','高雄市','苓雅區','830','高雄市','鳳山區','1850','2025-02-15 12:34:24','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('411365','447416',1,'','','O25020075312','1','2','1','0','0','','','0','0000-00-00','0','0','0','','150','0','2000','701','台南市','東區','701','台南市','東區','2150','2025-02-15 13:50:48','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('61277','34807',1,'','','O25020075461','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','150','2080','260','宜蘭縣','宜蘭市','260','宜蘭縣','宜蘭市','2080','2025-02-15 14:28:11','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('273053','310653',1,'','','O25020075554','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','280','503','彰化縣','花壇鄉','503','彰化縣','花壇鄉','430','2025-02-15 14:35:16','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('3319','2183',1,'','','O25020075673','1','11','1','1','1','53282372','振益水電工業股份有限公司','0','0000-00-00','0','0','0','','150','0','2810','521','彰化縣','北斗鎮','521','彰化縣','北斗鎮','2960','2025-02-15 14:57:36','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('419935','456154',1,'永康當日宅配','19','S25020075750','1','1','14','1','1','16131112','同亞開發有限公司','0','2025-02-15','0','0','0','','125','30','1920','106','台北市','大安區','106','台北市','大安區','2015','2025-02-15 15:00:22','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('419945','456164',1,'','','O25020075821','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','840','330','桃園市','桃園區','330','桃園市','桃園區','960','2025-02-15 15:07:31','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('419966','456185',1,'','','O25020075977','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','280','427','台中市','潭子區','268','宜蘭縣','五結鄉','400','2025-02-15 15:54:29','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('348648','385361',1,'','','O25020076099','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','2655','105','台北市','松山區','105','台北市','松山區','2805','2025-02-15 16:38:37','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('233179','261994',1,'','','O25020076171','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','150','1680','821','高雄市','路竹區','821','高雄市','路竹區','1680','2025-02-15 16:39:26','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('419995','456214',1,'','','O25020076216','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1430','221','新北市','汐止區','221','新北市','汐止區','1550','2025-02-15 16:47:16','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('419999','456218',1,'美村門市訂單','32','S25020076348','1','2','1','1','1','','','0','2025-02-18','0','480','0','','0','0','9600','600','嘉義市','西區','600','嘉義市','西區','9120','2025-02-15 17:03:28','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('419930','456149',1,'','','O25020076428','1','11','1','1','1','','','0','0000-00-00','0','0','0','','0','100','5620','521','彰化縣','北斗鎮','521','彰化縣','北斗鎮','5520','2025-02-15 17:09:25','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('420033','456252',1,'','','O25020076514','1','11','1','1','1','90428201','桃傳媒有限公司','0','0000-00-00','456','0','0','','0','30','9120','330','桃園市','桃園區','330','桃園市','桃園區','8634','2025-02-15 18:25:11','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('232755','261428',1,'','','O25020076636','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','2800','632','雲林縣','虎尾鎮','632','雲林縣','虎尾鎮','2950','2025-02-15 18:41:35','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('420041','456260',1,'','','O25020076711','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','280','435','台中市','梧棲區','435','台中市','梧棲區','400','2025-02-15 19:02:54','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('419981','456200',1,'','','O25020076875','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','2100','800','高雄市','新興區','803','高雄市','鹽埕區','2220','2025-02-15 19:15:51','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('406291','442399',1,'','','O25020076960','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1920','433','台中市','沙鹿區','433','台中市','沙鹿區','2070','2025-02-15 19:25:07','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('403853','439993',1,'永康門市訂單','31','S25020077094','1','2','1','0','0','87388459','育騰旺事業股份有限公司中壢車站營業所','0','2025-02-17','0','994','0','','0','0','19875','320','桃園市','中壢區','320','桃園市','中壢區','18881','2025-02-15 19:49:01','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('197533','163565',1,'永康當日宅配','19','S25020077151','1','1','14','1','1','','','0','2025-02-17','0','0','0','','125','0','2640','108','台北市','萬華區','108','台北市','萬華區','2765','2025-02-15 19:54:24','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('420053','456272',1,'','','O25020077278','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','560','324','桃園市','平鎮區','324','桃園市','平鎮區','680','2025-02-15 19:57:28','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('41333','189503',1,'','','O25020077316','1','1','1','1','1','27812261','育旌股份有限公司','0','0000-00-00','672','0','0','','0','0','13440','302','新竹縣','竹北市','302','新竹縣','竹北市','12768','2025-02-15 20:22:52','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('207053','172827',1,'','','O25020077438','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1400','420','台中市','豐原區','825','高雄市','橋頭區','1550','2025-02-15 20:51:25','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('419841','456060',1,'','','O25020077560','1','2','1','1','1','','','0','0000-00-00','0','0','0','','150','30','800','350','苗栗縣','竹南鎮','350','苗栗縣','竹南鎮','920','2025-02-15 20:56:26','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('148399','116212',1,'','','O25020077656','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','2800','520','彰化縣','田中鎮','520','彰化縣','田中鎮','2950','2025-02-15 21:05:27','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('420057','456276',1,'','','O25020077741','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','910','330','桃園市','桃園區','330','桃園市','桃園區','1030','2025-02-15 21:05:32','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('420060','456279',1,'','','O25020077848','1','2','1','1','1','','','0','0000-00-00','0','0','0','','150','30','760','880','澎湖縣','馬公市','813','高雄市','左營區','880','2025-02-15 21:49:00','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('420063','456282',1,'','','O25020077955','2','1','1','0','0','','','0','0000-00-00','0','0','0','','280','0','480','884','澎湖縣','白沙鄉','884','澎湖縣','白沙鄉','760','2025-02-15 22:06:26','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('413828','449854',1,'','','O25020078095','1','1','1','0','0','','','0','0000-00-00','0','0','0','','150','0','1080','334','桃園市','八德區','334','桃園市','八德區','1230','2025-02-15 23:02:29','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('420065','456284',1,'','','O25020078188','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','560','521','彰化縣','北斗鎮','521','彰化縣','北斗鎮','680','2025-02-15 23:27:06','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('136106','104435',1,'','','O25020078231','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','960','243','新北市','泰山區','243','新北市','泰山區','1110','2025-02-15 23:29:42','2025-01-18') 2025-02-15 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('420066','234863',1,'','','O25020078332','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1900','824','高雄市','燕巢區','824','高雄市','燕巢區','2050','2025-02-15 23:32:00','2025-01-18') 2025-02-15 23:59:05 -- == sync_order end == 2025-02-15 23:59:05 -- == sync_order_detail start == 2025-02-15 23:59:05 -- start:2025-02-15,end:2025-02-15 2025-02-15 23:59:05 -- == sync omo_order_detail == 2025-02-15 23:59:05 -- == SELECT order_detail == SELECT * from order_detail WHERE create_date like '2025-02-15%' OR modify_date like '2025-02-15%' 2025-02-15 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S25020036312' and product_code = 'DG010265-01' 2025-02-15 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269340',`firm_id` = '8',`ordernumber` = 'S25020036312', `product_name` = '【SNOOPY 聯名】獨特心意-8結提盒',`product_code` = 'DG010265-01',`product_sn` = 'DG010265',`product_spec` = '原味',`invoice_name` = '提盒-SNOOPY(粉)-40入原味',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '6',`total_price` = '1800',`etd` = '2025-02-17',`create_date` = '2025-02-09 18:38:34',`modify_date` = '2025-02-15 11:30:56',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2025-01-12'where ordernumber = 'S25020036312' and product_code = 'DG010265-01' 2025-02-15 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S25020039496' and product_code = 'DG010101-01' 2025-02-15 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269371',`firm_id` = '8',`ordernumber` = 'S25020039496', `product_name` = '經典原味蛋捲',`product_code` = 'DG010101-01',`product_sn` = 'DG010101',`product_spec` = '原味',`invoice_name` = '40入原味蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '0',`total_price` = '0',`etd` = '2025-02-17',`create_date` = '2025-02-10 14:27:10',`modify_date` = '2025-02-15 19:53:59',`points_use_id` = 0,`item_status` = '0', `lunar_date` = '2025-01-13'where ordernumber = 'S25020039496' and product_code = 'DG010101-01' 2025-02-15 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S25020039496' and product_code = 'DG010101-02' 2025-02-15 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269371',`firm_id` = '8',`ordernumber` = 'S25020039496', `product_name` = '香醇芝麻蛋捲',`product_code` = 'DG010101-02',`product_sn` = 'DG010101',`product_spec` = '芝麻',`invoice_name` = '40入芝麻蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '0',`total_price` = '0',`etd` = '2025-02-17',`create_date` = '2025-02-10 14:27:10',`modify_date` = '2025-02-15 19:53:59',`points_use_id` = 0,`item_status` = '0', `lunar_date` = '2025-01-13'where ordernumber = 'S25020039496' and product_code = 'DG010101-02' 2025-02-15 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S25020039496' and product_code = 'DG010404-01' 2025-02-15 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269371',`firm_id` = '8',`ordernumber` = 'S25020039496', `product_name` = '紅色提袋',`product_code` = 'DG010404-01',`product_sn` = 'DG010404',`product_spec` = '提袋/個',`invoice_name` = '紅色提袋',`listprice` = '10',`sellingprice` = '10',`isadd` = '1',`isbaby` = '0',`addprice` = '10',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '0',`total_price` = '0',`etd` = '2025-02-17',`create_date` = '2025-02-10 14:27:10',`modify_date` = '2025-02-15 19:53:59',`points_use_id` = 0,`item_status` = '0', `lunar_date` = '2025-01-13'where ordernumber = 'S25020039496' and product_code = 'DG010404-01' 2025-02-15 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020074339' and product_code = 'DG0103188-07' 2025-02-15 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269720','8','O25020074339','【SNOOPY 聯名】美好探尋-8結禮盒','DG0103188-07','DG0103188','原味蛋捲,咖啡蛋捲','禮盒-SNOOPY(橘)【原味+咖啡】','500','500','0','0','0','0','1','0.0','4','2000','2025-02-18','2025-02-15 00:17:47','2025-02-15 23:59:07',null,'1','2025-01-18') 2025-02-15 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269720',`firm_id` = '8',`ordernumber` = 'O25020074339', `product_name` = '【SNOOPY 聯名】美好探尋-8結禮盒',`product_code` = 'DG0103188-07',`product_sn` = 'DG0103188',`product_spec` = '原味蛋捲,咖啡蛋捲',`invoice_name` = '禮盒-SNOOPY(橘)【原味+咖啡】',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '4',`total_price` = '2000',`etd` = '2025-02-18',`create_date` = '2025-02-15 00:17:47',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020074339' and product_code = 'DG0103188-07' 2025-02-15 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020074339' and product_code = 'TE010101-01' 2025-02-15 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269720','8','O25020074339','棗香枸杞茶','TE010101-01','TE010101','6入紅棗枸杞茶包','(盒)枸杞茶','160','160','0','0','0','0','1','160.0','2','320','2025-02-18','2025-02-15 00:17:47','2025-02-15 23:59:07',null,'1','2025-01-18') 2025-02-15 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269720',`firm_id` = '8',`ordernumber` = 'O25020074339', `product_name` = '棗香枸杞茶',`product_code` = 'TE010101-01',`product_sn` = 'TE010101',`product_spec` = '6入紅棗枸杞茶包',`invoice_name` = '(盒)枸杞茶',`listprice` = '160',`sellingprice` = '160',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '160.0',`amount` = '2',`total_price` = '320',`etd` = '2025-02-18',`create_date` = '2025-02-15 00:17:47',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020074339' and product_code = 'TE010101-01' 2025-02-15 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020074492' and product_code = 'DG0103188-09' 2025-02-15 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269721','8','O25020074492','【SNOOPY 聯名】美好探尋-8結禮盒','DG0103188-09','DG0103188','原味蛋捲,巧克力蛋捲','禮盒-SNOOPY(橘)【原味+巧克力】','500','500','0','0','0','0','1','0.0','4','2000','2025-02-18','2025-02-15 01:40:01','2025-02-15 23:59:07',null,'1','2025-01-18') 2025-02-15 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269721',`firm_id` = '8',`ordernumber` = 'O25020074492', `product_name` = '【SNOOPY 聯名】美好探尋-8結禮盒',`product_code` = 'DG0103188-09',`product_sn` = 'DG0103188',`product_spec` = '原味蛋捲,巧克力蛋捲',`invoice_name` = '禮盒-SNOOPY(橘)【原味+巧克力】',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '4',`total_price` = '2000',`etd` = '2025-02-18',`create_date` = '2025-02-15 01:40:01',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020074492' and product_code = 'DG0103188-09' 2025-02-15 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020074529' and product_code = 'DG010144-01' 2025-02-15 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269722','8','O25020074529','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','4','1120','2025-02-18','2025-02-15 04:08:09','2025-02-15 23:59:07',null,'1','2025-01-18') 2025-02-15 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269722',`firm_id` = '8',`ordernumber` = 'O25020074529', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '4',`total_price` = '1120',`etd` = '2025-02-18',`create_date` = '2025-02-15 04:08:09',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020074529' and product_code = 'DG010144-01' 2025-02-15 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020074529' and product_code = 'DG010312-12' 2025-02-15 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269722','8','O25020074529','【咖啡+巧克力】金8結禮盒','DG010312-12','DG010312','金8結盒','禮盒-金8結【咖啡+巧克力】','590','480','0','0','0','0','1','480.0','2','960','2025-02-18','2025-02-15 04:08:09','2025-02-15 23:59:07',null,'1','2025-01-18') 2025-02-15 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269722',`firm_id` = '8',`ordernumber` = 'O25020074529', `product_name` = '【咖啡+巧克力】金8結禮盒',`product_code` = 'DG010312-12',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【咖啡+巧克力】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '2',`total_price` = '960',`etd` = '2025-02-18',`create_date` = '2025-02-15 04:08:09',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020074529' and product_code = 'DG010312-12' 2025-02-15 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020074677' and product_code = 'DG010144-01' 2025-02-15 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269723','8','O25020074677','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','1','280','2025-02-18','2025-02-15 07:34:10','2025-02-15 23:59:07',null,'1','2025-01-18') 2025-02-15 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269723',`firm_id` = '8',`ordernumber` = 'O25020074677', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '280',`etd` = '2025-02-18',`create_date` = '2025-02-15 07:34:10',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020074677' and product_code = 'DG010144-01' 2025-02-15 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020074677' and product_code = 'DG010143-01' 2025-02-15 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269723','8','O25020074677','可可烤布蕾蛋捲','DG010143-01','DG010143','32入可可烤布蕾蛋捲','32入可可烤布蕾蛋捲','240','240','0','0','0','0','1','0.0','1','240','2025-02-18','2025-02-15 07:34:10','2025-02-15 23:59:07',null,'1','2025-01-18') 2025-02-15 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269723',`firm_id` = '8',`ordernumber` = 'O25020074677', `product_name` = '可可烤布蕾蛋捲',`product_code` = 'DG010143-01',`product_sn` = 'DG010143',`product_spec` = '32入可可烤布蕾蛋捲',`invoice_name` = '32入可可烤布蕾蛋捲',`listprice` = '240',`sellingprice` = '240',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '240',`etd` = '2025-02-18',`create_date` = '2025-02-15 07:34:10',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020074677' and product_code = 'DG010143-01' 2025-02-15 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020074712' and product_code = 'DG010101-02' 2025-02-15 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269724','8','O25020074712','香醇芝麻蛋捲','DG010101-02','DG010101','芝麻','40入芝麻蛋捲','320','280','0','0','0','0','1','280.0','2','560','2025-02-19','2025-02-15 09:58:47','2025-02-15 23:59:07',null,'1','2025-01-18') 2025-02-15 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269724',`firm_id` = '8',`ordernumber` = 'O25020074712', `product_name` = '香醇芝麻蛋捲',`product_code` = 'DG010101-02',`product_sn` = 'DG010101',`product_spec` = '芝麻',`invoice_name` = '40入芝麻蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '2',`total_price` = '560',`etd` = '2025-02-19',`create_date` = '2025-02-15 09:58:47',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020074712' and product_code = 'DG010101-02' 2025-02-15 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020074712' and product_code = 'DG010144-01' 2025-02-15 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269724','8','O25020074712','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','1','280','2025-02-19','2025-02-15 09:58:47','2025-02-15 23:59:07',null,'1','2025-01-18') 2025-02-15 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269724',`firm_id` = '8',`ordernumber` = 'O25020074712', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '280',`etd` = '2025-02-19',`create_date` = '2025-02-15 09:58:47',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020074712' and product_code = 'DG010144-01' 2025-02-15 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020074712' and product_code = 'DG010143-01' 2025-02-15 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269724','8','O25020074712','可可烤布蕾蛋捲','DG010143-01','DG010143','32入可可烤布蕾蛋捲','32入可可烤布蕾蛋捲','240','240','0','0','0','0','1','0.0','8','1920','2025-02-19','2025-02-15 09:58:47','2025-02-15 23:59:07',null,'1','2025-01-18') 2025-02-15 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269724',`firm_id` = '8',`ordernumber` = 'O25020074712', `product_name` = '可可烤布蕾蛋捲',`product_code` = 'DG010143-01',`product_sn` = 'DG010143',`product_spec` = '32入可可烤布蕾蛋捲',`invoice_name` = '32入可可烤布蕾蛋捲',`listprice` = '240',`sellingprice` = '240',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '8',`total_price` = '1920',`etd` = '2025-02-19',`create_date` = '2025-02-15 09:58:47',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020074712' and product_code = 'DG010143-01' 2025-02-15 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020074885' and product_code = 'DG010144-01' 2025-02-15 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269725','8','O25020074885','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','6','1680','2025-02-19','2025-02-15 10:09:23','2025-02-15 23:59:07',null,'1','2025-01-18') 2025-02-15 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269725',`firm_id` = '8',`ordernumber` = 'O25020074885', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '6',`total_price` = '1680',`etd` = '2025-02-19',`create_date` = '2025-02-15 10:09:23',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020074885' and product_code = 'DG010144-01' 2025-02-15 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020074885' and product_code = 'DG010404-01' 2025-02-15 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269725','8','O25020074885','紅色提袋','DG010404-01','DG010404','提袋/個','紅色提袋','10','10','0','0','0','0','1','0.0','5','50','2025-02-19','2025-02-15 10:09:23','2025-02-15 23:59:07',null,'1','2025-01-18') 2025-02-15 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269725',`firm_id` = '8',`ordernumber` = 'O25020074885', `product_name` = '紅色提袋',`product_code` = 'DG010404-01',`product_sn` = 'DG010404',`product_spec` = '提袋/個',`invoice_name` = '紅色提袋',`listprice` = '10',`sellingprice` = '10',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '5',`total_price` = '50',`etd` = '2025-02-19',`create_date` = '2025-02-15 10:09:23',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020074885' and product_code = 'DG010404-01' 2025-02-15 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020074970' and product_code = 'DG010347-01' 2025-02-15 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269726','8','O25020074970','六月初一&成真咖啡禮盒','DG010347-01','DG010347','原味蛋捲+6入咖啡','禮盒-ESG藍金【原味+成真咖啡】','495','495','0','0','0','0','1','0.0','1','495','2025-02-20','2025-02-15 10:36:22','2025-02-15 23:59:07',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269726',`firm_id` = '8',`ordernumber` = 'O25020074970', `product_name` = '六月初一&成真咖啡禮盒',`product_code` = 'DG010347-01',`product_sn` = 'DG010347',`product_spec` = '原味蛋捲+6入咖啡',`invoice_name` = '禮盒-ESG藍金【原味+成真咖啡】',`listprice` = '495',`sellingprice` = '495',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '495',`etd` = '2025-02-20',`create_date` = '2025-02-15 10:36:22',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020074970' and product_code = 'DG010347-01' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020074970' and product_code = 'DG010347-02' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269726','8','O25020074970','六月初一&成真咖啡禮盒','DG010347-02','DG010347','芝麻蛋捲+6入咖啡','禮盒-ESG藍金【芝麻+成真咖啡】','495','495','0','0','0','0','1','0.0','1','495','2025-02-20','2025-02-15 10:36:22','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269726',`firm_id` = '8',`ordernumber` = 'O25020074970', `product_name` = '六月初一&成真咖啡禮盒',`product_code` = 'DG010347-02',`product_sn` = 'DG010347',`product_spec` = '芝麻蛋捲+6入咖啡',`invoice_name` = '禮盒-ESG藍金【芝麻+成真咖啡】',`listprice` = '495',`sellingprice` = '495',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '495',`etd` = '2025-02-20',`create_date` = '2025-02-15 10:36:22',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020074970' and product_code = 'DG010347-02' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020074970' and product_code = 'DG010347-05' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269726','8','O25020074970','六月初一&成真咖啡禮盒','DG010347-05','DG010347','巧克力蛋捲+6入咖啡','禮盒-ESG藍金【巧克力+成真咖啡】','495','495','0','0','0','0','1','0.0','1','495','2025-02-20','2025-02-15 10:36:22','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269726',`firm_id` = '8',`ordernumber` = 'O25020074970', `product_name` = '六月初一&成真咖啡禮盒',`product_code` = 'DG010347-05',`product_sn` = 'DG010347',`product_spec` = '巧克力蛋捲+6入咖啡',`invoice_name` = '禮盒-ESG藍金【巧克力+成真咖啡】',`listprice` = '495',`sellingprice` = '495',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '495',`etd` = '2025-02-20',`create_date` = '2025-02-15 10:36:22',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020074970' and product_code = 'DG010347-05' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020075076' and product_code = 'DG010347-01' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269727','8','O25020075076','六月初一&成真咖啡禮盒','DG010347-01','DG010347','原味蛋捲+6入咖啡','禮盒-ESG藍金【原味+成真咖啡】','495','495','0','0','0','0','1','0.0','2','990','2025-02-19','2025-02-15 10:46:17','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269727',`firm_id` = '8',`ordernumber` = 'O25020075076', `product_name` = '六月初一&成真咖啡禮盒',`product_code` = 'DG010347-01',`product_sn` = 'DG010347',`product_spec` = '原味蛋捲+6入咖啡',`invoice_name` = '禮盒-ESG藍金【原味+成真咖啡】',`listprice` = '495',`sellingprice` = '495',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '990',`etd` = '2025-02-19',`create_date` = '2025-02-15 10:46:17',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020075076' and product_code = 'DG010347-01' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020075076' and product_code = 'DG010347-02' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269727','8','O25020075076','六月初一&成真咖啡禮盒','DG010347-02','DG010347','芝麻蛋捲+6入咖啡','禮盒-ESG藍金【芝麻+成真咖啡】','495','495','0','0','0','0','1','0.0','1','495','2025-02-19','2025-02-15 10:46:17','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269727',`firm_id` = '8',`ordernumber` = 'O25020075076', `product_name` = '六月初一&成真咖啡禮盒',`product_code` = 'DG010347-02',`product_sn` = 'DG010347',`product_spec` = '芝麻蛋捲+6入咖啡',`invoice_name` = '禮盒-ESG藍金【芝麻+成真咖啡】',`listprice` = '495',`sellingprice` = '495',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '495',`etd` = '2025-02-19',`create_date` = '2025-02-15 10:46:17',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020075076' and product_code = 'DG010347-02' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020075076' and product_code = 'DG010347-05' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269727','8','O25020075076','六月初一&成真咖啡禮盒','DG010347-05','DG010347','巧克力蛋捲+6入咖啡','禮盒-ESG藍金【巧克力+成真咖啡】','495','495','0','0','0','0','1','0.0','1','495','2025-02-19','2025-02-15 10:46:17','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269727',`firm_id` = '8',`ordernumber` = 'O25020075076', `product_name` = '六月初一&成真咖啡禮盒',`product_code` = 'DG010347-05',`product_sn` = 'DG010347',`product_spec` = '巧克力蛋捲+6入咖啡',`invoice_name` = '禮盒-ESG藍金【巧克力+成真咖啡】',`listprice` = '495',`sellingprice` = '495',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '495',`etd` = '2025-02-19',`create_date` = '2025-02-15 10:46:17',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020075076' and product_code = 'DG010347-05' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020075110' and product_code = 'DG010144-01' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269728','8','O25020075110','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','2','560','2025-02-21','2025-02-15 11:19:27','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269728',`firm_id` = '8',`ordernumber` = 'O25020075110', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '560',`etd` = '2025-02-21',`create_date` = '2025-02-15 11:19:27',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020075110' and product_code = 'DG010144-01' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020075110' and product_code = 'DG010312-03' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269728','8','O25020075110','【原味+咖啡】金8結禮盒','DG010312-03','DG010312','金8結盒','禮盒-金8結【原味+咖啡】','590','480','0','0','0','0','1','480.0','1','480','2025-02-21','2025-02-15 11:19:27','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269728',`firm_id` = '8',`ordernumber` = 'O25020075110', `product_name` = '【原味+咖啡】金8結禮盒',`product_code` = 'DG010312-03',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+咖啡】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2025-02-21',`create_date` = '2025-02-15 11:19:27',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020075110' and product_code = 'DG010312-03' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S25020036312' and product_code = 'BP010183-01' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269340','8','S25020036312','贈品-SNOOPY飲料提袋','BP010183-01','BP010183','贈品-SNOOPY飲料提袋','贈品-SNOOPY飲料提袋','0','0','0','0','0','0','1','0.0','1','0','2025-02-17','2025-02-15 11:30:56','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269340',`firm_id` = '8',`ordernumber` = 'S25020036312', `product_name` = '贈品-SNOOPY飲料提袋',`product_code` = 'BP010183-01',`product_sn` = 'BP010183',`product_spec` = '贈品-SNOOPY飲料提袋',`invoice_name` = '贈品-SNOOPY飲料提袋',`listprice` = '0',`sellingprice` = '0',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '0',`etd` = '2025-02-17',`create_date` = '2025-02-15 11:30:56',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'S25020036312' and product_code = 'BP010183-01' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020075298' and product_code = '13657' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269729','8','O25020075298','8結蛋捲【紅提袋裝】','13657','13656','40入芝麻蛋捲','組合-40入芝麻+紅提袋','290','290','0','0','0','0','1','0.0','4','1160','2025-02-18','2025-02-15 12:34:24','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269729',`firm_id` = '8',`ordernumber` = 'O25020075298', `product_name` = '8結蛋捲【紅提袋裝】',`product_code` = '13657',`product_sn` = '13656',`product_spec` = '40入芝麻蛋捲',`invoice_name` = '組合-40入芝麻+紅提袋',`listprice` = '290',`sellingprice` = '290',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '4',`total_price` = '1160',`etd` = '2025-02-18',`create_date` = '2025-02-15 12:34:24',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020075298' and product_code = '13657' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020075298' and product_code = '13658' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269729','8','O25020075298','8結蛋捲【紅提袋裝】','13658','13656','40入咖啡蛋捲','組合-40入咖啡+紅提袋','290','290','0','0','0','0','1','0.0','1','290','2025-02-18','2025-02-15 12:34:24','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269729',`firm_id` = '8',`ordernumber` = 'O25020075298', `product_name` = '8結蛋捲【紅提袋裝】',`product_code` = '13658',`product_sn` = '13656',`product_spec` = '40入咖啡蛋捲',`invoice_name` = '組合-40入咖啡+紅提袋',`listprice` = '290',`sellingprice` = '290',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '290',`etd` = '2025-02-18',`create_date` = '2025-02-15 12:34:24',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020075298' and product_code = '13658' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020075298' and product_code = 'DG010144-01' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269729','8','O25020075298','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','1','280','2025-02-18','2025-02-15 12:34:24','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269729',`firm_id` = '8',`ordernumber` = 'O25020075298', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '280',`etd` = '2025-02-18',`create_date` = '2025-02-15 12:34:24',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020075298' and product_code = 'DG010144-01' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020075312' and product_code = 'DG010144-01' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269730','8','O25020075312','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','3','840','2025-02-19','2025-02-15 13:50:48','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269730',`firm_id` = '8',`ordernumber` = 'O25020075312', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '3',`total_price` = '840',`etd` = '2025-02-19',`create_date` = '2025-02-15 13:50:48',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020075312' and product_code = 'DG010144-01' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020075312' and product_code = '13658' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269730','8','O25020075312','8結蛋捲【紅提袋裝】','13658','13656','40入咖啡蛋捲','組合-40入咖啡+紅提袋','290','290','0','0','0','0','1','0.0','2','580','2025-02-19','2025-02-15 13:50:48','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269730',`firm_id` = '8',`ordernumber` = 'O25020075312', `product_name` = '8結蛋捲【紅提袋裝】',`product_code` = '13658',`product_sn` = '13656',`product_spec` = '40入咖啡蛋捲',`invoice_name` = '組合-40入咖啡+紅提袋',`listprice` = '290',`sellingprice` = '290',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '580',`etd` = '2025-02-19',`create_date` = '2025-02-15 13:50:48',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020075312' and product_code = '13658' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020075312' and product_code = '13660' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269730','8','O25020075312','8結蛋捲【紅提袋裝】','13660','13656','40入巧克力蛋捲','組合-40入巧克力+紅提袋','290','290','0','0','0','0','1','0.0','2','580','2025-02-19','2025-02-15 13:50:48','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269730',`firm_id` = '8',`ordernumber` = 'O25020075312', `product_name` = '8結蛋捲【紅提袋裝】',`product_code` = '13660',`product_sn` = '13656',`product_spec` = '40入巧克力蛋捲',`invoice_name` = '組合-40入巧克力+紅提袋',`listprice` = '290',`sellingprice` = '290',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '580',`etd` = '2025-02-19',`create_date` = '2025-02-15 13:50:48',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020075312' and product_code = '13660' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020075461' and product_code = 'DG010312-10' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269731','8','O25020075461','【咖啡＋咖啡】金8結禮盒','DG010312-10','DG010312','金8結盒','禮盒-金8結【咖啡+咖啡】','590','480','0','0','0','0','1','480.0','1','480','2025-02-18','2025-02-15 14:28:11','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269731',`firm_id` = '8',`ordernumber` = 'O25020075461', `product_name` = '【咖啡＋咖啡】金8結禮盒',`product_code` = 'DG010312-10',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【咖啡+咖啡】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2025-02-18',`create_date` = '2025-02-15 14:28:11',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020075461' and product_code = 'DG010312-10' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020075461' and product_code = 'DG010312-15' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269731','8','O25020075461','【巧克力＋巧克力】金8結禮盒','DG010312-15','DG010312','金8結盒','禮盒-金8結【巧克力+巧克力】','590','480','0','0','0','0','1','480.0','1','480','2025-02-18','2025-02-15 14:28:11','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269731',`firm_id` = '8',`ordernumber` = 'O25020075461', `product_name` = '【巧克力＋巧克力】金8結禮盒',`product_code` = 'DG010312-15',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【巧克力+巧克力】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2025-02-18',`create_date` = '2025-02-15 14:28:11',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020075461' and product_code = 'DG010312-15' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020075461' and product_code = 'DG010144-01' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269731','8','O25020075461','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','4','1120','2025-02-18','2025-02-15 14:28:11','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269731',`firm_id` = '8',`ordernumber` = 'O25020075461', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '4',`total_price` = '1120',`etd` = '2025-02-18',`create_date` = '2025-02-15 14:28:11',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020075461' and product_code = 'DG010144-01' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020075554' and product_code = 'DG010144-01' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269732','8','O25020075554','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','1','280','2025-02-27','2025-02-15 14:35:16','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269732',`firm_id` = '8',`ordernumber` = 'O25020075554', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '280',`etd` = '2025-02-27',`create_date` = '2025-02-15 14:35:16',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020075554' and product_code = 'DG010144-01' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020075673' and product_code = 'DG010312-12' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269733','8','O25020075673','【咖啡+巧克力】金8結禮盒','DG010312-12','DG010312','金8結盒','禮盒-金8結【咖啡+巧克力】','590','480','0','0','0','0','1','480.0','1','480','2025-02-18','2025-02-15 14:57:36','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269733',`firm_id` = '8',`ordernumber` = 'O25020075673', `product_name` = '【咖啡+巧克力】金8結禮盒',`product_code` = 'DG010312-12',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【咖啡+巧克力】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2025-02-18',`create_date` = '2025-02-15 14:57:36',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020075673' and product_code = 'DG010312-12' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020075673' and product_code = 'DG010312-15' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269733','8','O25020075673','【巧克力＋巧克力】金8結禮盒','DG010312-15','DG010312','金8結盒','禮盒-金8結【巧克力+巧克力】','590','480','0','0','0','0','1','480.0','1','480','2025-02-18','2025-02-15 14:57:36','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269733',`firm_id` = '8',`ordernumber` = 'O25020075673', `product_name` = '【巧克力＋巧克力】金8結禮盒',`product_code` = 'DG010312-15',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【巧克力+巧克力】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2025-02-18',`create_date` = '2025-02-15 14:57:36',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020075673' and product_code = 'DG010312-15' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020075673' and product_code = 'DG010312-10' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269733','8','O25020075673','【咖啡＋咖啡】金8結禮盒','DG010312-10','DG010312','金8結盒','禮盒-金8結【咖啡+咖啡】','590','480','0','0','0','0','1','480.0','1','480','2025-02-18','2025-02-15 14:57:36','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269733',`firm_id` = '8',`ordernumber` = 'O25020075673', `product_name` = '【咖啡＋咖啡】金8結禮盒',`product_code` = 'DG010312-10',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【咖啡+咖啡】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2025-02-18',`create_date` = '2025-02-15 14:57:36',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020075673' and product_code = 'DG010312-10' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020075673' and product_code = 'DG010312-01' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269733','8','O25020075673','【原味＋原味】金8結禮盒','DG010312-01','DG010312','金8結盒','禮盒-金8結【原味+原味】','590','480','0','0','0','0','1','480.0','1','480','2025-02-18','2025-02-15 14:57:36','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269733',`firm_id` = '8',`ordernumber` = 'O25020075673', `product_name` = '【原味＋原味】金8結禮盒',`product_code` = 'DG010312-01',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+原味】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2025-02-18',`create_date` = '2025-02-15 14:57:36',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020075673' and product_code = 'DG010312-01' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020075673' and product_code = 'FL010102-01' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269733','8','O25020075673','一口鳳梨酥','FL010102-01','FL010102','8入鳳梨酥','(盒)鳳梨酥','165','165','0','0','0','0','1','130.0','2','330','2025-02-18','2025-02-15 14:57:36','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269733',`firm_id` = '8',`ordernumber` = 'O25020075673', `product_name` = '一口鳳梨酥',`product_code` = 'FL010102-01',`product_sn` = 'FL010102',`product_spec` = '8入鳳梨酥',`invoice_name` = '(盒)鳳梨酥',`listprice` = '165',`sellingprice` = '165',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '130.0',`amount` = '2',`total_price` = '330',`etd` = '2025-02-18',`create_date` = '2025-02-15 14:57:36',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020075673' and product_code = 'FL010102-01' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020075673' and product_code = 'DG010144-01' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269733','8','O25020075673','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','2','560','2025-02-18','2025-02-15 14:57:36','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269733',`firm_id` = '8',`ordernumber` = 'O25020075673', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '560',`etd` = '2025-02-18',`create_date` = '2025-02-15 14:57:36',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020075673' and product_code = 'DG010144-01' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S25020075750' and product_code = 'DG010312-02' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269734','8','S25020075750','【原味+芝麻】金8結禮盒','DG010312-02','DG010312','金8結盒','禮盒-金8結【原味+芝麻】','590','480','0','0','0','0','1','480.0','1','480','2025-02-15','2025-02-15 15:00:22','2025-02-15 23:59:08',0,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269734',`firm_id` = '8',`ordernumber` = 'S25020075750', `product_name` = '【原味+芝麻】金8結禮盒',`product_code` = 'DG010312-02',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+芝麻】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2025-02-15',`create_date` = '2025-02-15 15:00:22',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'S25020075750' and product_code = 'DG010312-02' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S25020075750' and product_code = 'DG010312-05' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269734','8','S25020075750','【原味+巧克力】金8結禮盒','DG010312-05','DG010312','金8結盒','禮盒-金8結【原味+巧克力】','590','480','0','0','0','0','1','480.0','3','1440','2025-02-15','2025-02-15 15:00:22','2025-02-15 23:59:08',0,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269734',`firm_id` = '8',`ordernumber` = 'S25020075750', `product_name` = '【原味+巧克力】金8結禮盒',`product_code` = 'DG010312-05',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+巧克力】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '3',`total_price` = '1440',`etd` = '2025-02-15',`create_date` = '2025-02-15 15:00:22',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'S25020075750' and product_code = 'DG010312-05' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020075821' and product_code = 'DG010144-01' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269735','8','O25020075821','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','2','560','2025-02-19','2025-02-15 15:07:31','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269735',`firm_id` = '8',`ordernumber` = 'O25020075821', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '560',`etd` = '2025-02-19',`create_date` = '2025-02-15 15:07:31',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020075821' and product_code = 'DG010144-01' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020075821' and product_code = 'DG010101-02' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269735','8','O25020075821','香醇芝麻蛋捲','DG010101-02','DG010101','芝麻','40入芝麻蛋捲','320','280','0','0','0','0','1','280.0','1','280','2025-02-19','2025-02-15 15:07:31','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269735',`firm_id` = '8',`ordernumber` = 'O25020075821', `product_name` = '香醇芝麻蛋捲',`product_code` = 'DG010101-02',`product_sn` = 'DG010101',`product_spec` = '芝麻',`invoice_name` = '40入芝麻蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2025-02-19',`create_date` = '2025-02-15 15:07:31',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020075821' and product_code = 'DG010101-02' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020075977' and product_code = 'DG010144-01' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269736','8','O25020075977','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','1','280','2025-02-18','2025-02-15 15:54:29','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269736',`firm_id` = '8',`ordernumber` = 'O25020075977', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '280',`etd` = '2025-02-18',`create_date` = '2025-02-15 15:54:29',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020075977' and product_code = 'DG010144-01' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020076099' and product_code = 'DG010314-02' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269737','8','O25020076099','金8結隨行醇蜜禮盒','DG010314-02','DG010314','芝麻蛋捲+隨行瓶','禮盒-金8結【芝麻+隨行醇蜜】','565','565','0','0','0','0','1','565.0','3','1695','2025-02-19','2025-02-15 16:38:37','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269737',`firm_id` = '8',`ordernumber` = 'O25020076099', `product_name` = '金8結隨行醇蜜禮盒',`product_code` = 'DG010314-02',`product_sn` = 'DG010314',`product_spec` = '芝麻蛋捲+隨行瓶',`invoice_name` = '禮盒-金8結【芝麻+隨行醇蜜】',`listprice` = '565',`sellingprice` = '565',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '565.0',`amount` = '3',`total_price` = '1695',`etd` = '2025-02-19',`create_date` = '2025-02-15 16:38:37',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020076099' and product_code = 'DG010314-02' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020076099' and product_code = 'DG010312-09' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269737','8','O25020076099','【芝麻+巧克力】金8結禮盒','DG010312-09','DG010312','金8結盒','禮盒-金8結【芝麻+巧克力】','590','480','0','0','0','0','1','480.0','2','960','2025-02-19','2025-02-15 16:38:37','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269737',`firm_id` = '8',`ordernumber` = 'O25020076099', `product_name` = '【芝麻+巧克力】金8結禮盒',`product_code` = 'DG010312-09',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【芝麻+巧克力】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '2',`total_price` = '960',`etd` = '2025-02-19',`create_date` = '2025-02-15 16:38:37',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020076099' and product_code = 'DG010312-09' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020076171' and product_code = 'DG010144-01' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269738','8','O25020076171','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','4','1120','2025-02-18','2025-02-15 16:39:26','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269738',`firm_id` = '8',`ordernumber` = 'O25020076171', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '4',`total_price` = '1120',`etd` = '2025-02-18',`create_date` = '2025-02-15 16:39:26',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020076171' and product_code = 'DG010144-01' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020076171' and product_code = 'DG010101-05' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269738','8','O25020076171','濃情巧克力蛋捲','DG010101-05','DG010101','巧克力','40入巧克力蛋捲','320','280','0','0','0','0','1','280.0','2','560','2025-02-18','2025-02-15 16:39:26','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269738',`firm_id` = '8',`ordernumber` = 'O25020076171', `product_name` = '濃情巧克力蛋捲',`product_code` = 'DG010101-05',`product_sn` = 'DG010101',`product_spec` = '巧克力',`invoice_name` = '40入巧克力蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '2',`total_price` = '560',`etd` = '2025-02-18',`create_date` = '2025-02-15 16:39:26',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020076171' and product_code = 'DG010101-05' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020076216' and product_code = 'DG010101-01' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269739','8','O25020076216','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','1','280','2025-02-18','2025-02-15 16:47:16','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269739',`firm_id` = '8',`ordernumber` = 'O25020076216', `product_name` = '經典原味蛋捲',`product_code` = 'DG010101-01',`product_sn` = 'DG010101',`product_spec` = '原味',`invoice_name` = '40入原味蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2025-02-18',`create_date` = '2025-02-15 16:47:16',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020076216' and product_code = 'DG010101-01' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020076216' and product_code = 'DG010101-05' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269739','8','O25020076216','濃情巧克力蛋捲','DG010101-05','DG010101','巧克力','40入巧克力蛋捲','320','280','0','0','0','0','1','280.0','1','280','2025-02-18','2025-02-15 16:47:16','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269739',`firm_id` = '8',`ordernumber` = 'O25020076216', `product_name` = '濃情巧克力蛋捲',`product_code` = 'DG010101-05',`product_sn` = 'DG010101',`product_spec` = '巧克力',`invoice_name` = '40入巧克力蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2025-02-18',`create_date` = '2025-02-15 16:47:16',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020076216' and product_code = 'DG010101-05' 2025-02-15 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020076216' and product_code = 'DG010101-02' 2025-02-15 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269739','8','O25020076216','香醇芝麻蛋捲','DG010101-02','DG010101','芝麻','40入芝麻蛋捲','320','280','0','0','0','0','1','280.0','1','280','2025-02-18','2025-02-15 16:47:16','2025-02-15 23:59:08',null,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269739',`firm_id` = '8',`ordernumber` = 'O25020076216', `product_name` = '香醇芝麻蛋捲',`product_code` = 'DG010101-02',`product_sn` = 'DG010101',`product_spec` = '芝麻',`invoice_name` = '40入芝麻蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2025-02-18',`create_date` = '2025-02-15 16:47:16',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020076216' and product_code = 'DG010101-02' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020076216' and product_code = 'LS010510-02' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269739','8','O25020076216','梅子零嘴任選二入組','LS010510-02','LS010510','(袋)烏梅絲+(袋)無籽梅肉','(袋)烏梅絲+(袋)無籽梅肉','170','170','0','0','0','0','1','0.0','1','170','2025-02-18','2025-02-15 16:47:16','2025-02-15 23:59:09',null,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269739',`firm_id` = '8',`ordernumber` = 'O25020076216', `product_name` = '梅子零嘴任選二入組',`product_code` = 'LS010510-02',`product_sn` = 'LS010510',`product_spec` = '(袋)烏梅絲+(袋)無籽梅肉',`invoice_name` = '(袋)烏梅絲+(袋)無籽梅肉',`listprice` = '170',`sellingprice` = '170',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '170',`etd` = '2025-02-18',`create_date` = '2025-02-15 16:47:16',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020076216' and product_code = 'LS010510-02' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020076216' and product_code = 'LM010102-01' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269739','8','O25020076216','單盒-8結老梅肉','LM010102-01','LM010102','12包老梅肉','(盒)老梅肉','500','420','0','0','0','0','1','0.0','1','420','2025-02-18','2025-02-15 16:47:16','2025-02-15 23:59:09',null,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269739',`firm_id` = '8',`ordernumber` = 'O25020076216', `product_name` = '單盒-8結老梅肉',`product_code` = 'LM010102-01',`product_sn` = 'LM010102',`product_spec` = '12包老梅肉',`invoice_name` = '(盒)老梅肉',`listprice` = '500',`sellingprice` = '420',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '420',`etd` = '2025-02-18',`create_date` = '2025-02-15 16:47:16',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020076216' and product_code = 'LM010102-01' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S25020076348' and product_code = 'DG010312-07' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269740','8','S25020076348','【芝麻+咖啡】金8結禮盒','DG010312-07','DG010312','金8結盒','禮盒-金8結【芝麻+咖啡】','590','480','0','0','0','0','1','480.0','20','9600','2025-02-18','2025-02-15 17:03:28','2025-02-15 23:59:09',0,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269740',`firm_id` = '8',`ordernumber` = 'S25020076348', `product_name` = '【芝麻+咖啡】金8結禮盒',`product_code` = 'DG010312-07',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【芝麻+咖啡】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '20',`total_price` = '9600',`etd` = '2025-02-18',`create_date` = '2025-02-15 17:03:28',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'S25020076348' and product_code = 'DG010312-07' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S25020076348' and product_code = 'DG010404-01' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269740','8','S25020076348','紅色提袋','DG010404-01','DG010404','提袋/個','紅色提袋','10','0','1','0','0','0','1','0.0','40','0','2025-02-18','2025-02-15 17:03:28','2025-02-15 23:59:09',null,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269740',`firm_id` = '8',`ordernumber` = 'S25020076348', `product_name` = '紅色提袋',`product_code` = 'DG010404-01',`product_sn` = 'DG010404',`product_spec` = '提袋/個',`invoice_name` = '紅色提袋',`listprice` = '10',`sellingprice` = '0',`isadd` = '1',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '40',`total_price` = '0',`etd` = '2025-02-18',`create_date` = '2025-02-15 17:03:28',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'S25020076348' and product_code = 'DG010404-01' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020076428' and product_code = 'DG010144-01' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269741','8','O25020076428','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','4','1120','2025-02-18','2025-02-15 17:09:25','2025-02-15 23:59:09',null,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269741',`firm_id` = '8',`ordernumber` = 'O25020076428', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '4',`total_price` = '1120',`etd` = '2025-02-18',`create_date` = '2025-02-15 17:09:25',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020076428' and product_code = 'DG010144-01' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020076428' and product_code = 'DG010143-01' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269741','8','O25020076428','可可烤布蕾蛋捲','DG010143-01','DG010143','32入可可烤布蕾蛋捲','32入可可烤布蕾蛋捲','240','240','0','0','0','0','1','0.0','5','1200','2025-02-18','2025-02-15 17:09:25','2025-02-15 23:59:09',null,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269741',`firm_id` = '8',`ordernumber` = 'O25020076428', `product_name` = '可可烤布蕾蛋捲',`product_code` = 'DG010143-01',`product_sn` = 'DG010143',`product_spec` = '32入可可烤布蕾蛋捲',`invoice_name` = '32入可可烤布蕾蛋捲',`listprice` = '240',`sellingprice` = '240',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '5',`total_price` = '1200',`etd` = '2025-02-18',`create_date` = '2025-02-15 17:09:25',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020076428' and product_code = 'DG010143-01' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020076428' and product_code = 'ZS010201-03' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269741','8','O25020076428','提盒裝肉酥酥','ZS010201-03','ZS010201','辣味+辣味','提盒-肉酥酥【辣味】','300','300','0','0','0','0','1','300.0','2','600','2025-02-18','2025-02-15 17:09:25','2025-02-15 23:59:09',null,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269741',`firm_id` = '8',`ordernumber` = 'O25020076428', `product_name` = '提盒裝肉酥酥',`product_code` = 'ZS010201-03',`product_sn` = 'ZS010201',`product_spec` = '辣味+辣味',`invoice_name` = '提盒-肉酥酥【辣味】',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '300.0',`amount` = '2',`total_price` = '600',`etd` = '2025-02-18',`create_date` = '2025-02-15 17:09:25',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020076428' and product_code = 'ZS010201-03' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020076428' and product_code = 'ZS010201-02' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269741','8','O25020076428','提盒裝肉酥酥','ZS010201-02','ZS010201','原味+辣味','提盒-肉酥酥【原+辣】','300','300','0','0','0','0','1','300.0','1','300','2025-02-18','2025-02-15 17:09:25','2025-02-15 23:59:09',null,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269741',`firm_id` = '8',`ordernumber` = 'O25020076428', `product_name` = '提盒裝肉酥酥',`product_code` = 'ZS010201-02',`product_sn` = 'ZS010201',`product_spec` = '原味+辣味',`invoice_name` = '提盒-肉酥酥【原+辣】',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '300.0',`amount` = '1',`total_price` = '300',`etd` = '2025-02-18',`create_date` = '2025-02-15 17:09:25',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020076428' and product_code = 'ZS010201-02' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020076428' and product_code = 'ZS010201-01' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269741','8','O25020076428','提盒裝肉酥酥','ZS010201-01','ZS010201','原味+原味','提盒-肉酥酥【原味】','300','300','0','0','0','0','1','300.0','1','300','2025-02-18','2025-02-15 17:09:25','2025-02-15 23:59:09',null,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269741',`firm_id` = '8',`ordernumber` = 'O25020076428', `product_name` = '提盒裝肉酥酥',`product_code` = 'ZS010201-01',`product_sn` = 'ZS010201',`product_spec` = '原味+原味',`invoice_name` = '提盒-肉酥酥【原味】',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '300.0',`amount` = '1',`total_price` = '300',`etd` = '2025-02-18',`create_date` = '2025-02-15 17:09:25',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020076428' and product_code = 'ZS010201-01' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020076428' and product_code = 'DG010312-05' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269741','8','O25020076428','【原味+巧克力】金8結禮盒','DG010312-05','DG010312','金8結盒','禮盒-金8結【原味+巧克力】','590','480','0','0','0','0','1','480.0','1','480','2025-02-18','2025-02-15 17:09:25','2025-02-15 23:59:09',null,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269741',`firm_id` = '8',`ordernumber` = 'O25020076428', `product_name` = '【原味+巧克力】金8結禮盒',`product_code` = 'DG010312-05',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+巧克力】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2025-02-18',`create_date` = '2025-02-15 17:09:25',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020076428' and product_code = 'DG010312-05' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020076428' and product_code = 'LS010104-03' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269741','8','O25020076428','分享包-乳酪絲','LS010104-03','LS010104','45g黑松露乳酪絲','(藍袋)乳酪絲【黑松露】','200','200','0','0','0','0','1','0.0','1','200','2025-02-18','2025-02-15 17:09:25','2025-02-15 23:59:09',null,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269741',`firm_id` = '8',`ordernumber` = 'O25020076428', `product_name` = '分享包-乳酪絲',`product_code` = 'LS010104-03',`product_sn` = 'LS010104',`product_spec` = '45g黑松露乳酪絲',`invoice_name` = '(藍袋)乳酪絲【黑松露】',`listprice` = '200',`sellingprice` = '200',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '200',`etd` = '2025-02-18',`create_date` = '2025-02-15 17:09:25',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020076428' and product_code = 'LS010104-03' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020076428' and product_code = 'LS010104-01' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269741','8','O25020076428','分享包-乳酪絲','LS010104-01','LS010104','45g原味乳酪絲','(藍袋)乳酪絲【原味】','200','200','0','0','0','0','1','0.0','1','200','2025-02-18','2025-02-15 17:09:25','2025-02-15 23:59:09',null,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269741',`firm_id` = '8',`ordernumber` = 'O25020076428', `product_name` = '分享包-乳酪絲',`product_code` = 'LS010104-01',`product_sn` = 'LS010104',`product_spec` = '45g原味乳酪絲',`invoice_name` = '(藍袋)乳酪絲【原味】',`listprice` = '200',`sellingprice` = '200',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '200',`etd` = '2025-02-18',`create_date` = '2025-02-15 17:09:25',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020076428' and product_code = 'LS010104-01' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020076428' and product_code = 'TG010117-01' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269741','8','O25020076428','分享包-南棗核桃糕','TG010117-01','TG010117','25入核棗糕分享包','(紅袋)南棗核桃糕','300','300','0','0','0','0','1','0.0','1','300','2025-02-18','2025-02-15 17:09:25','2025-02-15 23:59:09',null,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269741',`firm_id` = '8',`ordernumber` = 'O25020076428', `product_name` = '分享包-南棗核桃糕',`product_code` = 'TG010117-01',`product_sn` = 'TG010117',`product_spec` = '25入核棗糕分享包',`invoice_name` = '(紅袋)南棗核桃糕',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '300',`etd` = '2025-02-18',`create_date` = '2025-02-15 17:09:25',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020076428' and product_code = 'TG010117-01' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020076428' and product_code = 'DG010101-01' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269741','8','O25020076428','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','1','280','2025-02-18','2025-02-15 17:09:25','2025-02-15 23:59:09',null,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269741',`firm_id` = '8',`ordernumber` = 'O25020076428', `product_name` = '經典原味蛋捲',`product_code` = 'DG010101-01',`product_sn` = 'DG010101',`product_spec` = '原味',`invoice_name` = '40入原味蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2025-02-18',`create_date` = '2025-02-15 17:09:25',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020076428' and product_code = 'DG010101-01' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020076428' and product_code = 'DG010312-03' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269741','8','O25020076428','【原味+咖啡】金8結禮盒','DG010312-03','DG010312','金8結盒','禮盒-金8結【原味+咖啡】','590','480','0','0','0','0','1','480.0','1','480','2025-02-18','2025-02-15 17:09:25','2025-02-15 23:59:09',null,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269741',`firm_id` = '8',`ordernumber` = 'O25020076428', `product_name` = '【原味+咖啡】金8結禮盒',`product_code` = 'DG010312-03',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+咖啡】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2025-02-18',`create_date` = '2025-02-15 17:09:25',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020076428' and product_code = 'DG010312-03' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020076428' and product_code = 'TE010107-01' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269741','8','O25020076428','蕎麥國寶茶','TE010107-01','TE010107','6入蕎麥國寶茶包','(盒)國寶茶','160','160','0','0','0','0','1','0.0','1','160','2025-02-18','2025-02-15 17:09:25','2025-02-15 23:59:09',null,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269741',`firm_id` = '8',`ordernumber` = 'O25020076428', `product_name` = '蕎麥國寶茶',`product_code` = 'TE010107-01',`product_sn` = 'TE010107',`product_spec` = '6入蕎麥國寶茶包',`invoice_name` = '(盒)國寶茶',`listprice` = '160',`sellingprice` = '160',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '160',`etd` = '2025-02-18',`create_date` = '2025-02-15 17:09:25',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020076428' and product_code = 'TE010107-01' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020076514' and product_code = 'DG010312-02' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269742','8','O25020076514','【原味+芝麻】金8結禮盒','DG010312-02','DG010312','金8結盒','禮盒-金8結【原味+芝麻】','590','480','0','0','0','0','1','480.0','19','9120','2025-02-18','2025-02-15 18:25:11','2025-02-15 23:59:09',null,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269742',`firm_id` = '8',`ordernumber` = 'O25020076514', `product_name` = '【原味+芝麻】金8結禮盒',`product_code` = 'DG010312-02',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+芝麻】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '19',`total_price` = '9120',`etd` = '2025-02-18',`create_date` = '2025-02-15 18:25:11',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020076514' and product_code = 'DG010312-02' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020076636' and product_code = 'DG010144-01' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269743','8','O25020076636','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','10','2800','2025-02-18','2025-02-15 18:41:35','2025-02-15 23:59:09',null,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269743',`firm_id` = '8',`ordernumber` = 'O25020076636', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '10',`total_price` = '2800',`etd` = '2025-02-18',`create_date` = '2025-02-15 18:41:35',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020076636' and product_code = 'DG010144-01' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020076711' and product_code = 'DG010144-01' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269744','8','O25020076711','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','1','280','2025-02-18','2025-02-15 19:02:54','2025-02-15 23:59:09',null,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269744',`firm_id` = '8',`ordernumber` = 'O25020076711', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '280',`etd` = '2025-02-18',`create_date` = '2025-02-15 19:02:54',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020076711' and product_code = 'DG010144-01' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020076875' and product_code = 'DG010144-01' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269745','8','O25020076875','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','2','560','2025-02-18','2025-02-15 19:15:51','2025-02-15 23:59:09',null,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269745',`firm_id` = '8',`ordernumber` = 'O25020076875', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '560',`etd` = '2025-02-18',`create_date` = '2025-02-15 19:15:51',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020076875' and product_code = 'DG010144-01' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020076875' and product_code = 'DG010527-01' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269745','8','O25020076875','8結蛋捲【小禮袋裝】','DG010527-01','DG010527','40入原味蛋捲','組合-40入原味+8結小禮袋','290','290','0','0','0','0','1','0.0','2','580','2025-02-18','2025-02-15 19:15:51','2025-02-15 23:59:09',null,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269745',`firm_id` = '8',`ordernumber` = 'O25020076875', `product_name` = '8結蛋捲【小禮袋裝】',`product_code` = 'DG010527-01',`product_sn` = 'DG010527',`product_spec` = '40入原味蛋捲',`invoice_name` = '組合-40入原味+8結小禮袋',`listprice` = '290',`sellingprice` = '290',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '580',`etd` = '2025-02-18',`create_date` = '2025-02-15 19:15:51',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020076875' and product_code = 'DG010527-01' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020076875' and product_code = 'DG010312-02' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269745','8','O25020076875','【原味+芝麻】金8結禮盒','DG010312-02','DG010312','金8結盒','禮盒-金8結【原味+芝麻】','590','480','0','0','0','0','1','480.0','2','960','2025-02-18','2025-02-15 19:15:51','2025-02-15 23:59:09',null,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269745',`firm_id` = '8',`ordernumber` = 'O25020076875', `product_name` = '【原味+芝麻】金8結禮盒',`product_code` = 'DG010312-02',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+芝麻】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '2',`total_price` = '960',`etd` = '2025-02-18',`create_date` = '2025-02-15 19:15:51',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020076875' and product_code = 'DG010312-02' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020076960' and product_code = 'DG0103148-01' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269746','8','O25020076960','金典8結禮盒','DG0103148-01','DG0103148','原味+原味','禮盒-金典(紅)【原味+原味】','480','480','0','0','0','0','1','0.0','4','1920','2025-02-18','2025-02-15 19:25:07','2025-02-15 23:59:09',null,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269746',`firm_id` = '8',`ordernumber` = 'O25020076960', `product_name` = '金典8結禮盒',`product_code` = 'DG0103148-01',`product_sn` = 'DG0103148',`product_spec` = '原味+原味',`invoice_name` = '禮盒-金典(紅)【原味+原味】',`listprice` = '480',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '4',`total_price` = '1920',`etd` = '2025-02-18',`create_date` = '2025-02-15 19:25:07',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020076960' and product_code = 'DG0103148-01' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S25020077094' and product_code = 'DG010275-02' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269747','8','S25020077094','【小王子聯名】玫瑰星球8結提盒','DG010275-02','DG010275','芝麻','提盒-小王子(NEW)-40入芝麻','300','300','0','0','0','0','1','0.0','6','1800','2025-02-17','2025-02-15 19:49:01','2025-02-15 23:59:09',0,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269747',`firm_id` = '8',`ordernumber` = 'S25020077094', `product_name` = '【小王子聯名】玫瑰星球8結提盒',`product_code` = 'DG010275-02',`product_sn` = 'DG010275',`product_spec` = '芝麻',`invoice_name` = '提盒-小王子(NEW)-40入芝麻',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '6',`total_price` = '1800',`etd` = '2025-02-17',`create_date` = '2025-02-15 19:49:01',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'S25020077094' and product_code = 'DG010275-02' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S25020077094' and product_code = 'DG010275-03' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269747','8','S25020077094','【小王子聯名】玫瑰星球8結提盒','DG010275-03','DG010275','咖啡','提盒-小王子(NEW)-40入咖啡','300','300','0','0','0','0','1','0.0','6','1800','2025-02-17','2025-02-15 19:49:01','2025-02-15 23:59:09',0,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269747',`firm_id` = '8',`ordernumber` = 'S25020077094', `product_name` = '【小王子聯名】玫瑰星球8結提盒',`product_code` = 'DG010275-03',`product_sn` = 'DG010275',`product_spec` = '咖啡',`invoice_name` = '提盒-小王子(NEW)-40入咖啡',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '6',`total_price` = '1800',`etd` = '2025-02-17',`create_date` = '2025-02-15 19:49:01',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'S25020077094' and product_code = 'DG010275-03' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S25020077094' and product_code = 'DG0103182-10' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269747','8','S25020077094','金巧8結禮盒','DG0103182-10','DG0103182','原味.鳳梨酥.國寶茶','禮盒-金巧8結【(原味)-鳳梨酥+國寶茶】','590','590','0','0','0','0','1','0.0','15','8850','2025-02-17','2025-02-15 19:49:01','2025-02-15 23:59:09',0,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269747',`firm_id` = '8',`ordernumber` = 'S25020077094', `product_name` = '金巧8結禮盒',`product_code` = 'DG0103182-10',`product_sn` = 'DG0103182',`product_spec` = '原味.鳳梨酥.國寶茶',`invoice_name` = '禮盒-金巧8結【(原味)-鳳梨酥+國寶茶】',`listprice` = '590',`sellingprice` = '590',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '15',`total_price` = '8850',`etd` = '2025-02-17',`create_date` = '2025-02-15 19:49:01',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'S25020077094' and product_code = 'DG0103182-10' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S25020077094' and product_code = 'DG010347-01' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269747','8','S25020077094','六月初一&成真咖啡禮盒','DG010347-01','DG010347','原味蛋捲+6入咖啡','禮盒-ESG藍金【原味+成真咖啡】','495','495','0','0','0','0','1','0.0','15','7425','2025-02-17','2025-02-15 19:49:01','2025-02-15 23:59:09',0,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269747',`firm_id` = '8',`ordernumber` = 'S25020077094', `product_name` = '六月初一&成真咖啡禮盒',`product_code` = 'DG010347-01',`product_sn` = 'DG010347',`product_spec` = '原味蛋捲+6入咖啡',`invoice_name` = '禮盒-ESG藍金【原味+成真咖啡】',`listprice` = '495',`sellingprice` = '495',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '15',`total_price` = '7425',`etd` = '2025-02-17',`create_date` = '2025-02-15 19:49:01',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'S25020077094' and product_code = 'DG010347-01' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S25020039496' and product_code = 'DG010143-01' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269371','8','S25020039496','可可烤布蕾蛋捲','DG010143-01','DG010143','32入可可烤布蕾蛋捲','32入可可烤布蕾蛋捲','240','240','0','0','0','0','1','0.0','11','2640','2025-02-17','2025-02-15 19:53:59','2025-02-15 23:59:09',null,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269371',`firm_id` = '8',`ordernumber` = 'S25020039496', `product_name` = '可可烤布蕾蛋捲',`product_code` = 'DG010143-01',`product_sn` = 'DG010143',`product_spec` = '32入可可烤布蕾蛋捲',`invoice_name` = '32入可可烤布蕾蛋捲',`listprice` = '240',`sellingprice` = '240',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '11',`total_price` = '2640',`etd` = '2025-02-17',`create_date` = '2025-02-15 19:53:59',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'S25020039496' and product_code = 'DG010143-01' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S25020077151' and product_code = 'DG010143-01' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269748','8','S25020077151','可可烤布蕾蛋捲','DG010143-01','DG010143','32入可可烤布蕾蛋捲','32入可可烤布蕾蛋捲','240','240','0','0','0','0','1','0.0','11','2640','2025-02-17','2025-02-15 19:53:59','2025-02-15 23:59:09',null,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269748',`firm_id` = '8',`ordernumber` = 'S25020077151', `product_name` = '可可烤布蕾蛋捲',`product_code` = 'DG010143-01',`product_sn` = 'DG010143',`product_spec` = '32入可可烤布蕾蛋捲',`invoice_name` = '32入可可烤布蕾蛋捲',`listprice` = '240',`sellingprice` = '240',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '11',`total_price` = '2640',`etd` = '2025-02-17',`create_date` = '2025-02-15 19:53:59',`modify_date` = '2025-02-15 19:54:24',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'S25020077151' and product_code = 'DG010143-01' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020077278' and product_code = 'DG010144-01' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269749','8','O25020077278','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','1','280','2025-02-18','2025-02-15 19:57:28','2025-02-15 23:59:09',null,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269749',`firm_id` = '8',`ordernumber` = 'O25020077278', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '280',`etd` = '2025-02-18',`create_date` = '2025-02-15 19:57:28',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020077278' and product_code = 'DG010144-01' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020077278' and product_code = 'DG010101-05' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269749','8','O25020077278','濃情巧克力蛋捲','DG010101-05','DG010101','巧克力','40入巧克力蛋捲','320','280','0','0','0','0','1','280.0','1','280','2025-02-18','2025-02-15 19:57:28','2025-02-15 23:59:09',null,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269749',`firm_id` = '8',`ordernumber` = 'O25020077278', `product_name` = '濃情巧克力蛋捲',`product_code` = 'DG010101-05',`product_sn` = 'DG010101',`product_spec` = '巧克力',`invoice_name` = '40入巧克力蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2025-02-18',`create_date` = '2025-02-15 19:57:28',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020077278' and product_code = 'DG010101-05' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020077316' and product_code = 'DG010312-06' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269750','8','O25020077316','【芝麻＋芝麻】金8結禮盒','DG010312-06','DG010312','金8結盒','禮盒-金8結【芝麻+芝麻】','590','480','0','0','0','0','1','480.0','10','4800','2025-02-18','2025-02-15 20:22:52','2025-02-15 23:59:09',null,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269750',`firm_id` = '8',`ordernumber` = 'O25020077316', `product_name` = '【芝麻＋芝麻】金8結禮盒',`product_code` = 'DG010312-06',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【芝麻+芝麻】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '10',`total_price` = '4800',`etd` = '2025-02-18',`create_date` = '2025-02-15 20:22:52',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020077316' and product_code = 'DG010312-06' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020077316' and product_code = 'DG010312-15' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269750','8','O25020077316','【巧克力＋巧克力】金8結禮盒','DG010312-15','DG010312','金8結盒','禮盒-金8結【巧克力+巧克力】','590','480','0','0','0','0','1','480.0','6','2880','2025-02-18','2025-02-15 20:22:52','2025-02-15 23:59:09',null,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269750',`firm_id` = '8',`ordernumber` = 'O25020077316', `product_name` = '【巧克力＋巧克力】金8結禮盒',`product_code` = 'DG010312-15',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【巧克力+巧克力】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '6',`total_price` = '2880',`etd` = '2025-02-18',`create_date` = '2025-02-15 20:22:52',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020077316' and product_code = 'DG010312-15' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020077316' and product_code = 'DG010312-01' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269750','8','O25020077316','【原味＋原味】金8結禮盒','DG010312-01','DG010312','金8結盒','禮盒-金8結【原味+原味】','590','480','0','0','0','0','1','480.0','12','5760','2025-02-18','2025-02-15 20:22:52','2025-02-15 23:59:09',null,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269750',`firm_id` = '8',`ordernumber` = 'O25020077316', `product_name` = '【原味＋原味】金8結禮盒',`product_code` = 'DG010312-01',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+原味】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '12',`total_price` = '5760',`etd` = '2025-02-18',`create_date` = '2025-02-15 20:22:52',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020077316' and product_code = 'DG010312-01' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020077438' and product_code = 'DG010144-01' 2025-02-15 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269751','8','O25020077438','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','4','1120','2025-02-18','2025-02-15 20:51:25','2025-02-15 23:59:09',null,'1','2025-01-18') 2025-02-15 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269751',`firm_id` = '8',`ordernumber` = 'O25020077438', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '4',`total_price` = '1120',`etd` = '2025-02-18',`create_date` = '2025-02-15 20:51:25',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020077438' and product_code = 'DG010144-01' 2025-02-15 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020077438' and product_code = 'DG010101-03' 2025-02-15 23:59:10 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269751','8','O25020077438','極上咖啡蛋捲','DG010101-03','DG010101','咖啡','40入咖啡蛋捲','320','280','0','0','0','0','1','280.0','1','280','2025-02-18','2025-02-15 20:51:25','2025-02-15 23:59:09',null,'1','2025-01-18') 2025-02-15 23:59:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269751',`firm_id` = '8',`ordernumber` = 'O25020077438', `product_name` = '極上咖啡蛋捲',`product_code` = 'DG010101-03',`product_sn` = 'DG010101',`product_spec` = '咖啡',`invoice_name` = '40入咖啡蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2025-02-18',`create_date` = '2025-02-15 20:51:25',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020077438' and product_code = 'DG010101-03' 2025-02-15 23:59:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020077560' and product_code = 'DG010144-01' 2025-02-15 23:59:10 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269752','8','O25020077560','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','2','560','2025-02-18','2025-02-15 20:56:26','2025-02-15 23:59:10',null,'1','2025-01-18') 2025-02-15 23:59:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269752',`firm_id` = '8',`ordernumber` = 'O25020077560', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '560',`etd` = '2025-02-18',`create_date` = '2025-02-15 20:56:26',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020077560' and product_code = 'DG010144-01' 2025-02-15 23:59:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020077560' and product_code = 'DG010143-01' 2025-02-15 23:59:10 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269752','8','O25020077560','可可烤布蕾蛋捲','DG010143-01','DG010143','32入可可烤布蕾蛋捲','32入可可烤布蕾蛋捲','240','240','0','0','0','0','1','0.0','1','240','2025-02-18','2025-02-15 20:56:26','2025-02-15 23:59:10',null,'1','2025-01-18') 2025-02-15 23:59:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269752',`firm_id` = '8',`ordernumber` = 'O25020077560', `product_name` = '可可烤布蕾蛋捲',`product_code` = 'DG010143-01',`product_sn` = 'DG010143',`product_spec` = '32入可可烤布蕾蛋捲',`invoice_name` = '32入可可烤布蕾蛋捲',`listprice` = '240',`sellingprice` = '240',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '240',`etd` = '2025-02-18',`create_date` = '2025-02-15 20:56:26',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020077560' and product_code = 'DG010143-01' 2025-02-15 23:59:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020077656' and product_code = 'DG010144-01' 2025-02-15 23:59:10 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269753','8','O25020077656','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','7','1960','2025-02-18','2025-02-15 21:05:27','2025-02-15 23:59:10',null,'1','2025-01-18') 2025-02-15 23:59:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269753',`firm_id` = '8',`ordernumber` = 'O25020077656', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '7',`total_price` = '1960',`etd` = '2025-02-18',`create_date` = '2025-02-15 21:05:27',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020077656' and product_code = 'DG010144-01' 2025-02-15 23:59:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020077656' and product_code = 'DG010101-05' 2025-02-15 23:59:10 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269753','8','O25020077656','濃情巧克力蛋捲','DG010101-05','DG010101','巧克力','40入巧克力蛋捲','320','280','0','0','0','0','1','280.0','3','840','2025-02-18','2025-02-15 21:05:27','2025-02-15 23:59:10',null,'1','2025-01-18') 2025-02-15 23:59:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269753',`firm_id` = '8',`ordernumber` = 'O25020077656', `product_name` = '濃情巧克力蛋捲',`product_code` = 'DG010101-05',`product_sn` = 'DG010101',`product_spec` = '巧克力',`invoice_name` = '40入巧克力蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '3',`total_price` = '840',`etd` = '2025-02-18',`create_date` = '2025-02-15 21:05:27',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020077656' and product_code = 'DG010101-05' 2025-02-15 23:59:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020077741' and product_code = 'DG010144-01' 2025-02-15 23:59:10 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269754','8','O25020077741','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','1','280','2025-02-18','2025-02-15 21:05:32','2025-02-15 23:59:10',null,'1','2025-01-18') 2025-02-15 23:59:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269754',`firm_id` = '8',`ordernumber` = 'O25020077741', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '280',`etd` = '2025-02-18',`create_date` = '2025-02-15 21:05:32',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020077741' and product_code = 'DG010144-01' 2025-02-15 23:59:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020077741' and product_code = 'DG010312-08' 2025-02-15 23:59:10 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269754','8','O25020077741','【芝麻+海苔】金8結禮盒','DG010312-08','DG010312','金8結盒','禮盒-金8結【芝麻+海苔】','590','480','0','0','0','0','1','480.0','1','480','2025-02-18','2025-02-15 21:05:32','2025-02-15 23:59:10',null,'1','2025-01-18') 2025-02-15 23:59:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269754',`firm_id` = '8',`ordernumber` = 'O25020077741', `product_name` = '【芝麻+海苔】金8結禮盒',`product_code` = 'DG010312-08',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【芝麻+海苔】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2025-02-18',`create_date` = '2025-02-15 21:05:32',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020077741' and product_code = 'DG010312-08' 2025-02-15 23:59:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020077741' and product_code = 'LS010143-01' 2025-02-15 23:59:10 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269754','8','O25020077741','香酥岩烤海苔(純素)','LS010143-01','LS010143','一組','香酥岩烤海苔','150','150','0','0','0','0','1','0.0','1','150','2025-02-18','2025-02-15 21:05:32','2025-02-15 23:59:10',null,'1','2025-01-18') 2025-02-15 23:59:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269754',`firm_id` = '8',`ordernumber` = 'O25020077741', `product_name` = '香酥岩烤海苔(純素)',`product_code` = 'LS010143-01',`product_sn` = 'LS010143',`product_spec` = '一組',`invoice_name` = '香酥岩烤海苔',`listprice` = '150',`sellingprice` = '150',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '150',`etd` = '2025-02-18',`create_date` = '2025-02-15 21:05:32',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020077741' and product_code = 'LS010143-01' 2025-02-15 23:59:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020077848' and product_code = 'DG010143-01' 2025-02-15 23:59:10 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269755','8','O25020077848','可可烤布蕾蛋捲','DG010143-01','DG010143','32入可可烤布蕾蛋捲','32入可可烤布蕾蛋捲','240','240','0','0','0','0','1','0.0','2','480','2025-02-18','2025-02-15 21:49:00','2025-02-15 23:59:10',null,'1','2025-01-18') 2025-02-15 23:59:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269755',`firm_id` = '8',`ordernumber` = 'O25020077848', `product_name` = '可可烤布蕾蛋捲',`product_code` = 'DG010143-01',`product_sn` = 'DG010143',`product_spec` = '32入可可烤布蕾蛋捲',`invoice_name` = '32入可可烤布蕾蛋捲',`listprice` = '240',`sellingprice` = '240',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '480',`etd` = '2025-02-18',`create_date` = '2025-02-15 21:49:00',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020077848' and product_code = 'DG010143-01' 2025-02-15 23:59:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020077848' and product_code = 'DG010144-01' 2025-02-15 23:59:10 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269755','8','O25020077848','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','1','280','2025-02-18','2025-02-15 21:49:00','2025-02-15 23:59:10',null,'1','2025-01-18') 2025-02-15 23:59:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269755',`firm_id` = '8',`ordernumber` = 'O25020077848', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '280',`etd` = '2025-02-18',`create_date` = '2025-02-15 21:49:00',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020077848' and product_code = 'DG010144-01' 2025-02-15 23:59:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020077955' and product_code = 'DG010312-02' 2025-02-15 23:59:10 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269756','8','O25020077955','【原味+芝麻】金8結禮盒','DG010312-02','DG010312','金8結盒','禮盒-金8結【原味+芝麻】','590','480','0','0','0','0','1','480.0','1','480','2025-02-18','2025-02-15 22:06:26','2025-02-15 23:59:10',null,'1','2025-01-18') 2025-02-15 23:59:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269756',`firm_id` = '8',`ordernumber` = 'O25020077955', `product_name` = '【原味+芝麻】金8結禮盒',`product_code` = 'DG010312-02',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+芝麻】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2025-02-18',`create_date` = '2025-02-15 22:06:26',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020077955' and product_code = 'DG010312-02' 2025-02-15 23:59:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020078095' and product_code = 'DG010144-01' 2025-02-15 23:59:10 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269757','8','O25020078095','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','1','280','2025-02-18','2025-02-15 23:02:29','2025-02-15 23:59:10',null,'1','2025-01-18') 2025-02-15 23:59:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269757',`firm_id` = '8',`ordernumber` = 'O25020078095', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '280',`etd` = '2025-02-18',`create_date` = '2025-02-15 23:02:29',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020078095' and product_code = 'DG010144-01' 2025-02-15 23:59:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020078095' and product_code = 'DG010143-01' 2025-02-15 23:59:10 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269757','8','O25020078095','可可烤布蕾蛋捲','DG010143-01','DG010143','32入可可烤布蕾蛋捲','32入可可烤布蕾蛋捲','240','240','0','0','0','0','1','0.0','1','240','2025-02-18','2025-02-15 23:02:29','2025-02-15 23:59:10',null,'1','2025-01-18') 2025-02-15 23:59:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269757',`firm_id` = '8',`ordernumber` = 'O25020078095', `product_name` = '可可烤布蕾蛋捲',`product_code` = 'DG010143-01',`product_sn` = 'DG010143',`product_spec` = '32入可可烤布蕾蛋捲',`invoice_name` = '32入可可烤布蕾蛋捲',`listprice` = '240',`sellingprice` = '240',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '240',`etd` = '2025-02-18',`create_date` = '2025-02-15 23:02:29',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020078095' and product_code = 'DG010143-01' 2025-02-15 23:59:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020078095' and product_code = 'DG010101-01' 2025-02-15 23:59:10 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269757','8','O25020078095','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','2','560','2025-02-18','2025-02-15 23:02:29','2025-02-15 23:59:10',null,'1','2025-01-18') 2025-02-15 23:59:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269757',`firm_id` = '8',`ordernumber` = 'O25020078095', `product_name` = '經典原味蛋捲',`product_code` = 'DG010101-01',`product_sn` = 'DG010101',`product_spec` = '原味',`invoice_name` = '40入原味蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '2',`total_price` = '560',`etd` = '2025-02-18',`create_date` = '2025-02-15 23:02:29',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020078095' and product_code = 'DG010101-01' 2025-02-15 23:59:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020078188' and product_code = 'DG010144-01' 2025-02-15 23:59:10 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269758','8','O25020078188','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','2','560','2025-02-19','2025-02-15 23:27:06','2025-02-15 23:59:10',null,'1','2025-01-18') 2025-02-15 23:59:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269758',`firm_id` = '8',`ordernumber` = 'O25020078188', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '560',`etd` = '2025-02-19',`create_date` = '2025-02-15 23:27:06',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020078188' and product_code = 'DG010144-01' 2025-02-15 23:59:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020078231' and product_code = 'DG010312-05' 2025-02-15 23:59:10 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269759','8','O25020078231','【原味+巧克力】金8結禮盒','DG010312-05','DG010312','金8結盒','禮盒-金8結【原味+巧克力】','590','480','0','0','0','0','1','480.0','1','480','2025-02-18','2025-02-15 23:29:42','2025-02-15 23:59:10',null,'1','2025-01-18') 2025-02-15 23:59:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269759',`firm_id` = '8',`ordernumber` = 'O25020078231', `product_name` = '【原味+巧克力】金8結禮盒',`product_code` = 'DG010312-05',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+巧克力】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2025-02-18',`create_date` = '2025-02-15 23:29:42',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020078231' and product_code = 'DG010312-05' 2025-02-15 23:59:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020078231' and product_code = 'DG010312-12' 2025-02-15 23:59:10 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269759','8','O25020078231','【咖啡+巧克力】金8結禮盒','DG010312-12','DG010312','金8結盒','禮盒-金8結【咖啡+巧克力】','590','480','0','0','0','0','1','480.0','1','480','2025-02-18','2025-02-15 23:29:42','2025-02-15 23:59:10',null,'1','2025-01-18') 2025-02-15 23:59:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269759',`firm_id` = '8',`ordernumber` = 'O25020078231', `product_name` = '【咖啡+巧克力】金8結禮盒',`product_code` = 'DG010312-12',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【咖啡+巧克力】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2025-02-18',`create_date` = '2025-02-15 23:29:42',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020078231' and product_code = 'DG010312-12' 2025-02-15 23:59:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020078332' and product_code = 'DG010144-01' 2025-02-15 23:59:10 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269760','8','O25020078332','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','3','840','2025-02-18','2025-02-15 23:32:00','2025-02-15 23:59:10',null,'1','2025-01-18') 2025-02-15 23:59:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269760',`firm_id` = '8',`ordernumber` = 'O25020078332', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '3',`total_price` = '840',`etd` = '2025-02-18',`create_date` = '2025-02-15 23:32:00',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020078332' and product_code = 'DG010144-01' 2025-02-15 23:59:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020078332' and product_code = 'DG010143-01' 2025-02-15 23:59:10 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269760','8','O25020078332','可可烤布蕾蛋捲','DG010143-01','DG010143','32入可可烤布蕾蛋捲','32入可可烤布蕾蛋捲','240','240','0','0','0','0','1','0.0','2','480','2025-02-18','2025-02-15 23:32:00','2025-02-15 23:59:10',null,'1','2025-01-18') 2025-02-15 23:59:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269760',`firm_id` = '8',`ordernumber` = 'O25020078332', `product_name` = '可可烤布蕾蛋捲',`product_code` = 'DG010143-01',`product_sn` = 'DG010143',`product_spec` = '32入可可烤布蕾蛋捲',`invoice_name` = '32入可可烤布蕾蛋捲',`listprice` = '240',`sellingprice` = '240',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '480',`etd` = '2025-02-18',`create_date` = '2025-02-15 23:32:00',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020078332' and product_code = 'DG010143-01' 2025-02-15 23:59:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020078332' and product_code = 'DG010101-05' 2025-02-15 23:59:10 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269760','8','O25020078332','濃情巧克力蛋捲','DG010101-05','DG010101','巧克力','40入巧克力蛋捲','320','280','0','0','0','0','1','280.0','2','560','2025-02-18','2025-02-15 23:32:00','2025-02-15 23:59:10',null,'1','2025-01-18') 2025-02-15 23:59:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269760',`firm_id` = '8',`ordernumber` = 'O25020078332', `product_name` = '濃情巧克力蛋捲',`product_code` = 'DG010101-05',`product_sn` = 'DG010101',`product_spec` = '巧克力',`invoice_name` = '40入巧克力蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '2',`total_price` = '560',`etd` = '2025-02-18',`create_date` = '2025-02-15 23:32:00',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020078332' and product_code = 'DG010101-05' 2025-02-15 23:59:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25020078332' and product_code = 'BP010128-01' 2025-02-15 23:59:10 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'269760','8','O25020078332','8結小禮袋','BP010128-01','BP010128','提袋/個','8結小禮袋','10','10','0','0','0','0','1','0.0','2','20','2025-02-18','2025-02-15 23:32:00','2025-02-15 23:59:10',null,'1','2025-01-18') 2025-02-15 23:59:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '269760',`firm_id` = '8',`ordernumber` = 'O25020078332', `product_name` = '8結小禮袋',`product_code` = 'BP010128-01',`product_sn` = 'BP010128',`product_spec` = '提袋/個',`invoice_name` = '8結小禮袋',`listprice` = '10',`sellingprice` = '10',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '20',`etd` = '2025-02-18',`create_date` = '2025-02-15 23:32:00',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-18'where ordernumber = 'O25020078332' and product_code = 'BP010128-01' 2025-02-15 23:59:10 -- == sync_order_detail end == 2025-02-15 23:59:10 -- == sync_order start == 2025-02-15 23:59:10 -- start:2025-02-15,end:2025-02-15 2025-02-15 23:59:10 -- == select june1.order_list == select l.mid,m.uid,l.category_name,l.category_id,l.ordernumber,l.location,l.payway,l.delivery_way,l.pay_status,l.process_status,l.company_number,l.company_title,l.invoice_status,l.etd,l.web_discount,l.class_discount,l.member_discount,l.web_gift,l.freight,l.entity_discount,l.totalprice,l.orderzip,l.orderaddresscity,l.orderaddressarea,l.recipientzip,l.recipientaddresscity,l.recipientaddressarea,l.totalprice_after-web_discount-class_discount-member_discount-entity_discount as totalprice_after,l.create_date FROM `order_list` l LEFT JOIN member_list m on l.mid = m.id WHERE l.create_date like '2025-02-15%' OR l.modify_date like '2025-02-15%'; 2025-02-15 23:59:10 -- == sync omo_order_list == 2025-02-15 23:59:10 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('158241','434187',2,'正式彌,美村門市訂單','1,21','M25020012687','1','1','1','0','6','','','0','2025-02-17','0','0','0','','0','0','600','824','高雄市','燕巢區','824','高雄市','燕巢區','600','2025-02-15 12:17:19','2025-01-18') 2025-02-15 23:59:10 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('158241','434187',2,'正式彌,美村門市訂單','1,21','M25020012754','1','1','1','0','6','','','0','2025-02-17','0','0','0','','0','0','600','824','高雄市','燕巢區','824','高雄市','燕巢區','600','2025-02-15 12:23:06','2025-01-18') 2025-02-15 23:59:10 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('158241','434187',2,'正式彌,美村門市訂單','1,21','M25020012842','1','1','6','0','6','','','0','2025-02-17','0','0','0','','0','0','600','824','高雄市','燕巢區','824','高雄市','燕巢區','600','2025-02-15 12:24:10','2025-01-18') 2025-02-15 23:59:10 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('158241','434187',2,'正式彌,美村門市訂單','1,21','M25020012987','1','1','1','1','1','','','0','2025-02-17','0','30','0','','0','0','600','824','高雄市','燕巢區','824','高雄市','燕巢區','570','2025-02-15 12:31:56','2025-01-18') 2025-02-15 23:59:10 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('160618','436533',2,'','','B25020013055','1','11','1','1','1','','','0','0000-00-00','0','0','0','','0','100','5600','800','高雄市','新興區','800','高雄市','新興區','5500','2025-02-15 20:13:00','2025-01-18') 2025-02-15 23:59:10 -- == sync_order end == 2025-02-15 23:59:10 -- == sync_order_detail start == 2025-02-15 23:59:10 -- start:2025-02-15,end:2025-02-15 2025-02-15 23:59:10 -- == sync omo_order_detail == 2025-02-15 23:59:10 -- == SELECT order_detail == SELECT * from order_detail WHERE create_date like '2025-02-15%' OR modify_date like '2025-02-15%' 2025-02-15 23:59:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M25020012687' and product_code = 'DG010266-05' 2025-02-15 23:59:11 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`, `channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`,`lunar_date`) VALUES (null, 2,'34246','8','M25020012687','SNOOPY獨特心意-8結彌月提盒','DG010266-05','DG010266','巧克力','提盒-彌月SNOOPY(粉)-40入巧克力','300','300','0','0','0','0','1','0.0','2','600','2025-02-17','2025-02-15 12:17:19','2025-02-15 23:59:11',null,'1','2025-01-18') 2025-02-15 23:59:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '34246',`firm_id` = '8',`ordernumber` = 'M25020012687', `product_name` = 'SNOOPY獨特心意-8結彌月提盒',`product_code` = 'DG010266-05',`product_sn` = 'DG010266',`product_spec` = '巧克力',`invoice_name` = '提盒-彌月SNOOPY(粉)-40入巧克力',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '600',`etd` = '2025-02-17',`create_date` = '2025-02-15 12:17:19',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M25020012687' and product_code = 'DG010266-05', `lunar_date` = '2025-01-18' 2025-02-15 23:59:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M25020012754' and product_code = 'DG010266-05' 2025-02-15 23:59:11 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`, `channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`,`lunar_date`) VALUES (null, 2,'34247','8','M25020012754','SNOOPY獨特心意-8結彌月提盒','DG010266-05','DG010266','巧克力','提盒-彌月SNOOPY(粉)-40入巧克力','300','300','0','0','0','0','1','0.0','2','600','2025-02-17','2025-02-15 12:17:19','2025-02-15 23:59:11',null,'1','2025-01-18') 2025-02-15 23:59:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '34247',`firm_id` = '8',`ordernumber` = 'M25020012754', `product_name` = 'SNOOPY獨特心意-8結彌月提盒',`product_code` = 'DG010266-05',`product_sn` = 'DG010266',`product_spec` = '巧克力',`invoice_name` = '提盒-彌月SNOOPY(粉)-40入巧克力',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '600',`etd` = '2025-02-17',`create_date` = '2025-02-15 12:17:19',`modify_date` = '2025-02-15 12:23:06',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M25020012754' and product_code = 'DG010266-05', `lunar_date` = '2025-01-18' 2025-02-15 23:59:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M25020012842' and product_code = 'DG010266-05' 2025-02-15 23:59:11 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`, `channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`,`lunar_date`) VALUES (null, 2,'34248','8','M25020012842','SNOOPY獨特心意-8結彌月提盒','DG010266-05','DG010266','巧克力','提盒-彌月SNOOPY(粉)-40入巧克力','300','300','0','0','0','0','1','0.0','2','600','2025-02-17','2025-02-15 12:17:19','2025-02-15 23:59:11',null,'1','2025-01-18') 2025-02-15 23:59:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '34248',`firm_id` = '8',`ordernumber` = 'M25020012842', `product_name` = 'SNOOPY獨特心意-8結彌月提盒',`product_code` = 'DG010266-05',`product_sn` = 'DG010266',`product_spec` = '巧克力',`invoice_name` = '提盒-彌月SNOOPY(粉)-40入巧克力',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '600',`etd` = '2025-02-17',`create_date` = '2025-02-15 12:17:19',`modify_date` = '2025-02-15 12:28:27',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M25020012842' and product_code = 'DG010266-05', `lunar_date` = '2025-01-18' 2025-02-15 23:59:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M25020012987' and product_code = 'DG010266-05' 2025-02-15 23:59:11 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`, `channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`,`lunar_date`) VALUES (null, 2,'34249','8','M25020012987','SNOOPY獨特心意-8結彌月提盒','DG010266-05','DG010266','巧克力','提盒-彌月SNOOPY(粉)-40入巧克力','300','300','0','0','0','0','1','0.0','2','600','2025-02-17','2025-02-15 12:31:56','2025-02-15 23:59:11',null,'1','2025-01-18') 2025-02-15 23:59:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '34249',`firm_id` = '8',`ordernumber` = 'M25020012987', `product_name` = 'SNOOPY獨特心意-8結彌月提盒',`product_code` = 'DG010266-05',`product_sn` = 'DG010266',`product_spec` = '巧克力',`invoice_name` = '提盒-彌月SNOOPY(粉)-40入巧克力',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '600',`etd` = '2025-02-17',`create_date` = '2025-02-15 12:31:56',`modify_date` = '2025-02-15 12:34:12',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M25020012987' and product_code = 'DG010266-05', `lunar_date` = '2025-01-18' 2025-02-15 23:59:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B25020013055' and product_code = 'DG0103224-09' 2025-02-15 23:59:11 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`, `channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`,`lunar_date`) VALUES (null, 2,'34250','8','B25020013055','【小王子聯名】玫瑰星球彌月禮盒','DG0103224-09','DG0103224','芝麻+巧克力','禮盒-彌月小王子(NEW)【芝麻+巧克力】','500','500','0','0','0','0','1','0.0','1','500','2025-02-26','2025-02-15 20:13:00','2025-02-15 23:59:11',null,'1','2025-01-18') 2025-02-15 23:59:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '34250',`firm_id` = '8',`ordernumber` = 'B25020013055', `product_name` = '【小王子聯名】玫瑰星球彌月禮盒',`product_code` = 'DG0103224-09',`product_sn` = 'DG0103224',`product_spec` = '芝麻+巧克力',`invoice_name` = '禮盒-彌月小王子(NEW)【芝麻+巧克力】',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '500',`etd` = '2025-02-26',`create_date` = '2025-02-15 20:13:00',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B25020013055' and product_code = 'DG0103224-09', `lunar_date` = '2025-01-18' 2025-02-15 23:59:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B25020013055' and product_code = 'DG010276-02' 2025-02-15 23:59:11 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`, `channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`,`lunar_date`) VALUES (null, 2,'34250','8','B25020013055','【小王子聯名】玫瑰星球彌月提盒','DG010276-02','DG010276','芝麻','提盒-彌月小王子(NEW)-40入芝麻','300','300','0','0','0','0','1','0.0','9','2700','2025-02-26','2025-02-15 20:13:00','2025-02-15 23:59:11',null,'1','2025-01-18') 2025-02-15 23:59:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '34250',`firm_id` = '8',`ordernumber` = 'B25020013055', `product_name` = '【小王子聯名】玫瑰星球彌月提盒',`product_code` = 'DG010276-02',`product_sn` = 'DG010276',`product_spec` = '芝麻',`invoice_name` = '提盒-彌月小王子(NEW)-40入芝麻',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '9',`total_price` = '2700',`etd` = '2025-02-26',`create_date` = '2025-02-15 20:13:00',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B25020013055' and product_code = 'DG010276-02', `lunar_date` = '2025-01-18' 2025-02-15 23:59:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B25020013055' and product_code = 'DG010276-01' 2025-02-15 23:59:11 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`, `channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`,`lunar_date`) VALUES (null, 2,'34250','8','B25020013055','【小王子聯名】玫瑰星球彌月提盒','DG010276-01','DG010276','原味','提盒-彌月小王子(NEW)-40入原味','300','300','0','0','0','0','1','0.0','8','2400','2025-02-26','2025-02-15 20:13:00','2025-02-15 23:59:11',null,'1','2025-01-18') 2025-02-15 23:59:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '34250',`firm_id` = '8',`ordernumber` = 'B25020013055', `product_name` = '【小王子聯名】玫瑰星球彌月提盒',`product_code` = 'DG010276-01',`product_sn` = 'DG010276',`product_spec` = '原味',`invoice_name` = '提盒-彌月小王子(NEW)-40入原味',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '8',`total_price` = '2400',`etd` = '2025-02-26',`create_date` = '2025-02-15 20:13:00',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B25020013055' and product_code = 'DG010276-01', `lunar_date` = '2025-01-18' 2025-02-15 23:59:11 -- == sync_order_detail end == 2025-02-15 23:59:11 -- == select one.order_list == SELECT o.code,o.pay_status,o.order_status,o.user_id,o.pay_method_id,o.activity_freight_id,o.freight_fee,o.items_total,o.total,DATE(o.shipped_at) as shipped_at,o.created_at as create_date, inv.company_number,inv.company_title,inv.invoice_status, cust.zipcode,cust.county,cust.district, rec.zipcode as recipientzip,rec.county as recipientaddresscity,rec.district as recipientaddressarea, af.type as freight_type FROM `orders` o LEFT JOIN systemlead_invoices inv on o.id = inv.order_id LEFT JOIN order_customers cust on o.id = cust.order_id LEFT JOIN order_receivers rec on o.id = rec.order_id LEFT JOIN activity_freights af on o.activity_freight_id = af.id WHERE (DATE(o.created_at) = '2025-02-15' OR o.updated_at = '2025-02-15') and o.deleted_at is null 2025-02-15 23:59:11 -- == sync_order_detail start == 2025-02-15 23:59:11 -- start:2025-02-15,end:2025-02-15 2025-02-15 23:59:12 -- step1: SELECT id,sku,combinations_product_spec_id FROM `product_specs` 2025-02-15 23:59:12 -- step2: SELECT * FROM `product_specs` WHERE combinations_product_spec_id is not null 2025-02-15 23:59:15 -- step3: SELECT id,product_code,product_sn FROM `omo_order_detail` WHERE `channel` = 6 and product_code like '%,%' and create_date LIKE '2025-02-15%';