ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a1d1d188cfe0: POST https://beta.jinchangxiao.com/vue/project/list at 2026-06-01 01:48:08 pm by 43.224.72.82

Database Queries

总计13条数据
TimeDurationTypeQuery
  
13:48:08.7531.5 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=5495

[+] Explain
13:48:08.7560.5 msSELECTSELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5495

[+] Explain
13:48:08.7625.2 msSELECTSELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND (("pa"."engineer_id"='5495')) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) GROUP BY "p"."id" ORDER BY p.bargain_date DESC NULLS LAST, p.created_at DESC) "c"

[+] Explain
13:48:08.7685.8 msSELECTSELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND (("pa"."engineer_id"='5495')) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) GROUP BY "p"."id" ORDER BY p.bargain_date DESC NULLS LAST, p.created_at DESC LIMIT 20

[+] Explain
13:48:08.7753.5 msSELECTSELECT count(*) as count, sum(budget), "project_status" FROM (SELECT p.budget, CASE WHEN project_status = 3 and p.budget <= collected THEN -1 WHEN project_status = 3 and p.budget > collected THEN 3 ELSE project_status END as project_status FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND (("pa"."engineer_id"='5495')) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) GROUP BY "p"."id") "sub" GROUP BY "project_status"

[+] Explain
13:48:08.7800.3 msSELECTSELECT "id" AS "key", "project_status" AS "name", "color" FROM "o6a13e2c574d5a"."tbl_project_statuses" WHERE "id" IN (1, 2) ORDER BY "order"

[+] Explain
13:48:08.7815.5 msSELECTSELECT SUM(case when need_analysis = true THEN amount ELSE 0 END) FROM "o6a13e2c574d5a"."tbl_sales_contracts" WHERE "id" IN (SELECT "id" FROM "o6a13e2c574d5a"."tbl_sales_contracts" WHERE "from_project" IN (SELECT "p"."id" FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND (("pa"."engineer_id"='5495')) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) GROUP BY "p"."id"))

[+] Explain
13:48:08.7875.4 msSELECTSELECT SUM(case when need_analysis = true THEN amount ELSE 0 END) FROM "o6a13e2c574d5a"."tbl_sales_contracts" WHERE ("id" IN (SELECT "id" FROM "o6a13e2c574d5a"."tbl_sales_contracts" WHERE "from_project" IN (SELECT "p"."id" FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND (("pa"."engineer_id"='5495')) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) GROUP BY "p"."id"))) AND ("including_tax"=TRUE)

[+] Explain
13:48:08.7935.2 msSELECTSELECT SUM(erp_settle_amount) FROM "o6a13e2c574d5a"."tbl_sales_contracts" WHERE "id" IN (SELECT "id" FROM "o6a13e2c574d5a"."tbl_sales_contracts" WHERE "from_project" IN (SELECT "p"."id" FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND (("pa"."engineer_id"='5495')) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) GROUP BY "p"."id"))

[+] Explain
13:48:08.7995.9 msSELECTSELECT SUM(amount) FROM "o6a13e2c574d5a"."tbl_sales_contract_invoices" WHERE "contract_id" IN (SELECT "id" FROM "o6a13e2c574d5a"."tbl_sales_contracts" WHERE "from_project" IN (SELECT "p"."id" FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND (("pa"."engineer_id"='5495')) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) GROUP BY "p"."id"))

[+] Explain
13:48:08.8055.9 msSELECTSELECT SUM(amount) FROM "o6a13e2c574d5a"."tbl_sales_contract_invoices" WHERE "contract_id" IN (SELECT "id" FROM "o6a13e2c574d5a"."tbl_sales_contracts" WHERE ("id" IN (SELECT "id" FROM "o6a13e2c574d5a"."tbl_sales_contracts" WHERE "from_project" IN (SELECT "p"."id" FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND (("pa"."engineer_id"='5495')) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) GROUP BY "p"."id"))) AND ("including_tax"=TRUE))

[+] Explain
13:48:08.8116.2 msSELECTSELECT SUM(total_contact_point - coalesce(paid_contact_point, 0)) FROM "o6a13e2c574d5a"."tbl_projects" WHERE "id" IN (SELECT "from_project" FROM "o6a13e2c574d5a"."tbl_sales_contracts" WHERE "id" IN (SELECT "id" FROM "o6a13e2c574d5a"."tbl_sales_contracts" WHERE "from_project" IN (SELECT "p"."id" FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND (("pa"."engineer_id"='5495')) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) GROUP BY "p"."id")))

[+] Explain
13:48:08.8191.1 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'o6a13e2c574d5a', 5495, 5, 'vue/project/list', '{"ProjectSearch":{"engineer_id":["5495"],"group":"","project_status":"","creator":"","purchaseType":"","engineer_group":"1","period":"","budget":"","profit_pct":"","invoice_status":"","payment_status":"","collected_plan":"","project_progress":"","salesForecast":"","projectProductTypes":"","contact_point_status":"","from_contact_name":"","from_contact":"","contract_type":"","is_sales_order_ready":"","created_period":""},"Filter":{"name":"bargain_date","sort":"DESC","Tsort":"","Tname":""},"page":"1","web_access_token":"BVNSh9YfxWIaBBEpqELLGqJuWOoESJvj"}', '{"code":2000,"result":{"count":{"statusCount":[{"count":0,"key":1,"name":"\u9690\u6027\u9700\u6c42","color":"#f49b00","sum":0},{"count":0,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#4e6ef2","sum":0},{"count":0,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#3fad00","sum":0},{"count":0,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a","sum":0},{"count":0,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222","sum":0},{"count":0,"key":-1,"name":"\u6536\u6b3e\u5b8c\u6210","color":"#6200fe","sum":0}]},"list":[],"thisUser":"","options":{"Projects[project_status]":{"key":"Projects[project_status]","name":"\u5546\u673a\u72b6\u6001","value":[{"key":1,"name":"\u9690\u6027\u9700\u6c42","color":"#ffc000"},{"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"}]}},"can_create":false,"can_create_work_log":true,"can_create_schedule":true,"pagenation":{"totalcount":0,"thispage":1,"pagesize":20},"count2":[{"name":"\u5408\u540c\u603b\u91d1\u989d","value":""},{"name":"\u5df2\u6536\u6b3e","value":""},{"name":"\u672a\u6536\u6b3e","value":0},{"name":"\u5df2\u5f00\u53d1\u7968","value":""},{"name":"\u672a\u5f00\u53d1\u7968","value":0}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"43.224.72.82","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-01 13:48:08', 236158208) RETURNING "id"

[+] Explain