ci_log_query icon indicating copy to clipboard operation
ci_log_query copied to clipboard

Log All Queries with Execution Time for Codeigniter 3.x

CI Query Logger

Log All Queries with Execution Time for Codeigniter 3.x

How to Use

  1. Set the log_threshold to 2 in applications/config/config.php file
$config['log_threshold'] = 2;
or
$config['log_threshold'] = array(2);
  1. Set the enable_hooks to true in applications/config/config.php file
$config['enable_hooks'] = true;
  1. Then Open up your hooks.php file in applications/config folder and add the following code in it
$hook['post_controller'][] = array(
    'class' => 'Log_Query', 
    'function' => 'run',
    'filename' => 'Log_query.php',
    'filepath' => 'hooks'
);
  1. Now add applications/hooks/Log_query.php file in the repository to your codeigniter applications/hooks folder.

Enjoy it!