There are some queries repeating for 70 times in my homepage. Especially these two;
SELECT tax_id, address_type, priority, price_includes_tax, regnumber FROM cscart_taxes WHERE tax_id IN (6) AND status = 'A' ORDER BY priority SELECT destination_id, rate_value, rate_type FROM cscart_tax_rates WHERE tax_id = 6 AND destination_id = 1
These two queries run 69 times for each. (That is 138 times for only two queries.)
@martfox was very kind enough to setup the same environment of mine to one of his servers; his copy shows 65-72 queries run for the homepage but mine changes between 104 and 520.
How can I diagnose this problem?