Hey @foco_radiante,
As @steevej has mentioned, kindly post the explain plain for us to better understand and help you with the problem. I also noticed that your included schema snippet does not have any index declarations, which could be one of the reasons for the slow queries. I suggest adding the appropriate compound index to support that query if you are not already using them.
I also noticed you had a very similar discussion here as well:
Did this discussion help resolve this problem or something is still left to be resolved?
Regards,
Satyam