ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c3cd1199d12: POST https://beta.jinchangxiao.com/vue/analysis/collect-list at 2025-09-12 03:34:41 pm by 114.246.237.213

Performance Profiling

Total processing time: 45 ms; Peak memory: 5.195 MB. Show Profiling Timeline

总计15条数据
TimeDurationCategoryInfo
  
15:34:41.6425.8 msyii\db\Command::querySELECT SUM(amount) FROM (SELECT "scp".* FROM (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1)) )) "sub") "scp" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "c" ON c.id = scp.contract_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON c.from_project = p.id WHERE ("scp"."collected_date" >= '2025-01-01') AND ("scp"."collected_date" <= '2025-12-31') AND (p.id is not null) AND ("p"."created_by"='1001') ORDER BY scp.created_at DESC NULLS LAST, scp.id desc) "c"
15:34:41.6574.5 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_erp_collect_ticket_settles' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
15:34:41.6533.9 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_erp_collect_ticket_settles' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
15:34:41.6663.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=23) AND ("visit_date"='2025-09-12')
15:34:41.6482.6 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT "scp".* FROM (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1)) )) "sub") "scp" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "c" ON c.id = scp.contract_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON c.from_project = p.id WHERE ("scp"."collected_date" >= '2025-01-01') AND ("scp"."collected_date" <= '2025-12-31') AND (p.id is not null) AND ("p"."created_by"='1001') ORDER BY scp.created_at DESC NULLS LAST, scp.id desc) "c"
15:34:41.6512.6 msyii\db\Command::querySELECT "scp".* FROM (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1)) )) "sub") "scp" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "c" ON c.id = scp.contract_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON c.from_project = p.id WHERE ("scp"."collected_date" >= '2025-01-01') AND ("scp"."collected_date" <= '2025-12-31') AND (p.id is not null) AND ("p"."created_by"='1001') ORDER BY scp.created_at DESC NULLS LAST, scp.id desc LIMIT 20
15:34:41.6332.2 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
15:34:41.6311.9 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:34:41.6361.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:34:41.6711.4 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/collect-list', '{"dataUserId":"1001","page":"1","status":"collected","web_access_token":"2BZqbE639wqIoHhgH0VfUgn-meZYtkbz"}', '{"code":2000,"result":{"list":[{"id":"12022","ticket_type":1,"contract_id":4112,"amount":"1","collected_date":"2025-09-04 10:32:38","created_at":"2025-09-04 10:32:38","created_by":1001,"description":"\u505c\u7528","project":{"id":3927,"key":3927,"name":"PA VM\u9632\u706b\u5899\u7ef4\u4fdd\u7eed\u7ea6","budget":"40932","bargain_date":"2025-08-22","created_by":1001,"client_id":3286,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-09-04"},{"id":"12021","ticket_type":1,"contract_id":4131,"amount":"80000","collected_date":"2025-09-04 09:20:43","created_at":"2025-09-04 09:20:43","created_by":1001,"description":"","project":{"id":3950,"key":3950,"name":"\u6d4b-\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355\uff1a\u6df1\u4fe1\u670d\u9632\u706b\u5899AF-1000-FH2300B","budget":"80000","bargain_date":"2025-08-21","created_by":1001,"client_id":3389,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"}},"created_at_display":"2025-09-04"},{"id":"1363","ticket_type":1,"contract_id":3978,"amount":"17500","collected_date":"2025-06-30 09:53:22","created_at":"2025-06-30 09:53:22","created_by":1013,"description":null,"project":{"id":3890,"key":3890,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899+\u9510\u6377\u4ea4\u6362\u673a\u91c7\u8d2d\u9879\u76ee","budget":"35000","bargain_date":"2025-06-16","created_by":1001,"client_id":3372,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":3372,"key":3372,"name":"\u6d77\u5357\u65f6\u4ee3\u5171\u8d62\u79c1\u52df\u57fa\u91d1\u7ba1\u7406\u5408\u4f19\u4f01\u4e1a\uff08\u6709\u9650\u5408\u4f19\uff09"}},"created_at_display":"2025-06-30"},{"id":"1358","ticket_type":1,"contract_id":3997,"amount":"8982","collected_date":"2025-06-26 16:37:30","created_at":"2025-06-26 16:37:30","created_by":1013,"description":null,"project":{"id":3899,"key":3899,"name":"AF-1000-FH1300A\u9632\u706b\u5899\u4e00\u5e74\u7eed\u4fdd\u9879\u76ee","budget":"8982","bargain_date":"2025-06-24","created_by":1001,"client_id":2545,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-06-26"},{"id":"1340","ticket_type":1,"contract_id":3935,"amount":"32557","collected_date":"2025-06-19 17:57:49","created_at":"2025-06-19 17:57:49","created_by":1013,"description":null,"project":{"id":3872,"key":3872,"name":"PA1410 Bundle Lic\u91c7\u8d2d\u9879\u76ee","budget":"32557","bargain_date":"2025-05-28","created_by":1001,"client_id":2845,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":2845,"key":2845,"name":"\u5317\u4eac\u6052\u6cf0\u901a\u529b\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08PA\u8fc7\u5355\uff09"}},"created_at_display":"2025-06-19"},{"id":"1362","ticket_type":1,"contract_id":3978,"amount":"17500","collected_date":"2025-06-17 11:10:10","created_at":"2025-06-17 11:10:10","created_by":1013,"description":null,"project":{"id":3890,"key":3890,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899+\u9510\u6377\u4ea4\u6362\u673a\u91c7\u8d2d\u9879\u76ee","budget":"35000","bargain_date":"2025-06-16","created_by":1001,"client_id":3372,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":3372,"key":3372,"name":"\u6d77\u5357\u65f6\u4ee3\u5171\u8d62\u79c1\u52df\u57fa\u91d1\u7ba1\u7406\u5408\u4f19\u4f01\u4e1a\uff08\u6709\u9650\u5408\u4f19\uff09"}},"created_at_display":"2025-06-17"},{"id":"1317","ticket_type":1,"contract_id":3916,"amount":"570000","collected_date":"2025-06-17 10:13:55","created_at":"2025-06-17 10:13:55","created_by":1013,"description":null,"project":{"id":3857,"key":3857,"name":"PA1410 \u4e09\u5e74\u670d\u52a13\u53f0\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee","budget":"570000","bargain_date":"2025-05-19","created_by":1001,"client_id":3364,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":3364,"key":3364,"name":"\u5317\u4eac\u6781\u901a\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"}},"created_at_display":"2025-06-17"},{"id":"1349","ticket_type":1,"contract_id":3967,"amount":"26550","collected_date":"2025-06-12 14:02:12","created_at":"2025-06-12 14:02:12","created_by":1013,"description":null,"project":{"id":3886,"key":3886,"name":"SR650\u670d\u52a1\u5668\u914d\u4ef6\u91c7\u8d2d\u9879\u76ee","budget":"26550","bargain_date":"2025-06-09","created_by":1001,"client_id":2545,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-06-12"},{"id":"1325","ticket_type":1,"contract_id":3900,"amount":"40630","collected_date":"2025-05-16 11:46:39","created_at":"2025-05-16 11:46:39","created_by":1013,"description":null,"project":{"id":3855,"key":3855,"name":"\u8054\u60f3SR650\u4e8c\u624b\u670d\u52a1\u5668\u91c7\u8d2d\u9879\u76ee\u56db","budget":"40630","bargain_date":"2025-05-13","created_by":1001,"client_id":2545,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-05-16"},{"id":"1274","ticket_type":1,"contract_id":3857,"amount":"3994","collected_date":"2025-04-08 14:54:29","created_at":"2025-04-08 14:54:29","created_by":1013,"description":null,"project":{"id":3816,"key":3816,"name":"\u5357\u975e\u7ea2\u77f3\u9879\u76ee\u6570\u636e\u7f51PA440\u8bbe\u5907\u7eed\u4fdd","budget":"3994","bargain_date":"2025-04-07","created_by":1001,"client_id":2117,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":2117,"key":2117,"name":"\u6c5f\u82cf\u9ed1\u9a6c\u9ad8\u79d1\u80a1\u4efd\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-04-08"},{"id":"1265","ticket_type":1,"contract_id":3803,"amount":"3048204","collected_date":"2025-03-28 14:27:23","created_at":"2025-03-28 14:27:23","created_by":1013,"description":null,"project":{"id":3786,"key":3786,"name":"\u8fdc\u9274\u8f6f\u4ef6-\u8fc7\u7a0b\u76d1\u63a7\u4ea7\u54c1","budget":"3048204","bargain_date":"2025-02-28","created_by":1001,"client_id":3334,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":3334,"key":3334,"name":"\u5317\u4eac\u878d\u9890\u5149\u7535\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"}},"created_at_display":"2025-03-28"},{"id":"1304","ticket_type":1,"contract_id":3724,"amount":"12600.9","collected_date":"2025-03-12 17:16:52","created_at":"2025-03-12 17:16:52","created_by":1013,"description":null,"project":{"id":3744,"key":3744,"name":"PA440 2\u53f0\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee","budget":"126009","bargain_date":"2024-12-25","created_by":1001,"client_id":3327,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":3327,"key":3327,"name":"\u4fe1\u8054\u6cfd\u90a6\uff08\u9752\u5c9b\uff09\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"}},"created_at_display":"2025-03-12"},{"id":"1273","ticket_type":1,"contract_id":3763,"amount":"12136.1","collected_date":"2025-03-12 17:16:37","created_at":"2025-03-12 17:16:37","created_by":1013,"description":null,"project":{"id":3767,"key":3767,"name":"PA440 2\u53f0\u8bbe\u5907\u65b0\u8d2d\u9879\u76ee\u4e8c","budget":"121361","bargain_date":"2025-01-16","created_by":1001,"client_id":3327,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":3327,"key":3327,"name":"\u4fe1\u8054\u6cfd\u90a6\uff08\u9752\u5c9b\uff09\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"}},"created_at_display":"2025-03-12"},{"id":"1272","ticket_type":1,"contract_id":3763,"amount":"84952.7","collected_date":"2025-03-05 11:48:47","created_at":"2025-03-05 11:48:47","created_by":1013,"description":null,"project":{"id":3767,"key":3767,"name":"PA440 2\u53f0\u8bbe\u5907\u65b0\u8d2d\u9879\u76ee\u4e8c","budget":"121361","bargain_date":"2025-01-16","created_by":1001,"client_id":3327,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":3327,"key":3327,"name":"\u4fe1\u8054\u6cfd\u90a6\uff08\u9752\u5c9b\uff09\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"}},"created_at_display":"2025-03-05"},{"id":"1206","ticket_type":1,"contract_id":3703,"amount":"319460.45","collected_date":"2025-02-24 10:15:41","created_at":"2025-02-24 10:15:41","created_by":1013,"description":null,"project":{"id":3723,"key":3723,"name":"PAN-M-300\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee","budget":"319460.45","bargain_date":"2024-12-11","created_by":1001,"client_id":3304,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":3304,"key":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"}},"created_at_display":"2025-02-24"},{"id":"1277","ticket_type":1,"contract_id":3724,"amount":"88206.3","collected_date":"2025-02-10 15:25:51","created_at":"2025-02-10 15:25:51","created_by":1013,"description":null,"project":{"id":3744,"key":3744,"name":"PA440 2\u53f0\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee","budget":"126009","bargain_date":"2024-12-25","created_by":1001,"client_id":3327,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":3327,"key":3327,"name":"\u4fe1\u8054\u6cfd\u90a6\uff08\u9752\u5c9b\uff09\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"}},"created_at_display":"2025-02-10"},{"id":"1243","ticket_type":1,"contract_id":3502,"amount":"120000","collected_date":"2025-01-24 10:45:26","created_at":"2025-01-24 10:45:26","created_by":1013,"description":null,"project":{"id":3644,"key":3644,"name":"PA820\u9632\u706b\u58993\u5e74\u670d\u52a1\u91c7\u8d2d\u9879\u76ee","budget":"120000","bargain_date":"2024-08-28","created_by":1001,"client_id":2553,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-01-24"},{"id":"1242","ticket_type":1,"contract_id":3755,"amount":"122000","collected_date":"2025-01-24 10:41:10","created_at":"2025-01-24 10:41:10","created_by":1013,"description":null,"project":{"id":3764,"key":3764,"name":"PA1410 \u4e24\u53f0\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee","budget":"122000","bargain_date":"2025-01-13","created_by":1001,"client_id":2616,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":2616,"key":2616,"name":"\u5317\u4eac\u6e90\u70b9\u601d\u535a\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"}},"created_at_display":"2025-01-24"},{"id":"1235","ticket_type":1,"contract_id":3725,"amount":"87000","collected_date":"2025-01-21 09:55:18","created_at":"2025-01-21 09:55:18","created_by":1013,"description":null,"project":{"id":3752,"key":3752,"name":"PA440 ATP\/AWF\/ADVURL \u6388\u6743\u65b0\u8d2d\u9879\u76ee","budget":"87000","bargain_date":"2024-12-25","created_by":1001,"client_id":2553,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-01-21"},{"id":"1225","ticket_type":1,"contract_id":3746,"amount":"60945","collected_date":"2025-01-17 14:41:35","created_at":"2025-01-17 14:41:35","created_by":1013,"description":null,"project":{"id":3760,"key":3760,"name":"\u8054\u60f33\u5957\u4e8c\u624b\u670d\u52a1\u5668SR650\u91c7\u8d2d\u9879\u76ee","budget":"121890","bargain_date":"2025-01-08","created_by":1001,"client_id":2545,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-01-17"}],"sumAmount":"4863638.45","pagenation":{"totalcount":23,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-12 15:34:41') RETURNING "id"
15:34:41.6621.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id" IN (4112, 4131, 3978, 3997, 3935, 3916, 3967, 3900, 3857, 3803, 3724, 3763, 3703, 3502, 3755, 3725, 3746)
15:34:41.6700.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=90, "last_visit_at"='now()' WHERE "id"=56539
15:34:41.6650.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3389, 2616, 2553, 2545, 3327, 3372, 3334, 3304, 2117, 3364, 2845, 3286)
15:34:41.6640.4 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "budget", "bargain_date", "created_by", "client_id" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3644, 3723, 3767, 3764, 3744, 3752, 3760, 3786, 3816, 3872, 3857, 3855, 3886, 3890, 3899, 3927, 3950)
15:34:41.6640.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001