Codeigniter自动将字段添加到order

我想通过查询获得大多数视图:

        $this->db->select("a.pid, a.title, a.pic, a.date_created, d.view as post_view");
        $this->db->from("posts as a");
        $this->db->join('views as d', 'd.post_id=a.pid');  
        $this->db->join('cats as b', 'b.catid=a.catid'); //ensure Cat existed
        $this->db->where("a.block", 0);
        $this->db->order_by("d.view", "desc");
        $this->db->limit(5);
        $query = $this->db->get();
        return $query->result();

pid asc公司 从未 订单描述 d、 查看 字段。我尝试打印查询字符串,这里是:

SELECT `a`.`pid`, `a`.`title`, `a`.`pic`, `a`.`date_created`, `d`.`view` as `post_view` FROM `posts` as `a` JOIN `views` as `d` ON `d`.`post_id`=`a`.`pid` JOIN `cats` as `b` ON `b`.`catid`=`a`.`catid` WHERE `a`.`block` =0 ORDER BY `pid` asc, `d`.`view` DESC LIMIT 5

有什么建议吗?(CI版本3.*)