[2026-09-09 00:53:35][sql] CONNECT:[ UseTime:0.000922s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-09 00:53:35][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000696s ]
[2026-09-09 00:53:35][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000495s ]
[2026-09-09 05:36:42][sql] CONNECT:[ UseTime:0.001095s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-09 05:36:42][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000729s ]
[2026-09-09 05:36:42][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000567s ]
[2026-09-09 08:44:47][sql] CONNECT:[ UseTime:0.000794s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-09 08:44:47][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000638s ]
[2026-09-09 08:44:47][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000482s ]
[2026-09-09 08:46:19][sql] CONNECT:[ UseTime:0.000814s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-09 08:46:19][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000717s ]
[2026-09-09 08:46:19][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000405s ]
[2026-09-09 08:53:06][sql] CONNECT:[ UseTime:0.001357s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-09 08:53:06][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000861s ]
[2026-09-09 08:53:06][sql] INSERT INTO `sp_order` SET `order_no` = '1788915186810810' , `web_url` = 'https://pleasantonstore.com' , `payment_method` = 'oceanpayment' , `discount` = 13196 , `currency` = 'USD' , `product_info` = '{\"payment_method\":\"oceanpayment\",\"qty\":1,\"discount\":-131.96,\"shipping\":{\"first_name\":\"Gary\",\"second_name\":\"Sato\",\"email\":\"poppasato001@socal.rr.com\",\"phone_full\":\"+17147203665\",\"country\":\"US\",\"city\":\"Fountain  valley\",\"province\":\"CA\",\"address\":\"9044 crocus ave,\",\"code\":\"92708\",\"domain_name\":\"gadgets.pleasantonstore.com\"},\"total\":\"$128.94\",\"amount\":\"128.94\",\"shipping_fee\":\"0.00\",\"product\":[{\"id\":18,\"qty\":\"3\",\"sku\":\"TY21146-C513\",\"main\":\"on\",\"title\":\"Single Galaxy Ball\",\"image\":\"https:\\/\\/clicklink.s3.amazonaws.com\\/img\\/vip\\/mNEEiUEUlPUcK0pi.png\",\"description\":\"Single Pack\",\"market_price\":\"79.98\",\"discount_price\":\"39.99\",\"shipping_fee\":\"5.99\",\"discount\":\"50% Saving \",\"currency\":\"USD\",\"symbol\":\"$\",\"discount_amount\":107.97},{\"id\":16,\"qty\":\"3\",\"sku\":\"WARRANTY-S\",\"title\":\"1 Year Extended Warranty\",\"image\":\"https:\\/\\/clicklink.s3.amazonaws.com\\/img\\/vip\\/ixsZuX852JPEuG9Q.png\",\"description\":\"\",\"market_price\":\"13.98\",\"discount_price\":\"6.99\",\"shipping_fee\":\"0.00\",\"discount\":\"50%\",\"currency\":\"USD\",\"symbol\":\"$\"}],\"currency\":\"USD\",\"view_lang\":\"en\",\"prod_name\":\"galaxy\",\"publisher\":\"\",\"source\":\"\",\"web_url\":\"https:\\/\\/pleasantonstore.com\",\"order_no\":\"1788915186810810\",\"email\":\"poppasato001@socal.rr.com\"}' , `total_amount` = 12894 , `pay_amount` = 12894 , `shipping_fee` = 0 , `email` = 'poppasato001@socal.rr.com' , `create_time` = '2026-09-09 08:53:06' [ RunTime:0.002568s ]
[2026-09-09 08:53:06][sql] SHOW FULL COLUMNS FROM `sp_order_item` [ RunTime:0.000920s ]
[2026-09-09 08:53:06][sql] INSERT INTO `sp_order_item` SET `order_id` = 19324 , `title` = 'Single Galaxy Ball' , `sku` = 'TY21146-C513' , `num` = 3 , `price` = 7998 , `discount_price` = 10797 , `create_time` = '2026-09-09 08:53:06' [ RunTime:0.000279s ]
[2026-09-09 08:53:06][sql] INSERT INTO `sp_order_item` SET `order_id` = 19324 , `title` = '1 Year Extended Warranty' , `sku` = 'WARRANTY-S' , `num` = 3 , `price` = 1398 , `discount_price` = 2097 , `create_time` = '2026-09-09 08:53:06' [ RunTime:0.000215s ]
[2026-09-09 08:53:06][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000796s ]
[2026-09-09 08:53:06][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000486s ]
[2026-09-09 08:53:06][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000654s ]
[2026-09-09 08:53:06][sql] INSERT INTO `sp_order_shipping` SET `order_id` = 19324 , `last_name` = 'Sato' , `first_name` = 'Gary' , `name` = 'GarySato' , `address1` = '9044 crocus ave,' , `province` = 'CA' , `zip` = '92708' , `city` = 'Fountain  valley' , `country` = 'US' , `country_code` = 'US' , `phone` = '+17147203665' , `create_time` = '2026-09-09 08:53:06' [ RunTime:0.001842s ]
[2026-09-09 08:53:06][sql] SHOW FULL COLUMNS FROM `sp_order_extend` [ RunTime:0.000561s ]
[2026-09-09 08:53:06][sql] INSERT INTO `sp_order_extend` SET `order_id` = 19324 , `bank_account` = '251704' [ RunTime:0.001302s ]
[2026-09-09 08:55:49][sql] CONNECT:[ UseTime:0.001369s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-09 08:55:49][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000645s ]
[2026-09-09 08:55:49][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000483s ]
[2026-09-09 08:55:49][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000475s ]
[2026-09-09 08:55:49][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1788915186810810' LIMIT 1 [ RunTime:0.025197s ]
[2026-09-09 08:55:49][sql] SHOW FULL COLUMNS FROM `sp_order_oceanpay` [ RunTime:0.000766s ]
[2026-09-09 08:55:49][sql] INSERT INTO `sp_order_oceanpay` SET `order_no` = '1788915186810810' , `quickpay_id` = '912e5445-6bf1-4398-a323-9f654be23cc3' , `web_url` = 'https://gadgets.pleasantonstore.com' , `create_time` = '2026-09-09 08:55:47' [ RunTime:0.002481s ]
[2026-09-09 08:55:49][sql] CONNECT:[ UseTime:0.000908s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-09 08:55:49][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000734s ]
[2026-09-09 08:55:49][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000440s ]
[2026-09-09 08:55:49][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000576s ]
[2026-09-09 08:55:49][sql] SELECT * FROM `sp_order` `t` LEFT JOIN `sp_order_shipping` `order_shipping` ON `t`.`id`=`order_shipping`.`order_id` WHERE  `order_no` = '1788915186810810' LIMIT 1 [ RunTime:0.027424s ]
[2026-09-09 08:55:49][sql] UPDATE `sp_order`  SET `transaction_id` = '260909085547469332057' , `status` = 'COMPLETED' , `order_time` = '2026-09-09 08:55:49' , `pay_time` = '2026-09-09 08:55:49'  WHERE  `order_no` = '1788915186810810' [ RunTime:0.031028s ]
[2026-09-09 08:55:49][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1788915186810810' LIMIT 1 [ RunTime:0.025664s ]
[2026-09-09 08:55:49][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000714s ]
[2026-09-09 08:55:49][sql] SELECT * FROM `sp_order_shipping` WHERE  `order_id` = 19324 LIMIT 1 [ RunTime:0.000470s ]
[2026-09-09 08:55:49][sql] SHOW FULL COLUMNS FROM `sp_order_item` [ RunTime:0.000586s ]
[2026-09-09 08:55:49][sql] SELECT * FROM `sp_order_item` WHERE  `order_id` = 19324 [ RunTime:0.018486s ]
[2026-09-09 08:55:49][sql] SHOW FULL COLUMNS FROM `sp_order_extend` [ RunTime:0.000669s ]
[2026-09-09 08:55:49][sql] SELECT * FROM `sp_order_extend` WHERE  `order_id` = 19324 LIMIT 1 [ RunTime:0.005567s ]
[2026-09-09 08:55:49][sql] UPDATE `sp_order`  SET `push_erp_status` = 1 , `push_erp_time` = '2026-09-09 08:55:49'  WHERE  `order_no` = '1788915186810810' [ RunTime:0.034695s ]
[2026-09-09 08:55:49][sql] CONNECT:[ UseTime:0.000968s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-09 08:55:49][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000646s ]
[2026-09-09 08:55:49][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000444s ]
[2026-09-09 08:55:49][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000504s ]
[2026-09-09 08:55:49][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1788915186810810' LIMIT 1 [ RunTime:0.024869s ]
[2026-09-09 08:55:50][sql] CONNECT:[ UseTime:0.000896s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-09 08:55:50][sql] SHOW FULL COLUMNS FROM `sp_goods` [ RunTime:0.000560s ]
[2026-09-09 08:55:50][sql] SELECT * FROM `sp_goods` WHERE  `name` = 'GalaxyUpsell' LIMIT 1 [ RunTime:0.000325s ]
[2026-09-09 08:56:38][sql] CONNECT:[ UseTime:0.001020s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-09 08:56:38][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000739s ]
[2026-09-09 08:56:38][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1788915186810810' LIMIT 1 [ RunTime:0.024213s ]
[2026-09-09 08:56:38][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1788915186810810' LIMIT 1 [ RunTime:0.024705s ]
[2026-09-09 08:56:38][sql] SHOW FULL COLUMNS FROM `sp_order_upsell` [ RunTime:0.000594s ]
[2026-09-09 08:56:38][sql] SELECT * FROM `sp_order_upsell` WHERE  `order_no` = '1788915186810810'  AND `status` = 'COMPLETED' [ RunTime:0.000349s ]
[2026-09-09 08:56:38][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000475s ]
[2026-09-09 08:56:38][sql] SELECT * FROM `sp_order_shipping` WHERE  `order_id` = 19324 LIMIT 1 [ RunTime:0.000350s ]
[2026-09-09 08:56:57][sql] CONNECT:[ UseTime:0.000995s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-09 08:56:57][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000568s ]
[2026-09-09 08:56:57][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1788915186810810' LIMIT 1 [ RunTime:0.024676s ]
[2026-09-09 08:56:57][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1788915186810810' LIMIT 1 [ RunTime:0.025309s ]
[2026-09-09 08:56:57][sql] SHOW FULL COLUMNS FROM `sp_order_upsell` [ RunTime:0.000599s ]
[2026-09-09 08:56:57][sql] SELECT * FROM `sp_order_upsell` WHERE  `order_no` = '1788915186810810'  AND `status` = 'COMPLETED' [ RunTime:0.000348s ]
[2026-09-09 08:56:57][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000532s ]
[2026-09-09 08:56:57][sql] SELECT * FROM `sp_order_shipping` WHERE  `order_id` = 19324 LIMIT 1 [ RunTime:0.000386s ]
[2026-09-09 09:10:38][sql] CONNECT:[ UseTime:0.001109s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-09 09:10:38][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000593s ]
[2026-09-09 09:10:38][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000390s ]
[2026-09-09 09:10:38][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000404s ]
[2026-09-09 09:10:38][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1788915186810810' LIMIT 1 [ RunTime:0.024258s ]
[2026-09-09 09:37:50][sql] CONNECT:[ UseTime:0.001166s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-09 09:37:50][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000722s ]
[2026-09-09 09:37:50][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000523s ]
[2026-09-09 10:57:30][sql] CONNECT:[ UseTime:0.000875s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-09 10:57:30][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000584s ]
[2026-09-09 10:57:30][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000523s ]
[2026-09-09 12:27:33][sql] CONNECT:[ UseTime:0.001092s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-09 12:27:33][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000639s ]
[2026-09-09 12:27:33][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000459s ]
[2026-09-09 12:57:40][sql] CONNECT:[ UseTime:0.000879s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-09 12:57:40][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000602s ]
[2026-09-09 12:57:40][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000638s ]
[2026-09-09 16:17:26][sql] CONNECT:[ UseTime:0.000867s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-09 16:17:26][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000600s ]
[2026-09-09 16:17:26][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000533s ]