ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a1d037793532: POST https://beta.jinchangxiao.com/vue/project/of-client at 2026-06-01 11:58:47 am by 43.224.72.82

Database Queries

总计68条数据
TimeDurationTypeQuery
  
11:58:47.6050.6 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=5495

[+] Explain
11:58:47.6060.3 msSELECTSELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5495

[+] Explain
11:58:47.6080.4 msSELECTSELECT * FROM "o6a13e2c574d5a"."tbl_clients" WHERE ("id"='1') AND ("deleted"=FALSE)

[+] Explain
11:58:47.6124.4 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 ((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))) AND ("p"."client_id"=1) GROUP BY "p"."id" ORDER BY "bargain_date" DESC, "p"."created_at" DESC) "c"

[+] Explain
11:58:47.6164.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 ((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))) AND ("p"."client_id"=1) GROUP BY "p"."id" ORDER BY "bargain_date" DESC, "p"."created_at" DESC LIMIT 20

[+] Explain
11:58:47.6254.1 msSELECTSELECT "id", "id" AS "key", "name", "logo", "client_type", "client_class", "client_industry", "sales_rep" FROM "o6a13e2c574d5a"."tbl_clients" WHERE "id"=1

[+] Explain
11:58:47.6300.4 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493

[+] Explain
11:58:47.6300.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5493)

[+] Explain
11:58:47.6310.5 msSELECTSELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_client_types" WHERE "id"=1

[+] Explain
11:58:47.6310.4 msSELECTSELECT "id", "id" AS "key", "name", "notice_days", "color" FROM "o6a13e2c574d5a"."tbl_client_classes" WHERE "id"=1

[+] Explain
11:58:47.6320.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_client_industries" WHERE "id"=20

[+] Explain
11:58:47.6331.5 msSELECTSELECT "id", "id" AS "key", "type" AS "name" FROM "o6a13e2c574d5a"."tbl_contract_types" WHERE "id"=1

[+] Explain
11:58:47.6341.7 msSELECTSELECT "project_id", "contribution" AS "value", "engineer_id" AS "key", "u"."name" FROM "o6a13e2c574d5a"."tbl_project_architects" LEFT JOIN "o6a13e2c574d5a"."tbl_users" "u" ON engineer_id = u.id WHERE "o6a13e2c574d5a"."tbl_project_architects"."project_id"=1 ORDER BY "contribution" DESC, "engineer_id"

[+] Explain
11:58:47.6371.0 msSELECTSELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "o6a13e2c574d5a"."tbl_project_statuses" WHERE "id"=3

[+] Explain
11:58:47.6391.4 msSELECTSELECT "id", "id" AS "key", "project_progress" AS "name", "description" FROM "o6a13e2c574d5a"."tbl_project_progresses" WHERE "id"=6

[+] Explain
11:58:47.6401.8 msSELECTSELECT id, product_type_id, product_type_id as key, name, coalesce(budget, 0) as budget, coalesce(pct, 0) as pct, coalesce(profit, 0) as profit, project_id FROM "o6a13e2c574d5a"."tbl_project_product_types" WHERE "project_id"=1

[+] Explain
11:58:47.6420.2 msSELECTSELECT * FROM "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" WHERE "object_id"=1

[+] Explain
11:58:47.6430.3 msSELECTSELECT "id", "id" AS "key", "name", "description" FROM "o6a13e2c574d5a"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (61, 162, 2100000000, 71, 93)) ORDER BY "sort"

[+] Explain
11:58:47.6430.2 msSELECTSELECT * FROM "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" WHERE "object_id"=1

[+] Explain
11:58:47.6430.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_term_taxonomies" WHERE ("term_id"=10) AND ("id" IN (61, 162, 2100000000, 71, 93)) ORDER BY "sort"

[+] Explain
11:58:47.6440.2 msSELECTSELECT * FROM "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" WHERE "object_id"=1

[+] Explain
11:58:47.6440.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (61, 162, 2100000000, 71, 93)) ORDER BY "sort"

[+] Explain
11:58:47.6450.2 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493

[+] Explain
11:58:47.6450.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5493)

[+] Explain
11:58:47.6450.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_departments" WHERE "id"=1

[+] Explain
11:58:47.6460.2 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5495

[+] Explain
11:58:47.6460.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5495)

[+] Explain
11:58:47.6460.4 msSELECTSELECT * FROM "o6a13e2c574d5a"."tbl_clients" WHERE "id"=1

[+] Explain
11:58:47.6470.2 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493

[+] Explain
11:58:47.6470.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5493)

[+] Explain
11:58:47.6480.9 msSELECTSELECT "c"."project_id", sum(ca.points) as points FROM "o6a13e2c574d5a"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", sum(points) as points FROM "o6a13e2c574d5a"."tbl_case_assignments" GROUP BY "case_id") "ca" ON ca.case_id = c.id WHERE "c"."project_id"=1 GROUP BY "c"."project_id"

[+] Explain
11:58:47.6490.6 msSELECTSELECT "project_id", count(id) as count FROM "o6a13e2c574d5a"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("project_id"=1) GROUP BY "project_id"

[+] Explain
11:58:47.6500.2 msSELECTSELECT "project_id", count(id) as count FROM "o6a13e2c574d5a"."tbl_cases" WHERE "project_id"=1 GROUP BY "project_id"

[+] Explain
11:58:47.6500.4 msSELECTSELECT "project_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "o6a13e2c574d5a"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=1) AND (("location_in_id" IS NOT NULL) AND ("location_out_id" IS NOT NULL) AND ("client_id" IS NOT NULL)) AND ("project_id"=1) GROUP BY "project_id"

[+] Explain
11:58:47.6511.0 msSELECTSELECT "c"."project_id", sum(hours), sum(times) as times FROM "o6a13e2c574d5a"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(left_at - arrived_at)) /3600 AS hours, count(id) as times FROM "o6a13e2c574d5a"."tbl_implement_records" WHERE "is_draft"=FALSE GROUP BY "case_id") "i" ON i.case_id = c.id WHERE ("case_type"=2) AND ("c"."project_id"=1) GROUP BY "c"."project_id"

[+] Explain
11:58:47.6520.9 msSELECTSELECT "c"."project_id", sum(hours), sum(times) as times FROM "o6a13e2c574d5a"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "o6a13e2c574d5a"."tbl_pre_sales" WHERE "is_draft"=FALSE GROUP BY "case_id") "i" ON i.case_id = c.id WHERE ("case_type"=1) AND ("c"."project_id"=1) GROUP BY "c"."project_id"

[+] Explain
11:58:47.6530.4 msSELECTSELECT "project_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "o6a13e2c574d5a"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=2) AND ("project_id"=1) GROUP BY "project_id"

[+] Explain
11:58:47.6530.3 msSELECTSELECT "project_id", sum(amount) AS sum FROM "o6a13e2c574d5a"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("project_id"=1) GROUP BY "project_id"

[+] Explain
11:58:47.6540.7 msSELECTSELECT "id", "from_project", "payment_collection_remind_ahead", "serial_no", "is_settle", "is_deliver", "is_outbound", "erp_settle_amount", "erp_un_settle_amount", "including_tax", "amount" FROM "o6a13e2c574d5a"."tbl_sales_contracts" WHERE "from_project"=1

[+] Explain
11:58:47.6631.0 msSELECTSELECT * FROM "o6a13e2c574d5a"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id"=8)

[+] Explain
11:58:47.6651.7 msSELECTSELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "o6a13e2c574d5a"."tbl_attachments" WHERE "id"=2

[+] Explain
11:58:47.6670.2 msSELECTSELECT * FROM "o6a13e2c574d5a"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id"=8)

[+] Explain
11:58:47.6670.2 msSELECTSELECT * FROM "o6a13e2c574d5a"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id"=8)

[+] Explain
11:58:47.6670.7 msSELECTSELECT * FROM "o6a13e2c574d5a"."tbl_erp_collect_tickets" WHERE ("status"=2) AND ("sales_contract_id"=8) ORDER BY "id" DESC

[+] Explain
11:58:47.6686.8 msSELECTSELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "created_by", "collected_date" FROM (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.wrote_date as collected_date, t.created_at, t.created_by, t.abstract as description FROM "o6a13e2c574d5a"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "o6a13e2c574d5a"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "o6a13e2c574d5a"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) )) "sub") "r" WHERE "contract_id"=8 ORDER BY "id" DESC

[+] Explain
11:58:47.6750.6 msSELECTSELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date" FROM "o6a13e2c574d5a"."tbl_sales_contract_invoices" WHERE "contract_id"=8 ORDER BY "id"

[+] Explain
11:58:47.6761.6 msSELECTSELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days", "status", "remind_date" FROM "o6a13e2c574d5a"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=8 ORDER BY "remind_date"

[+] Explain
11:58:47.6781.5 msSELECTSELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "o6a13e2c574d5a"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id"=8

[+] Explain
11:58:47.6790.3 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493

[+] Explain
11:58:47.6800.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5493)

[+] Explain
11:58:47.6800.9 msSELECTSELECT * FROM "o6a13e2c574d5a"."tbl_sales_supplier_rels" WHERE "contract_id"=8

[+] Explain
11:58:47.6810.2 msSELECTSELECT "id", "user_id", "user_id" AS "key", "project_id" FROM "o6a13e2c574d5a"."tbl_project_remind_receivers" WHERE "project_id"=1

[+] Explain
11:58:47.6821.6 msSELECTSELECT * FROM "o6a13e2c574d5a"."tbl_project_product_rels" WHERE "project_id"=1 ORDER BY "id"

[+] Explain
11:58:47.6861.2 msSELECTSELECT * FROM "o6a13e2c574d5a"."tbl_products" WHERE "id"=1

[+] Explain
11:58:47.6907.1 msSELECTSELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_types" WHERE "id"=1

[+] Explain
11:58:47.6972.8 msSELECTSELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_components" WHERE "id"=1

[+] Explain
11:58:47.7001.6 msSELECTSELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_brands" WHERE "id"=1

[+] Explain
11:58:47.7022.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_series" WHERE "id"=1

[+] Explain
11:58:47.7044.8 msSELECTSELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_order_products" WHERE "id"=1

[+] Explain
11:58:47.7090.3 msSELECTSELECT "object_id", count(*) as comment FROM "o6a13e2c574d5a"."tbl_comments" WHERE ("object_type"=1) AND ("object_id"=1) GROUP BY "object_id"

[+] Explain
11:58:47.7100.3 msSELECTSELECT "object_id", count(*) AS unread FROM "o6a13e2c574d5a"."tbl_unread_comments" WHERE ("object_type"=1) AND (remind_user_id = 5495 AND is_read = false) AND ("object_id"=1) GROUP BY "object_id"

[+] Explain
11:58:47.7106.7 msSELECTSELECT * FROM "o6a13e2c574d5a"."tbl_project_contact_points" WHERE "project_id"=1

[+] Explain
11:58:47.7171.4 msSELECTSELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id"=1)

[+] Explain
11:58:47.7191.1 msSELECTSELECT * FROM "o6a13e2c574d5a"."tbl_project_used_clients" WHERE "project_id"=1

[+] Explain
11:58:47.7200.4 msSELECTSELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_orders" WHERE ("status"=1) AND ("project_id"=1)

[+] Explain
11:58:47.7211.1 msSELECTSELECT s.id, project_id, client_id, schedule_title, complete_at, start_at, end_at, created_by, is_complete, is_closed, complete_description, set_top_at, CASE WHEN is_complete = true THEN 3 WHEN is_complete = false AND end_at <= NOW() THEN 2 ELSE 1 END AS sort FROM "o6a13e2c574d5a"."tbl_schedules" "s" LEFT JOIN "o6a13e2c574d5a"."tbl_schedule_carbon_copy_rels" "ccr" ON ccr.schedule_id = s.id WHERE (("is_complete"=FALSE) OR ("complete_at" >= '2026-05-18')) AND ((("is_public"=1) AND ("created_by" != 5495)) OR ("created_by"=5495) OR ("ccr"."user_id"=5495)) AND ("s"."project_id"=1) ORDER BY set_top_at DESC nulls last, sort ASC, CASE WHEN is_complete = true THEN complete_at END DESC, CASE WHEN is_complete = false THEN end_at END ASC, end_at DESC

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

[+] Explain
11:58:47.7241.5 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/of-client', '{"id":"1","page":"1","web_access_token":"7CCP7jMsjjSDfF61luGGB1mxLPdASSzl"}', '{"code":2000,"result":{"list":[{"id":1,"client_id":1,"project_status":3,"project_progress":6,"budget":"10000","profit_pct":"60","bargain_date":"2026-05-27","description":"","created_by":5493,"created_at":"2026-05-27 17:25:00","updated_at":"2026-05-27 17:32:47","engineer_id":"","project_title":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260527001","collected":"0","status_updated_at":"2026-05-27 17:26:48.428905+08","success_rate":"","comment":"\u6d4b\u8bd5\u9500\u552e\u5408\u540c\u64cd\u4f5c","contract_type":1,"progress_updated_at":"2026-05-27 17:26:48.428905+08","forecast_updated_at":"2026-05-27 17:26:48.428905+08","end_at":"","pinyin_shortcut":"xsxssc20260527001","creator":5495,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1,"is_sales_order_ready":false,"collected_plan":10000,"change_status_to":"","is_verify":false,"profits":"6000.0000000000000000","remain":"4 days 18:31:59.188903","progress_remain":"4 days 18:31:59.188903","forecast_remain":"4 days 18:31:59.188903","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"4 days 18:33:47.16478","issued_invoices":"","client":{"id":1,"key":1,"name":"\u903b\u8f91\u6d4b\u8bd5-\u9500\u552e\u5408\u540c","logo":"","client_type":1,"client_class":1,"client_industry":20,"sales_rep":5493,"salesRep":{"id":5493,"key":5493,"name":"97289742","sex":"M","avatar":{}},"clientType":{"id":1,"key":1,"name":"\u6700\u7ec8\u7528\u6237"},"clientClass":{"id":1,"key":1,"name":"A\u7ea7\u5ba2\u6237","notice_days":10,"color":"#D2456D"},"clientIndustry":{"id":20,"key":20,"name":"\u5176\u4ed6"}},"usedClient":{},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":6,"key":6,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002\n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u7248\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectProductTypes":[{"id":1,"product_type_id":1,"key":1,"name":"\u9632\u706b\u5899","budget":"10000","pct":"60","profit":"6000","project_id":1}],"salesForecast":{"id":93,"key":93,"name":"\u786e\u4fdd","description":"100%\u786e\u8ba4\u5728\u6210\u4ea4\u65e5\u671f\u5185\u7b7e\u8ba2\u5408\u540c\u3002"},"opportunityFrom":{},"purchaseType":{"id":71,"key":71,"name":"\u516c\u5f00\u62db\u6807"},"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":{},"department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"projectCreator":{"id":5495,"key":5495,"name":"\u903b\u8f91\u6d4b\u8bd5","sex":"F","department_id":4,"avatar":{}},"salesRep":{"id":5493,"key":5493,"name":"97289742","sex":"M","avatar":{}},"casePoints":"","workLogCount":"","caseCount":"","salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":8,"from_project":1,"payment_collection_remind_ahead":"1 day","serial_no":"2026-05-27-001","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"0","erp_un_settle_amount":"10000","including_tax":true,"amount":"10000","contractScans":[{"id":2,"object_type":105,"object_id":8,"attachment_id":2,"attachment":{"id":2,"key":2,"name":"10371908-0ac1-3197-94f5-c0abebff10f3","extension":"pdf","path":"\/vue\/attachment\/preview\/10371908-0ac1-3197-94f5-c0abebff10f3\/\u91d1\u7545\u900d\u4f7f\u7528\u6d41\u7a0b\u56fe.pdf","orig_name":"\u91d1\u7545\u900d\u4f7f\u7528\u6d41\u7a0b\u56fe.pdf"}}],"receiptScans":[],"verifyScans":[],"erpCollectTickets":[],"salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":1,"key":1,"contract_id":8,"name":"2026-05-29","value":"10000","overdue_days":3,"status":0,"remind_date":"2026-05-29","pct":100,"overdue_display":"\u903e\u671f3\u5929"}],"salesContractPaymentCollectionRemindReceivers":[{"id":1,"user_id":5493,"key":5493,"contract_id":8,"user":{"id":5493,"key":5493,"name":"97289742","sex":"M","avatar":{}}}],"salesSupplierRels":[],"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","invoiced":0},"projectRemindReceivers":[],"projectProductRels":[{"id":2,"project_id":1,"product_id":1,"amount":"10000","number":1,"cost":"","description":"","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"10000","total_cost":"","erp_sales_order_product_id":1,"supplier":"","product":{"id":1,"name":"\u6df1\u4fe1\u670d AF-1210-A","product_type":1,"product_component":1,"product_brand":1,"product_serie":1,"product_misc":"","product_qa":"","pn":"","description":"","created_by":5493,"created_at":"2026-05-25 13:48:53","updated_at":"2026-05-27 16:44:31","pinyin_shortcut":"","product_unit":"","is_renew":false,"in_out_at":"2026-05-27 16:44:31.392118+08","productType":{"id":1,"key":1,"name":"\u9632\u706b\u5899"},"productComponent":{"id":1,"key":1,"name":"\u786c\u4ef6\u4e3b\u673a"},"productBrand":{"id":1,"key":1,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1,"key":1,"name":"\u6df1\u4fe1\u670dAF-1210"},"productUnit":{}},"erpSalesOrderProduct":{"id":1,"erp_sales_order_id":1,"erp_store_id":"","product_id":1,"description":"","number":"1","outbound":"0","amount":"10000","total_amount":"10000","last_number":"","last_amount":"","last_total_amount":"","cost":"","total_cost":"","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":""}}],"commentCount":{"object_id":1,"comment":1},"unreadComments":{},"fromContact":"","projectContactPoints":[],"erpSalesOrder":{"id":1,"serial_no":"XSDD-20260527-00001","from_date":"","wrote_date":"2026-05-27","handler":5493,"client_id":1,"purchase_contract_id":"","project_id":1,"sales_contract_id":8,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2026-05-27 17:26:48","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"1","amount":"10000","created_by":5493,"stop_description":"","extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5493\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2026-05-29\",\"amount\":\"10000\",\"pct\":\"100\"}]}","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-05-27 17:26:48","updated_at":"2026-05-27 17:26:48","print_times":""},"projectUsedClient":{},"erpSalesOrderVerify":{},"schedules":[],"is_only_cp":false,"remain_display":4,"progress_remain_display":4,"forecast_remain_display":4,"projectProductTotalAmount":10000,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":false,"projectProductTotalNumber":1,"unissued_invoice":10000,"is_exceeded":false,"can_update":false,"can_delete":false,"unread":0,"last_arrive_days_display":"","project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","can_invoice":false,"can_payment":false,"duration_display":4,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":false,"lost_contact_days_display":"","can_view_product":false,"budget_display":"10000","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"10000","un_invoiced":10000,"object_type":1,"can_view_product_cost":true}],"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,"pagenation":{"totalcount":1,"thispage":1,"pagesize":20}},"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 11:58:47', 120346112) RETURNING "id"

[+] Explain