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

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


  1. Array
(
    [area] => C
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 24
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [product_id] => 
)


  1. Advanced and feature filters

  1. before hook

  1. after hook

  2. C

  1. 1

  1. before 2nd hook

  1. after 2nd hook

  1. SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_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 (34250)) AND ?:categories.category_id IN (2821) 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

  1. before end of oxn

  2. Array
(
    [1403] => Array
        (
            [product_id] => 1403
            [product] => ABC Cleansing Gel - 50 ml
            [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] => DSFP1028
            [hsn_code] => 3304
            [status] => A
            [list_price] => 499.00
            [amount] => 0
            [weight] => 50.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1614668863
            [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] => activity
            [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] => 474.050000
            [short_description] => For fighting ageing
            [full_description] => <p>This product is gentle on your skin but still packs a punch against dirt, oil and dullness. It is a proprietary blend that exfoliates, brightens, fights ageing while remaining calming to the skin.</p>
            [category_ids] => Array
                (
                    [0] => 2821
                )

            [position] => 0
            [seo_name] => abc-cleansing-gel-50-ml
            [seo_path] => 2685/2686/2821
            [main_category] => 2821
            [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] => Dr. Sheth's
        )

    [20094] => Array
        (
            [product_id] => 20094
            [product] => Advanced Acne Care
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 253
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => SSC-27
            [hsn_code] => 3304
            [status] => A
            [list_price] => 947.00
            [amount] => 30
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1667286431
            [updated_timestamp] => 1750324658
            [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] => 804.950000
            [short_description] => Skin Exfoliation, Moisturises skin, Replenishes skin
            [full_description] => <p>Born from the frustration of skin care products that just wont work, this kit contains powerhouse products that use gentle aggression to fight your current breakouts and prevent new from forming. From your first application of each step, your skin will feel clean, refreshed, and healthy.</p>
            [category_ids] => Array
                (
                    [0] => 438
                    [1] => 2821
                )

            [position] => 0
            [seo_name] => advanced-acne-care
            [seo_path] => 2685/2686/2821
            [main_category] => 2821
            [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] => The Skin Story
        )

    [32157] => Array
        (
            [product_id] => 32157
            [product] => PHA Resurfacing Glow Peel - 50ml
            [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] => 8809634610362
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1700.00
            [amount] => 3
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1690308644
            [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] => N
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => S
            [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] => 1190.000000
            [short_description] => Gently exfoliates & clears pores
            [full_description] => <p>A 10% PHA gel-water peel which gently exfoliates the skin and clears the pores to reveal rejuvenated skin. With the extracts of 5 different fruits and vegetables, this peel soothes and clears the skin from the first use. Extracts of Cucumber, Papaya, and Centella Asiatica nourish the skin for a healthy glow.</p>
<p>Note: The order will be dispatched within 7 days.</p>
            [category_ids] => Array
                (
                    [0] => 2821
                )

            [position] => 0
            [seo_name] => pha-resurfacing-glow-peel-50ml
            [seo_path] => 2685/2686/2821
            [main_category] => 2821
            [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] => AXIS-Y
        )

    [35763] => Array
        (
            [product_id] => 35763
            [product] => 25ml Plum Green Tea Mattifying Moisturizer
            [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] => PLGT0025DMT0279
            [hsn_code] => 3304
            [status] => A
            [list_price] => 275.00
            [amount] => 40
            [weight] => 50.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1705402185
            [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] => 2
            [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] => activity
            [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] => 261.250000
            [short_description] => Expiry Date: 01-03-2025
            [full_description] => <p>This product with green tea extracts helps in fighting acne  and provides controlled hydration to the skin. Glycolic acid helps exfoliate pores gently and keeps the skin clear and oil-free all day long. It is 100% vegan.  After cleansing and toning, apply tiny dots of the moisturizer all over your face and neck. While it's still drying, tap lightly with your fingertips to allow the moisturizer to soak in better. Suitable for oily, acne-prone skin on both, men and women in all season, this product is FDA approved, mineral oil free, SLS free, cruelty-free and paraben free.</p>
            [category_ids] => Array
                (
                    [0] => 459
                    [1] => 2821
                )

            [position] => 0
            [seo_name] => plum-green-tea-mattifying-moisturizer-25ml
            [seo_path] => 2685/2686/2821
            [main_category] => 2821
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 2
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                    [995] => Array
                        (
                            [video_id] => 995
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1707849000
                            [status] => A
                            [user_id] => 76014
                            [extra_params] => 
                            [community_video_id] => 1126
                            [community_url] => https://www.kindlife.in/plum-haul
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1126/5485bf9e4601f3dd331bf2a675ca1f08.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1126/5485bf9e4601f3dd331bf2a675ca1f08.mp4
                            [community_last_sync_timestamp] => 1707913411
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Unboxing My Latest Plum Haul
                            [description] => <p>Treat yourself to a Plum Haul and discover a range of delightful products for your skin and senses! Start with the invigorating Coffee Wake-a-ccino Foot Cream to nourish tired feet. Indulge in the rich Vanilla Vibes BodyButter for deep hydration and a luxurious scent. Finish off with the refreshing Vanilla Vibes Body Mist, perfect for an all-day sweet aroma. Experience the joy of self-care with these Plum favorites, designed to leave you feeling pampered and radiant!</p>
<p><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"><br></span></b></span></p><p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"></span></b></span></b></p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary">
<p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"></span></b></span></b></p>
<p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"></span></b></span></b></b></p>
<p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary">
<span data-state="closed"><b class="cursor-pointer rounded-md px-1 text-token-text-secondary h-[30px] hover:bg-token-main-surface-secondary"></b></span></b></b></b></p>
<p><br></p>
</b><p></p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 0
                            [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] => Plum
        )

)


  1. Array
(
    [1403] => Array
        (
            [product_id] => 1403
            [product] => ABC Cleansing Gel - 50 ml
            [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] => DSFP1028
            [hsn_code] => 3304
            [status] => A
            [list_price] => 499.00
            [amount] => 0
            [weight] => 50.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1614668863
            [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] => activity
            [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] => 474.050000
            [short_description] => For fighting ageing
            [full_description] => <p>This product is gentle on your skin but still packs a punch against dirt, oil and dullness. It is a proprietary blend that exfoliates, brightens, fights ageing while remaining calming to the skin.</p>
            [category_ids] => Array
                (
                    [0] => 2821
                )

            [position] => 0
            [seo_name] => abc-cleansing-gel-50-ml
            [seo_path] => 2685/2686/2821
            [main_category] => 2821
            [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] => Dr. Sheth's
        )

    [20094] => Array
        (
            [product_id] => 20094
            [product] => Advanced Acne Care
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 253
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => SSC-27
            [hsn_code] => 3304
            [status] => A
            [list_price] => 947.00
            [amount] => 30
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1667286431
            [updated_timestamp] => 1750324658
            [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] => 804.950000
            [short_description] => Skin Exfoliation, Moisturises skin, Replenishes skin
            [full_description] => <p>Born from the frustration of skin care products that just wont work, this kit contains powerhouse products that use gentle aggression to fight your current breakouts and prevent new from forming. From your first application of each step, your skin will feel clean, refreshed, and healthy.</p>
            [category_ids] => Array
                (
                    [0] => 438
                    [1] => 2821
                )

            [position] => 0
            [seo_name] => advanced-acne-care
            [seo_path] => 2685/2686/2821
            [main_category] => 2821
            [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] => The Skin Story
        )

    [32157] => Array
        (
            [product_id] => 32157
            [product] => PHA Resurfacing Glow Peel - 50ml
            [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] => 8809634610362
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1700.00
            [amount] => 3
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1690308644
            [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] => N
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => S
            [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] => 1190.000000
            [short_description] => Gently exfoliates & clears pores
            [full_description] => <p>A 10% PHA gel-water peel which gently exfoliates the skin and clears the pores to reveal rejuvenated skin. With the extracts of 5 different fruits and vegetables, this peel soothes and clears the skin from the first use. Extracts of Cucumber, Papaya, and Centella Asiatica nourish the skin for a healthy glow.</p>
<p>Note: The order will be dispatched within 7 days.</p>
            [category_ids] => Array
                (
                    [0] => 2821
                )

            [position] => 0
            [seo_name] => pha-resurfacing-glow-peel-50ml
            [seo_path] => 2685/2686/2821
            [main_category] => 2821
            [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] => AXIS-Y
        )

    [35763] => Array
        (
            [product_id] => 35763
            [product] => 25ml Plum Green Tea Mattifying Moisturizer
            [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] => PLGT0025DMT0279
            [hsn_code] => 3304
            [status] => A
            [list_price] => 275.00
            [amount] => 40
            [weight] => 50.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1705402185
            [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] => 2
            [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] => activity
            [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] => 261.250000
            [short_description] => Expiry Date: 01-03-2025
            [full_description] => <p>This product with green tea extracts helps in fighting acne  and provides controlled hydration to the skin. Glycolic acid helps exfoliate pores gently and keeps the skin clear and oil-free all day long. It is 100% vegan.  After cleansing and toning, apply tiny dots of the moisturizer all over your face and neck. While it's still drying, tap lightly with your fingertips to allow the moisturizer to soak in better. Suitable for oily, acne-prone skin on both, men and women in all season, this product is FDA approved, mineral oil free, SLS free, cruelty-free and paraben free.</p>
            [category_ids] => Array
                (
                    [0] => 459
                    [1] => 2821
                )

            [position] => 0
            [seo_name] => plum-green-tea-mattifying-moisturizer-25ml
            [seo_path] => 2685/2686/2821
            [main_category] => 2821
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 2
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                    [995] => Array
                        (
                            [video_id] => 995
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1707849000
                            [status] => A
                            [user_id] => 76014
                            [extra_params] => 
                            [community_video_id] => 1126
                            [community_url] => https://www.kindlife.in/plum-haul
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1126/5485bf9e4601f3dd331bf2a675ca1f08.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1126/5485bf9e4601f3dd331bf2a675ca1f08.mp4
                            [community_last_sync_timestamp] => 1707913411
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Unboxing My Latest Plum Haul
                            [description] => <p>Treat yourself to a Plum Haul and discover a range of delightful products for your skin and senses! Start with the invigorating Coffee Wake-a-ccino Foot Cream to nourish tired feet. Indulge in the rich Vanilla Vibes BodyButter for deep hydration and a luxurious scent. Finish off with the refreshing Vanilla Vibes Body Mist, perfect for an all-day sweet aroma. Experience the joy of self-care with these Plum favorites, designed to leave you feeling pampered and radiant!</p>
<p><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"><br></span></b></span></p><p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"></span></b></span></b></p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary">
<p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"></span></b></span></b></p>
<p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"></span></b></span></b></b></p>
<p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary">
<span data-state="closed"><b class="cursor-pointer rounded-md px-1 text-token-text-secondary h-[30px] hover:bg-token-main-surface-secondary"></b></span></b></b></b></p>
<p><br></p>
</b><p></p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 0
                            [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] => Plum
        )

)


  2. end of fxn

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

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


  1. Array
(
    [area] => C
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 24
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [product_id] => 
)


  1. Advanced and feature filters

  1. before hook

  1. after hook

  2. C

  1. 1

  1. before 2nd hook

  1. after 2nd hook

  1. SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_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 (34250)) AND ?:categories.category_id IN (2821) 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

  1. before end of oxn

  2. Array
(
    [1403] => Array
        (
            [product_id] => 1403
            [product] => ABC Cleansing Gel - 50 ml
            [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] => DSFP1028
            [hsn_code] => 3304
            [status] => A
            [list_price] => 499.00
            [amount] => 0
            [weight] => 50.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1614668863
            [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] => activity
            [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] => 474.050000
            [short_description] => For fighting ageing
            [full_description] => <p>This product is gentle on your skin but still packs a punch against dirt, oil and dullness. It is a proprietary blend that exfoliates, brightens, fights ageing while remaining calming to the skin.</p>
            [category_ids] => Array
                (
                    [0] => 2821
                )

            [position] => 0
            [seo_name] => abc-cleansing-gel-50-ml
            [seo_path] => 2685/2686/2821
            [main_category] => 2821
            [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] => Dr. Sheth's
        )

    [20094] => Array
        (
            [product_id] => 20094
            [product] => Advanced Acne Care
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 253
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => SSC-27
            [hsn_code] => 3304
            [status] => A
            [list_price] => 947.00
            [amount] => 30
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1667286431
            [updated_timestamp] => 1750324658
            [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] => 804.950000
            [short_description] => Skin Exfoliation, Moisturises skin, Replenishes skin
            [full_description] => <p>Born from the frustration of skin care products that just wont work, this kit contains powerhouse products that use gentle aggression to fight your current breakouts and prevent new from forming. From your first application of each step, your skin will feel clean, refreshed, and healthy.</p>
            [category_ids] => Array
                (
                    [0] => 438
                    [1] => 2821
                )

            [position] => 0
            [seo_name] => advanced-acne-care
            [seo_path] => 2685/2686/2821
            [main_category] => 2821
            [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] => The Skin Story
        )

    [32157] => Array
        (
            [product_id] => 32157
            [product] => PHA Resurfacing Glow Peel - 50ml
            [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] => 8809634610362
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1700.00
            [amount] => 3
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1690308644
            [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] => N
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => S
            [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] => 1190.000000
            [short_description] => Gently exfoliates & clears pores
            [full_description] => <p>A 10% PHA gel-water peel which gently exfoliates the skin and clears the pores to reveal rejuvenated skin. With the extracts of 5 different fruits and vegetables, this peel soothes and clears the skin from the first use. Extracts of Cucumber, Papaya, and Centella Asiatica nourish the skin for a healthy glow.</p>
<p>Note: The order will be dispatched within 7 days.</p>
            [category_ids] => Array
                (
                    [0] => 2821
                )

            [position] => 0
            [seo_name] => pha-resurfacing-glow-peel-50ml
            [seo_path] => 2685/2686/2821
            [main_category] => 2821
            [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] => AXIS-Y
        )

    [35763] => Array
        (
            [product_id] => 35763
            [product] => 25ml Plum Green Tea Mattifying Moisturizer
            [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] => PLGT0025DMT0279
            [hsn_code] => 3304
            [status] => A
            [list_price] => 275.00
            [amount] => 40
            [weight] => 50.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1705402185
            [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] => 2
            [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] => activity
            [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] => 261.250000
            [short_description] => Expiry Date: 01-03-2025
            [full_description] => <p>This product with green tea extracts helps in fighting acne  and provides controlled hydration to the skin. Glycolic acid helps exfoliate pores gently and keeps the skin clear and oil-free all day long. It is 100% vegan.  After cleansing and toning, apply tiny dots of the moisturizer all over your face and neck. While it's still drying, tap lightly with your fingertips to allow the moisturizer to soak in better. Suitable for oily, acne-prone skin on both, men and women in all season, this product is FDA approved, mineral oil free, SLS free, cruelty-free and paraben free.</p>
            [category_ids] => Array
                (
                    [0] => 459
                    [1] => 2821
                )

            [position] => 0
            [seo_name] => plum-green-tea-mattifying-moisturizer-25ml
            [seo_path] => 2685/2686/2821
            [main_category] => 2821
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 2
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                    [995] => Array
                        (
                            [video_id] => 995
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1707849000
                            [status] => A
                            [user_id] => 76014
                            [extra_params] => 
                            [community_video_id] => 1126
                            [community_url] => https://www.kindlife.in/plum-haul
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1126/5485bf9e4601f3dd331bf2a675ca1f08.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1126/5485bf9e4601f3dd331bf2a675ca1f08.mp4
                            [community_last_sync_timestamp] => 1707913411
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Unboxing My Latest Plum Haul
                            [description] => <p>Treat yourself to a Plum Haul and discover a range of delightful products for your skin and senses! Start with the invigorating Coffee Wake-a-ccino Foot Cream to nourish tired feet. Indulge in the rich Vanilla Vibes BodyButter for deep hydration and a luxurious scent. Finish off with the refreshing Vanilla Vibes Body Mist, perfect for an all-day sweet aroma. Experience the joy of self-care with these Plum favorites, designed to leave you feeling pampered and radiant!</p>
<p><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"><br></span></b></span></p><p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"></span></b></span></b></p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary">
<p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"></span></b></span></b></p>
<p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"></span></b></span></b></b></p>
<p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary">
<span data-state="closed"><b class="cursor-pointer rounded-md px-1 text-token-text-secondary h-[30px] hover:bg-token-main-surface-secondary"></b></span></b></b></b></p>
<p><br></p>
</b><p></p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 0
                            [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] => Plum
        )

)


  1. Array
(
    [1403] => Array
        (
            [product_id] => 1403
            [product] => ABC Cleansing Gel - 50 ml
            [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] => DSFP1028
            [hsn_code] => 3304
            [status] => A
            [list_price] => 499.00
            [amount] => 0
            [weight] => 50.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1614668863
            [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] => activity
            [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] => 474.050000
            [short_description] => For fighting ageing
            [full_description] => <p>This product is gentle on your skin but still packs a punch against dirt, oil and dullness. It is a proprietary blend that exfoliates, brightens, fights ageing while remaining calming to the skin.</p>
            [category_ids] => Array
                (
                    [0] => 2821
                )

            [position] => 0
            [seo_name] => abc-cleansing-gel-50-ml
            [seo_path] => 2685/2686/2821
            [main_category] => 2821
            [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] => Dr. Sheth's
        )

    [20094] => Array
        (
            [product_id] => 20094
            [product] => Advanced Acne Care
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 253
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => SSC-27
            [hsn_code] => 3304
            [status] => A
            [list_price] => 947.00
            [amount] => 30
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1667286431
            [updated_timestamp] => 1750324658
            [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] => 804.950000
            [short_description] => Skin Exfoliation, Moisturises skin, Replenishes skin
            [full_description] => <p>Born from the frustration of skin care products that just wont work, this kit contains powerhouse products that use gentle aggression to fight your current breakouts and prevent new from forming. From your first application of each step, your skin will feel clean, refreshed, and healthy.</p>
            [category_ids] => Array
                (
                    [0] => 438
                    [1] => 2821
                )

            [position] => 0
            [seo_name] => advanced-acne-care
            [seo_path] => 2685/2686/2821
            [main_category] => 2821
            [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] => The Skin Story
        )

    [32157] => Array
        (
            [product_id] => 32157
            [product] => PHA Resurfacing Glow Peel - 50ml
            [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] => 8809634610362
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1700.00
            [amount] => 3
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1690308644
            [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] => N
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => S
            [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] => 1190.000000
            [short_description] => Gently exfoliates & clears pores
            [full_description] => <p>A 10% PHA gel-water peel which gently exfoliates the skin and clears the pores to reveal rejuvenated skin. With the extracts of 5 different fruits and vegetables, this peel soothes and clears the skin from the first use. Extracts of Cucumber, Papaya, and Centella Asiatica nourish the skin for a healthy glow.</p>
<p>Note: The order will be dispatched within 7 days.</p>
            [category_ids] => Array
                (
                    [0] => 2821
                )

            [position] => 0
            [seo_name] => pha-resurfacing-glow-peel-50ml
            [seo_path] => 2685/2686/2821
            [main_category] => 2821
            [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] => AXIS-Y
        )

    [35763] => Array
        (
            [product_id] => 35763
            [product] => 25ml Plum Green Tea Mattifying Moisturizer
            [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] => PLGT0025DMT0279
            [hsn_code] => 3304
            [status] => A
            [list_price] => 275.00
            [amount] => 40
            [weight] => 50.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1705402185
            [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] => 2
            [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] => activity
            [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] => 261.250000
            [short_description] => Expiry Date: 01-03-2025
            [full_description] => <p>This product with green tea extracts helps in fighting acne  and provides controlled hydration to the skin. Glycolic acid helps exfoliate pores gently and keeps the skin clear and oil-free all day long. It is 100% vegan.  After cleansing and toning, apply tiny dots of the moisturizer all over your face and neck. While it's still drying, tap lightly with your fingertips to allow the moisturizer to soak in better. Suitable for oily, acne-prone skin on both, men and women in all season, this product is FDA approved, mineral oil free, SLS free, cruelty-free and paraben free.</p>
            [category_ids] => Array
                (
                    [0] => 459
                    [1] => 2821
                )

            [position] => 0
            [seo_name] => plum-green-tea-mattifying-moisturizer-25ml
            [seo_path] => 2685/2686/2821
            [main_category] => 2821
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 2
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                    [995] => Array
                        (
                            [video_id] => 995
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1707849000
                            [status] => A
                            [user_id] => 76014
                            [extra_params] => 
                            [community_video_id] => 1126
                            [community_url] => https://www.kindlife.in/plum-haul
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1126/5485bf9e4601f3dd331bf2a675ca1f08.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1126/5485bf9e4601f3dd331bf2a675ca1f08.mp4
                            [community_last_sync_timestamp] => 1707913411
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Unboxing My Latest Plum Haul
                            [description] => <p>Treat yourself to a Plum Haul and discover a range of delightful products for your skin and senses! Start with the invigorating Coffee Wake-a-ccino Foot Cream to nourish tired feet. Indulge in the rich Vanilla Vibes BodyButter for deep hydration and a luxurious scent. Finish off with the refreshing Vanilla Vibes Body Mist, perfect for an all-day sweet aroma. Experience the joy of self-care with these Plum favorites, designed to leave you feeling pampered and radiant!</p>
<p><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"><br></span></b></span></p><p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"></span></b></span></b></p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary">
<p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"></span></b></span></b></p>
<p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"></span></b></span></b></b></p>
<p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary">
<span data-state="closed"><b class="cursor-pointer rounded-md px-1 text-token-text-secondary h-[30px] hover:bg-token-main-surface-secondary"></b></span></b></b></b></p>
<p><br></p>
</b><p></p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 0
                            [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] => Plum
        )

)


  2. end of fxn

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


  1. Array
(
    [area] => C
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [product_id] => 
)


  1. Advanced and feature filters

  1. before hook

  1. after hook

  2. C

  1. 1

  1. before 2nd hook

  1. after 2nd hook

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

  1. before end of oxn

  2. Array
(
)


  1. Array
(
)


  2. end of fxn

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


  1. Array
(
    [area] => C
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [product_id] => 
)


  1. Advanced and feature filters

  1. before hook

  1. after hook

  2. C

  1. 1

  1. before 2nd hook

  1. after 2nd hook

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

  1. before end of oxn

  2. Array
(
)


  1. Array
(
)


  2. end of fxn

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


  1. Array
(
    [area] => C
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [product_id] => 
)


  1. Advanced and feature filters

  1. before hook

  1. after hook

  2. C

  1. 1

  1. before 2nd hook

  1. after 2nd hook

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

  1. before end of oxn

  2. Array
(
)


  1. Array
(
)


  2. end of fxn

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


  1. Array
(
    [area] => C
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [product_id] => 
)


  1. Advanced and feature filters

  1. before hook

  1. after hook

  2. C

  1. 1

  1. before 2nd hook

  1. after 2nd hook

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

  1. before end of oxn

  2. Array
(
)


  1. Array
(
)


  2. end of fxn
Scrubs & Exfoliators:Cleansers:Skin 
  1. Array
(
    [show_master_products_only] => 
    [area] => C
    [check_location] => 1
    [process_empty_items] => 1
    [dispatch] => categories.view
    [category_id] => 2821
    [features_hash] => 28-34250
    [block_data] => Array
        (
            [grid_id] => 2219
            [block_id] => 59
            [content] => Array
                (
                    [items] => Array
                        (
                            [filling] => manually
                            [item_ids] => 19,18,16,17,25,26,30,31,32,33,28,21,34,35,36
                        )

                )

            [object_id] => 0
            [object_type] => 
            [object_ids] => 1741
            [snapping_id] => 3364
            [wrapper] => blocks/wrappers/sidebox_important.tpl
            [user_class] => prod-filters
            [order] => 1
            [status] => A
            [type] => product_filters
            [properties] => Array
                (
                    [template] => blocks/product_filters/for_category/original.tpl
                )

            [company_id] => 0
            [storefront_id] => 1
            [lang_code] => en
            [name] => Filters
            [items_array] => Array
                (
                    [0] => 1741
                )

            [items_count] => 1
            [availability] => Array
                (
                    [app] => 1
                    [phone] => 1
                    [tablet] => 1
                    [desktop] => 1
                )

        )

    [storefront_id] => 1
    [filter_item_ids] => 19,18,16,17,25,26,30,31,32,33,28,21,34,35,36
    [split_filters] => 1
    [variant_filter] => 
    [get_conditions] => 1
    [custom_extend] => Array
        (
            [0] => categories
        )

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


  1. Array
(
    [area] => C
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [product_id] => 
)


  1. Advanced and feature filters

  1. before hook

  1. after hook

  2. C

  1. 1

  1. before 2nd hook

  1. after 2nd hook

  1. Array
(
    [show_master_products_only] => 
    [area] => C
    [check_location] => 1
    [process_empty_items] => 1
    [dispatch] => categories.view
    [category_id] => 2821
    [features_hash] => 
    [block_data] => Array
        (
            [grid_id] => 2219
            [block_id] => 59
            [content] => Array
                (
                    [items] => Array
                        (
                            [filling] => manually
                            [item_ids] => 19,18,16,17,25,26,30,31,32,33,28,21,34,35,36
                        )

                )

            [object_id] => 0
            [object_type] => 
            [object_ids] => 1741
            [snapping_id] => 3364
            [wrapper] => blocks/wrappers/sidebox_important.tpl
            [user_class] => prod-filters
            [order] => 1
            [status] => A
            [type] => product_filters
            [properties] => Array
                (
                    [template] => blocks/product_filters/for_category/original.tpl
                )

            [company_id] => 0
            [storefront_id] => 1
            [lang_code] => en
            [name] => Filters
            [items_array] => Array
                (
                    [0] => 1741
                )

            [items_count] => 1
            [availability] => Array
                (
                    [app] => 1
                    [phone] => 1
                    [tablet] => 1
                    [desktop] => 1
                )

        )

    [storefront_id] => 1
    [filter_item_ids] => 19,18,16,17,25,26,30,31,32,33,28,21,34,35,36
    [split_filters] => 1
    [variant_filter] => 
    [get_conditions] => 1
    [custom_extend] => Array
        (
            [0] => categories
        )

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


  1. Array
(
    [area] => C
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [product_id] => 
)


  1. Advanced and feature filters

  1. before hook

  1. after hook

  2. C

  1. 1

  1. before 2nd hook

  1. after 2nd hook

Extra 5% off on all Kbeauty orders above ₹999

KLOVE

Copied

Discover with Ai
Community

Scrubs & Exfoliators

Filters

Filters
Brand
Price

₹  –  ₹

  • ‎₹142
  • ‎₹9279
Categories
Certification
Kind Code
Express Shipping
reset Apply

KLOVE | Extra 5% off on all Kbeauty orders above ₹999

SUMVIBE10 | Extra 10% off on orders on orders ₹1,999+

SUNKISS5 | Extra 5% off on orders ₹999+

Scrubs & Exfoliators

  • Skin Acne & Pimples
Filters
Bestselling
4 Products Found 
  1. Array
(
    [show_master_products_only] => 
    [area] => A
    [extend] => Array
        (
            [0] => product_name
        )

    [pid] => Array
        (
            [0] => 1403
        )

    [group_child_variations] => 
    [skip_rating] => 1
    [sort_by] => null
    [runtime_company_id] => 0
)


  1. Array
(
    [area] => C
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [product_id] => 
)


  1. Advanced and feature filters

  1. before hook

  1. after hook

  2. C

  1. before 2nd hook

  1. after 2nd hook

  1. SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND companies.status IN ('A') 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)  AND  ((1  AND  products.product_id IN (1403)) AND companies.status IN ('A') AND products.company_id IN (13, 0) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc 

  1. before end of oxn

  2. Array
(
    [1403] => Array
        (
            [product_id] => 1403
            [product] => ABC Cleansing Gel - 50 ml
            [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] => DSFP1028
            [hsn_code] => 3304
            [status] => A
            [list_price] => 499.00
            [amount] => 0
            [weight] => 50.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1614668863
            [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] => activity
            [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] => 474.050000
            [category_ids] => Array
                (
                    [0] => 2821
                )

            [seo_name] => abc-cleansing-gel-50-ml
            [seo_path] => 2685/2686/2821
            [main_category] => 2821
            [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] => Dr. Sheth's
        )

)


  1. Array
(
    [1403] => Array
        (
            [product_id] => 1403
            [product] => ABC Cleansing Gel - 50 ml
            [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] => DSFP1028
            [hsn_code] => 3304
            [status] => A
            [list_price] => 499.00
            [amount] => 0
            [weight] => 50.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1614668863
            [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] => activity
            [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] => 474.050000
            [category_ids] => Array
                (
                    [0] => 2821
                )

            [seo_name] => abc-cleansing-gel-50-ml
            [seo_path] => 2685/2686/2821
            [main_category] => 2821
            [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] => Dr. Sheth's
        )

)


  2. end of fxn

                


    
    
        
            Dr. Sheth's: ABC Cleansing Gel - 50 ml

        

            





                                        
                                
            

            
                                    

                        
    


    

        
                
                    
        

        
                    
                    
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
        

                                    Dr. Sheth's
        


        

            

                                
    
            ABC Cleansing Gel - 50 ml    


            


            
            

                                
            
    


            


            

                                
            


                            

                            
            



                            

        

        

        

                                        

                        
                        

     



    


                                

                                                            
            

                

                                                            Out of stock
                        

                            

                                

                                

                                    Notify me                                    
                                

                                

                                    i
                                    
We will notify you, when product is back in stock.

                                

                            

                                                            
                                                                
                                                    

                                                                    
                

                    
                    
                    
                                                                    









    
            
    
 
    


    
                            
                                
        
 
    








                                    

            

        

        

    

    
        







                                
                        

    
    
    
    


































        

                        
                        

 





            
        
        

            


            

                                                                                    

                                            

            

                                                                                
                                                                                                        

                        
            

            
                                    
                        
                                        

                    
                    
  1. Array
(
    [show_master_products_only] => 
    [area] => A
    [extend] => Array
        (
            [0] => product_name
        )

    [pid] => Array
        (
            [0] => 20094
        )

    [group_child_variations] => 
    [skip_rating] => 1
    [sort_by] => null
    [runtime_company_id] => 0
)


  1. Array
(
    [area] => C
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [product_id] => 
)


  1. Advanced and feature filters

  1. before hook

  1. after hook

  2. C

  1. before 2nd hook

  1. after 2nd hook

  1. SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND companies.status IN ('A') 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)  AND  ((1  AND  products.product_id IN (20094)) AND companies.status IN ('A') AND products.company_id IN (13, 0) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc 

  1. before end of oxn

  2. Array
(
    [20094] => Array
        (
            [product_id] => 20094
            [product] => Advanced Acne Care
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 253
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => SSC-27
            [hsn_code] => 3304
            [status] => A
            [list_price] => 947.00
            [amount] => 30
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1667286431
            [updated_timestamp] => 1750324658
            [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] => 804.950000
            [category_ids] => Array
                (
                    [0] => 438
                    [1] => 2821
                )

            [seo_name] => advanced-acne-care
            [seo_path] => 2685/2686/2821
            [main_category] => 2821
            [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] => The Skin Story
        )

)


  1. Array
(
    [20094] => Array
        (
            [product_id] => 20094
            [product] => Advanced Acne Care
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 253
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => SSC-27
            [hsn_code] => 3304
            [status] => A
            [list_price] => 947.00
            [amount] => 30
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1667286431
            [updated_timestamp] => 1750324658
            [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] => 804.950000
            [category_ids] => Array
                (
                    [0] => 438
                    [1] => 2821
                )

            [seo_name] => advanced-acne-care
            [seo_path] => 2685/2686/2821
            [main_category] => 2821
            [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] => The Skin Story
        )

)


  2. end of fxn

                


    
    
        
            The Skin Story: Advanced Acne Care

        

            





                                        
                                
            

            
                                    

                        
    


    

        
                
                    
        

        
                    
                                        
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    

                                                                                                                            Use RX10 & Get Flat 10% off on orders above Rs. 600.Use SUNKISS5 & Get Flat 5% off on orders above Rs. 999.
                                    +1
                                                                                    

                                                                            
        

                                    The Skin Story
        


        

            

                                
    
            Advanced Acne Care    


            


            
            

                                
            
    


            


            

                                
            


                            

                            
            



                            

        

        

        

                            


	            	                	                 

    
        
        
                                
                                    ₹805
                            

                        

	            	            
	            	            	                           
            

            
            

                            ₹947
                        

            

        
    
	            
            
	            	                
	            
	            	                
                                                                                                                                                        

	                    15%
	                

                                

                                        

                        
                        

     



    


                                

                                                            
            

                

                                                        
                        
 
                                                        
                            
					        
                        

                                                                    
                

                    
                    
                    
                                                                    









        
                
 

        
        
    

    





    
            
    
 
    


    
                            
                                
        
 
    








                                    

            

        

        

    

    
        







                                
                        

    
    
    
    


































        

                        
                        

 





            
        
        

            


            

                                                                                    

                                            

            

                                                                                
                                                                                                        

                        
            

            
                                    
                        
                                        

                    
                    
  1. Array
(
    [show_master_products_only] => 
    [area] => A
    [extend] => Array
        (
            [0] => product_name
        )

    [pid] => Array
        (
            [0] => 32157
        )

    [group_child_variations] => 
    [skip_rating] => 1
    [sort_by] => null
    [runtime_company_id] => 0
)


  1. Array
(
    [area] => C
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [product_id] => 
)


  1. Advanced and feature filters

  1. before hook

  1. after hook

  2. C

  1. before 2nd hook

  1. after 2nd hook

  1. SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND companies.status IN ('A') 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)  AND  ((1  AND  products.product_id IN (32157)) AND companies.status IN ('A') AND products.company_id IN (13, 0) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc 

  1. before end of oxn

  2. Array
(
    [32157] => Array
        (
            [product_id] => 32157
            [product] => PHA Resurfacing Glow Peel - 50ml
            [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] => 8809634610362
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1700.00
            [amount] => 3
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1690308644
            [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] => N
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => S
            [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] => 1190.000000
            [category_ids] => Array
                (
                    [0] => 2821
                )

            [seo_name] => pha-resurfacing-glow-peel-50ml
            [seo_path] => 2685/2686/2821
            [main_category] => 2821
            [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] => AXIS-Y
        )

)


  1. Array
(
    [32157] => Array
        (
            [product_id] => 32157
            [product] => PHA Resurfacing Glow Peel - 50ml
            [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] => 8809634610362
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1700.00
            [amount] => 3
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1690308644
            [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] => N
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => S
            [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] => 1190.000000
            [category_ids] => Array
                (
                    [0] => 2821
                )

            [seo_name] => pha-resurfacing-glow-peel-50ml
            [seo_path] => 2685/2686/2821
            [main_category] => 2821
            [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] => AXIS-Y
        )

)


  2. end of fxn

                


    
    
        
            AXIS-Y: PHA Resurfacing Glow Peel - 50ml

        

            





                                        
                                
            

            
                                    

                        
    


    

        
                
                    
        

        
                    
                                                            
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            

                                                                                                                            Use SUMVIBE10 & Get Flat 10% off on orders above Rs. 1999.Use SUNKISS5 & Get Flat 5% off on orders above Rs. 999.
                                    +1
                                                                                    

                                                        
        

                                    AXIS-Y
        


        

            

                                
    
            PHA Resurfacing Glow Peel - 50ml    


            


            
            

                                
            
    


            


            

                                
            


                            

                            
            



                            

        

        

        

                            


	            	                	                 

    
        
        
                                
                                    ₹1,190
                            

                        

	            	            
	            	            	                           
            

            
            

                            ₹1,700
                        

            

        
    
	            
            
	            	                
	            
	            	                
                                                                                                                                                        

	                    30%
	                

                                

                                        

                        
                        

     



    


                                

                                                            
            

                

                                                        
                        
 
                                                        
                            
					        
                        

                                                                    
                

                    
                    
                    
                                                                    









        
                
 

        
        
    

    





    
            
    
 
    


    
                            
                                
        
 
    








                                    

            

        

        

    

    
        







                                
                        

    
    
    
    


































        

                                        

                    
                

            
                        

 





            
        
        

            


            

                                                                                    

                                            

            

                                                                                
                                                                                                        

                        
            

            
                                    
                        
                                        

                    
                    
  1. Array
(
    [show_master_products_only] => 
    [area] => A
    [extend] => Array
        (
            [0] => product_name
        )

    [pid] => Array
        (
            [0] => 35763
        )

    [group_child_variations] => 
    [skip_rating] => 1
    [sort_by] => null
    [runtime_company_id] => 0
)


  1. Array
(
    [area] => C
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [product_id] => 
)


  1. Advanced and feature filters

  1. before hook

  1. after hook

  2. C

  1. before 2nd hook

  1. after 2nd hook

  1. SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND companies.status IN ('A') 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)  AND  ((1  AND  products.product_id IN (35763)) AND companies.status IN ('A') AND products.company_id IN (13, 0) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc 

  1. before end of oxn

  2. Array
(
    [35763] => Array
        (
            [product_id] => 35763
            [product] => 25ml Plum Green Tea Mattifying Moisturizer
            [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] => PLGT0025DMT0279
            [hsn_code] => 3304
            [status] => A
            [list_price] => 275.00
            [amount] => 40
            [weight] => 50.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1705402185
            [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] => 2
            [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] => activity
            [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] => 261.250000
            [category_ids] => Array
                (
                    [0] => 459
                    [1] => 2821
                )

            [seo_name] => plum-green-tea-mattifying-moisturizer-25ml
            [seo_path] => 2685/2686/2821
            [main_category] => 2821
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 2
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                    [995] => Array
                        (
                            [video_id] => 995
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1707849000
                            [status] => A
                            [user_id] => 76014
                            [extra_params] => 
                            [community_video_id] => 1126
                            [community_url] => https://www.kindlife.in/plum-haul
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1126/5485bf9e4601f3dd331bf2a675ca1f08.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1126/5485bf9e4601f3dd331bf2a675ca1f08.mp4
                            [community_last_sync_timestamp] => 1707913411
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Unboxing My Latest Plum Haul
                            [description] => <p>Treat yourself to a Plum Haul and discover a range of delightful products for your skin and senses! Start with the invigorating Coffee Wake-a-ccino Foot Cream to nourish tired feet. Indulge in the rich Vanilla Vibes BodyButter for deep hydration and a luxurious scent. Finish off with the refreshing Vanilla Vibes Body Mist, perfect for an all-day sweet aroma. Experience the joy of self-care with these Plum favorites, designed to leave you feeling pampered and radiant!</p>
<p><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"><br></span></b></span></p><p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"></span></b></span></b></p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary">
<p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"></span></b></span></b></p>
<p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"></span></b></span></b></b></p>
<p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary">
<span data-state="closed"><b class="cursor-pointer rounded-md px-1 text-token-text-secondary h-[30px] hover:bg-token-main-surface-secondary"></b></span></b></b></b></p>
<p><br></p>
</b><p></p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 0
                            [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] => Plum
        )

)


  1. Array
(
    [35763] => Array
        (
            [product_id] => 35763
            [product] => 25ml Plum Green Tea Mattifying Moisturizer
            [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] => PLGT0025DMT0279
            [hsn_code] => 3304
            [status] => A
            [list_price] => 275.00
            [amount] => 40
            [weight] => 50.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1705402185
            [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] => 2
            [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] => activity
            [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] => 261.250000
            [category_ids] => Array
                (
                    [0] => 459
                    [1] => 2821
                )

            [seo_name] => plum-green-tea-mattifying-moisturizer-25ml
            [seo_path] => 2685/2686/2821
            [main_category] => 2821
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 2
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                    [995] => Array
                        (
                            [video_id] => 995
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1707849000
                            [status] => A
                            [user_id] => 76014
                            [extra_params] => 
                            [community_video_id] => 1126
                            [community_url] => https://www.kindlife.in/plum-haul
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1126/5485bf9e4601f3dd331bf2a675ca1f08.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1126/5485bf9e4601f3dd331bf2a675ca1f08.mp4
                            [community_last_sync_timestamp] => 1707913411
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Unboxing My Latest Plum Haul
                            [description] => <p>Treat yourself to a Plum Haul and discover a range of delightful products for your skin and senses! Start with the invigorating Coffee Wake-a-ccino Foot Cream to nourish tired feet. Indulge in the rich Vanilla Vibes BodyButter for deep hydration and a luxurious scent. Finish off with the refreshing Vanilla Vibes Body Mist, perfect for an all-day sweet aroma. Experience the joy of self-care with these Plum favorites, designed to leave you feeling pampered and radiant!</p>
<p><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"><br></span></b></span></p><p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"></span></b></span></b></p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary">
<p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"></span></b></span></b></p>
<p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"></span></b></span></b></b></p>
<p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary">
<span data-state="closed"><b class="cursor-pointer rounded-md px-1 text-token-text-secondary h-[30px] hover:bg-token-main-surface-secondary"></b></span></b></b></b></p>
<p><br></p>
</b><p></p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 0
                            [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] => Plum
        )

)


  2. end of fxn

                


    
    
        
            Plum: 25ml Plum Green Tea Mattifying Moisturizer

        

            





                                        
                                
            

            
                                    

                        
    


    

        
                
                    
        

        
                    
                                                                                
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            

                                                                                                                            Use SUMVIBE10 & Get Flat 10% off on orders above Rs. 1999.Use SUNKISS5 & Get Flat 5% off on orders above Rs. 999.
                                    +1
                                                                                    

                                    
        

                                    Plum
        


        

            

                                
    
            25ml Plum Green Tea Mattifying Moisturizer    


            


            
            

                                
            

            
            



    
Good For: 
    Skin Acne & Pimples  
Shipping: 
    Express Delivery 

        

    


            


            

                                
            


                            

                            
            



                            

        

        

        

                            


	            	                	                 

    
        
        
                                
                                    ₹261
                            

                        

	            	            
	            	            	                           
            

            
            

                            ₹275
                        

            

        
    
	            
            
	            	                
	            
	            	                
                                                                                                                                                        

	                    5%
	                

                                

                                        

                        
                        

     



    


                                

                                                            
            

                

                                                        
                        
 
                                                        
                            
					        
                        

                                                                    
                

                    
                    
                    
                                                                    









        
                
 

        
        
    

    





    
            
    
 
    


    
                            
                                
        
 
    








                                    

            

        

        

    

    
        










    




    0 Items selected
    
        Move to Collection
    






    










            


    

    
    

























    

                            

        
                                        
            
                        

                                    






                            

        
    
        

    









            

        


        

        


        



            
    
    

    
    
    
    
    
    
    
    
    












































































































                    























    
    

    

        
                
        

        

            

            Ctrl+Alt+D - show/hide toolbar
        

        

        
    
            
  • Page generating time 0.8934 s
    • 
            
  • Memory usage 12 956.05 KB
    • 
                    

        

    

    
    

        

            
Server

            ✖
        

        

        

    


    
    

        

            
Request

            ✖
        

        

        

    


    
    

        

            
Config

            ✖
        

        

        

    


    
    

        

            
SQL

            ✖
        

        

        

    


    
    

        

            
Cache queries

            ✖
        

        

        

    


    
    

        

            
Logging

            ✖
        

        

        

    


    
    

        

            
Templates

            ✖
        

        

        

    


    
    

        

            
Blocks

            ✖