Оптимизировать кол-во запросов - Модификации расширений для Joomla

		$db = JFactory::getDbo();
		$query = $db->getQuery(true);
		$query->select('private_code,receipt_name'); //достаю все квитанции
		$query->from('#__action_receipt');
		$query->where("content_id = 239");
		$db->setQuery($query) or die("запрос1 не сработал"); 
		$data = $db->loadObjectList(); 
		
		foreach ($data as $var) 
		{
			$receipts[] = $var->receipt_name;
			$code_array[] = $var->private_code;
		}
		
		$a=0;
		for ($i=0; $i < count($code_array); $i++) 
		{
		$a++;
		$rec = $receipts[$i];
		$code = $code_array[$i];
		$receipt_view = "<a href='user_receipts/sale/{$rec}' target='_blank'>{$rec}</a>";
		
			$query = $db->getQuery(true);
			$query->select('member');//вывожу пользователя по коду квитанции
			$query->from('#__actions_members');
			$query->where("private_code = '{$code}'");
			$db->setQuery($query) or die("запрос1 не сработал"); 
			$member = $db->loadResult();
			
			$query = $db->getQuery(true);
			$query->select('supervisor');//вывожу куратора по коду квитанции
			$query->from('#__actions_members');
			$query->where("private_code = '{$code}'");
			$db->setQuery($query) or die("запрос1 не сработал"); 
			$supervisor = $db->loadResult();
			
			$query = $db->getQuery(true);
			$query->select('email');
			$query->from('#__actions_members');
			$query->where("private_code = '{$code}'");
			$db->setQuery($query) or die("запрос1 не сработал"); 
			$email = $db->loadResult();

			
			$tab .= "<tr><td>{$a}</td><td>{$member}</td><td>{$supervisor}</td><td>{$email}</td><td>{$receipt_view}</td></tr>";
			
		
		}
		
		echo "<table>{$tab}</table>";

$query = $db->getQuery(true);
			$query->select('member');//вывожу пользователя по коду квитанции
			$query->from('#__actions_members');
			$query->where("private_code = '{$code}'");
			$db->setQuery($query) or die("запрос1 не сработал"); 
			$member = $db->loadResult();
 
			$query = $db->getQuery(true);
			$query->select('supervisor');//вывожу куратора по коду квитанции
			$query->from('#__actions_members');
			$query->where("private_code = '{$code}'");
			$db->setQuery($query) or die("запрос1 не сработал"); 
			$supervisor = $db->loadResult();
 
			$query = $db->getQuery(true);
			$query->select('email');
			$query->from('#__actions_members');
			$query->where("private_code = '{$code}'");
			$db->setQuery($query) or die("запрос1 не сработал"); 
			$email = $db->loadResult();

$query = $db->getQuery(true);
			$query->select('member, supervisor, email')
				->from('#__actions_members')
				->where("private_code = '{$code}'");
			$user= $db->setQuery($query)->loadObject();
			$tab .= "<tr><td>{$a}</td><td>{$user->member}</td><td>{$user->supervisor}</td><td>{$email}</td><td>{$user->receipt_view}</td></tr>";

$query = $db->getQuery(true);
			$query->select('r.private_code, r.receipt_name, m.member, m.supervisor, m.email')
				->from('#__action_receipt AS r')
				->leftJoint('#__actions_members AS m ON r.private_code=m.private_code')
				->where("r.content_id = 239");
			$list= $db->setQuery($query)->loadObjectList();

$query->select('member, supervisor, email')
				->from('#__actions_members')
				->where("private_code = '{$code}'")
				->order("supervisor");
			$user= $db->setQuery($query)->loadObject();

		$query->select('private_code,member,supervisor,email');
		$query->from('#__actions_members');
		$query->where("content_id = 239 AND provereno='0'");
		$query->order('supervisor');

$query->order('supervisor DESC');

			$query = $db->getQuery(true);
			$query->select('member,supervisor,email')
				->from('#__actions_members')
				->where("private_code = '{$code}'")
				->order('supervisor DESC');
			$user= $db->setQuery($query)->loadObject();

		$query = $db->getQuery(true);
		$query->select('private_code,member,supervisor,email');
		$query->from('#__actions_members');
		$query->where("content_id = 239 AND provereno='0'");
		$query->order('supervisor');

$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('r.private_code, r.receipt_name, m.member, m.supervisor, m.email')
	->from('#__action_receipt AS r')
	->leftJoint('#__actions_members AS m ON r.private_code=m.private_code')
	->where("r.content_id = 239");
$list= $db->setQuery($query)->loadObjectList();

$query = $db->getQuery(true);
$query->select('r.private_code, r.receipt_name, m.member, m.id, m.supervisor, m.email,m.provereno')
	->from('#__action_receipt AS r')
	->leftJoin('#__actions_members AS m ON r.private_code=m.private_code')
	->where("r.content_id = 239")
	->order('m.supervisor');
$list= $db->setQuery($query)->loadObjectList();

->order('m.supervisor ASC, m.member DESC');