Instances of Phalcon\Db can generate execution profiles on SQL statements sent to the relational database. Profiled information includes execution time in miliseconds. This helps you to identify bottlenecks in your applications.
$profiler = new Phalcon\Db\Profiler(); //Set the connection profiler $connection->setProfiler($profiler); $sql = "SELECT buyer_name, quantity, product_name FROM buyers LEFT JOIN products ON buyers.pid=products.id"; //Execute a SQL statement $connection->query($sql); //Get the last profile in the profiler $profile = $profiler->getLastProfile(); echo "SQL Statement: ", $profile->getSQLStatement(), "\n"; echo "Start Time: ", $profile->getInitialTime(), "\n"; echo "Final Time: ", $profile->getFinalTime(), "\n"; echo "Total Elapsed Time: ", $profile->getTotalElapsedSeconds(), "\n";
Starts the profile of a SQL sentence
Stops the active profile
Returns the total number of SQL statements processed
Returns the total time in seconds spent by the profiles
Returns all the processed profiles
Resets the profiler, cleaning up all the profiles
Returns the last profile executed in the profiler
© 2011–2016 Phalcon Framework Team
Licensed under the Creative Commons Attribution License 3.0.