Performance Profiling

Total processing time: 604 ms; Peak memory: 94.821 MB. Show Profiling Timeline

总计10条数据

Time	Duration	Category	Info

14:04:07.633	2.2 ms	yii\db\Command::query	SELECT * FROM "o6a13e2c574d5a"."tbl_auth_items" WHERE ("type"=2) AND ("name" IN ('Guest', 'viewSalesChart', 'viewPreSalesChart', 'viewImplementChart', 'viewServicePlan', 'viewCalendar', 'viewClientAnalysis', 'viewClientMap', 'viewFootPrint', 'viewSchedule', 'createSchedule', 'updateSchedule', 'viewSource', 'createSource', 'updateSource', 'viewCalendarMng', 'createCalendarMng', 'updateCalendarMng', 'viewTask', 'createTask', 'updateTask', 'viewClient', 'createClient', 'updateClient', 'createClientDocument', 'updateClientDocument', 'createProjectDocument', 'updateProjectDocument', 'createCaseDocument', 'updateCaseDocument', 'viewOperation', 'createOperation', 'updateOperation', 'distributeContact', 'viewOtherOperation', 'viewClientContact', 'createClientContact', 'updateClientContact', 'viewContactInfo', 'viewWorkLog', 'createWorkLog', 'updateWorkLog', 'viewProject', 'viewCase', 'createCase', 'updateCase', 'closeCase', 'suspendCase', 'distributeCase', 'viewTicket', 'viewSalesOrder', 'createSalesOrder', 'updateSalesOrder', 'viewSalesContract', 'createSalesContract', 'updateSalesContract', 'viewReimbursement', 'createReimbursement', 'updateReimbursement', 'viewApprove', 'createApprove', 'updateApprove', 'viewDocument', 'createDocument', 'updateDocument', 'viewSupplier', 'createSupplier', 'updateSupplier', 'viewSupplierContact', 'createSupplierContact', 'updateSupplierContact', 'viewPurchaseContract', 'createPurchaseContract', 'updatePurchaseContract', 'viewProduct', 'createProduct', 'updateProduct', 'manageProductCategory', 'viewService', 'createService', 'updateService', 'viewPunch', 'createPunch', 'viewRating', 'createRating', 'updateRating', 'manageRating', 'createSupplierDocument', 'updateSupplierDocument', 'viewPunchApprove', 'createPunchApprove', 'updatePunchApprove', 'visitSupplier', 'serviceProgress', 'viewReimbursementAnalysis', 'viewApproveAnalysis', 'viewProjectProduct', 'viewSaleContractProduct', 'viewErpSettle', 'saveErpSettle', 'viewErpPurchaseOrder', 'viewErpPurchaseInbound', 'viewErpPurchaseReturn', 'viewErpInventoryLost', 'viewErpInventoryBuild', 'viewErpInventoryDisassemble', 'viewErpSalesOrder', 'viewErpSalesOutbound', 'viewErpSalesReturn', 'viewErpInventoryOverflow', 'viewErpPurchaseGift', 'viewErpSalesGift', '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', 'viewErpSocialInsurance', 'createErpSocialInsurance', 'updateErpSocialInsurance', 'deleteErpSocialInsurance', 'viewErpProvidentFund', 'createErpProvidentFund', 'updateErpProvidentFund', 'deleteErpProvidentFund', 'viewErpPersonalTax', 'createErpPersonalTax', 'updateErpPersonalTax', 'deleteErpPersonalTax', 'viewErpWagePrize', 'createErpWagePrize', 'updateErpWagePrize', 'deleteErpWagePrize', 'viewErpWageTicket', 'createErpWageTicket', 'updateErpWageTicket', 'deleteErpWageTicket', 'viewErpProfitDistribute', 'createErpProfitDistribute', 'updateErpProfitDistribute', 'deleteErpProfitDistribute', 'viewErpAsset', 'viewErp'))
14:04:07.637	1.4 ms	yii\db\Command::query	INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (403, 'o6a13e2c574d5a', 5495, 5, 'vue/setting/get-edit-basic', '{"web_access_token":"fBwCmd7csXIYKc0xRKne9r8J7AW22Ivz"}', '{"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, '2026-06-12 14:04:07', 75671040) RETURNING "id"
14:04:07.631	1.2 ms	yii\db\Command::query	SELECT * FROM "o6a13e2c574d5a"."tbl_auth_item_child"
14:04:07.629	1.0 ms	yii\db\Command::query	SELECT "b".* FROM "o6a13e2c574d5a"."tbl_auth_assignments" "a", "o6a13e2c574d5a"."tbl_auth_items" "b" WHERE ("a"."item_name"="b"."name") AND ("a"."user_id"='5495') AND ("b"."type"=1)
14:04:07.620	0.9 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=5495
14:04:07.623	0.6 ms	yii\db\Command::query	SELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5495
14:04:07.630	0.5 ms	yii\db\Command::query	SELECT "b".* FROM "o6a13e2c574d5a"."tbl_auth_assignments" "a", "o6a13e2c574d5a"."tbl_auth_items" "b" WHERE ("a"."item_name"="b"."name") AND ("a"."user_id"='5495') AND ("b"."type"=2)
14:04:07.620	0.4 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:04:07.636	0.4 ms	yii\db\Command::query	SELECT "department_id", "department_position_id" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5495
14:04:07.632	0.3 ms	yii\db\Command::query	SELECT "item_name" FROM "o6a13e2c574d5a"."tbl_auth_assignments" WHERE "user_id"='5495'