[2026-09-18 00:17:01][sql] CONNECT:[ UseTime:0.001084s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-18 00:17:01][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.001154s ]
[2026-09-18 00:17:01][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000697s ]
[2026-09-18 00:21:36][sql] CONNECT:[ UseTime:0.001176s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-18 00:21:36][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000641s ]
[2026-09-18 00:21:36][sql] INSERT INTO `sp_order` SET `order_no` = '1789662096105510' , `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\":\"Barbara\",\"second_name\":\"Johnson\",\"email\":\"baj0312@comcast.net\",\"phone_full\":\"+13035213124\",\"country\":\"US\",\"city\":\"Florence\",\"province\":\"AZ\",\"address\":\"8182 W Noble Prairie Way,\",\"code\":\"85132\",\"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\":\"1789662096105510\",\"email\":\"baj0312@comcast.net\"}' , `total_amount` = 5297 , `pay_amount` = 5297 , `shipping_fee` = 599 , `email` = 'baj0312@comcast.net' , `create_time` = '2026-09-18 00:21:36' [ RunTime:0.002869s ]
[2026-09-18 00:21:36][sql] SHOW FULL COLUMNS FROM `sp_order_item` [ RunTime:0.001598s ]
[2026-09-18 00:21:36][sql] INSERT INTO `sp_order_item` SET `order_id` = 19329 , `title` = 'Single Galaxy Ball' , `sku` = 'TY21146-C513' , `num` = 1 , `price` = 7998 , `discount_price` = 3999 , `create_time` = '2026-09-18 00:21:36' [ RunTime:0.000372s ]
[2026-09-18 00:21:36][sql] INSERT INTO `sp_order_item` SET `order_id` = 19329 , `title` = '1 Year Extended Warranty' , `sku` = 'WARRANTY-S' , `num` = 1 , `price` = 1398 , `discount_price` = 699 , `create_time` = '2026-09-18 00:21:36' [ RunTime:0.000241s ]
[2026-09-18 00:21:36][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000842s ]
[2026-09-18 00:21:36][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000492s ]
[2026-09-18 00:21:36][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.002106s ]
[2026-09-18 00:21:36][sql] INSERT INTO `sp_order_shipping` SET `order_id` = 19329 , `last_name` = 'Johnson' , `first_name` = 'Barbara' , `name` = 'BarbaraJohnson' , `address1` = '8182 W Noble Prairie Way,' , `province` = 'AZ' , `zip` = '85132' , `city` = 'Florence' , `country` = 'US' , `country_code` = 'US' , `phone` = '+13035213124' , `create_time` = '2026-09-18 00:21:36' [ RunTime:0.002174s ]
[2026-09-18 00:21:36][sql] SHOW FULL COLUMNS FROM `sp_order_extend` [ RunTime:0.001835s ]
[2026-09-18 00:21:36][sql] INSERT INTO `sp_order_extend` SET `order_id` = 19329 , `bank_account` = '251704' [ RunTime:0.002066s ]
[2026-09-18 03:28:30][sql] CONNECT:[ UseTime:0.001216s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-18 03:28:30][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000705s ]
[2026-09-18 03:28:30][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000576s ]
[2026-09-18 03:29:08][sql] CONNECT:[ UseTime:0.001252s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-18 03:29:08][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000679s ]
[2026-09-18 03:29:08][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000509s ]
[2026-09-18 04:18:22][sql] CONNECT:[ UseTime:0.001482s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-18 04:18:22][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000797s ]
[2026-09-18 04:18:22][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000535s ]
[2026-09-18 05:35:34][sql] CONNECT:[ UseTime:0.001077s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-18 05:35:34][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000813s ]
[2026-09-18 05:35:34][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000557s ]
[2026-09-18 05:35:39][sql] CONNECT:[ UseTime:0.000841s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-18 05:35:39][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000615s ]
[2026-09-18 05:35:39][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000410s ]
[2026-09-18 08:21:34][sql] CONNECT:[ UseTime:0.000944s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-18 08:21:34][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000641s ]
[2026-09-18 08:21:34][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000442s ]
[2026-09-18 12:43:32][sql] CONNECT:[ UseTime:0.001200s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-18 12:43:32][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000717s ]
[2026-09-18 12:43:32][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000534s ]
[2026-09-18 12:59:30][sql] CONNECT:[ UseTime:0.001081s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-18 12:59:30][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000690s ]
[2026-09-18 12:59:30][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000515s ]
[2026-09-18 12:59:37][sql] CONNECT:[ UseTime:0.001087s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-18 12:59:37][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000752s ]
[2026-09-18 12:59:37][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000524s ]
[2026-09-18 14:27:40][sql] CONNECT:[ UseTime:0.000961s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-18 14:27:40][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000707s ]
[2026-09-18 14:27:40][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000416s ]
[2026-09-18 17:54:41][sql] CONNECT:[ UseTime:0.001033s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-18 17:54:41][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000639s ]
[2026-09-18 17:54:41][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000435s ]
[2026-09-18 17:54:41][sql] CONNECT:[ UseTime:0.001115s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-18 17:54:41][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000653s ]
[2026-09-18 17:54:41][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000443s ]
[2026-09-18 18:39:28][sql] CONNECT:[ UseTime:0.001009s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-18 18:39:28][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000612s ]
[2026-09-18 18:39:28][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000522s ]
[2026-09-18 19:20:01][sql] CONNECT:[ UseTime:0.001094s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-18 19:20:01][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000852s ]
[2026-09-18 19:20:01][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000579s ]
[2026-09-18 21:13:07][sql] CONNECT:[ UseTime:0.001186s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-09-18 21:13:07][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000929s ]
[2026-09-18 21:13:07][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000788s ]