Hello,

I am creating code that allows me to store the information of my products, such as name, description, price and their relationship in one place on a Visualforce Page. To gather it I am using queries to get all the information I need regarding the products and their relationships. So far the code that I have exceeds the SOQL governor limits. I took out some of the relationships but still having the products and their first relationship causes the limit to be 29 which is too big if I want to add the rest of the relationships and information like I need to do. Since I am new to Apex coding, would anyone be able to look at my code and determine why the queries are running so much? I have looked at the forums and the suggestions that Salesforce has on governor limits and tried my best to follow the advice, but I am not sure I am implementing it properly since I am fairly new to using Apex and programming.

Here is my code:
 

public class CCQueries9 {
    
    List<DisplayProduct> productsParent; 
     
    //Queries the Product Information
    public List<DisplayProduct> getProducts() {
        if(productsParent == null) {
            productsParent = new List<DisplayProduct>();
            List<Product2> item = [SELECT Id, Name, HTML_Description__c FROM Product2 WHERE Account_Relatable__c = true ORDER BY Order__c];
            for(Product2 prod : item ) {
                productsParent.add(new DisplayProduct(prod));            
            }        
        }
        return productsParent; 
    }//End of Query Code
    
    
    public class DisplayProduct {
        
        List<Id> productParentId = new List<Id>();
        List<Id> ChildrenProductIds = new List<Id>();
        List<DisplaySuite> productsChildren {get;set;}
        
        private Product2 product;
        public DisplayProduct(Product2 item) {
            
           this.product = item;
           
            productParentId.add(this.product.Id); 
           
        }
        
        public String name {
            get {return product.Name;}
        }
         
        public String description {
            get {return product.HTML_Description__c;}
        }
        //Code to determine Query Limits
          public String GetCharlie {
            get {return String.valueOf(Limits.getQueries());}
        }

        //Query for the Childrens of Products 
        public List<DisplaySuite> getProductsChildren() {
        	
            if(productsChildren == null) {
            	
            	
         
            List<Product_Relationship__c> relationships = new List<Product_Relationship__c>(); 

         	 
            relationships = [SELECT Master_Product__c, Child_Product__c, CalculatorOrder__c, Child_Product__r.Name 
            				 FROM Product_Relationship__c 
            				 WHERE Master_Product__c IN : productParentId   
            				 ORDER BY CalculatorOrder__c,Child_Product__r.Name]; 
            
            
            for(Product_Relationship__c c:relationships){
               ChildrenProductIds.add(c.Child_Product__c);
            }
            
            if(ChildrenProductIds != null) {
			// query the product2 table for those products in the relationship, store in the final list        
                productsChildren = new List<DisplaySuite>();
                List<Product2> item = [SELECT Id, Name, HTML_Description__c FROM Product2 WHERE Id IN :ChildrenProductIds ORDER BY Order__c]; 
                for(Product2 children : item ) { 
                    productsChildren.add(new DisplaySuite(children));            
                }
            }        
            }
            return productsChildren;
        }
      
        
    }
    
    public class DisplaySuite {
        
        List<Id> productParentId = new List<Id>();
        List<Id> ChildrenProductIds = new List<Id>();
        List<DisplaySuite> productsChildren {get;set;}
        
        private Product2 product;
        
        public DisplaySuite(Product2 item) {
            this.product = item;
            productParentId.add(this.product.Id); 
        }
        public String name {
            get {return product.Name;}
        }
        public String description {
            get {return product.HTML_Description__c;}
        }
        //Code to determine Query Limits
          public String GetCharlie {
            get {return String.valueOf(Limits.getQueries());}
        }
            
     }
      
        
    }

And here is the page that I am calling the information on.
 

<apex:page showHeader="false" sidebar="false" Controller="CCQueries9" standardStylesheets="false">
       
    <apex:repeat value="{!products}" var="pitem"> <!-- Repeat for Product Information -->
      
        <apex:outputPanel >
                
            <apex:outputText escape="false" value="{!pitem.Name}"/><br/>
          		{! pitem.getCharlie } <br/>
            <div style="margin-left: 30px;">
           
            <apex:repeat value="{!pitem.productsChildren}" var="sitem"> <!-- Repeat for Suite Information -->
            
                <apex:outputPanel >                  
           
                    <apex:outputText escape="false" value="{!sitem.Name}"/><br/>
                    	{! sitem.getCharlie } <br/>
          	        	 
                </apex:outputPanel>
          
            </apex:repeat>   
            
            </div>
        
        </apex:outputPanel>
    
    </apex:repeat>  
    
</apex:page>

Thanks for any advice in advance!