• Модуль: crm
  • Путь к файлу: ~/bitrix/modules/crm/lib/volume/base.php
  • Класс: Bitrix\Crm\Volume\Base
  • Вызов: Base::loadTablesInformation
static function loadTablesInformation()
{
	if (empty(self::$tablesInformation))
	{
		$connection = Main\Application::getConnection();

		self::$tablesInformation = array();

		$querySql = "
			SELECT 
				TABLE_NAME, 
				TABLE_ROWS AS TABLE_ROWS, 
				DATA_LENGTH + INDEX_LENGTH AS SIZE, 
				case TABLE_ROWS 
					when 0 then 0 
					else round((DATA_LENGTH + INDEX_LENGTH) / TABLE_ROWS)
				end AS AVG_SIZE
			FROM information_schema.TABLES 
			WHERE 
				TABLE_SCHEMA = '".$connection->getDatabase()."'
				AND (
					TABLE_NAME LIKE 'b_crm_%' OR 
					TABLE_NAME LIKE 'b_uts_crm_%' OR
					TABLE_NAME LIKE 'b_utm_crm_%' OR
					TABLE_NAME LIKE 'b_uts_order' OR
					TABLE_NAME LIKE 'b_utm_order'
				)
		";
		$result = $connection->query($querySql);
		while ($row = $result->fetch())
		{
			self::$tablesInformation[mb_strtolower($row['TABLE_NAME'])] = $row;
		}
	}
}