1. Array
(
    [show_master_products_only] => 
    [area] => C
    [currency] => USD
    [features_hash] => 28-44657
    [items_per_page] => 24
    [sl] => en
    [dispatch] => categories.view
    [category_id] => 2811
    [save_view_results] => product_id
    [sort_by] => bestsellers
    [sort_order] => desc
    [cid] => 2811
    [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 (44657)) AND ?:categories.category_id IN (2811) 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
(
    [33694] => Array
        (
            [product_id] => 33694
            [product] => Madagascar Centella Cream 75 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] => BL01NRC00480002000
            [hsn_code] => 3304
            [status] => A
            [list_price] => 2299.00
            [amount] => 46
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1693230300
            [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] => 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] => 1609.300000
            [short_description] => <p>Hydrates skin & anti ageing</p>
            [full_description] => <p>Madagascar Centella Cream, an exceptional moisture-sealing cream, boasts a harmonious blend of squalene and Centella asiatica extract, working in synergy to cocoon the skin in a soothing hydration haven. Emanating certified brightening and anti-ageing prowess, it unveils a look of clarity and elasticity. Amidst its velvety, lightweight texture lies a potent guardian, fending off external adversaries while nourishing and revitalising damaged skin. Its seamless glide is accompanied by a delightful natural aroma.</p>
<p>All orders will be dispatched in 8-9 days</p>
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [position] => 0
            [seo_name] => madagascar-centella-cream-75ml
            [seo_path] => 2685/2705/2811
            [average_rating] => 5.00
            [reviews_count] => 1
            [main_category] => 2811
            [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] => SKIN1004
            [ratting_count] => 1
        )

    [28573] => Array
        (
            [product_id] => 28573
            [product] => Matcha & Chia Cleansing Cream - 110gm
            [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] => KITA001
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1950.00
            [amount] => 4
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1681715605
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 1852.500000
            [short_description] => <p>Moisturizes & revitalizes skin</p>
            [full_description] => <p>This facial cream uses antioxidant-rich superfoods such as ECOCERT-certified organic matcha directly from Kyoto, Japan to hydrate, replenish skin, and keep moisture locked in all day long. If youre tired of moisturizing creams that leave your skin feeling greasy or sticky, then this is the perfect facial cream for you. Their formula firms, moisturizes and revitalizes skin all without leaving behind a sticky residue. The quinoa and açai in this formula also help minimize free radical damage and even out skin complexion.</p>
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [position] => 0
            [seo_name] => matcha-and-chia-cleansing-cream-110gm
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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] => Kitao
        )

    [33233] => Array
        (
            [product_id] => 33233
            [product] => Avocado Body Milk - 001 - 300ml
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 605
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => AVBM001
            [hsn_code] => 3304
            [status] => A
            [list_price] => 299.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1692344935
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 284.050000
            [short_description] => Hydrates skin & repaire dryness
            [full_description] => <p>This luxurious body milk moisturizer works deep within the skin, helps in repairing dryness layer by layer stimulate moisture production naturally. This is much lighter so it quickly seeps into the skin. It’s time to hydrate thirsty skin with a replenishing dose of lightweight moisture. It come up with a fluid texture compared to body lotion while leaving skin smooth, glowy and supple.</p>
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [position] => 0
            [seo_name] => avocado-body-milk-001-300ml
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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] => Colorbar
        )

    [33695] => Array
        (
            [product_id] => 33695
            [product] =>  Madagascar Centella Cream 30ml
            [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] => BL01WAC00480005000
            [hsn_code] => 3304
            [status] => A
            [list_price] => 899.00
            [amount] => 7
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1693230300
            [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] => 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] => 629.300000
            [short_description] => <p>Hydrates skin & anti ageing</p>
            [full_description] => <p>Madagascar Centella Cream, an exceptional moisture-sealing cream, boasts a harmonious blend of squalene and Centella asiatica extract, working in synergy to cocoon the skin in a soothing hydration haven. Emanating certified brightening and anti-ageing prowess, it unveils a visage of clarity and elasticity. Amidst its velvety, lightweight texture lies a potent guardian, fending off external adversaries while nourishing and revitalising damaged skin. Its seamless glide is accompanied by a delightful natural aroma.</p>
<p>All orders will be dispatched in 8-9 days</p>
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [position] => 0
            [seo_name] => madagascar-centella-cream-30ml
            [seo_path] => 2685/2705/2811
            [average_rating] => 5.00
            [reviews_count] => 2
            [main_category] => 2811
            [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] => SKIN1004
            [ratting_count] => 2
        )

    [35812] => Array
        (
            [product_id] => 35812
            [product] => Skin Replenishing Rich Moisturiser - 125ml
            [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] => 27276
            [hsn_code] => 3304
            [status] => A
            [list_price] => 475.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1705649616
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 451.250000
            [short_description] => Hydration for 12 hours
            [full_description] => <p>Simple focuses on rejecting skin irritants and utilising ingredients that nourish and maintain your skin's equilibrium. Environmental factors like pollution, stress, and weather changes can trigger sensitivity. Replenishing rich facial moisturiser provides 24-hour hydration, rendering skin smooth and nourished. Infused with skin-friendly elements like Pro-Vitamin B5 and Bisabolol, it revitalises, soothes, and hydrates sans greasiness. Free from dyes, artificial fragrances, and harsh chemicals, it suits even sensitive skin. Dermatologist- and ophthalmologist-approved, hypoallergenic, and non-comedogenic Simple is the choice for expert, kind skincare.</p>
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [position] => 0
            [seo_name] => skin-replenishing-rich-moisturiser-125ml
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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] => Simple
        )

    [35813] => Array
        (
            [product_id] => 35813
            [product] => Skin Protecting Light Moisturiser - 125ml
            [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] => 27275
            [hsn_code] => 3304
            [status] => A
            [list_price] => 485.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1705649616
            [updated_timestamp] => 1750411725
            [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] => 461.000000
            [short_description] => Moisturises skin & nourishes skin
            [full_description] => <p>Simple's philosophy revolves around rejecting skin irritants and embracing ingredients that love and balance your skin. Sensitive skin can arise from pollution, stress, and various other factors, warranting extra care. Embrace the Simple approach with our Kind to Skin Protecting Light Moisturiser SPF 15. This essential addition to your SPF regimen hydrates for 12 hours while guarding against UVA and UVB rays. Suitable for sensitive skin, it's free from artificial colours, perfumes, and harsh chemicals. With Pro-vitamin B5, vitamin E, glycerin, allantoin, bisabol, and SPF 15, this staple follows your Simple cleanser, delivering moisturization, nourishment, and protection. A pathway to radiant, healthy skin.</p>
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [position] => 0
            [seo_name] => skin-protecting-light-moisturiser-125ml
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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] => Simple
        )

    [35820] => Array
        (
            [product_id] => 35820
            [product] => Water Boost Hydrating Gel Creme - 50gm
            [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] => SMPI100
            [hsn_code] => 3304
            [status] => A
            [list_price] => 499.00
            [amount] => 16
            [weight] => 50.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1705649616
            [updated_timestamp] => 1750414740
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => N
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 474.000000
            [short_description] => 
            [full_description] => <p>Simple water boost hydrating gel cream moisturiser, an oil-free gem, delivers 100-hour hydration with a lightweight touch, leaving skin velvety, supple, and revitalized throughout the day. Fit for all skin types, particularly dry and dehydrated, its non-greasy, swift-absorbing formulation suits oily skin as well, without clogging poresdeeply nourishing while maintaining a fresh feel. Packed with skin-loving elements, including 11% hydrating actives for natural hydration, Pentavitin for 2x faster skin reset, plant-based glycerin for replenishment, and Vitamin E for smoother, healthier skin. Enhanced with prebiotics to restore moisture and rejuvenate dry, damaged skin. Suitable for various skin types and genders.</p>
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [position] => 0
            [seo_name] => water-boost-hydrating-gel-creme-50gm
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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
                (
                    [1382] => Array
                        (
                            [video_id] => 1382
                            [video_type] => S
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1722882600
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 0
                            [community_url] => https://admin.kindlife.in/beat-the-heat-hydrate-with-ease
                            [community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1382_SaveInsta.App - 3400351472614108250_preview.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/video_library/1382_SaveInsta.App - 3400351472614108250.mp4
                            [community_last_sync_timestamp] => 0
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Beat the Heat, Hydrate with Ease
                            [description] => <p>Summer heat got your skin feeling sticky. Don't worry, we've got you covered! Check out these lightweight moisturizers that pack a hydration punch without the greasy feel. Say hello to fresh, dewy skin all summer long!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 1
                            [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
                                )

                        )

                    [1267] => Array
                        (
                            [video_id] => 1267
                            [video_type] => A
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1716316200
                            [status] => A
                            [user_id] => 210173
                            [extra_params] => 
                            [community_video_id] => 0
                            [community_url] => https://www.kindlife.in/simple-water-boost-hydrating-gel-creme
                            [community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1267_1000300034_preview.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/video_library/1267_1000300034.mp4
                            [community_last_sync_timestamp] => 0
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Unlock a Burst of Hydration
                            [description] => <p>Quench your skin’s thirst with Simple Water Boost Hydrating Gel Creme!&nbsp; Lightweight and refreshing, it provides instant hydration for a plump, dewy complexion. Perfect for all skin types, this gel creme keeps your skin feeling soft and smooth all day long.&nbsp;</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 0
                            [dislike_count] => 0
                            [comment_count] => 0
                            [meta_keywords] => 
                            [meta_description] => 
                            [page_title] => 
                            [tagged_brands] => 52656
                            [category_id] => 7
                            [link_type] => M
                            [preview] => Array
                                (
                                    [default_icon] => 1
                                )

                        )

                )

            [cp_has_video] => 1
            [brand_name] => Simple
        )

)


  1. Array
(
    [33694] => Array
        (
            [product_id] => 33694
            [product] => Madagascar Centella Cream 75 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] => BL01NRC00480002000
            [hsn_code] => 3304
            [status] => A
            [list_price] => 2299.00
            [amount] => 46
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1693230300
            [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] => 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] => 1609.300000
            [short_description] => <p>Hydrates skin & anti ageing</p>
            [full_description] => <p>Madagascar Centella Cream, an exceptional moisture-sealing cream, boasts a harmonious blend of squalene and Centella asiatica extract, working in synergy to cocoon the skin in a soothing hydration haven. Emanating certified brightening and anti-ageing prowess, it unveils a look of clarity and elasticity. Amidst its velvety, lightweight texture lies a potent guardian, fending off external adversaries while nourishing and revitalising damaged skin. Its seamless glide is accompanied by a delightful natural aroma.</p>
<p>All orders will be dispatched in 8-9 days</p>
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [position] => 0
            [seo_name] => madagascar-centella-cream-75ml
            [seo_path] => 2685/2705/2811
            [average_rating] => 5.00
            [reviews_count] => 1
            [main_category] => 2811
            [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] => SKIN1004
            [ratting_count] => 1
        )

    [28573] => Array
        (
            [product_id] => 28573
            [product] => Matcha & Chia Cleansing Cream - 110gm
            [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] => KITA001
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1950.00
            [amount] => 4
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1681715605
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 1852.500000
            [short_description] => <p>Moisturizes & revitalizes skin</p>
            [full_description] => <p>This facial cream uses antioxidant-rich superfoods such as ECOCERT-certified organic matcha directly from Kyoto, Japan to hydrate, replenish skin, and keep moisture locked in all day long. If youre tired of moisturizing creams that leave your skin feeling greasy or sticky, then this is the perfect facial cream for you. Their formula firms, moisturizes and revitalizes skin all without leaving behind a sticky residue. The quinoa and açai in this formula also help minimize free radical damage and even out skin complexion.</p>
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [position] => 0
            [seo_name] => matcha-and-chia-cleansing-cream-110gm
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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] => Kitao
        )

    [33233] => Array
        (
            [product_id] => 33233
            [product] => Avocado Body Milk - 001 - 300ml
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 605
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => AVBM001
            [hsn_code] => 3304
            [status] => A
            [list_price] => 299.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1692344935
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 284.050000
            [short_description] => Hydrates skin & repaire dryness
            [full_description] => <p>This luxurious body milk moisturizer works deep within the skin, helps in repairing dryness layer by layer stimulate moisture production naturally. This is much lighter so it quickly seeps into the skin. It’s time to hydrate thirsty skin with a replenishing dose of lightweight moisture. It come up with a fluid texture compared to body lotion while leaving skin smooth, glowy and supple.</p>
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [position] => 0
            [seo_name] => avocado-body-milk-001-300ml
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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] => Colorbar
        )

    [33695] => Array
        (
            [product_id] => 33695
            [product] =>  Madagascar Centella Cream 30ml
            [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] => BL01WAC00480005000
            [hsn_code] => 3304
            [status] => A
            [list_price] => 899.00
            [amount] => 7
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1693230300
            [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] => 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] => 629.300000
            [short_description] => <p>Hydrates skin & anti ageing</p>
            [full_description] => <p>Madagascar Centella Cream, an exceptional moisture-sealing cream, boasts a harmonious blend of squalene and Centella asiatica extract, working in synergy to cocoon the skin in a soothing hydration haven. Emanating certified brightening and anti-ageing prowess, it unveils a visage of clarity and elasticity. Amidst its velvety, lightweight texture lies a potent guardian, fending off external adversaries while nourishing and revitalising damaged skin. Its seamless glide is accompanied by a delightful natural aroma.</p>
<p>All orders will be dispatched in 8-9 days</p>
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [position] => 0
            [seo_name] => madagascar-centella-cream-30ml
            [seo_path] => 2685/2705/2811
            [average_rating] => 5.00
            [reviews_count] => 2
            [main_category] => 2811
            [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] => SKIN1004
            [ratting_count] => 2
        )

    [35812] => Array
        (
            [product_id] => 35812
            [product] => Skin Replenishing Rich Moisturiser - 125ml
            [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] => 27276
            [hsn_code] => 3304
            [status] => A
            [list_price] => 475.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1705649616
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 451.250000
            [short_description] => Hydration for 12 hours
            [full_description] => <p>Simple focuses on rejecting skin irritants and utilising ingredients that nourish and maintain your skin's equilibrium. Environmental factors like pollution, stress, and weather changes can trigger sensitivity. Replenishing rich facial moisturiser provides 24-hour hydration, rendering skin smooth and nourished. Infused with skin-friendly elements like Pro-Vitamin B5 and Bisabolol, it revitalises, soothes, and hydrates sans greasiness. Free from dyes, artificial fragrances, and harsh chemicals, it suits even sensitive skin. Dermatologist- and ophthalmologist-approved, hypoallergenic, and non-comedogenic Simple is the choice for expert, kind skincare.</p>
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [position] => 0
            [seo_name] => skin-replenishing-rich-moisturiser-125ml
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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] => Simple
        )

    [35813] => Array
        (
            [product_id] => 35813
            [product] => Skin Protecting Light Moisturiser - 125ml
            [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] => 27275
            [hsn_code] => 3304
            [status] => A
            [list_price] => 485.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1705649616
            [updated_timestamp] => 1750411725
            [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] => 461.000000
            [short_description] => Moisturises skin & nourishes skin
            [full_description] => <p>Simple's philosophy revolves around rejecting skin irritants and embracing ingredients that love and balance your skin. Sensitive skin can arise from pollution, stress, and various other factors, warranting extra care. Embrace the Simple approach with our Kind to Skin Protecting Light Moisturiser SPF 15. This essential addition to your SPF regimen hydrates for 12 hours while guarding against UVA and UVB rays. Suitable for sensitive skin, it's free from artificial colours, perfumes, and harsh chemicals. With Pro-vitamin B5, vitamin E, glycerin, allantoin, bisabol, and SPF 15, this staple follows your Simple cleanser, delivering moisturization, nourishment, and protection. A pathway to radiant, healthy skin.</p>
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [position] => 0
            [seo_name] => skin-protecting-light-moisturiser-125ml
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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] => Simple
        )

    [35820] => Array
        (
            [product_id] => 35820
            [product] => Water Boost Hydrating Gel Creme - 50gm
            [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] => SMPI100
            [hsn_code] => 3304
            [status] => A
            [list_price] => 499.00
            [amount] => 16
            [weight] => 50.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1705649616
            [updated_timestamp] => 1750414740
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => N
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 474.000000
            [short_description] => 
            [full_description] => <p>Simple water boost hydrating gel cream moisturiser, an oil-free gem, delivers 100-hour hydration with a lightweight touch, leaving skin velvety, supple, and revitalized throughout the day. Fit for all skin types, particularly dry and dehydrated, its non-greasy, swift-absorbing formulation suits oily skin as well, without clogging poresdeeply nourishing while maintaining a fresh feel. Packed with skin-loving elements, including 11% hydrating actives for natural hydration, Pentavitin for 2x faster skin reset, plant-based glycerin for replenishment, and Vitamin E for smoother, healthier skin. Enhanced with prebiotics to restore moisture and rejuvenate dry, damaged skin. Suitable for various skin types and genders.</p>
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [position] => 0
            [seo_name] => water-boost-hydrating-gel-creme-50gm
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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
                (
                    [1382] => Array
                        (
                            [video_id] => 1382
                            [video_type] => S
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1722882600
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 0
                            [community_url] => https://admin.kindlife.in/beat-the-heat-hydrate-with-ease
                            [community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1382_SaveInsta.App - 3400351472614108250_preview.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/video_library/1382_SaveInsta.App - 3400351472614108250.mp4
                            [community_last_sync_timestamp] => 0
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Beat the Heat, Hydrate with Ease
                            [description] => <p>Summer heat got your skin feeling sticky. Don't worry, we've got you covered! Check out these lightweight moisturizers that pack a hydration punch without the greasy feel. Say hello to fresh, dewy skin all summer long!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 1
                            [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
                                )

                        )

                    [1267] => Array
                        (
                            [video_id] => 1267
                            [video_type] => A
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1716316200
                            [status] => A
                            [user_id] => 210173
                            [extra_params] => 
                            [community_video_id] => 0
                            [community_url] => https://www.kindlife.in/simple-water-boost-hydrating-gel-creme
                            [community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1267_1000300034_preview.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/video_library/1267_1000300034.mp4
                            [community_last_sync_timestamp] => 0
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Unlock a Burst of Hydration
                            [description] => <p>Quench your skin’s thirst with Simple Water Boost Hydrating Gel Creme!&nbsp; Lightweight and refreshing, it provides instant hydration for a plump, dewy complexion. Perfect for all skin types, this gel creme keeps your skin feeling soft and smooth all day long.&nbsp;</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 0
                            [dislike_count] => 0
                            [comment_count] => 0
                            [meta_keywords] => 
                            [meta_description] => 
                            [page_title] => 
                            [tagged_brands] => 52656
                            [category_id] => 7
                            [link_type] => M
                            [preview] => Array
                                (
                                    [default_icon] => 1
                                )

                        )

                )

            [cp_has_video] => 1
            [brand_name] => Simple
        )

)


  2. end of fxn

  1. Array
(
    [show_master_products_only] => 
    [area] => C
    [pid] => 28573
    [limit] => 1
    [total] => 1
    [custom_extend] => Array
        (
            [0] => product_name
            [1] => categories
        )

    [load_products_extra_data] => 
    [force_virtual] => 1
    [runtime_company_id] => 0
    [vr_company_id] => 0
    [is_virtual] => Y
    [virtual_conditions] => Array
        (
            [set] => all
            [set_value] => 1
            [conditions] => Array
                (
                    [1] => Array
                        (
                            [operator] => in
                            [condition] => products
                            [value] => 3556,3976,14830,15216,23660,28537,32931,35638,35639,36366,37916,39004,39636,58631,63910,63916,63922,65282
                        )

                )

        )

)


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

    [custom_extend] => Array
        (
        )

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

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

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

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


  1. Advanced and feature filters

  1. before hook

  1. after hook

  2. C

  1. 1

  1. before 2nd hook

  1. after 2nd hook

  1. SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A')  AND  ((1  AND  products.product_id IN (28573)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products.product_id IN (3556,3976,14830,15216,23660,28537,32931,35638,35639,36366,37916,39004,39636,58631,63910,63916,63922,65282)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1

  1. before end of oxn

  2. Array
(
)


  1. Array
(
)


  2. end of fxn

  1. Array
(
    [show_master_products_only] => 
    [area] => C
    [pid] => 28573
    [limit] => 1
    [total] => 1
    [custom_extend] => Array
        (
            [0] => product_name
            [1] => categories
        )

    [load_products_extra_data] => 
    [force_virtual] => 1
    [runtime_company_id] => 0
    [vr_company_id] => 0
    [is_virtual] => Y
    [virtual_conditions] => Array
        (
            [set] => all
            [set_value] => 1
            [conditions] => Array
                (
                    [1] => Array
                        (
                            [condition_element] => 62
                            [operator] => nin
                            [condition] => feature
                            [value] => 49321,40971,38308
                            [value_name] => 
                        )

                )

        )

    [include_child_variations] => 1
)


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

    [custom_extend] => Array
        (
        )

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

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

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

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


  1. Advanced and feature filters

  1. before hook

  1. after hook

  2. C

  1. 1

  1. before 2nd hook

  1. after 2nd hook

  1. SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  LEFT JOIN ?:product_features_values AS pfv_62 ON pfv_62.product_id = products.product_id AND pfv_62.feature_id = 62 WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A')  AND  ((1  AND  products.product_id IN (28573)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND pfv_62.variant_id NOT IN (49321,40971,38308)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1

  1. before end of oxn

  2. Array
(
    [28573] => Array
        (
            [product_id] => 28573
            [product] => Matcha & Chia Cleansing Cream - 110gm
            [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
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                )

            [brand_name] => Kitao
        )

)


  1. Array
(
    [28573] => Array
        (
            [product_id] => 28573
            [product] => Matcha & Chia Cleansing Cream - 110gm
            [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
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                )

            [brand_name] => Kitao
        )

)


  2. end of fxn

  1. Array
(
    [show_master_products_only] => 
    [area] => C
    [pid] => 28573
    [limit] => 1
    [total] => 1
    [custom_extend] => Array
        (
            [0] => product_name
            [1] => categories
        )

    [load_products_extra_data] => 
    [force_virtual] => 1
    [runtime_company_id] => 0
    [vr_company_id] => 0
    [is_virtual] => Y
    [virtual_conditions] => Array
        (
            [set] => all
            [set_value] => 1
            [conditions] => Array
                (
                    [1] => Array
                        (
                            [operator] => in
                            [condition] => categories
                            [value] => 274,275,276,277,278,281,282,284,285,287,288,290,296,432,508,579,620,621,745,1011,1096,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1181,1182,1183,1184,1185,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1202,1203,1204,1205,1206,1207,1208,1209,1214,1215,1216,1217,1218,1238,1270,1364,1632,1648,1703,1704,1977,2040,2116,2117,2118,2141,2191,2242,2250,2251,2322,2366,2421,2437,2439,2440,2444,2445,2456,2457,2458,2465,2468,2469,2472,2474,2476,2477,2481,2483,2485,2486,2489,2492,2497,2498,458,1186,2438,2453,2463,2473,2488,2494,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2654,2655,2656,2657,2658,2659,2660,2661,2662,2663,2664,2665,2666,2667,2668,2669,2670,2671,2672,2673,2674,2675,2676,2677,2678,2679,2680,2681,2682,2683,2684
                        )

                )

        )

)


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

    [custom_extend] => Array
        (
        )

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

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

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

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


  1. Advanced and feature filters

  1. before hook

  1. after hook

  2. C

  1. 1

  1. before 2nd hook

  1. after 2nd hook

  1. SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A')  AND  ((1  AND  products.product_id IN (28573)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products_categories.category_id IN (458, 1648, 274, 275, 276, 277, 278, 281, 282, 284, 285, 287, 288, 290, 296, 432, 2662, 508, 579, 1632, 620, 621, 745, 1011, 1096, 1218, 1153, 1154, 1155, 1156, 1157, 1158, 1159, 1160, 1161, 1162, 1163, 1164, 1165, 1166, 1167, 1168, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1214, 1215, 1216, 1217, 1238, 1270, 1364, 1704, 1703, 1977, 2040, 2116, 2117, 2118, 2141, 2191, 2242, 2661, 2250, 2251, 2488, 2421, 2322, 2366, 2656, 2437, 2438, 2439, 2440, 2645, 2659, 2444, 2445, 2663, 2658, 2654, 2453, 2643, 2644, 2456, 2457, 2458, 2653, 2651, 2652, 2463, 2465, 2640, 2468, 2469, 2649, 2650, 2472, 2473, 2474, 2646, 2476, 2477, 2648, 2684, 2481, 2660, 2642, 2483, 2485, 2486, 2489, 2647, 2641, 2492, 2494, 2655, 2497, 2498, 2657, 2664, 2666, 2665, 2667, 2668, 2669, 2670, 2671, 2672, 2673, 2674, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1

  1. before end of oxn

  2. Array
(
)


  1. Array
(
)


  2. end of fxn

  1. Array
(
    [show_master_products_only] => 
    [area] => C
    [pid] => 28573
    [limit] => 1
    [total] => 1
    [custom_extend] => Array
        (
            [0] => product_name
            [1] => categories
        )

    [load_products_extra_data] => 
    [force_virtual] => 1
    [runtime_company_id] => 0
    [vr_company_id] => 0
    [is_virtual] => Y
    [virtual_conditions] => Array
        (
            [set] => all
            [set_value] => 1
            [conditions] => Array
                (
                    [1] => Array
                        (
                            [operator] => in
                            [condition] => categories
                            [value] => 458,1186,2438,2453,2463,2473,2488,2494,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2654,2655,2656,2657,2658,2659,2660,2661,2662,2663,2664,2665,2666,2667,2668,2669,2670,2671,2672,2673,2674,2675,2676,2677,2678,2679,2680,2681,2682,2683,2684
                        )

                )

        )

)


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

    [custom_extend] => Array
        (
        )

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

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

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

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


  1. Advanced and feature filters

  1. before hook

  1. after hook

  2. C

  1. 1

  1. before 2nd hook

  1. after 2nd hook

  1. SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A')  AND  ((1  AND  products.product_id IN (28573)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products_categories.category_id IN (458, 2662, 1186, 2661, 2488, 2656, 2438, 2645, 2659, 2663, 2658, 2654, 2453, 2643, 2644, 2653, 2651, 2652, 2463, 2640, 2649, 2650, 2473, 2646, 2648, 2684, 2660, 2642, 2647, 2641, 2494, 2655, 2657, 2664, 2666, 2665, 2667, 2668, 2669, 2670, 2671, 2672, 2673, 2674, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1

  1. before end of oxn

  2. Array
(
)


  1. Array
(
)


  2. end of fxn

  1. Array
(
    [show_master_products_only] => 
    [area] => C
    [pid] => 35820
    [limit] => 1
    [total] => 1
    [custom_extend] => Array
        (
            [0] => product_name
            [1] => categories
        )

    [load_products_extra_data] => 
    [force_virtual] => 1
    [runtime_company_id] => 0
    [vr_company_id] => 0
    [is_virtual] => Y
    [virtual_conditions] => Array
        (
            [set] => all
            [set_value] => 1
            [conditions] => Array
                (
                    [1] => Array
                        (
                            [operator] => in
                            [condition] => products
                            [value] => 3556,3976,14830,15216,23660,28537,32931,35638,35639,36366,37916,39004,39636,58631,63910,63916,63922,65282
                        )

                )

        )

)


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

    [custom_extend] => Array
        (
        )

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

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

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

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


  1. Advanced and feature filters

  1. before hook

  1. after hook

  2. C

  1. 1

  1. before 2nd hook

  1. after 2nd hook

  1. SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A')  AND  ((1  AND  products.product_id IN (35820)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products.product_id IN (3556,3976,14830,15216,23660,28537,32931,35638,35639,36366,37916,39004,39636,58631,63910,63916,63922,65282)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1

  1. before end of oxn

  2. Array
(
)


  1. Array
(
)


  2. end of fxn

  1. Array
(
    [show_master_products_only] => 
    [area] => C
    [pid] => 35820
    [limit] => 1
    [total] => 1
    [custom_extend] => Array
        (
            [0] => product_name
            [1] => categories
        )

    [load_products_extra_data] => 
    [force_virtual] => 1
    [runtime_company_id] => 0
    [vr_company_id] => 0
    [is_virtual] => Y
    [virtual_conditions] => Array
        (
            [set] => all
            [set_value] => 1
            [conditions] => Array
                (
                    [1] => Array
                        (
                            [condition_element] => 62
                            [operator] => nin
                            [condition] => feature
                            [value] => 49321,40971,38308
                            [value_name] => 
                        )

                )

        )

    [include_child_variations] => 1
)


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

    [custom_extend] => Array
        (
        )

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

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

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

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


  1. Advanced and feature filters

  1. before hook

  1. after hook

  2. C

  1. 1

  1. before 2nd hook

  1. after 2nd hook

  1. SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  LEFT JOIN ?:product_features_values AS pfv_62 ON pfv_62.product_id = products.product_id AND pfv_62.feature_id = 62 WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A')  AND  ((1  AND  products.product_id IN (35820)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND pfv_62.variant_id NOT IN (49321,40971,38308)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1

  1. before end of oxn

  2. Array
(
    [35820] => Array
        (
            [product_id] => 35820
            [product] => Water Boost Hydrating Gel Creme - 50gm
            [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
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                    [1382] => Array
                        (
                            [video_id] => 1382
                            [video_type] => S
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1722882600
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 0
                            [community_url] => https://admin.kindlife.in/beat-the-heat-hydrate-with-ease
                            [community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1382_SaveInsta.App - 3400351472614108250_preview.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/video_library/1382_SaveInsta.App - 3400351472614108250.mp4
                            [community_last_sync_timestamp] => 0
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Beat the Heat, Hydrate with Ease
                            [description] => <p>Summer heat got your skin feeling sticky. Don't worry, we've got you covered! Check out these lightweight moisturizers that pack a hydration punch without the greasy feel. Say hello to fresh, dewy skin all summer long!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 1
                            [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
                                )

                        )

                    [1267] => Array
                        (
                            [video_id] => 1267
                            [video_type] => A
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1716316200
                            [status] => A
                            [user_id] => 210173
                            [extra_params] => 
                            [community_video_id] => 0
                            [community_url] => https://www.kindlife.in/simple-water-boost-hydrating-gel-creme
                            [community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1267_1000300034_preview.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/video_library/1267_1000300034.mp4
                            [community_last_sync_timestamp] => 0
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Unlock a Burst of Hydration
                            [description] => <p>Quench your skin’s thirst with Simple Water Boost Hydrating Gel Creme!&nbsp; Lightweight and refreshing, it provides instant hydration for a plump, dewy complexion. Perfect for all skin types, this gel creme keeps your skin feeling soft and smooth all day long.&nbsp;</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 0
                            [dislike_count] => 0
                            [comment_count] => 0
                            [meta_keywords] => 
                            [meta_description] => 
                            [page_title] => 
                            [tagged_brands] => 52656
                            [category_id] => 7
                            [link_type] => M
                            [preview] => Array
                                (
                                    [default_icon] => 1
                                )

                        )

                )

            [cp_has_video] => 1
            [brand_name] => Simple
        )

)


  1. Array
(
    [35820] => Array
        (
            [product_id] => 35820
            [product] => Water Boost Hydrating Gel Creme - 50gm
            [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
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                    [1382] => Array
                        (
                            [video_id] => 1382
                            [video_type] => S
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1722882600
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 0
                            [community_url] => https://admin.kindlife.in/beat-the-heat-hydrate-with-ease
                            [community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1382_SaveInsta.App - 3400351472614108250_preview.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/video_library/1382_SaveInsta.App - 3400351472614108250.mp4
                            [community_last_sync_timestamp] => 0
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Beat the Heat, Hydrate with Ease
                            [description] => <p>Summer heat got your skin feeling sticky. Don't worry, we've got you covered! Check out these lightweight moisturizers that pack a hydration punch without the greasy feel. Say hello to fresh, dewy skin all summer long!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 1
                            [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
                                )

                        )

                    [1267] => Array
                        (
                            [video_id] => 1267
                            [video_type] => A
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1716316200
                            [status] => A
                            [user_id] => 210173
                            [extra_params] => 
                            [community_video_id] => 0
                            [community_url] => https://www.kindlife.in/simple-water-boost-hydrating-gel-creme
                            [community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1267_1000300034_preview.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/video_library/1267_1000300034.mp4
                            [community_last_sync_timestamp] => 0
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Unlock a Burst of Hydration
                            [description] => <p>Quench your skin’s thirst with Simple Water Boost Hydrating Gel Creme!&nbsp; Lightweight and refreshing, it provides instant hydration for a plump, dewy complexion. Perfect for all skin types, this gel creme keeps your skin feeling soft and smooth all day long.&nbsp;</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 0
                            [dislike_count] => 0
                            [comment_count] => 0
                            [meta_keywords] => 
                            [meta_description] => 
                            [page_title] => 
                            [tagged_brands] => 52656
                            [category_id] => 7
                            [link_type] => M
                            [preview] => Array
                                (
                                    [default_icon] => 1
                                )

                        )

                )

            [cp_has_video] => 1
            [brand_name] => Simple
        )

)


  2. end of fxn

  1. Array
(
    [show_master_products_only] => 
    [area] => C
    [pid] => 35820
    [limit] => 1
    [total] => 1
    [custom_extend] => Array
        (
            [0] => product_name
            [1] => categories
        )

    [load_products_extra_data] => 
    [force_virtual] => 1
    [runtime_company_id] => 0
    [vr_company_id] => 0
    [is_virtual] => Y
    [virtual_conditions] => Array
        (
            [set] => all
            [set_value] => 1
            [conditions] => Array
                (
                    [1] => Array
                        (
                            [operator] => in
                            [condition] => categories
                            [value] => 274,275,276,277,278,281,282,284,285,287,288,290,296,432,508,579,620,621,745,1011,1096,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1181,1182,1183,1184,1185,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1202,1203,1204,1205,1206,1207,1208,1209,1214,1215,1216,1217,1218,1238,1270,1364,1632,1648,1703,1704,1977,2040,2116,2117,2118,2141,2191,2242,2250,2251,2322,2366,2421,2437,2439,2440,2444,2445,2456,2457,2458,2465,2468,2469,2472,2474,2476,2477,2481,2483,2485,2486,2489,2492,2497,2498,458,1186,2438,2453,2463,2473,2488,2494,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2654,2655,2656,2657,2658,2659,2660,2661,2662,2663,2664,2665,2666,2667,2668,2669,2670,2671,2672,2673,2674,2675,2676,2677,2678,2679,2680,2681,2682,2683,2684
                        )

                )

        )

)


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

    [custom_extend] => Array
        (
        )

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

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

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

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


  1. Advanced and feature filters

  1. before hook

  1. after hook

  2. C

  1. 1

  1. before 2nd hook

  1. after 2nd hook

  1. SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A')  AND  ((1  AND  products.product_id IN (35820)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products_categories.category_id IN (458, 1648, 274, 275, 276, 277, 278, 281, 282, 284, 285, 287, 288, 290, 296, 432, 2662, 508, 579, 1632, 620, 621, 745, 1011, 1096, 1218, 1153, 1154, 1155, 1156, 1157, 1158, 1159, 1160, 1161, 1162, 1163, 1164, 1165, 1166, 1167, 1168, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1214, 1215, 1216, 1217, 1238, 1270, 1364, 1704, 1703, 1977, 2040, 2116, 2117, 2118, 2141, 2191, 2242, 2661, 2250, 2251, 2488, 2421, 2322, 2366, 2656, 2437, 2438, 2439, 2440, 2645, 2659, 2444, 2445, 2663, 2658, 2654, 2453, 2643, 2644, 2456, 2457, 2458, 2653, 2651, 2652, 2463, 2465, 2640, 2468, 2469, 2649, 2650, 2472, 2473, 2474, 2646, 2476, 2477, 2648, 2684, 2481, 2660, 2642, 2483, 2485, 2486, 2489, 2647, 2641, 2492, 2494, 2655, 2497, 2498, 2657, 2664, 2666, 2665, 2667, 2668, 2669, 2670, 2671, 2672, 2673, 2674, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1

  1. before end of oxn

  2. Array
(
)


  1. Array
(
)


  2. end of fxn

  1. Array
(
    [show_master_products_only] => 
    [area] => C
    [pid] => 35820
    [limit] => 1
    [total] => 1
    [custom_extend] => Array
        (
            [0] => product_name
            [1] => categories
        )

    [load_products_extra_data] => 
    [force_virtual] => 1
    [runtime_company_id] => 0
    [vr_company_id] => 0
    [is_virtual] => Y
    [virtual_conditions] => Array
        (
            [set] => all
            [set_value] => 1
            [conditions] => Array
                (
                    [1] => Array
                        (
                            [operator] => in
                            [condition] => categories
                            [value] => 458,1186,2438,2453,2463,2473,2488,2494,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2654,2655,2656,2657,2658,2659,2660,2661,2662,2663,2664,2665,2666,2667,2668,2669,2670,2671,2672,2673,2674,2675,2676,2677,2678,2679,2680,2681,2682,2683,2684
                        )

                )

        )

)


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

    [custom_extend] => Array
        (
        )

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

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

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

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


  1. Advanced and feature filters

  1. before hook

  1. after hook

  2. C

  1. 1

  1. before 2nd hook

  1. after 2nd hook

  1. SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A')  AND  ((1  AND  products.product_id IN (35820)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products_categories.category_id IN (458, 2662, 1186, 2661, 2488, 2656, 2438, 2645, 2659, 2663, 2658, 2654, 2453, 2643, 2644, 2653, 2651, 2652, 2463, 2640, 2649, 2650, 2473, 2646, 2648, 2684, 2660, 2642, 2647, 2641, 2494, 2655, 2657, 2664, 2666, 2665, 2667, 2668, 2669, 2670, 2671, 2672, 2673, 2674, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1

  1. before end of oxn

  2. Array
(
)


  1. Array
(
)


  2. end of fxn

  1. Array
(
    [show_master_products_only] => 
    [area] => C
    [currency] => USD
    [features_hash] => 28-44657
    [items_per_page] => 24
    [sl] => en
    [dispatch] => categories.view
    [category_id] => 2811
    [save_view_results] => product_id
    [sort_by] => bestsellers
    [sort_order] => desc
    [cid] => 2811
    [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 (44657)) AND ?:categories.category_id IN (2811) 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
(
    [33694] => Array
        (
            [product_id] => 33694
            [product] => Madagascar Centella Cream 75 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] => BL01NRC00480002000
            [hsn_code] => 3304
            [status] => A
            [list_price] => 2299.00
            [amount] => 46
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1693230300
            [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] => 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] => 1609.300000
            [short_description] => <p>Hydrates skin & anti ageing</p>
            [full_description] => <p>Madagascar Centella Cream, an exceptional moisture-sealing cream, boasts a harmonious blend of squalene and Centella asiatica extract, working in synergy to cocoon the skin in a soothing hydration haven. Emanating certified brightening and anti-ageing prowess, it unveils a look of clarity and elasticity. Amidst its velvety, lightweight texture lies a potent guardian, fending off external adversaries while nourishing and revitalising damaged skin. Its seamless glide is accompanied by a delightful natural aroma.</p>
<p>All orders will be dispatched in 8-9 days</p>
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [position] => 0
            [seo_name] => madagascar-centella-cream-75ml
            [seo_path] => 2685/2705/2811
            [average_rating] => 5.00
            [reviews_count] => 1
            [main_category] => 2811
            [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] => SKIN1004
            [ratting_count] => 1
        )

    [28573] => Array
        (
            [product_id] => 28573
            [product] => Matcha & Chia Cleansing Cream - 110gm
            [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] => KITA001
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1950.00
            [amount] => 4
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1681715605
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 1852.500000
            [short_description] => <p>Moisturizes & revitalizes skin</p>
            [full_description] => <p>This facial cream uses antioxidant-rich superfoods such as ECOCERT-certified organic matcha directly from Kyoto, Japan to hydrate, replenish skin, and keep moisture locked in all day long. If youre tired of moisturizing creams that leave your skin feeling greasy or sticky, then this is the perfect facial cream for you. Their formula firms, moisturizes and revitalizes skin all without leaving behind a sticky residue. The quinoa and açai in this formula also help minimize free radical damage and even out skin complexion.</p>
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [position] => 0
            [seo_name] => matcha-and-chia-cleansing-cream-110gm
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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] => Kitao
        )

    [33233] => Array
        (
            [product_id] => 33233
            [product] => Avocado Body Milk - 001 - 300ml
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 605
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => AVBM001
            [hsn_code] => 3304
            [status] => A
            [list_price] => 299.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1692344935
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 284.050000
            [short_description] => Hydrates skin & repaire dryness
            [full_description] => <p>This luxurious body milk moisturizer works deep within the skin, helps in repairing dryness layer by layer stimulate moisture production naturally. This is much lighter so it quickly seeps into the skin. It’s time to hydrate thirsty skin with a replenishing dose of lightweight moisture. It come up with a fluid texture compared to body lotion while leaving skin smooth, glowy and supple.</p>
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [position] => 0
            [seo_name] => avocado-body-milk-001-300ml
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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] => Colorbar
        )

    [33695] => Array
        (
            [product_id] => 33695
            [product] =>  Madagascar Centella Cream 30ml
            [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] => BL01WAC00480005000
            [hsn_code] => 3304
            [status] => A
            [list_price] => 899.00
            [amount] => 7
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1693230300
            [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] => 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] => 629.300000
            [short_description] => <p>Hydrates skin & anti ageing</p>
            [full_description] => <p>Madagascar Centella Cream, an exceptional moisture-sealing cream, boasts a harmonious blend of squalene and Centella asiatica extract, working in synergy to cocoon the skin in a soothing hydration haven. Emanating certified brightening and anti-ageing prowess, it unveils a visage of clarity and elasticity. Amidst its velvety, lightweight texture lies a potent guardian, fending off external adversaries while nourishing and revitalising damaged skin. Its seamless glide is accompanied by a delightful natural aroma.</p>
<p>All orders will be dispatched in 8-9 days</p>
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [position] => 0
            [seo_name] => madagascar-centella-cream-30ml
            [seo_path] => 2685/2705/2811
            [average_rating] => 5.00
            [reviews_count] => 2
            [main_category] => 2811
            [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] => SKIN1004
            [ratting_count] => 2
        )

    [35812] => Array
        (
            [product_id] => 35812
            [product] => Skin Replenishing Rich Moisturiser - 125ml
            [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] => 27276
            [hsn_code] => 3304
            [status] => A
            [list_price] => 475.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1705649616
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 451.250000
            [short_description] => Hydration for 12 hours
            [full_description] => <p>Simple focuses on rejecting skin irritants and utilising ingredients that nourish and maintain your skin's equilibrium. Environmental factors like pollution, stress, and weather changes can trigger sensitivity. Replenishing rich facial moisturiser provides 24-hour hydration, rendering skin smooth and nourished. Infused with skin-friendly elements like Pro-Vitamin B5 and Bisabolol, it revitalises, soothes, and hydrates sans greasiness. Free from dyes, artificial fragrances, and harsh chemicals, it suits even sensitive skin. Dermatologist- and ophthalmologist-approved, hypoallergenic, and non-comedogenic Simple is the choice for expert, kind skincare.</p>
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [position] => 0
            [seo_name] => skin-replenishing-rich-moisturiser-125ml
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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] => Simple
        )

    [35813] => Array
        (
            [product_id] => 35813
            [product] => Skin Protecting Light Moisturiser - 125ml
            [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] => 27275
            [hsn_code] => 3304
            [status] => A
            [list_price] => 485.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1705649616
            [updated_timestamp] => 1750411725
            [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] => 461.000000
            [short_description] => Moisturises skin & nourishes skin
            [full_description] => <p>Simple's philosophy revolves around rejecting skin irritants and embracing ingredients that love and balance your skin. Sensitive skin can arise from pollution, stress, and various other factors, warranting extra care. Embrace the Simple approach with our Kind to Skin Protecting Light Moisturiser SPF 15. This essential addition to your SPF regimen hydrates for 12 hours while guarding against UVA and UVB rays. Suitable for sensitive skin, it's free from artificial colours, perfumes, and harsh chemicals. With Pro-vitamin B5, vitamin E, glycerin, allantoin, bisabol, and SPF 15, this staple follows your Simple cleanser, delivering moisturization, nourishment, and protection. A pathway to radiant, healthy skin.</p>
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [position] => 0
            [seo_name] => skin-protecting-light-moisturiser-125ml
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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] => Simple
        )

    [35820] => Array
        (
            [product_id] => 35820
            [product] => Water Boost Hydrating Gel Creme - 50gm
            [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] => SMPI100
            [hsn_code] => 3304
            [status] => A
            [list_price] => 499.00
            [amount] => 16
            [weight] => 50.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1705649616
            [updated_timestamp] => 1750414740
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => N
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 474.000000
            [short_description] => 
            [full_description] => <p>Simple water boost hydrating gel cream moisturiser, an oil-free gem, delivers 100-hour hydration with a lightweight touch, leaving skin velvety, supple, and revitalized throughout the day. Fit for all skin types, particularly dry and dehydrated, its non-greasy, swift-absorbing formulation suits oily skin as well, without clogging poresdeeply nourishing while maintaining a fresh feel. Packed with skin-loving elements, including 11% hydrating actives for natural hydration, Pentavitin for 2x faster skin reset, plant-based glycerin for replenishment, and Vitamin E for smoother, healthier skin. Enhanced with prebiotics to restore moisture and rejuvenate dry, damaged skin. Suitable for various skin types and genders.</p>
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [position] => 0
            [seo_name] => water-boost-hydrating-gel-creme-50gm
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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
                (
                    [1382] => Array
                        (
                            [video_id] => 1382
                            [video_type] => S
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1722882600
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 0
                            [community_url] => https://admin.kindlife.in/beat-the-heat-hydrate-with-ease
                            [community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1382_SaveInsta.App - 3400351472614108250_preview.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/video_library/1382_SaveInsta.App - 3400351472614108250.mp4
                            [community_last_sync_timestamp] => 0
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Beat the Heat, Hydrate with Ease
                            [description] => <p>Summer heat got your skin feeling sticky. Don't worry, we've got you covered! Check out these lightweight moisturizers that pack a hydration punch without the greasy feel. Say hello to fresh, dewy skin all summer long!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 1
                            [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
                                )

                        )

                    [1267] => Array
                        (
                            [video_id] => 1267
                            [video_type] => A
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1716316200
                            [status] => A
                            [user_id] => 210173
                            [extra_params] => 
                            [community_video_id] => 0
                            [community_url] => https://www.kindlife.in/simple-water-boost-hydrating-gel-creme
                            [community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1267_1000300034_preview.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/video_library/1267_1000300034.mp4
                            [community_last_sync_timestamp] => 0
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Unlock a Burst of Hydration
                            [description] => <p>Quench your skin’s thirst with Simple Water Boost Hydrating Gel Creme!&nbsp; Lightweight and refreshing, it provides instant hydration for a plump, dewy complexion. Perfect for all skin types, this gel creme keeps your skin feeling soft and smooth all day long.&nbsp;</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 0
                            [dislike_count] => 0
                            [comment_count] => 0
                            [meta_keywords] => 
                            [meta_description] => 
                            [page_title] => 
                            [tagged_brands] => 52656
                            [category_id] => 7
                            [link_type] => M
                            [preview] => Array
                                (
                                    [default_icon] => 1
                                )

                        )

                )

            [cp_has_video] => 1
            [brand_name] => Simple
        )

)


  1. Array
(
    [33694] => Array
        (
            [product_id] => 33694
            [product] => Madagascar Centella Cream 75 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] => BL01NRC00480002000
            [hsn_code] => 3304
            [status] => A
            [list_price] => 2299.00
            [amount] => 46
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1693230300
            [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] => 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] => 1609.300000
            [short_description] => <p>Hydrates skin & anti ageing</p>
            [full_description] => <p>Madagascar Centella Cream, an exceptional moisture-sealing cream, boasts a harmonious blend of squalene and Centella asiatica extract, working in synergy to cocoon the skin in a soothing hydration haven. Emanating certified brightening and anti-ageing prowess, it unveils a look of clarity and elasticity. Amidst its velvety, lightweight texture lies a potent guardian, fending off external adversaries while nourishing and revitalising damaged skin. Its seamless glide is accompanied by a delightful natural aroma.</p>
<p>All orders will be dispatched in 8-9 days</p>
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [position] => 0
            [seo_name] => madagascar-centella-cream-75ml
            [seo_path] => 2685/2705/2811
            [average_rating] => 5.00
            [reviews_count] => 1
            [main_category] => 2811
            [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] => SKIN1004
            [ratting_count] => 1
        )

    [28573] => Array
        (
            [product_id] => 28573
            [product] => Matcha & Chia Cleansing Cream - 110gm
            [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] => KITA001
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1950.00
            [amount] => 4
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1681715605
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 1852.500000
            [short_description] => <p>Moisturizes & revitalizes skin</p>
            [full_description] => <p>This facial cream uses antioxidant-rich superfoods such as ECOCERT-certified organic matcha directly from Kyoto, Japan to hydrate, replenish skin, and keep moisture locked in all day long. If youre tired of moisturizing creams that leave your skin feeling greasy or sticky, then this is the perfect facial cream for you. Their formula firms, moisturizes and revitalizes skin all without leaving behind a sticky residue. The quinoa and açai in this formula also help minimize free radical damage and even out skin complexion.</p>
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [position] => 0
            [seo_name] => matcha-and-chia-cleansing-cream-110gm
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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] => Kitao
        )

    [33233] => Array
        (
            [product_id] => 33233
            [product] => Avocado Body Milk - 001 - 300ml
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 605
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => AVBM001
            [hsn_code] => 3304
            [status] => A
            [list_price] => 299.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1692344935
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 284.050000
            [short_description] => Hydrates skin & repaire dryness
            [full_description] => <p>This luxurious body milk moisturizer works deep within the skin, helps in repairing dryness layer by layer stimulate moisture production naturally. This is much lighter so it quickly seeps into the skin. It’s time to hydrate thirsty skin with a replenishing dose of lightweight moisture. It come up with a fluid texture compared to body lotion while leaving skin smooth, glowy and supple.</p>
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [position] => 0
            [seo_name] => avocado-body-milk-001-300ml
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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] => Colorbar
        )

    [33695] => Array
        (
            [product_id] => 33695
            [product] =>  Madagascar Centella Cream 30ml
            [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] => BL01WAC00480005000
            [hsn_code] => 3304
            [status] => A
            [list_price] => 899.00
            [amount] => 7
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1693230300
            [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] => 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] => 629.300000
            [short_description] => <p>Hydrates skin & anti ageing</p>
            [full_description] => <p>Madagascar Centella Cream, an exceptional moisture-sealing cream, boasts a harmonious blend of squalene and Centella asiatica extract, working in synergy to cocoon the skin in a soothing hydration haven. Emanating certified brightening and anti-ageing prowess, it unveils a visage of clarity and elasticity. Amidst its velvety, lightweight texture lies a potent guardian, fending off external adversaries while nourishing and revitalising damaged skin. Its seamless glide is accompanied by a delightful natural aroma.</p>
<p>All orders will be dispatched in 8-9 days</p>
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [position] => 0
            [seo_name] => madagascar-centella-cream-30ml
            [seo_path] => 2685/2705/2811
            [average_rating] => 5.00
            [reviews_count] => 2
            [main_category] => 2811
            [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] => SKIN1004
            [ratting_count] => 2
        )

    [35812] => Array
        (
            [product_id] => 35812
            [product] => Skin Replenishing Rich Moisturiser - 125ml
            [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] => 27276
            [hsn_code] => 3304
            [status] => A
            [list_price] => 475.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1705649616
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 451.250000
            [short_description] => Hydration for 12 hours
            [full_description] => <p>Simple focuses on rejecting skin irritants and utilising ingredients that nourish and maintain your skin's equilibrium. Environmental factors like pollution, stress, and weather changes can trigger sensitivity. Replenishing rich facial moisturiser provides 24-hour hydration, rendering skin smooth and nourished. Infused with skin-friendly elements like Pro-Vitamin B5 and Bisabolol, it revitalises, soothes, and hydrates sans greasiness. Free from dyes, artificial fragrances, and harsh chemicals, it suits even sensitive skin. Dermatologist- and ophthalmologist-approved, hypoallergenic, and non-comedogenic Simple is the choice for expert, kind skincare.</p>
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [position] => 0
            [seo_name] => skin-replenishing-rich-moisturiser-125ml
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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] => Simple
        )

    [35813] => Array
        (
            [product_id] => 35813
            [product] => Skin Protecting Light Moisturiser - 125ml
            [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] => 27275
            [hsn_code] => 3304
            [status] => A
            [list_price] => 485.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1705649616
            [updated_timestamp] => 1750411725
            [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] => 461.000000
            [short_description] => Moisturises skin & nourishes skin
            [full_description] => <p>Simple's philosophy revolves around rejecting skin irritants and embracing ingredients that love and balance your skin. Sensitive skin can arise from pollution, stress, and various other factors, warranting extra care. Embrace the Simple approach with our Kind to Skin Protecting Light Moisturiser SPF 15. This essential addition to your SPF regimen hydrates for 12 hours while guarding against UVA and UVB rays. Suitable for sensitive skin, it's free from artificial colours, perfumes, and harsh chemicals. With Pro-vitamin B5, vitamin E, glycerin, allantoin, bisabol, and SPF 15, this staple follows your Simple cleanser, delivering moisturization, nourishment, and protection. A pathway to radiant, healthy skin.</p>
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [position] => 0
            [seo_name] => skin-protecting-light-moisturiser-125ml
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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] => Simple
        )

    [35820] => Array
        (
            [product_id] => 35820
            [product] => Water Boost Hydrating Gel Creme - 50gm
            [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] => SMPI100
            [hsn_code] => 3304
            [status] => A
            [list_price] => 499.00
            [amount] => 16
            [weight] => 50.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1705649616
            [updated_timestamp] => 1750414740
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => N
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 474.000000
            [short_description] => 
            [full_description] => <p>Simple water boost hydrating gel cream moisturiser, an oil-free gem, delivers 100-hour hydration with a lightweight touch, leaving skin velvety, supple, and revitalized throughout the day. Fit for all skin types, particularly dry and dehydrated, its non-greasy, swift-absorbing formulation suits oily skin as well, without clogging poresdeeply nourishing while maintaining a fresh feel. Packed with skin-loving elements, including 11% hydrating actives for natural hydration, Pentavitin for 2x faster skin reset, plant-based glycerin for replenishment, and Vitamin E for smoother, healthier skin. Enhanced with prebiotics to restore moisture and rejuvenate dry, damaged skin. Suitable for various skin types and genders.</p>
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [position] => 0
            [seo_name] => water-boost-hydrating-gel-creme-50gm
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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
                (
                    [1382] => Array
                        (
                            [video_id] => 1382
                            [video_type] => S
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1722882600
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 0
                            [community_url] => https://admin.kindlife.in/beat-the-heat-hydrate-with-ease
                            [community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1382_SaveInsta.App - 3400351472614108250_preview.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/video_library/1382_SaveInsta.App - 3400351472614108250.mp4
                            [community_last_sync_timestamp] => 0
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Beat the Heat, Hydrate with Ease
                            [description] => <p>Summer heat got your skin feeling sticky. Don't worry, we've got you covered! Check out these lightweight moisturizers that pack a hydration punch without the greasy feel. Say hello to fresh, dewy skin all summer long!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 1
                            [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
                                )

                        )

                    [1267] => Array
                        (
                            [video_id] => 1267
                            [video_type] => A
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1716316200
                            [status] => A
                            [user_id] => 210173
                            [extra_params] => 
                            [community_video_id] => 0
                            [community_url] => https://www.kindlife.in/simple-water-boost-hydrating-gel-creme
                            [community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1267_1000300034_preview.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/video_library/1267_1000300034.mp4
                            [community_last_sync_timestamp] => 0
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Unlock a Burst of Hydration
                            [description] => <p>Quench your skin’s thirst with Simple Water Boost Hydrating Gel Creme!&nbsp; Lightweight and refreshing, it provides instant hydration for a plump, dewy complexion. Perfect for all skin types, this gel creme keeps your skin feeling soft and smooth all day long.&nbsp;</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 0
                            [dislike_count] => 0
                            [comment_count] => 0
                            [meta_keywords] => 
                            [meta_description] => 
                            [page_title] => 
                            [tagged_brands] => 52656
                            [category_id] => 7
                            [link_type] => M
                            [preview] => Array
                                (
                                    [default_icon] => 1
                                )

                        )

                )

            [cp_has_video] => 1
            [brand_name] => Simple
        )

)


  2. end of fxn

  1. Array
(
    [show_master_products_only] => 
    [area] => C
    [for_required_product] => 33694
    [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 = 33694 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] => 28573
    [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 = 28573 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] => 33233
    [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 = 33233 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] => 33695
    [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 = 33695 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] => 35812
    [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 = 35812 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] => 35813
    [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 = 35813 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] => 35820
    [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 = 35820 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
Cream moisturisers:Moisturisers:Skin 
  1. Array
(
    [show_master_products_only] => 
    [area] => C
    [check_location] => 1
    [process_empty_items] => 1
    [dispatch] => categories.view
    [category_id] => 2811
    [features_hash] => 28-44657
    [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] => 2811
    [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] => 2811
    [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] => 2811
    [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

Cream moisturisers

Filters

Filters
Brand
Price

$  –  $

  • ‎$2
  • ‎$117
Categories
Kind Code
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+

Cream moisturisers

  • Skin Damage
Filters
Bestselling
7 Products Found 
  1. Array
(
    [show_master_products_only] => 
    [area] => A
    [extend] => Array
        (
            [0] => product_name
        )

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

    [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 (33694)) 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
(
    [33694] => Array
        (
            [product_id] => 33694
            [product] => Madagascar Centella Cream 75 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] => BL01NRC00480002000
            [hsn_code] => 3304
            [status] => A
            [list_price] => 2299.00
            [amount] => 46
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1693230300
            [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] => 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] => 1609.300000
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [seo_name] => madagascar-centella-cream-75ml
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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] => SKIN1004
        )

)


  1. Array
(
    [33694] => Array
        (
            [product_id] => 33694
            [product] => Madagascar Centella Cream 75 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] => BL01NRC00480002000
            [hsn_code] => 3304
            [status] => A
            [list_price] => 2299.00
            [amount] => 46
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1693230300
            [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] => 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] => 1609.300000
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [seo_name] => madagascar-centella-cream-75ml
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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] => SKIN1004
        )

)


  2. end of fxn

                


    
    
        
            SKIN1004: Madagascar Centella Cream 75 ml

        

            





                                        
                                
            

            
                                    

                        
    


    

        
                
                    
        

        
                    
                    
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            

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

                                                                                                                                                            
        

                                    SKIN1004
        


        

            

                                
    
            Madagascar Centella Cream 75 ml    


            


            
            

                                
            
    


            


            

                                
            


                            

                            
            



                            

        

        

        

                            


	            	                	                 

    
        
        
                                
                                    $24.76
                            

                        

	            	            
	            	            	                           
            

            
            

                            $35.37
                        

            

        
    
	            
            
	            	                
	            
	            	                
                                                                                                                                                        

	                    30%
	                

                                

                                        

                        
                        

     

                                
                                
            
            

                                    5.0

            
    



    


                 (1)                 

                                                            
            

                

                                                        
                        
 
                                                        
                            
					        
                        

                                                                    
                

                    
                    
                    
                                                                    









        
                
 

        
        
    

    





    
            
    
 
    


    
                            
                                
        
 
    








                                    

            

        

        

    

    
        







                                
                        

    
    
    
    


































        

                                        

                    
                

            
                        

 





            
        
        

            


            

                                                                                    

                                            

            

                                                                                
                                                                                                        

                        
            

            
                                    
                        
                                        

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

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

    [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 (28573)) 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
(
    [28573] => Array
        (
            [product_id] => 28573
            [product] => Matcha & Chia Cleansing Cream - 110gm
            [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] => KITA001
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1950.00
            [amount] => 4
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1681715605
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 1852.500000
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [seo_name] => matcha-and-chia-cleansing-cream-110gm
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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] => Kitao
        )

)


  1. Array
(
    [28573] => Array
        (
            [product_id] => 28573
            [product] => Matcha & Chia Cleansing Cream - 110gm
            [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] => KITA001
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1950.00
            [amount] => 4
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1681715605
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 1852.500000
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [seo_name] => matcha-and-chia-cleansing-cream-110gm
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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] => Kitao
        )

)


  2. end of fxn

                


    
    
        
            Kitao: Matcha & Chia Cleansing Cream - 110gm

        

            





                                        
                                
            

            
                                    

                        
    


    

        
                
                    
        

        
                    
                                        
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            

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

                                                                                                                                        
        

                                    Kitao
        


        

            

                                
    
            Matcha & Chia Cleansing Cream - 110gm    


            


            
            

                                
            

            
            



    
Good For: 
    Skin Damage  

        

    


            


            

                                
            


                            

                            
            



                            

        

        

        

                            


	            	                	                 

    
        
        
                                
                                    $28.50
                            

                        

	            	            
	            	            	                           
            

            
            

                            $30.00
                        

            

        
    
	            
            
	            	                
	            
	            	                
                                                                                                                                                        

	                    5%
	                

                                

                                        

                        
                        

     



    


                                

                                                            
            

                

                                                        
                        
 
                                                        
                            
					        
                        

                                                                    
                

                    
                    
                    
                                                                    









        
                
 

        
        
    

    





    
            
    
 
    


    
                            
                                
        
 
    








                                    

            

        

        

    

    
        







                                
                        

    
    
    
    


































        

                        
                        

 





            
        
        

            


            

                                                                                    

                                            

            

                                                                                
                                                                                                        

                        
            

            
                                    
                        
                                        

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

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

    [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 (33233)) 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
(
    [33233] => Array
        (
            [product_id] => 33233
            [product] => Avocado Body Milk - 001 - 300ml
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 605
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => AVBM001
            [hsn_code] => 3304
            [status] => A
            [list_price] => 299.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1692344935
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 284.050000
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [seo_name] => avocado-body-milk-001-300ml
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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] => Colorbar
        )

)


  1. Array
(
    [33233] => Array
        (
            [product_id] => 33233
            [product] => Avocado Body Milk - 001 - 300ml
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 605
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => AVBM001
            [hsn_code] => 3304
            [status] => A
            [list_price] => 299.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1692344935
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 284.050000
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [seo_name] => avocado-body-milk-001-300ml
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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] => Colorbar
        )

)


  2. end of fxn

                


    
    
        
            Colorbar: Avocado Body Milk - 001 - 300ml

        

            





                                        
                                
            

            
                                    

                        
    


    

        
                
                    
        

        
                    
                                                            
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
        

                                    Colorbar
        


        

            

                                
    
            Avocado Body Milk - 001 - 300ml    


            


            
            

                                
            
    


            


            

                                
            


                            

                            
            



                            

        

        

        

                                        

                        
                        

     



    


                                

                                                            
            

                

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

    [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 (33695)) 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
(
    [33695] => Array
        (
            [product_id] => 33695
            [product] =>  Madagascar Centella Cream 30ml
            [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] => BL01WAC00480005000
            [hsn_code] => 3304
            [status] => A
            [list_price] => 899.00
            [amount] => 7
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1693230300
            [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] => 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] => 629.300000
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [seo_name] => madagascar-centella-cream-30ml
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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] => SKIN1004
        )

)


  1. Array
(
    [33695] => Array
        (
            [product_id] => 33695
            [product] =>  Madagascar Centella Cream 30ml
            [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] => BL01WAC00480005000
            [hsn_code] => 3304
            [status] => A
            [list_price] => 899.00
            [amount] => 7
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1693230300
            [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] => 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] => 629.300000
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [seo_name] => madagascar-centella-cream-30ml
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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] => SKIN1004
        )

)


  2. end of fxn

                


    
    
        
            SKIN1004:  Madagascar Centella Cream 30ml

        

            





                                        
                                
            

            
                                    

                        
    


    

        
                
                    
        

        
                    
                                                                                
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            

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

                                                                                                
        

                                    SKIN1004
        


        

            

                                
    
             Madagascar Centella Cream 30ml    


            


            
            

                                
            
    


            


            

                                
            


                            

                            
            



                            

        

        

        

                            


	            	                	                 

    
        
        
                                
                                    $9.68
                            

                        

	            	            
	            	            	                           
            

            
            

                            $13.83
                        

            

        
    
	            
            
	            	                
	            
	            	                
                                                                                                                                                        

	                    30%
	                

                                

                                        

                        
                        

     

                                
                                
            
            

                                    5.0

            
    



    


                 (2)                 

                                                            
            

                

                                                        
                        
 
                                                        
                            
					        
                        

                                                                    
                

                    
                    
                    
                                                                    









        
                
 

        
        
    

    





    
            
    
 
    


    
                            
                                
        
 
    








                                    

            

        

        

    

    
        







                                
                        

    
    
    
    


































        

                                        

                    
                

            
                        

 





            
        
        

            


            

                                                                                    

                                            

            

                                                                                
                                                                                                        

                        
            

            
                                    
                        
                                        

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

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

    [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 (35812)) 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
(
    [35812] => Array
        (
            [product_id] => 35812
            [product] => Skin Replenishing Rich Moisturiser - 125ml
            [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] => 27276
            [hsn_code] => 3304
            [status] => A
            [list_price] => 475.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1705649616
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 451.250000
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [seo_name] => skin-replenishing-rich-moisturiser-125ml
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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] => Simple
        )

)


  1. Array
(
    [35812] => Array
        (
            [product_id] => 35812
            [product] => Skin Replenishing Rich Moisturiser - 125ml
            [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] => 27276
            [hsn_code] => 3304
            [status] => A
            [list_price] => 475.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1705649616
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 451.250000
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [seo_name] => skin-replenishing-rich-moisturiser-125ml
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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] => Simple
        )

)


  2. end of fxn

                


    
    
        
            Simple: Skin Replenishing Rich Moisturiser - 125ml

        

            





                                        
                                
            

            
                                    

                        
    


    

        
                
                    
        

        
                    
                                                                                                    
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
        

                                    Simple
        


        

            

                                
    
            Skin Replenishing Rich Moisturiser - 125ml    


            


            
            

                                
            
    


            


            

                                
            


                            

                            
            



                            

        

        

        

                                        

                        
                        

     



    


                                

                                                            
            

                

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

    [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 (35813)) 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
(
    [35813] => Array
        (
            [product_id] => 35813
            [product] => Skin Protecting Light Moisturiser - 125ml
            [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] => 27275
            [hsn_code] => 3304
            [status] => A
            [list_price] => 485.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1705649616
            [updated_timestamp] => 1750411725
            [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] => 461.000000
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [seo_name] => skin-protecting-light-moisturiser-125ml
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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] => Simple
        )

)


  1. Array
(
    [35813] => Array
        (
            [product_id] => 35813
            [product] => Skin Protecting Light Moisturiser - 125ml
            [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] => 27275
            [hsn_code] => 3304
            [status] => A
            [list_price] => 485.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1705649616
            [updated_timestamp] => 1750411725
            [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] => 461.000000
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [seo_name] => skin-protecting-light-moisturiser-125ml
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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] => Simple
        )

)


  2. end of fxn

                


    
    
        
            Simple: Skin Protecting Light Moisturiser - 125ml

        

            





                                        
                                
            

            
                                    

                        
    


    

        
                
                    
        

        
                    
                                                                                                                        
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
        

                                    Simple
        


        

            

                                
    
            Skin Protecting Light Moisturiser - 125ml    


            


            
            

                                
            
    


            


            

                                
            


                            

                            
            



                            

        

        

        

                                        

                        
                        

     



    


                                

                                                            
            

                

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

    [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 (35820)) 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
(
    [35820] => Array
        (
            [product_id] => 35820
            [product] => Water Boost Hydrating Gel Creme - 50gm
            [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] => SMPI100
            [hsn_code] => 3304
            [status] => A
            [list_price] => 499.00
            [amount] => 16
            [weight] => 50.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1705649616
            [updated_timestamp] => 1750414740
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => N
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 474.000000
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [seo_name] => water-boost-hydrating-gel-creme-50gm
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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
                (
                    [1382] => Array
                        (
                            [video_id] => 1382
                            [video_type] => S
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1722882600
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 0
                            [community_url] => https://admin.kindlife.in/beat-the-heat-hydrate-with-ease
                            [community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1382_SaveInsta.App - 3400351472614108250_preview.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/video_library/1382_SaveInsta.App - 3400351472614108250.mp4
                            [community_last_sync_timestamp] => 0
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Beat the Heat, Hydrate with Ease
                            [description] => <p>Summer heat got your skin feeling sticky. Don't worry, we've got you covered! Check out these lightweight moisturizers that pack a hydration punch without the greasy feel. Say hello to fresh, dewy skin all summer long!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 1
                            [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
                                )

                        )

                    [1267] => Array
                        (
                            [video_id] => 1267
                            [video_type] => A
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1716316200
                            [status] => A
                            [user_id] => 210173
                            [extra_params] => 
                            [community_video_id] => 0
                            [community_url] => https://www.kindlife.in/simple-water-boost-hydrating-gel-creme
                            [community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1267_1000300034_preview.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/video_library/1267_1000300034.mp4
                            [community_last_sync_timestamp] => 0
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Unlock a Burst of Hydration
                            [description] => <p>Quench your skin’s thirst with Simple Water Boost Hydrating Gel Creme!&nbsp; Lightweight and refreshing, it provides instant hydration for a plump, dewy complexion. Perfect for all skin types, this gel creme keeps your skin feeling soft and smooth all day long.&nbsp;</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 0
                            [dislike_count] => 0
                            [comment_count] => 0
                            [meta_keywords] => 
                            [meta_description] => 
                            [page_title] => 
                            [tagged_brands] => 52656
                            [category_id] => 7
                            [link_type] => M
                            [preview] => Array
                                (
                                    [default_icon] => 1
                                )

                        )

                )

            [cp_has_video] => 1
            [brand_name] => Simple
        )

)


  1. Array
(
    [35820] => Array
        (
            [product_id] => 35820
            [product] => Water Boost Hydrating Gel Creme - 50gm
            [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] => SMPI100
            [hsn_code] => 3304
            [status] => A
            [list_price] => 499.00
            [amount] => 16
            [weight] => 50.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1705649616
            [updated_timestamp] => 1750414740
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => N
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 474.000000
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [seo_name] => water-boost-hydrating-gel-creme-50gm
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [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
                (
                    [1382] => Array
                        (
                            [video_id] => 1382
                            [video_type] => S
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1722882600
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 0
                            [community_url] => https://admin.kindlife.in/beat-the-heat-hydrate-with-ease
                            [community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1382_SaveInsta.App - 3400351472614108250_preview.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/video_library/1382_SaveInsta.App - 3400351472614108250.mp4
                            [community_last_sync_timestamp] => 0
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Beat the Heat, Hydrate with Ease
                            [description] => <p>Summer heat got your skin feeling sticky. Don't worry, we've got you covered! Check out these lightweight moisturizers that pack a hydration punch without the greasy feel. Say hello to fresh, dewy skin all summer long!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 1
                            [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
                                )

                        )

                    [1267] => Array
                        (
                            [video_id] => 1267
                            [video_type] => A
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1716316200
                            [status] => A
                            [user_id] => 210173
                            [extra_params] => 
                            [community_video_id] => 0
                            [community_url] => https://www.kindlife.in/simple-water-boost-hydrating-gel-creme
                            [community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1267_1000300034_preview.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/video_library/1267_1000300034.mp4
                            [community_last_sync_timestamp] => 0
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Unlock a Burst of Hydration
                            [description] => <p>Quench your skin’s thirst with Simple Water Boost Hydrating Gel Creme!&nbsp; Lightweight and refreshing, it provides instant hydration for a plump, dewy complexion. Perfect for all skin types, this gel creme keeps your skin feeling soft and smooth all day long.&nbsp;</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 0
                            [dislike_count] => 0
                            [comment_count] => 0
                            [meta_keywords] => 
                            [meta_description] => 
                            [page_title] => 
                            [tagged_brands] => 52656
                            [category_id] => 7
                            [link_type] => M
                            [preview] => Array
                                (
                                    [default_icon] => 1
                                )

                        )

                )

            [cp_has_video] => 1
            [brand_name] => Simple
        )

)


  2. end of fxn

                


    
    
        
            Simple: Water Boost Hydrating Gel Creme - 50gm

        

            





                                        
                                
            

            
                                    

                        
    


    

        
                
                    
        

        
                    
                                                                                                                                            
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            

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

                                    
        

                                    Simple
        


        

            

                                
    
            Water Boost Hydrating Gel Creme - 50gm    


            


            
            

                                
            
    


            


            

                                
            


                            

                            
            



                            

        

        

        

                            


	            	                	                 

    
        
        
                                
                                    $7.29
                            

                        

	            	            
	            	            	                           
            

            
            

                            $7.68
                        

            

        
    
	            
            
	            	                
	            
	            	                
                                                                                                                                                        

	                    5%
	                

                                

                                        

                        
                        

     



    


                                

                                                            
            

                

                                                        
                        
 
                                                        
                            
					        
                        

                                                                    
                

                    
                    
                    
                                                                    









        
                
 

        
        
    

    





    
            
    
 
    


    
                            
                                
        
 
    








                                    

            

        

        

    

    
        










    




    0 Items selected
    
        Move to Collection
    






    










            


    

    
    

























    

                            

        
                                        
            
                        

                                    






                            

        
    
        

    









            

        


        

        


        



            
    
    

    
    
    
    
    
    
    
    
    















































































































                    























    
    

    

        
                
        

        

            

            Ctrl+Alt+D - show/hide toolbar
        

        

        
    
            
  • Page generating time 1.4947 s
    • 
            
  • Memory usage 17 089.82 KB
    • 
                    

        

    

    
    

        

            
Server

            ✖
        

        

        

    


    
    

        

            
Request

            ✖
        

        

        

    


    
    

        

            
Config

            ✖
        

        

        

    


    
    

        

            
SQL

            ✖
        

        

        

    


    
    

        

            
Cache queries

            ✖
        

        

        

    


    
    

        

            
Logging

            ✖
        

        

        

    


    
    

        

            
Templates

            ✖
        

        

        

    


    
    

        

            
Blocks

            ✖