ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a1e92ec54514: POST https://beta.jinchangxiao.com/vue/setting/list-role at 2026-06-02 04:23:08 pm by 221.216.117.119

Database Queries

总计6条数据
TimeDurationTypeQuery
  
16:23:08.3470.8 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=5064

[+] Explain
16:23:08.3490.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064

[+] Explain
16:23:08.3510.6 msSELECTSELECT COUNT(*) FROM (SELECT * FROM "a57be577deb434"."tbl_auth_items" WHERE ("type"=1) AND ("visible"=TRUE) ORDER BY "system" DESC, "created_at", "id") "c"

[+] Explain
16:23:08.3520.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_auth_items" WHERE ("type"=1) AND ("visible"=TRUE) ORDER BY "system" DESC, "created_at", "id" LIMIT 20

[+] Explain
16:23:08.3520.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_auth_assignments" WHERE "item_name" IN ('Admin', 'GM', 'Engineer', 'AccountManager', 'TechDirector', 'SalesManager', 'SalesDirector', 'CommercialAttache', 'ProjectManager', 'StoreKeeper', 'Accountant', 'Dispatcher', 'Operator', 'Treasurer', 'FinancialAudit', '软件开发', '人力资源', '电话销售', '运营总监')

[+] Explain
16:23:08.3551.0 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 5064, 5, 'vue/setting/list-role', '{"page":"1","web_access_token":"66P66ib-3t6D-JRCTEPzE250hI-J5OEu"}', '{"code":2000,"result":{"list":[{"id":77,"name":"Admin","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u7cfb\u7edf\u7ba1\u7406\u5458)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2016-12-22 13:21:50","updated_at":"2017-01-13 17:56:37","visible":true,"editable":false,"deletable":false,"order":-100,"system":true,"display_name":"\u7cfb\u7edf\u7ba1\u7406\u5458","can_update":false,"can_delete":false,"bgcolor":"#89c541"},{"id":78,"name":"GM","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u603b\u7ecf\u7406)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2016-12-22 13:21:50","updated_at":"2022-11-07 17:53:13","visible":true,"editable":true,"deletable":false,"order":-90,"system":true,"display_name":"\u603b\u7ecf\u7406","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":79,"name":"Engineer","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u5de5\u7a0b\u5e08)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2016-12-22 13:21:50","updated_at":"2026-04-23 16:42:37","visible":true,"editable":true,"deletable":false,"order":-40,"system":true,"display_name":"\u5de5\u7a0b\u5e08","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":81,"name":"AccountManager","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u5ba2\u6237\u7ecf\u7406)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2016-12-22 13:21:50","updated_at":"2026-05-21 18:20:04","visible":true,"editable":true,"deletable":false,"order":-50,"system":true,"display_name":"\u5ba2\u6237\u7ecf\u7406","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":82,"name":"TechDirector","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u6280\u672f\u603b\u76d1)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2016-12-22 13:21:50","updated_at":"2022-11-07 17:54:26","visible":true,"editable":true,"deletable":false,"order":-70,"system":true,"display_name":"\u6280\u672f\u603b\u76d1","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":83,"name":"SalesManager","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u9500\u552e\u7ecf\u7406)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2016-12-22 13:21:50","updated_at":"2026-05-21 18:16:30","visible":true,"editable":true,"deletable":false,"order":-60,"system":true,"display_name":"\u9500\u552e\u7ecf\u7406","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":84,"name":"SalesDirector","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u9500\u552e\u603b\u76d1)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2016-12-22 13:21:50","updated_at":"2024-03-21 07:10:24","visible":true,"editable":true,"deletable":false,"order":-80,"system":true,"display_name":"\u9500\u552e\u603b\u76d1","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":85,"name":"CommercialAttache","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u5546\u52a1\u4e13\u5458)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2016-12-22 13:21:50","updated_at":"2026-05-28 10:59:39","visible":true,"editable":true,"deletable":false,"order":-20,"system":true,"display_name":"\u5546\u52a1\u4e13\u5458","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":92,"name":"ProjectManager","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u9879\u76ee\u7ecf\u7406)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2016-12-22 13:21:50","updated_at":"2025-04-08 17:21:57","visible":true,"editable":true,"deletable":false,"order":-9,"system":true,"display_name":"\u9879\u76ee\u7ecf\u7406","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":86,"name":"StoreKeeper","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u5e93\u7ba1\u4e13\u5458)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2016-12-27 11:24:21","updated_at":"2025-08-13 16:59:32","visible":true,"editable":true,"deletable":false,"order":-10,"system":true,"display_name":"\u5e93\u7ba1\u4e13\u5458","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":99,"name":"Accountant","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u4f1a\u8ba1\u4e13\u5458)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2017-04-25 23:29:27","updated_at":"2025-08-12 18:01:17","visible":true,"editable":true,"deletable":false,"order":-8,"system":true,"display_name":"\u4f1a\u8ba1\u4e13\u5458","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":161,"name":"Dispatcher","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u6d3e\u5355\u5458)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2018-09-18 10:46:37","updated_at":"2026-04-17 15:30:36","visible":true,"editable":true,"deletable":false,"order":-8,"system":true,"display_name":"\u6d3e\u5355\u5458","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":175,"name":"Operator","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u5ba2\u6237\u8fd0\u8425)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2019-12-02 18:25:10","updated_at":"2025-11-26 13:55:57","visible":true,"editable":true,"deletable":false,"order":-7,"system":true,"display_name":"\u5ba2\u6237\u8fd0\u8425","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":283,"name":"Treasurer","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u8d22\u52a1\u4eba\u5458)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2025-08-01 23:14:16","updated_at":"2025-11-05 18:10:06","visible":true,"editable":true,"deletable":false,"order":-20,"system":true,"display_name":"\u8d22\u52a1\u4e13\u5458","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":392,"name":"FinancialAudit","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u8d22\u52a1\u5ba1\u8ba1)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2025-08-18 13:44:05","updated_at":"2025-08-18 13:44:05","visible":true,"editable":true,"deletable":false,"order":-10,"system":true,"display_name":"\u8d22\u52a1\u5ba1\u8ba1","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":101,"name":"\u8f6f\u4ef6\u5f00\u53d1","type":1,"description":"","rule_name":"","data":"","created_at":"2017-05-25 16:47:52","updated_at":"2026-04-23 16:37:57","visible":true,"editable":true,"deletable":true,"order":0,"system":false,"display_name":"\u8f6f\u4ef6\u5f00\u53d1","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":110,"name":"\u4eba\u529b\u8d44\u6e90","type":1,"description":"","rule_name":"","data":"","created_at":"2017-09-06 17:54:48","updated_at":"2025-04-10 10:37:21","visible":true,"editable":true,"deletable":true,"order":0,"system":false,"display_name":"\u4eba\u529b\u8d44\u6e90","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":174,"name":"\u7535\u8bdd\u9500\u552e","type":1,"description":"","rule_name":"","data":"","created_at":"2019-10-08 09:18:30","updated_at":"2022-11-07 17:56:59","visible":true,"editable":true,"deletable":true,"order":0,"system":false,"display_name":"\u7535\u8bdd\u9500\u552e","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":182,"name":"\u8fd0\u8425\u603b\u76d1","type":1,"description":"","rule_name":"","data":"","created_at":"2019-12-03 19:52:10","updated_at":"2022-11-07 17:57:11","visible":true,"editable":true,"deletable":true,"order":0,"system":false,"display_name":"\u8fd0\u8425\u603b\u76d1","can_update":true,"can_delete":true,"bgcolor":"#89c541"}],"can_create":true,"pagenation":{"totalcount":19,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/148.0.0.0 Safari\/537.36"}', FALSE, '2026-06-02 16:23:08', 9367808) RETURNING "id"

[+] Explain