[ 2019-07-22T15:45:56+08:00 ] 223.104.147.41 /api/user/login SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0468s ] SQL: SELECT * FROM `hp_user` WHERE `phone` = '13913933901' AND `password` = '13913933901' LIMIT 1 [ RunTime:0.0214s ] [ 2019-07-22T15:45:58+08:00 ] 223.104.147.41 /api/wxUser/getCompanyList?type=monitor SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0019s ] SQL: SHOW COLUMNS FROM `user_company` [ RunTime:0.0312s ] SQL: SELECT * FROM `user_company` WHERE `phone` = '13913933901' ORDER BY id desc [ RunTime:0.0097s ] [ 2019-07-22T15:46:03+08:00 ] 223.104.147.41 /api/wxUser/getCompanyList?type=monitor SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `user_company` [ RunTime:0.0000s ] SQL: SELECT * FROM `user_company` WHERE `phone` = '13913933901' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-22T15:46:07+08:00 ] 223.104.147.41 /api/wxUser/getDictList SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0019s ] SQL: SHOW COLUMNS FROM `hp_dict` [ RunTime:0.0292s ] SQL: SELECT * FROM `hp_dict` [ RunTime:0.0058s ] [ 2019-07-22T15:46:07+08:00 ] 223.104.147.41 /api/wxUser/getCompanyIOList SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0019s ] SQL: SHOW COLUMNS FROM `hp_io_set` [ RunTime:0.0029s ] SQL: SELECT * FROM `hp_io_set` [ RunTime:0.0010s ] [ 2019-07-22T15:46:09+08:00 ] 223.104.147.41 /api/wxUser/getCompanyList?type=monitor SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0010s ] SQL: SHOW COLUMNS FROM `user_company` [ RunTime:0.0019s ] SQL: SELECT * FROM `user_company` WHERE `phone` = '13913933901' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-22T15:46:17+08:00 ] 223.104.147.41 /api/wxUser/getCompanyList?type=monitor SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0019s ] SQL: SHOW COLUMNS FROM `user_company` [ RunTime:0.0019s ] SQL: SELECT * FROM `user_company` WHERE `phone` = '13913933901' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-22T15:46:18+08:00 ] 223.104.147.41 /api/wxUser/getDictList SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0020s ] SQL: SHOW COLUMNS FROM `hp_dict` [ RunTime:0.0029s ] SQL: SELECT * FROM `hp_dict` [ RunTime:0.0010s ] [ 2019-07-22T15:46:18+08:00 ] 223.104.147.41 /api/wxUser/getCompanyIOList SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0020s ] SQL: SHOW COLUMNS FROM `hp_io_set` [ RunTime:0.0010s ] SQL: SELECT * FROM `hp_io_set` [ RunTime:0.0000s ] [ 2019-07-22T15:48:34+08:00 ] 223.104.147.41 /api/wxUser/addCompany SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0029s ] SQL: SHOW COLUMNS FROM `hp_company` [ RunTime:0.0019s ] SQL: SELECT * FROM `hp_company` WHERE `company_name` = '黄龙医药' LIMIT 1 [ RunTime:0.0010s ] SQL: INSERT INTO `hp_company` (`company_name`,`company_address`,`company_scope`,`flow_physics`,`flow_chemical`,`discharge_dict`,`discharge_type`,`operate_company`,`begin_time`,`operate_person_count`,`operate_type`,`contact_person`,`contact_tel`,`in_info`,`out_info`) VALUES ('黄龙医药','生命园','30','3','0','仙林大学城污水处理厂','日间连续','中意昂','2018-06-12','2','白班','徐','139','[{\"id\":\"9\",\"item_key\":\"CODcr\",\"item_title\":\"CODcr\",\"item_type\":\"1\",\"item_unit\":\"mg/l\",\"display_order\":\"0\",\"core\":\"1\",\"checked\":true,\"value\":\"2000\"},{\"id\":\"11\",\"item_key\":\"氨氮\",\"item_title\":\"氨氮\",\"item_type\":\"1\",\"item_unit\":\"mg/l\",\"display_order\":\"0\",\"core\":\"1\",\"checked\":true,\"value\":\"200\"}]','[{\"id\":\"9\",\"item_key\":\"CODcr\",\"item_title\":\"CODcr\",\"item_type\":\"1\",\"item_unit\":\"mg/l\",\"display_order\":\"0\",\"core\":\"1\",\"checked\":true,\"value\":\"2000\"},{\"id\":\"11\",\"item_key\":\"氨氮\",\"item_title\":\"氨氮\",\"item_type\":\"1\",\"item_unit\":\"mg/l\",\"display_order\":\"0\",\"core\":\"1\",\"checked\":true,\"value\":\"200\"}]') [ RunTime:0.2153s ] SQL: SHOW COLUMNS FROM `hp_company_user` [ RunTime:0.0000s ] SQL: INSERT INTO `hp_company_user` (`phone`,`company_id`,`type`) VALUES ('13913933901','15','3') [ RunTime:0.0779s ] [ 2019-07-22T15:48:34+08:00 ] 223.104.147.41 /api/wxUser/getCompanyList?type=monitor SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `user_company` [ RunTime:0.0000s ] SQL: SELECT * FROM `user_company` WHERE `phone` = '13913933901' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-22T15:48:39+08:00 ] 223.104.147.41 /api/wxUser/companyMemberListById?companyId=15 SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `hp_company_user` [ RunTime:0.0000s ] SQL: SELECT * FROM `hp_company_user` WHERE ( company_id=15 and phone='13913933901' and (type=3 or type=3) ) LIMIT 1 [ RunTime:0.0000s ] SQL: SELECT * FROM `hp_company_user` WHERE ( company_id=15 ) ORDER BY id desc [ RunTime:0.0156s ] [ 2019-07-22T15:48:58+08:00 ] 223.104.147.41 /api/wxUser/addCompanyMember SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `hp_company_user` [ RunTime:0.0000s ] SQL: SELECT * FROM `hp_company_user` WHERE ( company_id=15 and phone='13913933901' and (type=3 or type=3) ) LIMIT 1 [ RunTime:0.0000s ] SQL: SELECT * FROM `hp_company_user` WHERE `type` = 1 AND `phone` = '13954136854' AND `company_id` = 15 LIMIT 1 [ RunTime:0.0000s ] SQL: INSERT INTO `hp_company_user` (`type`,`phone`,`company_id`) VALUES ('1','13954136854','15') [ RunTime:0.0156s ] [ 2019-07-22T15:48:58+08:00 ] 223.104.147.41 /api/wxUser/companyMemberListById?companyId=15 SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0019s ] SQL: SHOW COLUMNS FROM `hp_company_user` [ RunTime:0.0019s ] SQL: SELECT * FROM `hp_company_user` WHERE ( company_id=15 and phone='13913933901' and (type=3 or type=3) ) LIMIT 1 [ RunTime:0.0000s ] SQL: SELECT * FROM `hp_company_user` WHERE ( company_id=15 ) ORDER BY id desc [ RunTime:0.0010s ] [ 2019-07-22T15:49:08+08:00 ] 223.104.147.41 /api/wxUser/getCompanyList?type=monitor SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0019s ] SQL: SHOW COLUMNS FROM `user_company` [ RunTime:0.0010s ] SQL: SELECT * FROM `user_company` WHERE `phone` = '13913933901' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-22T15:49:12+08:00 ] 223.104.147.41 /api/wxUser/getCompanyInfo?id=15 SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0019s ] SQL: SHOW COLUMNS FROM `hp_company` [ RunTime:0.0019s ] SQL: SELECT * FROM `hp_company` WHERE `id` = 15 LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-22T15:50:44+08:00 ] 223.104.147.41 /api/wxUser/addIOForm SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0019s ] SQL: SHOW COLUMNS FROM `hp_company_user` [ RunTime:0.0019s ] SQL: SELECT * FROM `hp_company_user` WHERE ( company_id=15 and phone='13913933901' and (type=3 or type=1) ) LIMIT 1 [ RunTime:0.0399s ] NOTIC: [8] Undefined index: phone E:\web\hp\api\Interface\Api\Controller\WxUserController.class.php 第 97 行. NOTIC: [8] Undefined index: id E:\web\hp\api\Interface\Api\Controller\WxUserController.class.php 第 101 行. SQL: SHOW COLUMNS FROM `hp_io_table` [ RunTime:0.0760s ] SQL: INSERT INTO `hp_io_table` (`flow_count`,`flow_count_time`,`day_t`,`day_h`,`company_id`,`content_info`,`author`,`pubdate`,`user_id`) VALUES ('3528','2019-07-22','0','0','15','{\"in\":[{\"title\":\"进水CODcr (mg/l)\",\"id\":\"9\",\"data\":[{\"time\":\"2019-07-22 08:30:00\",\"value\":\"1500\"},{\"time\":\"\",\"value\":\"\"}],\"remark\":\"\"},{\"title\":\"进水氨氮 (mg/l)\",\"id\":\"11\",\"data\":[{\"time\":\"2019-07-22 15:50:19\",\"value\":\"50\"}],\"remark\":\"\"}],\"out\":[{\"title\":\"出水CODcr (mg/l)\",\"id\":\"9\",\"data\":[{\"time\":\"2019-07-22 15:50:29\",\"value\":\"200\"}],\"remark\":\"\"},{\"title\":\"出水氨氮 (mg/l)\",\"id\":\"11\",\"data\":[{\"time\":\"2019-07-22 15:50:37\",\"value\":\"100\"}],\"remark\":\"\"}]}',NULL,'1563781844','65') [ RunTime:0.0458s ] [ 2019-07-22T15:51:01+08:00 ] 223.104.147.41 /api/wxUser/getCompanyInfo?id=15 SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0019s ] SQL: SHOW COLUMNS FROM `hp_company` [ RunTime:0.0019s ] SQL: SELECT * FROM `hp_company` WHERE `id` = 15 LIMIT 1 [ RunTime:0.0010s ] [ 2019-07-22T15:51:21+08:00 ] 223.104.147.41 /api/wxUser/getCompanyList?type=monitor SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0019s ] SQL: SHOW COLUMNS FROM `user_company` [ RunTime:0.0214s ] SQL: SELECT * FROM `user_company` WHERE `phone` = '13913933901' ORDER BY id desc [ RunTime:0.0010s ] [ 2019-07-22T15:51:24+08:00 ] 223.104.147.41 /api/wxUser/getCompanyInfo?id=15 SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0019s ] SQL: SHOW COLUMNS FROM `hp_company` [ RunTime:0.0019s ] SQL: SELECT * FROM `hp_company` WHERE `id` = 15 LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-22T15:51:29+08:00 ] 223.104.147.41 /api/wxUser/getIoRecordListByCompanyId?companyId=15 SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `hp_company_user` [ RunTime:0.0000s ] SQL: SELECT * FROM `hp_company_user` WHERE ( company_id=15 and phone='13913933901' and (type=3 or type=2) ) LIMIT 1 [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `hp_io_table` [ RunTime:0.0000s ] SQL: SELECT * FROM `hp_io_table` WHERE ( company_id=15 ) ORDER BY id desc LIMIT 0,9 [ RunTime:0.0156s ] [ 2019-07-22T15:51:32+08:00 ] 223.104.147.41 /api/wxUser/getIoRecord?recordId=20 SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0029s ] SQL: SHOW COLUMNS FROM `hp_io_table` [ RunTime:0.0010s ] SQL: SELECT * FROM `hp_io_table` WHERE `id` = 20 LIMIT 1 [ RunTime:0.0010s ] SQL: SHOW COLUMNS FROM `hp_company_user` [ RunTime:0.0010s ] SQL: SELECT * FROM `hp_company_user` WHERE ( company_id=15 and phone='13913933901' and (type=3 or type=2) ) LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-22T15:51:43+08:00 ] 223.104.147.41 /api/wxUser/getIoRecordListByCompanyId?companyId=15 SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0019s ] SQL: SHOW COLUMNS FROM `hp_company_user` [ RunTime:0.0010s ] SQL: SELECT * FROM `hp_company_user` WHERE ( company_id=15 and phone='13913933901' and (type=3 or type=2) ) LIMIT 1 [ RunTime:0.0010s ] SQL: SHOW COLUMNS FROM `hp_io_table` [ RunTime:0.0010s ] SQL: SELECT * FROM `hp_io_table` WHERE ( company_id=15 ) ORDER BY id desc LIMIT 0,9 [ RunTime:0.0000s ] [ 2019-07-22T15:51:44+08:00 ] 223.104.147.41 /api/wxUser/getCompanyList?type=monitor SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0019s ] SQL: SHOW COLUMNS FROM `user_company` [ RunTime:0.0019s ] SQL: SELECT * FROM `user_company` WHERE `phone` = '13913933901' ORDER BY id desc [ RunTime:0.0010s ] [ 2019-07-22T15:52:50+08:00 ] 223.104.147.41 /api/user/loginOut SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0019s ] SQL: UPDATE `hp_user` SET `wx_openid`='' WHERE `id` = 65 [ RunTime:0.0282s ] [ 2019-07-22T15:55:21+08:00 ] 61.151.178.180 /api/user/login SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SELECT * FROM `hp_user` WHERE `phone` = '15366012136' AND `password` = '123456' LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-22T15:56:06+08:00 ] 61.151.207.252 /api/user/login SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0156s ] SQL: SELECT * FROM `hp_user` WHERE `phone` = '15996406365' AND `password` = '15996406365' LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-22T15:56:13+08:00 ] 61.151.178.180 /api/user/register SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0019s ] SQL: SELECT COUNT(*) AS tp_count FROM `hp_user` WHERE `phone` = '15366012136' LIMIT 1 [ RunTime:0.0019s ] SQL: INSERT INTO `hp_user` (`phone`,`password`,`create_date`,`ip`,`wx_openid`) VALUES ('15366012136','15366012136','1563782173','49.90.149.91','') [ RunTime:0.0205s ] SQL: SELECT * FROM `hp_user` WHERE `phone` = '15366012136' LIMIT 1 [ RunTime:0.0010s ] [ 2019-07-22T15:56:23+08:00 ] 61.151.178.180 /api/wxUser/getCompanyList?type=monitor SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0029s ] SQL: SHOW COLUMNS FROM `user_company` [ RunTime:0.0019s ] SQL: SELECT * FROM `user_company` WHERE `phone` = '15366012136' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-22T15:56:27+08:00 ] 61.151.207.252 /api/user/register SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0029s ] SQL: SELECT COUNT(*) AS tp_count FROM `hp_user` WHERE `phone` = '15996406365' LIMIT 1 [ RunTime:0.0000s ] SQL: INSERT INTO `hp_user` (`phone`,`password`,`create_date`,`ip`,`wx_openid`) VALUES ('15996406365','15996406365','1563782187','49.94.143.194','') [ RunTime:0.0058s ] SQL: SELECT * FROM `hp_user` WHERE `phone` = '15996406365' LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-22T15:56:28+08:00 ] 61.151.178.180 /api/wxUser/getCompanyIOList SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0019s ] SQL: SHOW COLUMNS FROM `hp_io_set` [ RunTime:0.0010s ] SQL: SELECT * FROM `hp_io_set` [ RunTime:0.0000s ] [ 2019-07-22T15:56:28+08:00 ] 61.151.178.180 /api/wxUser/getDictList SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0019s ] SQL: SHOW COLUMNS FROM `hp_dict` [ RunTime:0.0019s ] SQL: SELECT * FROM `hp_dict` [ RunTime:0.0000s ] [ 2019-07-22T15:56:29+08:00 ] 61.151.207.252 /api/wxUser/getCompanyList?type=monitor SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `user_company` [ RunTime:0.0000s ] SQL: SELECT * FROM `user_company` WHERE `phone` = '15996406365' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-22T15:56:31+08:00 ] 61.151.207.252 /api/wxUser/getDictList SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0019s ] SQL: SHOW COLUMNS FROM `hp_dict` [ RunTime:0.0019s ] SQL: SELECT * FROM `hp_dict` [ RunTime:0.0000s ] [ 2019-07-22T15:56:31+08:00 ] 61.151.207.252 /api/wxUser/getCompanyIOList SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0019s ] SQL: SHOW COLUMNS FROM `hp_io_set` [ RunTime:0.0010s ] SQL: SELECT * FROM `hp_io_set` [ RunTime:0.0010s ] [ 2019-07-22T15:59:07+08:00 ] 61.151.178.180 /api/wxUser/getCompanyList?type=monitor SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0029s ] SQL: SHOW COLUMNS FROM `user_company` [ RunTime:0.0019s ] SQL: SELECT * FROM `user_company` WHERE `phone` = '15366012136' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-22T15:59:15+08:00 ] 61.151.178.180 /api/wxUser/getCompanyList?type=monitor SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0019s ] SQL: SHOW COLUMNS FROM `user_company` [ RunTime:0.0019s ] SQL: SELECT * FROM `user_company` WHERE `phone` = '15366012136' ORDER BY id desc [ RunTime:0.0010s ] [ 2019-07-22T16:02:29+08:00 ] 61.151.207.252 /api/wxUser/getCompanyList?type=monitor SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0019s ] SQL: SHOW COLUMNS FROM `user_company` [ RunTime:0.0019s ] SQL: SELECT * FROM `user_company` WHERE `phone` = '15996406365' ORDER BY id desc [ RunTime:0.0010s ] [ 2019-07-22T17:46:52+08:00 ] 49.94.143.194 /api/wxUser/getCompanyList?type=monitor SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0731s ] SQL: SHOW COLUMNS FROM `user_company` [ RunTime:0.0185s ] SQL: SELECT * FROM `user_company` WHERE `phone` = '15996406365' ORDER BY id desc [ RunTime:0.0224s ] [ 2019-07-22T17:47:11+08:00 ] 49.94.143.194 /api/wxUser/getCompanyList?type=monitor SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0019s ] SQL: SHOW COLUMNS FROM `user_company` [ RunTime:0.0019s ] SQL: SELECT * FROM `user_company` WHERE `phone` = '15996406365' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-22T17:47:13+08:00 ] 49.94.143.194 /api/wxUser/getDictList SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0292s ] SQL: SHOW COLUMNS FROM `hp_dict` [ RunTime:0.0107s ] SQL: SELECT * FROM `hp_dict` [ RunTime:0.0205s ] [ 2019-07-22T17:47:13+08:00 ] 49.94.143.194 /api/wxUser/getCompanyIOList SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0039s ] SQL: SHOW COLUMNS FROM `hp_io_set` [ RunTime:0.0029s ] SQL: SELECT * FROM `hp_io_set` [ RunTime:0.0019s ] [ 2019-07-22T17:47:20+08:00 ] 49.94.143.194 /api/wxUser/getCompanyList?type=monitor SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0020s ] SQL: SHOW COLUMNS FROM `user_company` [ RunTime:0.0020s ] SQL: SELECT * FROM `user_company` WHERE `phone` = '15996406365' ORDER BY id desc [ RunTime:0.0010s ]