ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a1d0e5ff3ecc: POST https://beta.jinchangxiao.com/vue/setting/list-erp-verify-processes at 2026-06-01 12:45:19 pm by 221.216.117.119

Database Queries

总计10条数据
TimeDurationTypeQuery
  
12:45:20.0010.6 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
12:45:20.0020.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
12:45:20.0040.4 msSELECTSELECT COUNT(*) FROM (SELECT * FROM "a57be577deb434"."tbl_erp_verify_processes" WHERE ("title" ILIKE '%销售订单%') OR ("parent_title" ILIKE '%销售订单%') ORDER BY "is_delete", "parent_title", "id") "c"

[+] Explain
12:45:20.0050.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_verify_processes" WHERE ("title" ILIKE '%销售订单%') OR ("parent_title" ILIKE '%销售订单%') ORDER BY "is_delete", "parent_title", "id" LIMIT 20

[+] Explain
12:45:20.0050.2 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

[+] Explain
12:45:20.0060.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000)

[+] Explain
12:45:20.0060.1 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10

[+] Explain
12:45:20.0060.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id" IN ('5064', '1001') ORDER BY array_position(array[5064,1001], id)

[+] Explain
12:45:20.0070.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5064, 1001))

[+] Explain
12:45:20.0091.0 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/setting/list-erp-verify-processes', '{"is_delete":"","keyword":"\u9500\u552e\u8ba2\u5355","page":"1","web_access_token":"YNQKwEYJYN8muCSh8ExnNlBf2oepDAlv"}', '{"code":2000,"result":{"list":[{"id":6,"title":"\u9500\u552e\u8ba2\u5355","parent_title":"\u9500\u552e","is_delete":true,"verify_user":"5064,1001","carbon_copy_user":"","updated_by":1000,"updated_at":"2025-08-01 23:14:22","updatedBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"verifyUsers":[{"id":5064,"email":"yaoxuechun@jinchangxiao.com","name":"\u59da\u96ea\u7eaf","user_status":"1","pinyin_shortcut":"yxc","sex":"F","birth_date":"1992-08-02","entry_date":"2018-03-06","department_id":10,"department_position_id":25,"mobile":"17610273960","telephone":"88864628","created_at":"2018-03-06 16:55:56","updated_at":"2026-04-23 17:24:00","id_number":"","native_place":"\u4fdd\u5b9a","graduate_school":"","specialty":"","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"845","leave_date":"","pinyin1":"yao","pinyin2":"xue","pinyin3":"chun","pinyin4":"","namecut1":"\u59da","namecut2":"\u96ea","namecut3":"\u7eaf","namecut4":"","budget_count":"0","profit_count":"0","bargain_count":"0","opportunity_budget_count":"0","opportunity_count":"0","work_log_score":"0","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":false,"view_public":true,"client_remind_alarm_before":"","work_on_remind":true,"work_off_remind":false,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"}},{"id":1001,"email":"lrc@toast.com.cn","name":"\u5218\u4eba\u8bda","user_status":"1","pinyin_shortcut":"lrc","sex":"M","birth_date":"1977-04-06","entry_date":"2005-06-06","department_id":4,"department_position_id":7,"mobile":"13501128560","telephone":"88864628","created_at":"2017-02-06 13:05:08","updated_at":"2026-04-24 14:52:43","id_number":"220523197704064411","native_place":"\u5409\u6797","graduate_school":"\u5409\u6797\u5de5\u4e1a\u5927\u5b66","specialty":"\u8ba1\u7b97\u673a\u5e94\u7528","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"821","leave_date":"","pinyin1":"liu","pinyin2":"ren","pinyin3":"cheng","pinyin4":"","namecut1":"\u5218","namecut2":"\u4eba","namecut3":"\u8bda","namecut4":"","budget_count":"2000425.78","profit_count":"88226.214434000000000000","bargain_count":"5","opportunity_budget_count":"697106.06","opportunity_count":"4","work_log_score":"0","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":true,"view_public":false,"client_remind_alarm_before":"","work_on_remind":false,"work_off_remind":false,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}],"carbonCopyUsers":[],"can_update":true,"can_stop":false,"can_start":true,"bgcolor":"#89c541"}],"can_create":true,"pagenation":{"totalcount":1,"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; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-01 12:45:20', 9755904) RETURNING "id"

[+] Explain