[ 2019-07-23T12:06:39+08:00 ] 223.104.145.42 /api/user/login SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0029s ] SQL: SELECT * FROM `hp_user` WHERE `phone` = '13913933901' AND `password` = '13913933901' LIMIT 1 [ RunTime:0.0166s ] [ 2019-07-23T12:06:41+08:00 ] 223.104.145.42 /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-23T12:06:46+08:00 ] 223.104.145.42 /api/wxUser/getCompanyInfo?id=15 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` = 15 LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-23T12:06:52+08:00 ] 223.104.145.42 /api/wxUser/getCompanyList?type=monitor SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0097s ] 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-23T12:06:54+08:00 ] 223.104.145.42 /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.0477s ] SQL: SHOW COLUMNS FROM `hp_io_table` [ RunTime:0.0029s ] SQL: SELECT * FROM `hp_io_table` WHERE ( company_id=15 ) ORDER BY id desc LIMIT 0,9 [ RunTime:0.0185s ] [ 2019-07-23T12:06:55+08:00 ] 223.104.145.42 /api/wxUser/getIoRecord?recordId=20 SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0019s ] SQL: SHOW COLUMNS FROM `hp_io_table` [ RunTime:0.0010s ] SQL: SELECT * FROM `hp_io_table` WHERE `id` = 20 LIMIT 1 [ RunTime:0.0000s ] 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=2) ) LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-23T12:06:58+08:00 ] 223.104.145.42 /api/wxUser/getIoRecordListByCompanyId?companyId=15 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=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.0000s ] [ 2019-07-23T12:07:01+08:00 ] 223.104.145.42 /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-23T12:07:02+08:00 ] 223.104.145.42 /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-23T12:07:02+08:00 ] 223.104.145.42 /api/wxUser/getCompanyIOList SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0019s ] SQL: SHOW COLUMNS FROM `hp_io_set` [ RunTime:0.0019s ] SQL: SELECT * FROM `hp_io_set` [ RunTime:0.0000s ] [ 2019-07-23T12:07:20+08:00 ] 223.104.145.42 /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-23T12:08:46+08:00 ] 223.104.4.110 /api/user/register SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SELECT COUNT(*) AS tp_count FROM `hp_user` WHERE `phone` = '18362982665' LIMIT 1 [ RunTime:0.0000s ] SQL: INSERT INTO `hp_user` (`phone`,`password`,`create_date`,`ip`,`wx_openid`) VALUES ('18362982665','152499','1563854926','223.104.4.110','') [ RunTime:0.1257s ] SQL: SELECT * FROM `hp_user` WHERE `phone` = '18362982665' LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-23T12:08:49+08:00 ] 223.104.4.110 /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` = '18362982665' ORDER BY id desc [ RunTime:0.0010s ] [ 2019-07-23T12:08:51+08:00 ] 223.104.4.110 /api/wxUser/getDictList SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `hp_dict` [ RunTime:0.0000s ] SQL: SELECT * FROM `hp_dict` [ RunTime:0.0000s ] [ 2019-07-23T12:08:51+08:00 ] 223.104.4.110 /api/wxUser/getCompanyIOList SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `hp_io_set` [ RunTime:0.0156s ] SQL: SELECT * FROM `hp_io_set` [ RunTime:0.0000s ] [ 2019-07-23T12:09:09+08:00 ] 223.104.4.110 /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` = '18362982665' ORDER BY id desc [ RunTime:0.0010s ] [ 2019-07-23T12:44:03+08:00 ] 223.104.4.110 /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` = '18362982665' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-23T12:44:07+08:00 ] 223.104.4.110 /api/wxUser/getDictList SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `hp_dict` [ RunTime:0.0000s ] SQL: SELECT * FROM `hp_dict` [ RunTime:0.0000s ] [ 2019-07-23T12:44:07+08:00 ] 223.104.4.110 /api/wxUser/getCompanyIOList SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `hp_io_set` [ RunTime:0.0000s ] SQL: SELECT * FROM `hp_io_set` [ RunTime:0.0000s ] [ 2019-07-23T12:45:13+08:00 ] 223.104.4.110 /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` = '18362982665' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-23T12:45:15+08:00 ] 223.104.4.110 /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-23T12:45:15+08:00 ] 223.104.4.110 /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-23T12:45:17+08:00 ] 223.104.4.110 /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` = '18362982665' ORDER BY id desc [ RunTime:0.0010s ] [ 2019-07-23T12:45:33+08:00 ] 223.104.4.110 /api/wxUser/getCompanyList?type=monitor SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0029s ] SQL: SHOW COLUMNS FROM `user_company` [ RunTime:0.0010s ] SQL: SELECT * FROM `user_company` WHERE `phone` = '18362982665' ORDER BY id desc [ RunTime:0.0010s ] [ 2019-07-23T12:45:40+08:00 ] 223.104.4.110 /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` = '18362982665' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-23T12:45:40+08:00 ] 223.104.4.110 /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.0010s ] [ 2019-07-23T12:45:40+08:00 ] 223.104.4.110 /api/wxUser/getCompanyIOList SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `hp_io_set` [ RunTime:0.0156s ] SQL: SELECT * FROM `hp_io_set` [ RunTime:0.0000s ] [ 2019-07-23T12:45:44+08:00 ] 223.104.4.110 /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` = '18362982665' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-23T12:45:46+08:00 ] 223.104.4.110 /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-23T12:45:46+08:00 ] 223.104.4.110 /api/wxUser/getCompanyIOList SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0019s ] SQL: SHOW COLUMNS FROM `hp_io_set` [ RunTime:0.0019s ] SQL: SELECT * FROM `hp_io_set` [ RunTime:0.0010s ] [ 2019-07-23T12:48:07+08:00 ] 223.104.4.110 /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` = '18362982665' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-23T21:02:40+08:00 ] 36.24.147.186 /api/user/login SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0039s ] SQL: SELECT * FROM `hp_user` WHERE `phone` = '18606506851' AND `password` = '123456' LIMIT 1 [ RunTime:0.0292s ] [ 2019-07-23T21:02:43+08:00 ] 36.24.147.186 /api/wxUser/getCompanyList?type=monitor SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0039s ] SQL: SHOW COLUMNS FROM `user_company` [ RunTime:0.0234s ] SQL: SELECT * FROM `user_company` WHERE `phone` = '18606506851' ORDER BY id desc [ RunTime:0.0136s ] [ 2019-07-23T21:02:45+08:00 ] 36.24.147.186 /api/wxUser/getCompanyList?type=monitor SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0312s ] SQL: SHOW COLUMNS FROM `user_company` [ RunTime:0.0117s ] SQL: SELECT * FROM `user_company` WHERE `phone` = '18606506851' ORDER BY id desc [ RunTime:0.0000s ] [ 2019-07-23T21:02:50+08:00 ] 36.24.147.186 /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-23T21:02:51+08:00 ] 36.24.147.186 /api/wxUser/getDictList SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0019s ] SQL: SHOW COLUMNS FROM `hp_dict` [ RunTime:0.0234s ] SQL: SELECT * FROM `hp_dict` [ RunTime:0.0058s ] [ 2019-07-23T21:02:51+08:00 ] 36.24.147.186 /api/wxUser/getCompanyIOList SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0010s ] SQL: SHOW COLUMNS FROM `hp_io_set` [ RunTime:0.0263s ] SQL: SELECT * FROM `hp_io_set` [ RunTime:0.0019s ] [ 2019-07-23T21:02:52+08:00 ] 36.24.147.186 /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` = '18606506851' ORDER BY id desc [ RunTime:0.0010s ] [ 2019-07-23T21:02:54+08:00 ] 36.24.147.186 /api/page/getOneInfo/id/2 SQL: SHOW COLUMNS FROM `hp_page` [ RunTime:0.1062s ] SQL: SELECT * FROM `hp_page` WHERE `id` = 2 LIMIT 1 [ RunTime:0.0019s ] [ 2019-07-23T21:02:57+08:00 ] 36.24.147.186 /api/wxUser/companyMemberListById?companyId=14 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=14 and phone='18606506851' and (type=3 or type=3) ) LIMIT 1 [ RunTime:0.0146s ] SQL: SELECT * FROM `hp_company_user` WHERE ( company_id=14 ) ORDER BY id desc [ RunTime:0.0019s ] [ 2019-07-23T21:02:58+08:00 ] 36.24.147.186 /api/wxUser/getCompanyInfo?id=14 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` = 14 LIMIT 1 [ RunTime:0.0068s ] [ 2019-07-23T21:02:59+08:00 ] 36.24.147.186 /api/wxUser/getTodayIoRecordByCompanyId?companyId=14 SQL: SHOW COLUMNS FROM `hp_user` [ RunTime:0.0019s ] SQL: SHOW COLUMNS FROM `hp_company_user` [ RunTime:0.0039s ] SQL: SELECT * FROM `hp_company_user` WHERE ( company_id=14 and phone='18606506851' and (type=3 or type=2) ) LIMIT 1 [ RunTime:0.0010s ] SQL: SHOW COLUMNS FROM `hp_io_table` [ RunTime:0.0097s ] SQL: SELECT * FROM `hp_io_table` WHERE ( flow_count_time='2019-07-23' and company_id=14 ) LIMIT 1 [ RunTime:0.0019s ] SQL: SELECT * FROM `hp_io_table` WHERE ( flow_count_time='2019-07-22' and company_id=14 ) LIMIT 1 [ RunTime:0.0000s ] [ 2019-07-23T21:03:00+08:00 ] 36.24.147.186 /api/wxUser/getIoRecordListByCompanyId?companyId=14 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=14 and phone='18606506851' and (type=3 or type=2) ) LIMIT 1 [ RunTime:0.0000s ] SQL: SHOW COLUMNS FROM `hp_io_table` [ RunTime:0.0117s ] SQL: SELECT * FROM `hp_io_table` WHERE ( company_id=14 ) ORDER BY id desc LIMIT 0,9 [ RunTime:0.0010s ] [ 2019-07-23T21:03:01+08:00 ] 36.24.147.186 /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 ]