public function searchInfo() { $record_count = new Expression('count(id)'); $start = new Expression("left(column_get(blob_data,'load_date' as datetime),16)"); // $end = new Expression("column_get(blob_data,'load_date' as datetime)"); $query = parent::find()->addSelect(['record_count' => $record_count, 'start' => $start])->groupBy('start'); $ret = $query->all(); // var_dump($ret);die; // $dataProvider = new ActiveDataProvider([ // 'query' => $query, // 'pagination'=>false, // ]); $return['labels'] = ArrayHelper::getColumn($ret, 'start'); $return['data'] = ArrayHelper::getColumn($ret, 'record_count'); // $return['cpu']=shell_exec('rrdtool fetch /var/lib/munin/localhost/localhost-mysql_bytes-recv-d.rrd AVERAGE -r 1m -s -1h'); // var_dump($return['cpu']);die; return $return; }