Performance Profiling

Total processing time: 1,509 ms; Peak memory: 4.787 MB. Show Profiling Timeline

总计10条数据

Time	Duration	Category	Info

15:27:28.150	4.0 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "access_token"='tnwd0bCdPezg-JBOsRPBmnL0JfJg3LvK'
15:27:28.147	2.8 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:27:28.166	2.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_auth_item_child"
15:27:28.156	2.0 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5295
15:27:28.170	1.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', 'viewReimbursementAnalysis', 'viewApproveAnalysis', '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', 'changeProjectStatus3', 'changeProjectStatus4', 'changeProjectStatus5', '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', 'createPurchaseContract', 'updatePurchaseContract', 'deletePurchaseContract', 'viewCostContract', 'createCostContract', 'updateCostContract', 'deleteCostContract', 'viewProduct', 'viewPunch', 'createPunch', 'viewPunchApprove', 'createPunchApprove', 'updatePunchApprove', 'viewRating', 'viewErp', 'viewErpSalesOrder', 'viewErpSalesOutbound', 'viewErpSalesReturn', 'viewOperation', 'createOperation', 'updateOperation'))
15:27:28.173	1.6 ms	yii\db\Command::query	INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5295, 2, 1148, 'v2/user/get-menu', '{"access_token":"tnwd0bCdPezg-JBOsRPBmnL0JfJg3LvK","device_type":"2","posttime":"1755761280","token":"1a652af7d48d4d6678379c05781c4630","version_code":"1148"}', '{"code":200,"data":{"menu":[{"id":9,"title":"\u5f85\u529e\u4e8b\u9879","isShow":1},{"id":24,"title":"\u65e5\u7a0b\u7ba1\u7406","isShow":1},{"id":10,"title":"\u5ba2\u6237\u4fe1\u606f","isShow":1},{"id":19,"title":"\u5de5\u4f5c\u65e5\u5fd7","isShow":1},{"id":18,"title":"\u5de5\u5355\u7ba1\u7406","isShow":1},{"id":1,"title":"\u5546\u673a\u4fe1\u606f","isShow":1},{"id":999,"title":"\u9879\u76ee\u7ba1\u7406","isShow":1},{"id":7,"title":"\u9500\u552e\u5408\u540c","isShow":1},{"id":12,"title":"\u4f9b\u5e94\u5546","isShow":1},{"id":13,"title":"\u91c7\u8d2d\u5408\u540c","isShow":1},{"id":28,"title":"\u8bc4\u6d4b\u6295\u7968","isShow":1},{"id":27,"title":"\u901a\u8baf\u5f55","isShow":1},{"id":11,"title":"\u6587\u6863\u7ba1\u7406","isShow":1},{"id":20,"title":"\u8d39\u7528\u62a5\u9500","isShow":1},{"id":37,"title":"\u5ba1\u6279\u7ba1\u7406","isShow":1},{"id":16,"title":"\u8003\u52e4\u6253\u5361","isShow":1},{"id":10000,"title":"\u5ba2\u6237\u5730\u56fe","isShow":1},{"id":10001,"title":"\u8db3\u8ff9\u5730\u56fe","isShow":1}],"createMenu":[{"id":24,"title":"\u65e5\u7a0b\u7ba1\u7406","extra":0},{"id":20,"title":"\u8d39\u7528\u62a5\u9500","extra":0},{"id":10,"title":"\u5ba2\u6237\u4fe1\u606f","extra":0},{"id":12,"title":"\u4f9b\u5e94\u5546","extra":0},{"id":1,"title":"\u5546\u673a\u4fe1\u606f","extra":0},{"id":10002,"title":"\u5ba2\u6237\u8054\u7cfb\u4eba","extra":0},{"id":101,"title":"\u9879\u76ee\u6e05\u5355","extra":0},{"id":19,"title":"\u5de5\u4f5c\u65e5\u5fd7","extra":0},{"id":10003,"title":"\u4f9b\u5e94\u5546\u8054\u7cfb\u4eba","extra":0},{"id":9,"title":"\u5f85\u529e\u4e8b\u9879","extra":0},{"id":37,"title":"\u5ba1\u6279\u7ba1\u7406","extra":0}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-08-21 15:27:28') RETURNING "id"
15:27:28.164	1.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"='5295') AND ("b"."type"=1)
15:27:28.166	0.5 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"='5295') AND ("b"."type"=2)
15:27:28.172	0.3 ms	yii\db\Command::query	SELECT "department_id", "department_position_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5295
15:27:28.169	0.3 ms	yii\db\Command::query	SELECT "item_name" FROM "a57be577deb434"."tbl_auth_assignments" WHERE "user_id"='5295'