ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c3d9fe80611: POST https://beta.jinchangxiao.com/vue/erp-dashboard/list-log at 2025-09-12 04:29:50 pm by 114.246.237.213

Database Queries

总计14条数据
TimeDurationTypeQuery
  
16:29:50.5292.2 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
16:29:50.5321.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
16:29:50.5361.6 msSELECTSELECT COUNT(*) FROM (SELECT r.* FROM "a57be577deb434"."tbl_erp_ticket_change_logs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_ticket_change_log_handlers" "rvr" ON rvr.erp_ticket_change_log_id = r.id GROUP BY "r"."id" ORDER BY r.created_at DESC) "c"

[+] Explain
16:29:50.5371.4 msSELECTSELECT r.* FROM "a57be577deb434"."tbl_erp_ticket_change_logs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_ticket_change_log_handlers" "rvr" ON rvr.erp_ticket_change_log_id = r.id GROUP BY "r"."id" ORDER BY r.created_at DESC LIMIT 20

[+] Explain
16:29:50.5390.3 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1000, 5087, 5064, 5446)

[+] Explain
16:29:50.5400.7 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5446, 5087, 5064, 1000))

[+] Explain
16:29:50.5400.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 8, 1, 10)

[+] Explain
16:29:50.5410.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (431, 90, 511)

[+] Explain
16:29:50.5410.5 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3281, 1661, 2125, 2128, 3369, 2747, 2166)

[+] Explain
16:29:50.5420.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_ticket_change_log_handlers" WHERE "erp_ticket_change_log_id" IN (488, 487, 486, 485, 484, 483, 481, 482, 480, 479, 478, 477, 476, 475, 474, 473, 472, 471, 469, 468)

[+] Explain
16:29:50.5430.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5446, 5300, 5449, 5087, 1000, 1001, 1011)

[+] Explain
16:29:50.5446.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=20000) AND ("visit_date"='2025-09-12')

[+] Explain
16:29:50.5500.9 msUPDATEUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=260, "last_visit_at"='now()' WHERE "id"=56537

[+] Explain
16:29:50.5521.6 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-dashboard/list-log', '{"ErpTicketChangeLogSearch":{"created_at_period":"","status":"","created_by":""},"page":"1","web_access_token":"S7OJrULURAq348jTGnVvRiAMpe10N7Zn"}', '{"code":2000,"result":{"list":[{"id":488,"serial_no":"ZSD-20250912-00002","ticket_type":20011,"wrote_date":"2025-09-12","status":2,"supplier_id":"","client_id":3281,"abstract":"","description":"","verify_at":"2025-09-12 15:58:12","created_by":1001,"created_at":"2025-09-12 15:58:12","updated_at":"2025-09-12 15:58:12","contact_id":"","user_id":"","amount":"0","object_id":15,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{"id":3281,"key":3281,"name":"\u5bd2\u5e8f\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\uff08EDA\uff09"},"user":{},"contact":{},"handlers":[{"id":472,"erp_ticket_change_log_id":488,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}}],"ticket_type_display":"\u8d60\u9001\u5355","unit":{"id":3281,"key":3281,"name":"\u5bd2\u5e8f\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\uff08EDA\uff09"}},{"id":487,"serial_no":"CGDD-20250912-00001","ticket_type":20001,"wrote_date":"","status":2,"supplier_id":431,"client_id":"","abstract":"","description":"","verify_at":"2025-09-12 15:57:23","created_by":1001,"created_at":"2025-09-12 15:57:23","updated_at":"2025-09-12 15:57:23","contact_id":"","user_id":"","amount":"0","object_id":2044,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"client":{},"user":{},"contact":{},"handlers":[{"id":471,"erp_ticket_change_log_id":487,"user_id":1011,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3"}}],"ticket_type_display":"\u91c7\u8d2d\u8ba2\u5355","unit":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"}},{"id":486,"serial_no":"FKD-20250912-00001","ticket_type":20012,"wrote_date":"2025-09-12","status":2,"supplier_id":90,"client_id":"","abstract":"","description":"","verify_at":"2025-09-12 15:48:10","created_by":1001,"created_at":"2025-09-12 15:45:16","updated_at":"2025-09-12 15:48:10","contact_id":"","user_id":"","amount":"1","object_id":2128,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"client":{},"user":{},"contact":{},"handlers":[{"id":470,"erp_ticket_change_log_id":486,"user_id":1011,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3"}}],"ticket_type_display":"\u4ed8\u6b3e\u5355","unit":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"}},{"id":485,"serial_no":"XSCKD-20250912-00001","ticket_type":20008,"wrote_date":"2025-09-12","status":2,"supplier_id":"","client_id":1661,"abstract":"","description":"","verify_at":"2025-09-12 09:39:19","created_by":1001,"created_at":"2025-09-12 09:39:19","updated_at":"2025-09-12 09:39:19","contact_id":"","user_id":"","amount":"788888","object_id":22,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"handlers":[{"id":469,"erp_ticket_change_log_id":485,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}}],"ticket_type_display":"\u9500\u552e\u51fa\u5e93\u5355","unit":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8"}},{"id":484,"serial_no":"QTYSD-20250912-00003","ticket_type":20021,"wrote_date":"2025-09-12","status":2,"supplier_id":511,"client_id":"","abstract":"\u6d4b\u8bd5","description":"","verify_at":"2025-09-12 09:27:07","created_by":1001,"created_at":"2025-09-12 09:26:27","updated_at":"2025-09-12 09:27:07","contact_id":"","user_id":"","amount":"24000","object_id":29,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{"id":511,"key":511,"name":"\u5317\u4eac\u610f\u7545\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"client":{},"user":{},"contact":{},"handlers":[{"id":468,"erp_ticket_change_log_id":484,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}}],"ticket_type_display":"\u5176\u4ed6\u5e94\u6536\u5355","unit":{"id":511,"key":511,"name":"\u5317\u4eac\u610f\u7545\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"}},{"id":483,"serial_no":"FKD-20250911-00001","ticket_type":20012,"wrote_date":"2025-09-11","status":2,"supplier_id":90,"client_id":"","abstract":"\u5b98\u65b9","description":"","verify_at":"2025-09-11 15:51:47","created_by":1001,"created_at":"2025-09-11 15:50:59","updated_at":"2025-09-11 15:51:47","contact_id":"","user_id":"","amount":"44","object_id":2127,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"client":{},"user":{},"contact":{},"handlers":[{"id":467,"erp_ticket_change_log_id":483,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}}],"ticket_type_display":"\u4ed8\u6b3e\u5355","unit":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"}},{"id":481,"serial_no":"XJFYD-20250911-00004","ticket_type":20018,"wrote_date":"","status":2,"supplier_id":"","client_id":1661,"abstract":"","description":"","verify_at":"2025-09-11 11:33:36","created_by":1000,"created_at":"2025-09-11 11:33:36","updated_at":"2025-09-11 11:33:36","contact_id":"","user_id":"","amount":"221","object_id":7503,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"supplier":{},"client":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"handlers":[{"id":465,"erp_ticket_change_log_id":481,"user_id":1000,"user":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f"}}],"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","unit":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8"}},{"id":482,"serial_no":"XSDD-20250911-00001","ticket_type":20007,"wrote_date":"2025-09-11","status":2,"supplier_id":"","client_id":1661,"abstract":"","description":"","verify_at":"2025-09-11 15:03:36","created_by":1001,"created_at":"2025-09-11 10:49:29","updated_at":"2025-09-11 15:03:36","contact_id":"","user_id":"","amount":"12230","object_id":1586,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"handlers":[{"id":466,"erp_ticket_change_log_id":482,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}}],"ticket_type_display":"\u9500\u552e\u8ba2\u5355","unit":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8"}},{"id":480,"serial_no":"XJFYD-20250911-00003","ticket_type":20018,"wrote_date":"","status":2,"supplier_id":"","client_id":"","abstract":"","description":"","verify_at":"2025-09-11 09:37:53","created_by":1000,"created_at":"2025-09-11 09:37:53","updated_at":"2025-09-11 09:37:53","contact_id":"","user_id":"","amount":"111","object_id":7502,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"supplier":{},"client":{},"user":{},"contact":{},"handlers":[{"id":464,"erp_ticket_change_log_id":480,"user_id":1000,"user":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f"}}],"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","unit":{}},{"id":479,"serial_no":"XJFYD-20250911-00002","ticket_type":20018,"wrote_date":"","status":2,"supplier_id":"","client_id":1661,"abstract":"","description":"","verify_at":"2025-09-11 09:37:53","created_by":1000,"created_at":"2025-09-11 09:37:53","updated_at":"2025-09-11 09:37:53","contact_id":"","user_id":"","amount":"289.76","object_id":7501,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"supplier":{},"client":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"handlers":[{"id":463,"erp_ticket_change_log_id":479,"user_id":1000,"user":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f"}}],"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","unit":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8"}},{"id":478,"serial_no":"XJFYD-20250911-00001","ticket_type":20018,"wrote_date":"","status":2,"supplier_id":"","client_id":1661,"abstract":"","description":"","verify_at":"2025-09-11 09:37:47","created_by":1000,"created_at":"2025-09-11 09:37:47","updated_at":"2025-09-11 09:37:47","contact_id":"","user_id":"","amount":"123","object_id":7500,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"supplier":{},"client":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"handlers":[{"id":462,"erp_ticket_change_log_id":478,"user_id":1000,"user":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f"}}],"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","unit":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8"}},{"id":477,"serial_no":"XSDD-20250910-00008","ticket_type":20007,"wrote_date":"2025-09-10","status":2,"supplier_id":"","client_id":2125,"abstract":"","description":"","verify_at":"2025-09-10 17:48:45","created_by":5087,"created_at":"2025-09-10 17:48:33","updated_at":"2025-09-10 17:48:45","contact_id":"","user_id":"","amount":"790000","object_id":1585,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"supplier":{},"client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u822a\u661f\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8239\u5382"},"user":{},"contact":{},"handlers":[{"id":461,"erp_ticket_change_log_id":477,"user_id":5087,"user":{"id":5087,"key":5087,"name":"\u5218\u5fae"}}],"ticket_type_display":"\u9500\u552e\u8ba2\u5355","unit":{"id":2125,"key":2125,"name":"\u5317\u4eac\u822a\u661f\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8239\u5382"}},{"id":476,"serial_no":"XSDD-20250910-00006","ticket_type":20007,"wrote_date":"2025-09-10","status":2,"supplier_id":"","client_id":2128,"abstract":"","description":"","verify_at":"2025-09-10 17:41:10","created_by":5087,"created_at":"2025-09-10 17:41:02","updated_at":"2025-09-10 17:41:10","contact_id":"","user_id":"","amount":"1150000","object_id":1583,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"supplier":{},"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u81ea\u52a8\u5316\u63a7\u5236\u8bbe\u5907\u7814\u7a76\u624033\u6240"},"user":{},"contact":{},"handlers":[{"id":460,"erp_ticket_change_log_id":476,"user_id":5087,"user":{"id":5087,"key":5087,"name":"\u5218\u5fae"}}],"ticket_type_display":"\u9500\u552e\u8ba2\u5355","unit":{"id":2128,"key":2128,"name":"\u5317\u4eac\u81ea\u52a8\u5316\u63a7\u5236\u8bbe\u5907\u7814\u7a76\u624033\u6240"}},{"id":475,"serial_no":"XSDD-20250910-00005","ticket_type":20007,"wrote_date":"2025-09-10","status":2,"supplier_id":"","client_id":3369,"abstract":"","description":"","verify_at":"2025-09-10 17:24:13","created_by":5064,"created_at":"2025-09-10 17:23:46","updated_at":"2025-09-10 17:24:13","contact_id":"","user_id":"","amount":"444","object_id":1582,"createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"supplier":{},"client":{"id":3369,"key":3369,"name":"\u4e2d\u56fd\u4e2d\u7164\u80fd\u6e90\u96c6\u56e2\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"handlers":[{"id":459,"erp_ticket_change_log_id":475,"user_id":5449,"user":{"id":5449,"key":5449,"name":"\u5468\u4e3d\u98de"}}],"ticket_type_display":"\u9500\u552e\u8ba2\u5355","unit":{"id":3369,"key":3369,"name":"\u4e2d\u56fd\u4e2d\u7164\u80fd\u6e90\u96c6\u56e2\u6709\u9650\u516c\u53f8"}},{"id":474,"serial_no":"XSDD-20250910-00004","ticket_type":20007,"wrote_date":"2025-09-10","status":2,"supplier_id":"","client_id":2747,"abstract":"","description":"","verify_at":"2025-09-10 17:10:13","created_by":5064,"created_at":"2025-09-10 17:09:45","updated_at":"2025-09-10 17:10:13","contact_id":"","user_id":"","amount":"18855","object_id":1581,"createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"supplier":{},"client":{"id":2747,"key":2747,"name":"\u4e2d\u56fd\u5316\u5b66\u5de5\u7a0b\u96c6\u56e2"},"user":{},"contact":{},"handlers":[{"id":458,"erp_ticket_change_log_id":474,"user_id":5449,"user":{"id":5449,"key":5449,"name":"\u5468\u4e3d\u98de"}}],"ticket_type_display":"\u9500\u552e\u8ba2\u5355","unit":{"id":2747,"key":2747,"name":"\u4e2d\u56fd\u5316\u5b66\u5de5\u7a0b\u96c6\u56e2"}},{"id":473,"serial_no":"XSDD-20250910-00003","ticket_type":20007,"wrote_date":"2025-09-10","status":2,"supplier_id":"","client_id":2166,"abstract":"","description":"","verify_at":"2025-09-10 16:53:38","created_by":1001,"created_at":"2025-09-10 16:53:26","updated_at":"2025-09-10 16:53:38","contact_id":"","user_id":"","amount":"129992","object_id":1580,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{"id":2166,"key":2166,"name":"\u6c5f\u539f\u521b\u82af\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"handlers":[{"id":457,"erp_ticket_change_log_id":473,"user_id":5300,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}}],"ticket_type_display":"\u9500\u552e\u8ba2\u5355","unit":{"id":2166,"key":2166,"name":"\u6c5f\u539f\u521b\u82af\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8"}},{"id":472,"serial_no":"XSDD-20250910-00001","ticket_type":20007,"wrote_date":"2025-09-10","status":8,"supplier_id":"","client_id":2166,"abstract":"","description":"","verify_at":"2025-09-10 16:41:46","created_by":1001,"created_at":"2025-09-10 16:37:43","updated_at":"2025-09-10 16:47:10","contact_id":"","user_id":"","amount":"129992","object_id":1578,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{"id":2166,"key":2166,"name":"\u6c5f\u539f\u521b\u82af\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"handlers":[{"id":456,"erp_ticket_change_log_id":472,"user_id":5300,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}}],"ticket_type_display":"\u9500\u552e\u8ba2\u5355-\u7ea2\u5b57\u53cd\u51b2","unit":{"id":2166,"key":2166,"name":"\u6c5f\u539f\u521b\u82af\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8"}},{"id":471,"serial_no":"XSDD-20250910-00001","ticket_type":20007,"wrote_date":"2025-09-10","status":2,"supplier_id":"","client_id":2166,"abstract":"","description":"","verify_at":"2025-09-10 16:41:46","created_by":1001,"created_at":"2025-09-10 16:37:43","updated_at":"2025-09-10 16:41:46","contact_id":"","user_id":"","amount":"129992","object_id":1578,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{"id":2166,"key":2166,"name":"\u6c5f\u539f\u521b\u82af\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"handlers":[{"id":455,"erp_ticket_change_log_id":471,"user_id":5300,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}}],"ticket_type_display":"\u9500\u552e\u8ba2\u5355","unit":{"id":2166,"key":2166,"name":"\u6c5f\u539f\u521b\u82af\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8"}},{"id":469,"serial_no":"GZD-20250910-00001","ticket_type":20023,"wrote_date":"2025-09-10","status":2,"supplier_id":"","client_id":"","abstract":"\u6d4b\u8bd5","description":"","verify_at":"2025-09-10 15:53:51","created_by":1001,"created_at":"2025-09-10 15:50:46","updated_at":"2025-09-10 15:53:51","contact_id":"","user_id":"","amount":"66","object_id":3,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{},"user":{},"contact":{},"handlers":[],"ticket_type_display":"\u5de5\u8d44\u5355","unit":{}},{"id":468,"serial_no":"XJFYD-20250908-00002","ticket_type":20018,"wrote_date":"","status":2,"supplier_id":"","client_id":"","abstract":"","description":"","verify_at":"2025-09-08 21:53:23","created_by":5446,"created_at":"2025-09-08 21:53:23","updated_at":"2025-09-08 21:53:23","contact_id":"","user_id":"","amount":"306.48","object_id":7499,"createdBy":{"id":5446,"key":5446,"name":"\u5218\u5a1f","sex":"F","department_id":8,"avatar":{"id":164,"user_id":5446,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5631bbfb-fa6e-308e-b87c-b159e8042209.jpg"},"department":{"id":8,"key":8,"name":"\u4eba\u529b\u8d44\u6e90"}},"supplier":{},"client":{},"user":{},"contact":{},"handlers":[{"id":454,"erp_ticket_change_log_id":468,"user_id":5446,"user":{"id":5446,"key":5446,"name":"\u5218\u5a1f"}}],"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","unit":{}}],"pagenation":{"totalcount":488,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-12 16:29:50') RETURNING "id"

[+] Explain