Selecting all pipelines is slow

[ghost]

Running

GET http://localhost:8080/master/api/1/pipelines/ 

is slow. Reason is attached in form of log of all queries which are run during this function inside mysql:
https://www.sendbigfiles.com/4b449d99978929988e7f742d538df48b/

800kB of select statements

[tomas-knap]

So this is caused by too many queries being executed by commons-app?

Or is the error somewhere in REST API layer? (I guess not)

[ghost]

Not reproducible.