Optimize query of shop page (code ignitor + sql)

Job ID: 37247569

Budget: ₹1,500 – ₹12,500 INR

I am looking for a skilled developer to optimize the query of our shop page. I give you all necessary details required for you to confirm in case you are able to optimize for a proper solution since we manage to drop the query from 1.5seconds to 0.35seconds , yet our objective to reach 0.001second or less per query like other ecommerce platforms so in case multiple users browsing at the same time or searching or ... it will be smooth
check if doable then we can hire?

Need to check the issue of offset and limit
We reach 0.35sec down from 1.5sec per single query

Specific requirements for the rewritten query include ensuring compatibility with certain versions of Code Ignitor.

https://www.dropbox.com/scl/fi/vtj9d2ynstvhazshqqjda/casadar_live.sql?rlkey=lh14gti7ga5h8m1bgu4uv9sol&dl=0

Budget is fixed 2000 INR
I will only release payment once achieve to run query as per mention.

Happy Bidding!