Database Queries

总计6条数据
TimeDurationTypeQuery
  
10:58:35.445114.0 msSELECTSELECT code AS key, CASE WHEN code = 200 THEN '正常'||'('|| code||')' ELSE '错误'||'('|| code||')' END AS name FROM "global"."tbl_api_log" "a" WHERE a.code IS NOT NULL GROUP BY "code" ORDER BY "code"

10:58:35.56016.8 msSELECTSELECT t.table_schema AS key, e.name FROM information_schema.tables AS t LEFT JOIN global.tbl_enterprises AS e ON (t.table_schema = e.schema_id) WHERE table_name = 'tbl_clients'

10:58:35.58353.5 msSELECTSELECT COUNT(*) FROM "global"."tbl_api_log" "a"

10:58:35.6384.1 msSELECTSELECT a.* FROM "global"."tbl_api_log" "a" ORDER BY "id" DESC LIMIT 20

10:58:35.6430.5 msSELECTSELECT * FROM "global"."tbl_logins" WHERE "id" IN (1001, 1000)

10:58:35.6440.5 msSELECTSELECT * FROM "global"."tbl_enterprises" WHERE "id"=2