... | @@ -26,3 +26,8 @@ INSERT INTO personal_credit.api_log_statistics (time_index, user_id, api_id, dat |
... | @@ -26,3 +26,8 @@ INSERT INTO personal_credit.api_log_statistics (time_index, user_id, api_id, dat |
|
```
|
|
```
|
|
对应表 :`api_log_statistics`;
|
|
对应表 :`api_log_statistics`;
|
|
查询条件:`time_index, user_id, api_id, data_key`;
|
|
查询条件:`time_index, user_id, api_id, data_key`;
|
|
|
|
|
|
|
|
* 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 |