I just had an account banned for excessive MySQL queries - totalling 2000 per single page view. I think it has something to do with the number of options available on some products. Is there any way to minimize the number of queries while still keeping those options available?


15 Query select master_categories_id from products where products_id = '9'
15 Query select sale_specials_condition, sale_deduction_value, sale_deduction_type from salemaker_sales where sale_categories_all like '%,4,%' and sale_status = '1' and (sale_date_start <= now() or sale_date_start = '0001-01-01') and (sale_date_end >= now() or sale_date_end = '0001-01-01') and (sale_pricerange_from <= '0.0000' or sale_pricerange_from = '0') and (sale_pricerange_to >= '0.0000' or sale_pricerange_to = '0')
15 Query select options_id from products_attributes where products_attributes_id='888'
15 Query select products_options_type from products_options where products_options_id='16'
15 Query select products_attributes_filename, products_attributes_maxdays, products_attributes_maxcount
15 Query select max(products_attributes_id) + 1
15 Query select products_model
15 Query select products_name
15 Query select * from products_options
15 Query select * from products_options_values
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id
15 Query select products_options_name
15 Query select products_options_id