[2026-10-21 00:34:35][sql] CONNECT:[ UseTime:0.001005s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 00:34:35][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000788s ]
[2026-10-21 00:34:35][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000616s ]
[2026-10-21 00:41:40][sql] CONNECT:[ UseTime:0.000952s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 00:41:40][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000664s ]
[2026-10-21 00:41:40][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000415s ]
[2026-10-21 00:44:03][sql] CONNECT:[ UseTime:0.001049s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 00:44:03][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000704s ]
[2026-10-21 00:44:03][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000458s ]
[2026-10-21 00:45:04][sql] CONNECT:[ UseTime:0.001041s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 00:45:04][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000670s ]
[2026-10-21 00:45:04][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000547s ]
[2026-10-21 01:18:55][sql] CONNECT:[ UseTime:0.001190s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 01:18:55][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000710s ]
[2026-10-21 01:18:55][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000548s ]
[2026-10-21 01:30:39][sql] CONNECT:[ UseTime:0.001086s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 01:30:39][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000638s ]
[2026-10-21 01:30:39][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000432s ]
[2026-10-21 01:31:41][sql] CONNECT:[ UseTime:0.001074s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 01:31:41][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000646s ]
[2026-10-21 01:31:41][sql] INSERT INTO `sp_order` SET `order_no` = '1792517501478710' , `web_url` = 'https://pleasantonstore.com' , `payment_method` = 'oceanpayment' , `discount` = 3999 , `currency` = 'USD' , `product_info` = '{\"payment_method\":\"oceanpayment\",\"qty\":1,\"discount\":-39.99,\"shipping\":{\"first_name\":\"Ramona\",\"second_name\":\"Orzell\",\"email\":\"orzellrjo@gmail.com\",\"phone_full\":\"+12533436049\",\"country\":\"US\",\"city\":\"Rocky Mount\",\"province\":\"NC\",\"address\":\"1105 Turnstone Drive,\",\"code\":\"27803\",\"domain_name\":\"gadgets.pleasantonstore.com\"},\"total\":\"$52.97\",\"amount\":\"52.97\",\"shipping_fee\":\"5.99\",\"product\":[{\"id\":18,\"qty\":\"1\",\"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\":\"$\"},{\"id\":16,\"qty\":1,\"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\":\"1792517501478710\",\"email\":\"orzellrjo@gmail.com\"}' , `total_amount` = 5297 , `pay_amount` = 5297 , `shipping_fee` = 599 , `email` = 'orzellrjo@gmail.com' , `create_time` = '2026-10-21 01:31:41' [ RunTime:0.002155s ]
[2026-10-21 01:31:41][sql] SHOW FULL COLUMNS FROM `sp_order_item` [ RunTime:0.000561s ]
[2026-10-21 01:31:41][sql] INSERT INTO `sp_order_item` SET `order_id` = 19365 , `title` = 'Single Galaxy Ball' , `sku` = 'TY21146-C513' , `num` = 1 , `price` = 7998 , `discount_price` = 3999 , `create_time` = '2026-10-21 01:31:41' [ RunTime:0.000230s ]
[2026-10-21 01:31:41][sql] INSERT INTO `sp_order_item` SET `order_id` = 19365 , `title` = '1 Year Extended Warranty' , `sku` = 'WARRANTY-S' , `num` = 1 , `price` = 1398 , `discount_price` = 699 , `create_time` = '2026-10-21 01:31:41' [ RunTime:0.000165s ]
[2026-10-21 01:31:41][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000642s ]
[2026-10-21 01:31:41][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000355s ]
[2026-10-21 01:31:41][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000357s ]
[2026-10-21 01:31:41][sql] INSERT INTO `sp_order_shipping` SET `order_id` = 19365 , `last_name` = 'Orzell' , `first_name` = 'Ramona' , `name` = 'RamonaOrzell' , `address1` = '1105 Turnstone Drive,' , `province` = 'NC' , `zip` = '27803' , `city` = 'Rocky Mount' , `country` = 'US' , `country_code` = 'US' , `phone` = '+12533436049' , `create_time` = '2026-10-21 01:31:41' [ RunTime:0.001224s ]
[2026-10-21 01:31:41][sql] SHOW FULL COLUMNS FROM `sp_order_extend` [ RunTime:0.000356s ]
[2026-10-21 01:31:41][sql] INSERT INTO `sp_order_extend` SET `order_id` = 19365 , `bank_account` = '251704' [ RunTime:0.000470s ]
[2026-10-21 01:33:09][sql] CONNECT:[ UseTime:0.001053s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 01:33:09][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000797s ]
[2026-10-21 01:33:09][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000459s ]
[2026-10-21 01:33:09][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000512s ]
[2026-10-21 01:33:09][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1792517501478710' LIMIT 1 [ RunTime:0.026155s ]
[2026-10-21 01:33:09][sql] SHOW FULL COLUMNS FROM `sp_order_oceanpay` [ RunTime:0.000647s ]
[2026-10-21 01:33:09][sql] INSERT INTO `sp_order_oceanpay` SET `order_no` = '1792517501478710' , `quickpay_id` = '89f25d51-6dd9-439d-b944-cc03a079cb5a' , `web_url` = 'https://gadgets.pleasantonstore.com' , `create_time` = '2026-10-21 01:33:07' [ RunTime:0.001902s ]
[2026-10-21 01:33:09][sql] CONNECT:[ UseTime:0.001154s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 01:33:09][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000745s ]
[2026-10-21 01:33:09][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000412s ]
[2026-10-21 01:33:09][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000456s ]
[2026-10-21 01:33:09][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1792517501478710' LIMIT 1 [ RunTime:0.025816s ]
[2026-10-21 01:33:10][sql] CONNECT:[ UseTime:0.001026s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 01:33:10][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000822s ]
[2026-10-21 01:33:10][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000458s ]
[2026-10-21 01:33:10][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000585s ]
[2026-10-21 01:33:10][sql] SELECT * FROM `sp_order` `t` LEFT JOIN `sp_order_shipping` `order_shipping` ON `t`.`id`=`order_shipping`.`order_id` WHERE  `order_no` = '1792517501478710' LIMIT 1 [ RunTime:0.025053s ]
[2026-10-21 01:33:10][sql] UPDATE `sp_order`  SET `transaction_id` = '261021013307976978003' , `status` = 'COMPLETED' , `order_time` = '2026-10-21 01:33:09' , `pay_time` = '2026-10-21 01:33:09'  WHERE  `order_no` = '1792517501478710' [ RunTime:0.031752s ]
[2026-10-21 01:33:10][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1792517501478710' LIMIT 1 [ RunTime:0.024218s ]
[2026-10-21 01:33:10][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000697s ]
[2026-10-21 01:33:10][sql] SELECT * FROM `sp_order_shipping` WHERE  `order_id` = 19365 LIMIT 1 [ RunTime:0.000408s ]
[2026-10-21 01:33:10][sql] SHOW FULL COLUMNS FROM `sp_order_item` [ RunTime:0.000525s ]
[2026-10-21 01:33:10][sql] SELECT * FROM `sp_order_item` WHERE  `order_id` = 19365 [ RunTime:0.019327s ]
[2026-10-21 01:33:10][sql] SHOW FULL COLUMNS FROM `sp_order_extend` [ RunTime:0.000665s ]
[2026-10-21 01:33:10][sql] SELECT * FROM `sp_order_extend` WHERE  `order_id` = 19365 LIMIT 1 [ RunTime:0.004930s ]
[2026-10-21 01:33:10][sql] UPDATE `sp_order`  SET `push_erp_status` = 1 , `push_erp_time` = '2026-10-21 01:33:10'  WHERE  `order_no` = '1792517501478710' [ RunTime:0.032797s ]
[2026-10-21 01:33:10][sql] CONNECT:[ UseTime:0.001223s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 01:33:10][sql] SHOW FULL COLUMNS FROM `sp_goods` [ RunTime:0.000553s ]
[2026-10-21 01:33:10][sql] SELECT * FROM `sp_goods` WHERE  `name` = 'GalaxyUpsell' LIMIT 1 [ RunTime:0.000311s ]
[2026-10-21 01:33:32][sql] CONNECT:[ UseTime:0.000973s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 01:33:32][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000695s ]
[2026-10-21 01:33:32][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1792517501478710' LIMIT 1 [ RunTime:0.024317s ]
[2026-10-21 01:33:32][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1792517501478710' LIMIT 1 [ RunTime:0.026134s ]
[2026-10-21 01:33:32][sql] SHOW FULL COLUMNS FROM `sp_order_upsell` [ RunTime:0.000688s ]
[2026-10-21 01:33:32][sql] SELECT * FROM `sp_order_upsell` WHERE  `order_no` = '1792517501478710'  AND `status` = 'COMPLETED' [ RunTime:0.000397s ]
[2026-10-21 01:33:32][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000698s ]
[2026-10-21 01:33:32][sql] SELECT * FROM `sp_order_shipping` WHERE  `order_id` = 19365 LIMIT 1 [ RunTime:0.000405s ]
[2026-10-21 01:34:34][sql] CONNECT:[ UseTime:0.001034s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 01:34:34][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000685s ]
[2026-10-21 01:34:34][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1792517501478710' LIMIT 1 [ RunTime:0.024438s ]
[2026-10-21 01:34:34][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1792517501478710' LIMIT 1 [ RunTime:0.023526s ]
[2026-10-21 01:34:34][sql] SHOW FULL COLUMNS FROM `sp_order_upsell` [ RunTime:0.000628s ]
[2026-10-21 01:34:34][sql] SELECT * FROM `sp_order_upsell` WHERE  `order_no` = '1792517501478710'  AND `status` = 'COMPLETED' [ RunTime:0.000400s ]
[2026-10-21 01:34:34][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000420s ]
[2026-10-21 01:34:34][sql] SELECT * FROM `sp_order_shipping` WHERE  `order_id` = 19365 LIMIT 1 [ RunTime:0.000369s ]
[2026-10-21 01:34:37][sql] CONNECT:[ UseTime:0.000846s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 01:34:37][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000748s ]
[2026-10-21 01:34:37][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1792517501478710' LIMIT 1 [ RunTime:0.023356s ]
[2026-10-21 01:34:37][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1792517501478710' LIMIT 1 [ RunTime:0.025268s ]
[2026-10-21 01:34:37][sql] SHOW FULL COLUMNS FROM `sp_order_upsell` [ RunTime:0.000664s ]
[2026-10-21 01:34:37][sql] SELECT * FROM `sp_order_upsell` WHERE  `order_no` = '1792517501478710'  AND `status` = 'COMPLETED' [ RunTime:0.000415s ]
[2026-10-21 01:34:37][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000416s ]
[2026-10-21 01:34:37][sql] SELECT * FROM `sp_order_shipping` WHERE  `order_id` = 19365 LIMIT 1 [ RunTime:0.000328s ]
[2026-10-21 01:45:38][sql] CONNECT:[ UseTime:0.000867s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 01:45:38][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000593s ]
[2026-10-21 01:45:38][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000403s ]
[2026-10-21 01:45:38][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000464s ]
[2026-10-21 01:45:38][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1792517501478710' LIMIT 1 [ RunTime:0.023368s ]
[2026-10-21 01:51:54][sql] CONNECT:[ UseTime:0.001126s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 01:51:54][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000658s ]
[2026-10-21 01:51:54][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000499s ]
[2026-10-21 02:29:46][sql] CONNECT:[ UseTime:0.000973s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 02:29:46][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000601s ]
[2026-10-21 02:29:46][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000483s ]
[2026-10-21 02:51:35][sql] CONNECT:[ UseTime:0.001037s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 02:51:35][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000652s ]
[2026-10-21 02:51:35][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000516s ]
[2026-10-21 02:53:47][sql] CONNECT:[ UseTime:0.001112s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 02:53:47][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000713s ]
[2026-10-21 02:53:47][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000528s ]
[2026-10-21 03:14:14][sql] CONNECT:[ UseTime:0.000990s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 03:14:14][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000747s ]
[2026-10-21 03:14:14][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000509s ]
[2026-10-21 03:52:21][sql] CONNECT:[ UseTime:0.001012s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 03:52:21][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000583s ]
[2026-10-21 03:52:21][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000468s ]
[2026-10-21 03:52:26][sql] CONNECT:[ UseTime:0.001054s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 03:52:26][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000604s ]
[2026-10-21 03:52:26][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000459s ]
[2026-10-21 04:00:48][sql] CONNECT:[ UseTime:0.001006s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 04:00:48][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000657s ]
[2026-10-21 04:00:48][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000541s ]
[2026-10-21 04:22:51][sql] CONNECT:[ UseTime:0.000934s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 04:22:51][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000593s ]
[2026-10-21 04:22:51][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000416s ]
[2026-10-21 04:27:37][sql] CONNECT:[ UseTime:0.000897s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 04:27:37][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000623s ]
[2026-10-21 04:27:37][sql] INSERT INTO `sp_order` SET `order_no` = '1792528057786010' , `web_url` = 'https://pleasantonstore.com' , `payment_method` = 'oceanpayment' , `discount` = 25250 , `currency` = 'USD' , `product_info` = '{\"payment_method\":\"oceanpayment\",\"qty\":1,\"discount\":-252.49999999999997,\"shipping\":{\"first_name\":\"Brenda\",\"second_name\":\"Wilson\",\"email\":\"shutterbug135@yahoo.com\",\"phone_full\":\"+17163864821\",\"country\":\"US\",\"city\":\"Bemus point\",\"province\":\"NY\",\"address\":\"3680 Crestview rd,\",\"code\":\"14712\",\"domain_name\":\"gadgets.pleasantonstore.com\"},\"total\":\"$163.92\",\"amount\":\"163.92\",\"shipping_fee\":\"0.00\",\"product\":[{\"id\":18,\"qty\":\"4\",\"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\":135.96},{\"id\":16,\"qty\":\"4\",\"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\":\"1792528057786010\",\"email\":\"shutterbug135@yahoo.com\"}' , `total_amount` = 16392 , `pay_amount` = 16392 , `shipping_fee` = 0 , `email` = 'shutterbug135@yahoo.com' , `create_time` = '2026-10-21 04:27:37' [ RunTime:0.005688s ]
[2026-10-21 04:27:37][sql] SHOW FULL COLUMNS FROM `sp_order_item` [ RunTime:0.000514s ]
[2026-10-21 04:27:37][sql] INSERT INTO `sp_order_item` SET `order_id` = 19366 , `title` = 'Single Galaxy Ball' , `sku` = 'TY21146-C513' , `num` = 4 , `price` = 7998 , `discount_price` = 13596 , `create_time` = '2026-10-21 04:27:37' [ RunTime:0.000237s ]
[2026-10-21 04:27:37][sql] INSERT INTO `sp_order_item` SET `order_id` = 19366 , `title` = '1 Year Extended Warranty' , `sku` = 'WARRANTY-S' , `num` = 4 , `price` = 1398 , `discount_price` = 2796 , `create_time` = '2026-10-21 04:27:37' [ RunTime:0.000206s ]
[2026-10-21 04:27:37][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000661s ]
[2026-10-21 04:27:37][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000429s ]
[2026-10-21 04:27:37][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000431s ]
[2026-10-21 04:27:37][sql] INSERT INTO `sp_order_shipping` SET `order_id` = 19366 , `last_name` = 'Wilson' , `first_name` = 'Brenda' , `name` = 'BrendaWilson' , `address1` = '3680 Crestview rd,' , `province` = 'NY' , `zip` = '14712' , `city` = 'Bemus point' , `country` = 'US' , `country_code` = 'US' , `phone` = '+17163864821' , `create_time` = '2026-10-21 04:27:37' [ RunTime:0.001530s ]
[2026-10-21 04:27:37][sql] SHOW FULL COLUMNS FROM `sp_order_extend` [ RunTime:0.000414s ]
[2026-10-21 04:27:37][sql] INSERT INTO `sp_order_extend` SET `order_id` = 19366 , `bank_account` = '251704' [ RunTime:0.000747s ]
[2026-10-21 04:29:59][sql] CONNECT:[ UseTime:0.001106s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 04:29:59][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000616s ]
[2026-10-21 04:29:59][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000370s ]
[2026-10-21 04:29:59][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000511s ]
[2026-10-21 04:29:59][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1792528057786010' LIMIT 1 [ RunTime:0.022966s ]
[2026-10-21 04:29:59][sql] SHOW FULL COLUMNS FROM `sp_order_oceanpay` [ RunTime:0.000782s ]
[2026-10-21 04:29:59][sql] INSERT INTO `sp_order_oceanpay` SET `order_no` = '1792528057786010' , `quickpay_id` = '56c08635-2216-436d-a6bc-d6c1866e0923' , `web_url` = 'https://gadgets.pleasantonstore.com' , `create_time` = '2026-10-21 04:29:57' [ RunTime:0.002054s ]
[2026-10-21 04:30:00][sql] CONNECT:[ UseTime:0.001408s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 04:30:00][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000820s ]
[2026-10-21 04:30:00][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000581s ]
[2026-10-21 04:30:00][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000682s ]
[2026-10-21 04:30:00][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1792528057786010' LIMIT 1 [ RunTime:0.030113s ]
[2026-10-21 04:30:00][sql] CONNECT:[ UseTime:0.000893s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 04:30:00][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000805s ]
[2026-10-21 04:30:00][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000472s ]
[2026-10-21 04:30:00][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000568s ]
[2026-10-21 04:30:00][sql] SELECT * FROM `sp_order` `t` LEFT JOIN `sp_order_shipping` `order_shipping` ON `t`.`id`=`order_shipping`.`order_id` WHERE  `order_no` = '1792528057786010' LIMIT 1 [ RunTime:0.024105s ]
[2026-10-21 04:30:00][sql] UPDATE `sp_order`  SET `transaction_id` = '261021042957703725016' , `status` = 'COMPLETED' , `order_time` = '2026-10-21 04:29:59' , `pay_time` = '2026-10-21 04:29:59'  WHERE  `order_no` = '1792528057786010' [ RunTime:0.029044s ]
[2026-10-21 04:30:00][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1792528057786010' LIMIT 1 [ RunTime:0.024497s ]
[2026-10-21 04:30:00][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000777s ]
[2026-10-21 04:30:00][sql] SELECT * FROM `sp_order_shipping` WHERE  `order_id` = 19366 LIMIT 1 [ RunTime:0.000846s ]
[2026-10-21 04:30:00][sql] SHOW FULL COLUMNS FROM `sp_order_item` [ RunTime:0.000600s ]
[2026-10-21 04:30:00][sql] SELECT * FROM `sp_order_item` WHERE  `order_id` = 19366 [ RunTime:0.020143s ]
[2026-10-21 04:30:00][sql] SHOW FULL COLUMNS FROM `sp_order_extend` [ RunTime:0.000645s ]
[2026-10-21 04:30:00][sql] SELECT * FROM `sp_order_extend` WHERE  `order_id` = 19366 LIMIT 1 [ RunTime:0.005790s ]
[2026-10-21 04:30:00][sql] UPDATE `sp_order`  SET `push_erp_status` = 1 , `push_erp_time` = '2026-10-21 04:30:00'  WHERE  `order_no` = '1792528057786010' [ RunTime:0.036607s ]
[2026-10-21 04:30:00][sql] CONNECT:[ UseTime:0.001096s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 04:30:00][sql] SHOW FULL COLUMNS FROM `sp_goods` [ RunTime:0.000958s ]
[2026-10-21 04:30:00][sql] SELECT * FROM `sp_goods` WHERE  `name` = 'GalaxyUpsell' LIMIT 1 [ RunTime:0.000348s ]
[2026-10-21 04:30:38][sql] CONNECT:[ UseTime:0.000959s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 04:30:38][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000744s ]
[2026-10-21 04:30:38][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1792528057786010' LIMIT 1 [ RunTime:0.024508s ]
[2026-10-21 04:30:38][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1792528057786010' LIMIT 1 [ RunTime:0.025809s ]
[2026-10-21 04:30:38][sql] SHOW FULL COLUMNS FROM `sp_order_upsell` [ RunTime:0.000641s ]
[2026-10-21 04:30:38][sql] SELECT * FROM `sp_order_upsell` WHERE  `order_no` = '1792528057786010'  AND `status` = 'COMPLETED' [ RunTime:0.000433s ]
[2026-10-21 04:30:38][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000497s ]
[2026-10-21 04:30:38][sql] SELECT * FROM `sp_order_shipping` WHERE  `order_id` = 19366 LIMIT 1 [ RunTime:0.000298s ]
[2026-10-21 04:35:33][sql] CONNECT:[ UseTime:0.001116s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 04:35:33][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000656s ]
[2026-10-21 04:35:33][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000661s ]
[2026-10-21 04:40:38][sql] CONNECT:[ UseTime:0.001221s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 04:40:38][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000620s ]
[2026-10-21 04:40:38][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000474s ]
[2026-10-21 04:40:38][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000515s ]
[2026-10-21 04:40:38][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1792528057786010' LIMIT 1 [ RunTime:0.023108s ]
[2026-10-21 04:54:53][sql] CONNECT:[ UseTime:0.001385s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 04:54:53][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000706s ]
[2026-10-21 04:54:53][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000487s ]
[2026-10-21 05:06:27][sql] CONNECT:[ UseTime:0.001319s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 05:06:27][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000791s ]
[2026-10-21 05:06:27][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000565s ]
[2026-10-21 05:07:18][sql] CONNECT:[ UseTime:0.001067s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 05:07:18][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000583s ]
[2026-10-21 05:07:18][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000417s ]
[2026-10-21 05:33:30][sql] CONNECT:[ UseTime:0.000894s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 05:33:30][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000735s ]
[2026-10-21 05:33:30][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000507s ]
[2026-10-21 06:15:57][sql] CONNECT:[ UseTime:0.003381s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 06:15:57][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000783s ]
[2026-10-21 06:15:57][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000499s ]
[2026-10-21 07:33:31][sql] CONNECT:[ UseTime:0.000843s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 07:33:31][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000594s ]
[2026-10-21 07:33:31][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000487s ]
[2026-10-21 08:14:06][sql] CONNECT:[ UseTime:0.001339s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 08:14:06][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000766s ]
[2026-10-21 08:14:06][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000515s ]
[2026-10-21 08:16:46][sql] CONNECT:[ UseTime:0.000855s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 08:16:46][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000698s ]
[2026-10-21 08:16:46][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000403s ]
[2026-10-21 08:28:03][sql] CONNECT:[ UseTime:0.000985s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 08:28:03][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000642s ]
[2026-10-21 08:28:03][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000550s ]
[2026-10-21 08:28:04][sql] CONNECT:[ UseTime:0.000901s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 08:28:04][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000541s ]
[2026-10-21 08:28:04][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000562s ]
[2026-10-21 09:10:46][sql] CONNECT:[ UseTime:0.001102s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 09:10:46][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000683s ]
[2026-10-21 09:10:46][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000508s ]
[2026-10-21 09:17:08][sql] CONNECT:[ UseTime:0.000833s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 09:17:08][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000531s ]
[2026-10-21 09:17:08][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000434s ]
[2026-10-21 09:45:07][sql] CONNECT:[ UseTime:0.000752s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 09:45:07][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000525s ]
[2026-10-21 09:45:07][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000498s ]
[2026-10-21 09:59:18][sql] CONNECT:[ UseTime:0.000816s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 09:59:18][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000520s ]
[2026-10-21 09:59:18][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000394s ]
[2026-10-21 10:14:29][sql] CONNECT:[ UseTime:0.001001s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 10:14:29][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000692s ]
[2026-10-21 10:14:29][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000528s ]
[2026-10-21 10:19:03][sql] CONNECT:[ UseTime:0.000940s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 10:19:03][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000692s ]
[2026-10-21 10:19:03][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000570s ]
[2026-10-21 10:24:24][sql] CONNECT:[ UseTime:0.000926s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 10:24:24][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000585s ]
[2026-10-21 10:24:24][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000465s ]
[2026-10-21 11:48:08][sql] CONNECT:[ UseTime:0.001294s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 11:48:08][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000807s ]
[2026-10-21 11:48:08][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000563s ]
[2026-10-21 12:17:43][sql] CONNECT:[ UseTime:0.000848s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 12:17:43][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000587s ]
[2026-10-21 12:17:43][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000523s ]
[2026-10-21 13:02:23][sql] CONNECT:[ UseTime:0.000945s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 13:02:23][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000604s ]
[2026-10-21 13:02:23][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000536s ]
[2026-10-21 13:05:21][sql] CONNECT:[ UseTime:0.001043s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 13:05:21][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000747s ]
[2026-10-21 13:05:21][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000444s ]
[2026-10-21 14:40:24][sql] CONNECT:[ UseTime:0.001336s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 14:40:24][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.001143s ]
[2026-10-21 14:40:24][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000534s ]
[2026-10-21 14:42:18][sql] CONNECT:[ UseTime:0.000882s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 14:42:18][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000607s ]
[2026-10-21 14:42:18][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000437s ]
[2026-10-21 15:03:41][sql] CONNECT:[ UseTime:0.000872s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 15:03:41][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000639s ]
[2026-10-21 15:03:41][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000444s ]
[2026-10-21 15:03:41][sql] CONNECT:[ UseTime:0.000883s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 15:03:41][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000821s ]
[2026-10-21 15:03:41][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000524s ]
[2026-10-21 15:56:38][sql] CONNECT:[ UseTime:0.001150s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 15:56:38][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000708s ]
[2026-10-21 15:56:38][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000529s ]
[2026-10-21 17:42:28][sql] CONNECT:[ UseTime:0.000931s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 17:42:28][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000566s ]
[2026-10-21 17:42:28][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000424s ]
[2026-10-21 18:57:23][sql] CONNECT:[ UseTime:0.000961s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 18:57:23][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000652s ]
[2026-10-21 18:57:23][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000384s ]
[2026-10-21 18:58:53][sql] CONNECT:[ UseTime:0.001076s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 18:58:53][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000691s ]
[2026-10-21 18:58:53][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000487s ]
[2026-10-21 20:26:02][sql] CONNECT:[ UseTime:0.001048s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 20:26:02][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000655s ]
[2026-10-21 20:26:02][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000565s ]
[2026-10-21 20:33:54][sql] CONNECT:[ UseTime:0.000876s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 20:33:54][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000673s ]
[2026-10-21 20:33:54][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000415s ]
[2026-10-21 21:22:07][sql] CONNECT:[ UseTime:0.001050s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 21:22:07][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000571s ]
[2026-10-21 21:22:07][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000457s ]
[2026-10-21 21:24:20][sql] CONNECT:[ UseTime:0.000905s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 21:24:20][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000555s ]
[2026-10-21 21:24:20][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000458s ]
[2026-10-21 21:27:53][sql] CONNECT:[ UseTime:0.001125s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 21:27:53][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000770s ]
[2026-10-21 21:27:53][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000544s ]
[2026-10-21 21:29:56][sql] CONNECT:[ UseTime:0.000962s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 21:29:56][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000765s ]
[2026-10-21 21:29:56][sql] INSERT INTO `sp_order` SET `order_no` = '1792589396752310' , `web_url` = 'https://pleasantonstore.com' , `payment_method` = 'oceanpayment' , `discount` = 3999 , `currency` = 'USD' , `product_info` = '{\"payment_method\":\"oceanpayment\",\"qty\":1,\"discount\":-39.99,\"shipping\":{\"first_name\":\"Jeff\",\"second_name\":\"Moore\",\"email\":\"wemoores1@gmail.com\",\"phone_full\":\"+12172992505\",\"country\":\"US\",\"city\":\"Springfield\",\"province\":\"IL\",\"address\":\"20 Ranger Dr,\",\"code\":\"62702\",\"domain_name\":\"gadgets.pleasantonstore.com\"},\"total\":\"$52.97\",\"amount\":\"52.97\",\"shipping_fee\":\"5.99\",\"product\":[{\"id\":18,\"qty\":\"1\",\"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\":\"$\"},{\"id\":16,\"qty\":1,\"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\":\"1792589396752310\",\"email\":\"wemoores1@gmail.com\"}' , `total_amount` = 5297 , `pay_amount` = 5297 , `shipping_fee` = 599 , `email` = 'wemoores1@gmail.com' , `create_time` = '2026-10-21 21:29:56' [ RunTime:0.002259s ]
[2026-10-21 21:29:56][sql] SHOW FULL COLUMNS FROM `sp_order_item` [ RunTime:0.000597s ]
[2026-10-21 21:29:56][sql] INSERT INTO `sp_order_item` SET `order_id` = 19367 , `title` = 'Single Galaxy Ball' , `sku` = 'TY21146-C513' , `num` = 1 , `price` = 7998 , `discount_price` = 3999 , `create_time` = '2026-10-21 21:29:56' [ RunTime:0.000251s ]
[2026-10-21 21:29:56][sql] INSERT INTO `sp_order_item` SET `order_id` = 19367 , `title` = '1 Year Extended Warranty' , `sku` = 'WARRANTY-S' , `num` = 1 , `price` = 1398 , `discount_price` = 699 , `create_time` = '2026-10-21 21:29:56' [ RunTime:0.000153s ]
[2026-10-21 21:29:56][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000645s ]
[2026-10-21 21:29:56][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000608s ]
[2026-10-21 21:29:56][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000692s ]
[2026-10-21 21:29:56][sql] INSERT INTO `sp_order_shipping` SET `order_id` = 19367 , `last_name` = 'Moore' , `first_name` = 'Jeff' , `name` = 'JeffMoore' , `address1` = '20 Ranger Dr,' , `province` = 'IL' , `zip` = '62702' , `city` = 'Springfield' , `country` = 'US' , `country_code` = 'US' , `phone` = '+12172992505' , `create_time` = '2026-10-21 21:29:56' [ RunTime:0.001302s ]
[2026-10-21 21:29:56][sql] SHOW FULL COLUMNS FROM `sp_order_extend` [ RunTime:0.000477s ]
[2026-10-21 21:29:56][sql] INSERT INTO `sp_order_extend` SET `order_id` = 19367 , `bank_account` = '251704' [ RunTime:0.000674s ]
[2026-10-21 21:33:50][sql] CONNECT:[ UseTime:0.001291s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 21:33:50][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000764s ]
[2026-10-21 21:33:50][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000480s ]
[2026-10-21 21:33:50][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000494s ]
[2026-10-21 21:33:50][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1792589396752310' LIMIT 1 [ RunTime:0.024318s ]
[2026-10-21 21:33:50][sql] SHOW FULL COLUMNS FROM `sp_order_oceanpay` [ RunTime:0.000670s ]
[2026-10-21 21:33:50][sql] INSERT INTO `sp_order_oceanpay` SET `order_no` = '1792589396752310' , `quickpay_id` = '253fb859-14cb-45ab-a14a-e8f7d490ab19' , `web_url` = 'https://gadgets.pleasantonstore.com' , `create_time` = '2026-10-21 21:33:48' [ RunTime:0.002618s ]
[2026-10-21 21:33:51][sql] CONNECT:[ UseTime:0.001054s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 21:33:51][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000668s ]
[2026-10-21 21:33:51][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000359s ]
[2026-10-21 21:33:51][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000531s ]
[2026-10-21 21:33:51][sql] SELECT * FROM `sp_order` `t` LEFT JOIN `sp_order_shipping` `order_shipping` ON `t`.`id`=`order_shipping`.`order_id` WHERE  `order_no` = '1792589396752310' LIMIT 1 [ RunTime:0.024252s ]
[2026-10-21 21:33:51][sql] UPDATE `sp_order`  SET `transaction_id` = '261021213348785882046' , `status` = 'COMPLETED' , `order_time` = '2026-10-21 21:33:51' , `pay_time` = '2026-10-21 21:33:51'  WHERE  `order_no` = '1792589396752310' [ RunTime:0.027952s ]
[2026-10-21 21:33:51][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1792589396752310' LIMIT 1 [ RunTime:0.022716s ]
[2026-10-21 21:33:51][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000967s ]
[2026-10-21 21:33:51][sql] SELECT * FROM `sp_order_shipping` WHERE  `order_id` = 19367 LIMIT 1 [ RunTime:0.000447s ]
[2026-10-21 21:33:51][sql] SHOW FULL COLUMNS FROM `sp_order_item` [ RunTime:0.000593s ]
[2026-10-21 21:33:51][sql] SELECT * FROM `sp_order_item` WHERE  `order_id` = 19367 [ RunTime:0.018185s ]
[2026-10-21 21:33:51][sql] SHOW FULL COLUMNS FROM `sp_order_extend` [ RunTime:0.000692s ]
[2026-10-21 21:33:51][sql] SELECT * FROM `sp_order_extend` WHERE  `order_id` = 19367 LIMIT 1 [ RunTime:0.005004s ]
[2026-10-21 21:33:51][sql] UPDATE `sp_order`  SET `push_erp_status` = 1 , `push_erp_time` = '2026-10-21 21:33:51'  WHERE  `order_no` = '1792589396752310' [ RunTime:0.030379s ]
[2026-10-21 21:33:51][sql] CONNECT:[ UseTime:0.000805s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 21:33:51][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000589s ]
[2026-10-21 21:33:51][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000493s ]
[2026-10-21 21:33:51][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000490s ]
[2026-10-21 21:33:51][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1792589396752310' LIMIT 1 [ RunTime:0.026742s ]
[2026-10-21 21:33:53][sql] CONNECT:[ UseTime:0.000941s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 21:33:53][sql] SHOW FULL COLUMNS FROM `sp_goods` [ RunTime:0.000611s ]
[2026-10-21 21:33:53][sql] SELECT * FROM `sp_goods` WHERE  `name` = 'GalaxyUpsell' LIMIT 1 [ RunTime:0.000353s ]
[2026-10-21 21:34:00][sql] CONNECT:[ UseTime:0.001246s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 21:34:00][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000714s ]
[2026-10-21 21:34:00][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1792589396752310' LIMIT 1 [ RunTime:0.024374s ]
[2026-10-21 21:34:00][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1792589396752310' LIMIT 1 [ RunTime:0.026127s ]
[2026-10-21 21:34:00][sql] SHOW FULL COLUMNS FROM `sp_order_upsell` [ RunTime:0.000789s ]
[2026-10-21 21:34:00][sql] SELECT * FROM `sp_order_upsell` WHERE  `order_no` = '1792589396752310'  AND `status` = 'COMPLETED' [ RunTime:0.000449s ]
[2026-10-21 21:34:00][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000555s ]
[2026-10-21 21:34:00][sql] SELECT * FROM `sp_order_shipping` WHERE  `order_id` = 19367 LIMIT 1 [ RunTime:0.000468s ]
[2026-10-21 21:45:38][sql] CONNECT:[ UseTime:0.001232s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-10-21 21:45:38][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000694s ]
[2026-10-21 21:45:38][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000438s ]
[2026-10-21 21:45:38][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000437s ]
[2026-10-21 21:45:38][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1792589396752310' LIMIT 1 [ RunTime:0.028877s ]