--------------------------------------------------------------- [2025-07-18T23:55:59+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.177381s] [吞吐率：5.64req/s] [内存消耗：4,170.40kb] [文件加载：101] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-type' => 'application/json', 'host' => 'api.scyeby.com', 'content-length' => '103', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '207', 'IDS' => 'YEWI0017', 'SIDS' => 'BJ000199', 'IC' => '3475095970', 'CZ' => '4', 'CS' => '1', 'TY' => '1', 'MXHao' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009166s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007586s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006181s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.007294s ] [ sql ] [ SQL ] SELECT `site_id`,`brand` FROM `tp_charge_equi` WHERE `equi_ids` = 'YEWI0017' LIMIT 1 [ RunTime:0.006738s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007356s ] [ sql ] [ SQL ] SELECT `relation_site_ids` FROM `tp_comm_site` WHERE `id` = 968 LIMIT 1 [ RunTime:0.006100s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.007315s ] [ 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` = 968 AND `icard` = '3475095970' AND `start_time` <= '2025-07-18' AND `end_time` > '2025-07-18' [ RunTime:0.007227s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008115s ] [ sql ] [ SQL ] SELECT total_money-yet_money sy_money,`icard`,`member_id`,`state`,`park_end` FROM `tp_comm_icard` WHERE `site_id` = 968 AND `icard` = '3475095970' ORDER BY `id` ASC [ RunTime:0.006194s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.007318s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 968 [ RunTime:0.006172s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.007379s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`sids`,`socket_num` FROM `tp_charge_orders` WHERE `icard` = '3475095970' AND `site_id` = 968 AND `state` = 1 [ RunTime:0.007606s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.007548s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEWI0017' , 'QY_207' , '{\"Z\":\"207\",\"IDS\":\"YEWI0017\",\"SIDS\":\"BJ000199\",\"IC\":\"3475095970\",\"CZ\":\"4\",\"CS\":\"1\",\"TY\":\"1\",\"MXHao\":\"1\"}' , '{\"Z\":\"207\",\"IDS\":\"YEWI0017\",\"SIDS\":\"BJ000199\",\"CZ\":\"4\",\"IC\":\"3475095970\",\"MONEY\":\"0\",\"MXHao\":\"1\",\"state\":\"0\",\"msg\":\"6\",\"msg2\":\"103\",\"txt\":\"一张卡只允许充【1】台车，已充【1】台\"}' , '2025-07-18 23:55:59') [ RunTime:0.006291s ] [ error ] [8]未定义数组索引: sy_money[D:\www\api\application\index\controller\Receive.php:128] --------------------------------------------------------------- [2025-07-18T23:56:13+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.612947s] [吞吐率：1.63req/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' => '199', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => '10145947', 'SIDS' => 'BJ000059', 'CZ' => '5', 'DH' => '2913441', 'POW' => '122', 'DL' => '0.4483', 'TIM' => '345', 'MSG' => '8', 'POWs' => '2913441', 'MONEY' => '115', 'MSG2' => '5分钟时间无功率自动关闭充电', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009817s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007948s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006795s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.007953s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2913441 LIMIT 1 [ RunTime:0.006777s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.008044s ] [ sql ] [ SQL ] SELECT `total_elec`,`yet_elec`,`total_time`,`yet_time`,`total_num`,`yet_num` FROM `tp_charge_month` WHERE `id` = 85823 LIMIT 1 [ RunTime:0.007448s ] [ sql ] [ SQL ] UPDATE `tp_charge_month` SET `yet_time` = 61.4 WHERE `id` = 85823 [ RunTime:0.006893s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025071818103517528334355996' , `order_money` = 0 , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 345 , `elec_num` = 0.49313 , `power_num` = 122 , `finish` = 8 , `state` = 9 , `other` = '{\"month_id\":85823,\"finish_text\":\"5分钟时间无功率自动关闭充电\",\"POWs\":\"2913441\",\"sj_elec\":\"0.4483\"}' , `finish_time` = '2025-07-18 23:56:13' , `js_result` = '[]' WHERE `id` = 2913441 [ RunTime:0.007646s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007835s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 958 LIMIT 1 [ RunTime:0.006609s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.007994s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006620s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008339s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 1843 LIMIT 1 [ RunTime:0.007219s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008192s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5bcXpioPRy7xH1sic1dBoXs' , '结束充电' , '{\"touser\":\"oCmeh5bcXpioPRy7xH1sic1dBoXs\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"蓝水湾\"},\"time4\":{\"value\":\"2025-07-18 18:10:35\"},\"time3\":{\"value\":\"2025-07-18 23:56:13\"},\"thing5\":{\"value\":\"您的订单【2913441】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=2913441\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 687a6e9d-52b595e0-0f146a01\"}' , '2025-07-18 23:56:13') [ RunTime:0.006927s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.007733s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('10145947' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"10145947\",\"SIDS\":\"BJ000059\",\"CZ\":\"5\",\"DH\":\"2913441\",\"POW\":\"122\",\"DL\":\"0.4483\",\"TIM\":\"345\",\"MSG\":\"8\",\"POWs\":\"2913441\",\"MONEY\":\"115\",\"MSG2\":\"5分钟时间无功率自动关闭充电\"}' , '{\"Z\":\"206\",\"IDS\":\"10145947\",\"SIDS\":\"BJ000059\",\"CZ\":\"5\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-07-18 23:56:13') [ RunTime:0.006774s ] --------------------------------------------------------------- [2025-07-18T23:56:17+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.768186s] [吞吐率：1.30req/s] [内存消耗：4,375.34kb] [文件加载：107] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-type' => 'application/json', 'host' => 'api.scyeby.com', 'content-length' => '104', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '207', 'IDS' => 'YEWI0003', 'SIDS' => 'BJ000190', 'IC' => '3148569813', 'CZ' => '11', 'CS' => '1', 'TY' => '1', 'MXHao' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009243s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007461s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006209s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.007266s ] [ sql ] [ SQL ] SELECT `site_id`,`brand` FROM `tp_charge_equi` WHERE `equi_ids` = 'YEWI0003' LIMIT 1 [ RunTime:0.006179s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007455s ] [ sql ] [ SQL ] SELECT `relation_site_ids` FROM `tp_comm_site` WHERE `id` = 943 LIMIT 1 [ RunTime:0.006538s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.007471s ] [ 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` = 943 AND `icard` = '3148569813' AND `start_time` <= '2025-07-18' AND `end_time` > '2025-07-18' [ RunTime:0.007108s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.007309s ] [ sql ] [ SQL ] SELECT total_money-yet_money sy_money,`icard`,`member_id`,`state`,`park_end` FROM `tp_comm_icard` WHERE `site_id` = 943 AND `icard` = '3148569813' ORDER BY `id` ASC [ RunTime:0.006776s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.007308s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 943 [ RunTime:0.006189s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.007291s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`sids`,`socket_num` FROM `tp_charge_orders` WHERE `icard` = '3148569813' AND `site_id` = 943 AND `state` = 1 [ RunTime:0.010510s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.007675s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 943 LIMIT 1 [ RunTime:0.006634s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 943 [ RunTime:0.006128s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.007402s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 40634 LIMIT 1 [ RunTime:0.006447s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = 'YEWI0003' AND `state` = 1 AND `sids` = 'BJ000190' AND `socket_num` = 11 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.013646s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 943 LIMIT 1 [ RunTime:0.006164s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.007542s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006131s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.007791s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006166s ] [ 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 , 943 , '20250718235617182038' , '3148569813' , 0 , 40634 , '17628329643' , 'YEWI0003' , 11 , 0 , 'BJ000190' , 0 , '2025-07-18 23:56:17' , 1752890177 , '{\"charge_type\":\"4\",\"start_power\":[\"0\",\"201\",\"361\",\"501\"],\"end_power\":[\"200\",\"360\",\"500\",\"950\"],\"price\":[\"1\",\"1\",\"1\",\"1\"],\"time\":[\"2\",\"2\",\"1\",\"1\"]}' , 'qy' , 20 , '{\"month_id\":88085}' , 'main') [ RunTime:0.006515s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2914700 LIMIT 1 [ RunTime:0.006247s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `state` = 1 , `payment_code` = 'month' , `trade_no` = 'HD2025071823561717528541777739' WHERE `id` = 2914700 [ RunTime:0.006576s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.007331s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEWI0003' , 'QY_101' , '{\"Z\":\"101\",\"IDS\":\"YEWI0003\",\"SIDS\":\"BJ000190\",\"CZ\":\"11\",\"MODEL\":\"4\",\"TIM\":\"1200\",\"DL\":\"2000\",\"MONEY\":\"2000\",\"LIST\":\"0_200_100_120,201_360_100_120,361_500_100_60,501_950_100_60\",\"DH\":\"2914700\",\"ZMONEY\":\"0\"}' , '{\"state\":\"1\"}' , '2025-07-18 23:56:17') [ RunTime:0.006159s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 943 LIMIT 1 [ RunTime:0.006141s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.007418s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006236s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 40634 LIMIT 1 [ RunTime:0.006121s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.007833s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5crtN51-L-Ul94p8yU6SAwg' , '开始充电' , '{\"touser\":\"oCmeh5crtN51-L-Ul94p8yU6SAwg\",\"template_id\":\"Agy1VhMUNj0Ts8jwvjW_UqGEDJOg0Y0-39j6y8nhpRg\",\"data\":{\"thing2\":{\"value\":\"锦悦楠庭一号车库\"},\"character_string8\":{\"value\":\"YEWI0003（BJ000190）\"},\"character_string9\":{\"value\":\"No.11\"},\"character_string6\":{\"value\":2914700},\"time3\":{\"value\":\"2025-07-18 23:56:17\"}},\"page\":\"\\/pages\\/orders\\/chargeing?order_id=2914700\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 687a6ea1-322cfdee-490255a6\"}' , '2025-07-18 23:56:17') [ RunTime:0.006428s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEWI0003' , 'QY_207' , '{\"Z\":\"207\",\"IDS\":\"YEWI0003\",\"SIDS\":\"BJ000190\",\"IC\":\"3148569813\",\"CZ\":\"11\",\"CS\":\"1\",\"TY\":\"1\",\"MXHao\":\"1\"}' , '{\"Z\":\"207\",\"IDS\":\"YEWI0003\",\"SIDS\":\"BJ000190\",\"CZ\":\"11\",\"IC\":\"3148569813\",\"MONEY\":\"0\",\"MXHao\":\"1\",\"state\":\"1\",\"msg\":\"5\",\"msg2\":\"45\",\"txt\":\"开电成功\"}' , '2025-07-18 23:56:17') [ RunTime:0.006146s ] [ error ] [8]未定义数组索引: msg[D:\www\api\application\charge\model\Api.php:373] --------------------------------------------------------------- [2025-07-18T23:56:24+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.191066s] [吞吐率：5.23req/s] [内存消耗：4,170.56kb] [文件加载：101] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-type' => 'application/json', 'host' => 'api.scyeby.com', 'content-length' => '104', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '207', 'IDS' => 'YEWI0003', 'SIDS' => 'BJ000190', 'IC' => '3148569813', 'CZ' => '11', 'CS' => '1', 'TY' => '1', 'MXHao' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010139s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008118s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006780s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.008026s ] [ sql ] [ SQL ] SELECT `site_id`,`brand` FROM `tp_charge_equi` WHERE `equi_ids` = 'YEWI0003' LIMIT 1 [ RunTime:0.006706s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007874s ] [ sql ] [ SQL ] SELECT `relation_site_ids` FROM `tp_comm_site` WHERE `id` = 943 LIMIT 1 [ RunTime:0.007204s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.008540s ] [ 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` = 943 AND `icard` = '3148569813' AND `start_time` <= '2025-07-18' AND `end_time` > '2025-07-18' [ RunTime:0.006923s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.007860s ] [ sql ] [ SQL ] SELECT total_money-yet_money sy_money,`icard`,`member_id`,`state`,`park_end` FROM `tp_comm_icard` WHERE `site_id` = 943 AND `icard` = '3148569813' ORDER BY `id` ASC [ RunTime:0.006775s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008204s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 943 [ RunTime:0.006770s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.007981s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`sids`,`socket_num` FROM `tp_charge_orders` WHERE `icard` = '3148569813' AND `site_id` = 943 AND `state` = 1 [ RunTime:0.007152s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008179s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEWI0003' , 'QY_207' , '{\"Z\":\"207\",\"IDS\":\"YEWI0003\",\"SIDS\":\"BJ000190\",\"IC\":\"3148569813\",\"CZ\":\"11\",\"CS\":\"1\",\"TY\":\"1\",\"MXHao\":\"1\"}' , '{\"Z\":\"207\",\"IDS\":\"YEWI0003\",\"SIDS\":\"BJ000190\",\"CZ\":\"11\",\"IC\":\"3148569813\",\"MONEY\":\"0\",\"MXHao\":\"1\",\"state\":\"0\",\"msg\":\"6\",\"msg2\":\"103\",\"txt\":\"一张卡只允许充【1】台车，已充【1】台\"}' , '2025-07-18 23:56:24') [ RunTime:0.006742s ] [ error ] [8]未定义数组索引: sy_money[D:\www\api\application\index\controller\Receive.php:128] --------------------------------------------------------------- [2025-07-18T23:56:29+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.769328s] [吞吐率：1.30req/s] [内存消耗：4,376.80kb] [文件加载：107] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-type' => 'application/json', 'host' => 'api.scyeby.com', 'content-length' => '104', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '207', 'IDS' => 'YEWI0008', 'SIDS' => 'BJ000192', 'IC' => '2071645412', 'CZ' => '10', 'CS' => '1', 'TY' => '1', 'MXHao' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009725s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007737s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006428s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.007626s ] [ sql ] [ SQL ] SELECT `site_id`,`brand` FROM `tp_charge_equi` WHERE `equi_ids` = 'YEWI0008' LIMIT 1 [ RunTime:0.006409s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007584s ] [ sql ] [ SQL ] SELECT `relation_site_ids` FROM `tp_comm_site` WHERE `id` = 950 LIMIT 1 [ RunTime:0.006502s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.007645s ] [ 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` = 950 AND `icard` = '2071645412' AND `start_time` <= '2025-07-18' AND `end_time` > '2025-07-18' [ RunTime:0.006907s ] [ 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` = '2071645412' AND `start_time` <= '2025-07-18' AND `end_time` >= '2025-07-18' [ RunTime:0.006469s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.007637s ] [ sql ] [ SQL ] SELECT total_money-yet_money sy_money,`icard`,`member_id`,`state`,`park_end` FROM `tp_comm_icard` WHERE `site_id` = 950 AND `icard` = '2071645412' ORDER BY `id` ASC [ RunTime:0.008301s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.007665s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 950 [ RunTime:0.006428s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.007903s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`sids`,`socket_num` FROM `tp_charge_orders` WHERE `icard` = '2071645412' AND `site_id` = 950 AND `state` = 1 [ RunTime:0.009698s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.007808s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 950 LIMIT 1 [ RunTime:0.006417s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 950 [ RunTime:0.006354s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.007678s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 1825 LIMIT 1 [ RunTime:0.006418s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = 'YEWI0008' AND `state` = 1 AND `sids` = 'BJ000192' AND `socket_num` = 10 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.007661s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 950 LIMIT 1 [ RunTime:0.006352s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.007821s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006412s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.007544s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006379s ] [ 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 , 950 , '20250718235629937682' , '2071645412' , 0 , 1825 , '13980565780' , 'YEWI0008' , 10 , 0 , 'BJ000192' , 10 , '2025-07-18 23:56:29' , 1752890189 , '{\"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.006863s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2914701 LIMIT 1 [ RunTime:0.006515s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `state` = 1 , `payment_code` = 'icardyue' , `trade_no` = 'HD2025071823562917528541893285' WHERE `id` = 2914701 [ RunTime:0.006727s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.007753s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEWI0008' , 'QY_101' , '{\"Z\":\"101\",\"IDS\":\"YEWI0008\",\"SIDS\":\"BJ000192\",\"CZ\":\"10\",\"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\":\"2914701\",\"ZMONEY\":\"1570\"}' , '{\"state\":\"1\"}' , '2025-07-18 23:56:29') [ RunTime:0.006357s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 950 LIMIT 1 [ RunTime:0.006392s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.007649s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006516s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 1825 LIMIT 1 [ RunTime:0.006401s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.007942s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5aVUib3JqWuSWreJuQv2srs' , '开始充电' , '{\"touser\":\"oCmeh5aVUib3JqWuSWreJuQv2srs\",\"template_id\":\"Agy1VhMUNj0Ts8jwvjW_UqGEDJOg0Y0-39j6y8nhpRg\",\"data\":{\"thing2\":{\"value\":\"浅水半岛一期\"},\"character_string8\":{\"value\":\"YEWI0008（BJ000192）\"},\"character_string9\":{\"value\":\"No.10\"},\"character_string6\":{\"value\":2914701},\"time3\":{\"value\":\"2025-07-18 23:56:29\"}},\"page\":\"\\/pages\\/orders\\/chargeing?order_id=2914701\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 687a6ead-018c939a-1165f17b\"}' , '2025-07-18 23:56:29') [ RunTime:0.007867s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEWI0008' , 'QY_207' , '{\"Z\":\"207\",\"IDS\":\"YEWI0008\",\"SIDS\":\"BJ000192\",\"IC\":\"2071645412\",\"CZ\":\"10\",\"CS\":\"1\",\"TY\":\"1\",\"MXHao\":\"1\"}' , '{\"Z\":\"207\",\"IDS\":\"YEWI0008\",\"SIDS\":\"BJ000192\",\"CZ\":\"10\",\"IC\":\"2071645412\",\"MONEY\":\"1570\",\"MXHao\":\"1\",\"state\":\"1\",\"msg\":\"5\",\"msg2\":\"45\",\"txt\":\"开电成功\"}' , '2025-07-18 23:56:29') [ RunTime:0.006405s ] [ error ] [8]未定义数组索引: msg[D:\www\api\application\charge\model\Api.php:373] --------------------------------------------------------------- [2025-07-18T23:56:42+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.817053s] [吞吐率：1.22req/s] [内存消耗：4,375.99kb] [文件加载：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' => '10145853', 'SIDS' => 'BJ000029', 'IC' => '2710424379', 'CZ' => '1', 'CS' => '1', 'TY' => '1', 'MXHao' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009789s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007964s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006588s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.008145s ] [ sql ] [ SQL ] SELECT `site_id`,`brand` FROM `tp_charge_equi` WHERE `equi_ids` = '10145853' LIMIT 1 [ RunTime:0.006583s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008379s ] [ sql ] [ SQL ] SELECT `relation_site_ids` FROM `tp_comm_site` WHERE `id` = 964 LIMIT 1 [ RunTime:0.006593s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.007880s ] [ 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` = '2710424379' AND `start_time` <= '2025-07-18' AND `end_time` > '2025-07-18' [ RunTime:0.007409s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.008651s ] [ 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` = '2710424379' ORDER BY `id` ASC [ RunTime:0.008448s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008261s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 964 [ RunTime:0.006597s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.009246s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`sids`,`socket_num` FROM `tp_charge_orders` WHERE `icard` = '2710424379' AND `site_id` = 964 AND `state` = 1 [ RunTime:0.009863s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.008031s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 964 LIMIT 1 [ RunTime:0.007232s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 964 [ RunTime:0.006598s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.007898s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 46396 LIMIT 1 [ RunTime:0.006976s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = '10145853' AND `state` = 1 AND `sids` = 'BJ000029' AND `socket_num` = 1 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.007894s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 964 LIMIT 1 [ RunTime:0.006531s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.007783s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006569s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.007788s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006585s ] [ 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 , '20250718235642147996' , '2710424379' , 0 , 46396 , '15282300653' , '10145853' , 1 , 0 , 'BJ000029' , 10 , '2025-07-18 23:56:42' , 1752890202 , '{\"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\":84058}' , 'main') [ RunTime:0.006912s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2914702 LIMIT 1 [ RunTime:0.006817s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `state` = 1 , `payment_code` = 'month' , `trade_no` = 'HD2025071823564217528542028564' WHERE `id` = 2914702 [ RunTime:0.007059s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008155s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('10145853' , 'QY_101' , '{\"Z\":\"101\",\"IDS\":\"10145853\",\"SIDS\":\"BJ000029\",\"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\":\"2914702\",\"ZMONEY\":\"866\"}' , '{\"state\":\"1\"}' , '2025-07-18 23:56:42') [ RunTime:0.006644s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 964 LIMIT 1 [ RunTime:0.006522s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.009266s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006629s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 46396 LIMIT 1 [ RunTime:0.006552s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.007744s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5RnquToqy0GGsx8AcnPM06c' , '开始充电' , '{\"touser\":\"oCmeh5RnquToqy0GGsx8AcnPM06c\",\"template_id\":\"Agy1VhMUNj0Ts8jwvjW_UqGEDJOg0Y0-39j6y8nhpRg\",\"data\":{\"thing2\":{\"value\":\"润新花园A区\"},\"character_string8\":{\"value\":\"10145853（BJ000029）\"},\"character_string9\":{\"value\":\"No.1\"},\"character_string6\":{\"value\":2914702},\"time3\":{\"value\":\"2025-07-18 23:56:42\"}},\"page\":\"\\/pages\\/orders\\/chargeing?order_id=2914702\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 687a6eba-64ea7f30-3dc5e3a4\"}' , '2025-07-18 23:56:42') [ RunTime:0.006905s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('10145853' , 'QY_207' , '{\"Z\":\"207\",\"IDS\":\"10145853\",\"SIDS\":\"BJ000029\",\"IC\":\"2710424379\",\"CZ\":\"1\",\"CS\":\"1\",\"TY\":\"1\",\"MXHao\":\"1\"}' , '{\"Z\":\"207\",\"IDS\":\"10145853\",\"SIDS\":\"BJ000029\",\"CZ\":\"1\",\"IC\":\"2710424379\",\"MONEY\":\"866\",\"MXHao\":\"1\",\"state\":\"1\",\"msg\":\"5\",\"msg2\":\"45\",\"txt\":\"开电成功\"}' , '2025-07-18 23:56:42') [ RunTime:0.006536s ] [ error ] [8]未定义数组索引: msg[D:\www\api\application\charge\model\Api.php:373] --------------------------------------------------------------- [2025-07-18T23:56:43+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：1.623587s] [吞吐率：0.62req/s] [内存消耗：4,232.95kb] [文件加载：101] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-type' => 'application/json', 'host' => 'api.scyeby.com', 'content-length' => '197', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => 'YEWI0034', 'SIDS' => 'BJ000250', 'CZ' => '3', 'DH' => '2914363', 'POW' => '246', 'DL' => '0.4428', 'TIM' => '143', 'MSG' => '8', 'POWs' => '2914363', 'MONEY' => '85', 'MSG2' => '检测到插座无充电器结束订单', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009359s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007810s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006275s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008001s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2914363 LIMIT 1 [ RunTime:0.006357s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.007392s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 967 [ RunTime:0.006384s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.007525s ] [ sql ] [ SQL ] SELECT `rate` FROM `tp_comm_consume` WHERE `trade_no` = '4200002794202507181924843714' LIMIT 1 [ RunTime:0.007243s ] [ sql ] [ SQL ] SELECT `id`,`order_sn`,`pay_config`,`pay_money`,`trade_no` FROM `tp_comm_consume` WHERE `trade_no` = '4200002794202507181924843714' LIMIT 1 [ RunTime:0.006201s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_pay` [ RunTime:0.008498s ] [ sql ] [ SQL ] INSERT INTO `tp_log_pay` (`trade_no` , `content` , `result` , `ctime`) VALUES ('TK4200002794202507181924843714' , '{\"trade_no\":\"4200002794202507181924843714\",\"order_sn\":\"Y20250718213215680050\",\"pay_money\":1,\"refund_money\":0.12}' , '{\"code\":200,\"msg\":\"退款成功\",\"data\":{\"return_code\":\"SUCCESS\",\"return_msg\":\"OK\",\"appid\":\"wx9d3af783c5718533\",\"mch_id\":\"1511337021\",\"nonce_str\":\"j9yWvddGR9yn6juG\",\"sign\":\"9B2EC998C1814E8ACCAE5004A1815E6D\",\"result_code\":\"SUCCESS\",\"transaction_id\":\"4200002794202507181924843714\",\"out_trade_no\":\"Y20250718213215680050\",\"out_refund_no\":\"Y20250718213215680050\",\"refund_id\":\"50303404032025071856841147130\",\"refund_channel\":[],\"refund_fee\":\"12\",\"coupon_refund_fee\":\"0\",\"total_fee\":\"100\",\"cash_fee\":\"100\",\"coupon_refund_count\":\"0\",\"cash_refund_fee\":\"12\"}}' , '2025-07-18 23:56:42') [ RunTime:0.006464s ] [ sql ] [ SQL ] UPDATE `tp_comm_consume` SET `refund_money` = 0.12 , `refund_state` = 9 , `refund_day` = '2025-07-18' , `refund_month` = '2025-07' , `refund_remark` = ',系统自动退款' WHERE `id` = 2112412 [ RunTime:0.006659s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007736s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 967 LIMIT 1 [ RunTime:0.006268s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.007456s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006355s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.007581s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006267s ] [ sql ] [ SQL ] SELECT `nickname`,`mobile` FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006263s ] [ sql ] [ SQL ] SELECT `total_money` FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006219s ] [ sql ] [ SQL ] UPDATE `tp_comm_user` SET `total_money` = `total_money` + 0.88 WHERE `user_id` = 438 [ RunTime:0.006255s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_packet` [ RunTime:0.008186s ] [ 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 ( 967,438,1,'0.88',9,'charge_temp','2025-07-18 21:32:15','2025-07-18 23:56:42','{\"order_money\":\"0.88\",\"old_money\":4202943}','4200002794202507181924843714','元贰佰壹科技有限公司','18980369999','100%','2025-07','2025-07-18','main' ) [ RunTime:0.011317s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = '4200002794202507181924843714' , `order_money` = '0.88' , `refund_money` = 0.12 , `refund_state` = 9 , `time_num` = 143 , `elec_num` = 0.48708 , `power_num` = 246 , `finish` = 8 , `state` = 9 , `other` = '{\"finish_text\":\"检测到插座无充电器结束订单\",\"POWs\":\"2914363\",\"sj_elec\":\"0.4428\"}' , `finish_time` = '2025-07-18 23:56:42' , `js_result` = '{\"money\":\"0.88\",\"elec_num\":0.48708,\"elec_price\":\"0.579\",\"timeNum\":3,\"server_price\":\"0.2\"}' WHERE `id` = 2914363 [ RunTime:0.006382s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 967 LIMIT 1 [ RunTime:0.006254s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.007463s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006348s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.007360s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 45194 LIMIT 1 [ RunTime:0.007360s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008020s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5a5HeQH5oK88C7qr6vNM3fA' , '结束充电' , '{\"touser\":\"oCmeh5a5HeQH5oK88C7qr6vNM3fA\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"上行锦绣5栋\"},\"time4\":{\"value\":\"2025-07-18 21:32:15\"},\"time3\":{\"value\":\"2025-07-18 23:56:42\"},\"thing5\":{\"value\":\"您的订单【2914363】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=2914363\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 687a6eba-0dcb250c-3d6a4ef8\"}' , '2025-07-18 23:56:43') [ RunTime:0.007519s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008398s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEWI0034' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YEWI0034\",\"SIDS\":\"BJ000250\",\"CZ\":\"3\",\"DH\":\"2914363\",\"POW\":\"246\",\"DL\":\"0.4428\",\"TIM\":\"143\",\"MSG\":\"8\",\"POWs\":\"2914363\",\"MONEY\":\"85\",\"MSG2\":\"检测到插座无充电器结束订单\"}' , '{\"Z\":\"206\",\"IDS\":\"YEWI0034\",\"SIDS\":\"BJ000250\",\"CZ\":\"3\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-07-18 23:56:43') [ RunTime:0.006244s ] --------------------------------------------------------------- [2025-07-18T23:57:04+08:00] 171.219.176.142 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.471481s] [吞吐率：2.12req/s] [内存消耗：4,117.24kb] [文件加载：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' => 'oCmeh5drRzb9x2GozB4EYkfbm6DQ', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 12; JER-AN10 Build/HUAWEIJER-AN10; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/134.0.6998.136 Mobile Safari/537.36 XWEB/1340153 MMWEBSDK/20250503 MMWEBID/5725 MicroMessenger/8.0.61.2880(0x28003D51) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/getChargeData', 'host' => 'main', 'pageSize' => '15', 'sids' => 'BJ000187', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009428s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007633s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006306s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.007437s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5drRzb9x2GozB4EYkfbm6DQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006326s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.007865s ] [ sql ] [ SQL ] SELECT `id`,`openid`,`name`,`mobile` FROM `tp_comm_member` WHERE `openid` = 'oCmeh5drRzb9x2GozB4EYkfbm6DQ' LIMIT 1 [ RunTime:0.165445s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_cache` WHERE `key` = 'oCmeh5drRzb9x2GozB4EYkfbm6DQ' LIMIT 1 [ RunTime:0.006320s ] [ sql ] [ SQL ] INSERT INTO `tp_cache` (`tables` , `key` , `value`) VALUES ('comm_member' , 'oCmeh5drRzb9x2GozB4EYkfbm6DQ' , '{\"id\":41129,\"openid\":\"oCmeh5drRzb9x2GozB4EYkfbm6DQ\",\"name\":\"微信用户\",\"mobile\":\"18123469855\"}') [ RunTime:0.006168s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5drRzb9x2GozB4EYkfbm6DQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006295s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_socket` [ RunTime:0.007770s ] [ sql ] [ SQL ] SELECT `equi_id`,`num`,`socket_list`,`name` FROM `tp_charge_socket` WHERE `code` = 'BJ000187' [ RunTime:0.015137s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.007645s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`brand`,`site_id` FROM `tp_charge_equi` WHERE `id` = 709 LIMIT 1 [ RunTime:0.006868s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007684s ] [ sql ] [ SQL ] SELECT `id`,`name`,`state`,`server_tel` FROM `tp_comm_site` WHERE `id` = 948 LIMIT 1 [ RunTime:0.006762s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.007446s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 948 LIMIT 1 [ RunTime:0.007144s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.007536s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 948 LIMIT 1 [ RunTime:0.006709s ] [ error ] [8]未定义数组索引: time[D:\www\api\application\member\controller\Charge.php:288] --------------------------------------------------------------- [2025-07-18T23:57:11+08:00] 175.24.211.4 POST api.scyeby.com/public/index.php/index/Wxservice/index.html?signature=6ede4097f69d39c26d9c705ee3d9b7378f91e768×tamp=1752854230&nonce=373083945&openid=oCmeh5drRzb9x2GozB4EYkfbm6DQ [运行时间：0.062626s] [吞吐率：15.97req/s] [内存消耗：3,503.61kb] [文件加载：86] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'user-agent' => 'Mozilla/4.0', 'accept' => '*/*', 'host' => 'api.scyeby.com', 'pragma' => 'no-cache', 'content-length' => '688', 'content-type' => 'text/xml', ) [ info ] [ PARAM ] array ( 'signature' => '6ede4097f69d39c26d9c705ee3d9b7378f91e768', 'timestamp' => '1752854230', 'nonce' => '373083945', 'openid' => 'oCmeh5drRzb9x2GozB4EYkfbm6DQ', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009529s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008389s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006356s ] --------------------------------------------------------------- [2025-07-18T23:57:11+08:00] 171.219.176.142 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.312341s] [吞吐率：3.20req/s] [内存消耗：4,197.84kb] [文件加载：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' => '1265', 'content-type' => 'application/x-www-form-urlencoded', 'x-token' => 'oCmeh5drRzb9x2GozB4EYkfbm6DQ', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 12; JER-AN10 Build/HUAWEIJER-AN10; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/134.0.6998.136 Mobile Safari/537.36 XWEB/1340153 MMWEBSDK/20250503 MMWEBID/5725 MicroMessenger/8.0.61.2880(0x28003D51) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/createOrder', 'host' => 'main', 'pageSize' => '15', 'state' => '9', 'state_msg' => '', 'site_id' => '948', 'site_name' => '孔雀城单独充电', 'site_server' => '18980369999', 'equi_ids' => 'YE4G0002', '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' => 'BJ000187', 'price_info' => '[object Object]', 'money_list' => '[object Object],[object Object],[object Object],[object Object],[object Object],[object Object]', 'money_name' => '按电量计费', 'pay_money' => '4.8', 'value' => '5', 'socket_num' => '3', '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.017621s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008297s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007196s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.009707s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5drRzb9x2GozB4EYkfbm6DQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006314s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5drRzb9x2GozB4EYkfbm6DQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006828s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008079s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 948 [ RunTime:0.007579s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 948 [ RunTime:0.006251s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.007618s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 41129 LIMIT 1 [ RunTime:0.007174s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.007548s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = 'YE4G0002' AND `state` = 1 AND `sids` = 'BJ000187' AND `socket_num` = 3 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.030516s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007616s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 948 LIMIT 1 [ RunTime:0.006830s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008008s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006346s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.007680s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006895s ] [ 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 , '20250718235711109491' , NULL , 0 , 41129 , '18123469855' , 'YE4G0002' , 3 , 0 , 'BJ000187' , '4.8' , '2025-07-18 23:57:11' , 1752890231 , '{\"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' , 5 , '[]' , 'main') [ RunTime:0.009384s ] [ sql ] [ SQL ] SELECT 948,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 948 [ RunTime:0.006273s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.007440s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 948 [ RunTime:0.007676s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006319s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006280s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.007589s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006361s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.007784s ] [ 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 , 'Y20250718235711928878' , NULL , 948 , 41129 , 41129 , '4.8' , '4.8' , 'charge_temp' , '2025-07-18 23:57:11' , '{\"site_id\":\"948\",\"site_name\":\"孔雀城单独充电\",\"equi_ids\":\"YE4G0002\",\"equi_brand\":\"qy\",\"sids\":\"BJ000187\",\"socket_num\":\"3\",\"socket_no\":\"\",\"value\":\"5\",\"order_id\":\"2914703\",\"sy_money\":\"4.8\"}' , '{\"appId\":\"wx9d3af783c5718533\",\"appSecret\":\"49cd7ec1b8418d1dcb19ce60b78ccb95\",\"partnerId\":\"1511337021\",\"apiKey\":\"f02795ff419df1f67b1b59aa0ca06754\",\"code\":\"yeby\",\"name\":\"元贰佰壹\"}' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '临时充电' , '2025-07' , '2025-07-18' , NULL , 'main') [ RunTime:0.010356s ] [ error ] [8]未定义数组索引: icard[D:\www\api\application\charge\model\Orders.php:79] [ error ] [8]未定义数组索引: other[D:\www\api\application\charge\model\Orders.php:93] [ error ] [8]未定义数组索引: icard[D:\www\api\application\comm\model\Consume.php:53] [ error ] [8]未定义数组索引: remark[D:\www\api\application\comm\model\Consume.php:67] --------------------------------------------------------------- [2025-07-18T23:57:12+08:00] 171.219.176.142 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.523847s] [吞吐率：1.91req/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' => 'oCmeh5drRzb9x2GozB4EYkfbm6DQ', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 12; JER-AN10 Build/HUAWEIJER-AN10; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/134.0.6998.136 Mobile Safari/537.36 XWEB/1340153 MMWEBSDK/20250503 MMWEBID/5725 MicroMessenger/8.0.61.2880(0x28003D51) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/consume/getPayment', 'host' => 'main', 'pageSize' => '15', 'order_id' => '2112671', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.018040s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008036s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006851s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.007834s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5drRzb9x2GozB4EYkfbm6DQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006559s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5drRzb9x2GozB4EYkfbm6DQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006529s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008666s ] [ sql ] [ SQL ] SELECT `id`,`state`,`src_by`,`pay_money`,`order_sn`,`pay_config` FROM `tp_comm_consume` WHERE `id` = 2112671 LIMIT 1 [ RunTime:0.006582s ] [ error ] [8]未定义数组索引: paysuc_url[D:\www\api\application\index\controller\Payment.php:41] [ error ] [8]未定义数组索引: payerr_url[D:\www\api\application\index\controller\Payment.php:42] --------------------------------------------------------------- [2025-07-18T23:57:19+08:00] 140.207.54.76 POST api.scyeby.com/public/index.php/index/payment/wxnotify.html [运行时间：0.751623s] [吞吐率：1.33req/s] [内存消耗：4,124.05kb] [文件加载：97] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-length' => '826', 'user-agent' => 'Mozilla/4.0', 'content-type' => 'text/xml', 'pragma' => 'no-cache', 'connection' => 'Keep-Alive', 'host' => 'api.scyeby.com', 'accept' => '*/*', ) [ info ] [ PARAM ] array ( ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009626s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008055s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006493s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_pay` [ RunTime:0.007707s ] [ sql ] [ SQL ] INSERT INTO `tp_log_pay` (`trade_no` , `content` , `result` , `ctime`) VALUES ('4200002778202507182480035252' , '{\"appid\":\"wx9d3af783c5718533\",\"attach\":\"2112671\",\"bank_type\":\"OTHERS\",\"cash_fee\":\"480\",\"fee_type\":\"CNY\",\"is_subscribe\":\"N\",\"mch_id\":\"1511337021\",\"nonce_str\":\"dd33770ec3c03d69c3f017a98f3a7126\",\"openid\":\"oCmeh5drRzb9x2GozB4EYkfbm6DQ\",\"out_trade_no\":\"Y20250718235711928878\",\"result_code\":\"SUCCESS\",\"return_code\":\"SUCCESS\",\"sign\":\"FAB4BBFC8E48CF64F3EC27874777F196\",\"time_end\":\"20250718235718\",\"total_fee\":\"480\",\"trade_type\":\"JSAPI\",\"transaction_id\":\"4200002778202507182480035252\"}' , '[]' , '2025-07-18 23:57:18') [ RunTime:0.006429s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008081s ] [ sql ] [ SQL ] SELECT `id`,`state`,`ctime`,`details`,`src_by`,`order_money`,`rate` FROM `tp_comm_consume` WHERE `id` = 2112671 LIMIT 1 [ RunTime:0.006464s ] [ sql ] [ SQL ] UPDATE `tp_comm_consume` SET `state` = 9 , `payment_code` = 'wxpay' , `trade_no` = '4200002778202507182480035252' WHERE `id` = 2112671 [ RunTime:0.008589s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.007740s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2914703 LIMIT 1 [ RunTime:0.008185s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `state` = 1 , `payment_code` = 'wxpay' , `trade_no` = '4200002778202507182480035252' WHERE `id` = 2914703 [ RunTime:0.006502s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.007759s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0002' , 'QY_101' , '{\"Z\":\"101\",\"IDS\":\"YE4G0002\",\"SIDS\":\"BJ000187\",\"CZ\":\"3\",\"MODEL\":\"3\",\"TIM\":\"300\",\"DL\":\"500\",\"MONEY\":\"500\",\"LIST\":\"\",\"DH\":\"2914703\",\"ZMONEY\":\"480\"}' , '{\"state\":\"1\"}' , '2025-07-18 23:57:18') [ RunTime:0.006587s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007714s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 948 LIMIT 1 [ RunTime:0.009525s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.007741s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006545s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008143s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 41129 LIMIT 1 [ RunTime:0.006459s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008064s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5drRzb9x2GozB4EYkfbm6DQ' , '开始充电' , '{\"touser\":\"oCmeh5drRzb9x2GozB4EYkfbm6DQ\",\"template_id\":\"Agy1VhMUNj0Ts8jwvjW_UqGEDJOg0Y0-39j6y8nhpRg\",\"data\":{\"thing2\":{\"value\":\"孔雀城单独充电\"},\"character_string8\":{\"value\":\"YE4G0002（BJ000187）\"},\"character_string9\":{\"value\":\"No.3\"},\"character_string6\":{\"value\":2914703},\"time3\":{\"value\":\"2025-07-18 23:57:11\"}},\"page\":\"\\/pages\\/orders\\/chargeing?order_id=2914703\"}' , '{\"errcode\":0,\"errmsg\":\"ok\",\"msgid\":4081258585848463360}' , '2025-07-18 23:57:19') [ RunTime:0.008041s ] [ sql ] [ SQL ] UPDATE `tp_log_pay` SET `result` = '{\"code\":200}' WHERE `trade_no` = '4200002778202507182480035252' [ RunTime:0.006432s ] --------------------------------------------------------------- [2025-07-18T23:57:20+08:00] 124.220.226.99 POST api.scyeby.com/public/index.php/index/Wxservice/index.html?signature=eeccc7e0e5a67df1a34dc8297300ba00fe8d1934×tamp=1752854239&nonce=1080175172&openid=oCmeh5drRzb9x2GozB4EYkfbm6DQ [运行时间：0.066874s] [吞吐率：14.95req/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' => 'eeccc7e0e5a67df1a34dc8297300ba00fe8d1934', 'timestamp' => '1752854239', 'nonce' => '1080175172', 'openid' => 'oCmeh5drRzb9x2GozB4EYkfbm6DQ', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.016626s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007980s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006428s ] --------------------------------------------------------------- [2025-07-18T23:57:20+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：1.800608s] [吞吐率：0.56req/s] [内存消耗：4,232.84kb] [文件加载：101] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-type' => 'application/json', 'host' => 'api.scyeby.com', 'content-length' => '170', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => 'YE4G0070', 'SIDS' => 'C60B8516', 'CZ' => '1', 'DH' => '2913464', 'POW' => '365', 'DL' => '1.4452', 'TIM' => '340', 'MSG' => '10', 'POWs' => '2913464', 'MONEY' => '0', 'MSG2' => '充满停止', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009784s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007993s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006558s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.007857s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2913464 LIMIT 1 [ RunTime:0.006636s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.007946s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 948 [ RunTime:0.006599s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.007965s ] [ sql ] [ SQL ] SELECT `rate` FROM `tp_comm_consume` WHERE `trade_no` = '4200002771202507184293425161' LIMIT 1 [ RunTime:0.007388s ] [ sql ] [ SQL ] SELECT `id`,`order_sn`,`pay_config`,`pay_money`,`trade_no` FROM `tp_comm_consume` WHERE `trade_no` = '4200002771202507184293425161' LIMIT 1 [ RunTime:0.006529s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_pay` [ RunTime:0.007998s ] [ sql ] [ SQL ] INSERT INTO `tp_log_pay` (`trade_no` , `content` , `result` , `ctime`) VALUES ('TK4200002771202507184293425161' , '{\"trade_no\":\"4200002771202507184293425161\",\"order_sn\":\"Y20250718181625757529\",\"pay_money\":1.92,\"refund_money\":0.3899999999999999}' , '{\"code\":200,\"msg\":\"退款成功\",\"data\":{\"return_code\":\"SUCCESS\",\"return_msg\":\"OK\",\"appid\":\"wx9d3af783c5718533\",\"mch_id\":\"1511337021\",\"nonce_str\":\"NlQbgQnCNHNxVLbt\",\"sign\":\"6AF9CC4EEDD97CA5A44C985327C9B783\",\"result_code\":\"SUCCESS\",\"transaction_id\":\"4200002771202507184293425161\",\"out_trade_no\":\"Y20250718181625757529\",\"out_refund_no\":\"Y20250718181625757529\",\"refund_id\":\"50300104042025071844431692126\",\"refund_channel\":[],\"refund_fee\":\"39\",\"coupon_refund_fee\":\"0\",\"total_fee\":\"192\",\"cash_fee\":\"192\",\"coupon_refund_count\":\"0\",\"cash_refund_fee\":\"39\"}}' , '2025-07-18 23:57:20') [ RunTime:0.006509s ] [ sql ] [ SQL ] UPDATE `tp_comm_consume` SET `refund_money` = 0.39 , `refund_state` = 9 , `refund_day` = '2025-07-18' , `refund_month` = '2025-07' , `refund_remark` = ',系统自动退款' WHERE `id` = 2112016 [ RunTime:0.006933s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008437s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 948 LIMIT 1 [ RunTime:0.006495s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.007775s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006620s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.007793s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006545s ] [ sql ] [ SQL ] SELECT `nickname`,`mobile` FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006488s ] [ sql ] [ SQL ] SELECT `total_money` FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006521s ] [ sql ] [ SQL ] UPDATE `tp_comm_user` SET `total_money` = `total_money` + 1.53 WHERE `user_id` = 438 [ RunTime:0.006555s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_packet` [ RunTime:0.007807s ] [ 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,'1.53',9,'charge_temp','2025-07-18 18:16:25','2025-07-18 23:57:20','{\"order_money\":\"1.53\",\"old_money\":4202944}','4200002771202507184293425161','元贰佰壹科技有限公司','18980369999','100%','2025-07','2025-07-18','main' ) [ RunTime:0.010309s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = '4200002771202507184293425161' , `order_money` = '1.53' , `refund_money` = 0.39 , `refund_state` = 9 , `time_num` = 340 , `elec_num` = 1.58972 , `power_num` = 365 , `finish` = 10 , `state` = 9 , `other` = '{\"finish_text\":\"充满停止\",\"POWs\":\"2913464\",\"sj_elec\":\"1.4452\"}' , `finish_time` = '2025-07-18 23:57:20' , `js_result` = '{\"money\":\"1.53\",\"num\":1.58972,\"first_price\":\"0.96\",\"first_time\":\"1\",\"dw_price\":\"0.96\",\"by_card_price\":0}' WHERE `id` = 2913464 [ RunTime:0.007161s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 948 LIMIT 1 [ RunTime:0.006659s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008165s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006704s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.007669s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 810 LIMIT 1 [ RunTime:0.006926s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.007992s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5Zy0AnQjPaJYuwVFOBlYsjs' , '结束充电' , '{\"touser\":\"oCmeh5Zy0AnQjPaJYuwVFOBlYsjs\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"孔雀城单独充电\"},\"time4\":{\"value\":\"2025-07-18 18:16:25\"},\"time3\":{\"value\":\"2025-07-18 23:57:20\"},\"thing5\":{\"value\":\"您的订单【2913464】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=2913464\"}' , '{\"errcode\":0,\"errmsg\":\"ok\",\"msgid\":4081258608044802053}' , '2025-07-18 23:57:20') [ RunTime:0.006850s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008173s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0070' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YE4G0070\",\"SIDS\":\"C60B8516\",\"CZ\":\"1\",\"DH\":\"2913464\",\"POW\":\"365\",\"DL\":\"1.4452\",\"TIM\":\"340\",\"MSG\":\"10\",\"POWs\":\"2913464\",\"MONEY\":\"0\",\"MSG2\":\"充满停止\"}' , '{\"Z\":\"206\",\"IDS\":\"YE4G0070\",\"SIDS\":\"C60B8516\",\"CZ\":\"1\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-07-18 23:57:20') [ RunTime:0.006614s ] --------------------------------------------------------------- [2025-07-18T23:57:21+08:00] 81.69.103.129 POST api.scyeby.com/public/index.php/index/Wxservice/index.html?signature=f7baf50cda44889488181f2b38364f4546a1f973×tamp=1752854240&nonce=1052253810&openid=oCmeh5Zy0AnQjPaJYuwVFOBlYsjs [运行时间：0.059174s] [吞吐率：16.90req/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' => 'f7baf50cda44889488181f2b38364f4546a1f973', 'timestamp' => '1752854240', 'nonce' => '1052253810', 'openid' => 'oCmeh5Zy0AnQjPaJYuwVFOBlYsjs', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009612s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007767s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006482s ] --------------------------------------------------------------- [2025-07-18T23:57:23+08:00] 171.219.176.142 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.106054s] [吞吐率：9.43req/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' => 'oCmeh5drRzb9x2GozB4EYkfbm6DQ', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 12; JER-AN10 Build/HUAWEIJER-AN10; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/134.0.6998.136 Mobile Safari/537.36 XWEB/1340153 MMWEBSDK/20250503 MMWEBID/5725 MicroMessenger/8.0.61.2880(0x28003D51) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/park/getLists', 'host' => 'main', 'pageSize' => '15', 'page_num' => '1', 'state' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010671s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007767s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.007455s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.009412s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5drRzb9x2GozB4EYkfbm6DQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007645s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5drRzb9x2GozB4EYkfbm6DQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006605s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_park_orders` [ RunTime:0.007829s ] [ 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` = 41129 AND `state` IN (1,8) ORDER BY `state` ASC,`id` DESC LIMIT 30 [ RunTime:0.008342s ] --------------------------------------------------------------- [2025-07-18T23:57:23+08:00] 171.219.176.142 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.290590s] [吞吐率：3.44req/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' => 'oCmeh5drRzb9x2GozB4EYkfbm6DQ', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 12; JER-AN10 Build/HUAWEIJER-AN10; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/134.0.6998.136 Mobile Safari/537.36 XWEB/1340153 MMWEBSDK/20250503 MMWEBID/5725 MicroMessenger/8.0.61.2880(0x28003D51) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/getChargeData', 'host' => 'main', 'pageSize' => '15', 'sids' => 'BJ000187', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.017358s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007953s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006658s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.007723s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5drRzb9x2GozB4EYkfbm6DQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006512s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5drRzb9x2GozB4EYkfbm6DQ' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006610s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_socket` [ RunTime:0.008524s ] [ sql ] [ SQL ] SELECT `equi_id`,`num`,`socket_list`,`name` FROM `tp_charge_socket` WHERE `code` = 'BJ000187' [ RunTime:0.019220s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.008225s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`brand`,`site_id` FROM `tp_charge_equi` WHERE `id` = 709 LIMIT 1 [ RunTime:0.007525s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.009118s ] [ sql ] [ SQL ] SELECT `id`,`name`,`state`,`server_tel` FROM `tp_comm_site` WHERE `id` = 948 LIMIT 1 [ RunTime:0.006550s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008247s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 948 LIMIT 1 [ RunTime:0.006562s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.015153s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 948 LIMIT 1 [ RunTime:0.007758s ] [ error ] [8]未定义数组索引: time[D:\www\api\application\member\controller\Charge.php:288] --------------------------------------------------------------- [2025-07-18T23:57:46+08:00] 222.212.10.157 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.269082s] [吞吐率：3.72req/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' => 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 10; YAL-AL00 Build/HUAWEIYAL-AL00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.157 Mobile Safari/537.36 XWEB/1380055 MMWEBSDK/20250503 MMWEBID/4826 MicroMessenger/8.0.61.2880(0x28003D3F) WeChat/arm64 Weixin NetType/WIFI Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/getChargeData', 'host' => 'main', 'pageSize' => '15', 'sids' => 'BJ000263', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.017484s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007888s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006288s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.007827s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006707s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006217s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_socket` [ RunTime:0.007740s ] [ sql ] [ SQL ] SELECT `equi_id`,`num`,`socket_list`,`name` FROM `tp_charge_socket` WHERE `code` = 'BJ000263' [ RunTime:0.009953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.007429s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`brand`,`site_id` FROM `tp_charge_equi` WHERE `id` = 316 LIMIT 1 [ RunTime:0.006638s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007518s ] [ sql ] [ SQL ] SELECT `id`,`name`,`state`,`server_tel` FROM `tp_comm_site` WHERE `id` = 968 LIMIT 1 [ RunTime:0.006234s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.007413s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 968 LIMIT 1 [ RunTime:0.006384s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.007789s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 968 LIMIT 1 [ RunTime:0.006918s ] --------------------------------------------------------------- [2025-07-18T23:57:51+08:00] 182.143.209.221 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.260894s] [吞吐率：3.83req/s] [内存消耗：4,080.05kb] [文件加载：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' => 'oCmeh5Sm8dgHwdQ1KBIRrmN88S00', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 14; ALT-AN00 Build/HONORALT-AN10; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.63 Mobile Safari/537.36 XWEB/1380045 MMWEBSDK/20250503 MMWEBID/3271 MicroMessenger/8.0.61.2880(0x28003D3F) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/getChargeData', 'host' => 'main', 'pageSize' => '15', 'sids' => 'BJ000321', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009371s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007627s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006270s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.007611s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5Sm8dgHwdQ1KBIRrmN88S00' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006264s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5Sm8dgHwdQ1KBIRrmN88S00' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006268s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_socket` [ RunTime:0.007412s ] [ sql ] [ SQL ] SELECT `equi_id`,`num`,`socket_list`,`name` FROM `tp_charge_socket` WHERE `code` = 'BJ000321' [ RunTime:0.008210s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.007498s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`brand`,`site_id` FROM `tp_charge_equi` WHERE `id` = 744 LIMIT 1 [ RunTime:0.006244s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007609s ] [ sql ] [ SQL ] SELECT `id`,`name`,`state`,`server_tel` FROM `tp_comm_site` WHERE `id` = 983 LIMIT 1 [ RunTime:0.006277s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.007420s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 983 LIMIT 1 [ RunTime:0.006229s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.007468s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 983 LIMIT 1 [ RunTime:0.006311s ] --------------------------------------------------------------- [2025-07-18T23:57:52+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.685375s] [吞吐率：1.46req/s] [内存消耗：3,948.79kb] [文件加载：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' => '7', 'DH' => '2913749', 'POW' => '216', 'DL' => '0.9673', 'TIM' => '290', 'MSG' => '8', 'POWs' => '2913749', 'MONEY' => '156', 'MSG2' => '检测到插座无充电器结束订单', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009360s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007604s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006263s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.007859s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2913749 LIMIT 1 [ RunTime:0.006443s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.007645s ] [ sql ] [ SQL ] SELECT `total_elec`,`yet_elec`,`total_time`,`yet_time`,`total_num`,`yet_num` FROM `tp_charge_month` WHERE `id` = 82387 LIMIT 1 [ RunTime:0.007183s ] [ sql ] [ SQL ] UPDATE `tp_charge_month` SET `yet_time` = 22.23 WHERE `id` = 82387 [ RunTime:0.007271s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025071819065417528368146884' , `order_money` = 0 , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 290 , `elec_num` = 1.06403 , `power_num` = 216 , `finish` = 8 , `state` = 9 , `other` = '{\"month_id\":82387,\"finish_text\":\"检测到插座无充电器结束订单\",\"POWs\":\"2913749\",\"sj_elec\":\"0.9673\"}' , `finish_time` = '2025-07-18 23:57:51' , `js_result` = '[]' WHERE `id` = 2913749 [ RunTime:0.006398s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007880s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 971 LIMIT 1 [ RunTime:0.006288s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.007657s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006326s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.007893s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 38246 LIMIT 1 [ RunTime:0.010341s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.007714s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5Q8Wo976jpeV5czos4hYThA' , '结束充电' , '{\"touser\":\"oCmeh5Q8Wo976jpeV5czos4hYThA\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"红枫林三期三号门\"},\"time4\":{\"value\":\"2025-07-18 19:06:54\"},\"time3\":{\"value\":\"2025-07-18 23:57:51\"},\"thing5\":{\"value\":\"您的订单【2913749】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=2913749\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 687a6eff-1f5a2b01-52d520d3\"}' , '2025-07-18 23:57:51') [ RunTime:0.006987s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.007493s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEWKA017' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YEWKA017\",\"SIDS\":\"CH100019\",\"CZ\":\"7\",\"DH\":\"2913749\",\"POW\":\"216\",\"DL\":\"0.9673\",\"TIM\":\"290\",\"MSG\":\"8\",\"POWs\":\"2913749\",\"MONEY\":\"156\",\"MSG2\":\"检测到插座无充电器结束订单\"}' , '{\"Z\":\"206\",\"IDS\":\"YEWKA017\",\"SIDS\":\"CH100019\",\"CZ\":\"7\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-07-18 23:57:51') [ RunTime:0.006232s ] --------------------------------------------------------------- [2025-07-18T23:57:57+08:00] 43.143.57.46 POST api.scyeby.com/public/index.php/index/Wxservice/index.html?signature=2bac173c3d998cb69ff7df8eaf97efba8ad04118×tamp=1752854277&nonce=454851288&openid=oCmeh5Sm8dgHwdQ1KBIRrmN88S00 [运行时间：0.064112s] [吞吐率：15.60req/s] [内存消耗：3,503.61kb] [文件加载：86] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'user-agent' => 'Mozilla/4.0', 'accept' => '*/*', 'host' => 'api.scyeby.com', 'pragma' => 'no-cache', 'content-length' => '688', 'content-type' => 'text/xml', ) [ info ] [ PARAM ] array ( 'signature' => '2bac173c3d998cb69ff7df8eaf97efba8ad04118', 'timestamp' => '1752854277', 'nonce' => '454851288', 'openid' => 'oCmeh5Sm8dgHwdQ1KBIRrmN88S00', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.016766s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008014s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006454s ] --------------------------------------------------------------- [2025-07-18T23:57:58+08:00] 182.143.209.221 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.268880s] [吞吐率：3.72req/s] [内存消耗：4,198.78kb] [文件加载：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' => '1508', 'content-type' => 'application/x-www-form-urlencoded', 'x-token' => 'oCmeh5Sm8dgHwdQ1KBIRrmN88S00', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 14; ALT-AN00 Build/HONORALT-AN10; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.63 Mobile Safari/537.36 XWEB/1380045 MMWEBSDK/20250503 MMWEBID/3271 MicroMessenger/8.0.61.2880(0x28003D3F) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/createOrder', 'host' => 'main', 'pageSize' => '15', 'state' => '9', 'state_msg' => '', 'site_id' => '983', 'site_name' => '眉山柏林谷', 'site_server' => '18980369999', 'equi_ids' => 'YE4G0315', 'equi_brand' => 'qy', 'equi_state' => '1', 'socket' => '[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object]', 'sids' => 'BJ000321', 'price_info' => '[object Object]', 'money_list' => '[object Object],[object Object],[object Object],[object Object],[object Object]', 'money_name' => '', 'pay_money' => '3', 'value' => '15', 'socket_num' => '8', 'socket_no' => '', 'allow_time' => '4.68', 'power_num' => '502', 'temp' => '{"charge_type":"8","start_power":["0","201","301","401","501","601","701","801","951","1501","2001","2501","3001"],"end_power":["200","300","400","500","600","700","800","950","1500","2000","2500","3000","3600"],"price":["0.579","0.579","0.579","0.579","0.579","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","0.6","0.7","0.8","0.9","1.0"]}', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009658s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007697s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006450s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.007575s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5Sm8dgHwdQ1KBIRrmN88S00' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006682s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5Sm8dgHwdQ1KBIRrmN88S00' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006425s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.007697s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 983 [ RunTime:0.006474s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 983 [ RunTime:0.006431s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008061s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 44114 LIMIT 1 [ RunTime:0.006887s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.007781s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = 'YE4G0315' AND `state` = 1 AND `sids` = 'BJ000321' AND `socket_num` = 8 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.008647s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008360s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 983 LIMIT 1 [ RunTime:0.006370s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.008179s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006478s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.007574s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006505s ] [ 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 , 983 , '20250718235758980933' , NULL , 0 , 44114 , '19982678004' , 'YE4G0315' , 8 , 0 , 'BJ000321' , '3' , '2025-07-18 23:57:58' , 1752890278 , '{\"charge_type\":\"8\",\"start_power\":[\"0\",\"201\",\"301\",\"401\",\"501\",\"601\",\"701\",\"801\",\"951\",\"1501\",\"2001\",\"2501\",\"3001\"],\"end_power\":[\"200\",\"300\",\"400\",\"500\",\"600\",\"700\",\"800\",\"950\",\"1500\",\"2000\",\"2500\",\"3000\",\"3600\"],\"price\":[\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"0.579\",\"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\",\"0.6\",\"0.7\",\"0.8\",\"0.9\",\"1.0\"]}' , 'qy' , 15 , '[]' , 'main') [ RunTime:0.007336s ] [ sql ] [ SQL ] SELECT 983,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 983 [ RunTime:0.006426s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.007596s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 983 [ RunTime:0.006481s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006563s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006590s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.007801s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006454s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.007863s ] [ 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 , 'Y20250718235758523501' , NULL , 983 , 44114 , 44114 , '3' , '3' , 'charge_temp' , '2025-07-18 23:57:58' , '{\"site_id\":\"983\",\"site_name\":\"眉山柏林谷\",\"equi_ids\":\"YE4G0315\",\"equi_brand\":\"qy\",\"sids\":\"BJ000321\",\"socket_num\":\"8\",\"socket_no\":\"\",\"value\":\"15\",\"order_id\":\"2914704\",\"sy_money\":\"3\"}' , '{\"appId\":\"wx9d3af783c5718533\",\"appSecret\":\"49cd7ec1b8418d1dcb19ce60b78ccb95\",\"partnerId\":\"1511337021\",\"apiKey\":\"f02795ff419df1f67b1b59aa0ca06754\",\"code\":\"yeby\",\"name\":\"元贰佰壹\"}' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '临时充电' , '2025-07' , '2025-07-18' , NULL , 'main') [ RunTime:0.006827s ] [ error ] [8]未定义数组索引: icard[D:\www\api\application\charge\model\Orders.php:79] [ error ] [8]未定义数组索引: other[D:\www\api\application\charge\model\Orders.php:93] [ error ] [8]未定义数组索引: icard[D:\www\api\application\comm\model\Consume.php:53] [ error ] [8]未定义数组索引: remark[D:\www\api\application\comm\model\Consume.php:67] --------------------------------------------------------------- [2025-07-18T23:57:58+08:00] 182.143.209.221 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.510640s] [吞吐率：1.96req/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' => 'oCmeh5Sm8dgHwdQ1KBIRrmN88S00', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 14; ALT-AN00 Build/HONORALT-AN10; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.63 Mobile Safari/537.36 XWEB/1380045 MMWEBSDK/20250503 MMWEBID/3271 MicroMessenger/8.0.61.2880(0x28003D3F) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/consume/getPayment', 'host' => 'main', 'pageSize' => '15', 'order_id' => '2112672', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009394s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007588s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006250s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.007531s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5Sm8dgHwdQ1KBIRrmN88S00' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006277s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5Sm8dgHwdQ1KBIRrmN88S00' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006289s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.007624s ] [ sql ] [ SQL ] SELECT `id`,`state`,`src_by`,`pay_money`,`order_sn`,`pay_config` FROM `tp_comm_consume` WHERE `id` = 2112672 LIMIT 1 [ RunTime:0.006239s ] [ error ] [8]未定义数组索引: paysuc_url[D:\www\api\application\index\controller\Payment.php:41] [ error ] [8]未定义数组索引: payerr_url[D:\www\api\application\index\controller\Payment.php:42] --------------------------------------------------------------- [2025-07-18T23:57:59+08:00] 124.223.33.44 POST api.scyeby.com/public/index.php/index/Wxservice/index.html?signature=297916675da440f3696bc023a298c23ac0a35ee8×tamp=1752854279&nonce=870923963&openid=oCmeh5WRdZEFNfzmj4j08Rz8dM1o [运行时间：0.061052s] [吞吐率：16.38req/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' => '297916675da440f3696bc023a298c23ac0a35ee8', 'timestamp' => '1752854279', 'nonce' => '870923963', 'openid' => 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009702s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007742s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006820s ] --------------------------------------------------------------- [2025-07-18T23:57:59+08:00] 222.212.10.157 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.287836s] [吞吐率：3.47req/s] [内存消耗：4,250.81kb] [文件加载：105] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '1315', 'content-type' => 'application/x-www-form-urlencoded', 'x-token' => 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 10; YAL-AL00 Build/HUAWEIYAL-AL00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.157 Mobile Safari/537.36 XWEB/1380055 MMWEBSDK/20250503 MMWEBID/4826 MicroMessenger/8.0.61.2880(0x28003D3F) WeChat/arm64 Weixin NetType/WIFI 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' => '968', 'site_name' => '上行锦绣二车库', 'site_server' => '18980369999', 'equi_ids' => 'YEWI0047', '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' => 'BJ000263', 'price_info' => '[object Object]', 'money_list' => '[object Object],[object Object],[object Object],[object Object],[object Object]', 'money_name' => '', 'pay_money' => '2', 'value' => '15', 'socket_num' => '6', 'socket_no' => '', 'allow_time' => '3.12', '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.009592s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007843s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006441s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.007707s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006398s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006366s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.007648s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 968 [ RunTime:0.006441s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.007666s ] [ sql ] [ SQL ] SELECT `icard`,`park_end` FROM `tp_comm_icard` WHERE `site_id` = 968 AND `member_id` = 45852 ORDER BY `park_end` DESC LIMIT 1 [ RunTime:0.008783s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 968 [ RunTime:0.006855s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.007598s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 45852 LIMIT 1 [ RunTime:0.006823s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008361s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = 'YEWI0047' AND `state` = 1 AND `sids` = 'BJ000263' AND `socket_num` = 6 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.009548s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008132s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 968 LIMIT 1 [ RunTime:0.006403s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.007506s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006476s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.007840s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006454s ] [ 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 , 968 , '20250718235759953633' , NULL , 0 , 45852 , '13908192231' , 'YEWI0047' , 6 , 0 , 'BJ000263' , '2' , '2025-07-18 23:57:59' , 1752890279 , '{\"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.006901s ] [ sql ] [ SQL ] SELECT 968,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 968 [ RunTime:0.006465s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.007567s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 968 [ RunTime:0.006492s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006493s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006476s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008052s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006510s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.007693s ] [ 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 , 'Y20250718235759148940' , NULL , 968 , 45852 , 45852 , '2' , '2' , 'charge_temp' , '2025-07-18 23:57:59' , '{\"site_id\":\"968\",\"site_name\":\"上行锦绣二车库\",\"equi_ids\":\"YEWI0047\",\"equi_brand\":\"qy\",\"sids\":\"BJ000263\",\"socket_num\":\"6\",\"socket_no\":\"\",\"value\":\"15\",\"order_id\":\"2914705\",\"sy_money\":\"2\"}' , '{\"appId\":\"wx9d3af783c5718533\",\"appSecret\":\"49cd7ec1b8418d1dcb19ce60b78ccb95\",\"partnerId\":\"1511337021\",\"apiKey\":\"f02795ff419df1f67b1b59aa0ca06754\",\"code\":\"yeby\",\"name\":\"元贰佰壹\"}' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '临时充电' , '2025-07' , '2025-07-18' , NULL , 'main') [ RunTime:0.006871s ] [ error ] [8]未定义数组索引: icard[D:\www\api\application\charge\model\Orders.php:79] [ error ] [8]未定义数组索引: other[D:\www\api\application\charge\model\Orders.php:93] [ error ] [8]未定义数组索引: icard[D:\www\api\application\comm\model\Consume.php:53] [ error ] [8]未定义数组索引: remark[D:\www\api\application\comm\model\Consume.php:67] --------------------------------------------------------------- [2025-07-18T23:58:00+08:00] 222.212.10.157 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.540324s] [吞吐率：1.85req/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' => 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 10; YAL-AL00 Build/HUAWEIYAL-AL00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.157 Mobile Safari/537.36 XWEB/1380055 MMWEBSDK/20250503 MMWEBID/4826 MicroMessenger/8.0.61.2880(0x28003D3F) WeChat/arm64 Weixin NetType/WIFI 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' => '2112673', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.017553s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008134s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006606s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.007923s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006553s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006601s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008383s ] [ sql ] [ SQL ] SELECT `id`,`state`,`src_by`,`pay_money`,`order_sn`,`pay_config` FROM `tp_comm_consume` WHERE `id` = 2112673 LIMIT 1 [ RunTime:0.006582s ] [ error ] [8]未定义数组索引: paysuc_url[D:\www\api\application\index\controller\Payment.php:41] [ error ] [8]未定义数组索引: payerr_url[D:\www\api\application\index\controller\Payment.php:42] --------------------------------------------------------------- [2025-07-18T23:58:02+08:00] 221.182.14.120 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.102193s] [吞吐率：9.79req/s] [内存消耗：3,860.46kb] [文件加载：92] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '69', 'x-token' => 'oCmeh5cwhldLGKfwG8F6ZRu_r4zM', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 14_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.54(0x1800363a) NetType/4G Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/park/getLists', 'host' => 'main', 'pageSize' => '15', 'page_num' => '1', 'state' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009694s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008029s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006378s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.007685s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5cwhldLGKfwG8F6ZRu_r4zM' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006386s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5cwhldLGKfwG8F6ZRu_r4zM' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006371s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_park_orders` [ RunTime:0.008516s ] [ 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` = 44738 AND `state` IN (1,8) ORDER BY `state` ASC,`id` DESC LIMIT 30 [ RunTime:0.007176s ] --------------------------------------------------------------- [2025-07-18T23:58:02+08:00] 221.182.14.120 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.259039s] [吞吐率：3.86req/s] [内存消耗：4,110.74kb] [文件加载：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', 'x-token' => 'oCmeh5cwhldLGKfwG8F6ZRu_r4zM', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 14_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.54(0x1800363a) NetType/4G Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/getChargeData', 'host' => 'main', 'pageSize' => '15', 'sids' => 'C60B8545', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.019113s ] 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.006920s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008215s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5cwhldLGKfwG8F6ZRu_r4zM' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006783s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5cwhldLGKfwG8F6ZRu_r4zM' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006730s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_socket` [ RunTime:0.008077s ] [ sql ] [ SQL ] SELECT `equi_id`,`num`,`socket_list`,`name` FROM `tp_charge_socket` WHERE `code` = 'C60B8545' [ RunTime:0.009100s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.008125s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`brand`,`site_id` FROM `tp_charge_equi` WHERE `id` = 750 LIMIT 1 [ RunTime:0.006829s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008116s ] [ sql ] [ SQL ] SELECT `id`,`name`,`state`,`server_tel` FROM `tp_comm_site` WHERE `id` = 948 LIMIT 1 [ RunTime:0.006654s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008604s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 948 LIMIT 1 [ RunTime:0.006793s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.008142s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 948 LIMIT 1 [ RunTime:0.006741s ] [ error ] [8]未定义数组索引: time[D:\www\api\application\member\controller\Charge.php:288] --------------------------------------------------------------- [2025-07-18T23:58:07+08:00] 140.207.54.80 POST api.scyeby.com/public/index.php/index/payment/wxnotify.html [运行时间：0.827921s] [吞吐率：1.21req/s] [内存消耗：4,124.41kb] [文件加载：97] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-length' => '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.009693s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007759s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006413s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_pay` [ RunTime:0.008005s ] [ sql ] [ SQL ] INSERT INTO `tp_log_pay` (`trade_no` , `content` , `result` , `ctime`) VALUES ('4200002792202507188866257234' , '{\"appid\":\"wx9d3af783c5718533\",\"attach\":\"2112672\",\"bank_type\":\"SCNX_DEBIT\",\"cash_fee\":\"300\",\"fee_type\":\"CNY\",\"is_subscribe\":\"N\",\"mch_id\":\"1511337021\",\"nonce_str\":\"3486dab0aa8d46fd6ea1fd9aed5048f5\",\"openid\":\"oCmeh5Sm8dgHwdQ1KBIRrmN88S00\",\"out_trade_no\":\"Y20250718235758523501\",\"result_code\":\"SUCCESS\",\"return_code\":\"SUCCESS\",\"sign\":\"85A6EC7440A5F35485955F6F9351162B\",\"time_end\":\"20250718235805\",\"total_fee\":\"300\",\"trade_type\":\"JSAPI\",\"transaction_id\":\"4200002792202507188866257234\"}' , '[]' , '2025-07-18 23:58:06') [ RunTime:0.006490s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.007768s ] [ sql ] [ SQL ] SELECT `id`,`state`,`ctime`,`details`,`src_by`,`order_money`,`rate` FROM `tp_comm_consume` WHERE `id` = 2112672 LIMIT 1 [ RunTime:0.006435s ] [ sql ] [ SQL ] UPDATE `tp_comm_consume` SET `state` = 9 , `payment_code` = 'wxpay' , `trade_no` = '4200002792202507188866257234' WHERE `id` = 2112672 [ RunTime:0.007262s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.007817s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2914704 LIMIT 1 [ RunTime:0.006536s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `state` = 1 , `payment_code` = 'wxpay' , `trade_no` = '4200002792202507188866257234' WHERE `id` = 2914704 [ RunTime:0.006463s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.007990s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0315' , 'QY_101' , '{\"Z\":\"101\",\"IDS\":\"YE4G0315\",\"SIDS\":\"BJ000321\",\"CZ\":\"8\",\"MODEL\":\"8\",\"TIM\":\"900\",\"DL\":\"1500\",\"MONEY\":\"300\",\"LIST\":\"0_200_579_15,201_300_579_20,301_400_579_25,401_500_579_30,501_600_579_35,601_700_579_40,701_800_579_45,801_950_579_50,951_1500_579_60,1501_2000_579_70,2001_2500_579_80,2501_3000_579_90,3001_3600_579_100\",\"DH\":\"2914704\",\"ZMONEY\":\"300\"}' , '{\"state\":\"1\"}' , '2025-07-18 23:58:06') [ RunTime:0.006410s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007722s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 983 LIMIT 1 [ RunTime:0.006393s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.007956s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006516s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.007789s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 44114 LIMIT 1 [ RunTime:0.006428s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.007794s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5Sm8dgHwdQ1KBIRrmN88S00' , '开始充电' , '{\"touser\":\"oCmeh5Sm8dgHwdQ1KBIRrmN88S00\",\"template_id\":\"Agy1VhMUNj0Ts8jwvjW_UqGEDJOg0Y0-39j6y8nhpRg\",\"data\":{\"thing2\":{\"value\":\"眉山柏林谷\"},\"character_string8\":{\"value\":\"YE4G0315（BJ000321）\"},\"character_string9\":{\"value\":\"No.8\"},\"character_string6\":{\"value\":2914704},\"time3\":{\"value\":\"2025-07-18 23:57:58\"}},\"page\":\"\\/pages\\/orders\\/chargeing?order_id=2914704\"}' , '{\"errcode\":0,\"errmsg\":\"ok\",\"msgid\":4081259386406912002}' , '2025-07-18 23:58:07') [ RunTime:0.006564s ] [ sql ] [ SQL ] UPDATE `tp_log_pay` SET `result` = '{\"code\":200}' WHERE `trade_no` = '4200002792202507188866257234' [ RunTime:0.006563s ] --------------------------------------------------------------- [2025-07-18T23:58:07+08:00] 175.24.212.195 POST api.scyeby.com/public/index.php/index/Wxservice/index.html?signature=e29396057804be8d70dbe435f5c2bd325a22a9f4×tamp=1752854287&nonce=1139828561&openid=oCmeh5Sm8dgHwdQ1KBIRrmN88S00 [运行时间：0.057056s] [吞吐率：17.53req/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' => 'e29396057804be8d70dbe435f5c2bd325a22a9f4', 'timestamp' => '1752854287', 'nonce' => '1139828561', 'openid' => 'oCmeh5Sm8dgHwdQ1KBIRrmN88S00', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009637s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007753s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006422s ] --------------------------------------------------------------- [2025-07-18T23:58:08+08:00] 140.207.54.77 POST api.scyeby.com/public/index.php/index/payment/wxnotify.html [运行时间：1.438523s] [吞吐率：0.70req/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.016664s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007820s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006433s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_pay` [ RunTime:0.007903s ] [ sql ] [ SQL ] INSERT INTO `tp_log_pay` (`trade_no` , `content` , `result` , `ctime`) VALUES ('4200002792202507188823162733' , '{\"appid\":\"wx9d3af783c5718533\",\"attach\":\"2112673\",\"bank_type\":\"OTHERS\",\"cash_fee\":\"200\",\"fee_type\":\"CNY\",\"is_subscribe\":\"N\",\"mch_id\":\"1511337021\",\"nonce_str\":\"b22a0b3aa870a7f15b2beca2275ee034\",\"openid\":\"oCmeh5WRdZEFNfzmj4j08Rz8dM1o\",\"out_trade_no\":\"Y20250718235759148940\",\"result_code\":\"SUCCESS\",\"return_code\":\"SUCCESS\",\"sign\":\"7569636A79CDFD09C913A0E9C843E319\",\"time_end\":\"20250718235806\",\"total_fee\":\"200\",\"trade_type\":\"JSAPI\",\"transaction_id\":\"4200002792202507188823162733\"}' , '[]' , '2025-07-18 23:58:07') [ RunTime:0.006399s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.007735s ] [ sql ] [ SQL ] SELECT `id`,`state`,`ctime`,`details`,`src_by`,`order_money`,`rate` FROM `tp_comm_consume` WHERE `id` = 2112673 LIMIT 1 [ RunTime:0.006471s ] [ sql ] [ SQL ] UPDATE `tp_comm_consume` SET `state` = 9 , `payment_code` = 'wxpay' , `trade_no` = '4200002792202507188823162733' WHERE `id` = 2112673 [ RunTime:0.006816s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.007810s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2914705 LIMIT 1 [ RunTime:0.007709s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `state` = 1 , `payment_code` = 'wxpay' , `trade_no` = '4200002792202507188823162733' WHERE `id` = 2914705 [ RunTime:0.006461s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.010306s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEWI0047' , 'QY_101' , '{\"Z\":\"101\",\"IDS\":\"YEWI0047\",\"SIDS\":\"BJ000263\",\"CZ\":\"6\",\"MODEL\":\"8\",\"TIM\":\"900\",\"DL\":\"1500\",\"MONEY\":\"200\",\"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\":\"2914705\",\"ZMONEY\":\"200\"}' , '{\"state\":\"1\"}' , '2025-07-18 23:58:08') [ RunTime:0.006491s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007724s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 968 LIMIT 1 [ RunTime:0.006459s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.009596s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006528s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.007635s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 45852 LIMIT 1 [ RunTime:0.006427s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008256s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5WRdZEFNfzmj4j08Rz8dM1o' , '开始充电' , '{\"touser\":\"oCmeh5WRdZEFNfzmj4j08Rz8dM1o\",\"template_id\":\"Agy1VhMUNj0Ts8jwvjW_UqGEDJOg0Y0-39j6y8nhpRg\",\"data\":{\"thing2\":{\"value\":\"上行锦绣二车库\"},\"character_string8\":{\"value\":\"YEWI0047（BJ000263）\"},\"character_string9\":{\"value\":\"No.6\"},\"character_string6\":{\"value\":2914705},\"time3\":{\"value\":\"2025-07-18 23:57:59\"}},\"page\":\"\\/pages\\/orders\\/chargeing?order_id=2914705\"}' , '{\"errcode\":0,\"errmsg\":\"ok\",\"msgid\":4081259414777184258}' , '2025-07-18 23:58:08') [ RunTime:0.006756s ] [ sql ] [ SQL ] UPDATE `tp_log_pay` SET `result` = '{\"code\":200}' WHERE `trade_no` = '4200002792202507188823162733' [ RunTime:0.006442s ] --------------------------------------------------------------- [2025-07-18T23:58:09+08:00] 124.220.226.99 POST api.scyeby.com/public/index.php/index/Wxservice/index.html?signature=1b813c5abfbccc5e8d3cad844e400a5a16879723×tamp=1752854288&nonce=290045507&openid=oCmeh5WRdZEFNfzmj4j08Rz8dM1o [运行时间：0.064830s] [吞吐率：15.42req/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' => '1b813c5abfbccc5e8d3cad844e400a5a16879723', 'timestamp' => '1752854288', 'nonce' => '290045507', 'openid' => 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009792s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008311s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006977s ] --------------------------------------------------------------- [2025-07-18T23:58:09+08:00] 182.143.209.221 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.114520s] [吞吐率：8.73req/s] [内存消耗：3,861.39kb] [文件加载：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' => 'oCmeh5Sm8dgHwdQ1KBIRrmN88S00', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 14; ALT-AN00 Build/HONORALT-AN10; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.63 Mobile Safari/537.36 XWEB/1380045 MMWEBSDK/20250503 MMWEBID/3271 MicroMessenger/8.0.61.2880(0x28003D3F) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/park/getLists', 'host' => 'main', 'pageSize' => '15', 'page_num' => '1', 'state' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.012626s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008087s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006638s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.009001s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5Sm8dgHwdQ1KBIRrmN88S00' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006565s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5Sm8dgHwdQ1KBIRrmN88S00' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006756s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_park_orders` [ RunTime:0.007942s ] [ 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` = 44114 AND `state` IN (1,8) ORDER BY `state` ASC,`id` DESC LIMIT 30 [ RunTime:0.007156s ] --------------------------------------------------------------- [2025-07-18T23:58:09+08:00] 182.143.209.221 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.270122s] [吞吐率：3.70req/s] [内存消耗：4,080.05kb] [文件加载：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' => 'oCmeh5Sm8dgHwdQ1KBIRrmN88S00', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 14; ALT-AN00 Build/HONORALT-AN10; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.63 Mobile Safari/537.36 XWEB/1380045 MMWEBSDK/20250503 MMWEBID/3271 MicroMessenger/8.0.61.2880(0x28003D3F) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/getChargeData', 'host' => 'main', 'pageSize' => '15', 'sids' => 'BJ000321', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.017851s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008275s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006332s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008533s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5Sm8dgHwdQ1KBIRrmN88S00' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006633s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5Sm8dgHwdQ1KBIRrmN88S00' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.019541s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_socket` [ RunTime:0.008432s ] [ sql ] [ SQL ] SELECT `equi_id`,`num`,`socket_list`,`name` FROM `tp_charge_socket` WHERE `code` = 'BJ000321' [ RunTime:0.009843s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.007720s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`brand`,`site_id` FROM `tp_charge_equi` WHERE `id` = 744 LIMIT 1 [ RunTime:0.008093s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.009396s ] [ sql ] [ SQL ] SELECT `id`,`name`,`state`,`server_tel` FROM `tp_comm_site` WHERE `id` = 983 LIMIT 1 [ RunTime:0.006652s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.007835s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 983 LIMIT 1 [ RunTime:0.006207s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.007641s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 983 LIMIT 1 [ RunTime:0.006236s ] --------------------------------------------------------------- [2025-07-18T23:58:10+08:00] 221.182.14.120 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.168507s] [吞吐率：5.93req/s] [内存消耗：4,061.27kb] [文件加载：96] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '71', 'x-token' => 'oCmeh5cwhldLGKfwG8F6ZRu_r4zM', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 14_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.54(0x1800363a) 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' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.017377s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008471s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006666s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008396s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5cwhldLGKfwG8F6ZRu_r4zM' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006754s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5cwhldLGKfwG8F6ZRu_r4zM' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007360s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008001s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `member_id` = 44738 AND `state` = 1 AND `del` = 1 ORDER BY `state` ASC,`id` DESC LIMIT 30 [ RunTime:0.011657s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008467s ] [ sql ] [ SQL ] SELECT 948,`name` FROM `tp_comm_site` WHERE `id` = 948 [ RunTime:0.007500s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `time_num` = 5 , `elec_num` = '0.021' , `power_num` = 250 WHERE `id` = 2914694 [ RunTime:0.007076s ] --------------------------------------------------------------- [2025-07-18T23:58:11+08:00] 222.212.10.157 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.106044s] [吞吐率：9.43req/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' => 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 10; YAL-AL00 Build/HUAWEIYAL-AL00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.157 Mobile Safari/537.36 XWEB/1380055 MMWEBSDK/20250503 MMWEBID/4826 MicroMessenger/8.0.61.2880(0x28003D3F) WeChat/arm64 Weixin NetType/WIFI Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/park/getLists', 'host' => 'main', 'pageSize' => '15', 'page_num' => '1', 'state' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009577s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007541s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006454s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.007817s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006342s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006369s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_park_orders` [ RunTime:0.008071s ] [ 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` = 45852 AND `state` IN (1,8) ORDER BY `state` ASC,`id` DESC LIMIT 30 [ RunTime:0.006827s ] --------------------------------------------------------------- [2025-07-18T23:58:12+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.624135s] [吞吐率：1.60req/s] [内存消耗：3,948.76kb] [文件加载：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' => '200', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => '10142572', 'SIDS' => 'BJ000045', 'CZ' => '10', 'DH' => '2913422', 'POW' => '155', 'DL' => '0.7783', 'TIM' => '350', 'MSG' => '8', 'POWs' => '2913422', 'MONEY' => '135', 'MSG2' => '5分钟时间无功率自动关闭充电', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.018071s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007765s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006462s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.009504s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2913422 LIMIT 1 [ RunTime:0.010143s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.011051s ] [ sql ] [ SQL ] SELECT `total_elec`,`yet_elec`,`total_time`,`yet_time`,`total_num`,`yet_num` FROM `tp_charge_month` WHERE `id` = 87742 LIMIT 1 [ RunTime:0.007592s ] [ sql ] [ SQL ] UPDATE `tp_charge_month` SET `yet_time` = 68.48 WHERE `id` = 87742 [ RunTime:0.006707s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025071818070517528332254120' , `order_money` = 0 , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 350 , `elec_num` = 0.85613 , `power_num` = 155 , `finish` = 8 , `state` = 9 , `other` = '{\"month_id\":87742,\"finish_text\":\"5分钟时间无功率自动关闭充电\",\"POWs\":\"2913422\",\"sj_elec\":\"0.7783\"}' , `finish_time` = '2025-07-18 23:58:11' , `js_result` = '[]' WHERE `id` = 2913422 [ RunTime:0.006926s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008166s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 959 LIMIT 1 [ RunTime:0.006395s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.007868s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006885s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.007865s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 3260 LIMIT 1 [ RunTime:0.006763s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.007894s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5fmTFBhtt1iFD12iDvtBnvo' , '结束充电' , '{\"touser\":\"oCmeh5fmTFBhtt1iFD12iDvtBnvo\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"平安苑\"},\"time4\":{\"value\":\"2025-07-18 18:07:05\"},\"time3\":{\"value\":\"2025-07-18 23:58:11\"},\"thing5\":{\"value\":\"您的订单【2913422】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=2913422\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 687a6f13-3e1a7800-1a9cf3b2\"}' , '2025-07-18 23:58:12') [ RunTime:0.006949s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.007616s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('10142572' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"10142572\",\"SIDS\":\"BJ000045\",\"CZ\":\"10\",\"DH\":\"2913422\",\"POW\":\"155\",\"DL\":\"0.7783\",\"TIM\":\"350\",\"MSG\":\"8\",\"POWs\":\"2913422\",\"MONEY\":\"135\",\"MSG2\":\"5分钟时间无功率自动关闭充电\"}' , '{\"Z\":\"206\",\"IDS\":\"10142572\",\"SIDS\":\"BJ000045\",\"CZ\":\"10\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-07-18 23:58:12') [ RunTime:0.006432s ] --------------------------------------------------------------- [2025-07-18T23:58:12+08:00] 222.212.10.157 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.971404s] [吞吐率：1.03req/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' => 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 10; YAL-AL00 Build/HUAWEIYAL-AL00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.157 Mobile Safari/537.36 XWEB/1380055 MMWEBSDK/20250503 MMWEBID/4826 MicroMessenger/8.0.61.2880(0x28003D3F) WeChat/arm64 Weixin NetType/WIFI Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/getChargeData', 'host' => 'main', 'pageSize' => '15', 'sids' => 'BJ000263', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009196s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008120s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006149s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.007581s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006417s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007341s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_socket` [ RunTime:0.007875s ] [ sql ] [ SQL ] SELECT `equi_id`,`num`,`socket_list`,`name` FROM `tp_charge_socket` WHERE `code` = 'BJ000263' [ RunTime:0.012864s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.007869s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`brand`,`site_id` FROM `tp_charge_equi` WHERE `id` = 316 LIMIT 1 [ RunTime:0.006110s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007767s ] [ sql ] [ SQL ] SELECT `id`,`name`,`state`,`server_tel` FROM `tp_comm_site` WHERE `id` = 968 LIMIT 1 [ RunTime:0.006132s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.009303s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 968 LIMIT 1 [ RunTime:0.007007s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.007980s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 968 LIMIT 1 [ RunTime:0.006118s ] --------------------------------------------------------------- [2025-07-18T23:58:13+08:00] 222.212.10.157 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.136422s] [吞吐率：7.33req/s] [内存消耗：4,062.02kb] [文件加载：96] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '71', 'content-type' => 'application/x-www-form-urlencoded', 'x-token' => 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 10; YAL-AL00 Build/HUAWEIYAL-AL00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.157 Mobile Safari/537.36 XWEB/1380055 MMWEBSDK/20250503 MMWEBID/4826 MicroMessenger/8.0.61.2880(0x28003D3F) WeChat/arm64 Weixin NetType/WIFI Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/getLists', 'host' => 'main', 'pageSize' => '15', 'page_num' => '1', 'state' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009467s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007629s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006267s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.007592s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006137s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006164s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.007633s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `member_id` = 45852 AND `state` = 1 AND `del` = 1 ORDER BY `state` ASC,`id` DESC LIMIT 30 [ RunTime:0.009501s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007482s ] [ sql ] [ SQL ] SELECT 968,`name` FROM `tp_comm_site` WHERE `id` = 968 [ RunTime:0.006226s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `time_num` = 0 , `elec_num` = 0 , `power_num` = 0 WHERE `id` = 2914705 [ RunTime:0.006539s ] --------------------------------------------------------------- [2025-07-18T23:58:14+08:00] 221.182.14.120 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.155664s] [吞吐率：6.42req/s] [内存消耗：4,045.61kb] [文件加载：95] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '68', 'x-token' => 'oCmeh5cwhldLGKfwG8F6ZRu_r4zM', 'content-type' => 'application/x-www-form-urlencoded', 'accept-encoding' => 'gzip,compress,br,deflate', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 14_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.54(0x1800363a) NetType/4G Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/getInfo', 'host' => 'main', 'pageSize' => '15', 'order_id' => '2914694', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009750s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008264s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006491s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008021s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5cwhldLGKfwG8F6ZRu_r4zM' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006458s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5cwhldLGKfwG8F6ZRu_r4zM' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006422s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008099s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2914694 LIMIT 1 [ RunTime:0.006545s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `time_num` = 5 , `elec_num` = '0.021' , `power_num` = 250 WHERE `id` = 2914694 [ RunTime:0.006806s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.009553s ] [ sql ] [ SQL ] SELECT 948,`name` FROM `tp_comm_site` WHERE `id` = 948 [ RunTime:0.008110s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.009747s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 948 LIMIT 1 [ RunTime:0.006669s ] --------------------------------------------------------------- [2025-07-18T23:58:15+08:00] 222.212.10.157 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.152720s] [吞吐率：6.55req/s] [内存消耗：4,046.49kb] [文件加载：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' => 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 10; YAL-AL00 Build/HUAWEIYAL-AL00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.157 Mobile Safari/537.36 XWEB/1380055 MMWEBSDK/20250503 MMWEBID/4826 MicroMessenger/8.0.61.2880(0x28003D3F) WeChat/arm64 Weixin NetType/WIFI 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' => '2914705', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.011826s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008126s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006276s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.007735s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006310s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006266s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.007718s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2914705 LIMIT 1 [ RunTime:0.006327s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `time_num` = 0 , `elec_num` = 0 , `power_num` = 0 WHERE `id` = 2914705 [ RunTime:0.006590s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007675s ] [ sql ] [ SQL ] SELECT 968,`name` FROM `tp_comm_site` WHERE `id` = 968 [ RunTime:0.006261s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.007738s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 968 LIMIT 1 [ RunTime:0.006268s ] --------------------------------------------------------------- [2025-07-18T23:58:18+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：1.583674s] [吞吐率：0.63req/s] [内存消耗：4,132.14kb] [文件加载：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' => '193', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => 'YEWI0047', 'SIDS' => 'BJ000263', 'CZ' => '6', 'DH' => '2914705', 'POW' => '0', 'DL' => '0.0000', 'TIM' => '0', 'MSG' => '8', 'POWs' => '2914705', 'MONEY' => '15', 'MSG2' => '检测到插座无充电器结束订单', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009672s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007788s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006411s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.007805s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2914705 LIMIT 1 [ RunTime:0.006559s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.007659s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 968 [ RunTime:0.006464s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008642s ] [ sql ] [ SQL ] SELECT `rate` FROM `tp_comm_consume` WHERE `trade_no` = '4200002792202507188823162733' LIMIT 1 [ RunTime:0.006765s ] [ sql ] [ SQL ] SELECT `id`,`order_sn`,`pay_config`,`pay_money`,`trade_no` FROM `tp_comm_consume` WHERE `trade_no` = '4200002792202507188823162733' LIMIT 1 [ RunTime:0.006401s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_pay` [ RunTime:0.008332s ] [ sql ] [ SQL ] INSERT INTO `tp_log_pay` (`trade_no` , `content` , `result` , `ctime`) VALUES ('TK4200002792202507188823162733' , '{\"trade_no\":\"4200002792202507188823162733\",\"order_sn\":\"Y20250718235759148940\",\"pay_money\":2,\"refund_money\":2}' , '{\"code\":200,\"msg\":\"退款成功\",\"data\":{\"return_code\":\"SUCCESS\",\"return_msg\":\"OK\",\"appid\":\"wx9d3af783c5718533\",\"mch_id\":\"1511337021\",\"nonce_str\":\"rnsTaAjReb7veuOH\",\"sign\":\"87F61B2AFD5E1F84E19D15B308089D7F\",\"result_code\":\"SUCCESS\",\"transaction_id\":\"4200002792202507188823162733\",\"out_trade_no\":\"Y20250718235759148940\",\"out_refund_no\":\"Y20250718235759148940\",\"refund_id\":\"50301304012025071852087590390\",\"refund_channel\":[],\"refund_fee\":\"200\",\"coupon_refund_fee\":\"0\",\"total_fee\":\"200\",\"cash_fee\":\"200\",\"coupon_refund_count\":\"0\",\"cash_refund_fee\":\"200\"}}' , '2025-07-18 23:58:17') [ RunTime:0.006563s ] [ sql ] [ SQL ] UPDATE `tp_comm_consume` SET `refund_money` = 2 , `refund_state` = 9 , `refund_day` = '2025-07-18' , `refund_month` = '2025-07' , `refund_remark` = ',系统自动退款' WHERE `id` = 2112673 [ RunTime:0.008594s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = '4200002792202507188823162733' , `order_money` = '0.00' , `refund_money` = 2 , `refund_state` = 9 , `time_num` = 0 , `elec_num` = 0 , `power_num` = 0 , `finish` = 8 , `state` = 9 , `other` = '{\"finish_text\":\"检测到插座无充电器结束订单\",\"POWs\":\"2914705\",\"sj_elec\":\"0.0000\"}' , `finish_time` = '2025-07-18 23:58:17' , `js_result` = '{\"money\":\"0.00\",\"elec_num\":0,\"elec_price\":0,\"timeNum\":0,\"server_price\":0}' WHERE `id` = 2914705 [ RunTime:0.006551s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008574s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 968 LIMIT 1 [ RunTime:0.006459s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.007787s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006544s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.008011s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 45852 LIMIT 1 [ RunTime:0.006527s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.007908s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5WRdZEFNfzmj4j08Rz8dM1o' , '结束充电' , '{\"touser\":\"oCmeh5WRdZEFNfzmj4j08Rz8dM1o\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"上行锦绣二车库\"},\"time4\":{\"value\":\"2025-07-18 23:57:59\"},\"time3\":{\"value\":\"2025-07-18 23:58:17\"},\"thing5\":{\"value\":\"您的订单【2914705】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=2914705\"}' , '{\"errcode\":0,\"errmsg\":\"ok\",\"msgid\":4081259570536857604}' , '2025-07-18 23:58:18') [ RunTime:0.008025s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.007566s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEWI0047' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YEWI0047\",\"SIDS\":\"BJ000263\",\"CZ\":\"6\",\"DH\":\"2914705\",\"POW\":\"0\",\"DL\":\"0.0000\",\"TIM\":\"0\",\"MSG\":\"8\",\"POWs\":\"2914705\",\"MONEY\":\"15\",\"MSG2\":\"检测到插座无充电器结束订单\"}' , '{\"Z\":\"206\",\"IDS\":\"YEWI0047\",\"SIDS\":\"BJ000263\",\"CZ\":\"6\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-07-18 23:58:18') [ RunTime:0.006387s ] --------------------------------------------------------------- [2025-07-18T23:58:18+08:00] 123.207.188.148 POST api.scyeby.com/public/index.php/index/Wxservice/index.html?signature=8fb2a23e49fd89c6393670bd4a079414c2f239aa×tamp=1752854298&nonce=1796354622&openid=oCmeh5WRdZEFNfzmj4j08Rz8dM1o [运行时间：0.065487s] [吞吐率：15.27req/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' => '8fb2a23e49fd89c6393670bd4a079414c2f239aa', 'timestamp' => '1752854298', 'nonce' => '1796354622', 'openid' => 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.017855s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008054s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006380s ] --------------------------------------------------------------- [2025-07-18T23:58:28+08:00] 182.143.209.221 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.138220s] [吞吐率：7.23req/s] [内存消耗：4,062.02kb] [文件加载：96] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '71', 'content-type' => 'application/x-www-form-urlencoded', 'x-token' => 'oCmeh5Sm8dgHwdQ1KBIRrmN88S00', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 14; ALT-AN00 Build/HONORALT-AN10; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.63 Mobile Safari/537.36 XWEB/1380045 MMWEBSDK/20250503 MMWEBID/3271 MicroMessenger/8.0.61.2880(0x28003D3F) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/getLists', 'host' => 'main', 'pageSize' => '15', 'page_num' => '1', 'state' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009666s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007937s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006475s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.007654s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5Sm8dgHwdQ1KBIRrmN88S00' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006448s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5Sm8dgHwdQ1KBIRrmN88S00' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006385s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.007809s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `member_id` = 44114 AND `state` = 1 AND `del` = 1 ORDER BY `state` ASC,`id` DESC LIMIT 30 [ RunTime:0.008684s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007696s ] [ sql ] [ SQL ] SELECT 983,`name` FROM `tp_comm_site` WHERE `id` = 983 [ RunTime:0.006390s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `time_num` = 0 , `elec_num` = 0 , `power_num` = 0 WHERE `id` = 2914704 [ RunTime:0.006808s ] --------------------------------------------------------------- [2025-07-18T23:58:32+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：1.402304s] [吞吐率：0.71req/s] [内存消耗：4,376.87kb] [文件加载：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' => 'YE4G0011', 'SIDS' => 'BJ000233', 'IC' => '3143504805', 'CZ' => '4', 'CS' => '1', 'TY' => '1', 'MXHao' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009384s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007641s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006301s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.007478s ] [ sql ] [ SQL ] SELECT `site_id`,`brand` FROM `tp_charge_equi` WHERE `equi_ids` = 'YE4G0011' LIMIT 1 [ RunTime:0.006333s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007617s ] [ sql ] [ SQL ] SELECT `relation_site_ids` FROM `tp_comm_site` WHERE `id` = 953 LIMIT 1 [ RunTime:0.011922s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.007642s ] [ 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` = 953 AND `icard` = '3143504805' AND `start_time` <= '2025-07-18' AND `end_time` > '2025-07-18' [ RunTime:0.007604s ] [ 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` = '3143504805' AND `start_time` <= '2025-07-18' AND `end_time` >= '2025-07-18' [ RunTime:0.006310s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.007518s ] [ sql ] [ SQL ] SELECT total_money-yet_money sy_money,`icard`,`member_id`,`state`,`park_end` FROM `tp_comm_icard` WHERE `site_id` = 953 AND `icard` = '3143504805' ORDER BY `id` ASC [ RunTime:0.007363s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.007435s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 953 [ RunTime:0.006341s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.007555s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`sids`,`socket_num` FROM `tp_charge_orders` WHERE `icard` = '3143504805' AND `site_id` = 953 AND `state` = 1 [ RunTime:0.010425s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.007474s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 953 LIMIT 1 [ RunTime:0.006193s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 953 [ RunTime:0.006285s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.007383s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 24282 LIMIT 1 [ RunTime:0.007188s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = 'YE4G0011' AND `state` = 1 AND `sids` = 'BJ000233' AND `socket_num` = 4 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.007479s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 953 LIMIT 1 [ RunTime:0.006221s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.007524s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006330s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.007714s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006286s ] [ 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 , 953 , '20250718235830649701' , '3143504805' , 0 , 24282 , '18010587035' , 'YE4G0011' , 4 , 0 , 'BJ000233' , 10 , '2025-07-18 23:58:30' , 1752890310 , '{\"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.007266s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2914706 LIMIT 1 [ RunTime:0.006382s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `state` = 1 , `payment_code` = 'icardyue' , `trade_no` = 'HD2025071823583017528543106329' WHERE `id` = 2914706 [ RunTime:0.006657s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.008075s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0011' , 'QY_101' , '{\"Z\":\"101\",\"IDS\":\"YE4G0011\",\"SIDS\":\"BJ000233\",\"CZ\":\"4\",\"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\":\"2914706\",\"ZMONEY\":\"1247\"}' , '{\"state\":\"1\"}' , '2025-07-18 23:58:31') [ RunTime:0.006285s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 953 LIMIT 1 [ RunTime:0.006273s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.007625s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.009408s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 24282 LIMIT 1 [ RunTime:0.006227s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.007718s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5RRdtx0o5nrKjcqFMukFgvY' , '开始充电' , '{\"touser\":\"oCmeh5RRdtx0o5nrKjcqFMukFgvY\",\"template_id\":\"Agy1VhMUNj0Ts8jwvjW_UqGEDJOg0Y0-39j6y8nhpRg\",\"data\":{\"thing2\":{\"value\":\"浅水半岛三期9栋\"},\"character_string8\":{\"value\":\"YE4G0011（BJ000233）\"},\"character_string9\":{\"value\":\"No.4\"},\"character_string6\":{\"value\":2914706},\"time3\":{\"value\":\"2025-07-18 23:58:30\"}},\"page\":\"\\/pages\\/orders\\/chargeing?order_id=2914706\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 687a6f27-46dccd53-3f762d15\"}' , '2025-07-18 23:58:32') [ RunTime:0.006553s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YE4G0011' , 'QY_207' , '{\"Z\":\"207\",\"IDS\":\"YE4G0011\",\"SIDS\":\"BJ000233\",\"IC\":\"3143504805\",\"CZ\":\"4\",\"CS\":\"1\",\"TY\":\"1\",\"MXHao\":\"1\"}' , '{\"Z\":\"207\",\"IDS\":\"YE4G0011\",\"SIDS\":\"BJ000233\",\"CZ\":\"4\",\"IC\":\"3143504805\",\"MONEY\":\"1247\",\"MXHao\":\"1\",\"state\":\"1\",\"msg\":\"5\",\"msg2\":\"45\",\"txt\":\"开电成功\"}' , '2025-07-18 23:58:32') [ RunTime:0.006293s ] [ error ] [8]未定义数组索引: msg[D:\www\api\application\charge\model\Api.php:373] --------------------------------------------------------------- [2025-07-18T23:59:03+08:00] 222.212.10.157 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.262814s] [吞吐率：3.80req/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' => 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 10; YAL-AL00 Build/HUAWEIYAL-AL00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.157 Mobile Safari/537.36 XWEB/1380055 MMWEBSDK/20250503 MMWEBID/4826 MicroMessenger/8.0.61.2880(0x28003D3F) WeChat/arm64 Weixin NetType/WIFI Language/zh_CN ABI/arm64 MiniProgramEnv/android', 'accept-encoding' => 'gzip, deflate, br', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/getChargeData', 'host' => 'main', 'pageSize' => '15', 'sids' => 'BJ000263', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009384s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007637s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006341s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.007738s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006196s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006295s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_socket` [ RunTime:0.008762s ] [ sql ] [ SQL ] SELECT `equi_id`,`num`,`socket_list`,`name` FROM `tp_charge_socket` WHERE `code` = 'BJ000263' [ RunTime:0.013447s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_equi` [ RunTime:0.007455s ] [ sql ] [ SQL ] SELECT `id`,`equi_ids`,`brand`,`site_id` FROM `tp_charge_equi` WHERE `id` = 316 LIMIT 1 [ RunTime:0.006215s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007447s ] [ sql ] [ SQL ] SELECT `id`,`name`,`state`,`server_tel` FROM `tp_comm_site` WHERE `id` = 968 LIMIT 1 [ RunTime:0.006184s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.007417s ] [ sql ] [ SQL ] SELECT `show_server_rate` FROM `tp_comm_siteconfig` WHERE `site_id` = 968 LIMIT 1 [ RunTime:0.006190s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_tempprice` [ RunTime:0.007496s ] [ sql ] [ SQL ] SELECT `charge` FROM `tp_comm_tempprice` WHERE `site_id` = 968 LIMIT 1 [ RunTime:0.006219s ] --------------------------------------------------------------- [2025-07-18T23:59:10+08:00] 122.51.55.51 POST api.scyeby.com/public/index.php/index/Wxservice/index.html?signature=9e8aa35258b9bd26115462f2fc1d753a236d9715×tamp=1752854350&nonce=1832836889&openid=oCmeh5WRdZEFNfzmj4j08Rz8dM1o [运行时间：0.061288s] [吞吐率：16.32req/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' => '9e8aa35258b9bd26115462f2fc1d753a236d9715', 'timestamp' => '1752854350', 'nonce' => '1832836889', 'openid' => 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009846s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007899s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006508s ] --------------------------------------------------------------- [2025-07-18T23:59:10+08:00] 222.212.10.157 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.296114s] [吞吐率：3.38req/s] [内存消耗：4,250.80kb] [文件加载：105] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '1315', 'content-type' => 'application/x-www-form-urlencoded', 'x-token' => 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 10; YAL-AL00 Build/HUAWEIYAL-AL00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.157 Mobile Safari/537.36 XWEB/1380055 MMWEBSDK/20250503 MMWEBID/4826 MicroMessenger/8.0.61.2880(0x28003D3F) WeChat/arm64 Weixin NetType/WIFI 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' => '968', 'site_name' => '上行锦绣二车库', 'site_server' => '18980369999', 'equi_ids' => 'YEWI0047', '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' => 'BJ000263', 'price_info' => '[object Object]', 'money_list' => '[object Object],[object Object],[object Object],[object Object],[object Object]', 'money_name' => '', 'pay_money' => '2', 'value' => '15', 'socket_num' => '6', 'socket_no' => '', 'allow_time' => '3.12', '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.010018s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008234s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006748s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008762s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006749s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006859s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008039s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 968 [ RunTime:0.007646s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_icard` [ RunTime:0.007962s ] [ sql ] [ SQL ] SELECT `icard`,`park_end` FROM `tp_comm_icard` WHERE `site_id` = 968 AND `member_id` = 45852 ORDER BY `park_end` DESC LIMIT 1 [ RunTime:0.007383s ] [ sql ] [ SQL ] SELECT `site_id`,`charge_only_num`,`charge_max_time` FROM `tp_comm_siteconfig` WHERE `site_id` = 968 [ RunTime:0.006719s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.007862s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 45852 LIMIT 1 [ RunTime:0.006985s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008371s ] [ sql ] [ SQL ] SELECT `id` FROM `tp_charge_orders` WHERE `equi_ids` = 'YEWI0047' AND `state` = 1 AND `sids` = 'BJ000263' AND `socket_num` = 6 AND `socket_no` = 0 LIMIT 1 [ RunTime:0.008047s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.008005s ] [ sql ] [ SQL ] SELECT `agent_id` FROM `tp_comm_site` WHERE `id` = 968 LIMIT 1 [ RunTime:0.007252s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_user` [ RunTime:0.007964s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006724s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_user` [ RunTime:0.008460s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006662s ] [ 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 , 968 , '20250718235910688615' , NULL , 0 , 45852 , '13908192231' , 'YEWI0047' , 6 , 0 , 'BJ000263' , '2' , '2025-07-18 23:59:10' , 1752890350 , '{\"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.007166s ] [ sql ] [ SQL ] SELECT 968,`agent_id`,`name` FROM `tp_comm_site` WHERE `id` = 968 [ RunTime:0.006694s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_rate` [ RunTime:0.007866s ] [ sql ] [ SQL ] SELECT `user_id`,`type`,`park_rule`,`charge_rule` FROM `tp_comm_rate` WHERE `site_id` = 968 [ RunTime:0.006710s ] [ sql ] [ SQL ] SELECT * FROM `tp_admin_user` WHERE `id` = 438 LIMIT 1 [ RunTime:0.006730s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_user` WHERE `user_id` = 438 LIMIT 1 [ RunTime:0.006701s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008266s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006750s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.007971s ] [ 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 , 'Y20250718235910387481' , NULL , 968 , 45852 , 45852 , '2' , '2' , 'charge_temp' , '2025-07-18 23:59:10' , '{\"site_id\":\"968\",\"site_name\":\"上行锦绣二车库\",\"equi_ids\":\"YEWI0047\",\"equi_brand\":\"qy\",\"sids\":\"BJ000263\",\"socket_num\":\"6\",\"socket_no\":\"\",\"value\":\"15\",\"order_id\":\"2914707\",\"sy_money\":\"2\"}' , '{\"appId\":\"wx9d3af783c5718533\",\"appSecret\":\"49cd7ec1b8418d1dcb19ce60b78ccb95\",\"partnerId\":\"1511337021\",\"apiKey\":\"f02795ff419df1f67b1b59aa0ca06754\",\"code\":\"yeby\",\"name\":\"元贰佰壹\"}' , '[{\"user_id\":438,\"type\":1,\"park_rule\":100,\"charge_rule\":100}]' , '临时充电' , '2025-07' , '2025-07-18' , NULL , 'main') [ RunTime:0.007125s ] [ error ] [8]未定义数组索引: icard[D:\www\api\application\charge\model\Orders.php:79] [ error ] [8]未定义数组索引: other[D:\www\api\application\charge\model\Orders.php:93] [ error ] [8]未定义数组索引: icard[D:\www\api\application\comm\model\Consume.php:53] [ error ] [8]未定义数组索引: remark[D:\www\api\application\comm\model\Consume.php:67] --------------------------------------------------------------- [2025-07-18T23:59:11+08:00] 222.212.10.157 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.532551s] [吞吐率：1.88req/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' => 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o', 'charset' => 'utf-8', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', 'user-agent' => 'Mozilla/5.0 (Linux; Android 10; YAL-AL00 Build/HUAWEIYAL-AL00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/138.0.7204.157 Mobile Safari/537.36 XWEB/1380055 MMWEBSDK/20250503 MMWEBID/4826 MicroMessenger/8.0.61.2880(0x28003D3F) WeChat/arm64 Weixin NetType/WIFI 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' => '2112674', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010204s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008379s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006715s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008076s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006867s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006794s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008141s ] [ sql ] [ SQL ] SELECT `id`,`state`,`src_by`,`pay_money`,`order_sn`,`pay_config` FROM `tp_comm_consume` WHERE `id` = 2112674 LIMIT 1 [ RunTime:0.006667s ] [ error ] [8]未定义数组索引: paysuc_url[D:\www\api\application\index\controller\Payment.php:41] [ error ] [8]未定义数组索引: payerr_url[D:\www\api\application\index\controller\Payment.php:42] --------------------------------------------------------------- [2025-07-18T23:59:19+08:00] 121.51.58.171 POST api.scyeby.com/public/index.php/index/payment/wxnotify.html [运行时间：0.877155s] [吞吐率：1.14req/s] [内存消耗：4,124.45kb] [文件加载：97] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'content-length' => '826', 'user-agent' => 'Mozilla/4.0', 'content-type' => 'text/xml', 'pragma' => 'no-cache', 'connection' => 'Keep-Alive', 'host' => 'api.scyeby.com', 'accept' => '*/*', ) [ info ] [ PARAM ] array ( ) [ sql ] [ DB ] CONNECT:[ UseTime:0.017070s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008116s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006309s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_pay` [ RunTime:0.007701s ] [ sql ] [ SQL ] INSERT INTO `tp_log_pay` (`trade_no` , `content` , `result` , `ctime`) VALUES ('4200002788202507189968009882' , '{\"appid\":\"wx9d3af783c5718533\",\"attach\":\"2112674\",\"bank_type\":\"OTHERS\",\"cash_fee\":\"200\",\"fee_type\":\"CNY\",\"is_subscribe\":\"N\",\"mch_id\":\"1511337021\",\"nonce_str\":\"a23a124118c20c6a4caeb281b1a979a4\",\"openid\":\"oCmeh5WRdZEFNfzmj4j08Rz8dM1o\",\"out_trade_no\":\"Y20250718235910387481\",\"result_code\":\"SUCCESS\",\"return_code\":\"SUCCESS\",\"sign\":\"A719EBFA29EDA4687A5109982CDACCF6\",\"time_end\":\"20250718235917\",\"total_fee\":\"200\",\"trade_type\":\"JSAPI\",\"transaction_id\":\"4200002788202507189968009882\"}' , '[]' , '2025-07-18 23:59:18') [ RunTime:0.006328s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.007451s ] [ sql ] [ SQL ] SELECT `id`,`state`,`ctime`,`details`,`src_by`,`order_money`,`rate` FROM `tp_comm_consume` WHERE `id` = 2112674 LIMIT 1 [ RunTime:0.006351s ] [ sql ] [ SQL ] UPDATE `tp_comm_consume` SET `state` = 9 , `payment_code` = 'wxpay' , `trade_no` = '4200002788202507189968009882' WHERE `id` = 2112674 [ RunTime:0.007960s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.007774s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2914707 LIMIT 1 [ RunTime:0.006922s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `state` = 1 , `payment_code` = 'wxpay' , `trade_no` = '4200002788202507189968009882' WHERE `id` = 2914707 [ RunTime:0.006322s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.007441s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEWI0047' , 'QY_101' , '{\"Z\":\"101\",\"IDS\":\"YEWI0047\",\"SIDS\":\"BJ000263\",\"CZ\":\"6\",\"MODEL\":\"8\",\"TIM\":\"900\",\"DL\":\"1500\",\"MONEY\":\"200\",\"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\":\"2914707\",\"ZMONEY\":\"200\"}' , '{\"state\":\"1\"}' , '2025-07-18 23:59:18') [ RunTime:0.006365s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007451s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 968 LIMIT 1 [ RunTime:0.006317s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.007534s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.007289s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.007987s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 45852 LIMIT 1 [ RunTime:0.006228s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.007815s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5WRdZEFNfzmj4j08Rz8dM1o' , '开始充电' , '{\"touser\":\"oCmeh5WRdZEFNfzmj4j08Rz8dM1o\",\"template_id\":\"Agy1VhMUNj0Ts8jwvjW_UqGEDJOg0Y0-39j6y8nhpRg\",\"data\":{\"thing2\":{\"value\":\"上行锦绣二车库\"},\"character_string8\":{\"value\":\"YEWI0047（BJ000263）\"},\"character_string9\":{\"value\":\"No.6\"},\"character_string6\":{\"value\":2914707},\"time3\":{\"value\":\"2025-07-18 23:59:10\"}},\"page\":\"\\/pages\\/orders\\/chargeing?order_id=2914707\"}' , '{\"errcode\":0,\"errmsg\":\"ok\",\"msgid\":4081260599215079424}' , '2025-07-18 23:59:19') [ RunTime:0.006634s ] [ sql ] [ SQL ] UPDATE `tp_log_pay` SET `result` = '{\"code\":200}' WHERE `trade_no` = '4200002788202507189968009882' [ RunTime:0.006303s ] --------------------------------------------------------------- [2025-07-18T23:59:20+08:00] 121.4.104.160 POST api.scyeby.com/public/index.php/index/Wxservice/index.html?signature=6b38817647eb49deb9d5a9cdd0693243d0e1b351×tamp=1752854359&nonce=800872145&openid=oCmeh5WRdZEFNfzmj4j08Rz8dM1o [运行时间：0.060233s] [吞吐率：16.60req/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' => '6b38817647eb49deb9d5a9cdd0693243d0e1b351', 'timestamp' => '1752854359', 'nonce' => '800872145', 'openid' => 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.010066s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008154s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006780s ] --------------------------------------------------------------- [2025-07-18T23:59:29+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：1.762082s] [吞吐率：0.57req/s] [内存消耗：4,132.13kb] [文件加载：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' => '193', 'expect' => '100-continue', ) [ info ] [ PARAM ] array ( 'Z' => '206', 'IDS' => 'YEWI0047', 'SIDS' => 'BJ000263', 'CZ' => '6', 'DH' => '2914707', 'POW' => '0', 'DL' => '0.0000', 'TIM' => '0', 'MSG' => '8', 'POWs' => '2914707', 'MONEY' => '15', 'MSG2' => '检测到插座无充电器结束订单', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.018311s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008037s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006611s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.008266s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2914707 LIMIT 1 [ RunTime:0.006734s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_siteconfig` [ RunTime:0.008209s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_siteconfig` WHERE `site_id` = 968 [ RunTime:0.006646s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_consume` [ RunTime:0.008189s ] [ sql ] [ SQL ] SELECT `rate` FROM `tp_comm_consume` WHERE `trade_no` = '4200002788202507189968009882' LIMIT 1 [ RunTime:0.006632s ] [ sql ] [ SQL ] SELECT `id`,`order_sn`,`pay_config`,`pay_money`,`trade_no` FROM `tp_comm_consume` WHERE `trade_no` = '4200002788202507189968009882' LIMIT 1 [ RunTime:0.006615s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_pay` [ RunTime:0.008296s ] [ sql ] [ SQL ] INSERT INTO `tp_log_pay` (`trade_no` , `content` , `result` , `ctime`) VALUES ('TK4200002788202507189968009882' , '{\"trade_no\":\"4200002788202507189968009882\",\"order_sn\":\"Y20250718235910387481\",\"pay_money\":2,\"refund_money\":2}' , '{\"code\":200,\"msg\":\"退款成功\",\"data\":{\"return_code\":\"SUCCESS\",\"return_msg\":\"OK\",\"appid\":\"wx9d3af783c5718533\",\"mch_id\":\"1511337021\",\"nonce_str\":\"MtFT9tI3v47mabcc\",\"sign\":\"11846EFD1F00ADFE4C0B7668E465C937\",\"result_code\":\"SUCCESS\",\"transaction_id\":\"4200002788202507189968009882\",\"out_trade_no\":\"Y20250718235910387481\",\"out_refund_no\":\"Y20250718235910387481\",\"refund_id\":\"50300204122025071876598479157\",\"refund_channel\":[],\"refund_fee\":\"200\",\"coupon_refund_fee\":\"0\",\"total_fee\":\"200\",\"cash_fee\":\"200\",\"coupon_refund_count\":\"0\",\"cash_refund_fee\":\"200\"}}' , '2025-07-18 23:59:29') [ RunTime:0.006595s ] [ sql ] [ SQL ] UPDATE `tp_comm_consume` SET `refund_money` = 2 , `refund_state` = 9 , `refund_day` = '2025-07-18' , `refund_month` = '2025-07' , `refund_remark` = ',系统自动退款' WHERE `id` = 2112674 [ RunTime:0.007021s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = '4200002788202507189968009882' , `order_money` = '0.00' , `refund_money` = 2 , `refund_state` = 9 , `time_num` = 0 , `elec_num` = 0 , `power_num` = NULL , `finish` = 8 , `state` = 9 , `other` = '{\"finish_text\":\"检测到插座无充电器结束订单\",\"POWs\":\"2914707\",\"sj_elec\":\"0.0000\"}' , `finish_time` = '2025-07-18 23:59:29' , `js_result` = '{\"money\":\"0.00\",\"elec_num\":0,\"elec_price\":0,\"timeNum\":0,\"server_price\":0}' WHERE `id` = 2914707 [ RunTime:0.007575s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007870s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 968 LIMIT 1 [ RunTime:0.006554s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.008005s ] [ 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.009795s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 45852 LIMIT 1 [ RunTime:0.006565s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.008095s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5WRdZEFNfzmj4j08Rz8dM1o' , '结束充电' , '{\"touser\":\"oCmeh5WRdZEFNfzmj4j08Rz8dM1o\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"上行锦绣二车库\"},\"time4\":{\"value\":\"2025-07-18 23:59:10\"},\"time3\":{\"value\":\"2025-07-18 23:59:29\"},\"thing5\":{\"value\":\"您的订单【2914707】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=2914707\"}' , '{\"errcode\":0,\"errmsg\":\"ok\",\"msgid\":4081260771651305472}' , '2025-07-18 23:59:29') [ RunTime:0.006937s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.007912s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEWI0047' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YEWI0047\",\"SIDS\":\"BJ000263\",\"CZ\":\"6\",\"DH\":\"2914707\",\"POW\":\"0\",\"DL\":\"0.0000\",\"TIM\":\"0\",\"MSG\":\"8\",\"POWs\":\"2914707\",\"MONEY\":\"15\",\"MSG2\":\"检测到插座无充电器结束订单\"}' , '{\"Z\":\"206\",\"IDS\":\"YEWI0047\",\"SIDS\":\"BJ000263\",\"CZ\":\"6\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-07-18 23:59:29') [ RunTime:0.006637s ] --------------------------------------------------------------- [2025-07-18T23:59:30+08:00] 101.35.214.209 POST api.scyeby.com/public/index.php/index/Wxservice/index.html?signature=b0071fc183a7f3d9a38d9d8ea4f56bba5df9f45a×tamp=1752854369&nonce=913763899&openid=oCmeh5WRdZEFNfzmj4j08Rz8dM1o [运行时间：0.058273s] [吞吐率：17.16req/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' => 'b0071fc183a7f3d9a38d9d8ea4f56bba5df9f45a', 'timestamp' => '1752854369', 'nonce' => '913763899', 'openid' => 'oCmeh5WRdZEFNfzmj4j08Rz8dM1o', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009498s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007891s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006268s ] --------------------------------------------------------------- [2025-07-18T23:59:35+08:00] 47.108.14.101 POST api.scyeby.com/public/index.php/index/receive/qycharge.html [运行时间：0.603501s] [吞吐率：1.66req/s] [内存消耗：3,948.52kb] [文件加载：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' => 'YEWI0002', 'SIDS' => 'BJ000208', 'CZ' => '8', 'DH' => '2913858', 'POW' => '355', 'DL' => '0.8482', 'TIM' => '266', 'MSG' => '8', 'POWs' => '2913858', 'MONEY' => '174', 'MSG2' => '充满停止', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009442s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007622s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006290s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.007923s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `id` = 2913858 LIMIT 1 [ RunTime:0.006386s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_month` [ RunTime:0.007488s ] [ sql ] [ SQL ] SELECT `total_elec`,`yet_elec`,`total_time`,`yet_time`,`total_num`,`yet_num` FROM `tp_charge_month` WHERE `id` = 77791 LIMIT 1 [ RunTime:0.007114s ] [ sql ] [ SQL ] UPDATE `tp_charge_month` SET `yet_time` = 49.77 WHERE `id` = 77791 [ RunTime:0.007128s ] [ sql ] [ SQL ] UPDATE `tp_charge_orders` SET `trade_no` = 'HD2025071819324817528383683537' , `order_money` = 0 , `refund_money` = 0 , `refund_state` = 0 , `time_num` = 266 , `elec_num` = 0.93302 , `power_num` = 355 , `finish` = 8 , `state` = 9 , `other` = '{\"month_id\":77791,\"finish_text\":\"充满停止\",\"POWs\":\"2913858\",\"sj_elec\":\"0.8482\"}' , `finish_time` = '2025-07-18 23:59:34' , `js_result` = '[]' WHERE `id` = 2913858 [ RunTime:0.006332s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_site` [ RunTime:0.007397s ] [ sql ] [ SQL ] SELECT `name` FROM `tp_comm_site` WHERE `id` = 968 LIMIT 1 [ RunTime:0.006208s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.007731s ] [ sql ] [ SQL ] SELECT * FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006297s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.007756s ] [ sql ] [ SQL ] SELECT `openid` FROM `tp_comm_member` WHERE `id` = 23441 LIMIT 1 [ RunTime:0.006669s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_wxmp` [ RunTime:0.007998s ] [ sql ] [ SQL ] INSERT INTO `tp_log_wxmp` (`openid` , `type` , `content` , `result` , `ctime`) VALUES ('oCmeh5eZ91xQE3hGRL9YlfdOxMqQ' , '结束充电' , '{\"touser\":\"oCmeh5eZ91xQE3hGRL9YlfdOxMqQ\",\"template_id\":\"X1I7i1wIA7xmgL1yEuZU8ndQzYXgsCqm3qnoUjkYt9w\",\"data\":{\"thing1\":{\"value\":\"上行锦绣二车库\"},\"time4\":{\"value\":\"2025-07-18 19:32:48\"},\"time3\":{\"value\":\"2025-07-18 23:59:34\"},\"thing5\":{\"value\":\"您的订单【2913858】,已结束充电\"}},\"page\":\"\\/pages\\/orders\\/chargedetails?order_id=2913858\"}' , '{\"errcode\":43101,\"errmsg\":\"user refuse to accept the msg rid: 687a6f66-5dbd24e9-12f3e29a\"}' , '2025-07-18 23:59:35') [ RunTime:0.006599s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_log_charge` [ RunTime:0.007550s ] [ sql ] [ SQL ] INSERT INTO `tp_log_charge` (`equi_ids` , `type` , `content` , `result` , `ctime`) VALUES ('YEWI0002' , 'QY_206' , '{\"Z\":\"206\",\"IDS\":\"YEWI0002\",\"SIDS\":\"BJ000208\",\"CZ\":\"8\",\"DH\":\"2913858\",\"POW\":\"355\",\"DL\":\"0.8482\",\"TIM\":\"266\",\"MSG\":\"8\",\"POWs\":\"2913858\",\"MONEY\":\"174\",\"MSG2\":\"充满停止\"}' , '{\"Z\":\"206\",\"IDS\":\"YEWI0002\",\"SIDS\":\"BJ000208\",\"CZ\":\"8\",\"state\":\"1\",\"msg\":\"订单正常结束成功\"}' , '2025-07-18 23:59:35') [ RunTime:0.006544s ] --------------------------------------------------------------- [2025-07-18T23:59:51+08:00] 183.220.27.93 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.071324s] [吞吐率：14.02req/s] [内存消耗：3,543.69kb] [文件加载：89] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '53', 'x-token' => 'oCmeh5TOhb6APBuy4W600Dd1uyoA', '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.60(0x18003c32) NetType/WIFI Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/system/getSystem', 'host' => 'main', 'pageSize' => '15', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009475s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007741s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006309s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_base_system` [ RunTime:0.007751s ] [ sql ] [ SQL ] SELECT `site_name`,`site_logo`,`upload_config`,`regcms` FROM `tp_base_system` WHERE `code` = 'main' LIMIT 1 [ RunTime:0.006308s ] --------------------------------------------------------------- [2025-07-18T23:59:52+08:00] 183.220.27.93 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.115288s] [吞吐率：8.67req/s] [内存消耗：3,860.48kb] [文件加载：92] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '69', 'x-token' => 'oCmeh5TOhb6APBuy4W600Dd1uyoA', '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.60(0x18003c32) NetType/WIFI Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/park/getLists', 'host' => 'main', 'pageSize' => '15', 'page_num' => '1', 'state' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.017570s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008815s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006765s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.008219s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5TOhb6APBuy4W600Dd1uyoA' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006707s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5TOhb6APBuy4W600Dd1uyoA' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.007738s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_park_orders` [ RunTime:0.013083s ] [ 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` = 47586 AND `state` IN (1,8) ORDER BY `state` ASC,`id` DESC LIMIT 30 [ RunTime:0.008334s ] --------------------------------------------------------------- [2025-07-18T23:59:53+08:00] 183.220.27.93 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.105909s] [吞吐率：9.44req/s] [内存消耗：3,922.50kb] [文件加载：92] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '71', 'x-token' => 'oCmeh5TOhb6APBuy4W600Dd1uyoA', '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.60(0x18003c32) NetType/WIFI Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/charge/getLists', 'host' => 'main', 'pageSize' => '15', 'page_num' => '1', 'state' => '1', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009674s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.007809s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006470s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.007777s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5TOhb6APBuy4W600Dd1uyoA' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006413s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5TOhb6APBuy4W600Dd1uyoA' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006366s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_charge_orders` [ RunTime:0.007873s ] [ sql ] [ SQL ] SELECT * FROM `tp_charge_orders` WHERE `member_id` = 47586 AND `state` = 1 AND `del` = 1 ORDER BY `state` ASC,`id` DESC LIMIT 30 [ RunTime:0.014574s ] --------------------------------------------------------------- [2025-07-18T23:59:54+08:00] 183.220.27.93 POST api.scyeby.com/public/index.php/index/member/index [运行时间：0.093343s] [吞吐率：10.71req/s] [内存消耗：3,557.18kb] [文件加载：90] [ info ] [ LANG ] D:\www\api\thinkphp\lang\zh-cn.php [ info ] [ DB ] INIT mysql [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'api.scyeby.com', 'connection' => 'keep-alive', 'content-length' => '51', 'x-token' => 'oCmeh5TOhb6APBuy4W600Dd1uyoA', '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.60(0x18003c32) NetType/WIFI Language/zh_CN', 'referer' => 'https://servicewechat.com/wx9d3af783c5718533/17/page-frame.html', ) [ info ] [ PARAM ] array ( 'api' => 'member/member/getInfo', 'host' => 'main', 'pageSize' => '15', ) [ sql ] [ DB ] CONNECT:[ UseTime:0.009617s ] mysql:host=47.108.14.101;port=3306;dbname=yeby_park;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_admin_config` [ RunTime:0.008068s ] [ sql ] [ SQL ] SELECT `name`,`value`,`type` FROM `tp_admin_config` [ RunTime:0.006396s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_cache` [ RunTime:0.007580s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5TOhb6APBuy4W600Dd1uyoA' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006376s ] [ sql ] [ SQL ] SELECT `value` FROM `tp_cache` WHERE `key` = 'oCmeh5TOhb6APBuy4W600Dd1uyoA' AND `tables` = 'comm_member' LIMIT 1 [ RunTime:0.006376s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `tp_comm_member` [ RunTime:0.007573s ] [ sql ] [ SQL ] SELECT * FROM `tp_comm_member` WHERE `id` = 47586 LIMIT 1 [ RunTime:0.006895s ]