1. Array
    (
        [show_master_products_only] => 
        [area] => C
        [currency] => EUR
        [sl] => en
        [dispatch] => categories.view
        [category_id] => 438
        [page] => 7
        [save_view_results] => product_id
        [items_per_page] => 24
        [sort_by] => bestsellers
        [sort_order] => desc
        [cid] => 438
        [extend] => Array
            (
                [0] => categories
                [1] => description
                [2] => description
                [3] => full_description
            )
    
        [subcats] => Y
        [runtime_company_id] => 0
    )
    
    
  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] => 24
        [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 ?:master_products_storefront_offers_count AS master_products_storefront_offers_count  ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  WHERE 1  AND ?:categories.category_id IN (438) 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.parent_product_id = 0 AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 144, 24
    
  1. before end of oxn
    
  2. Array
    (
        [29793] => Array
            (
                [product_id] => 29793
                [product] => Mother's Day Nutty Indulgence Hamper
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [product_code] => Kokomae_MD8
                [hsn_code] => 3304
                [status] => A
                [list_price] => 1780.00
                [amount] => 100
                [weight] => 0.000
                [length] => 0
                [width] => 0
                [height] => 0
                [shipping_freight] => 0.00
                [low_avail_limit] => 0
                [timestamp] => 1683267706
                [updated_timestamp] => 1750246019
                [usergroup_ids] => 0
                [is_edp] => N
                [edp_shipping] => N
                [unlimited_download] => N
                [tracking] => B
                [free_shipping] => N
                [zero_price_action] => R
                [is_pbp] => Y
                [is_op] => N
                [is_oper] => N
                [is_returnable] => Y
                [return_period] => 10
                [avail_since] => 0
                [out_of_stock_actions] => N
                [localization] => 
                [min_qty] => 0
                [max_qty] => 5
                [qty_step] => 0
                [list_qty_count] => 0
                [tax_ids] => 13
                [age_verification] => N
                [age_limit] => 0
                [options_type] => P
                [exceptions_type] => F
                [details_layout] => default
                [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
                [facebook_obj_type] => 
                [buy_now_url] => 
                [is_stock_split_by_warehouses] => N
                [master_product_status] => A
                [youtube_link] => 
                [show_youtube_video] => Y
                [replace_main_image] => 
                [position_youtube] => 
                [restrict_cod] => N
                [price] => 1691.000000
                [short_description] => Exclusive Mother's Day hamper with Belgian chocolate covered roasted nuts.
                [full_description] => <p>Introducing our exclusive Mother's Day hamper, carefully curated to provide your beloved mom with the ultimate chocolate experience! Our hamper features a luxurious selection of whole roasted nuts covered in premium Belgian chocolate, offering the perfect combination of smooth and silky chocolate with the satisfying crunch of roasted nuts. Each chocolate is hand-crafted with the finest ingredients to ensure a rich and decadent flavor that's simply irresistible. All of these delicious treats are packed in a gorgeous box, making it the perfect gift for your mom on this special day. Order now and show your mom how much you appreciate and adore her!Coated nuts in jars ( 3 different flavors) <br />(i) Coated Hazelnut in Belgian Dark chocolate<br />(ii) Coated Almond in Belgian Milk chocolate<br />(iii) Coated Orange Peel in Belgian Dark chocolate</p>
                [category_ids] => Array
                    (
                        [0] => 438
                        [1] => 2648
                    )
    
                [position] => 0
                [seo_name] => mothers-day-nutty-indulgence-hamper
                [seo_path] => 458/2646/2648
                [main_category] => 2648
                [options_type_raw] => P
                [exceptions_type_raw] => F
                [tracking_raw] => B
                [zero_price_action_raw] => R
                [min_qty_raw] => 0
                [max_qty_raw] => 5
                [qty_step_raw] => 0
                [list_qty_count_raw] => 0
                [details_layout_raw] => default
                [video_as_images] => Array
                    (
                    )
    
                [videos] => Array
                    (
                    )
    
                [brand_name] => Kokomae
            )
    
        [29794] => Array
            (
                [product_id] => 29794
                [product] => Mother's Day Indian Chocolate Treats Hamper
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [product_code] => Kokomae_MD9
                [hsn_code] => 3304
                [status] => A
                [list_price] => 1780.00
                [amount] => 100
                [weight] => 0.000
                [length] => 0
                [width] => 0
                [height] => 0
                [shipping_freight] => 0.00
                [low_avail_limit] => 0
                [timestamp] => 1683267706
                [updated_timestamp] => 1750246019
                [usergroup_ids] => 0
                [is_edp] => N
                [edp_shipping] => N
                [unlimited_download] => N
                [tracking] => B
                [free_shipping] => N
                [zero_price_action] => R
                [is_pbp] => Y
                [is_op] => N
                [is_oper] => N
                [is_returnable] => Y
                [return_period] => 10
                [avail_since] => 0
                [out_of_stock_actions] => N
                [localization] => 
                [min_qty] => 0
                [max_qty] => 5
                [qty_step] => 0
                [list_qty_count] => 0
                [tax_ids] => 13
                [age_verification] => N
                [age_limit] => 0
                [options_type] => P
                [exceptions_type] => F
                [details_layout] => default
                [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
                [facebook_obj_type] => 
                [buy_now_url] => 
                [is_stock_split_by_warehouses] => N
                [master_product_status] => A
                [youtube_link] => 
                [show_youtube_video] => Y
                [replace_main_image] => 
                [position_youtube] => 
                [restrict_cod] => N
                [price] => 1691.000000
                [short_description] => Hand-crafted chocolate treats for a special Mother's Day.
                [full_description] => <p>Introducing our Mother's Day hamper, a gift basket that combines the deliciousness of whole roasted nuts enrobed in premium Indian chocolate. Packed in a stunning box, this hamper is the perfect way to show your mom how much you care and make her feel special on this Mother's Day. Hand-crafted with the finest ingredients, our chocolates offer a rich and authentic flavor that will satisfy your mom's taste buds. Order now and give your mom the gift of a delightful and unforgettable chocolate experience!Organic Coated nuts in jars (3 different flavors) <br />(i) Coated Coffee with White Chocolate<br />(ii) Caramalised Almond in 70% Dark Chocolate<br />(iii) Cashew Praline in 65% Dark Chocolate</p>
                [category_ids] => Array
                    (
                        [0] => 438
                        [1] => 2663
                    )
    
                [position] => 0
                [seo_name] => mothers-day-indian-chocolate-treats-hamper
                [seo_path] => 458/2654/2663
                [main_category] => 2663
                [options_type_raw] => P
                [exceptions_type_raw] => F
                [tracking_raw] => B
                [zero_price_action_raw] => R
                [min_qty_raw] => 0
                [max_qty_raw] => 5
                [qty_step_raw] => 0
                [list_qty_count_raw] => 0
                [details_layout_raw] => default
                [video_as_images] => Array
                    (
                    )
    
                [videos] => Array
                    (
                    )
    
                [brand_name] => Kokomae
            )
    
    )
    
    
  1. Array
    (
        [29793] => Array
            (
                [product_id] => 29793
                [product] => Mother's Day Nutty Indulgence Hamper
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [product_code] => Kokomae_MD8
                [hsn_code] => 3304
                [status] => A
                [list_price] => 1780.00
                [amount] => 100
                [weight] => 0.000
                [length] => 0
                [width] => 0
                [height] => 0
                [shipping_freight] => 0.00
                [low_avail_limit] => 0
                [timestamp] => 1683267706
                [updated_timestamp] => 1750246019
                [usergroup_ids] => 0
                [is_edp] => N
                [edp_shipping] => N
                [unlimited_download] => N
                [tracking] => B
                [free_shipping] => N
                [zero_price_action] => R
                [is_pbp] => Y
                [is_op] => N
                [is_oper] => N
                [is_returnable] => Y
                [return_period] => 10
                [avail_since] => 0
                [out_of_stock_actions] => N
                [localization] => 
                [min_qty] => 0
                [max_qty] => 5
                [qty_step] => 0
                [list_qty_count] => 0
                [tax_ids] => 13
                [age_verification] => N
                [age_limit] => 0
                [options_type] => P
                [exceptions_type] => F
                [details_layout] => default
                [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
                [facebook_obj_type] => 
                [buy_now_url] => 
                [is_stock_split_by_warehouses] => N
                [master_product_status] => A
                [youtube_link] => 
                [show_youtube_video] => Y
                [replace_main_image] => 
                [position_youtube] => 
                [restrict_cod] => N
                [price] => 1691.000000
                [short_description] => Exclusive Mother's Day hamper with Belgian chocolate covered roasted nuts.
                [full_description] => <p>Introducing our exclusive Mother's Day hamper, carefully curated to provide your beloved mom with the ultimate chocolate experience! Our hamper features a luxurious selection of whole roasted nuts covered in premium Belgian chocolate, offering the perfect combination of smooth and silky chocolate with the satisfying crunch of roasted nuts. Each chocolate is hand-crafted with the finest ingredients to ensure a rich and decadent flavor that's simply irresistible. All of these delicious treats are packed in a gorgeous box, making it the perfect gift for your mom on this special day. Order now and show your mom how much you appreciate and adore her!Coated nuts in jars ( 3 different flavors) <br />(i) Coated Hazelnut in Belgian Dark chocolate<br />(ii) Coated Almond in Belgian Milk chocolate<br />(iii) Coated Orange Peel in Belgian Dark chocolate</p>
                [category_ids] => Array
                    (
                        [0] => 438
                        [1] => 2648
                    )
    
                [position] => 0
                [seo_name] => mothers-day-nutty-indulgence-hamper
                [seo_path] => 458/2646/2648
                [main_category] => 2648
                [options_type_raw] => P
                [exceptions_type_raw] => F
                [tracking_raw] => B
                [zero_price_action_raw] => R
                [min_qty_raw] => 0
                [max_qty_raw] => 5
                [qty_step_raw] => 0
                [list_qty_count_raw] => 0
                [details_layout_raw] => default
                [video_as_images] => Array
                    (
                    )
    
                [videos] => Array
                    (
                    )
    
                [brand_name] => Kokomae
            )
    
        [29794] => Array
            (
                [product_id] => 29794
                [product] => Mother's Day Indian Chocolate Treats Hamper
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [product_code] => Kokomae_MD9
                [hsn_code] => 3304
                [status] => A
                [list_price] => 1780.00
                [amount] => 100
                [weight] => 0.000
                [length] => 0
                [width] => 0
                [height] => 0
                [shipping_freight] => 0.00
                [low_avail_limit] => 0
                [timestamp] => 1683267706
                [updated_timestamp] => 1750246019
                [usergroup_ids] => 0
                [is_edp] => N
                [edp_shipping] => N
                [unlimited_download] => N
                [tracking] => B
                [free_shipping] => N
                [zero_price_action] => R
                [is_pbp] => Y
                [is_op] => N
                [is_oper] => N
                [is_returnable] => Y
                [return_period] => 10
                [avail_since] => 0
                [out_of_stock_actions] => N
                [localization] => 
                [min_qty] => 0
                [max_qty] => 5
                [qty_step] => 0
                [list_qty_count] => 0
                [tax_ids] => 13
                [age_verification] => N
                [age_limit] => 0
                [options_type] => P
                [exceptions_type] => F
                [details_layout] => default
                [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
                [facebook_obj_type] => 
                [buy_now_url] => 
                [is_stock_split_by_warehouses] => N
                [master_product_status] => A
                [youtube_link] => 
                [show_youtube_video] => Y
                [replace_main_image] => 
                [position_youtube] => 
                [restrict_cod] => N
                [price] => 1691.000000
                [short_description] => Hand-crafted chocolate treats for a special Mother's Day.
                [full_description] => <p>Introducing our Mother's Day hamper, a gift basket that combines the deliciousness of whole roasted nuts enrobed in premium Indian chocolate. Packed in a stunning box, this hamper is the perfect way to show your mom how much you care and make her feel special on this Mother's Day. Hand-crafted with the finest ingredients, our chocolates offer a rich and authentic flavor that will satisfy your mom's taste buds. Order now and give your mom the gift of a delightful and unforgettable chocolate experience!Organic Coated nuts in jars (3 different flavors) <br />(i) Coated Coffee with White Chocolate<br />(ii) Caramalised Almond in 70% Dark Chocolate<br />(iii) Cashew Praline in 65% Dark Chocolate</p>
                [category_ids] => Array
                    (
                        [0] => 438
                        [1] => 2663
                    )
    
                [position] => 0
                [seo_name] => mothers-day-indian-chocolate-treats-hamper
                [seo_path] => 458/2654/2663
                [main_category] => 2663
                [options_type_raw] => P
                [exceptions_type_raw] => F
                [tracking_raw] => B
                [zero_price_action_raw] => R
                [min_qty_raw] => 0
                [max_qty_raw] => 5
                [qty_step_raw] => 0
                [list_qty_count_raw] => 0
                [details_layout_raw] => default
                [video_as_images] => Array
                    (
                    )
    
                [videos] => Array
                    (
                    )
    
                [brand_name] => Kokomae
            )
    
    )
    
    
  2. end of fxn
    
  1. Array
    (
        [show_master_products_only] => 
        [area] => C
        [pid] => 29793
        [limit] => 1
        [total] => 1
        [custom_extend] => Array
            (
                [0] => product_name
                [1] => categories
            )
    
        [load_products_extra_data] => 
        [force_virtual] => 1
        [runtime_company_id] => 0
        [vr_company_id] => 0
        [is_virtual] => Y
        [virtual_conditions] => Array
            (
                [set] => all
                [set_value] => 1
                [conditions] => Array
                    (
                        [1] => Array
                            (
                                [operator] => in
                                [condition] => products
                                [value] => 3556,3976,14830,15216,23660,28537,32931,35638,35639,36366,37916,39004,39636,58631,63910,63916,63922,65282
                            )
    
                    )
    
            )
    
    )
    
    
  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] => 1
        [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 ?: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  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  ((1  AND  products.product_id IN (29793)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products.product_id IN (3556,3976,14830,15216,23660,28537,32931,35638,35639,36366,37916,39004,39636,58631,63910,63916,63922,65282)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1
    
  1. before end of oxn
    
  2. Array
    (
    )
    
    
  1. Array
    (
    )
    
    
  2. end of fxn
    
  1. Array
    (
        [show_master_products_only] => 
        [area] => C
        [pid] => 29793
        [limit] => 1
        [total] => 1
        [custom_extend] => Array
            (
                [0] => product_name
                [1] => categories
            )
    
        [load_products_extra_data] => 
        [force_virtual] => 1
        [runtime_company_id] => 0
        [vr_company_id] => 0
        [is_virtual] => Y
        [virtual_conditions] => Array
            (
                [set] => all
                [set_value] => 1
                [conditions] => Array
                    (
                        [1] => Array
                            (
                                [condition_element] => 62
                                [operator] => nin
                                [condition] => feature
                                [value] => 49321,40971,38308
                                [value_name] => 
                            )
    
                    )
    
            )
    
        [include_child_variations] => 1
    )
    
    
  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] => 1
        [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 ?: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_features_values AS pfv_62 ON pfv_62.product_id = products.product_id AND pfv_62.feature_id = 62 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  ((1  AND  products.product_id IN (29793)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND pfv_62.variant_id NOT IN (49321,40971,38308)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1
    
  1. before end of oxn
    
  2. Array
    (
        [29793] => Array
            (
                [product_id] => 29793
                [product] => Mother's Day Nutty Indulgence Hamper
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [video_as_images] => Array
                    (
                    )
    
                [videos] => Array
                    (
                    )
    
                [brand_name] => Kokomae
            )
    
    )
    
    
  1. Array
    (
        [29793] => Array
            (
                [product_id] => 29793
                [product] => Mother's Day Nutty Indulgence Hamper
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [video_as_images] => Array
                    (
                    )
    
                [videos] => Array
                    (
                    )
    
                [brand_name] => Kokomae
            )
    
    )
    
    
  2. end of fxn
    
  1. Array
    (
        [show_master_products_only] => 
        [area] => C
        [pid] => 29793
        [limit] => 1
        [total] => 1
        [custom_extend] => Array
            (
                [0] => product_name
                [1] => categories
            )
    
        [load_products_extra_data] => 
        [force_virtual] => 1
        [runtime_company_id] => 0
        [vr_company_id] => 0
        [is_virtual] => Y
        [virtual_conditions] => Array
            (
                [set] => all
                [set_value] => 1
                [conditions] => Array
                    (
                        [1] => Array
                            (
                                [operator] => in
                                [condition] => categories
                                [value] => 274,275,276,277,278,281,282,284,285,287,288,290,296,432,508,579,620,621,745,1011,1096,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1181,1182,1183,1184,1185,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1202,1203,1204,1205,1206,1207,1208,1209,1214,1215,1216,1217,1218,1238,1270,1364,1632,1648,1703,1704,1977,2040,2116,2117,2118,2141,2191,2242,2250,2251,2322,2366,2421,2437,2439,2440,2444,2445,2456,2457,2458,2465,2468,2469,2472,2474,2476,2477,2481,2483,2485,2486,2489,2492,2497,2498,458,1186,2438,2453,2463,2473,2488,2494,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2654,2655,2656,2657,2658,2659,2660,2661,2662,2663,2664,2665,2666,2667,2668,2669,2670,2671,2672,2673,2674,2675,2676,2677,2678,2679,2680,2681,2682,2683,2684
                            )
    
                    )
    
            )
    
    )
    
    
  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] => 1
        [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 ?: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  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  ((1  AND  products.product_id IN (29793)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products_categories.category_id IN (458, 1648, 274, 275, 276, 277, 278, 281, 282, 284, 285, 287, 288, 290, 296, 432, 2662, 508, 579, 1632, 620, 621, 745, 1011, 1096, 1218, 1153, 1154, 1155, 1156, 1157, 1158, 1159, 1160, 1161, 1162, 1163, 1164, 1165, 1166, 1167, 1168, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1214, 1215, 1216, 1217, 1238, 1270, 1364, 1704, 1703, 1977, 2040, 2116, 2117, 2118, 2141, 2191, 2242, 2661, 2250, 2251, 2488, 2421, 2322, 2366, 2656, 2437, 2438, 2439, 2440, 2645, 2659, 2444, 2445, 2663, 2658, 2654, 2453, 2643, 2644, 2456, 2457, 2458, 2653, 2651, 2652, 2463, 2465, 2640, 2468, 2469, 2649, 2650, 2472, 2473, 2474, 2646, 2476, 2477, 2648, 2684, 2481, 2660, 2642, 2483, 2485, 2486, 2489, 2647, 2641, 2492, 2494, 2655, 2497, 2498, 2657, 2664, 2666, 2665, 2667, 2668, 2669, 2670, 2671, 2672, 2673, 2674, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1
    
  1. before end of oxn
    
  2. Array
    (
        [29793] => Array
            (
                [product_id] => 29793
                [product] => Mother's Day Nutty Indulgence Hamper
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [video_as_images] => Array
                    (
                    )
    
                [videos] => Array
                    (
                    )
    
                [brand_name] => Kokomae
            )
    
    )
    
    
  1. Array
    (
        [29793] => Array
            (
                [product_id] => 29793
                [product] => Mother's Day Nutty Indulgence Hamper
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [video_as_images] => Array
                    (
                    )
    
                [videos] => Array
                    (
                    )
    
                [brand_name] => Kokomae
            )
    
    )
    
    
  2. end of fxn
    
  1. Array
    (
        [show_master_products_only] => 
        [area] => C
        [pid] => 29793
        [limit] => 1
        [total] => 1
        [custom_extend] => Array
            (
                [0] => product_name
                [1] => categories
            )
    
        [load_products_extra_data] => 
        [force_virtual] => 1
        [runtime_company_id] => 0
        [vr_company_id] => 0
        [is_virtual] => Y
        [virtual_conditions] => Array
            (
                [set] => all
                [set_value] => 1
                [conditions] => Array
                    (
                        [1] => Array
                            (
                                [operator] => in
                                [condition] => categories
                                [value] => 458,1186,2438,2453,2463,2473,2488,2494,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2654,2655,2656,2657,2658,2659,2660,2661,2662,2663,2664,2665,2666,2667,2668,2669,2670,2671,2672,2673,2674,2675,2676,2677,2678,2679,2680,2681,2682,2683,2684
                            )
    
                    )
    
            )
    
    )
    
    
  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] => 1
        [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 ?: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  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  ((1  AND  products.product_id IN (29793)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products_categories.category_id IN (458, 2662, 1186, 2661, 2488, 2656, 2438, 2645, 2659, 2663, 2658, 2654, 2453, 2643, 2644, 2653, 2651, 2652, 2463, 2640, 2649, 2650, 2473, 2646, 2648, 2684, 2660, 2642, 2647, 2641, 2494, 2655, 2657, 2664, 2666, 2665, 2667, 2668, 2669, 2670, 2671, 2672, 2673, 2674, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1
    
  1. before end of oxn
    
  2. Array
    (
        [29793] => Array
            (
                [product_id] => 29793
                [product] => Mother's Day Nutty Indulgence Hamper
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [video_as_images] => Array
                    (
                    )
    
                [videos] => Array
                    (
                    )
    
                [brand_name] => Kokomae
            )
    
    )
    
    
  1. Array
    (
        [29793] => Array
            (
                [product_id] => 29793
                [product] => Mother's Day Nutty Indulgence Hamper
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [video_as_images] => Array
                    (
                    )
    
                [videos] => Array
                    (
                    )
    
                [brand_name] => Kokomae
            )
    
    )
    
    
  2. end of fxn
    
  1. Array
    (
        [show_master_products_only] => 
        [area] => C
        [pid] => 29794
        [limit] => 1
        [total] => 1
        [custom_extend] => Array
            (
                [0] => product_name
                [1] => categories
            )
    
        [load_products_extra_data] => 
        [force_virtual] => 1
        [runtime_company_id] => 0
        [vr_company_id] => 0
        [is_virtual] => Y
        [virtual_conditions] => Array
            (
                [set] => all
                [set_value] => 1
                [conditions] => Array
                    (
                        [1] => Array
                            (
                                [operator] => in
                                [condition] => products
                                [value] => 3556,3976,14830,15216,23660,28537,32931,35638,35639,36366,37916,39004,39636,58631,63910,63916,63922,65282
                            )
    
                    )
    
            )
    
    )
    
    
  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] => 1
        [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 ?: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  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  ((1  AND  products.product_id IN (29794)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products.product_id IN (3556,3976,14830,15216,23660,28537,32931,35638,35639,36366,37916,39004,39636,58631,63910,63916,63922,65282)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1
    
  1. before end of oxn
    
  2. Array
    (
    )
    
    
  1. Array
    (
    )
    
    
  2. end of fxn
    
  1. Array
    (
        [show_master_products_only] => 
        [area] => C
        [pid] => 29794
        [limit] => 1
        [total] => 1
        [custom_extend] => Array
            (
                [0] => product_name
                [1] => categories
            )
    
        [load_products_extra_data] => 
        [force_virtual] => 1
        [runtime_company_id] => 0
        [vr_company_id] => 0
        [is_virtual] => Y
        [virtual_conditions] => Array
            (
                [set] => all
                [set_value] => 1
                [conditions] => Array
                    (
                        [1] => Array
                            (
                                [condition_element] => 62
                                [operator] => nin
                                [condition] => feature
                                [value] => 49321,40971,38308
                                [value_name] => 
                            )
    
                    )
    
            )
    
        [include_child_variations] => 1
    )
    
    
  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] => 1
        [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 ?: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_features_values AS pfv_62 ON pfv_62.product_id = products.product_id AND pfv_62.feature_id = 62 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  ((1  AND  products.product_id IN (29794)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND pfv_62.variant_id NOT IN (49321,40971,38308)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1
    
  1. before end of oxn
    
  2. Array
    (
        [29794] => Array
            (
                [product_id] => 29794
                [product] => Mother's Day Indian Chocolate Treats Hamper
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [video_as_images] => Array
                    (
                    )
    
                [videos] => Array
                    (
                    )
    
                [brand_name] => Kokomae
            )
    
    )
    
    
  1. Array
    (
        [29794] => Array
            (
                [product_id] => 29794
                [product] => Mother's Day Indian Chocolate Treats Hamper
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [video_as_images] => Array
                    (
                    )
    
                [videos] => Array
                    (
                    )
    
                [brand_name] => Kokomae
            )
    
    )
    
    
  2. end of fxn
    
  1. Array
    (
        [show_master_products_only] => 
        [area] => C
        [pid] => 29794
        [limit] => 1
        [total] => 1
        [custom_extend] => Array
            (
                [0] => product_name
                [1] => categories
            )
    
        [load_products_extra_data] => 
        [force_virtual] => 1
        [runtime_company_id] => 0
        [vr_company_id] => 0
        [is_virtual] => Y
        [virtual_conditions] => Array
            (
                [set] => all
                [set_value] => 1
                [conditions] => Array
                    (
                        [1] => Array
                            (
                                [operator] => in
                                [condition] => categories
                                [value] => 274,275,276,277,278,281,282,284,285,287,288,290,296,432,508,579,620,621,745,1011,1096,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1181,1182,1183,1184,1185,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1202,1203,1204,1205,1206,1207,1208,1209,1214,1215,1216,1217,1218,1238,1270,1364,1632,1648,1703,1704,1977,2040,2116,2117,2118,2141,2191,2242,2250,2251,2322,2366,2421,2437,2439,2440,2444,2445,2456,2457,2458,2465,2468,2469,2472,2474,2476,2477,2481,2483,2485,2486,2489,2492,2497,2498,458,1186,2438,2453,2463,2473,2488,2494,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2654,2655,2656,2657,2658,2659,2660,2661,2662,2663,2664,2665,2666,2667,2668,2669,2670,2671,2672,2673,2674,2675,2676,2677,2678,2679,2680,2681,2682,2683,2684
                            )
    
                    )
    
            )
    
    )
    
    
  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] => 1
        [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 ?: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  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  ((1  AND  products.product_id IN (29794)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products_categories.category_id IN (458, 1648, 274, 275, 276, 277, 278, 281, 282, 284, 285, 287, 288, 290, 296, 432, 2662, 508, 579, 1632, 620, 621, 745, 1011, 1096, 1218, 1153, 1154, 1155, 1156, 1157, 1158, 1159, 1160, 1161, 1162, 1163, 1164, 1165, 1166, 1167, 1168, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1214, 1215, 1216, 1217, 1238, 1270, 1364, 1704, 1703, 1977, 2040, 2116, 2117, 2118, 2141, 2191, 2242, 2661, 2250, 2251, 2488, 2421, 2322, 2366, 2656, 2437, 2438, 2439, 2440, 2645, 2659, 2444, 2445, 2663, 2658, 2654, 2453, 2643, 2644, 2456, 2457, 2458, 2653, 2651, 2652, 2463, 2465, 2640, 2468, 2469, 2649, 2650, 2472, 2473, 2474, 2646, 2476, 2477, 2648, 2684, 2481, 2660, 2642, 2483, 2485, 2486, 2489, 2647, 2641, 2492, 2494, 2655, 2497, 2498, 2657, 2664, 2666, 2665, 2667, 2668, 2669, 2670, 2671, 2672, 2673, 2674, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1
    
  1. before end of oxn
    
  2. Array
    (
        [29794] => Array
            (
                [product_id] => 29794
                [product] => Mother's Day Indian Chocolate Treats Hamper
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [video_as_images] => Array
                    (
                    )
    
                [videos] => Array
                    (
                    )
    
                [brand_name] => Kokomae
            )
    
    )
    
    
  1. Array
    (
        [29794] => Array
            (
                [product_id] => 29794
                [product] => Mother's Day Indian Chocolate Treats Hamper
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [video_as_images] => Array
                    (
                    )
    
                [videos] => Array
                    (
                    )
    
                [brand_name] => Kokomae
            )
    
    )
    
    
  2. end of fxn
    
  1. Array
    (
        [show_master_products_only] => 
        [area] => C
        [pid] => 29794
        [limit] => 1
        [total] => 1
        [custom_extend] => Array
            (
                [0] => product_name
                [1] => categories
            )
    
        [load_products_extra_data] => 
        [force_virtual] => 1
        [runtime_company_id] => 0
        [vr_company_id] => 0
        [is_virtual] => Y
        [virtual_conditions] => Array
            (
                [set] => all
                [set_value] => 1
                [conditions] => Array
                    (
                        [1] => Array
                            (
                                [operator] => in
                                [condition] => categories
                                [value] => 458,1186,2438,2453,2463,2473,2488,2494,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2654,2655,2656,2657,2658,2659,2660,2661,2662,2663,2664,2665,2666,2667,2668,2669,2670,2671,2672,2673,2674,2675,2676,2677,2678,2679,2680,2681,2682,2683,2684
                            )
    
                    )
    
            )
    
    )
    
    
  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] => 1
        [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 ?: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  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  ((1  AND  products.product_id IN (29794)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products_categories.category_id IN (458, 2662, 1186, 2661, 2488, 2656, 2438, 2645, 2659, 2663, 2658, 2654, 2453, 2643, 2644, 2653, 2651, 2652, 2463, 2640, 2649, 2650, 2473, 2646, 2648, 2684, 2660, 2642, 2647, 2641, 2494, 2655, 2657, 2664, 2666, 2665, 2667, 2668, 2669, 2670, 2671, 2672, 2673, 2674, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1
    
  1. before end of oxn
    
  2. Array
    (
        [29794] => Array
            (
                [product_id] => 29794
                [product] => Mother's Day Indian Chocolate Treats Hamper
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [video_as_images] => Array
                    (
                    )
    
                [videos] => Array
                    (
                    )
    
                [brand_name] => Kokomae
            )
    
    )
    
    
  1. Array
    (
        [29794] => Array
            (
                [product_id] => 29794
                [product] => Mother's Day Indian Chocolate Treats Hamper
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [video_as_images] => Array
                    (
                    )
    
                [videos] => Array
                    (
                    )
    
                [brand_name] => Kokomae
            )
    
    )
    
    
  2. end of fxn
    
  1. Array
    (
        [show_master_products_only] => 
        [area] => C
        [currency] => EUR
        [sl] => en
        [dispatch] => categories.view
        [category_id] => 438
        [page] => 7
        [save_view_results] => product_id
        [items_per_page] => 24
        [sort_by] => bestsellers
        [sort_order] => desc
        [cid] => 438
        [extend] => Array
            (
                [0] => categories
                [1] => description
                [2] => description
                [3] => full_description
            )
    
        [subcats] => Y
        [runtime_company_id] => 0
    )
    
    
  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] => 24
        [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. before end of oxn
    
  2. Array
    (
        [29793] => Array
            (
                [product_id] => 29793
                [product] => Mother's Day Nutty Indulgence Hamper
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [product_code] => Kokomae_MD8
                [hsn_code] => 3304
                [status] => A
                [list_price] => 1780.00
                [amount] => 100
                [weight] => 0.000
                [length] => 0
                [width] => 0
                [height] => 0
                [shipping_freight] => 0.00
                [low_avail_limit] => 0
                [timestamp] => 1683267706
                [updated_timestamp] => 1750246019
                [usergroup_ids] => 0
                [is_edp] => N
                [edp_shipping] => N
                [unlimited_download] => N
                [tracking] => B
                [free_shipping] => N
                [zero_price_action] => R
                [is_pbp] => Y
                [is_op] => N
                [is_oper] => N
                [is_returnable] => Y
                [return_period] => 10
                [avail_since] => 0
                [out_of_stock_actions] => N
                [localization] => 
                [min_qty] => 0
                [max_qty] => 5
                [qty_step] => 0
                [list_qty_count] => 0
                [tax_ids] => 13
                [age_verification] => N
                [age_limit] => 0
                [options_type] => P
                [exceptions_type] => F
                [details_layout] => default
                [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
                [facebook_obj_type] => 
                [buy_now_url] => 
                [is_stock_split_by_warehouses] => N
                [master_product_status] => A
                [youtube_link] => 
                [show_youtube_video] => Y
                [replace_main_image] => 
                [position_youtube] => 
                [restrict_cod] => N
                [price] => 1691.000000
                [short_description] => Exclusive Mother's Day hamper with Belgian chocolate covered roasted nuts.
                [full_description] => <p>Introducing our exclusive Mother's Day hamper, carefully curated to provide your beloved mom with the ultimate chocolate experience! Our hamper features a luxurious selection of whole roasted nuts covered in premium Belgian chocolate, offering the perfect combination of smooth and silky chocolate with the satisfying crunch of roasted nuts. Each chocolate is hand-crafted with the finest ingredients to ensure a rich and decadent flavor that's simply irresistible. All of these delicious treats are packed in a gorgeous box, making it the perfect gift for your mom on this special day. Order now and show your mom how much you appreciate and adore her!Coated nuts in jars ( 3 different flavors) <br />(i) Coated Hazelnut in Belgian Dark chocolate<br />(ii) Coated Almond in Belgian Milk chocolate<br />(iii) Coated Orange Peel in Belgian Dark chocolate</p>
                [category_ids] => Array
                    (
                        [0] => 438
                        [1] => 2648
                    )
    
                [position] => 0
                [seo_name] => mothers-day-nutty-indulgence-hamper
                [seo_path] => 458/2646/2648
                [main_category] => 2648
                [options_type_raw] => P
                [exceptions_type_raw] => F
                [tracking_raw] => B
                [zero_price_action_raw] => R
                [min_qty_raw] => 0
                [max_qty_raw] => 5
                [qty_step_raw] => 0
                [list_qty_count_raw] => 0
                [details_layout_raw] => default
                [video_as_images] => Array
                    (
                    )
    
                [videos] => Array
                    (
                    )
    
                [brand_name] => Kokomae
            )
    
        [29794] => Array
            (
                [product_id] => 29794
                [product] => Mother's Day Indian Chocolate Treats Hamper
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [product_code] => Kokomae_MD9
                [hsn_code] => 3304
                [status] => A
                [list_price] => 1780.00
                [amount] => 100
                [weight] => 0.000
                [length] => 0
                [width] => 0
                [height] => 0
                [shipping_freight] => 0.00
                [low_avail_limit] => 0
                [timestamp] => 1683267706
                [updated_timestamp] => 1750246019
                [usergroup_ids] => 0
                [is_edp] => N
                [edp_shipping] => N
                [unlimited_download] => N
                [tracking] => B
                [free_shipping] => N
                [zero_price_action] => R
                [is_pbp] => Y
                [is_op] => N
                [is_oper] => N
                [is_returnable] => Y
                [return_period] => 10
                [avail_since] => 0
                [out_of_stock_actions] => N
                [localization] => 
                [min_qty] => 0
                [max_qty] => 5
                [qty_step] => 0
                [list_qty_count] => 0
                [tax_ids] => 13
                [age_verification] => N
                [age_limit] => 0
                [options_type] => P
                [exceptions_type] => F
                [details_layout] => default
                [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
                [facebook_obj_type] => 
                [buy_now_url] => 
                [is_stock_split_by_warehouses] => N
                [master_product_status] => A
                [youtube_link] => 
                [show_youtube_video] => Y
                [replace_main_image] => 
                [position_youtube] => 
                [restrict_cod] => N
                [price] => 1691.000000
                [short_description] => Hand-crafted chocolate treats for a special Mother's Day.
                [full_description] => <p>Introducing our Mother's Day hamper, a gift basket that combines the deliciousness of whole roasted nuts enrobed in premium Indian chocolate. Packed in a stunning box, this hamper is the perfect way to show your mom how much you care and make her feel special on this Mother's Day. Hand-crafted with the finest ingredients, our chocolates offer a rich and authentic flavor that will satisfy your mom's taste buds. Order now and give your mom the gift of a delightful and unforgettable chocolate experience!Organic Coated nuts in jars (3 different flavors) <br />(i) Coated Coffee with White Chocolate<br />(ii) Caramalised Almond in 70% Dark Chocolate<br />(iii) Cashew Praline in 65% Dark Chocolate</p>
                [category_ids] => Array
                    (
                        [0] => 438
                        [1] => 2663
                    )
    
                [position] => 0
                [seo_name] => mothers-day-indian-chocolate-treats-hamper
                [seo_path] => 458/2654/2663
                [main_category] => 2663
                [options_type_raw] => P
                [exceptions_type_raw] => F
                [tracking_raw] => B
                [zero_price_action_raw] => R
                [min_qty_raw] => 0
                [max_qty_raw] => 5
                [qty_step_raw] => 0
                [list_qty_count_raw] => 0
                [details_layout_raw] => default
                [video_as_images] => Array
                    (
                    )
    
                [videos] => Array
                    (
                    )
    
                [brand_name] => Kokomae
            )
    
    )
    
    
  1. Array
    (
        [29793] => Array
            (
                [product_id] => 29793
                [product] => Mother's Day Nutty Indulgence Hamper
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [product_code] => Kokomae_MD8
                [hsn_code] => 3304
                [status] => A
                [list_price] => 1780.00
                [amount] => 100
                [weight] => 0.000
                [length] => 0
                [width] => 0
                [height] => 0
                [shipping_freight] => 0.00
                [low_avail_limit] => 0
                [timestamp] => 1683267706
                [updated_timestamp] => 1750246019
                [usergroup_ids] => 0
                [is_edp] => N
                [edp_shipping] => N
                [unlimited_download] => N
                [tracking] => B
                [free_shipping] => N
                [zero_price_action] => R
                [is_pbp] => Y
                [is_op] => N
                [is_oper] => N
                [is_returnable] => Y
                [return_period] => 10
                [avail_since] => 0
                [out_of_stock_actions] => N
                [localization] => 
                [min_qty] => 0
                [max_qty] => 5
                [qty_step] => 0
                [list_qty_count] => 0
                [tax_ids] => 13
                [age_verification] => N
                [age_limit] => 0
                [options_type] => P
                [exceptions_type] => F
                [details_layout] => default
                [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
                [facebook_obj_type] => 
                [buy_now_url] => 
                [is_stock_split_by_warehouses] => N
                [master_product_status] => A
                [youtube_link] => 
                [show_youtube_video] => Y
                [replace_main_image] => 
                [position_youtube] => 
                [restrict_cod] => N
                [price] => 1691.000000
                [short_description] => Exclusive Mother's Day hamper with Belgian chocolate covered roasted nuts.
                [full_description] => <p>Introducing our exclusive Mother's Day hamper, carefully curated to provide your beloved mom with the ultimate chocolate experience! Our hamper features a luxurious selection of whole roasted nuts covered in premium Belgian chocolate, offering the perfect combination of smooth and silky chocolate with the satisfying crunch of roasted nuts. Each chocolate is hand-crafted with the finest ingredients to ensure a rich and decadent flavor that's simply irresistible. All of these delicious treats are packed in a gorgeous box, making it the perfect gift for your mom on this special day. Order now and show your mom how much you appreciate and adore her!Coated nuts in jars ( 3 different flavors) <br />(i) Coated Hazelnut in Belgian Dark chocolate<br />(ii) Coated Almond in Belgian Milk chocolate<br />(iii) Coated Orange Peel in Belgian Dark chocolate</p>
                [category_ids] => Array
                    (
                        [0] => 438
                        [1] => 2648
                    )
    
                [position] => 0
                [seo_name] => mothers-day-nutty-indulgence-hamper
                [seo_path] => 458/2646/2648
                [main_category] => 2648
                [options_type_raw] => P
                [exceptions_type_raw] => F
                [tracking_raw] => B
                [zero_price_action_raw] => R
                [min_qty_raw] => 0
                [max_qty_raw] => 5
                [qty_step_raw] => 0
                [list_qty_count_raw] => 0
                [details_layout_raw] => default
                [video_as_images] => Array
                    (
                    )
    
                [videos] => Array
                    (
                    )
    
                [brand_name] => Kokomae
            )
    
        [29794] => Array
            (
                [product_id] => 29794
                [product] => Mother's Day Indian Chocolate Treats Hamper
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [product_code] => Kokomae_MD9
                [hsn_code] => 3304
                [status] => A
                [list_price] => 1780.00
                [amount] => 100
                [weight] => 0.000
                [length] => 0
                [width] => 0
                [height] => 0
                [shipping_freight] => 0.00
                [low_avail_limit] => 0
                [timestamp] => 1683267706
                [updated_timestamp] => 1750246019
                [usergroup_ids] => 0
                [is_edp] => N
                [edp_shipping] => N
                [unlimited_download] => N
                [tracking] => B
                [free_shipping] => N
                [zero_price_action] => R
                [is_pbp] => Y
                [is_op] => N
                [is_oper] => N
                [is_returnable] => Y
                [return_period] => 10
                [avail_since] => 0
                [out_of_stock_actions] => N
                [localization] => 
                [min_qty] => 0
                [max_qty] => 5
                [qty_step] => 0
                [list_qty_count] => 0
                [tax_ids] => 13
                [age_verification] => N
                [age_limit] => 0
                [options_type] => P
                [exceptions_type] => F
                [details_layout] => default
                [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
                [facebook_obj_type] => 
                [buy_now_url] => 
                [is_stock_split_by_warehouses] => N
                [master_product_status] => A
                [youtube_link] => 
                [show_youtube_video] => Y
                [replace_main_image] => 
                [position_youtube] => 
                [restrict_cod] => N
                [price] => 1691.000000
                [short_description] => Hand-crafted chocolate treats for a special Mother's Day.
                [full_description] => <p>Introducing our Mother's Day hamper, a gift basket that combines the deliciousness of whole roasted nuts enrobed in premium Indian chocolate. Packed in a stunning box, this hamper is the perfect way to show your mom how much you care and make her feel special on this Mother's Day. Hand-crafted with the finest ingredients, our chocolates offer a rich and authentic flavor that will satisfy your mom's taste buds. Order now and give your mom the gift of a delightful and unforgettable chocolate experience!Organic Coated nuts in jars (3 different flavors) <br />(i) Coated Coffee with White Chocolate<br />(ii) Caramalised Almond in 70% Dark Chocolate<br />(iii) Cashew Praline in 65% Dark Chocolate</p>
                [category_ids] => Array
                    (
                        [0] => 438
                        [1] => 2663
                    )
    
                [position] => 0
                [seo_name] => mothers-day-indian-chocolate-treats-hamper
                [seo_path] => 458/2654/2663
                [main_category] => 2663
                [options_type_raw] => P
                [exceptions_type_raw] => F
                [tracking_raw] => B
                [zero_price_action_raw] => R
                [min_qty_raw] => 0
                [max_qty_raw] => 5
                [qty_step_raw] => 0
                [list_qty_count_raw] => 0
                [details_layout_raw] => default
                [video_as_images] => Array
                    (
                    )
    
                [videos] => Array
                    (
                    )
    
                [brand_name] => Kokomae
            )
    
    )
    
    
  2. end of fxn
    
  1. Array
    (
        [show_master_products_only] => 
        [area] => C
        [for_required_product] => 29793
        [include_child_variations] => 1
        [group_child_variations] => 
        [runtime_company_id] => 0
    )
    
    
  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 ?:master_products_storefront_offers_count AS master_products_storefront_offers_count  ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 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 products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) AND ?:product_required_products.product_id = 29793 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
    
  1. Array
    (
        [show_master_products_only] => 
        [area] => C
        [for_required_product] => 29794
        [include_child_variations] => 1
        [group_child_variations] => 
        [runtime_company_id] => 0
    )
    
    
  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 ?:master_products_storefront_offers_count AS master_products_storefront_offers_count  ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 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 products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) AND ?:product_required_products.product_id = 29794 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
    
Super Combos - page 7

Error

Message

Cannot create references to/from string offsets

Error at

app/Tygh/Registry.php, line: 221

Backtrace

File:app/Tygh/Registry.php
Line:89
Function:_varByKey
File:app/addons/seo/Tygh/SeoCache.php
Line:111
Function:set
File:app/addons/seo/Tygh/SeoCache.php
Line:49
Function:setStatic
File:app/addons/seo/func.php
Line:1329
Function:set
File:app/addons/seo/func.php
Line:1563
Function:fn_seo_get_name
File:app/functions/fn.control.php
Line:123
Function:fn_seo_url_post
File:app/functions/fn.common.php
Line:3921
Function:fn_set_hook
File:app/Tygh/BlockManager/Container.php
Line:496
Function:fn_url
File:app/Tygh/BlockManager/Container.php
Line:517
Function:getConfigurationUrl
File:app/Tygh/BlockManager/Container.php
Line:120
Function:addBlockManagerProperties
File:app/Tygh/BlockManager/RenderManager.php
Line:127
Function:getListByArea
File:app/functions/smarty_plugins/function.render_location.php
Line:50
Function:__construct
File:var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php
Line:191
Function:smarty_function_render_location
File:app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php
Line:188
Function:content_689464c1dbc0b1_26812820
File:app/Tygh/SmartyEngine/Core.php
Line:81
Function:fetch
File:app/functions/fn.control.php
Line:636
Function:fetch
File:index.php
Line:39
Function:fn_dispatch