Performance Profiling

Total processing time: 47 ms; Peak memory: 12.139 MB. Show Profiling Timeline

总计10条数据

Time	Duration	Category	Info

03:27:13.474	3.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"='1001') AND ("b"."type"=1)
03:27:13.479	3.1 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_auth_item_child"
03:27:13.483	2.5 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', 'viewSchedule', 'createSchedule', 'updateSchedule', 'viewSource', 'viewCalendarMng', 'createCalendarMng', 'updateCalendarMng', 'deleteCalendarMng', 'viewTask', 'createTask', 'updateTask', 'deleteTask', 'viewClient', 'createClient', 'updateClient', 'transferClient', 'createClientDocument', 'updateClientDocument', 'viewClientContact', 'createClientContact', 'updateClientContact', 'viewContactInfo', 'viewWorkLog', 'createWorkLog', 'updateWorkLog', 'viewProject', 'createProject', 'updateProject', 'createProjectDocument', 'updateProjectDocument', 'viewCase', 'viewTicket', 'createCaseDocument', 'updateCaseDocument', 'viewSalesOrder', 'viewSalesContract', 'serviceProgress', 'viewReimbursement', 'createReimbursement', 'updateReimbursement', 'deleteReimbursement', 'viewApprove', 'createApprove', 'updateApprove', 'viewDocument', 'createDocument', 'updateDocument', 'viewSupplier', 'visitSupplier', 'createSupplier', 'updateSupplier', 'viewSupplierContact', 'createSupplierContact', 'updateSupplierContact', 'viewPurchaseContract', 'viewProduct', 'viewPunch', 'createPunch', 'viewPunchApprove', 'createPunchApprove', 'updatePunchApprove', 'viewRating', 'changeProjectStatus3', 'changeProjectStatus4', 'changeProjectStatus5', 'viewReimbursementAnalysis', 'viewApproveAnalysis', 'viewStatisticsChart', 'deletePunchApprove', 'importClient', 'exportClient', 'deleteClient', 'viewPurchaseAnalysis', 'createPurchaseContract', 'deleteProject', 'exportProject', 'deleteSupplier', 'exportSupplier', 'updateSalesOrder', 'deleteSalesOrder', 'exportSalesOrder', 'updateProduct', 'deleteProduct', 'exportProduct', 'deleteClientContact', 'exportClientContact', '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', 'deleteSchedule', 'viewOperation', 'createOperation', 'updateOperation', 'deleteOperation', 'viewOtherOperation', 'distributeCase', 'deleteDocument', 'deleteClientDocument', 'viewService', 'createService', 'updateService', 'deleteService', 'updateOthersProject', 'deleteProjectDocument', 'deleteCaseDocument', 'createCase', 'updateCase', 'deleteCase', 'closeCase', 'suspendCase', 'viewSalesRepScore', 'updateTicket', 'lockClient', 'deleteTicket', 'createSupplierDocument', 'updateSupplierDocument', 'deleteSupplierDocument', 'viewContactAnalysis', 'createSource', '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', 'distributeContact', 'createSalesOrder', 'createSalesContract', 'createProduct', 'manageProductCategory', 'createRating', 'updateRating', 'manageRating'))
03:27:13.468	2.3 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
03:27:13.466	1.8 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
03:27:13.471	1.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
03:27:13.487	1.5 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', 1001, 5, 'vue/case/pre-sales-service-project-list', '[]', '{"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-10 03:27:13') RETURNING "id"
03:27:13.478	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"='1001') AND ("b"."type"=2)
03:27:13.486	0.3 ms	yii\db\Command::query	SELECT "department_id", "department_position_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
03:27:13.482	0.3 ms	yii\db\Command::query	SELECT "item_name" FROM "a57be577deb434"."tbl_auth_assignments" WHERE "user_id"='1001'