config active record to use local time zone, revert index back to select query