Skip to content

Instantly share code, notes, and snippets.

@astorm

astorm/gist:1003007

Created June 1, 2011 18:53
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save astorm/1003007 to your computer and use it in GitHub Desktop.
Save astorm/1003007 to your computer and use it in GitHub Desktop.
Download ZIP
Queries Run during the Loading and Saving of a Magento Product Model
Raw
gistfile1.sql
--------------------------------------------------
SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (eav_entity_type.entity_type_code='catalog_product')
--------------------------------------------------
--------------------------------------------------
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id=167)
--------------------------------------------------
--------------------------------------------------
SELECT `main_table`.*, `additional_table`.*, `entity_attribute`.*, IFNULL(al.value, main_table.frontend_label) AS `store_label` FROM `eav_attribute` AS `main_table`
INNER JOIN `catalog_eav_attribute` AS `additional_table` ON additional_table.attribute_id=main_table.attribute_id
INNER JOIN `eav_entity_attribute` AS `entity_attribute` ON entity_attribute.attribute_id=main_table.attribute_id
LEFT JOIN `eav_attribute_label` AS `al` ON al.attribute_id = main_table.attribute_id AND al.store_id = 0 WHERE (main_table.entity_type_id=10) AND (entity_attribute.attribute_set_id='40') ORDER BY sort_order ASC
--------------------------------------------------
--------------------------------------------------
SELECT `attr_table`.* FROM `catalog_product_entity_varchar` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id=set_table.attribute_id AND set_table.attribute_set_id=40 WHERE (attr_table.entity_id='167') AND (attr_table.store_id IN (0)) UNION SELECT `attr_table`.* FROM `catalog_product_entity_int` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id=set_table.attribute_id AND set_table.attribute_set_id=40 WHERE (attr_table.entity_id='167') AND (attr_table.store_id IN (0)) UNION SELECT `attr_table`.* FROM `catalog_product_entity_datetime` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id=set_table.attribute_id AND set_table.attribute_set_id=40 WHERE (attr_table.entity_id='167') AND (attr_table.store_id IN (0)) UNION SELECT `attr_table`.* FROM `catalog_product_entity_text` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id=set_table.attribute_id AND set_table.attribute_set_id=40 WHERE (attr_table.entity_id='167') AND (attr_table.store_id IN (0)) UNION SELECT `attr_table`.* FROM `catalog_product_entity_decimal` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id=set_table.attribute_id AND set_table.attribute_set_id=40 WHERE (attr_table.entity_id='167') AND (attr_table.store_id IN (0)) ORDER BY `store_id` ASC
--------------------------------------------------
--------------------------------------------------
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` FROM `catalog_product_entity_tier_price` WHERE (entity_id='167') AND (website_id=0) ORDER BY `qty` ASC
--------------------------------------------------
--------------------------------------------------
SELECT `main`.`value_id`, `main`.`value` AS `file`, `value`.`label`, `value`.`position`, `value`.`disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default` FROM `catalog_product_entity_media_gallery` AS `main`
LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id=value.value_id AND value.store_id=0
LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id=default_value.value_id AND default_value.store_id=0 WHERE (main.attribute_id = '703') AND (main.entity_id = '167') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
--------------------------------------------------
--------------------------------------------------
SELECT `cataloginventory_stock_item`.*, `p`.`type_id` FROM `cataloginventory_stock_item`
INNER JOIN `catalog_product_entity` AS `p` ON product_id=p.entity_id WHERE (cataloginventory_stock_item.product_id='167') AND (stock_id=1)
--------------------------------------------------
--------------------------------------------------
SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN('167')) AND (stock_id=1) AND (website_id='0')
--------------------------------------------------
--------------------------------------------------
begin
--------------------------------------------------
--------------------------------------------------
SELECT `entity`.`attribute_id`, `entity`.`attribute_set_id`, `entity`.`attribute_group_id`, `entity`.`sort_order`, `group`.`sort_order` AS `group_sort_order` FROM `eav_entity_attribute` AS `entity`
LEFT JOIN `eav_attribute_group` AS `group` ON entity.attribute_group_id=group.attribute_group_id WHERE (entity.attribute_id IN ('930', '931', '571', '933', '572', '934', '573', '503', '110', '96', '99', '103', '493', '506', '502', '495', '100', '104', '109', '97', '107', '98', '270', '105', '106', '492', '272', '101', '271', '501', '567', '102', '568', '703', '569', '273', '862', '274', '481', '526', '531', '836', '562', '929', '570', '704', '705', '837', '838', '859', '860', '861', '863', '879', '880', '881', '903', '904', '905', '906', '947', '948')) AND (entity.attribute_set_id='40')
--------------------------------------------------
--------------------------------------------------
SELECT `catalog_product_entity`.`entity_id` FROM `catalog_product_entity` WHERE (entity_id='167')
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_entity` SET `entity_id` = ?, `entity_type_id` = ?, `attribute_set_id` = ?, `type_id` = ?, `sku` = ?, `created_at` = ?, `updated_at` = ?, `has_options` = ?, `required_options` = ? WHERE (entity_id='167')
Params: [167],[10],[40],[simple],[ana-12],[2011-02-24 22:48:11],[2011-06-01 18:52:32],[0],[0]
--------------------------------------------------
--------------------------------------------------
SELECT `catalog_product_website`.`website_id` FROM `catalog_product_website` WHERE (product_id='167')
--------------------------------------------------
--------------------------------------------------
SELECT `catalog_product_website`.* FROM `catalog_product_website` WHERE (product_id='167')
--------------------------------------------------
--------------------------------------------------
DELETE FROM `catalog_product_entity_tier_price` WHERE (entity_id='167')
--------------------------------------------------
--------------------------------------------------
SELECT `catalog_category_product`.`category_id` FROM `catalog_category_product` WHERE (product_id='167')
--------------------------------------------------
--------------------------------------------------
commit
--------------------------------------------------
--------------------------------------------------
SELECT `main_table`.* FROM `index_process` AS `main_table`
--------------------------------------------------
--------------------------------------------------
SELECT `core_flag`.* FROM `core_flag` WHERE (core_flag.flag_code='catalog_product_flat')
--------------------------------------------------
--------------------------------------------------
SHOW TABLE STATUS LIKE 'catalog_product_flat_3'
--------------------------------------------------
--------------------------------------------------
DELETE FROM `catalog_product_flat_3` WHERE (entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
SELECT `main_table`.*, `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='10') AND (main_table.backend_type='static' OR additional_table.used_in_product_listing=1 OR additional_table.used_for_sort_by=1 OR main_table.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', 'enable_googlecheckout', 'gift_message_available', 'price_view', 'price_type', 'shipment_type', 'weight_type', 'sku_type', 'links_purchased_separately', 'links_title', 'short_description', 'image_label', 'thumbnail_label', 'small_image_label', 'news_from_date', 'news_to_date', 'created_at', 'updated_at', 'required_options'))
--------------------------------------------------
--------------------------------------------------
INSERT INTO `catalog_product_flat_3` (`entity_id`,`type_id`,`attribute_set_id`,`created_at`,`has_options`,`required_options`,`sku`,`updated_at`) SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `e`.`created_at`, `e`.`has_options`, `e`.`required_options`, `e`.`sku`, `e`.`updated_at` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_website` AS `wp` ON `e`.`entity_id`=`wp`.`product_id` AND `wp`.`website_id`=1
LEFT JOIN `catalog_product_entity_int` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_int` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 3 WHERE (t1.entity_type_id='10') AND (t1.attribute_id='273') AND (t1.store_id=0) AND (IF(`t2`.`value_id`>0, `t2`.`value`, `t1`.`value`)=1) AND (e.entity_id IN('167')) ON DUPLICATE KEY UPDATE `entity_id`=VALUES(`entity_id`), `type_id`=VALUES(`type_id`), `attribute_set_id`=VALUES(`attribute_set_id`), `created_at`=VALUES(`created_at`), `has_options`=VALUES(`has_options`), `required_options`=VALUES(`required_options`), `sku`=VALUES(`sku`), `updated_at`=VALUES(`updated_at`)
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_3` AS `e` LEFT JOIN `catalog_product_entity_decimal` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_decimal` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 3
SET `e`.`cost` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='100') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_3` AS `e` LEFT JOIN `catalog_product_entity_int` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_int` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 3
SET `e`.`enable_googlecheckout` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='903') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_3` AS `e` LEFT JOIN `catalog_product_entity_varchar` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_varchar` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 3
SET `e`.`gift_message_available` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='562') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_3` AS `e` LEFT JOIN `catalog_product_entity_varchar` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_varchar` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 3
SET `e`.`image_label` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='879') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_3` AS `e` LEFT JOIN `catalog_product_entity_int` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_int` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 3
SET `e`.`is_imported` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='948') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_3` AS `e` LEFT JOIN `catalog_product_entity_int` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_int` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 3
SET `e`.`is_recurring` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='933') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_3` AS `e` LEFT JOIN `catalog_product_entity_int` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_int` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 3
SET `e`.`links_exist` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='947') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_3` AS `e` LEFT JOIN `catalog_product_entity_int` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_int` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 3
SET `e`.`links_purchased_separately` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='904') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_3` AS `e` LEFT JOIN `catalog_product_entity_varchar` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_varchar` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 3
SET `e`.`links_title` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='906') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_3` AS `e` LEFT JOIN `catalog_product_entity_varchar` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_varchar` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 3
SET `e`.`name` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='96') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_3` AS `e` LEFT JOIN `catalog_product_entity_datetime` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_datetime` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 3
SET `e`.`news_from_date` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='704') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_3` AS `e` LEFT JOIN `catalog_product_entity_datetime` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_datetime` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 3
SET `e`.`news_to_date` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='705') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_3` AS `e` LEFT JOIN `catalog_product_entity_decimal` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_decimal` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 3
SET `e`.`price` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='99') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_3` AS `e` LEFT JOIN `catalog_product_entity_int` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_int` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 3
SET `e`.`price_type` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='859') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_3` AS `e` LEFT JOIN `catalog_product_entity_int` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_int` AS `t2` ON `t2`.`entity_id`=`t1`.`entity_id` AND `t1`.`entity_type_id`=`t2`.`entity_type_id` AND `t1`.`attribute_id`=`t2`.`attribute_id` AND `t2`.`store_id`=3
SET `e`.`price_view` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='862') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_3` AS `e` LEFT JOIN `catalog_product_entity_text` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_text` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 3
SET `e`.`recurring_profile` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='934') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_3` AS `e` LEFT JOIN `catalog_product_entity_int` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_int` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 3
SET `e`.`shipment_type` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='863') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_3` AS `e` LEFT JOIN `catalog_product_entity_text` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_text` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 3
SET `e`.`short_description` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='506') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_3` AS `e` LEFT JOIN `catalog_product_entity_int` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_int` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 3
SET `e`.`sku_type` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='860') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_3` AS `e` LEFT JOIN `catalog_product_entity_varchar` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_varchar` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 3
SET `e`.`small_image` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='109') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_3` AS `e` LEFT JOIN `catalog_product_entity_varchar` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_varchar` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 3
SET `e`.`small_image_label` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='880') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_3` AS `e` LEFT JOIN `catalog_product_entity_datetime` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_datetime` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 3
SET `e`.`special_from_date` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='568') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_3` AS `e` LEFT JOIN `catalog_product_entity_decimal` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_decimal` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 3
SET `e`.`special_price` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='567') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_3` AS `e` LEFT JOIN `catalog_product_entity_datetime` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_datetime` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 3
SET `e`.`special_to_date` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='569') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_3` AS `e` LEFT JOIN `catalog_product_entity_int` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_int` AS `t2` ON `t2`.`entity_id`=`t1`.`entity_id` AND `t1`.`entity_type_id`=`t2`.`entity_type_id` AND `t1`.`attribute_id`=`t2`.`attribute_id` AND `t2`.`store_id`=3
SET `e`.`tax_class_id` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='274') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_3` AS `e` LEFT JOIN `catalog_product_entity_varchar` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_varchar` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 3
SET `e`.`thumbnail` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='493') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_3` AS `e` LEFT JOIN `catalog_product_entity_varchar` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_varchar` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 3
SET `e`.`thumbnail_label` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='881') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_3` AS `e` LEFT JOIN `catalog_product_entity_varchar` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_varchar` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 3
SET `e`.`url_key` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='481') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_3` AS `e` LEFT JOIN `catalog_product_entity_varchar` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_varchar` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 3
SET `e`.`url_path` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='570') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_3` AS `e` LEFT JOIN `catalog_product_entity_int` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_int` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 3
SET `e`.`visibility` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='526') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_3` AS `e` LEFT JOIN `catalog_product_entity_decimal` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_decimal` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 3
SET `e`.`weight` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='101') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_3` AS `e` LEFT JOIN `catalog_product_entity_int` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_int` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 3
SET `e`.`weight_type` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='861') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
SHOW TABLE STATUS LIKE 'catalog_product_flat_2'
--------------------------------------------------
--------------------------------------------------
DELETE FROM `catalog_product_flat_2` WHERE (entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
INSERT INTO `catalog_product_flat_2` (`entity_id`,`type_id`,`attribute_set_id`,`created_at`,`has_options`,`required_options`,`sku`,`updated_at`) SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `e`.`created_at`, `e`.`has_options`, `e`.`required_options`, `e`.`sku`, `e`.`updated_at` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_website` AS `wp` ON `e`.`entity_id`=`wp`.`product_id` AND `wp`.`website_id`=1
LEFT JOIN `catalog_product_entity_int` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_int` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 2 WHERE (t1.entity_type_id='10') AND (t1.attribute_id='273') AND (t1.store_id=0) AND (IF(`t2`.`value_id`>0, `t2`.`value`, `t1`.`value`)=1) AND (e.entity_id IN('167')) ON DUPLICATE KEY UPDATE `entity_id`=VALUES(`entity_id`), `type_id`=VALUES(`type_id`), `attribute_set_id`=VALUES(`attribute_set_id`), `created_at`=VALUES(`created_at`), `has_options`=VALUES(`has_options`), `required_options`=VALUES(`required_options`), `sku`=VALUES(`sku`), `updated_at`=VALUES(`updated_at`)
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_2` AS `e` LEFT JOIN `catalog_product_entity_decimal` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_decimal` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 2
SET `e`.`cost` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='100') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_2` AS `e` LEFT JOIN `catalog_product_entity_int` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_int` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 2
SET `e`.`enable_googlecheckout` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='903') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_2` AS `e` LEFT JOIN `catalog_product_entity_varchar` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_varchar` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 2
SET `e`.`gift_message_available` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='562') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_2` AS `e` LEFT JOIN `catalog_product_entity_varchar` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_varchar` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 2
SET `e`.`image_label` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='879') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_2` AS `e` LEFT JOIN `catalog_product_entity_int` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_int` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 2
SET `e`.`is_imported` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='948') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_2` AS `e` LEFT JOIN `catalog_product_entity_int` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_int` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 2
SET `e`.`is_recurring` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='933') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_2` AS `e` LEFT JOIN `catalog_product_entity_int` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_int` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 2
SET `e`.`links_exist` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='947') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_2` AS `e` LEFT JOIN `catalog_product_entity_int` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_int` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 2
SET `e`.`links_purchased_separately` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='904') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_2` AS `e` LEFT JOIN `catalog_product_entity_varchar` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_varchar` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 2
SET `e`.`links_title` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='906') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_2` AS `e` LEFT JOIN `catalog_product_entity_varchar` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_varchar` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 2
SET `e`.`name` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='96') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_2` AS `e` LEFT JOIN `catalog_product_entity_datetime` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_datetime` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 2
SET `e`.`news_from_date` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='704') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_2` AS `e` LEFT JOIN `catalog_product_entity_datetime` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_datetime` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 2
SET `e`.`news_to_date` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='705') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_2` AS `e` LEFT JOIN `catalog_product_entity_decimal` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_decimal` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 2
SET `e`.`price` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='99') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_2` AS `e` LEFT JOIN `catalog_product_entity_int` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_int` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 2
SET `e`.`price_type` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='859') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_2` AS `e` LEFT JOIN `catalog_product_entity_int` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_int` AS `t2` ON `t2`.`entity_id`=`t1`.`entity_id` AND `t1`.`entity_type_id`=`t2`.`entity_type_id` AND `t1`.`attribute_id`=`t2`.`attribute_id` AND `t2`.`store_id`=2
SET `e`.`price_view` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='862') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_2` AS `e` LEFT JOIN `catalog_product_entity_text` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_text` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 2
SET `e`.`recurring_profile` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='934') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_2` AS `e` LEFT JOIN `catalog_product_entity_int` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_int` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 2
SET `e`.`shipment_type` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='863') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_2` AS `e` LEFT JOIN `catalog_product_entity_text` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_text` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 2
SET `e`.`short_description` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='506') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_2` AS `e` LEFT JOIN `catalog_product_entity_int` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_int` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 2
SET `e`.`sku_type` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='860') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_2` AS `e` LEFT JOIN `catalog_product_entity_varchar` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_varchar` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 2
SET `e`.`small_image` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='109') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_2` AS `e` LEFT JOIN `catalog_product_entity_varchar` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_varchar` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 2
SET `e`.`small_image_label` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='880') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_2` AS `e` LEFT JOIN `catalog_product_entity_datetime` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_datetime` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 2
SET `e`.`special_from_date` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='568') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_2` AS `e` LEFT JOIN `catalog_product_entity_decimal` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_decimal` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 2
SET `e`.`special_price` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='567') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_2` AS `e` LEFT JOIN `catalog_product_entity_datetime` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_datetime` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 2
SET `e`.`special_to_date` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='569') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_2` AS `e` LEFT JOIN `catalog_product_entity_int` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_int` AS `t2` ON `t2`.`entity_id`=`t1`.`entity_id` AND `t1`.`entity_type_id`=`t2`.`entity_type_id` AND `t1`.`attribute_id`=`t2`.`attribute_id` AND `t2`.`store_id`=2
SET `e`.`tax_class_id` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='274') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_2` AS `e` LEFT JOIN `catalog_product_entity_varchar` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_varchar` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 2
SET `e`.`thumbnail` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='493') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_2` AS `e` LEFT JOIN `catalog_product_entity_varchar` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_varchar` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 2
SET `e`.`thumbnail_label` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='881') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_2` AS `e` LEFT JOIN `catalog_product_entity_varchar` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_varchar` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 2
SET `e`.`url_key` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='481') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_2` AS `e` LEFT JOIN `catalog_product_entity_varchar` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_varchar` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 2
SET `e`.`url_path` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='570') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_2` AS `e` LEFT JOIN `catalog_product_entity_int` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_int` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 2
SET `e`.`visibility` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='526') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_2` AS `e` LEFT JOIN `catalog_product_entity_decimal` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_decimal` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 2
SET `e`.`weight` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='101') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
UPDATE `catalog_product_flat_2` AS `e` LEFT JOIN `catalog_product_entity_int` AS `t1` ON `e`.`entity_id`=`t1`.`entity_id`
LEFT JOIN `catalog_product_entity_int` AS `t2` ON t2.entity_id = t1.entity_id AND t1.entity_type_id = t2.entity_type_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = 2
SET `e`.`weight_type` = IF(t2.value_id>0, t2.value, t1.value)
WHERE (t1.entity_type_id='10') AND (t1.attribute_id='861') AND (t1.store_id=0) AND (e.entity_id IN('167'))
--------------------------------------------------
--------------------------------------------------
SELECT `catalog_product_entity`.* FROM `catalog_product_entity` WHERE (entity_id='167')
--------------------------------------------------
--------------------------------------------------
SELECT `attr_table`.* FROM `catalog_product_entity_varchar` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id=set_table.attribute_id AND set_table.attribute_set_id=40 WHERE (attr_table.entity_id='167') AND (attr_table.store_id IN (0)) UNION SELECT `attr_table`.* FROM `catalog_product_entity_int` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id=set_table.attribute_id AND set_table.attribute_set_id=40 WHERE (attr_table.entity_id='167') AND (attr_table.store_id IN (0)) UNION SELECT `attr_table`.* FROM `catalog_product_entity_datetime` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id=set_table.attribute_id AND set_table.attribute_set_id=40 WHERE (attr_table.entity_id='167') AND (attr_table.store_id IN (0)) UNION SELECT `attr_table`.* FROM `catalog_product_entity_text` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id=set_table.attribute_id AND set_table.attribute_set_id=40 WHERE (attr_table.entity_id='167') AND (attr_table.store_id IN (0)) UNION SELECT `attr_table`.* FROM `catalog_product_entity_decimal` AS `attr_table`
INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id=set_table.attribute_id AND set_table.attribute_set_id=40 WHERE (attr_table.entity_id='167') AND (attr_table.store_id IN (0)) ORDER BY `store_id` ASC
--------------------------------------------------
--------------------------------------------------
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` FROM `catalog_product_entity_tier_price` WHERE (entity_id='167') AND (website_id=0) ORDER BY `qty` ASC
--------------------------------------------------
--------------------------------------------------
SELECT `main`.`value_id`, `main`.`value` AS `file`, `value`.`label`, `value`.`position`, `value`.`disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default` FROM `catalog_product_entity_media_gallery` AS `main`
LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id=value.value_id AND value.store_id=0
LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id=default_value.value_id AND default_value.store_id=0 WHERE (main.attribute_id = '703') AND (main.entity_id = '167') ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC
--------------------------------------------------
--------------------------------------------------
SELECT `cataloginventory_stock_item`.*, `p`.`type_id` FROM `cataloginventory_stock_item`
INNER JOIN `catalog_product_entity` AS `p` ON product_id=p.entity_id WHERE (cataloginventory_stock_item.product_id='167') AND (stock_id=1)
--------------------------------------------------
--------------------------------------------------
SELECT `cataloginventory_stock_status`.`product_id`, `cataloginventory_stock_status`.`stock_status` FROM `cataloginventory_stock_status` WHERE (product_id IN('167')) AND (stock_id=1) AND (website_id='0')
--------------------------------------------------
--------------------------------------------------
SELECT `catalog_product_relation`.`parent_id` FROM `catalog_product_relation` WHERE (child_id IN('167'))
--------------------------------------------------
--------------------------------------------------
DELETE FROM `catalogsearch_fulltext` WHERE (store_id='3' AND product_id IN('167'))
--------------------------------------------------
--------------------------------------------------
SELECT `main_table`.*, `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=10) AND (additional_table.is_searchable = 1 OR main_table.attribute_code IN ('status', 'visibility'))
--------------------------------------------------
--------------------------------------------------
SELECT STRAIGHT_JOIN `e`.`entity_id`, `e`.`type_id`, `e`.`sku`, `stock_status`.`stock_status` AS `in_stock` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_website` AS `website` ON website.product_id=e.entity_id AND website.website_id='1'
INNER JOIN `cataloginventory_stock_status` AS `stock_status` ON stock_status.product_id=e.entity_id AND stock_status.website_id='1' WHERE (e.entity_id IN('167')) AND (e.entity_id>0) ORDER BY `e`.`entity_id` ASC LIMIT 100
--------------------------------------------------
--------------------------------------------------
(SELECT `t_default`.`entity_id`, `t_default`.`attribute_id`, IF(t_store.value_id > 0, t_store.value, t_default.value) AS `value` FROM `catalog_product_entity_int` AS `t_default`
LEFT JOIN `catalog_product_entity_int` AS `t_store` ON t_default.entity_id=t_store.entity_id AND t_default.attribute_id=t_store.attribute_id AND t_store.store_id='3' WHERE (t_default.store_id=0) AND (t_default.attribute_id IN(272, 510, 501, 102, 513, 508, 525, 502, 107, 273, 526)) AND (t_default.entity_id IN('167')))UNION(SELECT `t_default`.`entity_id`, `t_default`.`attribute_id`, IF(t_store.value_id > 0, t_store.value, t_default.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_default`
LEFT JOIN `catalog_product_entity_varchar` AS `t_store` ON t_default.entity_id=t_store.entity_id AND t_default.attribute_id=t_store.attribute_id AND t_store.store_id='3' WHERE (t_default.store_id=0) AND (t_default.attribute_id IN(96)) AND (t_default.entity_id IN('167')))UNION(SELECT `t_default`.`entity_id`, `t_default`.`attribute_id`, IF(t_store.value_id > 0, t_store.value, t_default.value) AS `value` FROM `catalog_product_entity_text` AS `t_default`
LEFT JOIN `catalog_product_entity_text` AS `t_store` ON t_default.entity_id=t_store.entity_id AND t_default.attribute_id=t_store.attribute_id AND t_store.store_id='3' WHERE (t_default.store_id=0) AND (t_default.attribute_id IN(507, 97, 494, 509, 499, 492, 498, 104, 495, 497, 500, 476, 506)) AND (t_default.entity_id IN('167')))UNION(SELECT `t_default`.`entity_id`, `t_default`.`attribute_id`, IF(t_store.value_id > 0, t_store.value, t_default.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_default`
LEFT JOIN `catalog_product_entity_decimal` AS `t_store` ON t_default.entity_id=t_store.entity_id AND t_default.attribute_id=t_store.attribute_id AND t_store.store_id='3' WHERE (t_default.store_id=0) AND (t_default.attribute_id IN(99)) AND (t_default.entity_id IN('167')))
--------------------------------------------------
--------------------------------------------------
SELECT STRAIGHT_JOIN `e`.`entity_id`, `e`.`type_id`, `e`.`sku`, `stock_status`.`stock_status` AS `in_stock` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_website` AS `website` ON website.product_id=e.entity_id AND website.website_id='1'
INNER JOIN `cataloginventory_stock_status` AS `stock_status` ON stock_status.product_id=e.entity_id AND stock_status.website_id='1' WHERE (e.entity_id IN('167')) AND (e.entity_id>'167') ORDER BY `e`.`entity_id` ASC LIMIT 100
--------------------------------------------------
--------------------------------------------------
begin
--------------------------------------------------
--------------------------------------------------
UPDATE `catalogsearch_query` SET `is_processed` = ?
Params: [0]
--------------------------------------------------
--------------------------------------------------
TRUNCATE TABLE catalogsearch_result
--------------------------------------------------
--------------------------------------------------
commit
--------------------------------------------------
--------------------------------------------------
DELETE FROM `catalogsearch_fulltext` WHERE (store_id='2' AND product_id IN('167'))
--------------------------------------------------
--------------------------------------------------
SELECT STRAIGHT_JOIN `e`.`entity_id`, `e`.`type_id`, `e`.`sku`, `stock_status`.`stock_status` AS `in_stock` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_website` AS `website` ON website.product_id=e.entity_id AND website.website_id='1'
INNER JOIN `cataloginventory_stock_status` AS `stock_status` ON stock_status.product_id=e.entity_id AND stock_status.website_id='1' WHERE (e.entity_id IN('167')) AND (e.entity_id>0) ORDER BY `e`.`entity_id` ASC LIMIT 100
--------------------------------------------------
--------------------------------------------------
(SELECT `t_default`.`entity_id`, `t_default`.`attribute_id`, IF(t_store.value_id > 0, t_store.value, t_default.value) AS `value` FROM `catalog_product_entity_int` AS `t_default`
LEFT JOIN `catalog_product_entity_int` AS `t_store` ON t_default.entity_id=t_store.entity_id AND t_default.attribute_id=t_store.attribute_id AND t_store.store_id='2' WHERE (t_default.store_id=0) AND (t_default.attribute_id IN(272, 510, 501, 102, 513, 508, 525, 502, 107, 273, 526)) AND (t_default.entity_id IN('167')))UNION(SELECT `t_default`.`entity_id`, `t_default`.`attribute_id`, IF(t_store.value_id > 0, t_store.value, t_default.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_default`
LEFT JOIN `catalog_product_entity_varchar` AS `t_store` ON t_default.entity_id=t_store.entity_id AND t_default.attribute_id=t_store.attribute_id AND t_store.store_id='2' WHERE (t_default.store_id=0) AND (t_default.attribute_id IN(96)) AND (t_default.entity_id IN('167')))UNION(SELECT `t_default`.`entity_id`, `t_default`.`attribute_id`, IF(t_store.value_id > 0, t_store.value, t_default.value) AS `value` FROM `catalog_product_entity_text` AS `t_default`
LEFT JOIN `catalog_product_entity_text` AS `t_store` ON t_default.entity_id=t_store.entity_id AND t_default.attribute_id=t_store.attribute_id AND t_store.store_id='2' WHERE (t_default.store_id=0) AND (t_default.attribute_id IN(507, 97, 494, 509, 499, 492, 498, 104, 495, 497, 500, 476, 506)) AND (t_default.entity_id IN('167')))UNION(SELECT `t_default`.`entity_id`, `t_default`.`attribute_id`, IF(t_store.value_id > 0, t_store.value, t_default.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_default`
LEFT JOIN `catalog_product_entity_decimal` AS `t_store` ON t_default.entity_id=t_store.entity_id AND t_default.attribute_id=t_store.attribute_id AND t_store.store_id='2' WHERE (t_default.store_id=0) AND (t_default.attribute_id IN(99)) AND (t_default.entity_id IN('167')))
--------------------------------------------------
--------------------------------------------------
SELECT STRAIGHT_JOIN `e`.`entity_id`, `e`.`type_id`, `e`.`sku`, `stock_status`.`stock_status` AS `in_stock` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_website` AS `website` ON website.product_id=e.entity_id AND website.website_id='1'
INNER JOIN `cataloginventory_stock_status` AS `stock_status` ON stock_status.product_id=e.entity_id AND stock_status.website_id='1' WHERE (e.entity_id IN('167')) AND (e.entity_id>'167') ORDER BY `e`.`entity_id` ASC LIMIT 100
--------------------------------------------------
--------------------------------------------------
begin
--------------------------------------------------
--------------------------------------------------
UPDATE `catalogsearch_query` SET `is_processed` = ?
Params: [0]
--------------------------------------------------
--------------------------------------------------
TRUNCATE TABLE catalogsearch_result
--------------------------------------------------
--------------------------------------------------
commit
--------------------------------------------------
--------------------------------------------------
begin
--------------------------------------------------
--------------------------------------------------
UPDATE `catalogsearch_query` SET `is_processed` = ?
Params: [0]
--------------------------------------------------
--------------------------------------------------
TRUNCATE TABLE catalogsearch_result
--------------------------------------------------
--------------------------------------------------
commit
--------------------------------------------------
--------------------------------------------------
SELECT `tag_relation`.`tag_id` FROM `tag_relation` WHERE (product_id IN('167')) ORDER BY `tag_id` ASC
--------------------------------------------------
--------------------------------------------------
begin
--------------------------------------------------
--------------------------------------------------
DELETE FROM `tag_summary` WHERE (tag_id IN(NULL))
--------------------------------------------------
--------------------------------------------------
INSERT INTO `tag_summary` (`tag_id`,`store_id`,`customers`,`products`,`popularity`,`uses`,`historical_uses`,`base_popularity`) SELECT `tr`.`tag_id`, `tr`.`store_id`, COUNT(DISTINCT tr.customer_id) AS `customers`, COUNT(DISTINCT tr.product_id) AS `products`, COUNT(tr.customer_id) + IFNULL(tp.base_popularity, 0) AS `popularity`, 0 AS `uses`, 0 AS `historical_uses`, 0 AS `base_popularity` FROM `tag_relation` AS `tr`
INNER JOIN `core_store` AS `cs` ON cs.store_id = tr.store_id
INNER JOIN `catalog_product_website` AS `pw` ON cs.website_id = pw.website_id AND tr.product_id = pw.product_id
INNER JOIN `catalog_product_entity` AS `e` ON tr.product_id = e.entity_id
LEFT JOIN `tag_properties` AS `tp` ON tp.tag_id = tr.tag_id AND tp.store_id = tr.store_id
INNER JOIN `catalog_product_entity_int` AS `tad_status` ON tad_status.entity_id = e.entity_id AND tad_status.attribute_id = 273 AND tad_status.store_id = 0
LEFT JOIN `catalog_product_entity_int` AS `tas_status` ON tas_status.entity_id = e.entity_id AND tas_status.attribute_id = 273 AND tas_status.store_id = cs.store_id
INNER JOIN `catalog_product_entity_int` AS `tad_visibility` ON tad_visibility.entity_id = e.entity_id AND tad_visibility.attribute_id = 526 AND tad_visibility.store_id = 0
LEFT JOIN `catalog_product_entity_int` AS `tas_visibility` ON tas_visibility.entity_id = e.entity_id AND tas_visibility.attribute_id = 526 AND tas_visibility.store_id = cs.store_id
INNER JOIN `cataloginventory_stock_status` AS `ciss` ON ciss.product_id = e.entity_id AND ciss.website_id = cs.website_id WHERE (IF(tas_status.value_id > 0, tas_status.value, tad_status.value)=1) AND (IF(tas_visibility.value_id > 0, tas_visibility.value, tad_visibility.value)!=1) AND (tr.tag_id IN(NULL)) AND (ciss.stock_status=1) GROUP BY `tr`.`tag_id`,
`tr`.`store_id` ON DUPLICATE KEY UPDATE `tag_id`=VALUES(`tag_id`), `store_id`=VALUES(`store_id`), `customers`=VALUES(`customers`), `products`=VALUES(`products`), `popularity`=VALUES(`popularity`), `uses`=VALUES(`uses`), `historical_uses`=VALUES(`historical_uses`), `base_popularity`=VALUES(`base_popularity`)
--------------------------------------------------
--------------------------------------------------
INSERT INTO `tag_summary` (`tag_id`,`store_id`,`customers`,`products`,`popularity`,`uses`,`historical_uses`,`base_popularity`) SELECT `tag_relation`.`tag_id`, 0 AS `store_id`, COUNT(DISTINCT customer_id) AS `customers`, COUNT(DISTINCT product_id) AS `products`, COUNT(customer_id) AS `popularity`, 0 AS `uses`, 0 AS `historical_uses`, 0 AS `base_popularity` FROM `tag_relation` WHERE (tag_id IN(NULL)) GROUP BY `tag_id` ON DUPLICATE KEY UPDATE `tag_id`=VALUES(`tag_id`), `store_id`=VALUES(`store_id`), `customers`=VALUES(`customers`), `products`=VALUES(`products`), `popularity`=VALUES(`popularity`), `uses`=VALUES(`uses`), `historical_uses`=VALUES(`historical_uses`), `base_popularity`=VALUES(`base_popularity`)
--------------------------------------------------
--------------------------------------------------
commit
--------------------------------------------------
--------------------------------------------------
begin
--------------------------------------------------
--------------------------------------------------
SELECT `index_event`.* FROM `index_event` WHERE (type='save') AND (entity='catalog_product') AND (entity_pk='167')
--------------------------------------------------
--------------------------------------------------
UPDATE `index_event` SET `event_id` = ?, `type` = ?, `entity` = ?, `entity_pk` = ?, `created_at` = ?, `old_data` = ?, `new_data` = ? WHERE (event_id='10')
Params: [10],[save],[catalog_product],[167],[2011-02-24 22:48:13],[a:8:{s:41:"Mage_CatalogInventory_Model_Indexer_Stock";N;s:38:"Mage_Catalog_Model_Product_Indexer_Eav";N;s:40:"Mage_Catalog_Model_Product_Indexer_Price";N;s:30:"Mage_Catalog_Model_Indexer_Url";N;s:39:"Mage_Catalog_Model_Product_Indexer_Flat";N;s:43:"Mage_Catalog_Model_Category_Indexer_Product";N;s:41:"Mage_CatalogSearch_Model_Indexer_Fulltext";N;s:30:"Mage_Tag_Model_Indexer_Summary";N;}],[a:15:{s:35:"cataloginventory_stock_match_result";b:1;s:41:"Mage_CatalogInventory_Model_Indexer_Stock";N;s:38:"Mage_Catalog_Model_Product_Indexer_Eav";N;s:34:"catalog_product_price_match_result";b:1;s:40:"Mage_Catalog_Model_Product_Indexer_Price";N;s:24:"catalog_url_match_result";b:1;s:30:"Mage_Catalog_Model_Indexer_Url";N;s:33:"catalog_product_flat_match_result";b:1;s:39:"Mage_Catalog_Model_Product_Indexer_Flat";N;s:34:"catalog_category_flat_match_result";b:0;s:37:"catalog_category_product_match_result";b:1;s:43:"Mage_Catalog_Model_Category_Indexer_Product";N;s:35:"catalogsearch_fulltext_match_result";b:1;s:41:"Mage_CatalogSearch_Model_Indexer_Fulltext";N;s:30:"Mage_Tag_Model_Indexer_Summary";N;}]
--------------------------------------------------
--------------------------------------------------
INSERT INTO `index_process_event` (`process_id`, `event_id`, `status`) VALUES (?,?,?) ON DUPLICATE KEY UPDATE `status`=VALUES(`status`)
Params: [8],[10],[done]
--------------------------------------------------
--------------------------------------------------
INSERT INTO `index_process_event` (`process_id`, `event_id`, `status`) VALUES (?,?,?) ON DUPLICATE KEY UPDATE `status`=VALUES(`status`)
Params: [1],[10],[done]
--------------------------------------------------
--------------------------------------------------
INSERT INTO `index_process_event` (`process_id`, `event_id`, `status`) VALUES (?,?,?) ON DUPLICATE KEY UPDATE `status`=VALUES(`status`)
Params: [2],[10],[done]
--------------------------------------------------
--------------------------------------------------
INSERT INTO `index_process_event` (`process_id`, `event_id`, `status`) VALUES (?,?,?) ON DUPLICATE KEY UPDATE `status`=VALUES(`status`)
Params: [3],[10],[done]
--------------------------------------------------
--------------------------------------------------
INSERT INTO `index_process_event` (`process_id`, `event_id`, `status`) VALUES (?,?,?) ON DUPLICATE KEY UPDATE `status`=VALUES(`status`)
Params: [4],[10],[done]
--------------------------------------------------
--------------------------------------------------
INSERT INTO `index_process_event` (`process_id`, `event_id`, `status`) VALUES (?,?,?) ON DUPLICATE KEY UPDATE `status`=VALUES(`status`)
Params: [6],[10],[done]
--------------------------------------------------
--------------------------------------------------
INSERT INTO `index_process_event` (`process_id`, `event_id`, `status`) VALUES (?,?,?) ON DUPLICATE KEY UPDATE `status`=VALUES(`status`)
Params: [7],[10],[done]
--------------------------------------------------
--------------------------------------------------
INSERT INTO `index_process_event` (`process_id`, `event_id`, `status`) VALUES (?,?,?) ON DUPLICATE KEY UPDATE `status`=VALUES(`status`)
Params: [9],[10],[done]
--------------------------------------------------
--------------------------------------------------
commit
--------------------------------------------------
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment