[Хак] Ускорение загрузки магазина (минимум в 10 раз) - страница 3 - [VM1] Модификации и хаки

// The "OR" in the where clause slows down the whole query. It is only needed when there are parent-products
$tmpdb = new ps_DB();
$tmpdb->query( "SELECT COUNT(*) AS parentcnt FROM #__{vm}_product WHERE product_parent_id>0");
$tmpdb->next_record();
if($tmpdb->f('parentcnt')>0) {
	// bunak - OPTIMIZE	---------------->>>
	$where_str = "(`#__{vm}_product_category_xref`.`product_id`=`#__{vm}_product`.`product_id` ";
	if( !empty( $keyword ) ) {
		// when someone is searching, we also show child products (product_parent_id != 0), IT is this case
		$where_str .= " OR `#__{vm}_product_category_xref`.`product_id`=`#__{vm}_product`.`product_parent_id` ";
	}
	$where_str .= ")";
	$where_clause[] = $where_str;
	// bunak - OPTIMIZE	<<<----------------
} else {
	$where_clause[] = "`#__{vm}_product_category_xref`.`product_id`=`#__{vm}_product`.`product_id`";	
}

SELECT g1.id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 3 AND 12
GROUP BY g1.name
ORDER BY g1.lft

	$database->setQuery( "SELECT $fields"
			. "\nFROM $table AS g1"
			. "\nINNER JOIN $table AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt"
			. "\n$where"
			. ($groupby ? "\nGROUP BY $groupby" : "")
			. "\nORDER BY g1.lft"
		);

$categories = ps_product_category::getCategoryTreeArray(); // Get array of category objects
$result = ps_product_category::sortCategoryTreeArray($categories); // Sort array of category objects

        // Кэширование запроса по формированию списка каталога;

        $fn = "cache/ps_product_category/result.txt";
        
        $fntime=filemtime($fn);
        $curtime=time();
        $daytime = 86400; //кэшируется на 1 день
        
        if ($curtime > $fntime + $daytime or !file_exists($fn)) {
                    $categories = ps_product_category::getCategoryTreeArray(); // Get array of category objects
                    $result = ps_product_category::sortCategoryTreeArray($categories); // Sort array of category objects
                    $string_result = serialize($result);
                    $fh = fopen($fn, 'w');
                    fwrite($fh, $string_result);
                    fclose($fh);
        }
        
                $str = file_get_contents($fn);
                $result = unserialize($str);
        
        // Кэширование запроса по формированию списка каталога;