获取codeigniter中所有数据库查询的列表（在ajax请求中）

Question

I'm using codeigniter

now my ajax request its very slow and I want to find the reason

in ajax request, I want to save all DB query in a log file

it's possible?

Answer 1

you can turn on db loging in config file:

$db['default'] = array(
   ...
   'save_queries' => TRUE
   ....
);

then end of ajax request use $queries = $this->db->queries; to get all SQL query

$log .= join("
",$this->db->queries);
$myfile = file_put_contents('logs.txt', $txt.PHP_EOL , FILE_APPEND | LOCK_EX);