| Server IP : 103.118.17.23 / Your IP : 216.73.216.188 Web Server : Microsoft-IIS/10.0 System : Windows NT RESELLERPLESK22 10.0 build 20348 (Windows Server 2016) AMD64 User : IWAM_plesk(default) ( 0) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : E:/Inetpub/vhosts/mesa.org.in/httpdocs/assets/_core/php/ |
Upload File : |
<?php
require_once('./qcubed.inc.php');
//Exit gracefully if called directly or profiling data is missing.
if ( !isset($_POST['intDatabaseIndex']) && !isset($_POST['strProfileData']) && !isset($_POST['strReferrer']) )
exit('Nothing to profile. No Database Profiling data recived.');
if ( !isset($_POST['intDatabaseIndex']) || !isset($_POST['strProfileData']) || !isset($_POST['strReferrer']) )
throw new Exception('Database Profiling data appears to have been corrupted.');
$intDatabaseIndex = intval($_POST['intDatabaseIndex']);
$strReferrer = QApplication::HtmlEntities($_POST['strReferrer']);
$objProfileArray = unserialize(base64_decode($_POST['strProfileData']));
$objProfileArray = QType::Cast($objProfileArray, QType::ArrayType);
$intCount = count($objProfileArray);
function PrintExplainStatement($strOriginalQuery) {
global $intDatabaseIndex;
if (substr_count($strOriginalQuery, "AUTOCOMMIT=1") > 0) {
return null;
}
$result = "";
$objDb = QApplication::$Database[$intDatabaseIndex];
$objDbResult = $objDb->ExplainStatement($strOriginalQuery);
if (!$objDbResult) {
return "";
}
$result .= "<table class='explainTable' border=1>";
$headersShown = false;
while ($mixRow = $objDbResult->FetchArray()) {
if (!$headersShown) {
$result .= "<thead class='header'>";
foreach ($mixRow as $key=>$value) {
if (!is_numeric($key)) {
$result .= "<td>" . $key . "</td>";
$headersShown = true;
}
}
$result .= '</thead>';
}
$result .= "<tr>";
foreach ($mixRow as $key=>$value) {
if (!is_numeric($key)) {
$result .= "<td>" . $value . "</td>";
}
}
$result .= "</tr>";
}
$result .= "</table>";
return $result;
}
?>
<!DOCTYPE html>
<html>
<head>
<title>QCubed Development Framework - Database Profiling Tool</title>
<style type="text/css">@import url("<?php _p(__VIRTUAL_DIRECTORY__ . __CSS_ASSETS__); ?>/corepage.css");</style>
<script type="text/javascript" src="<?php _p(__APP_JS_ASSETS__); ?>/jquery.min.js"></script>
<script type="text/javascript">
function Toggle(strWhatId) {
var obj = document.getElementById(strWhatId);
var objButton = document.getElementById("button" + strWhatId);
if (obj && objButton) {
if (obj.style.display == "block") {
obj.style.display = "none";
objButton.innerHTML = objButton.innerHTML.replace("Hide", "Show");
}
else {
obj.style.display = "block";
objButton.innerHTML = objButton.innerHTML.replace("Show", "Hide");
}
}
return false;
}
function ShowAll() {
jQuery(".querySection, .explainSection").each(function() {
if ($(this).css('display') == "none") {
Toggle(this.id);
}
});
return false;
}
function HideAll() {
jQuery(".querySection, .explainSection").each(function() {
if ($(this).css('display') == "block") {
Toggle(this.id);
}
});
return false;
}
</script>
<style>
.explainTable {
border: 1px solid black;
border-collapse:collapse;
margin-top: 5px;
}
.explainTable td {
padding: 4px;
}
.explainTable .header td {
background: #CCC;
font-weight: bold;
}
</style>
</head>
<body>
<div id="container">
<div id="headerContainer">
<div id="headerBorder">
<div id="header">
<div id="hleft">
<span class="hsmall">QCubed Development Framework <?php echo QCUBED_VERSION_NUMBER_ONLY ?></span><br/>
<span class="hbig">Database Profiling Tool</span>
</div>
<div id="hright">
<b>Database Index:</b> <?php _p($intDatabaseIndex); ?>
<b>Database Type:</b> <?php _p(QApplication::$Database[$intDatabaseIndex]->Adapter); ?><br/>
<b>Database Server:</b> <?php _p(QApplication::$Database[$intDatabaseIndex]->Server); ?>
<b>Database Name:</b> <?php _p(QApplication::$Database[$intDatabaseIndex]->Database); ?><br/>
<b>Profile Generated From:</b> <?php _p($strReferrer); ?>
</div>
<div class="clear"></div>
</div>
</div>
</div>
</div>
<div id="content">
<span class="title">
<?php
switch ($intCount) {
case 0: _p('<b>There were no queries that were performed.</b>', false); break;
case 1: _p('<b>There was 1 query that was performed.</b>', false); break;
default: printf('<b>There were %s queries that were performed.</b>', $intCount); break;
};
?>
</span>
<br/>
<br/>
<a href="#" onClick="return ShowAll();" class="smallbutton">Show All</a>
<a href="#" onClick="return HideAll();" class="smallbutton">Hide All</a>
<br/>
<br/>
<?php
$intIndex = 1;
foreach( $objProfileArray as $objProfile) {
$objBacktrace = $objProfile['objBacktrace'];
$strQuery = $objProfile['strQuery'];
$dblTimeInfo = $objProfile['dblTimeInfo'];
$objArgs = (array_key_exists('args', $objBacktrace)) ? $objBacktrace['args'] : array();
$strClass = (array_key_exists('class', $objBacktrace)) ? $objBacktrace['class'] : null;
$strType = (array_key_exists('type', $objBacktrace)) ? $objBacktrace['type'] : null;
$strFunction = (array_key_exists('function', $objBacktrace)) ? $objBacktrace['function'] : null;
$strFile = (array_key_exists('file', $objBacktrace)) ? $objBacktrace['file'] : null;
$strLine = (array_key_exists('line', $objBacktrace)) ? $objBacktrace['line'] : null;
?>
<span class="function">
Called by <?php _p($strClass . $strType . $strFunction . '(' . implode(', ', $objArgs) . ')'); ?>
</span> <br/>
<span class="function_details">
<b>File: </b><?php _p($strFile); ?>; <b>Line: </b><?php _p($strLine); ?>
</span>
<?php
//mark slow query - those that take over 1 second
if($dblTimeInfo >= 1)
echo('<div class="time slow">');
else
echo'<div class="time">';
printf("Query took %.1f ms", $dblTimeInfo * 1000);
?>
<?php $explainStatement = PrintExplainStatement($strQuery); ?>
<a href="#" onClick="return Toggle('query<?php _p($intIndex); ?>')" id="buttonquery<?php _p($intIndex); ?>" class="queryButton smallbutton">
Show SQL
</a>
<?php if ($explainStatement) { ?>
<a href="#" onClick="return Toggle('explain<?php _p($intIndex); ?>')" id="buttonexplain<?php _p($intIndex); ?>" class="explainButton smallbutton">
Show EXPLAIN statement
</a>
<?php } ?>
<pre id="query<?php _p($intIndex); ?>" style="display: none" class="querySection"><code><?php _p($strQuery); ?></code></pre>
<div id="explain<?php _p($intIndex); ?>" style="display: none" class="explainSection"><?php echo $explainStatement; ?></div>
<?php
echo '</div>';
?>
<br/>
<?php
$intIndex++;
}
?> </div>
</div>
<script>
if (<?php _p($intCount); ?> <= 5) ShowAll();
</script>
</body>
</html>