ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6895be8b81029: POST https://beta.jinchangxiao.com/vue/project/time-line at 2025-08-08 05:08:27 pm by 124.64.23.198

Database Queries

总计8条数据
TimeDurationTypeQuery
  
17:08:27.6833.2 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
17:08:27.6882.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
17:08:27.6931.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_projects" "p" WHERE "p"."id"='263'

[+] Explain
17:08:27.69598.6 msSELECTSELECT COUNT(*) FROM (SELECT * FROM "a57be577deb434"."tbl_object_change_logs" WHERE ("object_id"=263) 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"

[+] Explain
17:08:27.79480.0 msSELECTSELECT * FROM "a57be577deb434"."tbl_object_change_logs" WHERE ("object_id"=263) 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

[+] Explain
17:08:27.8740.3 msSELECTSELECT "id", "id" AS "key", "project_title" AS "name", "client_id" FROM "a57be577deb434"."tbl_projects" WHERE "id"=263

[+] Explain
17:08:27.8750.6 msSELECTSELECT "id", "id" AS "key", "name", "client_class", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=399

[+] Explain
17:08:27.8761.8 msINSERTINSERT 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":"263","page":"1","web_access_token":"0Bjt7zsA4RpFpNhApjLlKpy587hFcKCO"}', '{"code":2000,"result":{"list":[{"id":97167,"object_id":263,"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":"\u6731\u65ed\u9896","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a\u72b6\u6001","d4":["\u5546\u673a\u6210\u4ea4 <b>\u53d8\u4e3a<\/b> \u6536\u6b3e\u5b8c\u6210"]},"created_by":1014,"created_at":"2021-06-29 16:17:55","is_delete":false,"project":{"id":263,"key":263,"name":"\u4e92\u8054\u7f51+\u7b2c\u4e8c\u6279","client_id":399,"client":{"id":399,"key":399,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240\u4e2d\u76fe(\u8fc7\u5355\u516c\u53f8)","client_class":43,"logo":"\/files\/cdn\/a57be577deb434\/logo\/6fc2ad20-226c-311c-9f64-96f95d6c6bdd.png","sales_rep":1005}},"need_hidden":false,"created_at_display":"2021\u5e7406\u670829\u65e5 16:17"},{"id":96047,"object_id":263,"object_type":1,"target_id":"","target_object_type":"","act":1,"attribute":"create","old_value":[{"id":263,"client_id":399,"project_status":3,"project_progress":10,"budget":"863675","profit_pct":"9","bargain_date":"2017-06-21","description":"\u6d6a\u6f6e\u670d\u52a1\u5668","created_by":1001,"created_at":"2017-07-10 13:50:18","updated_at":"2021-06-29 16:17:55","engineer_id":"","project_title":"\u4e92\u8054\u7f51+\u7b2c\u4e8c\u6279","collected":"863675","status_updated_at":"2019-01-15 15:55:53.441106+08","success_rate":100,"comment":"","contract_type":1,"progress_updated_at":"2019-05-05 16:39:47.132109+08","forecast_updated_at":"2019-05-05 16:39:47.132109+08","end_at":"2019-05-05 16:39:47"}],"new_value":[{"id":263,"client_id":399,"project_status":3,"project_progress":10,"budget":"863675","profit_pct":"9","bargain_date":"2017-06-21","description":"\u6d6a\u6f6e\u670d\u52a1\u5668","created_by":1001,"created_at":"2017-07-10 13:50:18","updated_at":"2021-06-29 16:17:55","engineer_id":"","project_title":"\u4e92\u8054\u7f51+\u7b2c\u4e8c\u6279","collected":"863675","status_updated_at":"2019-01-15 15:55:53.441106+08","success_rate":100,"comment":"","contract_type":1,"progress_updated_at":"2019-05-05 16:39:47.132109+08","forecast_updated_at":"2019-05-05 16:39:47.132109+08","end_at":"2019-05-05 16:39:47"}],"description":{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u5546\u673a","d4":[]},"created_by":1001,"created_at":"2017-07-10 13:50:18","is_delete":false,"project":{"id":263,"key":263,"name":"\u4e92\u8054\u7f51+\u7b2c\u4e8c\u6279","client_id":399,"client":{"id":399,"key":399,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240\u4e2d\u76fe(\u8fc7\u5355\u516c\u53f8)","client_class":43,"logo":"\/files\/cdn\/a57be577deb434\/logo\/6fc2ad20-226c-311c-9f64-96f95d6c6bdd.png","sales_rep":1005}},"need_hidden":true,"created_at_display":"2017\u5e7407\u670810\u65e5 13:50"}],"pagenation":{"totalcount":2,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-08 17:08:27') RETURNING "id"

[+] Explain