用户 SQL API

GETusers/sql

最后修改时间： 2 年前

责任人:

请求参数

Query 参数

page

integer

分页

可选

示例值:

limit

string

限制显示条目

可选

示例值:

order

string

排序方式

可选

示例值:

create_time desc

where

string

条件语句

可选

whereOr

string

条件语句

可选

cache

string

是否获取缓存数据

可选

示例值:

true

示例代码

返回响应

请求成功(200)

HTTP 状态码: 200

内容格式: JSONapplication/json

code

integer

状态码

必需

msg

string

信息

必需

data

数据

必需

{
  "code": 200,
  "msg": "数据请求成功！",
  "data": {
    "page": 20,
    "count": 100,
    "data": [
      {
        "id": 115,
        "nickname": "兔子",
        "sex": "保密",
        "head_img": "https://api.inis.cn/api/file/random",
        "description": "兔子呀",
        "status": 1,
        "address_url": "https://inis.cn",
        "opt": {
          "login_auth": "c5d7680e585184c3790d95f39134e481"
        },
        "expand": null,
        "longtext": "",
        "create_time": "2022-09-26 12:27:25",
        "update_time": "2022-09-26 13:28:55",
        "last_login_time": "1664166906"
      },
      {
        "id": 114,
        "nickname": "woshilzz",
        "sex": "保密",
        "head_img": "https://api.inis.cn/admin/images/anime/1.jpg",
        "description": null,
        "status": 1,
        "address_url": null,
        "opt": null,
        "expand": null,
        "longtext": null,
        "create_time": "2022-09-20 07:15:26",
        "update_time": "2022-09-20 07:15:26",
        "last_login_time": null
      },
      {
        "id": 113,
        "nickname": "liaojie1314",
        "sex": "保密",
        "head_img": "https://api.inis.cn/admin/images/anime/9.jpg",
        "description": null,
        "status": 1,
        "address_url": null,
        "opt": null,
        "expand": null,
        "longtext": null,
        "create_time": "2022-08-03 23:53:49",
        "update_time": "2022-08-03 23:53:49",
        "last_login_time": null
      },
      {
        "id": 112,
        "nickname": "1",
        "sex": "保密",
        "head_img": "https://api.inis.cn/admin/images/anime/8.jpg",
        "description": null,
        "status": 1,
        "address_url": null,
        "opt": {
          "login_auth": "0d0968f8cebd94e8820f59d6f6d48b51"
        },
        "expand": null,
        "longtext": null,
        "create_time": "2022-07-26 07:51:04",
        "update_time": "2022-07-26 10:23:45",
        "last_login_time": "1658802225"
      },
      {
        "id": 111,
        "nickname": "明月不归沉",
        "sex": "保密",
        "head_img": "https://racns.com/admin/images/anime/9.jpg",
        "description": null,
        "status": 1,
        "address_url": null,
        "opt": null,
        "expand": null,
        "longtext": null,
        "create_time": "2022-07-24 16:05:04",
        "update_time": "2022-07-24 16:05:04",
        "last_login_time": null
      }
    ]
  }
}

最后修改时间： 2 年前