Database Queries

总计9条数据
TimeDurationTypeQuery
  
14:45:59.0983.2 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

14:45:59.1051.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

14:45:59.108145.0 msSELECTSELECT COUNT(*) FROM (SELECT * FROM "a57be577deb434"."tbl_object_change_logs" WHERE ("object_id"='4077') AND ("object_type"='13') ORDER BY "created_at" DESC) "c"

14:45:59.25371.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_object_change_logs" WHERE ("object_id"='4077') AND ("object_type"='13') ORDER BY "created_at" DESC LIMIT 20

14:45:59.3250.3 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1011

14:45:59.3260.7 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1011)

14:45:59.3271.4 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":"13","object_id":"4077","page":"1","web_access_token":"bMbho0_rXPW7OXlAQb1YuSTyV_XtCLu3"}', '{"code":2000,"result":{"list":[{"id":552588,"object_id":4077,"object_type":13,"target_id":"","target_object_type":"","act":2,"attribute":"purchaseContractPaymentCollectionRemindReceivers","old_value":[[]],"new_value":[["\u97e9\u96c5\u82b3","\u5f20\u7ea2\u82b3"]],"description":{"d1":"\u97e9\u96c5\u82b3","d2":"\u66f4\u65b0\u4e86","d3":"\u4ed8\u6b3e\u63d0\u9192\u4eba","d4":["(\u672a\u8bbe\u7f6e) <b>\u53d8\u4e3a<\/b> \u97e9\u96c5\u82b3;\u5f20\u7ea2\u82b3;"]},"created_by":1011,"created_at":"2025-08-01 13:31:43","is_delete":false,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"need_hidden":false,"created_at_display":"08\u670801\u65e5 13:31"},{"id":552587,"object_id":4077,"object_type":13,"target_id":"","target_object_type":"","act":2,"attribute":"purchaseContractPaymentCollectionRemindDates","old_value":[[]],"new_value":[["2025-09-01 72000.00\u5143"]],"description":{"d1":"\u97e9\u96c5\u82b3","d2":"\u66f4\u65b0\u4e86","d3":"\u4ed8\u6b3e\u8ba1\u5212","d4":["(\u672a\u8bbe\u7f6e) <b>\u53d8\u4e3a<\/b> 2025-09-01 72000.00\u5143;"]},"created_by":1011,"created_at":"2025-08-01 13:31:43","is_delete":false,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"need_hidden":false,"created_at_display":"08\u670801\u65e5 13:31"},{"id":552586,"object_id":4077,"object_type":13,"target_id":"","target_object_type":"","act":2,"attribute":"payment_collection_remind_ahead","old_value":["\u65e0"],"new_value":["\u63d0\u524d1\u5929"],"description":{"d1":"\u97e9\u96c5\u82b3","d2":"\u66f4\u65b0\u4e86","d3":"\u4ed8\u6b3e\u63d0\u9192\u65f6\u95f4","d4":["\u65e0 <b>\u53d8\u4e3a<\/b> \u63d0\u524d1\u5929"]},"created_by":1011,"created_at":"2025-08-01 13:31:43","is_delete":false,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"need_hidden":false,"created_at_display":"08\u670801\u65e5 13:31"},{"id":552582,"object_id":4077,"object_type":13,"target_id":"","target_object_type":"","act":2,"attribute":"purchaseClientRels","old_value":[[]],"new_value":[["\u4e0a\u6d77\u534e\u8baf\u7f51\u7edc\u7cfb\u7edf\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09 33\u6240\u9ad8\u6027\u80fd\u9879\u76ee"]],"description":{"d1":"\u97e9\u96c5\u82b3","d2":"\u66f4\u65b0\u4e86","d3":"\u5173\u8054\u5ba2\u6237\/\u5546\u673a","d4":["(\u672a\u8bbe\u7f6e) <b>\u53d8\u4e3a<\/b> \u4e0a\u6d77\u534e\u8baf\u7f51\u7edc\u7cfb\u7edf\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09 33\u6240\u9ad8\u6027\u80fd\u9879\u76ee;"]},"created_by":1011,"created_at":"2025-08-01 13:31:31","is_delete":false,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"need_hidden":false,"created_at_display":"08\u670801\u65e5 13:31"},{"id":552581,"object_id":4077,"object_type":13,"target_id":"","target_object_type":"","act":2,"attribute":"amount","old_value":[0],"new_value":["72000\u5143"],"description":{"d1":"\u97e9\u96c5\u82b3","d2":"\u66f4\u65b0\u4e86","d3":"\u5408\u540c\u603b\u989d","d4":["(\u672a\u8bbe\u7f6e) <b>\u53d8\u4e3a<\/b> 72000\u5143"]},"created_by":1011,"created_at":"2025-08-01 13:31:31","is_delete":false,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"need_hidden":false,"created_at_display":"08\u670801\u65e5 13:31"},{"id":552579,"object_id":4077,"object_type":13,"target_id":"","target_object_type":"","act":1,"attribute":"create","old_value":{"id":4077,"supplier_id":38,"contract_type":1,"signed_at":"2025-08-01","amount":"0","handler":1013,"description":"\u5185\u5b58 32\u683964GB DDR5 5600MHz ECC RDIMM","contract_scan":"","created_by":1011,"created_at":"2025-08-01 13:30:47","updated_at":"2025-08-01 13:30:47","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250801-WJC-001","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":false,"save_collection_at":"","is_chargeback":false,"cost_type":1},"new_value":{"id":4077,"supplier_id":38,"contract_type":1,"signed_at":"2025-08-01","amount":"0","handler":1013,"description":"\u5185\u5b58 32\u683964GB DDR5 5600MHz ECC RDIMM","contract_scan":"","created_by":1011,"created_at":"2025-08-01 13:30:47","updated_at":"2025-08-01 13:30:47","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250801-WJC-001","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":false,"save_collection_at":"","is_chargeback":false,"cost_type":1},"description":{"d1":"\u97e9\u96c5\u82b3","d2":"\u521b\u5efa\u4e86","d3":"\u91c7\u8d2d\u5408\u540c","d4":[]},"created_by":1011,"created_at":"2025-08-01 13:30:47","is_delete":false,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"need_hidden":true,"created_at_display":"08\u670801\u65e5 13:30"}],"pagenation":{"totalcount":6,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-25 14:45:59') RETURNING "id"

14:45:59.3300.3 msSELECTSELECT * FROM "global"."tbl_browser_ua_statistics" "b" WHERE "user_agent"='Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:142.0) Gecko/20100101 Firefox/142.0'

14:45:59.3310.2 msUPDATEUPDATE "global"."tbl_browser_ua_statistics" SET "counter"=1500 WHERE "id"=167