<select id="doGetList" resultMap="studyRecordMap">
select * from study_record
order by create_date desc limit ${start},${pageSize}
</select>
SELECT
deviceId, reportStatus, reportDateTime
FROM
doorSensorDevice
WHERE
deviceId = ${deviceId}
AND reportStatus IS NOT NULL
ORDER BY reportDateTime DESC
LIMIT 0 , 20;