ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
689998f60cd1a: POST https://beta.jinchangxiao.com/vue/setting/save-edit-role at 2025-08-11 03:17:10 pm by 124.64.23.198

Database Queries

总计16条数据
TimeDurationTypeQuery
  
15:17:10.0562.3 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=5252

[+] Explain
15:17:10.0590.5 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

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

[+] Explain
15:17:10.0630.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_auth_items" WHERE "id"='79'

[+] Explain
15:17:10.0640.6 msSELECTSELECT "name" FROM "a57be577deb434"."tbl_auth_items" WHERE "name"='Engineer' LIMIT 2

[+] Explain
15:17:10.0650.2 msSELECTSELECT "name" FROM "a57be577deb434"."tbl_auth_items" WHERE "display_name"='工程师' LIMIT 2

[+] Explain
15:17:10.0650.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_auth_items" WHERE ("type"=1) AND ("display_name"='Engineer') AND ("id" != 79)

[+] Explain
15:17:10.0650.2 msSELECTSELECT "name" FROM "a57be577deb434"."tbl_auth_items" WHERE "name"='Engineer' LIMIT 2

[+] Explain
15:17:10.0660.2 msSELECTSELECT "name" FROM "a57be577deb434"."tbl_auth_items" WHERE "display_name"='工程师' LIMIT 2

[+] Explain
15:17:10.0660.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_auth_items" WHERE ("type"=1) AND ("display_name"='Engineer') AND ("id" != 79)

[+] Explain
15:17:10.0660.9 msUPDATEUPDATE "a57be577deb434"."tbl_auth_items" SET "updated_at"=1754896630 WHERE "name"='Engineer'

[+] Explain
15:17:10.0681.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', 79, 'a:0:{}', '', 1001, '124.64.23.198')

[+] Explain
15:17:10.0690.8 msDELETEDELETE FROM "a57be577deb434"."tbl_auth_item_child" WHERE "parent"='Engineer'

[+] Explain
15:17:10.0704.8 msINSERTINSERT INTO "a57be577deb434"."tbl_auth_item_child" ("parent", "child") VALUES ('Engineer', 'viewSalesChart'), ('Engineer', 'viewPreSalesChart'), ('Engineer', 'viewImplementChart'), ('Engineer', 'viewServicePlan'), ('Engineer', 'viewCalendar'), ('Engineer', 'viewClientAnalysis'), ('Engineer', 'viewClientMap'), ('Engineer', 'viewFootPrint'), ('Engineer', 'viewReimbursementAnalysis'), ('Engineer', 'viewApproveAnalysis'), ('Engineer', 'viewSchedule'), ('Engineer', 'createSchedule'), ('Engineer', 'updateSchedule'), ('Engineer', 'viewCalendarMng'), ('Engineer', 'createCalendarMng'), ('Engineer', 'updateCalendarMng'), ('Engineer', 'deleteCalendarMng'), ('Engineer', 'viewTask'), ('Engineer', 'createTask'), ('Engineer', 'updateTask'), ('Engineer', 'deleteTask'), ('Engineer', 'viewOtherTask'), ('Engineer', 'viewClient'), ('Engineer', 'createClientDocument'), ('Engineer', 'updateClientDocument'), ('Engineer', 'viewClientContact'), ('Engineer', 'createClientContact'), ('Engineer', 'updateClientContact'), ('Engineer', 'viewContactInfo'), ('Engineer', 'viewWorkLog'), ('Engineer', 'createWorkLog'), ('Engineer', 'updateWorkLog'), ('Engineer', 'viewProject'), ('Engineer', 'createProjectDocument'), ('Engineer', 'updateProjectDocument'), ('Engineer', 'viewCase'), ('Engineer', 'viewTicket'), ('Engineer', 'createTicket'), ('Engineer', 'updateTicket'), ('Engineer', 'createCaseDocument'), ('Engineer', 'updateCaseDocument'), ('Engineer', 'viewSalesOrder'), ('Engineer', 'viewSalesContract'), ('Engineer', 'serviceProgress'), ('Engineer', 'viewReimbursement'), ('Engineer', 'createReimbursement'), ('Engineer', 'updateReimbursement'), ('Engineer', 'deleteReimbursement'), ('Engineer', 'viewApprove'), ('Engineer', 'createApprove'), ('Engineer', 'updateApprove'), ('Engineer', 'viewDocument'), ('Engineer', 'createDocument'), ('Engineer', 'updateDocument'), ('Engineer', 'viewSupplier'), ('Engineer', 'visitSupplier'), ('Engineer', 'createSupplier'), ('Engineer', 'updateSupplier'), ('Engineer', 'viewSupplierContact'), ('Engineer', 'createSupplierContact'), ('Engineer', 'updateSupplierContact'), ('Engineer', 'viewPurchaseContract'), ('Engineer', 'viewCostContract'), ('Engineer', 'createCostContract'), ('Engineer', 'updateCostContract'), ('Engineer', 'viewProduct'), ('Engineer', 'viewService'), ('Engineer', 'viewPunch'), ('Engineer', 'createPunch'), ('Engineer', 'viewPunchApprove'), ('Engineer', 'createPunchApprove'), ('Engineer', 'updatePunchApprove'), ('Engineer', 'viewRating')

[+] Explain
15:17:10.0751.0 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"='Engineer') GROUP BY "u"."id"

[+] Explain
15:17:10.0771.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":"79","permissions":["viewSalesChart","viewPreSalesChart","viewImplementChart","viewServicePlan","viewCalendar","viewClientAnalysis","viewClientMap","viewFootPrint","viewReimbursementAnalysis","viewApproveAnalysis","viewSchedule","createSchedule","updateSchedule","viewCalendarMng","createCalendarMng","updateCalendarMng","deleteCalendarMng","viewTask","createTask","updateTask","deleteTask","viewOtherTask","viewClient","createClientDocument","updateClientDocument","viewClientContact","createClientContact","updateClientContact","viewContactInfo","viewWorkLog","createWorkLog","updateWorkLog","viewProject","createProjectDocument","updateProjectDocument","viewCase","viewTicket","createTicket","updateTicket","createCaseDocument","updateCaseDocument","viewSalesOrder","viewSalesContract","serviceProgress","viewReimbursement","createReimbursement","updateReimbursement","deleteReimbursement","viewApprove","createApprove","updateApprove","viewDocument","createDocument","updateDocument","viewSupplier","visitSupplier","createSupplier","updateSupplier","viewSupplierContact","createSupplierContact","updateSupplierContact","viewPurchaseContract","viewCostContract","createCostContract","updateCostContract","viewProduct","viewService","viewPunch","createPunch","viewPunchApprove","createPunchApprove","updatePunchApprove","viewRating"]},"web_access_token":"HcPbdczjiT4Sp46OV0lNGsvc5AuI1uUw"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u89d2\u8272\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0}', FALSE, '2025-08-11 15:17:10') RETURNING "id"

[+] Explain