Over 1000-1500 MySQL queries. What's the cause?

[koskimaa]

Hey everybody,

 

I've done everything I can to optimize the speed of my store, php7+opcache, bought Jpresta's cache module, tried all the CCC options etc.

 

But I still can't get to that magic under 200ms server response time...

 

After reading dh42's post here: https://dh42.com/blog/prestashop-debug-profiling/

 

I turned on debug profiling and saw that I'm having over 1000 SQL queries, sometimes up to 1500 on a normal page (home page, category page, even product pages).

 

You can see for yourself here: https://www.supergangu.com/japan-toys-merch (debug profiling doesn't seem to want to load on the home page every time)

 

This seems to be way too much and the cause for why my store isn't as fast as it should be.

 

Here is my my.cnf config:

 

query_cache_size=512M
query_cache_limit=32M
query_cache_type=1

 

Shouldn't be any problems there. What do you think the cause of the huge amount of queries are? Is it my theme and modules that are coded poorly, or some other underlying cause?

 

I also attached a screenshot of the debug results.