ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a27d35142545: POST https://beta.jinchangxiao.com/vue/analysis/pre-sales-ticket-list at 2026-06-09 04:48:17 pm by 43.224.72.82

Performance Profiling

Total processing time: 30 ms; Peak memory: 5.305 MB. Show Profiling Timeline

总计9条数据
TimeDurationCategoryInfo
  
16:48:17.2904.7 msyii\db\Command::querySELECT 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 (5085, 5248, 1015, 1022, 5064, 1023)) AND ("ps"."start_at" >= '2026-01-01 00:00:00') AND ("ps"."start_at" <= '2026-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, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 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
16:48:17.2863.4 msyii\db\Command::querySELECT 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 (5085, 5248, 1015, 1022, 5064, 1023)) AND ("ps"."start_at" >= '2026-01-01 00:00:00') AND ("ps"."start_at" <= '2026-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, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 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"
16:48:17.2961.5 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/analysis/pre-sales-ticket-list', '{"period":"currentfascalyear","alert":"false","page":"1","web_access_token":"YwFaPh8a1dbQrFwOp6grZ7RlSTuMSejO"}', '{"code":2000,"result":{"list":[{"id":1946,"ticket_no":"PS260602001001","client_id":3464,"name":"\u9690\u6027\u9700\u6c42","project_id":4176,"project_title":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260602003","end_at":"2026-06-02 02:00:00","start_at":"2026-06-02 00:00:00","spent":"02:00:00","engineer_name":"\u59da\u96ea\u7eaf","service_id":273,"service_name":"\u6280\u672f\u65b9\u6848-\u4e00\u7ea7\u6587\u6863","case_id":9262,"case_no":"PS260602001","case_type":1,"sales_rep":5449,"sales_rep_name":"\u5468\u4e3d\u98de","updated_at":"2026-06-02 18:10:00","start_at_display":"2026-06-02 00:00","end_at_display":"2026-06-02 02:00","hours_spent_display":"2\u5c0f\u65f6","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1945,"ticket_no":"PS260601001001","client_id":3311,"name":"\u5317\u4eac\u534e\u8fb0\u60a6\u79d1\u6280\u6709\u9650\u516c\u53f8","project_id":4173,"project_title":"\u6d4b\u8bd5\u5de5\u5355\u4eba\u5de5\u6210\u672c\u95ee\u9898","end_at":"2026-06-01 02:00:00","start_at":"2026-06-01 00:00:00","spent":"02:00:00","engineer_name":"\u59da\u96ea\u7eaf","service_id":273,"service_name":"\u6280\u672f\u65b9\u6848-\u4e00\u7ea7\u6587\u6863","case_id":9260,"case_no":"PS260601001","case_type":1,"sales_rep":1001,"sales_rep_name":"\u5218\u4eba\u8bda","updated_at":"2026-06-01 12:47:46","start_at_display":"2026-06-01 00:00","end_at_display":"2026-06-01 02:00","hours_spent_display":"2\u5c0f\u65f6","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1944,"ticket_no":"PS260413001004","client_id":3456,"name":"\u5317\u4eac\u521b\u601d\u7acb\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8","project_id":"","project_title":"","end_at":"2026-04-17 11:36:00","start_at":"2026-04-17 11:36:00","spent":"00:00:00","engineer_name":"\u59da\u96ea\u7eaf","service_id":273,"service_name":"\u6280\u672f\u65b9\u6848-\u4e00\u7ea7\u6587\u6863","case_id":9250,"case_no":"PS260413001","case_type":1,"sales_rep":5295,"sales_rep_name":"\u9b4f\u6cfd\u6587","updated_at":"2026-04-17 12:00:03","start_at_display":"2026-04-17 11:36","end_at_display":"2026-04-17 11:36","hours_spent_display":"0\u5206\u949f","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1943,"ticket_no":"PS260413001003","client_id":3456,"name":"\u5317\u4eac\u521b\u601d\u7acb\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8","project_id":"","project_title":"","end_at":"2026-04-15 16:07:00","start_at":"2026-04-15 16:07:00","spent":"00:00:00","engineer_name":"\u59da\u96ea\u7eaf","service_id":273,"service_name":"\u6280\u672f\u65b9\u6848-\u4e00\u7ea7\u6587\u6863","case_id":9250,"case_no":"PS260413001","case_type":1,"sales_rep":5295,"sales_rep_name":"\u9b4f\u6cfd\u6587","updated_at":"2026-04-15 16:07:51","start_at_display":"2026-04-15 16:07","end_at_display":"2026-04-15 16:07","hours_spent_display":"0\u5206\u949f","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1942,"ticket_no":"PS260413001002","client_id":3456,"name":"\u5317\u4eac\u521b\u601d\u7acb\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8","project_id":"","project_title":"","end_at":"2026-04-13 15:19:00","start_at":"2026-04-13 15:19:00","spent":"00:00:00","engineer_name":"\u59da\u96ea\u7eaf","service_id":273,"service_name":"\u6280\u672f\u65b9\u6848-\u4e00\u7ea7\u6587\u6863","case_id":9250,"case_no":"PS260413001","case_type":1,"sales_rep":5295,"sales_rep_name":"\u9b4f\u6cfd\u6587","updated_at":"2026-04-13 15:19:52","start_at_display":"2026-04-13 15:19","end_at_display":"2026-04-13 15:19","hours_spent_display":"0\u5206\u949f","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1941,"ticket_no":"PS260413001001","client_id":3456,"name":"\u5317\u4eac\u521b\u601d\u7acb\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8","project_id":"","project_title":"","end_at":"2026-04-13 12:00:00","start_at":"2026-04-13 12:00:00","spent":"00:00:00","engineer_name":"\u59da\u96ea\u7eaf","service_id":273,"service_name":"\u6280\u672f\u65b9\u6848-\u4e00\u7ea7\u6587\u6863","case_id":9250,"case_no":"PS260413001","case_type":1,"sales_rep":5295,"sales_rep_name":"\u9b4f\u6cfd\u6587","updated_at":"2026-04-13 13:59:03","start_at_display":"2026-04-13 12:00","end_at_display":"2026-04-13 12:00","hours_spent_display":"0\u5206\u949f","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1940,"ticket_no":"PS260325003001","client_id":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","project_id":4132,"project_title":"AI\u670d\u52a1\u5668\u91c7\u8d2d","end_at":"2026-04-07 15:00:00","start_at":"2026-04-07 13:00:00","spent":"02:00:00","engineer_name":"\u5434\u660a","service_id":230,"service_name":"\u54a8\u8be2\u670d\u52a1","case_id":9245,"case_no":"PS260325003","case_type":1,"sales_rep":5087,"sales_rep_name":"\u5218\u5fae","updated_at":"2026-04-07 16:13:53","start_at_display":"2026-04-07 13:00","end_at_display":"2026-04-07 15:00","hours_spent_display":"2\u5c0f\u65f6","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1938,"ticket_no":"PS260325002001","client_id":85,"name":"\u5317\u4eac\u52a8\u529b\u673a\u68b0\u7814\u7a76\u624031\u6240","project_id":4029,"project_title":"\u667a\u80fd\u529e\u516c\u73af\u5883\u5efa\u8bbe-WPS+AI","end_at":"2026-03-25 16:15:00","start_at":"2026-03-25 16:15:00","spent":"00:00:00","engineer_name":"\u5434\u660a","service_id":230,"service_name":"\u54a8\u8be2\u670d\u52a1","case_id":9244,"case_no":"PS260325002","case_type":1,"sales_rep":5087,"sales_rep_name":"\u5218\u5fae","updated_at":"2026-03-25 20:29:01","start_at_display":"2026-03-25 16:15","end_at_display":"2026-03-25 16:15","hours_spent_display":"0\u5206\u949f","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1939,"ticket_no":"PS260325001001","client_id":85,"name":"\u5317\u4eac\u52a8\u529b\u673a\u68b0\u7814\u7a76\u624031\u6240","project_id":4029,"project_title":"\u667a\u80fd\u529e\u516c\u73af\u5883\u5efa\u8bbe-WPS+AI","end_at":"2026-03-25 11:05:00","start_at":"2026-03-25 09:05:00","spent":"02:00:00","engineer_name":"\u5434\u660a","service_id":275,"service_name":"\u6280\u672f\u65b9\u6848-\u4e8c\u7ea7\u6587\u6863","case_id":9243,"case_no":"PS260325001","case_type":1,"sales_rep":5087,"sales_rep_name":"\u5218\u5fae","updated_at":"2026-03-25 20:32:58","start_at_display":"2026-03-25 09:05","end_at_display":"2026-03-25 11:05","hours_spent_display":"2\u5c0f\u65f6","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1937,"ticket_no":"PS260320004001","client_id":3270,"name":"\u5317\u4eac\u51ef\u9510\u8fdc\u666f\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","project_id":3583,"project_title":"\u670d\u52a1\u8d39-K","end_at":"2026-03-20 12:39:00","start_at":"2026-03-20 11:00:00","spent":"01:39:00","engineer_name":"\u5434\u660a","service_id":230,"service_name":"\u54a8\u8be2\u670d\u52a1","case_id":9233,"case_no":"PS260320004","case_type":1,"sales_rep":5087,"sales_rep_name":"\u5218\u5fae","updated_at":"2026-03-22 10:59:07","start_at_display":"2026-03-20 11:00","end_at_display":"2026-03-20 12:39","hours_spent_display":"1\u5c0f\u65f639\u5206\u949f","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1936,"ticket_no":"PS260320001001","client_id":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","project_id":4132,"project_title":"AI\u670d\u52a1\u5668\u91c7\u8d2d","end_at":"2026-03-20 11:00:00","start_at":"2026-03-20 10:52:00","spent":"00:08:00","engineer_name":"\u5434\u660a","service_id":233,"service_name":"\u7efc\u5408\u670d\u52a1\u534a\u5929","case_id":9230,"case_no":"PS260320001","case_type":1,"sales_rep":5087,"sales_rep_name":"\u5218\u5fae","updated_at":"2026-03-22 10:54:59","start_at_display":"2026-03-20 10:52","end_at_display":"2026-03-20 11:00","hours_spent_display":"8\u5206\u949f","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1934,"ticket_no":"PS260318001001","client_id":2492,"name":"\u822a\u5929\u79d1\u5de5\u96c6\u56e2\u667a\u80fd\u79d1\u6280\u7814\u7a76\u9662\u6709\u9650\u516c\u53f8","project_id":4060,"project_title":"\u4f53\u7cfb\u5ba4\u5bf9J\u9879\u76ee","end_at":"2026-03-18 15:00:00","start_at":"2026-03-18 14:00:00","spent":"01:00:00","engineer_name":"\u5434\u660a","service_id":230,"service_name":"\u54a8\u8be2\u670d\u52a1","case_id":9227,"case_no":"PS260318001","case_type":1,"sales_rep":5087,"sales_rep_name":"\u5218\u5fae","updated_at":"2026-03-19 12:23:32","start_at_display":"2026-03-18 14:00","end_at_display":"2026-03-18 15:00","hours_spent_display":"1\u5c0f\u65f6","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1935,"ticket_no":"PS260317003001","client_id":498,"name":"\u7231\u6155\u80a1\u4efd\u6709\u9650\u516c\u53f8","project_id":4143,"project_title":"\u65b0\u8d2dPA\u9632\u706b\u5899","end_at":"2026-03-17 11:00:00","start_at":"2026-03-17 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":9226,"case_no":"PS260317003","case_type":1,"sales_rep":5295,"sales_rep_name":"\u9b4f\u6cfd\u6587","updated_at":"2026-03-19 12:27:53","start_at_display":"2026-03-17 10:00","end_at_display":"2026-03-17 11:00","hours_spent_display":"1\u5c0f\u65f6","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1933,"ticket_no":"PS260316006001","client_id":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240","project_id":3795,"project_title":"Deepseek\u79c1\u6709\u5316\u90e8\u7f72","end_at":"2026-03-16 17:34:00","start_at":"2026-03-16 15:25:00","spent":"02:09:00","engineer_name":"\u5434\u660a","service_id":230,"service_name":"\u54a8\u8be2\u670d\u52a1","case_id":9223,"case_no":"PS260316006","case_type":1,"sales_rep":5087,"sales_rep_name":"\u5218\u5fae","updated_at":"2026-03-19 12:26:22","start_at_display":"2026-03-16 15:25","end_at_display":"2026-03-16 17:34","hours_spent_display":"2\u5c0f\u65f69\u5206\u949f","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1932,"ticket_no":"PS260305003001","client_id":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","project_id":4132,"project_title":"AI\u670d\u52a1\u5668\u91c7\u8d2d","end_at":"2026-03-04 15:00:00","start_at":"2026-03-04 14:00:00","spent":"01:00:00","engineer_name":"\u5434\u660a","service_id":275,"service_name":"\u6280\u672f\u65b9\u6848-\u4e8c\u7ea7\u6587\u6863","case_id":9207,"case_no":"PS260305003","case_type":1,"sales_rep":5087,"sales_rep_name":"\u5218\u5fae","updated_at":"2026-03-05 16:17:03","start_at_display":"2026-03-04 14:00","end_at_display":"2026-03-04 15:00","hours_spent_display":"1\u5c0f\u65f6","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1931,"ticket_no":"PS260227001001","client_id":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","project_id":4109,"project_title":"\u865a\u62df\u684c\u9762\u5efa\u8bbe-K","end_at":"2026-02-27 17:37:00","start_at":"2026-02-27 15:47:00","spent":"01:50:00","engineer_name":"\u5434\u660a","service_id":230,"service_name":"\u54a8\u8be2\u670d\u52a1","case_id":9191,"case_no":"PS260227001","case_type":1,"sales_rep":5087,"sales_rep_name":"\u5218\u5fae","updated_at":"2026-02-28 07:46:06","start_at_display":"2026-02-27 15:47","end_at_display":"2026-02-27 17:37","hours_spent_display":"1\u5c0f\u65f650\u5206\u949f","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1930,"ticket_no":"PS260210002001","client_id":3330,"name":"\u94a2\u7814\u660a\u666e\u79d1\u6280\u6709\u9650\u516c\u53f8\/ \u94a2\u7814\u660a\u666e\uff08\u82cf\u5dde\uff09\u521b\u65b0\u4e2d\u5fc3\u6709\u9650\u516c\u53f8","project_id":4017,"project_title":"\u58f9\u8fdb\u5236\u5907\u4efd\u4e00\u4f53\u673a\u65b0\u8d2d-2026","end_at":"2026-02-11 11:00:00","start_at":"2026-02-11 09:00:00","spent":"02:00:00","engineer_name":"\u5f90\u7855","service_id":273,"service_name":"\u6280\u672f\u65b9\u6848-\u4e00\u7ea7\u6587\u6863","case_id":9180,"case_no":"PS260210002","case_type":1,"sales_rep":5300,"sales_rep_name":"\u82cf\u6e05\u4e91","updated_at":"2026-02-11 14:50:23","start_at_display":"2026-02-11 09:00","end_at_display":"2026-02-11 11:00","hours_spent_display":"2\u5c0f\u65f6","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1929,"ticket_no":"PS260209001001","client_id":3330,"name":"\u94a2\u7814\u660a\u666e\u79d1\u6280\u6709\u9650\u516c\u53f8\/ \u94a2\u7814\u660a\u666e\uff08\u82cf\u5dde\uff09\u521b\u65b0\u4e2d\u5fc3\u6709\u9650\u516c\u53f8","project_id":4017,"project_title":"\u58f9\u8fdb\u5236\u5907\u4efd\u4e00\u4f53\u673a\u65b0\u8d2d-2026","end_at":"2026-02-09 10:00:00","start_at":"2026-02-09 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":9176,"case_no":"PS260209001","case_type":1,"sales_rep":5300,"sales_rep_name":"\u82cf\u6e05\u4e91","updated_at":"2026-02-10 15:46:29","start_at_display":"2026-02-09 09:00","end_at_display":"2026-02-09 10:00","hours_spent_display":"1\u5c0f\u65f6","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1928,"ticket_no":"PS260204001001","client_id":89,"name":"\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u62db\u91d1\u77ff\u4e1a\u80a1\u4efd\u6709\u9650\u516c\u53f8)","project_id":3976,"project_title":"\u865a\u62df\u5316\u6269\u5bb9\uff0c\u6838\u5fc3\u7f51\u7edc\u6539\u9020","end_at":"2026-02-04 20:33:00","start_at":"2026-02-04 08:57:00","spent":"11:36:00","engineer_name":"\u5434\u660a","service_id":230,"service_name":"\u54a8\u8be2\u670d\u52a1","case_id":9160,"case_no":"PS260204001","case_type":1,"sales_rep":1005,"sales_rep_name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","updated_at":"2026-02-04 20:36:38","start_at_display":"2026-02-04 08:57","end_at_display":"2026-02-04 20:33","hours_spent_display":"11\u5c0f\u65f636\u5206\u949f","case_type_display":"\u552e\u524d\u54a8\u8be2"},{"id":1926,"ticket_no":"PS260204003001","client_id":89,"name":"\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u62db\u91d1\u77ff\u4e1a\u80a1\u4efd\u6709\u9650\u516c\u53f8)","project_id":3976,"project_title":"\u865a\u62df\u5316\u6269\u5bb9\uff0c\u6838\u5fc3\u7f51\u7edc\u6539\u9020","end_at":"2026-02-04 20:06:00","start_at":"2026-02-04 08:54:00","spent":"11:12:00","engineer_name":"\u5468\u5b50\u5065","service_id":230,"service_name":"\u54a8\u8be2\u670d\u52a1","case_id":9162,"case_no":"PS260204003","case_type":1,"sales_rep":1005,"sales_rep_name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","updated_at":"2026-02-05 17:29:12","start_at_display":"2026-02-04 08:54","end_at_display":"2026-02-04 20:06","hours_spent_display":"11\u5c0f\u65f612\u5206\u949f","case_type_display":"\u552e\u524d\u54a8\u8be2"}],"can_create":true,"pagenation":{"totalcount":26,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"43.224.72.82","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-09 16:48:17', 24375808) RETURNING "id"
16:48:17.2741.3 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:48:17.2831.0 msyii\db\Command::querySELECT "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, '[)') && '[2026-01-01 00:00:00, 2026-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
16:48:17.2750.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5493
16:48:17.2770.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:48:17.2850.5 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5085, 5248, 1015, 1022, 5064, 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
16:48:17.2780.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001