CAllPerfomanceSQL::Format

static function Format($strSql)
{
	$strSql = preg_replace("/[\n\r\t\s ]+/", " ", $strSql);
	$strSql = preg_replace("/^ +/", "", $strSql);
	$strSql = preg_replace("/ (INNER JOIN|OUTER JOIN|LEFT JOIN|SET|LIMIT) /i", "n\1 ", $strSql);
	$strSql = preg_replace("/(INSERT INTO [A-Z_0-1]+?)\s/i", "\1n", $strSql);
	$strSql = preg_replace("/(INSERT INTO [A-Z_0-1]+?)([(])/i", "\1n\2", $strSql);
	$strSql = preg_replace("/([\s)])(VALUES)([\s(])/i", "\1n\2n\3", $strSql);
	$strSql = preg_replace("/ (FROM|WHERE|ORDER BY|GROUP BY|HAVING) /i", "n\1n", $strSql);
	$arMatch = array();

	if (preg_match("/.*WHERE(.+)\s(ORDER BY|GROUP BY|HAVING|$)/is", $strSql." ", $arMatch))
	{
		$strWhere = $arMatch[1];
		$len = mb_strlen($strWhere);
		$res = "";
		$group = 0;
		for ($i = 0; $i < $len; $i++)
		{
			$char = mb_substr($strWhere, $i, 1);
			if ($char == "(")
				$group++;
			elseif ($char == ")")
				$group--;
			elseif ($group == 0)
			{
				$match = array();
				if (preg_match("/^(\s)(AND|OR|NOT)([\s(])/is", mb_substr($strWhere, $i), $match))
				{
					$char = "n    ".$match[2];
					$i += mb_strlen($match[1].$match[2]) - 1;
				}
			}
			$res .= $char;
		}
		$strSql = str_replace($arMatch[1], $res, $strSql);
	}

	if (preg_match("/.*?SELECT(.+)\s(FROM)/is", $strSql." ", $arMatch))
	{
		$strWhere = $arMatch[1];
		$len = mb_strlen($strWhere);
		$res = "";
		$group = 0;
		for ($i = 0; $i < $len; $i++)
		{
			$char = mb_substr($strWhere, $i, 1);
			if ($char == "(")
				$group++;
			elseif ($char == ")")
				$group--;
			elseif ($group == 0 && $char == ",")
			{
				$char = "n    ".$char;
			}
			$res .= $char;
		}
		$strSql = str_replace($arMatch[1], $res, $strSql);
	}

	if (preg_match("/.*?UPDATE\s.+?\sSET\s(.+?)WHERE/is", $strSql." ", $arMatch))
	{
		$strWhere = $arMatch[1];
		$len = mb_strlen($strWhere);
		$res = "";
		$group = 0;
		for ($i = 0; $i < $len; $i++)
		{
			$char = mb_substr($strWhere, $i, 1);
			if ($char == "(")
				$group++;
			elseif ($char == ")")
				$group--;
			elseif ($group == 0 && $char == ",")
			{
				$char = "n    ".$char;
			}
			$res .= $char;
		}
		$strSql = str_replace($arMatch[1], $res, $strSql);
	}
	return $strSql;
}