title: CakePHP repeats same queries
body: <p>I have a model structure: Category hasMany Product hasMany Stockitem belongsTo Warehouse, Manufacturer.</p>
  
  <p>I fetch data with this code, using containable to be able to filter deeper in the associated models:</p>
  
  <pre><code>$this-&gt;Category-&gt;find('all', array(
          'conditions' =&gt; array('Category.id' =&gt; $category_id),
          'contain' =&gt; array(
              'Product' =&gt; array(
                  'Stockitem' =&gt; array(
                      'conditions' =&gt; array('Stockitem.warehouse_id' =&gt; $warehouse_id),
                      'Warehouse',
                      'Manufacturer',
                  )
              )
          ),
          )
      );
  </code></pre>
  
  <p>Data structure is returned just fine, however, I get multiple repeating queries like, sometimes hundreds of such queries in a row, based on dataset.</p>
  
  <pre><code>SELECT `Warehouse`.`id`, `Warehouse`.`title` FROM `beta_warehouses` AS `Warehouse` WHERE `Warehouse`.`id` = 2
  </code></pre>
  
  <p>Basically, when building data structure Cake is fetching data from mysql over and over again, for each row. We have datasets of several thousand rows, and I have a feeling that it's going to impact performance. Is it possible to make it cache results and not repeat same queries?</p>