[2025-07-05 12:20:27]
[2025-07-05 12:20:27]
INSERT INTO ordbook_m ( part, route, ordstate, ocode, ccode, orddate, deldate, ordtime, bigo, shop_phone02, shop_memo, shop_receiver_uname, shop_receiver_zipcode, shop_receiver_address, shop_receiver_phone01, shop_receiver_phone02,ucode) VALUE ( '1', '1', '0', '1', '000918', '2025-07-05', '2025-07-05', '250705122023', '', '', '', '', '', '', '', '','05')[2025-07-05 12:20:27]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '[소림마라] 낱개 크림새우소스', '600545', '5KG*3EA/BOX', '1', '58000', '', '253140', '1' , '2025-07-05 12:20:27'  , 1 )[2025-07-05 12:20:59]
[2025-07-05 12:21:00]
UPDATE ordbook_m SET orddate = '2025-07-05', deldate = '2025-07-08', bigo = '', shop_memo = '', shop_receiver_uname = '', shop_receiver_zipcode = '', shop_receiver_address = '', shop_receiver_phone01 = '', shop_receiver_phone02 = '', ucode = '05'  WHERE ordno = '253140' [2025-07-05 12:21:00]
UPDATE ordbook_d SET pname = '[소림마라] 낱개 크림새우소스', pcode = '600545', pnorm = '5KG*3EA/BOX', ordqnt = '1', price = '58000', bigo = '' , lastmodify = '2025-07-05 12:20:59'  , parentseq = '1'  WHERE ordno = '253140' AND seq = '1'[2025-07-05 12:21:00]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '수정당면 기본(중국)', '100373', '350G*30봉*1BOX', '1', '55000', '', '253140', '2' , '2025-07-05 12:20:59'  , 2 )[2025-07-05 12:21:11]
[2025-07-05 12:21:11]
UPDATE ordbook_m SET orddate = '2025-07-05', deldate = '2025-07-08', bigo = '', shop_memo = '', shop_receiver_uname = '', shop_receiver_zipcode = '', shop_receiver_address = '', shop_receiver_phone01 = '', shop_receiver_phone02 = '', ucode = '05'  WHERE ordno = '253140' [2025-07-05 12:21:11]
UPDATE ordbook_d SET pname = '[소림마라] 낱개 크림새우소스', pcode = '600545', pnorm = '5KG*3EA/BOX', ordqnt = '1', price = '58000', bigo = '' , lastmodify = '2025-07-05 12:21:11'  , parentseq = '1'  WHERE ordno = '253140' AND seq = '1'[2025-07-05 12:21:12]
UPDATE ordbook_d SET pname = '수정당면 기본(중국)', pcode = '100373', pnorm = '350G*30봉*1BOX', ordqnt = '1', price = '55000', bigo = '' , lastmodify = '2025-07-05 12:21:11'  , parentseq = '2'  WHERE ordno = '253140' AND seq = '2'[2025-07-05 12:36:06]
DELETE FROM ordbook_d WHERE ordno = \'253140\' AND seq= \'1\'[2025-07-05 12:36:09]
DELETE FROM ordbook_d WHERE ordno = \'253140\' AND seq= \'2\'[2025-07-05 13:53:52]
[2025-07-05 13:53:52]
INSERT INTO ordbook_m ( part, route, ordstate, ocode, ccode, orddate, deldate, ordtime, bigo, shop_phone02, shop_memo, shop_receiver_uname, shop_receiver_zipcode, shop_receiver_address, shop_receiver_phone01, shop_receiver_phone02,ucode) VALUE ( '1', '1', '0', '1', '001019', '2025-07-05', '2025-07-05', '250705135056', '', '', '', '', '', '', '', '','')[2025-07-05 13:53:52]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '비엔나소시지 1KG', '100997', '1kg/10EA', '2', '5000', '', '253142', '1' , '2025-07-05 13:53:52'  , 1 )[2025-07-05 13:53:52]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '햄롯데(세븐)1K', '100998', '1KG*10EA/BOX', '1', '6500', '', '253142', '2' , '2025-07-05 13:53:52'  , 2 )[2025-07-05 13:53:52]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '*롤백(30*40)', '500020', '(380입 12EA/BOX)', '2', '5800', '', '253142', '3' , '2025-07-05 13:53:52'  , 3 )[2025-07-05 13:53:52]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '*하이퐁 주방세제(11.8L_12kg EA)', '500086', '(11.8L_12kg EA)', '1', '14000', '', '253142', '4' , '2025-07-05 13:53:52'  , 4 )[2025-07-05 13:54:08]
[2025-07-05 13:54:08]
UPDATE ordbook_m SET orddate = '2025-07-05', deldate = '2025-07-05', bigo = '', shop_memo = '', shop_receiver_uname = '', shop_receiver_zipcode = '', shop_receiver_address = '', shop_receiver_phone01 = '', shop_receiver_phone02 = '', ucode = ''  WHERE ordno = '253142' [2025-07-05 13:54:08]
UPDATE ordbook_d SET pname = '비엔나소시지 1KG', pcode = '100997', pnorm = '1kg/10EA', ordqnt = '2', price = '5000', bigo = '' , lastmodify = '2025-07-05 13:54:08'  , parentseq = '1'  WHERE ordno = '253142' AND seq = '1'[2025-07-05 13:54:08]
UPDATE ordbook_d SET pname = '햄롯데(세븐)1K', pcode = '100998', pnorm = '1KG*10EA/BOX', ordqnt = '1', price = '6500', bigo = '' , lastmodify = '2025-07-05 13:54:08'  , parentseq = '2'  WHERE ordno = '253142' AND seq = '2'[2025-07-05 13:54:08]
UPDATE ordbook_d SET pname = '*롤백(30*40)', pcode = '500020', pnorm = '(380입 12EA/BOX)', ordqnt = '2', price = '5800', bigo = '' , lastmodify = '2025-07-05 13:54:08'  , parentseq = '3'  WHERE ordno = '253142' AND seq = '3'[2025-07-05 13:54:08]
UPDATE ordbook_d SET pname = '*하이퐁 주방세제(11.8L_12kg EA)', pcode = '500086', pnorm = '(11.8L_12kg EA)', ordqnt = '1', price = '14000', bigo = '' , lastmodify = '2025-07-05 13:54:08'  , parentseq = '4'  WHERE ordno = '253142' AND seq = '4'[2025-07-05 13:54:08]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( ' 캡사이신/청우 10KG', '600354', '10kg', '1', '89000', '', '253142', '5' , '2025-07-05 13:54:08'  , 5 )[2025-07-05 13:55:11]
[2025-07-05 13:55:11]
UPDATE ordbook_m SET orddate = '2025-07-05', deldate = '2025-07-05', bigo = '', shop_memo = '', shop_receiver_uname = '', shop_receiver_zipcode = '', shop_receiver_address = '', shop_receiver_phone01 = '', shop_receiver_phone02 = '', ucode = ''  WHERE ordno = '253142' [2025-07-05 13:55:11]
UPDATE ordbook_d SET pname = '비엔나소시지 1KG', pcode = '100997', pnorm = '1kg/10EA', ordqnt = '2', price = '5000', bigo = '' , lastmodify = '2025-07-05 13:55:11'  , parentseq = '1'  WHERE ordno = '253142' AND seq = '1'[2025-07-05 13:55:11]
UPDATE ordbook_d SET pname = '햄롯데(세븐)1K', pcode = '100998', pnorm = '1KG*10EA/BOX', ordqnt = '1', price = '6500', bigo = '' , lastmodify = '2025-07-05 13:55:11'  , parentseq = '2'  WHERE ordno = '253142' AND seq = '2'[2025-07-05 13:55:11]
UPDATE ordbook_d SET pname = '*롤백(30*40)', pcode = '500020', pnorm = '(380입 12EA/BOX)', ordqnt = '2', price = '5800', bigo = '' , lastmodify = '2025-07-05 13:55:11'  , parentseq = '3'  WHERE ordno = '253142' AND seq = '3'[2025-07-05 13:55:11]
UPDATE ordbook_d SET pname = '*하이퐁 주방세제(11.8L_12kg EA)', pcode = '500086', pnorm = '(11.8L_12kg EA)', ordqnt = '1', price = '14000', bigo = '' , lastmodify = '2025-07-05 13:55:11'  , parentseq = '4'  WHERE ordno = '253142' AND seq = '4'[2025-07-05 13:55:11]
UPDATE ordbook_d SET pname = ' 캡사이신/청우 10KG', pcode = '600354', pnorm = '10kg', ordqnt = '1', price = '89000', bigo = '' , lastmodify = '2025-07-05 13:55:11'  , parentseq = '5'  WHERE ordno = '253142' AND seq = '5'