sql.md

@@ -25,4 +25,9 @@ SELECT user_id, api_id, status, count(0) FROM personal_credit.api_log WHERE crea
 INSERT INTO personal_credit.api_log_statistics (time_index, user_id, api_id, data_key, data_value, create_time) VALUES (20160815, 1, 1,  'call_error', 2, UNIX_TIMESTAMP(NOW())),(20160815, 1, 1,  'call_success', 2, UNIX_TIMESTAMP(NOW())),(20160815, 1, 1,  'call_total', 4, UNIX_TIMESTAMP(NOW())),(20160815, 1, 3,  'call_success', 1, UNIX_TIMESTAMP(NOW())),(20160815, 1, 3,  'call_total', 1, UNIX_TIMESTAMP(NOW())),(20160815, 2, 1,  'call_success', 1, UNIX_TIMESTAMP(NOW())),(20160815, 2, 1,  'call_total', 1, UNIX_TIMESTAMP(NOW()))ON DUPLICATE KEY UPDATE data_value = VALUES(data_value)
 ```
 对应表 ：`api_log_statistics`;
-查询条件：`time_index, user_id, api_id, data_key`;
+查询条件：`time_index, user_id, api_id, data_key`;
\ No newline at end of file
+
+* Credit_User_SearchHistoryController 控制器
+```
+SELECT * FROM `api_log_statistics` WHERE `api_id` IN (?) AND `data_key` = ? AND `time_index` <= ? AND `time_index` >= ? AND `user_id` = ? ORDER BY time_index ASC
+```
\ No newline at end of file