%PDF- %PDF-
Server IP : 37.220.80.31 / Your IP : 18.221.20.159 Web Server : Apache/2.4.52 (Ubuntu) System : Linux 3051455-guretool.twc1.net 5.15.0-107-generic #117-Ubuntu SMP Fri Apr 26 12:26:49 UTC 2024 x86_64 User : www-root ( 1010) PHP Version : 7.4.33 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /var/www/www-root/data/www/dev.artlot24.ru/bitrix/modules/perfmon/classes/general/ |
Upload File : |
<?php class CPerfomanceIndexSuggest { public 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__."<br>Line: ".__LINE__); return $res; } public static function Add($arFields) { global $DB; $ID = $DB->Add("b_perf_index_suggest", $arFields); return $ID; } public static function Delete($ID) { global $DB; $ID = intval($ID); $DB->Query("DELETE FROM b_perf_index_suggest_sql WHERE SUGGEST_ID = ".$ID); $DB->Query("DELETE FROM b_perf_index_suggest WHERE ID = ".$ID); } public static function UpdateStat($sql_md5, $count, $query_time, $sql_id) { global $DB; $res = $DB->Query(" INSERT INTO b_perf_index_suggest_sql ( SUGGEST_ID, SQL_ID ) SELECT iss.ID,s.ID FROM b_perf_index_suggest iss ,b_perf_sql s WHERE iss.SQL_MD5 = '".$DB->ForSQL($sql_md5)."' AND s.ID = ".intval($sql_id)." "); if (is_object($res)) { $DB->Query(" UPDATE b_perf_index_suggest SET SQL_COUNT = SQL_COUNT + ".intval($count).", SQL_TIME = SQL_TIME + ".floatval($query_time)." WHERE SQL_MD5 = '".$DB->ForSQL($sql_md5)."' "); } } public static function Clear() { global $DB; $DB->Query("TRUNCATE TABLE b_perf_tab_stat"); $DB->Query("TRUNCATE TABLE b_perf_tab_column_stat"); $DB->Query("TRUNCATE TABLE b_perf_index_suggest"); $DB->Query("TRUNCATE TABLE b_perf_index_suggest_sql"); } }