ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6949fcb4a1c38: POST https://beta.jinchangxiao.com/vue/analysis/collect-list at 2025-12-23 10:21:40 am by 223.72.15.12

Database Queries

总计13条数据
TimeDurationTypeQuery
  
10:21:40.6662.2 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
10:21:40.6690.5 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
10:21:40.6701.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
10:21:40.6755.8 msSELECTSELECT 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))) 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"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) ) 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"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) )) "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" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420', '5448', '5449')) ORDER BY scp.created_at DESC NULLS LAST, scp.id desc) "c"

[+] Explain
10:21:40.6813.2 msSELECTSELECT 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))) 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"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) ) 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"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) )) "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" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420', '5448', '5449')) ORDER BY scp.created_at DESC NULLS LAST, scp.id desc) "c"

[+] Explain
10:21:40.6843.2 msSELECTSELECT "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))) 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"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) ) 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"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) )) "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" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420', '5448', '5449')) ORDER BY scp.created_at DESC NULLS LAST, scp.id desc LIMIT 20 OFFSET 160

[+] Explain
10:21:40.6880.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id" IN (3736, 3842, 3854, 3797, 3857, 3812, 3342, 3816, 3792, 3005, 3477, 3803, 3805, 3841, 3838, 2925, 3567, 3833, 3626, 3822)

[+] Explain
10:21:40.6890.4 msSELECTSELECT "id", "id" AS "key", "project_title" AS "name", "budget", "bargain_date", "created_by", "client_id" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3784, 3785, 3562, 3672, 3609, 3694, 3720, 3786, 3788, 3809, 3806, 3782, 3792, 3794, 3793, 3804, 3808, 3816, 3322, 3319)

[+] Explain
10:21:40.6900.3 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 5300, 5295, 1001, 1004)

[+] Explain
10:21:40.6902.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (57, 287, 3340, 2021, 12, 2736, 149, 2546, 3334, 518, 2226, 20, 2091, 2117, 2596, 2594)

[+] Explain
10:21:40.6933.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=23) AND ("visit_date"='2025-12-23')

[+] Explain
10:21:40.6980.8 msUPDATEUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=91, "last_visit_at"='now()' WHERE "id"=59629

[+] Explain
10:21:40.6991.5 msINSERTINSERT 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,1004,1005,1013,5087,5295,5300,5311,5329,5332,5420,5448,5449","page":"9","status":"collected","web_access_token":"yb8YvQDqCxvGUQWSJnYL2S9XtkD7pVRr"}', '{"code":2000,"result":{"list":[{"id":"1215","ticket_type":1,"contract_id":3736,"amount":"452575","collected_date":"2025-04-14 17:17:24","created_at":"2025-04-14 17:17:24","created_by":1013,"description":null,"project":{"id":3720,"key":3720,"name":"\u81ea\u52a8\u5316\u8bbe\u5907\u4e09\u671f","budget":"905150","bargain_date":"2024-12-24","created_by":1005,"client_id":149,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1},"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)\uff08\u71d5\u4eac\uff09"}},"created_at_display":"2025-04-14"},{"id":"1291","ticket_type":1,"contract_id":3842,"amount":"50000","collected_date":"2025-04-14 11:35:12","created_at":"2025-04-14 11:35:12","created_by":1013,"description":null,"project":{"id":3809,"key":3809,"name":"\u601d\u4eab\u6df1\u4fe1\u670dEDR2025\u5e74\u7eed\u4fdd","budget":"50000","bargain_date":"2025-03-18","created_by":1005,"client_id":2226,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1},"client":{"id":2226,"key":2226,"name":"\u5317\u4eac\u767e\u8fbe\u4fe1\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"}},"created_at_display":"2025-04-14"},{"id":"1289","ticket_type":1,"contract_id":3854,"amount":"75500","collected_date":"2025-04-11 17:05:11","created_at":"2025-04-11 17:05:11","created_by":1013,"description":null,"project":{"id":3784,"key":3784,"name":"\u6570\u636e\u6062\u590d-K-2025","budget":"151000","bargain_date":"2025-04-03","created_by":5300,"client_id":12,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-04-11"},{"id":"1287","ticket_type":1,"contract_id":3797,"amount":"10800","collected_date":"2025-04-09 17:05:39","created_at":"2025-04-09 17:05:39","created_by":1013,"description":null,"project":{"id":3785,"key":3785,"name":"2025\u65b0\u8d2dUPS","budget":"10800","bargain_date":"2025-02-21","created_by":5295,"client_id":2546,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1},"client":{"id":2546,"key":2546,"name":"\u5317\u4eac\u534e\u4e9a\u4e16\u7eaa\u7535\u5b50\u6280\u672f\u6709\u9650\u516c\u53f8-\u96c6\u6210\u5546"}},"created_at_display":"2025-04-09"},{"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":"1286","ticket_type":1,"contract_id":3812,"amount":"500","collected_date":"2025-04-07 09:35:18","created_at":"2025-04-07 09:35:18","created_by":1013,"description":null,"project":{"id":3792,"key":3792,"name":"IBM\u7535\u6e90\u66f4\u6362","budget":"500","bargain_date":"2025-03-06","created_by":1005,"client_id":20,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1},"client":{"id":20,"key":20,"name":"\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u3001\u56fd\u673a\u91cd\u578b\u88c5\u5907(\u67ec\u57d4\u5be8\u8fbe\u5cb1\u6c34\u7535\u6709\u9650\u516c\u53f8)"}},"created_at_display":"2025-04-07"},{"id":"1278","ticket_type":1,"contract_id":3342,"amount":"10500","collected_date":"2025-04-03 17:52:33","created_at":"2025-04-03 17:52:33","created_by":1013,"description":null,"project":{"id":3562,"key":3562,"name":"\u4e0a\u6d77-\u601d\u79d1ISE\u7eed\u4fdd-\u601d\u8054\u79d1\u8baf-PO#20240607093","budget":"10500","bargain_date":"2024-06-07","created_by":1005,"client_id":57,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1},"client":{"id":57,"key":57,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8"}},"created_at_display":"2025-04-03"},{"id":"1216","ticket_type":1,"contract_id":3816,"amount":"511","collected_date":"2025-04-03 16:46:05","created_at":"2025-04-03 16:46:05","created_by":1013,"description":null,"project":{"id":3794,"key":3794,"name":"POBJ25031110-\u56fa\u6001\u786c\u76d8-G-2025","budget":"511","bargain_date":"2025-03-06","created_by":5300,"client_id":12,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-04-03"},{"id":"1285","ticket_type":1,"contract_id":3792,"amount":"629","collected_date":"2025-04-03 16:45:33","created_at":"2025-04-03 16:45:33","created_by":1013,"description":null,"project":{"id":3782,"key":3782,"name":"POBJ25024486-\u56fa\u6001\u786c\u76d8-G-2025","budget":"629","bargain_date":"2025-02-24","created_by":5300,"client_id":12,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-04-03"},{"id":"1284","ticket_type":1,"contract_id":3005,"amount":"179325","collected_date":"2025-04-03 16:41:58","created_at":"2025-04-03 16:41:58","created_by":1013,"description":null,"project":{"id":3322,"key":3322,"name":"\u4e2d\u5316\u80fd\u6e90\u9752\u85e4\u5b89\u5168\u4ea7\u54c1","budget":"597750","bargain_date":"2024-01-15","created_by":1005,"client_id":2596,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1},"client":{"id":2596,"key":2596,"name":"\u4eac\u4e1c\u4e91\u8ba1\u7b97\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"}},"created_at_display":"2025-04-03"},{"id":"1281","ticket_type":1,"contract_id":3477,"amount":"270000","collected_date":"2025-03-31 17:41:29","created_at":"2025-03-31 17:41:29","created_by":1013,"description":null,"project":{"id":3609,"key":3609,"name":"\u601d\u79d1N9K\u7b49\u7eed\u4fdd\u9879\u76ee","budget":"300000","bargain_date":"2024-08-05","created_by":1004,"client_id":2091,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1},"client":{"id":2091,"key":2091,"name":"\u795e\u5dde\u6570\u7801\u7cfb\u7edf\u96c6\u6210\u670d\u52a1\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-03-31"},{"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":"1305","ticket_type":1,"contract_id":3805,"amount":"1200","collected_date":"2025-03-27 16:43:48","created_at":"2025-03-27 16:43:48","created_by":1013,"description":null,"project":{"id":3788,"key":3788,"name":"\u65b0\u8d2d\u670d\u52a1\u5668\u786c\u76d8","budget":"1200","bargain_date":"2025-03-17","created_by":5295,"client_id":518,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1},"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-03-27"},{"id":"1231","ticket_type":1,"contract_id":3841,"amount":"720","collected_date":"2025-03-27 16:41:00","created_at":"2025-03-27 16:41:00","created_by":1013,"description":null,"project":{"id":3808,"key":3808,"name":"\u786c\u76d8-HP P2000-SAS 450GB-20250327","budget":"720","bargain_date":"2025-03-27","created_by":5300,"client_id":2021,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1},"client":{"id":2021,"key":2021,"name":"\u65b0\u7586\u535a\u4f17\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-03-27"},{"id":"1283","ticket_type":1,"contract_id":3838,"amount":"25920","collected_date":"2025-03-26 09:33:27","created_at":"2025-03-26 09:33:27","created_by":1013,"description":null,"project":{"id":3806,"key":3806,"name":"\u65b0\u8d2d\u6df1\u4fe1\u670d\u9632\u706b\u5899","budget":"25920","bargain_date":"2025-03-24","created_by":5295,"client_id":3340,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1},"client":{"id":3340,"key":3340,"name":"\u5317\u4eac\u661f\u8fb0\u672a\u6765\u7a7a\u95f4\u6280\u672f\u7814\u7a76\u9662\uff08\u8fc7\u5355\uff09"}},"created_at_display":"2025-03-26"},{"id":"1282","ticket_type":1,"contract_id":2925,"amount":"60000","collected_date":"2025-03-20 17:16:13","created_at":"2025-03-20 17:16:13","created_by":1013,"description":null,"project":{"id":3319,"key":3319,"name":"23-24\u5e74zstack\u539f\u5382\u8fd0\u7ef4\u670d\u52a1","budget":"60000","bargain_date":"2023-11-01","created_by":1005,"client_id":2594,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1},"client":{"id":2594,"key":2594,"name":"\u4e2d\u77f3\u6cb9\u4e2d\u4e9a\u5929\u7136\u6c14\u7ba1\u9053\u6709\u9650\u516c\u53f8\/\u4e2d\u6cb9\u56fd\u9645\u7ba1\u9053\u516c\u53f8\uff08\u8fc7\u5355\uff09"}},"created_at_display":"2025-03-20"},{"id":"1280","ticket_type":1,"contract_id":3567,"amount":"271822","collected_date":"2025-03-20 17:15:19","created_at":"2025-03-20 17:15:19","created_by":1013,"description":null,"project":{"id":3672,"key":3672,"name":"\u6c5f\u82cf\u65e0\u9521-PO\uff1a20240926023-20240927033\uff0824\u5e74-25\u5e74PA\u7eed\u4fdd\uff09","budget":"271822","bargain_date":"2024-09-12","created_by":1005,"client_id":57,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1},"client":{"id":57,"key":57,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8"}},"created_at_display":"2025-03-20"},{"id":"1275","ticket_type":1,"contract_id":3833,"amount":"720","collected_date":"2025-03-20 17:12:15","created_at":"2025-03-20 17:12:15","created_by":1013,"description":null,"project":{"id":3804,"key":3804,"name":"\u786c\u76d8-HP P2000-SAS 450GB-2025","budget":"720","bargain_date":"2025-03-20","created_by":5300,"client_id":2021,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1},"client":{"id":2021,"key":2021,"name":"\u65b0\u7586\u535a\u4f17\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-03-20"},{"id":"1270","ticket_type":1,"contract_id":3626,"amount":"598350","collected_date":"2025-03-19 17:14:36","created_at":"2025-03-19 17:14:36","created_by":1013,"description":null,"project":{"id":3694,"key":3694,"name":"PA\u9632\u706b\u5899\u65b0\u8d2d-2024-C","budget":"2672450","bargain_date":"2024-12-31","created_by":5300,"client_id":287,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1},"client":{"id":287,"key":287,"name":"\u5317\u4eac\u5954\u9a70\u6c7d\u8f66\u6709\u9650\u516c\u53f8\uff08\u70df\u53f0\u4fca\u9a70\u7535\u6c14\u81ea\u52a8\u5316\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u6d69\u60a6\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8\uff09"}},"created_at_display":"2025-03-19"},{"id":"1261","ticket_type":1,"contract_id":3822,"amount":"2500","collected_date":"2025-03-18 17:05:11","created_at":"2025-03-18 17:05:11","created_by":1013,"description":null,"project":{"id":3793,"key":3793,"name":"\u9632\u706b\u5899\u6545\u969c\u5904\u7f6e\u548c\u79df\u8d41-G-2025","budget":"2500","bargain_date":"2025-03-10","created_by":5300,"client_id":2736,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1},"client":{"id":2736,"key":2736,"name":"\u5317\u4eac\u4e2d\u6570\u521b\u65b0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u7f51\u6839\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8)"}},"created_at_display":"2025-03-18"}],"sumAmount":"30343966.91","pagenation":{"totalcount":253,"thispage":9,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"223.72.15.12","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:146.0) Gecko\/20100101 Firefox\/146.0"}', FALSE, '2025-12-23 10:21:40') RETURNING "id"

[+] Explain