title: Very slow product list issue with magento
body: <p>I have a category called <strong>new arrivals</strong> which has 5 subcategories. I created a custom view called new-arrivals.phtml. I created custom Static Block with the following code in magento </p>
  
  <pre><code>{{block type="core/template" template="custom/new-arrivals.phtml"}}
  </code></pre>
  
  <p>then from Category setting I changed the display setting>CMS Block to the this cms block that I created. And the <strong>display mode</strong> is <strong>static block only</strong></p>
  
  <p>This view bring all the subcategories of New Arrivals(Bags, Tops, Shoes etc..) with it's products.. <a href="http://www.gojane.com/new-styles.html" rel="nofollow">Like on this website</a>   As you can see on this website it is very fast but on my website with my code it is not. <a href="https://www.punkyfish.com/new-arrivals.html" rel="nofollow">Here it is...</a></p>
  
  <p>How can I make this load faster. Cache and everything is enabled. I assume that there is something wrong with my code. thank you for your help.</p>
  
  <p>and this is new-arrivals.phtml content:</p>
  
  <p>Magento CE 1.8.1</p>
  
  <pre><code>&lt;?php
              //I load all the subcategories here
              $category = Mage::getSingleton('catalog/layer')-&gt;getCurrentCategory();
              $categories = $category-&gt;getCollection()
                      -&gt;addAttributeToSelect(array('name', 'thumbnail'))
                      -&gt;addAttributeToFilter('is_active', 1)
                      -&gt;addIdFilter($category-&gt;getChildren())
              ?&gt;
  
                  &lt;?php foreach ($categories as $category): ?&gt;
                      &lt;div class="page-title category-title"&gt;
                          &lt;h1&gt;
                              &lt;a href="&lt;?php echo $category-&gt;getUrl() ?&gt;"&gt;
                              &lt;span&gt;&lt;?php echo $category-&gt;getName() ?&gt;&lt;/span&gt;
                              &lt;/a&gt;
                          &lt;/h1&gt;
                          &lt;?php
                              // here I load all the products for each category      
                              $_helper = $this-&gt;helper('catalog/output');                  
                              $category = Mage::getModel('catalog/category')-&gt;load($category-&gt;getId());
                              $_productCollection = $category-&gt;getProductCollection()-&gt;addCategoryFilter($category)
                              -&gt;addAttributeToSelect('*') // add all attributes - optional
                              -&gt;addAttributeToFilter('status', 1) // enabled
                              -&gt;addAttributeToFilter('visibility', 4) //visibility in catalog,search
                              -&gt;addAttributeToSort('date_added', 'ASC');
  
                          ?&gt;
                           &lt;div class="product-count"&gt;&lt;?php echo $count; ?&gt; &lt;?php echo $this-&gt;__('Products'); ?&gt;&lt;/div&gt;
              &lt;?php if(!$_productCollection-&gt;count()): ?&gt;
              &lt;p class="note-msg"&gt;&lt;?php echo $this-&gt;__('There are no products matching the selection.') ?&gt;&lt;/p&gt;
              &lt;?php else: ?&gt;
              &lt;div class="category-products"&gt;    
  
  
                  &lt;?php // Grid Mode ?&gt;
                  &lt;?php
                      $_span = 'span3';
                      $_grid_pro = 4;
                  ?&gt;
  
                  &lt;?php $_collectionSize = $_productCollection-&gt;count() ?&gt;
                  &lt;?php $_columnCount = $_grid_pro; //$this-&gt;getColumnCount(); ?&gt;
                  &lt;?php $i=0; foreach ($_productCollection as $_product): ?&gt;
                      &lt;?php if ($i++%$_columnCount==0): ?&gt;
  &lt;?php // all the others stuff ....... ?&gt;
  </code></pre>