debug.inc.php

php最好的论坛程序! php最好的论坛程序! php最好的论坛程序!

<?php
include_once "include/debug.fun.php";

if($debug) {
	$sqlstarttime = $sqlendttime = 0;
	$mtime = explode(' ', microtime());
	$sqlstarttime = number_format(($mtime[1] + $mtime[0] - $discuz_starttime), 6) * 1000;

	$mtime = explode(' ', microtime());
	$sqlendttime = number_format(($mtime[1] + $mtime[0] - $discuz_starttime), 6) * 1000;

	$sqlspenttimes[] = $sqlspenttime = $sqlendttime - $sqlstarttime;

	$sqldebug .="<center><div style=\"border:1px solid black;padding:5px;margin:10px;text-align:left; width:96%;clear:both;background:#eeeeee\">
	<div style=\"font-size:12px;text-align:right;\">TIME: $sqlstarttime - $sqlendttime = $sqlspenttime</div><span style=\"font-size:12px\">".sqlshowformat($sql).'</font>';
	if(preg_match("/^select /i", $sql)) {
		$sqldebug .= "<div onclick=\"this.nextSibling.style.display = this.nextSibling.style.display == 'block' ? 'none' : 'block';\" align=\"right\">
		<a href=\"javascript:\">[more]</a></div>
		<table width=\"100%\" style=\"font-size:12px;display:none;background:#fff\" cellspacing=\"2\" cellpadding=\"3\">
		<tr style=\"background:#eee\">
		<td>id</td>
		<td>table</td>
		<td>type</td>
		<td>possible_keys</td>
		<td>key</td>
		<td>key_len</td>
		<td>ref</td>
		<td>rows</td>
		<td>Extra</td>
		</tr>
		";
		$explainquery = mysql_query("explain $sql");
		while( $explain = mysql_fetch_assoc($explainquery) ){
			$sqldebug .= "
			<tr style=\"background:#eee\">
			<td>&nbsp;{$explain['id']}</td>
			<td>&nbsp;{$explain['table']}</td>
			<td>&nbsp;{$explain['type']}</td>
			<td>&nbsp;{$explain['possible_keys']}</td>
			<td>&nbsp;{$explain['key']}</td>
			<td>&nbsp;{$explain['key_len']}</td>
			<td>&nbsp;{$explain['ref']}</td>
			<td>&nbsp;{$explain['rows']}</td>
			<td>&nbsp;{$explain['Extra']}</td>
			</tr>";
		}
		$sqldebug .= "</table>";
	}
	$sqldebug .="</div><br></center>\r\n";
}



?>