Submitted by richard on November 7, 2009 - 11:21pm

This one is really short and simple

// load the Solar environment
require 'Solar.php';
Solar::start('/path/to/config/Solar.config.php');

// configure
$config = array(
    'adapter' => 'Solar_Sql_Adapter_Mysql',
    'host'    => '127.0.0.1',
    'user'    => 'username',
    'pass'    => 'password',
    'name'    => 'database_name',
);

// instantiate
$sql = Solar::factory('Solar_Sql', $config);

$sql->setProfiling(TRUE);

// Do a whole lot of SQL

print_r($sql->getProfile());

This prints out a lovely array with all the queries that have been done. Why is this really usefull? Because when using ORM/Model systems the framework builds your queries for you.. This allows you to dig a little deeper, see whats going on, how the queries are being built and were you might need indexes and other changes.