Database Queries

总计10条数据
TimeDurationTypeQuery
  
11:18:28.4182.7 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

11:18:28.4221.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

11:18:28.4260.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"='3851'

11:18:28.4271.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contract_payments" WHERE "contract_id"=3851 ORDER BY "collected_date" DESC, "id" DESC

11:18:28.4315.4 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

11:18:28.4413.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)

11:18:28.4450.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4

11:18:28.4455.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=110) AND ("object_id" IN (2103, 2102, 2101))

11:18:28.4580.6 msSELECTSELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=24821

11:18:28.4643.6 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/purchase-contract/get-payment-files', '{"contract_id":"3851","web_access_token":"er_liQPTz011rRwTshQzixBLTwcD6PCJ"}', '{"code":2000,"result":{"list":[{"id":24821,"key":24821,"name":"0029c0c5-1764-3a48-b0b8-2a6ea76c6784","extension":"png","path":"\/vue\/attachment\/view\/0029c0c5-1764-3a48-b0b8-2a6ea76c6784\/\u622a\u5c4f2025-07-03 14.39.11.png","orig_name":"\u622a\u5c4f2025-07-03 14.39.11.png"}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-04 11:18:28') RETURNING "id"