人大金仓使用sqlsugar返回数据与直接在数据库执行不一致 返回

SqlSugar 处理完成
12 148

SELECT "ProjectNo","DeviceNo","CyclesCount","WorkingSeconds","Weight","LastStatisticsDate","StatisticsDate","UniqueId"
FROM "dailyworkingcycles"  WHERE (((('3512330' like concat('%',"DeviceNo",'%')) AND( "ProjectNo" = '835e64d578e3417bbfe34195bcb24923' ))
AND ( "StatisticsDate" > '2023/3/24' )) AND ( "StatisticsDate" <= '2023/3/28 0:00:00' ))  这是生成的sql语句直接在数据运行是4条数据,但是程序执行只返回了3条,求助

热忱回答12