An explosion at a crowded market in the north-east state of Borno in Nigeria has killed at least 47 people, officials say.