=== 0. 表结构探查 ===
DeviceWorkRecords 列: RecordId, DeviceId, WorkDate, WorkHours, LegacySourceId, CreatedAt
CsmWorkRecords 列: RecordId, DeviceId, WorkDate, WorkHours, SyncAt
-> DeviceWorkRecords 时间戳列使用: CreatedAt

=== 1. Equipment 基本信息 (FactoryNo=0506500122) ===
  {"EquipmentId":37,"EquipmentCode":"克26-10","EquipmentName":"高空作业车","FactoryNo":"0506500122","GpsDeviceNo":"865167041633992","SmbGpsDeviceId":"67C2HYLG5QO7","SmbTotalWorkHours":11710171.1,"SmbCurrentWorkHours":11473739.8}
-> GpsDeviceNo = 865167041633992, SmbGpsDeviceId = 67C2HYLG5QO7

=== 2. DeviceWorkRecords (GPS51 来源) TOP 30 ORDER BY WorkDate DESC ===
记录数: 30
  {"WorkDate":"2026-08-06T00:00:00.000Z","WorkHours":2.69,"SyncAt":"2026-08-06T16:22:32.207Z"}
  {"WorkDate":"2026-08-05T00:00:00.000Z","WorkHours":0.07,"SyncAt":"2026-08-06T16:22:32.207Z"}
  {"WorkDate":"2026-08-03T00:00:00.000Z","WorkHours":6.96,"SyncAt":"2026-08-06T16:22:32.207Z"}
  {"WorkDate":"2026-08-02T00:00:00.000Z","WorkHours":6.27,"SyncAt":"2026-08-06T16:22:32.207Z"}
  {"WorkDate":"2026-08-01T00:00:00.000Z","WorkHours":4.67,"SyncAt":"2026-08-06T16:22:32.207Z"}
  {"WorkDate":"2026-07-31T00:00:00.000Z","WorkHours":14.19,"SyncAt":"2026-08-06T16:22:32.207Z"}
  {"WorkDate":"2026-07-30T00:00:00.000Z","WorkHours":13.56,"SyncAt":"2026-08-06T16:22:32.207Z"}
  {"WorkDate":"2026-07-29T00:00:00.000Z","WorkHours":9.74,"SyncAt":"2026-08-06T16:22:32.207Z"}
  {"WorkDate":"2026-07-28T00:00:00.000Z","WorkHours":18.9,"SyncAt":"2026-08-06T16:22:32.207Z"}
  {"WorkDate":"2026-07-27T00:00:00.000Z","WorkHours":10.04,"SyncAt":"2026-08-06T16:22:32.207Z"}
  {"WorkDate":"2026-07-26T00:00:00.000Z","WorkHours":10.43,"SyncAt":"2026-08-06T16:22:32.207Z"}
  {"WorkDate":"2026-07-25T00:00:00.000Z","WorkHours":5.36,"SyncAt":"2026-08-06T16:22:32.207Z"}
  {"WorkDate":"2026-07-24T00:00:00.000Z","WorkHours":6.22,"SyncAt":"2026-08-06T16:22:32.207Z"}
  {"WorkDate":"2026-07-23T00:00:00.000Z","WorkHours":18.71,"SyncAt":"2026-08-06T16:22:32.207Z"}
  {"WorkDate":"2026-07-22T00:00:00.000Z","WorkHours":6.81,"SyncAt":"2026-08-06T16:22:32.207Z"}
  {"WorkDate":"2026-07-21T00:00:00.000Z","WorkHours":18.67,"SyncAt":"2026-08-06T16:22:32.207Z"}
  {"WorkDate":"2026-07-20T00:00:00.000Z","WorkHours":4.8,"SyncAt":"2026-08-06T16:22:32.207Z"}
  {"WorkDate":"2026-07-19T00:00:00.000Z","WorkHours":0.02,"SyncAt":"2026-08-06T16:22:32.207Z"}
  {"WorkDate":"2026-07-18T00:00:00.000Z","WorkHours":4.11,"SyncAt":"2026-08-06T16:22:32.207Z"}
  {"WorkDate":"2026-07-17T00:00:00.000Z","WorkHours":8.86,"SyncAt":"2026-08-06T16:22:32.207Z"}
  {"WorkDate":"2026-07-16T00:00:00.000Z","WorkHours":9.98,"SyncAt":"2026-08-06T16:22:32.207Z"}
  {"WorkDate":"2026-07-15T00:00:00.000Z","WorkHours":16.88,"SyncAt":"2026-08-06T16:22:32.207Z"}
  {"WorkDate":"2026-07-14T00:00:00.000Z","WorkHours":10.62,"SyncAt":"2026-08-06T16:22:32.207Z"}
  {"WorkDate":"2026-07-13T00:00:00.000Z","WorkHours":1.81,"SyncAt":"2026-08-06T16:22:11.080Z"}
  {"WorkDate":"2026-07-12T00:00:00.000Z","WorkHours":0,"SyncAt":"2026-08-06T16:22:11.080Z"}
  {"WorkDate":"2026-07-11T00:00:00.000Z","WorkHours":0,"SyncAt":"2026-08-06T16:22:11.080Z"}
  {"WorkDate":"2026-07-10T00:00:00.000Z","WorkHours":0,"SyncAt":"2026-08-06T16:22:11.080Z"}
  {"WorkDate":"2026-07-09T00:00:00.000Z","WorkHours":7.86,"SyncAt":"2026-08-06T16:22:11.080Z"}
  {"WorkDate":"2026-07-08T00:00:00.000Z","WorkHours":10.31,"SyncAt":"2026-08-06T16:22:11.080Z"}
  {"WorkDate":"2026-07-07T00:00:00.000Z","WorkHours":11.51,"SyncAt":"2026-08-06T16:22:11.080Z"}

=== 3. CsmWorkRecords (CSM 来源) 按 GpsDeviceNo 查, TOP 30 ORDER BY WorkDate DESC ===
记录数: 30
  {"WorkDate":"2026-08-05T00:00:00.000Z","WorkHours":1.02,"SyncAt":"2026-08-06T17:20:43.303Z"}
  {"WorkDate":"2026-08-04T00:00:00.000Z","WorkHours":1.02,"SyncAt":"2026-08-06T16:29:37.717Z"}
  {"WorkDate":"2026-08-03T00:00:00.000Z","WorkHours":5.13,"SyncAt":"2026-08-06T17:20:43.303Z"}
  {"WorkDate":"2026-08-02T00:00:00.000Z","WorkHours":5.13,"SyncAt":"2026-08-06T16:29:37.717Z"}
  {"WorkDate":"2026-07-05T00:00:00.000Z","WorkHours":5.12,"SyncAt":"2026-08-06T17:25:56.650Z"}
  {"WorkDate":"2026-07-03T00:00:00.000Z","WorkHours":1.02,"SyncAt":"2026-08-06T17:25:56.650Z"}
  {"WorkDate":"2026-07-02T00:00:00.000Z","WorkHours":4.1,"SyncAt":"2026-08-06T17:25:56.650Z"}
  {"WorkDate":"2026-07-01T00:00:00.000Z","WorkHours":6.13,"SyncAt":"2026-08-06T17:25:56.650Z"}
  {"WorkDate":"2026-06-30T00:00:00.000Z","WorkHours":3.43,"SyncAt":"2026-08-06T17:25:56.763Z"}
  {"WorkDate":"2026-06-29T00:00:00.000Z","WorkHours":0.92,"SyncAt":"2026-08-06T17:25:56.763Z"}
  {"WorkDate":"2026-06-28T00:00:00.000Z","WorkHours":1.8,"SyncAt":"2026-08-06T17:25:56.763Z"}
  {"WorkDate":"2026-06-27T00:00:00.000Z","WorkHours":3.07,"SyncAt":"2026-08-06T17:25:56.763Z"}
  {"WorkDate":"2026-06-26T00:00:00.000Z","WorkHours":1.17,"SyncAt":"2026-08-06T17:25:56.763Z"}
  {"WorkDate":"2026-06-25T00:00:00.000Z","WorkHours":0.87,"SyncAt":"2026-08-06T17:25:56.763Z"}
  {"WorkDate":"2026-06-24T00:00:00.000Z","WorkHours":3.08,"SyncAt":"2026-08-06T17:25:56.763Z"}
  {"WorkDate":"2026-06-23T00:00:00.000Z","WorkHours":3.05,"SyncAt":"2026-08-06T17:25:56.763Z"}
  {"WorkDate":"2026-06-01T00:00:00.000Z","WorkHours":6.13,"SyncAt":"2026-08-06T17:25:56.763Z"}
  {"WorkDate":"2026-05-16T00:00:00.000Z","WorkHours":4.08,"SyncAt":"2026-08-06T17:25:56.917Z"}
  {"WorkDate":"2026-05-15T00:00:00.000Z","WorkHours":15.35,"SyncAt":"2026-08-06T17:25:56.917Z"}
  {"WorkDate":"2026-05-12T00:00:00.000Z","WorkHours":4.1,"SyncAt":"2026-08-06T17:25:56.917Z"}
  {"WorkDate":"2026-05-09T00:00:00.000Z","WorkHours":1.02,"SyncAt":"2026-08-06T17:25:56.917Z"}
  {"WorkDate":"2026-05-06T00:00:00.000Z","WorkHours":1.03,"SyncAt":"2026-08-06T17:25:56.917Z"}
  {"WorkDate":"2026-05-05T00:00:00.000Z","WorkHours":3.05,"SyncAt":"2026-08-06T17:25:56.917Z"}
  {"WorkDate":"2026-05-03T00:00:00.000Z","WorkHours":13.32,"SyncAt":"2026-08-06T17:25:56.917Z"}
  {"WorkDate":"2026-04-17T00:00:00.000Z","WorkHours":1.68,"SyncAt":"2026-08-06T17:25:57.040Z"}
  {"WorkDate":"2026-04-14T00:00:00.000Z","WorkHours":21.32,"SyncAt":"2026-08-06T17:25:57.040Z"}
  {"WorkDate":"2026-04-12T00:00:00.000Z","WorkHours":1.02,"SyncAt":"2026-08-06T17:25:57.040Z"}
  {"WorkDate":"2026-04-07T00:00:00.000Z","WorkHours":22.5,"SyncAt":"2026-08-06T17:25:57.040Z"}
  {"WorkDate":"2026-04-03T00:00:00.000Z","WorkHours":16.38,"SyncAt":"2026-08-06T17:25:57.040Z"}
  {"WorkDate":"2026-03-23T00:00:00.000Z","WorkHours":8.2,"SyncAt":"2026-08-06T17:25:57.160Z"}

=== 4. 跳过（步骤3 已用 GpsDeviceNo 查到数据）===

=== 5. GPS51 与 CSM 相同日期工时对比 (JOIN by GpsDeviceNo) ===
记录数: 92
  {"WorkDate":"2026-08-05T00:00:00.000Z","Gps51Hours":0.07,"CsmHours":1.02,"Diff":-0.95}
  {"WorkDate":"2026-08-03T00:00:00.000Z","Gps51Hours":6.96,"CsmHours":5.13,"Diff":1.83}
  {"WorkDate":"2026-08-02T00:00:00.000Z","Gps51Hours":6.27,"CsmHours":5.13,"Diff":1.14}
  {"WorkDate":"2026-07-05T00:00:00.000Z","Gps51Hours":15.45,"CsmHours":5.12,"Diff":10.33}
  {"WorkDate":"2026-07-03T00:00:00.000Z","Gps51Hours":1.52,"CsmHours":1.02,"Diff":0.5}
  {"WorkDate":"2026-07-02T00:00:00.000Z","Gps51Hours":10.78,"CsmHours":4.1,"Diff":6.68}
  {"WorkDate":"2026-07-01T00:00:00.000Z","Gps51Hours":5.64,"CsmHours":6.13,"Diff":-0.49}
  {"WorkDate":"2026-06-30T00:00:00.000Z","Gps51Hours":6.04,"CsmHours":3.43,"Diff":2.61}
  {"WorkDate":"2026-06-29T00:00:00.000Z","Gps51Hours":20.75,"CsmHours":0.92,"Diff":19.83}
  {"WorkDate":"2026-06-28T00:00:00.000Z","Gps51Hours":20.14,"CsmHours":1.8,"Diff":18.34}
  {"WorkDate":"2026-06-27T00:00:00.000Z","Gps51Hours":12.39,"CsmHours":3.07,"Diff":9.32}
  {"WorkDate":"2026-06-26T00:00:00.000Z","Gps51Hours":20.61,"CsmHours":1.17,"Diff":19.44}
  {"WorkDate":"2026-06-25T00:00:00.000Z","Gps51Hours":20.62,"CsmHours":0.87,"Diff":19.75}
  {"WorkDate":"2026-06-24T00:00:00.000Z","Gps51Hours":12.81,"CsmHours":3.08,"Diff":9.73}
  {"WorkDate":"2026-06-23T00:00:00.000Z","Gps51Hours":2.13,"CsmHours":3.05,"Diff":-0.92}
  {"WorkDate":"2026-06-01T00:00:00.000Z","Gps51Hours":13.72,"CsmHours":6.13,"Diff":7.59}
  {"WorkDate":"2026-05-16T00:00:00.000Z","Gps51Hours":0.2,"CsmHours":4.08,"Diff":-3.88}
  {"WorkDate":"2026-05-15T00:00:00.000Z","Gps51Hours":0.81,"CsmHours":15.35,"Diff":-14.54}
  {"WorkDate":"2026-05-12T00:00:00.000Z","Gps51Hours":0.21,"CsmHours":4.1,"Diff":-3.89}
  {"WorkDate":"2026-05-09T00:00:00.000Z","Gps51Hours":0.01,"CsmHours":1.02,"Diff":-1.01}
  {"WorkDate":"2026-05-06T00:00:00.000Z","Gps51Hours":0.09,"CsmHours":1.03,"Diff":-0.94}
  {"WorkDate":"2026-05-05T00:00:00.000Z","Gps51Hours":0.21,"CsmHours":3.05,"Diff":-2.84}
  {"WorkDate":"2026-05-03T00:00:00.000Z","Gps51Hours":0.78,"CsmHours":13.32,"Diff":-12.54}
  {"WorkDate":"2026-04-17T00:00:00.000Z","Gps51Hours":0,"CsmHours":1.68,"Diff":-1.68}
  {"WorkDate":"2026-04-14T00:00:00.000Z","Gps51Hours":1.09,"CsmHours":21.32,"Diff":-20.23}
  {"WorkDate":"2026-04-12T00:00:00.000Z","Gps51Hours":0.07,"CsmHours":1.02,"Diff":-0.95}
  {"WorkDate":"2026-04-07T00:00:00.000Z","Gps51Hours":1.16,"CsmHours":22.5,"Diff":-21.34}
  {"WorkDate":"2026-04-03T00:00:00.000Z","Gps51Hours":0.78,"CsmHours":16.38,"Diff":-15.6}
  {"WorkDate":"2026-03-23T00:00:00.000Z","Gps51Hours":0.42,"CsmHours":8.2,"Diff":-7.78}
  {"WorkDate":"2026-03-22T00:00:00.000Z","Gps51Hours":0.71,"CsmHours":10.23,"Diff":-9.52}
  {"WorkDate":"2026-03-20T00:00:00.000Z","Gps51Hours":0.81,"CsmHours":16.37,"Diff":-15.56}
  {"WorkDate":"2026-02-26T00:00:00.000Z","Gps51Hours":19.19,"CsmHours":1,"Diff":18.19}
  {"WorkDate":"2026-02-23T00:00:00.000Z","Gps51Hours":8.09,"CsmHours":1,"Diff":7.09}
  {"WorkDate":"2026-02-19T00:00:00.000Z","Gps51Hours":5.06,"CsmHours":3.1,"Diff":1.96}
  {"WorkDate":"2026-02-18T00:00:00.000Z","Gps51Hours":3.09,"CsmHours":1.1,"Diff":1.99}
  {"WorkDate":"2026-02-15T00:00:00.000Z","Gps51Hours":7.09,"CsmHours":2.1,"Diff":4.99}
  {"WorkDate":"2026-02-12T00:00:00.000Z","Gps51Hours":18.87,"CsmHours":1,"Diff":17.87}
  {"WorkDate":"2026-02-11T00:00:00.000Z","Gps51Hours":18.39,"CsmHours":1,"Diff":17.39}
  {"WorkDate":"2026-02-10T00:00:00.000Z","Gps51Hours":17.29,"CsmHours":1,"Diff":16.29}
  {"WorkDate":"2026-02-08T00:00:00.000Z","Gps51Hours":7.17,"CsmHours":1,"Diff":6.17}
  {"WorkDate":"2026-02-04T00:00:00.000Z","Gps51Hours":4.75,"CsmHours":1,"Diff":3.75}
  {"WorkDate":"2026-02-03T00:00:00.000Z","Gps51Hours":4.31,"CsmHours":1,"Diff":3.31}
  {"WorkDate":"2026-02-01T00:00:00.000Z","Gps51Hours":9.63,"CsmHours":1.1,"Diff":8.53}
  {"WorkDate":"2026-01-30T00:00:00.000Z","Gps51Hours":1.27,"CsmHours":1,"Diff":0.27}
  {"WorkDate":"2026-01-25T00:00:00.000Z","Gps51Hours":8.37,"CsmHours":1,"Diff":7.37}
  {"WorkDate":"2026-01-01T00:00:00.000Z","Gps51Hours":0,"CsmHours":1.1,"Diff":-1.1}
  {"WorkDate":"2025-11-04T00:00:00.000Z","Gps51Hours":3.59,"CsmHours":1,"Diff":2.59}
  {"WorkDate":"2025-11-03T00:00:00.000Z","Gps51Hours":1.56,"CsmHours":1,"Diff":0.56}
  {"WorkDate":"2025-10-19T00:00:00.000Z","Gps51Hours":0.69,"CsmHours":2.1,"Diff":-1.41}
  {"WorkDate":"2025-10-15T00:00:00.000Z","Gps51Hours":17.34,"CsmHours":1.1,"Diff":16.24}
  {"WorkDate":"2025-10-13T00:00:00.000Z","Gps51Hours":2.16,"CsmHours":2.1,"Diff":0.06}
  {"WorkDate":"2025-10-09T00:00:00.000Z","Gps51Hours":4.86,"CsmHours":3.1,"Diff":1.76}
  {"WorkDate":"2025-10-02T00:00:00.000Z","Gps51Hours":0.39,"CsmHours":1,"Diff":-0.61}
  {"WorkDate":"2025-09-30T00:00:00.000Z","Gps51Hours":6.73,"CsmHours":1,"Diff":5.73}
  {"WorkDate":"2025-09-29T00:00:00.000Z","Gps51Hours":5.54,"CsmHours":1,"Diff":4.54}
  {"WorkDate":"2025-09-27T00:00:00.000Z","Gps51Hours":11.06,"CsmHours":1.1,"Diff":9.96}
  {"WorkDate":"2025-09-26T00:00:00.000Z","Gps51Hours":10.51,"CsmHours":1,"Diff":9.51}
  {"WorkDate":"2025-09-22T00:00:00.000Z","Gps51Hours":0.46,"CsmHours":1.1,"Diff":-0.64}
  {"WorkDate":"2025-09-13T00:00:00.000Z","Gps51Hours":5.97,"CsmHours":2.1,"Diff":3.87}
  {"WorkDate":"2025-09-12T00:00:00.000Z","Gps51Hours":7.66,"CsmHours":1,"Diff":6.66}
  {"WorkDate":"2025-09-11T00:00:00.000Z","Gps51Hours":0.57,"CsmHours":1,"Diff":-0.43}
  {"WorkDate":"2025-09-09T00:00:00.000Z","Gps51Hours":0.21,"CsmHours":2,"Diff":-1.79}
  {"WorkDate":"2025-09-08T00:00:00.000Z","Gps51Hours":0.28,"CsmHours":1.1,"Diff":-0.82}
  {"WorkDate":"2025-09-06T00:00:00.000Z","Gps51Hours":0.06,"CsmHours":1,"Diff":-0.94}
  {"WorkDate":"2025-09-05T00:00:00.000Z","Gps51Hours":0.73,"CsmHours":1,"Diff":-0.27}
  {"WorkDate":"2025-09-03T00:00:00.000Z","Gps51Hours":5.24,"CsmHours":1,"Diff":4.24}
  {"WorkDate":"2025-09-02T00:00:00.000Z","Gps51Hours":6.36,"CsmHours":2,"Diff":4.36}
  {"WorkDate":"2025-09-01T00:00:00.000Z","Gps51Hours":17.09,"CsmHours":1,"Diff":16.09}
  {"WorkDate":"2025-08-31T00:00:00.000Z","Gps51Hours":5.57,"CsmHours":2,"Diff":3.57}
  {"WorkDate":"2025-08-30T00:00:00.000Z","Gps51Hours":0.06,"CsmHours":1.1,"Diff":-1.04}
  {"WorkDate":"2025-08-26T00:00:00.000Z","Gps51Hours":0.98,"CsmHours":1,"Diff":-0.02}
  {"WorkDate":"2025-08-23T00:00:00.000Z","Gps51Hours":6.51,"CsmHours":1,"Diff":5.51}
  {"WorkDate":"2025-08-22T00:00:00.000Z","Gps51Hours":7.36,"CsmHours":1.1,"Diff":6.26}
  {"WorkDate":"2025-08-16T00:00:00.000Z","Gps51Hours":0.04,"CsmHours":1,"Diff":-0.96}
  {"WorkDate":"2025-08-14T00:00:00.000Z","Gps51Hours":6.09,"CsmHours":1.1,"Diff":4.99}
  {"WorkDate":"2025-08-10T00:00:00.000Z","Gps51Hours":3.46,"CsmHours":1,"Diff":2.46}
  {"WorkDate":"2025-08-09T00:00:00.000Z","Gps51Hours":2.79,"CsmHours":1.1,"Diff":1.69}
  {"WorkDate":"2025-08-02T00:00:00.000Z","Gps51Hours":11.14,"CsmHours":1,"Diff":10.14}
  {"WorkDate":"2025-08-01T00:00:00.000Z","Gps51Hours":3.87,"CsmHours":2,"Diff":1.87}
  {"WorkDate":"2025-07-22T00:00:00.000Z","Gps51Hours":19.8,"CsmHours":1.1,"Diff":18.7}
  {"WorkDate":"2025-07-20T00:00:00.000Z","Gps51Hours":2.85,"CsmHours":1,"Diff":1.85}
  {"WorkDate":"2025-07-19T00:00:00.000Z","Gps51Hours":0.6,"CsmHours":1,"Diff":-0.4}
  {"WorkDate":"2025-07-16T00:00:00.000Z","Gps51Hours":4.91,"CsmHours":1,"Diff":3.91}
  {"WorkDate":"2025-07-15T00:00:00.000Z","Gps51Hours":4.87,"CsmHours":1,"Diff":3.87}
  {"WorkDate":"2025-07-13T00:00:00.000Z","Gps51Hours":1.41,"CsmHours":2.1,"Diff":-0.69}
  {"WorkDate":"2025-07-01T00:00:00.000Z","Gps51Hours":4.72,"CsmHours":1,"Diff":3.72}
  {"WorkDate":"2025-04-17T00:00:00.000Z","Gps51Hours":0.12,"CsmHours":4.1,"Diff":-3.98}
  {"WorkDate":"2025-04-15T00:00:00.000Z","Gps51Hours":7.26,"CsmHours":12.3,"Diff":-5.04}
  {"WorkDate":"2025-03-01T00:00:00.000Z","Gps51Hours":0.09,"CsmHours":4.1,"Diff":-4.01}
  {"WorkDate":"2025-02-25T00:00:00.000Z","Gps51Hours":0.05,"CsmHours":2,"Diff":-1.95}
  {"WorkDate":"2025-02-21T00:00:00.000Z","Gps51Hours":0.53,"CsmHours":16.4,"Diff":-15.87}
  {"WorkDate":"2025-02-20T00:00:00.000Z","Gps51Hours":0.14,"CsmHours":6.1,"Diff":-5.96}

=== 6. SmbDeviceMappings 映射关系 ===
记录数: 1
  {"MappingId":90,"EquipmentId":37,"SmbDeviceId":97,"SmbDeviceIdStr":["67C2HYLG5QO7","67C2HYLG5QO7"],"MatchMethod":"suffix6_unique","IsActive":true,"CreatedAt":"2026-07-30T15:14:29.297Z","UpdatedAt":"2026-07-30T15:14:29.297Z","FactoryNo":"0506500122","GpsDeviceNo":"865167041633992","SmbGpsDeviceId":"67C2HYLG5QO7","DeviceCode":"0506500122"}