--------------------------------------------------------------- [2025-09-05T23:55:46+08:00] 39.144.139.46 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.315553s] [吞吐率:3.17req/s] [内存消耗:4,197.23kb] [文件加载:104] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '1410', 'x-token' => 'oCmeh5eWGP98bg0z3srC6TXh7IlQ', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.62(0x18003e39) NetType/4G Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/createOrder', 'host' => 'main', 'pageSize' => '15', 'state' => '9', 'state_msg' => '', 'site_id' => '952', 'site_name' => '浅水半岛80俊二期', 'site_server' => '18980369999', 'equi_ids' => 'YE4G0014', 'equi_brand' => 'qy', 'equi_state' => '1', 'socket' => '[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object]', 'sids' => 'BJ000236', 'price_info' => '[object Object]', 'money_list' => '[object Object],[object Object],[object Object],[object Object],[object Object]', 'money_name' => '', 'pay_money' => '1', 'value' => '15', 'socket_num' => '11', 'socket_no' => '', 'allow_time' => '1.26', 'power_num' => '502', 'temp' => '{"charge_type":"8","start_power":["0","201","301","401","501","601","701","801","1001","2201"],"end_power":["200","300","400","500","600","700","800","1000","2200","3600"],"price":["0.58","0.58","0.58","0.58","0.58","0.58","0.58","0.58","0.58","0.58"],"time":["0.2","0.25","0.3","0.4","0.5","0.6","0.7","0.8","0.9","1.0"]}', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010628s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.009004s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007134s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.023737s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5eWGP98bg0z3srC6TXh7IlQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007098s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5eWGP98bg0z3srC6TXh7IlQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007091s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008634s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 952 [ RunTime:0.007066s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 952 [ RunTime:0.012770s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008378s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 48800 LIMIT 1 [ RunTime:0.007484s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008412s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = 'YE4G0014' AND `state` = 1 AND `sids` = 'BJ000236' AND `socket_num` = 11 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.008528s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008218s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 952 LIMIT 1 [ RunTime:0.006962s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008319s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007072s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008345s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007145s ] [ sql ] [ SQL ] INSERT INTO `tp_charge_orders` (`agent_id` , `site_id` , `order_sn` , `icard` , `state` , `member_id` , `member_mobile` , `equi_ids` , `socket_num` , `socket_no` , `sids` , `pay_money` , `ctime` , `valid_time` , `price_info` , `brand` , `value` , `other` , `system`) VALUES (438 , 952 , '20250905235546385618' , NULL , 0 , 48800 , '15281341478' , 'YE4G0014' , 11 , 0 , 'BJ000236' , '1' , '2025-09-05 23:55:46' , 1757123746 , '{\"charge_type\":\"8\",\"start_power\":[\"0\",\"201\",\"301\",\"401\",\"501\",\"601\",\"701\",\"801\",\"1001\",\"2201\"],\"end_power\":[\"200\",\"300\",\"400\",\"500\",\"600\",\"700\",\"800\",\"1000\",\"2200\",\"3600\"],\"price\":[\"0.58\",\"0.58\",\"0.58\",\"0.58\",\"0.58\",\"0.58\",\"0.58\",\"0.58\",\"0.58\",\"0.58\"],\"time\":[\"0.2\",\"0.25\",\"0.3\",\"0.4\",\"0.5\",\"0.6\",\"0.7\",\"0.8\",\"0.9\",\"1.0\"]}' , 'qy' , 15 , '[]' , 'main') [ RunTime:0.007538s ] [ sql ] [ SQL ] SELECT 952,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 952 [ RunTime:0.007190s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.008348s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 952 [ RunTime:0.007091s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007103s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007162s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008245s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007178s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008263s ] [ sql ] [ SQL ] INSERT INTO `tp_comm_consume` (`port` , `state` , `agent_id` , `order_sn` , `icard` , `site_id` , `member_id` , `pay_id` , `order_money` , `pay_money` , `src_by` , `ctime` , `details` , `pay_config` , `rate` , `directions` , `month` , `day` , `remark` , `system`) VALUES (1 , 0 , 438 , 'Y20250905235546460848' , NULL , 952 , 48800 , 48800 , '1' , '1' , 'charge_temp' , '2025-09-05 23:55:46' , '{\"site_id\":\"952\",\"site_name\":\"浅水半岛80俊二期\",\"equi_ids\":\"YE4G0014\",\"equi_brand\":\"qy\",\"sids\":\"BJ000236\",\"socket_num\":\"11\",\"socket_no\":\"\",\"value\":\"15\",\"order_id\":\"3034031\",\"sy_money\":\"1\"}' , '{\"appId\":\"wx9d3af783c5718533\",\"appSecret\":\"49cd7ec1b8418d1dcb19ce60b78ccb95\",\"partnerId\":\"1511337021\",\"apiKey\":\"f02795ff419df1f67b1b59aa0ca06754\",\"code\":\"yeby\",\"name\":\"元贰佰壹\"}' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '临时充电' , '2025-09' , '2025-09-05' , NULL , 'main') [ RunTime:0.008233s ] [ error ] [8]未定义数组索引: icard[D:\www\api\application\charge\model\Orders.php:79] [ error ] [8]未定义数组索引: other[D:\www\api\application\charge\model\Orders.php:93] [ error ] [8]未定义数组索引: icard[D:\www\api\application\comm\model\Consume.php:53] [ error ] [8]未定义数组索引: remark[D:\www\api\application\comm\model\Consume.php:67] --------------------------------------------------------------- [2025-09-05T23:55:47+08:00] 39.144.139.46 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.523488s] [吞吐率:1.91req/s] [内存消耗:4,008.88kb] [文件加载:98] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '72', 'x-token' => 'oCmeh5eWGP98bg0z3srC6TXh7IlQ', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.62(0x18003e39) NetType/4G Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/consume/getPayment', 'host' => 'main', 'pageSize' => '15', 'order_id' => '2202320', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010615s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008593s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007022s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008149s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5eWGP98bg0z3srC6TXh7IlQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007077s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5eWGP98bg0z3srC6TXh7IlQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006989s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008535s ] [ sql ] [ SQL ] SELECT `id`,`state`,`src_by`,`pay_money`,`order_sn`,`pay_config` FROM `tp_comm_consume` WHERE `id` = 2202320 LIMIT 1 [ RunTime:0.007072s ] [ error ] [8]未定义数组索引: paysuc_url[D:\www\api\application\index\controller\Payment.php:41] [ error ] [8]未定义数组索引: payerr_url[D:\www\api\application\index\controller\Payment.php:42] --------------------------------------------------------------- [2025-09-05T23:55:47+08:00] 111.231.165.30 POST api.scyeby.com/public/index.php/index/Wxservice/index.html?signature=3658e90c642cf5b32f54fa00e0fe7266129fa584×tamp=1757087746&nonce=1049325599&openid=oCmeh5eWGP98bg0z3srC6TXh7IlQ [运行时间:0.073749s] [吞吐率:13.56req/s] [内存消耗:3,503.61kb] [文件加载:86] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'user-agent' => 'Mozilla/4.0', 'accept' => '*/*', 'host' => 'api.scyeby.com', 'pragma' => 'no-cache', 'content-length' => '688', 'content-type' => 'text/xml', ) [ info ] [ PARAM ] array ( 'signature' => '3658e90c642cf5b32f54fa00e0fe7266129fa584', 'timestamp' => '1757087746', 'nonce' => '1049325599', 'openid' => 'oCmeh5eWGP98bg0z3srC6TXh7IlQ', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.018833s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008737s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007345s ] --------------------------------------------------------------- [2025-09-05T23:55:47+08:00] 39.144.139.46 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.310720s] [吞吐率:3.22req/s] [内存消耗:4,197.29kb] [文件加载:104] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '1410', 'x-token' => 'oCmeh5eWGP98bg0z3srC6TXh7IlQ', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.62(0x18003e39) NetType/4G Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/createOrder', 'host' => 'main', 'pageSize' => '15', 'state' => '9', 'state_msg' => '', 'site_id' => '952', 'site_name' => '浅水半岛80俊二期', 'site_server' => '18980369999', 'equi_ids' => 'YE4G0014', 'equi_brand' => 'qy', 'equi_state' => '1', 'socket' => '[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object]', 'sids' => 'BJ000236', 'price_info' => '[object Object]', 'money_list' => '[object Object],[object Object],[object Object],[object Object],[object Object]', 'money_name' => '', 'pay_money' => '1', 'value' => '15', 'socket_num' => '11', 'socket_no' => '', 'allow_time' => '1.26', 'power_num' => '502', 'temp' => '{"charge_type":"8","start_power":["0","201","301","401","501","601","701","801","1001","2201"],"end_power":["200","300","400","500","600","700","800","1000","2200","3600"],"price":["0.58","0.58","0.58","0.58","0.58","0.58","0.58","0.58","0.58","0.58"],"time":["0.2","0.25","0.3","0.4","0.5","0.6","0.7","0.8","0.9","1.0"]}', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.011619s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.009185s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007740s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.009412s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5eWGP98bg0z3srC6TXh7IlQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007786s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5eWGP98bg0z3srC6TXh7IlQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.008485s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.009381s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 952 [ RunTime:0.007780s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 952 [ RunTime:0.007673s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.009014s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 48800 LIMIT 1 [ RunTime:0.008180s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.009981s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = 'YE4G0014' AND `state` = 1 AND `sids` = 'BJ000236' AND `socket_num` = 11 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.009280s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008934s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 952 LIMIT 1 [ RunTime:0.007644s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.009134s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007775s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.009047s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007725s ] [ sql ] [ SQL ] INSERT INTO `tp_charge_orders` (`agent_id` , `site_id` , `order_sn` , `icard` , `state` , `member_id` , `member_mobile` , `equi_ids` , `socket_num` , `socket_no` , `sids` , `pay_money` , `ctime` , `valid_time` , `price_info` , `brand` , `value` , `other` , `system`) VALUES (438 , 952 , '20250905235547827346' , NULL , 0 , 48800 , '15281341478' , 'YE4G0014' , 11 , 0 , 'BJ000236' , '1' , '2025-09-05 23:55:47' , 1757123747 , '{\"charge_type\":\"8\",\"start_power\":[\"0\",\"201\",\"301\",\"401\",\"501\",\"601\",\"701\",\"801\",\"1001\",\"2201\"],\"end_power\":[\"200\",\"300\",\"400\",\"500\",\"600\",\"700\",\"800\",\"1000\",\"2200\",\"3600\"],\"price\":[\"0.58\",\"0.58\",\"0.58\",\"0.58\",\"0.58\",\"0.58\",\"0.58\",\"0.58\",\"0.58\",\"0.58\"],\"time\":[\"0.2\",\"0.25\",\"0.3\",\"0.4\",\"0.5\",\"0.6\",\"0.7\",\"0.8\",\"0.9\",\"1.0\"]}' , 'qy' , 15 , '[]' , 'main') [ RunTime:0.008167s ] [ sql ] [ SQL ] SELECT 952,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 952 [ RunTime:0.007724s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.009044s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 952 [ RunTime:0.007768s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.008046s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007731s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008915s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007753s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.009470s ] [ sql ] [ SQL ] INSERT INTO `tp_comm_consume` (`port` , `state` , `agent_id` , `order_sn` , `icard` , `site_id` , `member_id` , `pay_id` , `order_money` , `pay_money` , `src_by` , `ctime` , `details` , `pay_config` , `rate` , `directions` , `month` , `day` , `remark` , `system`) VALUES (1 , 0 , 438 , 'Y20250905235547645780' , NULL , 952 , 48800 , 48800 , '1' , '1' , 'charge_temp' , '2025-09-05 23:55:47' , '{\"site_id\":\"952\",\"site_name\":\"浅水半岛80俊二期\",\"equi_ids\":\"YE4G0014\",\"equi_brand\":\"qy\",\"sids\":\"BJ000236\",\"socket_num\":\"11\",\"socket_no\":\"\",\"value\":\"15\",\"order_id\":\"3034032\",\"sy_money\":\"1\"}' , '{\"appId\":\"wx9d3af783c5718533\",\"appSecret\":\"49cd7ec1b8418d1dcb19ce60b78ccb95\",\"partnerId\":\"1511337021\",\"apiKey\":\"f02795ff419df1f67b1b59aa0ca06754\",\"code\":\"yeby\",\"name\":\"元贰佰壹\"}' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '临时充电' , '2025-09' , '2025-09-05' , NULL , 'main') [ RunTime:0.008076s ] [ error ] [8]未定义数组索引: icard[D:\www\api\application\charge\model\Orders.php:79] [ error ] [8]未定义数组索引: other[D:\www\api\application\charge\model\Orders.php:93] [ error ] [8]未定义数组索引: icard[D:\www\api\application\comm\model\Consume.php:53] [ error ] [8]未定义数组索引: remark[D:\www\api\application\comm\model\Consume.php:67] --------------------------------------------------------------- [2025-09-05T23:55:48+08:00] 39.144.139.46 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.561964s] [吞吐率:1.78req/s] [内存消耗:4,008.88kb] [文件加载:98] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '72', 'x-token' => 'oCmeh5eWGP98bg0z3srC6TXh7IlQ', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.62(0x18003e39) NetType/4G Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/consume/getPayment', 'host' => 'main', 'pageSize' => '15', 'order_id' => '2202321', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009610s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008046s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006714s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.007618s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5eWGP98bg0z3srC6TXh7IlQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006517s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5eWGP98bg0z3srC6TXh7IlQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006383s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.007762s ] [ sql ] [ SQL ] SELECT `id`,`state`,`src_by`,`pay_money`,`order_sn`,`pay_config` FROM `tp_comm_consume` WHERE `id` = 2202321 LIMIT 1 [ RunTime:0.006377s ] [ error ] [8]未定义数组索引: paysuc_url[D:\www\api\application\index\controller\Payment.php:41] [ error ] [8]未定义数组索引: payerr_url[D:\www\api\application\index\controller\Payment.php:42] --------------------------------------------------------------- [2025-09-05T23:55:51+08:00] 118.115.47.98 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.199868s] [吞吐率:5.00req/s] [内存消耗:4,045.41kb] [文件加载:101] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '1067', 'x-token' => 'oCmeh5dZgyLH3JVXojnOo1kHWUx4', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.60(0x18003c32) NetType/4G Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/icard/yuePay', 'host' => 'main', 'pageSize' => '15', 'config' => '{"site_id":962,"month_select_nums":["3","6","9","12"],"icard_money":1,"is_member_pay":1,"month_pay_type_name":{"1":{"id":1,"name":"单停车","data":{"park_money":"30.00"},"money":"30.00","title":"停车:30.00元/月","tips":""}},"custome_pay":1}', 'icard' => '{"id":21026,"site_id":962,"icard":"3153613845","member_id":44689,"park_end":1764214759,"charge_end":null,"car_type":"elec","plan_id":207,"total_money":"260.00","yet_money":"256.03","park_end_time":"2025-11-27","charge_end_time":"2025-09-05","sy_money":"3.97","site_name":"星城都","server_tel":"18980369999"}', 'pay_type' => '1', 'month_num' => '3', 'total_money' => '90', 'icard_money' => '20', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010995s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008479s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007184s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008818s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5dZgyLH3JVXojnOo1kHWUx4' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007409s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5dZgyLH3JVXojnOo1kHWUx4' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007195s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008556s ] [ sql ] [ SQL ] SELECT 962,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 962 [ RunTime:0.007343s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.008960s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 962 [ RunTime:0.007238s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008568s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007224s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.009728s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007220s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008367s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007344s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008798s ] [ sql ] [ SQL ] INSERT INTO `tp_comm_consume` (`port` , `state` , `agent_id` , `order_sn` , `icard` , `site_id` , `member_id` , `pay_id` , `order_money` , `pay_money` , `src_by` , `ctime` , `details` , `pay_config` , `rate` , `directions` , `month` , `day` , `remark` , `system`) VALUES (1 , 0 , 438 , 'Y20250905235551466002' , '3153613845' , 962 , 44689 , 44689 , '20' , '20' , 'icard_money' , '2025-09-05 23:55:51' , '{\"icard_id\":21026,\"icard\":\"3153613845\",\"site_id\":962,\"old_money\":\"3.97\",\"icard_money\":\"20.00\"}' , '{\"appId\":\"wx9d3af783c5718533\",\"appSecret\":\"49cd7ec1b8418d1dcb19ce60b78ccb95\",\"partnerId\":\"1511337021\",\"apiKey\":\"f02795ff419df1f67b1b59aa0ca06754\",\"code\":\"yeby\",\"name\":\"元贰佰壹\"}' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , 'IC卡余额缴费,缴费前:3.97元,本次缴费:20.00元' , '2025-09' , '2025-09-05' , NULL , 'main') [ RunTime:0.007545s ] [ error ] [8]未定义数组索引: remark[D:\www\api\application\comm\model\Consume.php:237] --------------------------------------------------------------- [2025-09-05T23:55:52+08:00] 118.115.47.98 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.524264s] [吞吐率:1.91req/s] [内存消耗:4,008.88kb] [文件加载:98] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '72', 'x-token' => 'oCmeh5dZgyLH3JVXojnOo1kHWUx4', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.60(0x18003c32) NetType/4G Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/consume/getPayment', 'host' => 'main', 'pageSize' => '15', 'order_id' => '2202322', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.018001s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008328s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006878s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008122s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5dZgyLH3JVXojnOo1kHWUx4' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006905s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5dZgyLH3JVXojnOo1kHWUx4' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006839s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008250s ] [ sql ] [ SQL ] SELECT `id`,`state`,`src_by`,`pay_money`,`order_sn`,`pay_config` FROM `tp_comm_consume` WHERE `id` = 2202322 LIMIT 1 [ RunTime:0.006903s ] [ error ] [8]未定义数组索引: paysuc_url[D:\www\api\application\index\controller\Payment.php:41] [ error ] [8]未定义数组索引: payerr_url[D:\www\api\application\index\controller\Payment.php:42] --------------------------------------------------------------- [2025-09-05T23:55:54+08:00] 101.226.103.16 POST api.scyeby.com/public/index.php/index/payment/wxnotify.html [运行时间:0.883667s] [吞吐率:1.13req/s] [内存消耗:4,124.43kb] [文件加载:97] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-length' => '829', 'user-agent' => 'Mozilla/4.0', 'content-type' => 'text/xml', 'pragma' => 'no-cache', 'connection' => 'Keep-Alive', 'host' => 'api.scyeby.com', 'accept' => '*/*', ) [ info ] [ PARAM ] array ( ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010188s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008554s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006968s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_pay` [ RunTime:0.008341s ] [ sql ] [ SQL ] INSERT INTO `tp_log_pay` (`trade_no` , `content` , `result` , `ctime`) VALUES ('4200002779202509055109174823' , '{\"appid\":\"wx9d3af783c5718533\",\"attach\":\"2202321\",\"bank_type\":\"ZGB_DEBIT\",\"cash_fee\":\"100\",\"fee_type\":\"CNY\",\"is_subscribe\":\"N\",\"mch_id\":\"1511337021\",\"nonce_str\":\"e86b4f16537cb3c2a81ed331eef22a67\",\"openid\":\"oCmeh5eWGP98bg0z3srC6TXh7IlQ\",\"out_trade_no\":\"Y20250905235547645780\",\"result_code\":\"SUCCESS\",\"return_code\":\"SUCCESS\",\"sign\":\"5260F592BAA06C6738E5D64506A87E22\",\"time_end\":\"20250905235553\",\"total_fee\":\"100\",\"trade_type\":\"JSAPI\",\"transaction_id\":\"4200002779202509055109174823\"}' , '[]' , '2025-09-05 23:55:54') [ RunTime:0.006758s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008526s ] [ sql ] [ SQL ] SELECT `id`,`state`,`ctime`,`details`,`src_by`,`order_money`,`rate` FROM `tp_comm_consume` WHERE `id` = 2202321 LIMIT 1 [ RunTime:0.006755s ] [ sql ] [ SQL ] UPDATE `tp_comm_consume` SET `state` = 9 , `payment_code` = 'wxpay' , `trade_no` = '4200002779202509055109174823' WHERE `id` = 2202321 [ RunTime:0.007798s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008331s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3034032 LIMIT 1 [ RunTime:0.006804s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `state` = 1 , `payment_code` = 'wxpay' , `trade_no` = '4200002779202509055109174823' WHERE `id` = 3034032 [ RunTime:0.006758s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008010s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0014' , 'QY_101' , '{\"Z\":\"101\",\"IDS\":\"YE4G0014\",\"SIDS\":\"BJ000236\",\"CZ\":\"11\",\"MODEL\":\"8\",\"TIM\":\"900\",\"DL\":\"1500\",\"MONEY\":\"100\",\"LIST\":\"0_200_580_20,201_300_580_25,301_400_580_30,401_500_580_40,501_600_580_50,601_700_580_60,701_800_580_70,801_1000_580_80,1001_2200_580_90,2201_3600_580_100\",\"DH\":\"3034032\",\"ZMONEY\":\"100\"}' , '{\"state\":\"1\"}' , '2025-09-05 23:55:54') [ RunTime:0.007609s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008510s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 952 LIMIT 1 [ RunTime:0.006762s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.007996s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006790s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008422s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 48800 LIMIT 1 [ RunTime:0.006740s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.009466s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5eWGP98bg0z3srC6TXh7IlQ' , '开始充电' , '{\"touser\":\"oCmeh5eWGP98bg0z3srC6TXh7IlQ\",\"template_id\":\"Agy1VhMUNj0Ts8jwvjW_UqGEDJOg0Y0-39j6y8nhpRg\",\"data\":{\"thing2\":{\"value\":\"浅水半岛80俊二期\"},\"character_string8\":{\"value\":\"YE4G0014(BJ000236)\"},\"character_string9\":{\"value\":\"No.11\"},\"character_string6\":{\"value\":3034032},\"time3\":{\"value\":\"2025-09-05 23:55:47\"}},\"page\":\"\\/pages\\/orders\\/chargeing?order_id=3034032\"}' , '{\"errcode\":0,\"errmsg\":\"ok\",\"msgid\":4152285186694004742}' , '2025-09-05 23:55:54') [ RunTime:0.007048s ] [ sql ] [ SQL ] UPDATE `tp_log_pay` SET `result` = '{\"code\":200}' WHERE `trade_no` = '4200002779202509055109174823' [ RunTime:0.006725s ] --------------------------------------------------------------- [2025-09-05T23:55:55+08:00] 175.24.212.195 POST api.scyeby.com/public/index.php/index/Wxservice/index.html?signature=65033901b1d72d48eae1758add57c9df20ddfcff×tamp=1757087754&nonce=1671054373&openid=oCmeh5eWGP98bg0z3srC6TXh7IlQ [运行时间:0.064425s] [吞吐率:15.52req/s] [内存消耗:3,503.48kb] [文件加载:86] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'user-agent' => 'Mozilla/4.0', 'accept' => '*/*', 'host' => 'api.scyeby.com', 'pragma' => 'no-cache', 'content-length' => '510', 'content-type' => 'text/xml', ) [ info ] [ PARAM ] array ( 'signature' => '65033901b1d72d48eae1758add57c9df20ddfcff', 'timestamp' => '1757087754', 'nonce' => '1671054373', 'openid' => 'oCmeh5eWGP98bg0z3srC6TXh7IlQ', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.017109s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008039s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006558s ] --------------------------------------------------------------- [2025-09-05T23:55:56+08:00] 39.144.139.46 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.127920s] [吞吐率:7.82req/s] [内存消耗:3,891.22kb] [文件加载:93] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '69', 'x-token' => 'oCmeh5eWGP98bg0z3srC6TXh7IlQ', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.62(0x18003e39) NetType/4G Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/park/getLists', 'host' => 'main', 'pageSize' => '15', 'page_num' => '1', 'state' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010609s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008273s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007021s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008262s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5eWGP98bg0z3srC6TXh7IlQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007049s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5eWGP98bg0z3srC6TXh7IlQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007055s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_park_orders` [ RunTime:0.008857s ] [ sql ] [ SQL ] SELECT `id`,`state`,`site_id`,`ctime`,`total_money`,`pay_money`,`finish`,`finish_time`,`member_mobile`,`payment_code` FROM `tp_park_orders` WHERE `member_id` = 48800 AND `state` IN (1,8) ORDER BY `state` ASC,`id` DESC LIMIT 30 [ RunTime:0.012187s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008391s ] [ sql ] [ SQL ] SELECT 952,`name` FROM `tp_comm_site` WHERE `id` = 952 [ RunTime:0.007055s ] --------------------------------------------------------------- [2025-09-05T23:55:56+08:00] 39.144.139.46 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.285752s] [吞吐率:3.50req/s] [内存消耗:4,079.09kb] [文件加载:101] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '71', 'x-token' => 'oCmeh5eWGP98bg0z3srC6TXh7IlQ', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.62(0x18003e39) NetType/4G Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/getChargeData', 'host' => 'main', 'pageSize' => '15', 'sids' => 'BJ000236', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010404s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008279s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006914s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008240s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5eWGP98bg0z3srC6TXh7IlQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.008117s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5eWGP98bg0z3srC6TXh7IlQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006815s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_socket` [ RunTime:0.008952s ] [ sql ] [ SQL ] SELECT `equi_id`,`num`,`socket_list`,`name` FROM `tp_charge_socket` WHERE `code` = 'BJ000236' [ RunTime:0.008793s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.008279s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`brand`,`site_id` FROM `tp_charge_equi` WHERE `id` = 421 LIMIT 1 [ RunTime:0.006862s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008340s ] [ sql ] [ SQL ] SELECT `id`,`name`,`state`,`server_tel` FROM `tp_comm_site` WHERE `id` = 952 LIMIT 1 [ RunTime:0.006949s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.014946s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 952 LIMIT 1 [ RunTime:0.006937s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.009007s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 952 LIMIT 1 [ RunTime:0.006909s ] --------------------------------------------------------------- [2025-09-05T23:55:58+08:00] 39.144.139.46 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.148318s] [吞吐率:6.74req/s] [内存消耗:3,905.65kb] [文件加载:96] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '78', 'x-token' => 'oCmeh5eWGP98bg0z3srC6TXh7IlQ', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.62(0x18003e39) NetType/4G Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/park/getEquiInfo', 'host' => 'main', 'pageSize' => '15', 'door_num' => '', 'order_id' => '61907', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009586s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007807s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006403s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008473s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5eWGP98bg0z3srC6TXh7IlQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006378s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5eWGP98bg0z3srC6TXh7IlQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006340s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_park_orders` [ RunTime:0.007614s ] [ sql ] [ SQL ] SELECT `id`,`order_sn`,`site_id`,`member_id`,`order_money`,`temp_allow`,`over_price`,`valid_time`,`over_length`,`over_money`,`ctime`,`state`,`open_list` FROM `tp_park_orders` WHERE `id` = 61907 LIMIT 1 [ RunTime:0.006841s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007637s ] [ sql ] [ SQL ] SELECT `id`,`name`,`state`,`server_tel` FROM `tp_comm_site` WHERE `id` = 952 LIMIT 1 [ RunTime:0.006373s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.007504s ] [ sql ] [ SQL ] SELECT `park` FROM `tp_comm_tempprice` WHERE `site_id` = 952 LIMIT 1 [ RunTime:0.006325s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.007498s ] [ sql ] [ SQL ] SELECT `mobile` FROM `tp_comm_member` WHERE `id` = 48800 LIMIT 1 [ RunTime:0.006294s ] [ error ] [8]未定义变量: equi[D:\www\api\application\member\controller\Park.php:254] [ error ] [8]未定义变量: equi[D:\www\api\application\member\controller\Park.php:255] [ error ] [8]未定义变量: door_term[D:\www\api\application\member\controller\Park.php:257] [ error ] [8]未定义变量: door[D:\www\api\application\member\controller\Park.php:258] --------------------------------------------------------------- [2025-09-05T23:56:11+08:00] 101.226.103.15 POST api.scyeby.com/public/index.php/index/payment/wxnotify.html [运行时间:0.237355s] [吞吐率:4.21req/s] [内存消耗:3,948.47kb] [文件加载:93] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-length' => '828', 'user-agent' => 'Mozilla/4.0', 'content-type' => 'text/xml', 'pragma' => 'no-cache', 'connection' => 'Keep-Alive', 'host' => 'api.scyeby.com', 'accept' => '*/*', ) [ info ] [ PARAM ] array ( ) [ sql ] [ DB ] CONNECT:[ UseTime:0.018358s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008242s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006534s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_pay` [ RunTime:0.007756s ] [ sql ] [ SQL ] INSERT INTO `tp_log_pay` (`trade_no` , `content` , `result` , `ctime`) VALUES ('4200002779202509057222899506' , '{\"appid\":\"wx9d3af783c5718533\",\"attach\":\"2202322\",\"bank_type\":\"OTHERS\",\"cash_fee\":\"2000\",\"fee_type\":\"CNY\",\"is_subscribe\":\"N\",\"mch_id\":\"1511337021\",\"nonce_str\":\"c0bc57214e2c747116b6a1c501ecd910\",\"openid\":\"oCmeh5dZgyLH3JVXojnOo1kHWUx4\",\"out_trade_no\":\"Y20250905235551466002\",\"result_code\":\"SUCCESS\",\"return_code\":\"SUCCESS\",\"sign\":\"1E4BA2C1FFB06BC38FB38B34D3088D49\",\"time_end\":\"20250905235610\",\"total_fee\":\"2000\",\"trade_type\":\"JSAPI\",\"transaction_id\":\"4200002779202509057222899506\"}' , '[]' , '2025-09-05 23:56:11') [ RunTime:0.007126s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.007895s ] [ sql ] [ SQL ] SELECT `id`,`state`,`ctime`,`details`,`src_by`,`order_money`,`rate` FROM `tp_comm_consume` WHERE `id` = 2202322 LIMIT 1 [ RunTime:0.006605s ] [ sql ] [ SQL ] UPDATE `tp_comm_consume` SET `state` = 9 , `payment_code` = 'wxpay' , `trade_no` = '4200002779202509057222899506' WHERE `id` = 2202322 [ RunTime:0.006996s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.007818s ] [ sql ] [ SQL ] UPDATE `tp_comm_icard` SET `total_money` = `total_money` + 20 WHERE `icard` = '3153613845' AND `site_id` = 962 [ RunTime:0.008591s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007821s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 962 LIMIT 1 [ RunTime:0.006587s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.007846s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006613s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.007685s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006527s ] [ sql ] [ SQL ] SELECT `nickname`,`mobile` FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006543s ] [ sql ] [ SQL ] SELECT `total_money` FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006516s ] [ sql ] [ SQL ] UPDATE `tp_comm_user` SET `total_money` = `total_money` + 20 WHERE `user_id` = 438 [ RunTime:0.006553s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_packet` [ RunTime:0.007886s ] [ sql ] [ SQL ] INSERT INTO `tp_comm_packet` (`site_id` , `user_id` , `type` , `money` , `state` , `src_by` , `ctime` , `uptime` , `details` , `trade_no` , `name` , `mobile` , `rule` , `month` , `day` , `system`) VALUES ( 962,438,1,'20.00',9,'icard_money','2025-09-05 23:55:51','2025-09-05 23:56:11','{\"order_money\":20,\"old_money\":4403657.5}','4200002779202509057222899506','元贰佰壹科技有限公司','18980369999','100%','2025-09','2025-09-05','main' ) [ RunTime:0.011213s ] [ sql ] [ SQL ] UPDATE `tp_log_pay` SET `result` = '{\"code\":200}' WHERE `trade_no` = '4200002779202509057222899506' [ RunTime:0.006587s ] --------------------------------------------------------------- [2025-09-05T23:56:14+08:00] 118.115.47.98 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.115254s] [吞吐率:8.68req/s] [内存消耗:3,557.17kb] [文件加载:90] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '51', 'x-token' => 'oCmeh5dZgyLH3JVXojnOo1kHWUx4', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.60(0x18003c32) NetType/4G Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/member/getInfo', 'host' => 'main', 'pageSize' => '15', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.015956s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008709s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007379s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008760s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5dZgyLH3JVXojnOo1kHWUx4' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007146s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5dZgyLH3JVXojnOo1kHWUx4' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006996s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008569s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 44689 LIMIT 1 [ RunTime:0.008005s ] --------------------------------------------------------------- [2025-09-05T23:56:14+08:00] 118.115.47.98 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.134777s] [吞吐率:7.42req/s] [内存消耗:3,885.74kb] [文件加载:93] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '61', 'x-token' => 'oCmeh5dZgyLH3JVXojnOo1kHWUx4', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.60(0x18003c32) NetType/4G Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/icard/getLists', 'host' => 'main', 'pageSize' => '15', 'pageNum' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010569s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008330s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007155s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008839s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5dZgyLH3JVXojnOo1kHWUx4' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006929s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5dZgyLH3JVXojnOo1kHWUx4' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007131s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008642s ] [ sql ] [ SQL ] SELECT `id`,`site_id`,`icard`,`park_end`,`charge_end` FROM `tp_comm_icard` WHERE `member_id` = 44689 ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.007100s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008315s ] [ sql ] [ SQL ] SELECT 962,`name`,`area_name`,`server_tel` FROM `tp_comm_site` WHERE `id` = 962 [ RunTime:0.007038s ] [ sql ] [ SQL ] SELECT COUNT(`id`) AS tp_count FROM `tp_comm_icard` WHERE `member_id` = 44689 [ RunTime:0.008375s ] --------------------------------------------------------------- [2025-09-05T23:56:15+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:0.887794s] [吞吐率:1.13req/s] [内存消耗:4,384.91kb] [文件加载:107] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-type' => 'application/json', 'host' => 'api.scyeby.com', 'content-length' => '103', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '207', 'IDS' => 'YE4G0053', 'SIDS' => '860B890E', 'IC' => '1384586452', 'CZ' => '1', 'CS' => '1', 'TY' => '1', 'MXHao' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010956s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008612s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007142s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.008801s ] [ sql ] [ SQL ] SELECT `site_id`,`brand` FROM `tp_charge_equi` WHERE `equi_ids` = 'YE4G0053' LIMIT 1 [ RunTime:0.008168s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008811s ] [ sql ] [ SQL ] SELECT `relation_site_ids` FROM `tp_comm_site` WHERE `id` = 963 LIMIT 1 [ RunTime:0.009140s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.009136s ] [ sql ] [ SQL ] SELECT `start_time`,`id`,`total_elec`,`yet_elec`,total_elec-yet_elec sy_elec,`total_time`,`yet_time`,total_time-yet_time sy_time,`total_num`,`yet_num`,total_num-yet_num sy_num FROM `tp_charge_month` WHERE `site_id` = 963 AND `icard` = '1384586452' AND `start_time` <= '2025-09-05' AND `end_time` > '2025-09-05' [ RunTime:0.008829s ] [ sql ] [ SQL ] SELECT `id`,`total_elec`,`yet_elec`,total_elec-yet_elec sy_elec,`total_time`,`yet_time`,total_time-yet_time sy_time,`total_num`,`yet_num`,total_num-yet_num sy_num FROM `tp_charge_month` WHERE `icard` = '1384586452' AND `start_time` <= '2025-09-05' AND `end_time` >= '2025-09-05' [ RunTime:0.007357s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008486s ] [ sql ] [ SQL ] SELECT total_money-yet_money sy_money,`icard`,`member_id`,`state`,`park_end` FROM `tp_comm_icard` WHERE `site_id` = 963 AND `icard` = '1384586452' ORDER BY `id` ASC [ RunTime:0.007887s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008828s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 963 [ RunTime:0.007195s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008919s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`sids`,`socket_num` FROM `tp_charge_orders` WHERE `icard` = '1384586452' AND `site_id` = 963 AND `state` = 1 [ RunTime:0.012159s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.008776s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 963 LIMIT 1 [ RunTime:0.007845s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 963 [ RunTime:0.007139s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008659s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 47855 LIMIT 1 [ RunTime:0.007838s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = 'YE4G0053' AND `state` = 1 AND `sids` = '860B890E' AND `socket_num` = 1 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.008520s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 963 LIMIT 1 [ RunTime:0.007120s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008324s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007441s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008398s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007745s ] [ sql ] [ SQL ] INSERT INTO `tp_charge_orders` (`agent_id` , `site_id` , `order_sn` , `icard` , `state` , `member_id` , `member_mobile` , `equi_ids` , `socket_num` , `socket_no` , `sids` , `pay_money` , `ctime` , `valid_time` , `price_info` , `brand` , `value` , `other` , `system`) VALUES (438 , 963 , '20250905235614754661' , '1384586452' , 0 , 47855 , '13124653094' , 'YE4G0053' , 1 , 0 , '860B890E' , 10 , '2025-09-05 23:56:14' , 1757123774 , '{\"charge_type\":\"8\",\"start_power\":[\"0\",\"201\",\"301\",\"401\",\"501\",\"601\",\"701\",\"801\"],\"end_power\":[\"200\",\"300\",\"400\",\"500\",\"600\",\"700\",\"800\",\"950\"],\"price\":[\"0.95\",\"0.95\",\"0.95\",\"0.95\",\"0.95\",\"0.95\",\"0.95\",\"0.95\"],\"time\":[\"0.15\",\"0.2\",\"0.25\",\"0.3\",\"0.35\",\"0.4\",\"0.45\",\"0.5\"]}' , 'qy' , 10 , '[]' , 'main') [ RunTime:0.008196s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3034033 LIMIT 1 [ RunTime:0.007293s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `state` = 1 , `payment_code` = 'icardyue' , `trade_no` = 'HD2025090523561517570877759648' WHERE `id` = 3034033 [ RunTime:0.007483s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008696s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0053' , 'QY_101' , '{\"Z\":\"101\",\"IDS\":\"YE4G0053\",\"SIDS\":\"860B890E\",\"CZ\":\"1\",\"MODEL\":\"8\",\"TIM\":\"600\",\"DL\":\"1000\",\"MONEY\":\"1000\",\"LIST\":\"0_200_950_15,201_300_950_20,301_400_950_25,401_500_950_30,501_600_950_35,601_700_950_40,701_800_950_45,801_950_950_50\",\"DH\":\"3034033\",\"ZMONEY\":\"5790\"}' , '{\"state\":\"1\"}' , '2025-09-05 23:56:15') [ RunTime:0.007533s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 963 LIMIT 1 [ RunTime:0.007292s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008816s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007231s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 47855 LIMIT 1 [ RunTime:0.007139s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008612s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5cT765sCJubmwd1Hr1YHePE' , '开始充电' , '{\"touser\":\"oCmeh5cT765sCJubmwd1Hr1YHePE\",\"template_id\":\"Agy1VhMUNj0Ts8jwvjW_UqGEDJOg0Y0-39j6y8nhpRg\",\"data\":{\"thing2\":{\"value\":\"龙邸\"},\"character_string8\":{\"value\":\"YE4G0053(860B890E)\"},\"character_string9\":{\"value\":\"No.1\"},\"character_string6\":{\"value\":3034033},\"time3\":{\"value\":\"2025-09-05 23:56:14\"}},\"page\":\"\\/pages\\/orders\\/chargeing?order_id=3034033\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68bb081f-36eca1fd-3b3ee9da\"}' , '2025-09-05 23:56:15') [ RunTime:0.007520s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0053' , 'QY_207' , '{\"Z\":\"207\",\"IDS\":\"YE4G0053\",\"SIDS\":\"860B890E\",\"IC\":\"1384586452\",\"CZ\":\"1\",\"CS\":\"1\",\"TY\":\"1\",\"MXHao\":\"1\"}' , '{\"Z\":\"207\",\"IDS\":\"YE4G0053\",\"SIDS\":\"860B890E\",\"CZ\":\"1\",\"IC\":\"1384586452\",\"MONEY\":\"5790\",\"MXHao\":\"1\",\"state\":\"1\",\"msg\":\"5\",\"msg2\":\"45\",\"txt\":\"开电成功\"}' , '2025-09-05 23:56:15') [ RunTime:0.007206s ] [ error ] [8]未定义数组索引: msg[D:\www\api\application\charge\model\Api.php:373] --------------------------------------------------------------- [2025-09-05T23:57:21+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:0.783644s] [吞吐率:1.28req/s] [内存消耗:4,240.87kb] [文件加载:104] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-type' => 'application/json', 'host' => 'api.scyeby.com', 'content-length' => '178', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => 'YEWI0044', 'SIDS' => 'BJ000260', 'CZ' => '12', 'DH' => '3033114', 'POW' => '403', 'DL' => '1.5792', 'TIM' => '280', 'MSG' => '8', 'POWs' => '3033114', 'MONEY' => '241', 'MSG2' => '本次费用用完', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.011880s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008793s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007231s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.009136s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3033114 LIMIT 1 [ RunTime:0.007365s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008547s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 967 [ RunTime:0.008198s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008834s ] [ sql ] [ SQL ] SELECT `id`,`total_money`,`yet_money` FROM `tp_comm_icard` WHERE `site_id` = 967 AND `icard` = '3143429429' LIMIT 1 [ RunTime:0.008413s ] [ sql ] [ SQL ] UPDATE `tp_comm_icard` SET `yet_money` = '815.90' , `uptime` = 1757087840 WHERE `id` = 5320 [ RunTime:0.007424s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008495s ] [ sql ] [ SQL ] SELECT 967,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 967 [ RunTime:0.008477s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.008630s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 967 [ RunTime:0.008307s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008406s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007624s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008397s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007227s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008480s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007255s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008823s ] [ sql ] [ SQL ] INSERT INTO `tp_comm_consume` (`port` , `state` , `agent_id` , `order_sn` , `icard` , `site_id` , `member_id` , `pay_id` , `order_money` , `pay_money` , `src_by` , `ctime` , `rate` , `directions` , `month` , `day` , `remark` , `details` , `payment_code` , `trade_no` , `system`) VALUES (1 , 9 , 438 , 'Y20250905235720365072' , '3143429429' , 967 , 4439 , 4439 , '2.51' , '2.51' , 'charge_temp' , '2025-09-05 19:15:45' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '刷卡充电' , '2025-09' , '2025-09-05' , NULL , '{\"sql\":\"UPDATE `tp_comm_icard` SET `yet_money` = \'815.90\' , `uptime` = 1757087840 WHERE `id` = 5320\",\"icard\":{\"id\":5320,\"total_money\":\"815.90\",\"yet_money\":\"813.77\"}}' , 'icardyue' , 'HD2025090519154517570709458691' , 'main') [ RunTime:0.011223s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025090519154517570709458691' , `order_money` = '2.51' , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 280 , `elec_num` = 1.73712 , `power_num` = 403 , `finish` = 8 , `state` = 9 , `other` = '{\"finish_text\":\"本次费用用完\",\"POWs\":\"3033114\",\"sj_elec\":\"1.5792\"}' , `finish_time` = '2025-09-05 23:57:20' , `js_result` = '{\"money\":\"2.51\",\"elec_num\":1.73712,\"elec_price\":\"0.579\",\"timeNum\":5,\"server_price\":\"0.3\"}' WHERE `id` = 3033114 [ RunTime:0.008189s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 967 LIMIT 1 [ RunTime:0.007162s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007284s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008452s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 4439 LIMIT 1 [ RunTime:0.008035s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008682s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5cE2UHwc_wTSUeuDCSbTACs' , '结束充电' , '{\"touser\":\"oCmeh5cE2UHwc_wTSUeuDCSbTACs\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"上行锦绣5栋\"},\"time4\":{\"value\":\"2025-09-05 19:15:45\"},\"time3\":{\"value\":\"2025-09-05 23:57:20\"},\"thing5\":{\"value\":\"您的订单【3033114】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=3033114\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68bb0860-34f31f74-3f79e067\"}' , '2025-09-05 23:57:21') [ RunTime:0.008600s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008381s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEWI0044' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YEWI0044\",\"SIDS\":\"BJ000260\",\"CZ\":\"12\",\"DH\":\"3033114\",\"POW\":\"403\",\"DL\":\"1.5792\",\"TIM\":\"280\",\"MSG\":\"8\",\"POWs\":\"3033114\",\"MONEY\":\"241\",\"MSG2\":\"本次费用用完\"}' , '{\"Z\":\"206\",\"IDS\":\"YEWI0044\",\"SIDS\":\"BJ000260\",\"CZ\":\"12\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-09-05 23:57:21') [ RunTime:0.007178s ] [ error ] [8]未定义数组索引: remark[D:\www\api\application\comm\model\Consume.php:449] --------------------------------------------------------------- [2025-09-05T23:57:25+08:00] 39.144.139.46 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.175460s] [吞吐率:5.70req/s] [内存消耗:3,905.66kb] [文件加载:96] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '78', 'x-token' => 'oCmeh5eWGP98bg0z3srC6TXh7IlQ', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.62(0x18003e39) NetType/4G Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/park/getEquiInfo', 'host' => 'main', 'pageSize' => '15', 'door_num' => '', 'order_id' => '61907', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010566s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008516s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007049s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008830s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5eWGP98bg0z3srC6TXh7IlQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007045s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5eWGP98bg0z3srC6TXh7IlQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007375s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_park_orders` [ RunTime:0.008611s ] [ sql ] [ SQL ] SELECT `id`,`order_sn`,`site_id`,`member_id`,`order_money`,`temp_allow`,`over_price`,`valid_time`,`over_length`,`over_money`,`ctime`,`state`,`open_list` FROM `tp_park_orders` WHERE `id` = 61907 LIMIT 1 [ RunTime:0.007117s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008526s ] [ sql ] [ SQL ] SELECT `id`,`name`,`state`,`server_tel` FROM `tp_comm_site` WHERE `id` = 952 LIMIT 1 [ RunTime:0.007159s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.008195s ] [ sql ] [ SQL ] SELECT `park` FROM `tp_comm_tempprice` WHERE `site_id` = 952 LIMIT 1 [ RunTime:0.010438s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008170s ] [ sql ] [ SQL ] SELECT `mobile` FROM `tp_comm_member` WHERE `id` = 48800 LIMIT 1 [ RunTime:0.012626s ] [ error ] [8]未定义变量: equi[D:\www\api\application\member\controller\Park.php:254] [ error ] [8]未定义变量: equi[D:\www\api\application\member\controller\Park.php:255] [ error ] [8]未定义变量: door_term[D:\www\api\application\member\controller\Park.php:257] [ error ] [8]未定义变量: door[D:\www\api\application\member\controller\Park.php:258] --------------------------------------------------------------- [2025-09-05T23:57:31+08:00] 39.144.139.46 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.077022s] [吞吐率:12.98req/s] [内存消耗:3,543.73kb] [文件加载:89] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '53', 'x-token' => 'oCmeh5eWGP98bg0z3srC6TXh7IlQ', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.62(0x18003e39) NetType/4G Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/system/getSystem', 'host' => 'main', 'pageSize' => '15', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.011115s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008794s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007400s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008504s ] [ sql ] [ SQL ] SELECT `site_name`,`site_logo`,`upload_config`,`regcms` FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007438s ] --------------------------------------------------------------- [2025-09-05T23:57:40+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:0.723884s] [吞吐率:1.38req/s] [内存消耗:4,240.99kb] [文件加载:104] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-type' => 'application/json', 'host' => 'api.scyeby.com', 'content-length' => '198', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => 'YE4G0153', 'SIDS' => '900B65D5', 'CZ' => '1', 'DH' => '3032779', 'POW' => '252', 'DL' => '1.2790', 'TIM' => '335', 'MSG' => '8', 'POWs' => '3032779', 'MONEY' => '224', 'MSG2' => '检测到插座无充电器结束订单', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010536s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008307s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007040s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008333s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3032779 LIMIT 1 [ RunTime:0.007157s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008273s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 939 [ RunTime:0.007728s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008196s ] [ sql ] [ SQL ] SELECT `id`,`total_money`,`yet_money` FROM `tp_comm_icard` WHERE `site_id` = 939 AND `icard` = '3152993733' LIMIT 1 [ RunTime:0.007976s ] [ sql ] [ SQL ] UPDATE `tp_comm_icard` SET `yet_money` = 349.45 , `uptime` = 1757087859 WHERE `id` = 17277 [ RunTime:0.007341s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008232s ] [ sql ] [ SQL ] SELECT 939,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 939 [ RunTime:0.006968s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.008381s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 939 [ RunTime:0.007014s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008131s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007062s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008122s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007087s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008306s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.008286s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008196s ] [ sql ] [ SQL ] INSERT INTO `tp_comm_consume` (`port` , `state` , `agent_id` , `order_sn` , `icard` , `site_id` , `member_id` , `pay_id` , `order_money` , `pay_money` , `src_by` , `ctime` , `rate` , `directions` , `month` , `day` , `remark` , `details` , `payment_code` , `trade_no` , `system`) VALUES (1 , 9 , 438 , 'Y20250905235739688786' , '3152993733' , 939 , 33362 , 33362 , '2.31' , '2.31' , 'charge_temp' , '2025-09-05 18:21:15' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '刷卡充电' , '2025-09' , '2025-09-05' , NULL , '{\"sql\":\"UPDATE `tp_comm_icard` SET `yet_money` = 349.45 , `uptime` = 1757087859 WHERE `id` = 17277\",\"icard\":{\"id\":17277,\"total_money\":\"400.00\",\"yet_money\":\"347.14\"}}' , 'icardyue' , 'HD2025090518211517570676759132' , 'main') [ RunTime:0.007793s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025090518211517570676759132' , `order_money` = '2.31' , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 335 , `elec_num` = 1.4069 , `power_num` = 252 , `finish` = 8 , `state` = 9 , `other` = '{\"finish_text\":\"检测到插座无充电器结束订单\",\"POWs\":\"3032779\",\"sj_elec\":\"1.2790\"}' , `finish_time` = '2025-09-05 23:57:39' , `js_result` = '{\"money\":\"2.31\",\"elec_num\":1.4068999999999998,\"elec_price\":\"0.579\",\"timeNum\":6,\"server_price\":\"0.25\"}' WHERE `id` = 3032779 [ RunTime:0.007302s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 939 LIMIT 1 [ RunTime:0.007140s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007044s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008256s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 33362 LIMIT 1 [ RunTime:0.007321s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008533s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5ZYMX84tHVYZsM6CA9lqo5s' , '结束充电' , '{\"touser\":\"oCmeh5ZYMX84tHVYZsM6CA9lqo5s\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"浅水半岛二期\"},\"time4\":{\"value\":\"2025-09-05 18:21:15\"},\"time3\":{\"value\":\"2025-09-05 23:57:39\"},\"thing5\":{\"value\":\"您的订单【3032779】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=3032779\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68bb0873-7e9926d3-4c0e44bd\"}' , '2025-09-05 23:57:40') [ RunTime:0.007328s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008372s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0153' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YE4G0153\",\"SIDS\":\"900B65D5\",\"CZ\":\"1\",\"DH\":\"3032779\",\"POW\":\"252\",\"DL\":\"1.2790\",\"TIM\":\"335\",\"MSG\":\"8\",\"POWs\":\"3032779\",\"MONEY\":\"224\",\"MSG2\":\"检测到插座无充电器结束订单\"}' , '{\"Z\":\"206\",\"IDS\":\"YE4G0153\",\"SIDS\":\"900B65D5\",\"CZ\":\"1\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-09-05 23:57:40') [ RunTime:0.007241s ] [ error ] [8]未定义数组索引: remark[D:\www\api\application\comm\model\Consume.php:449] --------------------------------------------------------------- [2025-09-05T23:57:53+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:0.848983s] [吞吐率:1.18req/s] [内存消耗:4,384.31kb] [文件加载:107] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-type' => 'application/json', 'host' => 'api.scyeby.com', 'content-length' => '103', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '207', 'IDS' => 'GX4G0104', 'SIDS' => 'CB0B694B', 'IC' => '1392372004', 'CZ' => '3', 'CS' => '1', 'TY' => '1', 'MXHao' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.011274s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008897s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007557s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.009170s ] [ sql ] [ SQL ] SELECT `site_id`,`brand` FROM `tp_charge_equi` WHERE `equi_ids` = 'GX4G0104' LIMIT 1 [ RunTime:0.007569s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008841s ] [ sql ] [ SQL ] SELECT `relation_site_ids` FROM `tp_comm_site` WHERE `id` = 997 LIMIT 1 [ RunTime:0.007565s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.009193s ] [ sql ] [ SQL ] SELECT `start_time`,`id`,`total_elec`,`yet_elec`,total_elec-yet_elec sy_elec,`total_time`,`yet_time`,total_time-yet_time sy_time,`total_num`,`yet_num`,total_num-yet_num sy_num FROM `tp_charge_month` WHERE `site_id` = 997 AND `icard` = '1392372004' AND `start_time` <= '2025-09-05' AND `end_time` > '2025-09-05' [ RunTime:0.008885s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008974s ] [ sql ] [ SQL ] SELECT total_money-yet_money sy_money,`icard`,`member_id`,`state`,`park_end` FROM `tp_comm_icard` WHERE `site_id` = 997 AND `icard` = '1392372004' ORDER BY `id` ASC [ RunTime:0.008275s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.009370s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 997 [ RunTime:0.007600s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008940s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`sids`,`socket_num` FROM `tp_charge_orders` WHERE `icard` = '1392372004' AND `site_id` = 997 AND `state` = 1 [ RunTime:0.011542s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.008755s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 997 LIMIT 1 [ RunTime:0.007893s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 997 [ RunTime:0.007650s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008982s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 48328 LIMIT 1 [ RunTime:0.007862s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = 'GX4G0104' AND `state` = 1 AND `sids` = 'CB0B694B' AND `socket_num` = 3 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.013685s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 997 LIMIT 1 [ RunTime:0.007521s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008892s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007591s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008998s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007584s ] [ sql ] [ SQL ] INSERT INTO `tp_charge_orders` (`agent_id` , `site_id` , `order_sn` , `icard` , `state` , `member_id` , `member_mobile` , `equi_ids` , `socket_num` , `socket_no` , `sids` , `pay_money` , `ctime` , `valid_time` , `price_info` , `brand` , `value` , `other` , `system`) VALUES (438 , 997 , '20250905235753282713' , '1392372004' , 0 , 48328 , '13808141521' , 'GX4G0104' , 3 , 0 , 'CB0B694B' , 10 , '2025-09-05 23:57:53' , 1757123873 , '{\"charge_type\":\"8\",\"start_power\":[\"0\",\"201\",\"301\",\"401\",\"501\",\"601\",\"701\",\"801\"],\"end_power\":[\"200\",\"300\",\"400\",\"500\",\"600\",\"700\",\"800\",\"950\"],\"price\":[\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\"],\"time\":[\"0.15\",\"0.2\",\"0.25\",\"0.3\",\"0.35\",\"0.4\",\"0.45\",\"0.5\"]}' , 'qy' , 10 , '{\"month_id\":91625}' , 'main') [ RunTime:0.007931s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3034034 LIMIT 1 [ RunTime:0.008897s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `state` = 1 , `payment_code` = 'month' , `trade_no` = 'HD2025090523575317570878735044' WHERE `id` = 3034034 [ RunTime:0.007954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008799s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('GX4G0104' , 'QY_101' , '{\"Z\":\"101\",\"IDS\":\"GX4G0104\",\"SIDS\":\"CB0B694B\",\"CZ\":\"3\",\"MODEL\":\"8\",\"TIM\":\"600\",\"DL\":\"1000\",\"MONEY\":\"1000\",\"LIST\":\"0_200_579_15,201_300_579_20,301_400_579_25,401_500_579_30,501_600_579_35,601_700_579_40,701_800_579_45,801_950_579_50\",\"DH\":\"3034034\",\"ZMONEY\":\"0\"}' , '{\"state\":\"1\"}' , '2025-09-05 23:57:53') [ RunTime:0.008043s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 997 LIMIT 1 [ RunTime:0.007545s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008765s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007661s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 48328 LIMIT 1 [ RunTime:0.007517s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008808s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5cihg6eX0AG-TmjoYbXc9CE' , '开始充电' , '{\"touser\":\"oCmeh5cihg6eX0AG-TmjoYbXc9CE\",\"template_id\":\"Agy1VhMUNj0Ts8jwvjW_UqGEDJOg0Y0-39j6y8nhpRg\",\"data\":{\"thing2\":{\"value\":\"北极星\"},\"character_string8\":{\"value\":\"GX4G0104(CB0B694B)\"},\"character_string9\":{\"value\":\"No.3\"},\"character_string6\":{\"value\":3034034},\"time3\":{\"value\":\"2025-09-05 23:57:53\"}},\"page\":\"\\/pages\\/orders\\/chargeing?order_id=3034034\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68bb0881-04d547b2-40ccdf77\"}' , '2025-09-05 23:57:53') [ RunTime:0.007842s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('GX4G0104' , 'QY_207' , '{\"Z\":\"207\",\"IDS\":\"GX4G0104\",\"SIDS\":\"CB0B694B\",\"IC\":\"1392372004\",\"CZ\":\"3\",\"CS\":\"1\",\"TY\":\"1\",\"MXHao\":\"1\"}' , '{\"Z\":\"207\",\"IDS\":\"GX4G0104\",\"SIDS\":\"CB0B694B\",\"CZ\":\"3\",\"IC\":\"1392372004\",\"MONEY\":\"0\",\"MXHao\":\"1\",\"state\":\"1\",\"msg\":\"5\",\"msg2\":\"45\",\"txt\":\"开电成功\"}' , '2025-09-05 23:57:53') [ RunTime:0.007568s ] [ error ] [8]未定义数组索引: msg[D:\www\api\application\charge\model\Api.php:373] --------------------------------------------------------------- [2025-09-05T23:57:54+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:0.628880s] [吞吐率:1.59req/s] [内存消耗:3,956.88kb] [文件加载:94] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-type' => 'application/json', 'host' => 'api.scyeby.com', 'content-length' => '171', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => 'YEWKA025', 'SIDS' => 'CH100027', 'CZ' => '4', 'DH' => '3032618', 'POW' => '102', 'DL' => '0.4499', 'TIM' => '359', 'MSG' => '8', 'POWs' => '3032618', 'MONEY' => '116', 'MSG2' => '充满停止', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.017045s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007698s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006447s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008453s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3032618 LIMIT 1 [ RunTime:0.006896s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.007782s ] [ sql ] [ SQL ] SELECT `total_elec`,`yet_elec`,`total_time`,`yet_time`,`total_num`,`yet_num` FROM `tp_charge_month` WHERE `id` = 85772 LIMIT 1 [ RunTime:0.007656s ] [ sql ] [ SQL ] UPDATE `tp_charge_month` SET `yet_time` = 35.98 WHERE `id` = 85772 [ RunTime:0.006744s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025090517571917570662392727' , `order_money` = 0 , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 359 , `elec_num` = 0.49489 , `power_num` = 102 , `finish` = 8 , `state` = 9 , `other` = '{\"month_id\":85772,\"finish_text\":\"充满停止\",\"POWs\":\"3032618\",\"sj_elec\":\"0.4499\"}' , `finish_time` = '2025-09-05 23:57:53' , `js_result` = '[]' WHERE `id` = 3032618 [ RunTime:0.006500s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008118s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 971 LIMIT 1 [ RunTime:0.006399s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.007584s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007002s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.007606s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 8716 LIMIT 1 [ RunTime:0.006769s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.007896s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5ZCGJ-3wjfMUV4JQoLYU1sA' , '结束充电' , '{\"touser\":\"oCmeh5ZCGJ-3wjfMUV4JQoLYU1sA\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"红枫林三期三号门\"},\"time4\":{\"value\":\"2025-09-05 17:57:19\"},\"time3\":{\"value\":\"2025-09-05 23:57:53\"},\"thing5\":{\"value\":\"您的订单【3032618】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=3032618\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68bb0881-499a8a9d-38977406\"}' , '2025-09-05 23:57:54') [ RunTime:0.006739s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.007681s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEWKA025' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YEWKA025\",\"SIDS\":\"CH100027\",\"CZ\":\"4\",\"DH\":\"3032618\",\"POW\":\"102\",\"DL\":\"0.4499\",\"TIM\":\"359\",\"MSG\":\"8\",\"POWs\":\"3032618\",\"MONEY\":\"116\",\"MSG2\":\"充满停止\"}' , '{\"Z\":\"206\",\"IDS\":\"YEWKA025\",\"SIDS\":\"CH100027\",\"CZ\":\"4\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-09-05 23:57:54') [ RunTime:0.006921s ] --------------------------------------------------------------- [2025-09-05T23:57:58+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:0.190063s] [吞吐率:5.26req/s] [内存消耗:4,178.82kb] [文件加载:101] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-type' => 'application/json', 'host' => 'api.scyeby.com', 'content-length' => '103', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '207', 'IDS' => 'GX4G0104', 'SIDS' => 'CB0B694B', 'IC' => '1392372004', 'CZ' => '3', 'CS' => '1', 'TY' => '1', 'MXHao' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009869s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007888s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006564s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.007999s ] [ sql ] [ SQL ] SELECT `site_id`,`brand` FROM `tp_charge_equi` WHERE `equi_ids` = 'GX4G0104' LIMIT 1 [ RunTime:0.007491s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007692s ] [ sql ] [ SQL ] SELECT `relation_site_ids` FROM `tp_comm_site` WHERE `id` = 997 LIMIT 1 [ RunTime:0.007238s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.007710s ] [ sql ] [ SQL ] SELECT `start_time`,`id`,`total_elec`,`yet_elec`,total_elec-yet_elec sy_elec,`total_time`,`yet_time`,total_time-yet_time sy_time,`total_num`,`yet_num`,total_num-yet_num sy_num FROM `tp_charge_month` WHERE `site_id` = 997 AND `icard` = '1392372004' AND `start_time` <= '2025-09-05' AND `end_time` > '2025-09-05' [ RunTime:0.007584s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.007701s ] [ sql ] [ SQL ] SELECT total_money-yet_money sy_money,`icard`,`member_id`,`state`,`park_end` FROM `tp_comm_icard` WHERE `site_id` = 997 AND `icard` = '1392372004' ORDER BY `id` ASC [ RunTime:0.007245s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.007782s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 997 [ RunTime:0.007491s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.007775s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`sids`,`socket_num` FROM `tp_charge_orders` WHERE `icard` = '1392372004' AND `site_id` = 997 AND `state` = 1 [ RunTime:0.008313s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008125s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('GX4G0104' , 'QY_207' , '{\"Z\":\"207\",\"IDS\":\"GX4G0104\",\"SIDS\":\"CB0B694B\",\"IC\":\"1392372004\",\"CZ\":\"3\",\"CS\":\"1\",\"TY\":\"1\",\"MXHao\":\"1\"}' , '{\"Z\":\"207\",\"IDS\":\"GX4G0104\",\"SIDS\":\"CB0B694B\",\"CZ\":\"3\",\"IC\":\"1392372004\",\"MONEY\":\"0\",\"MXHao\":\"1\",\"state\":\"0\",\"msg\":\"6\",\"msg2\":\"103\",\"txt\":\"一张卡只允许充【1】台车,已充【1】台\"}' , '2025-09-05 23:57:58') [ RunTime:0.006643s ] [ error ] [8]未定义数组索引: sy_money[D:\www\api\application\index\controller\Receive.php:128] --------------------------------------------------------------- [2025-09-05T23:58:04+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:0.415217s] [吞吐率:2.41req/s] [内存消耗:4,380.62kb] [文件加载:107] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-type' => 'application/json', 'host' => 'api.scyeby.com', 'content-length' => '103', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '207', 'IDS' => '10142123', 'SIDS' => 'BJ000055', 'IC' => '3559889075', 'CZ' => '4', 'CS' => '1', 'TY' => '1', 'MXHao' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010941s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008809s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007212s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.008344s ] [ sql ] [ SQL ] SELECT `site_id`,`brand` FROM `tp_charge_equi` WHERE `equi_ids` = '10142123' LIMIT 1 [ RunTime:0.007207s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008705s ] [ sql ] [ SQL ] SELECT `relation_site_ids` FROM `tp_comm_site` WHERE `id` = 958 LIMIT 1 [ RunTime:0.007187s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.008497s ] [ sql ] [ SQL ] SELECT `start_time`,`id`,`total_elec`,`yet_elec`,total_elec-yet_elec sy_elec,`total_time`,`yet_time`,total_time-yet_time sy_time,`total_num`,`yet_num`,total_num-yet_num sy_num FROM `tp_charge_month` WHERE `site_id` = 958 AND `icard` = '3559889075' AND `start_time` <= '2025-09-05' AND `end_time` > '2025-09-05' [ RunTime:0.008788s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008415s ] [ sql ] [ SQL ] SELECT total_money-yet_money sy_money,`icard`,`member_id`,`state`,`park_end` FROM `tp_comm_icard` WHERE `site_id` = 958 AND `icard` = '3559889075' ORDER BY `id` ASC [ RunTime:0.008057s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008359s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 958 [ RunTime:0.007220s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008627s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`sids`,`socket_num` FROM `tp_charge_orders` WHERE `icard` = '3559889075' AND `site_id` = 958 AND `state` = 1 [ RunTime:0.011679s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.008352s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 958 LIMIT 1 [ RunTime:0.008140s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 958 [ RunTime:0.007137s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008402s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 2894 LIMIT 1 [ RunTime:0.007976s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = '10142123' AND `state` = 1 AND `sids` = 'BJ000055' AND `socket_num` = 4 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.025776s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 958 LIMIT 1 [ RunTime:0.007249s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008477s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007251s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008508s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007827s ] [ sql ] [ SQL ] INSERT INTO `tp_charge_orders` (`agent_id` , `site_id` , `order_sn` , `icard` , `state` , `member_id` , `member_mobile` , `equi_ids` , `socket_num` , `socket_no` , `sids` , `pay_money` , `ctime` , `valid_time` , `price_info` , `brand` , `value` , `other` , `system`) VALUES (438 , 958 , '20250905235804678756' , '3559889075' , 0 , 2894 , '15388167137' , '10142123' , 4 , 0 , 'BJ000055' , 10 , '2025-09-05 23:58:04' , 1757123884 , '{\"charge_type\":\"8\",\"start_power\":[\"0\",\"201\",\"301\",\"401\",\"501\",\"601\",\"701\",\"801\"],\"end_power\":[\"200\",\"300\",\"400\",\"500\",\"600\",\"700\",\"800\",\"950\"],\"price\":[\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\"],\"time\":[\"0.15\",\"0.2\",\"0.25\",\"0.3\",\"0.35\",\"0.4\",\"0.45\",\"0.5\"]}' , 'qy' , 10 , '{\"month_id\":87960}' , 'main') [ RunTime:0.007553s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3034035 LIMIT 1 [ RunTime:0.007326s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `state` = 1 , `payment_code` = 'month' , `trade_no` = 'HD2025090523580417570878843664' WHERE `id` = 3034035 [ RunTime:0.007472s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008551s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('10142123' , 'QY_101' , '{\"Z\":\"101\",\"IDS\":\"10142123\",\"SIDS\":\"BJ000055\",\"CZ\":\"4\",\"MODEL\":\"8\",\"TIM\":\"600\",\"DL\":\"1000\",\"MONEY\":\"1000\",\"LIST\":\"0_200_579_15,201_300_579_20,301_400_579_25,401_500_579_30,501_600_579_35,601_700_579_40,701_800_579_45,801_950_579_50\",\"DH\":\"3034035\",\"ZMONEY\":\"0\"}' , '{\"state\":\"1\"}' , '2025-09-05 23:58:04') [ RunTime:0.007556s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 958 LIMIT 1 [ RunTime:0.007173s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008474s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007239s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 2894 LIMIT 1 [ RunTime:0.007188s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('10142123' , 'QY_207' , '{\"Z\":\"207\",\"IDS\":\"10142123\",\"SIDS\":\"BJ000055\",\"IC\":\"3559889075\",\"CZ\":\"4\",\"CS\":\"1\",\"TY\":\"1\",\"MXHao\":\"1\"}' , '{\"Z\":\"207\",\"IDS\":\"10142123\",\"SIDS\":\"BJ000055\",\"CZ\":\"4\",\"IC\":\"3559889075\",\"MONEY\":\"0\",\"MXHao\":\"1\",\"state\":\"1\",\"msg\":\"5\",\"msg2\":\"45\",\"txt\":\"开电成功\"}' , '2025-09-05 23:58:04') [ RunTime:0.007198s ] [ error ] [8]未定义数组索引: msg[D:\www\api\application\charge\model\Api.php:373] --------------------------------------------------------------- [2025-09-05T23:58:13+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:0.834878s] [吞吐率:1.20req/s] [内存消耗:4,384.36kb] [文件加载:107] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-type' => 'application/json', 'host' => 'api.scyeby.com', 'content-length' => '103', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '207', 'IDS' => 'GX4G0123', 'SIDS' => 'E50B89D0', 'IC' => '2708183691', 'CZ' => '4', 'CS' => '1', 'TY' => '1', 'MXHao' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.011212s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008870s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007422s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.008601s ] [ sql ] [ SQL ] SELECT `site_id`,`brand` FROM `tp_charge_equi` WHERE `equi_ids` = 'GX4G0123' LIMIT 1 [ RunTime:0.007412s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008698s ] [ sql ] [ SQL ] SELECT `relation_site_ids` FROM `tp_comm_site` WHERE `id` = 975 LIMIT 1 [ RunTime:0.007430s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.008684s ] [ sql ] [ SQL ] SELECT `start_time`,`id`,`total_elec`,`yet_elec`,total_elec-yet_elec sy_elec,`total_time`,`yet_time`,total_time-yet_time sy_time,`total_num`,`yet_num`,total_num-yet_num sy_num FROM `tp_charge_month` WHERE `site_id` = 975 AND `icard` = '2708183691' AND `start_time` <= '2025-09-05' AND `end_time` > '2025-09-05' [ RunTime:0.008955s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008560s ] [ sql ] [ SQL ] SELECT total_money-yet_money sy_money,`icard`,`member_id`,`state`,`park_end` FROM `tp_comm_icard` WHERE `site_id` = 975 AND `icard` = '2708183691' ORDER BY `id` ASC [ RunTime:0.008118s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008509s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 975 [ RunTime:0.007464s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008727s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`sids`,`socket_num` FROM `tp_charge_orders` WHERE `icard` = '2708183691' AND `site_id` = 975 AND `state` = 1 [ RunTime:0.011997s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.008552s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 975 LIMIT 1 [ RunTime:0.007736s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 975 [ RunTime:0.007515s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008705s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 36955 LIMIT 1 [ RunTime:0.007654s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = 'GX4G0123' AND `state` = 1 AND `sids` = 'E50B89D0' AND `socket_num` = 4 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.009034s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 975 LIMIT 1 [ RunTime:0.007395s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.009566s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007450s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008628s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007405s ] [ sql ] [ SQL ] INSERT INTO `tp_charge_orders` (`agent_id` , `site_id` , `order_sn` , `icard` , `state` , `member_id` , `member_mobile` , `equi_ids` , `socket_num` , `socket_no` , `sids` , `pay_money` , `ctime` , `valid_time` , `price_info` , `brand` , `value` , `other` , `system`) VALUES (438 , 975 , '20250905235812283946' , '2708183691' , 0 , 36955 , '15208117976' , 'GX4G0123' , 4 , 0 , 'E50B89D0' , 10 , '2025-09-05 23:58:12' , 1757123892 , '{\"charge_type\":\"8\",\"start_power\":[\"0\",\"201\",\"301\",\"401\",\"501\",\"601\",\"701\",\"801\"],\"end_power\":[\"200\",\"300\",\"400\",\"500\",\"600\",\"700\",\"800\",\"950\"],\"price\":[\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\"],\"time\":[\"0.15\",\"0.2\",\"0.25\",\"0.3\",\"0.35\",\"0.4\",\"0.45\",\"0.5\"]}' , 'qy' , 10 , '{\"month_id\":86324}' , 'main') [ RunTime:0.007785s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3034036 LIMIT 1 [ RunTime:0.007523s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `state` = 1 , `payment_code` = 'month' , `trade_no` = 'HD2025090523581217570878926950' WHERE `id` = 3034036 [ RunTime:0.007819s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008908s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('GX4G0123' , 'QY_101' , '{\"Z\":\"101\",\"IDS\":\"GX4G0123\",\"SIDS\":\"E50B89D0\",\"CZ\":\"4\",\"MODEL\":\"8\",\"TIM\":\"600\",\"DL\":\"1000\",\"MONEY\":\"1000\",\"LIST\":\"0_200_579_15,201_300_579_20,301_400_579_25,401_500_579_30,501_600_579_35,601_700_579_40,701_800_579_45,801_950_579_50\",\"DH\":\"3034036\",\"ZMONEY\":\"0\"}' , '{\"state\":\"1\"}' , '2025-09-05 23:58:12') [ RunTime:0.008025s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 975 LIMIT 1 [ RunTime:0.007380s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008673s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007424s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 36955 LIMIT 1 [ RunTime:0.007388s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008946s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5TSqUH9WTCjmcDxyIAunJiQ' , '开始充电' , '{\"touser\":\"oCmeh5TSqUH9WTCjmcDxyIAunJiQ\",\"template_id\":\"Agy1VhMUNj0Ts8jwvjW_UqGEDJOg0Y0-39j6y8nhpRg\",\"data\":{\"thing2\":{\"value\":\"缤纷\"},\"character_string8\":{\"value\":\"GX4G0123(E50B89D0)\"},\"character_string9\":{\"value\":\"No.4\"},\"character_string6\":{\"value\":3034036},\"time3\":{\"value\":\"2025-09-05 23:58:12\"}},\"page\":\"\\/pages\\/orders\\/chargeing?order_id=3034036\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68bb0894-34d98ef5-50b73865\"}' , '2025-09-05 23:58:13') [ RunTime:0.007715s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('GX4G0123' , 'QY_207' , '{\"Z\":\"207\",\"IDS\":\"GX4G0123\",\"SIDS\":\"E50B89D0\",\"IC\":\"2708183691\",\"CZ\":\"4\",\"CS\":\"1\",\"TY\":\"1\",\"MXHao\":\"1\"}' , '{\"Z\":\"207\",\"IDS\":\"GX4G0123\",\"SIDS\":\"E50B89D0\",\"CZ\":\"4\",\"IC\":\"2708183691\",\"MONEY\":\"0\",\"MXHao\":\"1\",\"state\":\"1\",\"msg\":\"5\",\"msg2\":\"45\",\"txt\":\"开电成功\"}' , '2025-09-05 23:58:13') [ RunTime:0.007416s ] [ error ] [8]未定义数组索引: msg[D:\www\api\application\charge\model\Api.php:373] --------------------------------------------------------------- [2025-09-05T23:58:18+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:0.765232s] [吞吐率:1.31req/s] [内存消耗:4,240.91kb] [文件加载:104] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-type' => 'application/json', 'host' => 'api.scyeby.com', 'content-length' => '198', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => 'YE4G0313', 'SIDS' => 'BJ000323', 'CZ' => '5', 'DH' => '3033420', 'POW' => '255', 'DL' => '0.8344', 'TIM' => '212', 'MSG' => '8', 'POWs' => '3033420', 'MONEY' => '128', 'MSG2' => '检测到插座无充电器结束订单', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.017326s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008606s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006952s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008881s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3033420 LIMIT 1 [ RunTime:0.007070s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008568s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 983 [ RunTime:0.006984s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.009210s ] [ sql ] [ SQL ] SELECT `id`,`total_money`,`yet_money` FROM `tp_comm_icard` WHERE `site_id` = 983 AND `icard` = '1134496972' LIMIT 1 [ RunTime:0.007572s ] [ sql ] [ SQL ] UPDATE `tp_comm_icard` SET `yet_money` = 772.94 , `uptime` = 1757087898 WHERE `id` = 15408 [ RunTime:0.007213s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008077s ] [ sql ] [ SQL ] SELECT 983,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 983 [ RunTime:0.006883s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.008214s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 983 [ RunTime:0.007975s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008002s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007014s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008473s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006884s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008919s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006921s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008415s ] [ sql ] [ SQL ] INSERT INTO `tp_comm_consume` (`port` , `state` , `agent_id` , `order_sn` , `icard` , `site_id` , `member_id` , `pay_id` , `order_money` , `pay_money` , `src_by` , `ctime` , `rate` , `directions` , `month` , `day` , `remark` , `details` , `payment_code` , `trade_no` , `system`) VALUES (1 , 9 , 438 , 'Y20250905235818217632' , '1134496972' , 983 , 27294 , 27294 , '1.33' , '1.33' , 'charge_temp' , '2025-09-05 20:25:36' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '刷卡充电' , '2025-09' , '2025-09-05' , NULL , '{\"sql\":\"UPDATE `tp_comm_icard` SET `yet_money` = 772.94 , `uptime` = 1757087898 WHERE `id` = 15408\",\"icard\":{\"id\":15408,\"total_money\":\"800.00\",\"yet_money\":\"771.61\"}}' , 'icardyue' , 'HD2025090520253617570751364463' , 'main') [ RunTime:0.011661s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025090520253617570751364463' , `order_money` = '1.33' , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 212 , `elec_num` = 0.91784 , `power_num` = 255 , `finish` = 8 , `state` = 9 , `other` = '{\"finish_text\":\"检测到插座无充电器结束订单\",\"POWs\":\"3033420\",\"sj_elec\":\"0.8344\"}' , `finish_time` = '2025-09-05 23:58:18' , `js_result` = '{\"money\":\"1.33\",\"elec_num\":0.91784,\"elec_price\":\"0.579\",\"timeNum\":4,\"server_price\":\"0.2\"}' WHERE `id` = 3033420 [ RunTime:0.007305s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 983 LIMIT 1 [ RunTime:0.006918s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006986s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008081s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 27294 LIMIT 1 [ RunTime:0.007168s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008530s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5R0BD2PC2_qTGH1VWEeXtf4' , '结束充电' , '{\"touser\":\"oCmeh5R0BD2PC2_qTGH1VWEeXtf4\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"眉山柏林谷\"},\"time4\":{\"value\":\"2025-09-05 20:25:36\"},\"time3\":{\"value\":\"2025-09-05 23:58:18\"},\"thing5\":{\"value\":\"您的订单【3033420】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=3033420\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68bb089a-408c8b55-1f8b4fd6\"}' , '2025-09-05 23:58:18') [ RunTime:0.007074s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008107s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0313' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YE4G0313\",\"SIDS\":\"BJ000323\",\"CZ\":\"5\",\"DH\":\"3033420\",\"POW\":\"255\",\"DL\":\"0.8344\",\"TIM\":\"212\",\"MSG\":\"8\",\"POWs\":\"3033420\",\"MONEY\":\"128\",\"MSG2\":\"检测到插座无充电器结束订单\"}' , '{\"Z\":\"206\",\"IDS\":\"YE4G0313\",\"SIDS\":\"BJ000323\",\"CZ\":\"5\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-09-05 23:58:18') [ RunTime:0.007406s ] [ error ] [8]未定义数组索引: remark[D:\www\api\application\comm\model\Consume.php:449] --------------------------------------------------------------- [2025-09-05T23:58:35+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:0.195016s] [吞吐率:5.13req/s] [内存消耗:4,178.88kb] [文件加载:101] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-type' => 'application/json', 'host' => 'api.scyeby.com', 'content-length' => '103', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '207', 'IDS' => 'GX4G0097', 'SIDS' => 'B00A7638', 'IC' => '2708183691', 'CZ' => '3', 'CS' => '1', 'TY' => '1', 'MXHao' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010339s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008701s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.008783s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.008174s ] [ sql ] [ SQL ] SELECT `site_id`,`brand` FROM `tp_charge_equi` WHERE `equi_ids` = 'GX4G0097' LIMIT 1 [ RunTime:0.006983s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008209s ] [ sql ] [ SQL ] SELECT `relation_site_ids` FROM `tp_comm_site` WHERE `id` = 975 LIMIT 1 [ RunTime:0.006961s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.008452s ] [ sql ] [ SQL ] SELECT `start_time`,`id`,`total_elec`,`yet_elec`,total_elec-yet_elec sy_elec,`total_time`,`yet_time`,total_time-yet_time sy_time,`total_num`,`yet_num`,total_num-yet_num sy_num FROM `tp_charge_month` WHERE `site_id` = 975 AND `icard` = '2708183691' AND `start_time` <= '2025-09-05' AND `end_time` > '2025-09-05' [ RunTime:0.007046s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008089s ] [ sql ] [ SQL ] SELECT total_money-yet_money sy_money,`icard`,`member_id`,`state`,`park_end` FROM `tp_comm_icard` WHERE `site_id` = 975 AND `icard` = '2708183691' ORDER BY `id` ASC [ RunTime:0.006943s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008094s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 975 [ RunTime:0.006952s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008171s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`sids`,`socket_num` FROM `tp_charge_orders` WHERE `icard` = '2708183691' AND `site_id` = 975 AND `state` = 1 [ RunTime:0.007358s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.007985s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('GX4G0097' , 'QY_207' , '{\"Z\":\"207\",\"IDS\":\"GX4G0097\",\"SIDS\":\"B00A7638\",\"IC\":\"2708183691\",\"CZ\":\"3\",\"CS\":\"1\",\"TY\":\"1\",\"MXHao\":\"1\"}' , '{\"Z\":\"207\",\"IDS\":\"GX4G0097\",\"SIDS\":\"B00A7638\",\"CZ\":\"3\",\"IC\":\"2708183691\",\"MONEY\":\"0\",\"MXHao\":\"1\",\"state\":\"0\",\"msg\":\"6\",\"msg2\":\"103\",\"txt\":\"一张卡只允许充【1】台车,已充【1】台\"}' , '2025-09-05 23:58:35') [ RunTime:0.007200s ] [ error ] [8]未定义数组索引: sy_money[D:\www\api\application\index\controller\Receive.php:128] --------------------------------------------------------------- [2025-09-05T23:58:40+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:0.728880s] [吞吐率:1.37req/s] [内存消耗:4,128.30kb] [文件加载:98] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-type' => 'application/json', 'host' => 'api.scyeby.com', 'content-length' => '177', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => 'S3003797', 'SIDS' => 'BJ000063', 'CZ' => '9', 'DH' => '3032716', 'POW' => '101', 'DL' => '0.4659', 'TIM' => '348', 'MSG' => '8', 'POWs' => '3032716', 'MONEY' => '116', 'MSG2' => '本次费用用完', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010260s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008205s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006880s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008184s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3032716 LIMIT 1 [ RunTime:0.007135s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.007939s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 958 [ RunTime:0.006969s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008232s ] [ sql ] [ SQL ] SELECT `rate` FROM `tp_comm_consume` WHERE `trade_no` = '4200002790202509051819859892' LIMIT 1 [ RunTime:0.007868s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008103s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 958 LIMIT 1 [ RunTime:0.006835s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008008s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006916s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008019s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007163s ] [ sql ] [ SQL ] SELECT `nickname`,`mobile` FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006863s ] [ sql ] [ SQL ] SELECT `total_money` FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006826s ] [ sql ] [ SQL ] UPDATE `tp_comm_user` SET `total_money` = `total_money` + 1 WHERE `user_id` = 438 [ RunTime:0.007180s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_packet` [ RunTime:0.008102s ] [ sql ] [ SQL ] INSERT INTO `tp_comm_packet` (`site_id` , `user_id` , `type` , `money` , `state` , `src_by` , `ctime` , `uptime` , `details` , `trade_no` , `name` , `mobile` , `rule` , `month` , `day` , `system`) VALUES ( 958,438,1,'1.00',9,'charge_temp','2025-09-05 18:09:15','2025-09-05 23:58:39','{\"order_money\":\"1.00\",\"old_money\":4403677.5}','4200002790202509051819859892','元贰佰壹科技有限公司','18980369999','100%','2025-09','2025-09-05','main' ) [ RunTime:0.010915s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = '4200002790202509051819859892' , `order_money` = '1.00' , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 348 , `elec_num` = 0.51249 , `power_num` = 101 , `finish` = 8 , `state` = 9 , `other` = '{\"finish_text\":\"本次费用用完\",\"POWs\":\"3032716\",\"sj_elec\":\"0.4659\"}' , `finish_time` = '2025-09-05 23:58:39' , `js_result` = '{\"money\":\"1.20\",\"elec_num\":0.51249,\"elec_price\":\"0.579\",\"timeNum\":6,\"server_price\":\"0.15\"}' WHERE `id` = 3032716 [ RunTime:0.006910s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 958 LIMIT 1 [ RunTime:0.006838s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008673s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006926s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008074s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 1843 LIMIT 1 [ RunTime:0.007592s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008669s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5bcXpioPRy7xH1sic1dBoXs' , '结束充电' , '{\"touser\":\"oCmeh5bcXpioPRy7xH1sic1dBoXs\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"蓝水湾\"},\"time4\":{\"value\":\"2025-09-05 18:09:15\"},\"time3\":{\"value\":\"2025-09-05 23:58:39\"},\"thing5\":{\"value\":\"您的订单【3032716】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=3032716\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68bb08af-6163700f-13973e34\"}' , '2025-09-05 23:58:40') [ RunTime:0.007172s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008161s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('S3003797' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"S3003797\",\"SIDS\":\"BJ000063\",\"CZ\":\"9\",\"DH\":\"3032716\",\"POW\":\"101\",\"DL\":\"0.4659\",\"TIM\":\"348\",\"MSG\":\"8\",\"POWs\":\"3032716\",\"MONEY\":\"116\",\"MSG2\":\"本次费用用完\"}' , '{\"Z\":\"206\",\"IDS\":\"S3003797\",\"SIDS\":\"BJ000063\",\"CZ\":\"9\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-09-05 23:58:40') [ RunTime:0.007900s ] --------------------------------------------------------------- [2025-09-05T23:58:56+08:00] 117.172.62.160 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.078391s] [吞吐率:12.76req/s] [内存消耗:3,543.73kb] [文件加载:89] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '53', 'x-token' => 'oCmeh5co9r3d3hsL59E8dNyC9frQ', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.62(0x18003e39) NetType/WIFI Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/system/getSystem', 'host' => 'main', 'pageSize' => '15', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010398s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008377s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008303s ] [ sql ] [ SQL ] SELECT `site_name`,`site_logo`,`upload_config`,`regcms` FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006946s ] --------------------------------------------------------------- [2025-09-05T23:58:57+08:00] 117.172.62.160 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.106952s] [吞吐率:9.35req/s] [内存消耗:3,860.49kb] [文件加载:92] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '69', 'x-token' => 'oCmeh5co9r3d3hsL59E8dNyC9frQ', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.62(0x18003e39) NetType/WIFI Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/park/getLists', 'host' => 'main', 'pageSize' => '15', 'page_num' => '1', 'state' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009825s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008432s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006574s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.007892s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5co9r3d3hsL59E8dNyC9frQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006553s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5co9r3d3hsL59E8dNyC9frQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.008234s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_park_orders` [ RunTime:0.009832s ] [ sql ] [ SQL ] SELECT `id`,`state`,`site_id`,`ctime`,`total_money`,`pay_money`,`finish`,`finish_time`,`member_mobile`,`payment_code` FROM `tp_park_orders` WHERE `member_id` = 48442 AND `state` IN (1,8) ORDER BY `state` ASC,`id` DESC LIMIT 30 [ RunTime:0.008317s ] --------------------------------------------------------------- [2025-09-05T23:58:57+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qypark.html [运行时间:0.142231s] [吞吐率:7.03req/s] [内存消耗:3,774.40kb] [文件加载:92] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-type' => 'application/json', 'host' => 'api.scyeby.com', 'content-length' => '80', 'expect' => '100-continue', 'connection' => 'Keep-Alive', ) [ info ] [ PARAM ] array ( 'Z' => '4302', 'IDS' => 'YEWK0020', 'com' => 'IC卡未注册', 'msg' => '1238658542', 'CH' => '3', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.019077s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008948s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007518s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_park_equi` [ RunTime:0.009383s ] [ sql ] [ SQL ] SELECT `site_id` FROM `tp_park_equi` WHERE `equi_ids` = 'YEWK0020' LIMIT 1 [ RunTime:0.008372s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.009344s ] [ sql ] [ SQL ] SELECT `id`,`park_end` FROM `tp_comm_icard` WHERE `icard` = '1238658542' AND `site_id` = 962 LIMIT 1 [ RunTime:0.007634s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_park` [ RunTime:0.009738s ] [ sql ] [ SQL ] INSERT INTO `tp_log_park` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEWK0020' , '4302' , '{\"Z\":\"4302\",\"IDS\":\"YEWK0020\",\"com\":\"IC卡未注册\",\"msg\":\"1238658542\",\"CH\":\"3\"}' , '{\"state\":\"ok\",\"code\":null}' , '2025-09-05 23:58:57') [ RunTime:0.007749s ] [ error ] [8]未定义变量: rst[D:\www\api\application\index\controller\Receive.php:304] --------------------------------------------------------------- [2025-09-05T23:58:58+08:00] 117.172.62.160 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.159647s] [吞吐率:6.26req/s] [内存消耗:4,061.27kb] [文件加载:96] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '71', 'x-token' => 'oCmeh5co9r3d3hsL59E8dNyC9frQ', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.62(0x18003e39) NetType/WIFI Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/getLists', 'host' => 'main', 'pageSize' => '15', 'page_num' => '1', 'state' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.011111s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008910s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007429s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008755s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5co9r3d3hsL59E8dNyC9frQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007371s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5co9r3d3hsL59E8dNyC9frQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007341s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008835s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `member_id` = 48442 AND `state` = 1 AND `del` = 1 ORDER BY `state` ASC,`id` DESC LIMIT 30 [ RunTime:0.014448s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008592s ] [ sql ] [ SQL ] SELECT 955,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.007384s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `time_num` = 222 , `elec_num` = '1.239' , `power_num` = 356 WHERE `id` = 3033373 [ RunTime:0.008169s ] --------------------------------------------------------------- [2025-09-05T23:58:59+08:00] 117.172.62.160 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.161895s] [吞吐率:6.18req/s] [内存消耗:4,045.63kb] [文件加载:95] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '68', 'x-token' => 'oCmeh5co9r3d3hsL59E8dNyC9frQ', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.62(0x18003e39) NetType/WIFI Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/getInfo', 'host' => 'main', 'pageSize' => '15', 'order_id' => '3033373', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.011148s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008865s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007358s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008664s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5co9r3d3hsL59E8dNyC9frQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007326s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5co9r3d3hsL59E8dNyC9frQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007363s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008884s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3033373 LIMIT 1 [ RunTime:0.007460s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `time_num` = 222 , `elec_num` = '1.239' , `power_num` = 356 WHERE `id` = 3033373 [ RunTime:0.007647s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.009245s ] [ sql ] [ SQL ] SELECT 955,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.007333s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008674s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 955 LIMIT 1 [ RunTime:0.007392s ] --------------------------------------------------------------- [2025-09-05T23:59:01+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:0.288071s] [吞吐率:3.47req/s] [内存消耗:4,190.16kb] [文件加载:103] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-type' => 'application/json', 'host' => 'api.scyeby.com', 'content-length' => '171', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => '50087140', 'SIDS' => '04085BEB', 'CZ' => '1', 'DH' => '3033334', 'POW' => '370', 'DL' => '0.7858', 'TIM' => '234', 'MSG' => '8', 'POWs' => '3033334', 'MONEY' => '145', 'MSG2' => '充满停止', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009689s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008224s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006454s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008655s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3033334 LIMIT 1 [ RunTime:0.007316s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.007607s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 983 [ RunTime:0.007400s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.007666s ] [ sql ] [ SQL ] SELECT `id`,`total_money`,`yet_money` FROM `tp_comm_icard` WHERE `site_id` = 983 AND `icard` = '3475288786' LIMIT 1 [ RunTime:0.007886s ] [ sql ] [ SQL ] UPDATE `tp_comm_icard` SET `yet_money` = 426.44 , `uptime` = 1757087940 WHERE `id` = 8024 [ RunTime:0.006807s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007835s ] [ sql ] [ SQL ] SELECT 983,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 983 [ RunTime:0.006369s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.007802s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 983 [ RunTime:0.006751s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008252s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006424s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.007537s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006403s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.007774s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006471s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.007722s ] [ sql ] [ SQL ] INSERT INTO `tp_comm_consume` (`port` , `state` , `agent_id` , `order_sn` , `icard` , `site_id` , `member_id` , `pay_id` , `order_money` , `pay_money` , `src_by` , `ctime` , `rate` , `directions` , `month` , `day` , `remark` , `details` , `payment_code` , `trade_no` , `system`) VALUES (1 , 9 , 438 , 'Y20250905235900879931' , '3475288786' , 983 , 6700 , 6700 , '1.50' , '1.50' , 'charge_temp' , '2025-09-05 20:03:52' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '刷卡充电' , '2025-09' , '2025-09-05' , NULL , '{\"sql\":\"UPDATE `tp_comm_icard` SET `yet_money` = 426.44 , `uptime` = 1757087940 WHERE `id` = 8024\",\"icard\":{\"id\":8024,\"total_money\":\"494.00\",\"yet_money\":\"424.94\"}}' , 'icardyue' , 'HD2025090520035217570738326531' , 'main') [ RunTime:0.007129s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025090520035217570738326531' , `order_money` = '1.50' , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 234 , `elec_num` = 0.86438 , `power_num` = 370 , `finish` = 8 , `state` = 9 , `other` = '{\"finish_text\":\"充满停止\",\"POWs\":\"3033334\",\"sj_elec\":\"0.7858\"}' , `finish_time` = '2025-09-05 23:59:00' , `js_result` = '{\"money\":\"1.50\",\"elec_num\":0.86438,\"elec_price\":\"0.579\",\"timeNum\":4,\"server_price\":\"0.25\"}' WHERE `id` = 3033334 [ RunTime:0.006566s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 983 LIMIT 1 [ RunTime:0.006373s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006458s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008048s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 6700 LIMIT 1 [ RunTime:0.007000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.007756s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('50087140' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"50087140\",\"SIDS\":\"04085BEB\",\"CZ\":\"1\",\"DH\":\"3033334\",\"POW\":\"370\",\"DL\":\"0.7858\",\"TIM\":\"234\",\"MSG\":\"8\",\"POWs\":\"3033334\",\"MONEY\":\"145\",\"MSG2\":\"充满停止\"}' , '{\"Z\":\"206\",\"IDS\":\"50087140\",\"SIDS\":\"04085BEB\",\"CZ\":\"1\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-09-05 23:59:00') [ RunTime:0.006398s ] [ error ] [8]未定义数组索引: remark[D:\www\api\application\comm\model\Consume.php:449] --------------------------------------------------------------- [2025-09-05T23:59:01+08:00] 121.4.104.160 POST api.scyeby.com/public/index.php/index/Wxservice/index.html?signature=d21382c7230ee95bc0f9215ab8146c5a131077f7×tamp=1757087940&nonce=89313128&openid=oCmeh5co9r3d3hsL59E8dNyC9frQ [运行时间:0.062344s] [吞吐率:16.04req/s] [内存消耗:3,503.61kb] [文件加载:86] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'user-agent' => 'Mozilla/4.0', 'accept' => '*/*', 'host' => 'api.scyeby.com', 'pragma' => 'no-cache', 'content-length' => '688', 'content-type' => 'text/xml', ) [ info ] [ PARAM ] array ( 'signature' => 'd21382c7230ee95bc0f9215ab8146c5a131077f7', 'timestamp' => '1757087940', 'nonce' => '89313128', 'openid' => 'oCmeh5co9r3d3hsL59E8dNyC9frQ', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.011447s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.009254s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007530s ] --------------------------------------------------------------- [2025-09-05T23:59:02+08:00] 117.172.62.160 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.137750s] [吞吐率:7.26req/s] [内存消耗:3,983.93kb] [文件加载:94] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '66', 'x-token' => 'oCmeh5co9r3d3hsL59E8dNyC9frQ', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.62(0x18003e39) NetType/WIFI Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/close', 'host' => 'main', 'pageSize' => '15', 'order_id' => '3033373', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010540s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008605s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007049s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008177s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5co9r3d3hsL59E8dNyC9frQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007030s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5co9r3d3hsL59E8dNyC9frQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006950s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008329s ] [ sql ] [ SQL ] SELECT `id`,`state`,`equi_ids`,`sids`,`socket_num`,`socket_no`,`brand` FROM `tp_charge_orders` WHERE `id` = 3033373 LIMIT 1 [ RunTime:0.007035s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008231s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0307' , 'QY_102' , '{\"Z\":\"102\",\"IDS\":\"YE4G0307\",\"SIDS\":\"BJ000318\",\"CZ\":\"5\",\"DH\":\"3033373\"}' , '{\"state\":\"1\",\"msg\":\"结束操作开始\"}' , '2025-09-05 23:59:02') [ RunTime:0.008259s ] --------------------------------------------------------------- [2025-09-05T23:59:03+08:00] 117.172.62.160 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.095100s] [吞吐率:10.52req/s] [内存消耗:3,839.22kb] [文件加载:90] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '74', 'x-token' => 'oCmeh5co9r3d3hsL59E8dNyC9frQ', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.62(0x18003e39) NetType/WIFI Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/getOrderState', 'host' => 'main', 'pageSize' => '15', 'order_id' => '3033373', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009707s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007736s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006399s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.007625s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5co9r3d3hsL59E8dNyC9frQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006362s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5co9r3d3hsL59E8dNyC9frQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006347s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008055s ] [ sql ] [ SQL ] SELECT `state` FROM `tp_charge_orders` WHERE `id` = 3033373 LIMIT 1 [ RunTime:0.006344s ] --------------------------------------------------------------- [2025-09-05T23:59:04+08:00] 117.172.62.160 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.106423s] [吞吐率:9.40req/s] [内存消耗:3,839.22kb] [文件加载:90] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '74', 'x-token' => 'oCmeh5co9r3d3hsL59E8dNyC9frQ', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.62(0x18003e39) NetType/WIFI Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/getOrderState', 'host' => 'main', 'pageSize' => '15', 'order_id' => '3033373', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010520s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008760s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007084s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008220s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5co9r3d3hsL59E8dNyC9frQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006999s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5co9r3d3hsL59E8dNyC9frQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007054s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008550s ] [ sql ] [ SQL ] SELECT `state` FROM `tp_charge_orders` WHERE `id` = 3033373 LIMIT 1 [ RunTime:0.006978s ] --------------------------------------------------------------- [2025-09-05T23:59:04+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:0.745707s] [吞吐率:1.34req/s] [内存消耗:4,240.91kb] [文件加载:104] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-type' => 'application/json', 'host' => 'api.scyeby.com', 'content-length' => '177', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => 'YE4G0307', 'SIDS' => 'BJ000318', 'CZ' => '5', 'DH' => '3033373', 'POW' => '317', 'DL' => '1.2444', 'TIM' => '223', 'MSG' => '8', 'POWs' => '3033373', 'MONEY' => '192', 'MSG2' => '手机操作结束', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010588s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008658s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007004s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008781s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3033373 LIMIT 1 [ RunTime:0.007127s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008258s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 955 [ RunTime:0.007127s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008435s ] [ sql ] [ SQL ] SELECT `id`,`total_money`,`yet_money` FROM `tp_comm_icard` WHERE `site_id` = 955 AND `icard` = '3475741746' LIMIT 1 [ RunTime:0.007693s ] [ sql ] [ SQL ] UPDATE `tp_comm_icard` SET `yet_money` = 32.55 , `uptime` = 1757087944 WHERE `id` = 22446 [ RunTime:0.007377s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008523s ] [ sql ] [ SQL ] SELECT 955,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.007071s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.008648s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 955 [ RunTime:0.007106s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008300s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.010511s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008353s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007044s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008436s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.008081s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008586s ] [ sql ] [ SQL ] INSERT INTO `tp_comm_consume` (`port` , `state` , `agent_id` , `order_sn` , `icard` , `site_id` , `member_id` , `pay_id` , `order_money` , `pay_money` , `src_by` , `ctime` , `rate` , `directions` , `month` , `day` , `remark` , `details` , `payment_code` , `trade_no` , `system`) VALUES (1 , 9 , 438 , 'Y20250905235904472715' , '3475741746' , 955 , 48442 , 48442 , '1.99' , '1.99' , 'charge_temp' , '2025-09-05 20:15:17' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '刷卡充电' , '2025-09' , '2025-09-05' , NULL , '{\"sql\":\"UPDATE `tp_comm_icard` SET `yet_money` = 32.55 , `uptime` = 1757087944 WHERE `id` = 22446\",\"icard\":{\"id\":22446,\"total_money\":\"100.00\",\"yet_money\":\"30.56\"}}' , 'icardyue' , 'HD2025090520151717570745175656' , 'main') [ RunTime:0.007456s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025090520151717570745175656' , `order_money` = '1.99' , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 223 , `elec_num` = 1.36884 , `power_num` = 317 , `finish` = 8 , `state` = 9 , `other` = '{\"finish_text\":\"手机操作结束\",\"POWs\":\"3033373\",\"sj_elec\":\"1.2444\"}' , `finish_time` = '2025-09-05 23:59:04' , `js_result` = '{\"money\":\"1.99\",\"elec_num\":1.36884,\"elec_price\":\"0.579\",\"timeNum\":4,\"server_price\":\"0.3\"}' WHERE `id` = 3033373 [ RunTime:0.007177s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 955 LIMIT 1 [ RunTime:0.007500s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007084s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008374s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 48442 LIMIT 1 [ RunTime:0.007321s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008609s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5co9r3d3hsL59E8dNyC9frQ' , '结束充电' , '{\"touser\":\"oCmeh5co9r3d3hsL59E8dNyC9frQ\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"浅水半岛二期二号车库\"},\"time4\":{\"value\":\"2025-09-05 20:15:17\"},\"time3\":{\"value\":\"2025-09-05 23:59:04\"},\"thing5\":{\"value\":\"您的订单【3033373】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=3033373\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68bb08c8-602aa274-6ebc6d36\"}' , '2025-09-05 23:59:04') [ RunTime:0.007361s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008314s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0307' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YE4G0307\",\"SIDS\":\"BJ000318\",\"CZ\":\"5\",\"DH\":\"3033373\",\"POW\":\"317\",\"DL\":\"1.2444\",\"TIM\":\"223\",\"MSG\":\"8\",\"POWs\":\"3033373\",\"MONEY\":\"192\",\"MSG2\":\"手机操作结束\"}' , '{\"Z\":\"206\",\"IDS\":\"YE4G0307\",\"SIDS\":\"BJ000318\",\"CZ\":\"5\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-09-05 23:59:04') [ RunTime:0.007406s ] [ error ] [8]未定义数组索引: remark[D:\www\api\application\comm\model\Consume.php:449] --------------------------------------------------------------- [2025-09-05T23:59:10+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:0.679252s] [吞吐率:1.47req/s] [内存消耗:3,957.09kb] [文件加载:94] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-type' => 'application/json', 'host' => 'api.scyeby.com', 'content-length' => '198', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => '50053522', 'SIDS' => 'BJ000173', 'CZ' => '7', 'DH' => '3033638', 'POW' => '282', 'DL' => '0.4033', 'TIM' => '164', 'MSG' => '8', 'POWs' => '3033638', 'MONEY' => '83', 'MSG2' => '5分钟时间无功率自动关闭充电', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010604s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008539s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007253s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008973s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3033638 LIMIT 1 [ RunTime:0.008072s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.008477s ] [ sql ] [ SQL ] SELECT `total_elec`,`yet_elec`,`total_time`,`yet_time`,`total_num`,`yet_num` FROM `tp_charge_month` WHERE `id` = 87569 LIMIT 1 [ RunTime:0.008060s ] [ sql ] [ SQL ] UPDATE `tp_charge_month` SET `yet_time` = 37.9 WHERE `id` = 87569 [ RunTime:0.007313s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025090521135617570780369874' , `order_money` = 0 , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 164 , `elec_num` = 0.44363 , `power_num` = 282 , `finish` = 8 , `state` = 9 , `other` = '{\"month_id\":87569,\"finish_text\":\"5分钟时间无功率自动关闭充电\",\"POWs\":\"3033638\",\"sj_elec\":\"0.4033\"}' , `finish_time` = '2025-09-05 23:59:10' , `js_result` = '[]' WHERE `id` = 3033638 [ RunTime:0.008808s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.009546s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 959 LIMIT 1 [ RunTime:0.007732s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.009042s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007165s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008896s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 22516 LIMIT 1 [ RunTime:0.008174s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.009031s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5VEmxTKslcfXxvz5T3hcR9g' , '结束充电' , '{\"touser\":\"oCmeh5VEmxTKslcfXxvz5T3hcR9g\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"平安苑\"},\"time4\":{\"value\":\"2025-09-05 21:13:56\"},\"time3\":{\"value\":\"2025-09-05 23:59:10\"},\"thing5\":{\"value\":\"您的订单【3033638】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=3033638\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68bb08ce-3863095b-3c7589d0\"}' , '2025-09-05 23:59:10') [ RunTime:0.008809s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008634s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('50053522' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"50053522\",\"SIDS\":\"BJ000173\",\"CZ\":\"7\",\"DH\":\"3033638\",\"POW\":\"282\",\"DL\":\"0.4033\",\"TIM\":\"164\",\"MSG\":\"8\",\"POWs\":\"3033638\",\"MONEY\":\"83\",\"MSG2\":\"5分钟时间无功率自动关闭充电\"}' , '{\"Z\":\"206\",\"IDS\":\"50053522\",\"SIDS\":\"BJ000173\",\"CZ\":\"7\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-09-05 23:59:10') [ RunTime:0.007277s ] --------------------------------------------------------------- [2025-09-05T23:59:16+08:00] 117.172.62.160 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.161647s] [吞吐率:6.19req/s] [内存消耗:3,889.16kb] [文件加载:92] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '68', 'x-token' => 'oCmeh5co9r3d3hsL59E8dNyC9frQ', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.62(0x18003e39) NetType/WIFI Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/getInfo', 'host' => 'main', 'pageSize' => '15', 'order_id' => '3033373', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.018669s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.009021s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007477s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008963s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5co9r3d3hsL59E8dNyC9frQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007477s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5co9r3d3hsL59E8dNyC9frQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007465s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008963s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3033373 LIMIT 1 [ RunTime:0.008490s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008982s ] [ sql ] [ SQL ] SELECT 955,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.010006s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008967s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 955 LIMIT 1 [ RunTime:0.010697s ] --------------------------------------------------------------- [2025-09-05T23:59:19+08:00] 124.223.188.110 POST api.scyeby.com/public/index.php/index/Wxservice/index.html?signature=f232d1b43afb43b95d0fa0d601b379bfc6b51cb2×tamp=1757087959&nonce=200401077&openid=oCmeh5co9r3d3hsL59E8dNyC9frQ [运行时间:0.077078s] [吞吐率:12.97req/s] [内存消耗:3,503.61kb] [文件加载:86] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'user-agent' => 'Mozilla/4.0', 'accept' => '*/*', 'host' => 'api.scyeby.com', 'pragma' => 'no-cache', 'content-length' => '688', 'content-type' => 'text/xml', ) [ info ] [ PARAM ] array ( 'signature' => 'f232d1b43afb43b95d0fa0d601b379bfc6b51cb2', 'timestamp' => '1757087959', 'nonce' => '200401077', 'openid' => 'oCmeh5co9r3d3hsL59E8dNyC9frQ', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.017988s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008602s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007130s ] --------------------------------------------------------------- [2025-09-05T23:59:20+08:00] 117.172.62.160 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.111318s] [吞吐率:8.98req/s] [内存消耗:3,840.41kb] [文件加载:90] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '66', 'x-token' => 'oCmeh5co9r3d3hsL59E8dNyC9frQ', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.62(0x18003e39) NetType/WIFI Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/close', 'host' => 'main', 'pageSize' => '15', 'order_id' => '3033373', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010838s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008962s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007258s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008554s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5co9r3d3hsL59E8dNyC9frQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007258s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5co9r3d3hsL59E8dNyC9frQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007232s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.009068s ] [ sql ] [ SQL ] SELECT `id`,`state`,`equi_ids`,`sids`,`socket_num`,`socket_no`,`brand` FROM `tp_charge_orders` WHERE `id` = 3033373 LIMIT 1 [ RunTime:0.007513s ] --------------------------------------------------------------- [2025-09-05T23:59:21+08:00] 117.172.62.160 POST api.scyeby.com/public/index.php/index/member/index [运行时间:15.019436s] [吞吐率:0.07req/s] [内存消耗:3,956.89kb] [文件加载:93] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '70', 'x-token' => 'oCmeh5co9r3d3hsL59E8dNyC9frQ', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.62(0x18003e39) NetType/WIFI Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/getLists', 'host' => 'main', 'pageSize' => '15', 'page_num' => '1', 'state' => '', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010585s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008454s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007064s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008134s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5co9r3d3hsL59E8dNyC9frQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007041s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5co9r3d3hsL59E8dNyC9frQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006989s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008233s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `member_id` = 48442 AND `state` IN (1,9) AND `del` = 1 ORDER BY `state` ASC,`id` DESC LIMIT 15 [ RunTime:14.806421s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008568s ] [ sql ] [ SQL ] SELECT 955,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.007638s ] [ sql ] [ SQL ] SELECT 955,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.006971s ] [ sql ] [ SQL ] SELECT 955,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.007019s ] [ sql ] [ SQL ] SELECT 955,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.007028s ] [ sql ] [ SQL ] SELECT 955,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.007025s ] [ sql ] [ SQL ] SELECT 955,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.007001s ] [ sql ] [ SQL ] SELECT 955,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.007011s ] [ sql ] [ SQL ] SELECT 955,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.006994s ] [ sql ] [ SQL ] SELECT 955,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.007056s ] [ sql ] [ SQL ] SELECT 955,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.007040s ] [ sql ] [ SQL ] SELECT 955,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.007059s ] [ sql ] [ SQL ] SELECT 955,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.007248s ] [ sql ] [ SQL ] SELECT 955,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.007023s ] [ sql ] [ SQL ] SELECT 955,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.006974s ] [ sql ] [ SQL ] SELECT 955,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.006970s ] --------------------------------------------------------------- [2025-09-05T23:59:23+08:00] 117.172.62.160 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.105451s] [吞吐率:9.48req/s] [内存消耗:3,557.18kb] [文件加载:90] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '51', 'x-token' => 'oCmeh5co9r3d3hsL59E8dNyC9frQ', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.62(0x18003e39) NetType/WIFI Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/member/getInfo', 'host' => 'main', 'pageSize' => '15', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.011068s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008976s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007414s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.009290s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5co9r3d3hsL59E8dNyC9frQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007338s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5co9r3d3hsL59E8dNyC9frQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007313s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008942s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 48442 LIMIT 1 [ RunTime:0.008282s ] --------------------------------------------------------------- [2025-09-05T23:59:25+08:00] 117.172.62.160 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.248422s] [吞吐率:4.03req/s] [内存消耗:3,921.59kb] [文件加载:93] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '71', 'x-token' => 'oCmeh5co9r3d3hsL59E8dNyC9frQ', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.62(0x18003e39) NetType/WIFI Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/consume/getLists', 'host' => 'main', 'pageSize' => '15', 'month' => '', 'page_num' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.011694s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.009004s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007688s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008800s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5co9r3d3hsL59E8dNyC9frQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007670s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5co9r3d3hsL59E8dNyC9frQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007579s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.009164s ] [ sql ] [ SQL ] SELECT `id`,`src_by`,`pay_money`,`ctime`,`site_id` FROM `tp_comm_consume` WHERE `member_id` = 48442 AND `state` = 9 ORDER BY `id` DESC LIMIT 15 [ RunTime:0.020752s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.009128s ] [ sql ] [ SQL ] SELECT 955,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.007627s ] [ sql ] [ SQL ] SELECT 955,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.007688s ] [ sql ] [ SQL ] SELECT 955,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.007698s ] [ sql ] [ SQL ] SELECT 955,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.007629s ] [ sql ] [ SQL ] SELECT 955,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.007715s ] [ sql ] [ SQL ] SELECT 955,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.007593s ] [ sql ] [ SQL ] SELECT 955,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.007654s ] [ sql ] [ SQL ] SELECT 955,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.007679s ] [ sql ] [ SQL ] SELECT 955,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.007886s ] [ sql ] [ SQL ] SELECT 955,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.007762s ] [ sql ] [ SQL ] SELECT 955,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.007607s ] [ sql ] [ SQL ] SELECT 955,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.007625s ] [ sql ] [ SQL ] SELECT 955,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.007642s ] [ sql ] [ SQL ] SELECT 955,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.007634s ] [ sql ] [ SQL ] SELECT 955,`name` FROM `tp_comm_site` WHERE `id` = 955 [ RunTime:0.007662s ] --------------------------------------------------------------- [2025-09-05T23:59:48+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:0.751346s] [吞吐率:1.33req/s] [内存消耗:4,240.95kb] [文件加载:104] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-type' => 'application/json', 'host' => 'api.scyeby.com', 'content-length' => '199', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => 'YE4G0147', 'SIDS' => '860B8914', 'CZ' => '6', 'DH' => '3033014', 'POW' => '110', 'DL' => '0.4149', 'TIM' => '305', 'MSG' => '8', 'POWs' => '3033014', 'MONEY' => '144', 'MSG2' => '5分钟时间无功率自动关闭充电', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009827s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008063s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006736s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008494s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3033014 LIMIT 1 [ RunTime:0.007505s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.007838s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 939 [ RunTime:0.007866s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.007770s ] [ sql ] [ SQL ] SELECT `id`,`total_money`,`yet_money` FROM `tp_comm_icard` WHERE `site_id` = 939 AND `icard` = '2709945755' LIMIT 1 [ RunTime:0.011401s ] [ sql ] [ SQL ] UPDATE `tp_comm_icard` SET `yet_money` = 25.27 , `uptime` = 1757087987 WHERE `id` = 20920 [ RunTime:0.006766s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007720s ] [ sql ] [ SQL ] SELECT 939,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 939 [ RunTime:0.006465s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.007935s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 939 [ RunTime:0.007798s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.007830s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006607s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.007744s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007913s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.007903s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006483s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.007741s ] [ sql ] [ SQL ] INSERT INTO `tp_comm_consume` (`port` , `state` , `agent_id` , `order_sn` , `icard` , `site_id` , `member_id` , `pay_id` , `order_money` , `pay_money` , `src_by` , `ctime` , `rate` , `directions` , `month` , `day` , `remark` , `details` , `payment_code` , `trade_no` , `system`) VALUES (1 , 9 , 438 , 'Y20250905235947938777' , '2709945755' , 939 , 44363 , 44363 , '1.26' , '1.26' , 'charge_temp' , '2025-09-05 18:54:08' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '刷卡充电' , '2025-09' , '2025-09-05' , NULL , '{\"sql\":\"UPDATE `tp_comm_icard` SET `yet_money` = 25.27 , `uptime` = 1757087987 WHERE `id` = 20920\",\"icard\":{\"id\":20920,\"total_money\":\"50.00\",\"yet_money\":\"24.01\"}}' , 'icardyue' , 'HD2025090518540817570696484992' , 'main') [ RunTime:0.009160s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025090518540817570696484992' , `order_money` = '1.26' , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 305 , `elec_num` = 0.45639 , `power_num` = 110 , `finish` = 8 , `state` = 9 , `other` = '{\"finish_text\":\"5分钟时间无功率自动关闭充电\",\"POWs\":\"3033014\",\"sj_elec\":\"0.4149\"}' , `finish_time` = '2025-09-05 23:59:47' , `js_result` = '{\"money\":\"1.26\",\"elec_num\":0.45638999999999996,\"elec_price\":\"0.579\",\"timeNum\":5,\"server_price\":\"0.2\"}' WHERE `id` = 3033014 [ RunTime:0.008066s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 939 LIMIT 1 [ RunTime:0.006504s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006547s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.009152s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 44363 LIMIT 1 [ RunTime:0.006718s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008126s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5b64RVISsTq2hd8kBNKhorU' , '结束充电' , '{\"touser\":\"oCmeh5b64RVISsTq2hd8kBNKhorU\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"浅水半岛二期\"},\"time4\":{\"value\":\"2025-09-05 18:54:08\"},\"time3\":{\"value\":\"2025-09-05 23:59:47\"},\"thing5\":{\"value\":\"您的订单【3033014】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=3033014\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68bb08f3-127588f9-200eef56\"}' , '2025-09-05 23:59:48') [ RunTime:0.007949s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008261s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0147' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YE4G0147\",\"SIDS\":\"860B8914\",\"CZ\":\"6\",\"DH\":\"3033014\",\"POW\":\"110\",\"DL\":\"0.4149\",\"TIM\":\"305\",\"MSG\":\"8\",\"POWs\":\"3033014\",\"MONEY\":\"144\",\"MSG2\":\"5分钟时间无功率自动关闭充电\"}' , '{\"Z\":\"206\",\"IDS\":\"YE4G0147\",\"SIDS\":\"860B8914\",\"CZ\":\"6\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-09-05 23:59:48') [ RunTime:0.009710s ] [ error ] [8]未定义数组索引: remark[D:\www\api\application\comm\model\Consume.php:449] --------------------------------------------------------------- [2025-09-05T23:59:52+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:1.225385s] [吞吐率:0.82req/s] [内存消耗:4,384.91kb] [文件加载:107] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-type' => 'application/json', 'host' => 'api.scyeby.com', 'content-length' => '103', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '207', 'IDS' => 'YE4G0054', 'SIDS' => '860B8911', 'IC' => '3153613845', 'CZ' => '1', 'CS' => '1', 'TY' => '1', 'MXHao' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009619s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007785s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006344s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.007527s ] [ sql ] [ SQL ] SELECT `site_id`,`brand` FROM `tp_charge_equi` WHERE `equi_ids` = 'YE4G0054' LIMIT 1 [ RunTime:0.021838s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008862s ] [ sql ] [ SQL ] SELECT `relation_site_ids` FROM `tp_comm_site` WHERE `id` = 962 LIMIT 1 [ RunTime:0.006351s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.007621s ] [ sql ] [ SQL ] SELECT `start_time`,`id`,`total_elec`,`yet_elec`,total_elec-yet_elec sy_elec,`total_time`,`yet_time`,total_time-yet_time sy_time,`total_num`,`yet_num`,total_num-yet_num sy_num FROM `tp_charge_month` WHERE `site_id` = 962 AND `icard` = '3153613845' AND `start_time` <= '2025-09-05' AND `end_time` > '2025-09-05' [ RunTime:0.024645s ] [ sql ] [ SQL ] SELECT `id`,`total_elec`,`yet_elec`,total_elec-yet_elec sy_elec,`total_time`,`yet_time`,total_time-yet_time sy_time,`total_num`,`yet_num`,total_num-yet_num sy_num FROM `tp_charge_month` WHERE `icard` = '3153613845' AND `start_time` <= '2025-09-05' AND `end_time` >= '2025-09-05' [ RunTime:0.006434s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.007666s ] [ sql ] [ SQL ] SELECT total_money-yet_money sy_money,`icard`,`member_id`,`state`,`park_end` FROM `tp_comm_icard` WHERE `site_id` = 962 AND `icard` = '3153613845' ORDER BY `id` ASC [ RunTime:0.013347s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.007557s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 962 [ RunTime:0.006446s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008081s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`sids`,`socket_num` FROM `tp_charge_orders` WHERE `icard` = '3153613845' AND `site_id` = 962 AND `state` = 1 [ RunTime:0.066049s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.007687s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 962 LIMIT 1 [ RunTime:0.020925s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 962 [ RunTime:0.006362s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008376s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 44689 LIMIT 1 [ RunTime:0.014643s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = 'YE4G0054' AND `state` = 1 AND `sids` = '860B8911' AND `socket_num` = 1 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.119897s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 962 LIMIT 1 [ RunTime:0.006440s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008408s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006455s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.007722s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006394s ] [ sql ] [ SQL ] INSERT INTO `tp_charge_orders` (`agent_id` , `site_id` , `order_sn` , `icard` , `state` , `member_id` , `member_mobile` , `equi_ids` , `socket_num` , `socket_no` , `sids` , `pay_money` , `ctime` , `valid_time` , `price_info` , `brand` , `value` , `other` , `system`) VALUES (438 , 962 , '20250905235951125196' , '3153613845' , 0 , 44689 , '17608350324' , 'YE4G0054' , 1 , 0 , '860B8911' , 10 , '2025-09-05 23:59:51' , 1757123991 , '{\"charge_type\":\"8\",\"start_power\":[\"0\",\"201\",\"301\",\"401\",\"501\",\"601\",\"701\",\"801\"],\"end_power\":[\"200\",\"300\",\"400\",\"500\",\"600\",\"700\",\"800\",\"950\"],\"price\":[\"0.95\",\"0.95\",\"0.95\",\"0.95\",\"0.95\",\"0.95\",\"0.95\",\"0.95\"],\"time\":[\"0.15\",\"0.2\",\"0.25\",\"0.3\",\"0.35\",\"0.4\",\"0.45\",\"0.5\"]}' , 'qy' , 10 , '[]' , 'main') [ RunTime:0.030022s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3034037 LIMIT 1 [ RunTime:0.006586s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `state` = 1 , `payment_code` = 'icardyue' , `trade_no` = 'HD2025090523595117570879918165' WHERE `id` = 3034037 [ RunTime:0.015818s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008079s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0054' , 'QY_101' , '{\"Z\":\"101\",\"IDS\":\"YE4G0054\",\"SIDS\":\"860B8911\",\"CZ\":\"1\",\"MODEL\":\"8\",\"TIM\":\"600\",\"DL\":\"1000\",\"MONEY\":\"1000\",\"LIST\":\"0_200_950_15,201_300_950_20,301_400_950_25,401_500_950_30,501_600_950_35,601_700_950_40,701_800_950_45,801_950_950_50\",\"DH\":\"3034037\",\"ZMONEY\":\"2397\"}' , '{\"state\":\"1\"}' , '2025-09-05 23:59:52') [ RunTime:0.015061s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 962 LIMIT 1 [ RunTime:0.006435s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.007632s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.009505s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 44689 LIMIT 1 [ RunTime:0.006374s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008093s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5dZgyLH3JVXojnOo1kHWUx4' , '开始充电' , '{\"touser\":\"oCmeh5dZgyLH3JVXojnOo1kHWUx4\",\"template_id\":\"Agy1VhMUNj0Ts8jwvjW_UqGEDJOg0Y0-39j6y8nhpRg\",\"data\":{\"thing2\":{\"value\":\"星城都\"},\"character_string8\":{\"value\":\"YE4G0054(860B8911)\"},\"character_string9\":{\"value\":\"No.1\"},\"character_string6\":{\"value\":3034037},\"time3\":{\"value\":\"2025-09-05 23:59:51\"}},\"page\":\"\\/pages\\/orders\\/chargeing?order_id=3034037\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68bb08f8-0d9bed2a-10d9fa6c\"}' , '2025-09-05 23:59:52') [ RunTime:0.014248s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0054' , 'QY_207' , '{\"Z\":\"207\",\"IDS\":\"YE4G0054\",\"SIDS\":\"860B8911\",\"IC\":\"3153613845\",\"CZ\":\"1\",\"CS\":\"1\",\"TY\":\"1\",\"MXHao\":\"1\"}' , '{\"Z\":\"207\",\"IDS\":\"YE4G0054\",\"SIDS\":\"860B8911\",\"CZ\":\"1\",\"IC\":\"3153613845\",\"MONEY\":\"2397\",\"MXHao\":\"1\",\"state\":\"1\",\"msg\":\"5\",\"msg2\":\"45\",\"txt\":\"开电成功\"}' , '2025-09-05 23:59:52') [ RunTime:0.006620s ] [ error ] [8]未定义数组索引: msg[D:\www\api\application\charge\model\Api.php:373]