Performance Profiling

Total processing time: 54 ms; Peak memory: 12.137 MB. Show Profiling Timeline

总计10条数据

Time	Duration	Category	Info

15:54:55.239	5.6 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:54:55.245	3.0 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=5388
15:54:55.251	1.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5388
15:54:55.256	1.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_auth_item_child"
15:54:55.254	1.3 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"='5388') AND ("b"."type"=1)
15:54:55.260	1.2 ms	yii\db\Command::query	INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (403, 'a57be577deb434', 5388, 5, 'vue/purchase-contract/get-filter-cost', '{"web_access_token":"8xFoGs9_Un8l7vF7aN40sW81DgThk0xW"}', '{"code":403,"data":null,"status":0,"msg":[{"name":"error","success":"","error":"\u60a8\u6ca1\u6709\u6267\u884c\u6b64\u64cd\u4f5c\u7684\u6743\u9650","trace":{"name":"Forbidden","message":"\u60a8\u6ca1\u6709\u6267\u884c\u6b64\u64cd\u4f5c\u7684\u6743\u9650","code":0,"status":403,"type":"yii\\web\\ForbiddenHttpException"}}]}', TRUE, '2025-08-11 15:54:55') RETURNING "id"
15:54:55.258	1.1 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'))
15:54:55.256	0.4 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"='5388') AND ("b"."type"=2)
15:54:55.260	0.2 ms	yii\db\Command::query	SELECT "department_id", "department_position_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5388
15:54:55.258	0.2 ms	yii\db\Command::query	SELECT "item_name" FROM "a57be577deb434"."tbl_auth_assignments" WHERE "user_id"='5388'