[ 2019-07-03T00:02:13+08:00 ] 61.129.8.199 /api/user/loginOut SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: UPDATE `hp_user` SET `wx_openid`='' WHERE `id` = 47 [ RunTime:0.0000s ] [ 2019-07-03T00:02:25+08:00 ] 61.129.8.199 /api/user/login SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0019s ] SQL: SELECT * FROM `hp_user` WHERE `phone` = '18606506851' AND `password` = '123456' LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-03T00:02:27+08:00 ] 61.129.8.199 /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` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T00:02:37+08:00 ] 61.129.8.199 /api/wxUser/companyMemberListById?companyId=5 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=5 ) ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T00:02:48+08:00 ] 61.129.8.199 /api/wxUser/addCompanyMember SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `hp_company_user` [ RunTime:0.0000s ] SQL: INSERT INTO `hp_company_user` (`type`,`phone`,`company_id`) VALUES ('2','18606506851','5') [ RunTime:0.0156s ] [ 2019-07-03T00:02:48+08:00 ] 61.129.8.199 /api/wxUser/companyMemberListById?companyId=5 SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `hp_company_user` [ RunTime:0.0156s ] SQL: SELECT * FROM `hp_company_user` WHERE ( company_id=5 ) ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T00:02:54+08:00 ] 61.129.8.199 /api/wxUser/addCompanyMember SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0312s ] SQL: SHOW COLUMNS FROM `hp_company_user` [ RunTime:0.0000s ] SQL: INSERT INTO `hp_company_user` (`type`,`phone`,`company_id`) VALUES ('1','18606506851','5') [ RunTime:0.0156s ] [ 2019-07-03T00:02:54+08:00 ] 61.129.8.199 /api/wxUser/companyMemberListById?companyId=5 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=5 ) ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T00:03:05+08:00 ] 61.129.8.199 /api/wxUser/delCompanyMember?id=15 SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `hp_company_user` [ RunTime:0.0156s ] SQL: UPDATE `hp_company_user` SET `status`='-1' WHERE `id` = 15 [ RunTime:0.0156s ] [ 2019-07-03T00:03:06+08:00 ] 61.129.8.199 /api/wxUser/companyMemberListById?companyId=5 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=5 ) ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T00:03:51+08:00 ] 61.129.8.199 /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` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T00:03:56+08:00 ] 61.129.8.199 /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` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T00:04:02+08:00 ] 61.129.8.199 /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` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T00:04:13+08:00 ] 61.129.8.199 /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` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T00:04:15+08:00 ] 61.129.8.199 /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` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T00:04:24+08:00 ] 61.129.8.199 /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` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T00:04:27+08:00 ] 61.129.8.199 /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` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T00:04:29+08:00 ] 61.129.8.199 /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` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T00:04:32+08:00 ] 61.129.8.199 /api/wxUser/companyMemberListById?companyId=2 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=2 ) ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T00:04:43+08:00 ] 61.129.8.199 /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` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T00:04:45+08:00 ] 61.129.8.199 /api/user/loginOut SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: UPDATE `hp_user` SET `wx_openid`='' WHERE `id` = 47 [ RunTime:0.0312s ] [ 2019-07-03T07:32:55+08:00 ] 61.129.8.199 /api/user/login SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SELECT * FROM `hp_user` WHERE `phone` = '18606506851' AND `password` = '123456' LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-03T07:32:57+08:00 ] 61.129.8.199 /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` = '18606506851' ORDER BY id desc [ RunTime:0.0010s ] [ 2019-07-03T07:33:03+08:00 ] 61.129.8.199 /api/wxUser/companyMemberListById?companyId=2 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=2 ) ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T07:33:10+08:00 ] 61.129.8.199 /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` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T07:33:13+08:00 ] 58.246.221.74 /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` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T07:33:15+08:00 ] 61.129.8.199 /api/wxUser/getCompanyList?type=monitor SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `user_company` [ RunTime:0.0156s ] SQL: SELECT * FROM `user_company` WHERE `phone` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T07:33:17+08:00 ] 61.129.8.199 /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` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T07:33:24+08:00 ] 61.129.8.199 /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` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T08:58:36+08:00 ] 61.129.8.199 /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` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T08:58:39+08:00 ] 58.246.221.74 /api/user/loginOut SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0156s ] SQL: UPDATE `hp_user` SET `wx_openid`='' WHERE `id` = 47 [ RunTime:0.0000s ] [ 2019-07-03T12:11:49+08:00 ] 61.129.8.199 /api/user/login SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SELECT * FROM `hp_user` WHERE `phone` = '18606506851' AND `password` = '123456' LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-03T12:11:50+08:00 ] 61.129.8.199 /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` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T12:11:53+08:00 ] 61.129.8.199 /api/wxUser/companyMemberListById?companyId=2 SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `hp_company_user` [ RunTime:0.0156s ] SQL: SELECT * FROM `hp_company_user` WHERE ( company_id=2 ) ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T12:12:01+08:00 ] 61.129.8.199 /api/wxUser/getCompanyList?type=monitor SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0156s ] SQL: SHOW COLUMNS FROM `user_company` [ RunTime:0.0000s ] SQL: SELECT * FROM `user_company` WHERE `phone` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T12:12:08+08:00 ] 61.129.8.199 /api/wxUser/getCompanyList?type=monitor SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0156s ] SQL: SHOW COLUMNS FROM `user_company` [ RunTime:0.0000s ] SQL: SELECT * FROM `user_company` WHERE `phone` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T12:12:15+08:00 ] 58.246.221.74 /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` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T12:12:16+08:00 ] 58.246.221.74 /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` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T12:12:19+08:00 ] 58.246.221.74 /api/user/loginOut SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: UPDATE `hp_user` SET `wx_openid`='' WHERE `id` = 47 [ RunTime:0.0312s ] [ 2019-07-03T13:45:34+08:00 ] 61.175.197.202 /api/auth/getPerms SQL: SHOW COLUMNS FROM `hp_auth` [ RunTime:0.0000s ] [ 2019-07-03T13:45:34+08:00 ] 61.175.197.202 /api/auth/getAuthInfo SQL: SHOW COLUMNS FROM `hp_auth` [ RunTime:0.0000s ] [ 2019-07-03T13:45:34+08:00 ] 61.175.197.202 /api/dict/getAll SQL: SHOW COLUMNS FROM `hp_dict` [ RunTime:0.0000s ] SQL: SELECT * FROM `hp_dict` ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T13:45:34+08:00 ] 61.175.197.202 /api/user/getList?pageNo=1&pageSize=12&query= SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SELECT * FROM `hp_user` ORDER BY id desc LIMIT 0,12 [ RunTime:0.0156s ] SQL: SELECT COUNT(*) AS tp_count FROM `hp_user` LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-03T13:45:35+08:00 ] 61.175.197.202 /api/auth/getAuthInfo SQL: SHOW COLUMNS FROM `hp_auth` [ RunTime:0.0000s ] [ 2019-07-03T13:45:35+08:00 ] 61.175.197.202 /api/dict/getAll SQL: SHOW COLUMNS FROM `hp_dict` [ RunTime:0.0000s ] SQL: SELECT * FROM `hp_dict` ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T13:45:35+08:00 ] 61.175.197.202 /api/user/getList?pageNo=1&pageSize=12&query= SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SELECT * FROM `hp_user` ORDER BY id desc LIMIT 0,12 [ RunTime:0.0000s ] SQL: SELECT COUNT(*) AS tp_count FROM `hp_user` LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-03T13:45:37+08:00 ] 61.175.197.202 /api/ioTable/getList?pageNo=1&pageSize=12 ERR: 无法加载控制器:IoTable [ 2019-07-03T13:45:37+08:00 ] 61.175.197.202 /api/company/getList?pageSize=300 SQL: SHOW COLUMNS FROM `hp_company` [ RunTime:0.0156s ] NOTIC: [8] Undefined index: pageNo E:\web\hp\api\Interface\Api\Controller\CompanyController.class.php 第 19 行. NOTIC: [8] Undefined index: query E:\web\hp\api\Interface\Api\Controller\CompanyController.class.php 第 21 行. SQL: SELECT * FROM `hp_company` ORDER BY id desc LIMIT 0,300 [ RunTime:0.0000s ] SQL: SELECT COUNT(*) AS tp_count FROM `hp_company` LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-03T13:45:46+08:00 ] 61.175.197.202 /api/auth/getPerms SQL: SHOW COLUMNS FROM `hp_auth` [ RunTime:0.0000s ] [ 2019-07-03T13:45:46+08:00 ] 61.175.197.202 /api/auth/getAuthInfo SQL: SHOW COLUMNS FROM `hp_auth` [ RunTime:0.0156s ] [ 2019-07-03T13:45:46+08:00 ] 61.175.197.202 /api/dict/getAll SQL: SHOW COLUMNS FROM `hp_dict` [ RunTime:0.0000s ] SQL: SELECT * FROM `hp_dict` ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T13:45:46+08:00 ] 61.175.197.202 /api/ioTable/getList?pageNo=1&pageSize=12 ERR: 无法加载控制器:IoTable [ 2019-07-03T13:45:46+08:00 ] 61.175.197.202 /api/company/getList?pageSize=300 SQL: SHOW COLUMNS FROM `hp_company` [ RunTime:0.0000s ] NOTIC: [8] Undefined index: pageNo E:\web\hp\api\Interface\Api\Controller\CompanyController.class.php 第 19 行. NOTIC: [8] Undefined index: query E:\web\hp\api\Interface\Api\Controller\CompanyController.class.php 第 21 行. SQL: SELECT * FROM `hp_company` ORDER BY id desc LIMIT 0,300 [ RunTime:0.0000s ] SQL: SELECT COUNT(*) AS tp_count FROM `hp_company` LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-03T13:45:47+08:00 ] 61.175.197.202 /api/auth/getAuthInfo SQL: SHOW COLUMNS FROM `hp_auth` [ RunTime:0.0000s ] [ 2019-07-03T13:45:47+08:00 ] 61.175.197.202 /api/dict/getAll SQL: SHOW COLUMNS FROM `hp_dict` [ RunTime:0.0000s ] SQL: SELECT * FROM `hp_dict` ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T13:45:47+08:00 ] 61.175.197.202 /api/ioTable/getList?pageNo=1&pageSize=12 ERR: 无法加载控制器:IoTable [ 2019-07-03T13:45:47+08:00 ] 61.175.197.202 /api/company/getList?pageSize=300 SQL: SHOW COLUMNS FROM `hp_company` [ RunTime:0.0000s ] NOTIC: [8] Undefined index: pageNo E:\web\hp\api\Interface\Api\Controller\CompanyController.class.php 第 19 行. NOTIC: [8] Undefined index: query E:\web\hp\api\Interface\Api\Controller\CompanyController.class.php 第 21 行. SQL: SELECT * FROM `hp_company` ORDER BY id desc LIMIT 0,300 [ RunTime:0.0000s ] SQL: SELECT COUNT(*) AS tp_count FROM `hp_company` LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-03T13:46:03+08:00 ] 61.175.197.202 /api/dict/getList?pageNo=1&pageSize=12 SQL: SHOW COLUMNS FROM `hp_dict` [ RunTime:0.0156s ] SQL: SELECT * FROM `hp_dict` ORDER BY id desc LIMIT 0,12 [ RunTime:0.0000s ] SQL: SELECT COUNT(*) AS tp_count FROM `hp_dict` LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-03T13:46:04+08:00 ] 61.175.197.202 /api/ioSet/getList?pageNo=1&pageSize=12 ERR: 无法加载控制器:IoSet [ 2019-07-03T13:46:09+08:00 ] 61.175.197.202 /api/page/getList?pageNo=1&pageSize=12 SQL: SHOW COLUMNS FROM `hp_page` [ RunTime:0.0000s ] SQL: SELECT * FROM `hp_page` ORDER BY id desc LIMIT 0,12 [ RunTime:0.0000s ] SQL: SELECT COUNT(*) AS tp_count FROM `hp_page` LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-03T13:46:09+08:00 ] 61.175.197.202 /api/ioSet/getList?pageNo=1&pageSize=12 ERR: 无法加载控制器:IoSet [ 2019-07-03T21:38:49+08:00 ] 61.129.8.199 /api/user/login SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0156s ] SQL: SELECT * FROM `hp_user` WHERE `phone` = '18606506851' AND `password` = '123456' LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-03T21:38:56+08:00 ] 61.129.8.199 /api/wxUser/getCompanyList?type=monitor SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0156s ] SQL: SHOW COLUMNS FROM `user_company` [ RunTime:0.0000s ] SQL: SELECT * FROM `user_company` WHERE `phone` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T21:39:02+08:00 ] 61.129.8.199 /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` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T21:39:09+08:00 ] 61.129.8.199 /api/wxUser/getCompanyInfo?id=6 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` = 6 LIMIT 1 [ RunTime:0.0010s ] [ 2019-07-03T21:40:53+08:00 ] 61.129.8.199 /api/wxUser/addIOForm SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `hp_io_table` [ RunTime:0.0000s ] SQL: INSERT INTO `hp_io_table` (`flow_count`,`flow_count_time`,`day_t`,`day_h`,`company_id`,`content_info`,`pubdate`,`user_id`) VALUES ('120','2019-07-03','50','12','6','{\"in\":[{\"title\":\"进水CODcr (mg/l)\",\"id\":\"4\",\"data\":[{\"time\":\"2019-05-01 00:00:00\",\"value\":\"12\"},{\"time\":\"2019-05-01 03:00:00\",\"value\":\"13\"}],\"remark\":\"测试\"},{\"title\":\"进水TP (mg/l)\",\"id\":\"7\",\"data\":[{\"time\":\"2011-05-03 00:00:00\",\"value\":\"12\"}],\"remark\":\"\"}],\"out\":[{\"title\":\"出水CODcr (mg/l)\",\"id\":\"4\",\"data\":[{\"time\":\"2009-01-01 00:00:00\",\"value\":\"12\"}],\"remark\":\"\"},{\"title\":\"出水TP (mg/l)\",\"id\":\"7\",\"data\":[{\"time\":\"2009-02-01 00:00:00\",\"value\":\"12\"}],\"remark\":\"\"}]}','1562161253','47') [ RunTime:0.0156s ] [ 2019-07-03T21:40:57+08:00 ] 58.246.221.74 /api/wxUser/getCompanyInfo?id=6 SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `hp_company` [ RunTime:0.0000s ] SQL: SELECT * FROM `hp_company` WHERE `id` = 6 LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-03T21:40:59+08:00 ] 61.129.8.199 /api/wxUser/companyMemberListById?companyId=6 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=6 ) ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T21:41:01+08:00 ] 61.129.8.199 /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` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T21:41:03+08:00 ] 61.129.8.199 /api/wxUser/companyMemberListById?companyId=6 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=6 ) ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T21:41:10+08:00 ] 61.129.8.199 /api/wxUser/addCompanyMember SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `hp_company_user` [ RunTime:0.0000s ] SQL: INSERT INTO `hp_company_user` (`type`,`phone`,`company_id`) VALUES ('1','13819493577','6') [ RunTime:0.0156s ] [ 2019-07-03T21:41:10+08:00 ] 61.129.8.199 /api/wxUser/companyMemberListById?companyId=6 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=6 ) ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T21:41:16+08:00 ] 61.129.8.199 /api/page/getOneInfo/id/2 SQL: SHOW COLUMNS FROM `hp_page` [ RunTime:0.0000s ] SQL: SELECT * FROM `hp_page` WHERE `id` = 2 LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-03T21:41:19+08:00 ] 58.246.221.74 /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` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T21:41:23+08:00 ] 61.129.8.199 /api/wxUser/getIoRecordListByCompanyId?companyId=5 SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `hp_io_table` [ RunTime:0.0000s ] SQL: SELECT * FROM `hp_io_table` WHERE ( company_id=5 ) ORDER BY id desc LIMIT 0,9 [ RunTime:0.0000s ] [ 2019-07-03T21:41:24+08:00 ] 58.246.221.74 /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` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T21:41:25+08:00 ] 61.129.8.199 /api/wxUser/getCompanyInfo?id=5 SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `hp_company` [ RunTime:0.0000s ] SQL: SELECT * FROM `hp_company` WHERE `id` = 5 LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-03T21:41:26+08:00 ] 61.129.8.199 /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` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T21:41:30+08:00 ] 58.246.221.74 /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` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T21:41:32+08:00 ] 58.246.221.74 /api/wxUser/getCompanyInfo?id=3 SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0156s ] SQL: SHOW COLUMNS FROM `hp_company` [ RunTime:0.0000s ] SQL: SELECT * FROM `hp_company` WHERE `id` = 3 LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-03T21:41:33+08:00 ] 58.246.221.74 /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` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T21:41:34+08:00 ] 61.129.8.199 /api/wxUser/getCompanyInfo?id=2 SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `hp_company` [ RunTime:0.0156s ] SQL: SELECT * FROM `hp_company` WHERE `id` = 2 LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-03T21:41:35+08:00 ] 58.246.221.74 /api/wxUser/getCompanyList?type=monitor SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0156s ] SQL: SHOW COLUMNS FROM `user_company` [ RunTime:0.0000s ] SQL: SELECT * FROM `user_company` WHERE `phone` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T21:41:36+08:00 ] 58.246.221.74 /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` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T21:41:41+08:00 ] 58.246.221.74 /api/user/loginOut SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: UPDATE `hp_user` SET `wx_openid`='' WHERE `id` = 47 [ RunTime:0.0000s ] [ 2019-07-03T21:41:53+08:00 ] 58.246.221.74 /api/user/login SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SELECT * FROM `hp_user` WHERE `phone` = '13819493577' AND `password` = '123456' LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-03T21:42:09+08:00 ] 61.129.8.199 /api/user/register SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SELECT COUNT(*) AS tp_count FROM `hp_user` WHERE `phone` = '13819493577' LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-03T21:42:21+08:00 ] 58.246.221.74 /api/user/login SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SELECT * FROM `hp_user` WHERE `phone` = '13819493577' AND `password` = '123' LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-03T21:42:26+08:00 ] 61.129.8.199 /api/user/login SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0156s ] SQL: SELECT * FROM `hp_user` WHERE `phone` = '13819493577' AND `password` = '1' LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-03T21:42:42+08:00 ] 58.246.221.74 /api/user/login SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SELECT * FROM `hp_user` WHERE `phone` = '18606506851' AND `password` = '123456' LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-03T21:42:43+08:00 ] 58.246.221.74 /api/wxUser/getCompanyList?type=monitor SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0156s ] SQL: SHOW COLUMNS FROM `user_company` [ RunTime:0.0000s ] SQL: SELECT * FROM `user_company` WHERE `phone` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T21:42:46+08:00 ] 58.246.221.74 /api/wxUser/companyMemberListById?companyId=2 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=2 ) ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T21:42:48+08:00 ] 58.246.221.74 /api/page/getOneInfo/id/2 SQL: SHOW COLUMNS FROM `hp_page` [ RunTime:0.0000s ] SQL: SELECT * FROM `hp_page` WHERE `id` = 2 LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-03T21:42:50+08:00 ] 58.246.221.74 /api/wxUser/companyMemberListById?companyId=2 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=2 ) ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T21:42:52+08:00 ] 58.246.221.74 /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` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T21:42:55+08:00 ] 61.129.8.199 /api/wxUser/companyMemberListById?companyId=5 SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `hp_company_user` [ RunTime:0.0156s ] SQL: SELECT * FROM `hp_company_user` WHERE ( company_id=5 ) ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T21:42:57+08:00 ] 61.129.8.199 /api/wxUser/delCompanyMember?id=15 SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `hp_company_user` [ RunTime:0.0000s ] SQL: UPDATE `hp_company_user` SET `status`='-1' WHERE `id` = 15 [ RunTime:0.0000s ] [ 2019-07-03T21:42:57+08:00 ] 58.246.221.74 /api/wxUser/companyMemberListById?companyId=5 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=5 ) ORDER BY id desc [ RunTime:0.0156s ] [ 2019-07-03T21:42:58+08:00 ] 58.246.221.74 /api/wxUser/delCompanyMember?id=15 SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `hp_company_user` [ RunTime:0.0156s ] SQL: UPDATE `hp_company_user` SET `status`='-1' WHERE `id` = 15 [ RunTime:0.0000s ] [ 2019-07-03T21:42:58+08:00 ] 61.129.8.199 /api/wxUser/companyMemberListById?companyId=5 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=5 ) ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T21:42:59+08:00 ] 58.246.221.74 /api/wxUser/delCompanyMember?id=14 SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0156s ] SQL: SHOW COLUMNS FROM `hp_company_user` [ RunTime:0.0000s ] SQL: UPDATE `hp_company_user` SET `status`='-1' WHERE `id` = 14 [ RunTime:0.0000s ] [ 2019-07-03T21:42:59+08:00 ] 61.129.8.199 /api/wxUser/companyMemberListById?companyId=5 SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0156s ] SQL: SHOW COLUMNS FROM `hp_company_user` [ RunTime:0.0000s ] SQL: SELECT * FROM `hp_company_user` WHERE ( company_id=5 ) ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T21:43:03+08:00 ] 58.246.221.74 /api/wxUser/delCompanyMember?id=15 SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `hp_company_user` [ RunTime:0.0312s ] SQL: UPDATE `hp_company_user` SET `status`='-1' WHERE `id` = 15 [ RunTime:0.0000s ] [ 2019-07-03T21:43:03+08:00 ] 58.246.221.74 /api/wxUser/companyMemberListById?companyId=5 SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0029s ] SQL: SHOW COLUMNS FROM `hp_company_user` [ RunTime:0.0029s ] SQL: SELECT * FROM `hp_company_user` WHERE ( company_id=5 ) ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T21:43:03+08:00 ] 58.246.221.74 /api/wxUser/delCompanyMember?id=15 SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `hp_company_user` [ RunTime:0.0000s ] SQL: UPDATE `hp_company_user` SET `status`='-1' WHERE `id` = 15 [ RunTime:0.0156s ] [ 2019-07-03T21:43:03+08:00 ] 58.246.221.74 /api/wxUser/delCompanyMember?id=15 SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `hp_company_user` [ RunTime:0.0000s ] SQL: UPDATE `hp_company_user` SET `status`='-1' WHERE `id` = 15 [ RunTime:0.0000s ] [ 2019-07-03T21:43:03+08:00 ] 58.246.221.74 /api/wxUser/companyMemberListById?companyId=5 SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0156s ] SQL: SHOW COLUMNS FROM `hp_company_user` [ RunTime:0.0000s ] SQL: SELECT * FROM `hp_company_user` WHERE ( company_id=5 ) ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T21:43:03+08:00 ] 58.246.221.74 /api/wxUser/companyMemberListById?companyId=5 SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `hp_company_user` [ RunTime:0.0156s ] SQL: SELECT * FROM `hp_company_user` WHERE ( company_id=5 ) ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T21:43:08+08:00 ] 58.246.221.74 /api/wxUser/companyMemberListById?companyId=5 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=5 ) ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T21:43:10+08:00 ] 61.129.8.199 /api/wxUser/delCompanyMember?id=15 SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `hp_company_user` [ RunTime:0.0000s ] SQL: UPDATE `hp_company_user` SET `status`='-1' WHERE `id` = 15 [ RunTime:0.0000s ] [ 2019-07-03T21:43:11+08:00 ] 58.246.221.74 /api/wxUser/companyMemberListById?companyId=5 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=5 ) ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T21:43:11+08:00 ] 58.246.221.74 /api/wxUser/delCompanyMember?id=15 SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `hp_company_user` [ RunTime:0.0000s ] SQL: UPDATE `hp_company_user` SET `status`='-1' WHERE `id` = 15 [ RunTime:0.0000s ] [ 2019-07-03T21:43:11+08:00 ] 61.129.8.199 /api/wxUser/companyMemberListById?companyId=5 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=5 ) ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T22:23:33+08:00 ] 61.129.8.199 /api/wxUser/getCompanyList?type=monitor SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0156s ] SQL: SHOW COLUMNS FROM `user_company` [ RunTime:0.0000s ] SQL: SELECT * FROM `user_company` WHERE `phone` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T22:23:38+08:00 ] 61.129.8.199 /api/wxUser/getCompanyInfo?id=6 SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `hp_company` [ RunTime:0.0000s ] SQL: SELECT * FROM `hp_company` WHERE `id` = 6 LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-03T22:23:41+08:00 ] 61.129.8.199 /api/wxUser/getCompanyInfo?id=6 SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `hp_company` [ RunTime:0.0000s ] SQL: SELECT * FROM `hp_company` WHERE `id` = 6 LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-03T22:23:43+08:00 ] 61.129.8.199 /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` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-03T22:23:46+08:00 ] 61.129.8.199 /api/wxUser/getCompanyList?type=monitor SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0156s ] SQL: SHOW COLUMNS FROM `user_company` [ RunTime:0.0000s ] SQL: SELECT * FROM `user_company` WHERE `phone` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ]