Data operation problems

I currently have four tables for data operation problems. I need to display some of the fields in the table on the page. I don't want to use leftjoin now. I want to divide it into four SQL statements for query, then combine, but this will cause a problem: Search for several fields in four tables, or sort and pagination the fields. these operations will make my cooking more complicated, how can I optimize these operations? there are other solutions, such as le data operation problems?
Currently, I have four tables and need to display some of these fields to the page table. I don't want to use left join now. I want to divide them into four SQL statements for query and then combine them.
However, this may cause a problem: searching for several fields in four tables, sorting and paging the fields will make my cooking more complicated, how can I optimize these operations?

There are other solutions. the efficiency of left join is somewhat low. even if the index is added, how can we put these fields into the page table without using left join, in addition, it is easy to search by page, sort, and search!

------ Solution --------------------
Discussion
Currently, I have four tables and need to display some of these fields to the page table. I don't want to use left join now. I want to divide them into four SQL statements for query and then combine them.
However, this may cause a problem: searching for several fields in four tables, sorting and paging the fields will make my cooking more complicated, how can I optimize these operations?

There are other solutions. the efficiency of left join is somewhat low. even if the index is added, how can we put these fields in the page table without using left join ......

------ Solution --------------------
Integrate fields into a table.
Building indexes well won't be slow, as long as everything is properly planned
You must know that mysql has many restrictions, and even indexes do not do what you want.
You are too harsh on the normal classification of fields in each table. if you do not want to join the fields across four tables, it is too slow to index.