Magento getModel ('catalog / product') & # 8594; getCollection () with addAttributeToSelect ('*') returning no description

Magento does not initially load all attributes when using a model collection, for example

$collections = Mage::getModel('catalog/product')->getCollection(); 

      

        
        
        
      

    

Select a table

SELECT `e`.* FROM `catalog_product_entity` AS `e`

      

        
        
        
      

    

Magento using tables orm. If we dig more into this,

foreach($collections as $collection) {
    echo $collection->getName();
}

      

        
        
        
      

    

Now you can see how additional requests will be executed.

For more information go here

But you can get the entire collection of product details from a flat table without querying a lot of time in the database. To do this, you need to enable the plane in admin-> system->configuration ->catalog->catalog-> Front end->

Here you can see options for enabling the flat catalog

Use Flat Catalog Category -> Enable
Use Flat Catalog Product  -> Enable

      

        
        
        
      

    

For more information on the flat directory, please go here .

So now you see a query that he will like,

> SELECT 1 AS

status

,e



... entity_id

,e



... type_id

,e



... attribute_set_id

,e



... entity_id

,e



... attribute_set_id

e



... type_id

,e



... allow_open_amount

,e



... cost

,e



... created_at

,e



... email_template

,e



... enable_googlecheckout

,e



... giftcard_amounts

,e



... giftcard_type

,e



... gift_message_available

,e



... gift_wrapping_available

,e



... gift_wrapping_price

,e



... has_options

,e



... image_label

,e



... is_recurring

,e



... is_redeemable

,e



... lifetime

,e



... links_exist

,e



... links_purchased_separately

,e



... links_title

e



... msrp

,e



... msrp_display_actual_price_type

,e



... msrp_enabled

,e



... name

,e



... news_from_date

,e



... news_to_date

,e



... open_amount_max

,e



... open_amount_min

,e



... price

,e



... price_type

,e



... price_view

,e



... recurring_profile

,e



... required_options

,e



... shipment_type

,e



... short_description

,e



... sku

,e



... sku_type

,e



... small_image

,e



... small_image_label

,e



... special_from_date

,e



... special_price

,e



... special_to_date

,e



... tax_class_id

,e



... thumbnail

,e



... thumbnail_label

e



... updated_at

,e



... url_key

,e



... url_path

,e



... use_config_email_template

,e



... use_config_is_redeemable

,e



... use_config_lifetime

,e



... visibility

,e



... weight

,e



... weight_type

,e



... necklace_length

,e



... necklace_length_value

FROM catalog_product_flat_1

ASe

But remember that some of the methods are not available in the flat directory, and also when disabled.

Function Name                   Flat Catalog Enabled    Flat Disabled
setLoadProductCount($flag)       No                      Yes
setProductStoreId($storeId)      No                      Yes
addParentPathFilter($parent)     Yes                     No
addStoreFilter()                 Yes                     No
addSortedField($sorted)          Yes                     No