--------------------------------------------------------------- [2025-08-31T23:55:24+08:00] 118.115.103.157 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.583746s] [吞吐率:1.71req/s] [内存消耗:4,008.84kb] [文件加载: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' => 'oCmeh5XkEMfZy673UfxihJtmTMxo', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_4 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.61(0x18003d39) 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' => '2190474', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.011316s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008992s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007464s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.010713s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5XkEMfZy673UfxihJtmTMxo' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007498s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5XkEMfZy673UfxihJtmTMxo' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007437s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008794s ] [ sql ] [ SQL ] SELECT `id`,`state`,`src_by`,`pay_money`,`order_sn`,`pay_config` FROM `tp_comm_consume` WHERE `id` = 2190474 LIMIT 1 [ RunTime:0.007533s ] [ 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-08-31T23:55:25+08:00] 118.115.103.157 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.573236s] [吞吐率:1.74req/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' => 'oCmeh5XkEMfZy673UfxihJtmTMxo', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_4 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.61(0x18003d39) 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' => '2190475', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010017s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008159s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006587s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.011648s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5XkEMfZy673UfxihJtmTMxo' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006538s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5XkEMfZy673UfxihJtmTMxo' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006543s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.007966s ] [ sql ] [ SQL ] SELECT `id`,`state`,`src_by`,`pay_money`,`order_sn`,`pay_config` FROM `tp_comm_consume` WHERE `id` = 2190475 LIMIT 1 [ RunTime:0.006593s ] [ 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-08-31T23:55:40+08:00] 175.24.211.31 POST api.scyeby.com/public/index.php/index/Wxservice/index.html?signature=f601823e90a0824a20d59462b774ddfba87184d6×tamp=1756655740&nonce=700279246&openid=oCmeh5XkEMfZy673UfxihJtmTMxo [运行时间:0.064091s] [吞吐率:15.60req/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' => 'f601823e90a0824a20d59462b774ddfba87184d6', 'timestamp' => '1756655740', 'nonce' => '700279246', 'openid' => 'oCmeh5XkEMfZy673UfxihJtmTMxo', ) [ 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.008599s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007027s ] --------------------------------------------------------------- [2025-08-31T23:55:41+08:00] 118.115.103.157 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.291688s] [吞吐率:3.43req/s] [内存消耗:4,196.56kb] [文件加载: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' => '1170', 'x-token' => 'oCmeh5XkEMfZy673UfxihJtmTMxo', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_4 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.61(0x18003d39) 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' => '948', 'site_name' => '孔雀城单独充电', 'site_server' => '18980369999', 'equi_ids' => 'YE4G0050', 'equi_brand' => 'qy', 'equi_state' => '1', 'socket' => '[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object]', 'sids' => '8A086B85', 'price_info' => '[object Object]', 'money_list' => '[object Object],[object Object],[object Object],[object Object],[object Object],[object Object]', 'money_name' => '按电量计费', 'pay_money' => '3.84', 'value' => '4', 'socket_num' => '1', 'socket_no' => '', 'allow_time' => 'undefined', 'power_num' => '0', 'temp' => '{"charge_type":"3","start_power":["0","201","301","401","501","601"],"end_power":["200","300","400","500","600","700"],"price":["0.96","1.92","2.88","3.84","4.8","5.76"],"time":["1","2","3","4","5","6"]}', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010674s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008353s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007041s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008363s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5XkEMfZy673UfxihJtmTMxo' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006994s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5XkEMfZy673UfxihJtmTMxo' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.009937s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.009141s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 948 [ RunTime:0.007117s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 948 [ RunTime:0.007239s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008197s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 26498 LIMIT 1 [ RunTime:0.007175s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008449s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = 'YE4G0050' AND `state` = 1 AND `sids` = '8A086B85' AND `socket_num` = 1 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.008457s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008157s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 948 LIMIT 1 [ RunTime:0.007063s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008200s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007124s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008184s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007069s ] [ 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 , 948 , '20250831235541739490' , NULL , 0 , 26498 , '18010629651' , 'YE4G0050' , 1 , 0 , '8A086B85' , '3.84' , '2025-08-31 23:55:41' , 1756691740 , '{\"charge_type\":\"3\",\"start_power\":[\"0\",\"201\",\"301\",\"401\",\"501\",\"601\"],\"end_power\":[\"200\",\"300\",\"400\",\"500\",\"600\",\"700\"],\"price\":[\"0.96\",\"1.92\",\"2.88\",\"3.84\",\"4.8\",\"5.76\"],\"time\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"]}' , 'qy' , 4 , '[]' , 'main') [ RunTime:0.007415s ] [ sql ] [ SQL ] SELECT 948,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 948 [ RunTime:0.006970s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.008795s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 948 [ RunTime:0.007010s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007046s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006963s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008271s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007029s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008547s ] [ 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 , 'Y20250831235541733501' , NULL , 948 , 26498 , 26498 , '3.84' , '3.84' , 'charge_temp' , '2025-08-31 23:55:41' , '{\"site_id\":\"948\",\"site_name\":\"孔雀城单独充电\",\"equi_ids\":\"YE4G0050\",\"equi_brand\":\"qy\",\"sids\":\"8A086B85\",\"socket_num\":\"1\",\"socket_no\":\"\",\"value\":\"4\",\"order_id\":\"3018585\",\"sy_money\":\"3.84\"}' , '{\"appId\":\"wx9d3af783c5718533\",\"appSecret\":\"49cd7ec1b8418d1dcb19ce60b78ccb95\",\"partnerId\":\"1511337021\",\"apiKey\":\"f02795ff419df1f67b1b59aa0ca06754\",\"code\":\"yeby\",\"name\":\"元贰佰壹\"}' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '临时充电' , '2025-08' , '2025-08-31' , NULL , 'main') [ RunTime:0.009108s ] [ 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-08-31T23:55:41+08:00] 118.115.103.157 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.515641s] [吞吐率:1.94req/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' => 'oCmeh5XkEMfZy673UfxihJtmTMxo', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_4 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.61(0x18003d39) 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' => '2190476', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009583s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.012965s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006784s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.007529s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5XkEMfZy673UfxihJtmTMxo' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006379s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5XkEMfZy673UfxihJtmTMxo' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006377s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.007939s ] [ sql ] [ SQL ] SELECT `id`,`state`,`src_by`,`pay_money`,`order_sn`,`pay_config` FROM `tp_comm_consume` WHERE `id` = 2190476 LIMIT 1 [ RunTime:0.006386s ] [ 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-08-31T23:55:42+08:00] 171.219.10.74 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.166702s] [吞吐率:6.00req/s] [内存消耗:4,045.59kb] [文件加载: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' => 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4', '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(0x18003e38) NetType/4G 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' => '3018581', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010501s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008892s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007011s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008147s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007047s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007040s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008823s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3018581 LIMIT 1 [ RunTime:0.007126s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `time_num` = 0 , `elec_num` = 0 , `power_num` = 0 WHERE `id` = 3018581 [ RunTime:0.014589s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008518s ] [ sql ] [ SQL ] SELECT 983,`name` FROM `tp_comm_site` WHERE `id` = 983 [ RunTime:0.007062s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008140s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 983 LIMIT 1 [ RunTime:0.007003s ] --------------------------------------------------------------- [2025-08-31T23:55:43+08:00] 171.219.10.74 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.164976s] [吞吐率:6.06req/s] [内存消耗:4,045.58kb] [文件加载: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' => 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4', '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(0x18003e38) NetType/4G 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' => '3018581', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010106s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008032s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006655s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.007883s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006646s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006650s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008222s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3018581 LIMIT 1 [ RunTime:0.006768s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `time_num` = 0 , `elec_num` = 0 , `power_num` = 0 WHERE `id` = 3018581 [ RunTime:0.007016s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007949s ] [ sql ] [ SQL ] SELECT 983,`name` FROM `tp_comm_site` WHERE `id` = 983 [ RunTime:0.015437s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008383s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 983 LIMIT 1 [ RunTime:0.006687s ] --------------------------------------------------------------- [2025-08-31T23:55:44+08:00] 171.219.10.74 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.172323s] [吞吐率:5.80req/s] [内存消耗:4,045.59kb] [文件加载: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' => 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4', '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(0x18003e38) NetType/4G 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' => '3018581', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.020803s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008452s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007024s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008410s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006872s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006895s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008232s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3018581 LIMIT 1 [ RunTime:0.007227s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `time_num` = 0 , `elec_num` = 0 , `power_num` = 0 WHERE `id` = 3018581 [ RunTime:0.007208s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008414s ] [ sql ] [ SQL ] SELECT 983,`name` FROM `tp_comm_site` WHERE `id` = 983 [ RunTime:0.006798s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008839s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 983 LIMIT 1 [ RunTime:0.006835s ] --------------------------------------------------------------- [2025-08-31T23:55:44+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:0.870329s] [吞吐率:1.15req/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' => 'YE4G0058', 'SIDS' => '950B7DC7', 'IC' => '2708183563', 'CZ' => '4', 'CS' => '1', 'TY' => '1', 'MXHao' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010062s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008379s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006614s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.007936s ] [ sql ] [ SQL ] SELECT `site_id`,`brand` FROM `tp_charge_equi` WHERE `equi_ids` = 'YE4G0058' LIMIT 1 [ RunTime:0.007489s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008014s ] [ sql ] [ SQL ] SELECT `relation_site_ids` FROM `tp_comm_site` WHERE `id` = 963 LIMIT 1 [ RunTime:0.007003s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.007955s ] [ 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` = '2708183563' AND `start_time` <= '2025-08-31' AND `end_time` > '2025-08-31' [ RunTime:0.008247s ] [ 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` = '2708183563' AND `start_time` <= '2025-08-31' AND `end_time` >= '2025-08-31' [ RunTime:0.006782s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.009079s ] [ 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` = '2708183563' ORDER BY `id` ASC [ RunTime:0.008397s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008641s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 963 [ RunTime:0.006723s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008655s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`sids`,`socket_num` FROM `tp_charge_orders` WHERE `icard` = '2708183563' AND `site_id` = 963 AND `state` = 1 [ RunTime:0.011724s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.007751s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 963 LIMIT 1 [ RunTime:0.007009s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 963 [ RunTime:0.006660s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008231s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 7212 LIMIT 1 [ RunTime:0.007322s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = 'YE4G0058' AND `state` = 1 AND `sids` = '950B7DC7' AND `socket_num` = 4 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.010069s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 963 LIMIT 1 [ RunTime:0.006649s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.007973s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006726s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.007924s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006731s ] [ 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 , '20250831235544123627' , '2708183563' , 0 , 7212 , '18215624787' , 'YE4G0058' , 4 , 0 , '950B7DC7' , 10 , '2025-08-31 23:55:44' , 1756691743 , '{\"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.007170s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3018586 LIMIT 1 [ RunTime:0.006839s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `state` = 1 , `payment_code` = 'icardyue' , `trade_no` = 'HD2025083123554417566557449650' WHERE `id` = 3018586 [ RunTime:0.007090s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008184s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0058' , 'QY_101' , '{\"Z\":\"101\",\"IDS\":\"YE4G0058\",\"SIDS\":\"950B7DC7\",\"CZ\":\"4\",\"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\":\"3018586\",\"ZMONEY\":\"9907\"}' , '{\"state\":\"1\"}' , '2025-08-31 23:55:44') [ RunTime:0.009848s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 963 LIMIT 1 [ RunTime:0.006769s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.007784s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.010024s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 7212 LIMIT 1 [ RunTime:0.006989s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008145s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5fS410CxXIefRc8o4E470J0' , '开始充电' , '{\"touser\":\"oCmeh5fS410CxXIefRc8o4E470J0\",\"template_id\":\"Agy1VhMUNj0Ts8jwvjW_UqGEDJOg0Y0-39j6y8nhpRg\",\"data\":{\"thing2\":{\"value\":\"龙邸\"},\"character_string8\":{\"value\":\"YE4G0058(950B7DC7)\"},\"character_string9\":{\"value\":\"No.4\"},\"character_string6\":{\"value\":3018586},\"time3\":{\"value\":\"2025-08-31 23:55:44\"}},\"page\":\"\\/pages\\/orders\\/chargeing?order_id=3018586\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68b47080-73549266-6c2f3912\"}' , '2025-08-31 23:55:44') [ RunTime:0.007995s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0058' , 'QY_207' , '{\"Z\":\"207\",\"IDS\":\"YE4G0058\",\"SIDS\":\"950B7DC7\",\"IC\":\"2708183563\",\"CZ\":\"4\",\"CS\":\"1\",\"TY\":\"1\",\"MXHao\":\"1\"}' , '{\"Z\":\"207\",\"IDS\":\"YE4G0058\",\"SIDS\":\"950B7DC7\",\"CZ\":\"4\",\"IC\":\"2708183563\",\"MONEY\":\"9907\",\"MXHao\":\"1\",\"state\":\"1\",\"msg\":\"5\",\"msg2\":\"45\",\"txt\":\"开电成功\"}' , '2025-08-31 23:55:44') [ RunTime:0.006717s ] [ error ] [8]未定义数组索引: msg[D:\www\api\application\charge\model\Api.php:373] --------------------------------------------------------------- [2025-08-31T23:55:45+08:00] 171.219.10.74 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.157246s] [吞吐率:6.36req/s] [内存消耗:4,045.59kb] [文件加载: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' => 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4', '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(0x18003e38) NetType/4G 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' => '3018581', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010408s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008272s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006891s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008051s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006851s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006775s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008120s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3018581 LIMIT 1 [ RunTime:0.007204s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `time_num` = 0 , `elec_num` = 0 , `power_num` = 0 WHERE `id` = 3018581 [ RunTime:0.009118s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008132s ] [ sql ] [ SQL ] SELECT 983,`name` FROM `tp_comm_site` WHERE `id` = 983 [ RunTime:0.006847s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008141s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 983 LIMIT 1 [ RunTime:0.006779s ] --------------------------------------------------------------- [2025-08-31T23:55:46+08:00] 171.219.10.74 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.157277s] [吞吐率:6.36req/s] [内存消耗:4,045.59kb] [文件加载: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' => 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4', '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(0x18003e38) NetType/4G 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' => '3018581', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.012115s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008329s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007037s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008642s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006966s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007031s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008281s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3018581 LIMIT 1 [ RunTime:0.007100s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `time_num` = 0 , `elec_num` = 0 , `power_num` = 0 WHERE `id` = 3018581 [ RunTime:0.007390s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008449s ] [ sql ] [ SQL ] SELECT 983,`name` FROM `tp_comm_site` WHERE `id` = 983 [ RunTime:0.007012s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008156s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 983 LIMIT 1 [ RunTime:0.006987s ] --------------------------------------------------------------- [2025-08-31T23:55:47+08:00] 171.219.10.74 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.173201s] [吞吐率:5.77req/s] [内存消耗:4,045.58kb] [文件加载: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' => 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4', '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(0x18003e38) NetType/4G 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' => '3018581', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010805s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.009030s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007539s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008370s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007202s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007133s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.012991s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3018581 LIMIT 1 [ RunTime:0.007290s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `time_num` = 0 , `elec_num` = 0 , `power_num` = 0 WHERE `id` = 3018581 [ RunTime:0.009349s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.012873s ] [ sql ] [ SQL ] SELECT 983,`name` FROM `tp_comm_site` WHERE `id` = 983 [ RunTime:0.007169s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008467s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 983 LIMIT 1 [ RunTime:0.007318s ] --------------------------------------------------------------- [2025-08-31T23:55:47+08:00] 121.51.58.170 POST api.scyeby.com/public/index.php/index/payment/wxnotify.html [运行时间:0.797989s] [吞吐率:1.25req/s] [内存消耗:4,124.05kb] [文件加载:97] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-length' => '826', '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.014135s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007792s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006393s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_pay` [ RunTime:0.007539s ] [ sql ] [ SQL ] INSERT INTO `tp_log_pay` (`trade_no` , `content` , `result` , `ctime`) VALUES ('4200002773202508317056347229' , '{\"appid\":\"wx9d3af783c5718533\",\"attach\":\"2190476\",\"bank_type\":\"OTHERS\",\"cash_fee\":\"384\",\"fee_type\":\"CNY\",\"is_subscribe\":\"N\",\"mch_id\":\"1511337021\",\"nonce_str\":\"9b8ad89a7c3371572c520f0fb0f41f60\",\"openid\":\"oCmeh5XkEMfZy673UfxihJtmTMxo\",\"out_trade_no\":\"Y20250831235541733501\",\"result_code\":\"SUCCESS\",\"return_code\":\"SUCCESS\",\"sign\":\"88132F5425DB45A00BCD77B5DB824A1A\",\"time_end\":\"20250831235545\",\"total_fee\":\"384\",\"trade_type\":\"JSAPI\",\"transaction_id\":\"4200002773202508317056347229\"}' , '[]' , '2025-08-31 23:55:46') [ RunTime:0.006373s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.007593s ] [ sql ] [ SQL ] SELECT `id`,`state`,`ctime`,`details`,`src_by`,`order_money`,`rate` FROM `tp_comm_consume` WHERE `id` = 2190476 LIMIT 1 [ RunTime:0.006739s ] [ sql ] [ SQL ] UPDATE `tp_comm_consume` SET `state` = 9 , `payment_code` = 'wxpay' , `trade_no` = '4200002773202508317056347229' WHERE `id` = 2190476 [ RunTime:0.008295s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.007848s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3018585 LIMIT 1 [ RunTime:0.006478s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `state` = 1 , `payment_code` = 'wxpay' , `trade_no` = '4200002773202508317056347229' WHERE `id` = 3018585 [ RunTime:0.006566s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.007924s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0050' , 'QY_101' , '{\"Z\":\"101\",\"IDS\":\"YE4G0050\",\"SIDS\":\"8A086B85\",\"CZ\":\"1\",\"MODEL\":\"3\",\"TIM\":\"240\",\"DL\":\"400\",\"MONEY\":\"400\",\"LIST\":\"\",\"DH\":\"3018585\",\"ZMONEY\":\"384\"}' , '{\"state\":\"1\"}' , '2025-08-31 23:55:46') [ RunTime:0.006583s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007581s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 948 LIMIT 1 [ RunTime:0.006348s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.007505s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.009558s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008353s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 26498 LIMIT 1 [ RunTime:0.007248s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.007741s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5XkEMfZy673UfxihJtmTMxo' , '开始充电' , '{\"touser\":\"oCmeh5XkEMfZy673UfxihJtmTMxo\",\"template_id\":\"Agy1VhMUNj0Ts8jwvjW_UqGEDJOg0Y0-39j6y8nhpRg\",\"data\":{\"thing2\":{\"value\":\"孔雀城单独充电\"},\"character_string8\":{\"value\":\"YE4G0050(8A086B85)\"},\"character_string9\":{\"value\":\"No.1\"},\"character_string6\":{\"value\":3018585},\"time3\":{\"value\":\"2025-08-31 23:55:41\"}},\"page\":\"\\/pages\\/orders\\/chargeing?order_id=3018585\"}' , '{\"errcode\":0,\"errmsg\":\"ok\",\"msgid\":4145037299778322437}' , '2025-08-31 23:55:47') [ RunTime:0.006668s ] [ sql ] [ SQL ] UPDATE `tp_log_pay` SET `result` = '{\"code\":200}' WHERE `trade_no` = '4200002773202508317056347229' [ RunTime:0.006349s ] --------------------------------------------------------------- [2025-08-31T23:55:47+08:00] 42.192.0.152 POST api.scyeby.com/public/index.php/index/Wxservice/index.html?signature=d59f2e371127b133495c9a8d76771ef46eb94883×tamp=1756655747&nonce=904672679&openid=oCmeh5XkEMfZy673UfxihJtmTMxo [运行时间:0.058755s] [吞吐率:17.02req/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' => 'd59f2e371127b133495c9a8d76771ef46eb94883', 'timestamp' => '1756655747', 'nonce' => '904672679', 'openid' => 'oCmeh5XkEMfZy673UfxihJtmTMxo', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010617s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008657s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007040s ] --------------------------------------------------------------- [2025-08-31T23:55:50+08:00] 171.219.10.74 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.155586s] [吞吐率:6.43req/s] [内存消耗:4,045.59kb] [文件加载: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' => 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4', '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(0x18003e38) NetType/4G 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' => '3018581', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010378s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008428s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006875s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008189s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006960s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007192s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008171s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3018581 LIMIT 1 [ RunTime:0.006999s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `time_num` = 0 , `elec_num` = 0 , `power_num` = 0 WHERE `id` = 3018581 [ RunTime:0.007429s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008424s ] [ sql ] [ SQL ] SELECT 983,`name` FROM `tp_comm_site` WHERE `id` = 983 [ RunTime:0.006876s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008112s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 983 LIMIT 1 [ RunTime:0.006870s ] --------------------------------------------------------------- [2025-08-31T23:55:53+08:00] 171.219.10.74 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.076926s] [吞吐率:13.00req/s] [内存消耗:3,543.69kb] [文件加载: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' => 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4', '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(0x18003e38) 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.010341s ] 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.006875s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008075s ] [ sql ] [ SQL ] SELECT `site_name`,`site_logo`,`upload_config`,`regcms` FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006969s ] --------------------------------------------------------------- [2025-08-31T23:55:55+08:00] 39.144.137.228 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.286262s] [吞吐率:3.49req/s] [内存消耗:4,079.92kb] [文件加载: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', 'content-type' => 'application/x-www-form-urlencoded', 'x-token' => 'oCmeh5W3KsxqMP53CE53Y_viT6Ko', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 15; V2458A Build/AP3A.240905.015.A1_V000L1; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.180 Mobile Safari/537.36 XWEB/1380143 MMWEBSDK/20250802 MMWEBID/2195 MicroMessenger/8.0.62.2900(0x28003E57) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/getChargeData', 'host' => 'main', 'pageSize' => '15', 'sids' => 'BJ000262', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010528s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008785s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006971s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008297s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5W3KsxqMP53CE53Y_viT6Ko' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007477s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5W3KsxqMP53CE53Y_viT6Ko' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006965s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_socket` [ RunTime:0.008908s ] [ sql ] [ SQL ] SELECT `equi_id`,`num`,`socket_list`,`name` FROM `tp_charge_socket` WHERE `code` = 'BJ000262' [ RunTime:0.010026s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.010190s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`brand`,`site_id` FROM `tp_charge_equi` WHERE `id` = 197 LIMIT 1 [ RunTime:0.006976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008258s ] [ sql ] [ SQL ] SELECT `id`,`name`,`state`,`server_tel` FROM `tp_comm_site` WHERE `id` = 979 LIMIT 1 [ RunTime:0.007000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008355s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 979 LIMIT 1 [ RunTime:0.007594s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.014105s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 979 LIMIT 1 [ RunTime:0.007015s ] --------------------------------------------------------------- [2025-08-31T23:55:55+08:00] 42.192.0.152 POST api.scyeby.com/public/index.php/index/Wxservice/index.html?signature=35c6a51202409396b1d7da49d9f838af06da9453×tamp=1756655755&nonce=972014197&openid=oCmeh5e-W2nL29yZ-eNwK4aUzVfw [运行时间:0.063030s] [吞吐率:15.87req/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' => '35c6a51202409396b1d7da49d9f838af06da9453', 'timestamp' => '1756655755', 'nonce' => '972014197', 'openid' => 'oCmeh5e-W2nL29yZ-eNwK4aUzVfw', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010247s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008168s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007142s ] --------------------------------------------------------------- [2025-08-31T23:55:55+08:00] 110.191.109.9 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.294285s] [吞吐率:3.40req/s] [内存消耗:4,196.55kb] [文件加载: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' => '1229', 'x-token' => 'oCmeh5e-W2nL29yZ-eNwK4aUzVfw', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.62(0x18003e36) 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' => '1011', 'site_name' => '华庭阳光地面充电', 'site_server' => '18980369999', 'equi_ids' => 'YE4G0069', 'equi_brand' => 'qy', 'equi_state' => '1', 'socket' => '[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object]', 'sids' => 'C60B8515', 'price_info' => '[object Object]', 'money_list' => '[object Object],[object Object],[object Object],[object Object],[object Object]', 'money_name' => '', 'pay_money' => '3', 'value' => '15', 'socket_num' => '3', 'socket_no' => '', 'allow_time' => '4.68', 'power_num' => '502', 'temp' => '{"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"]}', ) [ 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.008245s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007080s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008165s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5e-W2nL29yZ-eNwK4aUzVfw' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006988s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5e-W2nL29yZ-eNwK4aUzVfw' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007105s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008220s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 1011 [ RunTime:0.007614s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 1011 [ RunTime:0.006984s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.009542s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 12313 LIMIT 1 [ RunTime:0.007517s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.009152s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = 'YE4G0069' AND `state` = 1 AND `sids` = 'C60B8515' AND `socket_num` = 3 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.008629s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008395s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 1011 LIMIT 1 [ RunTime:0.006968s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008181s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007041s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.011362s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007082s ] [ 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 , 1011 , '20250831235555727338' , NULL , 0 , 12313 , '17313368803' , 'YE4G0069' , 3 , 0 , 'C60B8515' , '3' , '2025-08-31 23:55:55' , 1756691755 , '{\"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' , 15 , '[]' , 'main') [ RunTime:0.007750s ] [ sql ] [ SQL ] SELECT 1011,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 1011 [ RunTime:0.006998s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.009101s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 1011 [ RunTime:0.007136s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007163s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007038s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008187s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007080s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008649s ] [ 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 , 'Y20250831235555509930' , NULL , 1011 , 12313 , 12313 , '3' , '3' , 'charge_temp' , '2025-08-31 23:55:55' , '{\"site_id\":\"1011\",\"site_name\":\"华庭阳光地面充电\",\"equi_ids\":\"YE4G0069\",\"equi_brand\":\"qy\",\"sids\":\"C60B8515\",\"socket_num\":\"3\",\"socket_no\":\"\",\"value\":\"15\",\"order_id\":\"3018587\",\"sy_money\":\"3\"}' , '{\"appId\":\"wx9d3af783c5718533\",\"appSecret\":\"49cd7ec1b8418d1dcb19ce60b78ccb95\",\"partnerId\":\"1511337021\",\"apiKey\":\"f02795ff419df1f67b1b59aa0ca06754\",\"code\":\"yeby\",\"name\":\"元贰佰壹\"}' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '临时充电' , '2025-08' , '2025-08-31' , NULL , 'main') [ RunTime:0.007811s ] [ 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-08-31T23:55:56+08:00] 110.191.109.9 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.527754s] [吞吐率:1.89req/s] [内存消耗:4,008.80kb] [文件加载: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' => 'oCmeh5e-W2nL29yZ-eNwK4aUzVfw', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.62(0x18003e36) 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' => '2190477', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.017190s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008630s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007416s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008550s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5e-W2nL29yZ-eNwK4aUzVfw' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007336s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5e-W2nL29yZ-eNwK4aUzVfw' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007350s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008630s ] [ sql ] [ SQL ] SELECT `id`,`state`,`src_by`,`pay_money`,`order_sn`,`pay_config` FROM `tp_comm_consume` WHERE `id` = 2190477 LIMIT 1 [ RunTime:0.007367s ] [ 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-08-31T23:55:58+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:0.775882s] [吞吐率:1.29req/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' => 'YE4G0034', 'SIDS' => 'BJ000278', 'CZ' => '9', 'DH' => '3017436', 'POW' => '106', 'DL' => '0.3935', 'TIM' => '301', 'MSG' => '8', 'POWs' => '3017436', 'MONEY' => '112', 'MSG2' => '5分钟时间无功率自动关闭充电', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010489s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008699s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006999s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008642s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3017436 LIMIT 1 [ RunTime:0.007098s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008196s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 976 [ RunTime:0.007055s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.009049s ] [ sql ] [ SQL ] SELECT `id`,`total_money`,`yet_money` FROM `tp_comm_icard` WHERE `site_id` = 976 AND `icard` = '3144049285' LIMIT 1 [ RunTime:0.007723s ] [ sql ] [ SQL ] UPDATE `tp_comm_icard` SET `yet_money` = 344.64 , `uptime` = 1756655757 WHERE `id` = 5880 [ RunTime:0.007348s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008217s ] [ sql ] [ SQL ] SELECT 976,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 976 [ RunTime:0.007013s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.008186s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 976 [ RunTime:0.006984s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.009089s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007063s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008265s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006998s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008153s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007043s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008275s ] [ 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 , 'Y20250831235557942800' , '3144049285' , 976 , 4988 , 4988 , '1.00' , '1.00' , 'charge_temp' , '2025-08-31 18:52:58' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '刷卡充电' , '2025-08' , '2025-08-31' , NULL , '{\"sql\":\"UPDATE `tp_comm_icard` SET `yet_money` = 344.64 , `uptime` = 1756655757 WHERE `id` = 5880\",\"icard\":{\"id\":5880,\"total_money\":\"501.40\",\"yet_money\":\"343.64\"}}' , 'icardyue' , 'HD2025083118525817566375789435' , 'main') [ RunTime:0.008386s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025083118525817566375789435' , `order_money` = '1.00' , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 301 , `elec_num` = 0.43285 , `power_num` = 106 , `finish` = 8 , `state` = 9 , `other` = '{\"finish_text\":\"5分钟时间无功率自动关闭充电\",\"POWs\":\"3017436\",\"sj_elec\":\"0.3935\"}' , `finish_time` = '2025-08-31 23:55:57' , `js_result` = '{\"money\":\"1.00\",\"elec_num\":0.43285,\"elec_price\":\"0.579\",\"timeNum\":5,\"server_price\":\"0.15\"}' WHERE `id` = 3017436 [ RunTime:0.007867s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 976 LIMIT 1 [ RunTime:0.006961s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007117s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008157s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 4988 LIMIT 1 [ RunTime:0.007366s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008297s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5fNc-W4NC2RpQXELBn2IgIo' , '结束充电' , '{\"touser\":\"oCmeh5fNc-W4NC2RpQXELBn2IgIo\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"力创锦苑二期\"},\"time4\":{\"value\":\"2025-08-31 18:52:58\"},\"time3\":{\"value\":\"2025-08-31 23:55:57\"},\"thing5\":{\"value\":\"您的订单【3017436】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=3017436\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68b4708d-48183911-27394a82\"}' , '2025-08-31 23:55:58') [ RunTime:0.007262s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008205s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0034' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YE4G0034\",\"SIDS\":\"BJ000278\",\"CZ\":\"9\",\"DH\":\"3017436\",\"POW\":\"106\",\"DL\":\"0.3935\",\"TIM\":\"301\",\"MSG\":\"8\",\"POWs\":\"3017436\",\"MONEY\":\"112\",\"MSG2\":\"5分钟时间无功率自动关闭充电\"}' , '{\"Z\":\"206\",\"IDS\":\"YE4G0034\",\"SIDS\":\"BJ000278\",\"CZ\":\"9\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-31 23:55:58') [ RunTime:0.008207s ] [ error ] [8]未定义数组索引: remark[D:\www\api\application\comm\model\Consume.php:449] --------------------------------------------------------------- [2025-08-31T23:55:59+08:00] 171.219.10.74 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.163371s] [吞吐率:6.12req/s] [内存消耗:4,045.58kb] [文件加载: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' => 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4', '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(0x18003e38) NetType/4G 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' => '3018581', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010565s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008418s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006967s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008128s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007032s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006965s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008292s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3018581 LIMIT 1 [ RunTime:0.007666s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `time_num` = 0 , `elec_num` = 0 , `power_num` = 0 WHERE `id` = 3018581 [ RunTime:0.007373s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008247s ] [ sql ] [ SQL ] SELECT 983,`name` FROM `tp_comm_site` WHERE `id` = 983 [ RunTime:0.006956s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008231s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 983 LIMIT 1 [ RunTime:0.007829s ] --------------------------------------------------------------- [2025-08-31T23:56:01+08:00] 124.223.151.119 POST api.scyeby.com/public/index.php/index/Wxservice/index.html?signature=b5e833f4cb32d1276039400d81ef1a9f7cd60626×tamp=1756655761&nonce=1919450604&openid=oCmeh5W3KsxqMP53CE53Y_viT6Ko [运行时间:0.075449s] [吞吐率:13.25req/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' => 'b5e833f4cb32d1276039400d81ef1a9f7cd60626', 'timestamp' => '1756655761', 'nonce' => '1919450604', 'openid' => 'oCmeh5W3KsxqMP53CE53Y_viT6Ko', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.018314s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007488s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006781s ] --------------------------------------------------------------- [2025-08-31T23:56:01+08:00] 39.144.137.228 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.332519s] [吞吐率:3.01req/s] [内存消耗:4,250.53kb] [文件加载:105] [ 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' => '1299', 'content-type' => 'application/x-www-form-urlencoded', 'x-token' => 'oCmeh5W3KsxqMP53CE53Y_viT6Ko', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 15; V2458A Build/AP3A.240905.015.A1_V000L1; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.180 Mobile Safari/537.36 XWEB/1380143 MMWEBSDK/20250802 MMWEBID/2195 MicroMessenger/8.0.62.2900(0x28003E57) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/createOrder', 'host' => 'main', 'pageSize' => '15', 'state' => '9', 'state_msg' => '', 'site_id' => '979', 'site_name' => '恋日家园C区', 'site_server' => '18980369999', 'equi_ids' => 'YEWI0046', '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' => 'BJ000262', 'price_info' => '[object Object]', 'money_list' => '[object Object],[object Object],[object Object],[object Object],[object Object]', 'money_name' => '', 'pay_money' => '3', 'value' => '15', 'socket_num' => '10', 'socket_no' => '', 'allow_time' => '4.68', 'power_num' => '502', 'temp' => '{"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"]}', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.011141s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008958s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007396s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008869s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5W3KsxqMP53CE53Y_viT6Ko' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007429s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5W3KsxqMP53CE53Y_viT6Ko' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007357s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008637s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 979 [ RunTime:0.007422s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008612s ] [ sql ] [ SQL ] SELECT `icard`,`park_end` FROM `tp_comm_icard` WHERE `site_id` = 979 AND `member_id` = 44564 ORDER BY `park_end` DESC LIMIT 1 [ RunTime:0.009037s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 979 [ RunTime:0.008856s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.009329s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 44564 LIMIT 1 [ RunTime:0.009524s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.009967s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = 'YEWI0046' AND `state` = 1 AND `sids` = 'BJ000262' AND `socket_num` = 10 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.011509s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008788s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 979 LIMIT 1 [ RunTime:0.008231s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.009418s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007503s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008574s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.008185s ] [ 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 , 979 , '20250831235601763430' , NULL , 0 , 44564 , '17713832890' , 'YEWI0046' , 10 , 0 , 'BJ000262' , '3' , '2025-08-31 23:56:01' , 1756691761 , '{\"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' , 15 , '[]' , 'main') [ RunTime:0.007888s ] [ sql ] [ SQL ] SELECT 979,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 979 [ RunTime:0.007411s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.009065s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 979 [ RunTime:0.007401s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007449s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.008156s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.009120s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007460s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008851s ] [ 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 , 'Y20250831235601558550' , NULL , 979 , 44564 , 44564 , '3' , '3' , 'charge_temp' , '2025-08-31 23:56:01' , '{\"site_id\":\"979\",\"site_name\":\"恋日家园C区\",\"equi_ids\":\"YEWI0046\",\"equi_brand\":\"qy\",\"sids\":\"BJ000262\",\"socket_num\":\"10\",\"socket_no\":\"\",\"value\":\"15\",\"order_id\":\"3018588\",\"sy_money\":\"3\"}' , '{\"appId\":\"wx9d3af783c5718533\",\"appSecret\":\"49cd7ec1b8418d1dcb19ce60b78ccb95\",\"partnerId\":\"1511337021\",\"apiKey\":\"f02795ff419df1f67b1b59aa0ca06754\",\"code\":\"yeby\",\"name\":\"元贰佰壹\"}' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '临时充电' , '2025-08' , '2025-08-31' , NULL , 'main') [ RunTime:0.008196s ] [ 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-08-31T23:56:02+08:00] 39.144.137.228 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.545598s] [吞吐率:1.83req/s] [内存消耗:4,009.70kb] [文件加载: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', 'content-type' => 'application/x-www-form-urlencoded', 'x-token' => 'oCmeh5W3KsxqMP53CE53Y_viT6Ko', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 15; V2458A Build/AP3A.240905.015.A1_V000L1; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.180 Mobile Safari/537.36 XWEB/1380143 MMWEBSDK/20250802 MMWEBID/2195 MicroMessenger/8.0.62.2900(0x28003E57) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/consume/getPayment', 'host' => 'main', 'pageSize' => '15', 'order_id' => '2190479', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010450s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008378s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006873s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008203s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5W3KsxqMP53CE53Y_viT6Ko' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006919s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5W3KsxqMP53CE53Y_viT6Ko' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006900s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008257s ] [ sql ] [ SQL ] SELECT `id`,`state`,`src_by`,`pay_money`,`order_sn`,`pay_config` FROM `tp_comm_consume` WHERE `id` = 2190479 LIMIT 1 [ RunTime:0.006908s ] [ 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-08-31T23:56:02+08:00] 101.34.79.105 POST api.scyeby.com/public/index.php/index/Wxservice/index.html?signature=bb6b591c56987ffb35061baf54745a56ea921f04×tamp=1756655761&nonce=600815650&openid=oCmeh5W3KsxqMP53CE53Y_viT6Ko [运行时间:0.063315s] [吞吐率:15.79req/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' => 'bb6b591c56987ffb35061baf54745a56ea921f04', 'timestamp' => '1756655761', 'nonce' => '600815650', 'openid' => 'oCmeh5W3KsxqMP53CE53Y_viT6Ko', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009875s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007724s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006595s ] --------------------------------------------------------------- [2025-08-31T23:56:02+08:00] 39.144.137.228 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.297871s] [吞吐率:3.36req/s] [内存消耗:4,250.58kb] [文件加载:105] [ 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' => '1299', 'content-type' => 'application/x-www-form-urlencoded', 'x-token' => 'oCmeh5W3KsxqMP53CE53Y_viT6Ko', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 15; V2458A Build/AP3A.240905.015.A1_V000L1; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.180 Mobile Safari/537.36 XWEB/1380143 MMWEBSDK/20250802 MMWEBID/2195 MicroMessenger/8.0.62.2900(0x28003E57) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/createOrder', 'host' => 'main', 'pageSize' => '15', 'state' => '9', 'state_msg' => '', 'site_id' => '979', 'site_name' => '恋日家园C区', 'site_server' => '18980369999', 'equi_ids' => 'YEWI0046', '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' => 'BJ000262', 'price_info' => '[object Object]', 'money_list' => '[object Object],[object Object],[object Object],[object Object],[object Object]', 'money_name' => '', 'pay_money' => '3', 'value' => '15', 'socket_num' => '10', 'socket_no' => '', 'allow_time' => '4.68', 'power_num' => '502', 'temp' => '{"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"]}', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.011636s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008171s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006749s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.007816s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5W3KsxqMP53CE53Y_viT6Ko' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006680s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5W3KsxqMP53CE53Y_viT6Ko' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006706s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.007877s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 979 [ RunTime:0.006722s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.007973s ] [ sql ] [ SQL ] SELECT `icard`,`park_end` FROM `tp_comm_icard` WHERE `site_id` = 979 AND `member_id` = 44564 ORDER BY `park_end` DESC LIMIT 1 [ RunTime:0.006765s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 979 [ RunTime:0.006677s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008186s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 44564 LIMIT 1 [ RunTime:0.006733s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008649s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = 'YEWI0046' AND `state` = 1 AND `sids` = 'BJ000262' AND `socket_num` = 10 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.009154s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.009756s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 979 LIMIT 1 [ RunTime:0.006726s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008026s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006765s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.007781s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006763s ] [ 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 , 979 , '20250831235602201246' , NULL , 0 , 44564 , '17713832890' , 'YEWI0046' , 10 , 0 , 'BJ000262' , '3' , '2025-08-31 23:56:02' , 1756691762 , '{\"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' , 15 , '[]' , 'main') [ RunTime:0.007004s ] [ sql ] [ SQL ] SELECT 979,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 979 [ RunTime:0.006662s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.007881s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 979 [ RunTime:0.006991s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006757s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006685s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.007788s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006715s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008306s ] [ 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 , 'Y20250831235602831249' , NULL , 979 , 44564 , 44564 , '3' , '3' , 'charge_temp' , '2025-08-31 23:56:02' , '{\"site_id\":\"979\",\"site_name\":\"恋日家园C区\",\"equi_ids\":\"YEWI0046\",\"equi_brand\":\"qy\",\"sids\":\"BJ000262\",\"socket_num\":\"10\",\"socket_no\":\"\",\"value\":\"15\",\"order_id\":\"3018589\",\"sy_money\":\"3\"}' , '{\"appId\":\"wx9d3af783c5718533\",\"appSecret\":\"49cd7ec1b8418d1dcb19ce60b78ccb95\",\"partnerId\":\"1511337021\",\"apiKey\":\"f02795ff419df1f67b1b59aa0ca06754\",\"code\":\"yeby\",\"name\":\"元贰佰壹\"}' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '临时充电' , '2025-08' , '2025-08-31' , NULL , 'main') [ RunTime:0.008378s ] [ 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-08-31T23:56:03+08:00] 39.144.137.228 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.510054s] [吞吐率:1.96req/s] [内存消耗:4,009.78kb] [文件加载: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', 'content-type' => 'application/x-www-form-urlencoded', 'x-token' => 'oCmeh5W3KsxqMP53CE53Y_viT6Ko', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 15; V2458A Build/AP3A.240905.015.A1_V000L1; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.180 Mobile Safari/537.36 XWEB/1380143 MMWEBSDK/20250802 MMWEBID/2195 MicroMessenger/8.0.62.2900(0x28003E57) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/consume/getPayment', 'host' => 'main', 'pageSize' => '15', 'order_id' => '2190480', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.011323s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008821s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007572s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.012966s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5W3KsxqMP53CE53Y_viT6Ko' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.008446s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5W3KsxqMP53CE53Y_viT6Ko' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007467s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008822s ] [ sql ] [ SQL ] SELECT `id`,`state`,`src_by`,`pay_money`,`order_sn`,`pay_config` FROM `tp_comm_consume` WHERE `id` = 2190480 LIMIT 1 [ RunTime:0.007557s ] [ 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-08-31T23:56:03+08:00] 121.51.58.170 POST api.scyeby.com/public/index.php/index/payment/wxnotify.html [运行时间:0.891317s] [吞吐率:1.12req/s] [内存消耗:4,124.41kb] [文件加载:97] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-length' => '826', '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.011563s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.009060s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.008571s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_pay` [ RunTime:0.009491s ] [ sql ] [ SQL ] INSERT INTO `tp_log_pay` (`trade_no` , `content` , `result` , `ctime`) VALUES ('4200002741202508313990221532' , '{\"appid\":\"wx9d3af783c5718533\",\"attach\":\"2190477\",\"bank_type\":\"OTHERS\",\"cash_fee\":\"300\",\"fee_type\":\"CNY\",\"is_subscribe\":\"N\",\"mch_id\":\"1511337021\",\"nonce_str\":\"0f7787d67f272a088ddf567ef86839b5\",\"openid\":\"oCmeh5e-W2nL29yZ-eNwK4aUzVfw\",\"out_trade_no\":\"Y20250831235555509930\",\"result_code\":\"SUCCESS\",\"return_code\":\"SUCCESS\",\"sign\":\"164E5D6383E823B937DB90AE97E6B9E2\",\"time_end\":\"20250831235602\",\"total_fee\":\"300\",\"trade_type\":\"JSAPI\",\"transaction_id\":\"4200002741202508313990221532\"}' , '[]' , '2025-08-31 23:56:03') [ RunTime:0.007925s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.009718s ] [ sql ] [ SQL ] SELECT `id`,`state`,`ctime`,`details`,`src_by`,`order_money`,`rate` FROM `tp_comm_consume` WHERE `id` = 2190477 LIMIT 1 [ RunTime:0.008214s ] [ sql ] [ SQL ] UPDATE `tp_comm_consume` SET `state` = 9 , `payment_code` = 'wxpay' , `trade_no` = '4200002741202508313990221532' WHERE `id` = 2190477 [ RunTime:0.008340s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.009006s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3018587 LIMIT 1 [ RunTime:0.007789s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `state` = 1 , `payment_code` = 'wxpay' , `trade_no` = '4200002741202508313990221532' WHERE `id` = 3018587 [ RunTime:0.007753s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.009095s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0069' , 'QY_101' , '{\"Z\":\"101\",\"IDS\":\"YE4G0069\",\"SIDS\":\"C60B8515\",\"CZ\":\"3\",\"MODEL\":\"8\",\"TIM\":\"900\",\"DL\":\"1500\",\"MONEY\":\"300\",\"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\":\"3018587\",\"ZMONEY\":\"300\"}' , '{\"state\":\"1\"}' , '2025-08-31 23:56:03') [ RunTime:0.008188s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008908s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 1011 LIMIT 1 [ RunTime:0.007668s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.010491s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007816s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.009184s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 12313 LIMIT 1 [ RunTime:0.007568s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.009326s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5e-W2nL29yZ-eNwK4aUzVfw' , '开始充电' , '{\"touser\":\"oCmeh5e-W2nL29yZ-eNwK4aUzVfw\",\"template_id\":\"Agy1VhMUNj0Ts8jwvjW_UqGEDJOg0Y0-39j6y8nhpRg\",\"data\":{\"thing2\":{\"value\":\"华庭阳光地面充电\"},\"character_string8\":{\"value\":\"YE4G0069(C60B8515)\"},\"character_string9\":{\"value\":\"No.3\"},\"character_string6\":{\"value\":3018587},\"time3\":{\"value\":\"2025-08-31 23:55:55\"}},\"page\":\"\\/pages\\/orders\\/chargeing?order_id=3018587\"}' , '{\"errcode\":0,\"errmsg\":\"ok\",\"msgid\":4145037579638800388}' , '2025-08-31 23:56:03') [ RunTime:0.007966s ] [ sql ] [ SQL ] UPDATE `tp_log_pay` SET `result` = '{\"code\":200}' WHERE `trade_no` = '4200002741202508313990221532' [ RunTime:0.007623s ] --------------------------------------------------------------- [2025-08-31T23:56:04+08:00] 124.223.188.110 POST api.scyeby.com/public/index.php/index/Wxservice/index.html?signature=bc280fd88ae16f1f69b34c768c6765b1c2b6e7af×tamp=1756655763&nonce=602269640&openid=oCmeh5e-W2nL29yZ-eNwK4aUzVfw [运行时间:0.061210s] [吞吐率:16.34req/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' => 'bc280fd88ae16f1f69b34c768c6765b1c2b6e7af', 'timestamp' => '1756655763', 'nonce' => '602269640', 'openid' => 'oCmeh5e-W2nL29yZ-eNwK4aUzVfw', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010271s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008150s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006816s ] --------------------------------------------------------------- [2025-08-31T23:56:05+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:0.197597s] [吞吐率:5.06req/s] [内存消耗:3,904.83kb] [文件加载:93] [ 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' => '196', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => 'YEWKA004', 'SIDS' => 'CH100006', 'CZ' => '6', 'DH' => '3017941', 'POW' => '98', 'DL' => '0.3057', 'TIM' => '199', 'MSG' => '8', 'POWs' => '3017941', 'MONEY' => '77', 'MSG2' => '检测到插座无充电器结束订单', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010403s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008998s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006920s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.009116s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3017941 LIMIT 1 [ RunTime:0.007064s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.008530s ] [ sql ] [ SQL ] SELECT `total_elec`,`yet_elec`,`total_time`,`yet_time`,`total_num`,`yet_num` FROM `tp_charge_month` WHERE `id` = 86094 LIMIT 1 [ RunTime:0.007865s ] [ sql ] [ SQL ] UPDATE `tp_charge_month` SET `yet_time` = 40.3 WHERE `id` = 86094 [ RunTime:0.007301s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025083120360217566437622036' , `order_money` = 0 , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 199 , `elec_num` = 0.33627 , `power_num` = 98 , `finish` = 8 , `state` = 9 , `other` = '{\"month_id\":86094,\"finish_text\":\"检测到插座无充电器结束订单\",\"POWs\":\"3017941\",\"sj_elec\":\"0.3057\"}' , `finish_time` = '2025-08-31 23:56:05' , `js_result` = '[]' WHERE `id` = 3017941 [ RunTime:0.007682s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008296s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 971 LIMIT 1 [ RunTime:0.006984s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008046s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006962s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008031s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 12164 LIMIT 1 [ RunTime:0.007475s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.007955s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEWKA004' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YEWKA004\",\"SIDS\":\"CH100006\",\"CZ\":\"6\",\"DH\":\"3017941\",\"POW\":\"98\",\"DL\":\"0.3057\",\"TIM\":\"199\",\"MSG\":\"8\",\"POWs\":\"3017941\",\"MONEY\":\"77\",\"MSG2\":\"检测到插座无充电器结束订单\"}' , '{\"Z\":\"206\",\"IDS\":\"YEWKA004\",\"SIDS\":\"CH100006\",\"CZ\":\"6\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-31 23:56:05') [ RunTime:0.007329s ] --------------------------------------------------------------- [2025-08-31T23:56:08+08:00] 121.51.58.171 POST api.scyeby.com/public/index.php/index/payment/wxnotify.html [运行时间:0.860824s] [吞吐率:1.16req/s] [内存消耗:4,124.41kb] [文件加载:97] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-length' => '826', '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.010307s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008291s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006851s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_pay` [ RunTime:0.008060s ] [ sql ] [ SQL ] INSERT INTO `tp_log_pay` (`trade_no` , `content` , `result` , `ctime`) VALUES ('4200002764202508315480482104' , '{\"appid\":\"wx9d3af783c5718533\",\"attach\":\"2190479\",\"bank_type\":\"OTHERS\",\"cash_fee\":\"300\",\"fee_type\":\"CNY\",\"is_subscribe\":\"N\",\"mch_id\":\"1511337021\",\"nonce_str\":\"a9ddfe3bc56934cff774910fd43df863\",\"openid\":\"oCmeh5W3KsxqMP53CE53Y_viT6Ko\",\"out_trade_no\":\"Y20250831235601558550\",\"result_code\":\"SUCCESS\",\"return_code\":\"SUCCESS\",\"sign\":\"AC4DE89FC04A38BD00DA1FB958DC0472\",\"time_end\":\"20250831235606\",\"total_fee\":\"300\",\"trade_type\":\"JSAPI\",\"transaction_id\":\"4200002764202508315480482104\"}' , '[]' , '2025-08-31 23:56:07') [ RunTime:0.006807s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008945s ] [ sql ] [ SQL ] SELECT `id`,`state`,`ctime`,`details`,`src_by`,`order_money`,`rate` FROM `tp_comm_consume` WHERE `id` = 2190479 LIMIT 1 [ RunTime:0.007176s ] [ sql ] [ SQL ] UPDATE `tp_comm_consume` SET `state` = 9 , `payment_code` = 'wxpay' , `trade_no` = '4200002764202508315480482104' WHERE `id` = 2190479 [ RunTime:0.007471s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008260s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3018588 LIMIT 1 [ RunTime:0.006951s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `state` = 1 , `payment_code` = 'wxpay' , `trade_no` = '4200002764202508315480482104' WHERE `id` = 3018588 [ RunTime:0.007338s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008131s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEWI0046' , 'QY_101' , '{\"Z\":\"101\",\"IDS\":\"YEWI0046\",\"SIDS\":\"BJ000262\",\"CZ\":\"10\",\"MODEL\":\"8\",\"TIM\":\"900\",\"DL\":\"1500\",\"MONEY\":\"300\",\"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\":\"3018588\",\"ZMONEY\":\"300\"}' , '{\"state\":\"1\"}' , '2025-08-31 23:56:07') [ RunTime:0.006794s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008256s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 979 LIMIT 1 [ RunTime:0.006790s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008184s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006887s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008266s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 44564 LIMIT 1 [ RunTime:0.006778s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.009198s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5W3KsxqMP53CE53Y_viT6Ko' , '开始充电' , '{\"touser\":\"oCmeh5W3KsxqMP53CE53Y_viT6Ko\",\"template_id\":\"Agy1VhMUNj0Ts8jwvjW_UqGEDJOg0Y0-39j6y8nhpRg\",\"data\":{\"thing2\":{\"value\":\"恋日家园C区\"},\"character_string8\":{\"value\":\"YEWI0046(BJ000262)\"},\"character_string9\":{\"value\":\"No.10\"},\"character_string6\":{\"value\":3018588},\"time3\":{\"value\":\"2025-08-31 23:56:01\"}},\"page\":\"\\/pages\\/orders\\/chargeing?order_id=3018588\"}' , '{\"errcode\":0,\"errmsg\":\"ok\",\"msgid\":4145037652519174145}' , '2025-08-31 23:56:08') [ RunTime:0.007285s ] [ sql ] [ SQL ] UPDATE `tp_log_pay` SET `result` = '{\"code\":200}' WHERE `trade_no` = '4200002764202508315480482104' [ RunTime:0.006958s ] --------------------------------------------------------------- [2025-08-31T23:56:08+08:00] 150.158.2.138 POST api.scyeby.com/public/index.php/index/Wxservice/index.html?signature=3ad9d455cc65e529b181ace01515534e0da506d6×tamp=1756655768&nonce=1287480526&openid=oCmeh5W3KsxqMP53CE53Y_viT6Ko [运行时间:0.058796s] [吞吐率:17.01req/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' => '3ad9d455cc65e529b181ace01515534e0da506d6', 'timestamp' => '1756655768', 'nonce' => '1287480526', 'openid' => 'oCmeh5W3KsxqMP53CE53Y_viT6Ko', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009508s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007711s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006319s ] --------------------------------------------------------------- [2025-08-31T23:56:08+08:00] 171.219.10.74 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.158183s] [吞吐率:6.32req/s] [内存消耗:4,045.59kb] [文件加载: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' => 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4', '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(0x18003e38) NetType/4G 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' => '3018581', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010469s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008580s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006587s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008162s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006531s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006559s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.007894s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3018581 LIMIT 1 [ RunTime:0.006669s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `time_num` = 0 , `elec_num` = 0 , `power_num` = 0 WHERE `id` = 3018581 [ RunTime:0.007888s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.009200s ] [ sql ] [ SQL ] SELECT 983,`name` FROM `tp_comm_site` WHERE `id` = 983 [ RunTime:0.006491s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.009446s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 983 LIMIT 1 [ RunTime:0.006482s ] --------------------------------------------------------------- [2025-08-31T23:56:10+08:00] 39.144.137.228 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.275742s] [吞吐率:3.63req/s] [内存消耗:4,079.94kb] [文件加载: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', 'content-type' => 'application/x-www-form-urlencoded', 'x-token' => 'oCmeh5W3KsxqMP53CE53Y_viT6Ko', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 15; V2458A Build/AP3A.240905.015.A1_V000L1; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.180 Mobile Safari/537.36 XWEB/1380143 MMWEBSDK/20250802 MMWEBID/2195 MicroMessenger/8.0.62.2900(0x28003E57) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/getChargeData', 'host' => 'main', 'pageSize' => '15', 'sids' => 'BJ000262', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010784s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008378s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006998s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008204s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5W3KsxqMP53CE53Y_viT6Ko' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006986s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5W3KsxqMP53CE53Y_viT6Ko' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006975s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_socket` [ RunTime:0.008158s ] [ sql ] [ SQL ] SELECT `equi_id`,`num`,`socket_list`,`name` FROM `tp_charge_socket` WHERE `code` = 'BJ000262' [ RunTime:0.009206s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.008233s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`brand`,`site_id` FROM `tp_charge_equi` WHERE `id` = 197 LIMIT 1 [ RunTime:0.007887s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008121s ] [ sql ] [ SQL ] SELECT `id`,`name`,`state`,`server_tel` FROM `tp_comm_site` WHERE `id` = 979 LIMIT 1 [ RunTime:0.007029s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008230s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 979 LIMIT 1 [ RunTime:0.007017s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.008010s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 979 LIMIT 1 [ RunTime:0.008168s ] --------------------------------------------------------------- [2025-08-31T23:56:14+08:00] 39.144.137.228 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.108619s] [吞吐率:9.21req/s] [内存消耗:3,861.38kb] [文件加载: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', 'content-type' => 'application/x-www-form-urlencoded', 'x-token' => 'oCmeh5W3KsxqMP53CE53Y_viT6Ko', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 15; V2458A Build/AP3A.240905.015.A1_V000L1; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.180 Mobile Safari/537.36 XWEB/1380143 MMWEBSDK/20250802 MMWEBID/2195 MicroMessenger/8.0.62.2900(0x28003E57) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/park/getLists', 'host' => 'main', 'pageSize' => '15', 'page_num' => '1', 'state' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.013366s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008759s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007513s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008681s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5W3KsxqMP53CE53Y_viT6Ko' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007489s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5W3KsxqMP53CE53Y_viT6Ko' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007535s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_park_orders` [ RunTime:0.008719s ] [ 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` = 44564 AND `state` IN (1,8) ORDER BY `state` ASC,`id` DESC LIMIT 30 [ RunTime:0.010362s ] --------------------------------------------------------------- [2025-08-31T23:56:15+08:00] 171.219.10.74 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.157557s] [吞吐率:6.35req/s] [内存消耗:4,045.58kb] [文件加载: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' => 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4', '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(0x18003e38) NetType/4G 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' => '3018581', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010032s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008505s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006698s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.007867s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006637s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006635s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.007940s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3018581 LIMIT 1 [ RunTime:0.007318s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `time_num` = 0 , `elec_num` = 0 , `power_num` = 0 WHERE `id` = 3018581 [ RunTime:0.006984s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008028s ] [ sql ] [ SQL ] SELECT 983,`name` FROM `tp_comm_site` WHERE `id` = 983 [ RunTime:0.006640s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.007868s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 983 LIMIT 1 [ RunTime:0.006800s ] --------------------------------------------------------------- [2025-08-31T23:56:15+08:00] 39.144.137.228 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.160757s] [吞吐率:6.22req/s] [内存消耗:4,061.97kb] [文件加载: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', 'content-type' => 'application/x-www-form-urlencoded', 'x-token' => 'oCmeh5W3KsxqMP53CE53Y_viT6Ko', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 15; V2458A Build/AP3A.240905.015.A1_V000L1; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.180 Mobile Safari/537.36 XWEB/1380143 MMWEBSDK/20250802 MMWEBID/2195 MicroMessenger/8.0.62.2900(0x28003E57) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/getLists', 'host' => 'main', 'pageSize' => '15', 'page_num' => '1', 'state' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.017327s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008591s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007229s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008561s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5W3KsxqMP53CE53Y_viT6Ko' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007135s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5W3KsxqMP53CE53Y_viT6Ko' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007109s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008398s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `member_id` = 44564 AND `state` = 1 AND `del` = 1 ORDER BY `state` ASC,`id` DESC LIMIT 30 [ RunTime:0.013536s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008763s ] [ sql ] [ SQL ] SELECT 979,`name` FROM `tp_comm_site` WHERE `id` = 979 [ RunTime:0.007146s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `time_num` = 0 , `elec_num` = 0 , `power_num` = 0 WHERE `id` = 3018588 [ RunTime:0.009597s ] --------------------------------------------------------------- [2025-08-31T23:56:16+08:00] 171.219.10.74 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.167869s] [吞吐率:5.96req/s] [内存消耗:4,045.59kb] [文件加载: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' => 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4', '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(0x18003e38) NetType/4G 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' => '3018581', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010514s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008428s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006979s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008531s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006978s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006951s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008296s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3018581 LIMIT 1 [ RunTime:0.007070s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `time_num` = 0 , `elec_num` = 0 , `power_num` = 0 WHERE `id` = 3018581 [ RunTime:0.007415s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.010376s ] [ sql ] [ SQL ] SELECT 983,`name` FROM `tp_comm_site` WHERE `id` = 983 [ RunTime:0.006939s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008754s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 983 LIMIT 1 [ RunTime:0.006948s ] --------------------------------------------------------------- [2025-08-31T23:56:17+08:00] 171.219.10.74 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.156729s] [吞吐率:6.38req/s] [内存消耗:4,045.59kb] [文件加载: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' => 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4', '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(0x18003e38) NetType/4G 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' => '3018581', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010308s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008391s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006846s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008022s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006898s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5R0BD2PC2_qTGH1VWEeXtf4' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006838s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008255s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3018581 LIMIT 1 [ RunTime:0.006966s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `time_num` = 0 , `elec_num` = 0 , `power_num` = 0 WHERE `id` = 3018581 [ RunTime:0.009271s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008065s ] [ sql ] [ SQL ] SELECT 983,`name` FROM `tp_comm_site` WHERE `id` = 983 [ RunTime:0.006906s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008053s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 983 LIMIT 1 [ RunTime:0.006828s ] --------------------------------------------------------------- [2025-08-31T23:56:20+08:00] 110.191.109.9 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.106816s] [吞吐率:9.36req/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' => 'oCmeh5e-W2nL29yZ-eNwK4aUzVfw', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.62(0x18003e36) 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.010569s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008556s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007032s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008210s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5e-W2nL29yZ-eNwK4aUzVfw' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006966s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5e-W2nL29yZ-eNwK4aUzVfw' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007094s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_park_orders` [ RunTime:0.008216s ] [ 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` = 12313 AND `state` IN (1,8) ORDER BY `state` ASC,`id` DESC LIMIT 30 [ RunTime:0.007712s ] --------------------------------------------------------------- [2025-08-31T23:56:20+08:00] 110.191.109.9 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.259175s] [吞吐率:3.86req/s] [内存消耗:4,079.02kb] [文件加载: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' => 'oCmeh5e-W2nL29yZ-eNwK4aUzVfw', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.62(0x18003e36) 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' => 'C60B8515', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010679s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.009286s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007586s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008851s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5e-W2nL29yZ-eNwK4aUzVfw' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007012s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5e-W2nL29yZ-eNwK4aUzVfw' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006986s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_socket` [ RunTime:0.008474s ] [ sql ] [ SQL ] SELECT `equi_id`,`num`,`socket_list`,`name` FROM `tp_charge_socket` WHERE `code` = 'C60B8515' [ RunTime:0.010441s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.008511s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`brand`,`site_id` FROM `tp_charge_equi` WHERE `id` = 572 LIMIT 1 [ RunTime:0.007405s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.009053s ] [ sql ] [ SQL ] SELECT `id`,`name`,`state`,`server_tel` FROM `tp_comm_site` WHERE `id` = 1011 LIMIT 1 [ RunTime:0.007050s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008337s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 1011 LIMIT 1 [ RunTime:0.006965s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.008493s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 1011 LIMIT 1 [ RunTime:0.007329s ] --------------------------------------------------------------- [2025-08-31T23:56:22+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:0.837779s] [吞吐率:1.19req/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' => '171', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => 'YEWKA054', 'SIDS' => 'CH100047', 'CZ' => '5', 'DH' => '3017032', 'POW' => '100', 'DL' => '0.5001', 'TIM' => '386', 'MSG' => '8', 'POWs' => '3017032', 'MONEY' => '133', 'MSG2' => '充满停止', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.014769s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008543s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007176s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008458s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3017032 LIMIT 1 [ RunTime:0.007516s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.009461s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 941 [ RunTime:0.008003s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008568s ] [ sql ] [ SQL ] SELECT `id`,`total_money`,`yet_money` FROM `tp_comm_icard` WHERE `site_id` = 941 AND `icard` = '3475163602' LIMIT 1 [ RunTime:0.008595s ] [ sql ] [ SQL ] UPDATE `tp_comm_icard` SET `yet_money` = 212.64 , `uptime` = 1756655782 WHERE `id` = 164 [ RunTime:0.012520s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.009000s ] [ sql ] [ SQL ] SELECT 941,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 941 [ RunTime:0.007132s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.008598s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 941 [ RunTime:0.007165s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.009423s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007158s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008323s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007163s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008333s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007229s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008903s ] [ 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 , 'Y20250831235622374032' , '3475163602' , 941 , 157 , 157 , '1.37' , '1.37' , 'charge_temp' , '2025-08-31 17:29:36' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '刷卡充电' , '2025-08' , '2025-08-31' , NULL , '{\"sql\":\"UPDATE `tp_comm_icard` SET `yet_money` = 212.64 , `uptime` = 1756655782 WHERE `id` = 164\",\"icard\":{\"id\":164,\"total_money\":\"219.00\",\"yet_money\":\"211.27\"}}' , 'icardyue' , 'HD2025083117293717566325773101' , 'main') [ RunTime:0.009414s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025083117293717566325773101' , `order_money` = '1.37' , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 386 , `elec_num` = 0.55011 , `power_num` = 100 , `finish` = 8 , `state` = 9 , `other` = '{\"finish_text\":\"充满停止\",\"POWs\":\"3017032\",\"sj_elec\":\"0.5001\"}' , `finish_time` = '2025-08-31 23:56:22' , `js_result` = '{\"money\":\"1.37\",\"elec_num\":0.55011,\"elec_price\":\"0.579\",\"timeNum\":7,\"server_price\":\"0.15\"}' WHERE `id` = 3017032 [ RunTime:0.007208s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 941 LIMIT 1 [ RunTime:0.007188s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007266s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008394s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 157 LIMIT 1 [ RunTime:0.008913s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008678s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5bJuut3EAA53lZGh-o29QsE' , '结束充电' , '{\"touser\":\"oCmeh5bJuut3EAA53lZGh-o29QsE\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"瑞景茗城5号车库\"},\"time4\":{\"value\":\"2025-08-31 17:29:36\"},\"time3\":{\"value\":\"2025-08-31 23:56:22\"},\"thing5\":{\"value\":\"您的订单【3017032】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=3017032\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68b470a6-067fc7f6-79da78b8\"}' , '2025-08-31 23:56:22') [ RunTime:0.008628s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008250s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEWKA054' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YEWKA054\",\"SIDS\":\"CH100047\",\"CZ\":\"5\",\"DH\":\"3017032\",\"POW\":\"100\",\"DL\":\"0.5001\",\"TIM\":\"386\",\"MSG\":\"8\",\"POWs\":\"3017032\",\"MONEY\":\"133\",\"MSG2\":\"充满停止\"}' , '{\"Z\":\"206\",\"IDS\":\"YEWKA054\",\"SIDS\":\"CH100047\",\"CZ\":\"5\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-31 23:56:22') [ RunTime:0.007637s ] [ error ] [8]未定义数组索引: remark[D:\www\api\application\comm\model\Consume.php:449] --------------------------------------------------------------- [2025-08-31T23:56:26+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qypark.html [运行时间:0.130283s] [吞吐率:7.68req/s] [内存消耗:3,774.38kb] [文件加载: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' => 'YEWK0077', 'com' => 'IC卡未注册', 'msg' => '1932379567', 'CH' => '4', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.011231s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008868s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.011428s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_park_equi` [ RunTime:0.008781s ] [ sql ] [ SQL ] SELECT `site_id` FROM `tp_park_equi` WHERE `equi_ids` = 'YEWK0077' LIMIT 1 [ RunTime:0.008544s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008981s ] [ sql ] [ SQL ] SELECT `id`,`park_end` FROM `tp_comm_icard` WHERE `icard` = '1932379567' AND `site_id` = 979 LIMIT 1 [ RunTime:0.007850s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_park` [ RunTime:0.008778s ] [ sql ] [ SQL ] INSERT INTO `tp_log_park` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEWK0077' , '4302' , '{\"Z\":\"4302\",\"IDS\":\"YEWK0077\",\"com\":\"IC卡未注册\",\"msg\":\"1932379567\",\"CH\":\"4\"}' , '{\"state\":\"ok\",\"code\":null}' , '2025-08-31 23:56:26') [ RunTime:0.007533s ] [ error ] [8]未定义变量: rst[D:\www\api\application\index\controller\Receive.php:304] --------------------------------------------------------------- [2025-08-31T23:57:19+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qypark.html [运行时间:0.123210s] [吞吐率:8.12req/s] [内存消耗:3,774.23kb] [文件加载: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', ) [ info ] [ PARAM ] array ( 'Z' => '4302', 'IDS' => 'YEWK0007', 'com' => 'IC卡未注册', 'msg' => '1377267816', 'CH' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.015921s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008370s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007108s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_park_equi` [ RunTime:0.008857s ] [ sql ] [ SQL ] SELECT `site_id` FROM `tp_park_equi` WHERE `equi_ids` = 'YEWK0007' LIMIT 1 [ RunTime:0.007042s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.009097s ] [ sql ] [ SQL ] SELECT `id`,`park_end` FROM `tp_comm_icard` WHERE `icard` = '1377267816' AND `site_id` = 971 LIMIT 1 [ RunTime:0.007392s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_park` [ RunTime:0.008863s ] [ sql ] [ SQL ] INSERT INTO `tp_log_park` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEWK0007' , '4302' , '{\"Z\":\"4302\",\"IDS\":\"YEWK0007\",\"com\":\"IC卡未注册\",\"msg\":\"1377267816\",\"CH\":\"1\"}' , '{\"state\":\"ok\",\"code\":null}' , '2025-08-31 23:57:19') [ RunTime:0.007030s ] [ error ] [8]未定义变量: rst[D:\www\api\application\index\controller\Receive.php:304] --------------------------------------------------------------- [2025-08-31T23:57:26+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:0.673889s] [吞吐率:1.48req/s] [内存消耗:3,956.90kb] [文件加载: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' => 'YEWI0044', 'SIDS' => 'BJ000260', 'CZ' => '8', 'DH' => '3017170', 'POW' => '288', 'DL' => '1.1333', 'TIM' => '356', 'MSG' => '8', 'POWs' => '3017170', 'MONEY' => '185', 'MSG2' => '充满停止', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.015605s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008753s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007407s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008662s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3017170 LIMIT 1 [ RunTime:0.007475s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.008470s ] [ sql ] [ SQL ] SELECT `total_elec`,`yet_elec`,`total_time`,`yet_time`,`total_num`,`yet_num` FROM `tp_charge_month` WHERE `id` = 90712 LIMIT 1 [ RunTime:0.008797s ] [ sql ] [ SQL ] UPDATE `tp_charge_month` SET `yet_time` = 45.02 WHERE `id` = 90712 [ RunTime:0.007650s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025083118002917566344299240' , `order_money` = 0 , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 356 , `elec_num` = 1.24663 , `power_num` = 288 , `finish` = 8 , `state` = 9 , `other` = '{\"month_id\":90712,\"finish_text\":\"充满停止\",\"POWs\":\"3017170\",\"sj_elec\":\"1.1333\"}' , `finish_time` = '2025-08-31 23:57:26' , `js_result` = '[]' WHERE `id` = 3017170 [ RunTime:0.007378s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008616s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 967 LIMIT 1 [ RunTime:0.007882s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008694s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007862s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008701s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 29613 LIMIT 1 [ RunTime:0.007659s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.009081s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5SMlNij1GWZxOdTOYEtdfGE' , '结束充电' , '{\"touser\":\"oCmeh5SMlNij1GWZxOdTOYEtdfGE\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"上行锦绣5栋\"},\"time4\":{\"value\":\"2025-08-31 18:00:29\"},\"time3\":{\"value\":\"2025-08-31 23:57:26\"},\"thing5\":{\"value\":\"您的订单【3017170】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=3017170\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68b470e6-01911795-63179288\"}' , '2025-08-31 23:57:26') [ RunTime:0.007890s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.009324s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEWI0044' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YEWI0044\",\"SIDS\":\"BJ000260\",\"CZ\":\"8\",\"DH\":\"3017170\",\"POW\":\"288\",\"DL\":\"1.1333\",\"TIM\":\"356\",\"MSG\":\"8\",\"POWs\":\"3017170\",\"MONEY\":\"185\",\"MSG2\":\"充满停止\"}' , '{\"Z\":\"206\",\"IDS\":\"YEWI0044\",\"SIDS\":\"BJ000260\",\"CZ\":\"8\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-31 23:57:26') [ RunTime:0.007591s ] --------------------------------------------------------------- [2025-08-31T23:57:40+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:0.804401s] [吞吐率:1.24req/s] [内存消耗:4,384.39kb] [文件加载: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' => '50062069', 'SIDS' => 'BJ000098', 'IC' => '2708696843', 'CZ' => '4', 'CS' => '1', 'TY' => '1', 'MXHao' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010607s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008742s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006999s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.008175s ] [ sql ] [ SQL ] SELECT `site_id`,`brand` FROM `tp_charge_equi` WHERE `equi_ids` = '50062069' LIMIT 1 [ RunTime:0.007089s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008500s ] [ sql ] [ SQL ] SELECT `relation_site_ids` FROM `tp_comm_site` WHERE `id` = 986 LIMIT 1 [ RunTime:0.006982s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.009393s ] [ 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` IN (985,986) AND `icard` = '2708696843' AND `start_time` <= '2025-08-31' AND `end_time` > '2025-08-31' [ RunTime:0.008668s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008840s ] [ sql ] [ SQL ] SELECT total_money-yet_money sy_money,`icard`,`member_id`,`state`,`park_end` FROM `tp_comm_icard` WHERE `site_id` IN (985,986) AND `icard` = '2708696843' ORDER BY `id` ASC [ RunTime:0.008229s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008301s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 986 [ RunTime:0.007034s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008293s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`sids`,`socket_num` FROM `tp_charge_orders` WHERE `icard` = '2708696843' AND `site_id` = 986 AND `state` = 1 [ RunTime:0.011087s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.008499s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 986 LIMIT 1 [ RunTime:0.007012s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 986 [ RunTime:0.006986s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008066s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 31832 LIMIT 1 [ RunTime:0.007329s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = '50062069' AND `state` = 1 AND `sids` = 'BJ000098' AND `socket_num` = 4 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.014513s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 986 LIMIT 1 [ RunTime:0.006984s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008235s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007074s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008178s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006954s ] [ 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 , 986 , '20250831235740212916' , '2708696843' , 0 , 31832 , '15528696691' , '50062069' , 4 , 0 , 'BJ000098' , 10 , '2025-08-31 23:57:40' , 1756691859 , '{\"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\":89956}' , 'main') [ RunTime:0.007451s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3018590 LIMIT 1 [ RunTime:0.007088s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `state` = 1 , `payment_code` = 'month' , `trade_no` = 'HD2025083123574017566558605910' WHERE `id` = 3018590 [ RunTime:0.007395s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.009306s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('50062069' , 'QY_101' , '{\"Z\":\"101\",\"IDS\":\"50062069\",\"SIDS\":\"BJ000098\",\"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\":\"3018590\",\"ZMONEY\":\"100\"}' , '{\"state\":\"1\"}' , '2025-08-31 23:57:40') [ RunTime:0.007684s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 986 LIMIT 1 [ RunTime:0.006992s ] [ 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.007077s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 31832 LIMIT 1 [ RunTime:0.007704s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.009709s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5TDy1dZMmM4JHD7Yib860nE' , '开始充电' , '{\"touser\":\"oCmeh5TDy1dZMmM4JHD7Yib860nE\",\"template_id\":\"Agy1VhMUNj0Ts8jwvjW_UqGEDJOg0Y0-39j6y8nhpRg\",\"data\":{\"thing2\":{\"value\":\"红星村三号车库\"},\"character_string8\":{\"value\":\"50062069(BJ000098)\"},\"character_string9\":{\"value\":\"No.4\"},\"character_string6\":{\"value\":3018590},\"time3\":{\"value\":\"2025-08-31 23:57:40\"}},\"page\":\"\\/pages\\/orders\\/chargeing?order_id=3018590\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68b470f4-06e3840f-7b2472e0\"}' , '2025-08-31 23:57:40') [ RunTime:0.007295s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('50062069' , 'QY_207' , '{\"Z\":\"207\",\"IDS\":\"50062069\",\"SIDS\":\"BJ000098\",\"IC\":\"2708696843\",\"CZ\":\"4\",\"CS\":\"1\",\"TY\":\"1\",\"MXHao\":\"1\"}' , '{\"Z\":\"207\",\"IDS\":\"50062069\",\"SIDS\":\"BJ000098\",\"CZ\":\"4\",\"IC\":\"2708696843\",\"MONEY\":\"100\",\"MXHao\":\"1\",\"state\":\"1\",\"msg\":\"5\",\"msg2\":\"45\",\"txt\":\"开电成功\"}' , '2025-08-31 23:57:40') [ RunTime:0.007027s ] [ error ] [8]未定义数组索引: msg[D:\www\api\application\charge\model\Api.php:373] --------------------------------------------------------------- [2025-08-31T23:57:52+08:00] 116.169.2.216 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.077092s] [吞吐率:12.97req/s] [内存消耗:3,544.59kb] [文件加载: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', 'content-type' => 'application/x-www-form-urlencoded', 'x-token' => 'oCmeh5TDy1dZMmM4JHD7Yib860nE', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 13; M2102J2SC Build/TKQ1.221114.001; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.180 Mobile Safari/537.36 XWEB/1380143 MMWEBSDK/20250802 MMWEBID/570 MicroMessenger/8.0.62.2900(0x28003E57) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/system/getSystem', 'host' => 'main', 'pageSize' => '15', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010048s ] 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.006670s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.007914s ] [ sql ] [ SQL ] SELECT `site_name`,`site_logo`,`upload_config`,`regcms` FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006737s ] --------------------------------------------------------------- [2025-08-31T23:57:54+08:00] 116.169.2.216 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.263644s] [吞吐率:3.79req/s] [内存消耗:3,866.35kb] [文件加载: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', 'content-type' => 'application/x-www-form-urlencoded', 'x-token' => 'oCmeh5TDy1dZMmM4JHD7Yib860nE', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 13; M2102J2SC Build/TKQ1.221114.001; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.180 Mobile Safari/537.36 XWEB/1380143 MMWEBSDK/20250802 MMWEBID/570 MicroMessenger/8.0.62.2900(0x28003E57) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/park/getLists', 'host' => 'main', 'pageSize' => '15', 'page_num' => '1', 'state' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009854s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007894s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006761s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.007865s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5TDy1dZMmM4JHD7Yib860nE' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006534s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.007757s ] [ sql ] [ SQL ] SELECT `id`,`openid`,`name`,`mobile` FROM `tp_comm_member` WHERE `openid` = 'oCmeh5TDy1dZMmM4JHD7Yib860nE' LIMIT 1 [ RunTime:0.136732s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_cache` WHERE `key` = 'oCmeh5TDy1dZMmM4JHD7Yib860nE' LIMIT 1 [ RunTime:0.007647s ] [ sql ] [ SQL ] INSERT INTO `tp_cache` (`tables` , `key` , `value`) VALUES ('comm_member' , 'oCmeh5TDy1dZMmM4JHD7Yib860nE' , '{\"id\":31832,\"openid\":\"oCmeh5TDy1dZMmM4JHD7Yib860nE\",\"name\":\"胡艺冬\",\"mobile\":\"15528696691\"}') [ RunTime:0.006440s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5TDy1dZMmM4JHD7Yib860nE' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006520s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_park_orders` [ RunTime:0.008115s ] [ 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` = 31832 AND `state` IN (1,8) ORDER BY `state` ASC,`id` DESC LIMIT 30 [ RunTime:0.006994s ] --------------------------------------------------------------- [2025-08-31T23:57:55+08:00] 116.169.2.216 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.192184s] [吞吐率:5.20req/s] [内存消耗:4,062.02kb] [文件加载: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', 'content-type' => 'application/x-www-form-urlencoded', 'x-token' => 'oCmeh5TDy1dZMmM4JHD7Yib860nE', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 13; M2102J2SC Build/TKQ1.221114.001; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.180 Mobile Safari/537.36 XWEB/1380143 MMWEBSDK/20250802 MMWEBID/570 MicroMessenger/8.0.62.2900(0x28003E57) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/getLists', 'host' => 'main', 'pageSize' => '15', 'page_num' => '1', 'state' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.015532s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008417s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007081s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008897s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5TDy1dZMmM4JHD7Yib860nE' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006951s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5TDy1dZMmM4JHD7Yib860nE' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.008260s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008252s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `member_id` = 31832 AND `state` = 1 AND `del` = 1 ORDER BY `state` ASC,`id` DESC LIMIT 30 [ RunTime:0.046355s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008378s ] [ sql ] [ SQL ] SELECT 986,`name` FROM `tp_comm_site` WHERE `id` = 986 [ RunTime:0.007639s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `time_num` = 0 , `elec_num` = 0 , `power_num` = 0 WHERE `id` = 3018590 [ RunTime:0.010732s ] --------------------------------------------------------------- [2025-08-31T23:58:00+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:0.642427s] [吞吐率:1.56req/s] [内存消耗:3,957.16kb] [文件加载: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' => 'YEWKA009', 'SIDS' => 'CH100011', 'CZ' => '4', 'DH' => '3017393', 'POW' => '563', 'DL' => '2.9762', 'TIM' => '315', 'MSG' => '8', 'POWs' => '3017393', 'MONEY' => '382', 'MSG2' => '检测到插座无充电器结束订单', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010141s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008474s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006760s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008150s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3017393 LIMIT 1 [ RunTime:0.006932s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.007816s ] [ sql ] [ SQL ] SELECT `total_elec`,`yet_elec`,`total_time`,`yet_time`,`total_num`,`yet_num` FROM `tp_charge_month` WHERE `id` = 87144 LIMIT 1 [ RunTime:0.007541s ] [ sql ] [ SQL ] UPDATE `tp_charge_month` SET `yet_time` = 122.83 WHERE `id` = 87144 [ RunTime:0.007141s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025083118414917566369092178' , `order_money` = 0 , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 315 , `elec_num` = 3.27382 , `power_num` = 563 , `finish` = 8 , `state` = 9 , `other` = '{\"month_id\":87144,\"finish_text\":\"检测到插座无充电器结束订单\",\"POWs\":\"3017393\",\"sj_elec\":\"2.9762\"}' , `finish_time` = '2025-08-31 23:58:00' , `js_result` = '[]' WHERE `id` = 3017393 [ RunTime:0.007336s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007836s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 971 LIMIT 1 [ RunTime:0.006646s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.007880s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006805s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008139s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 8695 LIMIT 1 [ RunTime:0.007322s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008249s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5dL_PD4Z2llgZ2Jps-FY3Ns' , '结束充电' , '{\"touser\":\"oCmeh5dL_PD4Z2llgZ2Jps-FY3Ns\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"红枫林三期三号门\"},\"time4\":{\"value\":\"2025-08-31 18:41:49\"},\"time3\":{\"value\":\"2025-08-31 23:58:00\"},\"thing5\":{\"value\":\"您的订单【3017393】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=3017393\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68b47108-10e20c28-18dd575b\"}' , '2025-08-31 23:58:00') [ RunTime:0.009018s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.007875s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEWKA009' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YEWKA009\",\"SIDS\":\"CH100011\",\"CZ\":\"4\",\"DH\":\"3017393\",\"POW\":\"563\",\"DL\":\"2.9762\",\"TIM\":\"315\",\"MSG\":\"8\",\"POWs\":\"3017393\",\"MONEY\":\"382\",\"MSG2\":\"检测到插座无充电器结束订单\"}' , '{\"Z\":\"206\",\"IDS\":\"YEWKA009\",\"SIDS\":\"CH100011\",\"CZ\":\"4\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-31 23:58:00') [ RunTime:0.006637s ] --------------------------------------------------------------- [2025-08-31T23:58:23+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:0.886274s] [吞吐率:1.13req/s] [内存消耗:4,384.72kb] [文件加载: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' => '104', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '207', 'IDS' => '10142572', 'SIDS' => 'BJ000045', 'IC' => '2710214059', 'CZ' => '12', 'CS' => '1', 'TY' => '1', 'MXHao' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.011236s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.009093s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007503s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.009547s ] [ sql ] [ SQL ] SELECT `site_id`,`brand` FROM `tp_charge_equi` WHERE `equi_ids` = '10142572' LIMIT 1 [ RunTime:0.008411s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.009166s ] [ sql ] [ SQL ] SELECT `relation_site_ids` FROM `tp_comm_site` WHERE `id` = 959 LIMIT 1 [ RunTime:0.007475s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.009192s ] [ 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` = 959 AND `icard` = '2710214059' AND `start_time` <= '2025-08-31' AND `end_time` > '2025-08-31' [ RunTime:0.008779s ] [ 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` = '2710214059' AND `start_time` <= '2025-08-31' AND `end_time` >= '2025-08-31' [ RunTime:0.007584s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008769s ] [ sql ] [ SQL ] SELECT total_money-yet_money sy_money,`icard`,`member_id`,`state`,`park_end` FROM `tp_comm_icard` WHERE `site_id` = 959 AND `icard` = '2710214059' ORDER BY `id` ASC [ RunTime:0.009113s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008701s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 959 [ RunTime:0.008474s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.009132s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`sids`,`socket_num` FROM `tp_charge_orders` WHERE `icard` = '2710214059' AND `site_id` = 959 AND `state` = 1 [ RunTime:0.012326s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.008672s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 959 LIMIT 1 [ RunTime:0.008509s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 959 [ RunTime:0.007459s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.009205s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 46197 LIMIT 1 [ RunTime:0.007856s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = '10142572' AND `state` = 1 AND `sids` = 'BJ000045' AND `socket_num` = 12 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.008912s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 959 LIMIT 1 [ RunTime:0.007496s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008825s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.009143s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.009181s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007919s ] [ 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 , 959 , '20250831235822635063' , '2710214059' , 0 , 46197 , '15982351817' , '10142572' , 12 , 0 , 'BJ000045' , 10 , '2025-08-31 23:58:22' , 1756691902 , '{\"charge_type\":\"8\",\"start_power\":[\"0\",\"201\",\"301\",\"401\",\"701\",\"801\"],\"end_power\":[\"200\",\"300\",\"400\",\"700\",\"800\",\"950\"],\"price\":[\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\"],\"time\":[\"0.15\",\"0.2\",\"0.25\",\"0.3\",\"0.4\",\"0.5\"]}' , 'qy' , 10 , '[]' , 'main') [ RunTime:0.008399s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3018591 LIMIT 1 [ RunTime:0.008412s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `state` = 1 , `payment_code` = 'icardyue' , `trade_no` = 'HD2025083123582217566559029119' WHERE `id` = 3018591 [ RunTime:0.007881s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.010513s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('10142572' , 'QY_101' , '{\"Z\":\"101\",\"IDS\":\"10142572\",\"SIDS\":\"BJ000045\",\"CZ\":\"12\",\"MODEL\":\"8\",\"TIM\":\"600\",\"DL\":\"1000\",\"MONEY\":\"1000\",\"LIST\":\"0_200_579_15,201_300_579_20,301_400_579_25,401_700_579_30,701_800_579_40,801_950_579_50\",\"DH\":\"3018591\",\"ZMONEY\":\"4586\"}' , '{\"state\":\"1\"}' , '2025-08-31 23:58:22') [ RunTime:0.008213s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 959 LIMIT 1 [ RunTime:0.007511s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008763s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007560s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 46197 LIMIT 1 [ RunTime:0.007646s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.009037s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5ZRbzgNpguEHXsVYKthNoRo' , '开始充电' , '{\"touser\":\"oCmeh5ZRbzgNpguEHXsVYKthNoRo\",\"template_id\":\"Agy1VhMUNj0Ts8jwvjW_UqGEDJOg0Y0-39j6y8nhpRg\",\"data\":{\"thing2\":{\"value\":\"平安苑\"},\"character_string8\":{\"value\":\"10142572(BJ000045)\"},\"character_string9\":{\"value\":\"No.12\"},\"character_string6\":{\"value\":3018591},\"time3\":{\"value\":\"2025-08-31 23:58:22\"}},\"page\":\"\\/pages\\/orders\\/chargeing?order_id=3018591\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68b4711e-1bfc8472-26013a93\"}' , '2025-08-31 23:58:23') [ RunTime:0.007858s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('10142572' , 'QY_207' , '{\"Z\":\"207\",\"IDS\":\"10142572\",\"SIDS\":\"BJ000045\",\"IC\":\"2710214059\",\"CZ\":\"12\",\"CS\":\"1\",\"TY\":\"1\",\"MXHao\":\"1\"}' , '{\"Z\":\"207\",\"IDS\":\"10142572\",\"SIDS\":\"BJ000045\",\"CZ\":\"12\",\"IC\":\"2710214059\",\"MONEY\":\"4586\",\"MXHao\":\"1\",\"state\":\"1\",\"msg\":\"5\",\"msg2\":\"45\",\"txt\":\"开电成功\"}' , '2025-08-31 23:58:23') [ RunTime:0.007997s ] [ error ] [8]未定义数组索引: msg[D:\www\api\application\charge\model\Api.php:373] --------------------------------------------------------------- [2025-08-31T23:58:26+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:0.732932s] [吞吐率:1.36req/s] [内存消耗:4,240.86kb] [文件加载: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' => '171', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => 'YE4G0131', 'SIDS' => '920B8D08', 'CZ' => '7', 'DH' => '3017587', 'POW' => '327', 'DL' => '0.9204', 'TIM' => '269', 'MSG' => '8', 'POWs' => '3017587', 'MONEY' => '203', 'MSG2' => '充满停止', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010560s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008517s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007051s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008234s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3017587 LIMIT 1 [ RunTime:0.007176s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008178s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 939 [ RunTime:0.007079s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008282s ] [ sql ] [ SQL ] SELECT `id`,`total_money`,`yet_money` FROM `tp_comm_icard` WHERE `site_id` = 939 AND `icard` = '2708910075' LIMIT 1 [ RunTime:0.007692s ] [ sql ] [ SQL ] UPDATE `tp_comm_icard` SET `yet_money` = 350.12 , `uptime` = 1756655906 WHERE `id` = 17360 [ RunTime:0.007370s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008252s ] [ sql ] [ SQL ] SELECT 939,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 939 [ RunTime:0.007083s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.008188s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 939 [ RunTime:0.008144s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008238s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007133s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008255s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007053s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008229s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007096s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008279s ] [ 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 , 'Y20250831235826639247' , '2708910075' , 939 , 33486 , 33486 , '2.09' , '2.09' , 'charge_temp' , '2025-08-31 19:28:36' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '刷卡充电' , '2025-08' , '2025-08-31' , NULL , '{\"sql\":\"UPDATE `tp_comm_icard` SET `yet_money` = 350.12 , `uptime` = 1756655906 WHERE `id` = 17360\",\"icard\":{\"id\":17360,\"total_money\":\"370.00\",\"yet_money\":\"348.03\"}}' , 'icardyue' , 'HD2025083119283617566397169343' , 'main') [ RunTime:0.011981s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025083119283617566397169343' , `order_money` = '2.09' , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 269 , `elec_num` = 1.01244 , `power_num` = 327 , `finish` = 8 , `state` = 9 , `other` = '{\"finish_text\":\"充满停止\",\"POWs\":\"3017587\",\"sj_elec\":\"0.9204\"}' , `finish_time` = '2025-08-31 23:58:26' , `js_result` = '{\"money\":\"2.09\",\"elec_num\":1.01244,\"elec_price\":\"0.579\",\"timeNum\":5,\"server_price\":\"0.3\"}' WHERE `id` = 3017587 [ RunTime:0.007211s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 939 LIMIT 1 [ RunTime:0.007058s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007085s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008632s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 33486 LIMIT 1 [ RunTime:0.007980s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008470s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5SsQATbaBjK8swglFOHa2iE' , '结束充电' , '{\"touser\":\"oCmeh5SsQATbaBjK8swglFOHa2iE\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"浅水半岛二期\"},\"time4\":{\"value\":\"2025-08-31 19:28:36\"},\"time3\":{\"value\":\"2025-08-31 23:58:26\"},\"thing5\":{\"value\":\"您的订单【3017587】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=3017587\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68b47122-03285274-3c7295a3\"}' , '2025-08-31 23:58:26') [ RunTime:0.007351s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008717s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0131' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YE4G0131\",\"SIDS\":\"920B8D08\",\"CZ\":\"7\",\"DH\":\"3017587\",\"POW\":\"327\",\"DL\":\"0.9204\",\"TIM\":\"269\",\"MSG\":\"8\",\"POWs\":\"3017587\",\"MONEY\":\"203\",\"MSG2\":\"充满停止\"}' , '{\"Z\":\"206\",\"IDS\":\"YE4G0131\",\"SIDS\":\"920B8D08\",\"CZ\":\"7\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-31 23:58:26') [ RunTime:0.007332s ] [ error ] [8]未定义数组索引: remark[D:\www\api\application\comm\model\Consume.php:449] --------------------------------------------------------------- [2025-08-31T23:58:49+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:0.628188s] [吞吐率:1.59req/s] [内存消耗:3,956.90kb] [文件加载: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' => 'S2917089', 'SIDS' => 'BJ000064', 'CZ' => '3', 'DH' => '3016587', 'POW' => '182', 'DL' => '1.2837', 'TIM' => '535', 'MSG' => '8', 'POWs' => '3016587', 'MONEY' => '209', 'MSG2' => '充满停止', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010240s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008110s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006838s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008122s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3016587 LIMIT 1 [ RunTime:0.006984s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.007969s ] [ sql ] [ SQL ] SELECT `total_elec`,`yet_elec`,`total_time`,`yet_time`,`total_num`,`yet_num` FROM `tp_charge_month` WHERE `id` = 89304 LIMIT 1 [ RunTime:0.007140s ] [ sql ] [ SQL ] UPDATE `tp_charge_month` SET `yet_time` = 17.62 WHERE `id` = 89304 [ RunTime:0.007167s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025083115024717566237674956' , `order_money` = 0 , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 535 , `elec_num` = 1.41207 , `power_num` = 182 , `finish` = 8 , `state` = 9 , `other` = '{\"month_id\":89304,\"finish_text\":\"充满停止\",\"POWs\":\"3016587\",\"sj_elec\":\"1.2837\"}' , `finish_time` = '2025-08-31 23:58:48' , `js_result` = '[]' WHERE `id` = 3016587 [ RunTime:0.006973s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008118s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 958 LIMIT 1 [ RunTime:0.006794s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.007942s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006996s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.007931s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 46665 LIMIT 1 [ RunTime:0.007220s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008348s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5fHYhv9nPT0M64l2ds8SnE8' , '结束充电' , '{\"touser\":\"oCmeh5fHYhv9nPT0M64l2ds8SnE8\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"蓝水湾\"},\"time4\":{\"value\":\"2025-08-31 15:02:47\"},\"time3\":{\"value\":\"2025-08-31 23:58:48\"},\"thing5\":{\"value\":\"您的订单【3016587】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=3016587\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68b47138-1ac96df4-4e42c2c7\"}' , '2025-08-31 23:58:49') [ RunTime:0.007194s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008023s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('S2917089' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"S2917089\",\"SIDS\":\"BJ000064\",\"CZ\":\"3\",\"DH\":\"3016587\",\"POW\":\"182\",\"DL\":\"1.2837\",\"TIM\":\"535\",\"MSG\":\"8\",\"POWs\":\"3016587\",\"MONEY\":\"209\",\"MSG2\":\"充满停止\"}' , '{\"Z\":\"206\",\"IDS\":\"S2917089\",\"SIDS\":\"BJ000064\",\"CZ\":\"3\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-31 23:58:49') [ RunTime:0.007243s ] --------------------------------------------------------------- [2025-08-31T23:59:15+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:1.160555s] [吞吐率:0.86req/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' => 'GX4G0125', 'SIDS' => 'E50B89CD', 'IC' => '1385934356', 'CZ' => '4', 'CS' => '1', 'TY' => '1', 'MXHao' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010550s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008481s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007011s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.008207s ] [ sql ] [ SQL ] SELECT `site_id`,`brand` FROM `tp_charge_equi` WHERE `equi_ids` = 'GX4G0125' LIMIT 1 [ RunTime:0.007063s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008258s ] [ sql ] [ SQL ] SELECT `relation_site_ids` FROM `tp_comm_site` WHERE `id` = 997 LIMIT 1 [ RunTime:0.007070s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.008185s ] [ 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` = '1385934356' AND `start_time` <= '2025-08-31' AND `end_time` > '2025-08-31' [ RunTime:0.008299s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008154s ] [ 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` = '1385934356' ORDER BY `id` ASC [ RunTime:0.007448s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008194s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 997 [ RunTime:0.007085s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008195s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`sids`,`socket_num` FROM `tp_charge_orders` WHERE `icard` = '1385934356' AND `site_id` = 997 AND `state` = 1 [ RunTime:0.010996s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.008199s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 997 LIMIT 1 [ RunTime:0.007342s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 997 [ RunTime:0.007026s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008569s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 46392 LIMIT 1 [ RunTime:0.007366s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = 'GX4G0125' AND `state` = 1 AND `sids` = 'E50B89CD' AND `socket_num` = 4 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.008592s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 997 LIMIT 1 [ RunTime:0.007011s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008304s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007145s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008224s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007077s ] [ 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 , '20250831235914876031' , '1385934356' , 0 , 46392 , '15736448930' , 'GX4G0125' , 4 , 0 , 'E50B89CD' , 10 , '2025-08-31 23:59:14' , 1756691954 , '{\"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\":89569}' , 'main') [ RunTime:0.007392s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3018592 LIMIT 1 [ RunTime:0.007148s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `state` = 1 , `payment_code` = 'month' , `trade_no` = 'HD2025083123591417566559543102' WHERE `id` = 3018592 [ RunTime:0.007400s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008363s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('GX4G0125' , 'QY_101' , '{\"Z\":\"101\",\"IDS\":\"GX4G0125\",\"SIDS\":\"E50B89CD\",\"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\":\"3018592\",\"ZMONEY\":\"0\"}' , '{\"state\":\"1\"}' , '2025-08-31 23:59:15') [ RunTime:0.009719s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 997 LIMIT 1 [ RunTime:0.007343s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008243s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.010582s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 46392 LIMIT 1 [ RunTime:0.007044s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008550s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5TMsaC3I2EIuqI4x8O0fpcQ' , '开始充电' , '{\"touser\":\"oCmeh5TMsaC3I2EIuqI4x8O0fpcQ\",\"template_id\":\"Agy1VhMUNj0Ts8jwvjW_UqGEDJOg0Y0-39j6y8nhpRg\",\"data\":{\"thing2\":{\"value\":\"北极星\"},\"character_string8\":{\"value\":\"GX4G0125(E50B89CD)\"},\"character_string9\":{\"value\":\"No.4\"},\"character_string6\":{\"value\":3018592},\"time3\":{\"value\":\"2025-08-31 23:59:14\"}},\"page\":\"\\/pages\\/orders\\/chargeing?order_id=3018592\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68b47153-67acd893-1b87cd2b\"}' , '2025-08-31 23:59:15') [ RunTime:0.007344s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('GX4G0125' , 'QY_207' , '{\"Z\":\"207\",\"IDS\":\"GX4G0125\",\"SIDS\":\"E50B89CD\",\"IC\":\"1385934356\",\"CZ\":\"4\",\"CS\":\"1\",\"TY\":\"1\",\"MXHao\":\"1\"}' , '{\"Z\":\"207\",\"IDS\":\"GX4G0125\",\"SIDS\":\"E50B89CD\",\"CZ\":\"4\",\"IC\":\"1385934356\",\"MONEY\":\"0\",\"MXHao\":\"1\",\"state\":\"1\",\"msg\":\"5\",\"msg2\":\"45\",\"txt\":\"开电成功\"}' , '2025-08-31 23:59:15') [ RunTime:0.007031s ] [ error ] [8]未定义数组索引: msg[D:\www\api\application\charge\model\Api.php:373] --------------------------------------------------------------- [2025-08-31T23:59:21+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:0.710612s] [吞吐率:1.41req/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' => 'YE4G0136', 'SIDS' => 'DD0AF365', 'CZ' => '2', 'DH' => '3017340', 'POW' => '252', 'DL' => '1.1847', 'TIM' => '328', 'MSG' => '8', 'POWs' => '3017340', 'MONEY' => '218', 'MSG2' => '检测到插座无充电器结束订单', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.011213s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.009360s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.009166s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.012403s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3017340 LIMIT 1 [ RunTime:0.007682s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008648s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 939 [ RunTime:0.007588s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008708s ] [ sql ] [ SQL ] SELECT `id`,`total_money`,`yet_money` FROM `tp_comm_icard` WHERE `site_id` = 939 AND `icard` = '2708370427' LIMIT 1 [ RunTime:0.008773s ] [ sql ] [ SQL ] UPDATE `tp_comm_icard` SET `yet_money` = 395.78 , `uptime` = 1756655960 WHERE `id` = 17227 [ RunTime:0.007834s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008710s ] [ sql ] [ SQL ] SELECT 939,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 939 [ RunTime:0.007448s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.008674s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 939 [ RunTime:0.007562s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.009703s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007516s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008960s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007472s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.009353s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007502s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.009529s ] [ 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 , 'Y20250831235920173254' , '2708370427' , 939 , 33309 , 33309 , '2.25' , '2.25' , 'charge_temp' , '2025-08-31 18:30:41' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '刷卡充电' , '2025-08' , '2025-08-31' , NULL , '{\"sql\":\"UPDATE `tp_comm_icard` SET `yet_money` = 395.78 , `uptime` = 1756655960 WHERE `id` = 17227\",\"icard\":{\"id\":17227,\"total_money\":\"430.00\",\"yet_money\":\"393.53\"}}' , 'icardyue' , 'HD2025083118304117566362412772' , 'main') [ RunTime:0.007684s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025083118304117566362412772' , `order_money` = '2.25' , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 328 , `elec_num` = 1.30317 , `power_num` = 252 , `finish` = 8 , `state` = 9 , `other` = '{\"finish_text\":\"检测到插座无充电器结束订单\",\"POWs\":\"3017340\",\"sj_elec\":\"1.1847\"}' , `finish_time` = '2025-08-31 23:59:20' , `js_result` = '{\"money\":\"2.25\",\"elec_num\":1.3031700000000002,\"elec_price\":\"0.579\",\"timeNum\":6,\"server_price\":\"0.25\"}' WHERE `id` = 3017340 [ RunTime:0.007523s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 939 LIMIT 1 [ RunTime:0.007445s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007550s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008775s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 33309 LIMIT 1 [ RunTime:0.008605s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.009063s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5bH0MATxMVls8BlqGd-EnM4' , '结束充电' , '{\"touser\":\"oCmeh5bH0MATxMVls8BlqGd-EnM4\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"浅水半岛二期\"},\"time4\":{\"value\":\"2025-08-31 18:30:41\"},\"time3\":{\"value\":\"2025-08-31 23:59:20\"},\"thing5\":{\"value\":\"您的订单【3017340】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=3017340\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68b47158-53040fa3-5b46fd47\"}' , '2025-08-31 23:59:21') [ RunTime:0.007761s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008650s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0136' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YE4G0136\",\"SIDS\":\"DD0AF365\",\"CZ\":\"2\",\"DH\":\"3017340\",\"POW\":\"252\",\"DL\":\"1.1847\",\"TIM\":\"328\",\"MSG\":\"8\",\"POWs\":\"3017340\",\"MONEY\":\"218\",\"MSG2\":\"检测到插座无充电器结束订单\"}' , '{\"Z\":\"206\",\"IDS\":\"YE4G0136\",\"SIDS\":\"DD0AF365\",\"CZ\":\"2\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-31 23:59:21') [ RunTime:0.008317s ] [ error ] [8]未定义数组索引: remark[D:\www\api\application\comm\model\Consume.php:449] --------------------------------------------------------------- [2025-08-31T23:59:31+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:0.403752s] [吞吐率:2.48req/s] [内存消耗:4,380.57kb] [文件加载: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' => 'YEWKA003', 'SIDS' => 'CH100005', 'IC' => '1135147148', 'CZ' => '6', 'CS' => '1', 'TY' => '1', 'MXHao' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.017608s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008296s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007056s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.009225s ] [ sql ] [ SQL ] SELECT `site_id`,`brand` FROM `tp_charge_equi` WHERE `equi_ids` = 'YEWKA003' LIMIT 1 [ RunTime:0.007095s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008584s ] [ sql ] [ SQL ] SELECT `relation_site_ids` FROM `tp_comm_site` WHERE `id` = 971 LIMIT 1 [ RunTime:0.007020s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.011140s ] [ 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` = 971 AND `icard` = '1135147148' AND `start_time` <= '2025-08-31' AND `end_time` > '2025-08-31' [ RunTime:0.007803s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008252s ] [ sql ] [ SQL ] SELECT total_money-yet_money sy_money,`icard`,`member_id`,`state`,`park_end` FROM `tp_comm_icard` WHERE `site_id` = 971 AND `icard` = '1135147148' ORDER BY `id` ASC [ RunTime:0.007752s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008244s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 971 [ RunTime:0.007234s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008528s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`sids`,`socket_num` FROM `tp_charge_orders` WHERE `icard` = '1135147148' AND `site_id` = 971 AND `state` = 1 [ RunTime:0.010582s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.008232s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 971 LIMIT 1 [ RunTime:0.007395s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 971 [ RunTime:0.006997s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008626s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 12222 LIMIT 1 [ RunTime:0.008410s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = 'YEWKA003' AND `state` = 1 AND `sids` = 'CH100005' AND `socket_num` = 6 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.008366s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 971 LIMIT 1 [ RunTime:0.006950s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008367s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007081s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008481s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007337s ] [ 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 , 971 , '20250831235931554524' , '1135147148' , 0 , 12222 , '13088046442' , 'YEWKA003' , 6 , 0 , 'CH100005' , 10 , '2025-08-31 23:59:31' , 1756691971 , '{\"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\":87147}' , 'main') [ RunTime:0.007375s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3018593 LIMIT 1 [ RunTime:0.007137s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `state` = 1 , `payment_code` = 'month' , `trade_no` = 'HD2025083123593117566559712032' WHERE `id` = 3018593 [ RunTime:0.007874s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008247s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEWKA003' , 'QY_101' , '{\"Z\":\"101\",\"IDS\":\"YEWKA003\",\"SIDS\":\"CH100005\",\"CZ\":\"6\",\"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\":\"3018593\",\"ZMONEY\":\"0\"}' , '{\"state\":\"1\"}' , '2025-08-31 23:59:31') [ RunTime:0.008011s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 971 LIMIT 1 [ RunTime:0.007142s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008209s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007347s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 12222 LIMIT 1 [ RunTime:0.007018s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEWKA003' , 'QY_207' , '{\"Z\":\"207\",\"IDS\":\"YEWKA003\",\"SIDS\":\"CH100005\",\"IC\":\"1135147148\",\"CZ\":\"6\",\"CS\":\"1\",\"TY\":\"1\",\"MXHao\":\"1\"}' , '{\"Z\":\"207\",\"IDS\":\"YEWKA003\",\"SIDS\":\"CH100005\",\"CZ\":\"6\",\"IC\":\"1135147148\",\"MONEY\":\"0\",\"MXHao\":\"1\",\"state\":\"1\",\"msg\":\"5\",\"msg2\":\"45\",\"txt\":\"开电成功\"}' , '2025-08-31 23:59:31') [ RunTime:0.007328s ] [ error ] [8]未定义数组索引: msg[D:\www\api\application\charge\model\Api.php:373] --------------------------------------------------------------- [2025-08-31T23:59:31+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:0.738457s] [吞吐率:1.35req/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' => '171', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => 'YE4G0049', 'SIDS' => '7302E242', 'CZ' => '3', 'DH' => '3017179', 'POW' => '265', 'DL' => '1.0941', 'TIM' => '355', 'MSG' => '8', 'POWs' => '3017179', 'MONEY' => '183', 'MSG2' => '充满停止', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010666s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008535s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007141s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008432s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3017179 LIMIT 1 [ RunTime:0.007341s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008322s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 983 [ RunTime:0.007824s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008328s ] [ sql ] [ SQL ] SELECT `id`,`total_money`,`yet_money` FROM `tp_comm_icard` WHERE `site_id` = 983 AND `icard` = '2710156907' LIMIT 1 [ RunTime:0.007867s ] [ sql ] [ SQL ] UPDATE `tp_comm_icard` SET `yet_money` = 331.06 , `uptime` = 1756655970 WHERE `id` = 18505 [ RunTime:0.007498s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008330s ] [ sql ] [ SQL ] SELECT 983,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 983 [ RunTime:0.007191s ] [ 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` = 983 [ RunTime:0.007158s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008418s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007254s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008422s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007153s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008419s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007212s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008394s ] [ 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 , 'Y20250831235931951812' , '2710156907' , 983 , 36847 , 36847 , '1.90' , '1.90' , 'charge_temp' , '2025-08-31 18:03:13' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '刷卡充电' , '2025-08' , '2025-08-31' , NULL , '{\"sql\":\"UPDATE `tp_comm_icard` SET `yet_money` = 331.06 , `uptime` = 1756655970 WHERE `id` = 18505\",\"icard\":{\"id\":18505,\"total_money\":\"350.00\",\"yet_money\":\"329.16\"}}' , 'icardyue' , 'HD2025083118031317566345939791' , 'main') [ RunTime:0.007774s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025083118031317566345939791' , `order_money` = '1.90' , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 355 , `elec_num` = 1.20351 , `power_num` = 265 , `finish` = 8 , `state` = 9 , `other` = '{\"finish_text\":\"充满停止\",\"POWs\":\"3017179\",\"sj_elec\":\"1.0941\"}' , `finish_time` = '2025-08-31 23:59:31' , `js_result` = '{\"money\":\"1.90\",\"elec_num\":1.20351,\"elec_price\":\"0.579\",\"timeNum\":6,\"server_price\":\"0.2\"}' WHERE `id` = 3017179 [ RunTime:0.007401s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 983 LIMIT 1 [ RunTime:0.007689s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007153s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008674s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 36847 LIMIT 1 [ RunTime:0.007382s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008778s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5SjxflwtS0AJQl0MUzDj60I' , '结束充电' , '{\"touser\":\"oCmeh5SjxflwtS0AJQl0MUzDj60I\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"眉山柏林谷\"},\"time4\":{\"value\":\"2025-08-31 18:03:13\"},\"time3\":{\"value\":\"2025-08-31 23:59:31\"},\"thing5\":{\"value\":\"您的订单【3017179】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=3017179\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68b47163-70abd8a1-1a2f565e\"}' , '2025-08-31 23:59:31') [ RunTime:0.007423s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008336s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0049' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YE4G0049\",\"SIDS\":\"7302E242\",\"CZ\":\"3\",\"DH\":\"3017179\",\"POW\":\"265\",\"DL\":\"1.0941\",\"TIM\":\"355\",\"MSG\":\"8\",\"POWs\":\"3017179\",\"MONEY\":\"183\",\"MSG2\":\"充满停止\"}' , '{\"Z\":\"206\",\"IDS\":\"YE4G0049\",\"SIDS\":\"7302E242\",\"CZ\":\"3\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-31 23:59:31') [ RunTime:0.010245s ] [ error ] [8]未定义数组索引: remark[D:\www\api\application\comm\model\Consume.php:449] --------------------------------------------------------------- [2025-08-31T23:59:36+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:0.207374s] [吞吐率:4.82req/s] [内存消耗:4,178.80kb] [文件加载: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' => 'YEWKA003', 'SIDS' => 'CH100005', 'IC' => '1135147148', 'CZ' => '6', 'CS' => '1', 'TY' => '1', 'MXHao' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010743s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008618s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007611s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.010333s ] [ sql ] [ SQL ] SELECT `site_id`,`brand` FROM `tp_charge_equi` WHERE `equi_ids` = 'YEWKA003' LIMIT 1 [ RunTime:0.008093s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008311s ] [ sql ] [ SQL ] SELECT `relation_site_ids` FROM `tp_comm_site` WHERE `id` = 971 LIMIT 1 [ RunTime:0.007517s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.008482s ] [ 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` = 971 AND `icard` = '1135147148' AND `start_time` <= '2025-08-31' AND `end_time` > '2025-08-31' [ RunTime:0.008687s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008282s ] [ sql ] [ SQL ] SELECT total_money-yet_money sy_money,`icard`,`member_id`,`state`,`park_end` FROM `tp_comm_icard` WHERE `site_id` = 971 AND `icard` = '1135147148' ORDER BY `id` ASC [ RunTime:0.007741s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008256s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 971 [ RunTime:0.007349s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008313s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`sids`,`socket_num` FROM `tp_charge_orders` WHERE `icard` = '1135147148' AND `site_id` = 971 AND `state` = 1 [ RunTime:0.007819s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.010820s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEWKA003' , 'QY_207' , '{\"Z\":\"207\",\"IDS\":\"YEWKA003\",\"SIDS\":\"CH100005\",\"IC\":\"1135147148\",\"CZ\":\"6\",\"CS\":\"1\",\"TY\":\"1\",\"MXHao\":\"1\"}' , '{\"Z\":\"207\",\"IDS\":\"YEWKA003\",\"SIDS\":\"CH100005\",\"CZ\":\"6\",\"IC\":\"1135147148\",\"MONEY\":\"0\",\"MXHao\":\"1\",\"state\":\"0\",\"msg\":\"6\",\"msg2\":\"103\",\"txt\":\"一张卡只允许充【1】台车,已充【1】台\"}' , '2025-08-31 23:59:36') [ RunTime:0.007179s ] [ error ] [8]未定义数组索引: sy_money[D:\www\api\application\index\controller\Receive.php:128] --------------------------------------------------------------- [2025-08-31T23:59:36+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:1.733832s] [吞吐率:0.58req/s] [内存消耗:4,233.02kb] [文件加载: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' => '199', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => 'YX4G0018', 'SIDS' => 'BJ000245', 'CZ' => '1', 'DH' => '3017492', 'POW' => '151', 'DL' => '0.5770', 'TIM' => '292', 'MSG' => '8', 'POWs' => '3017492', 'MONEY' => '133', 'MSG2' => '5分钟时间无功率自动关闭充电', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010581s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008520s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007034s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008376s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 3017492 LIMIT 1 [ RunTime:0.007156s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008212s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 1009 [ RunTime:0.007486s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008258s ] [ sql ] [ SQL ] SELECT `rate` FROM `tp_comm_consume` WHERE `trade_no` = '4200002717202508314732893741' LIMIT 1 [ RunTime:0.008052s ] [ sql ] [ SQL ] SELECT `id`,`order_sn`,`pay_config`,`pay_money`,`trade_no` FROM `tp_comm_consume` WHERE `trade_no` = '4200002717202508314732893741' LIMIT 1 [ RunTime:0.007006s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_pay` [ RunTime:0.009098s ] [ sql ] [ SQL ] INSERT INTO `tp_log_pay` (`trade_no` , `content` , `result` , `ctime`) VALUES ('TK4200002717202508314732893741' , '{\"trade_no\":\"4200002717202508314732893741\",\"order_sn\":\"Y20250831190656247449\",\"pay_money\":2,\"refund_money\":0.6299999999999999}' , '{\"code\":200,\"msg\":\"退款成功\",\"data\":{\"return_code\":\"SUCCESS\",\"return_msg\":\"OK\",\"appid\":\"wx9d3af783c5718533\",\"mch_id\":\"1511337021\",\"nonce_str\":\"mW3cKoe16HsGiCxY\",\"sign\":\"42E00219DEC37036C222B1E9697BF9A2\",\"result_code\":\"SUCCESS\",\"transaction_id\":\"4200002717202508314732893741\",\"out_trade_no\":\"Y20250831190656247449\",\"out_refund_no\":\"Y20250831190656247449\",\"refund_id\":\"50302104782025083155537804640\",\"refund_channel\":[],\"refund_fee\":\"63\",\"coupon_refund_fee\":\"0\",\"total_fee\":\"200\",\"cash_fee\":\"200\",\"coupon_refund_count\":\"0\",\"cash_refund_fee\":\"63\"}}' , '2025-08-31 23:59:36') [ RunTime:0.007068s ] [ sql ] [ SQL ] UPDATE `tp_comm_consume` SET `refund_money` = 0.63 , `refund_state` = 9 , `refund_day` = '2025-08-31' , `refund_month` = '2025-08' , `refund_remark` = ',系统自动退款' WHERE `id` = 2189733 [ RunTime:0.008315s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008628s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 1009 LIMIT 1 [ RunTime:0.007081s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008160s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007129s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008282s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007685s ] [ sql ] [ SQL ] SELECT `nickname`,`mobile` FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007077s ] [ sql ] [ SQL ] SELECT `total_money` FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007388s ] [ sql ] [ SQL ] UPDATE `tp_comm_user` SET `total_money` = `total_money` + 1.37 WHERE `user_id` = 438 [ RunTime:0.006991s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_packet` [ RunTime:0.008246s ] [ 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 ( 1009,438,1,'1.37',9,'charge_temp','2025-08-31 19:06:56','2025-08-31 23:59:36','{\"order_money\":\"1.37\",\"old_money\":4375956.5}','4200002717202508314732893741','元贰佰壹科技有限公司','18980369999','100%','2025-08','2025-08-31','main' ) [ RunTime:0.011300s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = '4200002717202508314732893741' , `order_money` = '1.37' , `refund_money` = 0.63 , `refund_state` = 9 , `time_num` = 292 , `elec_num` = 0.6347 , `power_num` = 151 , `finish` = 8 , `state` = 9 , `other` = '{\"finish_text\":\"5分钟时间无功率自动关闭充电\",\"POWs\":\"3017492\",\"sj_elec\":\"0.5770\"}' , `finish_time` = '2025-08-31 23:59:36' , `js_result` = '{\"money\":\"1.37\",\"elec_num\":0.6346999999999999,\"elec_price\":\"0.579\",\"timeNum\":5,\"server_price\":\"0.2\"}' WHERE `id` = 3017492 [ RunTime:0.007418s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 1009 LIMIT 1 [ RunTime:0.007136s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008229s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007142s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008195s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 38619 LIMIT 1 [ RunTime:0.007853s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008435s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5V_7zGxOX0zEHlK7VkIB8Js' , '结束充电' , '{\"touser\":\"oCmeh5V_7zGxOX0zEHlK7VkIB8Js\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"观城\"},\"time4\":{\"value\":\"2025-08-31 19:06:56\"},\"time3\":{\"value\":\"2025-08-31 23:59:36\"},\"thing5\":{\"value\":\"您的订单【3017492】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=3017492\"}' , '{\"errcode\":0,\"errmsg\":\"ok\",\"msgid\":4145041154997665796}' , '2025-08-31 23:59:36') [ RunTime:0.008450s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008444s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YX4G0018' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YX4G0018\",\"SIDS\":\"BJ000245\",\"CZ\":\"1\",\"DH\":\"3017492\",\"POW\":\"151\",\"DL\":\"0.5770\",\"TIM\":\"292\",\"MSG\":\"8\",\"POWs\":\"3017492\",\"MONEY\":\"133\",\"MSG2\":\"5分钟时间无功率自动关闭充电\"}' , '{\"Z\":\"206\",\"IDS\":\"YX4G0018\",\"SIDS\":\"BJ000245\",\"CZ\":\"1\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-31 23:59:36') [ RunTime:0.013581s ] --------------------------------------------------------------- [2025-08-31T23:59:37+08:00] 175.24.214.222 POST api.scyeby.com/public/index.php/index/Wxservice/index.html?signature=df072550b3993164156be56af12f9d02263aa212×tamp=1756655976&nonce=869253795&openid=oCmeh5V_7zGxOX0zEHlK7VkIB8Js [运行时间:0.068399s] [吞吐率:14.62req/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' => 'df072550b3993164156be56af12f9d02263aa212', 'timestamp' => '1756655976', 'nonce' => '869253795', 'openid' => 'oCmeh5V_7zGxOX0zEHlK7VkIB8Js', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.012890s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.009050s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007364s ]