-
-
Ever wondered why Magento Layered Cache Was SOOOO Slow and Greedy
August 31, 2009 -
Applies to Pre 1.4a Versions of Magento
Ever wondered why Magento Layered Cache Was SOOOO Slow and Greedy, as in it sees mysql as its bitch and likes to consume as much resource as humanly possible.
This is a SINGLE update query based on my test ‘footwear’ store, several attributes etc. Course the more attributes you have the slower it goes.
548 Query SHOW INNODB STATUS 553 CONNECT root@localhost ON localhost_co_uk_cfs 553 Query SET SQL_MODE='' 553 Query SET NAMES utf8 090829 20:32:00 553 Query SELECT `core_flag`.* FROM `core_flag` WHERE (core_flag.flag_code='catalogindex') 553 Query START TRANSACTION 553 Query DESCRIBE `core_flag` 548 Query SHOW GLOBAL STATUS 548 Query SHOW INNODB STATUS 553 Query INSERT INTO `core_flag` (`flag_code`, `state`, `flag_data`, `last_update`) VALUES ('catalogindex', '2', 'i:4520;', '2009-08-29 19:32:00') 553 Query COMMIT 553 Query SELECT DISTINCT `eav_attribute`.`attribute_id` FROM `eav_attribute` WHERE (frontend_input = 'price' AND attribute_code <> 'price') 090829 20:32:01 553 Query SELECT DISTINCT `eav_attribute`.`attribute_id` FROM `eav_attribute` WHERE (frontend_input IN ('select', 'multiselect') AND (is_filterable IN (1, 2) OR is_visible_in_advanced_search = 1)) 553 Query SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a` INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = 'catalog_product') AND (a.attribute_code = 'tier_price') 553 Query SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a` INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = 'catalog_product') AND (a.attribute_code = 'price') 553 Query DELETE FROM catalogindex_eav WHERE attribute_id IN ('492', '493', '496', '497', '498', '499', '501') AND entity_id IN (1144) AND store_id IN ('1') 548 Query SHOW GLOBAL STATUS 548 Query SHOW INNODB STATUS 553 Query DELETE FROM catalogindex_price WHERE attribute_id IN ('61', '64', '84') AND entity_id IN (1144) AND website_id IN ('1') 553 Query DELETE FROM catalogindex_price WHERE attribute_id IN ('60') AND entity_id IN (1144) AND website_id IN ('1') 090829 20:32:02 553 Query DELETE FROM catalogindex_price WHERE entity_id IN (1144) AND website_id IN ('1') 553 Query DELETE FROM catalogindex_minimal_price WHERE entity_id IN (1144) AND website_id IN ('1') 548 Query SHOW GLOBAL STATUS 548 Query SHOW INNODB STATUS 553 Query SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (eav_entity_type.entity_type_code='catalog_product') 090829 20:32:03 553 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code='status') AND (entity_type_id='4') 553 Query SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id=e.entity_id AND product_website.website_id='1' INNER JOIN `catalog_product_entity_int` AS `_table_status_default` ON (_table_status_default.entity_id = e.entity_id) AND (_table_status_default.attribute_id='80') AND _table_status_default.store_id=0 LEFT JOIN `catalog_product_entity_int` AS `_table_status` ON (_table_status.entity_id = e.entity_id) AND (_table_status.attribute_id='80') AND (_table_status.store_id='1') WHERE (e.entity_id = '1144') AND (IFNULL(_table_status.VALUE, _table_status_default.VALUE) IN (1)) AND (e.type_id = 'downloadable') 548 Query SHOW GLOBAL STATUS 548 Query SHOW INNODB STATUS 553 Query SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id=e.entity_id AND product_website.website_id='1' INNER JOIN `catalog_product_entity_int` AS `_table_status_default` ON (_table_status_default.entity_id = e.entity_id) AND (_table_status_default.attribute_id='80') AND _table_status_default.store_id=0 LEFT JOIN `catalog_product_entity_int` AS `_table_status` ON (_table_status.entity_id = e.entity_id) AND (_table_status.attribute_id='80') AND (_table_status.store_id='1') WHERE (e.entity_id = '1144') AND (IFNULL(_table_status.VALUE, _table_status_default.VALUE) IN (1)) AND (e.type_id = 'simple') 553 Query START TRANSACTION 553 Query SELECT `e`.`entity_id` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id=e.entity_id AND product_website.website_id='1' INNER JOIN `catalog_product_entity_int` AS `_table_status_default` ON (_table_status_default.entity_id = e.entity_id) AND (_table_status_default.attribute_id='80') AND _table_status_default.store_id=0 LEFT JOIN `catalog_product_entity_int` AS `_table_status` ON (_table_status.entity_id = e.entity_id) AND (_table_status.attribute_id='80') AND (_table_status.store_id='1') WHERE (e.entity_id = '1144') AND (IFNULL(_table_status.VALUE, _table_status_default.VALUE) IN (1)) AND (e.type_id = 'simple') LIMIT 1000 090829 20:32:04 553 Query SELECT `main_table`.`entity_id` AS `id`, `main_table`.`type_id` AS `type` FROM `catalog_product_entity` AS `main_table` WHERE (main_table.entity_id IN ('1144')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_decimal` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_decimal` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1144')) AND (c.attribute_id IN ('61', '64', '84') OR d.attribute_id IN ('61', '64', '84')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_varchar` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_varchar` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1144')) AND (c.attribute_id IN ('61', '64', '84') OR d.attribute_id IN ('61', '64', '84')) 548 Query SHOW GLOBAL STATUS 548 Query SHOW INNODB STATUS 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_int` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_int` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1144')) AND (c.attribute_id IN ('61', '64', '84') OR d.attribute_id IN ('61', '64', '84')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_text` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_text` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1144')) AND (c.attribute_id IN ('61', '64', '84') OR d.attribute_id IN ('61', '64', '84')) 090829 20:32:05 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_datetime` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_datetime` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1144')) AND (c.attribute_id IN ('61', '64', '84') OR d.attribute_id IN ('61', '64', '84')) 553 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_id='64') 553 Query REPLACE INTO catalogindex_price (entity_id, attribute_id, VALUE, website_id) VALUES ('1144', '64', '57.3000', '1') 553 Query SELECT `main_table`.`entity_id` AS `id`, `main_table`.`type_id` AS `type` FROM `catalog_product_entity` AS `main_table` WHERE (main_table.entity_id IN ('1144')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, `c`.`customer_group_id`, `c`.`qty`, `c`.`value`, `c`.`all_groups` FROM `catalog_product_entity` AS `product` LEFT JOIN `catalog_product_entity_tier_price` AS `c` ON product.entity_id = c.entity_id WHERE (product.entity_id IN ('1144')) AND (c.website_id=0) 553 Query DELETE FROM catalogindex_minimal_price WHERE entity_id IN ('1144') AND website_id IN ('1') 553 Query SELECT `main_table`.`entity_id` AS `id`, `main_table`.`type_id` AS `type` FROM `catalog_product_entity` AS `main_table` WHERE (main_table.entity_id IN ('1144')) 553 Query SELECT `base`.`customer_group_id`, MIN(VALUE) AS `minimal_value` FROM `catalogindex_price` AS `base` WHERE (base.entity_id IN ('1144')) AND (base.attribute_id IN ('75', '60')) AND (base.website_id = '1') GROUP BY `base`.`customer_group_id` 553 Query SELECT `main_table`.`entity_id` AS `id`, `main_table`.`type_id` AS `type` FROM `catalog_product_entity` AS `main_table` WHERE (main_table.entity_id IN ('1144')) 553 Query SELECT `main_table`.* FROM `customer_group` AS `main_table` 553 Query SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a` INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = 'catalog_product') AND (a.attribute_code = 'special_price') 553 Query SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a` INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = 'catalog_product') AND (a.attribute_code = 'special_from_date') 553 Query SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a` INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = 'catalog_product') AND (a.attribute_code = 'special_to_date') 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_decimal` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_decimal` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN (1144)) AND (c.attribute_id IN ('60', '61', '62', '63') OR d.attribute_id IN ('60', '61', '62', '63')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_varchar` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_varchar` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN (1144)) AND (c.attribute_id IN ('60', '61', '62', '63') OR d.attribute_id IN ('60', '61', '62', '63')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_int` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_int` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN (1144)) AND (c.attribute_id IN ('60', '61', '62', '63') OR d.attribute_id IN ('60', '61', '62', '63')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_text` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_text` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN (1144)) AND (c.attribute_id IN ('60', '61', '62', '63') OR d.attribute_id IN ('60', '61', '62', '63')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_datetime` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_datetime` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN (1144)) AND (c.attribute_id IN ('60', '61', '62', '63') OR d.attribute_id IN ('60', '61', '62', '63')) 548 Query SHOW GLOBAL STATUS 548 Query SHOW INNODB STATUS 553 Query SELECT `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date='2009-08-29') AND (website_id='1') AND (customer_group_id='0') AND (product_id='1144') 553 Query SELECT `a`.`attribute_id` FROM `eav_attribute` AS `a` INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (t.entity_type_code = 'catalog_product') AND (a.attribute_code = 'tax_class_id') 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_decimal` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_decimal` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1144')) AND (c.attribute_id IN ('81') OR d.attribute_id IN ('81')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_varchar` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_varchar` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1144')) AND (c.attribute_id IN ('81') OR d.attribute_id IN ('81')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_int` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_int` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1144')) AND (c.attribute_id IN ('81') OR d.attribute_id IN ('81')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_text` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_text` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1144')) AND (c.attribute_id IN ('81') OR d.attribute_id IN ('81')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_datetime` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_datetime` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1144')) AND (c.attribute_id IN ('81') OR d.attribute_id IN ('81')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_decimal` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_decimal` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN (1144)) AND (c.attribute_id IN ('60', '61', '62', '63') OR d.attribute_id IN ('60', '61', '62', '63')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_varchar` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_varchar` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN (1144)) AND (c.attribute_id IN ('60', '61', '62', '63') OR d.attribute_id IN ('60', '61', '62', '63')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_int` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_int` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN (1144)) AND (c.attribute_id IN ('60', '61', '62', '63') OR d.attribute_id IN ('60', '61', '62', '63')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_text` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_text` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN (1144)) AND (c.attribute_id IN ('60', '61', '62', '63') OR d.attribute_id IN ('60', '61', '62', '63')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_datetime` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_datetime` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN (1144)) AND (c.attribute_id IN ('60', '61', '62', '63') OR d.attribute_id IN ('60', '61', '62', '63')) 553 Query SELECT `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date='2009-08-29') AND (website_id='1') AND (customer_group_id='1') AND (product_id='1144') 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_decimal` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_decimal` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1144')) AND (c.attribute_id IN ('81') OR d.attribute_id IN ('81')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_varchar` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_varchar` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1144')) AND (c.attribute_id IN ('81') OR d.attribute_id IN ('81')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_int` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_int` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1144')) AND (c.attribute_id IN ('81') OR d.attribute_id IN ('81')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_text` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_text` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1144')) AND (c.attribute_id IN ('81') OR d.attribute_id IN ('81')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_datetime` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_datetime` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1144')) AND (c.attribute_id IN ('81') OR d.attribute_id IN ('81')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_decimal` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_decimal` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN (1144)) AND (c.attribute_id IN ('60', '61', '62', '63') OR d.attribute_id IN ('60', '61', '62', '63')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_varchar` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_varchar` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN (1144)) AND (c.attribute_id IN ('60', '61', '62', '63') OR d.attribute_id IN ('60', '61', '62', '63')) 090829 20:32:06 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_int` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_int` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN (1144)) AND (c.attribute_id IN ('60', '61', '62', '63') OR d.attribute_id IN ('60', '61', '62', '63')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_text` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_text` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN (1144)) AND (c.attribute_id IN ('60', '61', '62', '63') OR d.attribute_id IN ('60', '61', '62', '63')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_datetime` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_datetime` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN (1144)) AND (c.attribute_id IN ('60', '61', '62', '63') OR d.attribute_id IN ('60', '61', '62', '63')) 553 Query SELECT `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date='2009-08-29') AND (website_id='1') AND (customer_group_id='3') AND (product_id='1144') 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_decimal` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_decimal` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1144')) AND (c.attribute_id IN ('81') OR d.attribute_id IN ('81')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_varchar` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_varchar` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1144')) AND (c.attribute_id IN ('81') OR d.attribute_id IN ('81')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_int` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_int` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1144')) AND (c.attribute_id IN ('81') OR d.attribute_id IN ('81')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_text` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_text` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1144')) AND (c.attribute_id IN ('81') OR d.attribute_id IN ('81')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_datetime` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_datetime` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1144')) AND (c.attribute_id IN ('81') OR d.attribute_id IN ('81')) 553 Query REPLACE INTO catalogindex_price (entity_id, website_id, customer_group_id, VALUE, attribute_id, tax_class_id) VALUES ('1144', '1', '0', '137.0000', '60', '0'), ('1144', '1', '1', '137.0000', '60', '0'), ('1144', '1', '3', '137.0000', '60', '0') 553 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code='visibility') AND (entity_type_id='4') 553 Query DELETE FROM `catalog_product_enabled_index` WHERE (store_id=1 AND product_id IN ('1144')) 553 Query INSERT INTO catalog_product_enabled_index SELECT t_v_default.entity_id, 1, IFNULL(t_v.VALUE, t_v_default.VALUE) FROM catalog_product_entity_int AS t_v_default INNER JOIN catalog_product_website AS w ON w.product_id=t_v_default.entity_id AND w.website_id=1 LEFT JOIN catalog_product_entity_int AS `t_v` ON (t_v.entity_id = t_v_default.entity_id) AND (t_v.attribute_id='85') AND (t_v.store_id='1') INNER JOIN catalog_product_entity_int AS `t_s_default` ON (t_s_default.entity_id = t_v_default.entity_id) AND (t_s_default.attribute_id='80') AND t_s_default.store_id=0 LEFT JOIN catalog_product_entity_int AS `t_s` ON (t_s.entity_id = t_v_default.entity_id) AND (t_s.attribute_id='80') AND (t_s.store_id='1') WHERE t_v_default.attribute_id='85' AND t_v_default.store_id=0 AND t_v_default.entity_id IN ('1144') AND (IFNULL(t_s.VALUE, t_s_default.VALUE)=1) 553 Query SELECT `core_flag`.* FROM `core_flag` WHERE (core_flag.flag_code='catalogindex_kill') 553 Query COMMIT 553 Query SELECT `e`.`entity_id` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id=e.entity_id AND product_website.website_id='1' INNER JOIN `catalog_product_entity_int` AS `_table_status_default` ON (_table_status_default.entity_id = e.entity_id) AND (_table_status_default.attribute_id='80') AND _table_status_default.store_id=0 LEFT JOIN `catalog_product_entity_int` AS `_table_status` ON (_table_status.entity_id = e.entity_id) AND (_table_status.attribute_id='80') AND (_table_status.store_id='1') WHERE (e.entity_id = '1144') AND (IFNULL(_table_status.VALUE, _table_status_default.VALUE) IN (1)) AND (e.type_id = 'simple') LIMIT 1000 548 Query SHOW GLOBAL STATUS 548 Query SHOW INNODB STATUS 553 Query SELECT `catalog_product_super_link`.`product_id`, `catalog_product_super_link`.`parent_id` FROM `catalog_product_super_link` WHERE (product_id IN('1144')) 553 Query SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id=e.entity_id AND product_website.website_id='1' INNER JOIN `catalog_product_entity_int` AS `_table_status_default` ON (_table_status_default.entity_id = e.entity_id) AND (_table_status_default.attribute_id='80') AND _table_status_default.store_id=0 LEFT JOIN `catalog_product_entity_int` AS `_table_status` ON (_table_status.entity_id = e.entity_id) AND (_table_status.attribute_id='80') AND (_table_status.store_id='1') WHERE (e.entity_id IN ('1137')) AND (IFNULL(_table_status.VALUE, _table_status_default.VALUE) IN (1)) AND (e.type_id = 'configurable') 553 Query START TRANSACTION 553 Query SELECT `e`.`entity_id` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id=e.entity_id AND product_website.website_id='1' INNER JOIN `catalog_product_entity_int` AS `_table_status_default` ON (_table_status_default.entity_id = e.entity_id) AND (_table_status_default.attribute_id='80') AND _table_status_default.store_id=0 LEFT JOIN `catalog_product_entity_int` AS `_table_status` ON (_table_status.entity_id = e.entity_id) AND (_table_status.attribute_id='80') AND (_table_status.store_id='1') WHERE (e.entity_id IN ('1137')) AND (IFNULL(_table_status.VALUE, _table_status_default.VALUE) IN (1)) AND (e.type_id = 'configurable') LIMIT 1000 553 Query SELECT `main_table`.`entity_id` AS `id`, `main_table`.`type_id` AS `type` FROM `catalog_product_entity` AS `main_table` WHERE (main_table.entity_id IN ('1137')) 553 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code='required_options') AND (entity_type_id='4') 553 Query SELECT `l`.`product_id` FROM `catalog_product_super_link` AS `l` INNER JOIN `catalog_product_entity_int` AS `t_global_status` ON `l`.`product_id`=`t_global_status`.`entity_id` AND `t_global_status`.`attribute_id`='80' AND `t_global_status`.`store_id`=0 LEFT JOIN `catalog_product_entity_int` AS `t_store_status` ON `t_global_status`.`entity_id`=`t_store_status`.`entity_id` AND `t_global_status`.`attribute_id`=`t_store_status`.`attribute_id` AND `t_store_status`.`store_id`='1' INNER JOIN `catalog_product_website` AS `w` ON l.product_id=w.product_id AND w.website_id=1 INNER JOIN `catalog_product_entity` AS `t_required_options` ON `l`.`product_id`=`t_required_options`.`entity_id` WHERE (l.parent_id = '1137') AND (IFNULL(`t_store_status`.`value`, `t_global_status`.`value`) IN(1)) AND (t_required_options.required_options IN(0)) 090829 20:32:07 553 Query SELECT `main_table`.`entity_id` AS `id`, `main_table`.`type_id` AS `type` FROM `catalog_product_entity` AS `main_table` WHERE (main_table.entity_id IN ('1138', '1139', '1140', '1141', '1142', '1143', '1144')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_decimal` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_decimal` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1138', '1139', '1140', '1141', '1142', '1143', '1144')) AND (c.attribute_id IN ('61', '64', '84') OR d.attribute_id IN ('61', '64', '84')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_varchar` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_varchar` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1138', '1139', '1140', '1141', '1142', '1143', '1144')) AND (c.attribute_id IN ('61', '64', '84') OR d.attribute_id IN ('61', '64', '84')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_int` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_int` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1138', '1139', '1140', '1141', '1142', '1143', '1144')) AND (c.attribute_id IN ('61', '64', '84') OR d.attribute_id IN ('61', '64', '84')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_text` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_text` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1138', '1139', '1140', '1141', '1142', '1143', '1144')) AND (c.attribute_id IN ('61', '64', '84') OR d.attribute_id IN ('61', '64', '84')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_datetime` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_datetime` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1138', '1139', '1140', '1141', '1142', '1143', '1144')) AND (c.attribute_id IN ('61', '64', '84') OR d.attribute_id IN ('61', '64', '84')) 553 Query REPLACE INTO catalogindex_price (entity_id, attribute_id, VALUE, website_id) VALUES ('1137', '64', '57.3000', '1'), ('1137', '64', '57.3000', '1'), ('1137', '64', '57.3000', '1'), ('1137', '64', '57.3000', '1'), ('1137', '64', '57.3000', '1'), ('1137', '64', '57.3000', '1'), ('1137', '64', '57.3000', '1') 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_decimal` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_decimal` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1137')) AND (c.attribute_id IN ('61', '64', '84') OR d.attribute_id IN ('61', '64', '84')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_varchar` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_varchar` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1137')) AND (c.attribute_id IN ('61', '64', '84') OR d.attribute_id IN ('61', '64', '84')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_int` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_int` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1137')) AND (c.attribute_id IN ('61', '64', '84') OR d.attribute_id IN ('61', '64', '84')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_text` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_text` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1137')) AND (c.attribute_id IN ('61', '64', '84') OR d.attribute_id IN ('61', '64', '84')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_datetime` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_datetime` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1137')) AND (c.attribute_id IN ('61', '64', '84') OR d.attribute_id IN ('61', '64', '84')) 553 Query REPLACE INTO catalogindex_price (entity_id, attribute_id, VALUE, website_id) VALUES ('1137', '64', '57.3000', '1') 553 Query SELECT `main_table`.`entity_id` AS `id`, `main_table`.`type_id` AS `type` FROM `catalog_product_entity` AS `main_table` WHERE (main_table.entity_id IN ('1137')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, `c`.`customer_group_id`, `c`.`qty`, `c`.`value`, `c`.`all_groups` FROM `catalog_product_entity` AS `product` LEFT JOIN `catalog_product_entity_tier_price` AS `c` ON product.entity_id = c.entity_id WHERE (product.entity_id IN ('1137')) AND (c.website_id=0) 553 Query DELETE FROM catalogindex_minimal_price WHERE entity_id IN ('1137') AND website_id IN ('1') 548 Query SHOW GLOBAL STATUS 548 Query SHOW INNODB STATUS 553 Query SELECT `main_table`.`entity_id` AS `id`, `main_table`.`type_id` AS `type` FROM `catalog_product_entity` AS `main_table` WHERE (main_table.entity_id IN ('1137')) 553 Query SELECT `base`.`customer_group_id`, MIN(VALUE) AS `minimal_value` FROM `catalogindex_price` AS `base` WHERE (base.entity_id IN ('1137')) AND (base.attribute_id IN ('75', '60')) AND (base.website_id = '1') GROUP BY `base`.`customer_group_id` 553 Query REPLACE INTO catalogindex_minimal_price (website_id, entity_id, customer_group_id, VALUE, tax_class_id) VALUES ('1', '1137', '0', '137.0000', 0), ('1', '1137', '1', '137.0000', 0), ('1', '1137', '3', '137.0000', 0) 553 Query SELECT `main_table`.`entity_id` AS `id`, `main_table`.`type_id` AS `type` FROM `catalog_product_entity` AS `main_table` WHERE (main_table.entity_id IN ('1137')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_decimal` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_decimal` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN (1137)) AND (c.attribute_id IN ('60', '61', '62', '63') OR d.attribute_id IN ('60', '61', '62', '63')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_varchar` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_varchar` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN (1137)) AND (c.attribute_id IN ('60', '61', '62', '63') OR d.attribute_id IN ('60', '61', '62', '63')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_int` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_int` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN (1137)) AND (c.attribute_id IN ('60', '61', '62', '63') OR d.attribute_id IN ('60', '61', '62', '63')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_text` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_text` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN (1137)) AND (c.attribute_id IN ('60', '61', '62', '63') OR d.attribute_id IN ('60', '61', '62', '63')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_datetime` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_datetime` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN (1137)) AND (c.attribute_id IN ('60', '61', '62', '63') OR d.attribute_id IN ('60', '61', '62', '63')) 553 Query SELECT `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date='2009-08-29') AND (website_id='1') AND (customer_group_id='0') AND (product_id='1137') 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_decimal` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_decimal` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1137')) AND (c.attribute_id IN ('81') OR d.attribute_id IN ('81')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_varchar` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_varchar` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1137')) AND (c.attribute_id IN ('81') OR d.attribute_id IN ('81')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_int` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_int` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1137')) AND (c.attribute_id IN ('81') OR d.attribute_id IN ('81')) 090829 20:32:08 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_text` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_text` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1137')) AND (c.attribute_id IN ('81') OR d.attribute_id IN ('81')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_datetime` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_datetime` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1137')) AND (c.attribute_id IN ('81') OR d.attribute_id IN ('81')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_decimal` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_decimal` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN (1137)) AND (c.attribute_id IN ('60', '61', '62', '63') OR d.attribute_id IN ('60', '61', '62', '63')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_varchar` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_varchar` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN (1137)) AND (c.attribute_id IN ('60', '61', '62', '63') OR d.attribute_id IN ('60', '61', '62', '63')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_int` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_int` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN (1137)) AND (c.attribute_id IN ('60', '61', '62', '63') OR d.attribute_id IN ('60', '61', '62', '63')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_text` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_text` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN (1137)) AND (c.attribute_id IN ('60', '61', '62', '63') OR d.attribute_id IN ('60', '61', '62', '63')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_datetime` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_datetime` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN (1137)) AND (c.attribute_id IN ('60', '61', '62', '63') OR d.attribute_id IN ('60', '61', '62', '63')) 553 Query SELECT `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date='2009-08-29') AND (website_id='1') AND (customer_group_id='1') AND (product_id='1137') 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_decimal` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_decimal` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1137')) AND (c.attribute_id IN ('81') OR d.attribute_id IN ('81')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_varchar` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_varchar` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1137')) AND (c.attribute_id IN ('81') OR d.attribute_id IN ('81')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_int` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_int` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1137')) AND (c.attribute_id IN ('81') OR d.attribute_id IN ('81')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_text` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_text` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1137')) AND (c.attribute_id IN ('81') OR d.attribute_id IN ('81')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_datetime` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_datetime` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1137')) AND (c.attribute_id IN ('81') OR d.attribute_id IN ('81')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_decimal` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_decimal` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN (1137)) AND (c.attribute_id IN ('60', '61', '62', '63') OR d.attribute_id IN ('60', '61', '62', '63')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_varchar` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_varchar` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN (1137)) AND (c.attribute_id IN ('60', '61', '62', '63') OR d.attribute_id IN ('60', '61', '62', '63')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_int` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_int` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN (1137)) AND (c.attribute_id IN ('60', '61', '62', '63') OR d.attribute_id IN ('60', '61', '62', '63')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_text` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_text` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN (1137)) AND (c.attribute_id IN ('60', '61', '62', '63') OR d.attribute_id IN ('60', '61', '62', '63')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_datetime` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_datetime` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN (1137)) AND (c.attribute_id IN ('60', '61', '62', '63') OR d.attribute_id IN ('60', '61', '62', '63')) 553 Query SELECT `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date='2009-08-29') AND (website_id='1') AND (customer_group_id='3') AND (product_id='1137') 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_decimal` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_decimal` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1137')) AND (c.attribute_id IN ('81') OR d.attribute_id IN ('81')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_varchar` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_varchar` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1137')) AND (c.attribute_id IN ('81') OR d.attribute_id IN ('81')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_int` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_int` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1137')) AND (c.attribute_id IN ('81') OR d.attribute_id IN ('81')) 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_text` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_text` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1137')) AND (c.attribute_id IN ('81') OR d.attribute_id IN ('81')) 548 Query SHOW GLOBAL STATUS 548 Query SHOW INNODB STATUS 553 Query SELECT `product`.`entity_id`, `product`.`type_id`, IFNULL(c.attribute_id, d.attribute_id) AS `attribute_id`, IFNULL(c.VALUE, d.VALUE) AS `value` FROM `catalog_product_entity` AS `product` RIGHT JOIN `catalog_product_entity_datetime` AS `d` ON product.entity_id = d.entity_id AND d.store_id = 0 LEFT JOIN `catalog_product_entity_datetime` AS `c` ON product.entity_id = c.entity_id AND c.store_id = 1 AND c.attribute_id = d.attribute_id WHERE (product.entity_id IN ('1137')) AND (c.attribute_id IN ('81') OR d.attribute_id IN ('81')) 553 Query REPLACE INTO catalogindex_price (entity_id, website_id, customer_group_id, VALUE, attribute_id, tax_class_id) VALUES ('1137', '1', '0', '137.0000', '60', '0'), ('1137', '1', '1', '137.0000', '60', '0'), ('1137', '1', '3', '137.0000', '60', '0') 553 Query DELETE FROM `catalog_product_enabled_index` WHERE (store_id=1 AND product_id IN ('1137')) 553 Query INSERT INTO catalog_product_enabled_index SELECT t_v_default.entity_id, 1, IFNULL(t_v.VALUE, t_v_default.VALUE) FROM catalog_product_entity_int AS t_v_default INNER JOIN catalog_product_website AS w ON w.product_id=t_v_default.entity_id AND w.website_id=1 LEFT JOIN catalog_product_entity_int AS `t_v` ON (t_v.entity_id = t_v_default.entity_id) AND (t_v.attribute_id='85') AND (t_v.store_id='1') INNER JOIN catalog_product_entity_int AS `t_s_default` ON (t_s_default.entity_id = t_v_default.entity_id) AND (t_s_default.attribute_id='80') AND t_s_default.store_id=0 LEFT JOIN catalog_product_entity_int AS `t_s` ON (t_s.entity_id = t_v_default.entity_id) AND (t_s.attribute_id='80') AND (t_s.store_id='1') WHERE t_v_default.attribute_id='85' AND t_v_default.store_id=0 AND t_v_default.entity_id IN ('1137') AND (IFNULL(t_s.VALUE, t_s_default.VALUE)=1) 553 Query SELECT `core_flag`.* FROM `core_flag` WHERE (core_flag.flag_code='catalogindex_kill') 553 Query COMMIT 090829 20:32:09 553 Query SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (eav_entity_type.entity_type_code='catalog_product') 553 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code='price_type') AND (entity_type_id='4') 553 Query SELECT `e`.`entity_id`, `t_price_type`.`value` AS `price_type` FROM `catalog_product_entity` AS `e` LEFT JOIN `catalog_product_entity_int` AS `t_price_type` ON t_price_type.attribute_id='465' AND t_price_type.store_id=0 AND t_price_type.entity_id=e.entity_id WHERE (e.type_id='bundle') AND (e.entity_id IN('1137')) AND (e.entity_id>0) ORDER BY `e`.`entity_id` ASC LIMIT 100 553 Query SELECT `core_flag`.* FROM `core_flag` WHERE (core_flag.flag_code='catalog_product_flat') 553 Query SELECT `tbl_selection`.`product_id`, `tbl_selection`.`parent_product_id`, `tbl_selection`.`option_id`, `tbl_option`.`required` FROM `catalog_product_bundle_selection` AS `tbl_selection` INNER JOIN `catalog_product_bundle_option` AS `tbl_option` ON `tbl_option`.`option_id` = `tbl_selection`.`option_id` WHERE (`tbl_selection`.`product_id` IN('1144')) 548 Query SHOW GLOBAL STATUS 548 Query SHOW INNODB STATUS 553 Query SELECT `catalog_product_link`.`product_id`, `catalog_product_link`.`linked_product_id` FROM `catalog_product_link` WHERE (linked_product_id IN('1144')) AND (link_type_id=3) 553 Query SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id=e.entity_id AND product_website.website_id='1' INNER JOIN `catalog_product_entity_int` AS `_table_status_default` ON (_table_status_default.entity_id = e.entity_id) AND (_table_status_default.attribute_id='80') AND _table_status_default.store_id=0 LEFT JOIN `catalog_product_entity_int` AS `_table_status` ON (_table_status.entity_id = e.entity_id) AND (_table_status.attribute_id='80') AND (_table_status.store_id='1') WHERE (e.entity_id = '1144') AND (IFNULL(_table_status.VALUE, _table_status_default.VALUE) IN (1)) AND (e.type_id = 'virtual') 553 Query SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id=e.entity_id AND product_website.website_id='1' INNER JOIN `catalog_product_entity_int` AS `_table_status_default` ON (_table_status_default.entity_id = e.entity_id) AND (_table_status_default.attribute_id='80') AND _table_status_default.store_id=0 LEFT JOIN `catalog_product_entity_int` AS `_table_status` ON (_table_status.entity_id = e.entity_id) AND (_table_status.attribute_id='80') AND (_table_status.store_id='1') WHERE (e.entity_id = '1144') AND (IFNULL(_table_status.VALUE, _table_status_default.VALUE) IN (1)) AND (e.type_id = 'configurable') 553 Query SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id=e.entity_id AND product_website.website_id='1' INNER JOIN `catalog_product_entity_int` AS `_table_status_default` ON (_table_status_default.entity_id = e.entity_id) AND (_table_status_default.attribute_id='80') AND _table_status_default.store_id=0 LEFT JOIN `catalog_product_entity_int` AS `_table_status` ON (_table_status.entity_id = e.entity_id) AND (_table_status.attribute_id='80') AND (_table_status.store_id='1') WHERE (e.entity_id = '1144') AND (IFNULL(_table_status.VALUE, _table_status_default.VALUE) IN (1)) AND (e.type_id = 'bundle') 553 Query SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id=e.entity_id AND product_website.website_id='1' INNER JOIN `catalog_product_entity_int` AS `_table_status_default` ON (_table_status_default.entity_id = e.entity_id) AND (_table_status_default.attribute_id='80') AND _table_status_default.store_id=0 LEFT JOIN `catalog_product_entity_int` AS `_table_status` ON (_table_status.entity_id = e.entity_id) AND (_table_status.attribute_id='80') AND (_table_status.store_id='1') WHERE (e.entity_id = '1144') AND (IFNULL(_table_status.VALUE, _table_status_default.VALUE) IN (1)) AND (e.type_id = 'grouped') 553 Query SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(3, 2, 4) AND cat_index.category_id='2' WHERE (e.entity_id = '1144') AND (e.type_id = 'downloadable') 553 Query SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(3, 2, 4) AND cat_index.category_id='2' WHERE (e.entity_id = '1144') AND (e.type_id = 'simple') 553 Query SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(3, 2, 4) AND cat_index.category_id='2' WHERE (e.entity_id = '1144') AND (e.type_id = 'virtual') 553 Query SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(3, 2, 4) AND cat_index.category_id='2' WHERE (e.entity_id = '1144') AND (e.type_id = 'configurable') 553 Query SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(3, 2, 4) AND cat_index.category_id='2' WHERE (e.entity_id = '1144') AND (e.type_id = 'bundle') 553 Query SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(3, 2, 4) AND cat_index.category_id='2' WHERE (e.entity_id = '1144') AND (e.type_id = 'grouped') 553 Query SELECT `e`.`entity_id`, `t_price_type`.`value` AS `price_type` FROM `catalog_product_entity` AS `e` LEFT JOIN `catalog_product_entity_int` AS `t_price_type` ON t_price_type.attribute_id='465' AND t_price_type.store_id=0 AND t_price_type.entity_id=e.entity_id WHERE (e.type_id='bundle') AND (e.entity_id IN(1144)) AND (e.entity_id>0) ORDER BY `e`.`entity_id` ASC LIMIT 100 553 Query START TRANSACTION 553 Query DELETE FROM `core_flag` WHERE (flag_id='688') 553 Query COMMIT 090829 20:32:10 553 Quit
Now to damage my brain working out how to make this go faster; any suggestions appreciated
)
-
- © 2012 Chris McKee - chrismckee.co.uk
[HTML5]
6 Responses to “ Ever wondered why Magento Layered Cache Was SOOOO Slow and Greedy ”
This part of Magento is being refactored and should be available in the next alpha release.
I would be very interested in your feedback once it is out.
Thanks
yoav
@yoav Thanks is this the current alpha or one after this. will you be keeping the core indexer (i.e. will I need to rewrite my other script).
Glad to hear its being looked at; I look forward to poking through the code when it comes out
)
Hi Guys!
Is there any progress regarding this issue. One of my client experiences big troubles with it and we haven't solutions so far
. He has about 80 K products and refreshing of the layered navigation is really a huge issue for this project. Any help in it will be appreciated.
Thanks.
@Sergey I've not seen anything new drop in yet on the SVN releases but I'll keep an eye out and see if it really makes a great difference or not. Till then you'll just have to suffer using my script.
Now that is pretty horrendous! Jeepers!
Appears Fixed for 1.4 but alot of the queries still end up in my dev-machines slow query log
Thank god for the caching engine