Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

speed
 
coldlamper
Member
 
Total Posts:  35
Joined:  2009-02-01
NC, USA
 

here is mysql log of adding 1 product

090420 11:57:19 7 Query SELECT `main_table`.* FROM `eav_entity_type` AS `main_table`
7 Query SELECT `main_table`.* FROM `eav_attribute` AS `main_table` WHERE (main_table.entity_type_id=’4’) AND (main_table.attribute_code IN(’entity_id’, ‘entity_type_id’, ‘attribute_set_id’, ‘type_id’, ‘created_at’, ‘updated_at’))
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’entity_id’) AND (entity_type_id=’4’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’entity_type_id’) AND (entity_type_id=’4’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’attribute_set_id’) AND (entity_type_id=’4’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’type_id’) AND (entity_type_id=’4’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’created_at’) AND (entity_type_id=’4’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’updated_at’) AND (entity_type_id=’4’)
7 Query SELECT `main_table`.*, `entity_attribute`.* FROM `eav_attribute` AS `main_table`
INNER JOIN `eav_entity_attribute` AS `entity_attribute` ON entity_attribute.attribute_id=main_table.attribute_id WHERE (main_table.entity_type_id=’4’) AND (entity_attribute.attribute_set_id=4) ORDER BY sort_order ASC
7 Query SELECT `main_table`.* FROM `eav_attribute` AS `main_table` WHERE (main_table.entity_type_id=’4’) AND (main_table.attribute_code IN(’name’, ‘price’, ‘meta_title’, ‘image’, ‘custom_design’, ‘description’, ‘special_price’, ‘meta_keyword’, ‘small_image’, ‘custom_design_from’, ‘short_description’, ‘special_from_date’, ‘meta_description’, ‘thumbnail’, ‘custom_design_to’, ‘sku’, ‘special_to_date’, ‘media_gallery’, ‘custom_layout_update’, ‘shoesize’, ‘cost’, ‘gallery’, ‘options_container’, ‘weight’, ‘tax_class_id’, ‘old_id’, ‘manufacturer’, ‘tier_price’, ‘minimal_price’, ‘color’, ‘disable_googlecheckout’, ‘news_from_date’, ‘price_view’, ‘news_to_date’, ‘status’, ‘url_key’, ‘url_path’, ‘visibility’, ‘gift_message_available’, ‘category_ids’, ‘required_options’, ‘has_options’, ‘image_label’, ‘small_image_label’, ‘thumbnail_label’, ‘price_type’, ‘sku_type’, ‘weight_type’, ‘shipment_type’, ‘links_purchased_separately’, ‘samples_title’, ‘links_title’))
7 Query 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 (attribute_id IN (’90’, ‘76’, ‘64’, ‘86’, ‘87’, ‘88’, ‘89’, ‘57’, ‘462’, ‘79’, ‘464’, ‘93’, ‘70’, ‘94’, ‘470’, ‘472’, ‘66’, ‘73’, ‘69’, ‘68’, ‘67’, ‘84’, ‘56’, ‘77’, ‘78’, ‘74’, ‘91’, ‘60’, ‘465’, ‘468’, ‘92’, ‘471’, ‘469’, ‘491’, ‘58’, ‘59’, ‘466’, ‘71’, ‘95’, ‘62’, ‘61’, ‘63’, ‘80’, ‘81’, ‘72’, ‘96’, ‘75’, ‘82’, ‘83’, ‘85’, ‘65’, ‘467’))
090420 11:57:20 7 Query START TRANSACTION
090420 11:57:22 7 Query SELECT `main_table`.*, `entity_attribute`.* FROM `eav_attribute` AS `main_table`
INNER JOIN `eav_entity_attribute` AS `entity_attribute` ON entity_attribute.attribute_id=main_table.attribute_id WHERE (main_table.entity_type_id=’4’) AND (entity_attribute.attribute_set_id=4) ORDER BY sort_order ASC
7 Query select entity_id from catalog_product_entity where sku=’1AALIPGSPH10000’
7 Query SELECT `main_table`.* FROM `eav_attribute` AS `main_table` WHERE (main_table.entity_type_id=’3’)
7 Query 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 (attribute_id IN (’44’, ‘46’, ‘55’, ‘48’, ‘49’, ‘50’, ‘51’, ‘53’, ‘34’, ‘39’, ‘35’, ‘32’, ‘41’, ‘40’, ‘54’, ‘38’, ‘37’, ‘36’, ‘31’, ‘52’, ‘42’, ‘45’, ‘43’, ‘33’, ‘47’))
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’entity_type_id’) AND (entity_type_id=’3’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’attribute_set_id’) AND (entity_type_id=’3’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’created_at’) AND (entity_type_id=’3’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’updated_at’) AND (entity_type_id=’3’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’parent_id’) AND (entity_type_id=’3’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’increment_id’) AND (entity_type_id=’3’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’entity_id’) AND (entity_type_id=’3’)
7 Query SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id IN(’154’))
090420 11:57:23 7 Query SELECT `main_table`.* FROM `eav_attribute` AS `main_table` WHERE (main_table.entity_type_id=’4’)
7 Query 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 (attribute_id IN (’90’, ‘76’, ‘64’, ‘86’, ‘87’, ‘88’, ‘89’, ‘57’, ‘462’, ‘79’, ‘464’, ‘93’, ‘70’, ‘94’, ‘470’, ‘472’, ‘66’, ‘73’, ‘69’, ‘68’, ‘67’, ‘84’, ‘56’, ‘77’, ‘78’, ‘74’, ‘91’, ‘60’, ‘465’, ‘468’, ‘92’, ‘471’, ‘469’, ‘491’, ‘58’, ‘59’, ‘466’, ‘71’, ‘95’, ‘62’, ‘61’, ‘63’, ‘80’, ‘81’, ‘72’, ‘96’, ‘75’, ‘82’, ‘83’, ‘85’, ‘65’, ‘467’))
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’store_id’) AND (entity_type_id=’4’)
7 Query DESCRIBE `catalog_product_entity`
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’decksize’) AND (entity_type_id=’4’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’type_has_options’) AND (entity_type_id=’4’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’type_has_required_options’) AND (entity_type_id=’4’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’parent_id’) AND (entity_type_id=’4’)
7 Query INSERT INTO `catalog_product_entity` (`category_ids`, `attribute_set_id`, `sku`, `type_id`, `has_options`, `entity_type_id`, `entity_id`, `created_at`, `updated_at`) VALUES (’154’, ‘4’, ‘1AALIPGSPH10000’, ‘simple’, ‘’, ‘4’, ‘’, ‘2009-04-20 15:57:22’, ‘2009-04-20 15:57:22’)
7 Query INSERT INTO `catalog_product_entity_decimal` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘60’, ‘3.900000’, ‘0’)
7 Query INSERT INTO `catalog_product_entity_decimal` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘65’, ‘0.120000’, ‘0’)
7 Query INSERT INTO `catalog_product_entity_text` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘57’, ‘Alien 1\\\” Phillips Hardware Single Set’, ‘0’)
7 Query INSERT INTO `catalog_product_entity_text` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘58’, ‘Alien 1\\\” Phillips Hardware Single Set’, ‘0’)
7 Query INSERT INTO `catalog_product_entity_varchar` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘56’, ‘Alien 1\\\” Phillips Hardware Single Set’, ‘0’)
7 Query INSERT INTO `catalog_product_entity_int` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘66’, ‘173’, ‘0’)
7 Query INSERT INTO `catalog_product_entity_int` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘81’, ‘2’, ‘0’)
7 Query INSERT INTO `catalog_product_entity_int` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘80’, ‘1’, ‘0’)
7 Query INSERT INTO `catalog_product_entity_varchar` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘72’, ‘/1/A/1AALIPGSPH10000_8.gif’, ‘0’)
7 Query INSERT INTO `catalog_product_entity_varchar` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘71’, ‘/1/A/1AALIPGSPH10000_8.gif’, ‘0’)
7 Query INSERT INTO `catalog_product_entity_varchar` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘70’, ‘/1/A/1AALIPGSPH10000_8.gif’, ‘0’)
7 Query INSERT INTO `catalog_product_entity_varchar` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘94’, ‘’, ‘0’)
7 Query INSERT INTO `catalog_product_entity_varchar` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘95’, ‘’, ‘0’)
7 Query INSERT INTO `catalog_product_entity_varchar` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘96’, ‘’, ‘0’)
7 Query INSERT INTO `catalog_product_entity_varchar` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘91’, ‘container2’, ‘0’)
7 Query INSERT INTO `catalog_product_entity_varchar` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘82’, ‘alien-1-phillips-hardware-single-set’, ‘0’)
7 Query INSERT INTO `catalog_product_entity_int` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘85’, ‘4’, ‘0’)
7 Query SELECT `catalog_product_website`.* FROM `catalog_product_website` WHERE (product_id=’7’)
7 Query INSERT INTO `catalog_product_website` (`product_id`, `website_id`) VALUES (’7’, ‘1’)
7 Query insert into catalog_category_product
(category_id, product_id, position) values (154,7,0)
7 Query DELETE FROM `catalog_category_product_index` WHERE (product_id=’7’)
7 Query SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id IN (’154’))
7 Query SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id=7)
7 Query SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id IN (’1’, ‘2’, ‘152’, ‘153’, ‘154’)) ORDER BY `level` ASC, `path` ASC
7 Query SELECT
s.store_id, s.website_id, c.path AS root_path
FROM
core_store AS s,
core_store_group AS sg,
catalog_category_entity AS c
WHERE
sg.group_id=s.group_id
AND c.entity_id=sg.root_category_id
7 Query DELETE FROM `catalog_category_product_index` WHERE (category_id=1 AND store_id=1 AND product_id IN (’7’))
7 Query DELETE FROM `catalog_category_product_index` WHERE (category_id=2 AND store_id=1 AND product_id IN (’7’))
7 Query INSERT INTO catalog_category_product_index
(`category_id`, `product_id`, `position`, `is_parent`, `store_id`, `visibility`)
SELECT
2,
cp.product_id,
cp.position,
2=cp.category_id as is_parent,
1,
IFNULL(t_v.value, t_v_default.value)
FROM
catalog_category_product AS cp
INNER JOIN catalog_product_website AS pw
ON pw.product_id=cp.product_id AND pw.website_id=1
INNER JOIN catalog_product_entity_int AS `t_v_default`
ON (t_v_default.entity_id = cp.product_id)
AND (t_v_default.attribute_id=’85’)
AND t_v_default.store_id=0
LEFT JOIN catalog_product_entity_int AS `t_v`
ON (t_v.entity_id = cp.product_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 = cp.product_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 = cp.product_id)
AND (t_s.attribute_id=’80’)
AND (t_s.store_id=’1’)
WHERE category_id IN(
SELECT entity_id FROM catalog_category_entity
WHERE entity_id = 2 OR path LIKE ‘1/2/%’)
AND (IFNULL(t_s.value, t_s_default.value)=1)
AND cp.product_id IN (’7’)
GROUP BY product_id
ORDER BY is_parent desc
7 Query DELETE FROM `catalog_category_product_index` WHERE (category_id=152 AND store_id=1 AND product_id IN (’7’))
7 Query INSERT INTO catalog_category_product_index
(`category_id`, `product_id`, `position`, `is_parent`, `store_id`, `visibility`)
SELECT
152,
cp.product_id,
cp.position,
152=cp.category_id as is_parent,
1,
IFNULL(t_v.value, t_v_default.value)
FROM
catalog_category_product AS cp
INNER JOIN catalog_product_website AS pw
ON pw.product_id=cp.product_id AND pw.website_id=1
INNER JOIN catalog_product_entity_int AS `t_v_default`
ON (t_v_default.entity_id = cp.product_id)
AND (t_v_default.attribute_id=’85’)
AND t_v_default.store_id=0
LEFT JOIN catalog_product_entity_int AS `t_v`
ON (t_v.entity_id = cp.product_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 = cp.product_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 = cp.product_id)
AND (t_s.attribute_id=’80’)
AND (t_s.store_id=’1’)
WHERE category_id IN(
SELECT entity_id FROM catalog_category_entity
WHERE entity_id = 152 OR path LIKE ‘1/2/152/%’)
AND (IFNULL(t_s.value, t_s_default.value)=1)
AND cp.product_id IN (’7’)
GROUP BY product_id
ORDER BY is_parent desc
7 Query DELETE FROM `catalog_category_product_index` WHERE (category_id=153 AND store_id=1 AND product_id IN (’7’))
7 Query INSERT INTO catalog_category_product_index
(`category_id`, `product_id`, `position`, `is_parent`, `store_id`, `visibility`)
SELECT
153,
cp.product_id,
cp.position,
153=cp.category_id as is_parent,
1,
IFNULL(t_v.value, t_v_default.value)
FROM
catalog_category_product AS cp
INNER JOIN catalog_product_website AS pw
ON pw.product_id=cp.product_id AND pw.website_id=1
INNER JOIN catalog_product_entity_int AS `t_v_default`
ON (t_v_default.entity_id = cp.product_id)
AND (t_v_default.attribute_id=’85’)
AND t_v_default.store_id=0
LEFT JOIN catalog_product_entity_int AS `t_v`
ON (t_v.entity_id = cp.product_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 = cp.product_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 = cp.product_id)
AND (t_s.attribute_id=’80’)
AND (t_s.store_id=’1’)
WHERE category_id IN(
SELECT entity_id FROM catalog_category_entity
WHERE entity_id = 153 OR path LIKE ‘1/2/152/153/%’)
AND (IFNULL(t_s.value, t_s_default.value)=1)
AND cp.product_id IN (’7’)
GROUP BY product_id
ORDER BY is_parent desc
7 Query DELETE FROM `catalog_category_product_index` WHERE (category_id=154 AND store_id=1 AND product_id IN (’7’))
7 Query INSERT INTO catalog_category_product_index
(`category_id`, `product_id`, `position`, `is_parent`, `store_id`, `visibility`)
SELECT
154,
cp.product_id,
cp.position,
154=cp.category_id as is_parent,
1,
IFNULL(t_v.value, t_v_default.value)
FROM
catalog_category_product AS cp
INNER JOIN catalog_product_website AS pw
ON pw.product_id=cp.product_id AND pw.website_id=1
INNER JOIN catalog_product_entity_int AS `t_v_default`
ON (t_v_default.entity_id = cp.product_id)
AND (t_v_default.attribute_id=’85’)
AND t_v_default.store_id=0
LEFT JOIN catalog_product_entity_int AS `t_v`
ON (t_v.entity_id = cp.product_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 = cp.product_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 = cp.product_id)
AND (t_s.attribute_id=’80’)
AND (t_s.store_id=’1’)
WHERE category_id IN(
SELECT entity_id FROM catalog_category_entity
WHERE entity_id = 154 OR path LIKE ‘1/2/152/153/154/%’)
AND (IFNULL(t_s.value, t_s_default.value)=1)
AND cp.product_id IN (’7’)
GROUP BY product_id
ORDER BY is_parent desc
7 Query DELETE FROM `catalog_product_enabled_index` WHERE (product_id=7 AND store_id=1)
7 Query INSERT INTO catalog_product_enabled_index
SELECT
7, 1, IFNULL(t_v.value, t_v_default.value)
FROM
catalog_product_entity_int AS t_v_default
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.entity_id=7
AND t_v_default.attribute_id=’85’ AND t_v_default.store_id=0
AND (IFNULL(t_s.value, t_s_default.value)=1)
7 Query INSERT INTO `catalog_product_entity_media_gallery` (`entity_id`, `attribute_id`, `value`) VALUES (’7’, ‘73’, ‘/1/A/1AALIPGSPH10000_8.gif’)
7 Query DELETE FROM `catalog_product_entity_media_gallery_value` WHERE (value_id = 1 AND store_id = 0)
7 Query INSERT INTO `catalog_product_entity_media_gallery_value` (`value_id`, `label`, `position`, `disabled`, `store_id`) VALUES (’1’, ‘’, ‘1’, ‘0’, ‘0’)
7 Query DELETE FROM `catalog_product_entity_tier_price` WHERE (entity_id=’7’)
090420 11:57:24 7 Query SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (eav_entity_type.entity_type_code=’catalog_category’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’is_active’) AND (entity_type_id=’3’)
7 Query SELECT `main_table`.`entity_id`, `main_table`.`parent_id`, IFNULL(c.value, d.value) AS `is_active`, `main_table`.`path` FROM `catalog_category_entity` AS `main_table`
LEFT JOIN `catalog_category_entity_int` AS `d` ON d.attribute_id = ‘32’ AND d.store_id = 0 AND d.entity_id = main_table.entity_id
LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = ‘32’ AND c.store_id = ‘’ AND c.entity_id = main_table.entity_id WHERE (main_table.entity_id IN(’2’))
7 Query SELECT `e`.`entity_id`, `e`.`category_ids` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_website` AS `w` ON e.entity_id=w.product_id AND w.website_id=’1’ WHERE (e.entity_id>0) AND (e.entity_id IN(’7’)) ORDER BY `e`.`entity_id` ASC LIMIT 250
7 Query SELECT `t1`.`entity_id`, IFNULL(t2.value, t1.value) AS `value` FROM `catalog_product_entity_varchar` AS `t1`
LEFT JOIN `catalog_product_entity_varchar` AS `t2` ON t1.entity_id = t2.entity_id AND t1.attribute_id = t2.attribute_id AND t2.store_id=’1’ WHERE (t1.store_id = 0) AND (t1.attribute_id = ‘56’) AND (t1.entity_id IN(7))
7 Query SELECT `catalog_product_entity_varchar`.`entity_id`, `catalog_product_entity_varchar`.`value` FROM `catalog_product_entity_varchar` WHERE (attribute_id = ‘82’) AND (store_id=0) AND (entity_id IN(7))
7 Query SELECT `t1`.`entity_id`, IFNULL(t2.value, t1.value) AS `value` FROM `catalog_product_entity_varchar` AS `t1`
LEFT JOIN `catalog_product_entity_varchar` AS `t2` ON t1.entity_id = t2.entity_id AND t1.attribute_id = t2.attribute_id AND t2.store_id=’1’ WHERE (t1.store_id = 0) AND (t1.attribute_id = ‘83’) AND (t1.entity_id IN(7))
7 Query SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (eav_entity_type.entity_type_code=’catalog_category’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’is_active’) AND (entity_type_id=’3’)
7 Query SELECT `main_table`.`entity_id`, `main_table`.`parent_id`, IFNULL(c.value, d.value) AS `is_active`, `main_table`.`path` FROM `catalog_category_entity` AS `main_table`
LEFT JOIN `catalog_category_entity_int` AS `d` ON d.attribute_id = ‘32’ AND d.store_id = 0 AND d.entity_id = main_table.entity_id
LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = ‘32’ AND c.store_id = ‘1’ AND c.entity_id = main_table.entity_id WHERE (main_table.entity_id IN(’154’))
7 Query SELECT `t1`.`entity_id`, IFNULL(t2.value, t1.value) AS `value` FROM `catalog_category_entity_varchar` AS `t1`
LEFT JOIN `catalog_category_entity_varchar` AS `t2` ON t1.entity_id = t2.entity_id AND t1.attribute_id = t2.attribute_id AND t2.store_id=’1’ WHERE (t1.store_id = 0) AND (t1.attribute_id = ‘31’) AND (t1.entity_id IN(154))
7 Query SELECT `catalog_category_entity_varchar`.`entity_id`, `catalog_category_entity_varchar`.`value` FROM `catalog_category_entity_varchar` WHERE (attribute_id = ‘33’) AND (store_id=0) AND (entity_id IN(154))
7 Query SELECT `t1`.`entity_id`, IFNULL(t2.value, t1.value) AS `value` FROM `catalog_category_entity_varchar` AS `t1`
LEFT JOIN `catalog_category_entity_varchar` AS `t2` ON t1.entity_id = t2.entity_id AND t1.attribute_id = t2.attribute_id AND t2.store_id=’1’ WHERE (t1.store_id = 0) AND (t1.attribute_id = ‘47’) AND (t1.entity_id IN(154))
7 Query SELECT `core_url_rewrite`.* FROM `core_url_rewrite` WHERE (store_id=’1’) AND (is_system=1) AND (product_id IN(’7’))
7 Query SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (eav_entity_type.entity_type_code=’catalog_category’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’is_active’) AND (entity_type_id=’3’)
7 Query SELECT `main_table`.`entity_id`, `main_table`.`parent_id`, IFNULL(c.value, d.value) AS `is_active`, `main_table`.`path` FROM `catalog_category_entity` AS `main_table`
LEFT JOIN `catalog_category_entity_int` AS `d` ON d.attribute_id = ‘32’ AND d.store_id = 0 AND d.entity_id = main_table.entity_id
LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = ‘32’ AND c.store_id = ‘1’ AND c.entity_id = main_table.entity_id WHERE (main_table.entity_id IN(’2’))
7 Query SELECT `t1`.`entity_id`, IFNULL(t2.value, t1.value) AS `value` FROM `catalog_category_entity_varchar` AS `t1`
LEFT JOIN `catalog_category_entity_varchar` AS `t2` ON t1.entity_id = t2.entity_id AND t1.attribute_id = t2.attribute_id AND t2.store_id=’1’ WHERE (t1.store_id = 0) AND (t1.attribute_id = ‘31’) AND (t1.entity_id IN(2))
7 Query SELECT `catalog_category_entity_varchar`.`entity_id`, `catalog_category_entity_varchar`.`value` FROM `catalog_category_entity_varchar` WHERE (attribute_id = ‘33’) AND (store_id=0) AND (entity_id IN(2))
7 Query SELECT `t1`.`entity_id`, IFNULL(t2.value, t1.value) AS `value` FROM `catalog_category_entity_varchar` AS `t1`
LEFT JOIN `catalog_category_entity_varchar` AS `t2` ON t1.entity_id = t2.entity_id AND t1.attribute_id = t2.attribute_id AND t2.store_id=’1’ WHERE (t1.store_id = 0) AND (t1.attribute_id = ‘47’) AND (t1.entity_id IN(2))
7 Query SELECT `core_url_rewrite`.* FROM `core_url_rewrite` WHERE (store_id=’1’) AND (request_path=’skate-shop/accessories/hardware/alien-1-phillips-hardware-single-set.html’)
7 Query INSERT INTO `core_url_rewrite` (`store_id`, `category_id`, `product_id`, `id_path`, `request_path`, `target_path`, `is_system`) VALUES (’1’, ‘154’, ‘7’, ‘product/7/154’, ‘skate-shop/accessories/hardware/alien-1-phillips-hardware-single-set.html’, ‘catalog/product/view/id/7/category/154’, ‘1’)
7 Query SELECT `core_url_rewrite`.* FROM `core_url_rewrite` WHERE (store_id=’1’) AND (request_path=’alien-1-phillips-hardware-single-set.html’)
7 Query INSERT INTO `core_url_rewrite` (`store_id`, `category_id`, `product_id`, `id_path`, `request_path`, `target_path`, `is_system`) VALUES (’1’, NULL, ‘7’, ‘product/7’, ‘alien-1-phillips-hardware-single-set.html’, ‘catalog/product/view/id/7’, ‘1’)
7 Query SELECT `catalog_product_entity_varchar`.* FROM `catalog_product_entity_varchar` WHERE (entity_type_id=’4’) AND (attribute_id=’83’) AND (store_id=0) AND (entity_id=’7’)
7 Query INSERT INTO `catalog_product_entity_varchar` (`entity_type_id`, `attribute_id`, `store_id`, `entity_id`, `value`) VALUES (’4’, ‘83’, ‘0’, ‘7’, ‘alien-1-phillips-hardware-single-set.html’)
090420 11:57:26 7 Query DELETE FROM `catalogsearch_fulltext` WHERE (store_id=’1’) AND (product_id IN(’7’))
7 Query SELECT `eav_attribute`.`attribute_code` FROM `eav_attribute` WHERE (entity_type_id=’4’) AND (is_searchable=1)
7 Query SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`sku` 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’ WHERE (e.entity_id IN(’7’)) AND (e.entity_id>0) ORDER BY `e`.`entity_id` ASC LIMIT 100
7 Query (SELECT `t_default`.`entity_id`, `t_default`.`attribute_id`, IFNULL(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=’1’ WHERE (t_default.store_id=0) AND (t_default.attribute_id IN(76, 66, 491, 80, 81, 85)) AND (t_default.entity_id IN(’7’)))UNION(SELECT `t_default`.`entity_id`, `t_default`.`attribute_id`, IFNULL(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=’1’ WHERE (t_default.store_id=0) AND (t_default.attribute_id IN(56)) AND (t_default.entity_id IN(’7’)))UNION(SELECT `t_default`.`entity_id`, `t_default`.`attribute_id`, IFNULL(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=’1’ WHERE (t_default.store_id=0) AND (t_default.attribute_id IN(57, 58)) AND (t_default.entity_id IN(’7’)))
7 Query SELECT `main_table`.*, `store_default_value`.`value` AS `default_value`, `store_value`.`value` AS `store_value`, IFNULL(store_value.value,store_default_value.value) AS `value` FROM `eav_attribute_option` AS `main_table`
INNER JOIN `eav_attribute_option_value` AS `store_default_value` ON store_default_value.option_id=main_table.option_id
LEFT JOIN `eav_attribute_option_value` AS `store_value` ON store_value.option_id=main_table.option_id AND store_value.store_id=’default’ WHERE (main_table.attribute_id=’66’) AND (store_default_value.store_id=0) ORDER BY main_table.sort_order ASC, store_default_value.value ASC, main_table.sort_order ASC, store_default_value.value ASC
090420 11:57:27 7 Query SELECT `main_table`.* FROM `tax_class` AS `main_table` WHERE (class_type = ‘PRODUCT’)
7 Query REPLACE INTO `catalogsearch_fulltext` VALUES(7,’1’,’1AALIPGSPH10000 Alien Workshop Enabled Taxable Goods Alien 1\\\” Phillips Hardware Single Set Alien 1\\\” Phillips Hardware Single Set Alien 1\\\” Phillips Hardware Single Set’)
7 Query SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`sku` 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’ WHERE (e.entity_id IN(’7’)) AND (e.entity_id>’7’) ORDER BY `e`.`entity_id` ASC LIMIT 100
7 Query UPDATE `catalogsearch_query` SET `is_processed` = ‘0’
7 Query TRUNCATE TABLE catalogsearch_result
7 Query SELECT `tags`.`tag_code`, `tags`.`tag_id` FROM `catalogindex_aggregation_tag` AS `tags` WHERE (tags.tag_code IN (’SEARCH_QUERY’))
7 Query DELETE FROM `catalogindex_aggregation` WHERE (aggregation_id IN (SELECT `catalogindex_aggregation_to_tag`.`aggregation_id` FROM `catalogindex_aggregation_to_tag` WHERE (tag_id IN (’73’))))
7 Query UPDATE `catalogsearch_query` SET `is_processed` = ‘0’
7 Query TRUNCATE TABLE catalogsearch_result
7 Query SELECT `tags`.`tag_code`, `tags`.`tag_id` FROM `catalogindex_aggregation_tag` AS `tags` WHERE (tags.tag_code IN (’SEARCH_QUERY’))
7 Query DELETE FROM `catalogindex_aggregation` WHERE (aggregation_id IN (SELECT `catalogindex_aggregation_to_tag`.`aggregation_id` FROM `catalogindex_aggregation_to_tag` WHERE (tag_id IN (’73’))))
7 Query SELECT `e`.`entity_id`, `e`.`type_id` FROM `catalog_product_entity` AS `e` WHERE (entity_id IN(’7’))
7 Query 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=’7’) AND (stock_id=1)
7 Query SELECT `website_table`.`website_id`, IFNULL(`store_group_table`.`default_store_id`, 0) AS `store_id` FROM `core_website` AS `website_table`
LEFT JOIN `core_store_group` AS `store_group_table` ON `website_table`.`website_id`=`store_group_table`.`website_id` AND `website_table`.`default_group_id`=`store_group_table`.`group_id` WHERE (`website_table`.`website_id` <> 0)
090420 11:57:28 7 Query SELECT `cataloginventory_stock_status`.* FROM `cataloginventory_stock_status` WHERE (product_id=’7’) AND (website_id=1) AND (stock_id=1)
7 Query INSERT INTO `cataloginventory_stock_status` (`product_id`, `website_id`, `stock_id`, `qty`, `stock_status`) VALUES (’7’, ‘1’, ‘1’, ‘0’, ‘1’)
7 Query SELECT `catalog_product_link`.`product_id`, `catalog_product_link`.`linked_product_id` FROM `catalog_product_link` WHERE (linked_product_id=’7’) AND (link_type_id=3)
7 Query SELECT `catalog_product_super_link`.`product_id`, `catalog_product_super_link`.`parent_id` FROM `catalog_product_super_link` WHERE (product_id=’7’)
7 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`=’7’)
7 Query SELECT `core_flag`.* FROM `core_flag` WHERE (core_flag.flag_code=’catalogindex’)
7 Query SELECT `g`.`product_id` FROM `catalog_product_link` AS `g` WHERE (g.linked_product_id = ‘7’) AND (link_type_id = 3)
7 Query SELECT `c`.`parent_id` FROM `catalog_product_super_link` AS `c` WHERE (c.product_id = ‘7’)
7 Query SELECT `cat`.`path` FROM `catalog_category_entity` AS `cat`
INNER JOIN `catalog_category_product` AS `cat_prod` ON cat.entity_id=cat_prod.category_id AND cat_prod.product_id IN (’7’)
7 Query SELECT `tags`.`tag_code`, `tags`.`tag_id` FROM `catalogindex_aggregation_tag` AS `tags` WHERE (tags.tag_code IN (’catalog_category1’, ‘catalog_category2’, ‘catalog_category152’, ‘catalog_category153’, ‘catalog_category154’))
7 Query DELETE FROM `catalogindex_aggregation` WHERE (aggregation_id IN (SELECT `catalogindex_aggregation_to_tag`.`aggregation_id` FROM `catalogindex_aggregation_to_tag` WHERE (tag_id IN (’1’, ‘154’, ‘155’, ‘156’, ‘153’))))
7 Query COMMIT
7 Query 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=’7’) AND (stock_id=1)
7 Query START TRANSACTION
7 Query SELECT `e`.`entity_id`, `e`.`type_id` FROM `catalog_product_entity` AS `e` WHERE (entity_id IN(’7’))
7 Query SELECT `cataloginventory_stock_status`.* FROM `cataloginventory_stock_status` WHERE (product_id=’7’) AND (website_id=1) AND (stock_id=1)
7 Query UPDATE `cataloginventory_stock_status` SET `qty` = ‘0’, `stock_status` = ‘1’ WHERE (product_id=’7’) AND (website_id=’1’) AND (stock_id=’1’)
7 Query SELECT `catalog_product_link`.`product_id`, `catalog_product_link`.`linked_product_id` FROM `catalog_product_link` WHERE (linked_product_id=’7’) AND (link_type_id=3)
7 Query SELECT `catalog_product_super_link`.`product_id`, `catalog_product_super_link`.`parent_id` FROM `catalog_product_super_link` WHERE (product_id=’7’)
7 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`=’7’)
7 Query DESCRIBE `cataloginventory_stock_item`
7 Query INSERT INTO `cataloginventory_stock_item` (`product_id`, `stock_id`, `qty`, `is_in_stock`) VALUES (’7’, ‘1’, ‘0.000000’, ‘1’)
7 Query COMMIT
090420 11:57:47 7 Quit
8 Quit

It takes about 5-6 seconds to do that,.  What can i do to reduce the queries or speed it up.  Can you actually get a server that can handle this kind of load in a speedy manner?
Any info is appreciated. Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top