2025-03-01 23:59:01 -- == sync_order start == 2025-03-01 23:59:01 -- start:2025-03-01,end:2025-03-01 2025-03-01 23:59:01 -- == select june1.order_list == SELECT l.mid,m.uid,l.category_name,l.category_id,l.ordernumber,l.location,l.payway,l.delivery_way,l.pay_status,l.process_status,l.company_number,l.company_title,l.invoice_status,l.etd,l.web_discount,l.class_discount,l.member_discount,l.web_gift,l.freight,l.entity_discount,l.totalprice,l.orderzip,l.orderaddresscity,l.orderaddressarea,l.recipientzip,l.recipientaddresscity,l.recipientaddressarea,l.totalprice_after-web_discount-class_discount-member_discount-entity_discount as totalprice_after,l.create_date FROM `order_list` l LEFT JOIN member_list m on l.mid = m.id WHERE l.create_date like '2025-03-01%' OR l.modify_date like '2025-03-01%'; 2025-03-01 23:59:03 -- == sync omo_order_list == 2025-03-01 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '371268', process_status = '3', pay_status = '1', totalprice_after = '1510', lunar_date = '2025-01-23', invoice_status = '0',category_name = '永康當日宅配', category_id = '19' where ordernumber = 'S25020109218' 2025-03-01 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '457301', process_status = '3', pay_status = '1', totalprice_after = '12227', lunar_date = '2025-01-24', invoice_status = '1',category_name = '迪化當日宅配', category_id = '44' where ordernumber = 'S25020114612' 2025-03-01 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('419450','455680',1,'','','O25030000193','1','11','1','0','0','','','0','0000-00-00','0','0','0','','150','30','290','205','基隆市','暖暖區','110','台北市','信義區','410','2025-03-01 00:15:50','2025-02-02') 2025-03-01 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('419450','455680',1,'','','O25030000283','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','290','205','基隆市','暖暖區','110','台北市','信義區','440','2025-03-01 00:18:48','2025-02-02') 2025-03-01 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('422638','458814',1,'','','O25030000391','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','2030','220','新北市','板橋區','220','新北市','板橋區','2150','2025-03-01 03:05:50','2025-02-02') 2025-03-01 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('421653','457841',1,'','','O25030000439','1','2','1','1','1','','','0','0000-00-00','0','0','0','','150','30','840','736','台南市','柳營區','736','台南市','柳營區','960','2025-03-01 03:26:01','2025-02-02') 2025-03-01 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('422640','458815',1,'','','O25030000558','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1680','973','花蓮縣','吉安鄉','973','花蓮縣','吉安鄉','1800','2025-03-01 04:09:07','2025-02-02') 2025-03-01 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('116016','85381',1,'','','O25030000656','1','11','1','1','1','','','0','0000-00-00','0','0','0','','0','0','7680','608','嘉義縣','水上鄉','710','台南市','永康區','7680','2025-03-01 07:16:28','2025-02-02') 2025-03-01 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('105631','76126',1,'','','O25030000723','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1030','249','新北市','八里區','333','桃園市','龜山區','1180','2025-03-01 09:14:49','2025-02-02') 2025-03-01 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('422643','458818',1,'','','O25030000882','1','2','1','0','0','','','0','0000-00-00','0','0','0','','150','30','480','807','高雄市','三民區','807','高雄市','三民區','600','2025-03-01 10:43:07','2025-02-02') 2025-03-01 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('422642','458817',1,'','','O25030000915','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','885','221','新北市','汐止區','221','新北市','汐止區','1005','2025-03-01 10:50:53','2025-02-02') 2025-03-01 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('421445','457633',1,'','','O25030001013','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','240','411','台中市','太平區','411','台中市','太平區','360','2025-03-01 11:10:24','2025-02-02') 2025-03-01 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('422662','458837',1,'','','O25030001182','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','560','717','台南市','仁德區','717','台南市','仁德區','710','2025-03-01 11:54:56','2025-02-02') 2025-03-01 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('146771','114648',1,'','','O25030001287','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1070','414','台中市','烏日區','414','台中市','烏日區','1220','2025-03-01 12:10:59','2025-02-02') 2025-03-01 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('422735','458909',1,'','','O25030001321','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','800','402','台中市','南區','402','台中市','南區','920','2025-03-01 14:43:02','2025-02-02') 2025-03-01 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('422731','458905',1,'','','O25030001498','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','480','338','桃園市','蘆竹區','613','嘉義縣','朴子市','600','2025-03-01 14:50:30','2025-02-02') 2025-03-01 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('422379','458555',1,'','','O25030001535','1','2','1','0','0','','','0','0000-00-00','0','0','0','','150','30','840','725','台南市','將軍區','726','台南市','學甲區','960','2025-03-01 15:05:29','2025-02-02') 2025-03-01 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('422783','458957',1,'','','O25030001624','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1110','407','台中市','西屯區','407','台中市','西屯區','1230','2025-03-01 16:21:39','2025-02-02') 2025-03-01 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('259916','297608',1,'','','O25030001773','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','2140','500','彰化縣','彰化市','500','彰化縣','彰化市','2290','2025-03-01 17:56:01','2025-02-02') 2025-03-01 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('422822','458996',1,'','','O25030001893','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','560','420','台中市','豐原區','420','台中市','豐原區','680','2025-03-01 18:20:16','2025-02-02') 2025-03-01 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('95533','66851',1,'通路訂單','5','S25030001932','1','15','15','0','3','','','0','2025-03-01','0','1000','0','','0','0','3340','403','台中市','西區','403','台中市','西區','2340','2025-03-01 18:51:16','2025-02-02') 2025-03-01 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('352657','0',1,'永康當日宅配','19','S25030002090','1','1','14','1','1','83085089','得意佳廣告有限公司','0','2025-03-02','0','435','0','','750','0','8700','110','台北市','信義區','244','新北市','林口區','9015','2025-03-01 20:06:34','2025-02-02') 2025-03-01 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('141042','109123',1,'','','O25030002186','1','11','1','0','0','','','0','0000-00-00','0','0','0','','150','0','1320','807','高雄市','三民區','807','高雄市','三民區','1470','2025-03-01 20:06:51','2025-02-02') 2025-03-01 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('422858','459031',1,'','','O25030002288','1','2','1','0','0','','','0','0000-00-00','0','0','0','','150','30','960','710','台南市','永康區','710','台南市','永康區','1080','2025-03-01 20:41:03','2025-02-02') 2025-03-01 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('422859','202677',1,'','','O25030002391','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1770','600','嘉義市','西區','238','新北市','樹林區','1920','2025-03-01 20:47:39','2025-02-02') 2025-03-01 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('422862','459034',1,'','','O25030002417','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','100','2000','116','台北市','文山區','116','台北市','文山區','2050','2025-03-01 22:09:28','2025-02-02') 2025-03-01 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('422865','459037',1,'','','O25030002548','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1030','509','彰化縣','伸港鄉','509','彰化縣','伸港鄉','1150','2025-03-01 22:14:21','2025-02-02') 2025-03-01 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('344484','381246',1,'','','O25030002649','1','1','1','0','0','','','0','0000-00-00','0','0','0','','150','150','1600','932','屏東縣','新園鄉','932','屏東縣','新園鄉','1600','2025-03-01 22:30:58','2025-02-02') 2025-03-01 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('422866','459038',1,'','','O25030002782','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1040','709','台南市','安南區','709','台南市','安南區','1160','2025-03-01 22:33:04','2025-02-02') 2025-03-01 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('422868','459040',1,'','','O25030002861','1','1','1','1','1','80016834','順利金屬工業股份有限公司','0','0000-00-00','0','0','0','','150','30','1460','367','苗栗縣','三義鄉','367','苗栗縣','三義鄉','1580','2025-03-01 22:37:15','2025-02-02') 2025-03-01 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('422864','459036',1,'','','O25030002932','1','1','1','1','1','02612744','國立體育大學','0','0000-00-00','0','0','0','','150','30','2970','333','桃園市','龜山區','333','桃園市','龜山區','3090','2025-03-01 22:47:41','2025-02-02') 2025-03-01 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('414624','450638',1,'','','O25030003040','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','990','300','新竹市','東區','300','新竹市','東區','1140','2025-03-01 23:02:48','2025-02-02') 2025-03-01 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('58169','31893',1,'','','O25030003121','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','150','1960','236','新北市','土城區','236','新北市','土城區','1960','2025-03-01 23:06:13','2025-02-02') 2025-03-01 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('412073','448119',1,'','','O25030003222','1','1','1','0','0','','','0','0000-00-00','0','0','0','','150','0','2000','852','高雄市','茄萣區','741','台南市','善化區','2150','2025-03-01 23:23:03','2025-02-02') 2025-03-01 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('412073','448119',1,'','','O25030003391','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','2000','852','高雄市','茄萣區','741','台南市','善化區','2150','2025-03-01 23:35:50','2025-02-02') 2025-03-01 23:59:03 -- == sync_order end == 2025-03-01 23:59:04 -- == sync_order_detail start == 2025-03-01 23:59:04 -- start:2025-03-01,end:2025-03-01 2025-03-01 23:59:04 -- == sync omo_order_detail == 2025-03-01 23:59:04 -- == SELECT order_detail == SELECT * from order_detail WHERE create_date like '2025-03-01%' OR modify_date like '2025-03-01%' 2025-03-01 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S25020114612' and product_code = 'DG0105103-09' 2025-03-01 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270123',`firm_id` = '8',`ordernumber` = 'S25020114612', `product_name` = 'SNOOPY美好心意-蛋捲三入組',`product_code` = 'DG0105103-09',`product_sn` = 'DG0105103',`product_spec` = '原味+芝麻+巧克力',`invoice_name` = '組合-32入(原味+芝麻+巧克力)+SNOOPY美好提袋',`listprice` = '990',`sellingprice` = '990',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '13',`total_price` = '12870',`etd` = '2025-02-26',`create_date` = '2025-02-21 13:10:44',`modify_date` = '2025-03-01 17:14:18',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2025-01-24'where ordernumber = 'S25020114612' and product_code = 'DG0105103-09' 2025-03-01 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S25020109218' and product_code = 'DG010313-02' 2025-03-01 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270069',`firm_id` = '8',`ordernumber` = 'S25020109218', `product_name` = '金8結雙蜜禮盒',`product_code` = 'DG010313-02',`product_sn` = 'DG010313',`product_spec` = '芝麻蛋捲+醇蜜2瓶',`invoice_name` = '禮盒-金8結【芝麻+雙蜜】',`listprice` = '755',`sellingprice` = '755',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '755.0',`amount` = '2',`total_price` = '1510',`etd` = '2025-02-21',`create_date` = '2025-02-25 16:41:25',`modify_date` = '2025-03-01 19:20:07',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-01-28'where ordernumber = 'S25020109218' and product_code = 'DG010313-02' 2025-03-01 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030000193' and product_code = '13660' 2025-03-01 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,'270488','8','O25030000193','8結蛋捲【紅提袋裝】','13660','13656','40入巧克力蛋捲','組合-40入巧克力+紅提袋','290','290','0','0','0','0','1','0.0','1','290','2025-03-03','2025-03-01 00:15:50','2025-03-01 23:59:06',null,'1','2025-02-02') 2025-03-01 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270488',`firm_id` = '8',`ordernumber` = 'O25030000193', `product_name` = '8結蛋捲【紅提袋裝】',`product_code` = '13660',`product_sn` = '13656',`product_spec` = '40入巧克力蛋捲',`invoice_name` = '組合-40入巧克力+紅提袋',`listprice` = '290',`sellingprice` = '290',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '290',`etd` = '2025-03-03',`create_date` = '2025-03-01 00:15:50',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030000193' and product_code = '13660' 2025-03-01 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030000283' and product_code = '13660' 2025-03-01 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,'270489','8','O25030000283','8結蛋捲【紅提袋裝】','13660','13656','40入巧克力蛋捲','組合-40入巧克力+紅提袋','290','290','0','0','0','0','1','0.0','1','290','2025-03-03','2025-03-01 00:18:48','2025-03-01 23:59:06',null,'1','2025-02-02') 2025-03-01 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270489',`firm_id` = '8',`ordernumber` = 'O25030000283', `product_name` = '8結蛋捲【紅提袋裝】',`product_code` = '13660',`product_sn` = '13656',`product_spec` = '40入巧克力蛋捲',`invoice_name` = '組合-40入巧克力+紅提袋',`listprice` = '290',`sellingprice` = '290',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '290',`etd` = '2025-03-03',`create_date` = '2025-03-01 00:18:48',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030000283' and product_code = '13660' 2025-03-01 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030000391' and product_code = '13656' 2025-03-01 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,'270490','8','O25030000391','8結蛋捲【紅提袋裝】','13656','13656','40入原味蛋捲','組合-40入原味+紅提袋','290','290','0','0','0','0','1','0.0','7','2030','2025-03-03','2025-03-01 03:05:50','2025-03-01 23:59:06',null,'1','2025-02-02') 2025-03-01 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270490',`firm_id` = '8',`ordernumber` = 'O25030000391', `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` = '7',`total_price` = '2030',`etd` = '2025-03-03',`create_date` = '2025-03-01 03:05:50',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030000391' and product_code = '13656' 2025-03-01 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030000439' and product_code = 'DG010101-01' 2025-03-01 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,'270491','8','O25030000439','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','2','560','2025-03-03','2025-03-01 03:26:01','2025-03-01 23:59:06',null,'1','2025-02-02') 2025-03-01 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270491',`firm_id` = '8',`ordernumber` = 'O25030000439', `product_name` = '經典原味蛋捲',`product_code` = 'DG010101-01',`product_sn` = 'DG010101',`product_spec` = '原味',`invoice_name` = '40入原味蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '2',`total_price` = '560',`etd` = '2025-03-03',`create_date` = '2025-03-01 03:26:01',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030000439' and product_code = 'DG010101-01' 2025-03-01 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030000439' and product_code = 'DG010101-02' 2025-03-01 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,'270491','8','O25030000439','香醇芝麻蛋捲','DG010101-02','DG010101','芝麻','40入芝麻蛋捲','320','280','0','0','0','0','1','280.0','1','280','2025-03-03','2025-03-01 03:26:01','2025-03-01 23:59:06',null,'1','2025-02-02') 2025-03-01 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270491',`firm_id` = '8',`ordernumber` = 'O25030000439', `product_name` = '香醇芝麻蛋捲',`product_code` = 'DG010101-02',`product_sn` = 'DG010101',`product_spec` = '芝麻',`invoice_name` = '40入芝麻蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2025-03-03',`create_date` = '2025-03-01 03:26:01',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030000439' and product_code = 'DG010101-02' 2025-03-01 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030000558' and product_code = 'DG010101-01' 2025-03-01 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,'270492','8','O25030000558','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','2','560','2025-03-03','2025-03-01 04:09:07','2025-03-01 23:59:06',null,'1','2025-02-02') 2025-03-01 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270492',`firm_id` = '8',`ordernumber` = 'O25030000558', `product_name` = '經典原味蛋捲',`product_code` = 'DG010101-01',`product_sn` = 'DG010101',`product_spec` = '原味',`invoice_name` = '40入原味蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '2',`total_price` = '560',`etd` = '2025-03-03',`create_date` = '2025-03-01 04:09:07',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030000558' and product_code = 'DG010101-01' 2025-03-01 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030000558' and product_code = 'DG010101-02' 2025-03-01 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,'270492','8','O25030000558','香醇芝麻蛋捲','DG010101-02','DG010101','芝麻','40入芝麻蛋捲','320','280','0','0','0','0','1','280.0','2','560','2025-03-03','2025-03-01 04:09:07','2025-03-01 23:59:06',null,'1','2025-02-02') 2025-03-01 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270492',`firm_id` = '8',`ordernumber` = 'O25030000558', `product_name` = '香醇芝麻蛋捲',`product_code` = 'DG010101-02',`product_sn` = 'DG010101',`product_spec` = '芝麻',`invoice_name` = '40入芝麻蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '2',`total_price` = '560',`etd` = '2025-03-03',`create_date` = '2025-03-01 04:09:07',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030000558' and product_code = 'DG010101-02' 2025-03-01 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030000558' and product_code = 'DG010101-03' 2025-03-01 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,'270492','8','O25030000558','極上咖啡蛋捲','DG010101-03','DG010101','咖啡','40入咖啡蛋捲','320','280','0','0','0','0','1','280.0','2','560','2025-03-03','2025-03-01 04:09:07','2025-03-01 23:59:06',null,'1','2025-02-02') 2025-03-01 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270492',`firm_id` = '8',`ordernumber` = 'O25030000558', `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` = '2025-03-03',`create_date` = '2025-03-01 04:09:07',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030000558' and product_code = 'DG010101-03' 2025-03-01 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030000656' and product_code = 'DG010144-01' 2025-03-01 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,'270493','8','O25030000656','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','7','1960','2025-03-03','2025-03-01 07:16:28','2025-03-01 23:59:06',null,'1','2025-02-02') 2025-03-01 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270493',`firm_id` = '8',`ordernumber` = 'O25030000656', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '7',`total_price` = '1960',`etd` = '2025-03-03',`create_date` = '2025-03-01 07:16:28',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030000656' and product_code = 'DG010144-01' 2025-03-01 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030000656' and product_code = 'DG010143-01' 2025-03-01 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,'270493','8','O25030000656','可可烤布蕾蛋捲','DG010143-01','DG010143','32入可可烤布蕾蛋捲','32入可可烤布蕾蛋捲','240','240','0','0','0','0','1','0.0','4','960','2025-03-03','2025-03-01 07:16:28','2025-03-01 23:59:06',null,'1','2025-02-02') 2025-03-01 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270493',`firm_id` = '8',`ordernumber` = 'O25030000656', `product_name` = '可可烤布蕾蛋捲',`product_code` = 'DG010143-01',`product_sn` = 'DG010143',`product_spec` = '32入可可烤布蕾蛋捲',`invoice_name` = '32入可可烤布蕾蛋捲',`listprice` = '240',`sellingprice` = '240',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '4',`total_price` = '960',`etd` = '2025-03-03',`create_date` = '2025-03-01 07:16:28',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030000656' and product_code = 'DG010143-01' 2025-03-01 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030000656' and product_code = 'DG010101-01' 2025-03-01 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,'270493','8','O25030000656','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','2','560','2025-03-03','2025-03-01 07:16:28','2025-03-01 23:59:06',null,'1','2025-02-02') 2025-03-01 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270493',`firm_id` = '8',`ordernumber` = 'O25030000656', `product_name` = '經典原味蛋捲',`product_code` = 'DG010101-01',`product_sn` = 'DG010101',`product_spec` = '原味',`invoice_name` = '40入原味蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '2',`total_price` = '560',`etd` = '2025-03-03',`create_date` = '2025-03-01 07:16:28',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030000656' and product_code = 'DG010101-01' 2025-03-01 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030000656' and product_code = 'DG010101-02' 2025-03-01 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,'270493','8','O25030000656','香醇芝麻蛋捲','DG010101-02','DG010101','芝麻','40入芝麻蛋捲','320','280','0','0','0','0','1','280.0','1','280','2025-03-03','2025-03-01 07:16:28','2025-03-01 23:59:06',null,'1','2025-02-02') 2025-03-01 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270493',`firm_id` = '8',`ordernumber` = 'O25030000656', `product_name` = '香醇芝麻蛋捲',`product_code` = 'DG010101-02',`product_sn` = 'DG010101',`product_spec` = '芝麻',`invoice_name` = '40入芝麻蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2025-03-03',`create_date` = '2025-03-01 07:16:28',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030000656' and product_code = 'DG010101-02' 2025-03-01 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030000656' and product_code = 'DG010101-03' 2025-03-01 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,'270493','8','O25030000656','極上咖啡蛋捲','DG010101-03','DG010101','咖啡','40入咖啡蛋捲','320','280','0','0','0','0','1','280.0','8','2240','2025-03-03','2025-03-01 07:16:28','2025-03-01 23:59:06',null,'1','2025-02-02') 2025-03-01 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270493',`firm_id` = '8',`ordernumber` = 'O25030000656', `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` = '8',`total_price` = '2240',`etd` = '2025-03-03',`create_date` = '2025-03-01 07:16:28',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030000656' and product_code = 'DG010101-03' 2025-03-01 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030000656' and product_code = 'DG010101-05' 2025-03-01 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,'270493','8','O25030000656','濃情巧克力蛋捲','DG010101-05','DG010101','巧克力','40入巧克力蛋捲','320','280','0','0','0','0','1','280.0','5','1400','2025-03-03','2025-03-01 07:16:28','2025-03-01 23:59:06',null,'1','2025-02-02') 2025-03-01 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270493',`firm_id` = '8',`ordernumber` = 'O25030000656', `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` = '2025-03-03',`create_date` = '2025-03-01 07:16:28',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030000656' and product_code = 'DG010101-05' 2025-03-01 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030000656' and product_code = 'DG010101-04' 2025-03-01 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,'270493','8','O25030000656','日式海苔蛋捲','DG010101-04','DG010101','單盒','40入海苔蛋捲','320','280','0','0','0','0','1','280.0','1','280','2025-03-03','2025-03-01 07:16:28','2025-03-01 23:59:06',null,'1','2025-02-02') 2025-03-01 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270493',`firm_id` = '8',`ordernumber` = 'O25030000656', `product_name` = '日式海苔蛋捲',`product_code` = 'DG010101-04',`product_sn` = 'DG010101',`product_spec` = '單盒',`invoice_name` = '40入海苔蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2025-03-03',`create_date` = '2025-03-01 07:16:28',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030000656' and product_code = 'DG010101-04' 2025-03-01 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030000723' and product_code = 'DG0105162-20' 2025-03-01 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,'270494','8','O25030000723','【抹茶季限定】一抹風雅帆布袋-蛋捲三入組','DG0105162-20','DG0105162','原味,巧克力,抹茶','組合-32入(原味+巧克力+抹茶)+抹茶季限定帆布袋','1030','1030','0','0','0','1','1','0.0','1','1030','2025-03-04','2025-03-01 09:14:49','2025-03-01 23:59:06',null,'1','2025-02-02') 2025-03-01 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270494',`firm_id` = '8',`ordernumber` = 'O25030000723', `product_name` = '【抹茶季限定】一抹風雅帆布袋-蛋捲三入組',`product_code` = 'DG0105162-20',`product_sn` = 'DG0105162',`product_spec` = '原味,巧克力,抹茶',`invoice_name` = '組合-32入(原味+巧克力+抹茶)+抹茶季限定帆布袋',`listprice` = '1030',`sellingprice` = '1030',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1030',`etd` = '2025-03-04',`create_date` = '2025-03-01 09:14:49',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030000723' and product_code = 'DG0105162-20' 2025-03-01 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030000882' and product_code = 'DG010143-01' 2025-03-01 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,'270495','8','O25030000882','可可烤布蕾蛋捲','DG010143-01','DG010143','32入可可烤布蕾蛋捲','32入可可烤布蕾蛋捲','240','240','0','0','0','0','1','0.0','2','480','2025-03-03','2025-03-01 10:43:07','2025-03-01 23:59:06',null,'1','2025-02-02') 2025-03-01 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270495',`firm_id` = '8',`ordernumber` = 'O25030000882', `product_name` = '可可烤布蕾蛋捲',`product_code` = 'DG010143-01',`product_sn` = 'DG010143',`product_spec` = '32入可可烤布蕾蛋捲',`invoice_name` = '32入可可烤布蕾蛋捲',`listprice` = '240',`sellingprice` = '240',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '480',`etd` = '2025-03-03',`create_date` = '2025-03-01 10:43:07',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030000882' and product_code = 'DG010143-01' 2025-03-01 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030000915' and product_code = 'DG010258-01' 2025-03-01 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,'270496','8','O25030000915','金豐收8結提盒','DG010258-01','DG010258','40入原味蛋捲','提盒-金豐收(藍)-40入原味','295','295','0','0','0','0','1','0.0','2','590','2025-03-03','2025-03-01 10:50:53','2025-03-01 23:59:06',null,'1','2025-02-02') 2025-03-01 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270496',`firm_id` = '8',`ordernumber` = 'O25030000915', `product_name` = '金豐收8結提盒',`product_code` = 'DG010258-01',`product_sn` = 'DG010258',`product_spec` = '40入原味蛋捲',`invoice_name` = '提盒-金豐收(藍)-40入原味',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '590',`etd` = '2025-03-03',`create_date` = '2025-03-01 10:50:53',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030000915' and product_code = 'DG010258-01' 2025-03-01 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030000915' and product_code = 'DG010258-02' 2025-03-01 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,'270496','8','O25030000915','金豐收8結提盒','DG010258-02','DG010258','40入芝麻蛋捲','提盒-金豐收(藍)-40入芝麻','295','295','0','0','0','0','1','0.0','1','295','2025-03-03','2025-03-01 10:50:53','2025-03-01 23:59:06',null,'1','2025-02-02') 2025-03-01 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270496',`firm_id` = '8',`ordernumber` = 'O25030000915', `product_name` = '金豐收8結提盒',`product_code` = 'DG010258-02',`product_sn` = 'DG010258',`product_spec` = '40入芝麻蛋捲',`invoice_name` = '提盒-金豐收(藍)-40入芝麻',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '295',`etd` = '2025-03-03',`create_date` = '2025-03-01 10:50:53',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030000915' and product_code = 'DG010258-02' 2025-03-01 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030001013' and product_code = 'DG010143-01' 2025-03-01 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,'270497','8','O25030001013','可可烤布蕾蛋捲','DG010143-01','DG010143','32入可可烤布蕾蛋捲','32入可可烤布蕾蛋捲','240','240','0','0','0','0','1','0.0','1','240','2025-03-04','2025-03-01 11:10:24','2025-03-01 23:59:06',null,'1','2025-02-02') 2025-03-01 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270497',`firm_id` = '8',`ordernumber` = 'O25030001013', `product_name` = '可可烤布蕾蛋捲',`product_code` = 'DG010143-01',`product_sn` = 'DG010143',`product_spec` = '32入可可烤布蕾蛋捲',`invoice_name` = '32入可可烤布蕾蛋捲',`listprice` = '240',`sellingprice` = '240',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '240',`etd` = '2025-03-04',`create_date` = '2025-03-01 11:10:24',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030001013' and product_code = 'DG010143-01' 2025-03-01 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030001182' and product_code = 'DG010144-01' 2025-03-01 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,'270498','8','O25030001182','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','2','560','2025-03-05','2025-03-01 11:54:56','2025-03-01 23:59:06',null,'1','2025-02-02') 2025-03-01 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270498',`firm_id` = '8',`ordernumber` = 'O25030001182', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '560',`etd` = '2025-03-05',`create_date` = '2025-03-01 11:54:56',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030001182' and product_code = 'DG010144-01' 2025-03-01 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030001287' and product_code = 'DG0105162-46' 2025-03-01 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,'270499','8','O25030001287','【抹茶季限定】一抹風雅帆布袋-蛋捲三入組','DG0105162-46','DG0105162','咖啡,抹茶,抹茶','組合-32入(咖啡+抹茶+抹茶)+抹茶季限定帆布袋','1070','1070','0','0','0','1','1','0.0','1','1070','2025-03-13','2025-03-01 12:10:59','2025-03-01 23:59:06',null,'1','2025-02-02') 2025-03-01 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270499',`firm_id` = '8',`ordernumber` = 'O25030001287', `product_name` = '【抹茶季限定】一抹風雅帆布袋-蛋捲三入組',`product_code` = 'DG0105162-46',`product_sn` = 'DG0105162',`product_spec` = '咖啡,抹茶,抹茶',`invoice_name` = '組合-32入(咖啡+抹茶+抹茶)+抹茶季限定帆布袋',`listprice` = '1070',`sellingprice` = '1070',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1070',`etd` = '2025-03-13',`create_date` = '2025-03-01 12:10:59',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030001287' and product_code = 'DG0105162-46' 2025-03-01 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030001321' and product_code = 'DG010143-01' 2025-03-01 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,'270500','8','O25030001321','可可烤布蕾蛋捲','DG010143-01','DG010143','32入可可烤布蕾蛋捲','32入可可烤布蕾蛋捲','240','240','0','0','0','0','1','0.0','1','240','2025-03-03','2025-03-01 14:43:02','2025-03-01 23:59:06',null,'1','2025-02-02') 2025-03-01 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270500',`firm_id` = '8',`ordernumber` = 'O25030001321', `product_name` = '可可烤布蕾蛋捲',`product_code` = 'DG010143-01',`product_sn` = 'DG010143',`product_spec` = '32入可可烤布蕾蛋捲',`invoice_name` = '32入可可烤布蕾蛋捲',`listprice` = '240',`sellingprice` = '240',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '240',`etd` = '2025-03-03',`create_date` = '2025-03-01 14:43:02',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030001321' and product_code = 'DG010143-01' 2025-03-01 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030001321' and product_code = 'DG010144-01' 2025-03-01 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,'270500','8','O25030001321','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','1','280','2025-03-03','2025-03-01 14:43:02','2025-03-01 23:59:06',null,'1','2025-02-02') 2025-03-01 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270500',`firm_id` = '8',`ordernumber` = 'O25030001321', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '280',`etd` = '2025-03-03',`create_date` = '2025-03-01 14:43:02',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030001321' and product_code = 'DG010144-01' 2025-03-01 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030001321' and product_code = 'DG010101-05' 2025-03-01 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,'270500','8','O25030001321','濃情巧克力蛋捲','DG010101-05','DG010101','巧克力','40入巧克力蛋捲','320','280','0','0','0','0','1','280.0','1','280','2025-03-03','2025-03-01 14:43:02','2025-03-01 23:59:06',null,'1','2025-02-02') 2025-03-01 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270500',`firm_id` = '8',`ordernumber` = 'O25030001321', `product_name` = '濃情巧克力蛋捲',`product_code` = 'DG010101-05',`product_sn` = 'DG010101',`product_spec` = '巧克力',`invoice_name` = '40入巧克力蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2025-03-03',`create_date` = '2025-03-01 14:43:02',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030001321' and product_code = 'DG010101-05' 2025-03-01 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030001498' and product_code = 'DG010312-05' 2025-03-01 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,'270501','8','O25030001498','【原味+巧克力】金8結禮盒','DG010312-05','DG010312','金8結盒','禮盒-金8結【原味+巧克力】','590','480','0','0','0','0','1','480.0','1','480','2025-03-03','2025-03-01 14:50:30','2025-03-01 23:59:06',null,'1','2025-02-02') 2025-03-01 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270501',`firm_id` = '8',`ordernumber` = 'O25030001498', `product_name` = '【原味+巧克力】金8結禮盒',`product_code` = 'DG010312-05',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+巧克力】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2025-03-03',`create_date` = '2025-03-01 14:50:30',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030001498' and product_code = 'DG010312-05' 2025-03-01 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030001535' and product_code = 'DG010144-01' 2025-03-01 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,'270502','8','O25030001535','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','3','840','2025-03-03','2025-03-01 15:05:29','2025-03-01 23:59:06',null,'1','2025-02-02') 2025-03-01 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270502',`firm_id` = '8',`ordernumber` = 'O25030001535', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '3',`total_price` = '840',`etd` = '2025-03-03',`create_date` = '2025-03-01 15:05:29',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030001535' and product_code = 'DG010144-01' 2025-03-01 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030001624' and product_code = 'DG0105162-56' 2025-03-01 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,'270503','8','O25030001624','【抹茶季限定】一抹風雅帆布袋-蛋捲三入組','DG0105162-56','DG0105162','抹茶,抹茶,抹茶','組合-32入(抹茶+抹茶+抹茶)+抹茶季限定帆布袋','1110','1110','0','0','0','1','1','0.0','1','1110','2025-03-07','2025-03-01 16:21:39','2025-03-01 23:59:06',null,'1','2025-02-02') 2025-03-01 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270503',`firm_id` = '8',`ordernumber` = 'O25030001624', `product_name` = '【抹茶季限定】一抹風雅帆布袋-蛋捲三入組',`product_code` = 'DG0105162-56',`product_sn` = 'DG0105162',`product_spec` = '抹茶,抹茶,抹茶',`invoice_name` = '組合-32入(抹茶+抹茶+抹茶)+抹茶季限定帆布袋',`listprice` = '1110',`sellingprice` = '1110',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1110',`etd` = '2025-03-07',`create_date` = '2025-03-01 16:21:39',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030001624' and product_code = 'DG0105162-56' 2025-03-01 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030001773' and product_code = 'DG0105162-56' 2025-03-01 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,'270504','8','O25030001773','【抹茶季限定】一抹風雅帆布袋-蛋捲三入組','DG0105162-56','DG0105162','抹茶,抹茶,抹茶','組合-32入(抹茶+抹茶+抹茶)+抹茶季限定帆布袋','1110','1110','0','0','0','1','1','0.0','1','1110','2025-03-25','2025-03-01 17:56:01','2025-03-01 23:59:06',null,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270504',`firm_id` = '8',`ordernumber` = 'O25030001773', `product_name` = '【抹茶季限定】一抹風雅帆布袋-蛋捲三入組',`product_code` = 'DG0105162-56',`product_sn` = 'DG0105162',`product_spec` = '抹茶,抹茶,抹茶',`invoice_name` = '組合-32入(抹茶+抹茶+抹茶)+抹茶季限定帆布袋',`listprice` = '1110',`sellingprice` = '1110',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1110',`etd` = '2025-03-25',`create_date` = '2025-03-01 17:56:01',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030001773' and product_code = 'DG0105162-56' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030001773' and product_code = 'DG0105162-54' 2025-03-01 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,'270504','8','O25030001773','【抹茶季限定】一抹風雅帆布袋-蛋捲三入組','DG0105162-54','DG0105162','巧克力,巧克力,抹茶','組合-32入(巧克力+巧克力+抹茶)+抹茶季限定帆布袋','1030','1030','0','0','0','1','1','0.0','1','1030','2025-03-25','2025-03-01 17:56:01','2025-03-01 23:59:07',null,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270504',`firm_id` = '8',`ordernumber` = 'O25030001773', `product_name` = '【抹茶季限定】一抹風雅帆布袋-蛋捲三入組',`product_code` = 'DG0105162-54',`product_sn` = 'DG0105162',`product_spec` = '巧克力,巧克力,抹茶',`invoice_name` = '組合-32入(巧克力+巧克力+抹茶)+抹茶季限定帆布袋',`listprice` = '1030',`sellingprice` = '1030',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1030',`etd` = '2025-03-25',`create_date` = '2025-03-01 17:56:01',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030001773' and product_code = 'DG0105162-54' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030001893' and product_code = 'DG010144-01' 2025-03-01 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,'270505','8','O25030001893','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','2','560','2025-03-03','2025-03-01 18:20:16','2025-03-01 23:59:07',null,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270505',`firm_id` = '8',`ordernumber` = 'O25030001893', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '560',`etd` = '2025-03-03',`create_date` = '2025-03-01 18:20:16',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030001893' and product_code = 'DG010144-01' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S25030001932' and product_code = 'DG010101-01' 2025-03-01 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,'270506','8','S25030001932','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','4','1120','2025-03-01','2025-03-01 18:51:16','2025-03-01 23:59:07',0,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270506',`firm_id` = '8',`ordernumber` = 'S25030001932', `product_name` = '經典原味蛋捲',`product_code` = 'DG010101-01',`product_sn` = 'DG010101',`product_spec` = '原味',`invoice_name` = '40入原味蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '4',`total_price` = '1120',`etd` = '2025-03-01',`create_date` = '2025-03-01 18:51:16',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'S25030001932' and product_code = 'DG010101-01' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S25030001932' and product_code = 'DG010101-02' 2025-03-01 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,'270506','8','S25030001932','香醇芝麻蛋捲','DG010101-02','DG010101','芝麻','40入芝麻蛋捲','320','280','0','0','0','0','1','280.0','1','280','2025-03-01','2025-03-01 18:51:16','2025-03-01 23:59:07',0,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270506',`firm_id` = '8',`ordernumber` = 'S25030001932', `product_name` = '香醇芝麻蛋捲',`product_code` = 'DG010101-02',`product_sn` = 'DG010101',`product_spec` = '芝麻',`invoice_name` = '40入芝麻蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2025-03-01',`create_date` = '2025-03-01 18:51:16',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'S25030001932' and product_code = 'DG010101-02' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S25030001932' and product_code = 'DG010101-04' 2025-03-01 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,'270506','8','S25030001932','日式海苔蛋捲','DG010101-04','DG010101','單盒','40入海苔蛋捲','320','280','0','0','0','0','1','280.0','1','280','2025-03-01','2025-03-01 18:51:16','2025-03-01 23:59:07',0,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270506',`firm_id` = '8',`ordernumber` = 'S25030001932', `product_name` = '日式海苔蛋捲',`product_code` = 'DG010101-04',`product_sn` = 'DG010101',`product_spec` = '單盒',`invoice_name` = '40入海苔蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2025-03-01',`create_date` = '2025-03-01 18:51:16',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'S25030001932' and product_code = 'DG010101-04' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S25030001932' and product_code = 'DG010113-02' 2025-03-01 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,'270506','8','S25030001932','芝麻小盒','DG010113-02','DG010113','芝麻','32入芝麻','225','225','0','0','0','0','1','0.0','2','450','2025-03-01','2025-03-01 18:51:16','2025-03-01 23:59:07',0,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270506',`firm_id` = '8',`ordernumber` = 'S25030001932', `product_name` = '芝麻小盒',`product_code` = 'DG010113-02',`product_sn` = 'DG010113',`product_spec` = '芝麻',`invoice_name` = '32入芝麻',`listprice` = '225',`sellingprice` = '225',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '450',`etd` = '2025-03-01',`create_date` = '2025-03-01 18:51:16',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'S25030001932' and product_code = 'DG010113-02' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S25030001932' and product_code = 'DG010113-03' 2025-03-01 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,'270506','8','S25030001932','咖啡小盒','DG010113-03','DG010113','咖啡','32入咖啡','225','225','0','0','0','0','1','0.0','1','225','2025-03-01','2025-03-01 18:51:16','2025-03-01 23:59:07',0,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270506',`firm_id` = '8',`ordernumber` = 'S25030001932', `product_name` = '咖啡小盒',`product_code` = 'DG010113-03',`product_sn` = 'DG010113',`product_spec` = '咖啡',`invoice_name` = '32入咖啡',`listprice` = '225',`sellingprice` = '225',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '225',`etd` = '2025-03-01',`create_date` = '2025-03-01 18:51:16',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'S25030001932' and product_code = 'DG010113-03' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S25030001932' and product_code = 'DG010113-04' 2025-03-01 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,'270506','8','S25030001932','海苔小盒','DG010113-04','DG010113','海苔','32入海苔','225','225','0','0','0','0','1','0.0','1','225','2025-03-01','2025-03-01 18:51:16','2025-03-01 23:59:07',0,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270506',`firm_id` = '8',`ordernumber` = 'S25030001932', `product_name` = '海苔小盒',`product_code` = 'DG010113-04',`product_sn` = 'DG010113',`product_spec` = '海苔',`invoice_name` = '32入海苔',`listprice` = '225',`sellingprice` = '225',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '225',`etd` = '2025-03-01',`create_date` = '2025-03-01 18:51:16',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'S25030001932' and product_code = 'DG010113-04' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S25030001932' and product_code = 'DG010144-01' 2025-03-01 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,'270506','8','S25030001932','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','1','280','2025-03-01','2025-03-01 18:51:16','2025-03-01 23:59:07',0,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270506',`firm_id` = '8',`ordernumber` = 'S25030001932', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '280',`etd` = '2025-03-01',`create_date` = '2025-03-01 18:51:16',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'S25030001932' and product_code = 'DG010144-01' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S25030001932' and product_code = 'DG010143-01' 2025-03-01 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,'270506','8','S25030001932','可可烤布蕾蛋捲','DG010143-01','DG010143','32入可可烤布蕾蛋捲','32入可可烤布蕾蛋捲','240','240','0','0','0','0','1','0.0','2','480','2025-03-01','2025-03-01 18:51:16','2025-03-01 23:59:07',0,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270506',`firm_id` = '8',`ordernumber` = 'S25030001932', `product_name` = '可可烤布蕾蛋捲',`product_code` = 'DG010143-01',`product_sn` = 'DG010143',`product_spec` = '32入可可烤布蕾蛋捲',`invoice_name` = '32入可可烤布蕾蛋捲',`listprice` = '240',`sellingprice` = '240',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '480',`etd` = '2025-03-01',`create_date` = '2025-03-01 18:51:16',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'S25030001932' and product_code = 'DG010143-01' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S25030002090' and product_code = '13656' 2025-03-01 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,'270507','8','S25030002090','8結蛋捲【紅提袋裝】','13656','13656','40入原味蛋捲','組合-40入原味+紅提袋','290','290','0','0','0','0','1','0.0','30','8700','2025-03-02','2025-03-01 20:06:34','2025-03-01 23:59:07',0,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270507',`firm_id` = '8',`ordernumber` = 'S25030002090', `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` = '30',`total_price` = '8700',`etd` = '2025-03-02',`create_date` = '2025-03-01 20:06:34',`modify_date` = '2025-03-01 20:08:34',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'S25030002090' and product_code = '13656' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030002186' and product_code = 'DG010144-01' 2025-03-01 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,'270508','8','O25030002186','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','3','840','2025-03-03','2025-03-01 20:06:51','2025-03-01 23:59:07',null,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270508',`firm_id` = '8',`ordernumber` = 'O25030002186', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '3',`total_price` = '840',`etd` = '2025-03-03',`create_date` = '2025-03-01 20:06:51',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030002186' and product_code = 'DG010144-01' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030002186' and product_code = 'DG010143-01' 2025-03-01 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,'270508','8','O25030002186','可可烤布蕾蛋捲','DG010143-01','DG010143','32入可可烤布蕾蛋捲','32入可可烤布蕾蛋捲','240','240','0','0','0','0','1','0.0','2','480','2025-03-03','2025-03-01 20:06:51','2025-03-01 23:59:07',null,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270508',`firm_id` = '8',`ordernumber` = 'O25030002186', `product_name` = '可可烤布蕾蛋捲',`product_code` = 'DG010143-01',`product_sn` = 'DG010143',`product_spec` = '32入可可烤布蕾蛋捲',`invoice_name` = '32入可可烤布蕾蛋捲',`listprice` = '240',`sellingprice` = '240',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '480',`etd` = '2025-03-03',`create_date` = '2025-03-01 20:06:51',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030002186' and product_code = 'DG010143-01' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030002288' and product_code = 'DG010312-03' 2025-03-01 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,'270509','8','O25030002288','【原味+咖啡】金8結禮盒','DG010312-03','DG010312','金8結盒','禮盒-金8結【原味+咖啡】','590','480','0','0','0','0','1','480.0','1','480','2025-03-03','2025-03-01 20:41:03','2025-03-01 23:59:07',null,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270509',`firm_id` = '8',`ordernumber` = 'O25030002288', `product_name` = '【原味+咖啡】金8結禮盒',`product_code` = 'DG010312-03',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+咖啡】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2025-03-03',`create_date` = '2025-03-01 20:41:03',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030002288' and product_code = 'DG010312-03' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030002288' and product_code = 'DG010312-07' 2025-03-01 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,'270509','8','O25030002288','【芝麻+咖啡】金8結禮盒','DG010312-07','DG010312','金8結盒','禮盒-金8結【芝麻+咖啡】','590','480','0','0','0','0','1','480.0','1','480','2025-03-03','2025-03-01 20:41:03','2025-03-01 23:59:07',null,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270509',`firm_id` = '8',`ordernumber` = 'O25030002288', `product_name` = '【芝麻+咖啡】金8結禮盒',`product_code` = 'DG010312-07',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【芝麻+咖啡】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2025-03-03',`create_date` = '2025-03-01 20:41:03',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030002288' and product_code = 'DG010312-07' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030002391' and product_code = 'DG010258-01' 2025-03-01 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,'270510','8','O25030002391','金豐收8結提盒','DG010258-01','DG010258','40入原味蛋捲','提盒-金豐收(藍)-40入原味','295','295','0','0','0','0','1','0.0','3','885','2025-03-03','2025-03-01 20:47:39','2025-03-01 23:59:07',null,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270510',`firm_id` = '8',`ordernumber` = 'O25030002391', `product_name` = '金豐收8結提盒',`product_code` = 'DG010258-01',`product_sn` = 'DG010258',`product_spec` = '40入原味蛋捲',`invoice_name` = '提盒-金豐收(藍)-40入原味',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '3',`total_price` = '885',`etd` = '2025-03-03',`create_date` = '2025-03-01 20:47:39',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030002391' and product_code = 'DG010258-01' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030002391' and product_code = 'DG010258-02' 2025-03-01 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,'270510','8','O25030002391','金豐收8結提盒','DG010258-02','DG010258','40入芝麻蛋捲','提盒-金豐收(藍)-40入芝麻','295','295','0','0','0','0','1','0.0','3','885','2025-03-03','2025-03-01 20:47:39','2025-03-01 23:59:07',null,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270510',`firm_id` = '8',`ordernumber` = 'O25030002391', `product_name` = '金豐收8結提盒',`product_code` = 'DG010258-02',`product_sn` = 'DG010258',`product_spec` = '40入芝麻蛋捲',`invoice_name` = '提盒-金豐收(藍)-40入芝麻',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '3',`total_price` = '885',`etd` = '2025-03-03',`create_date` = '2025-03-01 20:47:39',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030002391' and product_code = 'DG010258-02' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030002417' and product_code = 'DG0103148-12' 2025-03-01 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,'270511','8','O25030002417','金典8結禮盒','DG0103148-12','DG0103148','巧克力+咖啡','禮盒-金典(紅)【咖啡+巧克力】','480','480','0','0','0','0','1','0.0','1','480','2025-03-04','2025-03-01 22:09:28','2025-03-01 23:59:07',null,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270511',`firm_id` = '8',`ordernumber` = 'O25030002417', `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` = '2025-03-04',`create_date` = '2025-03-01 22:09:28',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030002417' and product_code = 'DG0103148-12' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030002417' and product_code = 'DG0103148-03' 2025-03-01 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,'270511','8','O25030002417','金典8結禮盒','DG0103148-03','DG0103148','原味+咖啡','禮盒-金典(紅)【原味+咖啡】','480','480','0','0','0','0','1','0.0','1','480','2025-03-04','2025-03-01 22:09:28','2025-03-01 23:59:07',null,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270511',`firm_id` = '8',`ordernumber` = 'O25030002417', `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` = '2025-03-04',`create_date` = '2025-03-01 22:09:28',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030002417' and product_code = 'DG0103148-03' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030002417' and product_code = 'DG0103244-01' 2025-03-01 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,'270511','8','O25030002417','金典8結禮盒-京都宇治抹茶','DG0103244-01','DG0103244','原味+京都宇治抹茶','禮盒-金典(紅)【原味+京都宇治抹茶】','520','520','0','0','0','0','1','0.0','1','520','2025-03-04','2025-03-01 22:09:28','2025-03-01 23:59:07',null,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270511',`firm_id` = '8',`ordernumber` = 'O25030002417', `product_name` = '金典8結禮盒-京都宇治抹茶',`product_code` = 'DG0103244-01',`product_sn` = 'DG0103244',`product_spec` = '原味+京都宇治抹茶',`invoice_name` = '禮盒-金典(紅)【原味+京都宇治抹茶】',`listprice` = '520',`sellingprice` = '520',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '520',`etd` = '2025-03-04',`create_date` = '2025-03-01 22:09:28',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030002417' and product_code = 'DG0103244-01' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030002417' and product_code = 'DG010144-01' 2025-03-01 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,'270511','8','O25030002417','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','1','280','2025-03-04','2025-03-01 22:09:28','2025-03-01 23:59:07',null,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270511',`firm_id` = '8',`ordernumber` = 'O25030002417', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '280',`etd` = '2025-03-04',`create_date` = '2025-03-01 22:09:28',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030002417' and product_code = 'DG010144-01' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030002417' and product_code = 'DG010143-01' 2025-03-01 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,'270511','8','O25030002417','可可烤布蕾蛋捲','DG010143-01','DG010143','32入可可烤布蕾蛋捲','32入可可烤布蕾蛋捲','240','240','0','0','0','0','1','0.0','1','240','2025-03-04','2025-03-01 22:09:28','2025-03-01 23:59:07',null,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270511',`firm_id` = '8',`ordernumber` = 'O25030002417', `product_name` = '可可烤布蕾蛋捲',`product_code` = 'DG010143-01',`product_sn` = 'DG010143',`product_spec` = '32入可可烤布蕾蛋捲',`invoice_name` = '32入可可烤布蕾蛋捲',`listprice` = '240',`sellingprice` = '240',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '240',`etd` = '2025-03-04',`create_date` = '2025-03-01 22:09:28',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030002417' and product_code = 'DG010143-01' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030002548' and product_code = 'DG0105162-11' 2025-03-01 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,'270512','8','O25030002548','【抹茶季限定】一抹風雅帆布袋-蛋捲三入組','DG0105162-11','DG0105162','原味,芝麻,抹茶','組合-32入(原味+芝麻+抹茶)+抹茶季限定帆布袋','1030','1030','0','0','0','1','1','0.0','1','1030','2025-03-03','2025-03-01 22:14:21','2025-03-01 23:59:07',null,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270512',`firm_id` = '8',`ordernumber` = 'O25030002548', `product_name` = '【抹茶季限定】一抹風雅帆布袋-蛋捲三入組',`product_code` = 'DG0105162-11',`product_sn` = 'DG0105162',`product_spec` = '原味,芝麻,抹茶',`invoice_name` = '組合-32入(原味+芝麻+抹茶)+抹茶季限定帆布袋',`listprice` = '1030',`sellingprice` = '1030',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1030',`etd` = '2025-03-03',`create_date` = '2025-03-01 22:14:21',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030002548' and product_code = 'DG0105162-11' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030002649' and product_code = 'DG0103234-01' 2025-03-01 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,'270513','8','O25030002649','金典8結禮盒-可可烤布蕾','DG0103234-01','DG0103227','可可烤布蕾+可可烤布蕾','禮盒-金典(紅)【可可烤布蕾+可可烤布蕾】','480','480','0','0','0','0','1','0.0','1','480','2025-03-10','2025-03-01 22:30:58','2025-03-01 23:59:07',null,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270513',`firm_id` = '8',`ordernumber` = 'O25030002649', `product_name` = '金典8結禮盒-可可烤布蕾',`product_code` = 'DG0103234-01',`product_sn` = 'DG0103227',`product_spec` = '可可烤布蕾+可可烤布蕾',`invoice_name` = '禮盒-金典(紅)【可可烤布蕾+可可烤布蕾】',`listprice` = '480',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '480',`etd` = '2025-03-10',`create_date` = '2025-03-01 22:30:58',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030002649' and product_code = 'DG0103234-01' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030002649' and product_code = 'DG0103245-01' 2025-03-01 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,'270513','8','O25030002649','金典8結禮盒-京都宇治抹茶','DG0103245-01','DG0103244','京都宇治抹茶抹茶+京都宇治抹茶','禮盒-金典(紅)【京都宇治抹茶+京都宇治抹茶】','560','560','0','0','0','0','1','0.0','2','1120','2025-03-10','2025-03-01 22:30:58','2025-03-01 23:59:07',null,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270513',`firm_id` = '8',`ordernumber` = 'O25030002649', `product_name` = '金典8結禮盒-京都宇治抹茶',`product_code` = 'DG0103245-01',`product_sn` = 'DG0103244',`product_spec` = '京都宇治抹茶抹茶+京都宇治抹茶',`invoice_name` = '禮盒-金典(紅)【京都宇治抹茶+京都宇治抹茶】',`listprice` = '560',`sellingprice` = '560',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '1120',`etd` = '2025-03-10',`create_date` = '2025-03-01 22:30:58',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030002649' and product_code = 'DG0103245-01' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030002782' and product_code = 'DG010144-01' 2025-03-01 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,'270514','8','O25030002782','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','2','560','2025-03-03','2025-03-01 22:33:04','2025-03-01 23:59:07',null,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270514',`firm_id` = '8',`ordernumber` = 'O25030002782', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '560',`etd` = '2025-03-03',`create_date` = '2025-03-01 22:33:04',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030002782' and product_code = 'DG010144-01' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030002782' and product_code = 'DG010143-01' 2025-03-01 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,'270514','8','O25030002782','可可烤布蕾蛋捲','DG010143-01','DG010143','32入可可烤布蕾蛋捲','32入可可烤布蕾蛋捲','240','240','0','0','0','0','1','0.0','2','480','2025-03-03','2025-03-01 22:33:04','2025-03-01 23:59:07',null,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270514',`firm_id` = '8',`ordernumber` = 'O25030002782', `product_name` = '可可烤布蕾蛋捲',`product_code` = 'DG010143-01',`product_sn` = 'DG010143',`product_spec` = '32入可可烤布蕾蛋捲',`invoice_name` = '32入可可烤布蕾蛋捲',`listprice` = '240',`sellingprice` = '240',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '480',`etd` = '2025-03-03',`create_date` = '2025-03-01 22:33:04',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030002782' and product_code = 'DG010143-01' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030002861' and product_code = 'DG0103188-09' 2025-03-01 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,'270515','8','O25030002861','【SNOOPY 聯名】美好探尋-8結禮盒','DG0103188-09','DG0103188','原味蛋捲,巧克力蛋捲','禮盒-SNOOPY(橘)【原味+巧克力】','500','500','0','0','0','0','1','0.0','1','500','2025-03-10','2025-03-01 22:37:15','2025-03-01 23:59:07',null,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270515',`firm_id` = '8',`ordernumber` = 'O25030002861', `product_name` = '【SNOOPY 聯名】美好探尋-8結禮盒',`product_code` = 'DG0103188-09',`product_sn` = 'DG0103188',`product_spec` = '原味蛋捲,巧克力蛋捲',`invoice_name` = '禮盒-SNOOPY(橘)【原味+巧克力】',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '500',`etd` = '2025-03-10',`create_date` = '2025-03-01 22:37:15',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030002861' and product_code = 'DG0103188-09' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030002861' and product_code = 'DG010312-05' 2025-03-01 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,'270515','8','O25030002861','【原味+巧克力】金8結禮盒','DG010312-05','DG010312','金8結盒','禮盒-金8結【原味+巧克力】','590','480','0','0','0','0','1','480.0','2','960','2025-03-10','2025-03-01 22:37:15','2025-03-01 23:59:07',null,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270515',`firm_id` = '8',`ordernumber` = 'O25030002861', `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` = '2',`total_price` = '960',`etd` = '2025-03-10',`create_date` = '2025-03-01 22:37:15',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030002861' and product_code = 'DG010312-05' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030002932' and product_code = 'DG010347-02' 2025-03-01 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,'270516','8','O25030002932','六月初一&成真咖啡禮盒','DG010347-02','DG010347','芝麻蛋捲+6入咖啡','禮盒-ESG藍金【芝麻+成真咖啡】','495','495','0','0','0','0','1','0.0','5','2475','2025-03-03','2025-03-01 22:47:41','2025-03-01 23:59:07',null,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270516',`firm_id` = '8',`ordernumber` = 'O25030002932', `product_name` = '六月初一&成真咖啡禮盒',`product_code` = 'DG010347-02',`product_sn` = 'DG010347',`product_spec` = '芝麻蛋捲+6入咖啡',`invoice_name` = '禮盒-ESG藍金【芝麻+成真咖啡】',`listprice` = '495',`sellingprice` = '495',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '5',`total_price` = '2475',`etd` = '2025-03-03',`create_date` = '2025-03-01 22:47:41',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030002932' and product_code = 'DG010347-02' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030002932' and product_code = 'DG010347-01' 2025-03-01 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,'270516','8','O25030002932','六月初一&成真咖啡禮盒','DG010347-01','DG010347','原味蛋捲+6入咖啡','禮盒-ESG藍金【原味+成真咖啡】','495','495','0','0','0','0','1','0.0','1','495','2025-03-03','2025-03-01 22:47:41','2025-03-01 23:59:07',null,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270516',`firm_id` = '8',`ordernumber` = 'O25030002932', `product_name` = '六月初一&成真咖啡禮盒',`product_code` = 'DG010347-01',`product_sn` = 'DG010347',`product_spec` = '原味蛋捲+6入咖啡',`invoice_name` = '禮盒-ESG藍金【原味+成真咖啡】',`listprice` = '495',`sellingprice` = '495',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '495',`etd` = '2025-03-03',`create_date` = '2025-03-01 22:47:41',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030002932' and product_code = 'DG010347-01' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030003040' and product_code = 'DG010265-02' 2025-03-01 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,'270517','8','O25030003040','【SNOOPY 聯名】獨特心意-8結提盒','DG010265-02','DG010265','芝麻','提盒-SNOOPY(粉)-40入芝麻','300','300','0','0','0','0','1','0.0','1','300','2025-03-05','2025-03-01 23:02:48','2025-03-01 23:59:07',null,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270517',`firm_id` = '8',`ordernumber` = 'O25030003040', `product_name` = '【SNOOPY 聯名】獨特心意-8結提盒',`product_code` = 'DG010265-02',`product_sn` = 'DG010265',`product_spec` = '芝麻',`invoice_name` = '提盒-SNOOPY(粉)-40入芝麻',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '300',`etd` = '2025-03-05',`create_date` = '2025-03-01 23:02:48',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030003040' and product_code = 'DG010265-02' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030003040' and product_code = 'DG010265-04' 2025-03-01 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,'270517','8','O25030003040','【SNOOPY 聯名】獨特心意-8結提盒','DG010265-04','DG010265','海苔','提盒-SNOOPY(粉)-40入海苔','300','300','0','0','0','0','1','0.0','1','300','2025-03-05','2025-03-01 23:02:48','2025-03-01 23:59:07',null,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270517',`firm_id` = '8',`ordernumber` = 'O25030003040', `product_name` = '【SNOOPY 聯名】獨特心意-8結提盒',`product_code` = 'DG010265-04',`product_sn` = 'DG010265',`product_spec` = '海苔',`invoice_name` = '提盒-SNOOPY(粉)-40入海苔',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '300',`etd` = '2025-03-05',`create_date` = '2025-03-01 23:02:48',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030003040' and product_code = 'DG010265-04' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030003040' and product_code = 'BP010179-01' 2025-03-01 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,'270517','8','O25030003040','[加購]加購-SNOOPY美好提袋','BP010179-01','BP010179','-','加購-SNOOPY美好提袋','390','390','1','1','390','0','0','0.0','1','390','2025-03-05','2025-03-01 23:02:48','2025-03-01 23:59:07',null,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270517',`firm_id` = '8',`ordernumber` = 'O25030003040', `product_name` = '[加購]加購-SNOOPY美好提袋',`product_code` = 'BP010179-01',`product_sn` = 'BP010179',`product_spec` = '-',`invoice_name` = '加購-SNOOPY美好提袋',`listprice` = '390',`sellingprice` = '390',`isadd` = '1',`isbaby` = '1',`addprice` = '390',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '390',`etd` = '2025-03-05',`create_date` = '2025-03-01 23:02:48',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030003040' and product_code = 'BP010179-01' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030003121' and product_code = 'DG010144-01' 2025-03-01 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,'270518','8','O25030003121','【伊藤久右衛門聯名】京都宇治抹茶蛋捲','DG010144-01','DG010144','32入京都宇治抹茶蛋捲','32入京都宇治抹茶蛋捲','280','280','0','0','0','0','1','0.0','7','1960','2025-03-05','2025-03-01 23:06:13','2025-03-01 23:59:07',null,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270518',`firm_id` = '8',`ordernumber` = 'O25030003121', `product_name` = '【伊藤久右衛門聯名】京都宇治抹茶蛋捲',`product_code` = 'DG010144-01',`product_sn` = 'DG010144',`product_spec` = '32入京都宇治抹茶蛋捲',`invoice_name` = '32入京都宇治抹茶蛋捲',`listprice` = '280',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '7',`total_price` = '1960',`etd` = '2025-03-05',`create_date` = '2025-03-01 23:06:13',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030003121' and product_code = 'DG010144-01' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030003222' and product_code = 'DG0103248-01' 2025-03-01 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,'270519','8','O25030003222','金8結禮盒-京都宇治抹茶','DG0103248-01','DG0103241','京都宇治抹茶抹茶+京都宇治抹茶','禮盒-金8結【京都宇治抹茶+京都宇治抹茶】','560','560','0','0','0','0','1','0.0','1','560','2025-03-13','2025-03-01 23:23:03','2025-03-01 23:59:07',null,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270519',`firm_id` = '8',`ordernumber` = 'O25030003222', `product_name` = '金8結禮盒-京都宇治抹茶',`product_code` = 'DG0103248-01',`product_sn` = 'DG0103241',`product_spec` = '京都宇治抹茶抹茶+京都宇治抹茶',`invoice_name` = '禮盒-金8結【京都宇治抹茶+京都宇治抹茶】',`listprice` = '560',`sellingprice` = '560',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '560',`etd` = '2025-03-13',`create_date` = '2025-03-01 23:23:03',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030003222' and product_code = 'DG0103248-01' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030003222' and product_code = 'DG0103148-15' 2025-03-01 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,'270519','8','O25030003222','金典8結禮盒','DG0103148-15','DG0103148','巧克力+巧克力','禮盒-金典(紅)【巧克力+巧克力】','480','480','0','0','0','0','1','0.0','2','960','2025-03-13','2025-03-01 23:23:03','2025-03-01 23:59:07',null,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270519',`firm_id` = '8',`ordernumber` = 'O25030003222', `product_name` = '金典8結禮盒',`product_code` = 'DG0103148-15',`product_sn` = 'DG0103148',`product_spec` = '巧克力+巧克力',`invoice_name` = '禮盒-金典(紅)【巧克力+巧克力】',`listprice` = '480',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '960',`etd` = '2025-03-13',`create_date` = '2025-03-01 23:23:03',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030003222' and product_code = 'DG0103148-15' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030003222' and product_code = 'DG0103148-03' 2025-03-01 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,'270519','8','O25030003222','金典8結禮盒','DG0103148-03','DG0103148','原味+咖啡','禮盒-金典(紅)【原味+咖啡】','480','480','0','0','0','0','1','0.0','1','480','2025-03-13','2025-03-01 23:23:03','2025-03-01 23:59:07',null,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270519',`firm_id` = '8',`ordernumber` = 'O25030003222', `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` = '2025-03-13',`create_date` = '2025-03-01 23:23:03',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030003222' and product_code = 'DG0103148-03' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030003391' and product_code = 'DG0103148-15' 2025-03-01 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,'270520','8','O25030003391','金典8結禮盒','DG0103148-15','DG0103148','巧克力+巧克力','禮盒-金典(紅)【巧克力+巧克力】','480','480','0','0','0','0','1','0.0','2','960','2025-03-13','2025-03-01 23:35:50','2025-03-01 23:59:07',null,'1','2025-02-02') 2025-03-01 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270520',`firm_id` = '8',`ordernumber` = 'O25030003391', `product_name` = '金典8結禮盒',`product_code` = 'DG0103148-15',`product_sn` = 'DG0103148',`product_spec` = '巧克力+巧克力',`invoice_name` = '禮盒-金典(紅)【巧克力+巧克力】',`listprice` = '480',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '960',`etd` = '2025-03-13',`create_date` = '2025-03-01 23:35:50',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030003391' and product_code = 'DG0103148-15' 2025-03-01 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030003391' and product_code = 'DG0103148-07' 2025-03-01 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,'270520','8','O25030003391','金典8結禮盒','DG0103148-07','DG0103148','芝麻+咖啡','禮盒-金典(紅)【芝麻+咖啡】','480','480','0','0','0','0','1','0.0','1','480','2025-03-13','2025-03-01 23:35:50','2025-03-01 23:59:07',null,'1','2025-02-02') 2025-03-01 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270520',`firm_id` = '8',`ordernumber` = 'O25030003391', `product_name` = '金典8結禮盒',`product_code` = 'DG0103148-07',`product_sn` = 'DG0103148',`product_spec` = '芝麻+咖啡',`invoice_name` = '禮盒-金典(紅)【芝麻+咖啡】',`listprice` = '480',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '480',`etd` = '2025-03-13',`create_date` = '2025-03-01 23:35:50',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030003391' and product_code = 'DG0103148-07' 2025-03-01 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O25030003391' and product_code = 'DG0103248-01' 2025-03-01 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,'270520','8','O25030003391','金8結禮盒-京都宇治抹茶','DG0103248-01','DG0103241','京都宇治抹茶抹茶+京都宇治抹茶','禮盒-金8結【京都宇治抹茶+京都宇治抹茶】','560','560','0','0','0','0','1','0.0','1','560','2025-03-13','2025-03-01 23:35:50','2025-03-01 23:59:08',null,'1','2025-02-02') 2025-03-01 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '270520',`firm_id` = '8',`ordernumber` = 'O25030003391', `product_name` = '金8結禮盒-京都宇治抹茶',`product_code` = 'DG0103248-01',`product_sn` = 'DG0103241',`product_spec` = '京都宇治抹茶抹茶+京都宇治抹茶',`invoice_name` = '禮盒-金8結【京都宇治抹茶+京都宇治抹茶】',`listprice` = '560',`sellingprice` = '560',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '560',`etd` = '2025-03-13',`create_date` = '2025-03-01 23:35:50',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2025-02-02'where ordernumber = 'O25030003391' and product_code = 'DG0103248-01' 2025-03-01 23:59:08 -- == sync_order_detail end == 2025-03-01 23:59:08 -- == sync_order start == 2025-03-01 23:59:08 -- start:2025-03-01,end:2025-03-01 2025-03-01 23:59:08 -- == select june1.order_list == select l.mid,m.uid,l.category_name,l.category_id,l.ordernumber,l.location,l.payway,l.delivery_way,l.pay_status,l.process_status,l.company_number,l.company_title,l.invoice_status,l.etd,l.web_discount,l.class_discount,l.member_discount,l.web_gift,l.freight,l.entity_discount,l.totalprice,l.orderzip,l.orderaddresscity,l.orderaddressarea,l.recipientzip,l.recipientaddresscity,l.recipientaddressarea,l.totalprice_after-web_discount-class_discount-member_discount-entity_discount as totalprice_after,l.create_date FROM `order_list` l LEFT JOIN member_list m on l.mid = m.id WHERE l.create_date like '2025-03-01%' OR l.modify_date like '2025-03-01%'; 2025-03-01 23:59:08 -- == sync omo_order_list == 2025-03-01 23:59:08 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('8284','199543',2,'','','B25030000129','1','1','1','1','1','','','0','0000-00-00','560','0','0','','0','0','11200','600','嘉義市','東區','600','嘉義市','東區','10640','2025-03-01 03:45:17','2025-02-02') 2025-03-01 23:59:08 -- == sync_order end == 2025-03-01 23:59:08 -- == sync_order_detail start == 2025-03-01 23:59:08 -- start:2025-03-01,end:2025-03-01 2025-03-01 23:59:08 -- == sync omo_order_detail == 2025-03-01 23:59:08 -- == SELECT order_detail == SELECT * from order_detail WHERE create_date like '2025-03-01%' OR modify_date like '2025-03-01%' 2025-03-01 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B25030000129' and product_code = 'DG010266-01' 2025-03-01 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`, `channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`,`lunar_date`) VALUES (null, 2,'34347','8','B25030000129','SNOOPY獨特心意-8結彌月提盒','DG010266-01','DG010266','原味','提盒-彌月SNOOPY(粉)-40入原味','300','300','0','1','0','0','1','0.0','15','4500','2025-03-12','2025-03-01 03:45:17','2025-03-01 23:59:08',null,'1','2025-02-02') 2025-03-01 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '34347',`firm_id` = '8',`ordernumber` = 'B25030000129', `product_name` = 'SNOOPY獨特心意-8結彌月提盒',`product_code` = 'DG010266-01',`product_sn` = 'DG010266',`product_spec` = '原味',`invoice_name` = '提盒-彌月SNOOPY(粉)-40入原味',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '15',`total_price` = '4500',`etd` = '2025-03-12',`create_date` = '2025-03-01 03:45:17',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B25030000129' and product_code = 'DG010266-01', `lunar_date` = '2025-02-02' 2025-03-01 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B25030000129' and product_code = 'DG010266-05' 2025-03-01 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`, `channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`,`lunar_date`) VALUES (null, 2,'34347','8','B25030000129','SNOOPY獨特心意-8結彌月提盒','DG010266-05','DG010266','巧克力','提盒-彌月SNOOPY(粉)-40入巧克力','300','300','0','1','0','0','1','0.0','14','4200','2025-03-12','2025-03-01 03:45:17','2025-03-01 23:59:08',null,'1','2025-02-02') 2025-03-01 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '34347',`firm_id` = '8',`ordernumber` = 'B25030000129', `product_name` = 'SNOOPY獨特心意-8結彌月提盒',`product_code` = 'DG010266-05',`product_sn` = 'DG010266',`product_spec` = '巧克力',`invoice_name` = '提盒-彌月SNOOPY(粉)-40入巧克力',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '14',`total_price` = '4200',`etd` = '2025-03-12',`create_date` = '2025-03-01 03:45:17',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B25030000129' and product_code = 'DG010266-05', `lunar_date` = '2025-02-02' 2025-03-01 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B25030000129' and product_code = 'DG0103189-05' 2025-03-01 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`, `channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`,`lunar_date`) VALUES (null, 2,'34347','8','B25030000129','SNOOPY美好探尋-8結彌月禮盒','DG0103189-05','DG0103189','原味+巧克力','禮盒-彌月SNOOPY(橘)【原味+巧克力】','500','500','0','1','0','0','1','0.0','4','2000','2025-03-12','2025-03-01 03:45:17','2025-03-01 23:59:08',null,'1','2025-02-02') 2025-03-01 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '34347',`firm_id` = '8',`ordernumber` = 'B25030000129', `product_name` = 'SNOOPY美好探尋-8結彌月禮盒',`product_code` = 'DG0103189-05',`product_sn` = 'DG0103189',`product_spec` = '原味+巧克力',`invoice_name` = '禮盒-彌月SNOOPY(橘)【原味+巧克力】',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '4',`total_price` = '2000',`etd` = '2025-03-12',`create_date` = '2025-03-01 03:45:17',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B25030000129' and product_code = 'DG0103189-05', `lunar_date` = '2025-02-02' 2025-03-01 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B25030000129' and product_code = 'DG0103189-08' 2025-03-01 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`, `channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`,`lunar_date`) VALUES (null, 2,'34347','8','B25030000129','SNOOPY美好探尋-8結彌月禮盒','DG0103189-08','DG0103189','芝麻+海苔','禮盒-彌月SNOOPY(橘)【芝麻+海苔】','500','500','0','1','0','0','1','0.0','1','500','2025-03-12','2025-03-01 03:45:17','2025-03-01 23:59:08',null,'1','2025-02-02') 2025-03-01 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '34347',`firm_id` = '8',`ordernumber` = 'B25030000129', `product_name` = 'SNOOPY美好探尋-8結彌月禮盒',`product_code` = 'DG0103189-08',`product_sn` = 'DG0103189',`product_spec` = '芝麻+海苔',`invoice_name` = '禮盒-彌月SNOOPY(橘)【芝麻+海苔】',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '500',`etd` = '2025-03-12',`create_date` = '2025-03-01 03:45:17',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B25030000129' and product_code = 'DG0103189-08', `lunar_date` = '2025-02-02' 2025-03-01 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B25030000129' and product_code = 'ZP010518-01' 2025-03-01 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`, `channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`,`lunar_date`) VALUES (null, 2,'34347','8','B25030000129','贈品-剛剛好蛋捲組','ZP010518-01','ZP010518','一組','組合-32入原味蛋捲+剛剛好的優雅-有聲書(線上兌換)+剛剛好帆布袋+金句透卡','0','0','0','0','0','0','1','0.0','1','0','2025-03-12','2025-03-01 03:45:17','2025-03-01 23:59:08',null,'1','2025-02-02') 2025-03-01 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '34347',`firm_id` = '8',`ordernumber` = 'B25030000129', `product_name` = '贈品-剛剛好蛋捲組',`product_code` = 'ZP010518-01',`product_sn` = 'ZP010518',`product_spec` = '一組',`invoice_name` = '組合-32入原味蛋捲+剛剛好的優雅-有聲書(線上兌換)+剛剛好帆布袋+金句透卡',`listprice` = '0',`sellingprice` = '0',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '0',`etd` = '2025-03-12',`create_date` = '2025-03-01 03:45:17',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B25030000129' and product_code = 'ZP010518-01', `lunar_date` = '2025-02-02' 2025-03-01 23:59:08 -- == sync_order_detail end == 2025-03-01 23:59:08 -- == select one.order_list == SELECT o.code,o.pay_status,o.order_status,o.user_id,o.pay_method_id,o.activity_freight_id,o.freight_fee,o.items_total,o.total,DATE(o.shipped_at) as shipped_at,o.created_at as create_date, inv.company_number,inv.company_title,inv.invoice_status, cust.zipcode,cust.county,cust.district, rec.zipcode as recipientzip,rec.county as recipientaddresscity,rec.district as recipientaddressarea, af.type as freight_type FROM `orders` o LEFT JOIN systemlead_invoices inv on o.id = inv.order_id LEFT JOIN order_customers cust on o.id = cust.order_id LEFT JOIN order_receivers rec on o.id = rec.order_id LEFT JOIN activity_freights af on o.activity_freight_id = af.id WHERE (DATE(o.created_at) = '2025-03-01' OR o.updated_at = '2025-03-01') and o.deleted_at is null 2025-03-01 23:59:08 -- == sync_order_detail start == 2025-03-01 23:59:08 -- start:2025-03-01,end:2025-03-01 2025-03-01 23:59:09 -- step1: SELECT id,sku,combinations_product_spec_id FROM `product_specs` 2025-03-01 23:59:09 -- step2: SELECT * FROM `product_specs` WHERE combinations_product_spec_id is not null 2025-03-01 23:59:13 -- step3: SELECT id,product_code,product_sn FROM `omo_order_detail` WHERE `channel` = 6 and product_code like '%,%' and create_date LIKE '2025-03-01%';