recently moved hosting, went to look at the cache folder and found hundreds of these files basically like the below
note this is only part of one file
names like
query_selects_shopping_cart_1428321898.txt
Code:
I AM HERE shopping_cart
sidebox:
Explain
select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zen_products_attributes where products_id = '13' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value;
I AM HERE shopping_cart
sidebox:
Explain
select specials_new_products_price from zen_specials where products_id = '13' and status='1';
I AM HERE shopping_cart
sidebox:
Explain
select master_categories_id from zen_products where products_id = '13';
I AM HERE shopping_cart
sidebox:
Explain
select sale_specials_condition, sale_deduction_value, sale_deduction_type from zen_salemaker_sales where sale_categories_all like '%,3,%' 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 <= '28.9500' or sale_pricerange_from = '0') and (sale_pricerange_to >= '28.9500' or sale_pricerange_to = '0');
I AM HERE shopping_cart
sidebox:
Explain
select product_is_free from zen_products where products_id = '13' limit 1;
I AM HERE shopping_cart
sidebox:
Explain
select products_id, products_price, products_tax_class_id, products_weight,
products_priced_by_attribute, product_is_always_free_shipping, products_discount_type, products_discount_type_from,
products_virtual, products_model
from zen_products
where products_id = '13';
I AM HERE shopping_cart
sidebox:
Explain
select sum(tax_rate) as tax_rate
from (zen_tax_rates tr
left join zen_zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id)
left join zen_geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) )
where (za.zone_country_id is null
or za.zone_country_id = 0
or za.zone_country_id = '13')
and (za.zone_id is null
or za.zone_id = 0
or za.zone_id = '189')
and tr.tax_class_id = '0'
group by tr.tax_priority;
Bookmarks