WITH date_series AS (
SELECT FLOOR(EXTRACT(EPOCH FROM day) * 1000) AS day
FROM generate_series(
to_timestamp(#{startTime} / 1000),
to_timestamp(#{endTime} / 1000),
'1 day':: interval
) AS day
WHERE FLOOR(EXTRACT (EPOCH FROM day) * 1000) < #{endTime}
), 如果使用pagehelper 不支持分页。