public static function insertMultiple($tracks) { // build insert multiple data $model = self::model(); $track_sql = "INSERT IGNORE INTO {$model->tableName()} (hash, title, artist_hash, created_at, updated_at) VALUES "; $values_sql = array(); foreach ($tracks as $hash => $track) { $title = Artist::mres($track['title']); $values_sql[] = "('{$hash}', '{$title}', '{$track['artist_hash']}', NOW(), NOW())"; } $track_sql .= implode(', ', $values_sql); return Yii::app()->getDb()->createCommand($track_sql)->execute(); }