Как я делал каталог из 16000 товаров на Mosets tree - Mosets Tree

SELECT id
 FROM kamaz_menu
 WHERE type = 'content_typed'
 AND componentid = 2802363

SELECT hits FROM kamaz_content WHERE id = '28023'

function botAkoComment( $published, &$row, &$params, $page=0 ) {

// lms
 if ($_REQUEST['option']=='com_mtree') {
  	return;
  }
// lms

/component/option,com_mtree/task,listcats/cat_id,1433/Itemid,37/

/catalog-37.html

[b]Generation time:1.2738819 sec.106 queries executed[/b]

Generation time:0.3940439 sec.28 queries executed

if ($jrecache_config->getCfg('enable_cache') == "0" ){
	$bypass_cache= true;
	
	if ( $is_debug ) {
		$debug_out = "<br/>Cache is disabled";
	}
} else {
	[b]// lms
	if (strpos($_SERVER['REQUEST_URI'],"catalog")==0) {
		$bypass_cache = true;
		// if it is NOT catalog -  you should bypass cache
	} else {
	// lms[/b]
		$bypass_cache = false;
		$cache_TTL = $jrecache_config->getCfg('cache_TTL');
	}
}

	$sql = "SELECT DISTINCT l.link_id, l.*, u.username, c.*, img.img_id FROM (#__mt_links AS l, #__mt_cl AS cl";
			if($searchable_custom_fields_count > 0) {
				$sql .= ", #__mt_cfvalues AS cfv, #__mt_customfields AS cf";
			}
			$sql .= ")"
			.	"\n	LEFT JOIN #__mt_images AS img ON img.link_id = l.link_id AND img.ordering = 1 " 
			.	"\n	LEFT JOIN #__mt_cats AS c ON c.cat_id = cl.cat_id " 
			.	"\n LEFT JOIN #__users AS u ON u.id = l.user_id "
			.	"\n	WHERE " 
			. "link_published='1' AND link_approved='1' AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '$now'  ) AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '$now' )"
			.	"\n AND cl.link_id = l.link_id "
			.	"\n AND cl.main = 1 ";
			if($searchable_custom_fields_count > 0) {
		 		$sql .=	"\n AND cfv.link_id = l.link_id "
		 			.	"\n AND cfv.cf_id = cf.cf_id ";
			}
			$sql .= "\n AND ".$where
			.	( (!empty($only_subcats_sql)) ? $only_subcats_sql : '' )
			.	"\n ORDER BY " . $mtconf->get('first_search_order1') . ' ' . $mtconf->get('first_search_order2') . ', ' . $mtconf->get('second_search_order1') . ' ' . $mtconf->get('second_search_order2')
			.	"\n LIMIT $limitstart, " . $mtconf->get('fe_num_of_searchresults');
			*/

$sql = "SELECT DISTINCT l.link_id, l.*, c.* FROM (#__mt_links AS l, #__mt_cl AS cl) "
		/*	if($searchable_custom_fields_count > 0) {
				$sql .= ", #__mt_cfvalues AS cfv, #__mt_customfields AS cf";
			}
			$sql .= ")"*/
//			.	"\n	LEFT JOIN #__mt_images AS img ON img.link_id = l.link_id AND img.ordering = 1 " 
			.	"\n	LEFT JOIN #__mt_cats AS c ON c.cat_id = cl.cat_id " 
		//	.	"\n LEFT JOIN #__users AS u ON u.id = l.user_id "
			.	"\n	WHERE " 
			. "link_published='1' AND link_approved='1' AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '$now'  ) AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '$now' )"
			.	"\n AND cl.link_id = l.link_id "
			.	"\n AND cl.main = 1 ";
			/*if($searchable_custom_fields_count > 0) {
		 		$sql .=	"\n AND cfv.link_id = l.link_id "
		 			.	"\n AND cfv.cf_id = cf.cf_id ";
			}*/
			$sql .= "\n AND ".$where
			.	( (!empty($only_subcats_sql)) ? $only_subcats_sql : '' )
			.	"\n ORDER BY " . $mtconf->get('first_search_order1') . ' ' . $mtconf->get('first_search_order2') . ', ' . $mtconf->get('second_search_order1') . ' ' . $mtconf->get('second_search_order2')
			.	"\n LIMIT $limitstart, " . $mtconf->get('fe_num_of_searchresults');

/*if($searchable_custom_fields_count > 0) {
				$wheres0[] = "\n" .' (cf.hidden = 0 AND cf.simple_search = 1 AND cf.published = 1 AND LOWER(cfv.value) LIKE \'%' . $word . '%\')';
			}*/