Array
(
    [show_master_products_only] => 
    [area] => C
    [currency] => USD
    [features_hash] => 28-49534
    [items_per_page] => 48
    [sl] => en
    [dispatch] => categories.view
    [category_id] => 2819
    [save_view_results] => product_id
    [sort_by] => bestsellers
    [sort_order] => desc
    [cid] => 2819
    [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 (49534)) AND ?:categories.category_id IN (2819) 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, 48

before end of oxn

Array
(
    [30337] => Array
        (
            [product_id] => 30337
            [product] => Biome AC Foam Cleanser - 150gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 722
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => 8809634850089
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1200.00
            [amount] => 11
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1684133617
            [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] => 1020.000000
            [short_description] => Regulates sebum production
            [full_description] => <p>Introducing Biome AC Foam Cleanser, a skincare breakthrough for acne-prone skin. This gentle yet powerful formula is enriched with prebiotics, probiotics, cica, medacassoside, and panthenol to treat acne effectively. Infused with salicylic acid and pore blend complex, it purifies skin, minimizes pores, and regulates sebum production. The low irritant, slightly acidic composition harmonizes with the skin's natural pH level, ensuring a refreshing cleanse devoid of harmful ingredients. Elevate your skincare routine with Biome AC Foam Cleanser.</p>
            [category_ids] => Array
                (
                    [0] => 2819
                )

            [position] => 0
            [seo_name] => biome-ac-foam-cleanser-150gm
            [seo_path] => 2685/2686/2819
            [main_category] => 2819
            [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] => Juice to Cleanse
        )

    [33796] => Array
        (
            [product_id] => 33796
            [product] => Snail Magic Barrier Repair Gel Face Cleanser with Korean Snail Mucin Concentrate (100ml)
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 698
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => CCSMFC01
            [hsn_code] => 3304
            [status] => A
            [list_price] => 399.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1693643997
            [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] => 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] => 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] => 199.500000
            [short_description] => Gently cleanses, illuminates, soothes skin.
            [full_description] => Kickstart your routine with a refreshing and purifying start. Snail mucin is known for its hydrating, gently-exfoliating, blemish-fighting and dark-spot-targeting properties. The gentle feel formula is pH balanced and packed with snail mucin and pine bark that helps curb breakouts while reviving skin. It effectively cleanse down to pores without stripping skin of moisture.
            [category_ids] => Array
                (
                    [0] => 2819
                )

            [position] => 0
            [seo_name] => snail-magic-cleanser-barrier-repair-low-ph-gel-cleanser-100ml
            [seo_path] => 2685/2686/2819
            [average_rating] => 5.00
            [reviews_count] => 3
            [main_category] => 2819
            [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
                (
                    [1918] => Array
                        (
                            [video_id] => 1918
                            [video_type] => S
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1726597800
                            [status] => A
                            [user_id] => 246547
                            [extra_params] => 
                            [community_video_id] => 0
                            [community_url] => https://admin.kindlife.in/hey-skincare-lovers-got-you-my-top-picks
                            [community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1918_69405C2D19B6D622F51ABE8E97D499A6_video_dashinit_preview.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/video_library/1918_69405C2D19B6D622F51ABE8E97D499A6_video_dashinit.mp4
                            [community_last_sync_timestamp] => 0
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Hey skincare lovers!?? Got you my Top Picks
                            [description] => <p>Just restocked my beauty faves from @kindlife.in, my go-to for the best of skincare + glam essentials! ??️</p>
<p>? @consciouschemist’s Snail Magic Essence + Multi-Hyaluronic Gel Cream<br>☀️ @happier’s Glide Away Sunstick<br>?@faebeauty’s Lip Gloss in the shade Soaring</p>
<p>They’re running an epic sale right now, and trust me, you don’t want to miss out!✨</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 2
                            [dislike_count] => 0
                            [comment_count] => 0
                            [meta_keywords] => 
                            [meta_description] => 
                            [page_title] => 
                            [tagged_brands] => 
                            [category_id] => 7
                            [link_type] => M
                            [preview] => Array
                                (
                                    [default_icon] => 1
                                )

                        )

                )

            [cp_has_video] => 1
            [brand_name] => Conscious Chemist
            [ratting_count] => 3
        )

)

Array
(
    [30337] => Array
        (
            [product_id] => 30337
            [product] => Biome AC Foam Cleanser - 150gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 722
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => 8809634850089
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1200.00
            [amount] => 11
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1684133617
            [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] => 1020.000000
            [short_description] => Regulates sebum production
            [full_description] => <p>Introducing Biome AC Foam Cleanser, a skincare breakthrough for acne-prone skin. This gentle yet powerful formula is enriched with prebiotics, probiotics, cica, medacassoside, and panthenol to treat acne effectively. Infused with salicylic acid and pore blend complex, it purifies skin, minimizes pores, and regulates sebum production. The low irritant, slightly acidic composition harmonizes with the skin's natural pH level, ensuring a refreshing cleanse devoid of harmful ingredients. Elevate your skincare routine with Biome AC Foam Cleanser.</p>
            [category_ids] => Array
                (
                    [0] => 2819
                )

            [position] => 0
            [seo_name] => biome-ac-foam-cleanser-150gm
            [seo_path] => 2685/2686/2819
            [main_category] => 2819
            [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] => Juice to Cleanse
        )

    [33796] => Array
        (
            [product_id] => 33796
            [product] => Snail Magic Barrier Repair Gel Face Cleanser with Korean Snail Mucin Concentrate (100ml)
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 698
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => CCSMFC01
            [hsn_code] => 3304
            [status] => A
            [list_price] => 399.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1693643997
            [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] => 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] => 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] => 199.500000
            [short_description] => Gently cleanses, illuminates, soothes skin.
            [full_description] => Kickstart your routine with a refreshing and purifying start. Snail mucin is known for its hydrating, gently-exfoliating, blemish-fighting and dark-spot-targeting properties. The gentle feel formula is pH balanced and packed with snail mucin and pine bark that helps curb breakouts while reviving skin. It effectively cleanse down to pores without stripping skin of moisture.
            [category_ids] => Array
                (
                    [0] => 2819
                )

            [position] => 0
            [seo_name] => snail-magic-cleanser-barrier-repair-low-ph-gel-cleanser-100ml
            [seo_path] => 2685/2686/2819
            [average_rating] => 5.00
            [reviews_count] => 3
            [main_category] => 2819
            [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
                (
                    [1918] => Array
                        (
                            [video_id] => 1918
                            [video_type] => S
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1726597800
                            [status] => A
                            [user_id] => 246547
                            [extra_params] => 
                            [community_video_id] => 0
                            [community_url] => https://admin.kindlife.in/hey-skincare-lovers-got-you-my-top-picks
                            [community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1918_69405C2D19B6D622F51ABE8E97D499A6_video_dashinit_preview.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/video_library/1918_69405C2D19B6D622F51ABE8E97D499A6_video_dashinit.mp4
                            [community_last_sync_timestamp] => 0
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Hey skincare lovers!?? Got you my Top Picks
                            [description] => <p>Just restocked my beauty faves from @kindlife.in, my go-to for the best of skincare + glam essentials! ??️</p>
<p>? @consciouschemist’s Snail Magic Essence + Multi-Hyaluronic Gel Cream<br>☀️ @happier’s Glide Away Sunstick<br>?@faebeauty’s Lip Gloss in the shade Soaring</p>
<p>They’re running an epic sale right now, and trust me, you don’t want to miss out!✨</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 2
                            [dislike_count] => 0
                            [comment_count] => 0
                            [meta_keywords] => 
                            [meta_description] => 
                            [page_title] => 
                            [tagged_brands] => 
                            [category_id] => 7
                            [link_type] => M
                            [preview] => Array
                                (
                                    [default_icon] => 1
                                )

                        )

                )

            [cp_has_video] => 1
            [brand_name] => Conscious Chemist
            [ratting_count] => 3
        )

)

end of fxn

Array
(
    [show_master_products_only] => 
    [area] => C
    [currency] => USD
    [features_hash] => 28-49534
    [items_per_page] => 48
    [sl] => en
    [dispatch] => categories.view
    [category_id] => 2819
    [save_view_results] => product_id
    [sort_by] => bestsellers
    [sort_order] => desc
    [cid] => 2819
    [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 (49534)) AND ?:categories.category_id IN (2819) 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, 48

before end of oxn

Array
(
    [30337] => Array
        (
            [product_id] => 30337
            [product] => Biome AC Foam Cleanser - 150gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 722
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => 8809634850089
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1200.00
            [amount] => 11
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1684133617
            [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] => 1020.000000
            [short_description] => Regulates sebum production
            [full_description] => <p>Introducing Biome AC Foam Cleanser, a skincare breakthrough for acne-prone skin. This gentle yet powerful formula is enriched with prebiotics, probiotics, cica, medacassoside, and panthenol to treat acne effectively. Infused with salicylic acid and pore blend complex, it purifies skin, minimizes pores, and regulates sebum production. The low irritant, slightly acidic composition harmonizes with the skin's natural pH level, ensuring a refreshing cleanse devoid of harmful ingredients. Elevate your skincare routine with Biome AC Foam Cleanser.</p>
            [category_ids] => Array
                (
                    [0] => 2819
                )

            [position] => 0
            [seo_name] => biome-ac-foam-cleanser-150gm
            [seo_path] => 2685/2686/2819
            [main_category] => 2819
            [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] => Juice to Cleanse
        )

    [33796] => Array
        (
            [product_id] => 33796
            [product] => Snail Magic Barrier Repair Gel Face Cleanser with Korean Snail Mucin Concentrate (100ml)
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 698
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => CCSMFC01
            [hsn_code] => 3304
            [status] => A
            [list_price] => 399.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1693643997
            [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] => 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] => 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] => 199.500000
            [short_description] => Gently cleanses, illuminates, soothes skin.
            [full_description] => Kickstart your routine with a refreshing and purifying start. Snail mucin is known for its hydrating, gently-exfoliating, blemish-fighting and dark-spot-targeting properties. The gentle feel formula is pH balanced and packed with snail mucin and pine bark that helps curb breakouts while reviving skin. It effectively cleanse down to pores without stripping skin of moisture.
            [category_ids] => Array
                (
                    [0] => 2819
                )

            [position] => 0
            [seo_name] => snail-magic-cleanser-barrier-repair-low-ph-gel-cleanser-100ml
            [seo_path] => 2685/2686/2819
            [average_rating] => 5.00
            [reviews_count] => 3
            [main_category] => 2819
            [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
                (
                    [1918] => Array
                        (
                            [video_id] => 1918
                            [video_type] => S
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1726597800
                            [status] => A
                            [user_id] => 246547
                            [extra_params] => 
                            [community_video_id] => 0
                            [community_url] => https://admin.kindlife.in/hey-skincare-lovers-got-you-my-top-picks
                            [community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1918_69405C2D19B6D622F51ABE8E97D499A6_video_dashinit_preview.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/video_library/1918_69405C2D19B6D622F51ABE8E97D499A6_video_dashinit.mp4
                            [community_last_sync_timestamp] => 0
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Hey skincare lovers!?? Got you my Top Picks
                            [description] => <p>Just restocked my beauty faves from @kindlife.in, my go-to for the best of skincare + glam essentials! ??️</p>
<p>? @consciouschemist’s Snail Magic Essence + Multi-Hyaluronic Gel Cream<br>☀️ @happier’s Glide Away Sunstick<br>?@faebeauty’s Lip Gloss in the shade Soaring</p>
<p>They’re running an epic sale right now, and trust me, you don’t want to miss out!✨</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 2
                            [dislike_count] => 0
                            [comment_count] => 0
                            [meta_keywords] => 
                            [meta_description] => 
                            [page_title] => 
                            [tagged_brands] => 
                            [category_id] => 7
                            [link_type] => M
                            [preview] => Array
                                (
                                    [default_icon] => 1
                                )

                        )

                )

            [cp_has_video] => 1
            [brand_name] => Conscious Chemist
            [ratting_count] => 3
        )

)

Array
(
    [30337] => Array
        (
            [product_id] => 30337
            [product] => Biome AC Foam Cleanser - 150gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 722
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => 8809634850089
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1200.00
            [amount] => 11
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1684133617
            [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] => 1020.000000
            [short_description] => Regulates sebum production
            [full_description] => <p>Introducing Biome AC Foam Cleanser, a skincare breakthrough for acne-prone skin. This gentle yet powerful formula is enriched with prebiotics, probiotics, cica, medacassoside, and panthenol to treat acne effectively. Infused with salicylic acid and pore blend complex, it purifies skin, minimizes pores, and regulates sebum production. The low irritant, slightly acidic composition harmonizes with the skin's natural pH level, ensuring a refreshing cleanse devoid of harmful ingredients. Elevate your skincare routine with Biome AC Foam Cleanser.</p>
            [category_ids] => Array
                (
                    [0] => 2819
                )

            [position] => 0
            [seo_name] => biome-ac-foam-cleanser-150gm
            [seo_path] => 2685/2686/2819
            [main_category] => 2819
            [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] => Juice to Cleanse
        )

    [33796] => Array
        (
            [product_id] => 33796
            [product] => Snail Magic Barrier Repair Gel Face Cleanser with Korean Snail Mucin Concentrate (100ml)
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 698
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => CCSMFC01
            [hsn_code] => 3304
            [status] => A
            [list_price] => 399.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1693643997
            [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] => 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] => 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] => 199.500000
            [short_description] => Gently cleanses, illuminates, soothes skin.
            [full_description] => Kickstart your routine with a refreshing and purifying start. Snail mucin is known for its hydrating, gently-exfoliating, blemish-fighting and dark-spot-targeting properties. The gentle feel formula is pH balanced and packed with snail mucin and pine bark that helps curb breakouts while reviving skin. It effectively cleanse down to pores without stripping skin of moisture.
            [category_ids] => Array
                (
                    [0] => 2819
                )

            [position] => 0
            [seo_name] => snail-magic-cleanser-barrier-repair-low-ph-gel-cleanser-100ml
            [seo_path] => 2685/2686/2819
            [average_rating] => 5.00
            [reviews_count] => 3
            [main_category] => 2819
            [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
                (
                    [1918] => Array
                        (
                            [video_id] => 1918
                            [video_type] => S
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1726597800
                            [status] => A
                            [user_id] => 246547
                            [extra_params] => 
                            [community_video_id] => 0
                            [community_url] => https://admin.kindlife.in/hey-skincare-lovers-got-you-my-top-picks
                            [community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1918_69405C2D19B6D622F51ABE8E97D499A6_video_dashinit_preview.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/video_library/1918_69405C2D19B6D622F51ABE8E97D499A6_video_dashinit.mp4
                            [community_last_sync_timestamp] => 0
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Hey skincare lovers!?? Got you my Top Picks
                            [description] => <p>Just restocked my beauty faves from @kindlife.in, my go-to for the best of skincare + glam essentials! ??️</p>
<p>? @consciouschemist’s Snail Magic Essence + Multi-Hyaluronic Gel Cream<br>☀️ @happier’s Glide Away Sunstick<br>?@faebeauty’s Lip Gloss in the shade Soaring</p>
<p>They’re running an epic sale right now, and trust me, you don’t want to miss out!✨</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 2
                            [dislike_count] => 0
                            [comment_count] => 0
                            [meta_keywords] => 
                            [meta_description] => 
                            [page_title] => 
                            [tagged_brands] => 
                            [category_id] => 7
                            [link_type] => M
                            [preview] => Array
                                (
                                    [default_icon] => 1
                                )

                        )

                )

            [cp_has_video] => 1
            [brand_name] => Conscious Chemist
            [ratting_count] => 3
        )

)

end of fxn

Array
(
    [show_master_products_only] => 
    [area] => C
    [for_required_product] => 30337
    [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 = 30337 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] => 33796
    [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 = 33796 GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC 

before end of oxn

Array
(
)

Array
(
)

end of fxn