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

Database Queries

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

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

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

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

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

[+] Explain
15:17:29.9930.2 msSELECTSELECT "name" FROM "a57be577deb434"."tbl_auth_items" WHERE "display_name"='财务专员' LIMIT 2

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

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

[+] Explain
15:17:29.9940.2 msSELECTSELECT "name" FROM "a57be577deb434"."tbl_auth_items" WHERE "display_name"='财务专员' LIMIT 2

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

[+] Explain
15:17:29.9951.9 msUPDATEUPDATE "a57be577deb434"."tbl_auth_items" SET "updated_at"=1754896649 WHERE "name"='Treasurer'

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

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

[+] Explain
15:17:30.0018.6 msINSERTINSERT INTO "a57be577deb434"."tbl_auth_item_child" ("parent", "child") VALUES ('Treasurer', 'viewSalesChart'), ('Treasurer', 'viewPreSalesChart'), ('Treasurer', 'viewImplementChart'), ('Treasurer', 'viewServicePlan'), ('Treasurer', 'viewCalendar'), ('Treasurer', 'viewClientAnalysis'), ('Treasurer', 'viewClientMap'), ('Treasurer', 'viewFootPrint'), ('Treasurer', 'viewReimbursementAnalysis'), ('Treasurer', 'viewApproveAnalysis'), ('Treasurer', 'viewSchedule'), ('Treasurer', 'createSchedule'), ('Treasurer', 'updateSchedule'), ('Treasurer', 'viewSource'), ('Treasurer', 'createSource'), ('Treasurer', 'updateSource'), ('Treasurer', 'distributeSource'), ('Treasurer', 'viewCalendarMng'), ('Treasurer', 'createCalendarMng'), ('Treasurer', 'updateCalendarMng'), ('Treasurer', 'viewTask'), ('Treasurer', 'createTask'), ('Treasurer', 'updateTask'), ('Treasurer', 'viewClient'), ('Treasurer', 'createClient'), ('Treasurer', 'updateClient'), ('Treasurer', 'createClientDocument'), ('Treasurer', 'updateClientDocument'), ('Treasurer', 'viewOperation'), ('Treasurer', 'createOperation'), ('Treasurer', 'updateOperation'), ('Treasurer', 'viewOtherOperation'), ('Treasurer', 'viewClientContact'), ('Treasurer', 'createClientContact'), ('Treasurer', 'updateClientContact'), ('Treasurer', 'viewContactInfo'), ('Treasurer', 'viewWorkLog'), ('Treasurer', 'createWorkLog'), ('Treasurer', 'updateWorkLog'), ('Treasurer', 'viewProject'), ('Treasurer', 'createProjectDocument'), ('Treasurer', 'updateProjectDocument'), ('Treasurer', 'viewCase'), ('Treasurer', 'createCase'), ('Treasurer', 'updateCase'), ('Treasurer', 'distributeCase'), ('Treasurer', 'closeCase'), ('Treasurer', 'suspendCase'), ('Treasurer', 'viewTicket'), ('Treasurer', 'createCaseDocument'), ('Treasurer', 'updateCaseDocument'), ('Treasurer', 'viewSalesOrder'), ('Treasurer', 'createSalesOrder'), ('Treasurer', 'updateSalesOrder'), ('Treasurer', 'viewSalesContract'), ('Treasurer', 'createSalesContract'), ('Treasurer', 'updateSalesContract'), ('Treasurer', 'serviceProgress'), ('Treasurer', 'viewReimbursement'), ('Treasurer', 'createReimbursement'), ('Treasurer', 'updateReimbursement'), ('Treasurer', 'viewApprove'), ('Treasurer', 'createApprove'), ('Treasurer', 'updateApprove'), ('Treasurer', 'viewDocument'), ('Treasurer', 'createDocument'), ('Treasurer', 'updateDocument'), ('Treasurer', 'viewSupplier'), ('Treasurer', 'visitSupplier'), ('Treasurer', 'createSupplier'), ('Treasurer', 'updateSupplier'), ('Treasurer', 'createSupplierDocument'), ('Treasurer', 'updateSupplierDocument'), ('Treasurer', 'viewSupplierContact'), ('Treasurer', 'createSupplierContact'), ('Treasurer', 'updateSupplierContact'), ('Treasurer', 'viewCostContract'), ('Treasurer', 'createCostContract'), ('Treasurer', 'updateCostContract'), ('Treasurer', 'deleteCostContract'), ('Treasurer', 'viewProduct'), ('Treasurer', 'createProduct'), ('Treasurer', 'updateProduct'), ('Treasurer', 'manageProductCategory'), ('Treasurer', 'viewService'), ('Treasurer', 'createService'), ('Treasurer', 'updateService'), ('Treasurer', 'viewPunch'), ('Treasurer', 'createPunch'), ('Treasurer', 'viewPunchApprove'), ('Treasurer', 'createPunchApprove'), ('Treasurer', 'updatePunchApprove'), ('Treasurer', 'viewRating'), ('Treasurer', 'createRating'), ('Treasurer', 'updateRating'), ('Treasurer', 'manageRating'), ('Treasurer', 'viewErpPurchaseOrder'), ('Treasurer', 'viewErpPurchaseInbound'), ('Treasurer', 'viewErpPurchaseReturn'), ('Treasurer', 'viewErpPurchaseGift'), ('Treasurer', 'viewErpInventoryLost'), ('Treasurer', 'viewErpInventoryBuild'), ('Treasurer', 'viewErpSalesOrder'), ('Treasurer', 'viewErpSalesOutbound'), ('Treasurer', 'viewErpSalesReturn'), ('Treasurer', 'viewErpSalesGift'), ('Treasurer', 'viewErpPaymentTicket'), ('Treasurer', 'updateErpPaymentTicket'), ('Treasurer', 'createErpPaymentTicket'), ('Treasurer', 'deleteErpPaymentTicket'), ('Treasurer', 'viewErpCollectTicket'), ('Treasurer', 'updateErpCollectTicket'), ('Treasurer', 'createErpCollectTicket'), ('Treasurer', 'deleteErpCollectTicket'), ('Treasurer', 'viewErpCostTicket'), ('Treasurer', 'updateErpCostTicket'), ('Treasurer', 'createErpCostTicket'), ('Treasurer', 'deleteErpCostTicket'), ('Treasurer', 'viewErpOtherIncomeTicket'), ('Treasurer', 'updateErpOtherIncomeTicket'), ('Treasurer', 'createErpOtherIncomeTicket'), ('Treasurer', 'deleteErpOtherIncomeTicket'), ('Treasurer', 'viewErpCostConvertTicket'), ('Treasurer', 'updateErpCostConvertTicket'), ('Treasurer', 'createErpCostConvertTicket'), ('Treasurer', 'deleteErpCostConvertTicket'), ('Treasurer', 'viewErpBankTransferTicket'), ('Treasurer', 'updateErpBankTransferTicket'), ('Treasurer', 'createErpBankTransferTicket'), ('Treasurer', 'deleteErpBankTransferTicket'), ('Treasurer', 'viewErpCashCostTicket'), ('Treasurer', 'updateErpCashCostTicket'), ('Treasurer', 'createErpCashCostTicket'), ('Treasurer', 'deleteErpCashCostTicket'), ('Treasurer', 'viewErpAdvancePaymentTicket'), ('Treasurer', 'updateErpAdvancePaymentTicket'), ('Treasurer', 'createErpAdvancePaymentTicket'), ('Treasurer', 'deleteErpAdvancePaymentTicket'), ('Treasurer', 'viewErpOtherPaymentTicket'), ('Treasurer', 'updateErpOtherPaymentTicket'), ('Treasurer', 'createErpOtherPaymentTicket'), ('Treasurer', 'deleteErpOtherPaymentTicket'), ('Treasurer', 'viewErpOtherCollectTicket'), ('Treasurer', 'updateErpOtherCollectTicket'), ('Treasurer', 'createErpOtherCollectTicket'), ('Treasurer', 'deleteErpOtherCollectTicket'), ('Treasurer', 'viewErpPurchaseCost'), ('Treasurer', 'viewErpSocialInsurance'), ('Treasurer', 'updateErpSocialInsurance'), ('Treasurer', 'createErpSocialInsurance'), ('Treasurer', 'deleteErpSocialInsurance'), ('Treasurer', 'viewErpProvidentFund'), ('Treasurer', 'updateErpProvidentFund'), ('Treasurer', 'createErpProvidentFund'), ('Treasurer', 'deleteErpProvidentFund'), ('Treasurer', 'viewErpPersonalTax'), ('Treasurer', 'updateErpPersonalTax'), ('Treasurer', 'createErpPersonalTax'), ('Treasurer', 'deleteErpPersonalTax'), ('Treasurer', 'viewErpWagePrize'), ('Treasurer', 'updateErpWagePrize'), ('Treasurer', 'createErpWagePrize'), ('Treasurer', 'deleteErpWagePrize'), ('Treasurer', 'viewErpWageTicket'), ('Treasurer', 'updateErpWageTicket'), ('Treasurer', 'createErpWageTicket'), ('Treasurer', 'deleteErpWageTicket'), ('Treasurer', 'viewErpAsset')

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

[+] Explain
15:17:30.0111.2 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":"283","permissions":["viewSalesChart","viewPreSalesChart","viewImplementChart","viewServicePlan","viewCalendar","viewClientAnalysis","viewClientMap","viewFootPrint","viewReimbursementAnalysis","viewApproveAnalysis","viewSchedule","createSchedule","updateSchedule","viewSource","createSource","updateSource","distributeSource","viewCalendarMng","createCalendarMng","updateCalendarMng","viewTask","createTask","updateTask","viewClient","createClient","updateClient","createClientDocument","updateClientDocument","viewOperation","createOperation","updateOperation","viewOtherOperation","viewClientContact","createClientContact","updateClientContact","viewContactInfo","viewWorkLog","createWorkLog","updateWorkLog","viewProject","createProjectDocument","updateProjectDocument","viewCase","createCase","updateCase","distributeCase","closeCase","suspendCase","viewTicket","createCaseDocument","updateCaseDocument","viewSalesOrder","createSalesOrder","updateSalesOrder","viewSalesContract","createSalesContract","updateSalesContract","serviceProgress","viewReimbursement","createReimbursement","updateReimbursement","viewApprove","createApprove","updateApprove","viewDocument","createDocument","updateDocument","viewSupplier","visitSupplier","createSupplier","updateSupplier","createSupplierDocument","updateSupplierDocument","viewSupplierContact","createSupplierContact","updateSupplierContact","viewCostContract","createCostContract","updateCostContract","deleteCostContract","viewProduct","createProduct","updateProduct","manageProductCategory","viewService","createService","updateService","viewPunch","createPunch","viewPunchApprove","createPunchApprove","updatePunchApprove","viewRating","createRating","updateRating","manageRating","viewErpPurchaseOrder","viewErpPurchaseInbound","viewErpPurchaseReturn","viewErpPurchaseGift","viewErpInventoryLost","viewErpInventoryBuild","viewErpSalesOrder","viewErpSalesOutbound","viewErpSalesReturn","viewErpSalesGift","viewErpPaymentTicket","updateErpPaymentTicket","createErpPaymentTicket","deleteErpPaymentTicket","viewErpCollectTicket","updateErpCollectTicket","createErpCollectTicket","deleteErpCollectTicket","viewErpCostTicket","updateErpCostTicket","createErpCostTicket","deleteErpCostTicket","viewErpOtherIncomeTicket","updateErpOtherIncomeTicket","createErpOtherIncomeTicket","deleteErpOtherIncomeTicket","viewErpCostConvertTicket","updateErpCostConvertTicket","createErpCostConvertTicket","deleteErpCostConvertTicket","viewErpBankTransferTicket","updateErpBankTransferTicket","createErpBankTransferTicket","deleteErpBankTransferTicket","viewErpCashCostTicket","updateErpCashCostTicket","createErpCashCostTicket","deleteErpCashCostTicket","viewErpAdvancePaymentTicket","updateErpAdvancePaymentTicket","createErpAdvancePaymentTicket","deleteErpAdvancePaymentTicket","viewErpOtherPaymentTicket","updateErpOtherPaymentTicket","createErpOtherPaymentTicket","deleteErpOtherPaymentTicket","viewErpOtherCollectTicket","updateErpOtherCollectTicket","createErpOtherCollectTicket","deleteErpOtherCollectTicket","viewErpPurchaseCost","viewErpSocialInsurance","updateErpSocialInsurance","createErpSocialInsurance","deleteErpSocialInsurance","viewErpProvidentFund","updateErpProvidentFund","createErpProvidentFund","deleteErpProvidentFund","viewErpPersonalTax","updateErpPersonalTax","createErpPersonalTax","deleteErpPersonalTax","viewErpWagePrize","updateErpWagePrize","createErpWagePrize","deleteErpWagePrize","viewErpWageTicket","updateErpWageTicket","createErpWageTicket","deleteErpWageTicket","viewErpAsset"]},"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:30') RETURNING "id"

[+] Explain