CPerfomanceIndexSuggest::GetList

static function GetList($arSelect, $arFilter, $arOrder)
{
	global $DB;

	if (!is_array($arSelect))
		$arSelect = array();
	if (count($arSelect) < 1)
		$arSelect = array(
			"ID",
		);

	if (!is_array($arOrder))
		$arOrder = array();
	if (count($arOrder) < 1)
		$arOrder = array(
			"TABLE_NAME" => "ASC",
		);

	$arQueryOrder = array();
	foreach ($arOrder as $strColumn => $strDirection)
	{
		$strColumn = mb_strtoupper($strColumn);
		$strDirection = mb_strtoupper($strDirection) == "ASC"? "ASC": "DESC";
		switch ($strColumn)
		{
		case "ID":
		case "TABLE_NAME":
		case "SQL_COUNT":
		case "SQL_TIME":
			$arSelect[] = $strColumn;
			$arQueryOrder[$strColumn] = $strColumn." ".$strDirection;
			break;
		}
	}

	$bJoin = false;
	$arQuerySelect = array();
	foreach ($arSelect as $strColumn)
	{
		$strColumn = mb_strtoupper($strColumn);
		switch ($strColumn)
		{
		case "ID":
		case "TABLE_NAME":
		case "TABLE_ALIAS":
		case "COLUMN_NAMES":
		case "SQL_MD5":
		case "SQL_TEXT":
		case "SQL_COUNT":
		case "SQL_TIME":
		case "SQL_EXPLAIN":
			$arQuerySelect[$strColumn] = "s.".$strColumn;
			break;
		case "BANNED":
			$arQuerySelect[$strColumn] = "c.".$strColumn;
			$bJoin = true;
			break;
		}
	}

	$obQueryWhere = new CSQLWhere;
	$obQueryWhere->SetFields(array(
		"ID" => array(
			"TABLE_ALIAS" => "s",
			"FIELD_NAME" => "ID",
			"FIELD_TYPE" => "int", //int, double, file, enum, int, string, date, datetime
			"JOIN" => false,
			//"LEFT_JOIN" => "lt",
		),
		"SQL_MD5" => array(
			"TABLE_ALIAS" => "s",
			"FIELD_NAME" => "s.SQL_MD5",
			"FIELD_TYPE" => "string",
			"JOIN" => false,
		),
		"TABLE_NAME" => array(
			"TABLE_ALIAS" => "s",
			"FIELD_NAME" => "s.TABLE_NAME",
			"FIELD_TYPE" => "string",
			"JOIN" => false,
		),
		"COLUMN_NAMES" => array(
			"TABLE_ALIAS" => "s",
			"FIELD_NAME" => "s.COLUMN_NAMES",
			"FIELD_TYPE" => "string",
			"JOIN" => false,
		),
		"BANNED" => array(
			"TABLE_ALIAS" => "c1",
			"FIELD_NAME" => "c1.BANNED",
			"FIELD_TYPE" => "string",
			"JOIN" => "LEFT JOIN b_perf_index_complete c1 on c1.TABLE_NAME = s.TABLE_NAME and c1.COLUMN_NAMES = s.COLUMN_NAMES",
		),
	));

	if (count($arQuerySelect) < 1)
		$arQuerySelect = array("ID" => "s.ID");

	if (!is_array($arFilter))
		$arFilter = array();
	$strQueryWhere = $obQueryWhere->GetQuery($arFilter);

	$strSql = "
		SELECT ".implode(", ", $arQuerySelect)."
		FROM b_perf_index_suggest s
		".$obQueryWhere->GetJoins()."
		".($bJoin? "LEFT JOIN b_perf_index_complete c on c.TABLE_NAME = s.TABLE_NAME and c.COLUMN_NAMES = s.COLUMN_NAMES": "")."
		".($strQueryWhere? "WHERE ".$strQueryWhere: "")."
		".(count($arQueryOrder)? "ORDER BY ".implode(", ", $arQueryOrder): "")."
	";
	$res = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__);

	return $res;
}