tiarraMetroの初回ロードのクロスクエリを廃止して、メモリサイズオーバー対策の為に個別にループ化したもの

dao.php.part

    function getUnreadList( $server = "", $sort = 0 ){
        $sql = "SELECT
                    channel.id,
                    channel.name,
                    substring(channel.name, locate('@', channel.name) + 1) as network
                FROM channel
                WHERE view = ?";
        $values = array(1);

        if( !empty($server) ){
            $sql .= " WHERE name like ? ";
            $values[] = "%@".$server;
        }

        $order = $this->detectOrder($sort);
        if (!empty($order)) {
            $sql .= $order;
        }
        $list = $this->_conn->getArray($this->_conn->Prepare($sql), $values);

        foreach( $list as $key => $c ){
            $sql = "SELECT
                        count(*) as cnt
                    FROM channel
                        LEFT JOIN log ON channel.id = log.channel_id
                    WHERE channel.readed_on < log.created_on
                        && channel.id = ".$c['id'];

            $list[ $key ][ 'cnt' ] = $this->_conn->GetOne( $sql );
        }

        return $list;
    }