Хаки для убыстрения VirtueMart (уменьшение запросов и т.п.) - [VM1] Модификации и хаки

function get_flypage($product_id) {
	

		if( empty( $_SESSION['product_sess'][$product_id]['flypage'] )) {
			$db = new ps_DB;
			$productParentId = (int)$product_id;
			do {
				$q = "SELECT
                                `#__{vm}_product`.`product_parent_id` AS product_parent_id,
                                `#__{vm}_category`.`category_flypage`
                        FROM
                                `#__{vm}_product`

                        LEFT JOIN `#__{vm}_product_category_xref` ON `#__{vm}_product_category_xref`.`product_id` = `#__{vm}_product`.`product_id`
                        LEFT JOIN `#__{vm}_category` ON `#__{vm}_product_category_xref`.`category_id` = `#__{vm}_category`.`category_id`

                        WHERE `#__{vm}_product`.`product_id`='$productParentId'
                        ";
				$productParentId = $db->f("product_parent_id");
				$db->query($q);
				$db->next_record();
			} 
			while( $db->f("product_parent_id") && !$db->f("category_flypage"));

			if ($db->f("category_flypage")) {
				$_SESSION['product_sess'][$product_id]['flypage'] = $db->f("category_flypage");
			} else {
				$_SESSION['product_sess'][$product_id]['flypage'] = FLYPAGE;
			}
		}
		return $_SESSION['product_sess'][$product_id]['flypage']; 
	}

 function get_flypage($product_id) {
		$_SESSION['product_sess'][$product_id]['flypage'] = "mypage.tpl";
		return	$_SESSION['product_sess'][$product_id]['flypage'];
	}

function get_flypage($product_id) {
		return 'mypage.tpl';
}

SELECT tax_rate 
  FROM jos_vm_product, jos_vm_tax_rate 
  WHERE product_tax_id=tax_rate_id 
  AND product_id=401

Application afterRender: 2.285 seconds, 13.04 MB
128 queries logged

Application afterRender: 0.861 seconds, 12.96 MB
48 queries logged

function getFilesForProduct( $pid, $ppid = -1 ) {
		$db= new ps_DB();
		$files['images'] = array();
		$files['files'] = array();
		// Query for images if child doesn't have them check for parents
                                if ($ppid < 0 ) { 
 		    $db->query( "SELECT product_parent_id FROM `#__{vm}_product`  WHERE `product_id`=".intval($pid) );
		    $ppid = $db->f("product_parent_id");
		}
		$db->query( "SELECT * FROM `#__{vm}_product_files` WHERE `file_product_id`=".intval($pid)." AND `file_published`=1" );
		if(!$db->next_record()) {
		  if ($ppid > 0 ) {
		      $db->query("SELECT * FROM `demo_jos_vm_product_files` WHERE `file_product_id` = ".$ppid." AND `file_published` =1");
 		       $db->reset();
       		        while( $db->next_record() ) 
                                         {
                                               if ( $db->f("file_is_image") == 1)
                                                     {
 			                $files['images'][] = $db->get_row();
			    }
			         else	
			              {  $files['files'][] = $db->get_row();}
                                        }
		   }
		}
                                else
		{
 		       $db->reset();
       		        while( $db->next_record() ) {
                                               if ($db->f("file_is_image") == 1)
                                                     {
 			                $files['images'][] = $db->get_row();
			    }
			         else	
			               { $files['files'][] = $db->get_row();}
		     }
		}
		return $files;
	}

Информация о профиле
Application afterLoad: 0.003 seconds, 0.27 MB
Application afterInitialise: 0.099 seconds, 2.72 MB
Application afterRoute: 0.137 seconds, 4.24 MB
Application afterDispatch: 0.363 seconds, 10.18 MB
Application afterRender: 1.241 seconds, 13.09 MB
Использование памяти
13776304
Зарегистрировано запросов: 746

Информация о профиле
Application afterLoad: 0.003 seconds, 0.27 MB
Application afterInitialise: 0.080 seconds, 2.73 MB
Application afterRoute: 0.120 seconds, 4.25 MB
Application afterDispatch: 0.342 seconds, 10.19 MB
Application afterRender: 1.114 seconds, 13.10 MB
Использование памяти
13782296
Зарегистрировано запросов: 746

function getFilesForProduct( $pid, $ppid = -1 ) {

function getFilesForProduct( $pid ) {

Информация о профиле
Application afterLoad: 0.003 seconds, 0.27 MB
Application afterInitialise: 0.071 seconds, 2.74 MB
Application afterRoute: 0.099 seconds, 4.26 MB
Application afterDispatch: 0.311 seconds, 10.20 MB
Application afterRender: 0.959 seconds, 13.11 MB
Использование памяти
13796656
Зарегистрировано запросов: 745

Информация о профиле
Application afterLoad: 0.004 seconds, 0.27 MB
Application afterInitialise: 0.078 seconds, 2.75 MB
Application afterRoute: 0.109 seconds, 4.27 MB
Application afterDispatch: 0.334 seconds, 10.21 MB
Application afterRender: 0.943 seconds, 13.12 MB
Использование памяти
13807608
Зарегистрировано запросов: 746

Информация о профиле
Application afterLoad: 0.004 seconds, 0.27 MB
Application afterInitialise: 0.081 seconds, 2.85 MB
Application afterRoute: 0.109 seconds, 4.31 MB
Application afterDispatch: 0.324 seconds, 10.27 MB
Application afterRender: 0.904 seconds, 13.17 MB
Использование памяти
13858048
Зарегистрировано запросов: 745

Информация о профиле
Application afterLoad: 0.003 seconds, 0.27 MB
Application afterInitialise: 0.104 seconds, 2.78 MB
Application afterRoute: 0.138 seconds, 4.26 MB
Application afterDispatch: 0.973 seconds, 12.72 MB
Application afterRender: 1.897 seconds, 14.75 MB
Использование памяти
15514368
Зарегистрировано запросов: 1011

Информация о профиле
Application afterLoad: 0.003 seconds, 0.27 MB
Application afterInitialise: 0.077 seconds, 2.80 MB
Application afterRoute: 0.137 seconds, 4.26 MB
Application afterDispatch: 0.636 seconds, 12.71 MB
Application afterRender: 1.372 seconds, 14.73 MB
Использование памяти
15497272
Зарегистрировано запросов: 934