Database Queries

总计7条数据
TimeDurationTypeQuery
  
15:28:30.7632.2 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=5250

15:28:30.7661.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5250

15:28:30.76872.1 msSELECTSELECT COUNT(*) FROM (SELECT * FROM "a57be577deb434"."tbl_object_change_logs" WHERE ("object_id"='1572') AND ("object_type"='20007') ORDER BY "created_at" DESC) "c"

15:28:30.84180.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_object_change_logs" WHERE ("object_id"='1572') AND ("object_type"='20007') ORDER BY "created_at" DESC LIMIT 20

15:28:30.9210.4 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5295

15:28:30.9221.0 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5295)

15:28:30.9241.6 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5250, 5, 'vue/change-log/of-object', '{"object_type":"20007","object_id":"1572","page":"1","web_access_token":"fYPMcr-d-BNWEWblqdWXtE3DOD73_2vV"}', '{"code":2000,"result":{"list":[{"id":554052,"object_id":1572,"object_type":20007,"target_id":"","target_object_type":"","act":1,"attribute":"create","old_value":{"id":1572,"serial_no":"XSDD-20250821-00001","from_date":"","wrote_date":"2025-08-21","handler":5295,"client_id":107,"purchase_contract_id":"","project_id":3837,"sales_contract_id":"","erp_store_id":"","status":1,"erp_send_type_id":"","abstract":"","description":"","verify_type":1,"next_verify_user":1001,"next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"0","created_by":5295,"stop_description":"","extra":"{\"payment_collection_remind_ahead\":null,\"salesContractPaymentCollectionRemindReceivers\":null,\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-08-21 15:28:01","updated_at":"2025-08-21 15:28:01"},"new_value":{"id":1572,"serial_no":"XSDD-20250821-00001","from_date":"","wrote_date":"2025-08-21","handler":5295,"client_id":107,"purchase_contract_id":"","project_id":3837,"sales_contract_id":"","erp_store_id":"","status":1,"erp_send_type_id":"","abstract":"","description":"","verify_type":1,"next_verify_user":1001,"next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"0","created_by":5295,"stop_description":"","extra":"{\"payment_collection_remind_ahead\":null,\"salesContractPaymentCollectionRemindReceivers\":null,\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-08-21 15:28:01","updated_at":"2025-08-21 15:28:01"},"description":{"d1":"\u9b4f\u6cfd\u6587","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u8ba2\u5355\u7533\u8bf7","d4":[]},"created_by":5295,"created_at":"2025-08-21 15:28:01","is_delete":false,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"need_hidden":true,"created_at_display":"29\u79d2\u524d"}],"pagenation":{"totalcount":1,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-21 15:28:30') RETURNING "id"