What cameras and lenses are used for indoor still life shooting?

You can shoot tiny objects with a macro lens. Like Budweiser.

To shoot large objects, you can use a zoom lens of 35 or 50 times or a constant aperture zoom lens with a focal length of 24-70 ... This lens has higher imaging quality.

Due to the limited budget, which is less than 1w, it is difficult to complete all these equipments. ...

You can choose a half-frame body with a lens suitable for most of the subjects you shoot (such as shooting relatively small objects and choosing a macro lens), and then complete other equipment with sufficient budget. ...

As for the specific model, you can choose according to your personal preference ... After the price is determined, there are not many models of fuselage and lens available at that price, so it is easy to make a choice.