The database belongs to the underlying service, and most of the bottlenecks are often in the database. It is recommended that the database is only used as a tool for the data store, and not concerned with the business. Therefore, I suggest that it is better not to write all kinds of join SQL, it may be better to leave it to the business layer to do the association. What do you think?
Best wishes！ CalvinKirs
