--------------------------------------------------------------- [2025-08-01T23:53:23+08:00] 39.144.137.81 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.114471s] [吞吐率：8.74req/s] [内存消耗：3,860.42kb] [文件加载：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' => 'oCmeh5Wxsf3RF0ZtSceQB2H_nLEw', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.60(0x18003c32) NetType/4G Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/park/getLists', 'host' => 'main', 'pageSize' => '15', 'page_num' => '1', 'state' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.012106s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008924s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007591s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008886s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5Wxsf3RF0ZtSceQB2H_nLEw' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007539s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5Wxsf3RF0ZtSceQB2H_nLEw' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007501s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_park_orders` [ RunTime:0.009944s ] [ 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` = 46667 AND `state` IN (1,8) ORDER BY `state` ASC,`id` DESC LIMIT 30 [ RunTime:0.009079s ] --------------------------------------------------------------- [2025-08-01T23:53:23+08:00] 39.144.137.81 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.297955s] [吞吐率：3.36req/s] [内存消耗：4,079.04kb] [文件加载：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' => 'oCmeh5Wxsf3RF0ZtSceQB2H_nLEw', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.60(0x18003c32) NetType/4G Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/getChargeData', 'host' => 'main', 'pageSize' => '15', 'sids' => 'BJ000120', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.017201s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008963s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.010794s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008898s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5Wxsf3RF0ZtSceQB2H_nLEw' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007565s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5Wxsf3RF0ZtSceQB2H_nLEw' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007463s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_socket` [ RunTime:0.008799s ] [ sql ] [ SQL ] SELECT `equi_id`,`num`,`socket_list`,`name` FROM `tp_charge_socket` WHERE `code` = 'BJ000120' [ RunTime:0.009537s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.008635s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`brand`,`site_id` FROM `tp_charge_equi` WHERE `id` = 167 LIMIT 1 [ RunTime:0.008144s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008812s ] [ sql ] [ SQL ] SELECT `id`,`name`,`state`,`server_tel` FROM `tp_comm_site` WHERE `id` = 949 LIMIT 1 [ RunTime:0.007164s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008757s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 949 LIMIT 1 [ RunTime:0.007143s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.008809s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 949 LIMIT 1 [ RunTime:0.007263s ] --------------------------------------------------------------- [2025-08-01T23:53:40+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.795224s] [吞吐率：1.26req/s] [内存消耗：4,376.51kb] [文件加载：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' => 'GX4G0097', 'SIDS' => 'DD0AF376', 'IC' => '2709369051', 'CZ' => '5', 'CS' => '1', 'TY' => '1', 'MXHao' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010567s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008354s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007017s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.008579s ] [ sql ] [ SQL ] SELECT `site_id`,`brand` FROM `tp_charge_equi` WHERE `equi_ids` = 'GX4G0097' LIMIT 1 [ RunTime:0.007068s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008380s ] [ sql ] [ SQL ] SELECT `relation_site_ids` FROM `tp_comm_site` WHERE `id` = 975 LIMIT 1 [ RunTime:0.006986s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.008613s ] [ sql ] [ SQL ] SELECT `start_time`,`id`,`total_elec`,`yet_elec`,total_elec-yet_elec sy_elec,`total_time`,`yet_time`,total_time-yet_time sy_time,`total_num`,`yet_num`,total_num-yet_num sy_num FROM `tp_charge_month` WHERE `site_id` = 975 AND `icard` = '2709369051' AND `start_time` <= '2025-08-01' AND `end_time` > '2025-08-01' [ RunTime:0.008636s ] [ 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` = '2709369051' AND `start_time` <= '2025-08-01' AND `end_time` >= '2025-08-01' [ RunTime:0.007105s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008490s ] [ sql ] [ SQL ] SELECT total_money-yet_money sy_money,`icard`,`member_id`,`state`,`park_end` FROM `tp_comm_icard` WHERE `site_id` = 975 AND `icard` = '2709369051' ORDER BY `id` ASC [ RunTime:0.008085s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008259s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 975 [ RunTime:0.006963s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008370s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`sids`,`socket_num` FROM `tp_charge_orders` WHERE `icard` = '2709369051' AND `site_id` = 975 AND `state` = 1 [ RunTime:0.010068s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.008174s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 975 LIMIT 1 [ RunTime:0.006951s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 975 [ RunTime:0.006947s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008172s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 8871 LIMIT 1 [ RunTime:0.006976s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = 'GX4G0097' AND `state` = 1 AND `sids` = 'DD0AF376' AND `socket_num` = 5 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.008076s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 975 LIMIT 1 [ RunTime:0.006962s ] [ 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.007111s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008121s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007261s ] [ sql ] [ SQL ] INSERT INTO `tp_charge_orders` (`agent_id` , `site_id` , `order_sn` , `icard` , `state` , `member_id` , `member_mobile` , `equi_ids` , `socket_num` , `socket_no` , `sids` , `pay_money` , `ctime` , `valid_time` , `price_info` , `brand` , `value` , `other` , `system`) VALUES (438 , 975 , '20250801235339802755' , '2709369051' , 0 , 8871 , '13880146424' , 'GX4G0097' , 5 , 0 , 'DD0AF376' , '8.79' , '2025-08-01 23:53:39' , 1754099619 , '{\"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 , '[]' , 'main') [ RunTime:0.007355s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2947411 LIMIT 1 [ RunTime:0.007012s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `state` = 1 , `payment_code` = 'icardyue' , `trade_no` = 'HD2025080123533917540636194380' WHERE `id` = 2947411 [ RunTime:0.007313s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008185s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('GX4G0097' , 'QY_101' , '{\"Z\":\"101\",\"IDS\":\"GX4G0097\",\"SIDS\":\"DD0AF376\",\"CZ\":\"5\",\"MODEL\":\"8\",\"TIM\":\"600\",\"DL\":\"1000\",\"MONEY\":\"879\",\"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\":\"2947411\",\"ZMONEY\":\"879\"}' , '{\"state\":\"1\"}' , '2025-08-01 23:53:39') [ RunTime:0.006931s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 975 LIMIT 1 [ RunTime:0.007272s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008207s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.010432s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 8871 LIMIT 1 [ RunTime:0.006936s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008415s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5XwLPWFQ_p5kSPw54EVW9OQ' , '开始充电' , '{\"touser\":\"oCmeh5XwLPWFQ_p5kSPw54EVW9OQ\",\"template_id\":\"Agy1VhMUNj0Ts8jwvjW_UqGEDJOg0Y0-39j6y8nhpRg\",\"data\":{\"thing2\":{\"value\":\"缤纷\"},\"character_string8\":{\"value\":\"GX4G0097（DD0AF376）\"},\"character_string9\":{\"value\":\"No.5\"},\"character_string6\":{\"value\":2947411},\"time3\":{\"value\":\"2025-08-01 23:53:39\"}},\"page\":\"\\/pages\\/orders\\/chargeing?order_id=2947411\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 688ce303-4280130e-5ce71949\"}' , '2025-08-01 23:53:40') [ RunTime:0.007224s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('GX4G0097' , 'QY_207' , '{\"Z\":\"207\",\"IDS\":\"GX4G0097\",\"SIDS\":\"DD0AF376\",\"IC\":\"2709369051\",\"CZ\":\"5\",\"CS\":\"1\",\"TY\":\"1\",\"MXHao\":\"1\"}' , '{\"Z\":\"207\",\"IDS\":\"GX4G0097\",\"SIDS\":\"DD0AF376\",\"CZ\":\"5\",\"IC\":\"2709369051\",\"MONEY\":\"879\",\"MXHao\":\"1\",\"state\":\"1\",\"msg\":\"5\",\"msg2\":\"45\",\"txt\":\"开电成功\"}' , '2025-08-01 23:53:40') [ RunTime:0.007284s ] [ error ] [8]未定义数组索引: msg[D:\www\api\application\charge\model\Api.php:373] --------------------------------------------------------------- [2025-08-01T23:54:21+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.751799s] [吞吐率：1.33req/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' => '170', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => 'YE4G0023', 'SIDS' => '8A086B89', 'CZ' => '6', 'DH' => '2946018', 'POW' => '146', 'DL' => '0.8701', 'TIM' => '440', 'MSG' => '10', 'POWs' => '2946018', 'MONEY' => '0', 'MSG2' => '充满停止', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.018447s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008514s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007151s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008356s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2946018 LIMIT 1 [ RunTime:0.007925s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008569s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 948 [ RunTime:0.007330s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008351s ] [ sql ] [ SQL ] SELECT `id`,`total_money`,`yet_money` FROM `tp_comm_icard` WHERE `site_id` = 948 AND `icard` = '3475217890' LIMIT 1 [ RunTime:0.007597s ] [ sql ] [ SQL ] UPDATE `tp_comm_icard` SET `yet_money` = 192.07 , `uptime` = 1754063660 WHERE `id` = 1097 [ RunTime:0.007372s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008244s ] [ sql ] [ SQL ] SELECT 948,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 948 [ RunTime:0.007038s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.008260s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 948 [ RunTime:0.007084s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008324s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007499s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008310s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007129s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008259s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007179s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008653s ] [ 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 , 'Y20250801235420417340' , '3475217890' , 948 , 17582 , 17582 , '0.92' , '0.92' , 'charge_temp' , '2025-08-01 16:33:03' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '刷卡充电' , '2025-08' , '2025-08-01' , NULL , '{\"sql\":\"UPDATE `tp_comm_icard` SET `yet_money` = 192.07 , `uptime` = 1754063660 WHERE `id` = 1097\",\"icard\":{\"id\":1097,\"total_money\":\"241.80\",\"yet_money\":\"191.15\"}}' , 'icardyue' , 'HD2025080116330317540371839918' , 'main') [ RunTime:0.008012s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025080116330317540371839918' , `order_money` = '0.92' , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 440 , `elec_num` = 0.95711 , `power_num` = 146 , `finish` = 10 , `state` = 9 , `other` = '{\"finish_text\":\"充满停止\",\"POWs\":\"2946018\",\"sj_elec\":\"0.8701\"}' , `finish_time` = '2025-08-01 23:54:20' , `js_result` = '{\"money\":\"0.92\",\"num\":0.95711,\"first_price\":\"0.96\",\"first_time\":\"1\",\"dw_price\":0.96,\"by_card_price\":0}' WHERE `id` = 2946018 [ RunTime:0.007161s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 948 LIMIT 1 [ RunTime:0.007102s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007157s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008609s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 17582 LIMIT 1 [ RunTime:0.008378s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008636s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5WebhArGIDMW18QCRne8Amk' , '结束充电' , '{\"touser\":\"oCmeh5WebhArGIDMW18QCRne8Amk\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"孔雀城单独充电\"},\"time4\":{\"value\":\"2025-08-01 16:33:03\"},\"time3\":{\"value\":\"2025-08-01 23:54:20\"},\"thing5\":{\"value\":\"您的订单【2946018】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=2946018\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 688ce32c-6129a32d-77e781f2\"}' , '2025-08-01 23:54:21') [ RunTime:0.008514s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008199s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0023' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YE4G0023\",\"SIDS\":\"8A086B89\",\"CZ\":\"6\",\"DH\":\"2946018\",\"POW\":\"146\",\"DL\":\"0.8701\",\"TIM\":\"440\",\"MSG\":\"10\",\"POWs\":\"2946018\",\"MONEY\":\"0\",\"MSG2\":\"充满停止\"}' , '{\"Z\":\"206\",\"IDS\":\"YE4G0023\",\"SIDS\":\"8A086B89\",\"CZ\":\"6\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-01 23:54:21') [ RunTime:0.007102s ] [ error ] [8]未定义数组索引: remark[D:\www\api\application\comm\model\Consume.php:449] --------------------------------------------------------------- [2025-08-01T23:54:36+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.399395s] [吞吐率：2.50req/s] [内存消耗：4,373.22kb] [文件加载：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' => 'YE4G0154', 'SIDS' => '940B8D0A', 'IC' => '2708939595', 'CZ' => '6', 'CS' => '1', 'TY' => '1', 'MXHao' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009657s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007997s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006404s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.007622s ] [ sql ] [ SQL ] SELECT `site_id`,`brand` FROM `tp_charge_equi` WHERE `equi_ids` = 'YE4G0154' LIMIT 1 [ RunTime:0.007759s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007599s ] [ sql ] [ SQL ] SELECT `relation_site_ids` FROM `tp_comm_site` WHERE `id` = 939 LIMIT 1 [ RunTime:0.007073s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.007480s ] [ 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` = 939 AND `icard` = '2708939595' AND `start_time` <= '2025-08-01' AND `end_time` > '2025-08-01' [ RunTime:0.007337s ] [ 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` = '2708939595' AND `start_time` <= '2025-08-01' AND `end_time` >= '2025-08-01' [ RunTime:0.006448s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.007624s ] [ sql ] [ SQL ] SELECT total_money-yet_money sy_money,`icard`,`member_id`,`state`,`park_end` FROM `tp_comm_icard` WHERE `site_id` = 939 AND `icard` = '2708939595' ORDER BY `id` ASC [ RunTime:0.007609s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.007634s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 939 [ RunTime:0.007248s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008839s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`sids`,`socket_num` FROM `tp_charge_orders` WHERE `icard` = '2708939595' AND `site_id` = 939 AND `state` = 1 [ RunTime:0.011998s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.008064s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 939 LIMIT 1 [ RunTime:0.006932s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 939 [ RunTime:0.006401s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.007621s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 48287 LIMIT 1 [ RunTime:0.006848s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = 'YE4G0154' AND `state` = 1 AND `sids` = '940B8D0A' AND `socket_num` = 6 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.023299s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 939 LIMIT 1 [ RunTime:0.006394s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.007653s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006816s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.007847s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006388s ] [ 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 , 939 , '20250801235436527025' , '2708939595' , 0 , 48287 , '17882151474' , 'YE4G0154' , 6 , 0 , '940B8D0A' , 10 , '2025-08-01 23:54:36' , 1754099676 , '{\"charge_type\":\"8\",\"start_power\":[\"0\",\"201\",\"301\",\"401\",\"501\",\"601\",\"701\",\"801\",\"1001\",\"2201\"],\"end_power\":[\"200\",\"300\",\"400\",\"500\",\"600\",\"700\",\"800\",\"1000\",\"2200\",\"3600\"],\"price\":[\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\"],\"time\":[\"0.2\",\"0.25\",\"0.3\",\"0.4\",\"0.5\",\"0.6\",\"0.7\",\"0.8\",\"0.9\",\"1.0\"]}' , 'qy' , 10 , '[]' , 'main') [ RunTime:0.006866s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2947412 LIMIT 1 [ RunTime:0.006503s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `state` = 1 , `payment_code` = 'icardyue' , `trade_no` = 'HD2025080123543617540636763608' WHERE `id` = 2947412 [ RunTime:0.006928s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.007712s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0154' , 'QY_101' , '{\"Z\":\"101\",\"IDS\":\"YE4G0154\",\"SIDS\":\"940B8D0A\",\"CZ\":\"6\",\"MODEL\":\"8\",\"TIM\":\"600\",\"DL\":\"1000\",\"MONEY\":\"1000\",\"LIST\":\"0_200_579_20,201_300_579_25,301_400_579_30,401_500_579_40,501_600_579_50,601_700_579_60,701_800_579_70,801_1000_579_80,1001_2200_579_90,2201_3600_579_100\",\"DH\":\"2947412\",\"ZMONEY\":\"9947\"}' , '{\"state\":\"1\"}' , '2025-08-01 23:54:36') [ RunTime:0.011270s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 939 LIMIT 1 [ RunTime:0.006377s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.007715s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.012646s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 48287 LIMIT 1 [ RunTime:0.006378s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0154' , 'QY_207' , '{\"Z\":\"207\",\"IDS\":\"YE4G0154\",\"SIDS\":\"940B8D0A\",\"IC\":\"2708939595\",\"CZ\":\"6\",\"CS\":\"1\",\"TY\":\"1\",\"MXHao\":\"1\"}' , '{\"Z\":\"207\",\"IDS\":\"YE4G0154\",\"SIDS\":\"940B8D0A\",\"CZ\":\"6\",\"IC\":\"2708939595\",\"MONEY\":\"9947\",\"MXHao\":\"1\",\"state\":\"1\",\"msg\":\"5\",\"msg2\":\"45\",\"txt\":\"开电成功\"}' , '2025-08-01 23:54:36') [ RunTime:0.007002s ] [ error ] [8]未定义数组索引: msg[D:\www\api\application\charge\model\Api.php:373] --------------------------------------------------------------- [2025-08-01T23:54:52+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.735526s] [吞吐率：1.36req/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' => '198', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => 'GX4G0124', 'SIDS' => '900B65E6', 'CZ' => '4', 'DH' => '2946874', 'POW' => '259', 'DL' => '0.9041', 'TIM' => '201', 'MSG' => '8', 'POWs' => '2946874', 'MONEY' => '132', 'MSG2' => '检测到插座无充电器结束订单', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.015101s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008162s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006800s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008047s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2946874 LIMIT 1 [ RunTime:0.006969s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.007995s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 975 [ RunTime:0.006933s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008362s ] [ sql ] [ SQL ] SELECT `id`,`total_money`,`yet_money` FROM `tp_comm_icard` WHERE `site_id` = 975 AND `icard` = '1590829246' LIMIT 1 [ RunTime:0.007456s ] [ sql ] [ SQL ] UPDATE `tp_comm_icard` SET `yet_money` = 986.74 , `uptime` = 1754063692 WHERE `id` = 9032 [ RunTime:0.007037s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007950s ] [ sql ] [ SQL ] SELECT 975,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 975 [ RunTime:0.006716s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.007961s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 975 [ RunTime:0.007712s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008511s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006722s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008076s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006704s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.007961s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006809s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.009062s ] [ 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 , 'Y20250801235452750623' , '1590829246' , 975 , 8869 , 8869 , '1.38' , '1.38' , 'charge_temp' , '2025-08-01 20:33:13' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '刷卡充电' , '2025-08' , '2025-08-01' , NULL , '{\"sql\":\"UPDATE `tp_comm_icard` SET `yet_money` = 986.74 , `uptime` = 1754063692 WHERE `id` = 9032\",\"icard\":{\"id\":9032,\"total_money\":\"1073.00\",\"yet_money\":\"985.36\"}}' , 'icardyue' , 'HD2025080120331317540515933506' , 'main') [ RunTime:0.011290s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025080120331317540515933506' , `order_money` = '1.38' , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 201 , `elec_num` = 0.99451 , `power_num` = 259 , `finish` = 8 , `state` = 9 , `other` = '{\"finish_text\":\"检测到插座无充电器结束订单\",\"POWs\":\"2946874\",\"sj_elec\":\"0.9041\"}' , `finish_time` = '2025-08-01 23:54:52' , `js_result` = '{\"money\":\"1.38\",\"elec_num\":0.99451,\"elec_price\":\"0.579\",\"timeNum\":4,\"server_price\":\"0.2\"}' WHERE `id` = 2946874 [ RunTime:0.007333s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 975 LIMIT 1 [ RunTime:0.007134s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006788s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.007942s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 8869 LIMIT 1 [ RunTime:0.007010s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008301s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5XM58I8uy-tI-wIjoxIN4vA' , '结束充电' , '{\"touser\":\"oCmeh5XM58I8uy-tI-wIjoxIN4vA\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"缤纷\"},\"time4\":{\"value\":\"2025-08-01 20:33:13\"},\"time3\":{\"value\":\"2025-08-01 23:54:52\"},\"thing5\":{\"value\":\"您的订单【2946874】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=2946874\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 688ce34c-20a7f657-0c84fb39\"}' , '2025-08-01 23:54:52') [ RunTime:0.010289s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008028s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('GX4G0124' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"GX4G0124\",\"SIDS\":\"900B65E6\",\"CZ\":\"4\",\"DH\":\"2946874\",\"POW\":\"259\",\"DL\":\"0.9041\",\"TIM\":\"201\",\"MSG\":\"8\",\"POWs\":\"2946874\",\"MONEY\":\"132\",\"MSG2\":\"检测到插座无充电器结束订单\"}' , '{\"Z\":\"206\",\"IDS\":\"GX4G0124\",\"SIDS\":\"900B65E6\",\"CZ\":\"4\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-01 23:54:52') [ RunTime:0.007099s ] [ error ] [8]未定义数组索引: remark[D:\www\api\application\comm\model\Consume.php:449] --------------------------------------------------------------- [2025-08-01T23:55:23+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.632160s] [吞吐率：1.58req/s] [内存消耗：3,948.53kb] [文件加载：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' => 'YEWKA023', 'SIDS' => 'CH100025', 'CZ' => '10', 'DH' => '2946357', 'POW' => '92', 'DL' => '0.3643', 'TIM' => '328', 'MSG' => '8', 'POWs' => '2946357', 'MONEY' => '111', 'MSG2' => '充满停止', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010564s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008654s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007084s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008329s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2946357 LIMIT 1 [ RunTime:0.007189s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.008489s ] [ sql ] [ SQL ] SELECT `total_elec`,`yet_elec`,`total_time`,`yet_time`,`total_num`,`yet_num` FROM `tp_charge_month` WHERE `id` = 88061 LIMIT 1 [ RunTime:0.007690s ] [ sql ] [ SQL ] UPDATE `tp_charge_month` SET `yet_time` = 47.28 WHERE `id` = 88061 [ RunTime:0.007683s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025080118253417540439343542' , `order_money` = 0 , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 328 , `elec_num` = 0.40073 , `power_num` = 92 , `finish` = 8 , `state` = 9 , `other` = '{\"month_id\":88061,\"finish_text\":\"充满停止\",\"POWs\":\"2946357\",\"sj_elec\":\"0.3643\"}' , `finish_time` = '2025-08-01 23:55:22' , `js_result` = '[]' WHERE `id` = 2946357 [ RunTime:0.007151s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008303s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 971 LIMIT 1 [ RunTime:0.007068s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008188s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.010583s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008430s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 18967 LIMIT 1 [ RunTime:0.007419s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008716s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5R6ESOuYkjYWpcc5aKUIABI' , '结束充电' , '{\"touser\":\"oCmeh5R6ESOuYkjYWpcc5aKUIABI\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"红枫林三期三号门\"},\"time4\":{\"value\":\"2025-08-01 18:25:34\"},\"time3\":{\"value\":\"2025-08-01 23:55:22\"},\"thing5\":{\"value\":\"您的订单【2946357】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=2946357\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 688ce36a-39f54561-2075f1ce\"}' , '2025-08-01 23:55:23') [ RunTime:0.007395s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008289s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEWKA023' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YEWKA023\",\"SIDS\":\"CH100025\",\"CZ\":\"10\",\"DH\":\"2946357\",\"POW\":\"92\",\"DL\":\"0.3643\",\"TIM\":\"328\",\"MSG\":\"8\",\"POWs\":\"2946357\",\"MONEY\":\"111\",\"MSG2\":\"充满停止\"}' , '{\"Z\":\"206\",\"IDS\":\"YEWKA023\",\"SIDS\":\"CH100025\",\"CZ\":\"10\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-01 23:55:23') [ RunTime:0.007114s ] --------------------------------------------------------------- [2025-08-01T23:56:35+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.682322s] [吞吐率：1.47req/s] [内存消耗：3,948.50kb] [文件加载：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' => '50088106', 'SIDS' => 'BJ000120', 'CZ' => '4', 'DH' => '2946477', 'POW' => '262', 'DL' => '0.8110', 'TIM' => '307', 'MSG' => '8', 'POWs' => '2946477', 'MONEY' => '166', 'MSG2' => '充满停止', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.015227s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008519s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007241s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008377s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2946477 LIMIT 1 [ RunTime:0.007166s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.008786s ] [ sql ] [ SQL ] SELECT `total_elec`,`yet_elec`,`total_time`,`yet_time`,`total_num`,`yet_num` FROM `tp_charge_month` WHERE `id` = 89747 LIMIT 1 [ RunTime:0.007414s ] [ sql ] [ SQL ] UPDATE `tp_charge_month` SET `yet_time` = 44.47 WHERE `id` = 89747 [ RunTime:0.007464s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025080118484517540453257994' , `order_money` = 0 , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 307 , `elec_num` = 0.8921 , `power_num` = 262 , `finish` = 8 , `state` = 9 , `other` = '{\"month_id\":89747,\"finish_text\":\"充满停止\",\"POWs\":\"2946477\",\"sj_elec\":\"0.8110\"}' , `finish_time` = '2025-08-01 23:56:34' , `js_result` = '[]' WHERE `id` = 2946477 [ RunTime:0.007115s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008394s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 949 LIMIT 1 [ RunTime:0.007052s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008268s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007216s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008268s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 48301 LIMIT 1 [ RunTime:0.007117s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008582s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5fmOdggvlOGIScQO00yYPGQ' , '结束充电' , '{\"touser\":\"oCmeh5fmOdggvlOGIScQO00yYPGQ\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"馨园\"},\"time4\":{\"value\":\"2025-08-01 18:48:45\"},\"time3\":{\"value\":\"2025-08-01 23:56:34\"},\"thing5\":{\"value\":\"您的订单【2946477】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=2946477\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 688ce3b2-4546bb48-2be46c16\"}' , '2025-08-01 23:56:35') [ RunTime:0.007429s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008380s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('50088106' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"50088106\",\"SIDS\":\"BJ000120\",\"CZ\":\"4\",\"DH\":\"2946477\",\"POW\":\"262\",\"DL\":\"0.8110\",\"TIM\":\"307\",\"MSG\":\"8\",\"POWs\":\"2946477\",\"MONEY\":\"166\",\"MSG2\":\"充满停止\"}' , '{\"Z\":\"206\",\"IDS\":\"50088106\",\"SIDS\":\"BJ000120\",\"CZ\":\"4\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-01 23:56:35') [ RunTime:0.007148s ] --------------------------------------------------------------- [2025-08-01T23:56:40+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.207409s] [吞吐率：4.82req/s] [内存消耗：3,896.55kb] [文件加载：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' => '197', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => '50063539', 'SIDS' => 'BJ000159', 'CZ' => '5', 'DH' => '2946750', 'POW' => '46', 'DL' => '0.1621', 'TIM' => '237', 'MSG' => '10', 'POWs' => '2946750', 'MONEY' => '0', 'MSG2' => '5分钟时间无功率自动关闭充电', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.018651s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008433s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007159s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008594s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2946750 LIMIT 1 [ RunTime:0.007191s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.008443s ] [ sql ] [ SQL ] SELECT `total_elec`,`yet_elec`,`total_time`,`yet_time`,`total_num`,`yet_num` FROM `tp_charge_month` WHERE `id` = 83410 LIMIT 1 [ RunTime:0.008520s ] [ sql ] [ SQL ] UPDATE `tp_charge_month` SET `yet_elec` = 1.76831 WHERE `id` = 83410 [ RunTime:0.007368s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025080119583017540495107613' , `order_money` = 0 , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 237 , `elec_num` = 0.17831 , `power_num` = 46 , `finish` = 10 , `state` = 9 , `other` = '{\"month_id\":83410,\"finish_text\":\"5分钟时间无功率自动关闭充电\",\"POWs\":\"2946750\",\"sj_elec\":\"0.1621\"}' , `finish_time` = '2025-08-01 23:56:40' , `js_result` = '[]' WHERE `id` = 2946750 [ RunTime:0.007225s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008656s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 987 LIMIT 1 [ RunTime:0.007078s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008232s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007167s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008482s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 7049 LIMIT 1 [ RunTime:0.007334s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008176s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('50063539' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"50063539\",\"SIDS\":\"BJ000159\",\"CZ\":\"5\",\"DH\":\"2946750\",\"POW\":\"46\",\"DL\":\"0.1621\",\"TIM\":\"237\",\"MSG\":\"10\",\"POWs\":\"2946750\",\"MONEY\":\"0\",\"MSG2\":\"5分钟时间无功率自动关闭充电\"}' , '{\"Z\":\"206\",\"IDS\":\"50063539\",\"SIDS\":\"BJ000159\",\"CZ\":\"5\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-01 23:56:40') [ RunTime:0.007112s ] --------------------------------------------------------------- [2025-08-01T23:57:34+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.908836s] [吞吐率：1.10req/s] [内存消耗：4,376.55kb] [文件加载：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' => 'YEW00002', 'SIDS' => 'BJ000184', 'IC' => '3475745698', 'CZ' => '2', 'CS' => '1', 'TY' => '1', 'MXHao' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010854s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008790s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007250s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.008370s ] [ sql ] [ SQL ] SELECT `site_id`,`brand` FROM `tp_charge_equi` WHERE `equi_ids` = 'YEW00002' LIMIT 1 [ RunTime:0.007265s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008668s ] [ sql ] [ SQL ] SELECT `relation_site_ids` FROM `tp_comm_site` WHERE `id` = 970 LIMIT 1 [ RunTime:0.007446s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.008407s ] [ 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` = 970 AND `icard` = '3475745698' AND `start_time` <= '2025-08-01' AND `end_time` > '2025-08-01' [ RunTime:0.008505s ] [ 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` = '3475745698' AND `start_time` <= '2025-08-01' AND `end_time` >= '2025-08-01' [ RunTime:0.007223s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008470s ] [ sql ] [ SQL ] SELECT total_money-yet_money sy_money,`icard`,`member_id`,`state`,`park_end` FROM `tp_comm_icard` WHERE `site_id` = 970 AND `icard` = '3475745698' ORDER BY `id` ASC [ RunTime:0.009750s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008568s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 970 [ RunTime:0.007326s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008576s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`sids`,`socket_num` FROM `tp_charge_orders` WHERE `icard` = '3475745698' AND `site_id` = 970 AND `state` = 1 [ RunTime:0.010846s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.009233s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 970 LIMIT 1 [ RunTime:0.007502s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 970 [ RunTime:0.007334s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008536s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 5560 LIMIT 1 [ RunTime:0.007573s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = 'YEW00002' AND `state` = 1 AND `sids` = 'BJ000184' AND `socket_num` = 2 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.008594s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 970 LIMIT 1 [ RunTime:0.007757s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008686s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007560s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008443s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007417s ] [ 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 , 970 , '20250801235734827484' , '3475745698' , 0 , 5560 , '13547023327' , 'YEW00002' , 2 , 0 , 'BJ000184' , 10 , '2025-08-01 23:57:34' , 1754099854 , '{\"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 , '[]' , 'main') [ RunTime:0.008136s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2947413 LIMIT 1 [ RunTime:0.008053s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `state` = 1 , `payment_code` = 'icardyue' , `trade_no` = 'HD2025080123573417540638546478' WHERE `id` = 2947413 [ RunTime:0.007559s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.012307s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEW00002' , 'QY_101' , '{\"Z\":\"101\",\"IDS\":\"YEW00002\",\"SIDS\":\"BJ000184\",\"CZ\":\"2\",\"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\":\"2947413\",\"ZMONEY\":\"2212\"}' , '{\"state\":\"1\"}' , '2025-08-01 23:57:34') [ RunTime:0.007475s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 970 LIMIT 1 [ RunTime:0.007217s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008732s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007326s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 5560 LIMIT 1 [ RunTime:0.008406s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.009485s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5SMuEbj_mdE0spPkaB5S0EQ' , '开始充电' , '{\"touser\":\"oCmeh5SMuEbj_mdE0spPkaB5S0EQ\",\"template_id\":\"Agy1VhMUNj0Ts8jwvjW_UqGEDJOg0Y0-39j6y8nhpRg\",\"data\":{\"thing2\":{\"value\":\"东汽馨园7栋\"},\"character_string8\":{\"value\":\"YEW00002（BJ000184）\"},\"character_string9\":{\"value\":\"No.2\"},\"character_string6\":{\"value\":2947413},\"time3\":{\"value\":\"2025-08-01 23:57:34\"}},\"page\":\"\\/pages\\/orders\\/chargeing?order_id=2947413\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 688ce3ee-10fe743e-6ef75129\"}' , '2025-08-01 23:57:34') [ RunTime:0.007571s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEW00002' , 'QY_207' , '{\"Z\":\"207\",\"IDS\":\"YEW00002\",\"SIDS\":\"BJ000184\",\"IC\":\"3475745698\",\"CZ\":\"2\",\"CS\":\"1\",\"TY\":\"1\",\"MXHao\":\"1\"}' , '{\"Z\":\"207\",\"IDS\":\"YEW00002\",\"SIDS\":\"BJ000184\",\"CZ\":\"2\",\"IC\":\"3475745698\",\"MONEY\":\"2212\",\"MXHao\":\"1\",\"state\":\"1\",\"msg\":\"5\",\"msg2\":\"45\",\"txt\":\"开电成功\"}' , '2025-08-01 23:57:34') [ RunTime:0.007221s ] [ error ] [8]未定义数组索引: msg[D:\www\api\application\charge\model\Api.php:373] --------------------------------------------------------------- [2025-08-01T23:57:53+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.309371s] [吞吐率：3.23req/s] [内存消耗：4,190.29kb] [文件加载：103] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-type' => 'application/json', 'host' => 'api.scyeby.com', 'content-length' => '200', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => 'YEWI0043', 'SIDS' => 'BJ000259', 'CZ' => '11', 'DH' => '2946345', 'POW' => '115', 'DL' => '0.3947', 'TIM' => '333', 'MSG' => '8', 'POWs' => '2946345', 'MONEY' => '112', 'MSG2' => '5分钟时间无功率自动关闭充电', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.018663s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008282s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007019s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008416s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2946345 LIMIT 1 [ RunTime:0.007056s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.012474s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 967 [ RunTime:0.007053s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008266s ] [ sql ] [ SQL ] SELECT `id`,`total_money`,`yet_money` FROM `tp_comm_icard` WHERE `site_id` = 967 AND `icard` = '3475322146' LIMIT 1 [ RunTime:0.007692s ] [ sql ] [ SQL ] UPDATE `tp_comm_icard` SET `yet_money` = 385.05 , `uptime` = 1754063873 WHERE `id` = 5443 [ RunTime:0.007189s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008723s ] [ sql ] [ SQL ] SELECT 967,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 967 [ RunTime:0.006928s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.008143s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 967 [ RunTime:0.007986s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008090s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007522s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008214s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007080s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008128s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007042s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008146s ] [ 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 , 'Y20250801235753771160' , '3475322146' , 967 , 4551 , 4551 , '1.15' , '1.15' , 'charge_temp' , '2025-08-01 18:23:07' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '刷卡充电' , '2025-08' , '2025-08-01' , NULL , '{\"sql\":\"UPDATE `tp_comm_icard` SET `yet_money` = 385.05 , `uptime` = 1754063873 WHERE `id` = 5443\",\"icard\":{\"id\":5443,\"total_money\":\"394.60\",\"yet_money\":\"383.90\"}}' , 'icardyue' , 'HD2025080118230717540437876906' , 'main') [ RunTime:0.007836s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025080118230717540437876906' , `order_money` = '1.15' , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 333 , `elec_num` = 0.43417 , `power_num` = 115 , `finish` = 8 , `state` = 9 , `other` = '{\"finish_text\":\"5分钟时间无功率自动关闭充电\",\"POWs\":\"2946345\",\"sj_elec\":\"0.3947\"}' , `finish_time` = '2025-08-01 23:57:53' , `js_result` = '{\"money\":\"1.15\",\"elec_num\":0.43417,\"elec_price\":\"0.579\",\"timeNum\":6,\"server_price\":\"0.15\"}' WHERE `id` = 2946345 [ RunTime:0.007038s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 967 LIMIT 1 [ RunTime:0.006932s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006987s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008107s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 4551 LIMIT 1 [ RunTime:0.007296s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008033s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEWI0043' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YEWI0043\",\"SIDS\":\"BJ000259\",\"CZ\":\"11\",\"DH\":\"2946345\",\"POW\":\"115\",\"DL\":\"0.3947\",\"TIM\":\"333\",\"MSG\":\"8\",\"POWs\":\"2946345\",\"MONEY\":\"112\",\"MSG2\":\"5分钟时间无功率自动关闭充电\"}' , '{\"Z\":\"206\",\"IDS\":\"YEWI0043\",\"SIDS\":\"BJ000259\",\"CZ\":\"11\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-01 23:57:53') [ RunTime:0.008230s ] [ error ] [8]未定义数组索引: remark[D:\www\api\application\comm\model\Consume.php:449] --------------------------------------------------------------- [2025-08-01T23:58:17+08:00] 117.173.84.158 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.082430s] [吞吐率：12.13req/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' => 'oCmeh5Q-3024LiWpP_evGxygbsdk', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 15; 24053PY09C Build/AQ3A.240912.001; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.168 Mobile Safari/537.36 XWEB/1380075 MMWEBSDK/20250503 MMWEBID/668 MicroMessenger/8.0.61.2880(0x28003D57) WeChat/arm64 Weixin NetType/WIFI 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.011939s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.009133s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007713s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.009243s ] [ sql ] [ SQL ] SELECT `site_name`,`site_logo`,`upload_config`,`regcms` FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007705s ] --------------------------------------------------------------- [2025-08-01T23:58:19+08:00] 117.173.84.158 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.115758s] [吞吐率：8.64req/s] [内存消耗：3,861.36kb] [文件加载：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' => 'oCmeh5Q-3024LiWpP_evGxygbsdk', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 15; 24053PY09C Build/AQ3A.240912.001; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.168 Mobile Safari/537.36 XWEB/1380075 MMWEBSDK/20250503 MMWEBID/668 MicroMessenger/8.0.61.2880(0x28003D57) WeChat/arm64 Weixin NetType/WIFI 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.021533s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008516s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007377s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.010077s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5Q-3024LiWpP_evGxygbsdk' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007032s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5Q-3024LiWpP_evGxygbsdk' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007538s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_park_orders` [ RunTime:0.008298s ] [ 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` = 47132 AND `state` IN (1,8) ORDER BY `state` ASC,`id` DESC LIMIT 30 [ RunTime:0.008640s ] --------------------------------------------------------------- [2025-08-01T23:58:20+08:00] 117.173.84.158 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.119486s] [吞吐率：8.37req/s] [内存消耗：3,923.41kb] [文件加载：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' => '71', 'content-type' => 'application/x-www-form-urlencoded', 'x-token' => 'oCmeh5Q-3024LiWpP_evGxygbsdk', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 15; 24053PY09C Build/AQ3A.240912.001; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.168 Mobile Safari/537.36 XWEB/1380075 MMWEBSDK/20250503 MMWEBID/668 MicroMessenger/8.0.61.2880(0x28003D57) WeChat/arm64 Weixin NetType/WIFI 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.016196s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008139s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007380s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.007964s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5Q-3024LiWpP_evGxygbsdk' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006744s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5Q-3024LiWpP_evGxygbsdk' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006754s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008006s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `member_id` = 47132 AND `state` = 1 AND `del` = 1 ORDER BY `state` ASC,`id` DESC LIMIT 30 [ RunTime:0.015776s ] --------------------------------------------------------------- [2025-08-01T23:58:20+08:00] 117.173.84.158 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.104835s] [吞吐率：9.54req/s] [内存消耗：3,923.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' => '71', 'content-type' => 'application/x-www-form-urlencoded', 'x-token' => 'oCmeh5Q-3024LiWpP_evGxygbsdk', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 15; 24053PY09C Build/AQ3A.240912.001; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.168 Mobile Safari/537.36 XWEB/1380075 MMWEBSDK/20250503 MMWEBID/668 MicroMessenger/8.0.61.2880(0x28003D57) WeChat/arm64 Weixin NetType/WIFI 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.010928s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008406s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007044s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008422s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5Q-3024LiWpP_evGxygbsdk' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007057s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5Q-3024LiWpP_evGxygbsdk' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007146s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008338s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `member_id` = 47132 AND `state` = 1 AND `del` = 1 ORDER BY `state` ASC,`id` DESC LIMIT 30 [ RunTime:0.009437s ] --------------------------------------------------------------- [2025-08-01T23:58:22+08:00] 117.173.84.158 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.103891s] [吞吐率：9.63req/s] [内存消耗：3,558.08kb] [文件加载：90] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '51', 'content-type' => 'application/x-www-form-urlencoded', 'x-token' => 'oCmeh5Q-3024LiWpP_evGxygbsdk', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 15; 24053PY09C Build/AQ3A.240912.001; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.168 Mobile Safari/537.36 XWEB/1380075 MMWEBSDK/20250503 MMWEBID/668 MicroMessenger/8.0.61.2880(0x28003D57) WeChat/arm64 Weixin NetType/WIFI Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/member/getInfo', 'host' => 'main', 'pageSize' => '15', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.011536s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.009128s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007679s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008828s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5Q-3024LiWpP_evGxygbsdk' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007575s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5Q-3024LiWpP_evGxygbsdk' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007638s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008836s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 47132 LIMIT 1 [ RunTime:0.008068s ] --------------------------------------------------------------- [2025-08-01T23:58:23+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.194248s] [吞吐率：5.15req/s] [内存消耗：3,901.09kb] [文件加载：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' => '261', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => '10145871', 'SIDS' => 'BJ000032', 'CZ' => '4', 'DH' => '2946787', 'POW' => '120', 'DL' => '0.3834', 'TIM' => '225', 'MSG' => '11', 'POWs' => '2946787', 'MONEY' => '187', 'MSG2' => '检测到插座无充电器结束订单', 'MSG3' => '模式4 MONEY=消费金额（分）', 'MODE' => '模式4', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010095s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008213s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006703s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008029s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2946787 LIMIT 1 [ RunTime:0.006867s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.007890s ] [ sql ] [ SQL ] SELECT `total_elec`,`yet_elec`,`total_time`,`yet_time`,`total_num`,`yet_num` FROM `tp_charge_month` WHERE `id` = 89371 LIMIT 1 [ RunTime:0.007471s ] [ sql ] [ SQL ] UPDATE `tp_charge_month` SET `yet_time` = 11.83 WHERE `id` = 89371 [ RunTime:0.007136s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025080120113217540502927303' , `order_money` = 0 , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 225 , `elec_num` = 0.42174 , `power_num` = 120 , `finish` = 11 , `state` = 9 , `other` = '{\"month_id\":89371,\"finish_text\":\"检测到插座无充电器结束订单\",\"POWs\":\"2946787\",\"sj_elec\":\"0.3834\"}' , `finish_time` = '2025-08-01 23:58:23' , `js_result` = '[]' WHERE `id` = 2946787 [ RunTime:0.006783s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008191s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 944 LIMIT 1 [ RunTime:0.006763s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008159s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007389s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008170s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 529 LIMIT 1 [ RunTime:0.007109s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.007943s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('10145871' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"10145871\",\"SIDS\":\"BJ000032\",\"CZ\":\"4\",\"DH\":\"2946787\",\"POW\":\"120\",\"DL\":\"0.3834\",\"TIM\":\"225\",\"MSG\":\"11\",\"POWs\":\"2946787\",\"MONEY\":\"187\",\"MSG2\":\"检测到插座无充电器结束订单\",\"MSG3\":\"模式4 MONEY=消费金额（分）\",\"MODE\":\"模式4\"}' , '{\"Z\":\"206\",\"IDS\":\"10145871\",\"SIDS\":\"BJ000032\",\"CZ\":\"4\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-01 23:58:23') [ RunTime:0.007424s ] --------------------------------------------------------------- [2025-08-01T23:58:25+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.620636s] [吞吐率：1.61req/s] [内存消耗：4,372.38kb] [文件加载：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' => '105', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '207', 'IDS' => '52915141', 'SIDS' => 'A40845EA', 'IC' => '2935942836', 'CZ' => '5', 'CS' => '255', 'TY' => '1', 'MXHao' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.012907s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008079s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006830s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.008012s ] [ sql ] [ SQL ] SELECT `site_id`,`brand` FROM `tp_charge_equi` WHERE `equi_ids` = '52915141' LIMIT 1 [ RunTime:0.006851s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008256s ] [ sql ] [ SQL ] SELECT `relation_site_ids` FROM `tp_comm_site` WHERE `id` = 956 LIMIT 1 [ RunTime:0.006692s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.008218s ] [ 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` = 956 AND `icard` = '2935942836' AND `start_time` <= '2025-08-01' AND `end_time` > '2025-08-01' [ RunTime:0.007261s ] [ 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` = '2935942836' AND `start_time` <= '2025-08-01' AND `end_time` >= '2025-08-01' [ RunTime:0.006839s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.007925s ] [ sql ] [ SQL ] SELECT total_money-yet_money sy_money,`icard`,`member_id`,`state`,`park_end` FROM `tp_comm_icard` WHERE `site_id` = 956 AND `icard` = '2935942836' ORDER BY `id` ASC [ RunTime:0.007863s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.007962s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 956 [ RunTime:0.006788s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.007944s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`sids`,`socket_num` FROM `tp_charge_orders` WHERE `icard` = '2935942836' AND `site_id` = 956 AND `state` = 1 [ RunTime:0.008978s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.007920s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 956 LIMIT 1 [ RunTime:0.006789s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 956 [ RunTime:0.006693s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.007996s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 2107 LIMIT 1 [ RunTime:0.007065s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = '52915141' AND `state` = 1 AND `sids` = 'A40845EA' AND `socket_num` = 5 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.008581s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 956 LIMIT 1 [ RunTime:0.006680s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008066s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006737s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008072s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006777s ] [ 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 , 956 , '20250801235825350841' , '2935942836' , 0 , 2107 , '13458610644' , '52915141' , 5 , 0 , 'A40845EA' , 10 , '2025-08-01 23:58:25' , 1754099905 , '{\"charge_type\":\"3\",\"start_power\":[\"0\",\"301\",\"601\",\"901\"],\"end_power\":[\"300\",\"600\",\"900\",\"0\"],\"price\":[\"0.01\",\"0.01\",\"0.01\",\"0.01\"],\"time\":[\"1\",\"2\",\"3\",\"4\"]}' , 'qy' , 4 , '[]' , 'main') [ RunTime:0.007206s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2947414 LIMIT 1 [ RunTime:0.006837s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `state` = 1 , `payment_code` = 'icardyue' , `trade_no` = 'HD2025080123582517540639059371' WHERE `id` = 2947414 [ RunTime:0.007137s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008086s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('52915141' , 'QY_101' , '{\"Z\":\"101\",\"IDS\":\"52915141\",\"SIDS\":\"A40845EA\",\"CZ\":\"5\",\"MODEL\":\"3\",\"TIM\":\"240\",\"DL\":\"400\",\"MONEY\":\"400\",\"LIST\":\"\",\"DH\":\"2947414\",\"ZMONEY\":\"4822\"}' , '{\"state\":\"1\"}' , '2025-08-01 23:58:25') [ RunTime:0.006773s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 956 LIMIT 1 [ RunTime:0.007300s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.007943s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.010423s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 2107 LIMIT 1 [ RunTime:0.006713s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('52915141' , 'QY_207' , '{\"Z\":\"207\",\"IDS\":\"52915141\",\"SIDS\":\"A40845EA\",\"IC\":\"2935942836\",\"CZ\":\"5\",\"CS\":\"255\",\"TY\":\"1\",\"MXHao\":\"1\"}' , '{\"Z\":\"207\",\"IDS\":\"52915141\",\"SIDS\":\"A40845EA\",\"CZ\":\"5\",\"IC\":\"2935942836\",\"MONEY\":\"4822\",\"MXHao\":\"1\",\"state\":\"1\",\"msg\":\"5\",\"msg2\":\"45\",\"txt\":\"开电成功\"}' , '2025-08-01 23:58:25') [ RunTime:0.006841s ] [ error ] [8]未定义数组索引: msg[D:\www\api\application\charge\model\Api.php:373] --------------------------------------------------------------- [2025-08-01T23:58:29+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.767424s] [吞吐率：1.30req/s] [内存消耗：4,240.83kb] [文件加载：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' => '170', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => 'S2917277', 'SIDS' => 'BJ000093', 'CZ' => '8', 'DH' => '2946308', 'POW' => '274', 'DL' => '1.0599', 'TIM' => '345', 'MSG' => '10', 'POWs' => '2946308', 'MONEY' => '0', 'MSG2' => '充满停止', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.011360s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.009788s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007581s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.010351s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2946308 LIMIT 1 [ RunTime:0.007749s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.009598s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 947 [ RunTime:0.007651s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008941s ] [ sql ] [ SQL ] SELECT `id`,`total_money`,`yet_money` FROM `tp_comm_icard` WHERE `site_id` = 947 AND `icard` = '3475313394' LIMIT 1 [ RunTime:0.008301s ] [ sql ] [ SQL ] UPDATE `tp_comm_icard` SET `yet_money` = 394.9 , `uptime` = 1754063909 WHERE `id` = 1228 [ RunTime:0.007829s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.009020s ] [ sql ] [ SQL ] SELECT 947,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 947 [ RunTime:0.007563s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.008989s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 947 [ RunTime:0.007600s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008806s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007652s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008767s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.008098s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008708s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.008293s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008799s ] [ 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 , 'Y20250801235829194046' , '3475313394' , 947 , 1401 , 1401 , '1.47' , '1.47' , 'charge_temp' , '2025-08-01 18:12:58' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '刷卡充电' , '2025-08' , '2025-08-01' , NULL , '{\"sql\":\"UPDATE `tp_comm_icard` SET `yet_money` = 394.9 , `uptime` = 1754063909 WHERE `id` = 1228\",\"icard\":{\"id\":1228,\"total_money\":\"420.00\",\"yet_money\":\"393.43\"}}' , 'icardyue' , 'HD2025080118125817540431787900' , 'main') [ RunTime:0.008015s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025080118125817540431787900' , `order_money` = '1.47' , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 345 , `elec_num` = 1.16589 , `power_num` = 274 , `finish` = 10 , `state` = 9 , `other` = '{\"finish_text\":\"充满停止\",\"POWs\":\"2946308\",\"sj_elec\":\"1.0599\"}' , `finish_time` = '2025-08-01 23:58:29' , `js_result` = '{\"money\":\"1.47\",\"num\":1.16589,\"first_price\":\"0.96\",\"first_time\":\"1\",\"dw_price\":1.26,\"by_card_price\":0.3}' WHERE `id` = 2946308 [ RunTime:0.007752s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 947 LIMIT 1 [ RunTime:0.007600s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007598s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008893s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 1401 LIMIT 1 [ RunTime:0.008149s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.009382s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5U3KolliKMnHzUw1yEtP028' , '结束充电' , '{\"touser\":\"oCmeh5U3KolliKMnHzUw1yEtP028\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"孔雀城21栋\"},\"time4\":{\"value\":\"2025-08-01 18:12:58\"},\"time3\":{\"value\":\"2025-08-01 23:58:29\"},\"thing5\":{\"value\":\"您的订单【2946308】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=2946308\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 688ce425-0c251b66-2d48e2dc\"}' , '2025-08-01 23:58:29') [ RunTime:0.007871s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008777s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('S2917277' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"S2917277\",\"SIDS\":\"BJ000093\",\"CZ\":\"8\",\"DH\":\"2946308\",\"POW\":\"274\",\"DL\":\"1.0599\",\"TIM\":\"345\",\"MSG\":\"10\",\"POWs\":\"2946308\",\"MONEY\":\"0\",\"MSG2\":\"充满停止\"}' , '{\"Z\":\"206\",\"IDS\":\"S2917277\",\"SIDS\":\"BJ000093\",\"CZ\":\"8\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-01 23:58:29') [ RunTime:0.007579s ] [ error ] [8]未定义数组索引: remark[D:\www\api\application\comm\model\Consume.php:449] --------------------------------------------------------------- [2025-08-01T23:58:42+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.741002s] [吞吐率：1.35req/s] [内存消耗：4,240.96kb] [文件加载：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' => 'YEWKA113', 'SIDS' => 'CH100059', 'CZ' => '4', 'DH' => '2946429', 'POW' => '104', 'DL' => '0.3416', 'TIM' => '321', 'MSG' => '8', 'POWs' => '2946429', 'MONEY' => '109', 'MSG2' => '5分钟时间无功率自动关闭充电', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.015754s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008462s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007259s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008413s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2946429 LIMIT 1 [ RunTime:0.007191s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008278s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 940 [ RunTime:0.007892s ] [ 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` = 940 AND `icard` = '2708496299' LIMIT 1 [ RunTime:0.007939s ] [ sql ] [ SQL ] UPDATE `tp_comm_icard` SET `yet_money` = 410.41 , `uptime` = 1754063921 WHERE `id` = 12981 [ RunTime:0.007441s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008365s ] [ sql ] [ SQL ] SELECT 940,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 940 [ RunTime:0.007050s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.008294s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 940 [ RunTime:0.008052s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008254s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007183s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008189s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007129s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008185s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007171s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008260s ] [ 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 , 'Y20250801235841341300' , '2708496299' , 940 , 18688 , 18688 , '1.12' , '1.12' , 'charge_temp' , '2025-08-01 18:37:01' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '刷卡充电' , '2025-08' , '2025-08-01' , NULL , '{\"sql\":\"UPDATE `tp_comm_icard` SET `yet_money` = 410.41 , `uptime` = 1754063921 WHERE `id` = 12981\",\"icard\":{\"id\":12981,\"total_money\":\"430.00\",\"yet_money\":\"409.29\"}}' , 'icardyue' , 'HD2025080118370117540446219699' , 'main') [ RunTime:0.008123s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025080118370117540446219699' , `order_money` = '1.12' , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 321 , `elec_num` = 0.37576 , `power_num` = 104 , `finish` = 8 , `state` = 9 , `other` = '{\"finish_text\":\"5分钟时间无功率自动关闭充电\",\"POWs\":\"2946429\",\"sj_elec\":\"0.3416\"}' , `finish_time` = '2025-08-01 23:58:41' , `js_result` = '{\"money\":\"1.12\",\"elec_num\":0.37576000000000004,\"elec_price\":\"0.579\",\"timeNum\":6,\"server_price\":\"0.15\"}' WHERE `id` = 2946429 [ RunTime:0.007807s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 940 LIMIT 1 [ RunTime:0.007108s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007125s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008305s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 18688 LIMIT 1 [ RunTime:0.007388s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008550s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5TJqXeZaegmQ2wjhU9lzKOY' , '结束充电' , '{\"touser\":\"oCmeh5TJqXeZaegmQ2wjhU9lzKOY\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"瑞景茗城3号车库\"},\"time4\":{\"value\":\"2025-08-01 18:37:01\"},\"time3\":{\"value\":\"2025-08-01 23:58:41\"},\"thing5\":{\"value\":\"您的订单【2946429】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=2946429\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 688ce431-4b21ad84-349a9540\"}' , '2025-08-01 23:58:42') [ RunTime:0.007253s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008612s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEWKA113' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YEWKA113\",\"SIDS\":\"CH100059\",\"CZ\":\"4\",\"DH\":\"2946429\",\"POW\":\"104\",\"DL\":\"0.3416\",\"TIM\":\"321\",\"MSG\":\"8\",\"POWs\":\"2946429\",\"MONEY\":\"109\",\"MSG2\":\"5分钟时间无功率自动关闭充电\"}' , '{\"Z\":\"206\",\"IDS\":\"YEWKA113\",\"SIDS\":\"CH100059\",\"CZ\":\"4\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-01 23:58:42') [ RunTime:0.007753s ] [ error ] [8]未定义数组索引: remark[D:\www\api\application\comm\model\Consume.php:449] --------------------------------------------------------------- [2025-08-01T23:59:21+08:00] 117.176.200.75 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.104757s] [吞吐率：9.55req/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' => 'oCmeh5ZVNQh-EWA9T7IcyBBq6CLM', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 14; SDY-AN00 Build/HONORSDY-AN00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.168 Mobile Safari/537.36 XWEB/1380075 MMWEBSDK/20250503 MMWEBID/9378 MicroMessenger/8.0.61.2880(0x28003D57) WeChat/arm64 Weixin NetType/WIFI 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.014474s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008926s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007634s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008847s ] [ sql ] [ SQL ] SELECT `site_name`,`site_logo`,`upload_config`,`regcms` FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.008372s ] --------------------------------------------------------------- [2025-08-01T23:59:30+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.303442s] [吞吐率：3.30req/s] [内存消耗：4,190.20kb] [文件加载：103] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-type' => 'application/json', 'host' => 'api.scyeby.com', 'content-length' => '172', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => 'YEWI0045', 'SIDS' => 'BJ000261', 'CZ' => '11', 'DH' => '2946534', 'POW' => '291', 'DL' => '0.8539', 'TIM' => '296', 'MSG' => '8', 'POWs' => '2946534', 'MONEY' => '149', 'MSG2' => '充满停止', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010354s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008531s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006871s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008215s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2946534 LIMIT 1 [ RunTime:0.007026s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008366s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 967 [ RunTime:0.010139s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008596s ] [ sql ] [ SQL ] SELECT `id`,`total_money`,`yet_money` FROM `tp_comm_icard` WHERE `site_id` = 967 AND `icard` = '0260296570' LIMIT 1 [ RunTime:0.007208s ] [ sql ] [ SQL ] UPDATE `tp_comm_icard` SET `yet_money` = 882.75 , `uptime` = 1754063970 WHERE `id` = 5417 [ RunTime:0.007239s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.009455s ] [ sql ] [ SQL ] SELECT 967,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 967 [ RunTime:0.006927s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.008189s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 967 [ RunTime:0.006895s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008103s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006873s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008826s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006909s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008427s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008312s ] [ 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 , 'Y20250801235930464570' , '0260296570' , 967 , 4527 , 4527 , '1.54' , '1.54' , 'charge_temp' , '2025-08-01 19:01:36' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '刷卡充电' , '2025-08' , '2025-08-01' , NULL , '{\"sql\":\"UPDATE `tp_comm_icard` SET `yet_money` = 882.75 , `uptime` = 1754063970 WHERE `id` = 5417\",\"icard\":{\"id\":5417,\"total_money\":\"887.60\",\"yet_money\":\"881.21\"}}' , 'icardyue' , 'HD2025080119013617540460963444' , 'main') [ RunTime:0.007558s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025080119013617540460963444' , `order_money` = '1.54' , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 296 , `elec_num` = 0.93929 , `power_num` = 291 , `finish` = 8 , `state` = 9 , `other` = '{\"finish_text\":\"充满停止\",\"POWs\":\"2946534\",\"sj_elec\":\"0.8539\"}' , `finish_time` = '2025-08-01 23:59:30' , `js_result` = '{\"money\":\"1.54\",\"elec_num\":0.93929,\"elec_price\":\"0.579\",\"timeNum\":5,\"server_price\":\"0.2\"}' WHERE `id` = 2946534 [ RunTime:0.006982s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 967 LIMIT 1 [ RunTime:0.006858s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006946s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008155s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 4527 LIMIT 1 [ RunTime:0.007521s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008406s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEWI0045' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YEWI0045\",\"SIDS\":\"BJ000261\",\"CZ\":\"11\",\"DH\":\"2946534\",\"POW\":\"291\",\"DL\":\"0.8539\",\"TIM\":\"296\",\"MSG\":\"8\",\"POWs\":\"2946534\",\"MONEY\":\"149\",\"MSG2\":\"充满停止\"}' , '{\"Z\":\"206\",\"IDS\":\"YEWI0045\",\"SIDS\":\"BJ000261\",\"CZ\":\"11\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-01 23:59:30') [ RunTime:0.007175s ] [ error ] [8]未定义数组索引: remark[D:\www\api\application\comm\model\Consume.php:449] --------------------------------------------------------------- [2025-08-01T23:59:41+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.795631s] [吞吐率：1.26req/s] [内存消耗：4,241.01kb] [文件加载：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' => 'YE4G0037', 'SIDS' => 'BJ000283', 'CZ' => '8', 'DH' => '2946661', 'POW' => '378', 'DL' => '0.9026', 'TIM' => '265', 'MSG' => '8', 'POWs' => '2946661', 'MONEY' => '202', 'MSG2' => '检测到插座无充电器结束订单', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.018419s ] 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.007149s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008464s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2946661 LIMIT 1 [ RunTime:0.007158s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008491s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 953 [ RunTime:0.007423s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008602s ] [ sql ] [ SQL ] SELECT `id`,`total_money`,`yet_money` FROM `tp_comm_icard` WHERE `site_id` = 953 AND `icard` = '2708184331' LIMIT 1 [ RunTime:0.007819s ] [ sql ] [ SQL ] UPDATE `tp_comm_icard` SET `yet_money` = 398.92 , `uptime` = 1754063980 WHERE `id` = 13610 [ RunTime:0.007430s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008625s ] [ sql ] [ SQL ] SELECT 953,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 953 [ RunTime:0.007154s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.008574s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 953 [ RunTime:0.007410s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008403s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007163s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008206s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007332s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008155s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007208s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008450s ] [ 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 , 'Y20250801235940521903' , '2708184331' , 953 , 20575 , 20575 , '2.07' , '2.07' , 'charge_temp' , '2025-08-01 19:33:48' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '刷卡充电' , '2025-08' , '2025-08-01' , NULL , '{\"sql\":\"UPDATE `tp_comm_icard` SET `yet_money` = 398.92 , `uptime` = 1754063980 WHERE `id` = 13610\",\"icard\":{\"id\":13610,\"total_money\":\"461.00\",\"yet_money\":\"396.85\"}}' , 'icardyue' , 'HD2025080119334817540480286304' , 'main') [ RunTime:0.007856s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025080119334817540480286304' , `order_money` = '2.07' , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 265 , `elec_num` = 0.99286 , `power_num` = 378 , `finish` = 8 , `state` = 9 , `other` = '{\"finish_text\":\"检测到插座无充电器结束订单\",\"POWs\":\"2946661\",\"sj_elec\":\"0.9026\"}' , `finish_time` = '2025-08-01 23:59:40' , `js_result` = '{\"money\":\"2.07\",\"elec_num\":0.99286,\"elec_price\":\"0.579\",\"timeNum\":5,\"server_price\":\"0.3\"}' WHERE `id` = 2946661 [ RunTime:0.010331s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 953 LIMIT 1 [ RunTime:0.007104s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007083s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008551s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 20575 LIMIT 1 [ RunTime:0.007475s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008507s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5bPWnBoj2mZ8mhZGXwKCX5c' , '结束充电' , '{\"touser\":\"oCmeh5bPWnBoj2mZ8mhZGXwKCX5c\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"浅水半岛三期9栋\"},\"time4\":{\"value\":\"2025-08-01 19:33:48\"},\"time3\":{\"value\":\"2025-08-01 23:59:40\"},\"thing5\":{\"value\":\"您的订单【2946661】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=2946661\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 688ce46c-117b7cd1-2727835e\"}' , '2025-08-01 23:59:41') [ RunTime:0.008965s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008209s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0037' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YE4G0037\",\"SIDS\":\"BJ000283\",\"CZ\":\"8\",\"DH\":\"2946661\",\"POW\":\"378\",\"DL\":\"0.9026\",\"TIM\":\"265\",\"MSG\":\"8\",\"POWs\":\"2946661\",\"MONEY\":\"202\",\"MSG2\":\"检测到插座无充电器结束订单\"}' , '{\"Z\":\"206\",\"IDS\":\"YE4G0037\",\"SIDS\":\"BJ000283\",\"CZ\":\"8\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-01 23:59:41') [ RunTime:0.007619s ] [ error ] [8]未定义数组索引: remark[D:\www\api\application\comm\model\Consume.php:449]