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`='474') AND (stock_id = :stock_id)

item_id	product_id	stock_id	qty	min_qty	use_config_min_qty	is_qty_decimal	backorders	use_config_backorders	min_sale_qty	use_config_min_sale_qty	max_sale_qty	use_config_max_sale_qty	is_in_stock	low_stock_date	notify_stock_qty	use_config_notify_stock_qty	manage_stock	use_config_manage_stock	stock_status_changed_auto	use_config_qty_increments	qty_increments	use_config_enable_qty_inc	enable_qty_increments	is_decimal_divided	type_id
474	474	1	1.0000	0.0000	1	0	0	1	1.0000	1	0.0000	1	0		0.0000	1	0	1	0	1	0.0000	1	0	0	simple