2024-07-06 23:59:03 -- == sync_order start == 2024-07-06 23:59:03 -- start:2024-07-06,end:2024-07-06 2024-07-06 23:59:03 -- == select june1.order_list == SELECT l.mid,m.uid,l.category_name,l.category_id,l.ordernumber,l.location,l.payway,l.delivery_way,l.pay_status,l.process_status,l.company_number,l.company_title,l.invoice_status,l.etd,l.web_discount,l.class_discount,l.member_discount,l.web_gift,l.freight,l.entity_discount,l.totalprice,l.orderzip,l.orderaddresscity,l.orderaddressarea,l.recipientzip,l.recipientaddresscity,l.recipientaddressarea,l.totalprice_after-web_discount-class_discount-member_discount-entity_discount as totalprice_after,l.create_date FROM `order_list` l LEFT JOIN member_list m on l.mid = m.id WHERE l.create_date like '2024-07-06%' OR l.modify_date like '2024-07-06%'; 2024-07-06 23:59:05 -- == sync omo_order_list == 2024-07-06 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('363368','399960',1,'','','O24070018253','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','2510','220','新北市','板橋區','220','新北市','板橋區','2660','2024-07-06 03:15:40','2024-06-01') 2024-07-06 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('236422','266641',1,'','','O24070018343','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','150','1680','970','花蓮縣','花蓮市','970','花蓮縣','花蓮市','1680','2024-07-06 06:50:14','2024-06-01') 2024-07-06 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('359785','396408',1,'','','O24070018421','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','295','435','台中市','梧棲區','434','台中市','龍井區','445','2024-07-06 07:55:20','2024-06-01') 2024-07-06 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('28316','178541',1,'','','O24070018522','1','2','1','0','0','','','0','0000-00-00','0','0','0','','150','0','990','438','台中市','外埔區','438','台中市','外埔區','1140','2024-07-06 07:57:50','2024-06-01') 2024-07-06 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('337299','374143',1,'','','O24070018690','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1770','811','高雄市','楠梓區','946','屏東縣','恆春鎮','1920','2024-07-06 08:10:55','2024-06-01') 2024-07-06 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('363371','399963',1,'','','O24070018717','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','350','408','台中市','南屯區','408','台中市','南屯區','470','2024-07-06 08:40:42','2024-06-01') 2024-07-06 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('362298','398901',1,'','','O24070018823','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','3450','643','雲林縣','林內鄉','643','雲林縣','林內鄉','3570','2024-07-06 09:02:57','2024-06-01') 2024-07-06 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('363372','399964',1,'','','O24070018932','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1450','325','桃園市','龍潭區','325','桃園市','龍潭區','1570','2024-07-06 09:55:58','2024-06-01') 2024-07-06 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('363374','399966',1,'','','O24070019057','1','2','1','1','1','','','0','0000-00-00','0','0','0','','150','0','2530','300','新竹市','北區','300','新竹市','北區','2680','2024-07-06 09:58:18','2024-06-01') 2024-07-06 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('362765','399364',1,'','','O24070019117','1','2','1','1','1','','','0','0000-00-00','0','0','0','','150','30','870','646','雲林縣','古坑鄉','640','雲林縣','斗六市','990','2024-07-06 10:47:41','2024-06-01') 2024-07-06 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('362615','399215',1,'','','O24070019268','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1350','540','南投縣','南投市','540','南投縣','南投市','1500','2024-07-06 11:53:46','2024-06-01') 2024-07-06 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('363399','399991',1,'','','O24070019383','1','2','1','1','1','','','0','0000-00-00','0','0','0','','0','30','5750','928','屏東縣','東港鎮','928','屏東縣','東港鎮','5720','2024-07-06 12:31:57','2024-06-01') 2024-07-06 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('59629','33263',1,'','','O24070019462','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','2900','654','雲林縣','四湖鄉','654','雲林縣','四湖鄉','3050','2024-07-06 12:56:37','2024-06-01') 2024-07-06 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('363432','400024',1,'','','O24070019525','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1440','236','新北市','土城區','236','新北市','土城區','1590','2024-07-06 14:44:12','2024-06-01') 2024-07-06 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('363439','400031',1,'永康門市訂單','31','S24070019693','1','1','7','1','1','','','0','2024-07-08','0','0','0','','150','0','3320','106','台北市','大安區','801','高雄市','前金區','3470','2024-07-06 15:07:46','2024-06-01') 2024-07-06 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('363301','399893',1,'','','O24070019727','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','100','1560','236','新北市','土城區','236','新北市','土城區','1610','2024-07-06 15:14:38','2024-06-01') 2024-07-06 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('356383','393026',1,'','','O24070019895','1','2','1','0','0','','','0','0000-00-00','0','0','0','','150','0','2090','238','新北市','樹林區','238','新北市','樹林區','2240','2024-07-06 17:55:36','2024-06-01') 2024-07-06 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('363495','400087',1,'','','O24070019974','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1800','114','台北市','內湖區','114','台北市','內湖區','1920','2024-07-06 18:03:45','2024-06-01') 2024-07-06 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('362985','207481',1,'','','O24070020095','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','480','912','屏東縣','內埔鄉','912','屏東縣','內埔鄉','630','2024-07-06 20:44:47','2024-06-01') 2024-07-06 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('363528','400120',1,'','','O24070020184','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','620','300','新竹市','香山區','300','新竹市','香山區','740','2024-07-06 21:36:14','2024-06-01') 2024-07-06 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('362861','399459',1,'','','O24070020245','1','1','1','1','1','','','0','0000-00-00','459','0','0','','0','30','9180','806','高雄市','前鎮區','807','高雄市','三民區','8691','2024-07-06 21:57:10','2024-06-01') 2024-07-06 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('363530','400122',1,'','','O24070020319','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1440','241','新北市','三重區','241','新北市','三重區','1560','2024-07-06 21:58:36','2024-06-01') 2024-07-06 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('363532','400124',1,'','','O24070020492','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','960','338','桃園市','蘆竹區','920','屏東縣','潮州鎮','1080','2024-07-06 22:58:33','2024-06-01') 2024-07-06 23:59:05 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('363534','400126',1,'','','O24070020521','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','100','2200','523','彰化縣','埤頭鄉','428','台中市','大雅區','2250','2024-07-06 23:30:33','2024-06-01') 2024-07-06 23:59:05 -- == sync_order end == 2024-07-06 23:59:05 -- == sync_order_detail start == 2024-07-06 23:59:05 -- start:2024-07-06,end:2024-07-06 2024-07-06 23:59:05 -- == sync omo_order_detail == 2024-07-06 23:59:05 -- == SELECT order_detail == SELECT * from order_detail WHERE create_date like '2024-07-06%' OR modify_date like '2024-07-06%' 2024-07-06 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070018253' and product_code = 'DG010523-12' 2024-07-06 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,'234590','8','O24070018253','SNOOPY帶走心意-蛋捲三入組','DG010523-12','DG010523','原味+巧克力+咖啡','組合-32入(原味+咖啡+巧克力)+SNOOPY心意提袋','990','990','0','0','0','1','1','0.0','1','990','2024-07-11','2024-07-06 03:15:40','2024-07-06 23:59:06',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234590',`firm_id` = '8',`ordernumber` = 'O24070018253', `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-11',`create_date` = '2024-07-06 03:15:40',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070018253' and product_code = 'DG010523-12' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070018253' and product_code = '03952' 2024-07-06 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,'234590','8','O24070018253','[加購]加購-夏威夷豆軟糖分享包(袋裝15入)','03952','03952','-','加購-(紅袋)夏威夷豆軟糖','290','290','1','1','290','0','0','0.0','1','290','2024-07-11','2024-07-06 03:15:40','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234590',`firm_id` = '8',`ordernumber` = 'O24070018253', `product_name` = '[加購]加購-夏威夷豆軟糖分享包(袋裝15入)',`product_code` = '03952',`product_sn` = '03952',`product_spec` = '-',`invoice_name` = '加購-(紅袋)夏威夷豆軟糖',`listprice` = '290',`sellingprice` = '290',`isadd` = '1',`isbaby` = '1',`addprice` = '290',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '290',`etd` = '2024-07-11',`create_date` = '2024-07-06 03:15:40',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070018253' and product_code = '03952' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070018253' and product_code = '13044' 2024-07-06 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,'234590','8','O24070018253','[加購]加購-香酥醬燒海苔(純素)','13044','13044','-','加購-香酥醬燒海苔(純素)','140','140','1','1','140','0','0','0.0','2','280','2024-07-11','2024-07-06 03:15:40','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234590',`firm_id` = '8',`ordernumber` = 'O24070018253', `product_name` = '[加購]加購-香酥醬燒海苔(純素)',`product_code` = '13044',`product_sn` = '13044',`product_spec` = '-',`invoice_name` = '加購-香酥醬燒海苔(純素)',`listprice` = '140',`sellingprice` = '140',`isadd` = '1',`isbaby` = '1',`addprice` = '140',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '2',`total_price` = '280',`etd` = '2024-07-11',`create_date` = '2024-07-06 03:15:40',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070018253' and product_code = '13044' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070018253' and product_code = '13045' 2024-07-06 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,'234590','8','O24070018253','[加購]加購-厚切椒鹽海苔(純素)','13045','13045','-','加購-厚切椒鹽海苔(純素)','140','140','1','1','140','0','0','0.0','2','280','2024-07-11','2024-07-06 03:15:40','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234590',`firm_id` = '8',`ordernumber` = 'O24070018253', `product_name` = '[加購]加購-厚切椒鹽海苔(純素)',`product_code` = '13045',`product_sn` = '13045',`product_spec` = '-',`invoice_name` = '加購-厚切椒鹽海苔(純素)',`listprice` = '140',`sellingprice` = '140',`isadd` = '1',`isbaby` = '1',`addprice` = '140',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '2',`total_price` = '280',`etd` = '2024-07-11',`create_date` = '2024-07-06 03:15:40',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070018253' and product_code = '13045' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070018253' and product_code = 'LS010108-01' 2024-07-06 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,'234590','8','O24070018253','[加購]加購-原味乳酪絲','LS010108-01','LS010108','-','加購-(藍袋)乳酪絲【原味】','190','190','1','1','190','0','0','0.0','2','380','2024-07-11','2024-07-06 03:15:40','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234590',`firm_id` = '8',`ordernumber` = 'O24070018253', `product_name` = '[加購]加購-原味乳酪絲',`product_code` = 'LS010108-01',`product_sn` = 'LS010108',`product_spec` = '-',`invoice_name` = '加購-(藍袋)乳酪絲【原味】',`listprice` = '190',`sellingprice` = '190',`isadd` = '1',`isbaby` = '1',`addprice` = '190',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '2',`total_price` = '380',`etd` = '2024-07-11',`create_date` = '2024-07-06 03:15:40',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070018253' and product_code = 'LS010108-01' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070018253' and product_code = 'TG010118-01' 2024-07-06 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,'234590','8','O24070018253','[加購]加購-南棗核桃糕分享包','TG010118-01','TG010118','-','加購-(紅袋)南棗核桃糕','290','290','1','1','290','0','0','0.0','1','290','2024-07-11','2024-07-06 03:15:40','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234590',`firm_id` = '8',`ordernumber` = 'O24070018253', `product_name` = '[加購]加購-南棗核桃糕分享包',`product_code` = 'TG010118-01',`product_sn` = 'TG010118',`product_spec` = '-',`invoice_name` = '加購-(紅袋)南棗核桃糕',`listprice` = '290',`sellingprice` = '290',`isadd` = '1',`isbaby` = '1',`addprice` = '290',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '290',`etd` = '2024-07-11',`create_date` = '2024-07-06 03:15:40',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070018253' and product_code = 'TG010118-01' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070018343' and product_code = 'DG010101-03' 2024-07-06 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,'234591','8','O24070018343','極上咖啡蛋捲','DG010101-03','DG010101','咖啡','40入咖啡蛋捲','320','280','0','0','0','0','1','280.0','3','840','2024-07-08','2024-07-06 06:50:14','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234591',`firm_id` = '8',`ordernumber` = 'O24070018343', `product_name` = '極上咖啡蛋捲',`product_code` = 'DG010101-03',`product_sn` = 'DG010101',`product_spec` = '咖啡',`invoice_name` = '40入咖啡蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '3',`total_price` = '840',`etd` = '2024-07-08',`create_date` = '2024-07-06 06:50:14',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070018343' and product_code = 'DG010101-03' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070018343' and product_code = 'DG010101-05' 2024-07-06 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,'234591','8','O24070018343','濃情巧克力蛋捲','DG010101-05','DG010101','巧克力','40入巧克力蛋捲','320','280','0','0','0','0','1','280.0','3','840','2024-07-08','2024-07-06 06:50:14','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234591',`firm_id` = '8',`ordernumber` = 'O24070018343', `product_name` = '濃情巧克力蛋捲',`product_code` = 'DG010101-05',`product_sn` = 'DG010101',`product_spec` = '巧克力',`invoice_name` = '40入巧克力蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '3',`total_price` = '840',`etd` = '2024-07-08',`create_date` = '2024-07-06 06:50:14',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070018343' and product_code = 'DG010101-05' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070018421' and product_code = 'DG010206-01' 2024-07-06 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,'234592','8','O24070018421','8結蛋捲【紅提盒裝】','DG010206-01','DG010206','原味','提盒-品牌(紅)-40入原味蛋捲','295','295','0','0','0','0','1','0.0','1','295','2024-07-08','2024-07-06 07:55:20','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234592',`firm_id` = '8',`ordernumber` = 'O24070018421', `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` = '1',`total_price` = '295',`etd` = '2024-07-08',`create_date` = '2024-07-06 07:55:20',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070018421' and product_code = 'DG010206-01' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070018522' and product_code = 'DG010523-09' 2024-07-06 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,'234593','8','O24070018522','SNOOPY帶走心意-蛋捲三入組','DG010523-09','DG010523','原味+芝麻+巧克力','組合-32入(原味+芝麻+巧克力)+SNOOPY心意提袋','990','990','0','0','0','1','1','0.0','1','990','2024-07-31','2024-07-06 07:57:50','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234593',`firm_id` = '8',`ordernumber` = 'O24070018522', `product_name` = 'SNOOPY帶走心意-蛋捲三入組',`product_code` = 'DG010523-09',`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-31',`create_date` = '2024-07-06 07:57:50',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070018522' and product_code = 'DG010523-09' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070018690' and product_code = 'DG010258-01' 2024-07-06 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,'234594','8','O24070018690','金豐收8結提盒','DG010258-01','DG010258','40入原味蛋捲','提盒-金豐收(藍)-40入原味','295','295','0','0','0','0','1','0.0','2','590','2024-07-08','2024-07-06 08:10:55','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234594',`firm_id` = '8',`ordernumber` = 'O24070018690', `product_name` = '金豐收8結提盒',`product_code` = 'DG010258-01',`product_sn` = 'DG010258',`product_spec` = '40入原味蛋捲',`invoice_name` = '提盒-金豐收(藍)-40入原味',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '590',`etd` = '2024-07-08',`create_date` = '2024-07-06 08:10:55',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070018690' and product_code = 'DG010258-01' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070018690' and product_code = 'DG010204-03' 2024-07-06 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,'234594','8','O24070018690','8結蛋捲【品牌提盒裝】','DG010204-03','DG010204','咖啡','提盒-品牌(橘)-40入咖啡','295','295','0','0','0','0','1','0.0','1','295','2024-07-08','2024-07-06 08:10:55','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234594',`firm_id` = '8',`ordernumber` = 'O24070018690', `product_name` = '8結蛋捲【品牌提盒裝】',`product_code` = 'DG010204-03',`product_sn` = 'DG010204',`product_spec` = '咖啡',`invoice_name` = '提盒-品牌(橘)-40入咖啡',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '295',`etd` = '2024-07-08',`create_date` = '2024-07-06 08:10:55',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070018690' and product_code = 'DG010204-03' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070018690' and product_code = 'DG010204-02' 2024-07-06 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,'234594','8','O24070018690','8結蛋捲【品牌提盒裝】','DG010204-02','DG010204','芝麻','提盒-品牌(橘)-40入芝麻','295','295','0','0','0','0','1','0.0','1','295','2024-07-08','2024-07-06 08:10:55','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234594',`firm_id` = '8',`ordernumber` = 'O24070018690', `product_name` = '8結蛋捲【品牌提盒裝】',`product_code` = 'DG010204-02',`product_sn` = 'DG010204',`product_spec` = '芝麻',`invoice_name` = '提盒-品牌(橘)-40入芝麻',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '295',`etd` = '2024-07-08',`create_date` = '2024-07-06 08:10:55',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070018690' and product_code = 'DG010204-02' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070018690' and product_code = 'DG010204-01' 2024-07-06 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,'234594','8','O24070018690','8結蛋捲【品牌提盒裝】','DG010204-01','DG010204','原味','提盒-品牌(橘)-40入原味','295','295','0','0','0','0','1','0.0','1','295','2024-07-08','2024-07-06 08:10:55','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234594',`firm_id` = '8',`ordernumber` = 'O24070018690', `product_name` = '8結蛋捲【品牌提盒裝】',`product_code` = 'DG010204-01',`product_sn` = 'DG010204',`product_spec` = '原味',`invoice_name` = '提盒-品牌(橘)-40入原味',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '295',`etd` = '2024-07-08',`create_date` = '2024-07-06 08:10:55',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070018690' and product_code = 'DG010204-01' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070018690' and product_code = 'DG010204-05' 2024-07-06 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,'234594','8','O24070018690','8結蛋捲【品牌提盒裝】','DG010204-05','DG010204','巧克力','提盒-品牌(橘)-40入巧克力','295','295','0','0','0','0','1','0.0','1','295','2024-07-08','2024-07-06 08:10:55','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234594',`firm_id` = '8',`ordernumber` = 'O24070018690', `product_name` = '8結蛋捲【品牌提盒裝】',`product_code` = 'DG010204-05',`product_sn` = 'DG010204',`product_spec` = '巧克力',`invoice_name` = '提盒-品牌(橘)-40入巧克力',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '295',`etd` = '2024-07-08',`create_date` = '2024-07-06 08:10:55',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070018690' and product_code = 'DG010204-05' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070018717' and product_code = 'FL010102-01' 2024-07-06 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,'234595','8','O24070018717','一口鳳梨酥','FL010102-01','FL010102','8入鳳梨酥','(盒)鳳梨酥','165','165','0','0','0','0','1','130.0','1','165','2024-07-08','2024-07-06 08:40:42','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234595',`firm_id` = '8',`ordernumber` = 'O24070018717', `product_name` = '一口鳳梨酥',`product_code` = 'FL010102-01',`product_sn` = 'FL010102',`product_spec` = '8入鳳梨酥',`invoice_name` = '(盒)鳳梨酥',`listprice` = '165',`sellingprice` = '165',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '130.0',`amount` = '1',`total_price` = '165',`etd` = '2024-07-08',`create_date` = '2024-07-06 08:40:42',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070018717' and product_code = 'FL010102-01' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070018717' and product_code = 'FL010103-01' 2024-07-06 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,'234595','8','O24070018717','[加購]加購－一口鳳梅酥','FL010103-01','FL010103','-','加購-(盒)鳳梅酥','185','185','1','1','185','0','0','0.0','1','185','2024-07-08','2024-07-06 08:40:42','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234595',`firm_id` = '8',`ordernumber` = 'O24070018717', `product_name` = '[加購]加購－一口鳳梅酥',`product_code` = 'FL010103-01',`product_sn` = 'FL010103',`product_spec` = '-',`invoice_name` = '加購-(盒)鳳梅酥',`listprice` = '185',`sellingprice` = '185',`isadd` = '1',`isbaby` = '1',`addprice` = '185',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '185',`etd` = '2024-07-08',`create_date` = '2024-07-06 08:40:42',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070018717' and product_code = 'FL010103-01' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070018823' and product_code = 'DG0103148-10' 2024-07-06 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,'234596','8','O24070018823','金典8結禮盒','DG0103148-10','DG0103148','咖啡+咖啡','禮盒-金典(紅)【咖啡+咖啡】','480','480','0','0','0','0','1','0.0','1','480','2024-07-08','2024-07-06 09:02:57','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234596',`firm_id` = '8',`ordernumber` = 'O24070018823', `product_name` = '金典8結禮盒',`product_code` = 'DG0103148-10',`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-08',`create_date` = '2024-07-06 09:02:57',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070018823' and product_code = 'DG0103148-10' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070018823' and product_code = 'DG0103148-13' 2024-07-06 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,'234596','8','O24070018823','金典8結禮盒','DG0103148-13','DG0103148','海苔+海苔','禮盒-金典(紅)【海苔+海苔】','480','480','0','0','0','0','1','0.0','1','480','2024-07-08','2024-07-06 09:02:57','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234596',`firm_id` = '8',`ordernumber` = 'O24070018823', `product_name` = '金典8結禮盒',`product_code` = 'DG0103148-13',`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-08',`create_date` = '2024-07-06 09:02:57',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070018823' and product_code = 'DG0103148-13' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070018823' and product_code = 'DG0103148-15' 2024-07-06 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,'234596','8','O24070018823','金典8結禮盒','DG0103148-15','DG0103148','巧克力+巧克力','禮盒-金典(紅)【巧克力+巧克力】','480','480','0','0','0','0','1','0.0','1','480','2024-07-08','2024-07-06 09:02:57','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234596',`firm_id` = '8',`ordernumber` = 'O24070018823', `product_name` = '金典8結禮盒',`product_code` = 'DG0103148-15',`product_sn` = 'DG0103148',`product_spec` = '巧克力+巧克力',`invoice_name` = '禮盒-金典(紅)【巧克力+巧克力】',`listprice` = '480',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '480',`etd` = '2024-07-08',`create_date` = '2024-07-06 09:02:57',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070018823' and product_code = 'DG0103148-15' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070018823' and product_code = 'DG010312-06' 2024-07-06 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,'234596','8','O24070018823','【芝麻＋芝麻】金8結禮盒','DG010312-06','DG010312','金8結盒','禮盒-金8結【芝麻+芝麻】','590','480','0','0','0','0','1','480.0','2','960','2024-07-08','2024-07-06 09:02:57','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234596',`firm_id` = '8',`ordernumber` = 'O24070018823', `product_name` = '【芝麻＋芝麻】金8結禮盒',`product_code` = 'DG010312-06',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【芝麻+芝麻】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '2',`total_price` = '960',`etd` = '2024-07-08',`create_date` = '2024-07-06 09:02:57',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070018823' and product_code = 'DG010312-06' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070018823' and product_code = '13658' 2024-07-06 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,'234596','8','O24070018823','8結蛋捲【紅提袋裝】','13658','13656','40入咖啡蛋捲','組合-40入咖啡+紅提袋','290','290','0','0','0','0','1','0.0','1','290','2024-07-08','2024-07-06 09:02:57','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234596',`firm_id` = '8',`ordernumber` = 'O24070018823', `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-08',`create_date` = '2024-07-06 09:02:57',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070018823' and product_code = '13658' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070018823' and product_code = 'BP010128-01' 2024-07-06 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,'234596','8','O24070018823','8結小禮袋','BP010128-01','BP010128','提袋/個','8結小禮袋','10','10','0','0','0','0','1','0.0','8','80','2024-07-08','2024-07-06 09:02:57','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234596',`firm_id` = '8',`ordernumber` = 'O24070018823', `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` = '8',`total_price` = '80',`etd` = '2024-07-08',`create_date` = '2024-07-06 09:02:57',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070018823' and product_code = 'BP010128-01' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070018823' and product_code = 'FL010103-01' 2024-07-06 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,'234596','8','O24070018823','[加購]加購－一口鳳梅酥','FL010103-01','FL010103','-','加購-(盒)鳳梅酥','185','185','1','1','185','0','0','0.0','2','370','2024-07-08','2024-07-06 09:02:57','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234596',`firm_id` = '8',`ordernumber` = 'O24070018823', `product_name` = '[加購]加購－一口鳳梅酥',`product_code` = 'FL010103-01',`product_sn` = 'FL010103',`product_spec` = '-',`invoice_name` = '加購-(盒)鳳梅酥',`listprice` = '185',`sellingprice` = '185',`isadd` = '1',`isbaby` = '1',`addprice` = '185',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '2',`total_price` = '370',`etd` = '2024-07-08',`create_date` = '2024-07-06 09:02:57',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070018823' and product_code = 'FL010103-01' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070018823' and product_code = 'FL010104-01' 2024-07-06 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,'234596','8','O24070018823','[加購]加購－一口鳳梨酥','FL010104-01','FL010104','-','加購-(盒)鳳梨酥','155','155','1','1','155','0','0','0.0','2','310','2024-07-08','2024-07-06 09:02:57','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234596',`firm_id` = '8',`ordernumber` = 'O24070018823', `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` = '2',`total_price` = '310',`etd` = '2024-07-08',`create_date` = '2024-07-06 09:02:57',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070018823' and product_code = 'FL010104-01' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070018932' and product_code = 'DG010527-05' 2024-07-06 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,'234597','8','O24070018932','8結蛋捲【小禮袋裝】','DG010527-05','DG010527','40入巧克力蛋捲','組合-40入巧克力+8結小禮袋','290','290','0','0','0','0','1','0.0','5','1450','2024-07-08','2024-07-06 09:55:58','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234597',`firm_id` = '8',`ordernumber` = 'O24070018932', `product_name` = '8結蛋捲【小禮袋裝】',`product_code` = 'DG010527-05',`product_sn` = 'DG010527',`product_spec` = '40入巧克力蛋捲',`invoice_name` = '組合-40入巧克力+8結小禮袋',`listprice` = '290',`sellingprice` = '290',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '5',`total_price` = '1450',`etd` = '2024-07-08',`create_date` = '2024-07-06 09:55:58',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070018932' and product_code = 'DG010527-05' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070019057' and product_code = 'LS010516-19' 2024-07-06 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,'234598','8','O24070019057','梅子零嘴系列任選八入組','LS010516-19','LS010516','(袋)烏梅絲x3+(袋)無籽梅肉x2+(袋)梅片x3','組合-(袋)烏梅絲x3+(袋)無籽梅肉x2+(袋)梅片x3','640','640','0','0','0','1','1','0.0','1','640','2024-07-08','2024-07-06 09:58:18','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234598',`firm_id` = '8',`ordernumber` = 'O24070019057', `product_name` = '梅子零嘴系列任選八入組',`product_code` = 'LS010516-19',`product_sn` = 'LS010516',`product_spec` = '(袋)烏梅絲x3+(袋)無籽梅肉x2+(袋)梅片x3',`invoice_name` = '組合-(袋)烏梅絲x3+(袋)無籽梅肉x2+(袋)梅片x3',`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-08',`create_date` = '2024-07-06 09:58:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070019057' and product_code = 'LS010516-19' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070019057' and product_code = 'GG010110-01' 2024-07-06 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,'234598','8','O24070019057','手工腰果脆糖分享包','GG010110-01','GG010110','一組','手工腰果脆糖100g','270','270','0','0','0','0','1','0.0','1','270','2024-07-08','2024-07-06 09:58:18','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234598',`firm_id` = '8',`ordernumber` = 'O24070019057', `product_name` = '手工腰果脆糖分享包',`product_code` = 'GG010110-01',`product_sn` = 'GG010110',`product_spec` = '一組',`invoice_name` = '手工腰果脆糖100g',`listprice` = '270',`sellingprice` = '270',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '270',`etd` = '2024-07-08',`create_date` = '2024-07-06 09:58:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070019057' and product_code = 'GG010110-01' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070019057' and product_code = 'LS010101-01' 2024-07-06 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,'234598','8','O24070019057','分享包-無糖芒果乾','LS010101-01','LS010101','180g芒果乾分享包','(紅袋)芒果乾','360','360','0','0','0','0','1','0.0','1','360','2024-07-08','2024-07-06 09:58:18','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234598',`firm_id` = '8',`ordernumber` = 'O24070019057', `product_name` = '分享包-無糖芒果乾',`product_code` = 'LS010101-01',`product_sn` = 'LS010101',`product_spec` = '180g芒果乾分享包',`invoice_name` = '(紅袋)芒果乾',`listprice` = '360',`sellingprice` = '360',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '360',`etd` = '2024-07-08',`create_date` = '2024-07-06 09:58:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070019057' and product_code = 'LS010101-01' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070019057' and product_code = 'LS010124-01' 2024-07-06 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,'234598','8','O24070019057','韓式梅子海苔(純素)','LS010124-01','LS010124','韓式梅子海苔','韓式梅子海苔','150','150','0','0','0','0','1','0.0','1','150','2024-07-08','2024-07-06 09:58:18','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234598',`firm_id` = '8',`ordernumber` = 'O24070019057', `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-08',`create_date` = '2024-07-06 09:58:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070019057' and product_code = 'LS010124-01' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070019057' and product_code = 'DG010261-02' 2024-07-06 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,'234598','8','O24070019057','【SNOOPY聯名】美好食光-8結提盒','DG010261-02','DG010261','40入芝麻蛋捲','提盒-SNOOPY-40入芝麻','300','300','0','0','0','0','1','0.0','1','300','2024-07-08','2024-07-06 09:58:18','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234598',`firm_id` = '8',`ordernumber` = 'O24070019057', `product_name` = '【SNOOPY聯名】美好食光-8結提盒',`product_code` = 'DG010261-02',`product_sn` = 'DG010261',`product_spec` = '40入芝麻蛋捲',`invoice_name` = '提盒-SNOOPY-40入芝麻',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '300',`etd` = '2024-07-08',`create_date` = '2024-07-06 09:58:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070019057' and product_code = 'DG010261-02' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070019057' and product_code = 'FL010103-01' 2024-07-06 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,'234598','8','O24070019057','[加購]加購－一口鳳梅酥','FL010103-01','FL010103','-','加購-(盒)鳳梅酥','185','185','1','1','185','0','0','0.0','1','185','2024-07-08','2024-07-06 09:58:18','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234598',`firm_id` = '8',`ordernumber` = 'O24070019057', `product_name` = '[加購]加購－一口鳳梅酥',`product_code` = 'FL010103-01',`product_sn` = 'FL010103',`product_spec` = '-',`invoice_name` = '加購-(盒)鳳梅酥',`listprice` = '185',`sellingprice` = '185',`isadd` = '1',`isbaby` = '1',`addprice` = '185',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '185',`etd` = '2024-07-08',`create_date` = '2024-07-06 09:58:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070019057' and product_code = 'FL010103-01' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070019057' and product_code = 'FL010104-01' 2024-07-06 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,'234598','8','O24070019057','[加購]加購－一口鳳梨酥','FL010104-01','FL010104','-','加購-(盒)鳳梨酥','155','155','1','1','155','0','0','0.0','1','155','2024-07-08','2024-07-06 09:58:18','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234598',`firm_id` = '8',`ordernumber` = 'O24070019057', `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-08',`create_date` = '2024-07-06 09:58:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070019057' and product_code = 'FL010104-01' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070019057' and product_code = '13044' 2024-07-06 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,'234598','8','O24070019057','[加購]加購-香酥醬燒海苔(純素)','13044','13044','-','加購-香酥醬燒海苔(純素)','140','140','1','1','140','0','0','0.0','1','140','2024-07-08','2024-07-06 09:58:18','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234598',`firm_id` = '8',`ordernumber` = 'O24070019057', `product_name` = '[加購]加購-香酥醬燒海苔(純素)',`product_code` = '13044',`product_sn` = '13044',`product_spec` = '-',`invoice_name` = '加購-香酥醬燒海苔(純素)',`listprice` = '140',`sellingprice` = '140',`isadd` = '1',`isbaby` = '1',`addprice` = '140',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '140',`etd` = '2024-07-08',`create_date` = '2024-07-06 09:58:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070019057' and product_code = '13044' 2024-07-06 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070019057' and product_code = '13045' 2024-07-06 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'234598','8','O24070019057','[加購]加購-厚切椒鹽海苔(純素)','13045','13045','-','加購-厚切椒鹽海苔(純素)','140','140','1','1','140','0','0','0.0','1','140','2024-07-08','2024-07-06 09:58:18','2024-07-06 23:59:07',null,'1','2024-06-01') 2024-07-06 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234598',`firm_id` = '8',`ordernumber` = 'O24070019057', `product_name` = '[加購]加購-厚切椒鹽海苔(純素)',`product_code` = '13045',`product_sn` = '13045',`product_spec` = '-',`invoice_name` = '加購-厚切椒鹽海苔(純素)',`listprice` = '140',`sellingprice` = '140',`isadd` = '1',`isbaby` = '1',`addprice` = '140',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '140',`etd` = '2024-07-08',`create_date` = '2024-07-06 09:58:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070019057' and product_code = '13045' 2024-07-06 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070019057' and product_code = 'LS010108-01' 2024-07-06 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'234598','8','O24070019057','[加購]加購-原味乳酪絲','LS010108-01','LS010108','-','加購-(藍袋)乳酪絲【原味】','190','190','1','1','190','0','0','0.0','1','190','2024-07-08','2024-07-06 09:58:18','2024-07-06 23:59:08',null,'1','2024-06-01') 2024-07-06 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234598',`firm_id` = '8',`ordernumber` = 'O24070019057', `product_name` = '[加購]加購-原味乳酪絲',`product_code` = 'LS010108-01',`product_sn` = 'LS010108',`product_spec` = '-',`invoice_name` = '加購-(藍袋)乳酪絲【原味】',`listprice` = '190',`sellingprice` = '190',`isadd` = '1',`isbaby` = '1',`addprice` = '190',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '190',`etd` = '2024-07-08',`create_date` = '2024-07-06 09:58:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070019057' and product_code = 'LS010108-01' 2024-07-06 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070019117' and product_code = 'DG010527-04' 2024-07-06 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'234599','8','O24070019117','8結蛋捲【小禮袋裝】','DG010527-04','DG010527','40入海苔蛋捲','組合-40入海苔+8結小禮袋','290','290','0','0','0','0','1','0.0','3','870','2024-07-10','2024-07-06 10:47:41','2024-07-06 23:59:08',null,'1','2024-06-01') 2024-07-06 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234599',`firm_id` = '8',`ordernumber` = 'O24070019117', `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` = '3',`total_price` = '870',`etd` = '2024-07-10',`create_date` = '2024-07-06 10:47:41',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070019117' and product_code = 'DG010527-04' 2024-07-06 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070019268' and product_code = 'DG010523-07' 2024-07-06 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'234600','8','O24070019268','SNOOPY帶走心意-蛋捲三入組','DG010523-07','DG010523','原味+芝麻+咖啡','組合-32入(原味+芝麻+咖啡)+SNOOPY心意提袋','990','990','0','0','0','1','1','0.0','1','990','2024-07-08','2024-07-06 11:53:46','2024-07-06 23:59:08',null,'1','2024-06-01') 2024-07-06 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234600',`firm_id` = '8',`ordernumber` = 'O24070019268', `product_name` = 'SNOOPY帶走心意-蛋捲三入組',`product_code` = 'DG010523-07',`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-08',`create_date` = '2024-07-06 11:53:46',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070019268' and product_code = 'DG010523-07' 2024-07-06 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070019268' and product_code = 'BP010159-01' 2024-07-06 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'234600','8','O24070019268','[加購]加購-SNOOPY提把水瓶','BP010159-01','BP010159','-','加購-SNOOPY提把水瓶','360','360','1','1','360','0','0','0.0','1','360','2024-07-08','2024-07-06 11:53:46','2024-07-06 23:59:08',null,'1','2024-06-01') 2024-07-06 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234600',`firm_id` = '8',`ordernumber` = 'O24070019268', `product_name` = '[加購]加購-SNOOPY提把水瓶',`product_code` = 'BP010159-01',`product_sn` = 'BP010159',`product_spec` = '-',`invoice_name` = '加購-SNOOPY提把水瓶',`listprice` = '360',`sellingprice` = '360',`isadd` = '1',`isbaby` = '1',`addprice` = '360',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '360',`etd` = '2024-07-08',`create_date` = '2024-07-06 11:53:46',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070019268' and product_code = 'BP010159-01' 2024-07-06 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070019383' and product_code = 'DG010315-04' 2024-07-06 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'234601','8','O24070019383','金8結肉酥酥禮盒','DG010315-04','DG010315','原味肉酥酥【芝麻蛋捲】','禮盒-金8結【芝麻+原味肉酥酥】','555','555','0','0','0','0','1','555.0','10','5550','2024-07-08','2024-07-06 12:31:57','2024-07-06 23:59:08',null,'1','2024-06-01') 2024-07-06 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234601',`firm_id` = '8',`ordernumber` = 'O24070019383', `product_name` = '金8結肉酥酥禮盒',`product_code` = 'DG010315-04',`product_sn` = 'DG010315',`product_spec` = '原味肉酥酥【芝麻蛋捲】',`invoice_name` = '禮盒-金8結【芝麻+原味肉酥酥】',`listprice` = '555',`sellingprice` = '555',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '555.0',`amount` = '10',`total_price` = '5550',`etd` = '2024-07-08',`create_date` = '2024-07-06 12:31:57',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070019383' and product_code = 'DG010315-04' 2024-07-06 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070019383' and product_code = 'LS010104-01' 2024-07-06 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'234601','8','O24070019383','分享包-乳酪絲','LS010104-01','LS010104','45g原味乳酪絲','(藍袋)乳酪絲【原味】','200','200','0','0','0','0','1','0.0','1','200','2024-07-08','2024-07-06 12:31:57','2024-07-06 23:59:08',null,'1','2024-06-01') 2024-07-06 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234601',`firm_id` = '8',`ordernumber` = 'O24070019383', `product_name` = '分享包-乳酪絲',`product_code` = 'LS010104-01',`product_sn` = 'LS010104',`product_spec` = '45g原味乳酪絲',`invoice_name` = '(藍袋)乳酪絲【原味】',`listprice` = '200',`sellingprice` = '200',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '200',`etd` = '2024-07-08',`create_date` = '2024-07-06 12:31:57',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070019383' and product_code = 'LS010104-01' 2024-07-06 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070019462' and product_code = '13657' 2024-07-06 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'234602','8','O24070019462','8結蛋捲【紅提袋裝】','13657','13656','40入芝麻蛋捲','組合-40入芝麻+紅提袋','290','290','0','0','0','0','1','0.0','7','2030','2024-09-11','2024-07-06 12:56:37','2024-07-06 23:59:08',null,'1','2024-06-01') 2024-07-06 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234602',`firm_id` = '8',`ordernumber` = 'O24070019462', `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` = '7',`total_price` = '2030',`etd` = '2024-09-11',`create_date` = '2024-07-06 12:56:37',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070019462' and product_code = '13657' 2024-07-06 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070019462' and product_code = '13659' 2024-07-06 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'234602','8','O24070019462','8結蛋捲【紅提袋裝】','13659','13656','40入海苔蛋捲','組合-40入海苔+紅提袋','290','290','0','0','0','0','1','0.0','3','870','2024-09-11','2024-07-06 12:56:37','2024-07-06 23:59:08',null,'1','2024-06-01') 2024-07-06 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234602',`firm_id` = '8',`ordernumber` = 'O24070019462', `product_name` = '8結蛋捲【紅提袋裝】',`product_code` = '13659',`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-09-11',`create_date` = '2024-07-06 12:56:37',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070019462' and product_code = '13659' 2024-07-06 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070019525' and product_code = 'DG010312-12' 2024-07-06 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'234603','8','O24070019525','【咖啡+巧克力】金8結禮盒','DG010312-12','DG010312','金8結盒','禮盒-金8結【咖啡+巧克力】','590','480','0','0','0','0','1','480.0','1','480','2024-07-08','2024-07-06 14:44:12','2024-07-06 23:59:08',null,'1','2024-06-01') 2024-07-06 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234603',`firm_id` = '8',`ordernumber` = 'O24070019525', `product_name` = '【咖啡+巧克力】金8結禮盒',`product_code` = 'DG010312-12',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【咖啡+巧克力】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2024-07-08',`create_date` = '2024-07-06 14:44:12',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070019525' and product_code = 'DG010312-12' 2024-07-06 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070019525' and product_code = 'DG010312-08' 2024-07-06 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'234603','8','O24070019525','【芝麻+海苔】金8結禮盒','DG010312-08','DG010312','金8結盒','禮盒-金8結【芝麻+海苔】','590','480','0','0','0','0','1','480.0','1','480','2024-07-08','2024-07-06 14:44:12','2024-07-06 23:59:08',null,'1','2024-06-01') 2024-07-06 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234603',`firm_id` = '8',`ordernumber` = 'O24070019525', `product_name` = '【芝麻+海苔】金8結禮盒',`product_code` = 'DG010312-08',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【芝麻+海苔】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2024-07-08',`create_date` = '2024-07-06 14:44:12',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070019525' and product_code = 'DG010312-08' 2024-07-06 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070019525' and product_code = 'DG010312-01' 2024-07-06 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'234603','8','O24070019525','【原味＋原味】金8結禮盒','DG010312-01','DG010312','金8結盒','禮盒-金8結【原味+原味】','590','480','0','0','0','0','1','480.0','1','480','2024-07-08','2024-07-06 14:44:12','2024-07-06 23:59:08',null,'1','2024-06-01') 2024-07-06 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234603',`firm_id` = '8',`ordernumber` = 'O24070019525', `product_name` = '【原味＋原味】金8結禮盒',`product_code` = 'DG010312-01',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+原味】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2024-07-08',`create_date` = '2024-07-06 14:44:12',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070019525' and product_code = 'DG010312-01' 2024-07-06 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24070019693' and product_code = 'DG010101-01' 2024-07-06 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'234604','8','S24070019693','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','5','1400','2024-07-08','2024-07-06 15:07:46','2024-07-06 23:59:08',0,'1','2024-06-01') 2024-07-06 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234604',`firm_id` = '8',`ordernumber` = 'S24070019693', `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` = '5',`total_price` = '1400',`etd` = '2024-07-08',`create_date` = '2024-07-06 15:07:46',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'S24070019693' and product_code = 'DG010101-01' 2024-07-06 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24070019693' and product_code = 'DG010312-01' 2024-07-06 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'234604','8','S24070019693','【原味＋原味】金8結禮盒','DG010312-01','DG010312','金8結盒','禮盒-金8結【原味+原味】','590','480','0','0','0','0','1','480.0','3','1440','2024-07-08','2024-07-06 15:07:46','2024-07-06 23:59:08',0,'1','2024-06-01') 2024-07-06 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234604',`firm_id` = '8',`ordernumber` = 'S24070019693', `product_name` = '【原味＋原味】金8結禮盒',`product_code` = 'DG010312-01',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+原味】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '3',`total_price` = '1440',`etd` = '2024-07-08',`create_date` = '2024-07-06 15:07:46',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'S24070019693' and product_code = 'DG010312-01' 2024-07-06 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24070019693' and product_code = 'DG010312-13' 2024-07-06 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'234604','8','S24070019693','【海苔＋海苔】金8結禮盒','DG010312-13','DG010312','金8結盒','禮盒-金8結【海苔+海苔】','590','480','0','0','0','0','1','480.0','1','480','2024-07-08','2024-07-06 15:07:46','2024-07-06 23:59:08',0,'1','2024-06-01') 2024-07-06 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234604',`firm_id` = '8',`ordernumber` = 'S24070019693', `product_name` = '【海苔＋海苔】金8結禮盒',`product_code` = 'DG010312-13',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【海苔+海苔】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2024-07-08',`create_date` = '2024-07-06 15:07:46',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'S24070019693' and product_code = 'DG010312-13' 2024-07-06 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070019727' and product_code = 'DG010101-04' 2024-07-06 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'234605','8','O24070019727','日式海苔蛋捲','DG010101-04','DG010101','單盒','40入海苔蛋捲','320','280','0','0','0','0','1','280.0','1','280','2024-07-29','2024-07-06 15:14:38','2024-07-06 23:59:08',null,'1','2024-06-01') 2024-07-06 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234605',`firm_id` = '8',`ordernumber` = 'O24070019727', `product_name` = '日式海苔蛋捲',`product_code` = 'DG010101-04',`product_sn` = 'DG010101',`product_spec` = '單盒',`invoice_name` = '40入海苔蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2024-07-29',`create_date` = '2024-07-06 15:14:38',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070019727' and product_code = 'DG010101-04' 2024-07-06 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070019727' and product_code = 'DG010101-03' 2024-07-06 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'234605','8','O24070019727','極上咖啡蛋捲','DG010101-03','DG010101','咖啡','40入咖啡蛋捲','320','280','0','0','0','0','1','280.0','1','280','2024-07-29','2024-07-06 15:14:38','2024-07-06 23:59:08',null,'1','2024-06-01') 2024-07-06 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234605',`firm_id` = '8',`ordernumber` = 'O24070019727', `product_name` = '極上咖啡蛋捲',`product_code` = 'DG010101-03',`product_sn` = 'DG010101',`product_spec` = '咖啡',`invoice_name` = '40入咖啡蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2024-07-29',`create_date` = '2024-07-06 15:14:38',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070019727' and product_code = 'DG010101-03' 2024-07-06 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070019727' and product_code = 'DG0103155-05' 2024-07-06 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'234605','8','O24070019727','【SNOOPY聯名】友你相伴-8結禮盒','DG0103155-05','DG0103155','原味蛋捲,巧克力蛋捲','禮盒-SNOOPY【原味+巧克力】','500','500','0','0','0','0','1','0.0','2','1000','2024-07-29','2024-07-06 15:14:38','2024-07-06 23:59:08',null,'1','2024-06-01') 2024-07-06 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234605',`firm_id` = '8',`ordernumber` = 'O24070019727', `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-29',`create_date` = '2024-07-06 15:14:38',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070019727' and product_code = 'DG0103155-05' 2024-07-06 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070019895' and product_code = 'DG0105101-01' 2024-07-06 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'234606','8','O24070019895','【期間限定】限定人氣伴手禮組','DG0105101-01','DG0105101','原味蛋捲+鳳梨酥+復古紅提袋','組合-32入原味+8入鳳梨酥+［復古］提袋','565','565','0','0','0','0','1','0.0','2','1130','2024-07-12','2024-07-06 17:55:36','2024-07-06 23:59:08',null,'1','2024-06-01') 2024-07-06 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234606',`firm_id` = '8',`ordernumber` = 'O24070019895', `product_name` = '【期間限定】限定人氣伴手禮組',`product_code` = 'DG0105101-01',`product_sn` = 'DG0105101',`product_spec` = '原味蛋捲+鳳梨酥+復古紅提袋',`invoice_name` = '組合-32入原味+8入鳳梨酥+［復古］提袋',`listprice` = '565',`sellingprice` = '565',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '1130',`etd` = '2024-07-12',`create_date` = '2024-07-06 17:55:36',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070019895' and product_code = 'DG0105101-01' 2024-07-06 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070019895' and product_code = 'DG010312-05' 2024-07-06 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'234606','8','O24070019895','【原味+巧克力】金8結禮盒','DG010312-05','DG010312','金8結盒','禮盒-金8結【原味+巧克力】','590','480','0','0','0','0','1','480.0','2','960','2024-07-12','2024-07-06 17:55:36','2024-07-06 23:59:08',null,'1','2024-06-01') 2024-07-06 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234606',`firm_id` = '8',`ordernumber` = 'O24070019895', `product_name` = '【原味+巧克力】金8結禮盒',`product_code` = 'DG010312-05',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+巧克力】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '2',`total_price` = '960',`etd` = '2024-07-12',`create_date` = '2024-07-06 17:55:36',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070019895' and product_code = 'DG010312-05' 2024-07-06 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070019974' and product_code = 'DG010261-01' 2024-07-06 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'234607','8','O24070019974','【SNOOPY聯名】美好食光-8結提盒','DG010261-01','DG010261','40入原味蛋捲','提盒-SNOOPY-40入原味','300','300','0','0','0','0','1','0.0','6','1800','2024-07-08','2024-07-06 18:03:45','2024-07-06 23:59:08',null,'1','2024-06-01') 2024-07-06 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234607',`firm_id` = '8',`ordernumber` = 'O24070019974', `product_name` = '【SNOOPY聯名】美好食光-8結提盒',`product_code` = 'DG010261-01',`product_sn` = 'DG010261',`product_spec` = '40入原味蛋捲',`invoice_name` = '提盒-SNOOPY-40入原味',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '6',`total_price` = '1800',`etd` = '2024-07-08',`create_date` = '2024-07-06 18:03:45',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070019974' and product_code = 'DG010261-01' 2024-07-06 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070020095' and product_code = 'DG010312-05' 2024-07-06 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'234608','8','O24070020095','【原味+巧克力】金8結禮盒','DG010312-05','DG010312','金8結盒','禮盒-金8結【原味+巧克力】','590','480','0','0','0','0','1','480.0','1','480','2024-07-08','2024-07-06 20:44:47','2024-07-06 23:59:08',null,'1','2024-06-01') 2024-07-06 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234608',`firm_id` = '8',`ordernumber` = 'O24070020095', `product_name` = '【原味+巧克力】金8結禮盒',`product_code` = 'DG010312-05',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+巧克力】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2024-07-08',`create_date` = '2024-07-06 20:44:47',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070020095' and product_code = 'DG010312-05' 2024-07-06 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070020184' and product_code = 'DG0103182-426' 2024-07-06 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'234609','8','O24070020184','金巧8結禮盒','DG0103182-426','DG0103182','巧克力,鳳梨酥,黑松露腰果','禮盒-金巧8結【(巧克力)-鳳梨酥+黑松露腰果】','620','620','0','0','0','0','1','0.0','1','620','2024-07-16','2024-07-06 21:36:14','2024-07-06 23:59:08',null,'1','2024-06-01') 2024-07-06 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234609',`firm_id` = '8',`ordernumber` = 'O24070020184', `product_name` = '金巧8結禮盒',`product_code` = 'DG0103182-426',`product_sn` = 'DG0103182',`product_spec` = '巧克力,鳳梨酥,黑松露腰果',`invoice_name` = '禮盒-金巧8結【(巧克力)-鳳梨酥+黑松露腰果】',`listprice` = '620',`sellingprice` = '620',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '620',`etd` = '2024-07-16',`create_date` = '2024-07-06 21:36:14',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070020184' and product_code = 'DG0103182-426' 2024-07-06 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070020245' and product_code = '13658' 2024-07-06 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'234610','8','O24070020245','8結蛋捲【紅提袋裝】','13658','13656','40入咖啡蛋捲','組合-40入咖啡+紅提袋','290','290','0','0','0','0','1','0.0','2','580','2024-07-12','2024-07-06 21:57:10','2024-07-06 23:59:08',null,'1','2024-06-01') 2024-07-06 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234610',`firm_id` = '8',`ordernumber` = 'O24070020245', `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-12',`create_date` = '2024-07-06 21:57:10',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070020245' and product_code = '13658' 2024-07-06 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070020245' and product_code = '13660' 2024-07-06 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'234610','8','O24070020245','8結蛋捲【紅提袋裝】','13660','13656','40入巧克力蛋捲','組合-40入巧克力+紅提袋','290','290','0','0','0','0','1','0.0','28','8120','2024-07-12','2024-07-06 21:57:10','2024-07-06 23:59:08',null,'1','2024-06-01') 2024-07-06 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234610',`firm_id` = '8',`ordernumber` = 'O24070020245', `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` = '28',`total_price` = '8120',`etd` = '2024-07-12',`create_date` = '2024-07-06 21:57:10',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070020245' and product_code = '13660' 2024-07-06 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070020245' and product_code = 'DG010312-09' 2024-07-06 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'234610','8','O24070020245','【芝麻+巧克力】金8結禮盒','DG010312-09','DG010312','金8結盒','禮盒-金8結【芝麻+巧克力】','590','480','0','0','0','0','1','480.0','1','480','2024-07-12','2024-07-06 21:57:10','2024-07-06 23:59:08',null,'1','2024-06-01') 2024-07-06 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234610',`firm_id` = '8',`ordernumber` = 'O24070020245', `product_name` = '【芝麻+巧克力】金8結禮盒',`product_code` = 'DG010312-09',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【芝麻+巧克力】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2024-07-12',`create_date` = '2024-07-06 21:57:10',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070020245' and product_code = 'DG010312-09' 2024-07-06 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070020319' and product_code = 'DG0103148-05' 2024-07-06 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'234611','8','O24070020319','金典8結禮盒','DG0103148-05','DG0103148','原味+巧克力','禮盒-金典(紅)【原味+巧克力】','480','480','0','0','0','0','1','0.0','3','1440','2024-07-09','2024-07-06 21:58:36','2024-07-06 23:59:08',null,'1','2024-06-01') 2024-07-06 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234611',`firm_id` = '8',`ordernumber` = 'O24070020319', `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` = '3',`total_price` = '1440',`etd` = '2024-07-09',`create_date` = '2024-07-06 21:58:36',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070020319' and product_code = 'DG0103148-05' 2024-07-06 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070020492' and product_code = 'DG010312-07' 2024-07-06 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'234612','8','O24070020492','【芝麻+咖啡】金8結禮盒','DG010312-07','DG010312','金8結盒','禮盒-金8結【芝麻+咖啡】','590','480','0','0','0','0','1','480.0','1','480','2024-07-08','2024-07-06 22:58:33','2024-07-06 23:59:08',null,'1','2024-06-01') 2024-07-06 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234612',`firm_id` = '8',`ordernumber` = 'O24070020492', `product_name` = '【芝麻+咖啡】金8結禮盒',`product_code` = 'DG010312-07',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【芝麻+咖啡】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2024-07-08',`create_date` = '2024-07-06 22:58:33',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070020492' and product_code = 'DG010312-07' 2024-07-06 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070020492' and product_code = 'DG010312-02' 2024-07-06 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'234612','8','O24070020492','【原味+芝麻】金8結禮盒','DG010312-02','DG010312','金8結盒','禮盒-金8結【原味+芝麻】','590','480','0','0','0','0','1','480.0','1','480','2024-07-08','2024-07-06 22:58:33','2024-07-06 23:59:08',null,'1','2024-06-01') 2024-07-06 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234612',`firm_id` = '8',`ordernumber` = 'O24070020492', `product_name` = '【原味+芝麻】金8結禮盒',`product_code` = 'DG010312-02',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+芝麻】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2024-07-08',`create_date` = '2024-07-06 22:58:33',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070020492' and product_code = 'DG010312-02' 2024-07-06 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070020521' and product_code = 'DG0103148-05' 2024-07-06 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'234613','8','O24070020521','金典8結禮盒','DG0103148-05','DG0103148','原味+巧克力','禮盒-金典(紅)【原味+巧克力】','480','480','0','0','0','0','1','0.0','1','480','2024-07-08','2024-07-06 23:30:33','2024-07-06 23:59:08',null,'1','2024-06-01') 2024-07-06 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234613',`firm_id` = '8',`ordernumber` = 'O24070020521', `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-08',`create_date` = '2024-07-06 23:30:33',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070020521' and product_code = 'DG0103148-05' 2024-07-06 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070020521' and product_code = 'DG0103182-04' 2024-07-06 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'234613','8','O24070020521','金巧8結禮盒','DG0103182-04','DG0103182','原味,鳳梨酥,芝麻糕','禮盒-金巧8結【(原味)-鳳梨酥+芝麻糕】','580','580','0','0','0','0','1','0.0','2','1160','2024-07-08','2024-07-06 23:30:33','2024-07-06 23:59:08',null,'1','2024-06-01') 2024-07-06 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234613',`firm_id` = '8',`ordernumber` = 'O24070020521', `product_name` = '金巧8結禮盒',`product_code` = 'DG0103182-04',`product_sn` = 'DG0103182',`product_spec` = '原味,鳳梨酥,芝麻糕',`invoice_name` = '禮盒-金巧8結【(原味)-鳳梨酥+芝麻糕】',`listprice` = '580',`sellingprice` = '580',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '1160',`etd` = '2024-07-08',`create_date` = '2024-07-06 23:30:33',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070020521' and product_code = 'DG0103182-04' 2024-07-06 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070020521' and product_code = 'DG010101-01' 2024-07-06 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'234613','8','O24070020521','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','1','280','2024-07-08','2024-07-06 23:30:33','2024-07-06 23:59:08',null,'1','2024-06-01') 2024-07-06 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234613',`firm_id` = '8',`ordernumber` = 'O24070020521', `product_name` = '經典原味蛋捲',`product_code` = 'DG010101-01',`product_sn` = 'DG010101',`product_spec` = '原味',`invoice_name` = '40入原味蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2024-07-08',`create_date` = '2024-07-06 23:30:33',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070020521' and product_code = 'DG010101-01' 2024-07-06 23:59:08 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24070020521' and product_code = 'DG010101-03' 2024-07-06 23:59:08 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'234613','8','O24070020521','極上咖啡蛋捲','DG010101-03','DG010101','咖啡','40入咖啡蛋捲','320','280','0','0','0','0','1','280.0','1','280','2024-07-08','2024-07-06 23:30:33','2024-07-06 23:59:08',null,'1','2024-06-01') 2024-07-06 23:59:08 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '234613',`firm_id` = '8',`ordernumber` = 'O24070020521', `product_name` = '極上咖啡蛋捲',`product_code` = 'DG010101-03',`product_sn` = 'DG010101',`product_spec` = '咖啡',`invoice_name` = '40入咖啡蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2024-07-08',`create_date` = '2024-07-06 23:30:33',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-06-01'where ordernumber = 'O24070020521' and product_code = 'DG010101-03' 2024-07-06 23:59:08 -- == sync_order_detail end == 2024-07-06 23:59:08 -- == sync_order start == 2024-07-06 23:59:08 -- start:2024-07-06,end:2024-07-06 2024-07-06 23:59:08 -- == select june1.order_list == select l.mid,m.uid,l.category_name,l.category_id,l.ordernumber,l.location,l.payway,l.delivery_way,l.pay_status,l.process_status,l.company_number,l.company_title,l.invoice_status,l.etd,l.web_discount,l.class_discount,l.member_discount,l.web_gift,l.freight,l.entity_discount,l.totalprice,l.orderzip,l.orderaddresscity,l.orderaddressarea,l.recipientzip,l.recipientaddresscity,l.recipientaddressarea,l.totalprice_after-web_discount-class_discount-member_discount-entity_discount as totalprice_after,l.create_date FROM `order_list` l LEFT JOIN member_list m on l.mid = m.id WHERE l.create_date like '2024-07-06%' OR l.modify_date like '2024-07-06%'; 2024-07-06 23:59:09 -- == sync omo_order_list == 2024-07-06 23:59:09 -- == update lake.omo_order_list == update omo_order_list set userId = '399255', process_status = '3', pay_status = '8', totalprice_after = '400', lunar_date = '2024-05-26', invoice_status = '0', category_name = '彌月試吃,LINE@訂單', category_id = '2,9' where ordernumber = 'M24070001552' 2024-07-06 23:59:09 -- == update lake.omo_order_list == update omo_order_list set userId = '399473', process_status = '3', pay_status = '8', totalprice_after = '900', lunar_date = '2024-05-28', invoice_status = '1', category_name = '彌月試吃,LINE@訂單', category_id = '2,9' where ordernumber = 'M24070003311' 2024-07-06 23:59:09 -- == sync_order end == 2024-07-06 23:59:09 -- == sync_order_detail start == 2024-07-06 23:59:09 -- start:2024-07-06,end:2024-07-06 2024-07-06 23:59:09 -- == sync omo_order_detail == 2024-07-06 23:59:09 -- == SELECT order_detail == SELECT * from order_detail WHERE create_date like '2024-07-06%' OR modify_date like '2024-07-06%' 2024-07-06 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M24070001552' and product_code = 'DG0103157-02' 2024-07-06 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '31641',`firm_id` = '11',`ordernumber` = 'M24070001552', `product_name` = 'SNOOPY(藍)禮盒-彌月試吃【B4】',`product_code` = 'DG0103157-02',`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-07-05',`create_date` = '2024-07-01 13:30:10',`modify_date` = '2024-07-06 16:40:22',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M24070001552' and product_code = 'DG0103157-02', `lunar_date` = '2024-05-26' 2024-07-06 23:59:09 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M24070003311' and product_code = '05484 ' 2024-07-06 23:59:09 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '31661',`firm_id` = '11',`ordernumber` = 'M24070003311', `product_name` = '龍飛鳳舞(鳳梨酥) 彌月試吃體驗組(贈寶寶襪)【Z1】',`product_code` = '05484 ',`product_sn` = '05437',`product_spec` = '原味+芝麻+巧克力.辣味肉酥酥',`invoice_name` = '組合-8入(原味+芝麻+巧克力)+70g辣味肉酥酥+鳳梨酥+黑松露腰果+芝麻糕+寶寶襪一雙',`listprice` = '900',`sellingprice` = '900',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '900',`etd` = '2024-07-05',`create_date` = '2024-07-03 10:27:50',`modify_date` = '2024-07-06 13:23:12',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M24070003311' and product_code = '05484 ', `lunar_date` = '2024-05-28' 2024-07-06 23:59:09 -- == sync_order_detail end == 2024-07-06 23:59:09 -- == select one.order_list == SELECT o.code,o.pay_status,o.order_status,o.user_id,o.pay_method_id,o.activity_freight_id,o.freight_fee,o.items_total,o.total,DATE(o.shipped_at) as shipped_at,o.created_at as create_date, inv.company_number,inv.company_title,inv.invoice_status, cust.zipcode,cust.county,cust.district, rec.zipcode as recipientzip,rec.county as recipientaddresscity,rec.district as recipientaddressarea, af.type as freight_type FROM `orders` o LEFT JOIN systemlead_invoices inv on o.id = inv.order_id LEFT JOIN order_customers cust on o.id = cust.order_id LEFT JOIN order_receivers rec on o.id = rec.order_id LEFT JOIN activity_freights af on o.activity_freight_id = af.id WHERE (DATE(o.created_at) = '2024-07-06' OR o.updated_at = '2024-07-06') and o.deleted_at is null 2024-07-06 23:59:09 -- == sync_order_detail start == 2024-07-06 23:59:09 -- start:2024-07-06,end:2024-07-06 2024-07-06 23:59:09 -- step1: SELECT id,sku,combinations_product_spec_id FROM `product_specs` 2024-07-06 23:59:10 -- step2: SELECT * FROM `product_specs` WHERE combinations_product_spec_id is not null 2024-07-06 23:59:13 -- step3: SELECT id,product_code,product_sn FROM `omo_order_detail` WHERE `channel` = 6 and product_code like '%,%' and create_date LIKE '2024-07-06%';