## 2013-02-15 17:31:57 ## 27032 ## CONNECT TIME: 0.0020 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SET NAMES utf8 AFF: 0 TIME: 0.0072 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `core_url_rewrite`.* FROM `core_url_rewrite` WHERE (request_path IN (:path0, :path1)) AND (store_id IN(0, 4)) BIND: array ( ':path0' => 'checkout/cart', ':path1' => 'checkout/cart/', ) AFF: 0 TIME: 0.0004 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `design_change` AS `main_table` WHERE (store_id = :store_id) AND (date_from <= :required_date or date_from IS NULL) AND (date_to >= :required_date or date_to IS NULL) BIND: array ( ':store_id' => 4, ':required_date' => '2013-02-15 17:31:57', ) AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `sales_flat_quote`.* FROM `sales_flat_quote` WHERE (`sales_flat_quote`.`entity_id`='79') AND (store_id IN ('6', '4')) AND (is_active = 1) AFF: 1 TIME: 0.0007 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address` AS `main_table` WHERE (quote_id = '79') AFF: 2 TIME: 0.0005 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address_item` AS `main_table` WHERE (quote_address_id = '316') AFF: 0 TIME: 0.0006 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_item` AS `main_table` WHERE (quote_id = '79') AFF: 1 TIME: 0.0010 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_item_option` AS `main_table` WHERE (item_id IN(143)) AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (`eav_entity_type`.`entity_type_code`='catalog_product') AFF: 1 TIME: 0.0004 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (`eav_entity_type`.`entity_type_code`='customer') AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT DISTINCT ea.attribute_code FROM `salesrule_product_attribute` AS `a` INNER JOIN `eav_attribute` AS `ea` ON ea.attribute_id = a.attribute_id AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.`attribute_id`, `main_table`.`entity_type_id`, `main_table`.`attribute_code`, `main_table`.`attribute_model`, `main_table`.`backend_model`, `main_table`.`backend_type`, `main_table`.`backend_table`, `main_table`.`frontend_input`, `main_table`.`source_model`, `additional_table`.`is_global`, `additional_table`.`is_html_allowed_on_front`, `additional_table`.`is_wysiwyg_enabled` FROM `eav_attribute` AS `main_table` INNER JOIN `catalog_eav_attribute` AS `additional_table` ON additional_table.attribute_id = main_table.attribute_id WHERE (main_table.entity_type_id = 4) AND (attribute_code IN('sku', 'type_id', 'name', 'status', 'visibility', 'price', 'weight', 'url_path', 'url_key', 'thumbnail', 'small_image', 'tax_class_id', 'special_from_date', 'special_to_date', 'special_price', 'cost', 'is_recurring', 'recurring_profile', 'msrp_enabled', 'msrp', 'msrp_display_actual_price_type', 'enable_googlecheckout', 'gift_message_available', 'price_view', 'price_type', 'shipment_type', 'weight_type', 'sku_type', 'links_purchased_separately', 'links_title')) AFF: 29 TIME: 0.0004 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='type_id') AND (entity_type_id = :entity_type_id) BIND: array ( ':entity_type_id' => '4', ) AFF: 0 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `e`.* FROM `catalog_product_entity` AS `e` WHERE (`e`.`entity_id` IN(1302, 1302)) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d` LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('56', '65', '83', '82', '72', '71', '519', '520', '464', '472')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d` LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('80', '85', '81', '502', '462', '468', '465', '469', '467', '466', '470')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d` LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('60', '61', '64', '521')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d` LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('62', '63')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d` LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('503')) AND (t_d.store_id = 0) AFF: 21 TIME: 0.0004 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN('1302')) AND (stock_id=1) AND (website_id=1) AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = '4' LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = '4' WHERE (default_option_title.store_id = 0) AND (product_id IN('1302')) AFF: 0 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `core_url_rewrite`.`product_id`, `core_url_rewrite`.`request_path` FROM `core_url_rewrite` WHERE (store_id = '4') AND (is_system = 1) AND (category_id = '' OR category_id IS NULL) AND (product_id IN('1302')) ORDER BY `category_id` DESC AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='tier_price') AND (entity_type_id = :entity_type_id) BIND: array ( ':entity_type_id' => '4', ) AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id) BIND: array ( ':entity_type_id' => '4', ) AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) BIND: array ( ':attribute_id' => '75', ) AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (entity_id IN('1302')) AND (website_id IN('0', '1')) ORDER BY `entity_id` ASC, `qty` ASC AFF: 0 TIME: 0.0004 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2013-02-15') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('1302')) AFF: 0 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.*, `cp_table`.`type_id`, `status_table`.`stock_status` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id LEFT JOIN `cataloginventory_stock_status` AS `status_table` ON main_table.product_id=status_table.product_id AND main_table.stock_id=status_table.stock_id AND status_table.website_id='1' WHERE (main_table.stock_id = '1') AND (main_table.product_id IN('1302')) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`=1) AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `customer_group`.* FROM `customer_group` WHERE (`customer_group`.`customer_group_id`='0') AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (`eav_entity_type`.`entity_type_code`='customer_address') AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.`attribute_id`, `main_table`.`entity_type_id`, `main_table`.`attribute_code`, `main_table`.`attribute_model`, `main_table`.`backend_model`, `main_table`.`backend_type`, `main_table`.`backend_table`, `main_table`.`frontend_model`, `main_table`.`frontend_input`, `main_table`.`frontend_label`, `main_table`.`frontend_class`, `main_table`.`source_model`, `main_table`.`is_required`, `main_table`.`is_user_defined`, `main_table`.`default_value`, `main_table`.`is_unique`, `main_table`.`note`, `additional_table`.`is_visible`, `additional_table`.`input_filter`, `additional_table`.`multiline_count`, `additional_table`.`validate_rules`, `additional_table`.`is_system`, `additional_table`.`sort_order`, `additional_table`.`data_model`, `scope_table`.`website_id` AS `scope_website_id`, `scope_table`.`is_visible` AS `scope_is_visible`, `scope_table`.`is_required` AS `scope_is_required`, `scope_table`.`default_value` AS `scope_default_value`, `scope_table`.`multiline_count` AS `scope_multiline_count` FROM `eav_attribute` AS `main_table` INNER JOIN `customer_eav_attribute` AS `additional_table` ON additional_table.attribute_id = main_table.attribute_id LEFT JOIN `customer_eav_attribute_website` AS `scope_table` ON scope_table.attribute_id = main_table.attribute_id AND scope_table.website_id = :scope_website_id WHERE (main_table.entity_type_id = :mt_entity_type_id) BIND: array ( ':mt_entity_type_id' => 2, ':scope_website_id' => 1, ) AFF: 28 TIME: 0.0004 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `e`.* FROM `customer_address_entity` AS `e` WHERE (`e`.`entity_type_id` = '2') AND (`e`.`parent_id` = '-1') AFF: 0 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: (SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title` FROM `tax_calculation` AS `main_table` INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '4' WHERE (customer_tax_class_id = 3) AND (product_tax_class_id IN (4)) AND (rate.tax_country_id = 'DE') AND (rate.tax_region_id IN(0, 92)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', '06120', '06120*', '0612*', '061*', '06*', '0*'))) UNION (SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title` FROM `tax_calculation` AS `main_table` INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '4' WHERE (customer_tax_class_id = 3) AND (product_tax_class_id IN (4)) AND (rate.tax_country_id = 'DE') AND (rate.tax_region_id IN(0, 92)) AND (rate.zip_is_range IS NOT NULL) AND ('06120' BETWEEN rate.zip_from AND rate.zip_to)) ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC AFF: 1 TIME: 0.0005 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_payment` AS `main_table` WHERE (quote_id = '79') AFF: 1 TIME: 0.0005 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address_item` AS `main_table` WHERE (quote_address_id = '317') AFF: 0 TIME: 0.0004 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='group_price') AND (entity_type_id = :entity_type_id) BIND: array ( ':entity_type_id' => '4', ) AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id) BIND: array ( ':entity_type_id' => '4', ) AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id) BIND: array ( ':attribute_id' => '583', ) AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price` FROM `catalog_product_entity_group_price` WHERE (entity_id='1302') AND (website_id IN(0, '1')) AFF: 0 TIME: 0.0004 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `directory_currency_rate`.`rate` FROM `directory_currency_rate` WHERE (currency_from = :currency_from) AND (currency_to = :currency_to) BIND: array ( ':currency_from' => 'EUR', ':currency_to' => 'RUB', ) AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `salesrule` AS `main_table` INNER JOIN `salesrule_customer_group` AS `customer_group_ids` ON main_table.rule_id = customer_group_ids.rule_id AND customer_group_ids.customer_group_id = 0 WHERE (EXISTS (SELECT 1 FROM `salesrule_website` AS `website` WHERE (website.website_id IN ('1')) AND (main_table.rule_id = website.rule_id))) AND (from_date is null or from_date <= '2013-02-15') AND (to_date is null or to_date >= '2013-02-15') AND (is_active = '1') AND (main_table.coupon_type = '1') ORDER BY sort_order ASC AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `salesrule_customer_group`.`customer_group_id` FROM `salesrule_customer_group` WHERE (rule_id = '1') AFF: 5 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `salesrule_website`.`website_id` FROM `salesrule_website` WHERE (rule_id = '1') AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `salesrule_coupon`.* FROM `salesrule_coupon` WHERE (rule_id = :rule_id) AND (is_primary = :is_primary) BIND: array ( ':rule_id' => 1, ':is_primary' => 1, ) AFF: 0 TIME: 0.0048 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.`entity_type_id`, `main_table`.`attribute_code`, `main_table`.`attribute_model`, `main_table`.`backend_model`, `main_table`.`backend_type`, `main_table`.`backend_table`, `main_table`.`frontend_model`, `main_table`.`frontend_input`, `main_table`.`frontend_label`, `main_table`.`frontend_class`, `main_table`.`source_model`, `main_table`.`is_required`, `main_table`.`is_user_defined`, `main_table`.`default_value`, `main_table`.`is_unique`, `main_table`.`note`, `additional_table`.* FROM `eav_attribute` AS `main_table` INNER JOIN `catalog_eav_attribute` AS `additional_table` ON additional_table.attribute_id = main_table.attribute_id WHERE (main_table.entity_type_id = 4) AFF: 84 TIME: 0.0039 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: (SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title` FROM `tax_calculation` AS `main_table` INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '4' WHERE (customer_tax_class_id = 3) AND (product_tax_class_id IN ('1')) AND (rate.tax_country_id = 'DE') AND (rate.tax_region_id IN(0, 92)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN('*', '', '06120', '06120*', '0612*', '061*', '06*', '0*'))) UNION (SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title` FROM `tax_calculation` AS `main_table` INNER JOIN `tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id INNER JOIN `tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id LEFT JOIN `tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = '4' WHERE (customer_tax_class_id = 3) AND (product_tax_class_id IN ('1')) AND (rate.tax_country_id = 'DE') AND (rate.tax_region_id IN(0, 92)) AND (rate.zip_is_range IS NOT NULL) AND ('06120' BETWEEN rate.zip_from AND rate.zip_to)) ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC AFF: 1 TIME: 0.0005 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `sales_flat_quote`.* FROM `sales_flat_quote` WHERE (`sales_flat_quote`.`entity_id`='79') AND (store_id IN ('6', '4')) AND (is_active = 1) AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address` AS `main_table` WHERE (quote_id = '79') AFF: 2 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address_item` AS `main_table` WHERE (quote_address_id = '316') AFF: 0 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_item` AS `main_table` WHERE (quote_id = '79') AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_item_option` AS `main_table` WHERE (item_id IN(143)) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT DISTINCT ea.attribute_code FROM `salesrule_product_attribute` AS `a` INNER JOIN `eav_attribute` AS `ea` ON ea.attribute_id = a.attribute_id AFF: 1 TIME: 0.0004 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `e`.* FROM `catalog_product_entity` AS `e` WHERE (`e`.`entity_id` IN(1302, 1302)) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d` LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('56', '65', '83', '82', '72', '71', '519', '520', '464', '472')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d` LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('80', '85', '81', '502', '462', '468', '465', '469', '467', '466', '470')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d` LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('60', '61', '64', '521')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d` LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('62', '63')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d` LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('503')) AND (t_d.store_id = 0) AFF: 21 TIME: 0.0004 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN('1302')) AND (stock_id=1) AND (website_id=1) AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = '4' LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = '4' WHERE (default_option_title.store_id = 0) AND (product_id IN('1302')) AFF: 0 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `core_url_rewrite`.`product_id`, `core_url_rewrite`.`request_path` FROM `core_url_rewrite` WHERE (store_id = '4') AND (is_system = 1) AND (category_id = '' OR category_id IS NULL) AND (product_id IN('1302')) ORDER BY `category_id` DESC AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (entity_id IN('1302')) AND (website_id IN('0', '1')) ORDER BY `entity_id` ASC, `qty` ASC AFF: 0 TIME: 0.0005 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.*, `cp_table`.`type_id`, `status_table`.`stock_status` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id LEFT JOIN `cataloginventory_stock_status` AS `status_table` ON main_table.product_id=status_table.product_id AND main_table.stock_id=status_table.stock_id AND status_table.website_id='1' WHERE (main_table.stock_id = '1') AND (main_table.product_id IN('1302')) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `e`.* FROM `customer_address_entity` AS `e` WHERE (`e`.`entity_type_id` = '2') AND (`e`.`parent_id` = '-1') AFF: 0 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_payment` AS `main_table` WHERE (quote_id = '79') AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address_item` AS `main_table` WHERE (quote_address_id = '317') AFF: 0 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price` FROM `catalog_product_entity_group_price` WHERE (entity_id='1302') AND (website_id IN(0, '1')) AFF: 0 TIME: 0.0004 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `sales_flat_quote`.* FROM `sales_flat_quote` WHERE (`sales_flat_quote`.`entity_id`='79') AND (store_id IN ('6', '4')) AND (is_active = 1) AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address` AS `main_table` WHERE (quote_id = '79') AFF: 2 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address_item` AS `main_table` WHERE (quote_address_id = '316') AFF: 0 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_item` AS `main_table` WHERE (quote_id = '79') AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_item_option` AS `main_table` WHERE (item_id IN(143)) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT DISTINCT ea.attribute_code FROM `salesrule_product_attribute` AS `a` INNER JOIN `eav_attribute` AS `ea` ON ea.attribute_id = a.attribute_id AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `e`.* FROM `catalog_product_entity` AS `e` WHERE (`e`.`entity_id` IN(1302, 1302)) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d` LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('56', '65', '83', '82', '72', '71', '519', '520', '464', '472')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d` LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('80', '85', '81', '502', '462', '468', '465', '469', '467', '466', '470')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d` LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('60', '61', '64', '521')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d` LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('62', '63')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d` LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('503')) AND (t_d.store_id = 0) AFF: 21 TIME: 0.0004 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN('1302')) AND (stock_id=1) AND (website_id=1) AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = '4' LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = '4' WHERE (default_option_title.store_id = 0) AND (product_id IN('1302')) AFF: 0 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `core_url_rewrite`.`product_id`, `core_url_rewrite`.`request_path` FROM `core_url_rewrite` WHERE (store_id = '4') AND (is_system = 1) AND (category_id = '' OR category_id IS NULL) AND (product_id IN('1302')) ORDER BY `category_id` DESC AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (entity_id IN('1302')) AND (website_id IN('0', '1')) ORDER BY `entity_id` ASC, `qty` ASC AFF: 0 TIME: 0.0004 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.*, `cp_table`.`type_id`, `status_table`.`stock_status` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id LEFT JOIN `cataloginventory_stock_status` AS `status_table` ON main_table.product_id=status_table.product_id AND main_table.stock_id=status_table.stock_id AND status_table.website_id='1' WHERE (main_table.stock_id = '1') AND (main_table.product_id IN('1302')) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `e`.* FROM `customer_address_entity` AS `e` WHERE (`e`.`entity_type_id` = '2') AND (`e`.`parent_id` = '-1') AFF: 0 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_payment` AS `main_table` WHERE (quote_id = '79') AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address_item` AS `main_table` WHERE (quote_address_id = '317') AFF: 0 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price` FROM `catalog_product_entity_group_price` WHERE (entity_id='1302') AND (website_id IN(0, '1')) AFF: 0 TIME: 0.0004 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `sales_flat_quote`.* FROM `sales_flat_quote` WHERE (`sales_flat_quote`.`entity_id`='79') AND (store_id IN ('6', '4')) AND (is_active = 1) AFF: 1 TIME: 0.0004 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address` AS `main_table` WHERE (quote_id = '79') AFF: 2 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address_item` AS `main_table` WHERE (quote_address_id = '316') AFF: 0 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_item` AS `main_table` WHERE (quote_id = '79') AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_item_option` AS `main_table` WHERE (item_id IN(143)) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT DISTINCT ea.attribute_code FROM `salesrule_product_attribute` AS `a` INNER JOIN `eav_attribute` AS `ea` ON ea.attribute_id = a.attribute_id AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `e`.* FROM `catalog_product_entity` AS `e` WHERE (`e`.`entity_id` IN(1302, 1302)) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d` LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('56', '65', '83', '82', '72', '71', '519', '520', '464', '472')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d` LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('80', '85', '81', '502', '462', '468', '465', '469', '467', '466', '470')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d` LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('60', '61', '64', '521')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d` LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('62', '63')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d` LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('503')) AND (t_d.store_id = 0) AFF: 21 TIME: 0.0004 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN('1302')) AND (stock_id=1) AND (website_id=1) AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = '4' LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = '4' WHERE (default_option_title.store_id = 0) AND (product_id IN('1302')) AFF: 0 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `core_url_rewrite`.`product_id`, `core_url_rewrite`.`request_path` FROM `core_url_rewrite` WHERE (store_id = '4') AND (is_system = 1) AND (category_id = '' OR category_id IS NULL) AND (product_id IN('1302')) ORDER BY `category_id` DESC AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (entity_id IN('1302')) AND (website_id IN('0', '1')) ORDER BY `entity_id` ASC, `qty` ASC AFF: 0 TIME: 0.0004 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.*, `cp_table`.`type_id`, `status_table`.`stock_status` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id LEFT JOIN `cataloginventory_stock_status` AS `status_table` ON main_table.product_id=status_table.product_id AND main_table.stock_id=status_table.stock_id AND status_table.website_id='1' WHERE (main_table.stock_id = '1') AND (main_table.product_id IN('1302')) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `e`.* FROM `customer_address_entity` AS `e` WHERE (`e`.`entity_type_id` = '2') AND (`e`.`parent_id` = '-1') AFF: 0 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_payment` AS `main_table` WHERE (quote_id = '79') AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address_item` AS `main_table` WHERE (quote_address_id = '317') AFF: 0 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price` FROM `catalog_product_entity_group_price` WHERE (entity_id='1302') AND (website_id IN(0, '1')) AFF: 0 TIME: 0.0004 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `sales_flat_quote`.* FROM `sales_flat_quote` WHERE (`sales_flat_quote`.`entity_id`='79') AND (store_id IN ('6', '4')) AND (is_active = 1) AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address` AS `main_table` WHERE (quote_id = '79') AFF: 2 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address_item` AS `main_table` WHERE (quote_address_id = '316') AFF: 0 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_item` AS `main_table` WHERE (quote_id = '79') AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_item_option` AS `main_table` WHERE (item_id IN(143)) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT DISTINCT ea.attribute_code FROM `salesrule_product_attribute` AS `a` INNER JOIN `eav_attribute` AS `ea` ON ea.attribute_id = a.attribute_id AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `e`.* FROM `catalog_product_entity` AS `e` WHERE (`e`.`entity_id` IN(1302, 1302)) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d` LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('56', '65', '83', '82', '72', '71', '519', '520', '464', '472')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d` LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('80', '85', '81', '502', '462', '468', '465', '469', '467', '466', '470')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d` LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('60', '61', '64', '521')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d` LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('62', '63')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d` LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('503')) AND (t_d.store_id = 0) AFF: 21 TIME: 0.0004 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN('1302')) AND (stock_id=1) AND (website_id=1) AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = '4' LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = '4' WHERE (default_option_title.store_id = 0) AND (product_id IN('1302')) AFF: 0 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `core_url_rewrite`.`product_id`, `core_url_rewrite`.`request_path` FROM `core_url_rewrite` WHERE (store_id = '4') AND (is_system = 1) AND (category_id = '' OR category_id IS NULL) AND (product_id IN('1302')) ORDER BY `category_id` DESC AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (entity_id IN('1302')) AND (website_id IN('0', '1')) ORDER BY `entity_id` ASC, `qty` ASC AFF: 0 TIME: 0.0004 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.*, `cp_table`.`type_id`, `status_table`.`stock_status` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id LEFT JOIN `cataloginventory_stock_status` AS `status_table` ON main_table.product_id=status_table.product_id AND main_table.stock_id=status_table.stock_id AND status_table.website_id='1' WHERE (main_table.stock_id = '1') AND (main_table.product_id IN('1302')) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `e`.* FROM `customer_address_entity` AS `e` WHERE (`e`.`entity_type_id` = '2') AND (`e`.`parent_id` = '-1') AFF: 0 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_payment` AS `main_table` WHERE (quote_id = '79') AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address_item` AS `main_table` WHERE (quote_address_id = '317') AFF: 0 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price` FROM `catalog_product_entity_group_price` WHERE (entity_id='1302') AND (website_id IN(0, '1')) AFF: 0 TIME: 0.0004 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `sales_flat_quote`.* FROM `sales_flat_quote` WHERE (`sales_flat_quote`.`entity_id`='79') AND (store_id IN ('6', '4')) AND (is_active = 1) AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address` AS `main_table` WHERE (quote_id = '79') AFF: 2 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address_item` AS `main_table` WHERE (quote_address_id = '316') AFF: 0 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_item` AS `main_table` WHERE (quote_id = '79') AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_item_option` AS `main_table` WHERE (item_id IN(143)) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT DISTINCT ea.attribute_code FROM `salesrule_product_attribute` AS `a` INNER JOIN `eav_attribute` AS `ea` ON ea.attribute_id = a.attribute_id AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `e`.* FROM `catalog_product_entity` AS `e` WHERE (`e`.`entity_id` IN(1302, 1302)) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d` LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('56', '65', '83', '82', '72', '71', '519', '520', '464', '472')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d` LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('80', '85', '81', '502', '462', '468', '465', '469', '467', '466', '470')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d` LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('60', '61', '64', '521')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d` LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('62', '63')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d` LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('503')) AND (t_d.store_id = 0) AFF: 21 TIME: 0.0004 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN('1302')) AND (stock_id=1) AND (website_id=1) AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = '4' LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = '4' WHERE (default_option_title.store_id = 0) AND (product_id IN('1302')) AFF: 0 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `core_url_rewrite`.`product_id`, `core_url_rewrite`.`request_path` FROM `core_url_rewrite` WHERE (store_id = '4') AND (is_system = 1) AND (category_id = '' OR category_id IS NULL) AND (product_id IN('1302')) ORDER BY `category_id` DESC AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (entity_id IN('1302')) AND (website_id IN('0', '1')) ORDER BY `entity_id` ASC, `qty` ASC AFF: 0 TIME: 0.0005 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.*, `cp_table`.`type_id`, `status_table`.`stock_status` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id LEFT JOIN `cataloginventory_stock_status` AS `status_table` ON main_table.product_id=status_table.product_id AND main_table.stock_id=status_table.stock_id AND status_table.website_id='1' WHERE (main_table.stock_id = '1') AND (main_table.product_id IN('1302')) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `e`.* FROM `customer_address_entity` AS `e` WHERE (`e`.`entity_type_id` = '2') AND (`e`.`parent_id` = '-1') AFF: 0 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_payment` AS `main_table` WHERE (quote_id = '79') AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address_item` AS `main_table` WHERE (quote_address_id = '317') AFF: 0 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price` FROM `catalog_product_entity_group_price` WHERE (entity_id='1302') AND (website_id IN(0, '1')) AFF: 0 TIME: 0.0004 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `sales_flat_quote`.* FROM `sales_flat_quote` WHERE (`sales_flat_quote`.`entity_id`='79') AND (store_id IN ('6', '4')) AND (is_active = 1) AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address` AS `main_table` WHERE (quote_id = '79') AFF: 2 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address_item` AS `main_table` WHERE (quote_address_id = '316') AFF: 0 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_item` AS `main_table` WHERE (quote_id = '79') AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_item_option` AS `main_table` WHERE (item_id IN(143)) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT DISTINCT ea.attribute_code FROM `salesrule_product_attribute` AS `a` INNER JOIN `eav_attribute` AS `ea` ON ea.attribute_id = a.attribute_id AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `e`.* FROM `catalog_product_entity` AS `e` WHERE (`e`.`entity_id` IN(1302, 1302)) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d` LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('56', '65', '83', '82', '72', '71', '519', '520', '464', '472')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d` LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('80', '85', '81', '502', '462', '468', '465', '469', '467', '466', '470')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d` LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('60', '61', '64', '521')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d` LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('62', '63')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d` LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('503')) AND (t_d.store_id = 0) AFF: 21 TIME: 0.0004 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN('1302')) AND (stock_id=1) AND (website_id=1) AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = '4' LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = '4' WHERE (default_option_title.store_id = 0) AND (product_id IN('1302')) AFF: 0 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `core_url_rewrite`.`product_id`, `core_url_rewrite`.`request_path` FROM `core_url_rewrite` WHERE (store_id = '4') AND (is_system = 1) AND (category_id = '' OR category_id IS NULL) AND (product_id IN('1302')) ORDER BY `category_id` DESC AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (entity_id IN('1302')) AND (website_id IN('0', '1')) ORDER BY `entity_id` ASC, `qty` ASC AFF: 0 TIME: 0.0004 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.*, `cp_table`.`type_id`, `status_table`.`stock_status` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id LEFT JOIN `cataloginventory_stock_status` AS `status_table` ON main_table.product_id=status_table.product_id AND main_table.stock_id=status_table.stock_id AND status_table.website_id='1' WHERE (main_table.stock_id = '1') AND (main_table.product_id IN('1302')) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `e`.* FROM `customer_address_entity` AS `e` WHERE (`e`.`entity_type_id` = '2') AND (`e`.`parent_id` = '-1') AFF: 0 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_payment` AS `main_table` WHERE (quote_id = '79') AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address_item` AS `main_table` WHERE (quote_address_id = '317') AFF: 0 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price` FROM `catalog_product_entity_group_price` WHERE (entity_id='1302') AND (website_id IN(0, '1')) AFF: 0 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `sales_flat_quote`.* FROM `sales_flat_quote` WHERE (`sales_flat_quote`.`entity_id`='79') AND (store_id IN ('6', '4')) AND (is_active = 1) AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address` AS `main_table` WHERE (quote_id = '79') AFF: 2 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address_item` AS `main_table` WHERE (quote_address_id = '316') AFF: 0 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_item` AS `main_table` WHERE (quote_id = '79') AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_item_option` AS `main_table` WHERE (item_id IN(143)) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT DISTINCT ea.attribute_code FROM `salesrule_product_attribute` AS `a` INNER JOIN `eav_attribute` AS `ea` ON ea.attribute_id = a.attribute_id AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `e`.* FROM `catalog_product_entity` AS `e` WHERE (`e`.`entity_id` IN(1302, 1302)) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d` LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('56', '65', '83', '82', '72', '71', '519', '520', '464', '472')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d` LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('80', '85', '81', '502', '462', '468', '465', '469', '467', '466', '470')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d` LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('60', '61', '64', '521')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d` LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('62', '63')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d` LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('503')) AND (t_d.store_id = 0) AFF: 21 TIME: 0.0004 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN('1302')) AND (stock_id=1) AND (website_id=1) AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = '4' LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = '4' WHERE (default_option_title.store_id = 0) AND (product_id IN('1302')) AFF: 0 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `core_url_rewrite`.`product_id`, `core_url_rewrite`.`request_path` FROM `core_url_rewrite` WHERE (store_id = '4') AND (is_system = 1) AND (category_id = '' OR category_id IS NULL) AND (product_id IN('1302')) ORDER BY `category_id` DESC AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (entity_id IN('1302')) AND (website_id IN('0', '1')) ORDER BY `entity_id` ASC, `qty` ASC AFF: 0 TIME: 0.0004 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.*, `cp_table`.`type_id`, `status_table`.`stock_status` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id LEFT JOIN `cataloginventory_stock_status` AS `status_table` ON main_table.product_id=status_table.product_id AND main_table.stock_id=status_table.stock_id AND status_table.website_id='1' WHERE (main_table.stock_id = '1') AND (main_table.product_id IN('1302')) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `e`.* FROM `customer_address_entity` AS `e` WHERE (`e`.`entity_type_id` = '2') AND (`e`.`parent_id` = '-1') AFF: 0 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_payment` AS `main_table` WHERE (quote_id = '79') AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address_item` AS `main_table` WHERE (quote_address_id = '317') AFF: 0 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price` FROM `catalog_product_entity_group_price` WHERE (entity_id='1302') AND (website_id IN(0, '1')) AFF: 0 TIME: 0.0004 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `sales_flat_quote`.* FROM `sales_flat_quote` WHERE (`sales_flat_quote`.`entity_id`='79') AND (store_id IN ('6', '4')) AND (is_active = 1) AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address` AS `main_table` WHERE (quote_id = '79') AFF: 2 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address_item` AS `main_table` WHERE (quote_address_id = '316') AFF: 0 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_item` AS `main_table` WHERE (quote_id = '79') AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_item_option` AS `main_table` WHERE (item_id IN(143)) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT DISTINCT ea.attribute_code FROM `salesrule_product_attribute` AS `a` INNER JOIN `eav_attribute` AS `ea` ON ea.attribute_id = a.attribute_id AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `e`.* FROM `catalog_product_entity` AS `e` WHERE (`e`.`entity_id` IN(1302, 1302)) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d` LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('56', '65', '83', '82', '72', '71', '519', '520', '464', '472')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d` LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('80', '85', '81', '502', '462', '468', '465', '469', '467', '466', '470')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d` LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('60', '61', '64', '521')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d` LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('62', '63')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d` LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('503')) AND (t_d.store_id = 0) AFF: 21 TIME: 0.0004 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN('1302')) AND (stock_id=1) AND (website_id=1) AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = '4' LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = '4' WHERE (default_option_title.store_id = 0) AND (product_id IN('1302')) AFF: 0 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `core_url_rewrite`.`product_id`, `core_url_rewrite`.`request_path` FROM `core_url_rewrite` WHERE (store_id = '4') AND (is_system = 1) AND (category_id = '' OR category_id IS NULL) AND (product_id IN('1302')) ORDER BY `category_id` DESC AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (entity_id IN('1302')) AND (website_id IN('0', '1')) ORDER BY `entity_id` ASC, `qty` ASC AFF: 0 TIME: 0.0005 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.*, `cp_table`.`type_id`, `status_table`.`stock_status` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id LEFT JOIN `cataloginventory_stock_status` AS `status_table` ON main_table.product_id=status_table.product_id AND main_table.stock_id=status_table.stock_id AND status_table.website_id='1' WHERE (main_table.stock_id = '1') AND (main_table.product_id IN('1302')) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `e`.* FROM `customer_address_entity` AS `e` WHERE (`e`.`entity_type_id` = '2') AND (`e`.`parent_id` = '-1') AFF: 0 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_payment` AS `main_table` WHERE (quote_id = '79') AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address_item` AS `main_table` WHERE (quote_address_id = '317') AFF: 0 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price` FROM `catalog_product_entity_group_price` WHERE (entity_id='1302') AND (website_id IN(0, '1')) AFF: 0 TIME: 0.0004 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `sales_flat_quote`.* FROM `sales_flat_quote` WHERE (`sales_flat_quote`.`entity_id`='79') AND (store_id IN ('6', '4')) AND (is_active = 1) AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address` AS `main_table` WHERE (quote_id = '79') AFF: 2 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address_item` AS `main_table` WHERE (quote_address_id = '316') AFF: 0 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_item` AS `main_table` WHERE (quote_id = '79') AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_item_option` AS `main_table` WHERE (item_id IN(143)) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT DISTINCT ea.attribute_code FROM `salesrule_product_attribute` AS `a` INNER JOIN `eav_attribute` AS `ea` ON ea.attribute_id = a.attribute_id AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `e`.* FROM `catalog_product_entity` AS `e` WHERE (`e`.`entity_id` IN(1302, 1302)) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d` LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('56', '65', '83', '82', '72', '71', '519', '520', '464', '472')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d` LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('80', '85', '81', '502', '462', '468', '465', '469', '467', '466', '470')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d` LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('60', '61', '64', '521')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d` LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('62', '63')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d` LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('503')) AND (t_d.store_id = 0) AFF: 21 TIME: 0.0004 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN('1302')) AND (stock_id=1) AND (website_id=1) AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = '4' LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = '4' WHERE (default_option_title.store_id = 0) AND (product_id IN('1302')) AFF: 0 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `core_url_rewrite`.`product_id`, `core_url_rewrite`.`request_path` FROM `core_url_rewrite` WHERE (store_id = '4') AND (is_system = 1) AND (category_id = '' OR category_id IS NULL) AND (product_id IN('1302')) ORDER BY `category_id` DESC AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (entity_id IN('1302')) AND (website_id IN('0', '1')) ORDER BY `entity_id` ASC, `qty` ASC AFF: 0 TIME: 0.0005 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.*, `cp_table`.`type_id`, `status_table`.`stock_status` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id LEFT JOIN `cataloginventory_stock_status` AS `status_table` ON main_table.product_id=status_table.product_id AND main_table.stock_id=status_table.stock_id AND status_table.website_id='1' WHERE (main_table.stock_id = '1') AND (main_table.product_id IN('1302')) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `e`.* FROM `customer_address_entity` AS `e` WHERE (`e`.`entity_type_id` = '2') AND (`e`.`parent_id` = '-1') AFF: 0 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_payment` AS `main_table` WHERE (quote_id = '79') AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address_item` AS `main_table` WHERE (quote_address_id = '317') AFF: 0 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price` FROM `catalog_product_entity_group_price` WHERE (entity_id='1302') AND (website_id IN(0, '1')) AFF: 0 TIME: 0.0004 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `sales_flat_quote`.* FROM `sales_flat_quote` WHERE (`sales_flat_quote`.`entity_id`='79') AND (store_id IN ('6', '4')) AND (is_active = 1) AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address` AS `main_table` WHERE (quote_id = '79') AFF: 2 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address_item` AS `main_table` WHERE (quote_address_id = '316') AFF: 0 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_item` AS `main_table` WHERE (quote_id = '79') AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_item_option` AS `main_table` WHERE (item_id IN(143)) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT DISTINCT ea.attribute_code FROM `salesrule_product_attribute` AS `a` INNER JOIN `eav_attribute` AS `ea` ON ea.attribute_id = a.attribute_id AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `e`.* FROM `catalog_product_entity` AS `e` WHERE (`e`.`entity_id` IN(1302, 1302)) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d` LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('56', '65', '83', '82', '72', '71', '519', '520', '464', '472')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d` LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('80', '85', '81', '502', '462', '468', '465', '469', '467', '466', '470')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d` LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('60', '61', '64', '521')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d` LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('62', '63')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d` LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('503')) AND (t_d.store_id = 0) AFF: 21 TIME: 0.0004 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN('1302')) AND (stock_id=1) AND (website_id=1) AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `main_table`.*, `default_option_title`.`title` AS `default_title`, `store_option_title`.`title` AS `store_title`, IF(store_option_title.title IS NULL, default_option_title.title, store_option_title.title) AS `title`, `default_option_price`.`price` AS `default_price`, `default_option_price`.`price_type` AS `default_price_type`, `store_option_price`.`price` AS `store_price`, `store_option_price`.`price_type` AS `store_price_type`, IF(store_option_price.price IS NULL, default_option_price.price, store_option_price.price) AS `price`, IF(store_option_price.price_type IS NULL, default_option_price.price_type, store_option_price.price_type) AS `price_type` FROM `catalog_product_option` AS `main_table` INNER JOIN `catalog_product_option_title` AS `default_option_title` ON default_option_title.option_id = main_table.option_id LEFT JOIN `catalog_product_option_title` AS `store_option_title` ON store_option_title.option_id = main_table.option_id AND store_option_title.store_id = '4' LEFT JOIN `catalog_product_option_price` AS `default_option_price` ON default_option_price.option_id = main_table.option_id AND default_option_price.store_id = 0 LEFT JOIN `catalog_product_option_price` AS `store_option_price` ON store_option_price.option_id = main_table.option_id AND store_option_price.store_id = '4' WHERE (default_option_title.store_id = 0) AND (product_id IN('1302')) AFF: 0 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `core_url_rewrite`.`product_id`, `core_url_rewrite`.`request_path` FROM `core_url_rewrite` WHERE (store_id = '4') AND (is_system = 1) AND (category_id = '' OR category_id IS NULL) AND (product_id IN('1302')) ORDER BY `category_id` DESC AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:57 ## 27032 ## QUERY SQL: SELECT `catalog_product_entity_tier_price`.`value_id` AS `price_id`, `catalog_product_entity_tier_price`.`website_id`, `catalog_product_entity_tier_price`.`all_groups`, `catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_tier_price`.`qty` AS `price_qty`, `catalog_product_entity_tier_price`.`value` AS `price`, `catalog_product_entity_tier_price`.`entity_id` AS `product_id` FROM `catalog_product_entity_tier_price` WHERE (entity_id IN('1302')) AND (website_id IN('0', '1')) ORDER BY `entity_id` ASC, `qty` ASC AFF: 0 TIME: 0.0005 ## 2013-02-15 17:31:58 ## 27032 ## QUERY SQL: SELECT `main_table`.*, `cp_table`.`type_id`, `status_table`.`stock_status` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id LEFT JOIN `cataloginventory_stock_status` AS `status_table` ON main_table.product_id=status_table.product_id AND main_table.stock_id=status_table.stock_id AND status_table.website_id='1' WHERE (main_table.stock_id = '1') AND (main_table.product_id IN('1302')) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:58 ## 27032 ## QUERY SQL: SELECT `e`.* FROM `customer_address_entity` AS `e` WHERE (`e`.`entity_type_id` = '2') AND (`e`.`parent_id` = '-1') AFF: 0 TIME: 0.0002 ## 2013-02-15 17:31:58 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_payment` AS `main_table` WHERE (quote_id = '79') AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:58 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address_item` AS `main_table` WHERE (quote_address_id = '317') AFF: 0 TIME: 0.0002 ## 2013-02-15 17:31:58 ## 27032 ## QUERY SQL: SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price` FROM `catalog_product_entity_group_price` WHERE (entity_id='1302') AND (website_id IN(0, '1')) AFF: 0 TIME: 0.0004 ## 2013-02-15 17:31:58 ## 27032 ## QUERY SQL: SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2013-02-15') AND (website_id = '1') AND (customer_group_id = '0') AND (product_id IN('1302')) AFF: 0 TIME: 0.0003 ## 2013-02-15 17:31:58 ## 27032 ## QUERY SQL: SELECT `sales_flat_quote`.* FROM `sales_flat_quote` WHERE (`sales_flat_quote`.`entity_id`='79') AND (store_id IN ('6', '4')) AND (is_active = 1) AFF: 1 TIME: 0.0004 ## 2013-02-15 17:31:58 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address` AS `main_table` WHERE (quote_id = '79') AFF: 2 TIME: 0.0002 ## 2013-02-15 17:31:58 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_address_item` AS `main_table` WHERE (quote_address_id = '316') AFF: 0 TIME: 0.0002 ## 2013-02-15 17:31:58 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_item` AS `main_table` WHERE (quote_id = '79') AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:58 ## 27032 ## QUERY SQL: SELECT `main_table`.* FROM `sales_flat_quote_item_option` AS `main_table` WHERE (item_id IN(143)) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:58 ## 27032 ## QUERY SQL: SELECT DISTINCT ea.attribute_code FROM `salesrule_product_attribute` AS `a` INNER JOIN `eav_attribute` AS `ea` ON ea.attribute_id = a.attribute_id AFF: 1 TIME: 0.0003 ## 2013-02-15 17:31:58 ## 27032 ## QUERY SQL: SELECT `e`.* FROM `catalog_product_entity` AS `e` WHERE (`e`.`entity_id` IN(1302, 1302)) AFF: 1 TIME: 0.0002 ## 2013-02-15 17:31:58 ## 27032 ## QUERY SQL: SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d` LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('56', '65', '83', '82', '72', '71', '519', '520', '464', '472')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d` LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('80', '85', '81', '502', '462', '468', '465', '469', '467', '466', '470')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d` LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('60', '61', '64', '521')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d` LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('62', '63')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d` LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (1302)) AND (t_d.attribute_id IN ('503')) AND (t_d.store_id = 0) AFF: 21 TIME: 0.0004 ## 2013-02-15 17:31:58 ## 27032 ## QUERY SQL: SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN('1302')) AND (stock_id=1) AND (website_id=1) AFF: 1 TIME: 0.0003