title: cakephp see the compiled SQL Query before execution
body: <p>My query gets the timeout error on each run. Its a pagination with joins.<br>
  I want to debug the SQL, but since I get a timeout, I can't see it.</p>
  
  <p>How can I see the compiled SQL Query before execution?</p>
  
  <hr>
  
  <p>Some cake code:</p>
  
  <pre><code>$this -&gt; paginate = array(
          'limit' =&gt; '16',
          'joins' =&gt; array( array(
                  'table' =&gt; 'products',
                  'alias' =&gt; 'Product',
                  'type' =&gt; 'LEFT',
                  'conditions' =&gt; array('ProductModel.id = Product.product_model_id')
              )),
          'fields' =&gt; array(
              'COUNT(Product.product_model_id) as Counter',
              'ProductModel.name'
              ),
          'conditions' =&gt; array(
              'ProductModel.category_id' =&gt; $category_id,
          ),
          'group' =&gt; array('ProductModel.id')
      );
  </code></pre>