--------------------------------------------------------------- [2025-08-20T23:54:05+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.864747s] [吞吐率：1.16req/s] [内存消耗：4,375.88kb] [文件加载：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' => 'S3003797', 'SIDS' => 'BJ000063', 'IC' => '2709339867', 'CZ' => '3', 'CS' => '1', 'TY' => '1', 'MXHao' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010655s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008483s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007026s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.008315s ] [ sql ] [ SQL ] SELECT `site_id`,`brand` FROM `tp_charge_equi` WHERE `equi_ids` = 'S3003797' LIMIT 1 [ RunTime:0.007902s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008618s ] [ sql ] [ SQL ] SELECT `relation_site_ids` FROM `tp_comm_site` WHERE `id` = 958 LIMIT 1 [ RunTime:0.007032s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.008249s ] [ sql ] [ SQL ] SELECT `start_time`,`id`,`total_elec`,`yet_elec`,total_elec-yet_elec sy_elec,`total_time`,`yet_time`,total_time-yet_time sy_time,`total_num`,`yet_num`,total_num-yet_num sy_num FROM `tp_charge_month` WHERE `site_id` = 958 AND `icard` = '2709339867' AND `start_time` <= '2025-08-20' AND `end_time` > '2025-08-20' [ RunTime:0.009465s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008287s ] [ sql ] [ SQL ] SELECT total_money-yet_money sy_money,`icard`,`member_id`,`state`,`park_end` FROM `tp_comm_icard` WHERE `site_id` = 958 AND `icard` = '2709339867' ORDER BY `id` ASC [ RunTime:0.009372s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008552s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 958 [ RunTime:0.008177s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008574s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`sids`,`socket_num` FROM `tp_charge_orders` WHERE `icard` = '2709339867' AND `site_id` = 958 AND `state` = 1 [ RunTime:0.012454s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.008292s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 958 LIMIT 1 [ RunTime:0.007945s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 958 [ RunTime:0.007090s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008988s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 13159 LIMIT 1 [ RunTime:0.008039s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = 'S3003797' AND `state` = 1 AND `sids` = 'BJ000063' AND `socket_num` = 3 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.013215s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 958 LIMIT 1 [ RunTime:0.007080s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008349s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007169s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008316s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007511s ] [ sql ] [ SQL ] INSERT INTO `tp_charge_orders` (`agent_id` , `site_id` , `order_sn` , `icard` , `state` , `member_id` , `member_mobile` , `equi_ids` , `socket_num` , `socket_no` , `sids` , `pay_money` , `ctime` , `valid_time` , `price_info` , `brand` , `value` , `other` , `system`) VALUES (438 , 958 , '20250820235405485202' , '2709339867' , 0 , 13159 , '15680035795' , 'S3003797' , 3 , 0 , 'BJ000063' , 10 , '2025-08-20 23:54:05' , 1755741244 , '{\"charge_type\":\"8\",\"start_power\":[\"0\",\"201\",\"301\",\"401\",\"501\",\"601\",\"701\",\"801\"],\"end_power\":[\"200\",\"300\",\"400\",\"500\",\"600\",\"700\",\"800\",\"950\"],\"price\":[\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\"],\"time\":[\"0.15\",\"0.2\",\"0.25\",\"0.3\",\"0.35\",\"0.4\",\"0.45\",\"0.5\"]}' , 'qy' , 10 , '{\"month_id\":85142}' , 'main') [ RunTime:0.009334s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2991474 LIMIT 1 [ RunTime:0.007207s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `state` = 1 , `payment_code` = 'month' , `trade_no` = 'HD2025082023540517557052455919' WHERE `id` = 2991474 [ RunTime:0.007462s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008958s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('S3003797' , 'QY_101' , '{\"Z\":\"101\",\"IDS\":\"S3003797\",\"SIDS\":\"BJ000063\",\"CZ\":\"3\",\"MODEL\":\"8\",\"TIM\":\"600\",\"DL\":\"1000\",\"MONEY\":\"1000\",\"LIST\":\"0_200_579_15,201_300_579_20,301_400_579_25,401_500_579_30,501_600_579_35,601_700_579_40,701_800_579_45,801_950_579_50\",\"DH\":\"2991474\",\"ZMONEY\":\"0\"}' , '{\"state\":\"1\"}' , '2025-08-20 23:54:05') [ RunTime:0.008136s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 958 LIMIT 1 [ RunTime:0.007197s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008273s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007196s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 13159 LIMIT 1 [ RunTime:0.007001s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008558s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5ZaurRq_cBmBY4u9J1TQwvs' , '开始充电' , '{\"touser\":\"oCmeh5ZaurRq_cBmBY4u9J1TQwvs\",\"template_id\":\"Agy1VhMUNj0Ts8jwvjW_UqGEDJOg0Y0-39j6y8nhpRg\",\"data\":{\"thing2\":{\"value\":\"蓝水湾\"},\"character_string8\":{\"value\":\"S3003797（BJ000063）\"},\"character_string9\":{\"value\":\"No.3\"},\"character_string6\":{\"value\":2991474},\"time3\":{\"value\":\"2025-08-20 23:54:05\"}},\"page\":\"\\/pages\\/orders\\/chargeing?order_id=2991474\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68a5ef9d-690a6a6a-10fcdc8e\"}' , '2025-08-20 23:54:05') [ RunTime:0.008521s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('S3003797' , 'QY_207' , '{\"Z\":\"207\",\"IDS\":\"S3003797\",\"SIDS\":\"BJ000063\",\"IC\":\"2709339867\",\"CZ\":\"3\",\"CS\":\"1\",\"TY\":\"1\",\"MXHao\":\"1\"}' , '{\"Z\":\"207\",\"IDS\":\"S3003797\",\"SIDS\":\"BJ000063\",\"CZ\":\"3\",\"IC\":\"2709339867\",\"MONEY\":\"0\",\"MXHao\":\"1\",\"state\":\"1\",\"msg\":\"5\",\"msg2\":\"45\",\"txt\":\"开电成功\"}' , '2025-08-20 23:54:05') [ RunTime:0.007297s ] [ error ] [8]未定义数组索引: msg[D:\www\api\application\charge\model\Api.php:373] --------------------------------------------------------------- [2025-08-20T23:54:41+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.937553s] [吞吐率：1.07req/s] [内存消耗：4,376.79kb] [文件加载：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' => 'YE4G0312', 'SIDS' => 'BJ000319', 'IC' => '2708353067', 'CZ' => '3', 'CS' => '1', 'TY' => '1', 'MXHao' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010245s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008179s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006989s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.008828s ] [ sql ] [ SQL ] SELECT `site_id`,`brand` FROM `tp_charge_equi` WHERE `equi_ids` = 'YE4G0312' LIMIT 1 [ RunTime:0.008012s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008409s ] [ sql ] [ SQL ] SELECT `relation_site_ids` FROM `tp_comm_site` WHERE `id` = 955 LIMIT 1 [ RunTime:0.007376s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.010076s ] [ 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` = 955 AND `icard` = '2708353067' AND `start_time` <= '2025-08-20' AND `end_time` > '2025-08-20' [ RunTime:0.008309s ] [ 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` = '2708353067' AND `start_time` <= '2025-08-20' AND `end_time` >= '2025-08-20' [ RunTime:0.006844s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008314s ] [ sql ] [ SQL ] SELECT total_money-yet_money sy_money,`icard`,`member_id`,`state`,`park_end` FROM `tp_comm_icard` WHERE `site_id` = 955 AND `icard` = '2708353067' ORDER BY `id` ASC [ RunTime:0.012730s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008217s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 955 [ RunTime:0.007632s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008240s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`sids`,`socket_num` FROM `tp_charge_orders` WHERE `icard` = '2708353067' AND `site_id` = 955 AND `state` = 1 [ RunTime:0.015249s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.008135s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 955 LIMIT 1 [ RunTime:0.007622s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 955 [ RunTime:0.007070s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008435s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 44122 LIMIT 1 [ RunTime:0.007604s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = 'YE4G0312' AND `state` = 1 AND `sids` = 'BJ000319' AND `socket_num` = 3 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.048190s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 955 LIMIT 1 [ RunTime:0.007477s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008741s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006797s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008115s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007390s ] [ 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 , 955 , '20250820235440834760' , '2708353067' , 0 , 44122 , '15209693255' , 'YE4G0312' , 3 , 0 , 'BJ000319' , 10 , '2025-08-20 23:54:40' , 1755741280 , '{\"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.010511s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2991475 LIMIT 1 [ RunTime:0.006879s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `state` = 1 , `payment_code` = 'icardyue' , `trade_no` = 'HD2025082023544017557052809523' WHERE `id` = 2991475 [ RunTime:0.007076s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008359s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0312' , 'QY_101' , '{\"Z\":\"101\",\"IDS\":\"YE4G0312\",\"SIDS\":\"BJ000319\",\"CZ\":\"3\",\"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\":\"2991475\",\"ZMONEY\":\"1784\"}' , '{\"state\":\"1\"}' , '2025-08-20 23:54:40') [ RunTime:0.007322s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 955 LIMIT 1 [ RunTime:0.006731s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008138s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006850s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 44122 LIMIT 1 [ RunTime:0.014726s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008499s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5e7MSWK8wlA8T2BkyclOA4k' , '开始充电' , '{\"touser\":\"oCmeh5e7MSWK8wlA8T2BkyclOA4k\",\"template_id\":\"Agy1VhMUNj0Ts8jwvjW_UqGEDJOg0Y0-39j6y8nhpRg\",\"data\":{\"thing2\":{\"value\":\"浅水半岛二期二号车库\"},\"character_string8\":{\"value\":\"YE4G0312（BJ000319）\"},\"character_string9\":{\"value\":\"No.3\"},\"character_string6\":{\"value\":2991475},\"time3\":{\"value\":\"2025-08-20 23:54:40\"}},\"page\":\"\\/pages\\/orders\\/chargeing?order_id=2991475\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68a5efc0-314d1050-2f046b8b\"}' , '2025-08-20 23:54:41') [ RunTime:0.009491s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0312' , 'QY_207' , '{\"Z\":\"207\",\"IDS\":\"YE4G0312\",\"SIDS\":\"BJ000319\",\"IC\":\"2708353067\",\"CZ\":\"3\",\"CS\":\"1\",\"TY\":\"1\",\"MXHao\":\"1\"}' , '{\"Z\":\"207\",\"IDS\":\"YE4G0312\",\"SIDS\":\"BJ000319\",\"CZ\":\"3\",\"IC\":\"2708353067\",\"MONEY\":\"1784\",\"MXHao\":\"1\",\"state\":\"1\",\"msg\":\"5\",\"msg2\":\"45\",\"txt\":\"开电成功\"}' , '2025-08-20 23:54:41') [ RunTime:0.006913s ] [ error ] [8]未定义数组索引: msg[D:\www\api\application\charge\model\Api.php:373] --------------------------------------------------------------- [2025-08-20T23:54:46+08:00] 171.219.222.100 POST api.scyeby.com/public/index.php/index/member/index [运行时间：13.978081s] [吞吐率：0.07req/s] [内存消耗：3,956.86kb] [文件加载：93] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '70', 'x-token' => 'oCmeh5X1DeP6vR6fv-ZFmNHa4QPE', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.62(0x18003e30) NetType/4G Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/getLists', 'host' => 'main', 'pageSize' => '15', 'page_num' => '1', 'state' => '', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.011552s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.009068s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007762s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008878s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5X1DeP6vR6fv-ZFmNHa4QPE' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007659s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5X1DeP6vR6fv-ZFmNHa4QPE' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007725s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.009047s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `member_id` = 48354 AND `state` IN (1,9) AND `del` = 1 ORDER BY `state` ASC,`id` DESC LIMIT 15 [ RunTime:13.746271s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.009207s ] [ sql ] [ SQL ] SELECT 997,`name` FROM `tp_comm_site` WHERE `id` = 997 [ RunTime:0.008716s ] [ sql ] [ SQL ] SELECT 997,`name` FROM `tp_comm_site` WHERE `id` = 997 [ RunTime:0.008380s ] [ sql ] [ SQL ] SELECT 997,`name` FROM `tp_comm_site` WHERE `id` = 997 [ RunTime:0.007692s ] [ sql ] [ SQL ] SELECT 997,`name` FROM `tp_comm_site` WHERE `id` = 997 [ RunTime:0.007696s ] [ sql ] [ SQL ] SELECT 997,`name` FROM `tp_comm_site` WHERE `id` = 997 [ RunTime:0.007702s ] [ sql ] [ SQL ] SELECT 997,`name` FROM `tp_comm_site` WHERE `id` = 997 [ RunTime:0.007727s ] [ sql ] [ SQL ] SELECT 997,`name` FROM `tp_comm_site` WHERE `id` = 997 [ RunTime:0.007702s ] [ sql ] [ SQL ] SELECT 997,`name` FROM `tp_comm_site` WHERE `id` = 997 [ RunTime:0.007629s ] [ sql ] [ SQL ] SELECT 997,`name` FROM `tp_comm_site` WHERE `id` = 997 [ RunTime:0.007660s ] [ sql ] [ SQL ] SELECT 997,`name` FROM `tp_comm_site` WHERE `id` = 997 [ RunTime:0.007673s ] [ sql ] [ SQL ] SELECT 997,`name` FROM `tp_comm_site` WHERE `id` = 997 [ RunTime:0.007668s ] [ sql ] [ SQL ] SELECT 997,`name` FROM `tp_comm_site` WHERE `id` = 997 [ RunTime:0.007684s ] [ sql ] [ SQL ] SELECT 997,`name` FROM `tp_comm_site` WHERE `id` = 997 [ RunTime:0.007647s ] [ sql ] [ SQL ] SELECT 997,`name` FROM `tp_comm_site` WHERE `id` = 997 [ RunTime:0.007659s ] [ sql ] [ SQL ] SELECT 997,`name` FROM `tp_comm_site` WHERE `id` = 997 [ RunTime:0.007670s ] --------------------------------------------------------------- [2025-08-20T23:54:47+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.199673s] [吞吐率：5.01req/s] [内存消耗：3,896.31kb] [文件加载：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' => '171', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => '10145717', 'SIDS' => 'BJ000038', 'CZ' => '5', 'DH' => '2989904', 'POW' => '104', 'DL' => '0.5359', 'TIM' => '428', 'MSG' => '8', 'POWs' => '2989904', 'MONEY' => '151', 'MSG2' => '充满停止', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010446s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008285s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006854s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008783s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2989904 LIMIT 1 [ RunTime:0.007997s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.008123s ] [ sql ] [ SQL ] SELECT `total_elec`,`yet_elec`,`total_time`,`yet_time`,`total_num`,`yet_num` FROM `tp_charge_month` WHERE `id` = 86061 LIMIT 1 [ RunTime:0.007734s ] [ sql ] [ SQL ] UPDATE `tp_charge_month` SET `yet_time` = 13.35 WHERE `id` = 86061 [ RunTime:0.008251s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025082016452917556795296731' , `order_money` = 0 , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 428 , `elec_num` = 0.58949 , `power_num` = 104 , `finish` = 8 , `state` = 9 , `other` = '{\"month_id\":86061,\"finish_text\":\"充满停止\",\"POWs\":\"2989904\",\"sj_elec\":\"0.5359\"}' , `finish_time` = '2025-08-20 23:54:47' , `js_result` = '[]' WHERE `id` = 2989904 [ RunTime:0.008322s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008149s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 958 LIMIT 1 [ RunTime:0.007168s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008798s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006936s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.007996s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 2933 LIMIT 1 [ RunTime:0.007860s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008074s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('10145717' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"10145717\",\"SIDS\":\"BJ000038\",\"CZ\":\"5\",\"DH\":\"2989904\",\"POW\":\"104\",\"DL\":\"0.5359\",\"TIM\":\"428\",\"MSG\":\"8\",\"POWs\":\"2989904\",\"MONEY\":\"151\",\"MSG2\":\"充满停止\"}' , '{\"Z\":\"206\",\"IDS\":\"10145717\",\"SIDS\":\"BJ000038\",\"CZ\":\"5\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-20 23:54:47') [ RunTime:0.006866s ] --------------------------------------------------------------- [2025-08-20T23:54:50+08:00] 116.169.4.221 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.181147s] [吞吐率：5.52req/s] [内存消耗：4,046.51kb] [文件加载：95] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '68', 'content-type' => 'application/x-www-form-urlencoded', 'x-token' => 'oCmeh5RnquToqy0GGsx8AcnPM06c', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 15; PLF110 Build/UKQ1.231108.001; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.180 Mobile Safari/537.36 XWEB/1380117 MMWEBSDK/20250503 MMWEBID/9755 MicroMessenger/8.0.62.2900(0x28003E3A) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/getInfo', 'host' => 'main', 'pageSize' => '15', 'order_id' => '2990797', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.011625s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.009777s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.008233s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008965s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5RnquToqy0GGsx8AcnPM06c' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007665s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5RnquToqy0GGsx8AcnPM06c' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007692s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008898s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2990797 LIMIT 1 [ RunTime:0.009196s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `time_num` = 186 , `elec_num` = '0.656' , `power_num` = 103 WHERE `id` = 2990797 [ RunTime:0.008137s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.009644s ] [ sql ] [ SQL ] SELECT 964,`name` FROM `tp_comm_site` WHERE `id` = 964 [ RunTime:0.007676s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.009488s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 964 LIMIT 1 [ RunTime:0.008527s ] --------------------------------------------------------------- [2025-08-20T23:54:52+08:00] 116.169.4.221 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.164353s] [吞吐率：6.08req/s] [内存消耗：4,046.52kb] [文件加载：95] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '68', 'content-type' => 'application/x-www-form-urlencoded', 'x-token' => 'oCmeh5RnquToqy0GGsx8AcnPM06c', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 15; PLF110 Build/UKQ1.231108.001; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.180 Mobile Safari/537.36 XWEB/1380117 MMWEBSDK/20250503 MMWEBID/9755 MicroMessenger/8.0.62.2900(0x28003E3A) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/getInfo', 'host' => 'main', 'pageSize' => '15', 'order_id' => '2990797', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010923s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008903s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007238s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008773s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5RnquToqy0GGsx8AcnPM06c' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007188s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5RnquToqy0GGsx8AcnPM06c' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007198s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008637s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2990797 LIMIT 1 [ RunTime:0.007324s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `time_num` = 186 , `elec_num` = '0.656' , `power_num` = 103 WHERE `id` = 2990797 [ RunTime:0.007711s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008545s ] [ sql ] [ SQL ] SELECT 964,`name` FROM `tp_comm_site` WHERE `id` = 964 [ RunTime:0.007250s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008857s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 964 LIMIT 1 [ RunTime:0.007198s ] --------------------------------------------------------------- [2025-08-20T23:54:52+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.809576s] [吞吐率：1.24req/s] [内存消耗：3,948.59kb] [文件加载：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' => '172', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => '50070088', 'SIDS' => 'BJ000112', 'CZ' => '10', 'DH' => '2990540', 'POW' => '249', 'DL' => '0.6797', 'TIM' => '290', 'MSG' => '8', 'POWs' => '2990540', 'MONEY' => '139', 'MSG2' => '充满停止', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.155586s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.011310s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006596s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.007848s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2990540 LIMIT 1 [ RunTime:0.008064s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.008256s ] [ sql ] [ SQL ] SELECT `total_elec`,`yet_elec`,`total_time`,`yet_time`,`total_num`,`yet_num` FROM `tp_charge_month` WHERE `id` = 90821 LIMIT 1 [ RunTime:0.006936s ] [ sql ] [ SQL ] UPDATE `tp_charge_month` SET `yet_time` = 18.58 WHERE `id` = 90821 [ RunTime:0.006838s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025082019034817556878289712' , `order_money` = 0 , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 290 , `elec_num` = 0.74767 , `power_num` = 249 , `finish` = 8 , `state` = 9 , `other` = '{\"month_id\":90821,\"finish_text\":\"充满停止\",\"POWs\":\"2990540\",\"sj_elec\":\"0.6797\"}' , `finish_time` = '2025-08-20 23:54:52' , `js_result` = '[]' WHERE `id` = 2990540 [ RunTime:0.006628s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007806s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 966 LIMIT 1 [ RunTime:0.006570s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.007894s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006643s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.007831s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 41183 LIMIT 1 [ RunTime:0.006836s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008086s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5TleeDdZOX_VRZbJfaxc9fE' , '结束充电' , '{\"touser\":\"oCmeh5TleeDdZOX_VRZbJfaxc9fE\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"润新花园B区二号车库\"},\"time4\":{\"value\":\"2025-08-20 19:03:48\"},\"time3\":{\"value\":\"2025-08-20 23:54:52\"},\"thing5\":{\"value\":\"您的订单【2990540】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=2990540\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68a5efcc-6c902709-4eeed6c9\"}' , '2025-08-20 23:54:52') [ RunTime:0.007994s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.007779s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('50070088' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"50070088\",\"SIDS\":\"BJ000112\",\"CZ\":\"10\",\"DH\":\"2990540\",\"POW\":\"249\",\"DL\":\"0.6797\",\"TIM\":\"290\",\"MSG\":\"8\",\"POWs\":\"2990540\",\"MONEY\":\"139\",\"MSG2\":\"充满停止\"}' , '{\"Z\":\"206\",\"IDS\":\"50070088\",\"SIDS\":\"BJ000112\",\"CZ\":\"10\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-20 23:54:52') [ RunTime:0.007080s ] --------------------------------------------------------------- [2025-08-20T23:55:17+08:00] 39.144.139.87 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.323124s] [吞吐率：3.09req/s] [内存消耗：4,079.94kb] [文件加载：101] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '71', 'content-type' => 'application/x-www-form-urlencoded', 'x-token' => 'oCmeh5cCiTDwxkojSZO4kbcF6BkY', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 12; CLS-AL30 Build/HUAWEICLS-AL30; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.180 Mobile Safari/537.36 XWEB/1380123 MMWEBSDK/20250503 MMWEBID/329 MicroMessenger/8.0.62.2900(0x28003E50) WeChat/arm64 Weixin NetType/4G Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/getChargeData', 'host' => 'main', 'pageSize' => '15', 'sids' => 'BJ000271', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.018057s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008696s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007435s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008503s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5cCiTDwxkojSZO4kbcF6BkY' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007400s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5cCiTDwxkojSZO4kbcF6BkY' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007347s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_socket` [ RunTime:0.009291s ] [ sql ] [ SQL ] SELECT `equi_id`,`num`,`socket_list`,`name` FROM `tp_charge_socket` WHERE `code` = 'BJ000271' [ RunTime:0.016565s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.008847s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`brand`,`site_id` FROM `tp_charge_equi` WHERE `id` = 369 LIMIT 1 [ RunTime:0.008169s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008641s ] [ sql ] [ SQL ] SELECT `id`,`name`,`state`,`server_tel` FROM `tp_comm_site` WHERE `id` = 977 LIMIT 1 [ RunTime:0.007366s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008784s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 977 LIMIT 1 [ RunTime:0.007383s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.008839s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 977 LIMIT 1 [ RunTime:0.008476s ] --------------------------------------------------------------- [2025-08-20T23:55:21+08:00] 110.40.132.164 POST api.scyeby.com/public/index.php/index/Wxservice/index.html?signature=862c5e2b176ed7e7c647ce22b6b8aca60ead798d×tamp=1755705320&nonce=745390869&openid=oCmeh5cCiTDwxkojSZO4kbcF6BkY [运行时间：0.068371s] [吞吐率：14.63req/s] [内存消耗：3,503.61kb] [文件加载：86] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'user-agent' => 'Mozilla/4.0', 'accept' => '*/*', 'host' => 'api.scyeby.com', 'pragma' => 'no-cache', 'content-length' => '688', 'content-type' => 'text/xml', ) [ info ] [ PARAM ] array ( 'signature' => '862c5e2b176ed7e7c647ce22b6b8aca60ead798d', 'timestamp' => '1755705320', 'nonce' => '745390869', 'openid' => 'oCmeh5cCiTDwxkojSZO4kbcF6BkY', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.011257s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.009325s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007486s ] --------------------------------------------------------------- [2025-08-20T23:55:21+08:00] 39.144.139.87 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.608440s] [吞吐率：1.64req/s] [内存消耗：4,197.53kb] [文件加载：104] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '1306', 'content-type' => 'application/x-www-form-urlencoded', 'x-token' => 'oCmeh5cCiTDwxkojSZO4kbcF6BkY', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 12; CLS-AL30 Build/HUAWEICLS-AL30; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.180 Mobile Safari/537.36 XWEB/1380123 MMWEBSDK/20250503 MMWEBID/329 MicroMessenger/8.0.62.2900(0x28003E50) WeChat/arm64 Weixin NetType/4G Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/createOrder', 'host' => 'main', 'pageSize' => '15', 'state' => '9', 'state_msg' => '', 'site_id' => '977', 'site_name' => '力创锦苑一期', 'site_server' => '18980369999', 'equi_ids' => 'YE4G0028', 'equi_brand' => 'qy', 'equi_state' => '1', 'socket' => '[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object]', 'sids' => 'BJ000271', 'price_info' => '[object Object]', 'money_list' => '[object Object],[object Object],[object Object],[object Object],[object Object]', 'money_name' => '', 'pay_money' => '1', 'value' => '15', 'socket_num' => '1', 'socket_no' => '', 'allow_time' => '1.56', 'power_num' => '502', 'temp' => '{"charge_type":"8","start_power":["0","201","301","401","501","601","701","801"],"end_power":["200","300","400","500","600","700","800","950"],"price":["0.579","0.579","0.579","0.579","0.579","0.579","0.579","0.579"],"time":["0.15","0.2","0.25","0.3","0.35","0.4","0.45","0.5"]}', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.018161s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008780s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007598s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.009080s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5cCiTDwxkojSZO4kbcF6BkY' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007411s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5cCiTDwxkojSZO4kbcF6BkY' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007431s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008720s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 977 [ RunTime:0.007441s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 977 [ RunTime:0.007415s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.009111s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 48090 LIMIT 1 [ RunTime:0.012461s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008964s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = 'YE4G0028' AND `state` = 1 AND `sids` = 'BJ000271' AND `socket_num` = 1 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.212413s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.009849s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 977 LIMIT 1 [ RunTime:0.007451s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.009161s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007498s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.009212s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.013678s ] [ 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 , 977 , '20250820235521863450' , NULL , 0 , 48090 , '13881012212' , 'YE4G0028' , 1 , 0 , 'BJ000271' , '1' , '2025-08-20 23:55:21' , 1755741321 , '{\"charge_type\":\"8\",\"start_power\":[\"0\",\"201\",\"301\",\"401\",\"501\",\"601\",\"701\",\"801\"],\"end_power\":[\"200\",\"300\",\"400\",\"500\",\"600\",\"700\",\"800\",\"950\"],\"price\":[\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\"],\"time\":[\"0.15\",\"0.2\",\"0.25\",\"0.3\",\"0.35\",\"0.4\",\"0.45\",\"0.5\"]}' , 'qy' , 15 , '[]' , 'main') [ RunTime:0.025431s ] [ sql ] [ SQL ] SELECT 977,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 977 [ RunTime:0.007477s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.008749s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 977 [ RunTime:0.012170s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.008019s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007480s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.019453s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007499s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.009219s ] [ sql ] [ SQL ] INSERT INTO `tp_comm_consume` (`port` , `state` , `agent_id` , `order_sn` , `icard` , `site_id` , `member_id` , `pay_id` , `order_money` , `pay_money` , `src_by` , `ctime` , `details` , `pay_config` , `rate` , `directions` , `month` , `day` , `remark` , `system`) VALUES (1 , 0 , 438 , 'Y20250820235521759277' , NULL , 977 , 48090 , 48090 , '1' , '1' , 'charge_temp' , '2025-08-20 23:55:21' , '{\"site_id\":\"977\",\"site_name\":\"力创锦苑一期\",\"equi_ids\":\"YE4G0028\",\"equi_brand\":\"qy\",\"sids\":\"BJ000271\",\"socket_num\":\"1\",\"socket_no\":\"\",\"value\":\"15\",\"order_id\":\"2991476\",\"sy_money\":\"1\"}' , '{\"appId\":\"wx9d3af783c5718533\",\"appSecret\":\"49cd7ec1b8418d1dcb19ce60b78ccb95\",\"partnerId\":\"1511337021\",\"apiKey\":\"f02795ff419df1f67b1b59aa0ca06754\",\"code\":\"yeby\",\"name\":\"元贰佰壹\"}' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '临时充电' , '2025-08' , '2025-08-20' , NULL , 'main') [ RunTime:0.040066s ] [ error ] [8]未定义数组索引: icard[D:\www\api\application\charge\model\Orders.php:79] [ error ] [8]未定义数组索引: other[D:\www\api\application\charge\model\Orders.php:93] [ error ] [8]未定义数组索引: icard[D:\www\api\application\comm\model\Consume.php:53] [ error ] [8]未定义数组索引: remark[D:\www\api\application\comm\model\Consume.php:67] --------------------------------------------------------------- [2025-08-20T23:55:22+08:00] 39.144.139.87 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.611759s] [吞吐率：1.63req/s] [内存消耗：4,009.70kb] [文件加载：98] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '72', 'content-type' => 'application/x-www-form-urlencoded', 'x-token' => 'oCmeh5cCiTDwxkojSZO4kbcF6BkY', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 12; CLS-AL30 Build/HUAWEICLS-AL30; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.180 Mobile Safari/537.36 XWEB/1380123 MMWEBSDK/20250503 MMWEBID/329 MicroMessenger/8.0.62.2900(0x28003E50) WeChat/arm64 Weixin NetType/4G Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/consume/getPayment', 'host' => 'main', 'pageSize' => '15', 'order_id' => '2169933', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.018778s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.009193s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007594s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.009255s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5cCiTDwxkojSZO4kbcF6BkY' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007610s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5cCiTDwxkojSZO4kbcF6BkY' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007517s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.009785s ] [ sql ] [ SQL ] SELECT `id`,`state`,`src_by`,`pay_money`,`order_sn`,`pay_config` FROM `tp_comm_consume` WHERE `id` = 2169933 LIMIT 1 [ RunTime:0.007597s ] [ error ] [8]未定义数组索引: paysuc_url[D:\www\api\application\index\controller\Payment.php:41] [ error ] [8]未定义数组索引: payerr_url[D:\www\api\application\index\controller\Payment.php:42] --------------------------------------------------------------- [2025-08-20T23:55:28+08:00] 121.51.58.169 POST api.scyeby.com/public/index.php/index/payment/wxnotify.html [运行时间：0.632867s] [吞吐率：1.58req/s] [内存消耗：4,124.43kb] [文件加载：97] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-length' => '826', 'user-agent' => 'Mozilla/4.0', 'content-type' => 'text/xml', 'pragma' => 'no-cache', 'connection' => 'Keep-Alive', 'host' => 'api.scyeby.com', 'accept' => '*/*', ) [ info ] [ PARAM ] array ( ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010470s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008386s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006927s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_pay` [ RunTime:0.008322s ] [ sql ] [ SQL ] INSERT INTO `tp_log_pay` (`trade_no` , `content` , `result` , `ctime`) VALUES ('4200002769202508202192538446' , '{\"appid\":\"wx9d3af783c5718533\",\"attach\":\"2169933\",\"bank_type\":\"OTHERS\",\"cash_fee\":\"100\",\"fee_type\":\"CNY\",\"is_subscribe\":\"N\",\"mch_id\":\"1511337021\",\"nonce_str\":\"c2a6b52623c2dffb2ce610353dcfc3e2\",\"openid\":\"oCmeh5cCiTDwxkojSZO4kbcF6BkY\",\"out_trade_no\":\"Y20250820235521759277\",\"result_code\":\"SUCCESS\",\"return_code\":\"SUCCESS\",\"sign\":\"467DC6286DD1AA07AD6A58FAB4C0488F\",\"time_end\":\"20250820235527\",\"total_fee\":\"100\",\"trade_type\":\"JSAPI\",\"transaction_id\":\"4200002769202508202192538446\"}' , '[]' , '2025-08-20 23:55:28') [ RunTime:0.006943s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008192s ] [ sql ] [ SQL ] SELECT `id`,`state`,`ctime`,`details`,`src_by`,`order_money`,`rate` FROM `tp_comm_consume` WHERE `id` = 2169933 LIMIT 1 [ RunTime:0.006993s ] [ sql ] [ SQL ] UPDATE `tp_comm_consume` SET `state` = 9 , `payment_code` = 'wxpay' , `trade_no` = '4200002769202508202192538446' WHERE `id` = 2169933 [ RunTime:0.008779s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008306s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2991476 LIMIT 1 [ RunTime:0.007083s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `state` = 1 , `payment_code` = 'wxpay' , `trade_no` = '4200002769202508202192538446' WHERE `id` = 2991476 [ RunTime:0.007003s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008692s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0028' , 'QY_101' , '{\"Z\":\"101\",\"IDS\":\"YE4G0028\",\"SIDS\":\"BJ000271\",\"CZ\":\"1\",\"MODEL\":\"8\",\"TIM\":\"900\",\"DL\":\"1500\",\"MONEY\":\"100\",\"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\":\"2991476\",\"ZMONEY\":\"100\"}' , '{\"state\":\"1\"}' , '2025-08-20 23:55:28') [ RunTime:0.006917s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008869s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 977 LIMIT 1 [ RunTime:0.006942s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008104s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007005s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008310s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 48090 LIMIT 1 [ RunTime:0.007047s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008310s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5cCiTDwxkojSZO4kbcF6BkY' , '开始充电' , '{\"touser\":\"oCmeh5cCiTDwxkojSZO4kbcF6BkY\",\"template_id\":\"Agy1VhMUNj0Ts8jwvjW_UqGEDJOg0Y0-39j6y8nhpRg\",\"data\":{\"thing2\":{\"value\":\"力创锦苑一期\"},\"character_string8\":{\"value\":\"YE4G0028（BJ000271）\"},\"character_string9\":{\"value\":\"No.1\"},\"character_string6\":{\"value\":2991476},\"time3\":{\"value\":\"2025-08-20 23:55:21\"}},\"page\":\"\\/pages\\/orders\\/chargeing?order_id=2991476\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68a5eff0-48ea93bb-087cdc90\"}' , '2025-08-20 23:55:28') [ RunTime:0.007346s ] [ sql ] [ SQL ] UPDATE `tp_log_pay` SET `result` = '{\"code\":200}' WHERE `trade_no` = '4200002769202508202192538446' [ RunTime:0.006951s ] --------------------------------------------------------------- [2025-08-20T23:55:30+08:00] 39.144.139.87 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.106246s] [吞吐率：9.41req/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' => 'oCmeh5cCiTDwxkojSZO4kbcF6BkY', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 12; CLS-AL30 Build/HUAWEICLS-AL30; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.180 Mobile Safari/537.36 XWEB/1380123 MMWEBSDK/20250503 MMWEBID/329 MicroMessenger/8.0.62.2900(0x28003E50) WeChat/arm64 Weixin NetType/4G 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.010133s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007794s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006774s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008891s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5cCiTDwxkojSZO4kbcF6BkY' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006711s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5cCiTDwxkojSZO4kbcF6BkY' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007368s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_park_orders` [ RunTime:0.007974s ] [ 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` = 48090 AND `state` IN (1,8) ORDER BY `state` ASC,`id` DESC LIMIT 30 [ RunTime:0.008418s ] --------------------------------------------------------------- [2025-08-20T23:55:30+08:00] 39.144.139.87 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.279017s] [吞吐率：3.58req/s] [内存消耗：4,079.92kb] [文件加载：101] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '71', 'content-type' => 'application/x-www-form-urlencoded', 'x-token' => 'oCmeh5cCiTDwxkojSZO4kbcF6BkY', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 12; CLS-AL30 Build/HUAWEICLS-AL30; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.180 Mobile Safari/537.36 XWEB/1380123 MMWEBSDK/20250503 MMWEBID/329 MicroMessenger/8.0.62.2900(0x28003E50) WeChat/arm64 Weixin NetType/4G Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/getChargeData', 'host' => 'main', 'pageSize' => '15', 'sids' => 'BJ000271', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.013040s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008400s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006538s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.007782s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5cCiTDwxkojSZO4kbcF6BkY' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006544s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5cCiTDwxkojSZO4kbcF6BkY' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006527s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_socket` [ RunTime:0.008168s ] [ sql ] [ SQL ] SELECT `equi_id`,`num`,`socket_list`,`name` FROM `tp_charge_socket` WHERE `code` = 'BJ000271' [ RunTime:0.008738s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.008060s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`brand`,`site_id` FROM `tp_charge_equi` WHERE `id` = 369 LIMIT 1 [ RunTime:0.006483s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007725s ] [ sql ] [ SQL ] SELECT `id`,`name`,`state`,`server_tel` FROM `tp_comm_site` WHERE `id` = 977 LIMIT 1 [ RunTime:0.006448s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.007626s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 977 LIMIT 1 [ RunTime:0.006904s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.007691s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 977 LIMIT 1 [ RunTime:0.006519s ] --------------------------------------------------------------- [2025-08-20T23:55:33+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.717712s] [吞吐率：1.39req/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' => 'S2917277', 'SIDS' => 'BJ000093', 'CZ' => '2', 'DH' => '2989996', 'POW' => '248', 'DL' => '1.1438', 'TIM' => '388', 'MSG' => '10', 'POWs' => '2989996', 'MONEY' => '0', 'MSG2' => '5分钟时间无功率自动关闭充电', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010316s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008251s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006853s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008362s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2989996 LIMIT 1 [ RunTime:0.007014s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008074s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 947 [ RunTime:0.006978s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008183s ] [ sql ] [ SQL ] SELECT `id`,`total_money`,`yet_money` FROM `tp_comm_icard` WHERE `site_id` = 947 AND `icard` = '2709783163' LIMIT 1 [ RunTime:0.008489s ] [ sql ] [ SQL ] UPDATE `tp_comm_icard` SET `yet_money` = 189.59 , `uptime` = 1755705333 WHERE `id` = 18825 [ RunTime:0.007249s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008260s ] [ sql ] [ SQL ] SELECT 947,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 947 [ RunTime:0.006930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.008037s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 947 [ RunTime:0.006871s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008044s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006970s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008114s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006883s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008078s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006982s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008176s ] [ 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 , 'Y20250820235533503975' , '2709783163' , 947 , 37754 , 37754 , '1.59' , '1.59' , 'charge_temp' , '2025-08-20 17:25:57' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '刷卡充电' , '2025-08' , '2025-08-20' , NULL , '{\"sql\":\"UPDATE `tp_comm_icard` SET `yet_money` = 189.59 , `uptime` = 1755705333 WHERE `id` = 18825\",\"icard\":{\"id\":18825,\"total_money\":\"200.00\",\"yet_money\":\"188.00\"}}' , 'icardyue' , 'HD2025082017255717556819572941' , 'main') [ RunTime:0.007867s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025082017255717556819572941' , `order_money` = '1.59' , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 388 , `elec_num` = 1.25818 , `power_num` = 248 , `finish` = 10 , `state` = 9 , `other` = '{\"finish_text\":\"5分钟时间无功率自动关闭充电\",\"POWs\":\"2989996\",\"sj_elec\":\"1.1438\"}' , `finish_time` = '2025-08-20 23:55:33' , `js_result` = '{\"money\":\"1.59\",\"num\":1.2581799999999999,\"first_price\":\"0.96\",\"first_time\":\"1\",\"dw_price\":1.26,\"by_card_price\":0.3}' WHERE `id` = 2989996 [ RunTime:0.007014s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 947 LIMIT 1 [ RunTime:0.006880s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007013s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008574s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 37754 LIMIT 1 [ RunTime:0.007290s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008405s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5ZZLVBTcJr4NVU_4qUeDXiE' , '结束充电' , '{\"touser\":\"oCmeh5ZZLVBTcJr4NVU_4qUeDXiE\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"孔雀城21栋\"},\"time4\":{\"value\":\"2025-08-20 17:25:57\"},\"time3\":{\"value\":\"2025-08-20 23:55:33\"},\"thing5\":{\"value\":\"您的订单【2989996】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=2989996\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68a5eff5-244cfac4-6cf4dd05\"}' , '2025-08-20 23:55:33') [ RunTime:0.007247s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008382s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('S2917277' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"S2917277\",\"SIDS\":\"BJ000093\",\"CZ\":\"2\",\"DH\":\"2989996\",\"POW\":\"248\",\"DL\":\"1.1438\",\"TIM\":\"388\",\"MSG\":\"10\",\"POWs\":\"2989996\",\"MONEY\":\"0\",\"MSG2\":\"5分钟时间无功率自动关闭充电\"}' , '{\"Z\":\"206\",\"IDS\":\"S2917277\",\"SIDS\":\"BJ000093\",\"CZ\":\"2\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-20 23:55:33') [ RunTime:0.007445s ] [ error ] [8]未定义数组索引: remark[D:\www\api\application\comm\model\Consume.php:449] --------------------------------------------------------------- [2025-08-20T23:55:58+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.828597s] [吞吐率：1.21req/s] [内存消耗：4,375.95kb] [文件加载：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' => 'S2982891', 'SIDS' => 'BJ000088', 'IC' => '3153613029', 'CZ' => '6', 'CS' => '1', 'TY' => '1', 'MXHao' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010389s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008220s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006948s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.008122s ] [ sql ] [ SQL ] SELECT `site_id`,`brand` FROM `tp_charge_equi` WHERE `equi_ids` = 'S2982891' LIMIT 1 [ RunTime:0.006909s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008194s ] [ sql ] [ SQL ] SELECT `relation_site_ids` FROM `tp_comm_site` WHERE `id` = 964 LIMIT 1 [ RunTime:0.006961s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.008136s ] [ 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` = 964 AND `icard` = '3153613029' AND `start_time` <= '2025-08-20' AND `end_time` > '2025-08-20' [ RunTime:0.009192s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008167s ] [ sql ] [ SQL ] SELECT total_money-yet_money sy_money,`icard`,`member_id`,`state`,`park_end` FROM `tp_comm_icard` WHERE `site_id` = 964 AND `icard` = '3153613029' ORDER BY `id` ASC [ RunTime:0.007632s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008124s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 964 [ RunTime:0.008293s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.009191s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`sids`,`socket_num` FROM `tp_charge_orders` WHERE `icard` = '3153613029' AND `site_id` = 964 AND `state` = 1 [ RunTime:0.011449s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.008707s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 964 LIMIT 1 [ RunTime:0.006900s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 964 [ RunTime:0.006855s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008473s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 38425 LIMIT 1 [ RunTime:0.007258s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = 'S2982891' AND `state` = 1 AND `sids` = 'BJ000088' AND `socket_num` = 6 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.008361s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 964 LIMIT 1 [ RunTime:0.006976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008149s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007104s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008561s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007239s ] [ 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 , 964 , '20250820235558415610' , '3153613029' , 0 , 38425 , '18381059355' , 'S2982891' , 6 , 0 , 'BJ000088' , 10 , '2025-08-20 23:55:58' , 1755741357 , '{\"charge_type\":\"8\",\"start_power\":[\"0\",\"201\",\"301\",\"401\",\"501\",\"601\",\"701\",\"801\"],\"end_power\":[\"200\",\"300\",\"400\",\"500\",\"600\",\"700\",\"800\",\"950\"],\"price\":[\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\"],\"time\":[\"0.15\",\"0.2\",\"0.25\",\"0.3\",\"0.35\",\"0.4\",\"0.45\",\"0.5\"]}' , 'qy' , 10 , '{\"month_id\":89823}' , 'main') [ RunTime:0.007414s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2991477 LIMIT 1 [ RunTime:0.007053s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `state` = 1 , `payment_code` = 'month' , `trade_no` = 'HD2025082023555817557053581003' WHERE `id` = 2991477 [ RunTime:0.007254s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008228s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('S2982891' , 'QY_101' , '{\"Z\":\"101\",\"IDS\":\"S2982891\",\"SIDS\":\"BJ000088\",\"CZ\":\"6\",\"MODEL\":\"8\",\"TIM\":\"600\",\"DL\":\"1000\",\"MONEY\":\"1000\",\"LIST\":\"0_200_579_15,201_300_579_20,301_400_579_25,401_500_579_30,501_600_579_35,601_700_579_40,701_800_579_45,801_950_579_50\",\"DH\":\"2991477\",\"ZMONEY\":\"0\"}' , '{\"state\":\"1\"}' , '2025-08-20 23:55:58') [ RunTime:0.006927s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 964 LIMIT 1 [ RunTime:0.006914s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008301s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006987s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 38425 LIMIT 1 [ RunTime:0.006931s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.009399s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5QLkzaDgZkEj92CZk0lBxvY' , '开始充电' , '{\"touser\":\"oCmeh5QLkzaDgZkEj92CZk0lBxvY\",\"template_id\":\"Agy1VhMUNj0Ts8jwvjW_UqGEDJOg0Y0-39j6y8nhpRg\",\"data\":{\"thing2\":{\"value\":\"润新花园A区\"},\"character_string8\":{\"value\":\"S2982891（BJ000088）\"},\"character_string9\":{\"value\":\"No.6\"},\"character_string6\":{\"value\":2991477},\"time3\":{\"value\":\"2025-08-20 23:55:58\"}},\"page\":\"\\/pages\\/orders\\/chargeing?order_id=2991477\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68a5f00e-2bfba9d5-757a977c\"}' , '2025-08-20 23:55:58') [ RunTime:0.012434s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('S2982891' , 'QY_207' , '{\"Z\":\"207\",\"IDS\":\"S2982891\",\"SIDS\":\"BJ000088\",\"IC\":\"3153613029\",\"CZ\":\"6\",\"CS\":\"1\",\"TY\":\"1\",\"MXHao\":\"1\"}' , '{\"Z\":\"207\",\"IDS\":\"S2982891\",\"SIDS\":\"BJ000088\",\"CZ\":\"6\",\"IC\":\"3153613029\",\"MONEY\":\"0\",\"MXHao\":\"1\",\"state\":\"1\",\"msg\":\"5\",\"msg2\":\"45\",\"txt\":\"开电成功\"}' , '2025-08-20 23:55:58') [ RunTime:0.007985s ] [ error ] [8]未定义数组索引: msg[D:\www\api\application\charge\model\Api.php:373] --------------------------------------------------------------- [2025-08-20T23:55:58+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.190729s] [吞吐率：5.24req/s] [内存消耗：3,896.52kb] [文件加载：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' => '198', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => '10145717', 'SIDS' => 'BJ000038', 'CZ' => '2', 'DH' => '2990889', 'POW' => '251', 'DL' => '0.7358', 'TIM' => '219', 'MSG' => '8', 'POWs' => '2990889', 'MONEY' => '122', 'MSG2' => '检测到插座无充电器结束订单', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009620s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008053s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006473s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.007735s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2990889 LIMIT 1 [ RunTime:0.006512s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.008314s ] [ sql ] [ SQL ] SELECT `total_elec`,`yet_elec`,`total_time`,`yet_time`,`total_num`,`yet_num` FROM `tp_charge_month` WHERE `id` = 86704 LIMIT 1 [ RunTime:0.006897s ] [ sql ] [ SQL ] UPDATE `tp_charge_month` SET `yet_time` = 30.8 WHERE `id` = 86704 [ RunTime:0.006856s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025082020160217556921627959' , `order_money` = 0 , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 219 , `elec_num` = 0.80938 , `power_num` = 251 , `finish` = 8 , `state` = 9 , `other` = '{\"month_id\":86704,\"finish_text\":\"检测到插座无充电器结束订单\",\"POWs\":\"2990889\",\"sj_elec\":\"0.7358\"}' , `finish_time` = '2025-08-20 23:55:58' , `js_result` = '[]' WHERE `id` = 2990889 [ RunTime:0.006550s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007979s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 958 LIMIT 1 [ RunTime:0.006423s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.007769s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006502s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.007861s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 26720 LIMIT 1 [ RunTime:0.006834s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.007708s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('10145717' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"10145717\",\"SIDS\":\"BJ000038\",\"CZ\":\"2\",\"DH\":\"2990889\",\"POW\":\"251\",\"DL\":\"0.7358\",\"TIM\":\"219\",\"MSG\":\"8\",\"POWs\":\"2990889\",\"MONEY\":\"122\",\"MSG2\":\"检测到插座无充电器结束订单\"}' , '{\"Z\":\"206\",\"IDS\":\"10145717\",\"SIDS\":\"BJ000038\",\"CZ\":\"2\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-20 23:55:58') [ RunTime:0.006790s ] --------------------------------------------------------------- [2025-08-20T23:56:10+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.613452s] [吞吐率：1.63req/s] [内存消耗：3,948.73kb] [文件加载：94] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-type' => 'application/json', 'host' => 'api.scyeby.com', 'content-length' => '198', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => 'YEWKA017', 'SIDS' => 'CH100019', 'CZ' => '9', 'DH' => '2990474', 'POW' => '228', 'DL' => '1.1249', 'TIM' => '304', 'MSG' => '8', 'POWs' => '2990474', 'MONEY' => '185', 'MSG2' => '检测到插座无充电器结束订单', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.016800s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007881s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006457s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.007690s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2990474 LIMIT 1 [ RunTime:0.006601s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.007609s ] [ sql ] [ SQL ] SELECT `total_elec`,`yet_elec`,`total_time`,`yet_time`,`total_num`,`yet_num` FROM `tp_charge_month` WHERE `id` = 90680 LIMIT 1 [ RunTime:0.006808s ] [ sql ] [ SQL ] UPDATE `tp_charge_month` SET `yet_time` = 25.38 WHERE `id` = 90680 [ RunTime:0.006770s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025082018511317556870736611' , `order_money` = 0 , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 304 , `elec_num` = 1.23739 , `power_num` = 228 , `finish` = 8 , `state` = 9 , `other` = '{\"month_id\":90680,\"finish_text\":\"检测到插座无充电器结束订单\",\"POWs\":\"2990474\",\"sj_elec\":\"1.1249\"}' , `finish_time` = '2025-08-20 23:56:09' , `js_result` = '[]' WHERE `id` = 2990474 [ RunTime:0.006521s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008053s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 971 LIMIT 1 [ RunTime:0.006376s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.007594s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006503s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.007613s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 10736 LIMIT 1 [ RunTime:0.006789s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.007989s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5Zcrpd9fZeVzI_f6muItQfo' , '结束充电' , '{\"touser\":\"oCmeh5Zcrpd9fZeVzI_f6muItQfo\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"红枫林三期三号门\"},\"time4\":{\"value\":\"2025-08-20 18:51:13\"},\"time3\":{\"value\":\"2025-08-20 23:56:09\"},\"thing5\":{\"value\":\"您的订单【2990474】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=2990474\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68a5f019-60ca9eb2-040df0aa\"}' , '2025-08-20 23:56:10') [ RunTime:0.006744s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.007610s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEWKA017' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YEWKA017\",\"SIDS\":\"CH100019\",\"CZ\":\"9\",\"DH\":\"2990474\",\"POW\":\"228\",\"DL\":\"1.1249\",\"TIM\":\"304\",\"MSG\":\"8\",\"POWs\":\"2990474\",\"MONEY\":\"185\",\"MSG2\":\"检测到插座无充电器结束订单\"}' , '{\"Z\":\"206\",\"IDS\":\"YEWKA017\",\"SIDS\":\"CH100019\",\"CZ\":\"9\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-20 23:56:10') [ RunTime:0.006856s ] --------------------------------------------------------------- [2025-08-20T23:56:21+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.637351s] [吞吐率：1.57req/s] [内存消耗：3,948.58kb] [文件加载：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' => '10142123', 'SIDS' => 'BJ000055', 'CZ' => '5', 'DH' => '2990740', 'POW' => '284', 'DL' => '0.6026', 'TIM' => '251', 'MSG' => '8', 'POWs' => '2990740', 'MONEY' => '134', 'MSG2' => '充满停止', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010693s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008785s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007289s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008510s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2990740 LIMIT 1 [ RunTime:0.007234s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.009524s ] [ sql ] [ SQL ] SELECT `total_elec`,`yet_elec`,`total_time`,`yet_time`,`total_num`,`yet_num` FROM `tp_charge_month` WHERE `id` = 90536 LIMIT 1 [ RunTime:0.007452s ] [ sql ] [ SQL ] UPDATE `tp_charge_month` SET `yet_time` = 15.47 WHERE `id` = 90536 [ RunTime:0.007371s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025082019443617556902763877' , `order_money` = 0 , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 251 , `elec_num` = 0.66286 , `power_num` = 284 , `finish` = 8 , `state` = 9 , `other` = '{\"month_id\":90536,\"finish_text\":\"充满停止\",\"POWs\":\"2990740\",\"sj_elec\":\"0.6026\"}' , `finish_time` = '2025-08-20 23:56:20' , `js_result` = '[]' WHERE `id` = 2990740 [ RunTime:0.007104s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008679s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 958 LIMIT 1 [ RunTime:0.007057s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008870s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.008636s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008310s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 2991 LIMIT 1 [ RunTime:0.007444s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008840s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5ahKwsc9p7OF9xmmh9Omwp8' , '结束充电' , '{\"touser\":\"oCmeh5ahKwsc9p7OF9xmmh9Omwp8\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"蓝水湾\"},\"time4\":{\"value\":\"2025-08-20 19:44:36\"},\"time3\":{\"value\":\"2025-08-20 23:56:20\"},\"thing5\":{\"value\":\"您的订单【2990740】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=2990740\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68a5f024-7beecdc3-19d5cdc7\"}' , '2025-08-20 23:56:21') [ RunTime:0.007399s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.009507s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('10142123' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"10142123\",\"SIDS\":\"BJ000055\",\"CZ\":\"5\",\"DH\":\"2990740\",\"POW\":\"284\",\"DL\":\"0.6026\",\"TIM\":\"251\",\"MSG\":\"8\",\"POWs\":\"2990740\",\"MONEY\":\"134\",\"MSG2\":\"充满停止\"}' , '{\"Z\":\"206\",\"IDS\":\"10142123\",\"SIDS\":\"BJ000055\",\"CZ\":\"5\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-20 23:56:21') [ RunTime:0.007993s ] --------------------------------------------------------------- [2025-08-20T23:57:00+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.713526s] [吞吐率：1.40req/s] [内存消耗：4,240.92kb] [文件加载：104] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-type' => 'application/json', 'host' => 'api.scyeby.com', 'content-length' => '171', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => 'YE4G0030', 'SIDS' => 'BJ000269', 'CZ' => '2', 'DH' => '2990191', 'POW' => '116', 'DL' => '0.4720', 'TIM' => '351', 'MSG' => '8', 'POWs' => '2990191', 'MONEY' => '117', 'MSG2' => '充满停止', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010942s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008642s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007226s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008555s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2990191 LIMIT 1 [ RunTime:0.007428s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008425s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 1011 [ RunTime:0.007321s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008438s ] [ sql ] [ SQL ] SELECT `id`,`total_money`,`yet_money` FROM `tp_comm_icard` WHERE `site_id` = 1011 AND `icard` = '2709798811' LIMIT 1 [ RunTime:0.008026s ] [ sql ] [ SQL ] UPDATE `tp_comm_icard` SET `yet_money` = 340.68 , `uptime` = 1755705420 WHERE `id` = 16796 [ RunTime:0.007646s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008559s ] [ sql ] [ SQL ] SELECT 1011,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 1011 [ RunTime:0.007920s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.009562s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 1011 [ RunTime:0.007305s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008906s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007373s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008589s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007314s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008438s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.008574s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008477s ] [ 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 , 'Y20250820235700961168' , '2709798811' , 1011 , 34883 , 34883 , '1.20' , '1.20' , 'charge_temp' , '2025-08-20 18:04:38' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '刷卡充电' , '2025-08' , '2025-08-20' , NULL , '{\"sql\":\"UPDATE `tp_comm_icard` SET `yet_money` = 340.68 , `uptime` = 1755705420 WHERE `id` = 16796\",\"icard\":{\"id\":16796,\"total_money\":\"360.00\",\"yet_money\":\"339.48\"}}' , 'icardyue' , 'HD2025082018043817556842782271' , 'main') [ RunTime:0.007924s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025082018043817556842782271' , `order_money` = '1.20' , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 351 , `elec_num` = 0.5192 , `power_num` = 116 , `finish` = 8 , `state` = 9 , `other` = '{\"finish_text\":\"充满停止\",\"POWs\":\"2990191\",\"sj_elec\":\"0.4720\"}' , `finish_time` = '2025-08-20 23:57:00' , `js_result` = '{\"money\":\"1.20\",\"elec_num\":0.5192,\"elec_price\":\"0.579\",\"timeNum\":6,\"server_price\":\"0.15\"}' WHERE `id` = 2990191 [ RunTime:0.007303s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 1011 LIMIT 1 [ RunTime:0.007230s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007343s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008393s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 34883 LIMIT 1 [ RunTime:0.007525s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008976s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5TgBVll_AumG5RVF1qf77qM' , '结束充电' , '{\"touser\":\"oCmeh5TgBVll_AumG5RVF1qf77qM\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"华庭阳光地面充电\"},\"time4\":{\"value\":\"2025-08-20 18:04:38\"},\"time3\":{\"value\":\"2025-08-20 23:57:00\"},\"thing5\":{\"value\":\"您的订单【2990191】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=2990191\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68a5f04c-69966e85-6292adb0\"}' , '2025-08-20 23:57:00') [ RunTime:0.007601s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.011412s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0030' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YE4G0030\",\"SIDS\":\"BJ000269\",\"CZ\":\"2\",\"DH\":\"2990191\",\"POW\":\"116\",\"DL\":\"0.4720\",\"TIM\":\"351\",\"MSG\":\"8\",\"POWs\":\"2990191\",\"MONEY\":\"117\",\"MSG2\":\"充满停止\"}' , '{\"Z\":\"206\",\"IDS\":\"YE4G0030\",\"SIDS\":\"BJ000269\",\"CZ\":\"2\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-20 23:57:00') [ RunTime:0.007782s ] [ error ] [8]未定义数组索引: remark[D:\www\api\application\comm\model\Consume.php:449] --------------------------------------------------------------- [2025-08-20T23:57:07+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.861527s] [吞吐率：1.16req/s] [内存消耗：4,128.30kb] [文件加载：98] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-type' => 'application/json', 'host' => 'api.scyeby.com', 'content-length' => '170', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => 'YE4G0302', 'SIDS' => 'C40B6AC6', 'CZ' => '5', 'DH' => '2991065', 'POW' => '347', 'DL' => '1.0111', 'TIM' => '175', 'MSG' => '10', 'POWs' => '2991065', 'MONEY' => '0', 'MSG2' => '电量耗尽', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.017792s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008903s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007225s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008510s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2991065 LIMIT 1 [ RunTime:0.009833s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.009199s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 948 [ RunTime:0.007274s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008420s ] [ sql ] [ SQL ] SELECT `rate` FROM `tp_comm_consume` WHERE `trade_no` = '4200002738202508204776403120' LIMIT 1 [ RunTime:0.007829s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008726s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 948 LIMIT 1 [ RunTime:0.007234s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008701s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007278s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008764s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007205s ] [ sql ] [ SQL ] SELECT `nickname`,`mobile` FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007234s ] [ sql ] [ SQL ] SELECT `total_money` FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007148s ] [ sql ] [ SQL ] UPDATE `tp_comm_user` SET `total_money` = `total_money` + 0.96 WHERE `user_id` = 438 [ RunTime:0.007587s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_packet` [ RunTime:0.008887s ] [ sql ] [ SQL ] INSERT INTO `tp_comm_packet` (`site_id` , `user_id` , `type` , `money` , `state` , `src_by` , `ctime` , `uptime` , `details` , `trade_no` , `name` , `mobile` , `rule` , `month` , `day` , `system`) VALUES ( 948,438,1,'0.96',9,'charge_temp','2025-08-20 21:01:36','2025-08-20 23:57:07','{\"order_money\":\"0.96\",\"old_money\":4327386.5}','4200002738202508204776403120','元贰佰壹科技有限公司','18980369999','100%','2025-08','2025-08-20','main' ) [ RunTime:0.010826s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = '4200002738202508204776403120' , `order_money` = '0.96' , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 175 , `elec_num` = 1.11221 , `power_num` = 347 , `finish` = 10 , `state` = 9 , `other` = '{\"finish_text\":\"电量耗尽\",\"POWs\":\"2991065\",\"sj_elec\":\"1.0111\"}' , `finish_time` = '2025-08-20 23:57:07' , `js_result` = '{\"money\":\"1.07\",\"num\":1.1122100000000001,\"first_price\":\"0.96\",\"first_time\":\"1\",\"dw_price\":\"0.96\",\"by_card_price\":0}' WHERE `id` = 2991065 [ RunTime:0.008425s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 948 LIMIT 1 [ RunTime:0.007161s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008494s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007311s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008300s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 1492 LIMIT 1 [ RunTime:0.007528s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008731s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5XRIBBvd6XWHOr7r7Qr2cPU' , '结束充电' , '{\"touser\":\"oCmeh5XRIBBvd6XWHOr7r7Qr2cPU\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"孔雀城单独充电\"},\"time4\":{\"value\":\"2025-08-20 21:01:36\"},\"time3\":{\"value\":\"2025-08-20 23:57:07\"},\"thing5\":{\"value\":\"您的订单【2991065】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=2991065\"}' , '{\"errcode\":0,\"errmsg\":\"ok\",\"msgid\":4129093586438733829}' , '2025-08-20 23:57:07') [ RunTime:0.007591s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008887s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0302' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YE4G0302\",\"SIDS\":\"C40B6AC6\",\"CZ\":\"5\",\"DH\":\"2991065\",\"POW\":\"347\",\"DL\":\"1.0111\",\"TIM\":\"175\",\"MSG\":\"10\",\"POWs\":\"2991065\",\"MONEY\":\"0\",\"MSG2\":\"电量耗尽\"}' , '{\"Z\":\"206\",\"IDS\":\"YE4G0302\",\"SIDS\":\"C40B6AC6\",\"CZ\":\"5\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-20 23:57:07') [ RunTime:0.007254s ] --------------------------------------------------------------- [2025-08-20T23:57:08+08:00] 175.24.211.142 POST api.scyeby.com/public/index.php/index/Wxservice/index.html?signature=ac5879585fc3f4d84a15ae0f0f5e4e0475490a03×tamp=1755705427&nonce=1242612032&openid=oCmeh5XRIBBvd6XWHOr7r7Qr2cPU [运行时间：0.065057s] [吞吐率：15.37req/s] [内存消耗：3,503.48kb] [文件加载：86] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'user-agent' => 'Mozilla/4.0', 'accept' => '*/*', 'host' => 'api.scyeby.com', 'pragma' => 'no-cache', 'content-length' => '510', 'content-type' => 'text/xml', ) [ info ] [ PARAM ] array ( 'signature' => 'ac5879585fc3f4d84a15ae0f0f5e4e0475490a03', 'timestamp' => '1755705427', 'nonce' => '1242612032', 'openid' => 'oCmeh5XRIBBvd6XWHOr7r7Qr2cPU', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010866s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.009008s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007201s ] --------------------------------------------------------------- [2025-08-20T23:57:18+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.640781s] [吞吐率：1.56req/s] [内存消耗：3,948.58kb] [文件加载：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' => 'YEWKA028', 'SIDS' => 'CH100030', 'CZ' => '4', 'DH' => '2991044', 'POW' => '379', 'DL' => '0.4384', 'TIM' => '180', 'MSG' => '8', 'POWs' => '2991044', 'MONEY' => '125', 'MSG2' => '充满停止', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.017668s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.009019s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007061s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008368s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2991044 LIMIT 1 [ RunTime:0.007256s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.008454s ] [ sql ] [ SQL ] SELECT `total_elec`,`yet_elec`,`total_time`,`yet_time`,`total_num`,`yet_num` FROM `tp_charge_month` WHERE `id` = 86644 LIMIT 1 [ RunTime:0.007056s ] [ sql ] [ SQL ] UPDATE `tp_charge_month` SET `yet_time` = 19.17 WHERE `id` = 86644 [ RunTime:0.007332s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025082020560517556945652952' , `order_money` = 0 , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 180 , `elec_num` = 0.48224 , `power_num` = 379 , `finish` = 8 , `state` = 9 , `other` = '{\"month_id\":86644,\"finish_text\":\"充满停止\",\"POWs\":\"2991044\",\"sj_elec\":\"0.4384\"}' , `finish_time` = '2025-08-20 23:57:17' , `js_result` = '[]' WHERE `id` = 2991044 [ RunTime:0.007122s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008199s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 972 LIMIT 1 [ RunTime:0.007044s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008423s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007104s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008228s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 12792 LIMIT 1 [ RunTime:0.007436s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008528s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5YkB-qnAv9pNTBwPjEt2zrc' , '结束充电' , '{\"touser\":\"oCmeh5YkB-qnAv9pNTBwPjEt2zrc\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"红枫林三期一号门\"},\"time4\":{\"value\":\"2025-08-20 20:56:04\"},\"time3\":{\"value\":\"2025-08-20 23:57:17\"},\"thing5\":{\"value\":\"您的订单【2991044】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=2991044\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68a5f05d-5ec3737c-42f48c06\"}' , '2025-08-20 23:57:18') [ RunTime:0.007397s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008202s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEWKA028' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YEWKA028\",\"SIDS\":\"CH100030\",\"CZ\":\"4\",\"DH\":\"2991044\",\"POW\":\"379\",\"DL\":\"0.4384\",\"TIM\":\"180\",\"MSG\":\"8\",\"POWs\":\"2991044\",\"MONEY\":\"125\",\"MSG2\":\"充满停止\"}' , '{\"Z\":\"206\",\"IDS\":\"YEWKA028\",\"SIDS\":\"CH100030\",\"CZ\":\"4\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-20 23:57:18') [ RunTime:0.007051s ] --------------------------------------------------------------- [2025-08-20T23:57:40+08:00] 111.55.150.109 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.274979s] [吞吐率：3.64req/s] [内存消耗：4,111.64kb] [文件加载：102] [ 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' => 'oCmeh5f7Xrdm_9_p-1TEPQ1w7N_M', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 12; MIS-AL00 Build/HUAWEIMIS-AL00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.180 Mobile Safari/537.36 XWEB/1380123 MMWEBSDK/20250503 MMWEBID/3016 MicroMessenger/8.0.62.2900(0x28003E50) WeChat/arm64 Weixin NetType/4G Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/getChargeData', 'host' => 'main', 'pageSize' => '15', 'sids' => 'BJ000110', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010453s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008374s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006981s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008186s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5f7Xrdm_9_p-1TEPQ1w7N_M' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006981s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5f7Xrdm_9_p-1TEPQ1w7N_M' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006971s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_socket` [ RunTime:0.008108s ] [ sql ] [ SQL ] SELECT `equi_id`,`num`,`socket_list`,`name` FROM `tp_charge_socket` WHERE `code` = 'BJ000110' [ RunTime:0.008993s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.008308s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`brand`,`site_id` FROM `tp_charge_equi` WHERE `id` = 747 LIMIT 1 [ RunTime:0.007661s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008192s ] [ sql ] [ SQL ] SELECT `id`,`name`,`state`,`server_tel` FROM `tp_comm_site` WHERE `id` = 948 LIMIT 1 [ RunTime:0.006929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008083s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 948 LIMIT 1 [ RunTime:0.006917s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.008158s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 948 LIMIT 1 [ RunTime:0.007490s ] [ error ] [8]未定义数组索引: time[D:\www\api\application\member\controller\Charge.php:288] --------------------------------------------------------------- [2025-08-20T23:57:48+08:00] 175.24.213.149 POST api.scyeby.com/public/index.php/index/Wxservice/index.html?signature=18395d31c20eaaba52d1dae77c8ff5e526f656b3×tamp=1755705467&nonce=590597593&openid=oCmeh5f7Xrdm_9_p-1TEPQ1w7N_M [运行时间：0.072148s] [吞吐率：13.86req/s] [内存消耗：3,503.61kb] [文件加载：86] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'user-agent' => 'Mozilla/4.0', 'accept' => '*/*', 'host' => 'api.scyeby.com', 'pragma' => 'no-cache', 'content-length' => '688', 'content-type' => 'text/xml', ) [ info ] [ PARAM ] array ( 'signature' => '18395d31c20eaaba52d1dae77c8ff5e526f656b3', 'timestamp' => '1755705467', 'nonce' => '590597593', 'openid' => 'oCmeh5f7Xrdm_9_p-1TEPQ1w7N_M', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.011149s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.009130s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007458s ] --------------------------------------------------------------- [2025-08-20T23:57:48+08:00] 111.55.150.109 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.301093s] [吞吐率：3.32req/s] [内存消耗：4,197.79kb] [文件加载：104] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '1266', 'content-type' => 'application/x-www-form-urlencoded', 'x-token' => 'oCmeh5f7Xrdm_9_p-1TEPQ1w7N_M', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 12; MIS-AL00 Build/HUAWEIMIS-AL00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.180 Mobile Safari/537.36 XWEB/1380123 MMWEBSDK/20250503 MMWEBID/3016 MicroMessenger/8.0.62.2900(0x28003E50) WeChat/arm64 Weixin NetType/4G Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/createOrder', 'host' => 'main', 'pageSize' => '15', 'state' => '9', 'state_msg' => '', 'site_id' => '948', 'site_name' => '孔雀城单独充电', 'site_server' => '18980369999', 'equi_ids' => '50091712', 'equi_brand' => 'qy', 'equi_state' => '1', 'socket' => '[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object]', 'sids' => 'BJ000110', 'price_info' => '[object Object]', 'money_list' => '[object Object],[object Object],[object Object],[object Object],[object Object],[object Object]', 'money_name' => '按电量计费', 'pay_money' => '1.92', 'value' => '2', 'socket_num' => '2', 'socket_no' => '', 'allow_time' => 'undefined', 'power_num' => '0', 'temp' => '{"charge_type":"3","start_power":["0","201","301","401","501","601"],"end_power":["200","300","400","500","600","700"],"price":["0.96","1.92","2.88","3.84","4.8","5.76"],"time":["1","2","3","4","5","6"]}', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.011778s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.010728s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006914s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008232s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5f7Xrdm_9_p-1TEPQ1w7N_M' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.010047s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5f7Xrdm_9_p-1TEPQ1w7N_M' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006654s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008231s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 948 [ RunTime:0.006825s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 948 [ RunTime:0.006720s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008237s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 1416 LIMIT 1 [ RunTime:0.007086s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008110s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = '50091712' AND `state` = 1 AND `sids` = 'BJ000110' AND `socket_num` = 2 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.015773s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008088s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 948 LIMIT 1 [ RunTime:0.006703s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.007870s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006740s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008400s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006727s ] [ sql ] [ SQL ] INSERT INTO `tp_charge_orders` (`agent_id` , `site_id` , `order_sn` , `icard` , `state` , `member_id` , `member_mobile` , `equi_ids` , `socket_num` , `socket_no` , `sids` , `pay_money` , `ctime` , `valid_time` , `price_info` , `brand` , `value` , `other` , `system`) VALUES (438 , 948 , '20250820235748121684' , NULL , 0 , 1416 , '18081943907' , '50091712' , 2 , 0 , 'BJ000110' , '1.92' , '2025-08-20 23:57:48' , 1755741468 , '{\"charge_type\":\"3\",\"start_power\":[\"0\",\"201\",\"301\",\"401\",\"501\",\"601\"],\"end_power\":[\"200\",\"300\",\"400\",\"500\",\"600\",\"700\"],\"price\":[\"0.96\",\"1.92\",\"2.88\",\"3.84\",\"4.8\",\"5.76\"],\"time\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"]}' , 'qy' , 2 , '[]' , 'main') [ RunTime:0.007502s ] [ sql ] [ SQL ] SELECT 948,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 948 [ RunTime:0.006749s ] [ 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` = 948 [ RunTime:0.006799s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006724s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006795s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008501s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006794s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008028s ] [ sql ] [ SQL ] INSERT INTO `tp_comm_consume` (`port` , `state` , `agent_id` , `order_sn` , `icard` , `site_id` , `member_id` , `pay_id` , `order_money` , `pay_money` , `src_by` , `ctime` , `details` , `pay_config` , `rate` , `directions` , `month` , `day` , `remark` , `system`) VALUES (1 , 0 , 438 , 'Y20250820235748231736' , NULL , 948 , 1416 , 1416 , '1.92' , '1.92' , 'charge_temp' , '2025-08-20 23:57:48' , '{\"site_id\":\"948\",\"site_name\":\"孔雀城单独充电\",\"equi_ids\":\"50091712\",\"equi_brand\":\"qy\",\"sids\":\"BJ000110\",\"socket_num\":\"2\",\"socket_no\":\"\",\"value\":\"2\",\"order_id\":\"2991478\",\"sy_money\":\"1.92\"}' , '{\"appId\":\"wx9d3af783c5718533\",\"appSecret\":\"49cd7ec1b8418d1dcb19ce60b78ccb95\",\"partnerId\":\"1511337021\",\"apiKey\":\"f02795ff419df1f67b1b59aa0ca06754\",\"code\":\"yeby\",\"name\":\"元贰佰壹\"}' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '临时充电' , '2025-08' , '2025-08-20' , NULL , 'main') [ RunTime:0.007725s ] [ error ] [8]未定义数组索引: icard[D:\www\api\application\charge\model\Orders.php:79] [ error ] [8]未定义数组索引: other[D:\www\api\application\charge\model\Orders.php:93] [ error ] [8]未定义数组索引: icard[D:\www\api\application\comm\model\Consume.php:53] [ error ] [8]未定义数组索引: remark[D:\www\api\application\comm\model\Consume.php:67] --------------------------------------------------------------- [2025-08-20T23:57:49+08:00] 111.55.150.109 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.565698s] [吞吐率：1.77req/s] [内存消耗：4,009.78kb] [文件加载：98] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '72', 'content-type' => 'application/x-www-form-urlencoded', 'x-token' => 'oCmeh5f7Xrdm_9_p-1TEPQ1w7N_M', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 12; MIS-AL00 Build/HUAWEIMIS-AL00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.180 Mobile Safari/537.36 XWEB/1380123 MMWEBSDK/20250503 MMWEBID/3016 MicroMessenger/8.0.62.2900(0x28003E50) WeChat/arm64 Weixin NetType/4G Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/consume/getPayment', 'host' => 'main', 'pageSize' => '15', 'order_id' => '2169936', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010603s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008813s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007036s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008227s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5f7Xrdm_9_p-1TEPQ1w7N_M' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007057s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5f7Xrdm_9_p-1TEPQ1w7N_M' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007053s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008447s ] [ sql ] [ SQL ] SELECT `id`,`state`,`src_by`,`pay_money`,`order_sn`,`pay_config` FROM `tp_comm_consume` WHERE `id` = 2169936 LIMIT 1 [ RunTime:0.007170s ] [ error ] [8]未定义数组索引: paysuc_url[D:\www\api\application\index\controller\Payment.php:41] [ error ] [8]未定义数组索引: payerr_url[D:\www\api\application\index\controller\Payment.php:42] --------------------------------------------------------------- [2025-08-20T23:58:01+08:00] 121.51.58.173 POST api.scyeby.com/public/index.php/index/payment/wxnotify.html [运行时间：0.706616s] [吞吐率：1.42req/s] [内存消耗：4,124.04kb] [文件加载：97] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-length' => '830', 'user-agent' => 'Mozilla/4.0', 'content-type' => 'text/xml', 'pragma' => 'no-cache', 'connection' => 'Keep-Alive', 'host' => 'api.scyeby.com', 'accept' => '*/*', ) [ info ] [ PARAM ] array ( ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009747s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007847s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006371s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_pay` [ RunTime:0.007525s ] [ sql ] [ SQL ] INSERT INTO `tp_log_pay` (`trade_no` , `content` , `result` , `ctime`) VALUES ('4200002788202508205063730920' , '{\"appid\":\"wx9d3af783c5718533\",\"attach\":\"2169936\",\"bank_type\":\"GDB_CREDIT\",\"cash_fee\":\"192\",\"fee_type\":\"CNY\",\"is_subscribe\":\"N\",\"mch_id\":\"1511337021\",\"nonce_str\":\"f623c04162d10f108bdba97947dec4f0\",\"openid\":\"oCmeh5f7Xrdm_9_p-1TEPQ1w7N_M\",\"out_trade_no\":\"Y20250820235748231736\",\"result_code\":\"SUCCESS\",\"return_code\":\"SUCCESS\",\"sign\":\"DE85FB61E72F7FFEA514066265F5AFFB\",\"time_end\":\"20250820235759\",\"total_fee\":\"192\",\"trade_type\":\"JSAPI\",\"transaction_id\":\"4200002788202508205063730920\"}' , '[]' , '2025-08-20 23:58:00') [ RunTime:0.006479s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.007564s ] [ sql ] [ SQL ] SELECT `id`,`state`,`ctime`,`details`,`src_by`,`order_money`,`rate` FROM `tp_comm_consume` WHERE `id` = 2169936 LIMIT 1 [ RunTime:0.006396s ] [ sql ] [ SQL ] UPDATE `tp_comm_consume` SET `state` = 9 , `payment_code` = 'wxpay' , `trade_no` = '4200002788202508205063730920' WHERE `id` = 2169936 [ RunTime:0.008322s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.007911s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2991478 LIMIT 1 [ RunTime:0.006448s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `state` = 1 , `payment_code` = 'wxpay' , `trade_no` = '4200002788202508205063730920' WHERE `id` = 2991478 [ RunTime:0.007139s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.009310s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('50091712' , 'QY_101' , '{\"Z\":\"101\",\"IDS\":\"50091712\",\"SIDS\":\"BJ000110\",\"CZ\":\"2\",\"MODEL\":\"3\",\"TIM\":\"120\",\"DL\":\"200\",\"MONEY\":\"200\",\"LIST\":\"\",\"DH\":\"2991478\",\"ZMONEY\":\"192\"}' , '{\"state\":\"1\"}' , '2025-08-20 23:58:00') [ RunTime:0.006354s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007552s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 948 LIMIT 1 [ RunTime:0.006373s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.007607s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.009596s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.009166s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 1416 LIMIT 1 [ RunTime:0.008059s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.007921s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5f7Xrdm_9_p-1TEPQ1w7N_M' , '开始充电' , '{\"touser\":\"oCmeh5f7Xrdm_9_p-1TEPQ1w7N_M\",\"template_id\":\"Agy1VhMUNj0Ts8jwvjW_UqGEDJOg0Y0-39j6y8nhpRg\",\"data\":{\"thing2\":{\"value\":\"孔雀城单独充电\"},\"character_string8\":{\"value\":\"50091712（BJ000110）\"},\"character_string9\":{\"value\":\"No.2\"},\"character_string6\":{\"value\":2991478},\"time3\":{\"value\":\"2025-08-20 23:57:48\"}},\"page\":\"\\/pages\\/orders\\/chargeing?order_id=2991478\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68a5f088-42b6b0c7-58761511\"}' , '2025-08-20 23:58:01') [ RunTime:0.007797s ] [ sql ] [ SQL ] UPDATE `tp_log_pay` SET `result` = '{\"code\":200}' WHERE `trade_no` = '4200002788202508205063730920' [ RunTime:0.006406s ] --------------------------------------------------------------- [2025-08-20T23:58:03+08:00] 111.55.150.109 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.111827s] [吞吐率：8.94req/s] [内存消耗：3,861.38kb] [文件加载：92] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '69', 'content-type' => 'application/x-www-form-urlencoded', 'x-token' => 'oCmeh5f7Xrdm_9_p-1TEPQ1w7N_M', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 12; MIS-AL00 Build/HUAWEIMIS-AL00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.180 Mobile Safari/537.36 XWEB/1380123 MMWEBSDK/20250503 MMWEBID/3016 MicroMessenger/8.0.62.2900(0x28003E50) WeChat/arm64 Weixin NetType/4G 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.011231s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008740s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007436s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008505s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5f7Xrdm_9_p-1TEPQ1w7N_M' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007373s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5f7Xrdm_9_p-1TEPQ1w7N_M' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007421s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_park_orders` [ RunTime:0.008887s ] [ 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` = 1416 AND `state` IN (1,8) ORDER BY `state` ASC,`id` DESC LIMIT 30 [ RunTime:0.009830s ] --------------------------------------------------------------- [2025-08-20T23:58:03+08:00] 111.55.150.109 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.290954s] [吞吐率：3.44req/s] [内存消耗：4,111.63kb] [文件加载：102] [ 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' => 'oCmeh5f7Xrdm_9_p-1TEPQ1w7N_M', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 12; MIS-AL00 Build/HUAWEIMIS-AL00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.180 Mobile Safari/537.36 XWEB/1380123 MMWEBSDK/20250503 MMWEBID/3016 MicroMessenger/8.0.62.2900(0x28003E50) WeChat/arm64 Weixin NetType/4G Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/getChargeData', 'host' => 'main', 'pageSize' => '15', 'sids' => 'BJ000110', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010404s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008347s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006920s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008248s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5f7Xrdm_9_p-1TEPQ1w7N_M' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006915s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5f7Xrdm_9_p-1TEPQ1w7N_M' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006873s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_socket` [ RunTime:0.009317s ] [ sql ] [ SQL ] SELECT `equi_id`,`num`,`socket_list`,`name` FROM `tp_charge_socket` WHERE `code` = 'BJ000110' [ RunTime:0.018394s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.008463s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`brand`,`site_id` FROM `tp_charge_equi` WHERE `id` = 747 LIMIT 1 [ RunTime:0.007016s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008793s ] [ sql ] [ SQL ] SELECT `id`,`name`,`state`,`server_tel` FROM `tp_comm_site` WHERE `id` = 948 LIMIT 1 [ RunTime:0.007558s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008600s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 948 LIMIT 1 [ RunTime:0.007799s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.008063s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 948 LIMIT 1 [ RunTime:0.007680s ] [ error ] [8]未定义数组索引: time[D:\www\api\application\member\controller\Charge.php:288] --------------------------------------------------------------- [2025-08-20T23:58:28+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.813581s] [吞吐率：1.23req/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' => 'YE4G0066', 'SIDS' => '860B8912', 'CZ' => '7', 'DH' => '2990818', 'POW' => '251', 'DL' => '0.7979', 'TIM' => '236', 'MSG' => '8', 'POWs' => '2990818', 'MONEY' => '126', 'MSG2' => '检测到插座无充电器结束订单', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.017728s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008647s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007185s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008910s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2990818 LIMIT 1 [ RunTime:0.007895s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008409s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 1005 [ RunTime:0.007308s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008412s ] [ sql ] [ SQL ] SELECT `id`,`total_money`,`yet_money` FROM `tp_comm_icard` WHERE `site_id` = 1005 AND `icard` = '3158259861' LIMIT 1 [ RunTime:0.008672s ] [ sql ] [ SQL ] UPDATE `tp_comm_icard` SET `yet_money` = 813.71 , `uptime` = 1755705507 WHERE `id` = 16554 [ RunTime:0.007548s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008452s ] [ sql ] [ SQL ] SELECT 1005,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 1005 [ RunTime:0.007150s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.008329s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 1005 [ RunTime:0.007192s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008288s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007227s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008273s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007280s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008631s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007287s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008386s ] [ 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 , 'Y20250820235827256832' , '3158259861' , 1005 , 30829 , 30829 , '1.31' , '1.31' , 'charge_temp' , '2025-08-20 20:01:36' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '刷卡充电' , '2025-08' , '2025-08-20' , NULL , '{\"sql\":\"UPDATE `tp_comm_icard` SET `yet_money` = 813.71 , `uptime` = 1755705507 WHERE `id` = 16554\",\"icard\":{\"id\":16554,\"total_money\":\"815.00\",\"yet_money\":\"812.40\"}}' , 'icardyue' , 'HD2025082020013617556912961227' , 'main') [ RunTime:0.008688s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025082020013617556912961227' , `order_money` = '1.31' , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 236 , `elec_num` = 0.87769 , `power_num` = 251 , `finish` = 8 , `state` = 9 , `other` = '{\"finish_text\":\"检测到插座无充电器结束订单\",\"POWs\":\"2990818\",\"sj_elec\":\"0.7979\"}' , `finish_time` = '2025-08-20 23:58:27' , `js_result` = '{\"money\":\"1.31\",\"elec_num\":0.8776900000000001,\"elec_price\":\"0.579\",\"timeNum\":4,\"server_price\":\"0.2\"}' WHERE `id` = 2990818 [ RunTime:0.007874s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 1005 LIMIT 1 [ RunTime:0.007226s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007290s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008548s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 30829 LIMIT 1 [ RunTime:0.007778s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008653s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5QoxpG8gFbA4ZjTifkFt-CI' , '结束充电' , '{\"touser\":\"oCmeh5QoxpG8gFbA4ZjTifkFt-CI\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"华庭阳光20栋\"},\"time4\":{\"value\":\"2025-08-20 20:01:36\"},\"time3\":{\"value\":\"2025-08-20 23:58:27\"},\"thing5\":{\"value\":\"您的订单【2990818】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=2990818\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68a5f0a3-226c059d-60485838\"}' , '2025-08-20 23:58:28') [ RunTime:0.007613s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.009224s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0066' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YE4G0066\",\"SIDS\":\"860B8912\",\"CZ\":\"7\",\"DH\":\"2990818\",\"POW\":\"251\",\"DL\":\"0.7979\",\"TIM\":\"236\",\"MSG\":\"8\",\"POWs\":\"2990818\",\"MONEY\":\"126\",\"MSG2\":\"检测到插座无充电器结束订单\"}' , '{\"Z\":\"206\",\"IDS\":\"YE4G0066\",\"SIDS\":\"860B8912\",\"CZ\":\"7\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-20 23:58:28') [ RunTime:0.007210s ] [ error ] [8]未定义数组索引: remark[D:\www\api\application\comm\model\Consume.php:449] --------------------------------------------------------------- [2025-08-20T23:58:40+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.664956s] [吞吐率：1.50req/s] [内存消耗：3,948.74kb] [文件加载：94] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-type' => 'application/json', 'host' => 'api.scyeby.com', 'content-length' => '198', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => 'GX4G0122', 'SIDS' => 'E20B5D71', 'CZ' => '3', 'DH' => '2990405', 'POW' => '268', 'DL' => '1.1481', 'TIM' => '321', 'MSG' => '8', 'POWs' => '2990405', 'MONEY' => '186', 'MSG2' => '检测到插座无充电器结束订单', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.019134s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.009506s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007738s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.009078s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2990405 LIMIT 1 [ RunTime:0.007886s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.009068s ] [ sql ] [ SQL ] SELECT `total_elec`,`yet_elec`,`total_time`,`yet_time`,`total_num`,`yet_num` FROM `tp_charge_month` WHERE `id` = 90368 LIMIT 1 [ RunTime:0.008202s ] [ sql ] [ SQL ] UPDATE `tp_charge_month` SET `yet_time` = 48.13 WHERE `id` = 90368 [ RunTime:0.008031s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025082018364217556862026364' , `order_money` = 0 , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 321 , `elec_num` = 1.26291 , `power_num` = 268 , `finish` = 8 , `state` = 9 , `other` = '{\"month_id\":90368,\"finish_text\":\"检测到插座无充电器结束订单\",\"POWs\":\"2990405\",\"sj_elec\":\"1.1481\"}' , `finish_time` = '2025-08-20 23:58:39' , `js_result` = '[]' WHERE `id` = 2990405 [ RunTime:0.007875s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.009292s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 1010 LIMIT 1 [ RunTime:0.007695s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.009200s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007859s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.009237s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 38986 LIMIT 1 [ RunTime:0.008248s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.009524s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5Vwc_diq8atb1lz0NOCQ5MY' , '结束充电' , '{\"touser\":\"oCmeh5Vwc_diq8atb1lz0NOCQ5MY\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"上行锦绣3栋\"},\"time4\":{\"value\":\"2025-08-20 18:36:42\"},\"time3\":{\"value\":\"2025-08-20 23:58:39\"},\"thing5\":{\"value\":\"您的订单【2990405】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=2990405\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68a5f0af-5700a470-3ef95ab2\"}' , '2025-08-20 23:58:40') [ RunTime:0.008022s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008854s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('GX4G0122' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"GX4G0122\",\"SIDS\":\"E20B5D71\",\"CZ\":\"3\",\"DH\":\"2990405\",\"POW\":\"268\",\"DL\":\"1.1481\",\"TIM\":\"321\",\"MSG\":\"8\",\"POWs\":\"2990405\",\"MONEY\":\"186\",\"MSG2\":\"检测到插座无充电器结束订单\"}' , '{\"Z\":\"206\",\"IDS\":\"GX4G0122\",\"SIDS\":\"E20B5D71\",\"CZ\":\"3\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-20 23:58:40') [ RunTime:0.007719s ] --------------------------------------------------------------- [2025-08-20T23:58:43+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.759881s] [吞吐率：1.32req/s] [内存消耗：4,240.93kb] [文件加载：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' => 'YE4G0032', 'SIDS' => 'BJ000280', 'CZ' => '7', 'DH' => '2990568', 'POW' => '111', 'DL' => '0.3690', 'TIM' => '287', 'MSG' => '10', 'POWs' => '2990568', 'MONEY' => '0', 'MSG2' => '5分钟时间无功率自动关闭充电', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.017092s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008065s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006615s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.007956s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2990568 LIMIT 1 [ RunTime:0.006709s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008568s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 946 [ RunTime:0.006752s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.007881s ] [ sql ] [ SQL ] SELECT `id`,`total_money`,`yet_money` FROM `tp_comm_icard` WHERE `site_id` = 946 AND `icard` = '1589729326' LIMIT 1 [ RunTime:0.007314s ] [ sql ] [ SQL ] UPDATE `tp_comm_icard` SET `yet_money` = 236.43 , `uptime` = 1755705523 WHERE `id` = 12774 [ RunTime:0.006939s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007917s ] [ sql ] [ SQL ] SELECT 946,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 946 [ RunTime:0.006587s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.008393s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 946 [ RunTime:0.006676s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.007764s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006601s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.007907s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006614s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008105s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006661s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008370s ] [ 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 , 'Y20250820235843401322' , '1589729326' , 946 , 16186 , 16186 , '0.51' , '0.51' , 'charge_temp' , '2025-08-20 19:10:05' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '刷卡充电' , '2025-08' , '2025-08-20' , NULL , '{\"sql\":\"UPDATE `tp_comm_icard` SET `yet_money` = 236.43 , `uptime` = 1755705523 WHERE `id` = 12774\",\"icard\":{\"id\":12774,\"total_money\":\"240.00\",\"yet_money\":\"235.92\"}}' , 'icardyue' , 'HD2025082019100517556882056297' , 'main') [ RunTime:0.007455s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025082019100517556882056297' , `order_money` = '0.51' , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 287 , `elec_num` = 0.4059 , `power_num` = 111 , `finish` = 10 , `state` = 9 , `other` = '{\"finish_text\":\"5分钟时间无功率自动关闭充电\",\"POWs\":\"2990568\",\"sj_elec\":\"0.3690\"}' , `finish_time` = '2025-08-20 23:58:43' , `js_result` = '{\"money\":\"0.51\",\"num\":0.4059,\"first_price\":\"0.96\",\"first_time\":\"1\",\"dw_price\":1.26,\"by_card_price\":0.3}' WHERE `id` = 2990568 [ RunTime:0.006621s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 946 LIMIT 1 [ RunTime:0.006610s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006642s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.007945s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 16186 LIMIT 1 [ RunTime:0.006841s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008208s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5YHMJnH_-ZahAyWMEc8wd68' , '结束充电' , '{\"touser\":\"oCmeh5YHMJnH_-ZahAyWMEc8wd68\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"孔雀城8栋\"},\"time4\":{\"value\":\"2025-08-20 19:10:05\"},\"time3\":{\"value\":\"2025-08-20 23:58:43\"},\"thing5\":{\"value\":\"您的订单【2990568】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=2990568\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68a5f0b3-69c0959e-537e3a5d\"}' , '2025-08-20 23:58:43') [ RunTime:0.007053s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.007766s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0032' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YE4G0032\",\"SIDS\":\"BJ000280\",\"CZ\":\"7\",\"DH\":\"2990568\",\"POW\":\"111\",\"DL\":\"0.3690\",\"TIM\":\"287\",\"MSG\":\"10\",\"POWs\":\"2990568\",\"MONEY\":\"0\",\"MSG2\":\"5分钟时间无功率自动关闭充电\"}' , '{\"Z\":\"206\",\"IDS\":\"YE4G0032\",\"SIDS\":\"BJ000280\",\"CZ\":\"7\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-20 23:58:43') [ RunTime:0.007072s ] [ error ] [8]未定义数组索引: remark[D:\www\api\application\comm\model\Consume.php:449] --------------------------------------------------------------- [2025-08-20T23:58:50+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.676326s] [吞吐率：1.48req/s] [内存消耗：3,948.58kb] [文件加载：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' => 'YEWKA017', 'SIDS' => 'CH100019', 'CZ' => '5', 'DH' => '2990437', 'POW' => '190', 'DL' => '0.6666', 'TIM' => '314', 'MSG' => '8', 'POWs' => '2990437', 'MONEY' => '128', 'MSG2' => '充满停止', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.017175s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008929s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007600s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008938s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2990437 LIMIT 1 [ RunTime:0.007716s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.010313s ] [ sql ] [ SQL ] SELECT `total_elec`,`yet_elec`,`total_time`,`yet_time`,`total_num`,`yet_num` FROM `tp_charge_month` WHERE `id` = 86623 LIMIT 1 [ RunTime:0.007574s ] [ sql ] [ SQL ] UPDATE `tp_charge_month` SET `yet_time` = 27.33 WHERE `id` = 86623 [ RunTime:0.007884s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025082018433817556866189340' , `order_money` = 0 , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 314 , `elec_num` = 0.73326 , `power_num` = 190 , `finish` = 8 , `state` = 9 , `other` = '{\"month_id\":86623,\"finish_text\":\"充满停止\",\"POWs\":\"2990437\",\"sj_elec\":\"0.6666\"}' , `finish_time` = '2025-08-20 23:58:50' , `js_result` = '[]' WHERE `id` = 2990437 [ RunTime:0.007724s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.009038s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 971 LIMIT 1 [ RunTime:0.007516s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.009108s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007553s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.009042s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 12218 LIMIT 1 [ RunTime:0.007963s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.010351s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5btTrIhNYGCz1e66UHoRkKo' , '结束充电' , '{\"touser\":\"oCmeh5btTrIhNYGCz1e66UHoRkKo\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"红枫林三期三号门\"},\"time4\":{\"value\":\"2025-08-20 18:43:38\"},\"time3\":{\"value\":\"2025-08-20 23:58:50\"},\"thing5\":{\"value\":\"您的订单【2990437】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=2990437\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68a5f0ba-31091d99-40e5e68d\"}' , '2025-08-20 23:58:50') [ RunTime:0.007982s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008767s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEWKA017' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YEWKA017\",\"SIDS\":\"CH100019\",\"CZ\":\"5\",\"DH\":\"2990437\",\"POW\":\"190\",\"DL\":\"0.6666\",\"TIM\":\"314\",\"MSG\":\"8\",\"POWs\":\"2990437\",\"MONEY\":\"128\",\"MSG2\":\"充满停止\"}' , '{\"Z\":\"206\",\"IDS\":\"YEWKA017\",\"SIDS\":\"CH100019\",\"CZ\":\"5\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-20 23:58:50') [ RunTime:0.007517s ] --------------------------------------------------------------- [2025-08-20T23:59:05+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.321282s] [吞吐率：3.11req/s] [内存消耗：4,190.26kb] [文件加载：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' => '199', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => 'YE4G0082', 'SIDS' => 'BJ000295', 'CZ' => '6', 'DH' => '2990018', 'POW' => '248', 'DL' => '1.3798', 'TIM' => '387', 'MSG' => '8', 'POWs' => '2990018', 'MONEY' => '254', 'MSG2' => '5分钟时间无功率自动关闭充电', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.018685s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008760s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007367s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008600s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2990018 LIMIT 1 [ RunTime:0.007818s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008643s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 954 [ RunTime:0.007386s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008577s ] [ sql ] [ SQL ] SELECT `id`,`total_money`,`yet_money` FROM `tp_comm_icard` WHERE `site_id` = 954 AND `icard` = '2709403115' LIMIT 1 [ RunTime:0.008070s ] [ sql ] [ SQL ] UPDATE `tp_comm_icard` SET `yet_money` = 70.91 , `uptime` = 1755705545 WHERE `id` = 21424 [ RunTime:0.007693s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008903s ] [ sql ] [ SQL ] SELECT 954,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 954 [ RunTime:0.007401s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.008945s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 954 [ RunTime:0.007528s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008711s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007459s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.009017s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007468s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008681s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007516s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.009876s ] [ 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 , 'Y20250820235905627735' , '2709403115' , 954 , 45701 , 45701 , '2.63' , '2.63' , 'charge_temp' , '2025-08-20 17:31:31' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '刷卡充电' , '2025-08' , '2025-08-20' , NULL , '{\"sql\":\"UPDATE `tp_comm_icard` SET `yet_money` = 70.91 , `uptime` = 1755705545 WHERE `id` = 21424\",\"icard\":{\"id\":21424,\"total_money\":\"100.00\",\"yet_money\":\"68.28\"}}' , 'icardyue' , 'HD2025082017313117556822915479' , 'main') [ RunTime:0.008083s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025082017313117556822915479' , `order_money` = '2.63' , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 387 , `elec_num` = 1.51778 , `power_num` = 248 , `finish` = 8 , `state` = 9 , `other` = '{\"finish_text\":\"5分钟时间无功率自动关闭充电\",\"POWs\":\"2990018\",\"sj_elec\":\"1.3798\"}' , `finish_time` = '2025-08-20 23:59:05' , `js_result` = '{\"money\":\"2.63\",\"elec_num\":1.51778,\"elec_price\":\"0.579\",\"timeNum\":7,\"server_price\":\"0.25\"}' WHERE `id` = 2990018 [ RunTime:0.007604s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 954 LIMIT 1 [ RunTime:0.008238s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007411s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008691s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 45701 LIMIT 1 [ RunTime:0.007692s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.010069s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0082' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YE4G0082\",\"SIDS\":\"BJ000295\",\"CZ\":\"6\",\"DH\":\"2990018\",\"POW\":\"248\",\"DL\":\"1.3798\",\"TIM\":\"387\",\"MSG\":\"8\",\"POWs\":\"2990018\",\"MONEY\":\"254\",\"MSG2\":\"5分钟时间无功率自动关闭充电\"}' , '{\"Z\":\"206\",\"IDS\":\"YE4G0082\",\"SIDS\":\"BJ000295\",\"CZ\":\"6\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-08-20 23:59:05') [ RunTime:0.007790s ] [ error ] [8]未定义数组索引: remark[D:\www\api\application\comm\model\Consume.php:449] --------------------------------------------------------------- [2025-08-20T23:59:28+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.882224s] [吞吐率：1.13req/s] [内存消耗：4,375.95kb] [文件加载：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' => '50086720', 'SIDS' => 'BJ000113', 'IC' => '2710329067', 'CZ' => '1', 'CS' => '1', 'TY' => '1', 'MXHao' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.019035s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008855s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007290s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.008662s ] [ sql ] [ SQL ] SELECT `site_id`,`brand` FROM `tp_charge_equi` WHERE `equi_ids` = '50086720' LIMIT 1 [ RunTime:0.007558s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008488s ] [ sql ] [ SQL ] SELECT `relation_site_ids` FROM `tp_comm_site` WHERE `id` = 966 LIMIT 1 [ RunTime:0.007259s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.008530s ] [ 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` = 966 AND `icard` = '2710329067' AND `start_time` <= '2025-08-20' AND `end_time` > '2025-08-20' [ RunTime:0.009586s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008746s ] [ sql ] [ SQL ] SELECT total_money-yet_money sy_money,`icard`,`member_id`,`state`,`park_end` FROM `tp_comm_icard` WHERE `site_id` = 966 AND `icard` = '2710329067' ORDER BY `id` ASC [ RunTime:0.007866s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008424s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 966 [ RunTime:0.007312s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008420s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`sids`,`socket_num` FROM `tp_charge_orders` WHERE `icard` = '2710329067' AND `site_id` = 966 AND `state` = 1 [ RunTime:0.011456s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.008930s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 966 LIMIT 1 [ RunTime:0.007530s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 966 [ RunTime:0.007617s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008639s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 41195 LIMIT 1 [ RunTime:0.007546s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = '50086720' AND `state` = 1 AND `sids` = 'BJ000113' AND `socket_num` = 1 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.016491s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 966 LIMIT 1 [ RunTime:0.007234s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008525s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.007236s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008390s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.007266s ] [ 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 , 966 , '20250820235927472042' , '2710329067' , 0 , 41195 , '15708485250' , '50086720' , 1 , 0 , 'BJ000113' , 10 , '2025-08-20 23:59:27' , 1755741567 , '{\"charge_type\":\"8\",\"start_power\":[\"0\",\"201\",\"301\",\"401\",\"501\",\"601\",\"701\",\"801\"],\"end_power\":[\"200\",\"300\",\"400\",\"500\",\"600\",\"700\",\"800\",\"950\"],\"price\":[\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\"],\"time\":[\"0.15\",\"0.2\",\"0.25\",\"0.3\",\"0.35\",\"0.4\",\"0.45\",\"0.5\"]}' , 'qy' , 10 , '{\"month_id\":89289}' , 'main') [ RunTime:0.007727s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2991479 LIMIT 1 [ RunTime:0.007367s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `state` = 1 , `payment_code` = 'month' , `trade_no` = 'HD2025082023592717557055676251' WHERE `id` = 2991479 [ RunTime:0.007575s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008867s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('50086720' , 'QY_101' , '{\"Z\":\"101\",\"IDS\":\"50086720\",\"SIDS\":\"BJ000113\",\"CZ\":\"1\",\"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\":\"2991479\",\"ZMONEY\":\"0\"}' , '{\"state\":\"1\"}' , '2025-08-20 23:59:27') [ RunTime:0.007297s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 966 LIMIT 1 [ RunTime:0.007200s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008476s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.010779s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 41195 LIMIT 1 [ RunTime:0.007209s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.010330s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5VEnwF6qI3NDNmuCC-aWmU4' , '开始充电' , '{\"touser\":\"oCmeh5VEnwF6qI3NDNmuCC-aWmU4\",\"template_id\":\"Agy1VhMUNj0Ts8jwvjW_UqGEDJOg0Y0-39j6y8nhpRg\",\"data\":{\"thing2\":{\"value\":\"润新花园B区二号车库\"},\"character_string8\":{\"value\":\"50086720（BJ000113）\"},\"character_string9\":{\"value\":\"No.1\"},\"character_string6\":{\"value\":2991479},\"time3\":{\"value\":\"2025-08-20 23:59:27\"}},\"page\":\"\\/pages\\/orders\\/chargeing?order_id=2991479\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 68a5f0df-3ce4b15a-7a348368\"}' , '2025-08-20 23:59:28') [ RunTime:0.007587s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('50086720' , 'QY_207' , '{\"Z\":\"207\",\"IDS\":\"50086720\",\"SIDS\":\"BJ000113\",\"IC\":\"2710329067\",\"CZ\":\"1\",\"CS\":\"1\",\"TY\":\"1\",\"MXHao\":\"1\"}' , '{\"Z\":\"207\",\"IDS\":\"50086720\",\"SIDS\":\"BJ000113\",\"CZ\":\"1\",\"IC\":\"2710329067\",\"MONEY\":\"0\",\"MXHao\":\"1\",\"state\":\"1\",\"msg\":\"5\",\"msg2\":\"45\",\"txt\":\"开电成功\"}' , '2025-08-20 23:59:28') [ RunTime:0.007279s ] [ error ] [8]未定义数组索引: msg[D:\www\api\application\charge\model\Api.php:373]