{{{Executed SQL}}{{Executed SQL}}{{Executed SQL}}{{Mage_Core}}}

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`='427') 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