[2026-11-05 01:27:12][sql] CONNECT:[ UseTime:0.001075s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-11-05 01:27:12][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000609s ]
[2026-11-05 01:27:12][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000530s ]
[2026-11-05 04:12:37][sql] CONNECT:[ UseTime:0.000792s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-11-05 04:12:37][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000593s ]
[2026-11-05 04:12:37][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000457s ]
[2026-11-05 04:13:00][sql] CONNECT:[ UseTime:0.001179s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-11-05 04:13:00][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000677s ]
[2026-11-05 04:13:00][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000446s ]
[2026-11-05 04:14:20][sql] CONNECT:[ UseTime:0.000995s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-11-05 04:14:20][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000641s ]
[2026-11-05 04:14:20][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000436s ]
[2026-11-05 05:24:08][sql] CONNECT:[ UseTime:0.001261s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-11-05 05:24:08][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000635s ]
[2026-11-05 05:24:08][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000486s ]
[2026-11-05 06:55:22][sql] CONNECT:[ UseTime:0.001074s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-11-05 06:55:22][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000770s ]
[2026-11-05 06:55:22][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000629s ]
[2026-11-05 08:37:16][sql] CONNECT:[ UseTime:0.000854s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-11-05 08:37:16][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000630s ]
[2026-11-05 08:37:16][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000416s ]
[2026-11-05 08:37:45][sql] CONNECT:[ UseTime:0.001214s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-11-05 08:37:45][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000642s ]
[2026-11-05 08:37:45][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000525s ]
[2026-11-05 08:38:13][sql] CONNECT:[ UseTime:0.000853s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-11-05 08:38:13][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000600s ]
[2026-11-05 08:38:13][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000579s ]
[2026-11-05 08:47:24][sql] CONNECT:[ UseTime:0.001037s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-11-05 08:47:24][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000651s ]
[2026-11-05 08:47:24][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000474s ]
[2026-11-05 09:24:22][sql] CONNECT:[ UseTime:0.000957s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-11-05 09:24:22][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000813s ]
[2026-11-05 09:24:22][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000464s ]
[2026-11-05 09:34:45][sql] CONNECT:[ UseTime:0.000855s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-11-05 09:34:45][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000590s ]
[2026-11-05 09:34:45][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000457s ]
[2026-11-05 10:45:00][sql] CONNECT:[ UseTime:0.001016s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-11-05 10:45:00][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000864s ]
[2026-11-05 10:45:00][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000623s ]
[2026-11-05 13:53:22][sql] CONNECT:[ UseTime:0.000866s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-11-05 13:53:22][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000576s ]
[2026-11-05 13:53:22][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000380s ]
[2026-11-05 19:01:59][sql] CONNECT:[ UseTime:0.000876s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-11-05 19:01:59][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000655s ]
[2026-11-05 19:01:59][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000413s ]
[2026-11-05 19:36:31][sql] CONNECT:[ UseTime:0.000760s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-11-05 19:36:31][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000548s ]
[2026-11-05 19:36:31][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000417s ]
[2026-11-05 21:52:03][sql] CONNECT:[ UseTime:0.001242s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-11-05 21:52:03][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000816s ]
[2026-11-05 21:52:03][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000526s ]
[2026-11-05 22:16:19][sql] CONNECT:[ UseTime:0.000805s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-11-05 22:16:19][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000617s ]
[2026-11-05 22:16:19][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000414s ]
[2026-11-05 22:17:17][sql] CONNECT:[ UseTime:0.000959s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-11-05 22:17:17][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000859s ]
[2026-11-05 22:17:17][sql] INSERT INTO `sp_order` SET `order_no` = '1793888237977410' , `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\":\"Mark\",\"second_name\":\"Viggiano\",\"email\":\"viggianomark@gmail.com\",\"phone_full\":\"+19143913930\",\"country\":\"US\",\"city\":\"Katonah\",\"province\":\"NY\",\"address\":\"115 Mustato Rd, Katonah, NY 10536, USA,\",\"code\":\"10536\",\"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\":\"1793888237977410\",\"email\":\"viggianomark@gmail.com\"}' , `total_amount` = 12894 , `pay_amount` = 12894 , `shipping_fee` = 0 , `email` = 'viggianomark@gmail.com' , `create_time` = '2026-11-05 22:17:17' [ RunTime:0.002121s ]
[2026-11-05 22:17:17][sql] SHOW FULL COLUMNS FROM `sp_order_item` [ RunTime:0.000431s ]
[2026-11-05 22:17:17][sql] INSERT INTO `sp_order_item` SET `order_id` = 19401 , `title` = 'Single Galaxy Ball' , `sku` = 'TY21146-C513' , `num` = 3 , `price` = 7998 , `discount_price` = 10797 , `create_time` = '2026-11-05 22:17:17' [ RunTime:0.000201s ]
[2026-11-05 22:17:17][sql] INSERT INTO `sp_order_item` SET `order_id` = 19401 , `title` = '1 Year Extended Warranty' , `sku` = 'WARRANTY-S' , `num` = 3 , `price` = 1398 , `discount_price` = 2097 , `create_time` = '2026-11-05 22:17:17' [ RunTime:0.000179s ]
[2026-11-05 22:17:17][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000547s ]
[2026-11-05 22:17:17][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000384s ]
[2026-11-05 22:17:17][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000371s ]
[2026-11-05 22:17:17][sql] INSERT INTO `sp_order_shipping` SET `order_id` = 19401 , `last_name` = 'Viggiano' , `first_name` = 'Mark' , `name` = 'MarkViggiano' , `address1` = '115 Mustato Rd, Katonah, NY 10536, USA,' , `province` = 'NY' , `zip` = '10536' , `city` = 'Katonah' , `country` = 'US' , `country_code` = 'US' , `phone` = '+19143913930' , `create_time` = '2026-11-05 22:17:17' [ RunTime:0.000622s ]
[2026-11-05 22:17:17][sql] SHOW FULL COLUMNS FROM `sp_order_extend` [ RunTime:0.000370s ]
[2026-11-05 22:17:17][sql] INSERT INTO `sp_order_extend` SET `order_id` = 19401 , `bank_account` = '251704' [ RunTime:0.001197s ]
[2026-11-05 22:17:32][sql] CONNECT:[ UseTime:0.001056s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-11-05 22:17:32][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000686s ]
[2026-11-05 22:17:32][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000519s ]
[2026-11-05 22:17:32][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000644s ]
[2026-11-05 22:17:32][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1793888237977410' LIMIT 1 [ RunTime:0.023584s ]
[2026-11-05 22:17:32][sql] SHOW FULL COLUMNS FROM `sp_order_oceanpay` [ RunTime:0.000716s ]
[2026-11-05 22:17:32][sql] INSERT INTO `sp_order_oceanpay` SET `order_no` = '1793888237977410' , `quickpay_id` = '99ff1017-9f4a-4624-8c8b-30bebaf6bd1e' , `web_url` = 'https://gadgets.pleasantonstore.com' , `create_time` = '2026-11-05 22:17:29' [ RunTime:0.006862s ]
[2026-11-05 22:17:32][sql] CONNECT:[ UseTime:0.000860s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-11-05 22:17:32][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000591s ]
[2026-11-05 22:17:32][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000364s ]
[2026-11-05 22:17:32][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000465s ]
[2026-11-05 22:17:32][sql] SELECT * FROM `sp_order` `t` LEFT JOIN `sp_order_shipping` `order_shipping` ON `t`.`id`=`order_shipping`.`order_id` WHERE  `order_no` = '1793888237977410' LIMIT 1 [ RunTime:0.024919s ]
[2026-11-05 22:17:32][sql] UPDATE `sp_order`  SET `transaction_id` = '261105221730737386042' , `status` = 'COMPLETED' , `order_time` = '2026-11-05 22:17:32' , `pay_time` = '2026-11-05 22:17:32'  WHERE  `order_no` = '1793888237977410' [ RunTime:0.035366s ]
[2026-11-05 22:17:32][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1793888237977410' LIMIT 1 [ RunTime:0.024051s ]
[2026-11-05 22:17:32][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000697s ]
[2026-11-05 22:17:32][sql] SELECT * FROM `sp_order_shipping` WHERE  `order_id` = 19401 LIMIT 1 [ RunTime:0.000402s ]
[2026-11-05 22:17:32][sql] SHOW FULL COLUMNS FROM `sp_order_item` [ RunTime:0.000470s ]
[2026-11-05 22:17:32][sql] SELECT * FROM `sp_order_item` WHERE  `order_id` = 19401 [ RunTime:0.017993s ]
[2026-11-05 22:17:32][sql] SHOW FULL COLUMNS FROM `sp_order_extend` [ RunTime:0.000584s ]
[2026-11-05 22:17:32][sql] SELECT * FROM `sp_order_extend` WHERE  `order_id` = 19401 LIMIT 1 [ RunTime:0.005019s ]
[2026-11-05 22:17:32][sql] UPDATE `sp_order`  SET `push_erp_status` = 1 , `push_erp_time` = '2026-11-05 22:17:32'  WHERE  `order_no` = '1793888237977410' [ RunTime:0.029451s ]
[2026-11-05 22:17:32][sql] CONNECT:[ UseTime:0.000770s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-11-05 22:17:32][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000776s ]
[2026-11-05 22:17:32][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000452s ]
[2026-11-05 22:17:32][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000473s ]
[2026-11-05 22:17:32][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1793888237977410' LIMIT 1 [ RunTime:0.027290s ]
[2026-11-05 22:17:34][sql] CONNECT:[ UseTime:0.000806s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-11-05 22:17:34][sql] SHOW FULL COLUMNS FROM `sp_goods` [ RunTime:0.000495s ]
[2026-11-05 22:17:34][sql] SELECT * FROM `sp_goods` WHERE  `name` = 'GalaxyUpsell' LIMIT 1 [ RunTime:0.000284s ]
[2026-11-05 22:17:56][sql] CONNECT:[ UseTime:0.000941s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-11-05 22:17:56][sql] SHOW FULL COLUMNS FROM `sp_order_upsell` [ RunTime:0.000625s ]
[2026-11-05 22:17:56][sql] SELECT * FROM `sp_order_upsell` WHERE  `order_upsell_no` = '1793888237977410-upsell-1' LIMIT 1 [ RunTime:0.000412s ]
[2026-11-05 22:17:56][sql] INSERT INTO `sp_order_upsell` SET `order_no` = '1793888237977410' , `order_upsell_no` = '1793888237977410-upsell-1' , `web_url` = 'https://gadgets.pleasantonstore.com' , `payment_method` = 'oceanpayment' , `discount` = 8637 , `currency` = 'USD' , `product_info` = '{\"payment_method\":\"oceanpayment\",\"qty\":1,\"discount\":-86.37,\"shipping\":\"$0.00\",\"total\":\"$28.79\",\"amount\":\"28.79\",\"shipping_fee\":\"0.00\",\"currency\":\"USD\",\"view_lang\":\"en\",\"prod_name\":\"galaxy\",\"order_no\":\"1793888237977410\",\"product\":[{\"id\":224,\"qty\":\"1\",\"sku\":\"TY21146-C513\",\"title\":\"Single Galaxy Ball\",\"image\":\"https:\\/\\/clicklink.s3.amazonaws.com\\/img\\/vip\\/mNEEiUEUlPUcK0pi.png\",\"description\":\"Single Pack\",\"market_price\":\"115.16\",\"discount_price\":\"28.79\",\"shipping_fee\":\"0.00\",\"discount\":\"75%\",\"shopify_variant_json\":null,\"currency\":\"USD\",\"symbol\":\"$\"}],\"return_url\":\"upsell2\",\"current_upsell\":1,\"web_url\":\"https:\\/\\/gadgets.pleasantonstore.com\",\"email\":null,\"order_upsell_no\":\"1793888237977410-upsell-1\"}' , `total_amount` = 2879 , `pay_amount` = 2879 , `shipping_fee` = 0 , `email` = NULL , `create_time` = '2026-11-05 22:17:55' [ RunTime:0.002049s ]
[2026-11-05 22:17:56][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000672s ]
[2026-11-05 22:17:56][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000465s ]
[2026-11-05 22:17:56][sql] SHOW FULL COLUMNS FROM `sp_order_oceanpay` [ RunTime:0.000345s ]
[2026-11-05 22:17:56][sql] SELECT * FROM `sp_order_oceanpay` WHERE  `order_no` = '1793888237977410' LIMIT 1 [ RunTime:0.000356s ]
[2026-11-05 22:17:56][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000545s ]
[2026-11-05 22:17:56][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1793888237977410' LIMIT 1 [ RunTime:0.022793s ]
[2026-11-05 22:17:57][sql] CONNECT:[ UseTime:0.000974s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-11-05 22:17:57][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000707s ]
[2026-11-05 22:17:57][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000403s ]
[2026-11-05 22:17:57][sql] SHOW FULL COLUMNS FROM `sp_order_upsell` [ RunTime:0.000454s ]
[2026-11-05 22:17:57][sql] SELECT * FROM `sp_order_upsell` WHERE  `order_upsell_no` = '1793888237977410-upsell-1' LIMIT 1 [ RunTime:0.000358s ]
[2026-11-05 22:17:57][sql] UPDATE `sp_order_upsell`  SET `bank_account` = '251704' , `transaction_id` = '261105221755360722031' , `status` = 'COMPLETED' , `order_time` = '2026-11-05 22:17:57' , `pay_time` = '2026-11-05 22:17:57' , `update_time` = '2026-11-05 22:17:57'  WHERE  `order_upsell_no` = '1793888237977410-upsell-1' [ RunTime:0.002098s ]
[2026-11-05 22:17:57][sql] SELECT * FROM `sp_order_upsell` WHERE  `order_upsell_no` = '1793888237977410-upsell-1' LIMIT 1 [ RunTime:0.000665s ]
[2026-11-05 22:17:57][sql] UPDATE `sp_order_upsell`  SET `push_erp_status` = 1 , `push_erp_time` = '2026-11-05 22:17:57'  WHERE  `order_no` = '1793888237977410-upsell-1' [ RunTime:0.000573s ]
[2026-11-05 22:17:57][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000542s ]
[2026-11-05 22:17:57][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1793888237977410' LIMIT 1 [ RunTime:0.023424s ]
[2026-11-05 22:17:57][sql] SELECT * FROM `sp_order_upsell` WHERE  `order_no` = '1793888237977410'  AND `status` = 'COMPLETED' [ RunTime:0.000559s ]
[2026-11-05 22:17:57][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000592s ]
[2026-11-05 22:17:57][sql] SELECT * FROM `sp_order_shipping` WHERE  `order_id` = 19401 LIMIT 1 [ RunTime:0.000393s ]
[2026-11-05 22:17:57][sql] CONNECT:[ UseTime:0.000859s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-11-05 22:17:57][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000598s ]
[2026-11-05 22:17:57][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000467s ]
[2026-11-05 22:17:57][sql] SHOW FULL COLUMNS FROM `sp_order_upsell` [ RunTime:0.000402s ]
[2026-11-05 22:17:57][sql] SELECT * FROM `sp_order_upsell` WHERE  `order_upsell_no` = '1793888237977410-upsell-1' LIMIT 1 [ RunTime:0.000379s ]
[2026-11-05 22:30:38][sql] CONNECT:[ UseTime:0.001033s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-11-05 22:30:38][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000856s ]
[2026-11-05 22:30:38][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000459s ]
[2026-11-05 22:30:38][sql] SHOW FULL COLUMNS FROM `sp_order_upsell` [ RunTime:0.000538s ]
[2026-11-05 22:30:38][sql] SELECT * FROM `sp_order_upsell` WHERE  `order_upsell_no` = '1793888237977410-upsell-1' LIMIT 1 [ RunTime:0.000432s ]
[2026-11-05 22:30:40][sql] CONNECT:[ UseTime:0.000987s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-11-05 22:30:40][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000878s ]
[2026-11-05 22:30:40][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000496s ]
[2026-11-05 22:30:40][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000560s ]
[2026-11-05 22:30:40][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1793888237977410' LIMIT 1 [ RunTime:0.031001s ]
[2026-11-05 23:36:48][sql] CONNECT:[ UseTime:0.000846s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-11-05 23:36:48][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000806s ]
[2026-11-05 23:36:48][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000576s ]
[2026-11-05 23:55:12][sql] CONNECT:[ UseTime:0.001038s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-11-05 23:55:12][sql] SHOW FULL COLUMNS FROM `sp_order_upsell` [ RunTime:0.000694s ]
[2026-11-05 23:55:12][sql] SELECT * FROM `sp_order_upsell` WHERE  `order_upsell_no` = '1793888237977410-upsell-1' LIMIT 1 [ RunTime:0.000555s ]
[2026-11-05 23:55:17][sql] CONNECT:[ UseTime:0.000920s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-11-05 23:55:17][sql] SHOW FULL COLUMNS FROM `sp_order_upsell` [ RunTime:0.000609s ]
[2026-11-05 23:55:17][sql] SELECT * FROM `sp_order_upsell` WHERE  `order_upsell_no` = '1793888237977410-upsell-1' LIMIT 1 [ RunTime:0.000366s ]
[2026-11-05 23:55:17][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000428s ]
[2026-11-05 23:55:17][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1793888237977410' LIMIT 1 [ RunTime:0.024106s ]
[2026-11-05 23:55:17][sql] SELECT * FROM `sp_order_upsell` WHERE  `order_no` = '1793888237977410'  AND `status` = 'COMPLETED' [ RunTime:0.000521s ]
[2026-11-05 23:55:17][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000483s ]
[2026-11-05 23:55:17][sql] SELECT * FROM `sp_order_shipping` WHERE  `order_id` = 19401 LIMIT 1 [ RunTime:0.000339s ]
[2026-11-05 23:57:02][sql] CONNECT:[ UseTime:0.001039s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-11-05 23:57:02][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000744s ]
[2026-11-05 23:57:02][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000805s ]