In this post, following the example project that you have here, I am going to explain how to optimize queries to a database using JPA.
You will see different types of queries explaining how to make connections between lazy and eager tables. The tables will be joined by a single field, by several and even by one, but adding a static condition.