Two table paging problems

The paging problem of the two tables is that the user's images are counted as albums. There are two types of images for users: Images for posting and images for comments. The problem is how to pagination. These two types are stored in different tables. how can we implement paging?, the union query does not slow down the results page. only when you do this can you know the paging problem of the two tables.
Now, you need to count the images sent by users into albums. There are two types of images for users: Images for posting and images for comments. The problem is how to pagination. These two types are stored in different tables. how can we implement paging ..
------ Solution --------------------
Joint query
Pagination of results
------ Solution --------------------
It's not slow. you only know it when you do it.

If you think it is slow, it is not the fault of union, but your architecture problems.
------ Solution --------------------
Use union_all to hurry up...
The database can only do this.
To be faster, you should have to change the architecture design...