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

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


  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 (50284)) AND ?:categories.category_id IN (2813) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.parent_product_id = 0 AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 12

  1. before end of oxn

  2. Array
(
    [35494] => Array
        (
            [product_id] => 35494
            [product] => 
            [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] => 1200172
            [hsn_code] => 3304
            [status] => A
            [list_price] => 0.00
            [amount] => 6
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1702381915
            [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] => 0
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 0.000000
            [short_description] => 72 Hours Moisturisation
            [full_description] => <p>A rich and nourishing blend for deep moisturisation, this cream is all you need to revitalise dry and dehydrated skin. Infused with Ceramide Complex, Shea Butter, and Cactus Extracts, this non-greasy moisturiser makes the skin soft and smooth.<br />This non-sticky formula gets absorbed into your skin quickly and offers up to 72 hours of moisturization effortlessly. A must-have for normal to dry skin, Hello Hydration Barrier Boost Cream Moisturiser protects and restores the skin barrier.</p>
            [category_ids] => Array
                (
                    [0] => 2813
                )

            [position] => 0
            [seo_name] => hello-hydration-barrier-restore-cream-moisturizer-for-normal-to-dry-skin
            [seo_path] => 2685/2708/2813
            [average_rating] => 5.00
            [reviews_count] => 1
            [main_category] => 2813
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 0
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                    [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
                                )

                        )

                    [1039] => Array
                        (
                            [video_id] => 1039
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1707849000
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 1065
                            [community_url] => https://www.kindlife.in/10-step-beauty-routines
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1065/72de810e5a44e5fc3a7421f35338a4be.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1065/72de810e5a44e5fc3a7421f35338a4be.mp4
                            [community_last_sync_timestamp] => 1707913493
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Ditch 10 steps beauty routine and Grab this magic product instead!
                            [description] => <p><span style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">In a world obsessed with skincare hacks, TikTok trends, and those 10-step beauty routines, something’s here to flip the script on how you see beauty and skincare???</span></p>
<p>Buckle up, buttercups, because Kindlife just dropped a new brand that's gonna blow your FACE OFF (in the best way possible). We're talking about Within Skincare – a line so good, it's borderline illegal.   We're talking next-level ingredients, textures that'll make your angels sing, and results that'll have you questioning reality.  Is this sorcery? Maybe.  Is it life-changing? Absolutely.  Join us as we dive deep into Within and unleash the glow you never knew existed! <br style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br></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
                                )

                        )

                )

            [cp_has_video] => 1
            [brand_name] => Divyasatva
            [ratting_count] => 1
        )

    [35495] => Array
        (
            [product_id] => 35495
            [product] => 
            [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] => 1200173
            [hsn_code] => 3304
            [status] => A
            [list_price] => 0.00
            [amount] => 4
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1702381915
            [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] => 0
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 0.000000
            [short_description] => <p>72 Hours Moisturisation</p>
            [full_description] => <p>Light on the skin but heavy on moisturization, the Daily Dew Barrier Restore Gel Moisturizer is all you need for your skins daily dose of nourishment. Loaded with skin-loving ingredients such as Ceramide Complex, Hyaluronic Acid, and Sea Alage it keeps the skin moisturized for 72 hours.<br />This non-sticky and non-greasy blend is perfect for oily and sensitive skin. It helps achieve brighter and even-toned skin by protecting and restoring the skin barrier. This gel moisturizer sinks into the skin quickly to leave it soft, smooth, and plump in no time.</p>
            [category_ids] => Array
                (
                    [0] => 2813
                )

            [position] => 0
            [seo_name] => daily-dew-barrier-restore-gel-moisturizer-for-oily-and-sensitive-skin
            [seo_path] => 2685/2708/2813
            [main_category] => 2813
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 0
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                )

            [brand_name] => Divyasatva
        )

)


  1. Array
(
    [35494] => Array
        (
            [product_id] => 35494
            [product] => 
            [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] => 1200172
            [hsn_code] => 3304
            [status] => A
            [list_price] => 0.00
            [amount] => 6
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1702381915
            [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] => 0
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 0.000000
            [short_description] => 72 Hours Moisturisation
            [full_description] => <p>A rich and nourishing blend for deep moisturisation, this cream is all you need to revitalise dry and dehydrated skin. Infused with Ceramide Complex, Shea Butter, and Cactus Extracts, this non-greasy moisturiser makes the skin soft and smooth.<br />This non-sticky formula gets absorbed into your skin quickly and offers up to 72 hours of moisturization effortlessly. A must-have for normal to dry skin, Hello Hydration Barrier Boost Cream Moisturiser protects and restores the skin barrier.</p>
            [category_ids] => Array
                (
                    [0] => 2813
                )

            [position] => 0
            [seo_name] => hello-hydration-barrier-restore-cream-moisturizer-for-normal-to-dry-skin
            [seo_path] => 2685/2708/2813
            [average_rating] => 5.00
            [reviews_count] => 1
            [main_category] => 2813
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 0
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                    [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
                                )

                        )

                    [1039] => Array
                        (
                            [video_id] => 1039
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1707849000
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 1065
                            [community_url] => https://www.kindlife.in/10-step-beauty-routines
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1065/72de810e5a44e5fc3a7421f35338a4be.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1065/72de810e5a44e5fc3a7421f35338a4be.mp4
                            [community_last_sync_timestamp] => 1707913493
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Ditch 10 steps beauty routine and Grab this magic product instead!
                            [description] => <p><span style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">In a world obsessed with skincare hacks, TikTok trends, and those 10-step beauty routines, something’s here to flip the script on how you see beauty and skincare???</span></p>
<p>Buckle up, buttercups, because Kindlife just dropped a new brand that's gonna blow your FACE OFF (in the best way possible). We're talking about Within Skincare – a line so good, it's borderline illegal.   We're talking next-level ingredients, textures that'll make your angels sing, and results that'll have you questioning reality.  Is this sorcery? Maybe.  Is it life-changing? Absolutely.  Join us as we dive deep into Within and unleash the glow you never knew existed! <br style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br></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
                                )

                        )

                )

            [cp_has_video] => 1
            [brand_name] => Divyasatva
            [ratting_count] => 1
        )

    [35495] => Array
        (
            [product_id] => 35495
            [product] => 
            [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] => 1200173
            [hsn_code] => 3304
            [status] => A
            [list_price] => 0.00
            [amount] => 4
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1702381915
            [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] => 0
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 0.000000
            [short_description] => <p>72 Hours Moisturisation</p>
            [full_description] => <p>Light on the skin but heavy on moisturization, the Daily Dew Barrier Restore Gel Moisturizer is all you need for your skins daily dose of nourishment. Loaded with skin-loving ingredients such as Ceramide Complex, Hyaluronic Acid, and Sea Alage it keeps the skin moisturized for 72 hours.<br />This non-sticky and non-greasy blend is perfect for oily and sensitive skin. It helps achieve brighter and even-toned skin by protecting and restoring the skin barrier. This gel moisturizer sinks into the skin quickly to leave it soft, smooth, and plump in no time.</p>
            [category_ids] => Array
                (
                    [0] => 2813
                )

            [position] => 0
            [seo_name] => daily-dew-barrier-restore-gel-moisturizer-for-oily-and-sensitive-skin
            [seo_path] => 2685/2708/2813
            [main_category] => 2813
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 0
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                )

            [brand_name] => Divyasatva
        )

)


  2. end of fxn

  1. Array
(
    [show_master_products_only] => 
    [area] => C
    [pid] => 35494
    [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 (35494)) 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] => 35494
    [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 (35494)) 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
(
    [35494] => Array
        (
            [product_id] => 35494
            [product] => 
            [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
                                )

                        )

                    [1039] => Array
                        (
                            [video_id] => 1039
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1707849000
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 1065
                            [community_url] => https://www.kindlife.in/10-step-beauty-routines
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1065/72de810e5a44e5fc3a7421f35338a4be.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1065/72de810e5a44e5fc3a7421f35338a4be.mp4
                            [community_last_sync_timestamp] => 1707913493
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Ditch 10 steps beauty routine and Grab this magic product instead!
                            [description] => <p><span style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">In a world obsessed with skincare hacks, TikTok trends, and those 10-step beauty routines, something’s here to flip the script on how you see beauty and skincare???</span></p>
<p>Buckle up, buttercups, because Kindlife just dropped a new brand that's gonna blow your FACE OFF (in the best way possible). We're talking about Within Skincare – a line so good, it's borderline illegal.   We're talking next-level ingredients, textures that'll make your angels sing, and results that'll have you questioning reality.  Is this sorcery? Maybe.  Is it life-changing? Absolutely.  Join us as we dive deep into Within and unleash the glow you never knew existed! <br style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br></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
                                )

                        )

                )

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

)


  1. Array
(
    [35494] => Array
        (
            [product_id] => 35494
            [product] => 
            [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
                                )

                        )

                    [1039] => Array
                        (
                            [video_id] => 1039
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1707849000
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 1065
                            [community_url] => https://www.kindlife.in/10-step-beauty-routines
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1065/72de810e5a44e5fc3a7421f35338a4be.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1065/72de810e5a44e5fc3a7421f35338a4be.mp4
                            [community_last_sync_timestamp] => 1707913493
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Ditch 10 steps beauty routine and Grab this magic product instead!
                            [description] => <p><span style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">In a world obsessed with skincare hacks, TikTok trends, and those 10-step beauty routines, something’s here to flip the script on how you see beauty and skincare???</span></p>
<p>Buckle up, buttercups, because Kindlife just dropped a new brand that's gonna blow your FACE OFF (in the best way possible). We're talking about Within Skincare – a line so good, it's borderline illegal.   We're talking next-level ingredients, textures that'll make your angels sing, and results that'll have you questioning reality.  Is this sorcery? Maybe.  Is it life-changing? Absolutely.  Join us as we dive deep into Within and unleash the glow you never knew existed! <br style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br></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
                                )

                        )

                )

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

)


  2. end of fxn

  1. Array
(
    [show_master_products_only] => 
    [area] => C
    [pid] => 35494
    [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 (35494)) 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] => 35494
    [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 (35494)) 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
    [features_hash] => 28-50284
    [items_per_page] => 12
    [sl] => en
    [dispatch] => categories.view
    [category_id] => 2813
    [save_view_results] => product_id
    [sort_by] => bestsellers
    [sort_order] => desc
    [cid] => 2813
    [extend] => Array
        (
            [0] => categories
            [1] => description
            [2] => description
            [3] => full_description
        )

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


  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 (50284)) AND ?:categories.category_id IN (2813) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.parent_product_id = 0 AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 12

  1. before end of oxn

  2. Array
(
    [35494] => Array
        (
            [product_id] => 35494
            [product] => 
            [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] => 1200172
            [hsn_code] => 3304
            [status] => A
            [list_price] => 0.00
            [amount] => 6
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1702381915
            [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] => 0
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 0.000000
            [short_description] => 72 Hours Moisturisation
            [full_description] => <p>A rich and nourishing blend for deep moisturisation, this cream is all you need to revitalise dry and dehydrated skin. Infused with Ceramide Complex, Shea Butter, and Cactus Extracts, this non-greasy moisturiser makes the skin soft and smooth.<br />This non-sticky formula gets absorbed into your skin quickly and offers up to 72 hours of moisturization effortlessly. A must-have for normal to dry skin, Hello Hydration Barrier Boost Cream Moisturiser protects and restores the skin barrier.</p>
            [category_ids] => Array
                (
                    [0] => 2813
                )

            [position] => 0
            [seo_name] => hello-hydration-barrier-restore-cream-moisturizer-for-normal-to-dry-skin
            [seo_path] => 2685/2708/2813
            [average_rating] => 5.00
            [reviews_count] => 1
            [main_category] => 2813
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 0
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                    [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
                                )

                        )

                    [1039] => Array
                        (
                            [video_id] => 1039
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1707849000
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 1065
                            [community_url] => https://www.kindlife.in/10-step-beauty-routines
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1065/72de810e5a44e5fc3a7421f35338a4be.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1065/72de810e5a44e5fc3a7421f35338a4be.mp4
                            [community_last_sync_timestamp] => 1707913493
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Ditch 10 steps beauty routine and Grab this magic product instead!
                            [description] => <p><span style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">In a world obsessed with skincare hacks, TikTok trends, and those 10-step beauty routines, something’s here to flip the script on how you see beauty and skincare???</span></p>
<p>Buckle up, buttercups, because Kindlife just dropped a new brand that's gonna blow your FACE OFF (in the best way possible). We're talking about Within Skincare – a line so good, it's borderline illegal.   We're talking next-level ingredients, textures that'll make your angels sing, and results that'll have you questioning reality.  Is this sorcery? Maybe.  Is it life-changing? Absolutely.  Join us as we dive deep into Within and unleash the glow you never knew existed! <br style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br></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
                                )

                        )

                )

            [cp_has_video] => 1
            [brand_name] => Divyasatva
            [ratting_count] => 1
        )

    [35495] => Array
        (
            [product_id] => 35495
            [product] => 
            [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] => 1200173
            [hsn_code] => 3304
            [status] => A
            [list_price] => 0.00
            [amount] => 4
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1702381915
            [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] => 0
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 0.000000
            [short_description] => <p>72 Hours Moisturisation</p>
            [full_description] => <p>Light on the skin but heavy on moisturization, the Daily Dew Barrier Restore Gel Moisturizer is all you need for your skins daily dose of nourishment. Loaded with skin-loving ingredients such as Ceramide Complex, Hyaluronic Acid, and Sea Alage it keeps the skin moisturized for 72 hours.<br />This non-sticky and non-greasy blend is perfect for oily and sensitive skin. It helps achieve brighter and even-toned skin by protecting and restoring the skin barrier. This gel moisturizer sinks into the skin quickly to leave it soft, smooth, and plump in no time.</p>
            [category_ids] => Array
                (
                    [0] => 2813
                )

            [position] => 0
            [seo_name] => daily-dew-barrier-restore-gel-moisturizer-for-oily-and-sensitive-skin
            [seo_path] => 2685/2708/2813
            [main_category] => 2813
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 0
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                )

            [brand_name] => Divyasatva
        )

)


  1. Array
(
    [35494] => Array
        (
            [product_id] => 35494
            [product] => 
            [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] => 1200172
            [hsn_code] => 3304
            [status] => A
            [list_price] => 0.00
            [amount] => 6
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1702381915
            [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] => 0
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 0.000000
            [short_description] => 72 Hours Moisturisation
            [full_description] => <p>A rich and nourishing blend for deep moisturisation, this cream is all you need to revitalise dry and dehydrated skin. Infused with Ceramide Complex, Shea Butter, and Cactus Extracts, this non-greasy moisturiser makes the skin soft and smooth.<br />This non-sticky formula gets absorbed into your skin quickly and offers up to 72 hours of moisturization effortlessly. A must-have for normal to dry skin, Hello Hydration Barrier Boost Cream Moisturiser protects and restores the skin barrier.</p>
            [category_ids] => Array
                (
                    [0] => 2813
                )

            [position] => 0
            [seo_name] => hello-hydration-barrier-restore-cream-moisturizer-for-normal-to-dry-skin
            [seo_path] => 2685/2708/2813
            [average_rating] => 5.00
            [reviews_count] => 1
            [main_category] => 2813
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 0
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                    [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
                                )

                        )

                    [1039] => Array
                        (
                            [video_id] => 1039
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1707849000
                            [status] => A
                            [user_id] => 21551
                            [extra_params] => 
                            [community_video_id] => 1065
                            [community_url] => https://www.kindlife.in/10-step-beauty-routines
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1065/72de810e5a44e5fc3a7421f35338a4be.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1065/72de810e5a44e5fc3a7421f35338a4be.mp4
                            [community_last_sync_timestamp] => 1707913493
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Ditch 10 steps beauty routine and Grab this magic product instead!
                            [description] => <p><span style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">In a world obsessed with skincare hacks, TikTok trends, and those 10-step beauty routines, something’s here to flip the script on how you see beauty and skincare???</span></p>
<p>Buckle up, buttercups, because Kindlife just dropped a new brand that's gonna blow your FACE OFF (in the best way possible). We're talking about Within Skincare – a line so good, it's borderline illegal.   We're talking next-level ingredients, textures that'll make your angels sing, and results that'll have you questioning reality.  Is this sorcery? Maybe.  Is it life-changing? Absolutely.  Join us as we dive deep into Within and unleash the glow you never knew existed! <br style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br></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
                                )

                        )

                )

            [cp_has_video] => 1
            [brand_name] => Divyasatva
            [ratting_count] => 1
        )

    [35495] => Array
        (
            [product_id] => 35495
            [product] => 
            [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] => 1200173
            [hsn_code] => 3304
            [status] => A
            [list_price] => 0.00
            [amount] => 4
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1702381915
            [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] => 0
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 0.000000
            [short_description] => <p>72 Hours Moisturisation</p>
            [full_description] => <p>Light on the skin but heavy on moisturization, the Daily Dew Barrier Restore Gel Moisturizer is all you need for your skins daily dose of nourishment. Loaded with skin-loving ingredients such as Ceramide Complex, Hyaluronic Acid, and Sea Alage it keeps the skin moisturized for 72 hours.<br />This non-sticky and non-greasy blend is perfect for oily and sensitive skin. It helps achieve brighter and even-toned skin by protecting and restoring the skin barrier. This gel moisturizer sinks into the skin quickly to leave it soft, smooth, and plump in no time.</p>
            [category_ids] => Array
                (
                    [0] => 2813
                )

            [position] => 0
            [seo_name] => daily-dew-barrier-restore-gel-moisturizer-for-oily-and-sensitive-skin
            [seo_path] => 2685/2708/2813
            [main_category] => 2813
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 0
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                )

            [brand_name] => Divyasatva
        )

)


  2. end of fxn

  1. Array
(
    [show_master_products_only] => 
    [area] => C
    [for_required_product] => 35494
    [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 = 35494 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] => 35495
    [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 = 35495 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
Face sunscreen:Sun Care:Skin 
  1. Array
(
    [show_master_products_only] => 
    [area] => C
    [check_location] => 1
    [process_empty_items] => 1
    [dispatch] => categories.view
    [category_id] => 2813
    [features_hash] => 28-50284
    [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] => 2813
    [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] => 2813
    [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] => 2813
    [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

Face sunscreen

Filters

Filters
Brand
Price

₹  –  ₹

  • ‎₹0
  • ‎₹4247
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+

Face sunscreen

  • Moisturization
Filters
Bestselling
2 Products Found
Divyasatva:
Use SUMVIBE10 & Get Flat 10% off on orders above Rs. 1999.Use SUNKISS5 & Get Flat 5% off on orders above Rs. 999. +1
Divyasatva
5.0
 (1)
Divyasatva:
Use SUMVIBE10 & Get Flat 10% off on orders above Rs. 1999.Use SUNKISS5 & Get Flat 5% off on orders above Rs. 999. +1
Divyasatva
0 Items selected Move to Collection

Ctrl+Alt+D - show/hide toolbar

  • Page generating time 1.7566 s
  • Memory usage 10 778.51 KB

Server

✖

Request

✖

Config

✖

SQL

✖

Cache queries

✖

Logging

✖

Templates

✖

Blocks

✖