685d34cce0e87: POST https://beta.jinchangxiao.com/vue/dashboard/get-create-menu at 2025-06-26 07:53:48 pm by 120.244.156.86
Database Queries
总计9条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 19:53:48.926 | 3.1 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 19:53:48.930 | 1.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 19:53:48.932 | 4.3 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"='1001') AND ("b"."type"=1) |
| 19:53:48.939 | 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"='1001') AND ("b"."type"=2) |
| 19:53:48.940 | 3.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_auth_item_child" |
| 19:53:48.944 | 2.1 ms | SELECT | SELECT "item_name" FROM "a57be577deb434"."tbl_auth_assignments" WHERE "user_id"='1001' |
| 19:53:48.948 | 3.1 ms | SELECT | 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', 'viewStatisticsChart', 'deletePunchApprove', 'importClient', 'exportClient', 'deleteClient', 'viewPurchaseAnalysis', 'createPurchaseContract', 'deleteProject', 'exportProject', 'deleteSupplier', 'exportSupplier', 'updateSalesOrder', 'deleteSalesOrder', 'exportSalesOrder', 'updateProduct', 'deleteProduct', 'exportProduct', 'deleteClientContact', 'exportClientContact', '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', 'deleteSchedule', 'viewOperation', 'createOperation', 'updateOperation', 'deleteOperation', 'viewOtherOperation', 'distributeCase', 'deleteDocument', 'deleteClientDocument', 'viewService', 'createService', 'updateService', 'deleteService', 'updateOthersProject', 'deleteProjectDocument', 'deleteCaseDocument', 'createCase', 'updateCase', 'deleteCase', 'closeCase', 'suspendCase', 'viewSalesRepScore', 'updateTicket', 'lockClient', 'deleteTicket', 'createSupplierDocument', 'updateSupplierDocument', 'deleteSupplierDocument', 'viewContactAnalysis', 'createSource', 'updateSource', 'deleteSource', 'distributeSource', 'deleteApprove', 'viewOtherTask', 'createTicket')) |
| 19:53:48.952 | 0.3 ms | SELECT | SELECT "department_id", "department_position_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 19:53:48.956 | 1.7 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/dashboard/get-create-menu', '{"web_access_token":"SXPCUp7Z_YgHJ45TnvuyG1o7l8nwuHKC"}', '{"code":2000,"result":[{"id":9,"icon":"icon-daiban","title":"\u5f85\u529e\u4e8b\u9879","appName":"schedule","extra":0},{"id":24,"icon":"icon-richeng","title":"\u65e5\u7a0b\u7ba1\u7406","appName":"calendar","extra":0},{"id":10,"icon":"icon-kehuxinxi","title":"\u5ba2\u6237\u4fe1\u606f","appName":"client","extra":0},{"id":19,"icon":"icon-gongzuorizhi","title":"\u5de5\u4f5c\u65e5\u5fd7","appName":"worklog","extra":0},{"id":1,"icon":"icon-shangjixinxi","title":"\u5546\u673a\u4fe1\u606f","appName":"project","extra":0},{"id":21,"icon":"icon-xiaoshouxiansuo","title":"\u9500\u552e\u7ebf\u7d22","appName":"source","extra":0,"can_create_contact":true},{"id":1001,"icon":"icon-kehulianxiren","title":"\u5ba2\u6237\u8054\u7cfb\u4eba","appName":"clientContact","extra":0},{"id":1002,"icon":"icon-gongyingshanglianxiren","title":"\u4f9b\u5e94\u5546\u8054\u7cfb\u4eba","appName":"supplierContact","extra":0},{"id":101,"icon":"icon-xiangmuguanli","title":"\u9879\u76ee\u6e05\u5355","appName":"task","extra":0},{"id":18,"icon":"icon-gongdanguanli","title":"CASE","appName":"caseManagement","extra":0},{"id":20,"icon":"icon-feiyongbaoxiao","title":"\u8d39\u7528\u62a5\u9500","appName":"reimbursementManagement","extra":0},{"id":23,"icon":"icon-xiaoshoujilu","title":"\u9500\u552e\u8bb0\u5f55","appName":"salesOrder","extra":0},{"id":37,"icon":"icon-shenpi","title":"\u5ba1\u6279\u7ba1\u7406","appName":"approveManagement","extra":0}],"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-06-26 19:53:48') RETURNING "id" |