2023-12-09 23:59:03 -- == sync_order start == 2023-12-09 23:59:03 -- start:2023-12-09,end:2023-12-09 2023-12-09 23:59:03 -- == 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 '2023-12-09%' OR l.modify_date like '2023-12-09%'; 2023-12-09 23:59:04 -- == sync omo_order_list == 2023-12-09 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 ('27442','177766',1,'','','O23120047429','1','1','1','1','1','','','0','0000-00-00','620','0','0','','0','150','12400','811','高雄市','楠梓區','811','高雄市','楠梓區','11630','2023-12-09 00:09:58','2023-10-27') 2023-12-09 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 ('374','192993',1,'','','O23120047536','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1305','811','高雄市','楠梓區','811','高雄市','楠梓區','1455','2023-12-09 00:19:40','2023-10-27') 2023-12-09 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 ('313551','350707',1,'','','O23120047691','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1555','420','台中市','豐原區','420','台中市','豐原區','1675','2023-12-09 00:42:12','2023-10-27') 2023-12-09 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 ('314264','351409',1,'','','O23120047761','1','1','1','1','1','','','0','0000-00-00','424','0','0','','0','30','8490','235','新北市','中和區','235','新北市','中和區','8036','2023-12-09 09:59:21','2023-10-27') 2023-12-09 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 ('228190','254644',1,'','','O23120047824','1','2','1','0','0','','','0','0000-00-00','0','0','0','','0','0','5910','237','新北市','三峽區','237','新北市','三峽區','5910','2023-12-09 10:48:36','2023-10-27') 2023-12-09 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 ('314250','351396',1,'','','O23120047941','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','4975','630','雲林縣','斗南鎮','631','雲林縣','大埤鄉','5095','2023-12-09 11:46:17','2023-10-27') 2023-12-09 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 ('314285','351430',1,'','','O23120048080','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','3580','702','台南市','南區','712','台南市','新化區','3700','2023-12-09 12:10:00','2023-10-27') 2023-12-09 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 ('314282','351427',1,'','','O23120048154','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','480','327','桃園市','新屋區','237','新北市','三峽區','600','2023-12-09 12:18:21','2023-10-27') 2023-12-09 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 ('314293','351438',1,'','','O23120048230','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','800','104','台北市','中山區','115','台北市','南港區','920','2023-12-09 12:47:00','2023-10-27') 2023-12-09 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 ('314298','351443',1,'','','O23120048387','1','1','1','1','1','87042040','尚格工程行','0','0000-00-00','1475','0','0','','0','30','29500','505','彰化縣','鹿港鎮','505','彰化縣','鹿港鎮','27995','2023-12-09 12:57:14','2023-10-27') 2023-12-09 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 ('303501','340769',1,'','','O23120048473','1','1','1','1','1','60330130','彰源企業股份有限公司','0','0000-00-00','0','0','0','','150','0','3900','630','雲林縣','斗南鎮','630','雲林縣','斗南鎮','4050','2023-12-09 14:25:08','2023-10-27') 2023-12-09 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 ('314336','351480',1,'','','O23120048548','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1400','744','台南市','新市區','744','台南市','新市區','1550','2023-12-09 14:40:55','2023-10-27') 2023-12-09 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 ('314339','351484',1,'','','O23120048610','1','2','1','1','1','','','0','0000-00-00','0','0','0','','150','30','960','244','新北市','林口區','244','新北市','林口區','1080','2023-12-09 14:52:14','2023-10-27') 2023-12-09 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 ('314345','351490',1,'','','O23120048710','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','2640','401','台中市','東區','401','台中市','東區','2760','2023-12-09 15:17:26','2023-10-27') 2023-12-09 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 ('314369','351514',1,'','','O23120048813','1','11','1','0','0','','','0','0000-00-00','0','0','0','','150','30','435','710','台南市','永康區','710','台南市','永康區','555','2023-12-09 16:07:58','2023-10-27') 2023-12-09 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 ('314416','351561',1,'','','O23120048957','1','2','1','1','1','83476852','我懂設計有限公司','0','0000-00-00','0','0','0','','150','30','960','242','新北市','新莊區','242','新北市','新莊區','1080','2023-12-09 18:26:00','2023-10-27') 2023-12-09 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 ('299635','336971',1,'','','O23120049018','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1430','220','新北市','板橋區','220','新北市','板橋區','1580','2023-12-09 18:28:38','2023-10-27') 2023-12-09 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 ('314426','351571',1,'','','O23120049133','1','2','1','0','0','','','0','0000-00-00','0','0','0','','150','30','1800','115','台北市','南港區','115','台北市','南港區','1920','2023-12-09 18:49:11','2023-10-27') 2023-12-09 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 ('144630','112583',1,'','','O23120049240','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1680','324','桃園市','平鎮區','510','彰化縣','員林市','1830','2023-12-09 19:18:21','2023-10-27') 2023-12-09 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 ('122325','91102',1,'','','O23120049332','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','500','220','新北市','板橋區','710','台南市','永康區','650','2023-12-09 19:32:37','2023-10-27') 2023-12-09 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 ('314456','351601',1,'','','O23120049416','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','2430','300','新竹市','東區','300','新竹市','東區','2550','2023-12-09 20:43:31','2023-10-27') 2023-12-09 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 ('314457','351602',1,'','','O23120049584','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1545','235','新北市','中和區','235','新北市','中和區','1665','2023-12-09 20:48:55','2023-10-27') 2023-12-09 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 ('231694','260045',1,'','','O23120049670','1','1','1','1','1','','','0','0000-00-00','0','0','0','','0','0','5760','320','桃園市','中壢區','320','桃園市','中壢區','5760','2023-12-09 20:49:52','2023-10-27') 2023-12-09 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 ('182853','149311',1,'','','O23120049738','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','100','3840','236','新北市','土城區','236','新北市','土城區','3890','2023-12-09 20:53:04','2023-10-27') 2023-12-09 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 ('314458','351603',1,'','','O23120049812','1','1','1','1','1','','','0','0000-00-00','0','0','0','','0','100','6320','522','彰化縣','田尾鄉','522','彰化縣','田尾鄉','6220','2023-12-09 20:56:33','2023-10-27') 2023-12-09 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('222245','241897',1,'','','O23120049933','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','3800','600','嘉義市','東區','600','嘉義市','東區','3950','2023-12-09 21:04:30','2023-10-27') 2023-12-09 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('314462','351607',1,'','','O23120050089','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','4500','220','新北市','板橋區','100','台北市','中正區','4620','2023-12-09 21:28:14','2023-10-27') 2023-12-09 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('219445','234131',1,'','','O23120050160','1','1','1','1','1','18249334','新北市私立班尼迪克幼兒園','0','0000-00-00','542','0','0','','0','0','10850','220','新北市','板橋區','220','新北市','板橋區','10308','2023-12-09 21:59:16','2023-10-27') 2023-12-09 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('231520','259716',1,'','','O23120050290','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1150','247','新北市','蘆洲區','247','新北市','蘆洲區','1300','2023-12-09 22:03:17','2023-10-27') 2023-12-09 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('314464','351609',1,'','','O23120050387','1','2','1','0','0','','','0','0000-00-00','0','0','0','','150','30','2560','324','桃園市','平鎮區','324','桃園市','平鎮區','2680','2023-12-09 22:39:29','2023-10-27') 2023-12-09 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('314466','351611',1,'','','O23120050467','1','2','1','0','0','','','0','0000-00-00','0','0','0','','150','30','500','338','桃園市','蘆竹區','338','桃園市','蘆竹區','620','2023-12-09 23:52:53','2023-10-27') 2023-12-09 23:59:05 -- == sync_order end == 2023-12-09 23:59:05 -- == sync_order_detail start == 2023-12-09 23:59:05 -- start:2023-12-09,end:2023-12-09 2023-12-09 23:59:05 -- == sync omo_order_detail == 2023-12-09 23:59:05 -- == SELECT order_detail == SELECT * from order_detail WHERE create_date like '2023-12-09%' OR modify_date like '2023-12-09%' 2023-12-09 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120047429' and product_code = 'DG010101-01' 2023-12-09 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,'214451','8','O23120047429','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','15','4200','2024-01-16','2023-12-09 00:09:58','2023-12-09 23:59:06',null,'1','2023-10-27') 2023-12-09 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214451',`firm_id` = '8',`ordernumber` = 'O23120047429', `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` = '15',`total_price` = '4200',`etd` = '2024-01-16',`create_date` = '2023-12-09 00:09:58',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120047429' and product_code = 'DG010101-01' 2023-12-09 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120047429' and product_code = 'DG010101-02' 2023-12-09 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,'214451','8','O23120047429','香醇芝麻蛋捲','DG010101-02','DG010101','芝麻','40入芝麻蛋捲','320','280','0','0','0','0','1','280.0','3','840','2024-01-16','2023-12-09 00:09:58','2023-12-09 23:59:06',null,'1','2023-10-27') 2023-12-09 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214451',`firm_id` = '8',`ordernumber` = 'O23120047429', `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` = '2024-01-16',`create_date` = '2023-12-09 00:09:58',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120047429' and product_code = 'DG010101-02' 2023-12-09 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120047429' and product_code = 'DG010101-03' 2023-12-09 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,'214451','8','O23120047429','極上咖啡蛋捲','DG010101-03','DG010101','咖啡','40入咖啡蛋捲','320','280','0','0','0','0','1','280.0','4','1120','2024-01-16','2023-12-09 00:09:58','2023-12-09 23:59:06',null,'1','2023-10-27') 2023-12-09 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214451',`firm_id` = '8',`ordernumber` = 'O23120047429', `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` = '2024-01-16',`create_date` = '2023-12-09 00:09:58',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120047429' and product_code = 'DG010101-03' 2023-12-09 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120047429' and product_code = 'DG010101-04' 2023-12-09 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,'214451','8','O23120047429','日式海苔蛋捲','DG010101-04','DG010101','單盒','40入海苔蛋捲','320','280','0','0','0','0','1','280.0','1','280','2024-01-16','2023-12-09 00:09:58','2023-12-09 23:59:06',null,'1','2023-10-27') 2023-12-09 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214451',`firm_id` = '8',`ordernumber` = 'O23120047429', `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` = '2024-01-16',`create_date` = '2023-12-09 00:09:58',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120047429' and product_code = 'DG010101-04' 2023-12-09 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120047429' and product_code = 'DG010101-05' 2023-12-09 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,'214451','8','O23120047429','濃情巧克力蛋捲','DG010101-05','DG010101','巧克力','40入巧克力蛋捲','320','280','0','0','0','0','1','280.0','5','1400','2024-01-16','2023-12-09 00:09:58','2023-12-09 23:59:06',null,'1','2023-10-27') 2023-12-09 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214451',`firm_id` = '8',`ordernumber` = 'O23120047429', `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` = '5',`total_price` = '1400',`etd` = '2024-01-16',`create_date` = '2023-12-09 00:09:58',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120047429' and product_code = 'DG010101-05' 2023-12-09 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120047429' and product_code = 'DG010129-01' 2023-12-09 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,'214451','8','O23120047429','【期間限定】皇家伯爵茶蛋捲','DG010129-01','DG010129','32入伯爵茶','32入伯爵茶','300','300','0','0','0','0','1','0.0','4','1200','2024-01-16','2023-12-09 00:09:58','2023-12-09 23:59:06',null,'1','2023-10-27') 2023-12-09 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214451',`firm_id` = '8',`ordernumber` = 'O23120047429', `product_name` = '【期間限定】皇家伯爵茶蛋捲',`product_code` = 'DG010129-01',`product_sn` = 'DG010129',`product_spec` = '32入伯爵茶',`invoice_name` = '32入伯爵茶',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '4',`total_price` = '1200',`etd` = '2024-01-16',`create_date` = '2023-12-09 00:09:58',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120047429' and product_code = 'DG010129-01' 2023-12-09 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120047429' and product_code = 'DG0103148-07' 2023-12-09 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,'214451','8','O23120047429','金典8結禮盒','DG0103148-07','DG0103148','芝麻+咖啡','禮盒-金典(紅)【芝麻+咖啡】','480','480','0','0','0','0','1','0.0','2','960','2024-01-16','2023-12-09 00:09:58','2023-12-09 23:59:06',null,'1','2023-10-27') 2023-12-09 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214451',`firm_id` = '8',`ordernumber` = 'O23120047429', `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` = '2',`total_price` = '960',`etd` = '2024-01-16',`create_date` = '2023-12-09 00:09:58',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120047429' and product_code = 'DG0103148-07' 2023-12-09 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120047429' and product_code = 'DG0103148-09' 2023-12-09 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,'214451','8','O23120047429','金典8結禮盒','DG0103148-09','DG0103148','芝麻+巧克力','禮盒-金典(紅)【芝麻+巧克力】','480','480','0','0','0','0','1','0.0','2','960','2024-01-16','2023-12-09 00:09:58','2023-12-09 23:59:06',null,'1','2023-10-27') 2023-12-09 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214451',`firm_id` = '8',`ordernumber` = 'O23120047429', `product_name` = '金典8結禮盒',`product_code` = 'DG0103148-09',`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` = '2',`total_price` = '960',`etd` = '2024-01-16',`create_date` = '2023-12-09 00:09:58',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120047429' and product_code = 'DG0103148-09' 2023-12-09 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120047429' and product_code = 'DG0103148-02' 2023-12-09 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,'214451','8','O23120047429','金典8結禮盒','DG0103148-02','DG0103148','原味+芝麻','禮盒-金典(紅)【原味+芝麻】','480','480','0','0','0','0','1','0.0','3','1440','2024-01-16','2023-12-09 00:09:58','2023-12-09 23:59:06',null,'1','2023-10-27') 2023-12-09 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214451',`firm_id` = '8',`ordernumber` = 'O23120047429', `product_name` = '金典8結禮盒',`product_code` = 'DG0103148-02',`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` = '3',`total_price` = '1440',`etd` = '2024-01-16',`create_date` = '2023-12-09 00:09:58',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120047429' and product_code = 'DG0103148-02' 2023-12-09 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120047536' and product_code = 'FL010310-01' 2023-12-09 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,'214452','8','O23120047536','一口酥24入家庭號禮盒','FL010310-01','12586','12入鳳梨酥+12入鳳梅酥','禮盒-12入鳳梨酥+12入鳳梅酥','435','435','0','0','0','0','1','0.0','3','1305','2023-12-11','2023-12-09 00:19:40','2023-12-09 23:59:06',null,'1','2023-10-27') 2023-12-09 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214452',`firm_id` = '8',`ordernumber` = 'O23120047536', `product_name` = '一口酥24入家庭號禮盒',`product_code` = 'FL010310-01',`product_sn` = '12586',`product_spec` = '12入鳳梨酥+12入鳳梅酥',`invoice_name` = '禮盒-12入鳳梨酥+12入鳳梅酥',`listprice` = '435',`sellingprice` = '435',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '3',`total_price` = '1305',`etd` = '2023-12-11',`create_date` = '2023-12-09 00:19:40',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120047536' and product_code = 'FL010310-01' 2023-12-09 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120047691' and product_code = 'DG0103155-12' 2023-12-09 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,'214453','8','O23120047691','【SNOOPY聯名】友你相伴-8結禮盒','DG0103155-12','DG0103155','咖啡蛋捲,巧克力蛋捲','禮盒-SNOOPY【咖啡+巧克力】','500','500','0','0','0','0','1','0.0','2','1000','2024-01-08','2023-12-09 00:42:12','2023-12-09 23:59:06',null,'1','2023-10-27') 2023-12-09 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214453',`firm_id` = '8',`ordernumber` = 'O23120047691', `product_name` = '【SNOOPY聯名】友你相伴-8結禮盒',`product_code` = 'DG0103155-12',`product_sn` = 'DG0103155',`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` = '2',`total_price` = '1000',`etd` = '2024-01-08',`create_date` = '2023-12-09 00:42:12',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120047691' and product_code = 'DG0103155-12' 2023-12-09 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120047691' and product_code = 'DG0103169-05' 2023-12-09 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,'214453','8','O23120047691','【皇家伯爵茶】金8結禮盒','DG0103169-05','DG0103169','巧克力+32入皇家伯爵茶蛋捲','禮盒-金8結【伯爵茶+巧克力】','555','555','0','0','0','0','1','0.0','1','555','2024-01-08','2023-12-09 00:42:12','2023-12-09 23:59:06',null,'1','2023-10-27') 2023-12-09 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214453',`firm_id` = '8',`ordernumber` = 'O23120047691', `product_name` = '【皇家伯爵茶】金8結禮盒',`product_code` = 'DG0103169-05',`product_sn` = 'DG0103169',`product_spec` = '巧克力+32入皇家伯爵茶蛋捲',`invoice_name` = '禮盒-金8結【伯爵茶+巧克力】',`listprice` = '555',`sellingprice` = '555',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '555',`etd` = '2024-01-08',`create_date` = '2023-12-09 00:42:12',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120047691' and product_code = 'DG0103169-05' 2023-12-09 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120047761' and product_code = 'DG010312-01' 2023-12-09 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,'214454','8','O23120047761','【原味＋原味】金8結禮盒','DG010312-01','DG010312','金8結盒','禮盒-金8結【原味+原味】','590','480','0','0','0','0','1','480.0','17','8160','2024-01-17','2023-12-09 09:59:21','2023-12-09 23:59:06',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214454',`firm_id` = '8',`ordernumber` = 'O23120047761', `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` = '17',`total_price` = '8160',`etd` = '2024-01-17',`create_date` = '2023-12-09 09:59:21',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120047761' and product_code = 'DG010312-01' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120047761' and product_code = 'BP010128-01' 2023-12-09 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,'214454','8','O23120047761','8結小禮袋','BP010128-01','BP010128','提袋/個','8結小禮袋','10','10','0','0','0','0','1','0.0','33','330','2024-01-17','2023-12-09 09:59:21','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214454',`firm_id` = '8',`ordernumber` = 'O23120047761', `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` = '33',`total_price` = '330',`etd` = '2024-01-17',`create_date` = '2023-12-09 09:59:21',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120047761' and product_code = 'BP010128-01' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120047824' and product_code = 'DG0103134-09' 2023-12-09 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,'214455','8','O23120047824','仕女帆布袋蛋捲三入組','DG0103134-09','DG0103134','原味+芝麻+巧克力','組合-32入(原味+芝麻+巧克力)+仕女帆布袋','985','985','0','0','0','1','1','0.0','6','5910','2024-01-17','2023-12-09 10:48:36','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214455',`firm_id` = '8',`ordernumber` = 'O23120047824', `product_name` = '仕女帆布袋蛋捲三入組',`product_code` = 'DG0103134-09',`product_sn` = 'DG0103134',`product_spec` = '原味+芝麻+巧克力',`invoice_name` = '組合-32入(原味+芝麻+巧克力)+仕女帆布袋',`listprice` = '985',`sellingprice` = '985',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '6',`total_price` = '5910',`etd` = '2024-01-17',`create_date` = '2023-12-09 10:48:36',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120047824' and product_code = 'DG0103134-09' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120047941' and product_code = 'DG010101-05' 2023-12-09 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,'214456','8','O23120047941','濃情巧克力蛋捲','DG010101-05','DG010101','巧克力','40入巧克力蛋捲','320','280','0','0','0','0','1','280.0','1','280','2024-01-13','2023-12-09 11:46:17','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214456',`firm_id` = '8',`ordernumber` = 'O23120047941', `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` = '2024-01-13',`create_date` = '2023-12-09 11:46:17',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120047941' and product_code = 'DG010101-05' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120047941' and product_code = 'DG010129-01' 2023-12-09 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,'214456','8','O23120047941','【期間限定】皇家伯爵茶蛋捲','DG010129-01','DG010129','32入伯爵茶','32入伯爵茶','300','300','0','0','0','0','1','0.0','1','300','2024-01-13','2023-12-09 11:46:17','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214456',`firm_id` = '8',`ordernumber` = 'O23120047941', `product_name` = '【期間限定】皇家伯爵茶蛋捲',`product_code` = 'DG010129-01',`product_sn` = 'DG010129',`product_spec` = '32入伯爵茶',`invoice_name` = '32入伯爵茶',`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` = '2024-01-13',`create_date` = '2023-12-09 11:46:17',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120047941' and product_code = 'DG010129-01' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120047941' and product_code = '12241' 2023-12-09 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,'214456','8','O23120047941','8結隨享茶點禮盒','12241','12146','原味+芝麻,鳳梨酥,夏威夷豆軟糖','禮盒-8結隨享【原味+芝麻】+鳳梨酥+夏威夷豆軟糖','550','550','0','0','0','0','1','0.0','7','3850','2024-01-13','2023-12-09 11:46:17','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214456',`firm_id` = '8',`ordernumber` = 'O23120047941', `product_name` = '8結隨享茶點禮盒',`product_code` = '12241',`product_sn` = '12146',`product_spec` = '原味+芝麻,鳳梨酥,夏威夷豆軟糖',`invoice_name` = '禮盒-8結隨享【原味+芝麻】+鳳梨酥+夏威夷豆軟糖',`listprice` = '550',`sellingprice` = '550',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '7',`total_price` = '3850',`etd` = '2024-01-13',`create_date` = '2023-12-09 11:46:17',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120047941' and product_code = '12241' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120047941' and product_code = '03953' 2023-12-09 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,'214456','8','O23120047941','[加購]加購-無糖芒果乾分享包','03953','03953','-','加購-無糖芒果乾分享包','285','285','1','1','285','0','0','0.0','1','285','2024-01-13','2023-12-09 11:46:17','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214456',`firm_id` = '8',`ordernumber` = 'O23120047941', `product_name` = '[加購]加購-無糖芒果乾分享包',`product_code` = '03953',`product_sn` = '03953',`product_spec` = '-',`invoice_name` = '加購-無糖芒果乾分享包',`listprice` = '285',`sellingprice` = '285',`isadd` = '1',`isbaby` = '1',`addprice` = '285',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '285',`etd` = '2024-01-13',`create_date` = '2023-12-09 11:46:17',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120047941' and product_code = '03953' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120047941' and product_code = '13045' 2023-12-09 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,'214456','8','O23120047941','[加購]加購-厚切椒鹽海苔(純素)','13045','13045','-','加購-厚切椒鹽海苔(純素)','110','110','1','1','110','0','0','0.0','1','110','2024-01-13','2023-12-09 11:46:17','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214456',`firm_id` = '8',`ordernumber` = 'O23120047941', `product_name` = '[加購]加購-厚切椒鹽海苔(純素)',`product_code` = '13045',`product_sn` = '13045',`product_spec` = '-',`invoice_name` = '加購-厚切椒鹽海苔(純素)',`listprice` = '110',`sellingprice` = '110',`isadd` = '1',`isbaby` = '1',`addprice` = '110',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '110',`etd` = '2024-01-13',`create_date` = '2023-12-09 11:46:17',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120047941' and product_code = '13045' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120047941' and product_code = 'LS010108-01' 2023-12-09 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,'214456','8','O23120047941','[加購]加購-原味乳酪絲','LS010108-01','LS010108','-','加購-原味乳酪絲(藍)袋裝','150','150','1','1','150','0','0','0.0','1','150','2024-01-13','2023-12-09 11:46:17','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214456',`firm_id` = '8',`ordernumber` = 'O23120047941', `product_name` = '[加購]加購-原味乳酪絲',`product_code` = 'LS010108-01',`product_sn` = 'LS010108',`product_spec` = '-',`invoice_name` = '加購-原味乳酪絲(藍)袋裝',`listprice` = '150',`sellingprice` = '150',`isadd` = '1',`isbaby` = '1',`addprice` = '150',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '150',`etd` = '2024-01-13',`create_date` = '2023-12-09 11:46:17',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120047941' and product_code = 'LS010108-01' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120048080' and product_code = 'DG010383-02' 2023-12-09 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,'214457','8','O23120048080','【小王子聯名】星光飛行8結禮盒','DG010383-02','DG010383','原味+芝麻','禮盒-小王子(紅)【原味+芝麻】','500','500','0','0','0','0','1','0.0','6','3000','2024-01-16','2023-12-09 12:10:00','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214457',`firm_id` = '8',`ordernumber` = 'O23120048080', `product_name` = '【小王子聯名】星光飛行8結禮盒',`product_code` = 'DG010383-02',`product_sn` = 'DG010383',`product_spec` = '原味+芝麻',`invoice_name` = '禮盒-小王子(紅)【原味+芝麻】',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '6',`total_price` = '3000',`etd` = '2024-01-16',`create_date` = '2023-12-09 12:10:00',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120048080' and product_code = 'DG010383-02' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120048080' and product_code = 'DG010129-01' 2023-12-09 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,'214457','8','O23120048080','【期間限定】皇家伯爵茶蛋捲','DG010129-01','DG010129','32入伯爵茶','32入伯爵茶','300','300','0','0','0','0','1','0.0','1','300','2024-01-16','2023-12-09 12:10:00','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214457',`firm_id` = '8',`ordernumber` = 'O23120048080', `product_name` = '【期間限定】皇家伯爵茶蛋捲',`product_code` = 'DG010129-01',`product_sn` = 'DG010129',`product_spec` = '32入伯爵茶',`invoice_name` = '32入伯爵茶',`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` = '2024-01-16',`create_date` = '2023-12-09 12:10:00',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120048080' and product_code = 'DG010129-01' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120048080' and product_code = 'DG010101-01' 2023-12-09 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,'214457','8','O23120048080','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','1','280','2024-01-16','2023-12-09 12:10:00','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214457',`firm_id` = '8',`ordernumber` = 'O23120048080', `product_name` = '經典原味蛋捲',`product_code` = 'DG010101-01',`product_sn` = 'DG010101',`product_spec` = '原味',`invoice_name` = '40入原味蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2024-01-16',`create_date` = '2023-12-09 12:10:00',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120048080' and product_code = 'DG010101-01' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120048154' and product_code = 'DG010312-05' 2023-12-09 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,'214458','8','O23120048154','【原味+巧克力】金8結禮盒','DG010312-05','DG010312','金8結盒','禮盒-金8結【原味+巧克力】','590','480','0','0','0','0','1','480.0','1','480','2023-12-11','2023-12-09 12:18:21','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214458',`firm_id` = '8',`ordernumber` = 'O23120048154', `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` = '2023-12-11',`create_date` = '2023-12-09 12:18:21',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120048154' and product_code = 'DG010312-05' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120048230' and product_code = 'DG0103155-05' 2023-12-09 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,'214459','8','O23120048230','【SNOOPY聯名】友你相伴-8結禮盒','DG0103155-05','DG0103155','原味蛋捲,巧克力蛋捲','禮盒-SNOOPY【原味+巧克力】','500','500','0','0','0','0','1','0.0','1','500','2023-12-14','2023-12-09 12:47:00','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214459',`firm_id` = '8',`ordernumber` = 'O23120048230', `product_name` = '【SNOOPY聯名】友你相伴-8結禮盒',`product_code` = 'DG0103155-05',`product_sn` = 'DG0103155',`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` = '2023-12-14',`create_date` = '2023-12-09 12:47:00',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120048230' and product_code = 'DG0103155-05' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120048230' and product_code = 'DG010261-01' 2023-12-09 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,'214459','8','O23120048230','【SNOOPY聯名】美好食光-8結提盒','DG010261-01','DG010261','40入原味蛋捲','提盒-SNOOPY-40入原味','300','300','0','0','0','0','1','0.0','1','300','2023-12-14','2023-12-09 12:47:00','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214459',`firm_id` = '8',`ordernumber` = 'O23120048230', `product_name` = '【SNOOPY聯名】美好食光-8結提盒',`product_code` = 'DG010261-01',`product_sn` = 'DG010261',`product_spec` = '40入原味蛋捲',`invoice_name` = '提盒-SNOOPY-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` = '2023-12-14',`create_date` = '2023-12-09 12:47:00',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120048230' and product_code = 'DG010261-01' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120048387' and product_code = 'DG010206-02' 2023-12-09 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,'214460','8','O23120048387','8結蛋捲【紅提盒裝】','DG010206-02','DG010206','芝麻','提盒-品牌(紅)-40入芝麻蛋捲','295','295','0','0','0','0','1','0.0','60','17700','2023-12-13','2023-12-09 12:57:14','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214460',`firm_id` = '8',`ordernumber` = 'O23120048387', `product_name` = '8結蛋捲【紅提盒裝】',`product_code` = 'DG010206-02',`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` = '60',`total_price` = '17700',`etd` = '2023-12-13',`create_date` = '2023-12-09 12:57:14',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120048387' and product_code = 'DG010206-02' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120048387' and product_code = 'DG010204-01' 2023-12-09 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,'214460','8','O23120048387','8結蛋捲【品牌提盒裝】','DG010204-01','DG010204','原味','提盒-品牌(橘)-40入原味','295','295','0','0','0','0','1','0.0','10','2950','2023-12-13','2023-12-09 12:57:14','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214460',`firm_id` = '8',`ordernumber` = 'O23120048387', `product_name` = '8結蛋捲【品牌提盒裝】',`product_code` = 'DG010204-01',`product_sn` = 'DG010204',`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` = '10',`total_price` = '2950',`etd` = '2023-12-13',`create_date` = '2023-12-09 12:57:14',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120048387' and product_code = 'DG010204-01' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120048387' and product_code = 'DG010204-04' 2023-12-09 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,'214460','8','O23120048387','8結蛋捲【品牌提盒裝】','DG010204-04','DG010204','海苔','提盒-品牌(橘)-40入海苔','295','295','0','0','0','0','1','0.0','30','8850','2023-12-13','2023-12-09 12:57:14','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214460',`firm_id` = '8',`ordernumber` = 'O23120048387', `product_name` = '8結蛋捲【品牌提盒裝】',`product_code` = 'DG010204-04',`product_sn` = 'DG010204',`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` = '30',`total_price` = '8850',`etd` = '2023-12-13',`create_date` = '2023-12-09 12:57:14',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120048387' and product_code = 'DG010204-04' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120048473' and product_code = 'DG010527-02' 2023-12-09 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,'214461','8','O23120048473','8結蛋捲【小禮袋裝】','DG010527-02','DG010527','40入芝麻蛋捲','組合-40入芝麻+8結小禮袋','290','290','0','0','0','0','1','0.0','13','3770','2023-12-11','2023-12-09 14:25:08','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214461',`firm_id` = '8',`ordernumber` = 'O23120048473', `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` = '13',`total_price` = '3770',`etd` = '2023-12-11',`create_date` = '2023-12-09 14:25:08',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120048473' and product_code = 'DG010527-02' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120048473' and product_code = 'DG010404-01' 2023-12-09 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,'214461','8','O23120048473','[加購]紅色提袋','DG010404-01','DG010404','-','紅色提袋','10','10','1','0','10','0','0','0.0','13','130','2023-12-11','2023-12-09 14:25:08','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214461',`firm_id` = '8',`ordernumber` = 'O23120048473', `product_name` = '[加購]紅色提袋',`product_code` = 'DG010404-01',`product_sn` = 'DG010404',`product_spec` = '-',`invoice_name` = '紅色提袋',`listprice` = '10',`sellingprice` = '10',`isadd` = '1',`isbaby` = '0',`addprice` = '10',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '13',`total_price` = '130',`etd` = '2023-12-11',`create_date` = '2023-12-09 14:25:08',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120048473' and product_code = 'DG010404-01' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120048548' and product_code = 'DG010101-02' 2023-12-09 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,'214462','8','O23120048548','香醇芝麻蛋捲','DG010101-02','DG010101','芝麻','40入芝麻蛋捲','320','280','0','0','0','0','1','280.0','5','1400','2023-12-11','2023-12-09 14:40:55','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214462',`firm_id` = '8',`ordernumber` = 'O23120048548', `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` = '5',`total_price` = '1400',`etd` = '2023-12-11',`create_date` = '2023-12-09 14:40:55',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120048548' and product_code = 'DG010101-02' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120048610' and product_code = 'DG010312-02' 2023-12-09 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,'214463','8','O23120048610','【原味+芝麻】金8結禮盒','DG010312-02','DG010312','金8結盒','禮盒-金8結【原味+芝麻】','590','480','0','0','0','0','1','480.0','2','960','2023-12-11','2023-12-09 14:52:14','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214463',`firm_id` = '8',`ordernumber` = 'O23120048610', `product_name` = '【原味+芝麻】金8結禮盒',`product_code` = 'DG010312-02',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+芝麻】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '2',`total_price` = '960',`etd` = '2023-12-11',`create_date` = '2023-12-09 14:52:14',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120048610' and product_code = 'DG010312-02' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120048710' and product_code = '13991' 2023-12-09 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,'214464','8','O23120048710','小王子小提袋蛋捲組','13991','13987','巧克力','組合-32入巧克力+小王子小提袋','390','390','0','0','0','1','1','0.0','6','2340','2023-12-11','2023-12-09 15:17:26','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214464',`firm_id` = '8',`ordernumber` = 'O23120048710', `product_name` = '小王子小提袋蛋捲組',`product_code` = '13991',`product_sn` = '13987',`product_spec` = '巧克力',`invoice_name` = '組合-32入巧克力+小王子小提袋',`listprice` = '390',`sellingprice` = '390',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '6',`total_price` = '2340',`etd` = '2023-12-11',`create_date` = '2023-12-09 15:17:26',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120048710' and product_code = '13991' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120048710' and product_code = 'DG010129-01' 2023-12-09 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,'214464','8','O23120048710','【期間限定】皇家伯爵茶蛋捲','DG010129-01','DG010129','32入伯爵茶','32入伯爵茶','300','300','0','0','0','0','1','0.0','1','300','2023-12-11','2023-12-09 15:17:26','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214464',`firm_id` = '8',`ordernumber` = 'O23120048710', `product_name` = '【期間限定】皇家伯爵茶蛋捲',`product_code` = 'DG010129-01',`product_sn` = 'DG010129',`product_spec` = '32入伯爵茶',`invoice_name` = '32入伯爵茶',`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` = '2023-12-11',`create_date` = '2023-12-09 15:17:26',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120048710' and product_code = 'DG010129-01' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120048813' and product_code = 'FL010310-01' 2023-12-09 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,'214465','8','O23120048813','一口酥24入家庭號禮盒','FL010310-01','12586','12入鳳梨酥+12入鳳梅酥','禮盒-12入鳳梨酥+12入鳳梅酥','435','435','0','0','0','0','1','0.0','1','435','2023-12-14','2023-12-09 16:07:58','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214465',`firm_id` = '8',`ordernumber` = 'O23120048813', `product_name` = '一口酥24入家庭號禮盒',`product_code` = 'FL010310-01',`product_sn` = '12586',`product_spec` = '12入鳳梨酥+12入鳳梅酥',`invoice_name` = '禮盒-12入鳳梨酥+12入鳳梅酥',`listprice` = '435',`sellingprice` = '435',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '435',`etd` = '2023-12-14',`create_date` = '2023-12-09 16:07:58',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120048813' and product_code = 'FL010310-01' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120048957' and product_code = 'DG0103148-05' 2023-12-09 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,'214466','8','O23120048957','金典8結禮盒','DG0103148-05','DG0103148','原味+巧克力','禮盒-金典(紅)【原味+巧克力】','480','480','0','0','0','0','1','0.0','2','960','2023-12-11','2023-12-09 18:26:00','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214466',`firm_id` = '8',`ordernumber` = 'O23120048957', `product_name` = '金典8結禮盒',`product_code` = 'DG0103148-05',`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` = '2',`total_price` = '960',`etd` = '2023-12-11',`create_date` = '2023-12-09 18:26:00',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120048957' and product_code = 'DG0103148-05' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120049018' and product_code = '13656' 2023-12-09 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,'214467','8','O23120049018','8結蛋捲【紅提袋裝】','13656','13656','40入原味蛋捲','組合-40入原味+紅提袋','290','290','0','0','0','0','1','0.0','3','870','2024-01-17','2023-12-09 18:28:38','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214467',`firm_id` = '8',`ordernumber` = 'O23120049018', `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` = '3',`total_price` = '870',`etd` = '2024-01-17',`create_date` = '2023-12-09 18:28:38',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120049018' and product_code = '13656' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120049018' and product_code = 'DG010101-01' 2023-12-09 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,'214467','8','O23120049018','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','2','560','2024-01-17','2023-12-09 18:28:38','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214467',`firm_id` = '8',`ordernumber` = 'O23120049018', `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` = '2024-01-17',`create_date` = '2023-12-09 18:28:38',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120049018' and product_code = 'DG010101-01' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120049133' and product_code = 'DG0103155-04' 2023-12-09 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,'214468','8','O23120049133','【SNOOPY聯名】友你相伴-8結禮盒','DG0103155-04','DG0103155','原味蛋捲,海苔蛋捲','禮盒-SNOOPY【原味+海苔】','500','500','0','0','0','0','1','0.0','1','500','2024-01-17','2023-12-09 18:49:11','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214468',`firm_id` = '8',`ordernumber` = 'O23120049133', `product_name` = '【SNOOPY聯名】友你相伴-8結禮盒',`product_code` = 'DG0103155-04',`product_sn` = 'DG0103155',`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` = '2024-01-17',`create_date` = '2023-12-09 18:49:11',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120049133' and product_code = 'DG0103155-04' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120049133' and product_code = 'DG010327-04' 2023-12-09 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,'214468','8','O23120049133','【小王子聯名】仰望星空8結禮盒 ','DG010327-04','DG010327','原味,海苔','禮盒-小王子(藍)【原味+海苔】','500','500','0','0','0','0','1','0.0','2','1000','2024-01-17','2023-12-09 18:49:11','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214468',`firm_id` = '8',`ordernumber` = 'O23120049133', `product_name` = '【小王子聯名】仰望星空8結禮盒 ',`product_code` = 'DG010327-04',`product_sn` = 'DG010327',`product_spec` = '原味,海苔',`invoice_name` = '禮盒-小王子(藍)【原味+海苔】',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '1000',`etd` = '2024-01-17',`create_date` = '2023-12-09 18:49:11',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120049133' and product_code = 'DG010327-04' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120049133' and product_code = 'DG010203-01' 2023-12-09 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,'214468','8','O23120049133','【小王子聯名】閃耀星空8結提盒','DG010203-01','DG010203','40入原味蛋捲','提盒-小王子(藍)-40入原味','300','300','0','0','0','0','1','0.0','1','300','2024-01-17','2023-12-09 18:49:11','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214468',`firm_id` = '8',`ordernumber` = 'O23120049133', `product_name` = '【小王子聯名】閃耀星空8結提盒',`product_code` = 'DG010203-01',`product_sn` = 'DG010203',`product_spec` = '40入原味蛋捲',`invoice_name` = '提盒-小王子(藍)-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` = '2024-01-17',`create_date` = '2023-12-09 18:49:11',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120049133' and product_code = 'DG010203-01' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120049240' and product_code = 'DG010101-01' 2023-12-09 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,'214469','8','O23120049240','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','6','1680','2023-12-11','2023-12-09 19:18:21','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214469',`firm_id` = '8',`ordernumber` = 'O23120049240', `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` = '6',`total_price` = '1680',`etd` = '2023-12-11',`create_date` = '2023-12-09 19:18:21',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120049240' and product_code = 'DG010101-01' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120049332' and product_code = 'DG0103155-02' 2023-12-09 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,'214470','8','O23120049332','【SNOOPY聯名】友你相伴-8結禮盒','DG0103155-02','DG0103155','原味蛋捲,芝麻蛋捲','禮盒-SNOOPY【原味+芝麻】','500','500','0','0','0','0','1','0.0','1','500','2023-12-11','2023-12-09 19:32:37','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214470',`firm_id` = '8',`ordernumber` = 'O23120049332', `product_name` = '【SNOOPY聯名】友你相伴-8結禮盒',`product_code` = 'DG0103155-02',`product_sn` = 'DG0103155',`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` = '2023-12-11',`create_date` = '2023-12-09 19:32:37',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120049332' and product_code = 'DG0103155-02' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120049416' and product_code = 'DG010101-01' 2023-12-09 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,'214471','8','O23120049416','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','3','840','2023-12-11','2023-12-09 20:43:31','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214471',`firm_id` = '8',`ordernumber` = 'O23120049416', `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` = '2023-12-11',`create_date` = '2023-12-09 20:43:31',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120049416' and product_code = 'DG010101-01' 2023-12-09 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120049416' and product_code = 'DG010101-02' 2023-12-09 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,'214471','8','O23120049416','香醇芝麻蛋捲','DG010101-02','DG010101','芝麻','40入芝麻蛋捲','320','280','0','0','0','0','1','280.0','5','1400','2023-12-11','2023-12-09 20:43:31','2023-12-09 23:59:07',null,'1','2023-10-27') 2023-12-09 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214471',`firm_id` = '8',`ordernumber` = 'O23120049416', `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` = '5',`total_price` = '1400',`etd` = '2023-12-11',`create_date` = '2023-12-09 20:43:31',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120049416' and product_code = 'DG010101-02' 2023-12-09 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120049416' and product_code = 'DG010404-01' 2023-12-09 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,'214471','8','O23120049416','[加購]紅色提袋','DG010404-01','DG010404','-','紅色提袋','10','10','1','0','10','0','0','0.0','7','70','2023-12-11','2023-12-09 20:43:31','2023-12-09 23:59:08',null,'1','2023-10-27') 2023-12-09 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214471',`firm_id` = '8',`ordernumber` = 'O23120049416', `product_name` = '[加購]紅色提袋',`product_code` = 'DG010404-01',`product_sn` = 'DG010404',`product_spec` = '-',`invoice_name` = '紅色提袋',`listprice` = '10',`sellingprice` = '10',`isadd` = '1',`isbaby` = '0',`addprice` = '10',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '7',`total_price` = '70',`etd` = '2023-12-11',`create_date` = '2023-12-09 20:43:31',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120049416' and product_code = 'DG010404-01' 2023-12-09 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120049416' and product_code = '04191' 2023-12-09 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,'214471','8','O23120049416','[加購]加購－一口鳳梨酥','04191','04191','-','加購－金巧鳳梨酥','120','120','1','1','120','0','0','0.0','1','120','2023-12-11','2023-12-09 20:43:31','2023-12-09 23:59:08',null,'1','2023-10-27') 2023-12-09 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214471',`firm_id` = '8',`ordernumber` = 'O23120049416', `product_name` = '[加購]加購－一口鳳梨酥',`product_code` = '04191',`product_sn` = '04191',`product_spec` = '-',`invoice_name` = '加購－金巧鳳梨酥',`listprice` = '120',`sellingprice` = '120',`isadd` = '1',`isbaby` = '1',`addprice` = '120',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '120',`etd` = '2023-12-11',`create_date` = '2023-12-09 20:43:31',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120049416' and product_code = '04191' 2023-12-09 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120049584' and product_code = 'DG0103134-07' 2023-12-09 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,'214472','8','O23120049584','仕女帆布袋蛋捲三入組','DG0103134-07','DG0103134','原味+芝麻+咖啡','組合-32入(原味+芝麻+咖啡)+仕女帆布袋','985','985','0','0','0','1','1','0.0','1','985','2023-12-13','2023-12-09 20:48:55','2023-12-09 23:59:08',null,'1','2023-10-27') 2023-12-09 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214472',`firm_id` = '8',`ordernumber` = 'O23120049584', `product_name` = '仕女帆布袋蛋捲三入組',`product_code` = 'DG0103134-07',`product_sn` = 'DG0103134',`product_spec` = '原味+芝麻+咖啡',`invoice_name` = '組合-32入(原味+芝麻+咖啡)+仕女帆布袋',`listprice` = '985',`sellingprice` = '985',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '985',`etd` = '2023-12-13',`create_date` = '2023-12-09 20:48:55',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120049584' and product_code = 'DG0103134-07' 2023-12-09 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120049584' and product_code = 'DG010101-03' 2023-12-09 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,'214472','8','O23120049584','極上咖啡蛋捲','DG010101-03','DG010101','咖啡','40入咖啡蛋捲','320','280','0','0','0','0','1','280.0','1','280','2023-12-13','2023-12-09 20:48:55','2023-12-09 23:59:08',null,'1','2023-10-27') 2023-12-09 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214472',`firm_id` = '8',`ordernumber` = 'O23120049584', `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` = '2023-12-13',`create_date` = '2023-12-09 20:48:55',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120049584' and product_code = 'DG010101-03' 2023-12-09 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120049584' and product_code = 'DG010101-02' 2023-12-09 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,'214472','8','O23120049584','香醇芝麻蛋捲','DG010101-02','DG010101','芝麻','40入芝麻蛋捲','320','280','0','0','0','0','1','280.0','1','280','2023-12-13','2023-12-09 20:48:55','2023-12-09 23:59:08',null,'1','2023-10-27') 2023-12-09 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214472',`firm_id` = '8',`ordernumber` = 'O23120049584', `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` = '2023-12-13',`create_date` = '2023-12-09 20:48:55',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120049584' and product_code = 'DG010101-02' 2023-12-09 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120049670' and product_code = 'DG0103148-02' 2023-12-09 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,'214473','8','O23120049670','金典8結禮盒','DG0103148-02','DG0103148','原味+芝麻','禮盒-金典(紅)【原味+芝麻】','480','480','0','0','0','0','1','0.0','12','5760','2024-01-17','2023-12-09 20:49:52','2023-12-09 23:59:08',null,'1','2023-10-27') 2023-12-09 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214473',`firm_id` = '8',`ordernumber` = 'O23120049670', `product_name` = '金典8結禮盒',`product_code` = 'DG0103148-02',`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` = '12',`total_price` = '5760',`etd` = '2024-01-17',`create_date` = '2023-12-09 20:49:52',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120049670' and product_code = 'DG0103148-02' 2023-12-09 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120049738' and product_code = 'DG0103148-12' 2023-12-09 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,'214474','8','O23120049738','金典8結禮盒','DG0103148-12','DG0103148','巧克力+咖啡','禮盒-金典(紅)【咖啡+巧克力】','480','480','0','0','0','0','1','0.0','1','480','2024-01-17','2023-12-09 20:53:04','2023-12-09 23:59:08',null,'1','2023-10-27') 2023-12-09 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214474',`firm_id` = '8',`ordernumber` = 'O23120049738', `product_name` = '金典8結禮盒',`product_code` = 'DG0103148-12',`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` = '2024-01-17',`create_date` = '2023-12-09 20:53:04',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120049738' and product_code = 'DG0103148-12' 2023-12-09 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120049738' and product_code = 'DG0103148-03' 2023-12-09 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,'214474','8','O23120049738','金典8結禮盒','DG0103148-03','DG0103148','原味+咖啡','禮盒-金典(紅)【原味+咖啡】','480','480','0','0','0','0','1','0.0','1','480','2024-01-17','2023-12-09 20:53:04','2023-12-09 23:59:08',null,'1','2023-10-27') 2023-12-09 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214474',`firm_id` = '8',`ordernumber` = 'O23120049738', `product_name` = '金典8結禮盒',`product_code` = 'DG0103148-03',`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` = '2024-01-17',`create_date` = '2023-12-09 20:53:04',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120049738' and product_code = 'DG0103148-03' 2023-12-09 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120049738' and product_code = 'DG0103148-05' 2023-12-09 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,'214474','8','O23120049738','金典8結禮盒','DG0103148-05','DG0103148','原味+巧克力','禮盒-金典(紅)【原味+巧克力】','480','480','0','0','0','0','1','0.0','6','2880','2024-01-17','2023-12-09 20:53:04','2023-12-09 23:59:08',null,'1','2023-10-27') 2023-12-09 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214474',`firm_id` = '8',`ordernumber` = 'O23120049738', `product_name` = '金典8結禮盒',`product_code` = 'DG0103148-05',`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` = '6',`total_price` = '2880',`etd` = '2024-01-17',`create_date` = '2023-12-09 20:53:04',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120049738' and product_code = 'DG0103148-05' 2023-12-09 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120049812' and product_code = 'DG010101-05' 2023-12-09 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,'214475','8','O23120049812','濃情巧克力蛋捲','DG010101-05','DG010101','巧克力','40入巧克力蛋捲','320','280','0','0','0','0','1','280.0','2','560','2024-01-17','2023-12-09 20:56:33','2023-12-09 23:59:08',null,'1','2023-10-27') 2023-12-09 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214475',`firm_id` = '8',`ordernumber` = 'O23120049812', `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` = '2024-01-17',`create_date` = '2023-12-09 20:56:33',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120049812' and product_code = 'DG010101-05' 2023-12-09 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120049812' and product_code = 'DG010312-09' 2023-12-09 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,'214475','8','O23120049812','【芝麻+巧克力】金8結禮盒','DG010312-09','DG010312','金8結盒','禮盒-金8結【芝麻+巧克力】','590','480','0','0','0','0','1','480.0','12','5760','2024-01-17','2023-12-09 20:56:33','2023-12-09 23:59:08',null,'1','2023-10-27') 2023-12-09 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214475',`firm_id` = '8',`ordernumber` = 'O23120049812', `product_name` = '【芝麻+巧克力】金8結禮盒',`product_code` = 'DG010312-09',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【芝麻+巧克力】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '12',`total_price` = '5760',`etd` = '2024-01-17',`create_date` = '2023-12-09 20:56:33',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120049812' and product_code = 'DG010312-09' 2023-12-09 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120049933' and product_code = 'FL010310-01' 2023-12-09 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,'214476','8','O23120049933','一口酥24入家庭號禮盒','FL010310-01','12586','12入鳳梨酥+12入鳳梅酥','禮盒-12入鳳梨酥+12入鳳梅酥','435','435','0','0','0','0','1','0.0','4','1740','2024-01-17','2023-12-09 21:04:30','2023-12-09 23:59:08',null,'1','2023-10-27') 2023-12-09 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214476',`firm_id` = '8',`ordernumber` = 'O23120049933', `product_name` = '一口酥24入家庭號禮盒',`product_code` = 'FL010310-01',`product_sn` = '12586',`product_spec` = '12入鳳梨酥+12入鳳梅酥',`invoice_name` = '禮盒-12入鳳梨酥+12入鳳梅酥',`listprice` = '435',`sellingprice` = '435',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '4',`total_price` = '1740',`etd` = '2024-01-17',`create_date` = '2023-12-09 21:04:30',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120049933' and product_code = 'FL010310-01' 2023-12-09 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120049933' and product_code = 'FL010102-01' 2023-12-09 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,'214476','8','O23120049933','一口鳳梨酥','FL010102-01','FL010102','8入鳳梨酥','金巧鳳梨酥','130','130','0','0','0','0','1','130.0','2','260','2024-01-17','2023-12-09 21:04:30','2023-12-09 23:59:08',null,'1','2023-10-27') 2023-12-09 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214476',`firm_id` = '8',`ordernumber` = 'O23120049933', `product_name` = '一口鳳梨酥',`product_code` = 'FL010102-01',`product_sn` = 'FL010102',`product_spec` = '8入鳳梨酥',`invoice_name` = '金巧鳳梨酥',`listprice` = '130',`sellingprice` = '130',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '130.0',`amount` = '2',`total_price` = '260',`etd` = '2024-01-17',`create_date` = '2023-12-09 21:04:30',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120049933' and product_code = 'FL010102-01' 2023-12-09 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120049933' and product_code = '04190' 2023-12-09 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,'214476','8','O23120049933','[加購]加購－一口鳳梅酥','04190','04190','-','加購－金巧鳳梅酥','150','150','1','1','150','0','0','0.0','12','1800','2024-01-17','2023-12-09 21:04:30','2023-12-09 23:59:08',null,'1','2023-10-27') 2023-12-09 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214476',`firm_id` = '8',`ordernumber` = 'O23120049933', `product_name` = '[加購]加購－一口鳳梅酥',`product_code` = '04190',`product_sn` = '04190',`product_spec` = '-',`invoice_name` = '加購－金巧鳳梅酥',`listprice` = '150',`sellingprice` = '150',`isadd` = '1',`isbaby` = '1',`addprice` = '150',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '12',`total_price` = '1800',`etd` = '2024-01-17',`create_date` = '2023-12-09 21:04:30',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120049933' and product_code = '04190' 2023-12-09 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120050089' and product_code = 'DG010261-01' 2023-12-09 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,'214477','8','O23120050089','【SNOOPY聯名】美好食光-8結提盒','DG010261-01','DG010261','40入原味蛋捲','提盒-SNOOPY-40入原味','300','300','0','0','0','0','1','0.0','8','2400','2023-12-11','2023-12-09 21:28:14','2023-12-09 23:59:08',null,'1','2023-10-27') 2023-12-09 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214477',`firm_id` = '8',`ordernumber` = 'O23120050089', `product_name` = '【SNOOPY聯名】美好食光-8結提盒',`product_code` = 'DG010261-01',`product_sn` = 'DG010261',`product_spec` = '40入原味蛋捲',`invoice_name` = '提盒-SNOOPY-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` = '2023-12-11',`create_date` = '2023-12-09 21:28:14',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120050089' and product_code = 'DG010261-01' 2023-12-09 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120050089' and product_code = 'DG010203-01' 2023-12-09 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,'214477','8','O23120050089','【小王子聯名】閃耀星空8結提盒','DG010203-01','DG010203','40入原味蛋捲','提盒-小王子(藍)-40入原味','300','300','0','0','0','0','1','0.0','7','2100','2023-12-11','2023-12-09 21:28:14','2023-12-09 23:59:08',null,'1','2023-10-27') 2023-12-09 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214477',`firm_id` = '8',`ordernumber` = 'O23120050089', `product_name` = '【小王子聯名】閃耀星空8結提盒',`product_code` = 'DG010203-01',`product_sn` = 'DG010203',`product_spec` = '40入原味蛋捲',`invoice_name` = '提盒-小王子(藍)-40入原味',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '7',`total_price` = '2100',`etd` = '2023-12-11',`create_date` = '2023-12-09 21:28:14',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120050089' and product_code = 'DG010203-01' 2023-12-09 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120050160' and product_code = 'DG010312-05' 2023-12-09 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,'214478','8','O23120050160','【原味+巧克力】金8結禮盒','DG010312-05','DG010312','金8結盒','禮盒-金8結【原味+巧克力】','590','480','0','0','0','0','1','480.0','14','6720','2024-01-17','2023-12-09 21:59:16','2023-12-09 23:59:08',null,'1','2023-10-27') 2023-12-09 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214478',`firm_id` = '8',`ordernumber` = 'O23120050160', `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` = '14',`total_price` = '6720',`etd` = '2024-01-17',`create_date` = '2023-12-09 21:59:16',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120050160' and product_code = 'DG010312-05' 2023-12-09 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120050160' and product_code = 'DG010255-01' 2023-12-09 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,'214478','8','O23120050160','金典8結提盒','DG010255-01','DG010255','40入原味蛋捲','提盒-金典(紅)-40入原味','295','295','0','0','0','0','1','0.0','14','4130','2024-01-17','2023-12-09 21:59:16','2023-12-09 23:59:08',null,'1','2023-10-27') 2023-12-09 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214478',`firm_id` = '8',`ordernumber` = 'O23120050160', `product_name` = '金典8結提盒',`product_code` = 'DG010255-01',`product_sn` = 'DG010255',`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` = '14',`total_price` = '4130',`etd` = '2024-01-17',`create_date` = '2023-12-09 21:59:16',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120050160' and product_code = 'DG010255-01' 2023-12-09 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120050290' and product_code = 'DG010101-03' 2023-12-09 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,'214479','8','O23120050290','極上咖啡蛋捲','DG010101-03','DG010101','咖啡','40入咖啡蛋捲','320','280','0','0','0','0','1','280.0','2','560','2024-01-17','2023-12-09 22:03:17','2023-12-09 23:59:08',null,'1','2023-10-27') 2023-12-09 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214479',`firm_id` = '8',`ordernumber` = 'O23120050290', `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` = '2',`total_price` = '560',`etd` = '2024-01-17',`create_date` = '2023-12-09 22:03:17',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120050290' and product_code = 'DG010101-03' 2023-12-09 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120050290' and product_code = 'DG010129-01' 2023-12-09 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,'214479','8','O23120050290','【期間限定】皇家伯爵茶蛋捲','DG010129-01','DG010129','32入伯爵茶','32入伯爵茶','300','300','0','0','0','0','1','0.0','1','300','2024-01-17','2023-12-09 22:03:17','2023-12-09 23:59:08',null,'1','2023-10-27') 2023-12-09 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214479',`firm_id` = '8',`ordernumber` = 'O23120050290', `product_name` = '【期間限定】皇家伯爵茶蛋捲',`product_code` = 'DG010129-01',`product_sn` = 'DG010129',`product_spec` = '32入伯爵茶',`invoice_name` = '32入伯爵茶',`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` = '2024-01-17',`create_date` = '2023-12-09 22:03:17',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120050290' and product_code = 'DG010129-01' 2023-12-09 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120050290' and product_code = 'DG010101-01' 2023-12-09 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,'214479','8','O23120050290','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','1','280','2024-01-17','2023-12-09 22:03:17','2023-12-09 23:59:08',null,'1','2023-10-27') 2023-12-09 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214479',`firm_id` = '8',`ordernumber` = 'O23120050290', `product_name` = '經典原味蛋捲',`product_code` = 'DG010101-01',`product_sn` = 'DG010101',`product_spec` = '原味',`invoice_name` = '40入原味蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2024-01-17',`create_date` = '2023-12-09 22:03:17',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120050290' and product_code = 'DG010101-01' 2023-12-09 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120050290' and product_code = 'DG010404-01' 2023-12-09 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,'214479','8','O23120050290','[加購]紅色提袋','DG010404-01','DG010404','-','紅色提袋','10','10','1','0','10','0','0','0.0','1','10','2024-01-17','2023-12-09 22:03:17','2023-12-09 23:59:08',null,'1','2023-10-27') 2023-12-09 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214479',`firm_id` = '8',`ordernumber` = 'O23120050290', `product_name` = '[加購]紅色提袋',`product_code` = 'DG010404-01',`product_sn` = 'DG010404',`product_spec` = '-',`invoice_name` = '紅色提袋',`listprice` = '10',`sellingprice` = '10',`isadd` = '1',`isbaby` = '0',`addprice` = '10',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '10',`etd` = '2024-01-17',`create_date` = '2023-12-09 22:03:17',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120050290' and product_code = 'DG010404-01' 2023-12-09 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120050387' and product_code = 'DG010101-01' 2023-12-09 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,'214480','8','O23120050387','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','2','560','2023-12-19','2023-12-09 22:39:29','2023-12-09 23:59:08',null,'1','2023-10-27') 2023-12-09 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214480',`firm_id` = '8',`ordernumber` = 'O23120050387', `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` = '2023-12-19',`create_date` = '2023-12-09 22:39:29',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120050387' and product_code = 'DG010101-01' 2023-12-09 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120050387' and product_code = 'DG010101-03' 2023-12-09 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,'214480','8','O23120050387','極上咖啡蛋捲','DG010101-03','DG010101','咖啡','40入咖啡蛋捲','320','280','0','0','0','0','1','280.0','1','280','2023-12-19','2023-12-09 22:39:29','2023-12-09 23:59:08',null,'1','2023-10-27') 2023-12-09 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214480',`firm_id` = '8',`ordernumber` = 'O23120050387', `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` = '2023-12-19',`create_date` = '2023-12-09 22:39:29',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120050387' and product_code = 'DG010101-03' 2023-12-09 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120050387' and product_code = 'DG010101-02' 2023-12-09 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,'214480','8','O23120050387','香醇芝麻蛋捲','DG010101-02','DG010101','芝麻','40入芝麻蛋捲','320','280','0','0','0','0','1','280.0','1','280','2023-12-19','2023-12-09 22:39:29','2023-12-09 23:59:08',null,'1','2023-10-27') 2023-12-09 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214480',`firm_id` = '8',`ordernumber` = 'O23120050387', `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` = '2023-12-19',`create_date` = '2023-12-09 22:39:29',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120050387' and product_code = 'DG010101-02' 2023-12-09 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120050387' and product_code = 'DG010101-04' 2023-12-09 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,'214480','8','O23120050387','日式海苔蛋捲','DG010101-04','DG010101','單盒','40入海苔蛋捲','320','280','0','0','0','0','1','280.0','1','280','2023-12-19','2023-12-09 22:39:29','2023-12-09 23:59:08',null,'1','2023-10-27') 2023-12-09 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214480',`firm_id` = '8',`ordernumber` = 'O23120050387', `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` = '2023-12-19',`create_date` = '2023-12-09 22:39:29',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120050387' and product_code = 'DG010101-04' 2023-12-09 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120050387' and product_code = 'DG010527-01' 2023-12-09 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,'214480','8','O23120050387','8結蛋捲【小禮袋裝】','DG010527-01','DG010527','40入原味蛋捲','組合-40入原味+8結小禮袋','290','290','0','0','0','0','1','0.0','4','1160','2023-12-19','2023-12-09 22:39:29','2023-12-09 23:59:08',null,'1','2023-10-27') 2023-12-09 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214480',`firm_id` = '8',`ordernumber` = 'O23120050387', `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` = '4',`total_price` = '1160',`etd` = '2023-12-19',`create_date` = '2023-12-09 22:39:29',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120050387' and product_code = 'DG010527-01' 2023-12-09 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23120050467' and product_code = 'DG0103155-09' 2023-12-09 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,'214481','8','O23120050467','【SNOOPY聯名】友你相伴-8結禮盒','DG0103155-09','DG0103155','芝麻蛋捲,巧克力蛋捲','禮盒-SNOOPY【芝麻+巧克力】','500','500','0','0','0','0','1','0.0','1','500','2023-12-11','2023-12-09 23:52:53','2023-12-09 23:59:08',null,'1','2023-10-27') 2023-12-09 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '214481',`firm_id` = '8',`ordernumber` = 'O23120050467', `product_name` = '【SNOOPY聯名】友你相伴-8結禮盒',`product_code` = 'DG0103155-09',`product_sn` = 'DG0103155',`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` = '2023-12-11',`create_date` = '2023-12-09 23:52:53',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-27'where ordernumber = 'O23120050467' and product_code = 'DG0103155-09' 2023-12-09 23:59:08 -- == sync_order_detail end == 2023-12-09 23:59:08 -- == sync_order start == 2023-12-09 23:59:08 -- start:2023-12-09,end:2023-12-09 2023-12-09 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 '2023-12-09%' OR l.modify_date like '2023-12-09%'; 2023-12-09 23:59:09 -- == sync omo_order_list == 2023-12-09 23:59:09 -- == update lake.omo_order_list == update omo_order_list set userId = '350747', process_status = '3', pay_status = '1', totalprice_after = '800', lunar_date = '2023-10-22', invoice_status = '0', category_name = '彌月試吃,LINE@訂單', category_id = '2,9' where ordernumber = 'M23120003095' 2023-12-09 23:59:09 -- == update lake.omo_order_list == update omo_order_list set userId = '350982', process_status = '3', pay_status = '8', totalprice_after = '400', lunar_date = '2023-10-24', invoice_status = '1', category_name = '彌月試吃,LINE@訂單', category_id = '2,9' where ordernumber = 'M23120006449' 2023-12-09 23:59:09 -- == 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 ('74581','351452',2,'','','B23120009445','1','11','1','1','1','87495438','竹原小吃店','0','0000-00-00','0','0','0','','150','100','1300','242','新北市','新莊區','242','新北市','新莊區','1350','2023-12-09 13:21:35','2023-10-27') 2023-12-09 23:59:09 -- == 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 ('74607','351478',2,'','','B23120009533','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','500','540','南投縣','南投市','540','南投縣','南投市','620','2023-12-09 14:38:59','2023-10-27') 2023-12-09 23:59:09 -- == 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 ('74221','351101',2,'','','B23120009643','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','300','505','彰化縣','鹿港鎮','427','台中市','潭子區','420','2023-12-09 18:16:56','2023-10-27') 2023-12-09 23:59:09 -- == 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 ('74221','351101',2,'','','B23120009737','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','300','505','彰化縣','鹿港鎮','709','台南市','安南區','450','2023-12-09 18:55:57','2023-10-27') 2023-12-09 23:59:09 -- == 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 ('74221','351101',2,'','','B23120009863','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','300','505','彰化縣','鹿港鎮','320','桃園市','中壢區','450','2023-12-09 19:25:55','2023-10-27') 2023-12-09 23:59:09 -- == 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 ('74221','351101',2,'','','B23120009968','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','300','505','彰化縣','鹿港鎮','114','台北市','內湖區','450','2023-12-09 19:29:06','2023-10-27') 2023-12-09 23:59:09 -- == sync_order end == 2023-12-09 23:59:09 -- == sync_order_detail start == 2023-12-09 23:59:09 -- start:2023-12-09,end:2023-12-09 2023-12-09 23:59:09 -- == sync omo_order_detail == 2023-12-09 23:59:09 -- == SELECT order_detail == SELECT * from order_detail WHERE create_date like '2023-12-09%' OR modify_date like '2023-12-09%' 2023-12-09 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M23120003095' and product_code = 'DG010243-01' 2023-12-09 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29330',`firm_id` = '11',`ordernumber` = 'M23120003095', `product_name` = '彌月試吃提盒－年輪',`product_code` = 'DG010243-01',`product_sn` = 'DG010243',`product_spec` = '原味',`invoice_name` = '提盒-彌月年輪-40入原味(試吃)',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '300.0',`amount` = '1',`total_price` = '300',`etd` = '2023-12-08',`create_date` = '2023-12-04 14:15:28',`modify_date` = '2023-12-09 13:17:49',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M23120003095' and product_code = 'DG010243-01', `lunar_date` = '2023-10-22' 2023-12-09 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M23120003095' and product_code = 'DG010264-01' 2023-12-09 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29330',`firm_id` = '11',`ordernumber` = 'M23120003095', `product_name` = '【SNOOPY聯名】美好食光-8結彌月提盒(試吃)',`product_code` = 'DG010264-01',`product_sn` = 'DG010264',`product_spec` = '原味',`invoice_name` = '提盒-彌月SNOOPY-40入原味(試吃)',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '300',`etd` = '2023-12-08',`create_date` = '2023-12-04 14:15:28',`modify_date` = '2023-12-09 13:17:49',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M23120003095' and product_code = 'DG010264-01', `lunar_date` = '2023-10-22' 2023-12-09 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M23120003095' and product_code = 'DG010244-01' 2023-12-09 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29330',`firm_id` = '11',`ordernumber` = 'M23120003095', `product_name` = '小王子彌月試吃提盒',`product_code` = 'DG010244-01',`product_sn` = 'DG010244',`product_spec` = '原味',`invoice_name` = '提盒-小王子(藍)-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` = '2023-12-08',`create_date` = '2023-12-04 14:15:28',`modify_date` = '2023-12-09 13:17:49',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M23120003095' and product_code = 'DG010244-01', `lunar_date` = '2023-10-22' 2023-12-09 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M23120003095' and product_code = 'DG010253-01' 2023-12-09 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29330',`firm_id` = '11',`ordernumber` = 'M23120003095', `product_name` = '【小王子聯名】夢想旅程8結彌月提盒(試吃)',`product_code` = 'DG010253-01',`product_sn` = 'DG010253',`product_spec` = '原味',`invoice_name` = '提盒-彌月小王子(紅)-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` = '2023-12-08',`create_date` = '2023-12-04 14:15:28',`modify_date` = '2023-12-09 13:17:49',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M23120003095' and product_code = 'DG010253-01', `lunar_date` = '2023-10-22' 2023-12-09 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M23120006449' and product_code = 'DG010243-01' 2023-12-09 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29368',`firm_id` = '11',`ordernumber` = 'M23120006449', `product_name` = '彌月試吃提盒－年輪',`product_code` = 'DG010243-01',`product_sn` = 'DG010243',`product_spec` = '原味',`invoice_name` = '提盒-彌月年輪-40入原味(試吃)',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '300.0',`amount` = '1',`total_price` = '300',`etd` = '2023-12-08',`create_date` = '2023-12-06 11:50:29',`modify_date` = '2023-12-09 14:48:41',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M23120006449' and product_code = 'DG010243-01', `lunar_date` = '2023-10-24' 2023-12-09 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M23120006449' and product_code = 'DG010253-02' 2023-12-09 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29368',`firm_id` = '11',`ordernumber` = 'M23120006449', `product_name` = '【小王子聯名】夢想旅程8結彌月提盒(試吃)',`product_code` = 'DG010253-02',`product_sn` = 'DG010253',`product_spec` = '芝麻',`invoice_name` = '提盒-彌月小王子(紅)-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` = '2023-12-08',`create_date` = '2023-12-06 11:50:29',`modify_date` = '2023-12-09 14:48:41',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M23120006449' and product_code = 'DG010253-02', `lunar_date` = '2023-10-24' 2023-12-09 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B23120009445' and product_code = 'DG0103156-02' 2023-12-09 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`, `channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`,`lunar_date`) VALUES (null, 2,'29400','8','B23120009445','【SNOOPY聯名】友你相伴-8結彌月禮盒','DG0103156-02','DG0103156','原味+芝麻','禮盒-彌月SNOOPY【原味+芝麻】','500','500','0','1','0','0','1','0.0','1','500','2023-12-15','2023-12-09 13:21:35','2023-12-09 23:59:09',null,'1','2023-10-27') 2023-12-09 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29400',`firm_id` = '8',`ordernumber` = 'B23120009445', `product_name` = '【SNOOPY聯名】友你相伴-8結彌月禮盒',`product_code` = 'DG0103156-02',`product_sn` = 'DG0103156',`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` = '2023-12-15',`create_date` = '2023-12-09 13:21:35',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B23120009445' and product_code = 'DG0103156-02', `lunar_date` = '2023-10-27' 2023-12-09 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B23120009445' and product_code = 'DG0103156-05' 2023-12-09 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`, `channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`,`lunar_date`) VALUES (null, 2,'29400','8','B23120009445','【SNOOPY聯名】友你相伴-8結彌月禮盒','DG0103156-05','DG0103156','原味+巧克力','禮盒-彌月SNOOPY【原味+巧克力】','500','500','0','1','0','0','1','0.0','1','500','2023-12-15','2023-12-09 13:21:35','2023-12-09 23:59:09',null,'1','2023-10-27') 2023-12-09 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29400',`firm_id` = '8',`ordernumber` = 'B23120009445', `product_name` = '【SNOOPY聯名】友你相伴-8結彌月禮盒',`product_code` = 'DG0103156-05',`product_sn` = 'DG0103156',`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` = '2023-12-15',`create_date` = '2023-12-09 13:21:35',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B23120009445' and product_code = 'DG0103156-05', `lunar_date` = '2023-10-27' 2023-12-09 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B23120009445' and product_code = 'DG010263-01' 2023-12-09 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`, `channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`,`lunar_date`) VALUES (null, 2,'29400','8','B23120009445','【SNOOPY聯名】美好食光-8結彌月提盒','DG010263-01','DG010263','原味','提盒-彌月SNOOPY-40入原味','300','300','0','1','0','0','1','0.0','1','300','2023-12-15','2023-12-09 13:21:35','2023-12-09 23:59:09',null,'1','2023-10-27') 2023-12-09 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29400',`firm_id` = '8',`ordernumber` = 'B23120009445', `product_name` = '【SNOOPY聯名】美好食光-8結彌月提盒',`product_code` = 'DG010263-01',`product_sn` = 'DG010263',`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` = '1',`total_price` = '300',`etd` = '2023-12-15',`create_date` = '2023-12-09 13:21:35',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B23120009445' and product_code = 'DG010263-01', `lunar_date` = '2023-10-27' 2023-12-09 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B23120009533' and product_code = 'DG010383-03' 2023-12-09 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`, `channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`,`lunar_date`) VALUES (null, 2,'29401','8','B23120009533','【小王子聯名】星光飛行8結彌月禮盒','DG010383-03','DG010383','原味+咖啡','禮盒-小王子(紅)【原味+咖啡】','500','500','0','1','0','0','1','0.0','1','500','2023-12-15','2023-12-09 14:38:59','2023-12-09 23:59:09',null,'1','2023-10-27') 2023-12-09 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29401',`firm_id` = '8',`ordernumber` = 'B23120009533', `product_name` = '【小王子聯名】星光飛行8結彌月禮盒',`product_code` = 'DG010383-03',`product_sn` = 'DG010383',`product_spec` = '原味+咖啡',`invoice_name` = '禮盒-小王子(紅)【原味+咖啡】',`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` = '2023-12-15',`create_date` = '2023-12-09 14:38:59',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B23120009533' and product_code = 'DG010383-03', `lunar_date` = '2023-10-27' 2023-12-09 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B23120009643' and product_code = 'DG010203-01' 2023-12-09 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`, `channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`,`lunar_date`) VALUES (null, 2,'29402','8','B23120009643','【小王子聯名】閃耀星空8結彌月提盒','DG010203-01','DG010203','原味','提盒-小王子(藍)-40入原味','300','300','0','1','0','0','1','0.0','1','300','2023-12-15','2023-12-09 18:16:56','2023-12-09 23:59:09',null,'1','2023-10-27') 2023-12-09 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29402',`firm_id` = '8',`ordernumber` = 'B23120009643', `product_name` = '【小王子聯名】閃耀星空8結彌月提盒',`product_code` = 'DG010203-01',`product_sn` = 'DG010203',`product_spec` = '原味',`invoice_name` = '提盒-小王子(藍)-40入原味',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '300',`etd` = '2023-12-15',`create_date` = '2023-12-09 18:16:56',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B23120009643' and product_code = 'DG010203-01', `lunar_date` = '2023-10-27' 2023-12-09 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B23120009737' and product_code = 'DG010203-01' 2023-12-09 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`, `channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`,`lunar_date`) VALUES (null, 2,'29403','8','B23120009737','【小王子聯名】閃耀星空8結彌月提盒','DG010203-01','DG010203','原味','提盒-小王子(藍)-40入原味','300','300','0','1','0','0','1','0.0','1','300','2023-12-15','2023-12-09 18:55:57','2023-12-09 23:59:09',null,'1','2023-10-27') 2023-12-09 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29403',`firm_id` = '8',`ordernumber` = 'B23120009737', `product_name` = '【小王子聯名】閃耀星空8結彌月提盒',`product_code` = 'DG010203-01',`product_sn` = 'DG010203',`product_spec` = '原味',`invoice_name` = '提盒-小王子(藍)-40入原味',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '300',`etd` = '2023-12-15',`create_date` = '2023-12-09 18:55:57',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B23120009737' and product_code = 'DG010203-01', `lunar_date` = '2023-10-27' 2023-12-09 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B23120009863' and product_code = 'DG010203-01' 2023-12-09 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`, `channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`,`lunar_date`) VALUES (null, 2,'29404','8','B23120009863','【小王子聯名】閃耀星空8結彌月提盒','DG010203-01','DG010203','原味','提盒-小王子(藍)-40入原味','300','300','0','1','0','0','1','0.0','1','300','2023-12-15','2023-12-09 19:25:55','2023-12-09 23:59:09',null,'1','2023-10-27') 2023-12-09 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29404',`firm_id` = '8',`ordernumber` = 'B23120009863', `product_name` = '【小王子聯名】閃耀星空8結彌月提盒',`product_code` = 'DG010203-01',`product_sn` = 'DG010203',`product_spec` = '原味',`invoice_name` = '提盒-小王子(藍)-40入原味',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '300',`etd` = '2023-12-15',`create_date` = '2023-12-09 19:25:55',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B23120009863' and product_code = 'DG010203-01', `lunar_date` = '2023-10-27' 2023-12-09 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B23120009968' and product_code = 'DG010203-01' 2023-12-09 23:59:09 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`, `channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`,`lunar_date`) VALUES (null, 2,'29405','8','B23120009968','【小王子聯名】閃耀星空8結彌月提盒','DG010203-01','DG010203','原味','提盒-小王子(藍)-40入原味','300','300','0','1','0','0','1','0.0','1','300','2023-12-15','2023-12-09 19:29:06','2023-12-09 23:59:09',null,'1','2023-10-27') 2023-12-09 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29405',`firm_id` = '8',`ordernumber` = 'B23120009968', `product_name` = '【小王子聯名】閃耀星空8結彌月提盒',`product_code` = 'DG010203-01',`product_sn` = 'DG010203',`product_spec` = '原味',`invoice_name` = '提盒-小王子(藍)-40入原味',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '300',`etd` = '2023-12-15',`create_date` = '2023-12-09 19:29:06',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B23120009968' and product_code = 'DG010203-01', `lunar_date` = '2023-10-27' 2023-12-09 23:59:09 -- == sync_order_detail end == 2023-12-09 23:59:09 -- == 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) = '2023-12-09' OR o.updated_at = '2023-12-09') and o.deleted_at is null 2023-12-09 23:59:09 -- == sync_order_detail start == 2023-12-09 23:59:09 -- start:2023-12-09,end:2023-12-09