I have a project that has 1k visitors at the same time and my queries are not optimized for that end. i need to optimize the queries OR the db adding indexes or whatever. I think this can be done in one hour, but i’m no expert so it would take me like a day to do this. i’m providing the db structure and a screenshot of the explain of the most usual query in the site. i need this URGENTLY =)
