SELECT
  TD_TIME_FORMAT(time,'yyyy-MM-dd HH:mm:ss','JST') AS t,
  TD_TIME_FORMAT(TD_TIME_ADD(time,  '1d','JST' ),'yyyy-MM-dd HH:mm:ss','JST') AS add_1d,
  TD_TIME_FORMAT(TD_TIME_ADD(time, '-1d','JST' ),'yyyy-MM-dd HH:mm:ss','JST') AS reduce_1d,
  TD_TIME_FORMAT(TD_TIME_ADD(time,  '1h','JST' ),'yyyy-MM-dd HH:mm:ss','JST') AS add_1h,
  TD_TIME_FORMAT(TD_TIME_ADD(time, '-1h','JST' ),'yyyy-MM-dd HH:mm:ss','JST') AS reduce_1h,
  TD_TIME_FORMAT(TD_TIME_ADD(time,  '1m','JST' ),'yyyy-MM-dd HH:mm:ss','JST') AS add_1m,
  TD_TIME_FORMAT(TD_TIME_ADD(time, '-1m','JST' ),'yyyy-MM-dd HH:mm:ss','JST') AS reduce_1m,
  TD_TIME_FORMAT(TD_TIME_ADD(time,  '1s','JST' ),'yyyy-MM-dd HH:mm:ss','JST') AS add_1s,
  TD_TIME_FORMAT(TD_TIME_ADD(time, '-1s','JST' ),'yyyy-MM-dd HH:mm:ss','JST') AS reduce_1s
FROM access_log
WHERE TD_TIME_RANGE(time,'2017-01-15','2017-01-16','JST')
ORDER BY t DESC
LIMIT 1