Time consumption of SQLite GROYP queries, Ruby on Rails

I am a beginner in Sqlite3 and Ruby on Rails.

I would like to ask about the expected time of a GROUP query.

The truth is that I have a query with 10 conditions, retrieving data by that takes 166 ms, which is not a problem.

However, for the same query when I have the query and group by condition it takes 15358 ms or 4362 ms.

Are these number expected? Is there a way to improve the time consuming?