What?

We need to optimize the database queries that repairs do.

The motivation is to reduce resources, which has recently become more relevant because we increased the number of repair workers.

What needs to be done?

Review all the repair queries and see if they can be optimized.

We know that some queries can be optimized by only returning the columns that the repair needs. We likely need to create specific methods/functions for them instead of using a more general one.