Asda has been hardest hit by shoppers cutting back and spending more in no-frills supermarkets such as Aldi and Lidl, new research suggests.