685a9ad0100f2: POST https://beta.jinchangxiao.com/v2/user/get-menu at 2025-06-24 08:32:16 pm by 211.137.80.11
Database Queries
总计9条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 20:32:16.070 | 4.0 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='rpAaho7HBg3VJ1vNP7yVtm0Uw5j2xu-u' |
| 20:32:16.075 | 1.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 20:32:16.082 | 1.1 ms | SELECT | SELECT "b".* FROM "a57be577deb434"."tbl_auth_assignments" "a", "a57be577deb434"."tbl_auth_items" "b" WHERE ("a"."item_name"="b"."name") AND ("a"."user_id"='1000') AND ("b"."type"=1) |
| 20:32:16.084 | 0.6 ms | SELECT | SELECT "b".* FROM "a57be577deb434"."tbl_auth_assignments" "a", "a57be577deb434"."tbl_auth_items" "b" WHERE ("a"."item_name"="b"."name") AND ("a"."user_id"='1000') AND ("b"."type"=2) |
| 20:32:16.084 | 2.0 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_auth_item_child" |
| 20:32:16.087 | 0.4 ms | SELECT | SELECT "item_name" FROM "a57be577deb434"."tbl_auth_assignments" WHERE "user_id"='1000' |
| 20:32:16.088 | 1.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_auth_items" WHERE ("type"=2) AND ("name" IN ('viewSalesChart', 'viewPreSalesChart', 'viewImplementChart', 'viewServicePlan', 'viewCalendar', 'viewClientAnalysis', 'viewClientMap', 'viewFootPrint', 'viewOtherFootPrint', 'viewSalesRepScore', 'viewContactAnalysis', 'viewPurchaseAnalysis', 'viewReimbursementAnalysis', 'viewApproveAnalysis', 'viewSchedule', 'createSchedule', 'updateSchedule', 'deleteSchedule', 'viewSource', 'createSource', 'viewCalendarMng', 'createCalendarMng', 'updateCalendarMng', 'deleteCalendarMng', 'viewTask', 'createTask', 'updateTask', 'viewOtherTask', 'viewClient', 'viewOperation', 'viewOtherOperation', 'viewWorkLog', 'createWorkLog', 'updateWorkLog', 'viewProject', 'viewCase', 'viewTicket', 'viewSalesOrder', 'viewSalesContract', 'serviceProgress', 'viewReimbursement', 'createReimbursement', 'updateReimbursement', 'viewApprove', 'createApprove', 'updateApprove', 'viewDocument', 'viewSupplier', 'visitSupplier', 'viewPurchaseContract', 'viewProduct', 'viewService', 'viewPunch', 'createPunch', 'viewPunchApprove', 'createPunchApprove', 'updatePunchApprove', 'viewRating', 'viewStatisticsChart', 'deletePunchApprove', 'viewContactInfo', 'importClient', 'exportClient', 'updateClient', 'deleteClient', 'createPurchaseContract', 'updateProject', 'deleteProject', 'exportProject', 'updateSupplier', 'deleteSupplier', 'exportSupplier', 'updateSalesOrder', 'deleteSalesOrder', 'exportSalesOrder', 'updateProduct', 'deleteProduct', 'exportProduct', 'viewClientContact', 'updateClientContact', 'deleteClientContact', 'exportClientContact', 'viewSupplierContact', 'updateSupplierContact', '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', 'createOperation', 'updateOperation', 'deleteOperation', 'distributeCase', 'updateDocument', 'deleteDocument', 'updateClientDocument', 'deleteClientDocument', 'createService', 'updateService', 'deleteService', 'updateOthersProject', 'createClientDocument', 'createProjectDocument', 'updateProjectDocument', 'deleteProjectDocument', 'createCaseDocument', 'updateCaseDocument', 'deleteCaseDocument', 'createCase', 'updateCase', 'deleteCase', 'closeCase', 'suspendCase', 'deleteReimbursement', 'updateTicket', 'lockClient', 'deleteTicket', 'createSupplierDocument', 'updateSupplierDocument', 'deleteSupplierDocument', 'changeProjectStatus3', 'changeProjectStatus4', 'changeProjectStatus5', 'updateSource', 'deleteSource', 'distributeSource', 'deleteApprove')) |
| 20:32:16.090 | 0.3 ms | SELECT | SELECT "department_id", "department_position_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 20:32:16.092 | 1.5 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 2, 1141, 'v2/user/get-menu', '{"access_token":"rpAaho7HBg3VJ1vNP7yVtm0Uw5j2xu-u","device_type":"2","posttime":"1750768384","token":"0031525de2d33a8817b5c7ed073d51de","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":9,"title":"\u5f85\u529e\u4e8b\u9879","extra":0},{"id":24,"title":"\u65e5\u7a0b\u7ba1\u7406","extra":0},{"id":10,"title":"\u5ba2\u6237\u4fe1\u606f","extra":0},{"id":1,"title":"\u5546\u673a\u4fe1\u606f","extra":0},{"id":12,"title":"\u4f9b\u5e94\u5546","extra":0},{"id":10002,"title":"\u5ba2\u6237\u8054\u7cfb\u4eba","extra":0},{"id":10003,"title":"\u4f9b\u5e94\u5546\u8054\u7cfb\u4eba","extra":0},{"id":101,"title":"\u9879\u76ee\u6e05\u5355","extra":0},{"id":19,"title":"\u5de5\u4f5c\u65e5\u5fd7","extra":0},{"id":18,"title":"Case","extra":0},{"id":20,"title":"\u8d39\u7528\u62a5\u9500","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-24 20:32:16') RETURNING "id" |