[2026-07-27 00:12:30][sql] CONNECT:[ UseTime:0.000876s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-07-27 00:12:30][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000623s ]
[2026-07-27 00:12:30][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000634s ]
[2026-07-27 03:37:24][sql] CONNECT:[ UseTime:0.000945s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-07-27 03:37:24][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000710s ]
[2026-07-27 03:37:24][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000504s ]
[2026-07-27 05:55:27][sql] CONNECT:[ UseTime:0.001227s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-07-27 05:55:27][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000608s ]
[2026-07-27 05:55:27][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000496s ]
[2026-07-27 07:24:36][sql] CONNECT:[ UseTime:0.000804s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-07-27 07:24:36][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000515s ]
[2026-07-27 07:24:36][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000358s ]
[2026-07-27 08:58:36][sql] CONNECT:[ UseTime:0.000816s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-07-27 08:58:36][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000580s ]
[2026-07-27 08:58:36][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000387s ]
[2026-07-27 09:08:32][sql] CONNECT:[ UseTime:0.000810s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-07-27 09:08:32][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000576s ]
[2026-07-27 09:08:32][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000376s ]
[2026-07-27 16:19:42][sql] CONNECT:[ UseTime:0.001106s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-07-27 16:19:42][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000811s ]
[2026-07-27 16:19:42][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000597s ]
[2026-07-27 16:43:03][sql] CONNECT:[ UseTime:0.000872s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-07-27 16:43:03][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000623s ]
[2026-07-27 16:43:03][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000417s ]
[2026-07-27 20:15:45][sql] CONNECT:[ UseTime:0.000860s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-07-27 20:15:45][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000535s ]
[2026-07-27 20:15:45][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000397s ]
[2026-07-27 21:02:57][sql] CONNECT:[ UseTime:0.000955s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-07-27 21:02:57][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000676s ]
[2026-07-27 21:02:57][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000495s ]
[2026-07-27 21:08:55][sql] CONNECT:[ UseTime:0.000843s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-07-27 21:08:55][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000571s ]
[2026-07-27 21:08:55][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'payoneer' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000381s ]
[2026-07-27 21:08:55][sql] CONNECT:[ UseTime:0.000881s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-07-27 21:08:55][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000550s ]
[2026-07-27 21:08:55][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'payoneer' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000314s ]
[2026-07-27 22:19:38][sql] CONNECT:[ UseTime:0.000928s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-07-27 22:19:38][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000659s ]
[2026-07-27 22:19:38][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000478s ]
[2026-07-27 22:22:52][sql] CONNECT:[ UseTime:0.001054s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-07-27 22:22:52][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000660s ]
[2026-07-27 22:22:52][sql] INSERT INTO `sp_order` SET `order_no` = '1785162172021810' , `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\":\"Kenneth\",\"second_name\":\"Kapko\",\"email\":\"kkapko430@gmail.com\",\"phone_full\":\"+17578033751\",\"country\":\"US\",\"city\":\"Roanoke\",\"province\":\"VA\",\"address\":\"3345 Glade Creek Blvd NE,Apt 7\",\"code\":\"24012\",\"domain_name\":\"gadgets.pleasantonstore.com\"},\"total\":\"$75.98\",\"amount\":\"75.98\",\"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}],\"currency\":\"USD\",\"view_lang\":\"en\",\"prod_name\":\"galaxy\",\"publisher\":\"\",\"source\":\"\",\"web_url\":\"https:\\/\\/pleasantonstore.com\",\"order_no\":\"1785162172021810\",\"email\":\"kkapko430@gmail.com\"}' , `total_amount` = 7598 , `pay_amount` = 7598 , `shipping_fee` = 0 , `email` = 'kkapko430@gmail.com' , `create_time` = '2026-07-27 22:22:52' [ RunTime:0.002790s ]
[2026-07-27 22:22:52][sql] SHOW FULL COLUMNS FROM `sp_order_item` [ RunTime:0.000671s ]
[2026-07-27 22:22:52][sql] INSERT INTO `sp_order_item` SET `order_id` = 19313 , `title` = 'Single Galaxy Ball' , `sku` = 'TY21146-C513' , `num` = 2 , `price` = 7998 , `discount_price` = 7598 , `create_time` = '2026-07-27 22:22:52' [ RunTime:0.000354s ]
[2026-07-27 22:22:52][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000626s ]
[2026-07-27 22:22:52][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000472s ]
[2026-07-27 22:22:52][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000553s ]
[2026-07-27 22:22:52][sql] INSERT INTO `sp_order_shipping` SET `order_id` = 19313 , `last_name` = 'Kapko' , `first_name` = 'Kenneth' , `name` = 'KennethKapko' , `address1` = '3345 Glade Creek Blvd NE,Apt 7' , `province` = 'VA' , `zip` = '24012' , `city` = 'Roanoke' , `country` = 'US' , `country_code` = 'US' , `phone` = '+17578033751' , `create_time` = '2026-07-27 22:22:52' [ RunTime:0.001600s ]
[2026-07-27 22:22:52][sql] SHOW FULL COLUMNS FROM `sp_order_extend` [ RunTime:0.000631s ]
[2026-07-27 22:22:52][sql] INSERT INTO `sp_order_extend` SET `order_id` = 19313 , `bank_account` = '251704' [ RunTime:0.000674s ]
[2026-07-27 22:24:01][sql] CONNECT:[ UseTime:0.001046s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-07-27 22:24:01][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000679s ]
[2026-07-27 22:24:01][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000353s ]
[2026-07-27 22:24:01][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000404s ]
[2026-07-27 22:24:01][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1785162172021810' LIMIT 1 [ RunTime:0.024774s ]
[2026-07-27 22:24:01][sql] SHOW FULL COLUMNS FROM `sp_order_oceanpay` [ RunTime:0.000526s ]
[2026-07-27 22:24:01][sql] INSERT INTO `sp_order_oceanpay` SET `order_no` = '1785162172021810' , `quickpay_id` = '32a75a00-cbf8-4423-9a7a-b26ced87272d' , `web_url` = 'https://gadgets.pleasantonstore.com' , `create_time` = '2026-07-27 22:23:59' [ RunTime:0.002480s ]
[2026-07-27 22:24:02][sql] CONNECT:[ UseTime:0.000796s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-07-27 22:24:02][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000702s ]
[2026-07-27 22:24:02][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000419s ]
[2026-07-27 22:24:02][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000457s ]
[2026-07-27 22:24:02][sql] SELECT * FROM `sp_order` `t` LEFT JOIN `sp_order_shipping` `order_shipping` ON `t`.`id`=`order_shipping`.`order_id` WHERE  `order_no` = '1785162172021810' LIMIT 1 [ RunTime:0.026422s ]
[2026-07-27 22:24:02][sql] UPDATE `sp_order`  SET `transaction_id` = '260727222359812271045' , `status` = 'COMPLETED' , `order_time` = '2026-07-27 22:24:01' , `pay_time` = '2026-07-27 22:24:01'  WHERE  `order_no` = '1785162172021810' [ RunTime:0.030245s ]
[2026-07-27 22:24:02][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1785162172021810' LIMIT 1 [ RunTime:0.025033s ]
[2026-07-27 22:24:02][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000581s ]
[2026-07-27 22:24:02][sql] SELECT * FROM `sp_order_shipping` WHERE  `order_id` = 19313 LIMIT 1 [ RunTime:0.000335s ]
[2026-07-27 22:24:02][sql] SHOW FULL COLUMNS FROM `sp_order_item` [ RunTime:0.000359s ]
[2026-07-27 22:24:02][sql] SELECT * FROM `sp_order_item` WHERE  `order_id` = 19313 [ RunTime:0.018079s ]
[2026-07-27 22:24:02][sql] SHOW FULL COLUMNS FROM `sp_order_extend` [ RunTime:0.000493s ]
[2026-07-27 22:24:02][sql] SELECT * FROM `sp_order_extend` WHERE  `order_id` = 19313 LIMIT 1 [ RunTime:0.004946s ]
[2026-07-27 22:24:02][sql] UPDATE `sp_order`  SET `push_erp_status` = 1 , `push_erp_time` = '2026-07-27 22:24:02'  WHERE  `order_no` = '1785162172021810' [ RunTime:0.029853s ]
[2026-07-27 22:24:02][sql] CONNECT:[ UseTime:0.000921s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-07-27 22:24:02][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000556s ]
[2026-07-27 22:24:02][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000355s ]
[2026-07-27 22:24:02][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000456s ]
[2026-07-27 22:24:02][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1785162172021810' LIMIT 1 [ RunTime:0.024594s ]
[2026-07-27 22:24:02][sql] CONNECT:[ UseTime:0.001062s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-07-27 22:24:02][sql] SHOW FULL COLUMNS FROM `sp_goods` [ RunTime:0.000614s ]
[2026-07-27 22:24:02][sql] SELECT * FROM `sp_goods` WHERE  `name` = 'GalaxyUpsell' LIMIT 1 [ RunTime:0.000318s ]
[2026-07-27 22:24:04][sql] CONNECT:[ UseTime:0.001018s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-07-27 22:24:04][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000835s ]
[2026-07-27 22:24:04][sql] SELECT * FROM `sp_order` `t` LEFT JOIN `sp_order_shipping` `order_shipping` ON `t`.`id`=`order_shipping`.`order_id` WHERE  `order_no` = '1785162172021810' LIMIT 1 [ RunTime:0.026489s ]
[2026-07-27 22:24:05][sql] CONNECT:[ UseTime:0.000893s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-07-27 22:24:05][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000631s ]
[2026-07-27 22:24:05][sql] SELECT * FROM `sp_order` `t` LEFT JOIN `sp_order_shipping` `order_shipping` ON `t`.`id`=`order_shipping`.`order_id` WHERE  `order_no` = '1785162172021810' LIMIT 1 [ RunTime:0.025120s ]
[2026-07-27 22:24:14][sql] CONNECT:[ UseTime:0.000943s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-07-27 22:24:14][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000548s ]
[2026-07-27 22:24:14][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1785162172021810' LIMIT 1 [ RunTime:0.024348s ]
[2026-07-27 22:24:14][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1785162172021810' LIMIT 1 [ RunTime:0.024652s ]
[2026-07-27 22:24:14][sql] SHOW FULL COLUMNS FROM `sp_order_upsell` [ RunTime:0.000631s ]
[2026-07-27 22:24:14][sql] SELECT * FROM `sp_order_upsell` WHERE  `order_no` = '1785162172021810'  AND `status` = 'COMPLETED' [ RunTime:0.000411s ]
[2026-07-27 22:24:14][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000394s ]
[2026-07-27 22:24:14][sql] SELECT * FROM `sp_order_shipping` WHERE  `order_id` = 19313 LIMIT 1 [ RunTime:0.000262s ]
[2026-07-27 22:24:19][sql] CONNECT:[ UseTime:0.000875s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-07-27 22:24:19][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000581s ]
[2026-07-27 22:24:19][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1785162172021810' LIMIT 1 [ RunTime:0.025442s ]
[2026-07-27 22:24:19][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1785162172021810' LIMIT 1 [ RunTime:0.025190s ]
[2026-07-27 22:24:19][sql] SHOW FULL COLUMNS FROM `sp_order_upsell` [ RunTime:0.000780s ]
[2026-07-27 22:24:19][sql] SELECT * FROM `sp_order_upsell` WHERE  `order_no` = '1785162172021810'  AND `status` = 'COMPLETED' [ RunTime:0.000384s ]
[2026-07-27 22:24:19][sql] SHOW FULL COLUMNS FROM `sp_order_shipping` [ RunTime:0.000506s ]
[2026-07-27 22:24:19][sql] SELECT * FROM `sp_order_shipping` WHERE  `order_id` = 19313 LIMIT 1 [ RunTime:0.000290s ]
[2026-07-27 22:35:38][sql] CONNECT:[ UseTime:0.000791s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-07-27 22:35:38][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000537s ]
[2026-07-27 22:35:38][sql] SELECT * FROM `sp_payment` WHERE (  `handle` = 'oceanpayment' ) AND `sp_payment`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000321s ]
[2026-07-27 22:35:38][sql] SHOW FULL COLUMNS FROM `sp_order` [ RunTime:0.000441s ]
[2026-07-27 22:35:38][sql] SELECT * FROM `sp_order` WHERE  `order_no` = '1785162172021810' LIMIT 1 [ RunTime:0.024557s ]
[2026-07-27 22:56:41][sql] CONNECT:[ UseTime:0.000956s ] mysql:host=db;port=3306;dbname=keystone;charset=utf8
[2026-07-27 22:56:41][sql] SHOW FULL COLUMNS FROM `sp_payment` [ RunTime:0.000674s ]
[2026-07-27 22:56:41][sql] SELECT * FROM `sp_payment` WHERE (  `status` = 1 ) AND `sp_payment`.`delete_time` IS NULL [ RunTime:0.000431s ]