Database Queries

总计16条数据
TimeDurationTypeQuery
  
13:09:00.7990.9 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

13:09:00.8010.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

13:09:00.8050.4 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_attachments" WHERE "id"='32705')

13:09:00.8060.4 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='1956')

13:09:00.8060.3 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)

13:09:00.8070.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_attachments" WHERE "id"='32705')

13:09:00.8070.3 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='1956')

13:09:00.8070.3 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)

13:09:00.8085.9 msINSERTINSERT INTO "a57be577deb434"."tbl_client_documents" ("title", "description", "attachment_id", "client_id", "created_by") VALUES ('我认为', '我认为', 32705, 1956, 1001) RETURNING "id"

13:09:00.8141.1 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientDocuments', 1262, 'a:10:{s:2:"id";i:1262;s:13:"attachment_id";s:5:"32705";s:9:"client_id";s:4:"1956";s:5:"title";s:9:"我认为";s:11:"description";s:9:"我认为";s:10:"created_by";i:1001;s:10:"created_at";N;s:10:"updated_at";N;s:10:"project_id";N;s:7:"case_id";N;}', '', 1001, '221.216.117.119')

13:09:00.8160.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_client_documents" WHERE "id"=1262

13:09:00.8176.4 msINSERTINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (1, 'create', 1262, 104, 1001, '2026-06-04 13:09:00', '{"id":1262,"attachment_id":32705,"client_id":1956,"title":"\u6211\u8ba4\u4e3a","description":"\u6211\u8ba4\u4e3a","created_by":1001,"created_at":"2026-06-04 13:09:00","updated_at":"2026-06-04 13:09:00","project_id":null,"case_id":null}', '{"id":1262,"attachment_id":32705,"client_id":1956,"title":"\u6211\u8ba4\u4e3a","description":"\u6211\u8ba4\u4e3a","created_by":1001,"created_at":"2026-06-04 13:09:00","updated_at":"2026-06-04 13:09:00","project_id":null,"case_id":null}', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u5ba2\u6237\u6587\u6863","d4":[]}') RETURNING "id"

13:09:00.8240.9 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 641125, 'a:13:{s:2:"id";i:641125;s:9:"object_id";i:1262;s:11:"object_type";i:104;s:9:"target_id";N;s:18:"target_object_type";N;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:235:"{"id":1262,"attachment_id":32705,"client_id":1956,"title":"\u6211\u8ba4\u4e3a","description":"\u6211\u8ba4\u4e3a","created_by":1001,"created_at":"2026-06-04 13:09:00","updated_at":"2026-06-04 13:09:00","project_id":null,"case_id":null}";s:9:"new_value";s:235:"{"id":1262,"attachment_id":32705,"client_id":1956,"title":"\u6211\u8ba4\u4e3a","description":"\u6211\u8ba4\u4e3a","created_by":1001,"created_at":"2026-06-04 13:09:00","updated_at":"2026-06-04 13:09:00","project_id":null,"case_id":null}";s:11:"description";s:93:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u5ba2\u6237\u6587\u6863","d4":[]}";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2026-06-04 13:09:00";s:9:"is_delete";N;}', '', 1001, '221.216.117.119')

13:09:00.8250.9 msINSERTINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (1, 'create', 1956, 10, 1262, 104, 1001, '[1262]', '[1262]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u5ba2\u6237\u6587\u6863","d4":["\u6211\u8ba4\u4e3a"]}') RETURNING "id"

13:09:00.8260.9 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 641126, 'a:13:{s:2:"id";i:641126;s:9:"object_id";i:1956;s:11:"object_type";i:10;s:9:"target_id";i:1262;s:18:"target_object_type";i:104;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:6:"[1262]";s:9:"new_value";s:6:"[1262]";s:11:"description";s:113:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u5ba2\u6237\u6587\u6863","d4":["\u6211\u8ba4\u4e3a"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '221.216.117.119')

13:09:00.8280.9 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/client/save-new-document', '{"ClientDocuments":{"id":"","title":"\u6211\u8ba4\u4e3a","description":"\u6211\u8ba4\u4e3a","attachment_id":"32705","client_id":"1956"},"web_access_token":"-ooNs73DKJQ01PCpcbuHx_usnaO5SdwJ"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u65b0\u5ba2\u6237\u6587\u6863\u5df2\u521b\u5efa\u6210\u529f","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-04 13:09:00', 31323904) RETURNING "id"