2024-06-29 23:59:02 -- == sync_order start == 2024-06-29 23:59:02 -- start:2024-06-29,end:2024-06-29 2024-06-29 23:59:02 -- == select june1.order_list == SELECT l.mid,m.uid,l.category_name,l.category_id,l.ordernumber,l.location,l.payway,l.delivery_way,l.pay_status,l.process_status,l.company_number,l.company_title,l.invoice_status,l.etd,l.web_discount,l.class_discount,l.member_discount,l.web_gift,l.freight,l.entity_discount,l.totalprice,l.orderzip,l.orderaddresscity,l.orderaddressarea,l.recipientzip,l.recipientaddresscity,l.recipientaddressarea,l.totalprice_after-web_discount-class_discount-member_discount-entity_discount as totalprice_after,l.create_date FROM `order_list` l LEFT JOIN member_list m on l.mid = m.id WHERE l.create_date like '2024-06-29%' OR l.modify_date like '2024-06-29%'; 2024-06-29 23:59:04 -- == sync omo_order_list == 2024-06-29 23:59:04 -- == update lake.omo_order_list == update omo_order_list set userId = '398566', process_status = '3', pay_status = '1', totalprice_after = '2070', lunar_date = '2024-05-23', invoice_status = '0',category_name = '永康門市訂單', category_id = '31' where ordernumber = 'S24060123180' 2024-06-29 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('357894','394528',1,'','','O24060125246','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','480','236','新北市','土城區','950','台東縣','台東市','630','2024-06-29 00:13:09','2024-05-24') 2024-06-29 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('362139','398742',1,'','','O24060125352','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','2300','436','台中市','清水區','436','台中市','清水區','2420','2024-06-29 00:44:15','2024-05-24') 2024-06-29 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('362006','398609',1,'','','O24060125412','1','1','1','0','0','','','0','0000-00-00','0','0','0','','150','30','1180','351','苗栗縣','頭份市','351','苗栗縣','頭份市','1300','2024-06-29 05:18:15','2024-05-24') 2024-06-29 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('359013','395638',1,'','','O24060125516','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','2900','333','桃園市','龜山區','333','桃園市','龜山區','3050','2024-06-29 07:06:26','2024-05-24') 2024-06-29 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('360692','397306',1,'','','O24060125694','1','2','1','0','0','','','0','0000-00-00','0','0','0','','150','0','480','640','雲林縣','斗六市','640','雲林縣','斗六市','630','2024-06-29 09:17:46','2024-05-24') 2024-06-29 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('294228','331641',1,'','','O24060125763','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1150','251','新北市','淡水區','251','新北市','淡水區','1300','2024-06-29 09:30:14','2024-05-24') 2024-06-29 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('344939','381697',1,'','','O24060125889','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','700','404','台中市','北區','900','屏東縣','屏東市','850','2024-06-29 11:16:27','2024-05-24') 2024-06-29 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('362168','398771',1,'','','O24060125988','1','1','1','1','1','23483416','長友營造股份有限公司','0','0000-00-00','421','0','0','','0','0','8435','338','桃園市','蘆竹區','338','桃園市','蘆竹區','8014','2024-06-29 11:50:25','2024-05-24') 2024-06-29 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('362187','398790',1,'美村門市訂單','32','S24060126095','1','2','1','1','1','','','0','2024-07-01','0','0','0','','0','0','7200','414','台中市','烏日區','542','南投縣','草屯鎮','7200','2024-06-29 12:17:48','2024-05-24') 2024-06-29 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('235487','265197',1,'','','O24060126166','1','1','1','1','1','86814265','宣瑞股份有限公司','0','0000-00-00','472','0','0','','0','0','9440','330','桃園市','桃園區','330','桃園市','桃園區','8968','2024-06-29 13:15:40','2024-05-24') 2024-06-29 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('184721','151102',1,'','','O24060126244','1','1','1','0','0','','','0','0000-00-00','0','0','0','','150','0','2560','950','台東縣','台東市','950','台東縣','台東市','2710','2024-06-29 13:18:34','2024-05-24') 2024-06-29 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('107952','78192',1,'','','O24060126338','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','3000','110','台北市','信義區','110','台北市','信義區','3150','2024-06-29 13:35:43','2024-05-24') 2024-06-29 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('360466','397084',1,'','','O24060126427','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1680','235','新北市','中和區','235','新北市','中和區','1800','2024-06-29 14:33:55','2024-05-24') 2024-06-29 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('234831','264299',1,'','','O24060126599','1','2','1','0','0','','','0','0000-00-00','0','0','0','','150','0','1590','242','新北市','新莊區','242','新北市','新莊區','1740','2024-06-29 14:37:30','2024-05-24') 2024-06-29 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('362247','398850',1,'','','O24060126661','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','2640','231','新北市','新店區','231','新北市','新店區','2760','2024-06-29 15:18:30','2024-05-24') 2024-06-29 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('126012','94616',1,'','','O24060126716','1','2','1','1','1','','','0','0000-00-00','0','0','0','','150','0','2300','335','桃園市','大溪區','335','桃園市','大溪區','2450','2024-06-29 16:09:06','2024-05-24') 2024-06-29 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('362277','398880',1,'永康當日宅配','19','S24060126860','1','1','7','1','3','','','1','2024-06-29','0','0','0','','250','0','3080','110','台北市','信義區','110','台北市','信義區','3330','2024-06-29 16:15:11','2024-05-24') 2024-06-29 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('362262','398865',1,'','','O24060126943','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1460','505','彰化縣','鹿港鎮','436','台中市','清水區','1580','2024-06-29 16:32:27','2024-05-24') 2024-06-29 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('362282','398885',1,'','','O24060127044','1','1','1','1','1','83276480','睿奕交通股份有限公司','0','0000-00-00','0','0','0','','150','30','1150','435','台中市','梧棲區','435','台中市','梧棲區','1270','2024-06-29 16:43:57','2024-05-24') 2024-06-29 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('361141','397752',1,'迪化門市訂單','43','S24060127116','1','1','6','1','1','','','0','2024-07-02','0','0','0','','0','30','1335','220','新北市','板橋區','220','新北市','板橋區','1305','2024-06-29 17:18:44','2024-05-24') 2024-06-29 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('362309','398912',1,'','','O24060127283','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','3580','436','台中市','清水區','436','台中市','清水區','3700','2024-06-29 17:23:28','2024-05-24') 2024-06-29 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('361141','397752',1,'迪化門市訂單','43','S24060127390','1','1','6','1','1','','','0','2024-07-02','0','10','0','','0','30','1300','220','新北市','板橋區','220','新北市','板橋區','1260','2024-06-29 17:35:36','2024-05-24') 2024-06-29 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('196056','162133',1,'','','O24060127410','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','3450','724','台南市','七股區','724','台南市','七股區','3600','2024-06-29 18:32:27','2024-05-24') 2024-06-29 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('121861','0',1,'永康門市訂單','31','S24060127552','1','1','7','1','1','','','0','2024-07-01','0','0','0','','150','100','1000','111','台北市','士林區','111','台北市','士林區','1050','2024-06-29 19:30:22','2024-05-24') 2024-06-29 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('362358','398961',1,'','','O24060127678','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1990','330','桃園市','桃園區','330','桃園市','桃園區','2110','2024-06-29 19:52:55','2024-05-24') 2024-06-29 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('362363','398966',1,'','','O24060127759','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','2300','514','彰化縣','溪湖鎮','514','彰化縣','溪湖鎮','2420','2024-06-29 20:29:16','2024-05-24') 2024-06-29 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('362374','398977',1,'','','O24060127815','1','1','1','0','0','','','0','0000-00-00','0','0','0','','150','30','945','350','苗栗縣','竹南鎮','350','苗栗縣','竹南鎮','1065','2024-06-29 23:47:39','2024-05-24') 2024-06-29 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('362376','398979',1,'','','O24060127955','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','990','100','台北市','中正區','100','台北市','中正區','1140','2024-06-29 23:48:59','2024-05-24') 2024-06-29 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('360043','396661',1,'','','O24060128088','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','4460','742','台南市','大內區','640','雲林縣','斗六市','4580','2024-06-29 23:49:03','2024-05-24') 2024-06-29 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('362375','398978',1,'','','O24060128131','1','1','1','0','0','','','0','0000-00-00','0','0','0','','150','30','1690','621','嘉義縣','民雄鄉','621','嘉義縣','民雄鄉','1810','2024-06-29 23:51:25','2024-05-24') 2024-06-29 23:59:04 -- == sync_order end == 2024-06-29 23:59:04 -- == sync_order_detail start == 2024-06-29 23:59:04 -- start:2024-06-29,end:2024-06-29 2024-06-29 23:59:04 -- == sync omo_order_detail == 2024-06-29 23:59:04 -- == SELECT order_detail == SELECT * from order_detail WHERE create_date like '2024-06-29%' OR modify_date like '2024-06-29%' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24060123180' and product_code = 'DG0103148-02' 2024-06-29 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234322',`firm_id` = '8',`ordernumber` = 'S24060123180', `product_name` = '金典8結禮盒',`product_code` = 'DG0103148-02',`product_sn` = 'DG0103148',`product_spec` = '原味+芝麻',`invoice_name` = '禮盒-金典(紅)【原味+芝麻】',`listprice` = '480',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '4',`total_price` = '1920',`etd` = '2024-06-28',`create_date` = '2024-06-28 11:13:25',`modify_date` = '2024-06-29 10:55:38',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-05-23'where ordernumber = 'S24060123180' and product_code = 'DG0103148-02' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060125246' and product_code = 'DG0103148-05' 2024-06-29 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,'234343','8','O24060125246','金典8結禮盒','DG0103148-05','DG0103148','原味+巧克力','禮盒-金典(紅)【原味+巧克力】','480','480','0','0','0','0','1','0.0','1','480','2024-07-01','2024-06-29 00:13:09','2024-06-29 23:59:06',null,'1','2024-05-24') 2024-06-29 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234343',`firm_id` = '8',`ordernumber` = 'O24060125246', `product_name` = '金典8結禮盒',`product_code` = 'DG0103148-05',`product_sn` = 'DG0103148',`product_spec` = '原味+巧克力',`invoice_name` = '禮盒-金典(紅)【原味+巧克力】',`listprice` = '480',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '480',`etd` = '2024-07-01',`create_date` = '2024-06-29 00:13:09',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060125246' and product_code = 'DG0103148-05' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060125352' and product_code = 'DG010576-50' 2024-06-29 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,'234344','8','O24060125352','【品牌月獨家】經典蛋捲五入組','DG010576-50','DG010576','原+芝+巧+咖+海','組合-32入(原味x1+芝麻x1+咖啡x1+海苔x1+巧克力x1)+紅色提袋x2','1150','1150','0','0','0','1','1','0.0','2','2300','2024-07-03','2024-06-29 00:44:15','2024-06-29 23:59:06',null,'1','2024-05-24') 2024-06-29 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234344',`firm_id` = '8',`ordernumber` = 'O24060125352', `product_name` = '【品牌月獨家】經典蛋捲五入組',`product_code` = 'DG010576-50',`product_sn` = 'DG010576',`product_spec` = '原+芝+巧+咖+海',`invoice_name` = '組合-32入(原味x1+芝麻x1+咖啡x1+海苔x1+巧克力x1)+紅色提袋x2',`listprice` = '1150',`sellingprice` = '1150',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '2300',`etd` = '2024-07-03',`create_date` = '2024-06-29 00:44:15',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060125352' and product_code = 'DG010576-50' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060125412' and product_code = 'DG010576-25' 2024-06-29 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,'234345','8','O24060125412','【品牌月獨家】經典蛋捲五入組','DG010576-25','DG010576','原味x2+巧克力x2+芝麻x1','組合-32入(原味x2+巧克力x2+芝麻x1)+紅色提袋x2','1150','1150','0','0','0','1','1','0.0','1','1150','2024-07-01','2024-06-29 05:18:15','2024-06-29 23:59:06',null,'1','2024-05-24') 2024-06-29 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234345',`firm_id` = '8',`ordernumber` = 'O24060125412', `product_name` = '【品牌月獨家】經典蛋捲五入組',`product_code` = 'DG010576-25',`product_sn` = 'DG010576',`product_spec` = '原味x2+巧克力x2+芝麻x1',`invoice_name` = '組合-32入(原味x2+巧克力x2+芝麻x1)+紅色提袋x2',`listprice` = '1150',`sellingprice` = '1150',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1150',`etd` = '2024-07-01',`create_date` = '2024-06-29 05:18:15',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060125412' and product_code = 'DG010576-25' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060125412' and product_code = 'BP010128-01' 2024-06-29 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,'234345','8','O24060125412','8結小禮袋','BP010128-01','BP010128','提袋/個','8結小禮袋','10','10','0','0','0','0','1','0.0','3','30','2024-07-01','2024-06-29 05:18:15','2024-06-29 23:59:06',null,'1','2024-05-24') 2024-06-29 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234345',`firm_id` = '8',`ordernumber` = 'O24060125412', `product_name` = '8結小禮袋',`product_code` = 'BP010128-01',`product_sn` = 'BP010128',`product_spec` = '提袋/個',`invoice_name` = '8結小禮袋',`listprice` = '10',`sellingprice` = '10',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '3',`total_price` = '30',`etd` = '2024-07-01',`create_date` = '2024-06-29 05:18:15',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060125412' and product_code = 'BP010128-01' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060125516' and product_code = '13656' 2024-06-29 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,'234346','8','O24060125516','8結蛋捲【紅提袋裝】','13656','13656','40入原味蛋捲','組合-40入原味+紅提袋','290','290','0','0','0','0','1','0.0','4','1160','2024-07-01','2024-06-29 07:06:26','2024-06-29 23:59:06',null,'1','2024-05-24') 2024-06-29 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234346',`firm_id` = '8',`ordernumber` = 'O24060125516', `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` = '4',`total_price` = '1160',`etd` = '2024-07-01',`create_date` = '2024-06-29 07:06:26',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060125516' and product_code = '13656' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060125516' and product_code = '13657' 2024-06-29 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,'234346','8','O24060125516','8結蛋捲【紅提袋裝】','13657','13656','40入芝麻蛋捲','組合-40入芝麻+紅提袋','290','290','0','0','0','0','1','0.0','3','870','2024-07-01','2024-06-29 07:06:26','2024-06-29 23:59:06',null,'1','2024-05-24') 2024-06-29 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234346',`firm_id` = '8',`ordernumber` = 'O24060125516', `product_name` = '8結蛋捲【紅提袋裝】',`product_code` = '13657',`product_sn` = '13656',`product_spec` = '40入芝麻蛋捲',`invoice_name` = '組合-40入芝麻+紅提袋',`listprice` = '290',`sellingprice` = '290',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '3',`total_price` = '870',`etd` = '2024-07-01',`create_date` = '2024-06-29 07:06:26',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060125516' and product_code = '13657' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060125516' and product_code = '13658' 2024-06-29 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,'234346','8','O24060125516','8結蛋捲【紅提袋裝】','13658','13656','40入咖啡蛋捲','組合-40入咖啡+紅提袋','290','290','0','0','0','0','1','0.0','1','290','2024-07-01','2024-06-29 07:06:26','2024-06-29 23:59:06',null,'1','2024-05-24') 2024-06-29 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234346',`firm_id` = '8',`ordernumber` = 'O24060125516', `product_name` = '8結蛋捲【紅提袋裝】',`product_code` = '13658',`product_sn` = '13656',`product_spec` = '40入咖啡蛋捲',`invoice_name` = '組合-40入咖啡+紅提袋',`listprice` = '290',`sellingprice` = '290',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '290',`etd` = '2024-07-01',`create_date` = '2024-06-29 07:06:26',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060125516' and product_code = '13658' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060125516' and product_code = '13660' 2024-06-29 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,'234346','8','O24060125516','8結蛋捲【紅提袋裝】','13660','13656','40入巧克力蛋捲','組合-40入巧克力+紅提袋','290','290','0','0','0','0','1','0.0','2','580','2024-07-01','2024-06-29 07:06:26','2024-06-29 23:59:06',null,'1','2024-05-24') 2024-06-29 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234346',`firm_id` = '8',`ordernumber` = 'O24060125516', `product_name` = '8結蛋捲【紅提袋裝】',`product_code` = '13660',`product_sn` = '13656',`product_spec` = '40入巧克力蛋捲',`invoice_name` = '組合-40入巧克力+紅提袋',`listprice` = '290',`sellingprice` = '290',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '580',`etd` = '2024-07-01',`create_date` = '2024-06-29 07:06:26',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060125516' and product_code = '13660' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060125694' and product_code = 'DG0103148-04' 2024-06-29 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,'234347','8','O24060125694','金典8結禮盒','DG0103148-04','DG0103148','原味+海苔','禮盒-金典(紅)【原味+海苔】','480','480','0','0','0','0','1','0.0','1','480','2024-07-01','2024-06-29 09:17:46','2024-06-29 23:59:06',null,'1','2024-05-24') 2024-06-29 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234347',`firm_id` = '8',`ordernumber` = 'O24060125694', `product_name` = '金典8結禮盒',`product_code` = 'DG0103148-04',`product_sn` = 'DG0103148',`product_spec` = '原味+海苔',`invoice_name` = '禮盒-金典(紅)【原味+海苔】',`listprice` = '480',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '480',`etd` = '2024-07-01',`create_date` = '2024-06-29 09:17:46',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060125694' and product_code = 'DG0103148-04' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060125763' and product_code = 'DG010576-28' 2024-06-29 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,'234348','8','O24060125763','【品牌月獨家】經典蛋捲五入組','DG010576-28','DG010576','原味x2+咖啡x2+巧克力x1','組合-32入(原味x2+咖啡x2+巧克力x1)+紅色提袋x2','1150','1150','0','0','0','1','1','0.0','1','1150','2024-07-01','2024-06-29 09:30:14','2024-06-29 23:59:06',null,'1','2024-05-24') 2024-06-29 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234348',`firm_id` = '8',`ordernumber` = 'O24060125763', `product_name` = '【品牌月獨家】經典蛋捲五入組',`product_code` = 'DG010576-28',`product_sn` = 'DG010576',`product_spec` = '原味x2+咖啡x2+巧克力x1',`invoice_name` = '組合-32入(原味x2+咖啡x2+巧克力x1)+紅色提袋x2',`listprice` = '1150',`sellingprice` = '1150',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1150',`etd` = '2024-07-01',`create_date` = '2024-06-29 09:30:14',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060125763' and product_code = 'DG010576-28' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060125889' and product_code = 'DG010599-08' 2024-06-29 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,'234349','8','O24060125889','【品牌月獨家】經典蛋捲三入組','DG010599-08','DG010599','原味+芝麻+海苔','組合-32入(原味+芝麻+海苔)+紅色提袋','700','700','0','0','0','1','1','0.0','1','700','2024-07-01','2024-06-29 11:16:27','2024-06-29 23:59:06',null,'1','2024-05-24') 2024-06-29 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234349',`firm_id` = '8',`ordernumber` = 'O24060125889', `product_name` = '【品牌月獨家】經典蛋捲三入組',`product_code` = 'DG010599-08',`product_sn` = 'DG010599',`product_spec` = '原味+芝麻+海苔',`invoice_name` = '組合-32入(原味+芝麻+海苔)+紅色提袋',`listprice` = '700',`sellingprice` = '700',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '700',`etd` = '2024-07-01',`create_date` = '2024-06-29 11:16:27',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060125889' and product_code = 'DG010599-08' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060125988' and product_code = 'DG0103165-01' 2024-06-29 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,'234350','8','O24060125988','金典8結黑松露堅果禮盒','DG0103165-01','12529','原味蛋捲,黑松露腰果','禮盒-金典(紅)【原味+腰果提盒】','1205','1205','0','0','0','0','1','0.0','7','8435','2024-07-01','2024-06-29 11:50:25','2024-06-29 23:59:06',null,'1','2024-05-24') 2024-06-29 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234350',`firm_id` = '8',`ordernumber` = 'O24060125988', `product_name` = '金典8結黑松露堅果禮盒',`product_code` = 'DG0103165-01',`product_sn` = '12529',`product_spec` = '原味蛋捲,黑松露腰果',`invoice_name` = '禮盒-金典(紅)【原味+腰果提盒】',`listprice` = '1205',`sellingprice` = '1205',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '7',`total_price` = '8435',`etd` = '2024-07-01',`create_date` = '2024-06-29 11:50:25',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060125988' and product_code = 'DG0103165-01' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060125988' and product_code = 'ZP0101135-01' 2024-06-29 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,'234350','8','O24060125988','贈品-復古紅提袋x2','ZP0101135-01','ZP0101135','贈品-復古紅提袋x2','贈品-［復古］提袋x2','0','0','0','0','0','0','1','0.0','1','0','2024-07-01','2024-06-29 11:50:25','2024-06-29 23:59:06',null,'1','2024-05-24') 2024-06-29 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234350',`firm_id` = '8',`ordernumber` = 'O24060125988', `product_name` = '贈品-復古紅提袋x2',`product_code` = 'ZP0101135-01',`product_sn` = 'ZP0101135',`product_spec` = '贈品-復古紅提袋x2',`invoice_name` = '贈品-［復古］提袋x2',`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` = '2024-07-01',`create_date` = '2024-06-29 11:50:25',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060125988' and product_code = 'ZP0101135-01' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24060126095' and product_code = 'DG010312-02' 2024-06-29 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,'234351','8','S24060126095','【原味+芝麻】金8結禮盒','DG010312-02','DG010312','金8結盒','禮盒-金8結【原味+芝麻】','590','480','0','0','0','0','1','480.0','15','7200','2024-07-01','2024-06-29 12:17:48','2024-06-29 23:59:06',0,'1','2024-05-24') 2024-06-29 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234351',`firm_id` = '8',`ordernumber` = 'S24060126095', `product_name` = '【原味+芝麻】金8結禮盒',`product_code` = 'DG010312-02',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+芝麻】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '15',`total_price` = '7200',`etd` = '2024-07-01',`create_date` = '2024-06-29 12:17:48',`modify_date` = '2024-06-29 12:19:03',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'S24060126095' and product_code = 'DG010312-02' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060126166' and product_code = 'DG010206-01' 2024-06-29 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,'234352','8','O24060126166','8結蛋捲【紅提盒裝】','DG010206-01','DG010206','原味','提盒-品牌(紅)-40入原味蛋捲','295','295','0','0','0','0','1','0.0','32','9440','2024-07-03','2024-06-29 13:15:40','2024-06-29 23:59:06',null,'1','2024-05-24') 2024-06-29 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234352',`firm_id` = '8',`ordernumber` = 'O24060126166', `product_name` = '8結蛋捲【紅提盒裝】',`product_code` = 'DG010206-01',`product_sn` = 'DG010206',`product_spec` = '原味',`invoice_name` = '提盒-品牌(紅)-40入原味蛋捲',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '32',`total_price` = '9440',`etd` = '2024-07-03',`create_date` = '2024-06-29 13:15:40',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060126166' and product_code = 'DG010206-01' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060126166' and product_code = 'ZP0101135-01' 2024-06-29 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,'234352','8','O24060126166','贈品-復古紅提袋x2','ZP0101135-01','ZP0101135','贈品-復古紅提袋x2','贈品-［復古］提袋x2','0','0','0','0','0','0','1','0.0','1','0','2024-07-03','2024-06-29 13:15:40','2024-06-29 23:59:06',null,'1','2024-05-24') 2024-06-29 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234352',`firm_id` = '8',`ordernumber` = 'O24060126166', `product_name` = '贈品-復古紅提袋x2',`product_code` = 'ZP0101135-01',`product_sn` = 'ZP0101135',`product_spec` = '贈品-復古紅提袋x2',`invoice_name` = '贈品-［復古］提袋x2',`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` = '2024-07-03',`create_date` = '2024-06-29 13:15:40',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060126166' and product_code = 'ZP0101135-01' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060126244' and product_code = 'DG010347-02' 2024-06-29 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,'234353','8','O24060126244','六月初一&成真咖啡禮盒','DG010347-02','DG010347','芝麻蛋捲+6入咖啡','禮盒-ESG藍金【芝麻+成真咖啡】','495','495','0','0','0','0','1','0.0','4','1980','2024-07-05','2024-06-29 13:18:34','2024-06-29 23:59:06',null,'1','2024-05-24') 2024-06-29 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234353',`firm_id` = '8',`ordernumber` = 'O24060126244', `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` = '4',`total_price` = '1980',`etd` = '2024-07-05',`create_date` = '2024-06-29 13:18:34',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060126244' and product_code = 'DG010347-02' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060126244' and product_code = '13658' 2024-06-29 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,'234353','8','O24060126244','8結蛋捲【紅提袋裝】','13658','13656','40入咖啡蛋捲','組合-40入咖啡+紅提袋','290','290','0','0','0','0','1','0.0','2','580','2024-07-05','2024-06-29 13:18:34','2024-06-29 23:59:06',null,'1','2024-05-24') 2024-06-29 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234353',`firm_id` = '8',`ordernumber` = 'O24060126244', `product_name` = '8結蛋捲【紅提袋裝】',`product_code` = '13658',`product_sn` = '13656',`product_spec` = '40入咖啡蛋捲',`invoice_name` = '組合-40入咖啡+紅提袋',`listprice` = '290',`sellingprice` = '290',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '580',`etd` = '2024-07-05',`create_date` = '2024-06-29 13:18:34',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060126244' and product_code = '13658' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060126338' and product_code = 'DG010203-01' 2024-06-29 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,'234354','8','O24060126338','【小王子聯名】閃耀星空8結提盒','DG010203-01','DG010203','40入原味蛋捲','提盒-小王子(藍)-40入原味','300','300','0','0','0','0','1','0.0','10','3000','2024-07-11','2024-06-29 13:35:43','2024-06-29 23:59:06',null,'1','2024-05-24') 2024-06-29 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234354',`firm_id` = '8',`ordernumber` = 'O24060126338', `product_name` = '【小王子聯名】閃耀星空8結提盒',`product_code` = 'DG010203-01',`product_sn` = 'DG010203',`product_spec` = '40入原味蛋捲',`invoice_name` = '提盒-小王子(藍)-40入原味',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '10',`total_price` = '3000',`etd` = '2024-07-11',`create_date` = '2024-06-29 13:35:43',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060126338' and product_code = 'DG010203-01' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060126427' and product_code = 'DG0103155-05' 2024-06-29 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,'234355','8','O24060126427','【SNOOPY聯名】友你相伴-8結禮盒','DG0103155-05','DG0103155','原味蛋捲,巧克力蛋捲','禮盒-SNOOPY【原味+巧克力】','500','500','0','0','0','0','1','0.0','1','500','2024-07-12','2024-06-29 14:33:55','2024-06-29 23:59:06',null,'1','2024-05-24') 2024-06-29 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234355',`firm_id` = '8',`ordernumber` = 'O24060126427', `product_name` = '【SNOOPY聯名】友你相伴-8結禮盒',`product_code` = 'DG0103155-05',`product_sn` = 'DG0103155',`product_spec` = '原味蛋捲,巧克力蛋捲',`invoice_name` = '禮盒-SNOOPY【原味+巧克力】',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '500',`etd` = '2024-07-12',`create_date` = '2024-06-29 14:33:55',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060126427' and product_code = 'DG0103155-05' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060126427' and product_code = 'DG010576-50' 2024-06-29 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,'234355','8','O24060126427','【品牌月獨家】經典蛋捲五入組','DG010576-50','DG010576','原+芝+巧+咖+海','組合-32入(原味x1+芝麻x1+咖啡x1+海苔x1+巧克力x1)+紅色提袋x2','1150','1150','0','0','0','1','1','0.0','1','1150','2024-07-12','2024-06-29 14:33:55','2024-06-29 23:59:06',null,'1','2024-05-24') 2024-06-29 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234355',`firm_id` = '8',`ordernumber` = 'O24060126427', `product_name` = '【品牌月獨家】經典蛋捲五入組',`product_code` = 'DG010576-50',`product_sn` = 'DG010576',`product_spec` = '原+芝+巧+咖+海',`invoice_name` = '組合-32入(原味x1+芝麻x1+咖啡x1+海苔x1+巧克力x1)+紅色提袋x2',`listprice` = '1150',`sellingprice` = '1150',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1150',`etd` = '2024-07-12',`create_date` = '2024-06-29 14:33:55',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060126427' and product_code = 'DG010576-50' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060126427' and product_code = 'DG010404-01' 2024-06-29 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,'234355','8','O24060126427','紅色提袋','DG010404-01','DG010404','提袋/個','紅色提袋','10','10','0','0','0','0','1','0.0','3','30','2024-07-12','2024-06-29 14:33:55','2024-06-29 23:59:06',null,'1','2024-05-24') 2024-06-29 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234355',`firm_id` = '8',`ordernumber` = 'O24060126427', `product_name` = '紅色提袋',`product_code` = 'DG010404-01',`product_sn` = 'DG010404',`product_spec` = '提袋/個',`invoice_name` = '紅色提袋',`listprice` = '10',`sellingprice` = '10',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '3',`total_price` = '30',`etd` = '2024-07-12',`create_date` = '2024-06-29 14:33:55',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060126427' and product_code = 'DG010404-01' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060126599' and product_code = 'DG010523-08' 2024-06-29 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,'234356','8','O24060126599','SNOOPY帶走心意-蛋捲三入組','DG010523-08','DG010523','原味+芝麻+海苔','組合-32入(原味+芝麻+海苔)+SNOOPY心意提袋','990','990','0','0','0','1','1','0.0','1','990','2024-07-02','2024-06-29 14:37:30','2024-06-29 23:59:06',null,'1','2024-05-24') 2024-06-29 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234356',`firm_id` = '8',`ordernumber` = 'O24060126599', `product_name` = 'SNOOPY帶走心意-蛋捲三入組',`product_code` = 'DG010523-08',`product_sn` = 'DG010523',`product_spec` = '原味+芝麻+海苔',`invoice_name` = '組合-32入(原味+芝麻+海苔)+SNOOPY心意提袋',`listprice` = '990',`sellingprice` = '990',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '990',`etd` = '2024-07-02',`create_date` = '2024-06-29 14:37:30',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060126599' and product_code = 'DG010523-08' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060126599' and product_code = 'DG010527-04' 2024-06-29 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,'234356','8','O24060126599','8結蛋捲【小禮袋裝】','DG010527-04','DG010527','40入海苔蛋捲','組合-40入海苔+8結小禮袋','290','290','0','0','0','0','1','0.0','2','580','2024-07-02','2024-06-29 14:37:30','2024-06-29 23:59:06',null,'1','2024-05-24') 2024-06-29 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234356',`firm_id` = '8',`ordernumber` = 'O24060126599', `product_name` = '8結蛋捲【小禮袋裝】',`product_code` = 'DG010527-04',`product_sn` = 'DG010527',`product_spec` = '40入海苔蛋捲',`invoice_name` = '組合-40入海苔+8結小禮袋',`listprice` = '290',`sellingprice` = '290',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '580',`etd` = '2024-07-02',`create_date` = '2024-06-29 14:37:30',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060126599' and product_code = 'DG010527-04' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060126599' and product_code = 'DG010404-01' 2024-06-29 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,'234356','8','O24060126599','[加購]紅色提袋','DG010404-01','DG010404','-','紅色提袋','10','10','1','0','10','0','0','0.0','2','20','2024-07-02','2024-06-29 14:37:30','2024-06-29 23:59:06',null,'1','2024-05-24') 2024-06-29 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234356',`firm_id` = '8',`ordernumber` = 'O24060126599', `product_name` = '[加購]紅色提袋',`product_code` = 'DG010404-01',`product_sn` = 'DG010404',`product_spec` = '-',`invoice_name` = '紅色提袋',`listprice` = '10',`sellingprice` = '10',`isadd` = '1',`isbaby` = '0',`addprice` = '10',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '2',`total_price` = '20',`etd` = '2024-07-02',`create_date` = '2024-06-29 14:37:30',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060126599' and product_code = 'DG010404-01' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060126661' and product_code = 'DG0103168-07' 2024-06-29 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,'234357','8','O24060126661','隨享唐寧茶禮盒','DG0103168-07','DG0103168','芝麻+咖啡','禮盒-隨享唐寧茶【芝麻+咖啡】+唐寧早餐茶+茶葉匙','880','880','0','0','0','0','1','0.0','3','2640','2024-07-01','2024-06-29 15:18:30','2024-06-29 23:59:06',null,'1','2024-05-24') 2024-06-29 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234357',`firm_id` = '8',`ordernumber` = 'O24060126661', `product_name` = '隨享唐寧茶禮盒',`product_code` = 'DG0103168-07',`product_sn` = 'DG0103168',`product_spec` = '芝麻+咖啡',`invoice_name` = '禮盒-隨享唐寧茶【芝麻+咖啡】+唐寧早餐茶+茶葉匙',`listprice` = '880',`sellingprice` = '880',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '3',`total_price` = '2640',`etd` = '2024-07-01',`create_date` = '2024-06-29 15:18:30',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060126661' and product_code = 'DG0103168-07' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060126716' and product_code = 'DG010576-50' 2024-06-29 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,'234358','8','O24060126716','【品牌月獨家】經典蛋捲五入組','DG010576-50','DG010576','原+芝+巧+咖+海','組合-32入(原味x1+芝麻x1+咖啡x1+海苔x1+巧克力x1)+紅色提袋x2','1150','1150','0','0','0','1','1','0.0','2','2300','2024-07-01','2024-06-29 16:09:06','2024-06-29 23:59:06',null,'1','2024-05-24') 2024-06-29 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234358',`firm_id` = '8',`ordernumber` = 'O24060126716', `product_name` = '【品牌月獨家】經典蛋捲五入組',`product_code` = 'DG010576-50',`product_sn` = 'DG010576',`product_spec` = '原+芝+巧+咖+海',`invoice_name` = '組合-32入(原味x1+芝麻x1+咖啡x1+海苔x1+巧克力x1)+紅色提袋x2',`listprice` = '1150',`sellingprice` = '1150',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '2300',`etd` = '2024-07-01',`create_date` = '2024-06-29 16:09:06',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060126716' and product_code = 'DG010576-50' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24060126860' and product_code = 'DG010101-01' 2024-06-29 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,'234359','8','S24060126860','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','11','3080','2024-06-29','2024-06-29 16:15:11','2024-06-29 23:59:06',0,'1','2024-05-24') 2024-06-29 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234359',`firm_id` = '8',`ordernumber` = 'S24060126860', `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` = '11',`total_price` = '3080',`etd` = '2024-06-29',`create_date` = '2024-06-29 16:15:11',`modify_date` = '2024-06-29 16:57:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'S24060126860' and product_code = 'DG010101-01' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060126943' and product_code = 'DG0103148-12' 2024-06-29 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,'234360','8','O24060126943','金典8結禮盒','DG0103148-12','DG0103148','巧克力+咖啡','禮盒-金典(紅)【咖啡+巧克力】','480','480','0','0','0','0','1','0.0','1','480','2024-07-01','2024-06-29 16:32:27','2024-06-29 23:59:06',null,'1','2024-05-24') 2024-06-29 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234360',`firm_id` = '8',`ordernumber` = 'O24060126943', `product_name` = '金典8結禮盒',`product_code` = 'DG0103148-12',`product_sn` = 'DG0103148',`product_spec` = '巧克力+咖啡',`invoice_name` = '禮盒-金典(紅)【咖啡+巧克力】',`listprice` = '480',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '480',`etd` = '2024-07-01',`create_date` = '2024-06-29 16:32:27',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060126943' and product_code = 'DG0103148-12' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060126943' and product_code = 'DG0103148-05' 2024-06-29 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,'234360','8','O24060126943','金典8結禮盒','DG0103148-05','DG0103148','原味+巧克力','禮盒-金典(紅)【原味+巧克力】','480','480','0','0','0','0','1','0.0','1','480','2024-07-01','2024-06-29 16:32:27','2024-06-29 23:59:06',null,'1','2024-05-24') 2024-06-29 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234360',`firm_id` = '8',`ordernumber` = 'O24060126943', `product_name` = '金典8結禮盒',`product_code` = 'DG0103148-05',`product_sn` = 'DG0103148',`product_spec` = '原味+巧克力',`invoice_name` = '禮盒-金典(紅)【原味+巧克力】',`listprice` = '480',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '480',`etd` = '2024-07-01',`create_date` = '2024-06-29 16:32:27',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060126943' and product_code = 'DG0103148-05' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060126943' and product_code = 'DG010394-12' 2024-06-29 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,'234360','8','O24060126943','游魚轉心瓶8結蛋捲禮盒【國立故宮博物院聯名】','DG010394-12','DG010394','咖啡蛋捲,巧克力蛋捲','禮盒-故宮(文物款)【咖啡+巧克力】','500','500','0','0','0','0','1','0.0','1','500','2024-07-01','2024-06-29 16:32:27','2024-06-29 23:59:06',null,'1','2024-05-24') 2024-06-29 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234360',`firm_id` = '8',`ordernumber` = 'O24060126943', `product_name` = '游魚轉心瓶8結蛋捲禮盒【國立故宮博物院聯名】',`product_code` = 'DG010394-12',`product_sn` = 'DG010394',`product_spec` = '咖啡蛋捲,巧克力蛋捲',`invoice_name` = '禮盒-故宮(文物款)【咖啡+巧克力】',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '500',`etd` = '2024-07-01',`create_date` = '2024-06-29 16:32:27',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060126943' and product_code = 'DG010394-12' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060127044' and product_code = 'DG010576-71' 2024-06-29 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,'234361','8','O24060127044','【品牌月獨家】經典蛋捲五入組','DG010576-71','DG010576','芝麻x5','組合-32入芝麻x5+紅色提袋x2','1150','1150','0','0','0','1','1','0.0','1','1150','2024-07-01','2024-06-29 16:43:57','2024-06-29 23:59:06',null,'1','2024-05-24') 2024-06-29 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234361',`firm_id` = '8',`ordernumber` = 'O24060127044', `product_name` = '【品牌月獨家】經典蛋捲五入組',`product_code` = 'DG010576-71',`product_sn` = 'DG010576',`product_spec` = '芝麻x5',`invoice_name` = '組合-32入芝麻x5+紅色提袋x2',`listprice` = '1150',`sellingprice` = '1150',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1150',`etd` = '2024-07-01',`create_date` = '2024-06-29 16:43:57',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060127044' and product_code = 'DG010576-71' 2024-06-29 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24060127116' and product_code = 'DG010576-01' 2024-06-29 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,'234362','8','S24060127116','【品牌月獨家】經典蛋捲五入組','DG010576-01','DG010576','原味x5','組合-32入原味x5+紅色提袋x2','1150','1150','0','0','0','1','1','0.0','1','1150','2024-07-02','2024-06-29 17:18:44','2024-06-29 23:59:07',0,'1','2024-05-24') 2024-06-29 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234362',`firm_id` = '8',`ordernumber` = 'S24060127116', `product_name` = '【品牌月獨家】經典蛋捲五入組',`product_code` = 'DG010576-01',`product_sn` = 'DG010576',`product_spec` = '原味x5',`invoice_name` = '組合-32入原味x5+紅色提袋x2',`listprice` = '1150',`sellingprice` = '1150',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1150',`etd` = '2024-07-02',`create_date` = '2024-06-29 17:18:44',`modify_date` = '2024-06-29 17:36:15',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'S24060127116' and product_code = 'DG010576-01' 2024-06-29 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24060127116' and product_code = 'FL010103-01' 2024-06-29 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,'234362','8','S24060127116','加購－一口鳳梅酥','FL010103-01','FL010103','8入鳳梅酥','加購-(盒)鳳梅酥','185','185','1','0','185','1','1','0.0','1','185','2024-07-02','2024-06-29 17:18:44','2024-06-29 23:59:07',0,'1','2024-05-24') 2024-06-29 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234362',`firm_id` = '8',`ordernumber` = 'S24060127116', `product_name` = '加購－一口鳳梅酥',`product_code` = 'FL010103-01',`product_sn` = 'FL010103',`product_spec` = '8入鳳梅酥',`invoice_name` = '加購-(盒)鳳梅酥',`listprice` = '185',`sellingprice` = '185',`isadd` = '1',`isbaby` = '0',`addprice` = '185',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '185',`etd` = '2024-07-02',`create_date` = '2024-06-29 17:18:44',`modify_date` = '2024-06-29 17:36:15',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'S24060127116' and product_code = 'FL010103-01' 2024-06-29 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24060127116' and product_code = 'ZP0101166-01' 2024-06-29 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,'234362','8','S24060127116','贈品-鳳梨酥(新)會員','ZP0101166-01','ZP0101166','贈品-鳳梨酥(新)會員','贈品-鳳梨酥(新)會員','0','0','0','0','0','0','1','0.0','1','0','2024-07-02','2024-06-29 17:18:44','2024-06-29 23:59:07',null,'1','2024-05-24') 2024-06-29 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234362',`firm_id` = '8',`ordernumber` = 'S24060127116', `product_name` = '贈品-鳳梨酥(新)會員',`product_code` = 'ZP0101166-01',`product_sn` = 'ZP0101166',`product_spec` = '贈品-鳳梨酥(新)會員',`invoice_name` = '贈品-鳳梨酥(新)會員',`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` = '2024-07-02',`create_date` = '2024-06-29 17:18:44',`modify_date` = '2024-06-29 17:36:15',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'S24060127116' and product_code = 'ZP0101166-01' 2024-06-29 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060127283' and product_code = 'DG0103148-03' 2024-06-29 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,'234363','8','O24060127283','金典8結禮盒','DG0103148-03','DG0103148','原味+咖啡','禮盒-金典(紅)【原味+咖啡】','480','480','0','0','0','0','1','0.0','5','2400','2024-07-01','2024-06-29 17:23:28','2024-06-29 23:59:07',null,'1','2024-05-24') 2024-06-29 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234363',`firm_id` = '8',`ordernumber` = 'O24060127283', `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` = '5',`total_price` = '2400',`etd` = '2024-07-01',`create_date` = '2024-06-29 17:23:28',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060127283' and product_code = 'DG0103148-03' 2024-06-29 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060127283' and product_code = 'DG010258-02' 2024-06-29 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,'234363','8','O24060127283','金豐收8結提盒','DG010258-02','DG010258','40入芝麻蛋捲','提盒-金豐收(藍)-40入芝麻','295','295','0','0','0','0','1','0.0','4','1180','2024-07-01','2024-06-29 17:23:28','2024-06-29 23:59:07',null,'1','2024-05-24') 2024-06-29 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234363',`firm_id` = '8',`ordernumber` = 'O24060127283', `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` = '4',`total_price` = '1180',`etd` = '2024-07-01',`create_date` = '2024-06-29 17:23:28',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060127283' and product_code = 'DG010258-02' 2024-06-29 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060127283' and product_code = 'ZP0101133-01' 2024-06-29 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,'234363','8','O24060127283','贈品-復古紅提袋','ZP0101133-01','ZP0101133','贈品-復古紅提袋','贈品-［復古］提袋','0','0','0','0','0','0','1','0.0','1','0','2024-07-01','2024-06-29 17:23:28','2024-06-29 23:59:07',null,'1','2024-05-24') 2024-06-29 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234363',`firm_id` = '8',`ordernumber` = 'O24060127283', `product_name` = '贈品-復古紅提袋',`product_code` = 'ZP0101133-01',`product_sn` = 'ZP0101133',`product_spec` = '贈品-復古紅提袋',`invoice_name` = '贈品-［復古］提袋',`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` = '2024-07-01',`create_date` = '2024-06-29 17:23:28',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060127283' and product_code = 'ZP0101133-01' 2024-06-29 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24060127390' and product_code = 'DG010576-126' 2024-06-29 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,'234364','8','S24060127390','【品牌月獨家】經典蛋捲五入組','DG010576-126','DG010576','巧克力x5','組合-32入巧克力x5+紅色提袋x2','1150','1150','0','0','0','1','1','0.0','1','1150','2024-07-02','2024-06-29 17:35:36','2024-06-29 23:59:07',0,'1','2024-05-24') 2024-06-29 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234364',`firm_id` = '8',`ordernumber` = 'S24060127390', `product_name` = '【品牌月獨家】經典蛋捲五入組',`product_code` = 'DG010576-126',`product_sn` = 'DG010576',`product_spec` = '巧克力x5',`invoice_name` = '組合-32入巧克力x5+紅色提袋x2',`listprice` = '1150',`sellingprice` = '1150',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1150',`etd` = '2024-07-02',`create_date` = '2024-06-29 17:35:36',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'S24060127390' and product_code = 'DG010576-126' 2024-06-29 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24060127390' and product_code = 'LS010124-01' 2024-06-29 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,'234364','8','S24060127390','韓式梅子海苔(純素)','LS010124-01','LS010124','韓式梅子海苔','韓式梅子海苔','150','150','0','0','0','0','1','0.0','1','150','2024-07-02','2024-06-29 17:35:36','2024-06-29 23:59:07',0,'1','2024-05-24') 2024-06-29 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234364',`firm_id` = '8',`ordernumber` = 'S24060127390', `product_name` = '韓式梅子海苔(純素)',`product_code` = 'LS010124-01',`product_sn` = 'LS010124',`product_spec` = '韓式梅子海苔',`invoice_name` = '韓式梅子海苔',`listprice` = '150',`sellingprice` = '150',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '150',`etd` = '2024-07-02',`create_date` = '2024-06-29 17:35:36',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'S24060127390' and product_code = 'LS010124-01' 2024-06-29 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060127410' and product_code = 'DG010576-71' 2024-06-29 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,'234365','8','O24060127410','【品牌月獨家】經典蛋捲五入組','DG010576-71','DG010576','芝麻x5','組合-32入芝麻x5+紅色提袋x2','1150','1150','0','0','0','1','1','0.0','1','1150','2024-07-01','2024-06-29 18:32:27','2024-06-29 23:59:07',null,'1','2024-05-24') 2024-06-29 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234365',`firm_id` = '8',`ordernumber` = 'O24060127410', `product_name` = '【品牌月獨家】經典蛋捲五入組',`product_code` = 'DG010576-71',`product_sn` = 'DG010576',`product_spec` = '芝麻x5',`invoice_name` = '組合-32入芝麻x5+紅色提袋x2',`listprice` = '1150',`sellingprice` = '1150',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1150',`etd` = '2024-07-01',`create_date` = '2024-06-29 18:32:27',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060127410' and product_code = 'DG010576-71' 2024-06-29 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060127410' and product_code = 'DG010576-01' 2024-06-29 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,'234365','8','O24060127410','【品牌月獨家】經典蛋捲五入組','DG010576-01','DG010576','原味x5','組合-32入原味x5+紅色提袋x2','1150','1150','0','0','0','1','1','0.0','1','1150','2024-07-01','2024-06-29 18:32:27','2024-06-29 23:59:07',null,'1','2024-05-24') 2024-06-29 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234365',`firm_id` = '8',`ordernumber` = 'O24060127410', `product_name` = '【品牌月獨家】經典蛋捲五入組',`product_code` = 'DG010576-01',`product_sn` = 'DG010576',`product_spec` = '原味x5',`invoice_name` = '組合-32入原味x5+紅色提袋x2',`listprice` = '1150',`sellingprice` = '1150',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1150',`etd` = '2024-07-01',`create_date` = '2024-06-29 18:32:27',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060127410' and product_code = 'DG010576-01' 2024-06-29 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060127410' and product_code = 'DG010576-06' 2024-06-29 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,'234365','8','O24060127410','【品牌月獨家】經典蛋捲五入組','DG010576-06','DG010576','原味x3+芝麻x2','組合-32入(原味x3+芝麻x2)+紅色提袋x2','1150','1150','0','0','0','1','1','0.0','1','1150','2024-07-01','2024-06-29 18:32:27','2024-06-29 23:59:07',null,'1','2024-05-24') 2024-06-29 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234365',`firm_id` = '8',`ordernumber` = 'O24060127410', `product_name` = '【品牌月獨家】經典蛋捲五入組',`product_code` = 'DG010576-06',`product_sn` = 'DG010576',`product_spec` = '原味x3+芝麻x2',`invoice_name` = '組合-32入(原味x3+芝麻x2)+紅色提袋x2',`listprice` = '1150',`sellingprice` = '1150',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1150',`etd` = '2024-07-01',`create_date` = '2024-06-29 18:32:27',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060127410' and product_code = 'DG010576-06' 2024-06-29 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060127410' and product_code = 'ZP0101133-01' 2024-06-29 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,'234365','8','O24060127410','贈品-復古紅提袋','ZP0101133-01','ZP0101133','贈品-復古紅提袋','贈品-［復古］提袋','0','0','0','0','0','0','1','0.0','1','0','2024-07-01','2024-06-29 18:32:27','2024-06-29 23:59:07',null,'1','2024-05-24') 2024-06-29 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234365',`firm_id` = '8',`ordernumber` = 'O24060127410', `product_name` = '贈品-復古紅提袋',`product_code` = 'ZP0101133-01',`product_sn` = 'ZP0101133',`product_spec` = '贈品-復古紅提袋',`invoice_name` = '贈品-［復古］提袋',`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` = '2024-07-01',`create_date` = '2024-06-29 18:32:27',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060127410' and product_code = 'ZP0101133-01' 2024-06-29 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24060127552' and product_code = 'DG0103155-05' 2024-06-29 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,'234366','8','S24060127552','【SNOOPY聯名】友你相伴-8結禮盒','DG0103155-05','DG0103155','原味蛋捲.巧克力蛋捲','禮盒-SNOOPY【原味+巧克力】','500','500','0','0','0','0','1','0.0','2','1000','2024-07-01','2024-06-29 19:30:22','2024-06-29 23:59:07',0,'1','2024-05-24') 2024-06-29 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234366',`firm_id` = '8',`ordernumber` = 'S24060127552', `product_name` = '【SNOOPY聯名】友你相伴-8結禮盒',`product_code` = 'DG0103155-05',`product_sn` = 'DG0103155',`product_spec` = '原味蛋捲.巧克力蛋捲',`invoice_name` = '禮盒-SNOOPY【原味+巧克力】',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '1000',`etd` = '2024-07-01',`create_date` = '2024-06-29 19:30:22',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'S24060127552' and product_code = 'DG0103155-05' 2024-06-29 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060127678' and product_code = 'DG010399-01' 2024-06-29 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,'234367','8','O24060127678','游魚轉心瓶8結蛋捲茶禮盒【國立故宮博物院】','DG010399-01','DG010399','原味蛋捲,阿里山金萱','禮盒-故宮(文物款)【原味+阿里山金萱】','1350','1350','0','0','0','0','1','0.0','1','1350','2024-07-01','2024-06-29 19:52:55','2024-06-29 23:59:07',null,'1','2024-05-24') 2024-06-29 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234367',`firm_id` = '8',`ordernumber` = 'O24060127678', `product_name` = '游魚轉心瓶8結蛋捲茶禮盒【國立故宮博物院】',`product_code` = 'DG010399-01',`product_sn` = 'DG010399',`product_spec` = '原味蛋捲,阿里山金萱',`invoice_name` = '禮盒-故宮(文物款)【原味+阿里山金萱】',`listprice` = '1350',`sellingprice` = '1350',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1350',`etd` = '2024-07-01',`create_date` = '2024-06-29 19:52:55',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060127678' and product_code = 'DG010399-01' 2024-06-29 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060127678' and product_code = 'LS010516-31' 2024-06-29 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,'234367','8','O24060127678','梅子零嘴系列任選八入組','LS010516-31','LS010516','(袋)烏梅絲+(袋)無籽梅肉x5+(袋)梅片x2','組合-(袋)烏梅絲+(袋)無籽梅肉x5+(袋)梅片x2','640','640','0','0','0','1','1','0.0','1','640','2024-07-01','2024-06-29 19:52:55','2024-06-29 23:59:07',null,'1','2024-05-24') 2024-06-29 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234367',`firm_id` = '8',`ordernumber` = 'O24060127678', `product_name` = '梅子零嘴系列任選八入組',`product_code` = 'LS010516-31',`product_sn` = 'LS010516',`product_spec` = '(袋)烏梅絲+(袋)無籽梅肉x5+(袋)梅片x2',`invoice_name` = '組合-(袋)烏梅絲+(袋)無籽梅肉x5+(袋)梅片x2',`listprice` = '640',`sellingprice` = '640',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '640',`etd` = '2024-07-01',`create_date` = '2024-06-29 19:52:55',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060127678' and product_code = 'LS010516-31' 2024-06-29 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060127759' and product_code = 'DG010576-28' 2024-06-29 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,'234368','8','O24060127759','【品牌月獨家】經典蛋捲五入組','DG010576-28','DG010576','原味x2+咖啡x2+巧克力x1','組合-32入(原味x2+咖啡x2+巧克力x1)+紅色提袋x2','1150','1150','0','0','0','1','1','0.0','1','1150','2024-07-01','2024-06-29 20:29:16','2024-06-29 23:59:07',null,'1','2024-05-24') 2024-06-29 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234368',`firm_id` = '8',`ordernumber` = 'O24060127759', `product_name` = '【品牌月獨家】經典蛋捲五入組',`product_code` = 'DG010576-28',`product_sn` = 'DG010576',`product_spec` = '原味x2+咖啡x2+巧克力x1',`invoice_name` = '組合-32入(原味x2+咖啡x2+巧克力x1)+紅色提袋x2',`listprice` = '1150',`sellingprice` = '1150',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1150',`etd` = '2024-07-01',`create_date` = '2024-06-29 20:29:16',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060127759' and product_code = 'DG010576-28' 2024-06-29 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060127759' and product_code = 'DG010576-55' 2024-06-29 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,'234368','8','O24060127759','【品牌月獨家】經典蛋捲五入組','DG010576-55','DG010576','原味x1+芝麻x1+巧克力x3','組合-32入(原味x1+芝麻x1+巧克力x3)+紅色提袋x2','1150','1150','0','0','0','1','1','0.0','1','1150','2024-07-01','2024-06-29 20:29:16','2024-06-29 23:59:07',null,'1','2024-05-24') 2024-06-29 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234368',`firm_id` = '8',`ordernumber` = 'O24060127759', `product_name` = '【品牌月獨家】經典蛋捲五入組',`product_code` = 'DG010576-55',`product_sn` = 'DG010576',`product_spec` = '原味x1+芝麻x1+巧克力x3',`invoice_name` = '組合-32入(原味x1+芝麻x1+巧克力x3)+紅色提袋x2',`listprice` = '1150',`sellingprice` = '1150',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1150',`etd` = '2024-07-01',`create_date` = '2024-06-29 20:29:16',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060127759' and product_code = 'DG010576-55' 2024-06-29 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060127815' and product_code = 'DG010596-02' 2024-06-29 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,'234369','8','O24060127815','台灣經典伴手禮分享組','DG010596-02','DG010596','原味+芝麻','組合-32入(原味+芝麻)+8入鳳梨酥x2+紅提袋x2','780','780','0','0','0','1','1','0.0','1','780','2024-07-01','2024-06-29 23:47:39','2024-06-29 23:59:07',null,'1','2024-05-24') 2024-06-29 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234369',`firm_id` = '8',`ordernumber` = 'O24060127815', `product_name` = '台灣經典伴手禮分享組',`product_code` = 'DG010596-02',`product_sn` = 'DG010596',`product_spec` = '原味+芝麻',`invoice_name` = '組合-32入(原味+芝麻)+8入鳳梨酥x2+紅提袋x2',`listprice` = '780',`sellingprice` = '780',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '780',`etd` = '2024-07-01',`create_date` = '2024-06-29 23:47:39',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060127815' and product_code = 'DG010596-02' 2024-06-29 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060127815' and product_code = 'DG010404-01' 2024-06-29 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,'234369','8','O24060127815','[加購]紅色提袋','DG010404-01','DG010404','-','紅色提袋','10','10','1','0','10','0','0','0.0','1','10','2024-07-01','2024-06-29 23:47:39','2024-06-29 23:59:07',null,'1','2024-05-24') 2024-06-29 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234369',`firm_id` = '8',`ordernumber` = 'O24060127815', `product_name` = '[加購]紅色提袋',`product_code` = 'DG010404-01',`product_sn` = 'DG010404',`product_spec` = '-',`invoice_name` = '紅色提袋',`listprice` = '10',`sellingprice` = '10',`isadd` = '1',`isbaby` = '0',`addprice` = '10',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '10',`etd` = '2024-07-01',`create_date` = '2024-06-29 23:47:39',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060127815' and product_code = 'DG010404-01' 2024-06-29 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060127815' and product_code = 'FL010104-01' 2024-06-29 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,'234369','8','O24060127815','[加購]加購－一口鳳梨酥','FL010104-01','FL010104','-','加購-(盒)鳳梨酥','155','155','1','1','155','0','0','0.0','1','155','2024-07-01','2024-06-29 23:47:39','2024-06-29 23:59:07',null,'1','2024-05-24') 2024-06-29 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234369',`firm_id` = '8',`ordernumber` = 'O24060127815', `product_name` = '[加購]加購－一口鳳梨酥',`product_code` = 'FL010104-01',`product_sn` = 'FL010104',`product_spec` = '-',`invoice_name` = '加購-(盒)鳳梨酥',`listprice` = '155',`sellingprice` = '155',`isadd` = '1',`isbaby` = '1',`addprice` = '155',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '155',`etd` = '2024-07-01',`create_date` = '2024-06-29 23:47:39',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060127815' and product_code = 'FL010104-01' 2024-06-29 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060127955' and product_code = 'DG010523-12' 2024-06-29 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,'234370','8','O24060127955','SNOOPY帶走心意-蛋捲三入組','DG010523-12','DG010523','原味+巧克力+咖啡','組合-32入(原味+咖啡+巧克力)+SNOOPY心意提袋','990','990','0','0','0','1','1','0.0','1','990','2024-07-01','2024-06-29 23:48:59','2024-06-29 23:59:07',null,'1','2024-05-24') 2024-06-29 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234370',`firm_id` = '8',`ordernumber` = 'O24060127955', `product_name` = 'SNOOPY帶走心意-蛋捲三入組',`product_code` = 'DG010523-12',`product_sn` = 'DG010523',`product_spec` = '原味+巧克力+咖啡',`invoice_name` = '組合-32入(原味+咖啡+巧克力)+SNOOPY心意提袋',`listprice` = '990',`sellingprice` = '990',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '990',`etd` = '2024-07-01',`create_date` = '2024-06-29 23:48:59',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060127955' and product_code = 'DG010523-12' 2024-06-29 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060128088' and product_code = 'DG0103181-395' 2024-06-29 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,'234371','8','O24060128088','8結隨享茶點禮盒','DG0103181-395','DG0103181','原味+巧克力,鳳梅酥,無籽梅肉','禮盒-隨享茶點【原味+巧克力】【鳳梅酥+無籽梅肉】','650','650','0','0','0','0','1','0.0','6','3900','2024-07-01','2024-06-29 23:49:03','2024-06-29 23:59:07',null,'1','2024-05-24') 2024-06-29 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234371',`firm_id` = '8',`ordernumber` = 'O24060128088', `product_name` = '8結隨享茶點禮盒',`product_code` = 'DG0103181-395',`product_sn` = 'DG0103181',`product_spec` = '原味+巧克力,鳳梅酥,無籽梅肉',`invoice_name` = '禮盒-隨享茶點【原味+巧克力】【鳳梅酥+無籽梅肉】',`listprice` = '650',`sellingprice` = '650',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '6',`total_price` = '3900',`etd` = '2024-07-01',`create_date` = '2024-06-29 23:49:03',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060128088' and product_code = 'DG0103181-395' 2024-06-29 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060128088' and product_code = 'DG010101-05' 2024-06-29 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,'234371','8','O24060128088','濃情巧克力蛋捲','DG010101-05','DG010101','巧克力','40入巧克力蛋捲','320','280','0','0','0','0','1','280.0','2','560','2024-07-01','2024-06-29 23:49:03','2024-06-29 23:59:07',null,'1','2024-05-24') 2024-06-29 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234371',`firm_id` = '8',`ordernumber` = 'O24060128088', `product_name` = '濃情巧克力蛋捲',`product_code` = 'DG010101-05',`product_sn` = 'DG010101',`product_spec` = '巧克力',`invoice_name` = '40入巧克力蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '2',`total_price` = '560',`etd` = '2024-07-01',`create_date` = '2024-06-29 23:49:03',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060128088' and product_code = 'DG010101-05' 2024-06-29 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060128088' and product_code = 'ZP0101133-01' 2024-06-29 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,'234371','8','O24060128088','贈品-復古紅提袋','ZP0101133-01','ZP0101133','贈品-復古紅提袋','贈品-［復古］提袋','0','0','0','0','0','0','1','0.0','1','0','2024-07-01','2024-06-29 23:49:03','2024-06-29 23:59:07',null,'1','2024-05-24') 2024-06-29 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234371',`firm_id` = '8',`ordernumber` = 'O24060128088', `product_name` = '贈品-復古紅提袋',`product_code` = 'ZP0101133-01',`product_sn` = 'ZP0101133',`product_spec` = '贈品-復古紅提袋',`invoice_name` = '贈品-［復古］提袋',`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` = '2024-07-01',`create_date` = '2024-06-29 23:49:03',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060128088' and product_code = 'ZP0101133-01' 2024-06-29 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060128131' and product_code = 'FL010310-01' 2024-06-29 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,'234372','8','O24060128131','一口酥24入家庭號禮盒','FL010310-01','12586','12入鳳梨酥+12入鳳梅酥','禮盒-24入家庭號【鳳梨酥+鳳梅酥】','540','540','0','0','0','0','1','0.0','1','540','2024-07-01','2024-06-29 23:51:25','2024-06-29 23:59:07',null,'1','2024-05-24') 2024-06-29 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234372',`firm_id` = '8',`ordernumber` = 'O24060128131', `product_name` = '一口酥24入家庭號禮盒',`product_code` = 'FL010310-01',`product_sn` = '12586',`product_spec` = '12入鳳梨酥+12入鳳梅酥',`invoice_name` = '禮盒-24入家庭號【鳳梨酥+鳳梅酥】',`listprice` = '540',`sellingprice` = '540',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '540',`etd` = '2024-07-01',`create_date` = '2024-06-29 23:51:25',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060128131' and product_code = 'FL010310-01' 2024-06-29 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24060128131' and product_code = 'DG010576-55' 2024-06-29 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,'234372','8','O24060128131','【品牌月獨家】經典蛋捲五入組','DG010576-55','DG010576','原味x1+芝麻x1+巧克力x3','組合-32入(原味x1+芝麻x1+巧克力x3)+紅色提袋x2','1150','1150','0','0','0','1','1','0.0','1','1150','2024-07-01','2024-06-29 23:51:25','2024-06-29 23:59:07',null,'1','2024-05-24') 2024-06-29 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234372',`firm_id` = '8',`ordernumber` = 'O24060128131', `product_name` = '【品牌月獨家】經典蛋捲五入組',`product_code` = 'DG010576-55',`product_sn` = 'DG010576',`product_spec` = '原味x1+芝麻x1+巧克力x3',`invoice_name` = '組合-32入(原味x1+芝麻x1+巧克力x3)+紅色提袋x2',`listprice` = '1150',`sellingprice` = '1150',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1150',`etd` = '2024-07-01',`create_date` = '2024-06-29 23:51:25',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-05-24'where ordernumber = 'O24060128131' and product_code = 'DG010576-55' 2024-06-29 23:59:07 -- == sync_order_detail end == 2024-06-29 23:59:07 -- == sync_order start == 2024-06-29 23:59:07 -- start:2024-06-29,end:2024-06-29 2024-06-29 23:59:07 -- == 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 '2024-06-29%' OR l.modify_date like '2024-06-29%'; 2024-06-29 23:59:07 -- == sync omo_order_list == 2024-06-29 23:59:07 -- == update lake.omo_order_list == update omo_order_list set userId = '396599', process_status = '3', pay_status = '1', totalprice_after = '400', lunar_date = '2024-05-13', invoice_status = '1', category_name = '彌月試吃,LINE@訂單', category_id = '2,9' where ordernumber = 'M24060018634' 2024-06-29 23:59:07 -- == 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 ('107309','383835',2,'','','B24060029946','1','1','1','1','1','','','0','0000-00-00','450','0','0','','0','100','9000','104','台北市','中山區','104','台北市','中山區','8450','2024-06-29 12:36:39','2024-05-24') 2024-06-29 23:59:07 -- == 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 ('121878','398221',2,'','','B24060030042','1','11','1','1','1','','','0','0000-00-00','750','0','0','','0','30','15000','950','台東縣','台東市','950','台東縣','台東市','14220','2024-06-29 21:15:18','2024-05-24') 2024-06-29 23:59:07 -- == sync_order end == 2024-06-29 23:59:07 -- == sync_order_detail start == 2024-06-29 23:59:07 -- start:2024-06-29,end:2024-06-29 2024-06-29 23:59:07 -- == sync omo_order_detail == 2024-06-29 23:59:07 -- == SELECT order_detail == SELECT * from order_detail WHERE create_date like '2024-06-29%' OR modify_date like '2024-06-29%' 2024-06-29 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M24060018634' and product_code = 'DG0103157-12' 2024-06-29 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '31501',`firm_id` = '11',`ordernumber` = 'M24060018634', `product_name` = 'SNOOPY(藍)禮盒-彌月試吃【B5】',`product_code` = 'DG0103157-12',`product_sn` = 'DG0103157',`product_spec` = '咖啡+巧克力',`invoice_name` = '禮盒-彌月SNOOPY【咖啡+巧克力】(試吃)',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '500',`etd` = '2024-06-29',`create_date` = '2024-06-18 15:32:03',`modify_date` = '2024-06-29 18:36:56',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M24060018634' and product_code = 'DG0103157-12', `lunar_date` = '2024-05-13' 2024-06-29 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B24060029946' and product_code = 'DG010263-01' 2024-06-29 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,'31624','8','B24060029946','【SNOOPY聯名】美好食光-8結彌月提盒','DG010263-01','DG010263','原味','提盒-彌月SNOOPY-40入原味','300','300','0','1','0','0','1','0.0','30','9000','2024-07-04','2024-06-29 12:36:39','2024-06-29 23:59:08',null,'1','2024-05-24') 2024-06-29 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '31624',`firm_id` = '8',`ordernumber` = 'B24060029946', `product_name` = '【SNOOPY聯名】美好食光-8結彌月提盒',`product_code` = 'DG010263-01',`product_sn` = 'DG010263',`product_spec` = '原味',`invoice_name` = '提盒-彌月SNOOPY-40入原味',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '30',`total_price` = '9000',`etd` = '2024-07-04',`create_date` = '2024-06-29 12:36:39',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B24060029946' and product_code = 'DG010263-01', `lunar_date` = '2024-05-24' 2024-06-29 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B24060029946' and product_code = 'ZP010151-01' 2024-06-29 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,'31624','8','B24060029946','贈品-給足呵護童襪組','ZP010151-01','ZP010151','一組','贈品-sNug寶寶襪/童襪x4(款式隨機)','0','0','0','0','0','0','1','0.0','1','0','2024-07-04','2024-06-29 12:36:39','2024-06-29 23:59:08',null,'1','2024-05-24') 2024-06-29 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '31624',`firm_id` = '8',`ordernumber` = 'B24060029946', `product_name` = '贈品-給足呵護童襪組',`product_code` = 'ZP010151-01',`product_sn` = 'ZP010151',`product_spec` = '一組',`invoice_name` = '贈品-sNug寶寶襪/童襪x4(款式隨機)',`listprice` = '0',`sellingprice` = '0',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '0',`etd` = '2024-07-04',`create_date` = '2024-06-29 12:36:39',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B24060029946' and product_code = 'ZP010151-01', `lunar_date` = '2024-05-24' 2024-06-29 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B24060030042' and product_code = 'DG010263-01' 2024-06-29 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,'31625','8','B24060030042','【SNOOPY聯名】美好食光-8結彌月提盒','DG010263-01','DG010263','原味','提盒-彌月SNOOPY-40入原味','300','300','0','1','0','0','1','0.0','25','7500','2024-07-04','2024-06-29 21:15:18','2024-06-29 23:59:08',null,'1','2024-05-24') 2024-06-29 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '31625',`firm_id` = '8',`ordernumber` = 'B24060030042', `product_name` = '【SNOOPY聯名】美好食光-8結彌月提盒',`product_code` = 'DG010263-01',`product_sn` = 'DG010263',`product_spec` = '原味',`invoice_name` = '提盒-彌月SNOOPY-40入原味',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '25',`total_price` = '7500',`etd` = '2024-07-04',`create_date` = '2024-06-29 21:15:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B24060030042' and product_code = 'DG010263-01', `lunar_date` = '2024-05-24' 2024-06-29 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B24060030042' and product_code = 'DG010263-05' 2024-06-29 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,'31625','8','B24060030042','【SNOOPY聯名】美好食光-8結彌月提盒','DG010263-05','DG010263','巧克力','提盒-彌月SNOOPY-40入巧克力','300','300','0','1','0','0','1','0.0','25','7500','2024-07-04','2024-06-29 21:15:18','2024-06-29 23:59:08',null,'1','2024-05-24') 2024-06-29 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '31625',`firm_id` = '8',`ordernumber` = 'B24060030042', `product_name` = '【SNOOPY聯名】美好食光-8結彌月提盒',`product_code` = 'DG010263-05',`product_sn` = 'DG010263',`product_spec` = '巧克力',`invoice_name` = '提盒-彌月SNOOPY-40入巧克力',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '25',`total_price` = '7500',`etd` = '2024-07-04',`create_date` = '2024-06-29 21:15:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B24060030042' and product_code = 'DG010263-05', `lunar_date` = '2024-05-24' 2024-06-29 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B24060030042' and product_code = 'ZP0101119-01' 2024-06-29 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,'31625','8','B24060030042','贈品-recolte熱感美容儀','ZP0101119-01','ZP0101119','贈品-recolte熱感美容儀','贈品-recolte熱感美容儀','0','0','0','0','0','0','1','0.0','1','0','2024-07-04','2024-06-29 21:15:18','2024-06-29 23:59:08',null,'1','2024-05-24') 2024-06-29 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '31625',`firm_id` = '8',`ordernumber` = 'B24060030042', `product_name` = '贈品-recolte熱感美容儀',`product_code` = 'ZP0101119-01',`product_sn` = 'ZP0101119',`product_spec` = '贈品-recolte熱感美容儀',`invoice_name` = '贈品-recolte熱感美容儀',`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` = '2024-07-04',`create_date` = '2024-06-29 21:15:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B24060030042' and product_code = 'ZP0101119-01', `lunar_date` = '2024-05-24' 2024-06-29 23:59:08 -- == sync_order_detail end == 2024-06-29 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) = '2024-06-29' OR o.updated_at = '2024-06-29') and o.deleted_at is null 2024-06-29 23:59:08 -- == sync_order_detail start == 2024-06-29 23:59:08 -- start:2024-06-29,end:2024-06-29 2024-06-29 23:59:08 -- step1: SELECT id,sku,combinations_product_spec_id FROM `product_specs` 2024-06-29 23:59:09 -- step2: SELECT * FROM `product_specs` WHERE combinations_product_spec_id is not null 2024-06-29 23:59:11 -- step3: SELECT id,product_code,product_sn FROM `omo_order_detail` WHERE `channel` = 6 and product_code like '%,%' and create_date LIKE '2024-06-29%';