[2026-09-11 01:34:00][sql] CONNECT:[ UseTime:0.001271s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 01:34:00][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000798s ]
[2026-09-11 01:34:00][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000639s ]
[2026-09-11 01:34:05][sql] CONNECT:[ UseTime:0.000970s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 01:34:05][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000641s ]
[2026-09-11 01:34:05][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000471s ]
[2026-09-11 01:34:06][sql] CONNECT:[ UseTime:0.001250s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 01:34:06][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000702s ]
[2026-09-11 01:34:06][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000529s ]
[2026-09-11 02:22:35][sql] CONNECT:[ UseTime:0.001461s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 02:22:35][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000867s ]
[2026-09-11 02:22:35][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000606s ]
[2026-09-11 02:39:13][sql] CONNECT:[ UseTime:0.001154s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 02:39:13][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000674s ]
[2026-09-11 02:39:13][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000443s ]
[2026-09-11 02:41:08][sql] CONNECT:[ UseTime:0.001114s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 02:41:08][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000739s ]
[2026-09-11 02:41:08][sql] INSERT INTO `sp_order` SET `order_no` = '1789065668241010' , `web_url` = 'https://pleasantonstore.com' , `payment_method` = 'oceanpayment' , `discount` = 9286 , `currency` = 'USD' , `product_info` = '{\"payment_method\":\"oceanpayment\",\"qty\":1,\"discount\":-92.86,\"shipping\":{\"first_name\":\"Stephen\",\"second_name\":\"Brown\",\"email\":\"stepheng.sb61@gmail.com\",\"phone_full\":\"+14135304712\",\"country\":\"US\",\"city\":\"Maitland\",\"province\":\"FL\",\"address\":\"955 N Orlando Ave,\",\"code\":\"32751\",\"domain_name\":\"gadgets.pleasantonstore.com\"},\"total\":\"$89.96\",\"amount\":\"89.96\",\"shipping_fee\":\"0.00\",\"product\":[{\"id\":18,\"qty\":\"2\",\"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\":75.98},{\"id\":16,\"qty\":\"2\",\"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\":\"1789065668241010\",\"email\":\"stepheng.sb61@gmail.com\"}' , `total_amount` = 8996 , `pay_amount` = 8996 , `shipping_fee` = 0 , `email` = 'stepheng.sb61@gmail.com' , `create_time` = '2026-09-11 02:41:08' [ RunTime:0.002156s ]
[2026-09-11 02:41:08][sql] SHOW FULL COLUMNS FROM `sp_order_item` [ RunTime:0.000457s ]
[2026-09-11 02:41:08][sql] INSERT INTO `sp_order_item` SET `order_id` = 19326 , `title` = 'Single Galaxy Ball' , `sku` = 'TY21146-C513' , `num` = 2 , `price` = 7998 , `discount_price` = 7598 , `create_time` = '2026-09-11 02:41:08' [ RunTime:0.000202s ]
[2026-09-11 02:41:08][sql] INSERT INTO `sp_order_item` SET `order_id` = 19326 , `title` = '1 Year Extended Warranty' , `sku` = 'WARRANTY-S' , `num` = 2 , `price` = 1398 , `discount_price` = 1398 , `create_time` = '2026-09-11 02:41:08' [ RunTime:0.000153s ]
[2026-09-11 02:41:08][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000717s ]
[2026-09-11 02:41:08][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000491s ]
[2026-09-11 02:41:08][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000532s ]
[2026-09-11 02:41:08][sql] INSERT INTO `sp_order_shipping` SET `order_id` = 19326 , `last_name` = 'Brown' , `first_name` = 'Stephen' , `name` = 'StephenBrown' , `address1` = '955 N Orlando Ave,' , `province` = 'FL' , `zip` = '32751' , `city` = 'Maitland' , `country` = 'US' , `country_code` = 'US' , `phone` = '+14135304712' , `create_time` = '2026-09-11 02:41:08' [ RunTime:0.001510s ]
[2026-09-11 02:41:08][sql] SHOW FULL COLUMNS FROM `sp_order_extend` [ RunTime:0.000604s ]
[2026-09-11 02:41:08][sql] INSERT INTO `sp_order_extend` SET `order_id` = 19326 , `bank_account` = '251704' [ RunTime:0.000677s ]
[2026-09-11 02:42:35][sql] CONNECT:[ UseTime:0.001407s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 02:42:35][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000699s ]
[2026-09-11 02:42:35][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000457s ]
[2026-09-11 02:42:35][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000469s ]
[2026-09-11 02:42:35][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1789065668241010' LIMIT 1 [ RunTime:0.026862s ]
[2026-09-11 02:42:35][sql] SHOW FULL COLUMNS FROM `sp_order_oceanpay` [ RunTime:0.000620s ]
[2026-09-11 02:42:35][sql] INSERT INTO `sp_order_oceanpay` SET `order_no` = '1789065668241010' , `quickpay_id` = 'faafd1d7-b324-463f-b044-dbe15cbf676c' , `web_url` = 'https://gadgets.pleasantonstore.com' , `create_time` = '2026-09-11 02:42:32' [ RunTime:0.010713s ]
[2026-09-11 02:42:35][sql] CONNECT:[ UseTime:0.001023s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 02:42:35][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000698s ]
[2026-09-11 02:42:35][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000479s ]
[2026-09-11 02:42:35][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000596s ]
[2026-09-11 02:42:35][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1789065668241010' LIMIT 1 [ RunTime:0.028990s ]
[2026-09-11 02:42:35][sql] CONNECT:[ UseTime:0.001453s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 02:42:35][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.001074s ]
[2026-09-11 02:42:35][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000611s ]
[2026-09-11 02:42:35][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000648s ]
[2026-09-11 02:42:35][sql] SELECT * FROM `sp_order` `t` LEFT JOIN `sp_order_shipping` `order_shipping` ON `t`.`id`=`order_shipping`.`order_id` WHERE  `order_no` = '1789065668241010' LIMIT 1 [ RunTime:0.027967s ]
[2026-09-11 02:42:35][sql] UPDATE `sp_order`  SET `transaction_id` = '260911024233107131046' , `status` = 'COMPLETED' , `order_time` = '2026-09-11 02:42:35' , `pay_time` = '2026-09-11 02:42:35'  WHERE  `order_no` = '1789065668241010' [ RunTime:0.033391s ]
[2026-09-11 02:42:35][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1789065668241010' LIMIT 1 [ RunTime:0.027325s ]
[2026-09-11 02:42:35][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000654s ]
[2026-09-11 02:42:35][sql] SELECT * FROM `sp_order_shipping` WHERE  `order_id` = 19326 LIMIT 1 [ RunTime:0.000314s ]
[2026-09-11 02:42:35][sql] SHOW FULL COLUMNS FROM `sp_order_item` [ RunTime:0.000394s ]
[2026-09-11 02:42:35][sql] SELECT * FROM `sp_order_item` WHERE  `order_id` = 19326 [ RunTime:0.020032s ]
[2026-09-11 02:42:35][sql] SHOW FULL COLUMNS FROM `sp_order_extend` [ RunTime:0.000541s ]
[2026-09-11 02:42:35][sql] SELECT * FROM `sp_order_extend` WHERE  `order_id` = 19326 LIMIT 1 [ RunTime:0.004890s ]
[2026-09-11 02:42:35][sql] UPDATE `sp_order`  SET `push_erp_status` = 1 , `push_erp_time` = '2026-09-11 02:42:35'  WHERE  `order_no` = '1789065668241010' [ RunTime:0.032531s ]
[2026-09-11 02:42:37][sql] CONNECT:[ UseTime:0.001435s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 02:42:37][sql] SHOW FULL COLUMNS FROM `sp_goods` [ RunTime:0.000787s ]
[2026-09-11 02:42:37][sql] SELECT * FROM `sp_goods` WHERE  `name` = 'GalaxyUpsell' LIMIT 1 [ RunTime:0.000418s ]
[2026-09-11 02:42:38][sql] CONNECT:[ UseTime:0.001278s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 02:42:38][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000804s ]
[2026-09-11 02:42:38][sql] SELECT * FROM `sp_order` `t` LEFT JOIN `sp_order_shipping` `order_shipping` ON `t`.`id`=`order_shipping`.`order_id` WHERE  `order_no` = '1789065668241010' LIMIT 1 [ RunTime:0.028260s ]
[2026-09-11 02:42:38][sql] CONNECT:[ UseTime:0.001192s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 02:42:38][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000783s ]
[2026-09-11 02:42:38][sql] SELECT * FROM `sp_order` `t` LEFT JOIN `sp_order_shipping` `order_shipping` ON `t`.`id`=`order_shipping`.`order_id` WHERE  `order_no` = '1789065668241010' LIMIT 1 [ RunTime:0.039081s ]
[2026-09-11 02:42:38][sql] CONNECT:[ UseTime:0.001119s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 02:42:38][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000782s ]
[2026-09-11 02:42:38][sql] SELECT * FROM `sp_order` `t` LEFT JOIN `sp_order_shipping` `order_shipping` ON `t`.`id`=`order_shipping`.`order_id` WHERE  `order_no` = '1789065668241010' LIMIT 1 [ RunTime:0.029630s ]
[2026-09-11 02:42:39][sql] CONNECT:[ UseTime:0.001205s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 02:42:39][sql] SHOW FULL COLUMNS FROM `sp_goods` [ RunTime:0.000763s ]
[2026-09-11 02:42:39][sql] SELECT * FROM `sp_goods` WHERE  `name` = 'GalaxyUpsell' LIMIT 1 [ RunTime:0.000409s ]
[2026-09-11 02:42:51][sql] CONNECT:[ UseTime:0.001162s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 02:42:51][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000706s ]
[2026-09-11 02:42:51][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1789065668241010' LIMIT 1 [ RunTime:0.027052s ]
[2026-09-11 02:42:51][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1789065668241010' LIMIT 1 [ RunTime:0.026629s ]
[2026-09-11 02:42:51][sql] SHOW FULL COLUMNS FROM `sp_order_upsell` [ RunTime:0.000795s ]
[2026-09-11 02:42:51][sql] SELECT * FROM `sp_order_upsell` WHERE  `order_no` = '1789065668241010'  AND `status` = 'COMPLETED' [ RunTime:0.000497s ]
[2026-09-11 02:42:51][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000544s ]
[2026-09-11 02:42:51][sql] SELECT * FROM `sp_order_shipping` WHERE  `order_id` = 19326 LIMIT 1 [ RunTime:0.000384s ]
[2026-09-11 02:42:54][sql] CONNECT:[ UseTime:0.000960s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 02:42:54][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000801s ]
[2026-09-11 02:42:54][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1789065668241010' LIMIT 1 [ RunTime:0.026968s ]
[2026-09-11 02:42:54][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1789065668241010' LIMIT 1 [ RunTime:0.028837s ]
[2026-09-11 02:42:54][sql] SHOW FULL COLUMNS FROM `sp_order_upsell` [ RunTime:0.000605s ]
[2026-09-11 02:42:54][sql] SELECT * FROM `sp_order_upsell` WHERE  `order_no` = '1789065668241010'  AND `status` = 'COMPLETED' [ RunTime:0.000364s ]
[2026-09-11 02:42:54][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000389s ]
[2026-09-11 02:42:54][sql] SELECT * FROM `sp_order_shipping` WHERE  `order_id` = 19326 LIMIT 1 [ RunTime:0.000265s ]
[2026-09-11 02:42:54][sql] CONNECT:[ UseTime:0.000909s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 02:42:54][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000601s ]
[2026-09-11 02:42:54][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1789065668241010' LIMIT 1 [ RunTime:0.030085s ]
[2026-09-11 02:42:54][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1789065668241010' LIMIT 1 [ RunTime:0.028289s ]
[2026-09-11 02:42:54][sql] SHOW FULL COLUMNS FROM `sp_order_upsell` [ RunTime:0.000662s ]
[2026-09-11 02:42:54][sql] SELECT * FROM `sp_order_upsell` WHERE  `order_no` = '1789065668241010'  AND `status` = 'COMPLETED' [ RunTime:0.000364s ]
[2026-09-11 02:42:54][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000444s ]
[2026-09-11 02:42:54][sql] SELECT * FROM `sp_order_shipping` WHERE  `order_id` = 19326 LIMIT 1 [ RunTime:0.000305s ]
[2026-09-11 02:42:54][sql] CONNECT:[ UseTime:0.001080s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 02:42:54][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000631s ]
[2026-09-11 02:42:54][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1789065668241010' LIMIT 1 [ RunTime:0.032935s ]
[2026-09-11 02:42:54][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1789065668241010' LIMIT 1 [ RunTime:0.037844s ]
[2026-09-11 02:42:54][sql] SHOW FULL COLUMNS FROM `sp_order_upsell` [ RunTime:0.000681s ]
[2026-09-11 02:42:54][sql] SELECT * FROM `sp_order_upsell` WHERE  `order_no` = '1789065668241010'  AND `status` = 'COMPLETED' [ RunTime:0.000613s ]
[2026-09-11 02:42:54][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000459s ]
[2026-09-11 02:42:54][sql] SELECT * FROM `sp_order_shipping` WHERE  `order_id` = 19326 LIMIT 1 [ RunTime:0.000296s ]
[2026-09-11 02:46:57][sql] CONNECT:[ UseTime:0.001424s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 02:46:57][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000816s ]
[2026-09-11 02:46:57][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1789065668241010' LIMIT 1 [ RunTime:0.027653s ]
[2026-09-11 02:46:57][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1789065668241010' LIMIT 1 [ RunTime:0.026252s ]
[2026-09-11 02:46:57][sql] SHOW FULL COLUMNS FROM `sp_order_upsell` [ RunTime:0.000816s ]
[2026-09-11 02:46:57][sql] SELECT * FROM `sp_order_upsell` WHERE  `order_no` = '1789065668241010'  AND `status` = 'COMPLETED' [ RunTime:0.000478s ]
[2026-09-11 02:46:57][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000506s ]
[2026-09-11 02:46:57][sql] SELECT * FROM `sp_order_shipping` WHERE  `order_id` = 19326 LIMIT 1 [ RunTime:0.000429s ]
[2026-09-11 02:50:27][sql] CONNECT:[ UseTime:0.001165s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 02:50:27][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000735s ]
[2026-09-11 02:50:27][sql] INSERT INTO `sp_order` SET `order_no` = '1789066227551110' , `web_url` = 'https://pleasantonstore.com' , `payment_method` = 'oceanpayment' , `discount` = 9286 , `currency` = 'USD' , `product_info` = '{\"payment_method\":\"oceanpayment\",\"qty\":1,\"discount\":-92.86,\"shipping\":{\"first_name\":\"Stephen\",\"second_name\":\"Brown\",\"email\":\"stepheng.sb61@gmail.com\",\"phone_full\":\"+14135304712\",\"country\":\"US\",\"city\":\"Maitland\",\"province\":\"FL\",\"address\":\"955 N Orlando Ave,\",\"code\":\"32751\",\"domain_name\":\"gadgets.pleasantonstore.com\"},\"total\":\"$89.96\",\"amount\":\"89.96\",\"shipping_fee\":\"0.00\",\"product\":[{\"id\":18,\"qty\":\"2\",\"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\":75.98},{\"id\":16,\"qty\":\"2\",\"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\":\"1789066227551110\",\"email\":\"stepheng.sb61@gmail.com\"}' , `total_amount` = 8996 , `pay_amount` = 8996 , `shipping_fee` = 0 , `email` = 'stepheng.sb61@gmail.com' , `create_time` = '2026-09-11 02:50:27' [ RunTime:0.002422s ]
[2026-09-11 02:50:27][sql] SHOW FULL COLUMNS FROM `sp_order_item` [ RunTime:0.000624s ]
[2026-09-11 02:50:27][sql] INSERT INTO `sp_order_item` SET `order_id` = 19327 , `title` = 'Single Galaxy Ball' , `sku` = 'TY21146-C513' , `num` = 2 , `price` = 7998 , `discount_price` = 7598 , `create_time` = '2026-09-11 02:50:27' [ RunTime:0.000367s ]
[2026-09-11 02:50:27][sql] INSERT INTO `sp_order_item` SET `order_id` = 19327 , `title` = '1 Year Extended Warranty' , `sku` = 'WARRANTY-S' , `num` = 2 , `price` = 1398 , `discount_price` = 1398 , `create_time` = '2026-09-11 02:50:27' [ RunTime:0.000275s ]
[2026-09-11 02:50:27][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000720s ]
[2026-09-11 02:50:27][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000525s ]
[2026-09-11 02:50:27][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000542s ]
[2026-09-11 02:50:27][sql] INSERT INTO `sp_order_shipping` SET `order_id` = 19327 , `last_name` = 'Brown' , `first_name` = 'Stephen' , `name` = 'StephenBrown' , `address1` = '955 N Orlando Ave,' , `province` = 'FL' , `zip` = '32751' , `city` = 'Maitland' , `country` = 'US' , `country_code` = 'US' , `phone` = '+14135304712' , `create_time` = '2026-09-11 02:50:27' [ RunTime:0.001424s ]
[2026-09-11 02:50:27][sql] SHOW FULL COLUMNS FROM `sp_order_extend` [ RunTime:0.000598s ]
[2026-09-11 02:50:27][sql] INSERT INTO `sp_order_extend` SET `order_id` = 19327 , `bank_account` = '251704' [ RunTime:0.001486s ]
[2026-09-11 02:53:28][sql] CONNECT:[ UseTime:0.000869s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 02:53:28][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000609s ]
[2026-09-11 02:53:28][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000539s ]
[2026-09-11 02:53:28][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000536s ]
[2026-09-11 02:53:28][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1789065668241010' LIMIT 1 [ RunTime:0.026916s ]
[2026-09-11 02:53:28][sql] SHOW FULL COLUMNS FROM `sp_order_oceanpay` [ RunTime:0.000665s ]
[2026-09-11 02:53:28][sql] INSERT INTO `sp_order_oceanpay` SET `order_no` = '1789065668241010' , `quickpay_id` = '76c66d76-ea01-407b-8cc7-14de933b2d9a' , `web_url` = 'https://gadgets.pleasantonstore.com' , `create_time` = '2026-09-11 02:53:27' [ RunTime:0.002654s ]
[2026-09-11 02:53:28][sql] CONNECT:[ UseTime:0.001183s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 02:53:28][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000691s ]
[2026-09-11 02:53:28][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000450s ]
[2026-09-11 02:53:43][sql] CONNECT:[ UseTime:0.001012s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 02:53:43][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000770s ]
[2026-09-11 02:53:43][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000384s ]
[2026-09-11 02:53:43][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000526s ]
[2026-09-11 02:53:43][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1789066227551110' LIMIT 1 [ RunTime:0.024822s ]
[2026-09-11 02:53:43][sql] SHOW FULL COLUMNS FROM `sp_order_oceanpay` [ RunTime:0.000522s ]
[2026-09-11 02:53:43][sql] INSERT INTO `sp_order_oceanpay` SET `order_no` = '1789066227551110' , `quickpay_id` = '73b69635-9224-4ad5-a055-7b344a704d65' , `web_url` = 'https://gadgets.pleasantonstore.com' , `create_time` = '2026-09-11 02:53:40' [ RunTime:0.002258s ]
[2026-09-11 02:53:43][sql] CONNECT:[ UseTime:0.001328s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 02:53:43][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000854s ]
[2026-09-11 02:53:43][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000447s ]
[2026-09-11 02:53:43][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000590s ]
[2026-09-11 02:53:43][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1789066227551110' LIMIT 1 [ RunTime:0.025249s ]
[2026-09-11 02:53:44][sql] CONNECT:[ UseTime:0.001235s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 02:53:44][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000744s ]
[2026-09-11 02:53:44][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000396s ]
[2026-09-11 02:53:44][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000586s ]
[2026-09-11 02:53:44][sql] SELECT * FROM `sp_order` `t` LEFT JOIN `sp_order_shipping` `order_shipping` ON `t`.`id`=`order_shipping`.`order_id` WHERE  `order_no` = '1789066227551110' LIMIT 1 [ RunTime:0.027432s ]
[2026-09-11 02:53:44][sql] UPDATE `sp_order`  SET `transaction_id` = '260911025341617945034' , `status` = 'COMPLETED' , `order_time` = '2026-09-11 02:53:43' , `pay_time` = '2026-09-11 02:53:43'  WHERE  `order_no` = '1789066227551110' [ RunTime:0.030914s ]
[2026-09-11 02:53:44][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1789066227551110' LIMIT 1 [ RunTime:0.026252s ]
[2026-09-11 02:53:44][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000677s ]
[2026-09-11 02:53:44][sql] SELECT * FROM `sp_order_shipping` WHERE  `order_id` = 19327 LIMIT 1 [ RunTime:0.000379s ]
[2026-09-11 02:53:44][sql] SHOW FULL COLUMNS FROM `sp_order_item` [ RunTime:0.000530s ]
[2026-09-11 02:53:44][sql] SELECT * FROM `sp_order_item` WHERE  `order_id` = 19327 [ RunTime:0.019386s ]
[2026-09-11 02:53:44][sql] SHOW FULL COLUMNS FROM `sp_order_extend` [ RunTime:0.000665s ]
[2026-09-11 02:53:44][sql] SELECT * FROM `sp_order_extend` WHERE  `order_id` = 19327 LIMIT 1 [ RunTime:0.005148s ]
[2026-09-11 02:53:44][sql] UPDATE `sp_order`  SET `push_erp_status` = 1 , `push_erp_time` = '2026-09-11 02:53:44'  WHERE  `order_no` = '1789066227551110' [ RunTime:0.035212s ]
[2026-09-11 02:53:44][sql] CONNECT:[ UseTime:0.001322s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 02:53:44][sql] SHOW FULL COLUMNS FROM `sp_goods` [ RunTime:0.000606s ]
[2026-09-11 02:53:44][sql] SELECT * FROM `sp_goods` WHERE  `name` = 'GalaxyUpsell' LIMIT 1 [ RunTime:0.000363s ]
[2026-09-11 02:53:45][sql] CONNECT:[ UseTime:0.001165s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 02:53:45][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000677s ]
[2026-09-11 02:53:45][sql] SELECT * FROM `sp_order` `t` LEFT JOIN `sp_order_shipping` `order_shipping` ON `t`.`id`=`order_shipping`.`order_id` WHERE  `order_no` = '1789066227551110' LIMIT 1 [ RunTime:0.030228s ]
[2026-09-11 02:53:45][sql] CONNECT:[ UseTime:0.001217s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 02:53:45][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000745s ]
[2026-09-11 02:53:45][sql] SELECT * FROM `sp_order` `t` LEFT JOIN `sp_order_shipping` `order_shipping` ON `t`.`id`=`order_shipping`.`order_id` WHERE  `order_no` = '1789066227551110' LIMIT 1 [ RunTime:0.038333s ]
[2026-09-11 02:53:45][sql] CONNECT:[ UseTime:0.001423s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 02:53:45][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.001110s ]
[2026-09-11 02:53:45][sql] SELECT * FROM `sp_order` `t` LEFT JOIN `sp_order_shipping` `order_shipping` ON `t`.`id`=`order_shipping`.`order_id` WHERE  `order_no` = '1789066227551110' LIMIT 1 [ RunTime:0.035422s ]
[2026-09-11 02:53:46][sql] CONNECT:[ UseTime:0.000973s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 02:53:46][sql] SHOW FULL COLUMNS FROM `sp_goods` [ RunTime:0.000901s ]
[2026-09-11 02:53:46][sql] SELECT * FROM `sp_goods` WHERE  `name` = 'GalaxyUpsell' LIMIT 1 [ RunTime:0.000363s ]
[2026-09-11 02:53:49][sql] CONNECT:[ UseTime:0.001250s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 02:53:49][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000717s ]
[2026-09-11 02:53:49][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1789066227551110' LIMIT 1 [ RunTime:0.034302s ]
[2026-09-11 02:53:49][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1789066227551110' LIMIT 1 [ RunTime:0.034947s ]
[2026-09-11 02:53:49][sql] SHOW FULL COLUMNS FROM `sp_order_upsell` [ RunTime:0.000809s ]
[2026-09-11 02:53:49][sql] SELECT * FROM `sp_order_upsell` WHERE  `order_no` = '1789066227551110'  AND `status` = 'COMPLETED' [ RunTime:0.000426s ]
[2026-09-11 02:53:49][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000577s ]
[2026-09-11 02:53:49][sql] SELECT * FROM `sp_order_shipping` WHERE  `order_id` = 19327 LIMIT 1 [ RunTime:0.000371s ]
[2026-09-11 02:53:50][sql] CONNECT:[ UseTime:0.001329s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 02:53:50][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000752s ]
[2026-09-11 02:53:50][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1789066227551110' LIMIT 1 [ RunTime:0.025589s ]
[2026-09-11 02:53:50][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1789066227551110' LIMIT 1 [ RunTime:0.026250s ]
[2026-09-11 02:53:50][sql] SHOW FULL COLUMNS FROM `sp_order_upsell` [ RunTime:0.000642s ]
[2026-09-11 02:53:50][sql] SELECT * FROM `sp_order_upsell` WHERE  `order_no` = '1789066227551110'  AND `status` = 'COMPLETED' [ RunTime:0.000368s ]
[2026-09-11 02:53:50][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000393s ]
[2026-09-11 02:53:50][sql] SELECT * FROM `sp_order_shipping` WHERE  `order_id` = 19327 LIMIT 1 [ RunTime:0.000264s ]
[2026-09-11 02:53:51][sql] CONNECT:[ UseTime:0.000875s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 02:53:51][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000594s ]
[2026-09-11 02:53:51][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1789066227551110' LIMIT 1 [ RunTime:0.026212s ]
[2026-09-11 02:53:51][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1789066227551110' LIMIT 1 [ RunTime:0.027002s ]
[2026-09-11 02:53:51][sql] SHOW FULL COLUMNS FROM `sp_order_upsell` [ RunTime:0.000687s ]
[2026-09-11 02:53:51][sql] SELECT * FROM `sp_order_upsell` WHERE  `order_no` = '1789066227551110'  AND `status` = 'COMPLETED' [ RunTime:0.000449s ]
[2026-09-11 02:53:51][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000415s ]
[2026-09-11 02:53:51][sql] SELECT * FROM `sp_order_shipping` WHERE  `order_id` = 19327 LIMIT 1 [ RunTime:0.000270s ]
[2026-09-11 02:53:51][sql] CONNECT:[ UseTime:0.000972s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 02:53:51][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000676s ]
[2026-09-11 02:53:51][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1789066227551110' LIMIT 1 [ RunTime:0.025106s ]
[2026-09-11 02:53:51][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1789066227551110' LIMIT 1 [ RunTime:0.025888s ]
[2026-09-11 02:53:51][sql] SHOW FULL COLUMNS FROM `sp_order_upsell` [ RunTime:0.000622s ]
[2026-09-11 02:53:51][sql] SELECT * FROM `sp_order_upsell` WHERE  `order_no` = '1789066227551110'  AND `status` = 'COMPLETED' [ RunTime:0.000379s ]
[2026-09-11 02:53:51][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000420s ]
[2026-09-11 02:53:51][sql] SELECT * FROM `sp_order_shipping` WHERE  `order_id` = 19327 LIMIT 1 [ RunTime:0.000430s ]
[2026-09-11 02:55:38][sql] CONNECT:[ UseTime:0.000992s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 02:55:38][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000747s ]
[2026-09-11 02:55:38][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000463s ]
[2026-09-11 02:55:38][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000521s ]
[2026-09-11 02:55:38][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1789065668241010' LIMIT 1 [ RunTime:0.025070s ]
[2026-09-11 03:05:38][sql] CONNECT:[ UseTime:0.001049s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 03:05:38][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000689s ]
[2026-09-11 03:05:38][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000372s ]
[2026-09-11 03:05:38][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000428s ]
[2026-09-11 03:05:38][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1789066227551110' LIMIT 1 [ RunTime:0.027563s ]
[2026-09-11 04:02:04][sql] CONNECT:[ UseTime:0.000966s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 04:02:04][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000559s ]
[2026-09-11 04:02:04][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000703s ]
[2026-09-11 08:12:13][sql] CONNECT:[ UseTime:0.000757s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 08:12:13][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000632s ]
[2026-09-11 08:12:13][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000422s ]
[2026-09-11 17:28:24][sql] CONNECT:[ UseTime:0.000909s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 17:28:24][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000592s ]
[2026-09-11 17:28:24][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000447s ]
[2026-09-11 18:44:46][sql] CONNECT:[ UseTime:0.001071s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 18:44:46][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000753s ]
[2026-09-11 18:44:46][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000599s ]
[2026-09-11 18:44:46][sql] CONNECT:[ UseTime:0.000968s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 18:44:46][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000660s ]
[2026-09-11 18:44:46][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000482s ]
[2026-09-11 19:18:32][sql] CONNECT:[ UseTime:0.000897s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-11 19:18:32][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000651s ]
[2026-09-11 19:18:32][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000389s ]