Database Queries

总计9条数据
TimeDurationTypeQuery
  
18:11:00.1232.5 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1004

18:11:00.1261.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004

18:11:00.1301.3 msSELECTSELECT "b".* FROM "a57be577deb434"."tbl_auth_assignments" "a", "a57be577deb434"."tbl_auth_items" "b" WHERE ("a"."item_name"="b"."name") AND ("a"."user_id"='1004') AND ("b"."type"=1)

18:11:00.1310.4 msSELECTSELECT "b".* FROM "a57be577deb434"."tbl_auth_assignments" "a", "a57be577deb434"."tbl_auth_items" "b" WHERE ("a"."item_name"="b"."name") AND ("a"."user_id"='1004') AND ("b"."type"=2)

18:11:00.1321.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_auth_item_child"

18:11:00.1340.2 msSELECTSELECT "item_name" FROM "a57be577deb434"."tbl_auth_assignments" WHERE "user_id"='1004'

18:11:00.1341.3 msSELECTSELECT * 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', 'viewCostContract', 'createCostContract', 'updateCostContract', 'deleteCostContract', 'viewProduct', 'viewPunch', 'createPunch', 'viewPunchApprove', 'createPunchApprove', 'updatePunchApprove', 'viewRating', 'viewErp', 'viewErpSalesOrder', 'viewErpSalesOutbound', 'viewErpSalesReturn', 'createCase', 'updateCase', 'distributeCase', 'deleteCase', 'closeCase', 'suspendCase', 'createTicket', 'updateTicket', 'deleteTicket', 'createSupplierDocument', 'updateSupplierDocument', 'viewService', 'viewOtherPunch', 'viewAccount', 'viewOtherFootPrint', 'viewSalesRepScore', 'viewContactAnalysis', 'viewPurchaseAnalysis', 'deleteSchedule', 'createSource', 'viewOtherTask', 'deleteClient', 'lockClient', 'viewOperation', 'createOperation', 'updateOperation', 'deleteOperation', 'viewOtherOperation'))

18:11:00.1360.2 msSELECTSELECT "department_id", "department_position_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004

18:11:00.1361.2 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (403, 'a57be577deb434', 1004, 5, 'vue/purchase-contract/save-edit-cost', '{"PurchaseContracts":{"id":"4081","supplier_id":"431","amount":"11","handler":"1011","serial_no":"\u6d4b\u8bd5\u65b9\u5f0f\u5730\u65b9\u8bfb\u4e66","signed_at":"2025-08-12","description":"","including_tax":"1","contractScans":"","receiptScans":"","purchaseClientRels":"","PurchaseContractInvoices":"","costContractAmounts":[{"id":"386","amount":"11","description":"","parent_id":"385"}]},"web_access_token":"AidVpXYAKod5aJIX_4OSuCNwf6tmaemp"}', '{"code":403,"data":null,"status":0,"msg":[{"name":"error","success":"","error":"\u60a8\u6ca1\u6709\u6267\u884c\u6b64\u64cd\u4f5c\u7684\u6743\u9650","trace":{"name":"Forbidden","message":"\u60a8\u6ca1\u6709\u6267\u884c\u6b64\u64cd\u4f5c\u7684\u6743\u9650","code":0,"status":403,"type":"yii\\web\\ForbiddenHttpException"}}]}', TRUE, '2025-08-12 18:11:00') RETURNING "id"