Database Queries

总计7条数据
TimeDurationTypeQuery
  
14:50:19.2083.4 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

14:50:19.2141.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

14:50:19.21673.0 msSELECTSELECT COUNT(*) FROM (SELECT * FROM "a57be577deb434"."tbl_object_change_logs" WHERE ("object_id"='2118') AND ("object_type"='20012') ORDER BY "created_at" DESC) "c"

14:50:19.28972.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_object_change_logs" WHERE ("object_id"='2118') AND ("object_type"='20012') ORDER BY "created_at" DESC LIMIT 20

14:50:19.3620.3 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5388

14:50:19.3630.7 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5388)

14:50:19.3641.3 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/change-log/of-object', '{"object_type":"20012","object_id":"2118","page":"1","web_access_token":"1oIEeDxvJLe30O-GCa2UzTZzY9D9JY1c"}', '{"code":2000,"result":{"list":[{"id":564201,"object_id":2118,"object_type":20012,"target_id":"","target_object_type":"","act":1,"attribute":"create","old_value":{"id":2118,"serial_no":"FKD-20250901-00001","wrote_date":"2025-09-01","from_date":"","handler":1011,"client_id":"","sales_contract_id":"","supplier_id":262,"purchase_contract_id":"","status":1,"abstract":"","description":"","verify_type":2,"next_verify_user":1001,"next_stop_verify_user":"","verify_at":"","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"509.04","settle_amount":"0","created_by":5388,"stop_description":"","is_settle":false,"is_payment_settle":false,"is_old":false,"created_at":"2025-09-01 09:16:48","updated_at":"2025-09-01 09:16:48","paid_amount":"0","contact_id":""},"new_value":{"id":2118,"serial_no":"FKD-20250901-00001","wrote_date":"2025-09-01","from_date":"","handler":1011,"client_id":"","sales_contract_id":"","supplier_id":262,"purchase_contract_id":"","status":1,"abstract":"","description":"","verify_type":2,"next_verify_user":1001,"next_stop_verify_user":"","verify_at":"","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"509.04","settle_amount":"0","created_by":5388,"stop_description":"","is_settle":false,"is_payment_settle":false,"is_old":false,"created_at":"2025-09-01 09:16:48","updated_at":"2025-09-01 09:16:48","paid_amount":"0","contact_id":""},"description":{"d1":"\u6768\u71d5\u971e","d2":"\u521b\u5efa\u4e86","d3":"\u4ed8\u6b3e\u5355\u7533\u8bf7","d4":[]},"created_by":5388,"created_at":"2025-09-01 09:16:48","is_delete":false,"createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}},"need_hidden":true,"created_at_display":"09\u670801\u65e5 09:16"}],"pagenation":{"totalcount":1,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-08 14:50:19') RETURNING "id"