68c285418e147: POST https://beta.jinchangxiao.com/vue/project/time-line at 2025-09-11 04:16:01 pm by 114.246.237.213
Database Queries
总计8条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 16:16:01.598 | 3.2 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 16:16:01.603 | 2.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 16:16:01.608 | 1.1 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" "p" WHERE "p"."id"='3950' |
| 16:16:01.610 | 88.8 ms | SELECT | SELECT COUNT(*) FROM (SELECT * FROM "a57be577deb434"."tbl_object_change_logs" WHERE ("object_id"=3950) AND ("object_type"=1) AND ("attribute" IN ('create', 'transfer', 'project_status', 'project_progress', 'salesForecast', 'created_by')) AND ((target_id is null) OR ("target_object_type"=1)) ORDER BY "created_at" DESC) "c" |
| 16:16:01.699 | 81.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_object_change_logs" WHERE ("object_id"=3950) AND ("object_type"=1) AND ("attribute" IN ('create', 'transfer', 'project_status', 'project_progress', 'salesForecast', 'created_by')) AND ((target_id is null) OR ("target_object_type"=1)) ORDER BY "created_at" DESC LIMIT 20 |
| 16:16:01.781 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "project_title" AS "name", "client_id" FROM "a57be577deb434"."tbl_projects" WHERE "id"=3950 |
| 16:16:01.781 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "name", "client_class", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=3389 |
| 16:16:01.782 | 1.4 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/project/time-line', '{"id":"3950","page":"1","web_access_token":"2BZqbE639wqIoHhgH0VfUgn-meZYtkbz"}', '{"code":2000,"result":{"list":[{"id":564596,"object_id":3950,"object_type":1,"target_id":"","target_object_type":"","act":2,"attribute":"project_status","old_value":["\u5546\u673a\u6210\u4ea4"],"new_value":["\u6536\u6b3e\u5b8c\u6210"],"description":{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a\u72b6\u6001","d4":["\u5546\u673a\u6210\u4ea4 <b>\u53d8\u4e3a<\/b> \u6536\u6b3e\u5b8c\u6210"]},"created_by":1001,"created_at":"2025-09-04 09:21:06","is_delete":false,"project":{"id":3950,"key":3950,"name":"\u6d4b-\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355\uff1a\u6df1\u4fe1\u670d\u9632\u706b\u5899AF-1000-FH2300B","client_id":3389,"client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8","client_class":43,"logo":"","sales_rep":1001}},"need_hidden":false,"created_at_display":"2025\u5e7409\u670804\u65e5 09:21"},{"id":564529,"object_id":3950,"object_type":1,"target_id":"","target_object_type":"","act":2,"attribute":"project_status","old_value":["\u660e\u786e\u9700\u6c42"],"new_value":["\u5546\u673a\u6210\u4ea4"],"description":{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a\u72b6\u6001","d4":["\u660e\u786e\u9700\u6c42 <b>\u53d8\u4e3a<\/b> \u5546\u673a\u6210\u4ea4"]},"created_by":1001,"created_at":"2025-09-03 15:41:50","is_delete":false,"project":{"id":3950,"key":3950,"name":"\u6d4b-\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355\uff1a\u6df1\u4fe1\u670d\u9632\u706b\u5899AF-1000-FH2300B","client_id":3389,"client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8","client_class":43,"logo":"","sales_rep":1001}},"need_hidden":false,"created_at_display":"2025\u5e7409\u670803\u65e5 15:41"},{"id":559182,"object_id":3950,"object_type":1,"target_id":"","target_object_type":"","act":1,"attribute":"create","old_value":{"id":3950,"client_id":3389,"project_status":2,"project_progress":6,"budget":"270000","profit_pct":"3","bargain_date":"2025-08-21","description":"","created_by":1001,"created_at":"2025-08-21 12:26:55","updated_at":"2025-08-21 12:26:55","engineer_id":"","project_title":"\u6df1\u4fe1\u670d\u9632\u706b\u5899AF-1000-FH2300B","collected":"0","status_updated_at":"2025-08-21 12:26:55.466653+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-08-21 12:26:55.466653+08","forecast_updated_at":"2025-08-21 12:26:55.466653+08","end_at":"","pinyin_shortcut":"sxffhqAF1000FH2300B","creator":1011,"used_client":"","from_contact":5912,"total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false},"new_value":{"id":3950,"client_id":3389,"project_status":2,"project_progress":6,"budget":"270000","profit_pct":"3","bargain_date":"2025-08-21","description":"","created_by":1001,"created_at":"2025-08-21 12:26:55","updated_at":"2025-08-21 12:26:55","engineer_id":"","project_title":"\u6df1\u4fe1\u670d\u9632\u706b\u5899AF-1000-FH2300B","collected":"0","status_updated_at":"2025-08-21 12:26:55.466653+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-08-21 12:26:55.466653+08","forecast_updated_at":"2025-08-21 12:26:55.466653+08","end_at":"","pinyin_shortcut":"sxffhqAF1000FH2300B","creator":1011,"used_client":"","from_contact":5912,"total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false},"description":{"d1":"\u97e9\u96c5\u82b3","d2":"\u521b\u5efa\u4e86","d3":"\u5546\u673a","d4":[]},"created_by":1011,"created_at":"2025-08-21 12:26:55","is_delete":false,"project":{"id":3950,"key":3950,"name":"\u6d4b-\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355\uff1a\u6df1\u4fe1\u670d\u9632\u706b\u5899AF-1000-FH2300B","client_id":3389,"client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8","client_class":43,"logo":"","sales_rep":1001}},"need_hidden":true,"created_at_display":"2025\u5e7408\u670821\u65e5 12:26"}],"pagenation":{"totalcount":3,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-11 16:16:01') RETURNING "id" |