select t.type_name,p.* from product p inner join product_tree t on p.type_id = t.type_id where product_id = 0283