If you’re not using price-by-attributes support, turn this off to stop those calculations and the related queries. This step by step tutorial will show you how to disable price factor in your zen cart site.
Log into your zen cart admin and go to Configuration -> Attribute Settings.
Click on “Enable Price Factor”, select “false”, and click on the “update” button.
If you need help customizing your zen cart web site, or would like a great custom design, please contact us for a quote.