ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a1ea0ec76edc: POST https://beta.jinchangxiao.com/vue/analysis/sales-payment-collection at 2026-06-02 05:22:52 pm by 221.216.117.119

Database Queries

总计12条数据
TimeDurationTypeQuery
  
17:22:52.4890.6 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

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

[+] Explain
17:22:52.4956.2 msSELECTSELECT COUNT(*) FROM (SELECT (sc.id::varchar || ( CASE WHEN scpcrds.id is not null THEN scpcrds.id::varchar ELSE ''::varchar END)) as id, sc.id as id2, sc.serial_no, sc.project_id, sc.client_id, sc.need_analysis, p.bargain_date, CASE WHEN scpcrds.id is not null THEN scpcrds.paid_amount ELSE sc.erp_settle_amount END as collected, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE null END as remind_date, CASE WHEN scpcrds.id is not null THEN scpcrds.amount ELSE sc.amount END as amount, CASE WHEN scpcrds.id is not null THEN scpcrds.status ELSE (CASE WHEN sc.erp_un_settle_amount != 0 THEN 0 ELSE 1 END) END as status, CASE WHEN scpcrds.id is not null THEN scpcrds.amount - scpcrds.paid_amount ELSE (CASE WHEN sc.need_analysis = true THEN sc.erp_un_settle_amount ELSE 0 END) END as uncollected, CASE WHEN scpcrds.id is not null AND scpcrds.remind_date <= '2026-06-02'THEN scpcrds.amount - scpcrds.paid_amount ELSE null END as overdue, sci.invoiced, scpcrds.overdue_days, tcollect.collected_count as collected_count, (sc.amount - sci.invoiced) as uninvoiced, CASE WHEN scpcrds.id is not null THEN (CASE WHEN (scpcrds.remind_date <= '2026-06-02' AND scpcrds.status = 0) OR scpcrds.overdue_days is not null THEN scpcrds.paid_amount ELSE null END) ELSE ovsub.amount END as overdue_collect_amount, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE sc.signed_at END as c_date FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN (SELECT t0.* FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "t1" ON t0.contract_id = t1.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON t1.from_project = p.id WHERE (t1.need_analysis = true) AND (t1.from_project is not null) AND (p.project_status = 3) GROUP BY "t0"."id") "scpcrds" ON scpcrds.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, CASE WHEN t0.including_tax = true THEN COALESCE(sum(t1.amount), 0) ELSE t0.amount END AS invoiced FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contract_invoices" "t1" ON t0.id = t1.contract_id WHERE t0.need_analysis = true GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.from_project = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS this_collected, count(t1.id) as collected_count FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN (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 "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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") "t1" ON t0.id = t1.contract_id GROUP BY "t0"."id") "tcollect" ON tcollect.contract_id = sc.id LEFT JOIN (SELECT t1.id, sum(t0.paid_amount) as amount FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "t1" ON t0.contract_id = t1.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON t1.from_project = p.id WHERE (t1.need_analysis = true) AND (t1.from_project is not null) AND (p.project_status = 3) AND (((t0.status = 1) AND (t0.overdue_days is not null)) OR ((t0.status = 0) AND ("t0"."remind_date" <= '2026-06-02'))) GROUP BY "t1"."id") "ovsub" ON ovsub.id = sc.id WHERE (("sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) AND ("c"."sales_rep"='1001') AND ("sc"."build_by_project"=TRUE) AND ("sgr"."group_id"='1') ORDER BY "c_date" DESC) "c"

[+] Explain
17:22:52.50115.5 msSELECTSELECT (sc.id::varchar || ( CASE WHEN scpcrds.id is not null THEN scpcrds.id::varchar ELSE ''::varchar END)) as id, sc.id as id2, sc.serial_no, sc.project_id, sc.client_id, sc.need_analysis, p.bargain_date, CASE WHEN scpcrds.id is not null THEN scpcrds.paid_amount ELSE sc.erp_settle_amount END as collected, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE null END as remind_date, CASE WHEN scpcrds.id is not null THEN scpcrds.amount ELSE sc.amount END as amount, CASE WHEN scpcrds.id is not null THEN scpcrds.status ELSE (CASE WHEN sc.erp_un_settle_amount != 0 THEN 0 ELSE 1 END) END as status, CASE WHEN scpcrds.id is not null THEN scpcrds.amount - scpcrds.paid_amount ELSE (CASE WHEN sc.need_analysis = true THEN sc.erp_un_settle_amount ELSE 0 END) END as uncollected, CASE WHEN scpcrds.id is not null AND scpcrds.remind_date <= '2026-06-02'THEN scpcrds.amount - scpcrds.paid_amount ELSE null END as overdue, sci.invoiced, scpcrds.overdue_days, tcollect.collected_count as collected_count, (sc.amount - sci.invoiced) as uninvoiced, CASE WHEN scpcrds.id is not null THEN (CASE WHEN (scpcrds.remind_date <= '2026-06-02' AND scpcrds.status = 0) OR scpcrds.overdue_days is not null THEN scpcrds.paid_amount ELSE null END) ELSE ovsub.amount END as overdue_collect_amount, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE sc.signed_at END as c_date FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN (SELECT t0.* FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "t1" ON t0.contract_id = t1.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON t1.from_project = p.id WHERE (t1.need_analysis = true) AND (t1.from_project is not null) AND (p.project_status = 3) GROUP BY "t0"."id") "scpcrds" ON scpcrds.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, CASE WHEN t0.including_tax = true THEN COALESCE(sum(t1.amount), 0) ELSE t0.amount END AS invoiced FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contract_invoices" "t1" ON t0.id = t1.contract_id WHERE t0.need_analysis = true GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.from_project = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS this_collected, count(t1.id) as collected_count FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN (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 "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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") "t1" ON t0.id = t1.contract_id GROUP BY "t0"."id") "tcollect" ON tcollect.contract_id = sc.id LEFT JOIN (SELECT t1.id, sum(t0.paid_amount) as amount FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "t1" ON t0.contract_id = t1.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON t1.from_project = p.id WHERE (t1.need_analysis = true) AND (t1.from_project is not null) AND (p.project_status = 3) AND (((t0.status = 1) AND (t0.overdue_days is not null)) OR ((t0.status = 0) AND ("t0"."remind_date" <= '2026-06-02'))) GROUP BY "t1"."id") "ovsub" ON ovsub.id = sc.id WHERE (("sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) AND ("c"."sales_rep"='1001') AND ("sc"."build_by_project"=TRUE) AND ("sgr"."group_id"='1') ORDER BY "c_date" DESC LIMIT 20 OFFSET 20

[+] Explain
17:22:52.5170.3 msSELECTSELECT "id", "id" AS "key", "project_title" AS "name", "bargain_date", "budget", "collected" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (4057, 3950, 4086, 4063, 3991, 4014, 4052, 3927, 3857, 3874, 3751, 3949, 3899, 3872, 3886, 3855, 3816)

[+] Explain
17:22:52.5180.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3427, 3389, 3301, 3429, 3286, 3426, 3364, 3377, 2553, 2845, 2545, 2117)

[+] Explain
17:22:52.5187.1 msSELECTSELECT sum(invoiced) as invoiced FROM (SELECT id2, max(invoiced) as invoiced FROM (SELECT (sc.id::varchar || ( CASE WHEN scpcrds.id is not null THEN scpcrds.id::varchar ELSE ''::varchar END)) as id, sc.id as id2, sc.serial_no, sc.project_id, sc.client_id, sc.need_analysis, p.bargain_date, CASE WHEN scpcrds.id is not null THEN scpcrds.paid_amount ELSE sc.erp_settle_amount END as collected, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE null END as remind_date, CASE WHEN scpcrds.id is not null THEN scpcrds.amount ELSE sc.amount END as amount, CASE WHEN scpcrds.id is not null THEN scpcrds.status ELSE (CASE WHEN sc.erp_un_settle_amount != 0 THEN 0 ELSE 1 END) END as status, CASE WHEN scpcrds.id is not null THEN scpcrds.amount - scpcrds.paid_amount ELSE (CASE WHEN sc.need_analysis = true THEN sc.erp_un_settle_amount ELSE 0 END) END as uncollected, CASE WHEN scpcrds.id is not null AND scpcrds.remind_date <= '2026-06-02'THEN scpcrds.amount - scpcrds.paid_amount ELSE null END as overdue, sci.invoiced, scpcrds.overdue_days, tcollect.collected_count as collected_count, (sc.amount - sci.invoiced) as uninvoiced, CASE WHEN scpcrds.id is not null THEN (CASE WHEN (scpcrds.remind_date <= '2026-06-02' AND scpcrds.status = 0) OR scpcrds.overdue_days is not null THEN scpcrds.paid_amount ELSE null END) ELSE ovsub.amount END as overdue_collect_amount, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE sc.signed_at END as c_date FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN (SELECT t0.* FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "t1" ON t0.contract_id = t1.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON t1.from_project = p.id WHERE (t1.need_analysis = true) AND (t1.from_project is not null) AND (p.project_status = 3) GROUP BY "t0"."id") "scpcrds" ON scpcrds.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, CASE WHEN t0.including_tax = true THEN COALESCE(sum(t1.amount), 0) ELSE t0.amount END AS invoiced FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contract_invoices" "t1" ON t0.id = t1.contract_id WHERE t0.need_analysis = true GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.from_project = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS this_collected, count(t1.id) as collected_count FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN (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 "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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") "t1" ON t0.id = t1.contract_id GROUP BY "t0"."id") "tcollect" ON tcollect.contract_id = sc.id LEFT JOIN (SELECT t1.id, sum(t0.paid_amount) as amount FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "t1" ON t0.contract_id = t1.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON t1.from_project = p.id WHERE (t1.need_analysis = true) AND (t1.from_project is not null) AND (p.project_status = 3) AND (((t0.status = 1) AND (t0.overdue_days is not null)) OR ((t0.status = 0) AND ("t0"."remind_date" <= '2026-06-02'))) GROUP BY "t1"."id") "ovsub" ON ovsub.id = sc.id WHERE (("sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) AND ("c"."sales_rep"='1001') AND ("sc"."build_by_project"=TRUE) AND ("sgr"."group_id"='1') ORDER BY "c_date" DESC) "sub" GROUP BY "id2") "sub"

[+] Explain
17:22:52.5264.8 msSELECTSELECT sum(case when sub.need_analysis = true THEN amount ELSE 0 END) as amount, sum(uncollected) as uncollected, sum(overdue) as overdue FROM (SELECT (sc.id::varchar || ( CASE WHEN scpcrds.id is not null THEN scpcrds.id::varchar ELSE ''::varchar END)) as id, sc.id as id2, sc.serial_no, sc.project_id, sc.client_id, sc.need_analysis, p.bargain_date, CASE WHEN scpcrds.id is not null THEN scpcrds.paid_amount ELSE sc.erp_settle_amount END as collected, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE null END as remind_date, CASE WHEN scpcrds.id is not null THEN scpcrds.amount ELSE sc.amount END as amount, CASE WHEN scpcrds.id is not null THEN scpcrds.status ELSE (CASE WHEN sc.erp_un_settle_amount != 0 THEN 0 ELSE 1 END) END as status, CASE WHEN scpcrds.id is not null THEN scpcrds.amount - scpcrds.paid_amount ELSE (CASE WHEN sc.need_analysis = true THEN sc.erp_un_settle_amount ELSE 0 END) END as uncollected, CASE WHEN scpcrds.id is not null AND scpcrds.remind_date <= '2026-06-02'THEN scpcrds.amount - scpcrds.paid_amount ELSE null END as overdue, sci.invoiced, scpcrds.overdue_days, tcollect.collected_count as collected_count, (sc.amount - sci.invoiced) as uninvoiced, CASE WHEN scpcrds.id is not null THEN (CASE WHEN (scpcrds.remind_date <= '2026-06-02' AND scpcrds.status = 0) OR scpcrds.overdue_days is not null THEN scpcrds.paid_amount ELSE null END) ELSE ovsub.amount END as overdue_collect_amount, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE sc.signed_at END as c_date FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN (SELECT t0.* FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "t1" ON t0.contract_id = t1.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON t1.from_project = p.id WHERE (t1.need_analysis = true) AND (t1.from_project is not null) AND (p.project_status = 3) GROUP BY "t0"."id") "scpcrds" ON scpcrds.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, CASE WHEN t0.including_tax = true THEN COALESCE(sum(t1.amount), 0) ELSE t0.amount END AS invoiced FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contract_invoices" "t1" ON t0.id = t1.contract_id WHERE t0.need_analysis = true GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.from_project = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS this_collected, count(t1.id) as collected_count FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN (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 "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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") "t1" ON t0.id = t1.contract_id GROUP BY "t0"."id") "tcollect" ON tcollect.contract_id = sc.id LEFT JOIN (SELECT t1.id, sum(t0.paid_amount) as amount FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "t1" ON t0.contract_id = t1.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON t1.from_project = p.id WHERE (t1.need_analysis = true) AND (t1.from_project is not null) AND (p.project_status = 3) AND (((t0.status = 1) AND (t0.overdue_days is not null)) OR ((t0.status = 0) AND ("t0"."remind_date" <= '2026-06-02'))) GROUP BY "t1"."id") "ovsub" ON ovsub.id = sc.id WHERE (("sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) AND ("c"."sales_rep"='1001') AND ("sc"."build_by_project"=TRUE) AND ("sgr"."group_id"='1') ORDER BY "c_date" DESC) "sub"

[+] Explain
17:22:52.5315.8 msSELECTSELECT sum(collected) as collected FROM (SELECT coalesce(scp.collected, 0) as collected FROM (SELECT (sc.id::varchar || ( CASE WHEN scpcrds.id is not null THEN scpcrds.id::varchar ELSE ''::varchar END)) as id, sc.id as id2, sc.serial_no, sc.project_id, sc.client_id, sc.need_analysis, p.bargain_date, CASE WHEN scpcrds.id is not null THEN scpcrds.paid_amount ELSE sc.erp_settle_amount END as collected, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE null END as remind_date, CASE WHEN scpcrds.id is not null THEN scpcrds.amount ELSE sc.amount END as amount, CASE WHEN scpcrds.id is not null THEN scpcrds.status ELSE (CASE WHEN sc.erp_un_settle_amount != 0 THEN 0 ELSE 1 END) END as status, CASE WHEN scpcrds.id is not null THEN scpcrds.amount - scpcrds.paid_amount ELSE (CASE WHEN sc.need_analysis = true THEN sc.erp_un_settle_amount ELSE 0 END) END as uncollected, CASE WHEN scpcrds.id is not null AND scpcrds.remind_date <= '2026-06-02'THEN scpcrds.amount - scpcrds.paid_amount ELSE null END as overdue, sci.invoiced, scpcrds.overdue_days, tcollect.collected_count as collected_count, (sc.amount - sci.invoiced) as uninvoiced, CASE WHEN scpcrds.id is not null THEN (CASE WHEN (scpcrds.remind_date <= '2026-06-02' AND scpcrds.status = 0) OR scpcrds.overdue_days is not null THEN scpcrds.paid_amount ELSE null END) ELSE ovsub.amount END as overdue_collect_amount, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE sc.signed_at END as c_date FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN (SELECT t0.* FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "t1" ON t0.contract_id = t1.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON t1.from_project = p.id WHERE (t1.need_analysis = true) AND (t1.from_project is not null) AND (p.project_status = 3) GROUP BY "t0"."id") "scpcrds" ON scpcrds.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, CASE WHEN t0.including_tax = true THEN COALESCE(sum(t1.amount), 0) ELSE t0.amount END AS invoiced FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contract_invoices" "t1" ON t0.id = t1.contract_id WHERE t0.need_analysis = true GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.from_project = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS this_collected, count(t1.id) as collected_count FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN (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 "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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") "t1" ON t0.id = t1.contract_id GROUP BY "t0"."id") "tcollect" ON tcollect.contract_id = sc.id LEFT JOIN (SELECT t1.id, sum(t0.paid_amount) as amount FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "t1" ON t0.contract_id = t1.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON t1.from_project = p.id WHERE (t1.need_analysis = true) AND (t1.from_project is not null) AND (p.project_status = 3) AND (((t0.status = 1) AND (t0.overdue_days is not null)) OR ((t0.status = 0) AND ("t0"."remind_date" <= '2026-06-02'))) GROUP BY "t1"."id") "ovsub" ON ovsub.id = sc.id WHERE (("sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) AND ("c"."sales_rep"='1001') AND ("sc"."build_by_project"=TRUE) AND ("sgr"."group_id"='1') ORDER BY "c_date" DESC) "sc" LEFT JOIN (SELECT "id" AS "contract_id", "erp_settle_amount" AS "collected" FROM "a57be577deb434"."tbl_sales_contracts" GROUP BY "id") "scp" ON scp.contract_id = sc.id2 WHERE "sc"."need_analysis"=FALSE GROUP BY "sc"."id2", "scp"."collected") "sub"

[+] Explain
17:22:52.5374.9 msSELECTSELECT sum(case when need_analysis = true THEN amount ELSE 0 END) as amount, sum(collected) as collected, sum(uncollected) as uncollected, sum(overdue) as overdue FROM (SELECT (sc.id::varchar || ( CASE WHEN scpcrds.id is not null THEN scpcrds.id::varchar ELSE ''::varchar END)) as id, sc.id as id2, sc.serial_no, sc.project_id, sc.client_id, sc.need_analysis, p.bargain_date, CASE WHEN scpcrds.id is not null THEN scpcrds.paid_amount ELSE sc.erp_settle_amount END as collected, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE null END as remind_date, CASE WHEN scpcrds.id is not null THEN scpcrds.amount ELSE sc.amount END as amount, CASE WHEN scpcrds.id is not null THEN scpcrds.status ELSE (CASE WHEN sc.erp_un_settle_amount != 0 THEN 0 ELSE 1 END) END as status, CASE WHEN scpcrds.id is not null THEN scpcrds.amount - scpcrds.paid_amount ELSE (CASE WHEN sc.need_analysis = true THEN sc.erp_un_settle_amount ELSE 0 END) END as uncollected, CASE WHEN scpcrds.id is not null AND scpcrds.remind_date <= '2026-06-02'THEN scpcrds.amount - scpcrds.paid_amount ELSE null END as overdue, sci.invoiced, scpcrds.overdue_days, tcollect.collected_count as collected_count, (sc.amount - sci.invoiced) as uninvoiced, CASE WHEN scpcrds.id is not null THEN (CASE WHEN (scpcrds.remind_date <= '2026-06-02' AND scpcrds.status = 0) OR scpcrds.overdue_days is not null THEN scpcrds.paid_amount ELSE null END) ELSE ovsub.amount END as overdue_collect_amount, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE sc.signed_at END as c_date FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN (SELECT t0.* FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "t1" ON t0.contract_id = t1.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON t1.from_project = p.id WHERE (t1.need_analysis = true) AND (t1.from_project is not null) AND (p.project_status = 3) GROUP BY "t0"."id") "scpcrds" ON scpcrds.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, CASE WHEN t0.including_tax = true THEN COALESCE(sum(t1.amount), 0) ELSE t0.amount END AS invoiced FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contract_invoices" "t1" ON t0.id = t1.contract_id WHERE t0.need_analysis = true GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.from_project = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS this_collected, count(t1.id) as collected_count FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN (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 "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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") "t1" ON t0.id = t1.contract_id GROUP BY "t0"."id") "tcollect" ON tcollect.contract_id = sc.id LEFT JOIN (SELECT t1.id, sum(t0.paid_amount) as amount FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "t1" ON t0.contract_id = t1.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON t1.from_project = p.id WHERE (t1.need_analysis = true) AND (t1.from_project is not null) AND (p.project_status = 3) AND (((t0.status = 1) AND (t0.overdue_days is not null)) OR ((t0.status = 0) AND ("t0"."remind_date" <= '2026-06-02'))) GROUP BY "t1"."id") "ovsub" ON ovsub.id = sc.id WHERE (("sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) AND ("c"."sales_rep"='1001') AND ("sc"."build_by_project"=TRUE) AND ("sgr"."group_id"='1') ORDER BY "c_date" DESC) "sub"

[+] Explain
17:22:52.5439.7 msSELECTSELECT sum(collected) as collected, count(distinct client_id) as client_count, sum(collected_count) as collected_count, sum(overdue_collect_amount) as overdue FROM (SELECT (sc.id::varchar || ( CASE WHEN scpcrds.id is not null THEN scpcrds.id::varchar ELSE ''::varchar END)) as id, sc.id as id2, sc.serial_no, sc.project_id, sc.client_id, sc.need_analysis, p.bargain_date, CASE WHEN scpcrds.id is not null THEN scpcrds.paid_amount ELSE sc.erp_settle_amount END as collected, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE null END as remind_date, CASE WHEN scpcrds.id is not null THEN scpcrds.amount ELSE sc.amount END as amount, CASE WHEN scpcrds.id is not null THEN scpcrds.status ELSE (CASE WHEN sc.erp_un_settle_amount != 0 THEN 0 ELSE 1 END) END as status, CASE WHEN scpcrds.id is not null THEN scpcrds.amount - scpcrds.paid_amount ELSE (CASE WHEN sc.need_analysis = true THEN sc.erp_un_settle_amount ELSE 0 END) END as uncollected, CASE WHEN scpcrds.id is not null AND scpcrds.remind_date <= '2026-06-02'THEN scpcrds.amount - scpcrds.paid_amount ELSE null END as overdue, sci.invoiced, scpcrds.overdue_days, tcollect.collected_count as collected_count, (sc.amount - sci.invoiced) as uninvoiced, CASE WHEN scpcrds.id is not null THEN (CASE WHEN (scpcrds.remind_date <= '2026-06-02' AND scpcrds.status = 0) OR scpcrds.overdue_days is not null THEN scpcrds.paid_amount ELSE null END) ELSE ovsub.amount END as overdue_collect_amount, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE sc.signed_at END as c_date FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN (SELECT t0.* FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "t1" ON t0.contract_id = t1.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON t1.from_project = p.id WHERE (t1.need_analysis = true) AND (t1.from_project is not null) AND (p.project_status = 3) GROUP BY "t0"."id") "scpcrds" ON scpcrds.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, CASE WHEN t0.including_tax = true THEN COALESCE(sum(t1.amount), 0) ELSE t0.amount END AS invoiced FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contract_invoices" "t1" ON t0.id = t1.contract_id WHERE t0.need_analysis = true GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.from_project = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS this_collected, count(t1.id) as collected_count FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN (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 "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."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") "t1" ON t0.id = t1.contract_id GROUP BY "t0"."id") "tcollect" ON tcollect.contract_id = sc.id LEFT JOIN (SELECT t1.id, sum(t0.paid_amount) as amount FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "t1" ON t0.contract_id = t1.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON t1.from_project = p.id WHERE (t1.need_analysis = true) AND (t1.from_project is not null) AND (p.project_status = 3) AND (((t0.status = 1) AND (t0.overdue_days is not null)) OR ((t0.status = 0) AND ("t0"."remind_date" <= '2026-06-02'))) GROUP BY "t1"."id") "ovsub" ON ovsub.id = sc.id WHERE (("sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) AND ("c"."sales_rep"='1001') AND ("sc"."build_by_project"=TRUE) AND ("sgr"."group_id"='1') ORDER BY "c_date" DESC) "sub"

[+] Explain
17:22:52.5531.7 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/analysis/sales-payment-collection', '{"status":"","period":"","to":"","from":"","is_paid":"0","dataUserId":"1001","group":"1","page":"2","web_access_token":"RxNsgwK6AoRe247CZ3IJbk6VpAgcDvb0"}', '{"code":2000,"result":{"list":[{"id":4285,"id2":4285,"serial_no":"DM0020255590473","project_id":4057,"client_id":3427,"need_analysis":true,"bargain_date":"2025-11-26","collected":"28060.4","remind_date":"2026-01-04","amount":"28060.4","status":1,"uncollected":"0.0","overdue":"0.0","invoiced":"28060.40","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2026-01-04","project":{"id":4057,"key":4057,"name":"\u9632\u706b\u5899AF-2020\u4ea7\u54c1\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6\u91c7\u8d2d\u9879\u76ee","bargain_date":"2025-11-26","budget":"28060.4","collected":"28060.4"},"client":{"id":3427,"key":3427,"name":"\u4e2d\u592e\u5ba3\u4f20\u90e8\u7535\u5f71\u6570\u5b57\u8282\u76ee\u7ba1\u7406\u4e2d\u5fc3"},"overdue_display":"","overdue_amount":"0.0"},{"id":4144,"id2":4144,"serial_no":"ZZBRS20252516","project_id":3950,"client_id":3389,"need_analysis":true,"bargain_date":"2025-09-05","collected":"0","remind_date":"2025-12-31","amount":"90000","status":0,"uncollected":"90000","overdue":"90000","invoiced":"270000.00","overdue_days":153,"collected_count":2,"uninvoiced":"0.00","overdue_collect_amount":"0","c_date":"2025-12-31","project":{"id":3950,"key":3950,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899AF-1000-FH2300B","bargain_date":"2025-09-05","budget":"270000","collected":"180000"},"client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"overdue_display":"\u903e\u671f153\u5929","overdue_amount":"90000"},{"id":4349,"id2":4349,"serial_no":"Jrsbht2025169","project_id":4086,"client_id":3301,"need_analysis":true,"bargain_date":"2025-12-26","collected":"37500","remind_date":"2025-12-31","amount":"37500","status":1,"uncollected":"0","overdue":"0","invoiced":"37500.00","overdue_days":5,"collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"37500","c_date":"2025-12-31","project":{"id":4086,"key":4086,"name":"\u5b89\u5168\u68c0\u6d4b\u4e0e\u54cd\u5e94\u5e73\u53f0\u53ca\u670d\u52a1\u9879\u76ee","bargain_date":"2025-12-26","budget":"37500","collected":"37500"},"client":{"id":3301,"key":3301,"name":"\u91d1\u878d\u65f6\u62a5\u793e"},"overdue_display":"\u903e\u671f5\u5929","overdue_amount":"0"},{"id":4291,"id2":4291,"serial_no":"2025-12-08-001","project_id":4063,"client_id":3429,"need_analysis":true,"bargain_date":"2025-11-28","collected":"3587784","remind_date":"2025-12-25","amount":"3587784","status":1,"uncollected":"0","overdue":"0","invoiced":"3587784.00","overdue_days":14,"collected_count":2,"uninvoiced":"0.00","overdue_collect_amount":"3587784","c_date":"2025-12-25","project":{"id":4063,"key":4063,"name":"\u8fdc\u9274 \u667a\u80fd\u8bed\u97f3\u5173\u952e\u8bcd\u8bc6\u522b\u7cfb\u7edf\u91c7\u4e70\u9879\u76ee","bargain_date":"2025-11-28","budget":"3587784","collected":"3587784"},"client":{"id":3429,"key":3429,"name":"\u5e7f\u5dde\u4e16\u5b89\u4fe1\u606f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"overdue_display":"\u903e\u671f14\u5929","overdue_amount":"0"},{"id":4248,"id2":4248,"serial_no":"Jrsbht2025126","project_id":3991,"client_id":3301,"need_analysis":true,"bargain_date":"2025-11-19","collected":"13500","remind_date":"2025-12-20","amount":"13500","status":1,"uncollected":"0","overdue":"0","invoiced":"13500.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2025-12-20","project":{"id":3991,"key":3991,"name":"AC-1000 D600\u8bbe\u5907\u7ef4\u4fdd","bargain_date":"2025-11-19","budget":"13500","collected":"13500"},"client":{"id":3301,"key":3301,"name":"\u91d1\u878d\u65f6\u62a5\u793e"},"overdue_display":"","overdue_amount":"0"},{"id":4235,"id2":4235,"serial_no":"PO2501256","project_id":4014,"client_id":3286,"need_analysis":true,"bargain_date":"2025-11-06","collected":"183179.99","remind_date":"2025-12-13","amount":"183179.99","status":1,"uncollected":"0.00","overdue":"0.00","invoiced":"183179.99","overdue_days":3,"collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"183179.99","c_date":"2025-12-13","project":{"id":4014,"key":4014,"name":"\uff08\u897f\u4e91\u6570\u636e\uff09PA VM\u8f6f\u4ef6\u4ea7\u54c1\u7eed\u4fdd\u9879\u76ee","bargain_date":"2025-11-06","budget":"183179.99","collected":"183179.99"},"client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"overdue_display":"\u903e\u671f3\u5929","overdue_amount":"0.00"},{"id":4257,"id2":4257,"serial_no":"TS-LRC-2025103001","project_id":4052,"client_id":3426,"need_analysis":true,"bargain_date":"2025-11-24","collected":"6000","remind_date":"2025-11-24","amount":"6000","status":1,"uncollected":"0","overdue":"0","invoiced":"6000.00","overdue_days":0,"collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"6000","c_date":"2025-11-24","project":{"id":4052,"key":4052,"name":"\u91d1\u7545\u900d\u8f6f\u4ef6\u670d\u52a1\u91c7\u8d2d\u9879\u76ee","bargain_date":"2025-11-24","budget":"6000","collected":"6000"},"client":{"id":3426,"key":3426,"name":"\u6df1\u5733\u5e02\u4fe1\u548c\u9886\u521b\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"overdue_display":"\u903e\u671f0\u5929","overdue_amount":"0"},{"id":4144,"id2":4144,"serial_no":"ZZBRS20252516","project_id":3950,"client_id":3389,"need_analysis":true,"bargain_date":"2025-09-05","collected":"90000","remind_date":"2025-10-17","amount":"90000","status":1,"uncollected":"0","overdue":"0","invoiced":"270000.00","overdue_days":39,"collected_count":2,"uninvoiced":"0.00","overdue_collect_amount":"90000","c_date":"2025-10-17","project":{"id":3950,"key":3950,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899AF-1000-FH2300B","bargain_date":"2025-09-05","budget":"270000","collected":"180000"},"client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"overdue_display":"\u903e\u671f39\u5929","overdue_amount":"0"},{"id":4112,"id2":4112,"serial_no":"PO2500925\/PO2500926","project_id":3927,"client_id":3286,"need_analysis":true,"bargain_date":"2025-08-22","collected":"42448","remind_date":"2025-10-09","amount":"42448","status":1,"uncollected":"0","overdue":"0","invoiced":"42448.00","overdue_days":4,"collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"42448","c_date":"2025-10-09","project":{"id":3927,"key":3927,"name":"PA VM\u9632\u706b\u5899\u7ef4\u4fdd\u7eed\u7ea6","bargain_date":"2025-08-22","budget":"42448","collected":"42448"},"client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"overdue_display":"\u903e\u671f4\u5929","overdue_amount":"0"},{"id":3916,"id2":3916,"serial_no":"TS-LRC-20250514002","project_id":3857,"client_id":3364,"need_analysis":true,"bargain_date":"2025-05-19","collected":"570000","remind_date":"2025-09-30","amount":"570000","status":1,"uncollected":"0","overdue":"0","invoiced":"570000.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2025-09-30","project":{"id":3857,"key":3857,"name":"PA1410 \u4e09\u5e74\u670d\u52a13\u53f0\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee","bargain_date":"2025-05-19","budget":"570000","collected":"570000"},"client":{"id":3364,"key":3364,"name":"\u5317\u4eac\u6781\u901a\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"overdue_display":"","overdue_amount":"0"},{"id":4016,"id2":4016,"serial_no":"2025\/BJ262\/BJBJ2025-1191","project_id":3874,"client_id":3377,"need_analysis":true,"bargain_date":"2025-06-27","collected":"228000","remind_date":"2025-09-30","amount":"228000","status":1,"uncollected":"0","overdue":"0","invoiced":"228000.00","overdue_days":"","collected_count":3,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2025-09-30","project":{"id":3874,"key":3874,"name":"ZStack\u4e91\u4ea7\u54c1\uff08\u7518\u674e\u836f\u4e1a\uff09\u91c7\u8d2d\u9879\u76ee","bargain_date":"2025-06-27","budget":"228000","collected":"228000"},"client":{"id":3377,"key":3377,"name":"\u5317\u4eac\u5a01\u53d1\u65b0\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"overdue_display":"","overdue_amount":"0"},{"id":4144,"id2":4144,"serial_no":"ZZBRS20252516","project_id":3950,"client_id":3389,"need_analysis":true,"bargain_date":"2025-09-05","collected":"90000","remind_date":"2025-09-19","amount":"90000","status":1,"uncollected":"0","overdue":"0","invoiced":"270000.00","overdue_days":"","collected_count":2,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2025-09-19","project":{"id":3950,"key":3950,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899AF-1000-FH2300B","bargain_date":"2025-09-05","budget":"270000","collected":"180000"},"client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"overdue_display":"","overdue_amount":"0"},{"id":4055,"id2":4055,"serial_no":"W-KJ-CG-KXMTYB-20250729-01","project_id":3751,"client_id":2553,"need_analysis":true,"bargain_date":"2025-07-21","collected":"177060","remind_date":"2025-09-12","amount":"177060","status":1,"uncollected":"0","overdue":"0","invoiced":"885300.00","overdue_days":42,"collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"177060","c_date":"2025-09-12","project":{"id":3751,"key":3751,"name":"10\u53f0 PA445 \u8bbe\u5907\u91c7\u8d2d\u9879\u76ee\uff08\u6c99\u7279\u9879\u76ee\uff09","bargain_date":"2025-07-21","budget":"885300","collected":"858740.72"},"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"},"overdue_display":"\u903e\u671f42\u5929","overdue_amount":"0"},{"id":4106,"id2":4106,"serial_no":"TS-LRC-2025081901","project_id":3949,"client_id":2845,"need_analysis":true,"bargain_date":"2025-08-19","collected":"15340","remind_date":"2025-09-05","amount":"15340","status":1,"uncollected":"0","overdue":"0","invoiced":"15340.00","overdue_days":3,"collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"15340","c_date":"2025-09-05","project":{"id":3949,"key":3949,"name":"PA1410\u4e00\u5e74\u670d\u52a1","bargain_date":"2025-08-19","budget":"15340","collected":"15340"},"client":{"id":2845,"key":2845,"name":"\u5317\u4eac\u6052\u6cf0\u901a\u529b\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08PA\u8fc7\u5355\uff09"},"overdue_display":"\u903e\u671f3\u5929","overdue_amount":"0"},{"id":4055,"id2":4055,"serial_no":"W-KJ-CG-KXMTYB-20250729-01","project_id":3751,"client_id":2553,"need_analysis":true,"bargain_date":"2025-07-21","collected":"619710","remind_date":"2025-08-22","amount":"619710","status":1,"uncollected":"0","overdue":"0","invoiced":"885300.00","overdue_days":63,"collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"619710","c_date":"2025-08-22","project":{"id":3751,"key":3751,"name":"10\u53f0 PA445 \u8bbe\u5907\u91c7\u8d2d\u9879\u76ee\uff08\u6c99\u7279\u9879\u76ee\uff09","bargain_date":"2025-07-21","budget":"885300","collected":"858740.72"},"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"},"overdue_display":"\u903e\u671f63\u5929","overdue_amount":"0"},{"id":3997,"id2":3997,"serial_no":"TS-LRC-20250624001","project_id":3899,"client_id":2545,"need_analysis":true,"bargain_date":"2025-06-24","collected":"8982","remind_date":"2025-07-01","amount":"8982","status":1,"uncollected":"0","overdue":"0","invoiced":"8982.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2025-07-01","project":{"id":3899,"key":3899,"name":"AF-1000-FH1300A\u9632\u706b\u5899\u4e00\u5e74\u7eed\u4fdd\u9879\u76ee","bargain_date":"2025-06-24","budget":"8982","collected":"8982"},"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8"},"overdue_display":"","overdue_amount":"0"},{"id":3935,"id2":3935,"serial_no":"TS-LRC-2025052801","project_id":3872,"client_id":2845,"need_analysis":true,"bargain_date":"2025-05-28","collected":"32557","remind_date":"2025-06-30","amount":"32557","status":1,"uncollected":"0","overdue":"0","invoiced":"32557.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2025-06-30","project":{"id":3872,"key":3872,"name":"PA1410 Bundle Lic\u91c7\u8d2d\u9879\u76ee","bargain_date":"2025-05-28","budget":"32557","collected":"32557"},"client":{"id":2845,"key":2845,"name":"\u5317\u4eac\u6052\u6cf0\u901a\u529b\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08PA\u8fc7\u5355\uff09"},"overdue_display":"","overdue_amount":"0"},{"id":3967,"id2":3967,"serial_no":"TSC-LRC-20250609001","project_id":3886,"client_id":2545,"need_analysis":true,"bargain_date":"2025-06-09","collected":"26550","remind_date":"2025-06-13","amount":"26550","status":1,"uncollected":"0","overdue":"0","invoiced":"26550.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2025-06-13","project":{"id":3886,"key":3886,"name":"SR650\u670d\u52a1\u5668\u914d\u4ef6\u91c7\u8d2d\u9879\u76ee","bargain_date":"2025-06-09","budget":"26550","collected":"26550"},"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8"},"overdue_display":"","overdue_amount":"0"},{"id":3900,"id2":3900,"serial_no":"TS-LRC-20250513001","project_id":3855,"client_id":2545,"need_analysis":true,"bargain_date":"2025-05-13","collected":"40630","remind_date":"2025-05-16","amount":"40630","status":1,"uncollected":"0","overdue":"0","invoiced":"40630.00","overdue_days":0,"collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"40630","c_date":"2025-05-16","project":{"id":3855,"key":3855,"name":"\u8054\u60f3SR650\u4e8c\u624b\u670d\u52a1\u5668\u91c7\u8d2d\u9879\u76ee\u56db","bargain_date":"2025-05-13","budget":"40630","collected":"40630"},"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8"},"overdue_display":"\u903e\u671f0\u5929","overdue_amount":"0"},{"id":3857,"id2":3857,"serial_no":"HM202205050407C","project_id":3816,"client_id":2117,"need_analysis":true,"bargain_date":"2025-04-07","collected":"3994","remind_date":"2025-04-08","amount":"3994","status":1,"uncollected":"0","overdue":"0","invoiced":"3994.00","overdue_days":0,"collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"3994","c_date":"2025-04-08","project":{"id":3816,"key":3816,"name":"\u5357\u975e\u7ea2\u77f3\u9879\u76ee\u6570\u636e\u7f51PA440\u8bbe\u5907\u7eed\u4fdd","bargain_date":"2025-04-07","budget":"3994","collected":"3994"},"client":{"id":2117,"key":2117,"name":"\u6c5f\u82cf\u9ed1\u9a6c\u9ad8\u79d1\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"overdue_display":"\u903e\u671f0\u5929","overdue_amount":"0"}],"count":{"amount":"53255613.23","uncollected":"15394519.06","overdue":"2104201.00","invoiced":"39981308.45","chargeback_amount":"2621953"},"count_days":{"amount":"53255613.23","collected":"40483047.17","uncollected":"15394519.06","overdue":"2104201.00","invoiced":"39981308.45"},"count_pay":{"collected":"40483047.17","client_count":58,"collected_count":"190","overdue":"18991935.81","invoiced":"39981308.45"},"pagenation":{"totalcount":145,"thispage":2,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-02 17:22:52', 65970176) RETURNING "id"

[+] Explain