the following sql statement is known:

select * from a left join b on a.id=b.id
where a.x=1 and b.yroom2;

this is a very common join table query in the db layer, but if the db layer does not allow the join table query operation, it can only be queried by querying a single table separately, and the query results can be combined in the service layer.

it is known that there is a large amount of data in the aformab table, so there is no better solution.

sort out:
1. You cannot do join table queries at the db layer.
2. Both tables have query conditions
3. Query results require data combination of two tables
4. Both tables have a large amount of data