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

Database Queries

总计8条数据
TimeDurationTypeQuery
  
15:57:22.04912.0 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
15:57:22.0958.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
15:57:22.13371.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) 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" ORDER BY updated_at DESC) "c"

[+] Explain
15:57:22.21042.2 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) 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" ORDER BY updated_at DESC LIMIT 40

[+] Explain
15:57:22.2581.0 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (982, 3465, 3082, 3364, 3415, 3462, 93, 2130, 2593, 3009, 2150, 2125, 2128, 3311, 3407, 3281, 3315, 3303, 3354, 3432, 3389, 3464, 1188, 391, 3463, 3461, 3460, 3459, 3424, 3304, 1933, 399, 3429, 1111, 2616, 2538, 146, 2803, 1661)

[+] Explain
15:57:22.2590.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004

[+] Explain
15:57:22.26127.4 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) 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") "sub"

[+] Explain
15:57:22.29212.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/erp-analysis/list-unit', '{"created_at_period":"","not_zero":"","type":"","page":"1","pageSize":"40","listReload":"true","web_access_token":"2SCKb3BYAaSLDxSx0sIX1KfVKBB-1lWj"}', '{"code":2000,"result":{"list":[{"key":"9821","client_id":982,"supplier_id":"","user_id":"","contact_id":"","sales_rep":1001,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","pinyin_shortcut":"zgxxaqyjs","type_display":"\u5ba2\u6237","type":"client","created_at":"2018-05-16 18:55:46","updated_at":"2026-06-10 11:29:10","un_collect_amount":"12812634","un_collect_count":"5","un_payment_amount":"","un_payment_count":"","ap_amount":"0","oc_amount":"0","op_amount":"0","amount":"12812634","supplier":"","client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"user":"","contact":""},{"key":"34651","client_id":3465,"supplier_id":"","user_id":"","contact_id":"","sales_rep":1001,"name":"\u96f6\u552e001","pinyin_shortcut":"ls001","type_display":"\u5ba2\u6237","type":"client","created_at":"2026-06-09 17:08:39","updated_at":"2026-06-09 17:10:11","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":3465,"key":3465,"name":"\u96f6\u552e001"},"user":"","contact":""},{"key":"30821","client_id":3082,"supplier_id":"","user_id":"","contact_id":"","sales_rep":1013,"name":"\u5317\u4eac\u6c49\u738b\u9e4f\u82af\u79d1\u6280\u6709\u9650\u516c\u53f8","pinyin_shortcut":"bjhwpxkjyxgs","type_display":"\u5ba2\u6237","type":"client","created_at":"2024-05-10 18:01:54","updated_at":"2026-06-08 20:05:28","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":3082,"key":3082,"name":"\u5317\u4eac\u6c49\u738b\u9e4f\u82af\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":"","contact":""},{"key":"33641","client_id":3364,"supplier_id":"","user_id":"","contact_id":"","sales_rep":1001,"name":"\u5317\u4eac\u6781\u901a\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","pinyin_shortcut":"bjjtsjxxjsyxgsgd","type_display":"\u5ba2\u6237","type":"client","created_at":"2025-05-14 16:30:29","updated_at":"2026-06-05 17:59:52","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":3364,"key":3364,"name":"\u5317\u4eac\u6781\u901a\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"user":"","contact":""},{"key":"34151","client_id":3415,"supplier_id":"","user_id":"","contact_id":"","sales_rep":"","name":"\u5317\u4eac\u4e2d\u91d1\u4fdd\u9669\u7ecf\u7eaa\u6709\u9650\u516c\u53f8","pinyin_shortcut":"bjzjbxjjyxgs","type_display":"\u5ba2\u6237","type":"client","created_at":"2025-10-28 10:42:40","updated_at":"2026-06-05 17:40:43","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":3415,"key":3415,"name":"\u5317\u4eac\u4e2d\u91d1\u4fdd\u9669\u7ecf\u7eaa\u6709\u9650\u516c\u53f8"},"user":"","contact":""},{"key":"34621","client_id":3462,"supplier_id":"","user_id":"","contact_id":"","sales_rep":1001,"name":"\u5927\u59d1\u8bf4\u7684\u98ce\u683c","pinyin_shortcut":"dgsdfg","type_display":"\u5ba2\u6237","type":"client","created_at":"2026-06-02 16:52:29","updated_at":"2026-06-05 17:35:57","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":3462,"key":3462,"name":"\u5927\u59d1\u8bf4\u7684\u98ce\u683c"},"user":"","contact":""},{"key":"931","client_id":93,"supplier_id":"","user_id":"","contact_id":"","sales_rep":1005,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","pinyin_shortcut":"klhcbjxyjsgfyxgs","type_display":"\u5ba2\u6237","type":"client","created_at":"2017-02-21 12:42:50","updated_at":"2026-06-05 11:26:50","un_collect_amount":"500000","un_collect_count":"1","un_payment_amount":"","un_payment_count":"","ap_amount":"0","oc_amount":"0","op_amount":"0","amount":"500000","supplier":"","client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"user":"","contact":""},{"key":"21301","client_id":2130,"supplier_id":"","user_id":"","contact_id":"","sales_rep":5087,"name":"\u5317\u4eac\u4eac\u822a\u8ba1\u7b97\u901a\u8baf\u7814\u7a76\u6240304","pinyin_shortcut":"bjjhjstxyjs304","type_display":"\u5ba2\u6237","type":"client","created_at":"2021-12-24 06:21:13","updated_at":"2026-06-05 11:14:46","un_collect_amount":"20021700","un_collect_count":"2","un_payment_amount":"","un_payment_count":"","ap_amount":"0","oc_amount":"0","op_amount":"0","amount":"20021700","supplier":"","client":{"id":2130,"key":2130,"name":"\u5317\u4eac\u4eac\u822a\u8ba1\u7b97\u901a\u8baf\u7814\u7a76\u6240304"},"user":"","contact":""},{"key":"25931","client_id":2593,"supplier_id":"","user_id":"","contact_id":"","sales_rep":1001,"name":"\u56fd\u5bcc\u745e\u6570\u636e\u7cfb\u7edf\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","pinyin_shortcut":"gfrsjxtyxgsgd","type_display":"\u5ba2\u6237","type":"client","created_at":"2023-09-24 21:17:42","updated_at":"2026-06-05 11:14:23","un_collect_amount":"800","un_collect_count":"1","un_payment_amount":"","un_payment_count":"","ap_amount":"0","oc_amount":"0","op_amount":"0","amount":"800","supplier":"","client":{"id":2593,"key":2593,"name":"\u56fd\u5bcc\u745e\u6570\u636e\u7cfb\u7edf\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"user":"","contact":""},{"key":"30091","client_id":3009,"supplier_id":"","user_id":"","contact_id":"","sales_rep":1001,"name":"\u540c\u65b9\u77e5\u7f51(\u5317\u4eac)\u6280\u672f\u6709\u9650\u516c\u53f8\/\u540c\u65b9\u77e5\u7f51\u6570\u5b57\u51fa\u7248\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\/\u300a\u4e2d\u56fd\u5b66\u672f\u671f\u520a(\u5149\u76d8\u7248)\u300b\u7535\u5b50\u6742\u5fd7\u793e\u6709\u9650\u516c\u53f8","pinyin_shortcut":"tfzwbjjsyxgstfzwszcbjsgfyxgszgxsqkgpbdzzzsyxgs","type_display":"\u5ba2\u6237","type":"client","created_at":"2024-05-07 16:42:41","updated_at":"2026-06-05 11:12:59","un_collect_amount":"900","un_collect_count":"1","un_payment_amount":"","un_payment_count":"","ap_amount":"0","oc_amount":"0","op_amount":"0","amount":"900","supplier":"","client":{"id":3009,"key":3009,"name":"\u540c\u65b9\u77e5\u7f51(\u5317\u4eac)\u6280\u672f\u6709\u9650\u516c\u53f8\/\u540c\u65b9\u77e5\u7f51\u6570\u5b57\u51fa\u7248\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\/\u300a\u4e2d\u56fd\u5b66\u672f\u671f\u520a(\u5149\u76d8\u7248)\u300b\u7535\u5b50\u6742\u5fd7\u793e\u6709\u9650\u516c\u53f8"},"user":"","contact":""},{"key":"21501","client_id":2150,"supplier_id":"","user_id":"","contact_id":"","sales_rep":1001,"name":"\u5317\u4eac\u5730\u5e73\u7ebf\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u5b89\u4ead\u5730\u5e73\u7ebf\u667a\u80fd\u4ea4\u901a\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u7ea2\u897f\u74dc\u534a\u5bfc\u4f53\u6709\u9650\u516c\u53f8\/\u5b81\u6ce2\u5730\u5e73\u7ebf\u98d2\u817e\u79d1\u6280\u6709\u9650\u516c\u53f8(EDA)","pinyin_shortcut":"bjdpxxxjsyxgsshatdpxznjtjsyxgsshhxgbdtyxgsnbdpxstkjyxgsEDA","type_display":"\u5ba2\u6237","type":"client","created_at":"2022-02-16 10:45:21","updated_at":"2026-06-05 11:12:51","un_collect_amount":"420000","un_collect_count":"1","un_payment_amount":"","un_payment_count":"","ap_amount":"0","oc_amount":"107","op_amount":"110","amount":"419997","supplier":"","client":{"id":2150,"key":2150,"name":"\u5317\u4eac\u5730\u5e73\u7ebf\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u5b89\u4ead\u5730\u5e73\u7ebf\u667a\u80fd\u4ea4\u901a\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u7ea2\u897f\u74dc\u534a\u5bfc\u4f53\u6709\u9650\u516c\u53f8\/\u5b81\u6ce2\u5730\u5e73\u7ebf\u98d2\u817e\u79d1\u6280\u6709\u9650\u516c\u53f8(EDA)"},"user":"","contact":""},{"key":"21251","client_id":2125,"supplier_id":"","user_id":"","contact_id":"","sales_rep":5087,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8","pinyin_shortcut":"bjjqzzyxgs","type_display":"\u5ba2\u6237","type":"client","created_at":"2021-12-19 18:01:00","updated_at":"2026-06-05 11:12:45","un_collect_amount":"1281047","un_collect_count":"3","un_payment_amount":"","un_payment_count":"","ap_amount":"0","oc_amount":"0","op_amount":"0","amount":"1281047","supplier":"","client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8"},"user":"","contact":""},{"key":"21281","client_id":2128,"supplier_id":"","user_id":"","contact_id":"","sales_rep":5087,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","pinyin_shortcut":"bjkjyxgs","type_display":"\u5ba2\u6237","type":"client","created_at":"2021-12-19 21:44:13","updated_at":"2026-06-05 11:10:13","un_collect_amount":"44572103","un_collect_count":"2","un_payment_amount":"","un_payment_count":"","ap_amount":"0","oc_amount":"0","op_amount":"0","amount":"44572103","supplier":"","client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":"","contact":""},{"key":"33111","client_id":3311,"supplier_id":"","user_id":"","contact_id":"","sales_rep":1001,"name":"\u5317\u4eac\u534e\u8fb0\u60a6\u79d1\u6280\u6709\u9650\u516c\u53f8","pinyin_shortcut":"bjhcykjyxgs","type_display":"\u5ba2\u6237","type":"client","created_at":"2024-10-16 11:09:32","updated_at":"2026-06-05 10:06:41","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":3311,"key":3311,"name":"\u5317\u4eac\u534e\u8fb0\u60a6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":"","contact":""},{"key":"34071","client_id":3407,"supplier_id":"","user_id":"","contact_id":"","sales_rep":"","name":"\u4e9a\u8428\u5408\u83b1(\u4e2d\u56fd)\u6295\u8d44\u6709\u9650\u516c\u53f8","pinyin_shortcut":"yshlzgtzyxgs","type_display":"\u5ba2\u6237","type":"client","created_at":"2025-10-15 13:49:39","updated_at":"2026-06-04 21:16:06","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":3407,"key":3407,"name":"\u4e9a\u8428\u5408\u83b1(\u4e2d\u56fd)\u6295\u8d44\u6709\u9650\u516c\u53f8"},"user":"","contact":""},{"key":"32811","client_id":3281,"supplier_id":"","user_id":"","contact_id":"","sales_rep":5295,"name":"\u5bd2\u5e8f\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8(EDA)","pinyin_shortcut":"hxkjbjyxgsEDA","type_display":"\u5ba2\u6237","type":"client","created_at":"2024-06-27 17:27:09","updated_at":"2026-06-04 20:47:28","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":3281,"key":3281,"name":"\u5bd2\u5e8f\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8(EDA)"},"user":"","contact":""},{"key":"33151","client_id":3315,"supplier_id":"","user_id":"","contact_id":"","sales_rep":1001,"name":"\u822a\u5929\u79d1\u5de5206\u6240(\u91cd\u590d)","pinyin_shortcut":"htkg206scf","type_display":"\u5ba2\u6237","type":"client","created_at":"2024-10-27 21:53:27","updated_at":"2026-06-04 20:28:13","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":3315,"key":3315,"name":"\u822a\u5929\u79d1\u5de5206\u6240(\u91cd\u590d)"},"user":"","contact":""},{"key":"33031","client_id":3303,"supplier_id":"","user_id":"","contact_id":"","sales_rep":1004,"name":"\u5317\u4eac\u795e\u5dde\u90a6\u90a6\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","pinyin_shortcut":"bjszbbjsfwyxgsgd","type_display":"\u5ba2\u6237","type":"client","created_at":"2024-09-10 13:22:33","updated_at":"2026-06-04 20:24:49","un_collect_amount":"0","un_collect_count":"0","un_payment_amount":"","un_payment_count":"","ap_amount":"0","oc_amount":"0","op_amount":"800","amount":"-800","supplier":"","client":{"id":3303,"key":3303,"name":"\u5317\u4eac\u795e\u5dde\u90a6\u90a6\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"user":"","contact":""},{"key":"33541","client_id":3354,"supplier_id":"","user_id":"","contact_id":"","sales_rep":1005,"name":"\u822a\u5929\u79d1\u6280\u4e00\u966215\u6240","pinyin_shortcut":"htkjyy15s","type_display":"\u5ba2\u6237","type":"client","created_at":"2025-04-16 09:24:30","updated_at":"2026-06-04 16:19:49","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":3354,"key":3354,"name":"\u822a\u5929\u79d1\u6280\u4e00\u966215\u6240"},"user":"","contact":""},{"key":"34321","client_id":3432,"supplier_id":"","user_id":"","contact_id":"","sales_rep":1001,"name":"\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662","pinyin_shortcut":"zgmhglgbxy","type_display":"\u5ba2\u6237","type":"client","created_at":"2025-12-19 13:31:40","updated_at":"2026-06-03 22:57:02","un_collect_amount":"354000","un_collect_count":"2","un_payment_amount":"","un_payment_count":"","ap_amount":"0","oc_amount":"0","op_amount":"0","amount":"354000","supplier":"","client":{"id":3432,"key":3432,"name":"\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662"},"user":"","contact":""},{"key":"33891","client_id":3389,"supplier_id":"","user_id":"","contact_id":"","sales_rep":1001,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8","pinyin_shortcut":"zgzqbyxzrgs","type_display":"\u5ba2\u6237","type":"client","created_at":"2025-08-21 12:22:51","updated_at":"2026-06-02 23:12:40","un_collect_amount":"110700","un_collect_count":"4","un_payment_amount":"","un_payment_count":"","ap_amount":"0","oc_amount":"0","op_amount":"0","amount":"110700","supplier":"","client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"user":"","contact":""},{"key":"34641","client_id":3464,"supplier_id":"","user_id":"","contact_id":"","sales_rep":"","name":"\u9690\u6027\u9700\u6c42","pinyin_shortcut":"yxxq","type_display":"\u5ba2\u6237","type":"client","created_at":"2026-06-02 16:58:49","updated_at":"2026-06-02 18:08:44","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":3464,"key":3464,"name":"\u9690\u6027\u9700\u6c42"},"user":"","contact":""},{"key":"11881","client_id":1188,"supplier_id":"","user_id":"","contact_id":"","sales_rep":1005,"name":"\u4e2d\u56fd\u7164\u70ad\u5730\u8d28\u603b\u5c40","pinyin_shortcut":"zgmtdzzj","type_display":"\u5ba2\u6237","type":"client","created_at":"2018-11-06 18:49:53","updated_at":"2026-06-02 17:03:08","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":1188,"key":1188,"name":"\u4e2d\u56fd\u7164\u70ad\u5730\u8d28\u603b\u5c40"},"user":"","contact":""},{"key":"3911","client_id":391,"supplier_id":"","user_id":"","contact_id":"","sales_rep":"","name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240(8359)-S","pinyin_shortcut":"bjtzjxyjs8359S","type_display":"\u5ba2\u6237","type":"client","created_at":"2017-06-27 16:45:44","updated_at":"2026-06-02 16:55:09","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":391,"key":391,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240(8359)-S"},"user":"","contact":""},{"key":"34631","client_id":3463,"supplier_id":"","user_id":"","contact_id":"","sales_rep":1001,"name":"3","pinyin_shortcut":"3","type_display":"\u5ba2\u6237","type":"client","created_at":"2026-06-02 16:54:10","updated_at":"2026-06-02 16:54:10","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":3463,"key":3463,"name":"3"},"user":"","contact":""},{"key":"34611","client_id":3461,"supplier_id":"","user_id":"","contact_id":"","sales_rep":"","name":"2","pinyin_shortcut":"2","type_display":"\u5ba2\u6237","type":"client","created_at":"2026-06-02 15:26:34","updated_at":"2026-06-02 15:26:34","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":3461,"key":3461,"name":"2"},"user":"","contact":""},{"key":"34601","client_id":3460,"supplier_id":"","user_id":"","contact_id":"","sales_rep":1005,"name":"23","pinyin_shortcut":"23","type_display":"\u5ba2\u6237","type":"client","created_at":"2026-06-02 15:25:18","updated_at":"2026-06-02 15:25:18","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":3460,"key":3460,"name":"23"},"user":"","contact":""},{"key":"34591","client_id":3459,"supplier_id":"","user_id":"","contact_id":"","sales_rep":"","name":"\u6d4b\u8bd5","pinyin_shortcut":"cs","type_display":"\u5ba2\u6237","type":"client","created_at":"2026-06-02 15:23:56","updated_at":"2026-06-02 15:23:56","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":3459,"key":3459,"name":"\u6d4b\u8bd5"},"user":"","contact":""},{"key":"34241","client_id":3424,"supplier_id":"","user_id":"","contact_id":"","sales_rep":"","name":"\u5317\u4eac\u888b\u9f20\u4e91\u79d1\u6280\u6709\u9650\u516c\u53f8","pinyin_shortcut":"bjdsykjyxgs","type_display":"\u5ba2\u6237","type":"client","created_at":"2025-11-18 14:53:54","updated_at":"2026-06-01 18:41:15","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":3424,"key":3424,"name":"\u5317\u4eac\u888b\u9f20\u4e91\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":"","contact":""},{"key":"33041","client_id":3304,"supplier_id":"","user_id":"","contact_id":"","sales_rep":1001,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","pinyin_shortcut":"bjyckjyxgsgd","type_display":"\u5ba2\u6237","type":"client","created_at":"2024-09-19 15:34:42","updated_at":"2026-05-25 10:11:37","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":3304,"key":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"user":"","contact":""},{"key":"19331","client_id":1933,"supplier_id":"","user_id":"","contact_id":"","sales_rep":1001,"name":"SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8(\u91cd\u590d\u5ba2\u6237)","pinyin_shortcut":"SMCbjzzyxgscfkh","type_display":"\u5ba2\u6237","type":"client","created_at":"2020-09-29 09:58:29","updated_at":"2026-05-18 14:33:52","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":1933,"key":1933,"name":"SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8(\u91cd\u590d\u5ba2\u6237)"},"user":"","contact":""},{"key":"3991","client_id":399,"supplier_id":"","user_id":"","contact_id":"","sales_rep":1005,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240\u4e2d\u76fe(\u8fc7\u5355\u516c\u53f8)","pinyin_shortcut":"gabdyyjszdgdgs","type_display":"\u5ba2\u6237","type":"client","created_at":"2017-07-04 15:14:12","updated_at":"2026-05-18 13:48: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":399,"key":399,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240\u4e2d\u76fe(\u8fc7\u5355\u516c\u53f8)"},"user":"","contact":""},{"key":"34291","client_id":3429,"supplier_id":"","user_id":"","contact_id":"","sales_rep":1001,"name":"\u5e7f\u5dde\u4e16\u5b89\u4fe1\u606f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","pinyin_shortcut":"gzsaxxjsgfyxgs","type_display":"\u5ba2\u6237","type":"client","created_at":"2025-12-04 15:48:49","updated_at":"2026-05-15 13:07:30","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":3429,"key":3429,"name":"\u5e7f\u5dde\u4e16\u5b89\u4fe1\u606f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"user":"","contact":""},{"key":"11111","client_id":1111,"supplier_id":"","user_id":"","contact_id":"","sales_rep":5295,"name":"\u4e2d\u56fd\u79d1\u5b66\u9662\u884c\u653f\u7ba1\u7406\u5c40","pinyin_shortcut":"zgkxyxzglj","type_display":"\u5ba2\u6237","type":"client","created_at":"2018-08-27 11:47:28","updated_at":"2026-05-13 15:00:43","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":1111,"key":1111,"name":"\u4e2d\u56fd\u79d1\u5b66\u9662\u884c\u653f\u7ba1\u7406\u5c40"},"user":"","contact":""},{"key":"10043","client_id":"","supplier_id":"","user_id":1004,"contact_id":"","sales_rep":"","name":"\u4f0a\u5cfb\u8fb0","pinyin_shortcut":"yjc","type_display":"\u5185\u90e8\u5458\u5de5","type":"user","created_at":"2017-02-06 13:07:29","updated_at":"2026-05-12 09:32:50","un_collect_amount":"","un_collect_count":"","un_payment_amount":"","un_payment_count":"","ap_amount":"","oc_amount":"0","op_amount":"0","amount":"0","supplier":"","client":"","user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"},"contact":""},{"key":"26161","client_id":2616,"supplier_id":"","user_id":"","contact_id":"","sales_rep":1001,"name":"\u5317\u4eac\u6e90\u70b9\u601d\u535a\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","pinyin_shortcut":"bjydsbkjyxgsgd","type_display":"\u5ba2\u6237","type":"client","created_at":"2023-10-23 21:18:16","updated_at":"2026-05-09 18:11:24","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":2616,"key":2616,"name":"\u5317\u4eac\u6e90\u70b9\u601d\u535a\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"user":"","contact":""},{"key":"25381","client_id":2538,"supplier_id":"","user_id":"","contact_id":"","sales_rep":1001,"name":"(\u8fc7\u5355)\u5317\u4eac\u6606\u4ed1\u8054\u901a\u79d1\u6280\u53d1\u5c55\u80a1\u4efd\u6709\u9650\u516c\u53f8","pinyin_shortcut":"gdbjklltkjfzgfyxgs","type_display":"\u5ba2\u6237","type":"client","created_at":"2023-05-18 11:35:22","updated_at":"2026-05-09 18:10:57","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":2538,"key":2538,"name":"(\u8fc7\u5355)\u5317\u4eac\u6606\u4ed1\u8054\u901a\u79d1\u6280\u53d1\u5c55\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"user":"","contact":""},{"key":"1461","client_id":146,"supplier_id":"","user_id":"","contact_id":"","sales_rep":1001,"name":"smc(\u5929\u6d25)\u5236\u9020\u6709\u9650\u516c\u53f8-(\u91cd\u590d\u5ba2\u6237)","pinyin_shortcut":"smctjzzyxgscfkh","type_display":"\u5ba2\u6237","type":"client","created_at":"2017-03-06 15:44:05","updated_at":"2026-05-09 17:18:35","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":146,"key":146,"name":"smc(\u5929\u6d25)\u5236\u9020\u6709\u9650\u516c\u53f8-(\u91cd\u590d\u5ba2\u6237)"},"user":"","contact":""},{"key":"28031","client_id":2803,"supplier_id":"","user_id":"","contact_id":"","sales_rep":1001,"name":"\u62d3\u5b9e\u603b\u76d1\u4f1a","pinyin_shortcut":"tszjh","type_display":"\u5ba2\u6237","type":"client","created_at":"2024-03-04 13:47:14","updated_at":"2026-05-09 17:11:06","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":2803,"key":2803,"name":"\u62d3\u5b9e\u603b\u76d1\u4f1a"},"user":"","contact":""},{"key":"16611","client_id":1661,"supplier_id":"","user_id":"","contact_id":"","sales_rep":1001,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8","pinyin_shortcut":"bjwxykjyxgs","type_display":"\u5ba2\u6237","type":"client","created_at":"2020-06-23 16:16:09","updated_at":"2026-05-09 17:07:04","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":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":"","contact":""}],"countArr":[{"count":2689,"key":1,"name":"\u5f80\u6765\u5355\u4f4d\u603b\u6570","color":"#FEF7EC","border":"#FF9200","sum":2689},{"count":2689,"key":2,"name":"\u5e94\u4ed8\u6b3e","color":"#E7F3D5","border":"#70B603","sum":8817795.24},{"count":2689,"key":3,"name":"\u5e94\u6536\u6b3e","color":"#F1F2F5","border":"#555555","sum":91224639.49}],"count":2689,"un_payment_amount":"7656385.08","un_payment_count":"61","un_collect_amount":"90038893.71","un_collect_count":"66","ap_amount":"0","oc_amount":"1185745.78","op_amount":"1161410.16","amount":"82406844.25","pagenation":{"totalcount":2689,"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:22', 269391104) RETURNING "id"

[+] Explain