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

Database Queries

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

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

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

[+] Explain
10:13:14.7488.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:13:14.7575.6 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:13:14.7634.9 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

[+] Explain
10:13:14.7691.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id" IN (4170, 4233, 4198, 4241, 4204, 4035, 4213, 4026, 4200, 4199, 4193, 4192, 4197, 3740, 4147, 4091, 4055, 4130, 4191)

[+] Explain
10:13:14.7710.6 msSELECTSELECT "id", "id" AS "key", "project_title" AS "name", "budget", "bargain_date", "created_by", "client_id" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (4008, 3888, 3751, 4033, 3939, 3945, 3841, 3999, 3964, 4010, 4003, 4012, 4000, 4006, 4011, 3973, 3755, 3906, 3971)

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

[+] Explain
10:13:14.7732.6 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (304, 1301, 189, 3328, 20, 12, 42, 3309, 24, 2553, 3370, 3378, 3343)

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

[+] Explain
10:13:14.7831.2 msUPDATEUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=52, "last_visit_at"='now()' WHERE "id"=59629

[+] Explain
10:13:14.7852.0 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":"1","status":"collected","web_access_token":"yb8YvQDqCxvGUQWSJnYL2S9XtkD7pVRr"}', '{"code":2000,"result":{"list":[{"id":"12085","ticket_type":1,"contract_id":4170,"amount":"80","collected_date":"2025-11-20 14:50:03","created_at":"2025-11-20 14:50:03","created_by":5064,"description":null,"project":{"id":3971,"key":3971,"name":"\u65b0\u8d2d\u5149\u8f6c\u7535\u6a21\u5757","budget":"1080","bargain_date":"2025-09-18","created_by":5295,"client_id":304,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1},"client":{"id":304,"key":304,"name":"\u5317\u4eac\u5317\u65b9\u534e\u521b\u771f\u7a7a\u6280\u672f\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-11-20"},{"id":"12084","ticket_type":1,"contract_id":4233,"amount":"2000","collected_date":"2025-11-13 15:59:38","created_at":"2025-11-13 15:59:38","created_by":1013,"description":null,"project":{"id":4033,"key":4033,"name":"\u6280\u672f\u670d\u52a1-\u4ea4\u6362\u673a\u5b9e\u65bd","budget":"2000","bargain_date":"2025-11-04","created_by":5295,"client_id":1301,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1},"client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)"}},"created_at_display":"2025-11-13"},{"id":"12083","ticket_type":1,"contract_id":4198,"amount":"13708.8","collected_date":"2025-11-13 15:59:16","created_at":"2025-11-13 15:59:16","created_by":1013,"description":null,"project":{"id":4003,"key":4003,"name":"\u65b0\u8d2d\u63a5\u5165\u4ea4\u6362\u673a","budget":"19584","bargain_date":"2025-10-17","created_by":5295,"client_id":1301,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1},"client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)"}},"created_at_display":"2025-11-13"},{"id":"12082","ticket_type":1,"contract_id":4241,"amount":"24000","collected_date":"2025-11-13 15:56:35","created_at":"2025-11-13 15:56:35","created_by":1013,"description":null,"project":{"id":4008,"key":4008,"name":"\u6df1\u4fe1\u670dEDR\u7eed\u4fdd","budget":"24000","bargain_date":"2025-11-11","created_by":1004,"client_id":3309,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1},"client":{"id":3309,"key":3309,"name":"\u4e2d\u90fd\uff08\u682a\u6d32\uff09\u7269\u6d41\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-11-13"},{"id":"12081","ticket_type":1,"contract_id":4204,"amount":"76000","collected_date":"2025-11-10 14:11:47","created_at":"2025-11-10 14:11:47","created_by":1013,"description":null,"project":{"id":4010,"key":4010,"name":"\u534e\u4e3a\u6cf0\u5c71\u670d\u52a1\u5668\u65b0\u8d2d-2025","budget":"76000","bargain_date":"2025-10-28","created_by":5300,"client_id":24,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1},"client":{"id":24,"key":24,"name":"\u4e2d\u822a\u946b\u6e2f\u62c5\u4fdd\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-11-10"},{"id":"12080","ticket_type":1,"contract_id":4035,"amount":"73200","collected_date":"2025-11-10 14:09:29","created_at":"2025-11-10 14:09:29","created_by":1013,"description":null,"project":{"id":3841,"key":3841,"name":"2025PA\u9632\u706b\u5899\u66ff\u6362","budget":"183000","bargain_date":"2025-07-12","created_by":1004,"client_id":3343,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1},"client":{"id":3343,"key":3343,"name":"\u5317\u4eac\u5317\u6c7d\u79d1\u6280\u670d\u52a1\u6709\u9650\u516c\u53f8(\u4e2d\u90fd\u4e09\u4ea7\uff09"}},"created_at_display":"2025-11-10"},{"id":"12078","ticket_type":1,"contract_id":4213,"amount":"36201","collected_date":"2025-11-06 10:58:28","created_at":"2025-11-06 10:58:28","created_by":1013,"description":null,"project":{"id":3964,"key":3964,"name":"2025\u5353\u8c6a\u65e5\u5ba1\u7eed\u4fdd","budget":"36201","bargain_date":"2025-10-28","created_by":5295,"client_id":189,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1},"client":{"id":189,"key":189,"name":"\u5317\u4eac\u4eac\u897f\u5b66\u6821"}},"created_at_display":"2025-11-06"},{"id":"12077","ticket_type":1,"contract_id":4026,"amount":"128800","collected_date":"2025-11-05 09:30:19","created_at":"2025-11-05 09:30:19","created_by":1013,"description":null,"project":{"id":3906,"key":3906,"name":"\u601d\u79d1N9K\u7eed\u4fdd\u9879\u76ee","budget":"184000","bargain_date":"2025-07-11","created_by":1004,"client_id":3378,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1},"client":{"id":3378,"key":3378,"name":"\u5317\u4eac\u4e16\u7eaa\u98de\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"}},"created_at_display":"2025-11-05"},{"id":"12074","ticket_type":1,"contract_id":4200,"amount":"511","collected_date":"2025-11-03 17:03:10","created_at":"2025-11-03 17:03:10","created_by":1013,"description":null,"project":{"id":4011,"key":4011,"name":"POTJ25102625\u56fa\u6001\u786c\u76d8-2025","budget":"511","bargain_date":"2025-10-20","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-11-03"},{"id":"12073","ticket_type":1,"contract_id":4199,"amount":"598","collected_date":"2025-11-03 17:02:34","created_at":"2025-11-03 17:02:34","created_by":1013,"description":null,"project":{"id":4012,"key":4012,"name":"POTJ25102971\u56fa\u6001\u786c\u76d8-2025","budget":"598","bargain_date":"2025-10-20","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-11-03"},{"id":"12072","ticket_type":1,"contract_id":4193,"amount":"590","collected_date":"2025-11-03 17:02:14","created_at":"2025-11-03 17:02:14","created_by":1013,"description":null,"project":{"id":3999,"key":3999,"name":"POTJ25102153-\u5185\u5b58\u6761-2025","budget":"590","bargain_date":"2025-10-14","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-11-03"},{"id":"12071","ticket_type":1,"contract_id":4192,"amount":"598","collected_date":"2025-11-03 17:01:41","created_at":"2025-11-03 17:01:41","created_by":1013,"description":null,"project":{"id":4000,"key":4000,"name":"POTJ25102154-\u56fa\u6001\u786c\u76d8-2025","budget":"598","bargain_date":"2025-10-14","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-11-03"},{"id":"12069","ticket_type":1,"contract_id":4197,"amount":"3500","collected_date":"2025-10-30 16:38:17","created_at":"2025-10-30 16:38:17","created_by":1013,"description":null,"project":{"id":4006,"key":4006,"name":"\u62d3\u5b9e\u6280\u672f\u670d\u52a1","budget":"3500","bargain_date":"2025-10-17","created_by":5295,"client_id":42,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1},"client":{"id":42,"key":42,"name":"\u5317\u4eac\u4e50\u5065\u4e1c\u5916\u95e8\u8bca\u90e8\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-10-30"},{"id":"12068","ticket_type":1,"contract_id":3740,"amount":"537370","collected_date":"2025-10-29 17:59:57","created_at":"2025-10-29 17:59:57","created_by":1013,"description":null,"project":{"id":3755,"key":3755,"name":"\u9f50\u6cbb\u5821\u5792\u673a\u65b0\u8d2d-K-224","budget":"537370","bargain_date":"2024-12-31","created_by":5300,"client_id":3328,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1},"client":{"id":3328,"key":3328,"name":"\u8fc7\u5355-\u795e\u5dde\u6570\u7801\u7cfb\u7edf\u96c6\u6210\u670d\u52a1\u6709\u9650\u516c\u53f8\u4e0a\u6d77\u5206\u516c\u53f8-\u5317\u4eac\u5954\u9a70"}},"created_at_display":"2025-10-29"},{"id":"12064","ticket_type":1,"contract_id":4147,"amount":"7743","collected_date":"2025-10-27 17:18:54","created_at":"2025-10-27 17:18:54","created_by":1013,"description":null,"project":{"id":3888,"key":3888,"name":"\u8054\u60f3\u670d\u52a1\u5668\u65b0\u8d2d-K-2025","budget":"215700","bargain_date":"2025-08-27","created_by":5300,"client_id":3370,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1},"client":{"id":3370,"key":3370,"name":"\u77e5\u884c\u89c2\u590d\uff08\u6210\u90fd\uff09\u6587\u5316\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-10-27"},{"id":"12063","ticket_type":1,"contract_id":4091,"amount":"422844","collected_date":"2025-10-27 14:46:21","created_at":"2025-10-27 14:46:21","created_by":1013,"description":null,"project":{"id":3939,"key":3939,"name":"\u65b0\u8d2d\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406","budget":"422844","bargain_date":"2025-08-14","created_by":5295,"client_id":304,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1},"client":{"id":304,"key":304,"name":"\u5317\u4eac\u5317\u65b9\u534e\u521b\u771f\u7a7a\u6280\u672f\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-10-27"},{"id":"12062","ticket_type":1,"contract_id":4055,"amount":"858740.72","collected_date":"2025-10-24 11:44:02","created_at":"2025-10-24 11:44:02","created_by":1013,"description":null,"project":{"id":3751,"key":3751,"name":"10\u53f0 PA445 \u8bbe\u5907\u91c7\u8d2d\u9879\u76ee\uff08\u6c99\u7279\u9879\u76ee\uff09","budget":"885300","bargain_date":"2025-07-21","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-10-24"},{"id":"12059","ticket_type":1,"contract_id":4198,"amount":"5875.2","collected_date":"2025-10-23 16:58:25","created_at":"2025-10-23 16:58:25","created_by":1013,"description":null,"project":{"id":4003,"key":4003,"name":"\u65b0\u8d2d\u63a5\u5165\u4ea4\u6362\u673a","budget":"19584","bargain_date":"2025-10-17","created_by":5295,"client_id":1301,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1},"client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)"}},"created_at_display":"2025-10-23"},{"id":"12058","ticket_type":1,"contract_id":4130,"amount":"69850.2","collected_date":"2025-10-23 16:55:35","created_at":"2025-10-23 16:55:35","created_by":1013,"description":null,"project":{"id":3945,"key":3945,"name":"\u65b0\u8d2d\u5b89\u5168\u8bbe\u5907","budget":"99786","bargain_date":"2025-08-26","created_by":5295,"client_id":1301,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1},"client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)"}},"created_at_display":"2025-10-23"},{"id":"12057","ticket_type":1,"contract_id":4191,"amount":"208000","collected_date":"2025-10-22 17:43:20","created_at":"2025-10-22 17:43:20","created_by":1013,"description":"","project":{"id":3973,"key":3973,"name":"2025\u5e74-2026\u5e74\u5b89\u5168\u7eed\u4fdd","budget":"208000","bargain_date":"2025-10-10","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-10-22"}],"sumAmount":"30343966.91","pagenation":{"totalcount":253,"thispage":1,"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:13:14') RETURNING "id"

[+] Explain