一、数据库查询

    $map['select']='id, NAME';
    $map['from'] = 'bank_branch bb';
    $map['limit'] = '20';
    $map['like'] =  array('NAME',$keyword) ;
    //$map['like'] = array('a.cname',$this->input->get('cname'));
    $list['list'] = $this->User_model->selectAllList($map);
    $sqll = $this->db->last_query();

获取最后一次执行的sql语句：

$sqll = $this->db->last_query();
print_r($sqll) ;