Performance Profiling

Total processing time: 93 ms; Peak memory: 4.586 MB. Show Profiling Timeline

总计10条数据

Time	Duration	Category	Info

11:02:54.706	3.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_auth_item_child"
11:02:54.683	3.3 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "access_token"='aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b'
11:02:54.680	2.4 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
11:02:54.703	2.0 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)
11:02:54.687	1.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5295
11:02:54.713	1.5 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, 1141, 'v2/user/get-menu', '{"access_token":"aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b","device_type":"2","posttime":"1750820608","token":"6e89fdd5f4a15ba2080c7001c06d1332","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":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-06-25 11:02:54') RETURNING "id"
11:02:54.711	1.4 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', 'viewOperation', 'createOperation', 'updateOperation'))
11:02:54.705	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"='5295') AND ("b"."type"=2)
11:02:54.712	0.3 ms	yii\db\Command::query	SELECT "department_id", "department_position_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5295
11:02:54.710	0.2 ms	yii\db\Command::query	SELECT "item_name" FROM "a57be577deb434"."tbl_auth_assignments" WHERE "user_id"='5295'