ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a2a66339da5e: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-unit at 2026-06-11 03:39:31 pm by 221.216.117.119

Database Queries

总计7条数据
TimeDurationTypeQuery
  
15:39:31.6500.7 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=5064

[+] Explain
15:39:31.6530.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064

[+] Explain
15:39:31.65822.9 msSELECTSELECT COUNT(*) FROM (SELECT "sub".* FROM ((SELECT (s.id::varchar || 1::varchar) as key, s.id as client_id, null::integer as supplier_id, null::integer as user_id, null::integer as contact_id, s.sales_rep, s.name, s.pinyin_shortcut, '客户' as type_display, 'client' as type, s.created_at, s.updated_at, COALESCE(sum(un_collect_amount), 0) as un_collect_amount, COALESCE(sum(un_collect_count), 0) as un_collect_count, null::integer as un_payment_amount, null::integer as un_payment_count, COALESCE(sum(ap.un_paid_amount), 0) as ap_amount, COALESCE(sum(oc.amount - oc.settle_amount), 0) as oc_amount, COALESCE(sum(op.amount - op.settle_amount), 0) + COALESCE(sum(cos.amount - cos.settle_amount), 0) as op_amount, COALESCE(sum(un_collect_amount), 0) + COALESCE(sum(oc.amount - oc.settle_amount), 0) - COALESCE(sum(op.amount - op.settle_amount), 0) - COALESCE(sum(cos.amount - cos.settle_amount), 0) + COALESCE(sum(ap.un_paid_amount), 0) as amount FROM "a57be577deb434"."tbl_clients" "s" LEFT JOIN (SELECT t.supplier_id, t.client_id, sum(un_paid_amount) as un_paid_amount FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" "t" WHERE ("t"."status"=2) AND ("t"."is_payment_settle"=TRUE) GROUP BY "t"."supplier_id", "t"."client_id") "ap" ON ap.client_id = s.id LEFT JOIN (SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, sum(settle_amount) as settle_amount FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE "t"."status"=2 GROUP BY "t"."supplier_id", "t"."client_id", "t"."user_id", "t"."contact_id") "oc" ON oc.client_id = s.id LEFT JOIN (SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, sum(settle_amount) as settle_amount FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE "t"."status"=2 GROUP BY "t"."supplier_id", "t"."client_id", "t"."user_id", "t"."contact_id") "op" ON op.client_id = s.id LEFT JOIN (SELECT t.supplier_id, t.client_id, t.contact_id, sum(amount) as amount, sum(settle_amount) as settle_amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE "t"."status"=2 GROUP BY "t"."supplier_id", "t"."client_id", "t"."contact_id") "cos" ON cos.client_id = s.id LEFT JOIN (SELECT t.client_id, sum(erp_un_settle_amount) as un_collect_amount, count(*) as un_collect_count FROM "a57be577deb434"."tbl_sales_contracts" "t" WHERE ("t"."build_by_project"=TRUE) AND (t.client_id IS NOT NULL) AND (t.erp_un_settle_amount != 0) GROUP BY "t"."client_id") "sales_contract" ON sales_contract.client_id = s.id WHERE "deleted"=FALSE GROUP BY "s"."id") UNION ALL ( SELECT (s.id::varchar || 2::varchar) as key, null::integer as client_id, s.id as supplier_id, null::integer as user_id, null::integer as contact_id, null::integer as sales_rep, s.name, s.pinyin_shortcut, '供应商' as type_display, 'supplier' as type, s.created_at, s.updated_at, null::integer as un_collect_amount, null::integer as un_collect_count, COALESCE(sum(un_payment_amount), 0) as un_payment_amount, COALESCE(sum(un_payment_count), 0) as un_payment_count, COALESCE(sum(ap.un_paid_amount), 0) as ap_amount, COALESCE(sum(oc.amount - oc.settle_amount), 0) as oc_amount, COALESCE(sum(op.amount - op.settle_amount), 0) + COALESCE(sum(cos.amount - cos.settle_amount), 0) as op_amount, COALESCE(sum(oc.amount - oc.settle_amount), 0) - COALESCE(sum(un_payment_amount), 0) - COALESCE(sum(op.amount - op.settle_amount), 0) - COALESCE(sum(cos.amount - cos.settle_amount), 0) + COALESCE(sum(ap.un_paid_amount), 0) as amount FROM "a57be577deb434"."tbl_suppliers" "s" LEFT JOIN (SELECT t.supplier_id, t.client_id, sum(un_paid_amount) as un_paid_amount FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" "t" WHERE ("t"."status"=2) AND ("t"."is_payment_settle"=TRUE) GROUP BY "t"."supplier_id", "t"."client_id") "ap" ON ap.supplier_id = s.id LEFT JOIN (SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, sum(settle_amount) as settle_amount FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE "t"."status"=2 GROUP BY "t"."supplier_id", "t"."client_id", "t"."user_id", "t"."contact_id") "oc" ON oc.supplier_id = s.id LEFT JOIN (SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, sum(settle_amount) as settle_amount FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE "t"."status"=2 GROUP BY "t"."supplier_id", "t"."client_id", "t"."user_id", "t"."contact_id") "op" ON op.supplier_id = s.id LEFT JOIN (SELECT t.supplier_id, t.client_id, t.contact_id, sum(amount) as amount, sum(settle_amount) as settle_amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE "t"."status"=2 GROUP BY "t"."supplier_id", "t"."client_id", "t"."contact_id") "cos" ON cos.supplier_id = s.id LEFT JOIN (SELECT t.supplier_id, sum(erp_un_settle_amount) as un_payment_amount, count(*) as un_payment_count FROM "a57be577deb434"."tbl_purchase_contracts" "t" WHERE (t.is_draft = false) AND (t.is_refuse = false) AND (t.supplier_id IS NOT NULL) AND (t.erp_un_settle_amount != 0) AND (t.is_draft = false) AND (t.is_refuse = false) GROUP BY "t"."supplier_id") "purchase_contract" ON purchase_contract.supplier_id = s.id GROUP BY "s"."id" ) UNION ALL ( SELECT (u.id::varchar || 3::varchar) as key, null::integer as client_id, null::integer as supplier_id, u.id as user_id, null::integer as contact_id, null::integer as sales_rep, u.name, u.pinyin_shortcut, '内部员工' as type_display, 'user' as type, u.created_at, u.updated_at, null::integer as un_collect_amount, null::integer as un_collect_count, null::integer as un_payment_amount, null::integer as un_payment_count, null::numeric as ap_amount, COALESCE(sum(oc.amount - oc.settle_amount), 0) as oc_amount, COALESCE(sum(op.amount - op.settle_amount), 0) as op_amount, COALESCE(sum(oc.amount - oc.settle_amount), 0) - COALESCE(sum(op.amount - op.settle_amount), 0) as amount FROM "a57be577deb434"."tbl_users" "u" LEFT JOIN (SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, sum(settle_amount) as settle_amount FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE "t"."status"=2 GROUP BY "t"."supplier_id", "t"."client_id", "t"."user_id", "t"."contact_id") "oc" ON oc.user_id = u.id LEFT JOIN (SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, sum(settle_amount) as settle_amount FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE "t"."status"=2 GROUP BY "t"."supplier_id", "t"."client_id", "t"."user_id", "t"."contact_id") "op" ON op.user_id = u.id WHERE (oc.user_id is not null) OR (op.user_id is not null) GROUP BY "u"."id" ) UNION ALL ( SELECT (co.id::varchar || 4::varchar) as key, null::integer as client_id, null::integer as supplier_id, null::integer as user_id, co.id as contact_id, null::integer as sales_rep, co.name, co.pinyin_shortcut, '联系人' as type_display, 'contact' as type, co.created_at, co.updated_at, null::integer as un_collect_amount, null::integer as un_collect_count, null::integer as un_payment_amount, null::integer as un_payment_count, null::numeric as ap_amount, COALESCE(sum(oc.amount - oc.settle_amount), 0) as oc_amount, COALESCE(sum(op.amount - op.settle_amount), 0) + COALESCE(sum(cos.amount - cos.settle_amount), 0) as op_amount, COALESCE(sum(oc.amount - oc.settle_amount), 0) - COALESCE(sum(op.amount - op.settle_amount), 0) - COALESCE(sum(cos.amount - cos.settle_amount), 0) as amount FROM "a57be577deb434"."tbl_contacts" "co" LEFT JOIN (SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, sum(settle_amount) as settle_amount FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE "t"."status"=2 GROUP BY "t"."supplier_id", "t"."client_id", "t"."user_id", "t"."contact_id") "oc" ON oc.contact_id = co.id LEFT JOIN (SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, sum(settle_amount) as settle_amount FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE "t"."status"=2 GROUP BY "t"."supplier_id", "t"."client_id", "t"."user_id", "t"."contact_id") "op" ON op.contact_id = co.id LEFT JOIN (SELECT t.supplier_id, t.client_id, t.contact_id, sum(amount) as amount, sum(settle_amount) as settle_amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE "t"."status"=2 GROUP BY "t"."supplier_id", "t"."client_id", "t"."contact_id") "cos" ON cos.contact_id = co.id WHERE (oc.contact_id is not null) OR (op.contact_id is not null) GROUP BY "co"."id" )) "sub" WHERE ("sub"."name" ILIKE '%北京惠联讯通信息技术服务有限公司%') OR ("sub"."pinyin_shortcut" ILIKE '%北京惠联讯通信息技术服务有限公司%') ORDER BY updated_at DESC) "c"

[+] Explain
15:39:31.68121.4 msSELECTSELECT "sub".* FROM ((SELECT (s.id::varchar || 1::varchar) as key, s.id as client_id, null::integer as supplier_id, null::integer as user_id, null::integer as contact_id, s.sales_rep, s.name, s.pinyin_shortcut, '客户' as type_display, 'client' as type, s.created_at, s.updated_at, COALESCE(sum(un_collect_amount), 0) as un_collect_amount, COALESCE(sum(un_collect_count), 0) as un_collect_count, null::integer as un_payment_amount, null::integer as un_payment_count, COALESCE(sum(ap.un_paid_amount), 0) as ap_amount, COALESCE(sum(oc.amount - oc.settle_amount), 0) as oc_amount, COALESCE(sum(op.amount - op.settle_amount), 0) + COALESCE(sum(cos.amount - cos.settle_amount), 0) as op_amount, COALESCE(sum(un_collect_amount), 0) + COALESCE(sum(oc.amount - oc.settle_amount), 0) - COALESCE(sum(op.amount - op.settle_amount), 0) - COALESCE(sum(cos.amount - cos.settle_amount), 0) + COALESCE(sum(ap.un_paid_amount), 0) as amount FROM "a57be577deb434"."tbl_clients" "s" LEFT JOIN (SELECT t.supplier_id, t.client_id, sum(un_paid_amount) as un_paid_amount FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" "t" WHERE ("t"."status"=2) AND ("t"."is_payment_settle"=TRUE) GROUP BY "t"."supplier_id", "t"."client_id") "ap" ON ap.client_id = s.id LEFT JOIN (SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, sum(settle_amount) as settle_amount FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE "t"."status"=2 GROUP BY "t"."supplier_id", "t"."client_id", "t"."user_id", "t"."contact_id") "oc" ON oc.client_id = s.id LEFT JOIN (SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, sum(settle_amount) as settle_amount FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE "t"."status"=2 GROUP BY "t"."supplier_id", "t"."client_id", "t"."user_id", "t"."contact_id") "op" ON op.client_id = s.id LEFT JOIN (SELECT t.supplier_id, t.client_id, t.contact_id, sum(amount) as amount, sum(settle_amount) as settle_amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE "t"."status"=2 GROUP BY "t"."supplier_id", "t"."client_id", "t"."contact_id") "cos" ON cos.client_id = s.id LEFT JOIN (SELECT t.client_id, sum(erp_un_settle_amount) as un_collect_amount, count(*) as un_collect_count FROM "a57be577deb434"."tbl_sales_contracts" "t" WHERE ("t"."build_by_project"=TRUE) AND (t.client_id IS NOT NULL) AND (t.erp_un_settle_amount != 0) GROUP BY "t"."client_id") "sales_contract" ON sales_contract.client_id = s.id WHERE "deleted"=FALSE GROUP BY "s"."id") UNION ALL ( SELECT (s.id::varchar || 2::varchar) as key, null::integer as client_id, s.id as supplier_id, null::integer as user_id, null::integer as contact_id, null::integer as sales_rep, s.name, s.pinyin_shortcut, '供应商' as type_display, 'supplier' as type, s.created_at, s.updated_at, null::integer as un_collect_amount, null::integer as un_collect_count, COALESCE(sum(un_payment_amount), 0) as un_payment_amount, COALESCE(sum(un_payment_count), 0) as un_payment_count, COALESCE(sum(ap.un_paid_amount), 0) as ap_amount, COALESCE(sum(oc.amount - oc.settle_amount), 0) as oc_amount, COALESCE(sum(op.amount - op.settle_amount), 0) + COALESCE(sum(cos.amount - cos.settle_amount), 0) as op_amount, COALESCE(sum(oc.amount - oc.settle_amount), 0) - COALESCE(sum(un_payment_amount), 0) - COALESCE(sum(op.amount - op.settle_amount), 0) - COALESCE(sum(cos.amount - cos.settle_amount), 0) + COALESCE(sum(ap.un_paid_amount), 0) as amount FROM "a57be577deb434"."tbl_suppliers" "s" LEFT JOIN (SELECT t.supplier_id, t.client_id, sum(un_paid_amount) as un_paid_amount FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" "t" WHERE ("t"."status"=2) AND ("t"."is_payment_settle"=TRUE) GROUP BY "t"."supplier_id", "t"."client_id") "ap" ON ap.supplier_id = s.id LEFT JOIN (SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, sum(settle_amount) as settle_amount FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE "t"."status"=2 GROUP BY "t"."supplier_id", "t"."client_id", "t"."user_id", "t"."contact_id") "oc" ON oc.supplier_id = s.id LEFT JOIN (SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, sum(settle_amount) as settle_amount FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE "t"."status"=2 GROUP BY "t"."supplier_id", "t"."client_id", "t"."user_id", "t"."contact_id") "op" ON op.supplier_id = s.id LEFT JOIN (SELECT t.supplier_id, t.client_id, t.contact_id, sum(amount) as amount, sum(settle_amount) as settle_amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE "t"."status"=2 GROUP BY "t"."supplier_id", "t"."client_id", "t"."contact_id") "cos" ON cos.supplier_id = s.id LEFT JOIN (SELECT t.supplier_id, sum(erp_un_settle_amount) as un_payment_amount, count(*) as un_payment_count FROM "a57be577deb434"."tbl_purchase_contracts" "t" WHERE (t.is_draft = false) AND (t.is_refuse = false) AND (t.supplier_id IS NOT NULL) AND (t.erp_un_settle_amount != 0) AND (t.is_draft = false) AND (t.is_refuse = false) GROUP BY "t"."supplier_id") "purchase_contract" ON purchase_contract.supplier_id = s.id GROUP BY "s"."id" ) UNION ALL ( SELECT (u.id::varchar || 3::varchar) as key, null::integer as client_id, null::integer as supplier_id, u.id as user_id, null::integer as contact_id, null::integer as sales_rep, u.name, u.pinyin_shortcut, '内部员工' as type_display, 'user' as type, u.created_at, u.updated_at, null::integer as un_collect_amount, null::integer as un_collect_count, null::integer as un_payment_amount, null::integer as un_payment_count, null::numeric as ap_amount, COALESCE(sum(oc.amount - oc.settle_amount), 0) as oc_amount, COALESCE(sum(op.amount - op.settle_amount), 0) as op_amount, COALESCE(sum(oc.amount - oc.settle_amount), 0) - COALESCE(sum(op.amount - op.settle_amount), 0) as amount FROM "a57be577deb434"."tbl_users" "u" LEFT JOIN (SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, sum(settle_amount) as settle_amount FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE "t"."status"=2 GROUP BY "t"."supplier_id", "t"."client_id", "t"."user_id", "t"."contact_id") "oc" ON oc.user_id = u.id LEFT JOIN (SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, sum(settle_amount) as settle_amount FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE "t"."status"=2 GROUP BY "t"."supplier_id", "t"."client_id", "t"."user_id", "t"."contact_id") "op" ON op.user_id = u.id WHERE (oc.user_id is not null) OR (op.user_id is not null) GROUP BY "u"."id" ) UNION ALL ( SELECT (co.id::varchar || 4::varchar) as key, null::integer as client_id, null::integer as supplier_id, null::integer as user_id, co.id as contact_id, null::integer as sales_rep, co.name, co.pinyin_shortcut, '联系人' as type_display, 'contact' as type, co.created_at, co.updated_at, null::integer as un_collect_amount, null::integer as un_collect_count, null::integer as un_payment_amount, null::integer as un_payment_count, null::numeric as ap_amount, COALESCE(sum(oc.amount - oc.settle_amount), 0) as oc_amount, COALESCE(sum(op.amount - op.settle_amount), 0) + COALESCE(sum(cos.amount - cos.settle_amount), 0) as op_amount, COALESCE(sum(oc.amount - oc.settle_amount), 0) - COALESCE(sum(op.amount - op.settle_amount), 0) - COALESCE(sum(cos.amount - cos.settle_amount), 0) as amount FROM "a57be577deb434"."tbl_contacts" "co" LEFT JOIN (SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, sum(settle_amount) as settle_amount FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE "t"."status"=2 GROUP BY "t"."supplier_id", "t"."client_id", "t"."user_id", "t"."contact_id") "oc" ON oc.contact_id = co.id LEFT JOIN (SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, sum(settle_amount) as settle_amount FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE "t"."status"=2 GROUP BY "t"."supplier_id", "t"."client_id", "t"."user_id", "t"."contact_id") "op" ON op.contact_id = co.id LEFT JOIN (SELECT t.supplier_id, t.client_id, t.contact_id, sum(amount) as amount, sum(settle_amount) as settle_amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE "t"."status"=2 GROUP BY "t"."supplier_id", "t"."client_id", "t"."contact_id") "cos" ON cos.contact_id = co.id WHERE (oc.contact_id is not null) OR (op.contact_id is not null) GROUP BY "co"."id" )) "sub" WHERE ("sub"."name" ILIKE '%北京惠联讯通信息技术服务有限公司%') OR ("sub"."pinyin_shortcut" ILIKE '%北京惠联讯通信息技术服务有限公司%') ORDER BY updated_at DESC LIMIT 40

[+] Explain
15:39:31.7030.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=431

[+] Explain
15:39:31.70421.2 msSELECTSELECT count(*) as count, sum(un_collect_amount) as un_collect_amount, sum(un_collect_count) as un_collect_count, sum(un_payment_amount) as un_payment_amount, sum(un_payment_count) as un_payment_count, sum(ap_amount) as ap_amount, sum(oc_amount) as oc_amount, sum(op_amount) as op_amount, sum(amount) as amount FROM (SELECT "sub".* FROM ((SELECT (s.id::varchar || 1::varchar) as key, s.id as client_id, null::integer as supplier_id, null::integer as user_id, null::integer as contact_id, s.sales_rep, s.name, s.pinyin_shortcut, '客户' as type_display, 'client' as type, s.created_at, s.updated_at, COALESCE(sum(un_collect_amount), 0) as un_collect_amount, COALESCE(sum(un_collect_count), 0) as un_collect_count, null::integer as un_payment_amount, null::integer as un_payment_count, COALESCE(sum(ap.un_paid_amount), 0) as ap_amount, COALESCE(sum(oc.amount - oc.settle_amount), 0) as oc_amount, COALESCE(sum(op.amount - op.settle_amount), 0) + COALESCE(sum(cos.amount - cos.settle_amount), 0) as op_amount, COALESCE(sum(un_collect_amount), 0) + COALESCE(sum(oc.amount - oc.settle_amount), 0) - COALESCE(sum(op.amount - op.settle_amount), 0) - COALESCE(sum(cos.amount - cos.settle_amount), 0) + COALESCE(sum(ap.un_paid_amount), 0) as amount FROM "a57be577deb434"."tbl_clients" "s" LEFT JOIN (SELECT t.supplier_id, t.client_id, sum(un_paid_amount) as un_paid_amount FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" "t" WHERE ("t"."status"=2) AND ("t"."is_payment_settle"=TRUE) GROUP BY "t"."supplier_id", "t"."client_id") "ap" ON ap.client_id = s.id LEFT JOIN (SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, sum(settle_amount) as settle_amount FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE "t"."status"=2 GROUP BY "t"."supplier_id", "t"."client_id", "t"."user_id", "t"."contact_id") "oc" ON oc.client_id = s.id LEFT JOIN (SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, sum(settle_amount) as settle_amount FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE "t"."status"=2 GROUP BY "t"."supplier_id", "t"."client_id", "t"."user_id", "t"."contact_id") "op" ON op.client_id = s.id LEFT JOIN (SELECT t.supplier_id, t.client_id, t.contact_id, sum(amount) as amount, sum(settle_amount) as settle_amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE "t"."status"=2 GROUP BY "t"."supplier_id", "t"."client_id", "t"."contact_id") "cos" ON cos.client_id = s.id LEFT JOIN (SELECT t.client_id, sum(erp_un_settle_amount) as un_collect_amount, count(*) as un_collect_count FROM "a57be577deb434"."tbl_sales_contracts" "t" WHERE ("t"."build_by_project"=TRUE) AND (t.client_id IS NOT NULL) AND (t.erp_un_settle_amount != 0) GROUP BY "t"."client_id") "sales_contract" ON sales_contract.client_id = s.id WHERE "deleted"=FALSE GROUP BY "s"."id") UNION ALL ( SELECT (s.id::varchar || 2::varchar) as key, null::integer as client_id, s.id as supplier_id, null::integer as user_id, null::integer as contact_id, null::integer as sales_rep, s.name, s.pinyin_shortcut, '供应商' as type_display, 'supplier' as type, s.created_at, s.updated_at, null::integer as un_collect_amount, null::integer as un_collect_count, COALESCE(sum(un_payment_amount), 0) as un_payment_amount, COALESCE(sum(un_payment_count), 0) as un_payment_count, COALESCE(sum(ap.un_paid_amount), 0) as ap_amount, COALESCE(sum(oc.amount - oc.settle_amount), 0) as oc_amount, COALESCE(sum(op.amount - op.settle_amount), 0) + COALESCE(sum(cos.amount - cos.settle_amount), 0) as op_amount, COALESCE(sum(oc.amount - oc.settle_amount), 0) - COALESCE(sum(un_payment_amount), 0) - COALESCE(sum(op.amount - op.settle_amount), 0) - COALESCE(sum(cos.amount - cos.settle_amount), 0) + COALESCE(sum(ap.un_paid_amount), 0) as amount FROM "a57be577deb434"."tbl_suppliers" "s" LEFT JOIN (SELECT t.supplier_id, t.client_id, sum(un_paid_amount) as un_paid_amount FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" "t" WHERE ("t"."status"=2) AND ("t"."is_payment_settle"=TRUE) GROUP BY "t"."supplier_id", "t"."client_id") "ap" ON ap.supplier_id = s.id LEFT JOIN (SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, sum(settle_amount) as settle_amount FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE "t"."status"=2 GROUP BY "t"."supplier_id", "t"."client_id", "t"."user_id", "t"."contact_id") "oc" ON oc.supplier_id = s.id LEFT JOIN (SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, sum(settle_amount) as settle_amount FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE "t"."status"=2 GROUP BY "t"."supplier_id", "t"."client_id", "t"."user_id", "t"."contact_id") "op" ON op.supplier_id = s.id LEFT JOIN (SELECT t.supplier_id, t.client_id, t.contact_id, sum(amount) as amount, sum(settle_amount) as settle_amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE "t"."status"=2 GROUP BY "t"."supplier_id", "t"."client_id", "t"."contact_id") "cos" ON cos.supplier_id = s.id LEFT JOIN (SELECT t.supplier_id, sum(erp_un_settle_amount) as un_payment_amount, count(*) as un_payment_count FROM "a57be577deb434"."tbl_purchase_contracts" "t" WHERE (t.is_draft = false) AND (t.is_refuse = false) AND (t.supplier_id IS NOT NULL) AND (t.erp_un_settle_amount != 0) AND (t.is_draft = false) AND (t.is_refuse = false) GROUP BY "t"."supplier_id") "purchase_contract" ON purchase_contract.supplier_id = s.id GROUP BY "s"."id" ) UNION ALL ( SELECT (u.id::varchar || 3::varchar) as key, null::integer as client_id, null::integer as supplier_id, u.id as user_id, null::integer as contact_id, null::integer as sales_rep, u.name, u.pinyin_shortcut, '内部员工' as type_display, 'user' as type, u.created_at, u.updated_at, null::integer as un_collect_amount, null::integer as un_collect_count, null::integer as un_payment_amount, null::integer as un_payment_count, null::numeric as ap_amount, COALESCE(sum(oc.amount - oc.settle_amount), 0) as oc_amount, COALESCE(sum(op.amount - op.settle_amount), 0) as op_amount, COALESCE(sum(oc.amount - oc.settle_amount), 0) - COALESCE(sum(op.amount - op.settle_amount), 0) as amount FROM "a57be577deb434"."tbl_users" "u" LEFT JOIN (SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, sum(settle_amount) as settle_amount FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE "t"."status"=2 GROUP BY "t"."supplier_id", "t"."client_id", "t"."user_id", "t"."contact_id") "oc" ON oc.user_id = u.id LEFT JOIN (SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, sum(settle_amount) as settle_amount FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE "t"."status"=2 GROUP BY "t"."supplier_id", "t"."client_id", "t"."user_id", "t"."contact_id") "op" ON op.user_id = u.id WHERE (oc.user_id is not null) OR (op.user_id is not null) GROUP BY "u"."id" ) UNION ALL ( SELECT (co.id::varchar || 4::varchar) as key, null::integer as client_id, null::integer as supplier_id, null::integer as user_id, co.id as contact_id, null::integer as sales_rep, co.name, co.pinyin_shortcut, '联系人' as type_display, 'contact' as type, co.created_at, co.updated_at, null::integer as un_collect_amount, null::integer as un_collect_count, null::integer as un_payment_amount, null::integer as un_payment_count, null::numeric as ap_amount, COALESCE(sum(oc.amount - oc.settle_amount), 0) as oc_amount, COALESCE(sum(op.amount - op.settle_amount), 0) + COALESCE(sum(cos.amount - cos.settle_amount), 0) as op_amount, COALESCE(sum(oc.amount - oc.settle_amount), 0) - COALESCE(sum(op.amount - op.settle_amount), 0) - COALESCE(sum(cos.amount - cos.settle_amount), 0) as amount FROM "a57be577deb434"."tbl_contacts" "co" LEFT JOIN (SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, sum(settle_amount) as settle_amount FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE "t"."status"=2 GROUP BY "t"."supplier_id", "t"."client_id", "t"."user_id", "t"."contact_id") "oc" ON oc.contact_id = co.id LEFT JOIN (SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, sum(settle_amount) as settle_amount FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE "t"."status"=2 GROUP BY "t"."supplier_id", "t"."client_id", "t"."user_id", "t"."contact_id") "op" ON op.contact_id = co.id LEFT JOIN (SELECT t.supplier_id, t.client_id, t.contact_id, sum(amount) as amount, sum(settle_amount) as settle_amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE "t"."status"=2 GROUP BY "t"."supplier_id", "t"."client_id", "t"."contact_id") "cos" ON cos.contact_id = co.id WHERE (oc.contact_id is not null) OR (op.contact_id is not null) GROUP BY "co"."id" )) "sub" WHERE ("sub"."name" ILIKE '%北京惠联讯通信息技术服务有限公司%') OR ("sub"."pinyin_shortcut" ILIKE '%北京惠联讯通信息技术服务有限公司%')) "sub"

[+] Explain
15:39:31.7271.6 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 5064, 5, 'vue/erp-analysis/list-unit', '{"created_at_period":"","not_zero":"","type":"","keyword":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8","page":"1","pageSize":"40","listReload":"true","web_access_token":"4eQAiv21khj4ckVl-aCvgG-h5XZj42Z5"}', '{"code":2000,"result":{"list":[{"key":"4312","client_id":"","supplier_id":431,"user_id":"","contact_id":"","sales_rep":"","name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8","pinyin_shortcut":"bjhlxtxxjsfwyxgs","type_display":"\u4f9b\u5e94\u5546","type":"supplier","created_at":"2021-09-28 15:22:46","updated_at":"2021-09-28 15:22:46","un_collect_amount":"","un_collect_count":"","un_payment_amount":"20192","un_payment_count":"13","ap_amount":"0","oc_amount":"8200.01","op_amount":"0","amount":"-11991.99","supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"client":"","user":"","contact":""}],"countArr":[{"count":1,"key":1,"name":"\u5f80\u6765\u5355\u4f4d\u603b\u6570","color":"#FEF7EC","border":"#FF9200","sum":1},{"count":1,"key":2,"name":"\u5e94\u4ed8\u6b3e","color":"#E7F3D5","border":"#70B603","sum":20192},{"count":1,"key":3,"name":"\u5e94\u6536\u6b3e","color":"#F1F2F5","border":"#555555","sum":8200.01}],"count":1,"un_payment_amount":"20192","un_payment_count":"13","un_collect_amount":"","un_collect_count":"","ap_amount":"0","oc_amount":"8200.01","op_amount":"0","amount":"-11991.99","pagenation":{"totalcount":1,"thispage":1,"pagesize":40}},"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_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/149.0.0.0 Safari\/537.36"}', FALSE, '2026-06-11 15:39:31', 80584192) RETURNING "id"

[+] Explain