"Back"

SQL Explain

Executed SQL
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`='464') AND (stock_id = :stock_id)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cataloginventory_stock_item const UNQ_CATALOGINVENTORY_STOCK_ITEM_PRODUCT_ID_STOCK_ID,IDX_CATALOGINVENTORY_STOCK_ITEM_PRODUCT_ID,IDX_CATALOGINVENTORY_STOCK_ITEM_STOCK_ID UNQ_CATALOGINVENTORY_STOCK_ITEM_PRODUCT_ID_STOCK_ID 6 const,const 1
1 SIMPLE p const PRIMARY PRIMARY 4 const 1