2025-03-02 23:59:01 -- == sync_order start == 2025-03-02 23:59:01 -- start:2025-03-02,end:2025-03-02 2025-03-02 23:59:01 -- == 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-03-02%' OR l.modify_date like '2025-03-02%'; 2025-03-02 23:59:03 -- == sync omo_order_list == 2025-03-02 23:59:03 -- == 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 ('422870','459042',1,'','','O25030003411','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','580','802','高雄市','苓雅區','802','高雄市','苓雅區','700','2025-03-02 01:11:31','2025-02-03') 2025-03-02 23:59:03 -- == 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 ('422877','459049',1,'','','O25030003554','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','840','804','高雄市','鼓山區','804','高雄市','鼓山區','990','2025-03-02 09:22:31','2025-02-03') 2025-03-02 23:59:03 -- == 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 ('356065','392711',1,'','','O25030003691','1','2','1','1','1','','','0','0000-00-00','0','0','0','','150','0','2700','251','新北市','淡水區','251','新北市','淡水區','2850','2025-03-02 09:55:26','2025-02-03') 2025-03-02 23:59:03 -- == 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 ('293229','330655',1,'','','O25030003724','1','1','1','0','0','','','0','0000-00-00','0','0','0','','150','0','560','906','屏東縣','高樹鄉','906','屏東縣','高樹鄉','710','2025-03-02 10:50:42','2025-02-03') 2025-03-02 23:59:03 -- == 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 ('293229','330655',1,'','','O25030003854','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','560','906','屏東縣','高樹鄉','906','屏東縣','高樹鄉','710','2025-03-02 10:54:39','2025-02-03') 2025-03-02 23:59:03 -- == 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 ('422880','459052',1,'','','O25030003958','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1070','420','台中市','豐原區','429','台中市','神岡區','1190','2025-03-02 11:02:16','2025-02-03') 2025-03-02 23:59:03 -- == 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 ('422627','458803',1,'','','O25030004051','1','11','1','1','1','','','0','0000-00-00','472','0','0','','0','150','9450','116','台北市','文山區','234','新北市','永和區','8828','2025-03-02 11:14:38','2025-02-03') 2025-03-02 23:59:03 -- == 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 ('422883','459055',1,'','','O25030004130','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1080','723','台南市','西港區','723','台南市','西港區','1200','2025-03-02 11:40:36','2025-02-03') 2025-03-02 23:59:03 -- == 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 ('247587','280933',1,'','','O25030004234','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','2030','300','新竹市','東區','300','新竹市','東區','2180','2025-03-02 13:04:19','2025-02-03') 2025-03-02 23:59:03 -- == 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 ('422876','459048',1,'','','O25030004346','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1560','900','屏東縣','屏東市','900','屏東縣','屏東市','1680','2025-03-02 13:22:11','2025-02-03') 2025-03-02 23:59:03 -- == 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 ('422913','459082',1,'','','O25030004414','1','2','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1100','423','台中市','東勢區','423','台中市','東勢區','1220','2025-03-02 13:33:21','2025-02-03') 2025-03-02 23:59:03 -- == 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 ('421876','458062',1,'','','O25030004516','1','11','1','1','1','','','0','0000-00-00','0','0','0','','0','150','8120','110','台北市','信義區','110','台北市','信義區','7970','2025-03-02 13:57:08','2025-02-03') 2025-03-02 23:59:03 -- == 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 ('422938','459107',1,'','','O25030004612','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1120','712','台南市','新化區','712','台南市','新化區','1240','2025-03-02 14:10:06','2025-02-03') 2025-03-02 23:59:03 -- == 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 ('422965','459134',1,'','','O25030004776','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1960','302','新竹縣','竹北市','302','新竹縣','竹北市','2080','2025-03-02 15:20:48','2025-02-03') 2025-03-02 23:59:03 -- == 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,'','','O25030004859','1','1','1','1','1','27812261','育旌股份有限公司','0','0000-00-00','792','0','0','','0','0','15840','302','新竹縣','竹北市','302','新竹縣','竹北市','15048','2025-03-02 15:54:54','2025-02-03') 2025-03-02 23:59:03 -- == 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 ('422964','459133',1,'','','O25030004999','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','2900','243','新北市','泰山區','243','新北市','泰山區','3020','2025-03-02 17:46:54','2025-02-03') 2025-03-02 23:59:03 -- == 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 ('423026','459194',1,'','','O25030005045','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1030','830','高雄市','鳳山區','830','高雄市','鳳山區','1150','2025-03-02 18:29:23','2025-02-03') 2025-03-02 23:59:03 -- == 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 ('422197','458375',1,'','','O25030005152','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','800','814','高雄市','仁武區','814','高雄市','仁武區','920','2025-03-02 18:39:09','2025-02-03') 2025-03-02 23:59:03 -- == 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 ('423034','459202',1,'','','O25030005261','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1440','832','高雄市','林園區','832','高雄市','林園區','1590','2025-03-02 18:57:39','2025-02-03') 2025-03-02 23:59:03 -- == 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 ('95533','66851',1,'通路訂單','5','S25030005319','1','15','15','0','3','','','0','2025-03-02','0','588','0','','0','0','1960','403','台中市','西區','403','台中市','西區','1372','2025-03-02 19:26:05','2025-02-03') 2025-03-02 23:59:03 -- == 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 ('423044','459212',1,'','','O25030005471','1','2','1','0','0','','','0','0000-00-00','0','0','0','','150','30','3190','814','高雄市','仁武區','814','高雄市','仁武區','3310','2025-03-02 19:31:54','2025-02-03') 2025-03-02 23:59:03 -- == 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 ('359134','395759',1,'','','O25030005582','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','4160','234','新北市','永和區','234','新北市','永和區','4310','2025-03-02 19:59:21','2025-02-03') 2025-03-02 23:59:03 -- == 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 ('423045','459213',1,'','','O25030005687','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1030','302','新竹縣','竹北市','300','新竹市','北區','1150','2025-03-02 20:20:32','2025-02-03') 2025-03-02 23:59:03 -- == 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 ('418711','454950',1,'','','O25030005779','1','1','1','0','0','','','0','0000-00-00','0','0','0','','150','0','780','950','台東縣','台東市','950','台東縣','台東市','930','2025-03-02 20:24:49','2025-02-03') 2025-03-02 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 ('418711','454950',1,'','','O25030005837','1','2','1','0','0','','','0','0000-00-00','0','0','0','','150','0','760','950','台東縣','台東市','950','台東縣','台東市','910','2025-03-02 20:36:22','2025-02-03') 2025-03-02 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 ('410403','446464',1,'','','O25030005993','1','1','1','0','0','','','0','0000-00-00','0','0','0','','150','0','1180','632','雲林縣','虎尾鎮','632','雲林縣','虎尾鎮','1330','2025-03-02 20:48:49','2025-02-03') 2025-03-02 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 ('410403','446464',1,'','','O25030006023','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1180','632','雲林縣','虎尾鎮','632','雲林縣','虎尾鎮','1330','2025-03-02 20:53:00','2025-02-03') 2025-03-02 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 ('254303','288379',1,'','','O25030006169','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','480','206','基隆市','七堵區','830','高雄市','鳳山區','630','2025-03-02 22:21:21','2025-02-03') 2025-03-02 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 ('244070','276906',1,'','','O25030006295','1','1','1','0','0','','','0','0000-00-00','0','0','0','','150','0','2520','504','彰化縣','秀水鄉','504','彰化縣','秀水鄉','2670','2025-03-02 23:04:43','2025-02-03') 2025-03-02 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 ('244070','276906',1,'','','O25030006337','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','2520','504','彰化縣','秀水鄉','504','彰化縣','秀水鄉','2670','2025-03-02 23:08:16','2025-02-03') 2025-03-02 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 ('422167','458345',1,'','','O25030006495','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1640','625','嘉義縣','布袋鎮','625','嘉義縣','布袋鎮','1760','2025-03-02 23:13:11','2025-02-03') 2025-03-02 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 ('311244','348430',1,'','','O25030006552','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','150','1680','701','台南市','東區','701','台南市','東區','1680','2025-03-02 23:33:15','2025-02-03') 2025-03-02 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 ('421798','457985',1,'','','O25030006689','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','150','1560','338','桃園市','蘆竹區','338','桃園市','蘆竹區','1560','2025-03-02 23:41:59','2025-02-03') 2025-03-02 23:59:04 -- == sync_order end == 2025-03-02 23:59:04 -- == sync_order_detail start == 2025-03-02 23:59:04 -- start:2025-03-02,end:2025-03-02 2025-03-02 23:59:04 -- == sync omo_order_detail == 2025-03-02 23:59:04 -- == SELECT order_detail == SELECT * from order_detail WHERE create_date like '2025-03-02%' OR modify_date like '2025-03-02%' 2025-03-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030003411' and product_code = 'TG010117-01' 2025-03-02 23:59:05 -- == 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,'270521','8','O25030003411','分享包-南棗核桃糕','TG010117-01','TG010117','25入核棗糕分享包','(紅袋)南棗核桃糕','300','300','0','0','0','0','1','0.0','1','300','2025-03-04','2025-03-02 01:11:31','2025-03-02 23:59:05',null,'1','2025-02-03') 2025-03-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270521',`firm_id` = '8',`ordernumber` = 'O25030003411', `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-03-04',`create_date` = '2025-03-02 01:11:31',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030003411' and product_code = 'TG010117-01' 2025-03-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030003411' and product_code = 'DG010144-01' 2025-03-02 23:59:05 -- == 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,'270521','8','O25030003411','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','1','280','2025-03-04','2025-03-02 01:11:31','2025-03-02 23:59:05',null,'1','2025-02-03') 2025-03-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270521',`firm_id` = '8',`ordernumber` = 'O25030003411', `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-03-04',`create_date` = '2025-03-02 01:11:31',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030003411' and product_code = 'DG010144-01' 2025-03-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030003554' and product_code = 'DG010101-03' 2025-03-02 23:59:05 -- == 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,'270522','8','O25030003554','極上咖啡蛋捲','DG010101-03','DG010101','咖啡','40入咖啡蛋捲','320','280','0','0','0','0','1','280.0','1','280','2025-03-04','2025-03-02 09:22:31','2025-03-02 23:59:05',null,'1','2025-02-03') 2025-03-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270522',`firm_id` = '8',`ordernumber` = 'O25030003554', `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-03-04',`create_date` = '2025-03-02 09:22:31',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030003554' and product_code = 'DG010101-03' 2025-03-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030003554' and product_code = 'DG010101-05' 2025-03-02 23:59:06 -- == 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,'270522','8','O25030003554','濃情巧克力蛋捲','DG010101-05','DG010101','巧克力','40入巧克力蛋捲','320','280','0','0','0','0','1','280.0','2','560','2025-03-04','2025-03-02 09:22:31','2025-03-02 23:59:05',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270522',`firm_id` = '8',`ordernumber` = 'O25030003554', `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-03-04',`create_date` = '2025-03-02 09:22:31',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030003554' and product_code = 'DG010101-05' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030003691' and product_code = 'FL010310-01' 2025-03-02 23:59:06 -- == 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,'270523','8','O25030003691','一口酥24入家庭號禮盒','FL010310-01','12586','12入鳳梨酥+12入鳳梅酥','禮盒-24入家庭號【鳳梨酥+鳳梅酥】','540','540','0','0','0','0','1','0.0','5','2700','2025-03-05','2025-03-02 09:55:26','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270523',`firm_id` = '8',`ordernumber` = 'O25030003691', `product_name` = '一口酥24入家庭號禮盒',`product_code` = 'FL010310-01',`product_sn` = '12586',`product_spec` = '12入鳳梨酥+12入鳳梅酥',`invoice_name` = '禮盒-24入家庭號【鳳梨酥+鳳梅酥】',`listprice` = '540',`sellingprice` = '540',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '5',`total_price` = '2700',`etd` = '2025-03-05',`create_date` = '2025-03-02 09:55:26',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030003691' and product_code = 'FL010310-01' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030003724' and product_code = 'DG010144-01' 2025-03-02 23:59:06 -- == 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,'270524','8','O25030003724','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','2','560','2025-03-04','2025-03-02 10:50:42','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270524',`firm_id` = '8',`ordernumber` = 'O25030003724', `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-03-04',`create_date` = '2025-03-02 10:50:42',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030003724' and product_code = 'DG010144-01' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030003854' and product_code = 'DG010144-01' 2025-03-02 23:59:06 -- == 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,'270525','8','O25030003854','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','2','560','2025-03-04','2025-03-02 10:54:39','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270525',`firm_id` = '8',`ordernumber` = 'O25030003854', `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-03-04',`create_date` = '2025-03-02 10:54:39',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030003854' and product_code = 'DG010144-01' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030003958' and product_code = 'DG0105162-55' 2025-03-02 23:59:06 -- == 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,'270526','8','O25030003958','【抹茶季限定】一抹風雅帆布袋-蛋捲三入組','DG0105162-55','DG0105162','巧克力,抹茶,抹茶','組合-32入(巧克力+抹茶+抹茶)+抹茶季限定帆布袋','1070','1070','0','0','0','1','1','0.0','1','1070','2025-03-05','2025-03-02 11:02:16','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270526',`firm_id` = '8',`ordernumber` = 'O25030003958', `product_name` = '【抹茶季限定】一抹風雅帆布袋-蛋捲三入組',`product_code` = 'DG0105162-55',`product_sn` = 'DG0105162',`product_spec` = '巧克力,抹茶,抹茶',`invoice_name` = '組合-32入(巧克力+抹茶+抹茶)+抹茶季限定帆布袋',`listprice` = '1070',`sellingprice` = '1070',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1070',`etd` = '2025-03-05',`create_date` = '2025-03-02 11:02:16',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030003958' and product_code = 'DG0105162-55' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004051' and product_code = 'DG010144-01' 2025-03-02 23:59:06 -- == 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,'270527','8','O25030004051','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','7','1960','2025-03-04','2025-03-02 11:14:38','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270527',`firm_id` = '8',`ordernumber` = 'O25030004051', `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-03-04',`create_date` = '2025-03-02 11:14:38',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004051' and product_code = 'DG010144-01' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004051' and product_code = 'DG010143-01' 2025-03-02 23:59:06 -- == 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,'270527','8','O25030004051','可可烤布蕾蛋捲','DG010143-01','DG010143','32入可可烤布蕾蛋捲','32入可可烤布蕾蛋捲','240','240','0','0','0','0','1','0.0','5','1200','2025-03-04','2025-03-02 11:14:38','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270527',`firm_id` = '8',`ordernumber` = 'O25030004051', `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-03-04',`create_date` = '2025-03-02 11:14:38',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004051' and product_code = 'DG010143-01' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004051' and product_code = 'DG010101-01' 2025-03-02 23:59:06 -- == 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,'270527','8','O25030004051','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','3','840','2025-03-04','2025-03-02 11:14:38','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270527',`firm_id` = '8',`ordernumber` = 'O25030004051', `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` = '3',`total_price` = '840',`etd` = '2025-03-04',`create_date` = '2025-03-02 11:14:38',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004051' and product_code = 'DG010101-01' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004051' and product_code = 'DG010101-02' 2025-03-02 23:59:06 -- == 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,'270527','8','O25030004051','香醇芝麻蛋捲','DG010101-02','DG010101','芝麻','40入芝麻蛋捲','320','280','0','0','0','0','1','280.0','2','560','2025-03-04','2025-03-02 11:14:38','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270527',`firm_id` = '8',`ordernumber` = 'O25030004051', `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-03-04',`create_date` = '2025-03-02 11:14:38',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004051' and product_code = 'DG010101-02' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004051' and product_code = 'DG010101-03' 2025-03-02 23:59:06 -- == 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,'270527','8','O25030004051','極上咖啡蛋捲','DG010101-03','DG010101','咖啡','40入咖啡蛋捲','320','280','0','0','0','0','1','280.0','4','1120','2025-03-04','2025-03-02 11:14:38','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270527',`firm_id` = '8',`ordernumber` = 'O25030004051', `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` = '4',`total_price` = '1120',`etd` = '2025-03-04',`create_date` = '2025-03-02 11:14:38',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004051' and product_code = 'DG010101-03' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004051' and product_code = 'DG010101-04' 2025-03-02 23:59:06 -- == 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,'270527','8','O25030004051','日式海苔蛋捲','DG010101-04','DG010101','單盒','40入海苔蛋捲','320','280','0','0','0','0','1','280.0','1','280','2025-03-04','2025-03-02 11:14:38','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270527',`firm_id` = '8',`ordernumber` = 'O25030004051', `product_name` = '日式海苔蛋捲',`product_code` = 'DG010101-04',`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-03-04',`create_date` = '2025-03-02 11:14:38',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004051' and product_code = 'DG010101-04' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004051' and product_code = 'DG010101-05' 2025-03-02 23:59:06 -- == 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,'270527','8','O25030004051','濃情巧克力蛋捲','DG010101-05','DG010101','巧克力','40入巧克力蛋捲','320','280','0','0','0','0','1','280.0','3','840','2025-03-04','2025-03-02 11:14:38','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270527',`firm_id` = '8',`ordernumber` = 'O25030004051', `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-03-04',`create_date` = '2025-03-02 11:14:38',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004051' and product_code = 'DG010101-05' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004051' and product_code = 'DG010312-12' 2025-03-02 23:59:06 -- == 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,'270527','8','O25030004051','【咖啡+巧克力】金8結禮盒','DG010312-12','DG010312','金8結盒','禮盒-金8結【咖啡+巧克力】','590','480','0','0','0','0','1','480.0','1','480','2025-03-04','2025-03-02 11:14:38','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270527',`firm_id` = '8',`ordernumber` = 'O25030004051', `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-03-04',`create_date` = '2025-03-02 11:14:38',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004051' and product_code = 'DG010312-12' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004051' and product_code = 'TG010119-01' 2025-03-02 23:59:06 -- == 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,'270527','8','O25030004051','南棗核桃糕','TG010119-01','TG010119','12入核棗糕','(盒)南棗核桃糕','180','180','0','0','0','0','1','0.0','3','540','2025-03-04','2025-03-02 11:14:38','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270527',`firm_id` = '8',`ordernumber` = 'O25030004051', `product_name` = '南棗核桃糕',`product_code` = 'TG010119-01',`product_sn` = 'TG010119',`product_spec` = '12入核棗糕',`invoice_name` = '(盒)南棗核桃糕',`listprice` = '180',`sellingprice` = '180',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '3',`total_price` = '540',`etd` = '2025-03-04',`create_date` = '2025-03-02 11:14:38',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004051' and product_code = 'TG010119-01' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004051' and product_code = 'FL010310-01' 2025-03-02 23:59:06 -- == 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,'270527','8','O25030004051','一口酥24入家庭號禮盒','FL010310-01','12586','12入鳳梨酥+12入鳳梅酥','禮盒-24入家庭號【鳳梨酥+鳳梅酥】','540','540','0','0','0','0','1','0.0','1','540','2025-03-04','2025-03-02 11:14:38','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270527',`firm_id` = '8',`ordernumber` = 'O25030004051', `product_name` = '一口酥24入家庭號禮盒',`product_code` = 'FL010310-01',`product_sn` = '12586',`product_spec` = '12入鳳梨酥+12入鳳梅酥',`invoice_name` = '禮盒-24入家庭號【鳳梨酥+鳳梅酥】',`listprice` = '540',`sellingprice` = '540',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '540',`etd` = '2025-03-04',`create_date` = '2025-03-02 11:14:38',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004051' and product_code = 'FL010310-01' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004051' and product_code = 'LS010124-01' 2025-03-02 23:59:06 -- == 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,'270527','8','O25030004051','韓式梅子海苔(純素)','LS010124-01','LS010124','韓式梅子海苔','韓式梅子海苔','150','150','0','0','0','0','1','0.0','1','150','2025-03-04','2025-03-02 11:14:38','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270527',`firm_id` = '8',`ordernumber` = 'O25030004051', `product_name` = '韓式梅子海苔(純素)',`product_code` = 'LS010124-01',`product_sn` = 'LS010124',`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-03-04',`create_date` = '2025-03-02 11:14:38',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004051' and product_code = 'LS010124-01' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004051' and product_code = 'LS010101-01' 2025-03-02 23:59:06 -- == 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,'270527','8','O25030004051','分享包-無糖芒果乾','LS010101-01','LS010101','180g芒果乾分享包','(紅袋)芒果乾','360','360','0','0','0','0','1','0.0','2','720','2025-03-04','2025-03-02 11:14:38','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270527',`firm_id` = '8',`ordernumber` = 'O25030004051', `product_name` = '分享包-無糖芒果乾',`product_code` = 'LS010101-01',`product_sn` = 'LS010101',`product_spec` = '180g芒果乾分享包',`invoice_name` = '(紅袋)芒果乾',`listprice` = '360',`sellingprice` = '360',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '720',`etd` = '2025-03-04',`create_date` = '2025-03-02 11:14:38',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004051' and product_code = 'LS010101-01' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004051' and product_code = 'TG010104-01' 2025-03-02 23:59:06 -- == 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,'270527','8','O25030004051','夏威夷豆軟糖','TG010104-01','TG010104','10入夏威夷豆軟糖','(盒)夏威夷豆軟糖','220','220','0','0','0','0','1','220.0','1','220','2025-03-04','2025-03-02 11:14:38','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270527',`firm_id` = '8',`ordernumber` = 'O25030004051', `product_name` = '夏威夷豆軟糖',`product_code` = 'TG010104-01',`product_sn` = 'TG010104',`product_spec` = '10入夏威夷豆軟糖',`invoice_name` = '(盒)夏威夷豆軟糖',`listprice` = '220',`sellingprice` = '220',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '220.0',`amount` = '1',`total_price` = '220',`etd` = '2025-03-04',`create_date` = '2025-03-02 11:14:38',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004051' and product_code = 'TG010104-01' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004130' and product_code = 'DG010144-01' 2025-03-02 23:59:06 -- == 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,'270528','8','O25030004130','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','1','280','2025-03-04','2025-03-02 11:40:36','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270528',`firm_id` = '8',`ordernumber` = 'O25030004130', `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-03-04',`create_date` = '2025-03-02 11:40:36',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004130' and product_code = 'DG010144-01' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004130' and product_code = 'DG010143-01' 2025-03-02 23:59:06 -- == 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,'270528','8','O25030004130','可可烤布蕾蛋捲','DG010143-01','DG010143','32入可可烤布蕾蛋捲','32入可可烤布蕾蛋捲','240','240','0','0','0','0','1','0.0','1','240','2025-03-04','2025-03-02 11:40:36','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270528',`firm_id` = '8',`ordernumber` = 'O25030004130', `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-03-04',`create_date` = '2025-03-02 11:40:36',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004130' and product_code = 'DG010143-01' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004130' and product_code = 'DG010101-02' 2025-03-02 23:59:06 -- == 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,'270528','8','O25030004130','香醇芝麻蛋捲','DG010101-02','DG010101','芝麻','40入芝麻蛋捲','320','280','0','0','0','0','1','280.0','1','280','2025-03-04','2025-03-02 11:40:36','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270528',`firm_id` = '8',`ordernumber` = 'O25030004130', `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-03-04',`create_date` = '2025-03-02 11:40:36',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004130' and product_code = 'DG010101-02' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004130' and product_code = 'DG010101-03' 2025-03-02 23:59:06 -- == 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,'270528','8','O25030004130','極上咖啡蛋捲','DG010101-03','DG010101','咖啡','40入咖啡蛋捲','320','280','0','0','0','0','1','280.0','1','280','2025-03-04','2025-03-02 11:40:36','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270528',`firm_id` = '8',`ordernumber` = 'O25030004130', `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-03-04',`create_date` = '2025-03-02 11:40:36',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004130' and product_code = 'DG010101-03' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004234' and product_code = 'DG010144-01' 2025-03-02 23:59:06 -- == 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,'270529','8','O25030004234','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','7','1960','2025-03-11','2025-03-02 13:04:19','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270529',`firm_id` = '8',`ordernumber` = 'O25030004234', `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-03-11',`create_date` = '2025-03-02 13:04:19',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004234' and product_code = 'DG010144-01' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004234' and product_code = 'BP010128-01' 2025-03-02 23:59:06 -- == 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,'270529','8','O25030004234','8結小禮袋','BP010128-01','BP010128','提袋/個','8結小禮袋','10','10','0','0','0','0','1','0.0','7','70','2025-03-11','2025-03-02 13:04:19','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270529',`firm_id` = '8',`ordernumber` = 'O25030004234', `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` = '7',`total_price` = '70',`etd` = '2025-03-11',`create_date` = '2025-03-02 13:04:19',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004234' and product_code = 'BP010128-01' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004346' and product_code = 'DG0105162-34' 2025-03-02 23:59:06 -- == 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,'270530','8','O25030004346','【抹茶季限定】一抹風雅帆布袋-蛋捲三入組','DG0105162-34','DG0105162','芝麻,巧克力,巧克力','組合-32入(芝麻+巧克力+巧克力)+抹茶季限定帆布袋','990','990','0','0','0','1','1','0.0','1','990','2025-03-10','2025-03-02 13:22:11','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270530',`firm_id` = '8',`ordernumber` = 'O25030004346', `product_name` = '【抹茶季限定】一抹風雅帆布袋-蛋捲三入組',`product_code` = 'DG0105162-34',`product_sn` = 'DG0105162',`product_spec` = '芝麻,巧克力,巧克力',`invoice_name` = '組合-32入(芝麻+巧克力+巧克力)+抹茶季限定帆布袋',`listprice` = '990',`sellingprice` = '990',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '990',`etd` = '2025-03-10',`create_date` = '2025-03-02 13:22:11',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004346' and product_code = 'DG0105162-34' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004346' and product_code = '13656' 2025-03-02 23:59:06 -- == 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,'270530','8','O25030004346','8結蛋捲【紅提袋裝】','13656','13656','40入原味蛋捲','組合-40入原味+紅提袋','290','290','0','0','0','0','1','0.0','1','290','2025-03-10','2025-03-02 13:22:11','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270530',`firm_id` = '8',`ordernumber` = 'O25030004346', `product_name` = '8結蛋捲【紅提袋裝】',`product_code` = '13656',`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-03-10',`create_date` = '2025-03-02 13:22:11',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004346' and product_code = '13656' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004346' and product_code = 'DG010144-01' 2025-03-02 23:59:06 -- == 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,'270530','8','O25030004346','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','1','280','2025-03-10','2025-03-02 13:22:11','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270530',`firm_id` = '8',`ordernumber` = 'O25030004346', `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-03-10',`create_date` = '2025-03-02 13:22:11',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004346' and product_code = 'DG010144-01' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004414' and product_code = 'DG010144-01' 2025-03-02 23:59:06 -- == 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,'270531','8','O25030004414','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','1','280','2025-03-07','2025-03-02 13:33:21','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270531',`firm_id` = '8',`ordernumber` = 'O25030004414', `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-03-07',`create_date` = '2025-03-02 13:33:21',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004414' and product_code = 'DG010144-01' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004414' and product_code = 'DG010143-01' 2025-03-02 23:59:06 -- == 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,'270531','8','O25030004414','可可烤布蕾蛋捲','DG010143-01','DG010143','32入可可烤布蕾蛋捲','32入可可烤布蕾蛋捲','240','240','0','0','0','0','1','0.0','1','240','2025-03-07','2025-03-02 13:33:21','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270531',`firm_id` = '8',`ordernumber` = 'O25030004414', `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-03-07',`create_date` = '2025-03-02 13:33:21',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004414' and product_code = 'DG010143-01' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004414' and product_code = 'DG010101-03' 2025-03-02 23:59:06 -- == 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,'270531','8','O25030004414','極上咖啡蛋捲','DG010101-03','DG010101','咖啡','40入咖啡蛋捲','320','280','0','0','0','0','1','280.0','1','280','2025-03-07','2025-03-02 13:33:21','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270531',`firm_id` = '8',`ordernumber` = 'O25030004414', `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-03-07',`create_date` = '2025-03-02 13:33:21',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004414' and product_code = 'DG010101-03' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004414' and product_code = 'TG010106-01' 2025-03-02 23:59:06 -- == 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,'270531','8','O25030004414','分享包-黑曜芝麻糕','TG010106-01','TG010106','25入芝麻糕分享包','(紅袋)芝麻糕','300','300','0','0','0','0','1','0.0','1','300','2025-03-07','2025-03-02 13:33:21','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270531',`firm_id` = '8',`ordernumber` = 'O25030004414', `product_name` = '分享包-黑曜芝麻糕',`product_code` = 'TG010106-01',`product_sn` = 'TG010106',`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-03-07',`create_date` = '2025-03-02 13:33:21',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004414' and product_code = 'TG010106-01' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004516' and product_code = 'DG010527-01' 2025-03-02 23:59:06 -- == 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,'270532','8','O25030004516','8結蛋捲【小禮袋裝】','DG010527-01','DG010527','40入原味蛋捲','組合-40入原味+8結小禮袋','290','290','0','0','0','0','1','0.0','10','2900','2025-03-04','2025-03-02 13:57:08','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270532',`firm_id` = '8',`ordernumber` = 'O25030004516', `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` = '10',`total_price` = '2900',`etd` = '2025-03-04',`create_date` = '2025-03-02 13:57:08',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004516' and product_code = 'DG010527-01' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004516' and product_code = 'DG010527-02' 2025-03-02 23:59:06 -- == 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,'270532','8','O25030004516','8結蛋捲【小禮袋裝】','DG010527-02','DG010527','40入芝麻蛋捲','組合-40入芝麻+8結小禮袋','290','290','0','0','0','0','1','0.0','10','2900','2025-03-04','2025-03-02 13:57:08','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270532',`firm_id` = '8',`ordernumber` = 'O25030004516', `product_name` = '8結蛋捲【小禮袋裝】',`product_code` = 'DG010527-02',`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` = '10',`total_price` = '2900',`etd` = '2025-03-04',`create_date` = '2025-03-02 13:57:08',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004516' and product_code = 'DG010527-02' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004516' and product_code = 'DG010527-05' 2025-03-02 23:59:06 -- == 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,'270532','8','O25030004516','8結蛋捲【小禮袋裝】','DG010527-05','DG010527','40入巧克力蛋捲','組合-40入巧克力+8結小禮袋','290','290','0','0','0','0','1','0.0','8','2320','2025-03-04','2025-03-02 13:57:08','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270532',`firm_id` = '8',`ordernumber` = 'O25030004516', `product_name` = '8結蛋捲【小禮袋裝】',`product_code` = 'DG010527-05',`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` = '8',`total_price` = '2320',`etd` = '2025-03-04',`create_date` = '2025-03-02 13:57:08',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004516' and product_code = 'DG010527-05' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004612' and product_code = 'DG010144-01' 2025-03-02 23:59:06 -- == 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,'270533','8','O25030004612','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','4','1120','2025-03-05','2025-03-02 14:10:06','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270533',`firm_id` = '8',`ordernumber` = 'O25030004612', `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-03-05',`create_date` = '2025-03-02 14:10:06',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004612' and product_code = 'DG010144-01' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004776' and product_code = 'DG010144-01' 2025-03-02 23:59:06 -- == 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,'270534','8','O25030004776','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','3','840','2025-03-04','2025-03-02 15:20:48','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270534',`firm_id` = '8',`ordernumber` = 'O25030004776', `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-03-04',`create_date` = '2025-03-02 15:20:48',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004776' and product_code = 'DG010144-01' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004776' and product_code = 'DG010101-01' 2025-03-02 23:59:06 -- == 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,'270534','8','O25030004776','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','4','1120','2025-03-04','2025-03-02 15:20:48','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270534',`firm_id` = '8',`ordernumber` = 'O25030004776', `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` = '4',`total_price` = '1120',`etd` = '2025-03-04',`create_date` = '2025-03-02 15:20:48',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004776' and product_code = 'DG010101-01' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004859' and product_code = 'DG010312-15' 2025-03-02 23:59:06 -- == 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,'270535','8','O25030004859','【巧克力＋巧克力】金8結禮盒','DG010312-15','DG010312','金8結盒','禮盒-金8結【巧克力+巧克力】','590','480','0','0','0','0','1','480.0','8','3840','2025-03-04','2025-03-02 15:54:54','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270535',`firm_id` = '8',`ordernumber` = 'O25030004859', `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` = '8',`total_price` = '3840',`etd` = '2025-03-04',`create_date` = '2025-03-02 15:54:54',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004859' and product_code = 'DG010312-15' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004859' and product_code = 'DG010312-06' 2025-03-02 23:59:06 -- == 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,'270535','8','O25030004859','【芝麻＋芝麻】金8結禮盒','DG010312-06','DG010312','金8結盒','禮盒-金8結【芝麻+芝麻】','590','480','0','0','0','0','1','480.0','10','4800','2025-03-04','2025-03-02 15:54:54','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270535',`firm_id` = '8',`ordernumber` = 'O25030004859', `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-03-04',`create_date` = '2025-03-02 15:54:54',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004859' and product_code = 'DG010312-06' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004859' and product_code = 'DG010312-01' 2025-03-02 23:59:06 -- == 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,'270535','8','O25030004859','【原味＋原味】金8結禮盒','DG010312-01','DG010312','金8結盒','禮盒-金8結【原味+原味】','590','480','0','0','0','0','1','480.0','15','7200','2025-03-04','2025-03-02 15:54:54','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270535',`firm_id` = '8',`ordernumber` = 'O25030004859', `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` = '15',`total_price` = '7200',`etd` = '2025-03-04',`create_date` = '2025-03-02 15:54:54',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004859' and product_code = 'DG010312-01' 2025-03-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004999' and product_code = 'DG010144-01' 2025-03-02 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,'270536','8','O25030004999','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','3','840','2025-03-11','2025-03-02 17:46:54','2025-03-02 23:59:06',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270536',`firm_id` = '8',`ordernumber` = 'O25030004999', `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-03-11',`create_date` = '2025-03-02 17:46:54',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004999' and product_code = 'DG010144-01' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004999' and product_code = 'DG010527-01' 2025-03-02 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,'270536','8','O25030004999','8結蛋捲【小禮袋裝】','DG010527-01','DG010527','40入原味蛋捲','組合-40入原味+8結小禮袋','290','290','0','0','0','0','1','0.0','3','870','2025-03-11','2025-03-02 17:46:54','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270536',`firm_id` = '8',`ordernumber` = 'O25030004999', `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` = '3',`total_price` = '870',`etd` = '2025-03-11',`create_date` = '2025-03-02 17:46:54',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004999' and product_code = 'DG010527-01' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004999' and product_code = 'DG010527-02' 2025-03-02 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,'270536','8','O25030004999','8結蛋捲【小禮袋裝】','DG010527-02','DG010527','40入芝麻蛋捲','組合-40入芝麻+8結小禮袋','290','290','0','0','0','0','1','0.0','4','1160','2025-03-11','2025-03-02 17:46:54','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270536',`firm_id` = '8',`ordernumber` = 'O25030004999', `product_name` = '8結蛋捲【小禮袋裝】',`product_code` = 'DG010527-02',`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` = '4',`total_price` = '1160',`etd` = '2025-03-11',`create_date` = '2025-03-02 17:46:54',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004999' and product_code = 'DG010527-02' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030004999' and product_code = 'BP010128-01' 2025-03-02 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,'270536','8','O25030004999','8結小禮袋','BP010128-01','BP010128','提袋/個','8結小禮袋','10','10','0','0','0','0','1','0.0','3','30','2025-03-11','2025-03-02 17:46:54','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270536',`firm_id` = '8',`ordernumber` = 'O25030004999', `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` = '3',`total_price` = '30',`etd` = '2025-03-11',`create_date` = '2025-03-02 17:46:54',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030004999' and product_code = 'BP010128-01' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030005045' and product_code = 'DG0105162-45' 2025-03-02 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,'270537','8','O25030005045','【抹茶季限定】一抹風雅帆布袋-蛋捲三入組','DG0105162-45','DG0105162','咖啡,巧克力,抹茶','組合-32入(咖啡+巧克力+抹茶)+抹茶季限定帆布袋','1030','1030','0','0','0','1','1','0.0','1','1030','2025-03-06','2025-03-02 18:29:23','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270537',`firm_id` = '8',`ordernumber` = 'O25030005045', `product_name` = '【抹茶季限定】一抹風雅帆布袋-蛋捲三入組',`product_code` = 'DG0105162-45',`product_sn` = 'DG0105162',`product_spec` = '咖啡,巧克力,抹茶',`invoice_name` = '組合-32入(咖啡+巧克力+抹茶)+抹茶季限定帆布袋',`listprice` = '1030',`sellingprice` = '1030',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1030',`etd` = '2025-03-06',`create_date` = '2025-03-02 18:29:23',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030005045' and product_code = 'DG0105162-45' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030005152' and product_code = 'DG010143-01' 2025-03-02 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,'270538','8','O25030005152','可可烤布蕾蛋捲','DG010143-01','DG010143','32入可可烤布蕾蛋捲','32入可可烤布蕾蛋捲','240','240','0','0','0','0','1','0.0','1','240','2025-03-04','2025-03-02 18:39:09','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270538',`firm_id` = '8',`ordernumber` = 'O25030005152', `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-03-04',`create_date` = '2025-03-02 18:39:09',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030005152' and product_code = 'DG010143-01' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030005152' and product_code = 'DG010144-01' 2025-03-02 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,'270538','8','O25030005152','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','1','280','2025-03-04','2025-03-02 18:39:09','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270538',`firm_id` = '8',`ordernumber` = 'O25030005152', `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-03-04',`create_date` = '2025-03-02 18:39:09',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030005152' and product_code = 'DG010144-01' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030005152' and product_code = 'DG010101-03' 2025-03-02 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,'270538','8','O25030005152','極上咖啡蛋捲','DG010101-03','DG010101','咖啡','40入咖啡蛋捲','320','280','0','0','0','0','1','280.0','1','280','2025-03-04','2025-03-02 18:39:09','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270538',`firm_id` = '8',`ordernumber` = 'O25030005152', `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-03-04',`create_date` = '2025-03-02 18:39:09',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030005152' and product_code = 'DG010101-03' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030005261' and product_code = 'DG0103227-01' 2025-03-02 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,'270539','8','O25030005261','金典8結禮盒-可可烤布蕾','DG0103227-01','DG0103227','原味+可可烤布蕾','禮盒-金典(紅)【原味+可可烤布蕾】','480','480','0','0','0','0','1','0.0','3','1440','2025-03-04','2025-03-02 18:57:39','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270539',`firm_id` = '8',`ordernumber` = 'O25030005261', `product_name` = '金典8結禮盒-可可烤布蕾',`product_code` = 'DG0103227-01',`product_sn` = 'DG0103227',`product_spec` = '原味+可可烤布蕾',`invoice_name` = '禮盒-金典(紅)【原味+可可烤布蕾】',`listprice` = '480',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '3',`total_price` = '1440',`etd` = '2025-03-04',`create_date` = '2025-03-02 18:57:39',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030005261' and product_code = 'DG0103227-01' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S25030005319' and product_code = 'DG010101-01' 2025-03-02 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,'270540','8','S25030005319','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','2','560','2025-03-02','2025-03-02 19:26:05','2025-03-02 23:59:07',0,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270540',`firm_id` = '8',`ordernumber` = 'S25030005319', `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-03-02',`create_date` = '2025-03-02 19:26:05',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'S25030005319' and product_code = 'DG010101-01' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S25030005319' and product_code = 'DG010101-02' 2025-03-02 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,'270540','8','S25030005319','香醇芝麻蛋捲','DG010101-02','DG010101','芝麻','40入芝麻蛋捲','320','280','0','0','0','0','1','280.0','1','280','2025-03-02','2025-03-02 19:26:05','2025-03-02 23:59:07',0,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270540',`firm_id` = '8',`ordernumber` = 'S25030005319', `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-03-02',`create_date` = '2025-03-02 19:26:05',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'S25030005319' and product_code = 'DG010101-02' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S25030005319' and product_code = 'DG010101-05' 2025-03-02 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,'270540','8','S25030005319','濃情巧克力蛋捲','DG010101-05','DG010101','巧克力','40入巧克力蛋捲','320','280','0','0','0','0','1','280.0','4','1120','2025-03-02','2025-03-02 19:26:05','2025-03-02 23:59:07',0,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270540',`firm_id` = '8',`ordernumber` = 'S25030005319', `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` = '4',`total_price` = '1120',`etd` = '2025-03-02',`create_date` = '2025-03-02 19:26:05',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'S25030005319' and product_code = 'DG010101-05' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030005471' and product_code = 'DG0105103-09' 2025-03-02 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,'270541','8','O25030005471','SNOOPY美好心意-蛋捲三入組','DG0105103-09','DG0105103','原味+芝麻+巧克力','組合-32入(原味+芝麻+巧克力)+SNOOPY美好提袋','990','990','0','0','0','1','1','0.0','1','990','2025-03-10','2025-03-02 19:31:54','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270541',`firm_id` = '8',`ordernumber` = 'O25030005471', `product_name` = 'SNOOPY美好心意-蛋捲三入組',`product_code` = 'DG0105103-09',`product_sn` = 'DG0105103',`product_spec` = '原味+芝麻+巧克力',`invoice_name` = '組合-32入(原味+芝麻+巧克力)+SNOOPY美好提袋',`listprice` = '990',`sellingprice` = '990',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '990',`etd` = '2025-03-10',`create_date` = '2025-03-02 19:31:54',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030005471' and product_code = 'DG0105103-09' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030005471' and product_code = 'DG010144-01' 2025-03-02 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,'270541','8','O25030005471','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','1','280','2025-03-10','2025-03-02 19:31:54','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270541',`firm_id` = '8',`ordernumber` = 'O25030005471', `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-03-10',`create_date` = '2025-03-02 19:31:54',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030005471' and product_code = 'DG010144-01' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030005471' and product_code = 'DG0103148-01' 2025-03-02 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,'270541','8','O25030005471','金典8結禮盒','DG0103148-01','DG0103148','原味+原味','禮盒-金典(紅)【原味+原味】','480','480','0','0','0','0','1','0.0','1','480','2025-03-10','2025-03-02 19:31:54','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270541',`firm_id` = '8',`ordernumber` = 'O25030005471', `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` = '1',`total_price` = '480',`etd` = '2025-03-10',`create_date` = '2025-03-02 19:31:54',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030005471' and product_code = 'DG0103148-01' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030005471' and product_code = 'DG0103148-15' 2025-03-02 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,'270541','8','O25030005471','金典8結禮盒','DG0103148-15','DG0103148','巧克力+巧克力','禮盒-金典(紅)【巧克力+巧克力】','480','480','0','0','0','0','1','0.0','1','480','2025-03-10','2025-03-02 19:31:54','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270541',`firm_id` = '8',`ordernumber` = 'O25030005471', `product_name` = '金典8結禮盒',`product_code` = 'DG0103148-15',`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` = '1',`total_price` = '480',`etd` = '2025-03-10',`create_date` = '2025-03-02 19:31:54',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030005471' and product_code = 'DG0103148-15' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030005471' and product_code = 'DG0103148-07' 2025-03-02 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,'270541','8','O25030005471','金典8結禮盒','DG0103148-07','DG0103148','芝麻+咖啡','禮盒-金典(紅)【芝麻+咖啡】','480','480','0','0','0','0','1','0.0','1','480','2025-03-10','2025-03-02 19:31:54','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270541',`firm_id` = '8',`ordernumber` = 'O25030005471', `product_name` = '金典8結禮盒',`product_code` = 'DG0103148-07',`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` = '1',`total_price` = '480',`etd` = '2025-03-10',`create_date` = '2025-03-02 19:31:54',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030005471' and product_code = 'DG0103148-07' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030005471' and product_code = 'DG010143-01' 2025-03-02 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,'270541','8','O25030005471','可可烤布蕾蛋捲','DG010143-01','DG010143','32入可可烤布蕾蛋捲','32入可可烤布蕾蛋捲','240','240','0','0','0','0','1','0.0','2','480','2025-03-10','2025-03-02 19:31:54','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270541',`firm_id` = '8',`ordernumber` = 'O25030005471', `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-03-10',`create_date` = '2025-03-02 19:31:54',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030005471' and product_code = 'DG010143-01' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030005582' and product_code = '12525' 2025-03-02 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,'270542','8','O25030005582','心意禮盒','12525','FL010301','【芝麻糕+核棗糕+枸杞茶】','禮盒-心意【芝麻糕+核棗糕+枸杞茶】','520','520','0','0','0','0','1','0.0','8','4160','2025-03-04','2025-03-02 19:59:21','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270542',`firm_id` = '8',`ordernumber` = 'O25030005582', `product_name` = '心意禮盒',`product_code` = '12525',`product_sn` = 'FL010301',`product_spec` = '【芝麻糕+核棗糕+枸杞茶】',`invoice_name` = '禮盒-心意【芝麻糕+核棗糕+枸杞茶】',`listprice` = '520',`sellingprice` = '520',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '8',`total_price` = '4160',`etd` = '2025-03-04',`create_date` = '2025-03-02 19:59:21',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030005582' and product_code = '12525' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030005687' and product_code = 'DG010144-01' 2025-03-02 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,'270543','8','O25030005687','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','3','840','2025-03-24','2025-03-02 20:20:32','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270543',`firm_id` = '8',`ordernumber` = 'O25030005687', `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-03-24',`create_date` = '2025-03-02 20:20:32',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030005687' and product_code = 'DG010144-01' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030005687' and product_code = 'TG010119-01' 2025-03-02 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,'270543','8','O25030005687','南棗核桃糕','TG010119-01','TG010119','12入核棗糕','(盒)南棗核桃糕','180','180','0','0','0','0','1','0.0','1','180','2025-03-24','2025-03-02 20:20:32','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270543',`firm_id` = '8',`ordernumber` = 'O25030005687', `product_name` = '南棗核桃糕',`product_code` = 'TG010119-01',`product_sn` = 'TG010119',`product_spec` = '12入核棗糕',`invoice_name` = '(盒)南棗核桃糕',`listprice` = '180',`sellingprice` = '180',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '180',`etd` = '2025-03-24',`create_date` = '2025-03-02 20:20:32',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030005687' and product_code = 'TG010119-01' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030005687' and product_code = 'DG010404-01' 2025-03-02 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,'270543','8','O25030005687','紅色提袋','DG010404-01','DG010404','提袋/個','紅色提袋','10','10','0','0','0','0','1','0.0','1','10','2025-03-24','2025-03-02 20:20:32','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270543',`firm_id` = '8',`ordernumber` = 'O25030005687', `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` = '1',`total_price` = '10',`etd` = '2025-03-24',`create_date` = '2025-03-02 20:20:32',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030005687' and product_code = 'DG010404-01' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030005779' and product_code = 'DG010144-01' 2025-03-02 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,'270544','8','O25030005779','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','1','280','2025-03-04','2025-03-02 20:24:49','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270544',`firm_id` = '8',`ordernumber` = 'O25030005779', `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-03-04',`create_date` = '2025-03-02 20:24:49',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030005779' and product_code = 'DG010144-01' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030005779' and product_code = 'DG0103188-11' 2025-03-02 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,'270544','8','O25030005779','【SNOOPY 聯名】美好探尋-8結禮盒','DG0103188-11','DG0103188','芝麻蛋捲,海苔蛋捲','禮盒-SNOOPY(橘)【芝麻+海苔】','500','500','0','0','0','0','1','0.0','1','500','2025-03-04','2025-03-02 20:24:49','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270544',`firm_id` = '8',`ordernumber` = 'O25030005779', `product_name` = '【SNOOPY 聯名】美好探尋-8結禮盒',`product_code` = 'DG0103188-11',`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` = '1',`total_price` = '500',`etd` = '2025-03-04',`create_date` = '2025-03-02 20:24:49',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030005779' and product_code = 'DG0103188-11' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030005837' and product_code = 'DG010144-01' 2025-03-02 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,'270545','8','O25030005837','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','1','280','2025-03-04','2025-03-02 20:36:22','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270545',`firm_id` = '8',`ordernumber` = 'O25030005837', `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-03-04',`create_date` = '2025-03-02 20:36:22',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030005837' and product_code = 'DG010144-01' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030005837' and product_code = 'DG0103148-08' 2025-03-02 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,'270545','8','O25030005837','金典8結禮盒','DG0103148-08','DG0103148','芝麻+海苔','禮盒-金典(紅)【芝麻+海苔】','480','480','0','0','0','0','1','0.0','1','480','2025-03-04','2025-03-02 20:36:22','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270545',`firm_id` = '8',`ordernumber` = 'O25030005837', `product_name` = '金典8結禮盒',`product_code` = 'DG0103148-08',`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` = '1',`total_price` = '480',`etd` = '2025-03-04',`create_date` = '2025-03-02 20:36:22',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030005837' and product_code = 'DG0103148-08' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030005993' and product_code = 'DG010258-01' 2025-03-02 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,'270546','8','O25030005993','金豐收8結提盒','DG010258-01','DG010258','40入原味蛋捲','提盒-金豐收(藍)-40入原味','295','295','0','0','0','0','1','0.0','4','1180','2025-03-04','2025-03-02 20:48:49','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270546',`firm_id` = '8',`ordernumber` = 'O25030005993', `product_name` = '金豐收8結提盒',`product_code` = 'DG010258-01',`product_sn` = 'DG010258',`product_spec` = '40入原味蛋捲',`invoice_name` = '提盒-金豐收(藍)-40入原味',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '4',`total_price` = '1180',`etd` = '2025-03-04',`create_date` = '2025-03-02 20:48:49',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030005993' and product_code = 'DG010258-01' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030006023' and product_code = 'DG010206-01' 2025-03-02 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,'270547','8','O25030006023','8結蛋捲【紅提盒裝】','DG010206-01','DG010206','原味','提盒-品牌(紅)-40入原味蛋捲','295','295','0','0','0','0','1','0.0','4','1180','2025-03-04','2025-03-02 20:53:00','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270547',`firm_id` = '8',`ordernumber` = 'O25030006023', `product_name` = '8結蛋捲【紅提盒裝】',`product_code` = 'DG010206-01',`product_sn` = 'DG010206',`product_spec` = '原味',`invoice_name` = '提盒-品牌(紅)-40入原味蛋捲',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '4',`total_price` = '1180',`etd` = '2025-03-04',`create_date` = '2025-03-02 20:53:00',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030006023' and product_code = 'DG010206-01' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030006169' and product_code = 'DG010312-05' 2025-03-02 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,'270548','8','O25030006169','【原味+巧克力】金8結禮盒','DG010312-05','DG010312','金8結盒','禮盒-金8結【原味+巧克力】','590','480','0','0','0','0','1','480.0','1','480','2025-03-04','2025-03-02 22:21:21','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270548',`firm_id` = '8',`ordernumber` = 'O25030006169', `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-03-04',`create_date` = '2025-03-02 22:21:21',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030006169' and product_code = 'DG010312-05' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030006295' and product_code = 'DG010101-01' 2025-03-02 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,'270549','8','O25030006295','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','3','840','2025-03-04','2025-03-02 23:04:43','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270549',`firm_id` = '8',`ordernumber` = 'O25030006295', `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` = '3',`total_price` = '840',`etd` = '2025-03-04',`create_date` = '2025-03-02 23:04:43',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030006295' and product_code = 'DG010101-01' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030006295' and product_code = 'DG010144-01' 2025-03-02 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,'270549','8','O25030006295','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','3','840','2025-03-04','2025-03-02 23:04:43','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270549',`firm_id` = '8',`ordernumber` = 'O25030006295', `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-03-04',`create_date` = '2025-03-02 23:04:43',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030006295' and product_code = 'DG010144-01' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030006295' and product_code = 'DG010101-04' 2025-03-02 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,'270549','8','O25030006295','日式海苔蛋捲','DG010101-04','DG010101','單盒','40入海苔蛋捲','320','280','0','0','0','0','1','280.0','3','840','2025-03-04','2025-03-02 23:04:43','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270549',`firm_id` = '8',`ordernumber` = 'O25030006295', `product_name` = '日式海苔蛋捲',`product_code` = 'DG010101-04',`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-03-04',`create_date` = '2025-03-02 23:04:43',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030006295' and product_code = 'DG010101-04' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030006337' and product_code = 'DG010101-01' 2025-03-02 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,'270550','8','O25030006337','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','3','840','2025-03-04','2025-03-02 23:08:16','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270550',`firm_id` = '8',`ordernumber` = 'O25030006337', `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` = '3',`total_price` = '840',`etd` = '2025-03-04',`create_date` = '2025-03-02 23:08:16',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030006337' and product_code = 'DG010101-01' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030006337' and product_code = 'DG010101-04' 2025-03-02 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,'270550','8','O25030006337','日式海苔蛋捲','DG010101-04','DG010101','單盒','40入海苔蛋捲','320','280','0','0','0','0','1','280.0','3','840','2025-03-04','2025-03-02 23:08:16','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270550',`firm_id` = '8',`ordernumber` = 'O25030006337', `product_name` = '日式海苔蛋捲',`product_code` = 'DG010101-04',`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-03-04',`create_date` = '2025-03-02 23:08:16',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030006337' and product_code = 'DG010101-04' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030006337' and product_code = 'DG010101-02' 2025-03-02 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,'270550','8','O25030006337','香醇芝麻蛋捲','DG010101-02','DG010101','芝麻','40入芝麻蛋捲','320','280','0','0','0','0','1','280.0','3','840','2025-03-04','2025-03-02 23:08:16','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270550',`firm_id` = '8',`ordernumber` = 'O25030006337', `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` = '3',`total_price` = '840',`etd` = '2025-03-04',`create_date` = '2025-03-02 23:08:16',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030006337' and product_code = 'DG010101-02' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030006495' and product_code = 'DG010143-01' 2025-03-02 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,'270551','8','O25030006495','可可烤布蕾蛋捲','DG010143-01','DG010143','32入可可烤布蕾蛋捲','32入可可烤布蕾蛋捲','240','240','0','0','0','0','1','0.0','1','240','2025-03-10','2025-03-02 23:13:11','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270551',`firm_id` = '8',`ordernumber` = 'O25030006495', `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-03-10',`create_date` = '2025-03-02 23:13:11',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030006495' and product_code = 'DG010143-01' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030006495' and product_code = 'DG010101-01' 2025-03-02 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,'270551','8','O25030006495','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','2','560','2025-03-10','2025-03-02 23:13:11','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270551',`firm_id` = '8',`ordernumber` = 'O25030006495', `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-03-10',`create_date` = '2025-03-02 23:13:11',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030006495' and product_code = 'DG010101-01' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030006495' and product_code = 'DG010101-02' 2025-03-02 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,'270551','8','O25030006495','香醇芝麻蛋捲','DG010101-02','DG010101','芝麻','40入芝麻蛋捲','320','280','0','0','0','0','1','280.0','1','280','2025-03-10','2025-03-02 23:13:11','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270551',`firm_id` = '8',`ordernumber` = 'O25030006495', `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-03-10',`create_date` = '2025-03-02 23:13:11',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030006495' and product_code = 'DG010101-02' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030006495' and product_code = 'DG010101-03' 2025-03-02 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,'270551','8','O25030006495','極上咖啡蛋捲','DG010101-03','DG010101','咖啡','40入咖啡蛋捲','320','280','0','0','0','0','1','280.0','1','280','2025-03-10','2025-03-02 23:13:11','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270551',`firm_id` = '8',`ordernumber` = 'O25030006495', `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-03-10',`create_date` = '2025-03-02 23:13:11',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030006495' and product_code = 'DG010101-03' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030006495' and product_code = 'DG010101-05' 2025-03-02 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,'270551','8','O25030006495','濃情巧克力蛋捲','DG010101-05','DG010101','巧克力','40入巧克力蛋捲','320','280','0','0','0','0','1','280.0','1','280','2025-03-10','2025-03-02 23:13:11','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270551',`firm_id` = '8',`ordernumber` = 'O25030006495', `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-03-10',`create_date` = '2025-03-02 23:13:11',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030006495' and product_code = 'DG010101-05' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030006552' and product_code = 'DG010144-01' 2025-03-02 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,'270552','8','O25030006552','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','4','1120','2025-03-04','2025-03-02 23:33:15','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270552',`firm_id` = '8',`ordernumber` = 'O25030006552', `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-03-04',`create_date` = '2025-03-02 23:33:15',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030006552' and product_code = 'DG010144-01' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030006552' and product_code = 'DG010101-05' 2025-03-02 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,'270552','8','O25030006552','濃情巧克力蛋捲','DG010101-05','DG010101','巧克力','40入巧克力蛋捲','320','280','0','0','0','0','1','280.0','2','560','2025-03-04','2025-03-02 23:33:15','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270552',`firm_id` = '8',`ordernumber` = 'O25030006552', `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-03-04',`create_date` = '2025-03-02 23:33:15',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030006552' and product_code = 'DG010101-05' 2025-03-02 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030006689' and product_code = 'DG010275-05' 2025-03-02 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,'270553','8','O25030006689','【小王子聯名】玫瑰星球8結提盒','DG010275-05','DG010275','巧克力','提盒-小王子(NEW)-40入巧克力','300','300','0','0','0','0','1','0.0','1','300','2025-03-04','2025-03-02 23:41:59','2025-03-02 23:59:07',null,'1','2025-02-03') 2025-03-02 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270553',`firm_id` = '8',`ordernumber` = 'O25030006689', `product_name` = '【小王子聯名】玫瑰星球8結提盒',`product_code` = 'DG010275-05',`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` = '1',`total_price` = '300',`etd` = '2025-03-04',`create_date` = '2025-03-02 23:41:59',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030006689' and product_code = 'DG010275-05' 2025-03-02 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030006689' and product_code = 'DG0103188-09' 2025-03-02 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,'270553','8','O25030006689','【SNOOPY 聯名】美好探尋-8結禮盒','DG0103188-09','DG0103188','原味蛋捲,巧克力蛋捲','禮盒-SNOOPY(橘)【原味+巧克力】','500','500','0','0','0','0','1','0.0','1','500','2025-03-04','2025-03-02 23:41:59','2025-03-02 23:59:08',null,'1','2025-02-03') 2025-03-02 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270553',`firm_id` = '8',`ordernumber` = 'O25030006689', `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` = '1',`total_price` = '500',`etd` = '2025-03-04',`create_date` = '2025-03-02 23:41:59',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030006689' and product_code = 'DG0103188-09' 2025-03-02 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030006689' and product_code = 'DG010144-01' 2025-03-02 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,'270553','8','O25030006689','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','1','280','2025-03-04','2025-03-02 23:41:59','2025-03-02 23:59:08',null,'1','2025-02-03') 2025-03-02 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270553',`firm_id` = '8',`ordernumber` = 'O25030006689', `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-03-04',`create_date` = '2025-03-02 23:41:59',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030006689' and product_code = 'DG010144-01' 2025-03-02 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030006689' and product_code = 'DG010312-05' 2025-03-02 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,'270553','8','O25030006689','【原味+巧克力】金8結禮盒','DG010312-05','DG010312','金8結盒','禮盒-金8結【原味+巧克力】','590','480','0','0','0','0','1','480.0','1','480','2025-03-04','2025-03-02 23:41:59','2025-03-02 23:59:08',null,'1','2025-02-03') 2025-03-02 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270553',`firm_id` = '8',`ordernumber` = 'O25030006689', `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-03-04',`create_date` = '2025-03-02 23:41:59',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-03'where ordernumber = 'O25030006689' and product_code = 'DG010312-05' 2025-03-02 23:59:08 -- == sync_order_detail end == 2025-03-02 23:59:08 -- == sync_order start == 2025-03-02 23:59:08 -- start:2025-03-02,end:2025-03-02 2025-03-02 23:59:08 -- == 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-03-02%' OR l.modify_date like '2025-03-02%'; 2025-03-02 23:59:08 -- == sync omo_order_list == 2025-03-02 23:59:08 -- == 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 ('180821','456904',2,'','','B25030000269','1','11','1','1','1','','','0','0000-00-00','600','0','0','','0','30','12000','111','台北市','士林區','111','台北市','士林區','11370','2025-03-02 10:12:56','2025-02-03') 2025-03-02 23:59:08 -- == 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 ('183150','459218',2,'','','B25030000359','1','1','1','0','0','','','0','0000-00-00','0','0','0','','0','30','6500','514','彰化縣','溪湖鎮','514','彰化縣','溪湖鎮','6470','2025-03-02 22:20:18','2025-02-03') 2025-03-02 23:59:08 -- == 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 ('183150','459218',2,'','','B25030000421','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','4200','514','彰化縣','溪湖鎮','514','彰化縣','溪湖鎮','4320','2025-03-02 22:37:03','2025-02-03') 2025-03-02 23:59:08 -- == sync_order end == 2025-03-02 23:59:08 -- == sync_order_detail start == 2025-03-02 23:59:08 -- start:2025-03-02,end:2025-03-02 2025-03-02 23:59:08 -- == sync omo_order_detail == 2025-03-02 23:59:08 -- == SELECT order_detail == SELECT * from order_detail WHERE create_date like '2025-03-02%' OR modify_date like '2025-03-02%' 2025-03-02 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B25030000269' and product_code = 'DG010276-01' 2025-03-02 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, 2,'34348','8','B25030000269','【小王子聯名】玫瑰星球彌月提盒','DG010276-01','DG010276','原味','提盒-彌月小王子(NEW)-40入原味','300','300','0','0','0','0','1','0.0','32','9600','2025-03-18','2025-03-02 10:12:56','2025-03-02 23:59:08',null,'1','2025-02-03') 2025-03-02 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '34348',`firm_id` = '8',`ordernumber` = 'B25030000269', `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` = '32',`total_price` = '9600',`etd` = '2025-03-18',`create_date` = '2025-03-02 10:12:56',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B25030000269' and product_code = 'DG010276-01', `lunar_date` = '2025-02-03' 2025-03-02 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B25030000269' and product_code = 'DG010276-05' 2025-03-02 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, 2,'34348','8','B25030000269','【小王子聯名】玫瑰星球彌月提盒','DG010276-05','DG010276','巧克力','提盒-彌月小王子(NEW)-40入巧克力','300','300','0','0','0','0','1','0.0','8','2400','2025-03-18','2025-03-02 10:12:56','2025-03-02 23:59:08',null,'1','2025-02-03') 2025-03-02 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '34348',`firm_id` = '8',`ordernumber` = 'B25030000269', `product_name` = '【小王子聯名】玫瑰星球彌月提盒',`product_code` = 'DG010276-05',`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-03-18',`create_date` = '2025-03-02 10:12:56',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B25030000269' and product_code = 'DG010276-05', `lunar_date` = '2025-02-03' 2025-03-02 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B25030000269' and product_code = 'ZP010518-01' 2025-03-02 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, 2,'34348','8','B25030000269','贈品-剛剛好蛋捲組','ZP010518-01','ZP010518','一組','組合-32入原味蛋捲+剛剛好的優雅-有聲書(線上兌換)+剛剛好帆布袋+金句透卡','0','0','0','0','0','0','1','0.0','1','0','2025-03-18','2025-03-02 10:12:56','2025-03-02 23:59:08',null,'1','2025-02-03') 2025-03-02 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '34348',`firm_id` = '8',`ordernumber` = 'B25030000269', `product_name` = '贈品-剛剛好蛋捲組',`product_code` = 'ZP010518-01',`product_sn` = 'ZP010518',`product_spec` = '一組',`invoice_name` = '組合-32入原味蛋捲+剛剛好的優雅-有聲書(線上兌換)+剛剛好帆布袋+金句透卡',`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-03-18',`create_date` = '2025-03-02 10:12:56',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B25030000269' and product_code = 'ZP010518-01', `lunar_date` = '2025-02-03' 2025-03-02 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B25030000359' and product_code = 'DG010316-01' 2025-03-02 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, 2,'34349','8','B25030000359','8結彌月禮盒-樂芙','DG010316-01','DG010316','原味+原味','禮盒-彌月樂芙【原味+原味】','500','500','0','1','0','0','1','500.0','12','6000','2025-03-12','2025-03-02 22:20:18','2025-03-02 23:59:08',null,'1','2025-02-03') 2025-03-02 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '34349',`firm_id` = '8',`ordernumber` = 'B25030000359', `product_name` = '8結彌月禮盒-樂芙',`product_code` = 'DG010316-01',`product_sn` = 'DG010316',`product_spec` = '原味+原味',`invoice_name` = '禮盒-彌月樂芙【原味+原味】',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '500.0',`amount` = '12',`total_price` = '6000',`etd` = '2025-03-12',`create_date` = '2025-03-02 22:20:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B25030000359' and product_code = 'DG010316-01', `lunar_date` = '2025-02-03' 2025-03-02 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B25030000359' and product_code = 'DG010316-09' 2025-03-02 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, 2,'34349','8','B25030000359','8結彌月禮盒-樂芙','DG010316-09','DG010316','芝麻+巧克力','禮盒-彌月樂芙【芝麻+巧克力】','500','500','0','1','0','0','1','500.0','1','500','2025-03-12','2025-03-02 22:20:18','2025-03-02 23:59:08',null,'1','2025-02-03') 2025-03-02 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '34349',`firm_id` = '8',`ordernumber` = 'B25030000359', `product_name` = '8結彌月禮盒-樂芙',`product_code` = 'DG010316-09',`product_sn` = 'DG010316',`product_spec` = '芝麻+巧克力',`invoice_name` = '禮盒-彌月樂芙【芝麻+巧克力】',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '500.0',`amount` = '1',`total_price` = '500',`etd` = '2025-03-12',`create_date` = '2025-03-02 22:20:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B25030000359' and product_code = 'DG010316-09', `lunar_date` = '2025-02-03' 2025-03-02 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B25030000359' and product_code = 'ZP010151-01' 2025-03-02 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, 2,'34349','8','B25030000359','贈品-給足呵護童襪組','ZP010151-01','ZP010151','一組','贈品-sNug寶寶襪/童襪x4(款式隨機)','0','0','0','0','0','0','1','0.0','1','0','2025-03-12','2025-03-02 22:20:18','2025-03-02 23:59:08',null,'1','2025-02-03') 2025-03-02 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '34349',`firm_id` = '8',`ordernumber` = 'B25030000359', `product_name` = '贈品-給足呵護童襪組',`product_code` = 'ZP010151-01',`product_sn` = 'ZP010151',`product_spec` = '一組',`invoice_name` = '贈品-sNug寶寶襪/童襪x4(款式隨機)',`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-03-12',`create_date` = '2025-03-02 22:20:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B25030000359' and product_code = 'ZP010151-01', `lunar_date` = '2025-02-03' 2025-03-02 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B25030000421' and product_code = 'DG0103189-09' 2025-03-02 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, 2,'34350','8','B25030000421','SNOOPY美好探尋-8結彌月禮盒','DG0103189-09','DG0103189','芝麻+巧克力','禮盒-彌月SNOOPY(橘)【芝麻+巧克力】','500','500','0','1','0','0','1','0.0','1','500','2025-03-12','2025-03-02 22:37:03','2025-03-02 23:59:08',null,'1','2025-02-03') 2025-03-02 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '34350',`firm_id` = '8',`ordernumber` = 'B25030000421', `product_name` = 'SNOOPY美好探尋-8結彌月禮盒',`product_code` = 'DG0103189-09',`product_sn` = 'DG0103189',`product_spec` = '芝麻+巧克力',`invoice_name` = '禮盒-彌月SNOOPY(橘)【芝麻+巧克力】',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '500',`etd` = '2025-03-12',`create_date` = '2025-03-02 22:37:03',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B25030000421' and product_code = 'DG0103189-09', `lunar_date` = '2025-02-03' 2025-03-02 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B25030000421' and product_code = 'DG010316-01' 2025-03-02 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, 2,'34350','8','B25030000421','8結彌月禮盒-樂芙','DG010316-01','DG010316','原味+原味','禮盒-彌月樂芙【原味+原味】','500','500','0','1','0','0','1','500.0','2','1000','2025-03-12','2025-03-02 22:37:03','2025-03-02 23:59:08',null,'1','2025-02-03') 2025-03-02 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '34350',`firm_id` = '8',`ordernumber` = 'B25030000421', `product_name` = '8結彌月禮盒-樂芙',`product_code` = 'DG010316-01',`product_sn` = 'DG010316',`product_spec` = '原味+原味',`invoice_name` = '禮盒-彌月樂芙【原味+原味】',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '500.0',`amount` = '2',`total_price` = '1000',`etd` = '2025-03-12',`create_date` = '2025-03-02 22:37:03',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B25030000421' and product_code = 'DG010316-01', `lunar_date` = '2025-02-03' 2025-03-02 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B25030000421' and product_code = 'DG010266-01' 2025-03-02 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, 2,'34350','8','B25030000421','SNOOPY獨特心意-8結彌月提盒','DG010266-01','DG010266','原味','提盒-彌月SNOOPY(粉)-40入原味','300','300','0','1','0','0','1','0.0','9','2700','2025-03-12','2025-03-02 22:37:03','2025-03-02 23:59:08',null,'1','2025-02-03') 2025-03-02 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '34350',`firm_id` = '8',`ordernumber` = 'B25030000421', `product_name` = 'SNOOPY獨特心意-8結彌月提盒',`product_code` = 'DG010266-01',`product_sn` = 'DG010266',`product_spec` = '原味',`invoice_name` = '提盒-彌月SNOOPY(粉)-40入原味',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '9',`total_price` = '2700',`etd` = '2025-03-12',`create_date` = '2025-03-02 22:37:03',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B25030000421' and product_code = 'DG010266-01', `lunar_date` = '2025-02-03' 2025-03-02 23:59:08 -- == sync_order_detail end == 2025-03-02 23:59:08 -- == 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-03-02' OR o.updated_at = '2025-03-02') and o.deleted_at is null 2025-03-02 23:59:08 -- == sync_order_detail start == 2025-03-02 23:59:08 -- start:2025-03-02,end:2025-03-02 2025-03-02 23:59:09 -- step1: SELECT id,sku,combinations_product_spec_id FROM `product_specs` 2025-03-02 23:59:10 -- step2: SELECT * FROM `product_specs` WHERE combinations_product_spec_id is not null 2025-03-02 23:59:13 -- step3: SELECT id,product_code,product_sn FROM `omo_order_detail` WHERE `channel` = 6 and product_code like '%,%' and create_date LIKE '2025-03-02%';