1. Array
   (
       [show_master_products_only] => 
       [area] => C
       [for_required_product] => 15531
       [include_child_variations] => 1
       [group_child_variations] => 
       [runtime_company_id] => 13
   )
   
   

1. Array
   (
       [area] => C
       [use_caching] => 1
       [extend] => Array
           (
               [0] => product_name
               [1] => prices
               [2] => categories
           )
   
       [custom_extend] => Array
           (
           )
   
       [pname] => 
       [pshort] => 
       [pfull] => 
       [pkeywords] => 
       [feature] => Array
           (
           )
   
       [type] => simple
       [page] => 1
       [action] => 
       [filter_variants] => Array
           (
           )
   
       [features_hash] => 
       [limit] => 0
       [bid] => 0
       [match] => 
       [tracking] => Array
           (
           )
   
       [get_frontend_urls] => 
       [items_per_page] => 0
       [apply_disabled_filters] => 
       [load_products_extra_data] => 1
       [storefront] => 
       [company_ids] => 
       [product_id] => 
   )
   
   

1. Advanced and feature filters
   

1. before hook
   

1. after hook
   

2. C
   

1. 1
   

1. before 2nd hook
   

1. after 2nd hook
   

1. SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  LEFT JOIN ?:product_required_products ON products.product_id = ?:product_required_products.required_id WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.master_product_status IN ('A') AND ?:product_required_products.product_id = 15531 GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC 
   

1. before end of oxn
   

2. Array
   (
   )
   
   

1. Array
   (
   )
   
   

2. end of fxn