ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6948ade8d0629: POST https://beta.jinchangxiao.com/vue/analysis/pre-sales-ticket-list at 2025-12-22 10:33:12 am by 223.72.15.105

Database Queries

总计10条数据
TimeDurationTypeQuery
  
10:33:13.0853.2 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1000

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

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

[+] Explain
10:33:13.0994.0 msSELECTSELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" "urcl" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON urcl.user_id = u.id WHERE ("role_name"='Engineer') AND (((start_from < end_at) or end_at is null)) AND (tsrange(start_from::TIMESTAMP, end_at::TIMESTAMP, '[)') && '[2025-01-01 00:00:00, 2025-12-31 23:59:59]'::tsrange) GROUP BY "user_id", "pinyin1", "namecut1", "pinyin2", "namecut2", "pinyin3", "namecut3", "pinyin4", "namecut4" ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first

[+] Explain
10:33:13.1040.5 msSELECTSELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1017, 5085, 1001, 5248, 1015, 1022, 5296, 1023) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first

[+] Explain
10:33:13.1065.8 msSELECTSELECT COUNT(*) FROM (SELECT ps.id, ticket_no, ps.client_id, client.name, c.project_id, p.project_title, ps.end_at, ps.start_at, ps.end_at - ps.start_at as spent, u.name as engineer_name, ps.service_id, s.title as service_name, ps.case_id, c.case_no, c.case_type, c.deduct_points_from as sales_rep, sales.name as sales_rep_name, ps.updated_at FROM "a57be577deb434"."tbl_pre_sales" "ps" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ps.case_id = c.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON c.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_users" "u" ON ps.created_by = u.id LEFT JOIN "a57be577deb434"."tbl_users" "sales" ON c.deduct_points_from = sales.id LEFT JOIN "a57be577deb434"."tbl_services" "s" ON ps.service_id = s.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON ps.client_id = client.id WHERE ("ps"."created_by" IN (1017, 5085, 1001, 5248, 1015, 1022, 5296, 1023)) AND ("ps"."start_at" >= '2025-01-01 00:00:00') AND ("ps"."start_at" <= '2025-12-31 23:59:59') AND (("c"."deduct_points_from" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("c"."deduct_points_from" IS NULL)) AND ("ps"."is_draft"=FALSE) ORDER BY "end_at" DESC, "updated_at" DESC) "c"

[+] Explain
10:33:13.1139.0 msSELECTSELECT ps.id, ticket_no, ps.client_id, client.name, c.project_id, p.project_title, ps.end_at, ps.start_at, ps.end_at - ps.start_at as spent, u.name as engineer_name, ps.service_id, s.title as service_name, ps.case_id, c.case_no, c.case_type, c.deduct_points_from as sales_rep, sales.name as sales_rep_name, ps.updated_at FROM "a57be577deb434"."tbl_pre_sales" "ps" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ps.case_id = c.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON c.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_users" "u" ON ps.created_by = u.id LEFT JOIN "a57be577deb434"."tbl_users" "sales" ON c.deduct_points_from = sales.id LEFT JOIN "a57be577deb434"."tbl_services" "s" ON ps.service_id = s.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON ps.client_id = client.id WHERE ("ps"."created_by" IN (1017, 5085, 1001, 5248, 1015, 1022, 5296, 1023)) AND ("ps"."start_at" >= '2025-01-01 00:00:00') AND ("ps"."start_at" <= '2025-12-31 23:59:59') AND (("c"."deduct_points_from" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("c"."deduct_points_from" IS NULL)) AND ("ps"."is_draft"=FALSE) ORDER BY "end_at" DESC, "updated_at" DESC LIMIT 20

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

[+] Explain
10:33:13.1343.4 msUPDATEUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=12, "last_visit_at"='now()' WHERE "id"=59614

[+] Explain
10:33:13.1383.4 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/pre-sales-ticket-list', '{"period":"currentfascalyear","alert":"false","page":"1","web_access_token":"lJec5OoLODuCvm6gBWbjtNJVDT-F6hci"}', '{"code":2000,"result":{"list":[{"id":1908,"ticket_no":"PS251106003001","client_id":2128,"name":"\u5317\u4eac\u81ea\u52a8\u5316\u63a7\u5236\u8bbe\u5907\u7814\u7a76\u624033\u6240","project_id":3977,"project_title":"\u5907\u4efd\u7cfb\u7edf\u56fd\u4ea7\u5316\u66ff\u4ee3\u9879\u76ee","end_at":"2025-11-06 16:02:00","start_at":"2025-11-06 15:47:00","spent":"00:15:00","engineer_name":"\u5434\u660a","service_id":230,"service_name":"\u54a8\u8be2\u670d\u52a1","case_id":8941,"case_no":"PS251106003","case_type":1,"sales_rep":5087,"sales_rep_name":"\u5218\u5fae","updated_at":"2025-11-06 20:17:25","start_at_display":"2025-11-06 15:47","end_at_display":"2025-11-06 16:02","hours_spent_display":"15\u5206\u949f","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1907,"ticket_no":"PS251103001001","client_id":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","project_id":4007,"project_title":"\u6df1\u4fe1\u670d\u865a\u62df\u5316-2025","end_at":"2025-11-05 16:58:00","start_at":"2025-11-05 14:50:00","spent":"02:08:00","engineer_name":"\u5434\u660a","service_id":230,"service_name":"\u54a8\u8be2\u670d\u52a1","case_id":8931,"case_no":"PS251103001","case_type":1,"sales_rep":5300,"sales_rep_name":"\u82cf\u6e05\u4e91","updated_at":"2025-11-06 20:15:48","start_at_display":"2025-11-05 14:50","end_at_display":"2025-11-05 16:58","hours_spent_display":"2\u5c0f\u65f68\u5206\u949f","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1906,"ticket_no":"PS251103002001","client_id":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","project_id":4007,"project_title":"\u6df1\u4fe1\u670d\u865a\u62df\u5316-2025","end_at":"2025-11-03 10:45:00","start_at":"2025-11-03 10:00:00","spent":"00:45:00","engineer_name":"\u5434\u660a","service_id":273,"service_name":"\u6280\u672f\u65b9\u6848-\u4e00\u7ea7\u6587\u6863","case_id":8932,"case_no":"PS251103002","case_type":1,"sales_rep":5300,"sales_rep_name":"\u82cf\u6e05\u4e91","updated_at":"2025-11-04 09:51:56","start_at_display":"2025-11-03 10:00","end_at_display":"2025-11-03 10:45","hours_spent_display":"45\u5206\u949f","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1904,"ticket_no":"PS251030004001","client_id":85,"name":"\u5317\u4eac\u52a8\u529b\u673a\u68b0\u7814\u7a76\u6240 31\u6240","project_id":3981,"project_title":"\u58f9\u8fdb\u5236\u5907\u4efd\u7cfb\u7edf\u8fd0\u7ef4","end_at":"2025-10-30 14:00:00","start_at":"2025-10-30 09:00:00","spent":"05:00:00","engineer_name":"\u5468\u5b50\u5065","service_id":273,"service_name":"\u6280\u672f\u65b9\u6848-\u4e00\u7ea7\u6587\u6863","case_id":8926,"case_no":"PS251030004","case_type":1,"sales_rep":5087,"sales_rep_name":"\u5218\u5fae","updated_at":"2025-10-30 17:43:26","start_at_display":"2025-10-30 09:00","end_at_display":"2025-10-30 14:00","hours_spent_display":"5\u5c0f\u65f6","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1905,"ticket_no":"PS251030003001","client_id":85,"name":"\u5317\u4eac\u52a8\u529b\u673a\u68b0\u7814\u7a76\u6240 31\u6240","project_id":3981,"project_title":"\u58f9\u8fdb\u5236\u5907\u4efd\u7cfb\u7edf\u8fd0\u7ef4","end_at":"2025-10-30 11:45:00","start_at":"2025-10-30 11:00:00","spent":"00:45:00","engineer_name":"\u5434\u660a","service_id":273,"service_name":"\u6280\u672f\u65b9\u6848-\u4e00\u7ea7\u6587\u6863","case_id":8925,"case_no":"PS251030003","case_type":1,"sales_rep":5087,"sales_rep_name":"\u5218\u5fae","updated_at":"2025-10-30 18:04:36","start_at_display":"2025-10-30 11:00","end_at_display":"2025-10-30 11:45","hours_spent_display":"45\u5206\u949f","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1903,"ticket_no":"PS251028006001","client_id":85,"name":"\u5317\u4eac\u52a8\u529b\u673a\u68b0\u7814\u7a76\u6240 31\u6240","project_id":4029,"project_title":"\u667a\u80fd\u529e\u516c\u73af\u5883\u5efa\u8bbe-WPS+AI","end_at":"2025-10-29 18:35:00","start_at":"2025-10-29 16:00:00","spent":"02:35:00","engineer_name":"\u5434\u660a","service_id":230,"service_name":"\u54a8\u8be2\u670d\u52a1","case_id":8915,"case_no":"PS251028006","case_type":1,"sales_rep":5087,"sales_rep_name":"\u5218\u5fae","updated_at":"2025-10-30 11:11:09","start_at_display":"2025-10-29 16:00","end_at_display":"2025-10-29 18:35","hours_spent_display":"2\u5c0f\u65f635\u5206\u949f","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1902,"ticket_no":"PS251028004001","client_id":2128,"name":"\u5317\u4eac\u81ea\u52a8\u5316\u63a7\u5236\u8bbe\u5907\u7814\u7a76\u624033\u6240","project_id":3977,"project_title":"\u5907\u4efd\u7cfb\u7edf\u56fd\u4ea7\u5316\u66ff\u4ee3\u9879\u76ee","end_at":"2025-10-27 11:00:00","start_at":"2025-10-27 10:00:00","spent":"01:00:00","engineer_name":"\u5434\u660a","service_id":273,"service_name":"\u6280\u672f\u65b9\u6848-\u4e00\u7ea7\u6587\u6863","case_id":8912,"case_no":"PS251028004","case_type":1,"sales_rep":5087,"sales_rep_name":"\u5218\u5fae","updated_at":"2025-10-28 14:27:30","start_at_display":"2025-10-27 10:00","end_at_display":"2025-10-27 11:00","hours_spent_display":"1\u5c0f\u65f6","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1901,"ticket_no":"PS251028005001","client_id":2128,"name":"\u5317\u4eac\u81ea\u52a8\u5316\u63a7\u5236\u8bbe\u5907\u7814\u7a76\u624033\u6240","project_id":3977,"project_title":"\u5907\u4efd\u7cfb\u7edf\u56fd\u4ea7\u5316\u66ff\u4ee3\u9879\u76ee","end_at":"2025-10-27 10:00:00","start_at":"2025-10-27 09:00:00","spent":"01:00:00","engineer_name":"\u5434\u660a","service_id":273,"service_name":"\u6280\u672f\u65b9\u6848-\u4e00\u7ea7\u6587\u6863","case_id":8913,"case_no":"PS251028005","case_type":1,"sales_rep":5087,"sales_rep_name":"\u5218\u5fae","updated_at":"2025-10-28 14:26:29","start_at_display":"2025-10-27 09:00","end_at_display":"2025-10-27 10:00","hours_spent_display":"1\u5c0f\u65f6","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1900,"ticket_no":"PS251027002001","client_id":107,"name":"\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8","project_id":3837,"project_title":"\u65b0\u8d2d\u6df1\u4fe1\u670d\u8d85\u878d\u5408\u684c\u9762\u4e91","end_at":"2025-10-26 10:45:00","start_at":"2025-10-26 08:45:00","spent":"02:00:00","engineer_name":"\u5434\u660a","service_id":273,"service_name":"\u6280\u672f\u65b9\u6848-\u4e00\u7ea7\u6587\u6863","case_id":8905,"case_no":"PS251027002","case_type":1,"sales_rep":5295,"sales_rep_name":"\u9b4f\u6cfd\u6587","updated_at":"2025-10-27 13:06:31","start_at_display":"2025-10-26 08:45","end_at_display":"2025-10-26 10:45","hours_spent_display":"2\u5c0f\u65f6","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1899,"ticket_no":"PS251022002001","client_id":3330,"name":"\u94a2\u7814\u660a\u666e\u79d1\u6280\u6709\u9650\u516c\u53f8","project_id":4017,"project_title":"\u5907\u4efd\u8bbe\u5907\u65b0\u8d2d-2025","end_at":"2025-10-23 10:22:00","start_at":"2025-10-23 09:55:00","spent":"00:27:00","engineer_name":"\u5434\u660a","service_id":230,"service_name":"\u54a8\u8be2\u670d\u52a1","case_id":8895,"case_no":"PS251022002","case_type":1,"sales_rep":5300,"sales_rep_name":"\u82cf\u6e05\u4e91","updated_at":"2025-10-23 16:11:38","start_at_display":"2025-10-23 09:55","end_at_display":"2025-10-23 10:22","hours_spent_display":"27\u5206\u949f","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1897,"ticket_no":"PS251014001001","client_id":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)","project_id":4003,"project_title":"\u65b0\u8d2d\u63a5\u5165\u4ea4\u6362\u673a","end_at":"2025-10-14 16:48:00","start_at":"2025-10-14 09:47:00","spent":"07:01:00","engineer_name":"\u6587\u4f73\u9f99","service_id":230,"service_name":"\u54a8\u8be2\u670d\u52a1","case_id":8871,"case_no":"PS251014001","case_type":1,"sales_rep":5295,"sales_rep_name":"\u9b4f\u6cfd\u6587","updated_at":"2025-10-15 09:10:13","start_at_display":"2025-10-14 09:47","end_at_display":"2025-10-14 16:48","hours_spent_display":"7\u5c0f\u65f61\u5206\u949f","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1898,"ticket_no":"PS251014002001","client_id":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","project_id":4007,"project_title":"\u6df1\u4fe1\u670d\u865a\u62df\u5316-2025","end_at":"2025-10-14 11:00:00","start_at":"2025-10-14 09:00:00","spent":"02:00:00","engineer_name":"\u970d\u4e1c\u9633","service_id":230,"service_name":"\u54a8\u8be2\u670d\u52a1","case_id":8872,"case_no":"PS251014002","case_type":1,"sales_rep":5300,"sales_rep_name":"\u82cf\u6e05\u4e91","updated_at":"2025-10-14 23:42:22","start_at_display":"2025-10-14 09:00","end_at_display":"2025-10-14 11:00","hours_spent_display":"2\u5c0f\u65f6","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1895,"ticket_no":"PS251009004001","client_id":85,"name":"\u5317\u4eac\u52a8\u529b\u673a\u68b0\u7814\u7a76\u6240 31\u6240","project_id":3980,"project_title":"\u58f9\u8fdb\u5236\u5907\u4efd\u5347\u7ea7","end_at":"2025-10-10 16:01:00","start_at":"2025-10-10 14:20:00","spent":"01:41:00","engineer_name":"\u5434\u660a","service_id":230,"service_name":"\u54a8\u8be2\u670d\u52a1","case_id":8866,"case_no":"PS251009004","case_type":1,"sales_rep":5087,"sales_rep_name":"\u5218\u5fae","updated_at":"2025-10-13 08:02:02","start_at_display":"2025-10-10 14:20","end_at_display":"2025-10-10 16:01","hours_spent_display":"1\u5c0f\u65f641\u5206\u949f","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1896,"ticket_no":"PS251010002001","client_id":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","project_id":4007,"project_title":"\u6df1\u4fe1\u670d\u865a\u62df\u5316-2025","end_at":"2025-10-10 11:30:00","start_at":"2025-10-10 10:00:00","spent":"01:30:00","engineer_name":"\u970d\u4e1c\u9633","service_id":230,"service_name":"\u54a8\u8be2\u670d\u52a1","case_id":8868,"case_no":"PS251010002","case_type":1,"sales_rep":5300,"sales_rep_name":"\u82cf\u6e05\u4e91","updated_at":"2025-10-12 12:08:55","start_at_display":"2025-10-10 10:00","end_at_display":"2025-10-10 11:30","hours_spent_display":"1\u5c0f\u65f630\u5206\u949f","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1894,"ticket_no":"PS250929001001","client_id":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","project_id":4007,"project_title":"\u6df1\u4fe1\u670d\u865a\u62df\u5316-2025","end_at":"2025-09-29 17:50:00","start_at":"2025-09-29 13:30:00","spent":"04:20:00","engineer_name":"\u970d\u4e1c\u9633","service_id":230,"service_name":"\u54a8\u8be2\u670d\u52a1","case_id":8856,"case_no":"PS250929001","case_type":1,"sales_rep":5300,"sales_rep_name":"\u82cf\u6e05\u4e91","updated_at":"2025-09-30 08:12:05","start_at_display":"2025-09-29 13:30","end_at_display":"2025-09-29 17:50","hours_spent_display":"4\u5c0f\u65f620\u5206\u949f","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1893,"ticket_no":"PS250926002001","client_id":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","project_id":4007,"project_title":"\u6df1\u4fe1\u670d\u865a\u62df\u5316-2025","end_at":"2025-09-28 11:21:00","start_at":"2025-09-28 09:30:00","spent":"01:51:00","engineer_name":"\u5434\u660a","service_id":230,"service_name":"\u54a8\u8be2\u670d\u52a1","case_id":8853,"case_no":"PS250926002","case_type":1,"sales_rep":5300,"sales_rep_name":"\u82cf\u6e05\u4e91","updated_at":"2025-09-29 09:15:25","start_at_display":"2025-09-28 09:30","end_at_display":"2025-09-28 11:21","hours_spent_display":"1\u5c0f\u65f651\u5206\u949f","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1892,"ticket_no":"PS250915005001","client_id":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","project_id":4007,"project_title":"\u6df1\u4fe1\u670d\u865a\u62df\u5316-2025","end_at":"2025-09-16 14:31:00","start_at":"2025-09-16 13:42:00","spent":"00:49:00","engineer_name":"\u5434\u660a","service_id":230,"service_name":"\u54a8\u8be2\u670d\u52a1","case_id":8807,"case_no":"PS250915005","case_type":1,"sales_rep":5300,"sales_rep_name":"\u82cf\u6e05\u4e91","updated_at":"2025-09-17 15:55:39","start_at_display":"2025-09-16 13:42","end_at_display":"2025-09-16 14:31","hours_spent_display":"49\u5206\u949f","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1891,"ticket_no":"PS250902004001","client_id":2130,"name":"\u5317\u4eac\u4eac\u822a\u8ba1\u7b97\u901a\u8baf\u7814\u7a76\u6240304","project_id":"","project_title":"","end_at":"2025-09-05 17:06:00","start_at":"2025-09-05 14:05:00","spent":"03:01:00","engineer_name":"\u5434\u660a","service_id":230,"service_name":"\u54a8\u8be2\u670d\u52a1","case_id":8769,"case_no":"PS250902004","case_type":1,"sales_rep":5087,"sales_rep_name":"\u5218\u5fae","updated_at":"2025-09-06 17:49:11","start_at_display":"2025-09-05 14:05","end_at_display":"2025-09-05 17:06","hours_spent_display":"3\u5c0f\u65f61\u5206\u949f","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1890,"ticket_no":"PS250811006001","client_id":2821,"name":"\u56fd\u5bb6\u6797\u8349\u5c40\u6797\u8349\u8c03\u67e5\u89c4\u5212\u9662","project_id":"","project_title":"","end_at":"2025-08-13 16:27:00","start_at":"2025-08-13 15:56:00","spent":"00:31:00","engineer_name":"\u5434\u660a","service_id":230,"service_name":"\u54a8\u8be2\u670d\u52a1","case_id":8696,"case_no":"PS250811006","case_type":1,"sales_rep":5295,"sales_rep_name":"\u9b4f\u6cfd\u6587","updated_at":"2025-08-13 21:28:04","start_at_display":"2025-08-13 15:56","end_at_display":"2025-08-13 16:27","hours_spent_display":"31\u5206\u949f","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1889,"ticket_no":"PS250811003001","client_id":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)","project_id":3895,"project_title":"\u65b0\u5efa\u5bb9\u707e\u96c6\u7fa4","end_at":"2025-08-13 16:08:00","start_at":"2025-08-13 10:19:00","spent":"05:49:00","engineer_name":"\u6587\u4f73\u9f99","service_id":230,"service_name":"\u54a8\u8be2\u670d\u52a1","case_id":8693,"case_no":"PS250811003","case_type":1,"sales_rep":5295,"sales_rep_name":"\u9b4f\u6cfd\u6587","updated_at":"2025-08-14 09:08:15","start_at_display":"2025-08-13 10:19","end_at_display":"2025-08-13 16:08","hours_spent_display":"5\u5c0f\u65f649\u5206\u949f","case_type_display":"\u552e\u524d\u54a8\u8be2"}],"can_create":true,"pagenation":{"totalcount":103,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"223.72.15.105","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/143.0.0.0 Safari\/537.36"}', FALSE, '2025-12-22 10:33:13') RETURNING "id"

[+] Explain