ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68b176765e2ac: POST https://beta.jinchangxiao.com/vue/setting/save-edit-role at 2025-08-29 05:44:22 pm by 114.246.239.133

Database Queries

总计15条数据
TimeDurationTypeQuery
  
17:44:22.3892.3 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
17:44:22.3921.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
17:44:22.3950.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_auth_items" WHERE "id"='110'

[+] Explain
17:44:22.3960.6 msSELECTSELECT "name" FROM "a57be577deb434"."tbl_auth_items" WHERE "name"='人力资源' LIMIT 2

[+] Explain
17:44:22.3970.2 msSELECTSELECT "name" FROM "a57be577deb434"."tbl_auth_items" WHERE "display_name"='人力资源' LIMIT 2

[+] Explain
17:44:22.3970.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_auth_items" WHERE ("type"=1) AND ("display_name"='人力资源') AND ("id" != 110)

[+] Explain
17:44:22.3980.2 msSELECTSELECT "name" FROM "a57be577deb434"."tbl_auth_items" WHERE "name"='人力资源' LIMIT 2

[+] Explain
17:44:22.3980.2 msSELECTSELECT "name" FROM "a57be577deb434"."tbl_auth_items" WHERE "display_name"='人力资源' LIMIT 2

[+] Explain
17:44:22.3990.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_auth_items" WHERE ("type"=1) AND ("display_name"='人力资源') AND ("id" != 110)

[+] Explain
17:44:22.3990.8 msUPDATEUPDATE "a57be577deb434"."tbl_auth_items" SET "updated_at"=1756460662 WHERE "name"='人力资源'

[+] Explain
17:44:22.4001.1 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\AuthItems', 110, 'a:0:{}', '', 1001, '114.246.239.133')

[+] Explain
17:44:22.4010.9 msDELETEDELETE FROM "a57be577deb434"."tbl_auth_item_child" WHERE "parent"='人力资源'

[+] Explain
17:44:22.4033.9 msINSERTINSERT INTO "a57be577deb434"."tbl_auth_item_child" ("parent", "child") VALUES ('人力资源', 'viewSalesChart'), ('人力资源', 'viewPreSalesChart'), ('人力资源', 'viewImplementChart'), ('人力资源', 'viewCalendar'), ('人力资源', 'viewClientAnalysis'), ('人力资源', 'viewClientMap'), ('人力资源', 'viewFootPrint'), ('人力资源', 'viewOtherFootPrint'), ('人力资源', 'viewReimbursementAnalysis'), ('人力资源', 'viewApproveAnalysis'), ('人力资源', 'viewSchedule'), ('人力资源', 'createSchedule'), ('人力资源', 'updateSchedule'), ('人力资源', 'deleteSchedule'), ('人力资源', 'viewCalendarMng'), ('人力资源', 'createCalendarMng'), ('人力资源', 'updateCalendarMng'), ('人力资源', 'deleteCalendarMng'), ('人力资源', 'viewTask'), ('人力资源', 'createTask'), ('人力资源', 'updateTask'), ('人力资源', 'deleteTask'), ('人力资源', 'viewClient'), ('人力资源', 'updateClientDocument'), ('人力资源', 'viewWorkLog'), ('人力资源', 'createWorkLog'), ('人力资源', 'updateWorkLog'), ('人力资源', 'viewProject'), ('人力资源', 'viewTicket'), ('人力资源', 'viewSalesOrder'), ('人力资源', 'viewSalesContract'), ('人力资源', 'serviceProgress'), ('人力资源', 'viewReimbursement'), ('人力资源', 'createReimbursement'), ('人力资源', 'updateReimbursement'), ('人力资源', 'viewApprove'), ('人力资源', 'createApprove'), ('人力资源', 'updateApprove'), ('人力资源', 'viewDocument'), ('人力资源', 'createDocument'), ('人力资源', 'updateDocument'), ('人力资源', 'viewSupplier'), ('人力资源', 'visitSupplier'), ('人力资源', 'viewSupplierContact'), ('人力资源', 'createSupplierContact'), ('人力资源', 'updateSupplierContact'), ('人力资源', 'deleteSupplierContact'), ('人力资源', 'viewPurchaseContract'), ('人力资源', 'viewService'), ('人力资源', 'viewPunch'), ('人力资源', 'createPunch'), ('人力资源', 'viewOtherPunch'), ('人力资源', 'viewPunchApprove'), ('人力资源', 'createPunchApprove'), ('人力资源', 'updatePunchApprove'), ('人力资源', 'viewAccount'), ('人力资源', 'updateAccount'), ('人力资源', 'viewRating'), ('人力资源', 'createRating'), ('人力资源', 'updateRating'), ('人力资源', 'manageRating')

[+] Explain
17:44:22.4070.9 msSELECTSELECT "u"."id" FROM "a57be577deb434"."tbl_auth_assignments" "aa" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = aa.user_id WHERE ("u"."user_status"=1) AND ("aa"."item_name"='人力资源') GROUP BY "u"."id"

[+] Explain
17:44:22.4091.1 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/setting/save-edit-role', '{"AuthItems":{"id":"110","name":"\u4eba\u529b\u8d44\u6e90","display_name":"\u4eba\u529b\u8d44\u6e90","permissions":["viewSalesChart","viewPreSalesChart","viewImplementChart","viewCalendar","viewClientAnalysis","viewClientMap","viewFootPrint","viewOtherFootPrint","viewReimbursementAnalysis","viewApproveAnalysis","viewSchedule","createSchedule","updateSchedule","deleteSchedule","viewCalendarMng","createCalendarMng","updateCalendarMng","deleteCalendarMng","viewTask","createTask","updateTask","deleteTask","viewClient","updateClientDocument","viewWorkLog","createWorkLog","updateWorkLog","viewProject","viewTicket","viewSalesOrder","viewSalesContract","serviceProgress","viewReimbursement","createReimbursement","updateReimbursement","viewApprove","createApprove","updateApprove","viewDocument","createDocument","updateDocument","viewSupplier","visitSupplier","viewSupplierContact","createSupplierContact","updateSupplierContact","deleteSupplierContact","viewPurchaseContract","viewService","viewPunch","createPunch","viewOtherPunch","viewPunchApprove","createPunchApprove","updatePunchApprove","viewAccount","updateAccount","viewRating","createRating","updateRating","manageRating"]},"web_access_token":"GwzcwQPxiTG2B3PUDaCrV_Wl4I70m3do"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u89d2\u8272\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0}', FALSE, '2025-08-29 17:44:22') RETURNING "id"

[+] Explain