ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68975d837b1f5: GET https://beta.jinchangxiao.com/vue/analysis/purchase-payment-collection-by-times at 2025-08-09 10:38:59 pm by 114.119.152.128

Performance Profiling

Total processing time: 181 ms; Peak memory: 3.967 MB. Show Profiling Timeline

总计15条数据
TimeDurationCategoryInfo
  
22:38:59.61332.3 msyii\db\Command::querySELECT sum ( CASE WHEN collected >= total_this THEN 0 WHEN collected < total_this AND collected <= before_this_time THEN in_this_time WHEN collected < total_this AND collected > before_this_time THEN in_this_time - (collected - before_this_time) END ) as uncollected FROM (SELECT max(total_this) as total_this, max(in_this_time) as in_this_time, CASE WHEN MAX ( before_this_time ) IS NULL THEN 0 ELSE MAX ( before_this_time ) END AS before_this_time, case when MAX ( collected ) > 0 then MAX ( collected ) else 0 end AS collected, contract_id FROM (SELECT scpcrd.* ,( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_purchase_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ) ,( SELECT sum(scpcrdsub2.amount) as in_this_time FROM a57be577deb434.tbl_purchase_contract_payment_collection_remind_dates scpcrdsub2 where scpcrdsub2.remind_date <= scpcrd.remind_date and scpcrdsub2.contract_id = scpcrd.contract_id and ( "scpcrdsub2"."remind_date" >= '2025-08-01 00:00:00' ) AND ( "scpcrdsub2"."remind_date" <= '2025-08-31 23:59:59' ) ), ( SELECT sum(scpcrdsub3.amount) as before_this_time FROM a57be577deb434.tbl_purchase_contract_payment_collection_remind_dates scpcrdsub3 where scpcrdsub3.remind_date <= scpcrd.remind_date and scpcrdsub3.contract_id = scpcrd.contract_id and ( "scpcrdsub3"."remind_date" < '2025-08-01 00:00:00' ) ), case when p.collected is null then 0 else p.collected end as collected FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "sc" ON scpcrd.contract_id = sc.id LEFT JOIN (SELECT spc.id, spc.erp_settle_amount as collected FROM "a57be577deb434"."tbl_purchase_contracts" "spc" GROUP BY "spc"."id") "p" ON sc.id = p.id WHERE "scpcrd"."id" IN (SELECT "sub"."id" FROM (SELECT scpcrd.* ,( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_purchase_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ), case when p.collected is null then 0 else p.collected end as collected FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "sc" ON scpcrd.contract_id = sc.id LEFT JOIN (SELECT spc.id, spc.erp_settle_amount as collected FROM "a57be577deb434"."tbl_purchase_contracts" "spc" GROUP BY "spc"."id") "p" ON sc.id = p.id LEFT JOIN "a57be577deb434"."tbl_suppliers" "c" ON sc.supplier_id = c.id) "sub" LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "sc" ON sub.contract_id = sc.id WHERE (sc.is_draft = false) AND (sc.is_refuse = false) AND ((("sub"."remind_date" >= '2025-08-01 00:00:00') AND ("sub"."remind_date" <= '2025-08-31 23:59:59')) OR ((sub.collected < total_this) AND (CASE WHEN sub.remind_date <= '2025-08-09' THEN (total_this - sub.collected) ELSE 0 END > 0))) GROUP BY "sub"."id")) "sub" GROUP BY "contract_id") "sub2" WHERE collected < total_this
22:38:59.51528.7 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT sub.*, (total_this - sub.collected) as uncollected, CASE WHEN sub.remind_date <= '2025-08-09' THEN (total_this - sub.collected) ELSE 0 END as overdue, CASE WHEN sub.collected >= total_this THEN 1 ELSE 0 END as status, CASE WHEN sub.collected >= total_this THEN 2 ELSE ( CASE WHEN sub.remind_date <= '2025-08-09' THEN 1 ELSE 0 END ) END as status2 FROM (SELECT scpcrd.* ,( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_purchase_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ), case when p.collected is null then 0 else p.collected end as collected FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "sc" ON scpcrd.contract_id = sc.id LEFT JOIN (SELECT spc.id, spc.erp_settle_amount as collected FROM "a57be577deb434"."tbl_purchase_contracts" "spc" GROUP BY "spc"."id") "p" ON sc.id = p.id LEFT JOIN "a57be577deb434"."tbl_suppliers" "c" ON sc.supplier_id = c.id) "sub" LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "sc" ON sub.contract_id = sc.id WHERE (sc.is_draft = false) AND (sc.is_refuse = false) AND ((("sub"."remind_date" >= '2025-08-01 00:00:00') AND ("sub"."remind_date" <= '2025-08-31 23:59:59')) OR ((sub.collected < total_this) AND (CASE WHEN sub.remind_date <= '2025-08-09' THEN (total_this - sub.collected) ELSE 0 END > 0))) ORDER BY "sc"."signed_at" DESC, "sc"."created_at" DESC) "c"
22:38:59.64628.4 msyii\db\Command::querySELECT sum( CASE WHEN collected >= total_this THEN 0 ELSE total_this - collected END ) as overdue FROM (SELECT max(total_this) as total_this, max(in_this_time) as in_this_time, CASE WHEN MAX ( before_this_time ) IS NULL THEN 0 ELSE MAX ( before_this_time ) END AS before_this_time, case when MAX ( collected ) > 0 then MAX ( collected ) else 0 end AS collected, contract_id FROM (SELECT scpcrd.* ,( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_purchase_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ) ,( SELECT sum(scpcrdsub2.amount) as in_this_time FROM a57be577deb434.tbl_purchase_contract_payment_collection_remind_dates scpcrdsub2 where scpcrdsub2.remind_date <= scpcrd.remind_date and scpcrdsub2.contract_id = scpcrd.contract_id and ( "scpcrdsub2"."remind_date" >= '2025-08-01 00:00:00' ) AND ( "scpcrdsub2"."remind_date" <= '2025-08-31 23:59:59' ) ), ( SELECT sum(scpcrdsub3.amount) as before_this_time FROM a57be577deb434.tbl_purchase_contract_payment_collection_remind_dates scpcrdsub3 where scpcrdsub3.remind_date <= scpcrd.remind_date and scpcrdsub3.contract_id = scpcrd.contract_id and ( "scpcrdsub3"."remind_date" < '2025-08-01 00:00:00' ) ), case when p.collected is null then 0 else p.collected end as collected FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "sc" ON scpcrd.contract_id = sc.id LEFT JOIN (SELECT spc.id, spc.erp_settle_amount as collected FROM "a57be577deb434"."tbl_purchase_contracts" "spc" GROUP BY "spc"."id") "p" ON sc.id = p.id WHERE "scpcrd"."id" IN (SELECT "sub"."id" FROM (SELECT scpcrd.* ,( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_purchase_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ), case when p.collected is null then 0 else p.collected end as collected FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "sc" ON scpcrd.contract_id = sc.id LEFT JOIN (SELECT spc.id, spc.erp_settle_amount as collected FROM "a57be577deb434"."tbl_purchase_contracts" "spc" GROUP BY "spc"."id") "p" ON sc.id = p.id LEFT JOIN "a57be577deb434"."tbl_suppliers" "c" ON sc.supplier_id = c.id) "sub" LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "sc" ON sub.contract_id = sc.id WHERE (sc.is_draft = false) AND (sc.is_refuse = false) AND ((("sub"."remind_date" >= '2025-08-01 00:00:00') AND ("sub"."remind_date" <= '2025-08-31 23:59:59')) OR ((sub.collected < total_this) AND (CASE WHEN sub.remind_date <= '2025-08-09' THEN (total_this - sub.collected) ELSE 0 END > 0))) GROUP BY "sub"."id")) "sub" WHERE (sub.collected < sub.total_this) AND (remind_date <= '2025-08-09') AND ((("sub"."remind_date" >= '2025-08-01 00:00:00') AND ("sub"."remind_date" <= '2025-08-31 23:59:59')) OR ((sub.collected < total_this) AND (CASE WHEN sub.remind_date <= '2025-08-09' THEN (total_this - sub.collected) ELSE 0 END > 0))) GROUP BY "contract_id") "sub2"
22:38:59.58726.4 msyii\db\Command::querySELECT sum(amount) as budget FROM (SELECT scpcrd.* ,( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_purchase_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ) ,( SELECT sum(scpcrdsub2.amount) as in_this_time FROM a57be577deb434.tbl_purchase_contract_payment_collection_remind_dates scpcrdsub2 where scpcrdsub2.remind_date <= scpcrd.remind_date and scpcrdsub2.contract_id = scpcrd.contract_id and ( "scpcrdsub2"."remind_date" >= '2025-08-01 00:00:00' ) AND ( "scpcrdsub2"."remind_date" <= '2025-08-31 23:59:59' ) ), ( SELECT sum(scpcrdsub3.amount) as before_this_time FROM a57be577deb434.tbl_purchase_contract_payment_collection_remind_dates scpcrdsub3 where scpcrdsub3.remind_date <= scpcrd.remind_date and scpcrdsub3.contract_id = scpcrd.contract_id and ( "scpcrdsub3"."remind_date" < '2025-08-01 00:00:00' ) ), case when p.collected is null then 0 else p.collected end as collected FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "sc" ON scpcrd.contract_id = sc.id LEFT JOIN (SELECT spc.id, spc.erp_settle_amount as collected FROM "a57be577deb434"."tbl_purchase_contracts" "spc" GROUP BY "spc"."id") "p" ON sc.id = p.id WHERE "scpcrd"."id" IN (SELECT "sub"."id" FROM (SELECT scpcrd.* ,( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_purchase_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ), case when p.collected is null then 0 else p.collected end as collected FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "sc" ON scpcrd.contract_id = sc.id LEFT JOIN (SELECT spc.id, spc.erp_settle_amount as collected FROM "a57be577deb434"."tbl_purchase_contracts" "spc" GROUP BY "spc"."id") "p" ON sc.id = p.id LEFT JOIN "a57be577deb434"."tbl_suppliers" "c" ON sc.supplier_id = c.id) "sub" LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "sc" ON sub.contract_id = sc.id WHERE (sc.is_draft = false) AND (sc.is_refuse = false) AND ((("sub"."remind_date" >= '2025-08-01 00:00:00') AND ("sub"."remind_date" <= '2025-08-31 23:59:59')) OR ((sub.collected < total_this) AND (CASE WHEN sub.remind_date <= '2025-08-09' THEN (total_this - sub.collected) ELSE 0 END > 0))) GROUP BY "sub"."id")) "sub" WHERE (("sub"."remind_date" >= '2025-08-01 00:00:00') AND ("sub"."remind_date" <= '2025-08-31 23:59:59')) OR ((sub.collected < total_this) AND (CASE WHEN sub.remind_date <= '2025-08-09' THEN (total_this - sub.collected) ELSE 0 END > 0))
22:38:59.54325.9 msyii\db\Command::querySELECT sub.*, (total_this - sub.collected) as uncollected, CASE WHEN sub.remind_date <= '2025-08-09' THEN (total_this - sub.collected) ELSE 0 END as overdue, CASE WHEN sub.collected >= total_this THEN 1 ELSE 0 END as status, CASE WHEN sub.collected >= total_this THEN 2 ELSE ( CASE WHEN sub.remind_date <= '2025-08-09' THEN 1 ELSE 0 END ) END as status2 FROM (SELECT scpcrd.* ,( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_purchase_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ), case when p.collected is null then 0 else p.collected end as collected FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "sc" ON scpcrd.contract_id = sc.id LEFT JOIN (SELECT spc.id, spc.erp_settle_amount as collected FROM "a57be577deb434"."tbl_purchase_contracts" "spc" GROUP BY "spc"."id") "p" ON sc.id = p.id LEFT JOIN "a57be577deb434"."tbl_suppliers" "c" ON sc.supplier_id = c.id) "sub" LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "sc" ON sub.contract_id = sc.id WHERE (sc.is_draft = false) AND (sc.is_refuse = false) AND ((("sub"."remind_date" >= '2025-08-01 00:00:00') AND ("sub"."remind_date" <= '2025-08-31 23:59:59')) OR ((sub.collected < total_this) AND (CASE WHEN sub.remind_date <= '2025-08-09' THEN (total_this - sub.collected) ELSE 0 END > 0))) ORDER BY "sc"."signed_at" DESC, "sc"."created_at" DESC LIMIT 20
22:38:59.5749.1 msyii\db\Command::queryselect ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_purchase_contract_payment_collection_remind_dates' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
22:38:59.5704.4 msyii\db\Command::querySELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_purchase_contract_payment_collection_remind_dates' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
22:38:59.6753.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=23) AND ("visit_date"='2025-08-09')
22:38:59.5082.4 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
22:38:59.5061.9 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
22:38:59.6811.8 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/analysis/purchase-payment-collection-by-times', '[]', '{"code":2000,"result":{"list":[{"id":807,"contract_id":4070,"remind_date":"2025-07-28","reminded":true,"amount":"18000","paid_amount":"0","overdue_days":"","status":0,"total_this":"18000","collected":"0","uncollected":18000,"overdue":"18000","status2":1,"contract":{"id":4070,"supplier_id":138,"contract_type":1,"signed_at":"2025-07-25","amount":"18000.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-07-25 17:04:56","updated_at":"2025-07-28 10:08:54","client_id":"","project_id":"","sales_rep":"","serial_no":"H202507255159","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-25 17:05:06","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"18000","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"contract_type_display":"\u4ea7\u54c1\u5408\u540c"},"over_due_uncollected":18000,"over_due_display":"\u903e\u671f12\u5929","status_display":"\u672a\u5b8c\u6210"},{"id":806,"contract_id":4069,"remind_date":"2025-07-31","reminded":false,"amount":"130","paid_amount":"0","overdue_days":"","status":0,"total_this":"130","collected":"0","uncollected":130,"overdue":"130","status2":1,"contract":{"id":4069,"supplier_id":608,"contract_type":1,"signed_at":"2025-07-25","amount":"130.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-07-25 16:45:53","updated_at":"2025-07-25 16:46:01","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7: 4651203278745161702\t","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-25 16:46:01","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"130","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"contract_type_display":"\u4ea7\u54c1\u5408\u540c"},"over_due_uncollected":130,"over_due_display":"\u903e\u671f9\u5929","status_display":"\u672a\u5b8c\u6210"},{"id":805,"contract_id":4067,"remind_date":"2025-07-25","reminded":true,"amount":"397.01","paid_amount":"0","overdue_days":"","status":0,"total_this":"397.01","collected":"0","uncollected":397.01,"overdue":"397.01","status2":1,"contract":{"id":4067,"supplier_id":262,"contract_type":1,"signed_at":"2025-07-24","amount":"397.01","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-07-24 14:55:07","updated_at":"2025-07-24 14:55:19","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7\uff1a327559652672","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-24 14:55:19","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"397.01","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"contract_type_display":"\u4ea7\u54c1\u5408\u540c"},"over_due_uncollected":397.01,"over_due_display":"\u903e\u671f15\u5929","status_display":"\u672a\u5b8c\u6210"},{"id":804,"contract_id":4066,"remind_date":"2025-08-08","reminded":false,"amount":"520","paid_amount":"0","overdue_days":"","status":0,"total_this":"520","collected":"0","uncollected":520,"overdue":"520","status2":1,"contract":{"id":4066,"supplier_id":608,"contract_type":1,"signed_at":"2025-07-24","amount":"520.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-07-24 13:51:17","updated_at":"2025-07-24 13:51:34","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7: 4649415087350592710","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-24 13:51:34","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"520","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"contract_type_display":"\u4ea7\u54c1\u5408\u540c"},"over_due_uncollected":520,"over_due_display":"\u903e\u671f1\u5929","status_display":"\u672a\u5b8c\u6210"},{"id":802,"contract_id":4063,"remind_date":"2025-07-28","reminded":true,"amount":"3000","paid_amount":"0","overdue_days":"","status":0,"total_this":"3000","collected":"0","uncollected":3000,"overdue":"3000","status2":1,"contract":{"id":4063,"supplier_id":236,"contract_type":3,"signed_at":"2025-07-23","amount":"3000.00","handler":1011,"description":"PA\u914d\u7f6e\u7ffb\u8bd1\uff1b\n\u66ff\u6362\u8bbe\u5907\u5b9e\u65bd\uff08\u5468\u672b\uff09","contract_scan":"","created_by":1011,"created_at":"2025-07-23 14:42:05","updated_at":"2025-07-23 14:42:15","client_id":"","project_id":"","sales_rep":"","serial_no":"","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-23 14:42:15","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"3000","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"contract_type_display":"\u670d\u52a1\u5408\u540c"},"over_due_uncollected":3000,"over_due_display":"\u903e\u671f12\u5929","status_display":"\u672a\u5b8c\u6210"},{"id":801,"contract_id":4062,"remind_date":"2025-07-25","reminded":true,"amount":"2000","paid_amount":"0","overdue_days":"","status":0,"total_this":"2000","collected":"0","uncollected":2000,"overdue":"2000","status2":1,"contract":{"id":4062,"supplier_id":262,"contract_type":1,"signed_at":"2025-07-22","amount":"2000.00","handler":1011,"description":"\u5151\u4ed8\u79ef\u5206\u8f6c\u793c\u54c1\u5361\u91c7\u8d2d\u5408\u540c","contract_scan":"","created_by":1011,"created_at":"2025-07-23 10:52:39","updated_at":"2025-07-23 10:52:50","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7\uff1a 327609705325","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-23 10:52:50","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"2000","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"contract_type_display":"\u4ea7\u54c1\u5408\u540c"},"over_due_uncollected":2000,"over_due_display":"\u903e\u671f15\u5929","status_display":"\u672a\u5b8c\u6210"},{"id":797,"contract_id":4060,"remind_date":"2025-08-22","reminded":false,"amount":"49848","paid_amount":"0","overdue_days":"","status":0,"total_this":"49848","collected":"0","uncollected":49848,"overdue":"0","status2":0,"contract":{"id":4060,"supplier_id":505,"contract_type":1,"signed_at":"2025-07-21","amount":"49848.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-07-22 09:19:29","updated_at":"2025-07-22 09:19:50","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250721-ZHF-002","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-22 09:19:50","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"49848","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"supplier":{"id":505,"key":505,"name":"\u795e\u5dde\u6167\u667a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contract_type_display":"\u4ea7\u54c1\u5408\u540c"},"over_due_uncollected":0,"over_due_display":"","status_display":"\u672a\u5b8c\u6210"},{"id":799,"contract_id":4058,"remind_date":"2025-08-21","reminded":false,"amount":"250","paid_amount":"0","overdue_days":"","status":0,"total_this":"250","collected":"0","uncollected":250,"overdue":"0","status2":0,"contract":{"id":4058,"supplier_id":478,"contract_type":1,"signed_at":"2025-07-21","amount":"250.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-07-21 16:32:24","updated_at":"2025-07-22 10:53:23","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250721-HYF-003","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-22 10:53:23","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"250","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"supplier":{"id":478,"key":478,"name":"\u5317\u4eac\u957f\u987a\u7f51\u8054\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contract_type_display":"\u4ea7\u54c1\u5408\u540c"},"over_due_uncollected":0,"over_due_display":"","status_display":"\u672a\u5b8c\u6210"},{"id":800,"contract_id":4057,"remind_date":"2025-08-21","reminded":false,"amount":"520","paid_amount":"0","overdue_days":"","status":0,"total_this":"520","collected":"0","uncollected":520,"overdue":"0","status2":0,"contract":{"id":4057,"supplier_id":626,"contract_type":1,"signed_at":"2025-07-21","amount":"520.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-07-21 16:31:30","updated_at":"2025-07-22 13:26:17","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250721-HYF-002","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-22 13:26:17","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"520","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"supplier":{"id":626,"key":626,"name":"\u5317\u4eac\u6167\u79d1\u5929\u6b63\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contract_type_display":"\u4ea7\u54c1\u5408\u540c"},"over_due_uncollected":0,"over_due_display":"","status_display":"\u672a\u5b8c\u6210"},{"id":791,"contract_id":4053,"remind_date":"2025-08-21","reminded":false,"amount":"8000","paid_amount":"0","overdue_days":"","status":0,"total_this":"8000","collected":"0","uncollected":8000,"overdue":"0","status2":0,"contract":{"id":4053,"supplier_id":280,"contract_type":1,"signed_at":"2025-07-21","amount":"8000.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-07-21 13:22:15","updated_at":"2025-07-21 13:22:30","client_id":"","project_id":"","sales_rep":"","serial_no":"A20250721","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-21 13:22:30","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"8000","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"supplier":{"id":280,"key":280,"name":"\u5317\u4eac\u6210\u6d77\u661f\u6cb3\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contract_type_display":"\u4ea7\u54c1\u5408\u540c"},"over_due_uncollected":0,"over_due_display":"","status_display":"\u672a\u5b8c\u6210"},{"id":790,"contract_id":4052,"remind_date":"2025-07-31","reminded":false,"amount":"658.63","paid_amount":"0","overdue_days":"","status":0,"total_this":"658.63","collected":"0","uncollected":658.63,"overdue":"658.63","status2":1,"contract":{"id":4052,"supplier_id":608,"contract_type":1,"signed_at":"2025-07-21","amount":"658.63","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-07-21 11:21:01","updated_at":"2025-07-21 11:21:21","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7: 4643512058994592710\/4643515981688592710","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-21 11:21:21","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"658.63","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"contract_type_display":"\u4ea7\u54c1\u5408\u540c"},"over_due_uncollected":658.63,"over_due_display":"\u903e\u671f9\u5929","status_display":"\u672a\u5b8c\u6210"},{"id":786,"contract_id":4045,"remind_date":"2025-07-25","reminded":true,"amount":"197.75","paid_amount":"0","overdue_days":"","status":0,"total_this":"197.75","collected":"0","uncollected":197.75,"overdue":"197.75","status2":1,"contract":{"id":4045,"supplier_id":608,"contract_type":1,"signed_at":"2025-07-17","amount":"197.75","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-07-17 13:18:04","updated_at":"2025-07-17 13:18:21","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7: 4635961815999592710","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-17 13:18:21","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"197.75","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"contract_type_display":"\u4ea7\u54c1\u5408\u540c"},"over_due_uncollected":197.75,"over_due_display":"\u903e\u671f15\u5929","status_display":"\u672a\u5b8c\u6210"},{"id":784,"contract_id":4042,"remind_date":"2025-07-18","reminded":true,"amount":"260.52","paid_amount":"0","overdue_days":"","status":0,"total_this":"260.52","collected":"0","uncollected":260.52,"overdue":"260.52","status2":1,"contract":{"id":4042,"supplier_id":608,"contract_type":4,"signed_at":"2025-07-16","amount":"2147.52","handler":1011,"description":"\u6280\u672f\u90e8\u81ea\u7528-\u84dd\u5149\u5149\u9a71","contract_scan":"","created_by":1011,"created_at":"2025-07-16 15:47:04","updated_at":"2025-08-07 12:03:24","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7: 4634557275452161702","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-16 15:47:17","is_chargeback":false,"cost_type":2,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"2147.52","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"}},"contract_type_display":"\u8d39\u7528\u5408\u540c","over_due_uncollected":260.52,"over_due_display":"\u903e\u671f22\u5929","status_display":"\u672a\u5b8c\u6210"},{"id":777,"contract_id":4034,"remind_date":"2025-08-16","reminded":false,"amount":"7500","paid_amount":"0","overdue_days":"","status":0,"total_this":"15000","collected":"7500","uncollected":7500,"overdue":"0","status2":0,"contract":{"id":4034,"supplier_id":712,"contract_type":1,"signed_at":"2025-07-15","amount":"15000.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-07-15 11:34:17","updated_at":"2025-07-18 09:51:14","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250715-HYF-001","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-15 11:34:42","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"7500","erp_un_settle_amount":"7500","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"supplier":{"id":712,"key":712,"name":"\u5317\u4eac\u793a\u76ee\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contract_type_display":"\u4ea7\u54c1\u5408\u540c"},"over_due_uncollected":0,"over_due_display":"","status_display":"\u672a\u5b8c\u6210"},{"id":785,"contract_id":4032,"remind_date":"2025-08-15","reminded":false,"amount":"85150","paid_amount":"0","overdue_days":"","status":0,"total_this":"85150","collected":"0","uncollected":85150,"overdue":"0","status2":0,"contract":{"id":4032,"supplier_id":107,"contract_type":1,"signed_at":"2025-07-14","amount":"85150.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-07-15 10:23:01","updated_at":"2025-07-17 11:48:33","client_id":"","project_id":"","sales_rep":"","serial_no":"BJ-RCRT-2025-07-14-001","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-16 15:51:52","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"85150","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"supplier":{"id":107,"key":107,"name":"\u5317\u4eac\u878d\u521b\u777f\u901a\u6280\u672f\u5f00\u53d1\u6709\u9650\u516c\u53f8"},"contract_type_display":"\u4ea7\u54c1\u5408\u540c"},"over_due_uncollected":0,"over_due_display":"","status_display":"\u672a\u5b8c\u6210"},{"id":771,"contract_id":4031,"remind_date":"2025-08-22","reminded":false,"amount":"122524","paid_amount":"0","overdue_days":"","status":0,"total_this":"122524","collected":"0","uncollected":122524,"overdue":"0","status2":0,"contract":{"id":4031,"supplier_id":660,"contract_type":3,"signed_at":"2025-07-14","amount":"122524.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-07-14 16:17:55","updated_at":"2025-07-14 16:18:24","client_id":"","project_id":"","sales_rep":"","serial_no":"SLKX20250714001","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-14 16:18:24","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"122524","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"supplier":{"id":660,"key":660,"name":"\u5317\u4eac\u601d\u8054\u79d1\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contract_type_display":"\u670d\u52a1\u5408\u540c"},"over_due_uncollected":0,"over_due_display":"","status_display":"\u672a\u5b8c\u6210"},{"id":775,"contract_id":4030,"remind_date":"2025-08-15","reminded":false,"amount":"4250","paid_amount":"0","overdue_days":"","status":0,"total_this":"4250","collected":"0","uncollected":4250,"overdue":"0","status2":0,"contract":{"id":4030,"supplier_id":59,"contract_type":1,"signed_at":"2025-07-14","amount":"4250.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-07-14 15:29:08","updated_at":"2025-07-25 16:10:07","client_id":"","project_id":"","sales_rep":"","serial_no":"","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-15 11:25:41","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"4250","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"supplier":{"id":59,"key":59,"name":"\u5317\u4eac\u592a\u8c37\u8baf\u8bda\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"contract_type_display":"\u4ea7\u54c1\u5408\u540c"},"over_due_uncollected":0,"over_due_display":"","status_display":"\u672a\u5b8c\u6210"},{"id":766,"contract_id":4017,"remind_date":"2025-08-25","reminded":false,"amount":"150270","paid_amount":"0","overdue_days":"","status":0,"total_this":"150270","collected":"0","uncollected":150270,"overdue":"0","status2":0,"contract":{"id":4017,"supplier_id":68,"contract_type":1,"signed_at":"2025-07-08","amount":"150270.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-07-08 15:31:47","updated_at":"2025-07-23 14:15:57","client_id":"","project_id":"","sales_rep":"","serial_no":"Zstack-BJ7067-20250528","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-08 15:32:15","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"150270","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"contract_type_display":"\u4ea7\u54c1\u5408\u540c"},"over_due_uncollected":0,"over_due_display":"","status_display":"\u672a\u5b8c\u6210"},{"id":762,"contract_id":4013,"remind_date":"2025-08-05","reminded":false,"amount":"9250","paid_amount":"0","overdue_days":"","status":0,"total_this":"9250","collected":"0","uncollected":9250,"overdue":"9250","status2":1,"contract":{"id":4013,"supplier_id":659,"contract_type":3,"signed_at":"2025-07-04","amount":"9250.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-07-04 09:50:47","updated_at":"2025-07-10 11:32:38","client_id":"","project_id":"","sales_rep":"","serial_no":"XM2025070400024","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-04 09:52:07","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"9250","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"supplier":{"id":659,"key":659,"name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"},"contract_type_display":"\u670d\u52a1\u5408\u540c"},"over_due_uncollected":9250,"over_due_display":"\u903e\u671f4\u5929","status_display":"\u672a\u5b8c\u6210"},{"id":757,"contract_id":4010,"remind_date":"2025-08-01","reminded":false,"amount":"23600","paid_amount":"0","overdue_days":"","status":0,"total_this":"23600","collected":"0","uncollected":23600,"overdue":"23600","status2":1,"contract":{"id":4010,"supplier_id":626,"contract_type":1,"signed_at":"2025-07-01","amount":"23600.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-07-01 14:33:44","updated_at":"2025-07-01 15:12:34","client_id":"","project_id":"","sales_rep":"","serial_no":"HKTZ20250701WF001","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-01 14:34:01","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"23600","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"supplier":{"id":626,"key":626,"name":"\u5317\u4eac\u6167\u79d1\u5929\u6b63\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contract_type_display":"\u4ea7\u54c1\u5408\u540c"},"over_due_uncollected":23600,"over_due_display":"\u903e\u671f8\u5929","status_display":"\u672a\u5b8c\u6210"}],"count":{"budget":"4801106.29","uncollected":"699033","overdue":"4106223.29"},"pagenation":{"totalcount":50,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-09 22:38:59') RETURNING "id"
22:38:59.5111.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
22:38:59.5841.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (4070, 4069, 4067, 4066, 4063, 4062, 4060, 4058, 4057, 4053, 4052, 4045, 4042, 4034, 4032, 4031, 4030, 4017, 4013, 4010)
22:38:59.6800.9 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=76, "last_visit_at"='now()' WHERE "id"=54996
22:38:59.5850.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (478, 138, 626, 608, 262, 280, 68, 505, 236, 659, 59, 107, 660, 712)