Performance Profiling

Total processing time: 236 ms; Peak memory: 2.768 MB. Show Profiling Timeline

总计10条数据

Time	Duration	Category	Info

19:05:23.041	4.0 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252
19:05:23.033	3.1 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
19:05:23.037	2.9 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=5252
19:05:23.048	2.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_auth_item_child"
19:05:23.056	2.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', 5252, 5, 'vue/dashboard/get-create-menu', '{"web_access_token":"HcPbdczjiT4Sp46OV0lNGsvc5AuI1uUw"}', '{"code":2000,"result":[{"id":9,"icon":"icon-daiban","title":"\u5f85\u529e\u4e8b\u9879","appName":"schedule","extra":0},{"id":24,"icon":"icon-richeng","title":"\u65e5\u7a0b\u7ba1\u7406","appName":"calendar","extra":0},[],{"id":19,"icon":"icon-gongzuorizhi","title":"\u5de5\u4f5c\u65e5\u5fd7","appName":"worklog","extra":0},[],[],{"id":1001,"icon":"icon-kehulianxiren","title":"\u5ba2\u6237\u8054\u7cfb\u4eba","appName":"clientContact","extra":0},{"id":1002,"icon":"icon-gongyingshanglianxiren","title":"\u4f9b\u5e94\u5546\u8054\u7cfb\u4eba","appName":"supplierContact","extra":0},{"id":101,"icon":"icon-xiangmuguanli","title":"\u9879\u76ee\u6e05\u5355","appName":"task","extra":0},[],{"id":20,"icon":"icon-feiyongbaoxiao","title":"\u8d39\u7528\u62a5\u9500","appName":"reimbursementManagement","extra":0},{"id":37,"icon":"icon-shenpi","title":"\u5ba1\u6279\u7ba1\u7406","appName":"approveManagement","extra":0}],"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-08 19:05:23') RETURNING "id"
19:05:23.046	1.8 ms	yii\db\Command::query	SELECT "b".* FROM "a57be577deb434"."tbl_auth_assignments" "a", "a57be577deb434"."tbl_auth_items" "b" WHERE ("a"."item_name"="b"."name") AND ("a"."user_id"='5252') AND ("b"."type"=1)
19:05:23.052	1.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_auth_items" WHERE ("type"=2) AND ("name" IN ('viewSalesChart', 'viewPreSalesChart', 'viewImplementChart', 'viewServicePlan', 'viewCalendar', 'viewClientAnalysis', 'viewClientMap', 'viewFootPrint', 'viewOtherFootPrint', 'viewContactAnalysis', 'viewReimbursementAnalysis', 'viewApproveAnalysis', 'viewSchedule', 'createSchedule', 'updateSchedule', 'deleteSchedule', 'viewCalendarMng', 'createCalendarMng', 'updateCalendarMng', 'deleteCalendarMng', 'viewTask', 'createTask', 'updateTask', 'deleteTask', 'viewClient', 'updateClientDocument', 'viewClientContact', 'createClientContact', 'updateClientContact', 'viewContactInfo', 'viewWorkLog', 'createWorkLog', 'updateWorkLog', 'viewProject', 'updateProject', 'viewCase', 'viewTicket', 'viewSalesOrder', 'viewSalesContract', 'updateSalesContract', 'serviceProgress', 'viewReimbursement', 'createReimbursement', 'updateReimbursement', 'deleteReimbursement', 'viewApprove', 'createApprove', 'updateApprove', 'viewDocument', 'createDocument', 'updateDocument', 'viewSupplier', 'visitSupplier', 'viewSupplierContact', 'createSupplierContact', 'updateSupplierContact', 'viewPurchaseContract', 'createPurchaseContract', 'updatePurchaseContract', 'viewProduct', 'viewService', 'viewPunch', 'createPunch', 'viewOtherPunch', 'viewPunchApprove', 'createPunchApprove', 'updatePunchApprove', 'viewRating', 'viewTaxManagement', 'verifyInvoice', 'settleInvoice', 'makeProduct', 'viewErp', 'viewErpOtherPaymentTicket', 'updateErpOtherPaymentTicket', 'createErpOtherPaymentTicket'))
19:05:23.048	0.6 ms	yii\db\Command::query	SELECT "b".* FROM "a57be577deb434"."tbl_auth_assignments" "a", "a57be577deb434"."tbl_auth_items" "b" WHERE ("a"."item_name"="b"."name") AND ("a"."user_id"='5252') AND ("b"."type"=2)
19:05:23.055	0.3 ms	yii\db\Command::query	SELECT "department_id", "department_position_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5252
19:05:23.052	0.2 ms	yii\db\Command::query	SELECT "item_name" FROM "a57be577deb434"."tbl_auth_assignments" WHERE "user_id"='5252'