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

Performance Profiling

Total processing time: 81 ms; Peak memory: 3.770 MB. Show Profiling Timeline

总计9条数据
TimeDurationCategoryInfo
  
15:57:28.33819.8 msyii\db\Command::querySELECT 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) AND (t.bank_settle_at IS NOT NULL) 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") UNION ALL ( SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, 0::numeric as settle_amount FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND (t.bank_settle_at IS NULL) 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) AND (t.bank_settle_at IS NOT NULL) 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") UNION ALL ( SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, 0::numeric as settle_amount FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND (t.bank_settle_at IS NULL) 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) AND (t.bank_settle_at IS NOT NULL) 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") UNION ALL ( SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, 0::numeric as settle_amount FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND (t.bank_settle_at IS NULL) 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) AND (t.bank_settle_at IS NOT NULL) 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") UNION ALL ( SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, 0::numeric as settle_amount FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND (t.bank_settle_at IS NULL) 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 '%bjhl%') OR ("sub"."pinyin_shortcut" ILIKE '%bjhl%') ORDER BY updated_at DESC) "c"
15:57:28.35918.9 msyii\db\Command::querySELECT "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) AND (t.bank_settle_at IS NOT NULL) 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") UNION ALL ( SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, 0::numeric as settle_amount FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND (t.bank_settle_at IS NULL) 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) AND (t.bank_settle_at IS NOT NULL) 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") UNION ALL ( SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, 0::numeric as settle_amount FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND (t.bank_settle_at IS NULL) 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) AND (t.bank_settle_at IS NOT NULL) 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") UNION ALL ( SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, 0::numeric as settle_amount FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND (t.bank_settle_at IS NULL) 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) AND (t.bank_settle_at IS NOT NULL) 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") UNION ALL ( SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, 0::numeric as settle_amount FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND (t.bank_settle_at IS NULL) 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 '%bjhl%') OR ("sub"."pinyin_shortcut" ILIKE '%bjhl%') ORDER BY updated_at DESC LIMIT 40
15:57:28.38018.7 msyii\db\Command::querySELECT 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) AND (t.bank_settle_at IS NOT NULL) 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") UNION ALL ( SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, 0::numeric as settle_amount FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND (t.bank_settle_at IS NULL) 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) AND (t.bank_settle_at IS NOT NULL) 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") UNION ALL ( SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, 0::numeric as settle_amount FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND (t.bank_settle_at IS NULL) 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) AND (t.bank_settle_at IS NOT NULL) 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") UNION ALL ( SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, 0::numeric as settle_amount FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND (t.bank_settle_at IS NULL) 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) AND (t.bank_settle_at IS NOT NULL) 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") UNION ALL ( SELECT t.supplier_id, t.client_id, t.user_id, t.contact_id, sum(amount) as amount, 0::numeric as settle_amount FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND (t.bank_settle_at IS NULL) 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 '%bjhl%') OR ("sub"."pinyin_shortcut" ILIKE '%bjhl%')) "sub"
15:57:28.4012.1 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-analysis/list-unit', '{"created_at_period":"","not_zero":"","type":"","keyword":"bjhl","page":"1","pageSize":"40","listReload":"true","web_access_token":"2SCKb3BYAaSLDxSx0sIX1KfVKBB-1lWj"}', '{"code":2000,"result":{"list":[{"key":"32741","client_id":3274,"supplier_id":"","user_id":"","contact_id":"","sales_rep":"","name":"\u5317\u4eac\u4e92\u8054\u4e92\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","pinyin_shortcut":"bjhlhtkjyxgs","type_display":"\u5ba2\u6237","type":"client","created_at":"2024-06-12 11:01:04","updated_at":"2026-01-15 14:59:38","un_collect_amount":"0","un_collect_count":"0","un_payment_amount":"","un_payment_count":"","ap_amount":"0","oc_amount":"0","op_amount":"0","amount":"0","supplier":"","client":{"id":3274,"key":3274,"name":"\u5317\u4eac\u4e92\u8054\u4e92\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":"","contact":""},{"key":"7192","client_id":"","supplier_id":719,"user_id":"","contact_id":"","sales_rep":"","name":"\u5317\u4eac\u5408\u529b\u521b\u535a\u4fe1\u606f\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8","pinyin_shortcut":"bjhlcbxxgcjsyxgs","type_display":"\u4f9b\u5e94\u5546","type":"supplier","created_at":"2025-08-08 09:34:51","updated_at":"2025-08-08 10:40:03","un_collect_amount":"","un_collect_count":"","un_payment_amount":"0","un_payment_count":"0","ap_amount":"0","oc_amount":"0","op_amount":"0","amount":"0","supplier":{"id":719,"key":719,"name":"\u5317\u4eac\u5408\u529b\u521b\u535a\u4fe1\u606f\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8"},"client":"","user":"","contact":""},{"key":"27911","client_id":2791,"supplier_id":"","user_id":"","contact_id":"","sales_rep":"","name":"PA\u6e20\u9053-\u5317\u4eac\u5408\u529b\u817e\u8fbe\u65b0\u5174\u79d1\u6280\u6709\u9650\u516c\u53f8","pinyin_shortcut":"PAqdbjhltdxxkjyxgs","type_display":"\u5ba2\u6237","type":"client","created_at":"2024-01-18 18:18:54","updated_at":"2024-02-17 12:15:32","un_collect_amount":"0","un_collect_count":"0","un_payment_amount":"","un_payment_count":"","ap_amount":"0","oc_amount":"0","op_amount":"0","amount":"0","supplier":"","client":{"id":2791,"key":2791,"name":"PA\u6e20\u9053-\u5317\u4eac\u5408\u529b\u817e\u8fbe\u65b0\u5174\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":"","contact":""},{"key":"10761","client_id":1076,"supplier_id":"","user_id":"","contact_id":"","sales_rep":5311,"name":"\u5317\u4eac\u6c49\u9f99\u601d\u742a\u6570\u7801\u79d1\u6280\u6709\u9650\u516c\u53f8-S","pinyin_shortcut":"bjhlsqsmkjyxgsS","type_display":"\u5ba2\u6237","type":"client","created_at":"2018-07-25 17:58:44","updated_at":"2023-10-13 20:30:27","un_collect_amount":"0","un_collect_count":"0","un_payment_amount":"","un_payment_count":"","ap_amount":"0","oc_amount":"0","op_amount":"0","amount":"0","supplier":"","client":{"id":1076,"key":1076,"name":"\u5317\u4eac\u6c49\u9f99\u601d\u742a\u6570\u7801\u79d1\u6280\u6709\u9650\u516c\u53f8-S"},"user":"","contact":""},{"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","op_amount":"0.01","amount":"-11992.01","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":""},{"key":"802","client_id":"","supplier_id":80,"user_id":"","contact_id":"","sales_rep":"","name":"\u5317\u4eac\u8f89\u84dd\u4fdd\u76c8\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","pinyin_shortcut":"bjhlbykjfzyxgs","type_display":"\u4f9b\u5e94\u5546","type":"supplier","created_at":"2017-02-17 11:06:22","updated_at":"2021-09-07 11:11:14","un_collect_amount":"","un_collect_count":"","un_payment_amount":"0","un_payment_count":"0","ap_amount":"0","oc_amount":"0","op_amount":"0","amount":"0","supplier":{"id":80,"key":80,"name":"\u5317\u4eac\u8f89\u84dd\u4fdd\u76c8\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"client":"","user":"","contact":""}],"countArr":[{"count":6,"key":1,"name":"\u5f80\u6765\u5355\u4f4d\u603b\u6570","color":"#FEF7EC","border":"#FF9200","sum":6},{"count":6,"key":2,"name":"\u5e94\u4ed8\u6b3e","color":"#E7F3D5","border":"#70B603","sum":20192.01},{"count":6,"key":3,"name":"\u5e94\u6536\u6b3e","color":"#F1F2F5","border":"#555555","sum":8200}],"count":6,"un_payment_amount":"20192","un_payment_count":"13","un_collect_amount":"0","un_collect_count":"0","ap_amount":"0","oc_amount":"8200","op_amount":"0.01","amount":"-11992.01","pagenation":{"totalcount":6,"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; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-11 15:57:28', 73436928) RETURNING "id"
15:57:28.3300.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
15:57:28.3330.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:57:28.3300.4 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:57:28.3780.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (719, 431, 80)
15:57:28.3790.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3274, 2791, 1076)