--------------------------------------------------------------- [2025-07-29T23:58:44+08:00] 39.144.137.250 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.288554s] [吞吐率:3.47req/s] [内存消耗:4,078.98kb] [文件加载: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' => 'oCmeh5QYPeIwILHXc2Ems3bLc8gI', '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.59(0x18003b2e) 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' => 'CH100037', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010504s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008906s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007458s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008403s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5QYPeIwILHXc2Ems3bLc8gI' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007029s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5QYPeIwILHXc2Ems3bLc8gI' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006992s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_socket` [ RunTime:0.008344s ] [ sql ] [ SQL ] SELECT `equi_id`,`num`,`socket_list`,`name` FROM `tp_charge_socket` WHERE `code` = 'CH100037' [ RunTime:0.026808s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.009941s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`brand`,`site_id` FROM `tp_charge_equi` WHERE `id` = 456 LIMIT 1 [ RunTime:0.008479s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008534s ] [ sql ] [ SQL ] SELECT `id`,`name`,`state`,`server_tel` FROM `tp_comm_site` WHERE `id` = 958 LIMIT 1 [ RunTime:0.006931s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008454s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 958 LIMIT 1 [ RunTime:0.007005s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.009418s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 958 LIMIT 1 [ RunTime:0.007907s ] --------------------------------------------------------------- [2025-07-29T23:58:50+08:00] 124.222.246.206 POST api.scyeby.com/public/index.php/index/Wxservice/index.html?signature=cda87cd0a80a6ded3b48dd48411f14849952517c×tamp=1753804729&nonce=634966161&openid=oCmeh5QYPeIwILHXc2Ems3bLc8gI [运行时间:0.080472s] [吞吐率:12.43req/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' => 'cda87cd0a80a6ded3b48dd48411f14849952517c', 'timestamp' => '1753804729', 'nonce' => '634966161', 'openid' => 'oCmeh5QYPeIwILHXc2Ems3bLc8gI', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.018008s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.009660s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007036s ] --------------------------------------------------------------- [2025-07-29T23:58:50+08:00] 39.144.137.250 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.377291s] [吞吐率:2.65req/s] [内存消耗:4,249.00kb] [文件加载: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' => '1231', 'x-token' => 'oCmeh5QYPeIwILHXc2Ems3bLc8gI', '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.59(0x18003b2e) 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' => '958', 'site_name' => '蓝水湾', 'site_server' => '18980369999', 'equi_ids' => 'YE4G0046', '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]', 'sids' => 'CH100037', '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' => '7', '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.010956s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.009018s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007235s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.019158s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5QYPeIwILHXc2Ems3bLc8gI' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.010463s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5QYPeIwILHXc2Ems3bLc8gI' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.009422s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008819s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 958 [ RunTime:0.007373s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008821s ] [ sql ] [ SQL ] SELECT `icard`,`park_end` FROM `tp_comm_icard` WHERE `site_id` = 958 AND `member_id` = 44276 ORDER BY `park_end` DESC LIMIT 1 [ RunTime:0.011376s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 958 [ RunTime:0.018313s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008963s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 44276 LIMIT 1 [ RunTime:0.007650s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008763s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = 'YE4G0046' AND `state` = 1 AND `sids` = 'CH100037' AND `socket_num` = 7 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.028389s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008919s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 958 LIMIT 1 [ RunTime:0.009029s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008553s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007272s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008653s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.008845s ] [ sql ] [ SQL ] INSERT INTO `tp_charge_orders` (`agent_id` , `site_id` , `order_sn` , `icard` , `state` , `member_id` , `member_mobile` , `equi_ids` , `socket_num` , `socket_no` , `sids` , `pay_money` , `ctime` , `valid_time` , `price_info` , `brand` , `value` , `other` , `system`) VALUES (438 , 958 , '20250729235850149604' , NULL , 0 , 44276 , '18884034868' , 'YE4G0046' , 7 , 0 , 'CH100037' , '3' , '2025-07-29 23:58:50' , 1753840730 , '{\"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.009623s ] [ sql ] [ SQL ] SELECT 958,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 958 [ RunTime:0.007271s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.008848s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 958 [ RunTime:0.007269s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007264s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007267s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008466s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007357s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.009350s ] [ 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 , 'Y20250729235850725411' , NULL , 958 , 44276 , 44276 , '3' , '3' , 'charge_temp' , '2025-07-29 23:58:50' , '{\"site_id\":\"958\",\"site_name\":\"蓝水湾\",\"equi_ids\":\"YE4G0046\",\"equi_brand\":\"qy\",\"sids\":\"CH100037\",\"socket_num\":\"7\",\"socket_no\":\"\",\"value\":\"15\",\"order_id\":\"2940429\",\"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-07' , '2025-07-29' , NULL , 'main') [ RunTime:0.008530s ] [ 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-07-29T23:58:50+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:0.762103s] [吞吐率:1.31req/s] [内存消耗:4,240.88kb] [文件加载: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' => '196', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => 'YE4G0313', 'SIDS' => 'BJ000323', 'CZ' => '4', 'DH' => '2940245', 'POW' => '90', 'DL' => '0.1829', 'TIM' => '101', 'MSG' => '8', 'POWs' => '2940245', 'MONEY' => '40', 'MSG2' => '检测到插座无充电器结束订单', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.017865s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008935s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007458s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.009885s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2940245 LIMIT 1 [ RunTime:0.007560s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008572s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 983 [ RunTime:0.007552s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.009124s ] [ sql ] [ SQL ] SELECT `id`,`total_money`,`yet_money` FROM `tp_comm_icard` WHERE `site_id` = 983 AND `icard` = '2708922683' LIMIT 1 [ RunTime:0.008258s ] [ sql ] [ SQL ] UPDATE `tp_comm_icard` SET `yet_money` = 107.15 , `uptime` = 1753804730 WHERE `id` = 20554 [ RunTime:0.007683s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008712s ] [ sql ] [ SQL ] SELECT 983,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 983 [ RunTime:0.007445s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.009491s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 983 [ RunTime:0.007444s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008793s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.008103s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008988s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007511s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008594s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007482s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008656s ] [ 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 , 'Y20250729235850457135' , '2708922683' , 983 , 43249 , 43249 , '0.42' , '0.42' , 'charge_temp' , '2025-07-29 22:17:42' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '刷卡充电' , '2025-07' , '2025-07-29' , NULL , '{\"sql\":\"UPDATE `tp_comm_icard` SET `yet_money` = 107.15 , `uptime` = 1753804730 WHERE `id` = 20554\",\"icard\":{\"id\":20554,\"total_money\":\"150.00\",\"yet_money\":\"106.73\"}}' , 'icardyue' , 'HD2025072922174217537986622584' , 'main') [ RunTime:0.007760s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025072922174217537986622584' , `order_money` = '0.42' , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 101 , `elec_num` = 0.20119 , `power_num` = 90 , `finish` = 8 , `state` = 9 , `other` = '{\"finish_text\":\"检测到插座无充电器结束订单\",\"POWs\":\"2940245\",\"sj_elec\":\"0.1829\"}' , `finish_time` = '2025-07-29 23:58:50' , `js_result` = '{\"money\":\"0.42\",\"elec_num\":0.20119,\"elec_price\":\"0.579\",\"timeNum\":2,\"server_price\":\"0.15\"}' WHERE `id` = 2940245 [ RunTime:0.007726s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 983 LIMIT 1 [ RunTime:0.007425s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007645s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008648s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 43249 LIMIT 1 [ RunTime:0.007886s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.009073s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5W-USF_NUKJBnecuafFNiYo' , '结束充电' , '{\"touser\":\"oCmeh5W-USF_NUKJBnecuafFNiYo\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"眉山柏林谷\"},\"time4\":{\"value\":\"2025-07-29 22:17:42\"},\"time3\":{\"value\":\"2025-07-29 23:58:50\"},\"thing5\":{\"value\":\"您的订单【2940245】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=2940245\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 6888efba-2560e9c8-6361e65d\"}' , '2025-07-29 23:58:50') [ RunTime:0.007717s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008634s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0313' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YE4G0313\",\"SIDS\":\"BJ000323\",\"CZ\":\"4\",\"DH\":\"2940245\",\"POW\":\"90\",\"DL\":\"0.1829\",\"TIM\":\"101\",\"MSG\":\"8\",\"POWs\":\"2940245\",\"MONEY\":\"40\",\"MSG2\":\"检测到插座无充电器结束订单\"}' , '{\"Z\":\"206\",\"IDS\":\"YE4G0313\",\"SIDS\":\"BJ000323\",\"CZ\":\"4\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-07-29 23:58:50') [ RunTime:0.007861s ] [ error ] [8]未定义数组索引: remark[D:\www\api\application\comm\model\Consume.php:449] --------------------------------------------------------------- [2025-07-29T23:58:51+08:00] 39.144.137.250 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.549553s] [吞吐率:1.82req/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' => 'oCmeh5QYPeIwILHXc2Ems3bLc8gI', '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.59(0x18003b2e) 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' => '2131209', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010519s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008615s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007077s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008395s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5QYPeIwILHXc2Ems3bLc8gI' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007092s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5QYPeIwILHXc2Ems3bLc8gI' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007007s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008296s ] [ sql ] [ SQL ] SELECT `id`,`state`,`src_by`,`pay_money`,`order_sn`,`pay_config` FROM `tp_comm_consume` WHERE `id` = 2131209 LIMIT 1 [ RunTime:0.007092s ] [ 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-07-29T23:58:58+08:00] 140.207.54.77 POST api.scyeby.com/public/index.php/index/payment/wxnotify.html [运行时间:0.746175s] [吞吐率:1.34req/s] [内存消耗:4,124.45kb] [文件加载: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.011205s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008831s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007486s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_pay` [ RunTime:0.008824s ] [ sql ] [ SQL ] INSERT INTO `tp_log_pay` (`trade_no` , `content` , `result` , `ctime`) VALUES ('4200002792202507294793471096' , '{\"appid\":\"wx9d3af783c5718533\",\"attach\":\"2131209\",\"bank_type\":\"OTHERS\",\"cash_fee\":\"300\",\"fee_type\":\"CNY\",\"is_subscribe\":\"N\",\"mch_id\":\"1511337021\",\"nonce_str\":\"5f20ce52ed23d3996c5da8e2643b6b13\",\"openid\":\"oCmeh5QYPeIwILHXc2Ems3bLc8gI\",\"out_trade_no\":\"Y20250729235850725411\",\"result_code\":\"SUCCESS\",\"return_code\":\"SUCCESS\",\"sign\":\"1CA796F483ACFAAEBDADE1B35DB51603\",\"time_end\":\"20250729235857\",\"total_fee\":\"300\",\"trade_type\":\"JSAPI\",\"transaction_id\":\"4200002792202507294793471096\"}' , '[]' , '2025-07-29 23:58:58') [ RunTime:0.007440s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008685s ] [ sql ] [ SQL ] SELECT `id`,`state`,`ctime`,`details`,`src_by`,`order_money`,`rate` FROM `tp_comm_consume` WHERE `id` = 2131209 LIMIT 1 [ RunTime:0.008625s ] [ sql ] [ SQL ] UPDATE `tp_comm_consume` SET `state` = 9 , `payment_code` = 'wxpay' , `trade_no` = '4200002792202507294793471096' WHERE `id` = 2131209 [ RunTime:0.009593s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008859s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2940429 LIMIT 1 [ RunTime:0.007511s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `state` = 1 , `payment_code` = 'wxpay' , `trade_no` = '4200002792202507294793471096' WHERE `id` = 2940429 [ RunTime:0.008151s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008625s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0046' , 'QY_101' , '{\"Z\":\"101\",\"IDS\":\"YE4G0046\",\"SIDS\":\"CH100037\",\"CZ\":\"7\",\"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\":\"2940429\",\"ZMONEY\":\"300\"}' , '{\"state\":\"1\"}' , '2025-07-29 23:58:58') [ RunTime:0.008178s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008791s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 958 LIMIT 1 [ RunTime:0.007435s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008661s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007500s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008631s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 44276 LIMIT 1 [ RunTime:0.007443s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008913s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5QYPeIwILHXc2Ems3bLc8gI' , '开始充电' , '{\"touser\":\"oCmeh5QYPeIwILHXc2Ems3bLc8gI\",\"template_id\":\"Agy1VhMUNj0Ts8jwvjW_UqGEDJOg0Y0-39j6y8nhpRg\",\"data\":{\"thing2\":{\"value\":\"蓝水湾\"},\"character_string8\":{\"value\":\"YE4G0046(CH100037)\"},\"character_string9\":{\"value\":\"No.7\"},\"character_string6\":{\"value\":2940429},\"time3\":{\"value\":\"2025-07-29 23:58:50\"}},\"page\":\"\\/pages\\/orders\\/chargeing?order_id=2940429\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 6888efc2-5257359e-1b750b47\"}' , '2025-07-29 23:58:58') [ RunTime:0.007722s ] [ sql ] [ SQL ] UPDATE `tp_log_pay` SET `result` = '{\"code\":200}' WHERE `trade_no` = '4200002792202507294793471096' [ RunTime:0.007415s ] --------------------------------------------------------------- [2025-07-29T23:59:01+08:00] 39.144.137.250 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.138615s] [吞吐率:7.21req/s] [内存消耗:3,860.45kb] [文件加载: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' => 'oCmeh5QYPeIwILHXc2Ems3bLc8gI', '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.59(0x18003b2e) 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.018758s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.009084s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007622s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.009047s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5QYPeIwILHXc2Ems3bLc8gI' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007537s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5QYPeIwILHXc2Ems3bLc8gI' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007557s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_park_orders` [ RunTime:0.008949s ] [ 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` = 44276 AND `state` IN (1,8) ORDER BY `state` ASC,`id` DESC LIMIT 30 [ RunTime:0.021758s ] --------------------------------------------------------------- [2025-07-29T23:59:01+08:00] 39.144.137.250 POST api.scyeby.com/public/index.php/index/member/index [运行时间:0.281642s] [吞吐率:3.55req/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' => 'oCmeh5QYPeIwILHXc2Ems3bLc8gI', '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.59(0x18003b2e) 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' => 'CH100037', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010517s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008387s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006901s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008130s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5QYPeIwILHXc2Ems3bLc8gI' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006934s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5QYPeIwILHXc2Ems3bLc8gI' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007581s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_socket` [ RunTime:0.008172s ] [ sql ] [ SQL ] SELECT `equi_id`,`num`,`socket_list`,`name` FROM `tp_charge_socket` WHERE `code` = 'CH100037' [ RunTime:0.009582s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.008265s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`brand`,`site_id` FROM `tp_charge_equi` WHERE `id` = 456 LIMIT 1 [ RunTime:0.006857s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008119s ] [ sql ] [ SQL ] SELECT `id`,`name`,`state`,`server_tel` FROM `tp_comm_site` WHERE `id` = 958 LIMIT 1 [ RunTime:0.006906s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008360s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 958 LIMIT 1 [ RunTime:0.006832s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.007985s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 958 LIMIT 1 [ RunTime:0.006866s ] --------------------------------------------------------------- [2025-07-29T23:59:47+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间:0.595904s] [吞吐率:1.68req/s] [内存消耗:3,948.74kb] [文件加载: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' => 'YE4G0026', 'SIDS' => 'BJ000158', 'CZ' => '8', 'DH' => '2939648', 'POW' => '108', 'DL' => '0.3884', 'TIM' => '274', 'MSG' => '8', 'POWs' => '2939648', 'MONEY' => '97', 'MSG2' => '5分钟时间无功率自动关闭充电', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009789s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007922s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006590s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008211s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2939648 LIMIT 1 [ RunTime:0.006681s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.007773s ] [ sql ] [ SQL ] SELECT `total_elec`,`yet_elec`,`total_time`,`yet_time`,`total_num`,`yet_num` FROM `tp_charge_month` WHERE `id` = 81838 LIMIT 1 [ RunTime:0.007204s ] [ sql ] [ SQL ] UPDATE `tp_charge_month` SET `yet_time` = 68.76 WHERE `id` = 81838 [ RunTime:0.006886s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025072919245917537882996166' , `order_money` = 0 , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 274 , `elec_num` = 0.42724 , `power_num` = 108 , `finish` = 8 , `state` = 9 , `other` = '{\"month_id\":81838,\"finish_text\":\"5分钟时间无功率自动关闭充电\",\"POWs\":\"2939648\",\"sj_elec\":\"0.3884\"}' , `finish_time` = '2025-07-29 23:59:46' , `js_result` = '[]' WHERE `id` = 2939648 [ RunTime:0.006981s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007775s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 965 LIMIT 1 [ RunTime:0.006548s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008108s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006636s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.007661s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 17230 LIMIT 1 [ RunTime:0.007339s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008061s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5SiLGEZCucRuG5r6bK01vo0' , '结束充电' , '{\"touser\":\"oCmeh5SiLGEZCucRuG5r6bK01vo0\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"润新花园B区一号车库\"},\"time4\":{\"value\":\"2025-07-29 19:24:59\"},\"time3\":{\"value\":\"2025-07-29 23:59:47\"},\"thing5\":{\"value\":\"您的订单【2939648】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=2939648\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 6888eff2-3431f82d-332cf5c1\"}' , '2025-07-29 23:59:47') [ RunTime:0.006927s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.007724s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0026' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YE4G0026\",\"SIDS\":\"BJ000158\",\"CZ\":\"8\",\"DH\":\"2939648\",\"POW\":\"108\",\"DL\":\"0.3884\",\"TIM\":\"274\",\"MSG\":\"8\",\"POWs\":\"2939648\",\"MONEY\":\"97\",\"MSG2\":\"5分钟时间无功率自动关闭充电\"}' , '{\"Z\":\"206\",\"IDS\":\"YE4G0026\",\"SIDS\":\"BJ000158\",\"CZ\":\"8\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-07-29 23:59:47') [ RunTime:0.007027s ]