2024-09-17 23:59:02 -- == sync_order start == 2024-09-17 23:59:02 -- start:2024-09-17,end:2024-09-17 2024-09-17 23:59:02 -- == select june1.order_list == SELECT l.mid,m.uid,l.category_name,l.category_id,l.ordernumber,l.location,l.payway,l.delivery_way,l.pay_status,l.process_status,l.company_number,l.company_title,l.invoice_status,l.etd,l.web_discount,l.class_discount,l.member_discount,l.web_gift,l.freight,l.entity_discount,l.totalprice,l.orderzip,l.orderaddresscity,l.orderaddressarea,l.recipientzip,l.recipientaddresscity,l.recipientaddressarea,l.totalprice_after-web_discount-class_discount-member_discount-entity_discount as totalprice_after,l.create_date FROM `order_list` l LEFT JOIN member_list m on l.mid = m.id WHERE l.create_date like '2024-09-17%' OR l.modify_date like '2024-09-17%'; 2024-09-17 23:59:03 -- == sync omo_order_list == 2024-09-17 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('303970','341237',1,'','','O24090240945','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','550','407','台中市','西屯區','640','雲林縣','斗六市','700','2024-09-17 00:44:58','2024-08-15') 2024-09-17 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('384763','421089',1,'','','O24090241080','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1800','825','高雄市','橋頭區','825','高雄市','橋頭區','1920','2024-09-17 11:42:49','2024-08-15') 2024-09-17 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('144132','112107',1,'','','O24090241196','1','2','1','1','1','','','0','0000-00-00','0','0','0','','150','0','480','411','台中市','太平區','402','台中市','南區','630','2024-09-17 12:24:46','2024-08-15') 2024-09-17 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('385214','421540',1,'','','O24090241289','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','840','413','台中市','霧峰區','702','台南市','南區','960','2024-09-17 12:59:43','2024-08-15') 2024-09-17 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('385190','421517',1,'','','O24090241376','1','1','1','0','0','','','0','0000-00-00','0','0','0','','150','0','1920','251','新北市','淡水區','251','新北市','淡水區','2070','2024-09-17 14:04:51','2024-08-15') 2024-09-17 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('385190','421517',1,'','','O24090241418','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1920','251','新北市','淡水區','251','新北市','淡水區','2040','2024-09-17 14:11:47','2024-08-15') 2024-09-17 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('385218','421544',1,'','','O24090241572','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','960','333','桃園市','龜山區','333','桃園市','龜山區','1080','2024-09-17 15:36:57','2024-08-15') 2024-09-17 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('180408','146983',1,'','','O24090241699','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','970','300','新竹市','香山區','300','新竹市','香山區','1120','2024-09-17 16:50:11','2024-08-15') 2024-09-17 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('97083','68269',1,'','','O24090241786','1','1','1','1','1','91666686','寶貝我愛你童裝服飾用品店蓮埔營業所','0','0000-00-00','0','0','0','','0','0','5960','330','桃園市','桃園區','330','桃園市','桃園區','5960','2024-09-17 17:47:47','2024-08-15') 2024-09-17 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('380082','258387',1,'','','O24090241839','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','2400','406','台中市','北屯區','406','台中市','北屯區','2550','2024-09-17 18:05:23','2024-08-15') 2024-09-17 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('385230','421556',1,'','','O24090241945','1','1','1','1','1','','','0','0000-00-00','0','0','0','','0','30','5900','330','桃園市','桃園區','330','桃園市','桃園區','5870','2024-09-17 18:47:09','2024-08-15') 2024-09-17 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('368342','404881',1,'','','O24090242080','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1150','328','桃園市','觀音區','328','桃園市','觀音區','1300','2024-09-17 18:48:53','2024-08-15') 2024-09-17 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('384643','420971',1,'','','O24090242119','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1355','239','新北市','鶯歌區','239','新北市','鶯歌區','1475','2024-09-17 19:42:41','2024-08-15') 2024-09-17 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('385234','421560',1,'','','O24090242226','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1160','830','高雄市','鳳山區','830','高雄市','鳳山區','1280','2024-09-17 19:51:12','2024-08-15') 2024-09-17 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('385236','421562',1,'','','O24090242361','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','500','900','屏東縣','屏東市','900','屏東縣','屏東市','620','2024-09-17 20:09:10','2024-08-15') 2024-09-17 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('385235','421561',1,'','','O24090242462','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1920','542','南投縣','草屯鎮','542','南投縣','草屯鎮','2070','2024-09-17 20:09:32','2024-08-15') 2024-09-17 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('176241','143012',1,'','','O24090242540','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','500','510','彰化縣','員林市','110','台北市','信義區','650','2024-09-17 21:16:41','2024-08-15') 2024-09-17 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('385240','421566',1,'','','O24090242680','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1480','108','台北市','萬華區','804','高雄市','鼓山區','1600','2024-09-17 21:55:11','2024-08-15') 2024-09-17 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('385241','421567',1,'','','O24090242785','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1460','545','南投縣','埔里鎮','545','南投縣','埔里鎮','1580','2024-09-17 22:32:00','2024-08-15') 2024-09-17 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('375301','411764',1,'','','O24090242883','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','960','406','台中市','北屯區','406','台中市','北屯區','1080','2024-09-17 22:46:05','2024-08-15') 2024-09-17 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('88945','60757',1,'','','O24090242921','1','2','1','1','1','','','0','0000-00-00','1600','0','0','','0','0','32000','701','台南市','東區','701','台南市','東區','30400','2024-09-17 23:49:46','2024-08-15') 2024-09-17 23:59:03 -- == sync_order end == 2024-09-17 23:59:03 -- == sync_order_detail start == 2024-09-17 23:59:03 -- start:2024-09-17,end:2024-09-17 2024-09-17 23:59:03 -- == sync omo_order_detail == 2024-09-17 23:59:03 -- == SELECT order_detail == SELECT * from order_detail WHERE create_date like '2024-09-17%' OR modify_date like '2024-09-17%' 2024-09-17 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090240945' and product_code = 'TG010104-01' 2024-09-17 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248737','8','O24090240945','夏威夷豆軟糖','TG010104-01','TG010104','10入夏威夷豆軟糖','(盒)夏威夷豆軟糖','220','220','0','0','0','0','1','220.0','1','220','2024-09-24','2024-09-17 00:44:58','2024-09-17 23:59:05',null,'1','2024-08-15') 2024-09-17 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248737',`firm_id` = '8',`ordernumber` = 'O24090240945', `product_name` = '夏威夷豆軟糖',`product_code` = 'TG010104-01',`product_sn` = 'TG010104',`product_spec` = '10入夏威夷豆軟糖',`invoice_name` = '(盒)夏威夷豆軟糖',`listprice` = '220',`sellingprice` = '220',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '220.0',`amount` = '1',`total_price` = '220',`etd` = '2024-09-24',`create_date` = '2024-09-17 00:44:58',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090240945' and product_code = 'TG010104-01' 2024-09-17 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090240945' and product_code = 'TG010119-01' 2024-09-17 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248737','8','O24090240945','南棗核桃糕','TG010119-01','TG010119','12入核棗糕','(盒)南棗核桃糕','180','180','0','0','0','0','1','0.0','1','180','2024-09-24','2024-09-17 00:44:58','2024-09-17 23:59:05',null,'1','2024-08-15') 2024-09-17 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248737',`firm_id` = '8',`ordernumber` = 'O24090240945', `product_name` = '南棗核桃糕',`product_code` = 'TG010119-01',`product_sn` = 'TG010119',`product_spec` = '12入核棗糕',`invoice_name` = '(盒)南棗核桃糕',`listprice` = '180',`sellingprice` = '180',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '180',`etd` = '2024-09-24',`create_date` = '2024-09-17 00:44:58',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090240945' and product_code = 'TG010119-01' 2024-09-17 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090240945' and product_code = 'TG010102-01' 2024-09-17 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248737','8','O24090240945','黑曜芝麻糕(全素)','TG010102-01','TG010102','12入芝麻糕','(盒)芝麻糕','150','150','0','0','0','0','1','150.0','1','150','2024-09-24','2024-09-17 00:44:58','2024-09-17 23:59:05',null,'1','2024-08-15') 2024-09-17 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248737',`firm_id` = '8',`ordernumber` = 'O24090240945', `product_name` = '黑曜芝麻糕(全素)',`product_code` = 'TG010102-01',`product_sn` = 'TG010102',`product_spec` = '12入芝麻糕',`invoice_name` = '(盒)芝麻糕',`listprice` = '150',`sellingprice` = '150',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '150.0',`amount` = '1',`total_price` = '150',`etd` = '2024-09-24',`create_date` = '2024-09-17 00:44:58',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090240945' and product_code = 'TG010102-01' 2024-09-17 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090241080' and product_code = 'DG010265-01' 2024-09-17 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248738','8','O24090241080','【預購-9/19後出貨】SNOOPY獨特心意-8結提盒','DG010265-01','DG010265','原味','提盒-SNOOPY(粉)-40入原味','300','300','0','0','0','0','1','0.0','2','600','2024-09-23','2024-09-17 11:42:49','2024-09-17 23:59:05',null,'1','2024-08-15') 2024-09-17 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248738',`firm_id` = '8',`ordernumber` = 'O24090241080', `product_name` = '【預購-9/19後出貨】SNOOPY獨特心意-8結提盒',`product_code` = 'DG010265-01',`product_sn` = 'DG010265',`product_spec` = '原味',`invoice_name` = '提盒-SNOOPY(粉)-40入原味',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '600',`etd` = '2024-09-23',`create_date` = '2024-09-17 11:42:49',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090241080' and product_code = 'DG010265-01' 2024-09-17 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090241080' and product_code = 'DG010265-02' 2024-09-17 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248738','8','O24090241080','【預購-9/19後出貨】SNOOPY獨特心意-8結提盒','DG010265-02','DG010265','芝麻','提盒-SNOOPY(粉)-40入芝麻','300','300','0','0','0','0','1','0.0','2','600','2024-09-23','2024-09-17 11:42:49','2024-09-17 23:59:05',null,'1','2024-08-15') 2024-09-17 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248738',`firm_id` = '8',`ordernumber` = 'O24090241080', `product_name` = '【預購-9/19後出貨】SNOOPY獨特心意-8結提盒',`product_code` = 'DG010265-02',`product_sn` = 'DG010265',`product_spec` = '芝麻',`invoice_name` = '提盒-SNOOPY(粉)-40入芝麻',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '600',`etd` = '2024-09-23',`create_date` = '2024-09-17 11:42:49',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090241080' and product_code = 'DG010265-02' 2024-09-17 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090241080' and product_code = 'DG010265-04' 2024-09-17 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248738','8','O24090241080','【預購-9/19後出貨】SNOOPY獨特心意-8結提盒','DG010265-04','DG010265','海苔','提盒-SNOOPY(粉)-40入海苔','300','300','0','0','0','0','1','0.0','2','600','2024-09-23','2024-09-17 11:42:49','2024-09-17 23:59:05',null,'1','2024-08-15') 2024-09-17 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248738',`firm_id` = '8',`ordernumber` = 'O24090241080', `product_name` = '【預購-9/19後出貨】SNOOPY獨特心意-8結提盒',`product_code` = 'DG010265-04',`product_sn` = 'DG010265',`product_spec` = '海苔',`invoice_name` = '提盒-SNOOPY(粉)-40入海苔',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '600',`etd` = '2024-09-23',`create_date` = '2024-09-17 11:42:49',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090241080' and product_code = 'DG010265-04' 2024-09-17 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090241196' and product_code = 'DG010312-02' 2024-09-17 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248739','8','O24090241196','【原味+芝麻】金8結禮盒','DG010312-02','DG010312','金8結盒','禮盒-金8結【原味+芝麻】','590','480','0','0','0','0','1','480.0','1','480','2024-09-23','2024-09-17 12:24:46','2024-09-17 23:59:05',null,'1','2024-08-15') 2024-09-17 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248739',`firm_id` = '8',`ordernumber` = 'O24090241196', `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-09-23',`create_date` = '2024-09-17 12:24:46',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090241196' and product_code = 'DG010312-02' 2024-09-17 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090241289' and product_code = 'DG010101-05' 2024-09-17 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248740','8','O24090241289','濃情巧克力蛋捲','DG010101-05','DG010101','巧克力','40入巧克力蛋捲','320','280','0','0','0','0','1','280.0','2','560','2024-09-23','2024-09-17 12:59:43','2024-09-17 23:59:05',null,'1','2024-08-15') 2024-09-17 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248740',`firm_id` = '8',`ordernumber` = 'O24090241289', `product_name` = '濃情巧克力蛋捲',`product_code` = 'DG010101-05',`product_sn` = 'DG010101',`product_spec` = '巧克力',`invoice_name` = '40入巧克力蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '2',`total_price` = '560',`etd` = '2024-09-23',`create_date` = '2024-09-17 12:59:43',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090241289' and product_code = 'DG010101-05' 2024-09-17 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090241289' and product_code = 'DG010101-03' 2024-09-17 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248740','8','O24090241289','極上咖啡蛋捲','DG010101-03','DG010101','咖啡','40入咖啡蛋捲','320','280','0','0','0','0','1','280.0','1','280','2024-09-23','2024-09-17 12:59:43','2024-09-17 23:59:05',null,'1','2024-08-15') 2024-09-17 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248740',`firm_id` = '8',`ordernumber` = 'O24090241289', `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-09-23',`create_date` = '2024-09-17 12:59:43',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090241289' and product_code = 'DG010101-03' 2024-09-17 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090241376' and product_code = 'DG010312-03' 2024-09-17 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248741','8','O24090241376','【原味+咖啡】金8結禮盒','DG010312-03','DG010312','金8結盒','禮盒-金8結【原味+咖啡】','590','480','0','0','0','0','1','480.0','1','480','2024-09-23','2024-09-17 14:04:51','2024-09-17 23:59:05',null,'1','2024-08-15') 2024-09-17 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248741',`firm_id` = '8',`ordernumber` = 'O24090241376', `product_name` = '【原味+咖啡】金8結禮盒',`product_code` = 'DG010312-03',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+咖啡】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2024-09-23',`create_date` = '2024-09-17 14:04:51',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090241376' and product_code = 'DG010312-03' 2024-09-17 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090241376' and product_code = 'DG010312-05' 2024-09-17 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248741','8','O24090241376','【原味+巧克力】金8結禮盒','DG010312-05','DG010312','金8結盒','禮盒-金8結【原味+巧克力】','590','480','0','0','0','0','1','480.0','3','1440','2024-09-23','2024-09-17 14:04:51','2024-09-17 23:59:05',null,'1','2024-08-15') 2024-09-17 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248741',`firm_id` = '8',`ordernumber` = 'O24090241376', `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` = '3',`total_price` = '1440',`etd` = '2024-09-23',`create_date` = '2024-09-17 14:04:51',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090241376' and product_code = 'DG010312-05' 2024-09-17 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090241418' and product_code = 'DG010312-09' 2024-09-17 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248742','8','O24090241418','【芝麻+巧克力】金8結禮盒','DG010312-09','DG010312','金8結盒','禮盒-金8結【芝麻+巧克力】','590','480','0','0','0','0','1','480.0','2','960','2024-09-23','2024-09-17 14:11:47','2024-09-17 23:59:05',null,'1','2024-08-15') 2024-09-17 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248742',`firm_id` = '8',`ordernumber` = 'O24090241418', `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` = '2',`total_price` = '960',`etd` = '2024-09-23',`create_date` = '2024-09-17 14:11:47',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090241418' and product_code = 'DG010312-09' 2024-09-17 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090241418' and product_code = 'DG010312-05' 2024-09-17 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248742','8','O24090241418','【原味+巧克力】金8結禮盒','DG010312-05','DG010312','金8結盒','禮盒-金8結【原味+巧克力】','590','480','0','0','0','0','1','480.0','1','480','2024-09-23','2024-09-17 14:11:47','2024-09-17 23:59:05',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248742',`firm_id` = '8',`ordernumber` = 'O24090241418', `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-09-23',`create_date` = '2024-09-17 14:11:47',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090241418' and product_code = 'DG010312-05' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090241418' and product_code = 'DG010312-03' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248742','8','O24090241418','【原味+咖啡】金8結禮盒','DG010312-03','DG010312','金8結盒','禮盒-金8結【原味+咖啡】','590','480','0','0','0','0','1','480.0','1','480','2024-09-23','2024-09-17 14:11:47','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248742',`firm_id` = '8',`ordernumber` = 'O24090241418', `product_name` = '【原味+咖啡】金8結禮盒',`product_code` = 'DG010312-03',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+咖啡】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2024-09-23',`create_date` = '2024-09-17 14:11:47',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090241418' and product_code = 'DG010312-03' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090241572' and product_code = 'DG010312-05' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248743','8','O24090241572','【原味+巧克力】金8結禮盒','DG010312-05','DG010312','金8結盒','禮盒-金8結【原味+巧克力】','590','480','0','0','0','0','1','480.0','2','960','2024-09-23','2024-09-17 15:36:57','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248743',`firm_id` = '8',`ordernumber` = 'O24090241572', `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-09-23',`create_date` = '2024-09-17 15:36:57',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090241572' and product_code = 'DG010312-05' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090241699' and product_code = 'DG010312-03' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248744','8','O24090241699','【原味+咖啡】金8結禮盒','DG010312-03','DG010312','金8結盒','禮盒-金8結【原味+咖啡】','590','480','0','0','0','0','1','480.0','2','960','2024-09-23','2024-09-17 16:50:11','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248744',`firm_id` = '8',`ordernumber` = 'O24090241699', `product_name` = '【原味+咖啡】金8結禮盒',`product_code` = 'DG010312-03',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+咖啡】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '2',`total_price` = '960',`etd` = '2024-09-23',`create_date` = '2024-09-17 16:50:11',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090241699' and product_code = 'DG010312-03' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090241699' and product_code = 'BP010128-01' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248744','8','O24090241699','8結小禮袋','BP010128-01','BP010128','提袋/個','8結小禮袋','10','10','0','0','0','0','1','0.0','1','10','2024-09-23','2024-09-17 16:50:11','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248744',`firm_id` = '8',`ordernumber` = 'O24090241699', `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` = '1',`total_price` = '10',`etd` = '2024-09-23',`create_date` = '2024-09-17 16:50:11',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090241699' and product_code = 'BP010128-01' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090241786' and product_code = 'DG010258-01' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248745','8','O24090241786','金豐收8結提盒','DG010258-01','DG010258','40入原味蛋捲','提盒-金豐收(藍)-40入原味','295','295','0','0','0','0','1','0.0','2','590','2024-09-23','2024-09-17 17:47:47','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248745',`firm_id` = '8',`ordernumber` = 'O24090241786', `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-09-23',`create_date` = '2024-09-17 17:47:47',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090241786' and product_code = 'DG010258-01' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090241786' and product_code = 'DG010265-01' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248745','8','O24090241786','【預購-9/19後出貨】SNOOPY獨特心意-8結提盒','DG010265-01','DG010265','原味','提盒-SNOOPY(粉)-40入原味','300','300','0','0','0','0','1','0.0','8','2400','2024-09-23','2024-09-17 17:47:47','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248745',`firm_id` = '8',`ordernumber` = 'O24090241786', `product_name` = '【預購-9/19後出貨】SNOOPY獨特心意-8結提盒',`product_code` = 'DG010265-01',`product_sn` = 'DG010265',`product_spec` = '原味',`invoice_name` = '提盒-SNOOPY(粉)-40入原味',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '8',`total_price` = '2400',`etd` = '2024-09-23',`create_date` = '2024-09-17 17:47:47',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090241786' and product_code = 'DG010265-01' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090241786' and product_code = 'DG010265-05' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248745','8','O24090241786','【預購-9/19後出貨】SNOOPY獨特心意-8結提盒','DG010265-05','DG010265','巧克力','提盒-SNOOPY(粉)-40入巧克力','300','300','0','0','0','0','1','0.0','2','600','2024-09-23','2024-09-17 17:47:47','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248745',`firm_id` = '8',`ordernumber` = 'O24090241786', `product_name` = '【預購-9/19後出貨】SNOOPY獨特心意-8結提盒',`product_code` = 'DG010265-05',`product_sn` = 'DG010265',`product_spec` = '巧克力',`invoice_name` = '提盒-SNOOPY(粉)-40入巧克力',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '600',`etd` = '2024-09-23',`create_date` = '2024-09-17 17:47:47',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090241786' and product_code = 'DG010265-05' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090241786' and product_code = 'DG010206-01' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248745','8','O24090241786','8結蛋捲【紅提盒裝】','DG010206-01','DG010206','原味','提盒-品牌(紅)-40入原味蛋捲','295','295','0','0','0','0','1','0.0','2','590','2024-09-23','2024-09-17 17:47:47','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248745',`firm_id` = '8',`ordernumber` = 'O24090241786', `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` = '2',`total_price` = '590',`etd` = '2024-09-23',`create_date` = '2024-09-17 17:47:47',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090241786' and product_code = 'DG010206-01' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090241786' and product_code = 'DG010206-02' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248745','8','O24090241786','8結蛋捲【紅提盒裝】','DG010206-02','DG010206','芝麻','提盒-品牌(紅)-40入芝麻蛋捲','295','295','0','0','0','0','1','0.0','3','885','2024-09-23','2024-09-17 17:47:47','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248745',`firm_id` = '8',`ordernumber` = 'O24090241786', `product_name` = '8結蛋捲【紅提盒裝】',`product_code` = 'DG010206-02',`product_sn` = 'DG010206',`product_spec` = '芝麻',`invoice_name` = '提盒-品牌(紅)-40入芝麻蛋捲',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '3',`total_price` = '885',`etd` = '2024-09-23',`create_date` = '2024-09-17 17:47:47',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090241786' and product_code = 'DG010206-02' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090241786' and product_code = 'DG010206-03' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248745','8','O24090241786','8結蛋捲【紅提盒裝】','DG010206-03','DG010206','咖啡','提盒-品牌(紅)-40入咖啡蛋捲','295','295','0','0','0','0','1','0.0','1','295','2024-09-23','2024-09-17 17:47:47','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248745',`firm_id` = '8',`ordernumber` = 'O24090241786', `product_name` = '8結蛋捲【紅提盒裝】',`product_code` = 'DG010206-03',`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-09-23',`create_date` = '2024-09-17 17:47:47',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090241786' and product_code = 'DG010206-03' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090241786' and product_code = 'DG010268-05' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248745','8','O24090241786','【吳淡如聯名】築夢-8結提盒','DG010268-05','DG010268','巧克力','提盒-吳淡如-40入巧克力','300','300','0','0','0','0','1','0.0','1','300','2024-09-23','2024-09-17 17:47:47','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248745',`firm_id` = '8',`ordernumber` = 'O24090241786', `product_name` = '【吳淡如聯名】築夢-8結提盒',`product_code` = 'DG010268-05',`product_sn` = 'DG010268',`product_spec` = '巧克力',`invoice_name` = '提盒-吳淡如-40入巧克力',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '300',`etd` = '2024-09-23',`create_date` = '2024-09-17 17:47:47',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090241786' and product_code = 'DG010268-05' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090241786' and product_code = 'DG010226-01' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248745','8','O24090241786','蓮花式溫碗8結蛋捲提盒【國立故宮博物院】','DG010226-01','DG010226','40入原味蛋捲','提盒-故宮(文物款)-40入原味','300','300','0','0','0','0','1','0.0','1','300','2024-09-23','2024-09-17 17:47:47','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248745',`firm_id` = '8',`ordernumber` = 'O24090241786', `product_name` = '蓮花式溫碗8結蛋捲提盒【國立故宮博物院】',`product_code` = 'DG010226-01',`product_sn` = 'DG010226',`product_spec` = '40入原味蛋捲',`invoice_name` = '提盒-故宮(文物款)-40入原味',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '300',`etd` = '2024-09-23',`create_date` = '2024-09-17 17:47:47',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090241786' and product_code = 'DG010226-01' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090241839' and product_code = 'DG010312-05' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248746','8','O24090241839','【原味+巧克力】金8結禮盒','DG010312-05','DG010312','金8結盒','禮盒-金8結【原味+巧克力】','590','480','0','0','0','0','1','480.0','5','2400','2024-09-23','2024-09-17 18:05:23','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248746',`firm_id` = '8',`ordernumber` = 'O24090241839', `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` = '5',`total_price` = '2400',`etd` = '2024-09-23',`create_date` = '2024-09-17 18:05:23',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090241839' and product_code = 'DG010312-05' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090241945' and product_code = 'DG010206-01' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248747','8','O24090241945','8結蛋捲【紅提盒裝】','DG010206-01','DG010206','原味','提盒-品牌(紅)-40入原味蛋捲','295','295','0','0','0','0','1','0.0','5','1475','2024-09-23','2024-09-17 18:47:09','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248747',`firm_id` = '8',`ordernumber` = 'O24090241945', `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` = '5',`total_price` = '1475',`etd` = '2024-09-23',`create_date` = '2024-09-17 18:47:09',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090241945' and product_code = 'DG010206-01' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090241945' and product_code = 'DG010206-02' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248747','8','O24090241945','8結蛋捲【紅提盒裝】','DG010206-02','DG010206','芝麻','提盒-品牌(紅)-40入芝麻蛋捲','295','295','0','0','0','0','1','0.0','5','1475','2024-09-23','2024-09-17 18:47:09','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248747',`firm_id` = '8',`ordernumber` = 'O24090241945', `product_name` = '8結蛋捲【紅提盒裝】',`product_code` = 'DG010206-02',`product_sn` = 'DG010206',`product_spec` = '芝麻',`invoice_name` = '提盒-品牌(紅)-40入芝麻蛋捲',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '5',`total_price` = '1475',`etd` = '2024-09-23',`create_date` = '2024-09-17 18:47:09',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090241945' and product_code = 'DG010206-02' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090241945' and product_code = 'DG010206-03' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248747','8','O24090241945','8結蛋捲【紅提盒裝】','DG010206-03','DG010206','咖啡','提盒-品牌(紅)-40入咖啡蛋捲','295','295','0','0','0','0','1','0.0','5','1475','2024-09-23','2024-09-17 18:47:09','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248747',`firm_id` = '8',`ordernumber` = 'O24090241945', `product_name` = '8結蛋捲【紅提盒裝】',`product_code` = 'DG010206-03',`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` = '5',`total_price` = '1475',`etd` = '2024-09-23',`create_date` = '2024-09-17 18:47:09',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090241945' and product_code = 'DG010206-03' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090241945' and product_code = 'DG010206-04' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248747','8','O24090241945','8結蛋捲【紅提盒裝】','DG010206-04','DG010206','海苔','提盒-品牌(紅)-40入海苔蛋捲','295','295','0','0','0','0','1','0.0','5','1475','2024-09-23','2024-09-17 18:47:09','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248747',`firm_id` = '8',`ordernumber` = 'O24090241945', `product_name` = '8結蛋捲【紅提盒裝】',`product_code` = 'DG010206-04',`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` = '5',`total_price` = '1475',`etd` = '2024-09-23',`create_date` = '2024-09-17 18:47:09',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090241945' and product_code = 'DG010206-04' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090242080' and product_code = 'DG0103191-06' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248748','8','O24090242080','【預購-9/19後出貨】SNOOPY美好探尋-8結肉酥酥禮','DG0103191-06','DG0103191','芝麻蛋捲,辣味肉酥酥','禮盒-SNOOPY(橘)【芝麻+辣味肉酥酥】','575','575','0','0','0','0','1','0.0','2','1150','2024-09-23','2024-09-17 18:48:53','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248748',`firm_id` = '8',`ordernumber` = 'O24090242080', `product_name` = '【預購-9/19後出貨】SNOOPY美好探尋-8結肉酥酥禮',`product_code` = 'DG0103191-06',`product_sn` = 'DG0103191',`product_spec` = '芝麻蛋捲,辣味肉酥酥',`invoice_name` = '禮盒-SNOOPY(橘)【芝麻+辣味肉酥酥】',`listprice` = '575',`sellingprice` = '575',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '1150',`etd` = '2024-09-23',`create_date` = '2024-09-17 18:48:53',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090242080' and product_code = 'DG0103191-06' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090242119' and product_code = 'DG0103191-02' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248749','8','O24090242119','【預購-9/19後出貨】SNOOPY美好探尋-8結肉酥酥禮','DG0103191-02','DG0103191','原味蛋捲,原辣肉酥酥','禮盒-SNOOPY(橘)【原味+原辣肉酥酥】','575','575','0','0','0','0','1','0.0','1','575','2024-09-23','2024-09-17 19:42:41','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248749',`firm_id` = '8',`ordernumber` = 'O24090242119', `product_name` = '【預購-9/19後出貨】SNOOPY美好探尋-8結肉酥酥禮',`product_code` = 'DG0103191-02',`product_sn` = 'DG0103191',`product_spec` = '原味蛋捲,原辣肉酥酥',`invoice_name` = '禮盒-SNOOPY(橘)【原味+原辣肉酥酥】',`listprice` = '575',`sellingprice` = '575',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '575',`etd` = '2024-09-23',`create_date` = '2024-09-17 19:42:41',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090242119' and product_code = 'DG0103191-02' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090242119' and product_code = 'DG010312-05' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248749','8','O24090242119','【原味+巧克力】金8結禮盒','DG010312-05','DG010312','金8結盒','禮盒-金8結【原味+巧克力】','590','480','0','0','0','0','1','480.0','1','480','2024-09-23','2024-09-17 19:42:41','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248749',`firm_id` = '8',`ordernumber` = 'O24090242119', `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-09-23',`create_date` = '2024-09-17 19:42:41',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090242119' and product_code = 'DG010312-05' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090242119' and product_code = 'DG010265-01' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248749','8','O24090242119','【預購-9/19後出貨】SNOOPY獨特心意-8結提盒','DG010265-01','DG010265','原味','提盒-SNOOPY(粉)-40入原味','300','300','0','0','0','0','1','0.0','1','300','2024-09-23','2024-09-17 19:42:41','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248749',`firm_id` = '8',`ordernumber` = 'O24090242119', `product_name` = '【預購-9/19後出貨】SNOOPY獨特心意-8結提盒',`product_code` = 'DG010265-01',`product_sn` = 'DG010265',`product_spec` = '原味',`invoice_name` = '提盒-SNOOPY(粉)-40入原味',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '300',`etd` = '2024-09-23',`create_date` = '2024-09-17 19:42:41',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090242119' and product_code = 'DG010265-01' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090242226' and product_code = 'DG010527-01' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248750','8','O24090242226','8結蛋捲【小禮袋裝】','DG010527-01','DG010527','40入原味蛋捲','組合-40入原味+8結小禮袋','290','290','0','0','0','0','1','0.0','4','1160','2024-09-23','2024-09-17 19:51:12','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248750',`firm_id` = '8',`ordernumber` = 'O24090242226', `product_name` = '8結蛋捲【小禮袋裝】',`product_code` = 'DG010527-01',`product_sn` = 'DG010527',`product_spec` = '40入原味蛋捲',`invoice_name` = '組合-40入原味+8結小禮袋',`listprice` = '290',`sellingprice` = '290',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '4',`total_price` = '1160',`etd` = '2024-09-23',`create_date` = '2024-09-17 19:51:12',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090242226' and product_code = 'DG010527-01' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090242361' and product_code = 'DG010394-03' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248751','8','O24090242361','游魚轉心瓶8結蛋捲禮盒【國立故宮博物院聯名】','DG010394-03','DG010394','原味蛋捲,咖啡蛋捲','禮盒-故宮(文物款)【原味+咖啡】','500','500','0','0','0','0','1','0.0','1','500','2024-09-23','2024-09-17 20:09:10','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248751',`firm_id` = '8',`ordernumber` = 'O24090242361', `product_name` = '游魚轉心瓶8結蛋捲禮盒【國立故宮博物院聯名】',`product_code` = 'DG010394-03',`product_sn` = 'DG010394',`product_spec` = '原味蛋捲,咖啡蛋捲',`invoice_name` = '禮盒-故宮(文物款)【原味+咖啡】',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '500',`etd` = '2024-09-23',`create_date` = '2024-09-17 20:09:10',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090242361' and product_code = 'DG010394-03' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090242462' and product_code = 'DG0103148-05' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248752','8','O24090242462','金典8結禮盒','DG0103148-05','DG0103148','原味+巧克力','禮盒-金典(紅)【原味+巧克力】','480','480','0','0','0','0','1','0.0','4','1920','2024-09-23','2024-09-17 20:09:32','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248752',`firm_id` = '8',`ordernumber` = 'O24090242462', `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` = '4',`total_price` = '1920',`etd` = '2024-09-23',`create_date` = '2024-09-17 20:09:32',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090242462' and product_code = 'DG0103148-05' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090242540' and product_code = 'DG0103188-06' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248753','8','O24090242540','【預購-9/19後出貨】SNOOPY美好探尋-8結禮盒','DG0103188-06','DG0103188','原味蛋捲,芝麻蛋捲','禮盒-SNOOPY(橘)【原味+芝麻】','500','500','0','0','0','0','1','0.0','1','500','2024-09-23','2024-09-17 21:16:41','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248753',`firm_id` = '8',`ordernumber` = 'O24090242540', `product_name` = '【預購-9/19後出貨】SNOOPY美好探尋-8結禮盒',`product_code` = 'DG0103188-06',`product_sn` = 'DG0103188',`product_spec` = '原味蛋捲,芝麻蛋捲',`invoice_name` = '禮盒-SNOOPY(橘)【原味+芝麻】',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '500',`etd` = '2024-09-23',`create_date` = '2024-09-17 21:16:41',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090242540' and product_code = 'DG0103188-06' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090242680' and product_code = 'LS010113-01' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248754','8','O24090242680','家庭分享包-乳酪絲','LS010113-01','LS010113','原味','(紅袋)乳酪絲【原味】','550','550','0','0','0','0','1','0.0','1','550','2024-09-23','2024-09-17 21:55:11','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248754',`firm_id` = '8',`ordernumber` = 'O24090242680', `product_name` = '家庭分享包-乳酪絲',`product_code` = 'LS010113-01',`product_sn` = 'LS010113',`product_spec` = '原味',`invoice_name` = '(紅袋)乳酪絲【原味】',`listprice` = '550',`sellingprice` = '550',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '550',`etd` = '2024-09-23',`create_date` = '2024-09-17 21:55:11',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090242680' and product_code = 'LS010113-01' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090242680' and product_code = 'LS010113-03' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248754','8','O24090242680','家庭分享包-乳酪絲','LS010113-03','LS010113','黑松露','(紅袋)乳酪絲【黑松露】','550','550','0','0','0','0','1','0.0','1','550','2024-09-23','2024-09-17 21:55:11','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248754',`firm_id` = '8',`ordernumber` = 'O24090242680', `product_name` = '家庭分享包-乳酪絲',`product_code` = 'LS010113-03',`product_sn` = 'LS010113',`product_spec` = '黑松露',`invoice_name` = '(紅袋)乳酪絲【黑松露】',`listprice` = '550',`sellingprice` = '550',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '550',`etd` = '2024-09-23',`create_date` = '2024-09-17 21:55:11',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090242680' and product_code = 'LS010113-03' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090242680' and product_code = 'LS010108-02' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248754','8','O24090242680','[加購]加購-羅勒乳酪絲','LS010108-02','LS010108','-','加購-(藍袋)乳酪絲【羅勒】','190','190','1','1','190','0','0','0.0','2','380','2024-09-23','2024-09-17 21:55:11','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248754',`firm_id` = '8',`ordernumber` = 'O24090242680', `product_name` = '[加購]加購-羅勒乳酪絲',`product_code` = 'LS010108-02',`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-09-23',`create_date` = '2024-09-17 21:55:11',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090242680' and product_code = 'LS010108-02' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090242785' and product_code = 'DG010101-01' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248755','8','O24090242785','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','2','560','2024-09-24','2024-09-17 22:32:00','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248755',`firm_id` = '8',`ordernumber` = 'O24090242785', `product_name` = '經典原味蛋捲',`product_code` = 'DG010101-01',`product_sn` = 'DG010101',`product_spec` = '原味',`invoice_name` = '40入原味蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '2',`total_price` = '560',`etd` = '2024-09-24',`create_date` = '2024-09-17 22:32:00',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090242785' and product_code = 'DG010101-01' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090242785' and product_code = 'DG010101-05' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248755','8','O24090242785','濃情巧克力蛋捲','DG010101-05','DG010101','巧克力','40入巧克力蛋捲','320','280','0','0','0','0','1','280.0','3','840','2024-09-24','2024-09-17 22:32:00','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248755',`firm_id` = '8',`ordernumber` = 'O24090242785', `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-09-24',`create_date` = '2024-09-17 22:32:00',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090242785' and product_code = 'DG010101-05' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090242785' and product_code = 'DG010404-01' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248755','8','O24090242785','紅色提袋','DG010404-01','DG010404','提袋/個','紅色提袋','10','10','0','0','0','0','1','0.0','6','60','2024-09-24','2024-09-17 22:32:00','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248755',`firm_id` = '8',`ordernumber` = 'O24090242785', `product_name` = '紅色提袋',`product_code` = 'DG010404-01',`product_sn` = 'DG010404',`product_spec` = '提袋/個',`invoice_name` = '紅色提袋',`listprice` = '10',`sellingprice` = '10',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '6',`total_price` = '60',`etd` = '2024-09-24',`create_date` = '2024-09-17 22:32:00',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090242785' and product_code = 'DG010404-01' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090242883' and product_code = 'DG010312-03' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248756','8','O24090242883','【原味+咖啡】金8結禮盒','DG010312-03','DG010312','金8結盒','禮盒-金8結【原味+咖啡】','590','480','0','0','0','0','1','480.0','2','960','2024-09-23','2024-09-17 22:46:05','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248756',`firm_id` = '8',`ordernumber` = 'O24090242883', `product_name` = '【原味+咖啡】金8結禮盒',`product_code` = 'DG010312-03',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+咖啡】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '2',`total_price` = '960',`etd` = '2024-09-23',`create_date` = '2024-09-17 22:46:05',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090242883' and product_code = 'DG010312-03' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090242921' and product_code = 'DG0103182-04' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248757','8','O24090242921','金巧8結禮盒','DG0103182-04','DG0103182','原味,鳳梨酥,芝麻糕','禮盒-金巧8結【(原味)-鳳梨酥+芝麻糕】','580','580','0','0','0','0','1','0.0','20','11600','2024-09-23','2024-09-17 23:49:46','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248757',`firm_id` = '8',`ordernumber` = 'O24090242921', `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` = '20',`total_price` = '11600',`etd` = '2024-09-23',`create_date` = '2024-09-17 23:49:46',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090242921' and product_code = 'DG0103182-04' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090242921' and product_code = 'DG0103182-214' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248757','8','O24090242921','金巧8結禮盒','DG0103182-214','DG0103182','咖啡,鳳梨酥,芝麻糕','禮盒-金巧8結【(咖啡)-鳳梨酥+芝麻糕】','580','580','0','0','0','0','1','0.0','10','5800','2024-09-23','2024-09-17 23:49:46','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248757',`firm_id` = '8',`ordernumber` = 'O24090242921', `product_name` = '金巧8結禮盒',`product_code` = 'DG0103182-214',`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` = '10',`total_price` = '5800',`etd` = '2024-09-23',`create_date` = '2024-09-17 23:49:46',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090242921' and product_code = 'DG0103182-214' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090242921' and product_code = 'DG0103182-115' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248757','8','O24090242921','金巧8結禮盒','DG0103182-115','DG0103182','芝麻,鳳梨酥,國寶茶','禮盒-金巧8結【(芝麻)-鳳梨酥+國寶茶】','590','590','0','0','0','0','1','0.0','10','5900','2024-09-23','2024-09-17 23:49:46','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248757',`firm_id` = '8',`ordernumber` = 'O24090242921', `product_name` = '金巧8結禮盒',`product_code` = 'DG0103182-115',`product_sn` = 'DG0103182',`product_spec` = '芝麻,鳳梨酥,國寶茶',`invoice_name` = '禮盒-金巧8結【(芝麻)-鳳梨酥+國寶茶】',`listprice` = '590',`sellingprice` = '590',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '10',`total_price` = '5900',`etd` = '2024-09-23',`create_date` = '2024-09-17 23:49:46',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090242921' and product_code = 'DG0103182-115' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090242921' and product_code = 'DG0103182-109' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248757','8','O24090242921','金巧8結禮盒','DG0103182-109','DG0103182','芝麻,鳳梨酥,芝麻糕','禮盒-金巧8結【(芝麻)-鳳梨酥+芝麻糕】','580','580','0','0','0','0','1','0.0','10','5800','2024-09-23','2024-09-17 23:49:46','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248757',`firm_id` = '8',`ordernumber` = 'O24090242921', `product_name` = '金巧8結禮盒',`product_code` = 'DG0103182-109',`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` = '10',`total_price` = '5800',`etd` = '2024-09-23',`create_date` = '2024-09-17 23:49:46',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090242921' and product_code = 'DG0103182-109' 2024-09-17 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24090242921' and product_code = 'DG0103182-424' 2024-09-17 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'248757','8','O24090242921','金巧8結禮盒','DG0103182-424','DG0103182','巧克力,鳳梨酥,芝麻糕','禮盒-金巧8結【(巧克力)-鳳梨酥+芝麻糕】','580','580','0','0','0','0','1','0.0','5','2900','2024-09-23','2024-09-17 23:49:46','2024-09-17 23:59:06',null,'1','2024-08-15') 2024-09-17 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '248757',`firm_id` = '8',`ordernumber` = 'O24090242921', `product_name` = '金巧8結禮盒',`product_code` = 'DG0103182-424',`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` = '5',`total_price` = '2900',`etd` = '2024-09-23',`create_date` = '2024-09-17 23:49:46',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-08-15'where ordernumber = 'O24090242921' and product_code = 'DG0103182-424' 2024-09-17 23:59:06 -- == sync_order_detail end == 2024-09-17 23:59:06 -- == sync_order start == 2024-09-17 23:59:06 -- start:2024-09-17,end:2024-09-17 2024-09-17 23:59:06 -- == 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-09-17%' OR l.modify_date like '2024-09-17%'; 2024-09-17 23:59:07 -- == sync omo_order_list == 2024-09-17 23:59:07 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('145440','55931',2,'','','B24090020049','1','11','1','1','1','53975016','宸瀧有限公司','0','0000-00-00','0','0','0','','150','0','5440','334','桃園市','八德區','334','桃園市','八德區','5590','2024-09-17 02:54:58','2024-08-15') 2024-09-17 23:59:07 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('145467','421559',2,'','','B24090020198','1','1','1','0','0','','','0','0000-00-00','0','0','0','','150','30','1000','709','台南市','安南區','709','台南市','安南區','1120','2024-09-17 19:38:57','2024-08-15') 2024-09-17 23:59:07 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('145467','421559',2,'','','B24090020282','1','2','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1500','709','台南市','安南區','709','台南市','安南區','1650','2024-09-17 19:43:12','2024-08-15') 2024-09-17 23:59:07 -- == sync_order end == 2024-09-17 23:59:07 -- == sync_order_detail start == 2024-09-17 23:59:07 -- start:2024-09-17,end:2024-09-17 2024-09-17 23:59:07 -- == sync omo_order_detail == 2024-09-17 23:59:07 -- == SELECT order_detail == SELECT * from order_detail WHERE create_date like '2024-09-17%' OR modify_date like '2024-09-17%' 2024-09-17 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B24090020049' and product_code = 'DG0103189-04' 2024-09-17 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, 2,'32766','8','B24090020049','【預購-9/19後出貨】SNOOPY美好探尋-8結彌月禮盒','DG0103189-04','DG0103189','原味+海苔','禮盒-彌月SNOOPY(橘)【原味+海苔】','500','500','0','1','0','0','1','0.0','1','500','2024-09-23','2024-09-17 02:54:58','2024-09-17 23:59:07',null,'1','2024-08-15') 2024-09-17 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '32766',`firm_id` = '8',`ordernumber` = 'B24090020049', `product_name` = '【預購-9/19後出貨】SNOOPY美好探尋-8結彌月禮盒',`product_code` = 'DG0103189-04',`product_sn` = 'DG0103189',`product_spec` = '原味+海苔',`invoice_name` = '禮盒-彌月SNOOPY(橘)【原味+海苔】',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '500',`etd` = '2024-09-23',`create_date` = '2024-09-17 02:54:58',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B24090020049' and product_code = 'DG0103189-04', `lunar_date` = '2024-08-15' 2024-09-17 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B24090020049' and product_code = 'SS010101-01' 2024-09-17 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, 2,'32766','8','B24090020049','[加購]加購-30入品純萃鱸魚精','SS010101-01','SS010101','-','加購-30入品純萃鱸魚精','4940','4940','1','1','4940','0','0','0.0','1','4940','2024-09-23','2024-09-17 02:54:58','2024-09-17 23:59:07',null,'1','2024-08-15') 2024-09-17 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '32766',`firm_id` = '8',`ordernumber` = 'B24090020049', `product_name` = '[加購]加購-30入品純萃鱸魚精',`product_code` = 'SS010101-01',`product_sn` = 'SS010101',`product_spec` = '-',`invoice_name` = '加購-30入品純萃鱸魚精',`listprice` = '4940',`sellingprice` = '4940',`isadd` = '1',`isbaby` = '1',`addprice` = '4940',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '4940',`etd` = '2024-09-23',`create_date` = '2024-09-17 02:54:58',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B24090020049' and product_code = 'SS010101-01', `lunar_date` = '2024-08-15' 2024-09-17 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B24090020198' and product_code = 'DG0103189-12' 2024-09-17 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, 2,'32767','8','B24090020198','【預購-9/19後出貨】SNOOPY美好探尋-8結彌月禮盒','DG0103189-12','DG0103189','咖啡+巧克力','禮盒-彌月SNOOPY(橘)【咖啡+巧克力】','500','500','0','1','0','0','1','0.0','1','500','2024-09-23','2024-09-17 19:38:57','2024-09-17 23:59:07',null,'1','2024-08-15') 2024-09-17 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '32767',`firm_id` = '8',`ordernumber` = 'B24090020198', `product_name` = '【預購-9/19後出貨】SNOOPY美好探尋-8結彌月禮盒',`product_code` = 'DG0103189-12',`product_sn` = 'DG0103189',`product_spec` = '咖啡+巧克力',`invoice_name` = '禮盒-彌月SNOOPY(橘)【咖啡+巧克力】',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '500',`etd` = '2024-09-23',`create_date` = '2024-09-17 19:38:57',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B24090020198' and product_code = 'DG0103189-12', `lunar_date` = '2024-08-15' 2024-09-17 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B24090020198' and product_code = 'DG0103189-03' 2024-09-17 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, 2,'32767','8','B24090020198','【預購-9/19後出貨】SNOOPY美好探尋-8結彌月禮盒','DG0103189-03','DG0103189','原味+咖啡','禮盒-彌月SNOOPY(橘)【原味+咖啡】','500','500','0','1','0','0','1','0.0','1','500','2024-09-23','2024-09-17 19:38:57','2024-09-17 23:59:07',null,'1','2024-08-15') 2024-09-17 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '32767',`firm_id` = '8',`ordernumber` = 'B24090020198', `product_name` = '【預購-9/19後出貨】SNOOPY美好探尋-8結彌月禮盒',`product_code` = 'DG0103189-03',`product_sn` = 'DG0103189',`product_spec` = '原味+咖啡',`invoice_name` = '禮盒-彌月SNOOPY(橘)【原味+咖啡】',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '500',`etd` = '2024-09-23',`create_date` = '2024-09-17 19:38:57',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B24090020198' and product_code = 'DG0103189-03', `lunar_date` = '2024-08-15' 2024-09-17 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B24090020282' and product_code = 'DG010202-01' 2024-09-17 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, 2,'32768','8','B24090020282','8結彌月提盒-年輪','DG010202-01','DG010202','原味','提盒-彌月年輪-40入原味','0','300','0','1','0','0','1','300.0','2','600','2024-09-23','2024-09-17 19:43:12','2024-09-17 23:59:07',null,'1','2024-08-15') 2024-09-17 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '32768',`firm_id` = '8',`ordernumber` = 'B24090020282', `product_name` = '8結彌月提盒-年輪',`product_code` = 'DG010202-01',`product_sn` = 'DG010202',`product_spec` = '原味',`invoice_name` = '提盒-彌月年輪-40入原味',`listprice` = '0',`sellingprice` = '300',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '300.0',`amount` = '2',`total_price` = '600',`etd` = '2024-09-23',`create_date` = '2024-09-17 19:43:12',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B24090020282' and product_code = 'DG010202-01', `lunar_date` = '2024-08-15' 2024-09-17 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B24090020282' and product_code = 'DG010202-03' 2024-09-17 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, 2,'32768','8','B24090020282','8結彌月提盒-年輪','DG010202-03','DG010202','咖啡','提盒-彌月年輪-40入咖啡','300','300','0','1','0','0','1','300.0','2','600','2024-09-23','2024-09-17 19:43:12','2024-09-17 23:59:07',null,'1','2024-08-15') 2024-09-17 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '32768',`firm_id` = '8',`ordernumber` = 'B24090020282', `product_name` = '8結彌月提盒-年輪',`product_code` = 'DG010202-03',`product_sn` = 'DG010202',`product_spec` = '咖啡',`invoice_name` = '提盒-彌月年輪-40入咖啡',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '300.0',`amount` = '2',`total_price` = '600',`etd` = '2024-09-23',`create_date` = '2024-09-17 19:43:12',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B24090020282' and product_code = 'DG010202-03', `lunar_date` = '2024-08-15' 2024-09-17 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B24090020282' and product_code = 'DG010202-05' 2024-09-17 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, 2,'32768','8','B24090020282','8結彌月提盒-年輪','DG010202-05','DG010202','巧克力','提盒-彌月年輪-40入巧克力','300','300','0','1','0','0','1','300.0','1','300','2024-09-23','2024-09-17 19:43:12','2024-09-17 23:59:07',null,'1','2024-08-15') 2024-09-17 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '32768',`firm_id` = '8',`ordernumber` = 'B24090020282', `product_name` = '8結彌月提盒-年輪',`product_code` = 'DG010202-05',`product_sn` = 'DG010202',`product_spec` = '巧克力',`invoice_name` = '提盒-彌月年輪-40入巧克力',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '300.0',`amount` = '1',`total_price` = '300',`etd` = '2024-09-23',`create_date` = '2024-09-17 19:43:12',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B24090020282' and product_code = 'DG010202-05', `lunar_date` = '2024-08-15' 2024-09-17 23:59:07 -- == sync_order_detail end == 2024-09-17 23:59:07 -- == 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-09-17' OR o.updated_at = '2024-09-17') and o.deleted_at is null 2024-09-17 23:59:07 -- == sync_order_detail start == 2024-09-17 23:59:07 -- start:2024-09-17,end:2024-09-17 2024-09-17 23:59:08 -- step1: SELECT id,sku,combinations_product_spec_id FROM `product_specs` 2024-09-17 23:59:08 -- step2: SELECT * FROM `product_specs` WHERE combinations_product_spec_id is not null 2024-09-17 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-09-17%';