Performance Profiling

Total processing time: 28 ms; Peak memory: 3.265 MB. Show Profiling Timeline

总计17条数据

Time	Duration	Category	Info

15:17:10.070	4.8 ms	yii\db\Command::execute	INSERT 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')
15:17:10.056	2.3 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=5252
15:17:10.054	1.9 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:17:10.060	1.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:17:10.068	1.1 ms	yii\db\Command::execute	INSERT 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')
15:17:10.077	1.1 ms	yii\db\Command::query	INSERT 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"
15:17:10.075	1.0 ms	yii\db\Command::query	SELECT "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"
15:17:10.066	0.9 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_auth_items" SET "updated_at"=1754896630 WHERE "name"='Engineer'
15:17:10.069	0.8 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_auth_item_child" WHERE "parent"='Engineer'
15:17:10.064	0.6 ms	yii\db\Command::query	SELECT "name" FROM "a57be577deb434"."tbl_auth_items" WHERE "name"='Engineer' LIMIT 2
15:17:10.059	0.5 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
15:17:10.063	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_auth_items" WHERE "id"='79'
15:17:10.065	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_auth_items" WHERE ("type"=1) AND ("display_name"='Engineer') AND ("id" != 79)
15:17:10.066	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_auth_items" WHERE ("type"=1) AND ("display_name"='Engineer') AND ("id" != 79)
15:17:10.065	0.2 ms	yii\db\Command::query	SELECT "name" FROM "a57be577deb434"."tbl_auth_items" WHERE "display_name"='工程师' LIMIT 2
15:17:10.065	0.2 ms	yii\db\Command::query	SELECT "name" FROM "a57be577deb434"."tbl_auth_items" WHERE "name"='Engineer' LIMIT 2
15:17:10.066	0.2 ms	yii\db\Command::query	SELECT "name" FROM "a57be577deb434"."tbl_auth_items" WHERE "display_name"='工程师' LIMIT 2