Query problems that are slow

[2hexigua]

Springboot 2.4.1
gorm-hibernate5 7.1.0.M2
groovy 3.0.5
After MY query is complete, I continue to loop the query many times, which wastes a lot of my time.

[2hexigua]

A supplementary issue: after I upgraded from springboot1.5 to 2.0+, gorm was also upgraded, which caused the query to be very slow. Later, it was found that the query was slow because of multiple circular select, but I don't know the reason.