Performance Profiling

Total processing time: 45 ms; Peak memory: 4.389 MB. Show Profiling Timeline

总计10条数据

Time	Duration	Category	Info

10:22:45.474	6.5 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "access_token"='LaARkbjpq8ODkVzzYWTT4va5Qt3CsuSp'
10:22:45.492	4.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_auth_item_child"
10:22:45.470	3.3 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:22:45.490	1.9 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"='1017') AND ("b"."type"=1)
10:22:45.501	1.8 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', 1017, 2, 1141, 'v2/user/get-menu', '{"access_token":"LaARkbjpq8ODkVzzYWTT4va5Qt3CsuSp","device_type":"2","posttime":"1752200576","token":"8a25fbfdcdebca0705a0e67179c2a6cf","version_code":"1141"}', '{"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":12,"title":"\u4f9b\u5e94\u5546","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-07-11 10:22:45') RETURNING "id"
10:22:45.483	1.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1017
10:22:45.498	1.3 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', 'viewCalendarMng', 'createCalendarMng', 'updateCalendarMng', 'deleteCalendarMng', 'viewTask', 'createTask', 'updateTask', 'deleteTask', 'viewOtherTask', 'viewClient', 'createClientDocument', 'updateClientDocument', 'viewClientContact', 'createClientContact', 'updateClientContact', 'viewContactInfo', 'viewWorkLog', 'createWorkLog', 'updateWorkLog', 'viewProject', 'createProjectDocument', 'updateProjectDocument', 'viewCase', 'viewTicket', 'createTicket', 'updateTicket', 'createCaseDocument', 'updateCaseDocument', 'viewSalesOrder', 'viewSalesContract', 'serviceProgress', 'viewReimbursement', 'createReimbursement', 'updateReimbursement', 'deleteReimbursement', 'viewApprove', 'createApprove', 'updateApprove', 'viewDocument', 'createDocument', 'updateDocument', 'viewSupplier', 'visitSupplier', 'createSupplier', 'updateSupplier', 'viewSupplierContact', 'createSupplierContact', 'updateSupplierContact', 'viewPurchaseContract', 'viewProduct', 'viewService', 'viewPunch', 'createPunch', 'viewPunchApprove', 'createPunchApprove', 'updatePunchApprove', 'viewRating'))
10:22:45.492	0.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"='1017') AND ("b"."type"=2)
10:22:45.500	0.3 ms	yii\db\Command::query	SELECT "department_id", "department_position_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1017
10:22:45.497	0.2 ms	yii\db\Command::query	SELECT "item_name" FROM "a57be577deb434"."tbl_auth_assignments" WHERE "user_id"='1017'