Specials query

[Ted]

Hi,

Every now and then (when ofcourse logging is set to log this) I see a query like:

Code Select Expand


SELECT specials.specials_new_products_price, specials.status, specials.expires_date, products_to_categories.categories_id, products.products_date_added, products.products_date_available, products.products_id, products.products_image, products.products_image2, products.products_image3, products.products_image4, products.products_model, products.products_price, products.products_price_1, products.products_price_2, products.products_price_3, products.products_ordered, products.products_quantity, products.products_status, products.products_invisible, products.products_weight, products.products_tax_class_id, products.products_sku, products.products_type, products.products_file_path, products.products_content_type, products.custom1, products.custom2, products.custom3, products.custom4, products.custom5, products.store_id, products.max_download_days, products.max_num_downloads, products.stock_reorder_level, products.can_order_when_not_in_stock, manufacturers.manufacturers_name, manufacturers.manufacturers_id, products_description.products_name, products_description.products_url, products_description.products_viewed, kk_product_to_stores.price_id, products_description.products_description, products_description.products_comparison FROM products LEFT JOIN specials ON products.products_id=specials.products_id LEFT JOIN products_to_categories ON products.products_id=products_to_categories.products_id LEFT JOIN manufacturers ON products.manufacturers_id=manufacturers.manufacturers_id, products_description, kk_product_to_stores WHERE products.products_id=products_description.products_id AND products.products_id=kk_product_to_stores.products_id AND products_description.language_id=1 AND kk_product_to_stores.store_id='SAV' AND products_to_categories.store_id='SAV' AND products.products_id=30593


I can't really pinpoint what part of the code is causing this. Is there a way to disable this? (By the way we're using KkAppEng in our own Wicket app).

[julie]

Looks like the query generated when getting a product by id.