Array
(
    [show_master_products_only] => 
    [area] => C
    [currency] => USD
    [features_hash] => 28-52264
    [sl] => en
    [dispatch] => categories.view
    [category_id] => 2813
    [save_view_results] => product_id
    [items_per_page] => 24
    [sort_by] => bestsellers
    [sort_order] => desc
    [cid] => 2813
    [extend] => Array
        (
            [0] => categories
            [1] => description
            [2] => description
            [3] => full_description
        )

    [subcats] => Y
    [runtime_company_id] => 0
)

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] => 
)

Advanced and feature filters

before hook

after hook

C

1

before 2nd hook

after 2nd hook

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_features_values as var_val_73 ON var_val_73.product_id = products.product_id AND var_val_73.lang_code = 'en' AND var_val_73.feature_id = 73 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 (var_val_73.variant_id IN (52264)) AND ?:categories.category_id IN (2813) 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 0, 24

before end of oxn

Array
(
    [66795] => Array
        (
            [product_id] => 66795
            [product] => Sunglaze Sunscreen SPF 50 PA ++++ with Probiotic & Ceramides (50ml)
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 502
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => CC30
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1099.00
            [amount] => 26
            [weight] => 50.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1746265071
            [updated_timestamp] => 1750167663
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => N
            [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] => 0
            [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] => 1022.070000
            [short_description] => <p>Hydrating, glow-boosting hybrid sunscreen</p>
            [full_description] => <p>SunGlaze Water-Gel is a hybrid sunscreen with Probiotics & Ceramides that offers SPF 50+ and PA++++, providing broad-spectrum protection against UVA/UVB rays and blue light. Its water- and sweat-resistant formula hydrates, strengthens the skin barrier, and delivers a radiant glow, thanks to Probiotics and Ceramides. The lightweight, non-greasy texture absorbs quickly into the skin without leaving any white cast behind, making it perfect for all skin types and daily use.<br />1.Broad-Spectrum UV Protection: Offers SPF 50+ and PA++++, protecting from UVA/UVB rays and blue light.<br />Helps prevent premature aging, hyperpigmentation, and sun damage.<br />2. Deep Hydration & Moisturization: Contains Hyaluronic Acid and Glycerin to lock in moisture, leaving skin plump and hydrated throughout the day.<br />3. Skin Barrier Support: Ceramides and Cholesterol strengthen the skin’s natural barrier, protecting against environmental aggressors and reducing water loss.<br />4. Brightening & Radiance Boost: Rice Extract brightens, evens skin tone, and improves luminosity for a radiant finish.<br />5. Anti-Aging & Repair: Vitamin E and Sunflower Seed Oil fight free radicals, reduce aging signs, and repair the skin. Aloe Vera and Allantoin soothe and calm the skin, reducing irritation.<br />6. Lightweight, Non-Greasy Formula: Fast-absorbing, non-comedogenic, and leaves no white cast, making it ideal for all skin types.<br />7. Inspired by Japanese Skincare: Incorporates advanced ceramide complexes, rice extracts, and fermentation techniques to enhance ingredient efficacy and skin compatibility.<br />8. Perfect for Daily Use: Ideal for all skin types, including sensitive skin, thanks to soothing ingredients like Aloe Vera and Allantoin.</p>
            [category_ids] => Array
                (
                    [0] => 2813
                )

            [position] => 0
            [seo_name] => sunglaze-sunscreen-spf-50-pa-with-probiotic-and-ceramides-50ml
            [seo_path] => 2685/2708/2813
            [main_category] => 2813
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 0
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                )

            [brand_name] => ClayCo.
        )

    [37615] => Array
        (
            [product_id] => 37615
            [product] => Mini UV Aqua Rich Watery Essence Sunscreen SPF 50+ PA++++15g
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 704
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => 4901301413246_mini
            [hsn_code] => 3304
            [status] => A
            [list_price] => 450.00
            [amount] => 2
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1718701275
            [updated_timestamp] => 1750427156
            [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] => 360.000000
            [short_description] => <p>Covers skin to micro levels</p>
            [full_description] => <p>This sunscreen has a transparent texture and provides a light sensation on the skin, even when reapplying during the day. The watery essence sunscreen for protection from damaging UV rays. It is enriched with hyaluronic acid, royal jelly extract and butylene glycol. The aqua microcapsules release moisture upon application. It has a lightweight texture that spreads easily without leaving a white cast. It is water-resistant for up to 80 minutes. It is suitable for the face and body and makes a good makeup base. It is non-comedogenic and allergy-tested. It has no added colour.</p>
            [category_ids] => Array
                (
                    [0] => 2813
                    [1] => 2816
                )

            [position] => 0
            [seo_name] => mini-uv-aqua-rich-watery-essence-sunscreen-spf-50-pa15g
            [seo_path] => 2685/2708/2816
            [average_rating] => 5.00
            [reviews_count] => 1
            [main_category] => 2816
            [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] => Biore
            [ratting_count] => 1
        )

)

Array
(
    [66795] => Array
        (
            [product_id] => 66795
            [product] => Sunglaze Sunscreen SPF 50 PA ++++ with Probiotic & Ceramides (50ml)
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 502
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => CC30
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1099.00
            [amount] => 26
            [weight] => 50.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1746265071
            [updated_timestamp] => 1750167663
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => N
            [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] => 0
            [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] => 1022.070000
            [short_description] => <p>Hydrating, glow-boosting hybrid sunscreen</p>
            [full_description] => <p>SunGlaze Water-Gel is a hybrid sunscreen with Probiotics & Ceramides that offers SPF 50+ and PA++++, providing broad-spectrum protection against UVA/UVB rays and blue light. Its water- and sweat-resistant formula hydrates, strengthens the skin barrier, and delivers a radiant glow, thanks to Probiotics and Ceramides. The lightweight, non-greasy texture absorbs quickly into the skin without leaving any white cast behind, making it perfect for all skin types and daily use.<br />1.Broad-Spectrum UV Protection: Offers SPF 50+ and PA++++, protecting from UVA/UVB rays and blue light.<br />Helps prevent premature aging, hyperpigmentation, and sun damage.<br />2. Deep Hydration & Moisturization: Contains Hyaluronic Acid and Glycerin to lock in moisture, leaving skin plump and hydrated throughout the day.<br />3. Skin Barrier Support: Ceramides and Cholesterol strengthen the skin’s natural barrier, protecting against environmental aggressors and reducing water loss.<br />4. Brightening & Radiance Boost: Rice Extract brightens, evens skin tone, and improves luminosity for a radiant finish.<br />5. Anti-Aging & Repair: Vitamin E and Sunflower Seed Oil fight free radicals, reduce aging signs, and repair the skin. Aloe Vera and Allantoin soothe and calm the skin, reducing irritation.<br />6. Lightweight, Non-Greasy Formula: Fast-absorbing, non-comedogenic, and leaves no white cast, making it ideal for all skin types.<br />7. Inspired by Japanese Skincare: Incorporates advanced ceramide complexes, rice extracts, and fermentation techniques to enhance ingredient efficacy and skin compatibility.<br />8. Perfect for Daily Use: Ideal for all skin types, including sensitive skin, thanks to soothing ingredients like Aloe Vera and Allantoin.</p>
            [category_ids] => Array
                (
                    [0] => 2813
                )

            [position] => 0
            [seo_name] => sunglaze-sunscreen-spf-50-pa-with-probiotic-and-ceramides-50ml
            [seo_path] => 2685/2708/2813
            [main_category] => 2813
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 0
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                )

            [brand_name] => ClayCo.
        )

    [37615] => Array
        (
            [product_id] => 37615
            [product] => Mini UV Aqua Rich Watery Essence Sunscreen SPF 50+ PA++++15g
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 704
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => 4901301413246_mini
            [hsn_code] => 3304
            [status] => A
            [list_price] => 450.00
            [amount] => 2
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1718701275
            [updated_timestamp] => 1750427156
            [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] => 360.000000
            [short_description] => <p>Covers skin to micro levels</p>
            [full_description] => <p>This sunscreen has a transparent texture and provides a light sensation on the skin, even when reapplying during the day. The watery essence sunscreen for protection from damaging UV rays. It is enriched with hyaluronic acid, royal jelly extract and butylene glycol. The aqua microcapsules release moisture upon application. It has a lightweight texture that spreads easily without leaving a white cast. It is water-resistant for up to 80 minutes. It is suitable for the face and body and makes a good makeup base. It is non-comedogenic and allergy-tested. It has no added colour.</p>
            [category_ids] => Array
                (
                    [0] => 2813
                    [1] => 2816
                )

            [position] => 0
            [seo_name] => mini-uv-aqua-rich-watery-essence-sunscreen-spf-50-pa15g
            [seo_path] => 2685/2708/2816
            [average_rating] => 5.00
            [reviews_count] => 1
            [main_category] => 2816
            [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] => Biore
            [ratting_count] => 1
        )

)

end of fxn

Array
(
    [show_master_products_only] => 
    [area] => C
    [currency] => USD
    [features_hash] => 28-52264
    [sl] => en
    [dispatch] => categories.view
    [category_id] => 2813
    [save_view_results] => product_id
    [items_per_page] => 24
    [sort_by] => bestsellers
    [sort_order] => desc
    [cid] => 2813
    [extend] => Array
        (
            [0] => categories
            [1] => description
            [2] => description
            [3] => full_description
        )

    [subcats] => Y
    [runtime_company_id] => 0
)

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] => 
)

Advanced and feature filters

before hook

after hook

C

1

before 2nd hook

after 2nd hook

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_features_values as var_val_73 ON var_val_73.product_id = products.product_id AND var_val_73.lang_code = 'en' AND var_val_73.feature_id = 73 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 (var_val_73.variant_id IN (52264)) AND ?:categories.category_id IN (2813) 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 0, 24

before end of oxn

Array
(
    [66795] => Array
        (
            [product_id] => 66795
            [product] => Sunglaze Sunscreen SPF 50 PA ++++ with Probiotic & Ceramides (50ml)
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 502
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => CC30
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1099.00
            [amount] => 26
            [weight] => 50.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1746265071
            [updated_timestamp] => 1750167663
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => N
            [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] => 0
            [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] => 1022.070000
            [short_description] => <p>Hydrating, glow-boosting hybrid sunscreen</p>
            [full_description] => <p>SunGlaze Water-Gel is a hybrid sunscreen with Probiotics & Ceramides that offers SPF 50+ and PA++++, providing broad-spectrum protection against UVA/UVB rays and blue light. Its water- and sweat-resistant formula hydrates, strengthens the skin barrier, and delivers a radiant glow, thanks to Probiotics and Ceramides. The lightweight, non-greasy texture absorbs quickly into the skin without leaving any white cast behind, making it perfect for all skin types and daily use.<br />1.Broad-Spectrum UV Protection: Offers SPF 50+ and PA++++, protecting from UVA/UVB rays and blue light.<br />Helps prevent premature aging, hyperpigmentation, and sun damage.<br />2. Deep Hydration & Moisturization: Contains Hyaluronic Acid and Glycerin to lock in moisture, leaving skin plump and hydrated throughout the day.<br />3. Skin Barrier Support: Ceramides and Cholesterol strengthen the skin’s natural barrier, protecting against environmental aggressors and reducing water loss.<br />4. Brightening & Radiance Boost: Rice Extract brightens, evens skin tone, and improves luminosity for a radiant finish.<br />5. Anti-Aging & Repair: Vitamin E and Sunflower Seed Oil fight free radicals, reduce aging signs, and repair the skin. Aloe Vera and Allantoin soothe and calm the skin, reducing irritation.<br />6. Lightweight, Non-Greasy Formula: Fast-absorbing, non-comedogenic, and leaves no white cast, making it ideal for all skin types.<br />7. Inspired by Japanese Skincare: Incorporates advanced ceramide complexes, rice extracts, and fermentation techniques to enhance ingredient efficacy and skin compatibility.<br />8. Perfect for Daily Use: Ideal for all skin types, including sensitive skin, thanks to soothing ingredients like Aloe Vera and Allantoin.</p>
            [category_ids] => Array
                (
                    [0] => 2813
                )

            [position] => 0
            [seo_name] => sunglaze-sunscreen-spf-50-pa-with-probiotic-and-ceramides-50ml
            [seo_path] => 2685/2708/2813
            [main_category] => 2813
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 0
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                )

            [brand_name] => ClayCo.
        )

    [37615] => Array
        (
            [product_id] => 37615
            [product] => Mini UV Aqua Rich Watery Essence Sunscreen SPF 50+ PA++++15g
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 704
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => 4901301413246_mini
            [hsn_code] => 3304
            [status] => A
            [list_price] => 450.00
            [amount] => 2
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1718701275
            [updated_timestamp] => 1750427156
            [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] => 360.000000
            [short_description] => <p>Covers skin to micro levels</p>
            [full_description] => <p>This sunscreen has a transparent texture and provides a light sensation on the skin, even when reapplying during the day. The watery essence sunscreen for protection from damaging UV rays. It is enriched with hyaluronic acid, royal jelly extract and butylene glycol. The aqua microcapsules release moisture upon application. It has a lightweight texture that spreads easily without leaving a white cast. It is water-resistant for up to 80 minutes. It is suitable for the face and body and makes a good makeup base. It is non-comedogenic and allergy-tested. It has no added colour.</p>
            [category_ids] => Array
                (
                    [0] => 2813
                    [1] => 2816
                )

            [position] => 0
            [seo_name] => mini-uv-aqua-rich-watery-essence-sunscreen-spf-50-pa15g
            [seo_path] => 2685/2708/2816
            [average_rating] => 5.00
            [reviews_count] => 1
            [main_category] => 2816
            [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] => Biore
            [ratting_count] => 1
        )

)

Array
(
    [66795] => Array
        (
            [product_id] => 66795
            [product] => Sunglaze Sunscreen SPF 50 PA ++++ with Probiotic & Ceramides (50ml)
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 502
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => CC30
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1099.00
            [amount] => 26
            [weight] => 50.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1746265071
            [updated_timestamp] => 1750167663
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => N
            [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] => 0
            [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] => 1022.070000
            [short_description] => <p>Hydrating, glow-boosting hybrid sunscreen</p>
            [full_description] => <p>SunGlaze Water-Gel is a hybrid sunscreen with Probiotics & Ceramides that offers SPF 50+ and PA++++, providing broad-spectrum protection against UVA/UVB rays and blue light. Its water- and sweat-resistant formula hydrates, strengthens the skin barrier, and delivers a radiant glow, thanks to Probiotics and Ceramides. The lightweight, non-greasy texture absorbs quickly into the skin without leaving any white cast behind, making it perfect for all skin types and daily use.<br />1.Broad-Spectrum UV Protection: Offers SPF 50+ and PA++++, protecting from UVA/UVB rays and blue light.<br />Helps prevent premature aging, hyperpigmentation, and sun damage.<br />2. Deep Hydration & Moisturization: Contains Hyaluronic Acid and Glycerin to lock in moisture, leaving skin plump and hydrated throughout the day.<br />3. Skin Barrier Support: Ceramides and Cholesterol strengthen the skin’s natural barrier, protecting against environmental aggressors and reducing water loss.<br />4. Brightening & Radiance Boost: Rice Extract brightens, evens skin tone, and improves luminosity for a radiant finish.<br />5. Anti-Aging & Repair: Vitamin E and Sunflower Seed Oil fight free radicals, reduce aging signs, and repair the skin. Aloe Vera and Allantoin soothe and calm the skin, reducing irritation.<br />6. Lightweight, Non-Greasy Formula: Fast-absorbing, non-comedogenic, and leaves no white cast, making it ideal for all skin types.<br />7. Inspired by Japanese Skincare: Incorporates advanced ceramide complexes, rice extracts, and fermentation techniques to enhance ingredient efficacy and skin compatibility.<br />8. Perfect for Daily Use: Ideal for all skin types, including sensitive skin, thanks to soothing ingredients like Aloe Vera and Allantoin.</p>
            [category_ids] => Array
                (
                    [0] => 2813
                )

            [position] => 0
            [seo_name] => sunglaze-sunscreen-spf-50-pa-with-probiotic-and-ceramides-50ml
            [seo_path] => 2685/2708/2813
            [main_category] => 2813
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 0
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                )

            [brand_name] => ClayCo.
        )

    [37615] => Array
        (
            [product_id] => 37615
            [product] => Mini UV Aqua Rich Watery Essence Sunscreen SPF 50+ PA++++15g
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 704
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => 4901301413246_mini
            [hsn_code] => 3304
            [status] => A
            [list_price] => 450.00
            [amount] => 2
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1718701275
            [updated_timestamp] => 1750427156
            [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] => 360.000000
            [short_description] => <p>Covers skin to micro levels</p>
            [full_description] => <p>This sunscreen has a transparent texture and provides a light sensation on the skin, even when reapplying during the day. The watery essence sunscreen for protection from damaging UV rays. It is enriched with hyaluronic acid, royal jelly extract and butylene glycol. The aqua microcapsules release moisture upon application. It has a lightweight texture that spreads easily without leaving a white cast. It is water-resistant for up to 80 minutes. It is suitable for the face and body and makes a good makeup base. It is non-comedogenic and allergy-tested. It has no added colour.</p>
            [category_ids] => Array
                (
                    [0] => 2813
                    [1] => 2816
                )

            [position] => 0
            [seo_name] => mini-uv-aqua-rich-watery-essence-sunscreen-spf-50-pa15g
            [seo_path] => 2685/2708/2816
            [average_rating] => 5.00
            [reviews_count] => 1
            [main_category] => 2816
            [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] => Biore
            [ratting_count] => 1
        )

)

end of fxn

Array
(
    [show_master_products_only] => 
    [area] => C
    [for_required_product] => 66795
    [include_child_variations] => 1
    [group_child_variations] => 
    [runtime_company_id] => 0
)

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] => 
)

Advanced and feature filters

before hook

after hook

C

1

before 2nd hook

after 2nd hook

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 = 66795 GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC 

before end of oxn

Array
(
)

Array
(
)

end of fxn

Array
(
    [show_master_products_only] => 
    [area] => C
    [for_required_product] => 37615
    [include_child_variations] => 1
    [group_child_variations] => 
    [runtime_company_id] => 0
)

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] => 
)

Advanced and feature filters

before hook

after hook

C

1

before 2nd hook

after 2nd hook

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 = 37615 GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC 

before end of oxn

Array
(
)

Array
(
)

end of fxn