Array ( [e] => Array ( [joinType] => from [schema] => [tableName] => catalog_product_entity [joinCondition] => ) [price_index] => Array ( [joinType] => inner join [schema] => [tableName] => catalog_product_index_price [joinCondition] => price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 AND ((price_index.currency IS NULL) OR (price_index.currency = 'USD')) ) [cat_index] => Array ( [joinType] => inner join [schema] => [tableName] => catalog_category_product_index [joinCondition] => cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(3, 4) AND cat_index.category_id = '2' ) )