Shop is very slow everywhere i click

if($number_of_products){
	$additional_condition='';
	if($content_type=='manufacturer'){
		if(!$config->get('show_out_of_stock',1)){
			$additional_condition=' AND a.product_quantity!=0';
		}
		$database->setQuery('SELECT count(a.product_id) AS number_of_products,a.product_manufacturer_id as category_id FROM '.hikashop_table('product').' AS a WHERE a.product_published>0'.$additional_condition.' AND a.product_parent_id=0 AND a.product_manufacturer_id IN ('.implode(',',$ids).') GROUP BY a.product_manufacturer_id');
	}else{
		if(!$config->get('show_out_of_stock',1)){
			$additional_condition=' AND b.product_quantity!=0';
		}
		$database->setQuery('SELECT count(a.product_id) AS number_of_products,a.category_id FROM '.hikashop_table('product_category').' AS a INNER JOIN '.hikashop_table('product').' AS b ON a.product_id=b.product_id AND b.product_published>0'.$additional_condition.' AND b.product_parent_id=0 WHERE a.category_id IN ('.implode(',',$ids).') GROUP BY a.category_id');
	}
	$counts = $database->loadObjectList('category_id');
	$this->_getCount($rows,$counts);
}