if ($rs = $this->db->query($query)) {
                $total = $this->db->query("SELECT FOUND_ROWS() AS total"); 
                $total = $total->fetch_assoc(); 
                
                $return = array();