"Back"

SQL Explain

Executed SQL
SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `links`.`link_id`, `link_attribute_position_int`.`value` AS `position` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 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(2, 4) AND cat_index.category_id = '2' INNER JOIN `catalog_product_link` AS `links` ON links.linked_product_id = e.entity_id AND links.link_type_id = 4 LEFT JOIN `catalog_product_link_attribute_int` AS `link_attribute_position_int` ON link_attribute_position_int.link_id = links.link_id AND link_attribute_position_int.product_link_attribute_id = '4' WHERE (e.entity_id NOT IN((SELECT `sales_flat_quote_item`.`product_id` FROM `sales_flat_quote_item` WHERE (quote_id = '')))) AND (links.product_id = 337) AND (`e`.`entity_id` != '337') ORDER BY `position` ASC LIMIT 10
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY links ref UNQ_CAT_PRD_LNK_LNK_TYPE_ID_PRD_ID_LNKED_PRD_ID,IDX_CATALOG_PRODUCT_LINK_PRODUCT_ID,IDX_CATALOG_PRODUCT_LINK_LINKED_PRODUCT_ID,IDX_CATALOG_PRODUCT_LINK_LINK_TYPE_ID IDX_CATALOG_PRODUCT_LINK_PRODUCT_ID 4 const 1 Using where; Using temporary; Using filesort
1 PRIMARY link_attribute_position_int ref UNQ_CAT_PRD_LNK_ATTR_INT_PRD_LNK_ATTR_ID_LNK_ID,IDX_CATALOG_PRODUCT_LINK_ATTRIBUTE_INT_PRODUCT_LINK_ATTRIBUTE_ID,IDX_CATALOG_PRODUCT_LINK_ATTRIBUTE_INT_LINK_ID UNQ_CAT_PRD_LNK_ATTR_INT_PRD_LNK_ATTR_ID_LNK_ID 7 const,lalacurio_magn.links.link_id 1
1 PRIMARY cat_index eq_ref PRIMARY,IDX_CAT_CTGR_PRD_IDX_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY,15D3C269665C74C2219037D534F4B0DC PRIMARY 10 const,lalacurio_magn.links.linked_product_id,const 1 Using where
1 PRIMARY e eq_ref PRIMARY PRIMARY 4 lalacurio_magn.links.linked_product_id 1
1 PRIMARY price_index eq_ref PRIMARY,IDX_CATALOG_PRODUCT_INDEX_PRICE_CUSTOMER_GROUP_ID,IDX_CATALOG_PRODUCT_INDEX_PRICE_WEBSITE_ID,IDX_CAT_PRD_IDX_PRICE_WS_ID_CSTR_GROUP_ID_MIN_PRICE PRIMARY 8 lalacurio_magn.links.linked_product_id,const,const 1
2 DEPENDENT SUBQUERY sales_flat_quote_item ref IDX_SALES_FLAT_QUOTE_ITEM_PRODUCT_ID,IDX_SALES_FLAT_QUOTE_ITEM_QUOTE_ID IDX_SALES_FLAT_QUOTE_ITEM_QUOTE_ID 4 const 1 Using where