Performance Profiling

Total processing time: 90 ms; Peak memory: 4.011 MB. Show Profiling Timeline

总计10条数据

Time	Duration	Category	Info

12:15:38.314	6.6 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
12:15:38.321	3.3 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=5016
12:15:38.328	3.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"='5016') AND ("b"."type"=1)
12:15:38.335	2.7 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', 'viewSalesRepScore', 'viewContactAnalysis', 'viewPurchaseAnalysis', 'viewReimbursementAnalysis', 'viewApproveAnalysis', 'viewSchedule', 'createSchedule', 'updateSchedule', 'deleteSchedule', 'viewSource', 'createSource', 'viewCalendarMng', 'createCalendarMng', 'updateCalendarMng', 'deleteCalendarMng', 'viewTask', 'createTask', 'updateTask', 'viewOtherTask', 'viewClient', 'viewOperation', 'viewOtherOperation', 'viewWorkLog', 'createWorkLog', 'updateWorkLog', 'viewProject', 'viewCase', 'viewTicket', 'viewSalesOrder', 'viewSalesContract', 'serviceProgress', 'viewReimbursement', 'createReimbursement', 'updateReimbursement', 'viewApprove', 'createApprove', 'updateApprove', 'viewDocument', 'viewSupplier', 'visitSupplier', 'viewPurchaseContract', 'viewProduct', 'viewService', 'viewPunch', 'createPunch', 'viewPunchApprove', 'createPunchApprove', 'updatePunchApprove', 'viewRating', 'viewStatisticsChart', 'deletePunchApprove', 'viewContactInfo', 'importClient', 'exportClient', 'updateClient', 'deleteClient', 'createPurchaseContract', 'updateProject', 'deleteProject', 'exportProject', 'updateSupplier', 'deleteSupplier', 'exportSupplier', 'updateSalesOrder', 'deleteSalesOrder', 'exportSalesOrder', 'updateProduct', 'deleteProduct', 'exportProduct', 'viewClientContact', 'updateClientContact', 'deleteClientContact', 'exportClientContact', 'viewSupplierContact', 'updateSupplierContact', 'deleteSupplierContact', 'exportSupplierContact', 'viewSalesLog', 'updateSalesLog', 'deleteSalesLog', 'exportSalesLog', 'exportPreSales', 'exportImplement', 'updateSalesContract', 'deleteSalesContract', 'exportSalesContract', 'updatePurchaseContract', 'deletePurchaseContract', 'exportPurchaseContract', 'viewCallback', 'updateCallback', 'deleteCallback', 'exportCallback', 'viewAccount', 'updateAccount', 'deleteAccount', 'exportAccount', 'createAccount', 'changeAccountPassword', 'approveAccount', 'manageSetting', 'Guest', 'viewTaxManagement', 'verifyInvoice', 'settleInvoice', 'viewEngineerLog', 'updateEngineerLog', 'deleteEngineerLog', 'makeProduct', 'createOperation', 'updateOperation', 'deleteOperation', 'distributeCase', 'updateDocument', 'deleteDocument', 'updateClientDocument', 'deleteClientDocument', 'createService', 'updateService', 'deleteService', 'updateOthersProject', 'createClientDocument', 'createProjectDocument', 'updateProjectDocument', 'deleteProjectDocument', 'createCaseDocument', 'updateCaseDocument', 'deleteCaseDocument', 'createCase', 'updateCase', 'deleteCase', 'closeCase', 'suspendCase', 'deleteReimbursement', 'updateTicket', 'lockClient', 'deleteTicket', 'createSupplierDocument', 'updateSupplierDocument', 'deleteSupplierDocument', 'changeProjectStatus3', 'changeProjectStatus4', 'changeProjectStatus5', 'updateSource', 'deleteSource', 'distributeSource', 'deleteApprove', 'viewErp', 'viewErpPurchaseOrder', 'updateErpPurchaseOrder', 'viewErpPurchaseInbound', 'createErpPurchaseInbound', 'updateErpPurchaseInbound', 'deleteErpPurchaseInbound', 'viewErpPurchaseReturn', 'createErpPurchaseReturn', 'updateErpPurchaseReturn', 'deleteErpPurchaseReturn', 'viewErpInventoryProduct', 'viewErpInventoryLost', 'createErpInventoryLost', 'updateErpInventoryLost', 'deleteErpInventoryLost', 'viewErpInventoryBuild', 'createErpInventoryBuild', 'updateErpInventoryBuild', 'deleteErpInventoryBuild', 'viewErpSalesOrder', 'updateErpSalesOrder', 'viewErpSalesOutbound', 'createErpSalesOutbound', 'updateErpSalesOutbound', 'deleteErpSalesOutbound', 'viewErpSalesReturn', 'createErpSalesReturn', 'updateErpSalesReturn', 'deleteErpSalesReturn', 'viewErpPurchaseGift', 'createErpPurchaseGift', 'updateErpPurchaseGift', 'deleteErpPurchaseGift', 'viewErpSalesGift', 'createErpSalesGift', 'updateErpSalesGift', 'deleteErpSalesGift', 'viewErpPaymentTicket', 'createErpPaymentTicket', 'updateErpPaymentTicket', 'deleteErpPaymentTicket', 'viewErpCollectTicket', 'createErpCollectTicket', 'updateErpCollectTicket', 'deleteErpCollectTicket', 'viewErpCostTicket', 'createErpCostTicket', 'updateErpCostTicket', 'deleteErpCostTicket', 'viewErpOtherIncomeTicket', 'createErpOtherIncomeTicket', 'updateErpOtherIncomeTicket', 'deleteErpOtherIncomeTicket', 'viewErpCostConvertTicket', 'createErpCostConvertTicket', 'updateErpCostConvertTicket', 'deleteErpCostConvertTicket', 'viewErpBankTransferTicket', 'createErpBankTransferTicket', 'updateErpBankTransferTicket', 'deleteErpBankTransferTicket', 'viewErpCashCostTicket', 'createErpCashCostTicket', 'updateErpCashCostTicket', 'deleteErpCashCostTicket', 'viewErpAdvancePaymentTicket', 'createErpAdvancePaymentTicket', 'updateErpAdvancePaymentTicket', 'deleteErpAdvancePaymentTicket', 'viewErpOtherPaymentTicket', 'createErpOtherPaymentTicket', 'updateErpOtherPaymentTicket', 'deleteErpOtherPaymentTicket', 'viewErpOtherCollectTicket', 'createErpOtherCollectTicket', 'updateErpOtherCollectTicket', 'deleteErpOtherCollectTicket', 'viewErpPurchaseCost', 'createErpPurchaseCost', 'updateErpPurchaseCost', 'deleteErpPurchaseCost', 'viewErpSocialInsurance', 'createErpSocialInsurance', 'updateErpSocialInsurance', 'deleteErpSocialInsurance', 'viewErpProvidentFund', 'createErpProvidentFund', 'updateErpProvidentFund', 'deleteErpProvidentFund', 'viewErpPersonalTax', 'createErpPersonalTax', 'updateErpPersonalTax', 'deleteErpPersonalTax', 'viewErpWagePrize', 'createErpWagePrize', 'updateErpWagePrize', 'deleteErpWagePrize', 'viewErpWageTicket', 'createErpWageTicket', 'updateErpWageTicket', 'deleteErpWageTicket', 'viewErpAsset'))
12:15:38.325	2.1 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5016
12:15:38.333	1.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_auth_item_child"
12:15:38.342	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 (200, 'a57be577deb434', 5016, 5, 'vue/dashboard/get-create-menu', '{"web_access_token":"K2GiMFHHCmO3sg3MkIFTzY3xCRdOdse6"}', '{"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":10,"icon":"icon-kehuxinxi","title":"\u5ba2\u6237\u4fe1\u606f","appName":"client","extra":0},{"id":19,"icon":"icon-gongzuorizhi","title":"\u5de5\u4f5c\u65e5\u5fd7","appName":"worklog","extra":0},{"id":1,"icon":"icon-shangjixinxi","title":"\u5546\u673a\u4fe1\u606f","appName":"project","extra":0},{"id":21,"icon":"icon-xiaoshouxiansuo","title":"\u9500\u552e\u7ebf\u7d22","appName":"source","extra":0,"can_create_contact":true},{"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":18,"icon":"icon-gongdanguanli","title":"CASE","appName":"caseManagement","extra":0},{"id":20,"icon":"icon-feiyongbaoxiao","title":"\u8d39\u7528\u62a5\u9500","appName":"reimbursementManagement","extra":0},{"id":23,"icon":"icon-xiaoshoujilu","title":"\u9500\u552e\u8bb0\u5f55","appName":"salesOrder","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-04 12:15:38') RETURNING "id"
12:15:38.332	0.7 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"='5016') AND ("b"."type"=2)
12:15:38.339	0.2 ms	yii\db\Command::query	SELECT "department_id", "department_position_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5016
12:15:38.335	0.2 ms	yii\db\Command::query	SELECT "item_name" FROM "a57be577deb434"."tbl_auth_assignments" WHERE "user_id"='5016'