ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6868cac11ba99: POST https://beta.jinchangxiao.com/vue/change-log/of-object at 2025-07-05 02:48:33 pm by 223.72.35.175

Database Queries

总计7条数据
TimeDurationTypeQuery
  
14:48:33.5322.9 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=5250

[+] Explain
14:48:33.5361.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5250

[+] Explain
14:48:33.5391045.6 msSELECTSELECT COUNT(*) FROM (SELECT * FROM "a57be577deb434"."tbl_object_change_logs" WHERE ("object_id"='3815') AND ("object_type"='1') ORDER BY "created_at" DESC) "c"

[+] Explain
14:48:34.58571.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_object_change_logs" WHERE ("object_id"='3815') AND ("object_type"='1') ORDER BY "created_at" DESC LIMIT 20

[+] Explain
14:48:34.6560.5 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1000, 1017)

[+] Explain
14:48:34.6570.7 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1017, 1000))

[+] Explain
14:48:34.6591.4 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":"1","object_id":"3815","page":"1","web_access_token":"lF6lDSiCl5CRIFfE8shlx2wSeme229Hs"}', '{"code":2000,"result":{"list":[{"id":510098,"object_id":3815,"object_type":1,"target_id":17699,"target_object_type":9,"act":2,"attribute":"update","old_value":[17699],"new_value":[17699],"description":{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]},"created_by":1000,"created_at":"2025-07-04 14:37:30","is_delete":false,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"need_hidden":false,"created_at_display":"1\u5929\u524d"},{"id":510095,"object_id":3815,"object_type":1,"target_id":17699,"target_object_type":9,"act":2,"attribute":"update","old_value":[17699],"new_value":[17699],"description":{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]},"created_by":1000,"created_at":"2025-07-04 14:37:29","is_delete":false,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"need_hidden":false,"created_at_display":"1\u5929\u524d"},{"id":510031,"object_id":3815,"object_type":1,"target_id":8268,"target_object_type":18,"act":2,"attribute":"update","old_value":[8268],"new_value":[8268],"description":{"d1":"\u8f66\u660e\u98de","d2":"\u66f4\u65b0\u4e86","d3":"Case","d4":["Case\u7f16\u53f7:PS250704001"]},"created_by":1017,"created_at":"2025-07-04 12:02:09","is_delete":false,"createdBy":{"id":1017,"key":1017,"name":"\u8f66\u660e\u98de","sex":"M","avatar":{"id":8,"user_id":1017,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e538f0fe-48a7-33da-a512-b252266c9e91.jpg"}},"need_hidden":false,"created_at_display":"1\u5929\u524d"},{"id":510020,"object_id":3815,"object_type":1,"target_id":7444,"target_object_type":20,"act":1,"attribute":"create","old_value":[7444],"new_value":[7444],"description":{"d1":"\u66f9\u6c38\u751f","d2":"\u521b\u5efa\u4e86","d3":"\u8d39\u7528\u62a5\u9500","d4":["\u4ea4\u901a\u8d39"]},"created_by":1000,"created_at":"2025-07-04 11:26:28","is_delete":false,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"need_hidden":false,"created_at_display":"1\u5929\u524d"},{"id":510017,"object_id":3815,"object_type":1,"target_id":1737,"target_object_type":37,"act":1,"attribute":"create","old_value":1737,"new_value":1737,"description":{"d1":"\u66f9\u6c38\u751f","d2":"\u521b\u5efa\u4e86","d3":"\u5ba1\u6279\u7533\u8bf7","d4":["\u6b63\u5e38\u5907\u8d27"]},"created_by":1000,"created_at":"2025-07-04 11:25:54","is_delete":false,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"need_hidden":false,"created_at_display":"1\u5929\u524d"},{"id":510013,"object_id":3815,"object_type":1,"target_id":8268,"target_object_type":18,"act":2,"attribute":"update","old_value":[8268],"new_value":[8268],"description":{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"Case","d4":["Case\u7f16\u53f7:PS250704001"]},"created_by":1000,"created_at":"2025-07-04 11:25:08","is_delete":false,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"need_hidden":false,"created_at_display":"1\u5929\u524d"},{"id":510008,"object_id":3815,"object_type":1,"target_id":196,"target_object_type":102,"act":2,"attribute":"update","old_value":[196],"new_value":[196],"description":{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u9879\u76ee","d4":["\u5c0f\u5587\u53ed\u73ed\u54af"]},"created_by":1000,"created_at":"2025-07-04 11:24:22","is_delete":false,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"need_hidden":false,"created_at_display":"1\u5929\u524d"},{"id":509968,"object_id":3815,"object_type":1,"target_id":8268,"target_object_type":18,"act":2,"attribute":"update","old_value":[8268],"new_value":[8268],"description":{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"Case","d4":["Case\u7f16\u53f7:PS250704001"]},"created_by":1000,"created_at":"2025-07-04 11:05:50","is_delete":false,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"need_hidden":false,"created_at_display":"1\u5929\u524d"},{"id":509965,"object_id":3815,"object_type":1,"target_id":8268,"target_object_type":18,"act":1,"attribute":"create","old_value":[8268],"new_value":[8268],"description":{"d1":"\u66f9\u6c38\u751f","d2":"\u521b\u5efa\u4e86","d3":"Case","d4":["Case\u7f16\u53f7:PS250704001"]},"created_by":1000,"created_at":"2025-07-04 11:03:12","is_delete":false,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"need_hidden":false,"created_at_display":"1\u5929\u524d"},{"id":509962,"object_id":3815,"object_type":1,"target_id":17699,"target_object_type":9,"act":2,"attribute":"update","old_value":17699,"new_value":17699,"description":{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]},"created_by":1000,"created_at":"2025-07-04 11:02:38","is_delete":false,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"need_hidden":false,"created_at_display":"1\u5929\u524d"},{"id":509959,"object_id":3815,"object_type":1,"target_id":17699,"target_object_type":9,"act":1,"attribute":"create","old_value":[17699],"new_value":[17699],"description":{"d1":"\u66f9\u6c38\u751f","d2":"\u521b\u5efa\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]},"created_by":1000,"created_at":"2025-07-04 11:02:22","is_delete":false,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"need_hidden":false,"created_at_display":"1\u5929\u524d"},{"id":509956,"object_id":3815,"object_type":1,"target_id":37027,"target_object_type":19,"act":2,"attribute":"update","old_value":[37027],"new_value":[37027],"description":{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5de5\u4f5c\u65e5\u5fd7","d4":["\u5ba2\u60c5\u589e\u8fdb"]},"created_by":1000,"created_at":"2025-07-04 11:02:00","is_delete":false,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"need_hidden":false,"created_at_display":"1\u5929\u524d"},{"id":509951,"object_id":3815,"object_type":1,"target_id":"","target_object_type":"","act":1,"attribute":"create","old_value":{"id":3815,"client_id":3337,"project_status":1,"project_progress":5,"budget":"0","profit_pct":"0","bargain_date":"2025-12-04","description":"","created_by":5332,"created_at":"2025-07-04 11:01:46","updated_at":"2025-07-04 11:01:46","engineer_id":"","project_title":"\u4ed8\u6b3e\u53d1\u8d27","collected":"0","status_updated_at":"2025-07-04 11:01:46.580051+08","success_rate":"","comment":"\u5c06\u9519\u5c31\u9519\u5bb6","contract_type":1,"progress_updated_at":"2025-07-04 11:01:46.580051+08","forecast_updated_at":"2025-07-04 11:01:46.580051+08","end_at":"","pinyin_shortcut":"fkfh","creator":1000,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":""},"new_value":{"id":3815,"client_id":3337,"project_status":1,"project_progress":5,"budget":"0","profit_pct":"0","bargain_date":"2025-12-04","description":"","created_by":5332,"created_at":"2025-07-04 11:01:46","updated_at":"2025-07-04 11:01:46","engineer_id":"","project_title":"\u4ed8\u6b3e\u53d1\u8d27","collected":"0","status_updated_at":"2025-07-04 11:01:46.580051+08","success_rate":"","comment":"\u5c06\u9519\u5c31\u9519\u5bb6","contract_type":1,"progress_updated_at":"2025-07-04 11:01:46.580051+08","forecast_updated_at":"2025-07-04 11:01:46.580051+08","end_at":"","pinyin_shortcut":"fkfh","creator":1000,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":""},"description":{"d1":"\u66f9\u6c38\u751f","d2":"\u521b\u5efa\u4e86","d3":"\u5546\u673a","d4":[]},"created_by":1000,"created_at":"2025-07-04 11:01:46","is_delete":false,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"need_hidden":true,"created_at_display":"1\u5929\u524d"}],"pagenation":{"totalcount":13,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-05 14:48:34') RETURNING "id"

[+] Explain