Join tables in SQLite creates delay?

I would like to join the most 7 tables using the SQLite, in Ruby on Rails

However, this process causes a delay and a stuck of the server.

Is it good to have so many joins? Is there any alternative?