1. Array
(
    [show_master_products_only] => 
    [area] => C
    [currency] => EUR
    [sort_order] => desc
    [sl] => en
    [dispatch] => categories.view
    [category_id] => 1895
    [save_view_results] => product_id
    [items_per_page] => 24
    [sort_by] => bestsellers
    [extend] => Array
        (
            [0] => categories
            [1] => description
            [2] => description
            [3] => full_description
        )

    [subcats] => Y
    [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] => 11731,16371,24069,29531,30016,30188
                        )

                )

        )

)


  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_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 (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) AND (1 AND products.product_id IN (11731,16371,24069,29531,30016,30188)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 24

  1. before end of oxn

  2. Array
(
    [30016] => Array
        (
            [product_id] => 30016
            [product] => SPF50 Sunscreen Body Lotion - 200ml
            [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] => SPFBL200
            [hsn_code] => 3304
            [status] => A
            [list_price] => 499.00
            [amount] => 1
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1683627163
            [updated_timestamp] => 1750412913
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 474.000000
            [short_description] => Protection harmful sunrays & prevent tanning
            [full_description] => <p>WishCare SPF50 Sunscreen Body Lotion has a light, weight-less texture which performs the powerful triple action of protection from the harmful sunrays, brightening the skin and also nourishing it with intense moisturization and hydration. Regular and consistent usage of this sunscreen body lotion keeps the skin protected from UVA and UVB rays, and hence protecting the skin from photo-ageing, preventing sun spots and tanning. Enriched with Non-Comedogenic ingredients along with natural extracts of Carrot Seed and Raspberry, this body lotion keeps the skin nourished and moisturized.</p>
            [category_ids] => Array
                (
                    [0] => 1953
                    [1] => 2120
                    [2] => 2823
                    [3] => 1915
                )

            [seo_name] => spf50-sunscreen-body-lotion-200ml
            [seo_path] => 1915
            [average_rating] => 3.60
            [reviews_count] => 5
            [main_category] => 1915
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 5
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                    [1309] => Array
                        (
                            [video_id] => 1309
                            [video_type] => A
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1719167400
                            [status] => A
                            [user_id] => 183433
                            [extra_params] => 
                            [community_video_id] => 0
                            [community_url] => https://www.kindlife.in/need-tan-protection-in-summers
                            [community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1309_2024-06-18_13:55:51_video_preview.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/video_library/1309_2024-06-18_13:55:51_video.mp4
                            [community_last_sync_timestamp] => 0
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Your Summer Essential
                            [description] => <p>Stay sun-kissed without the burn! Wishcare SPF50 Sunscreen Body Lotion is your perfect sunny day companion, offering high-level protection with a lightweight, non-greasy feel. It’s enriched with nourishing ingredients to keep your skin soft and hydrated while guarding against harmful UVA and UVB rays. Say hello to carefree, radiant days under the sun with this delightful sunscreen!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 0
                            [dislike_count] => 0
                            [comment_count] => 0
                            [meta_keywords] => 
                            [meta_description] => 
                            [page_title] => 
                            [tagged_brands] => 32218
                            [category_id] => 7
                            [link_type] => M
                            [preview] => Array
                                (
                                    [default_icon] => 1
                                )

                        )

                )

            [cp_has_video] => 1
            [brand_name] => WishCare
            [ratting_count] => 5
        )

    [30188] => Array
        (
            [product_id] => 30188
            [product] => Sunday everyday body sunscreen moisturiser spf 50 - 500ml
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 180
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => 796554116167
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1800.00
            [amount] => 134
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1683884426
            [updated_timestamp] => 1750411724
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 1710.000000
            [short_description] => <p>Provides SPF 50 protection, nourishes, and hydrates.</p>
            [full_description] => <p>Sundays are for everyone with Sunday Everyday! This lightweight, non-sticky SPF 50 body sunscreen and moisturizer deeply nourishes your skin while protecting it from harmful UV rays. It combats dry elbows, sunburns, and unprotected areas. Infused with Retinal, which works 11 times faster than Retinol, it also addresses fine lines, wrinkles, and pigmentation. Water-resistant for 90 minutes, it's perfect for pool dips or beach days.</p>
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [seo_name] => sunday-everyday-body-sunscreen-moisturiser-spf-50-500ml
            [seo_path] => 2685/2705/2811
            [average_rating] => 4.85
            [reviews_count] => 13
            [main_category] => 2811
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 5
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                    [856] => Array
                        (
                            [video_id] => 856
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1692210600
                            [status] => A
                            [user_id] => 139224
                            [extra_params] => 
                            [community_video_id] => 907
                            [community_url] => https://www.kindlife.in/body-sunscreen-en
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/907/5c0ca277d658ef6c1dddef8cf164b2ab.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/907/07cb0047223f4d53543c2bf8ae7565df.mp4
                            [community_last_sync_timestamp] => 1713162745
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Pulp Sunday's Hydrating Sun Protection
                            [description] => <p>Introducing Pulp Sunday Everyday Body Sunscreen + Moisturiser (SPF 50), your everyday essential for sun protection and hydration. This lightweight formula combines SPF 50 protection with moisturizing benefits, keeping your skin shielded from harmful UV rays while ensuring it stays soft and nourished. Perfect for daily use, it absorbs quickly without leaving a sticky residue, making it ideal for any outdoor activity. Keep your skin healthy and protected with Pulp Sunday's multitasking sunscreen and moisturizer!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 0
                            [dislike_count] => 0
                            [comment_count] => 0
                            [meta_keywords] => 
                            [meta_description] => 
                            [page_title] => 
                            [tagged_brands] => 
                            [category_id] => 7
                            [link_type] => M
                            [preview] => Array
                                (
                                    [default_icon] => 1
                                )

                        )

                    [748] => Array
                        (
                            [video_id] => 748
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1684261800
                            [status] => A
                            [user_id] => 146299
                            [extra_params] => 
                            [community_video_id] => 775
                            [community_url] => https://www.kindlife.in/pulp-sunday-everyday-sunscreen
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/775/c1642a8243d39352dfa3fdf618ba6d24.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/775/f067bff0163f138a3db7a11038407b0c.mp4
                            [community_last_sync_timestamp] => 1713162272
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Pulp Sunday Everyday Sunscreen 
                            [description] => Pulp Sunday Everyday Sunscreen - moisturiser+ SPF. 500 ml bottle to last longer. Water resistant. Bigger bottle = less frequent repurchase, which is more sustainable.
                            [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] => Pulp
            [ratting_count] => 13
        )

)


  1. Array
(
    [30016] => Array
        (
            [product_id] => 30016
            [product] => SPF50 Sunscreen Body Lotion - 200ml
            [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] => SPFBL200
            [hsn_code] => 3304
            [status] => A
            [list_price] => 499.00
            [amount] => 1
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1683627163
            [updated_timestamp] => 1750412913
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 474.000000
            [short_description] => Protection harmful sunrays & prevent tanning
            [full_description] => <p>WishCare SPF50 Sunscreen Body Lotion has a light, weight-less texture which performs the powerful triple action of protection from the harmful sunrays, brightening the skin and also nourishing it with intense moisturization and hydration. Regular and consistent usage of this sunscreen body lotion keeps the skin protected from UVA and UVB rays, and hence protecting the skin from photo-ageing, preventing sun spots and tanning. Enriched with Non-Comedogenic ingredients along with natural extracts of Carrot Seed and Raspberry, this body lotion keeps the skin nourished and moisturized.</p>
            [category_ids] => Array
                (
                    [0] => 1953
                    [1] => 2120
                    [2] => 2823
                    [3] => 1915
                )

            [seo_name] => spf50-sunscreen-body-lotion-200ml
            [seo_path] => 1915
            [average_rating] => 3.60
            [reviews_count] => 5
            [main_category] => 1915
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 5
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                    [1309] => Array
                        (
                            [video_id] => 1309
                            [video_type] => A
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1719167400
                            [status] => A
                            [user_id] => 183433
                            [extra_params] => 
                            [community_video_id] => 0
                            [community_url] => https://www.kindlife.in/need-tan-protection-in-summers
                            [community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1309_2024-06-18_13:55:51_video_preview.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/video_library/1309_2024-06-18_13:55:51_video.mp4
                            [community_last_sync_timestamp] => 0
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Your Summer Essential
                            [description] => <p>Stay sun-kissed without the burn! Wishcare SPF50 Sunscreen Body Lotion is your perfect sunny day companion, offering high-level protection with a lightweight, non-greasy feel. It’s enriched with nourishing ingredients to keep your skin soft and hydrated while guarding against harmful UVA and UVB rays. Say hello to carefree, radiant days under the sun with this delightful sunscreen!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 0
                            [dislike_count] => 0
                            [comment_count] => 0
                            [meta_keywords] => 
                            [meta_description] => 
                            [page_title] => 
                            [tagged_brands] => 32218
                            [category_id] => 7
                            [link_type] => M
                            [preview] => Array
                                (
                                    [default_icon] => 1
                                )

                        )

                )

            [cp_has_video] => 1
            [brand_name] => WishCare
            [ratting_count] => 5
        )

    [30188] => Array
        (
            [product_id] => 30188
            [product] => Sunday everyday body sunscreen moisturiser spf 50 - 500ml
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 180
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => 796554116167
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1800.00
            [amount] => 134
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1683884426
            [updated_timestamp] => 1750411724
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 1710.000000
            [short_description] => <p>Provides SPF 50 protection, nourishes, and hydrates.</p>
            [full_description] => <p>Sundays are for everyone with Sunday Everyday! This lightweight, non-sticky SPF 50 body sunscreen and moisturizer deeply nourishes your skin while protecting it from harmful UV rays. It combats dry elbows, sunburns, and unprotected areas. Infused with Retinal, which works 11 times faster than Retinol, it also addresses fine lines, wrinkles, and pigmentation. Water-resistant for 90 minutes, it's perfect for pool dips or beach days.</p>
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [seo_name] => sunday-everyday-body-sunscreen-moisturiser-spf-50-500ml
            [seo_path] => 2685/2705/2811
            [average_rating] => 4.85
            [reviews_count] => 13
            [main_category] => 2811
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 5
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                    [856] => Array
                        (
                            [video_id] => 856
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1692210600
                            [status] => A
                            [user_id] => 139224
                            [extra_params] => 
                            [community_video_id] => 907
                            [community_url] => https://www.kindlife.in/body-sunscreen-en
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/907/5c0ca277d658ef6c1dddef8cf164b2ab.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/907/07cb0047223f4d53543c2bf8ae7565df.mp4
                            [community_last_sync_timestamp] => 1713162745
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Pulp Sunday's Hydrating Sun Protection
                            [description] => <p>Introducing Pulp Sunday Everyday Body Sunscreen + Moisturiser (SPF 50), your everyday essential for sun protection and hydration. This lightweight formula combines SPF 50 protection with moisturizing benefits, keeping your skin shielded from harmful UV rays while ensuring it stays soft and nourished. Perfect for daily use, it absorbs quickly without leaving a sticky residue, making it ideal for any outdoor activity. Keep your skin healthy and protected with Pulp Sunday's multitasking sunscreen and moisturizer!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 0
                            [dislike_count] => 0
                            [comment_count] => 0
                            [meta_keywords] => 
                            [meta_description] => 
                            [page_title] => 
                            [tagged_brands] => 
                            [category_id] => 7
                            [link_type] => M
                            [preview] => Array
                                (
                                    [default_icon] => 1
                                )

                        )

                    [748] => Array
                        (
                            [video_id] => 748
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1684261800
                            [status] => A
                            [user_id] => 146299
                            [extra_params] => 
                            [community_video_id] => 775
                            [community_url] => https://www.kindlife.in/pulp-sunday-everyday-sunscreen
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/775/c1642a8243d39352dfa3fdf618ba6d24.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/775/f067bff0163f138a3db7a11038407b0c.mp4
                            [community_last_sync_timestamp] => 1713162272
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Pulp Sunday Everyday Sunscreen 
                            [description] => Pulp Sunday Everyday Sunscreen - moisturiser+ SPF. 500 ml bottle to last longer. Water resistant. Bigger bottle = less frequent repurchase, which is more sustainable.
                            [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] => Pulp
            [ratting_count] => 13
        )

)


  2. end of fxn

  1. Array
(
    [show_master_products_only] => 
    [area] => C
    [pid] => 30016
    [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 (30016)) 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] => 30016
    [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 (30016)) 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
(
    [30016] => Array
        (
            [product_id] => 30016
            [product] => SPF50 Sunscreen Body Lotion - 200ml
            [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
                (
                    [1309] => Array
                        (
                            [video_id] => 1309
                            [video_type] => A
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1719167400
                            [status] => A
                            [user_id] => 183433
                            [extra_params] => 
                            [community_video_id] => 0
                            [community_url] => https://www.kindlife.in/need-tan-protection-in-summers
                            [community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1309_2024-06-18_13:55:51_video_preview.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/video_library/1309_2024-06-18_13:55:51_video.mp4
                            [community_last_sync_timestamp] => 0
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Your Summer Essential
                            [description] => <p>Stay sun-kissed without the burn! Wishcare SPF50 Sunscreen Body Lotion is your perfect sunny day companion, offering high-level protection with a lightweight, non-greasy feel. It’s enriched with nourishing ingredients to keep your skin soft and hydrated while guarding against harmful UVA and UVB rays. Say hello to carefree, radiant days under the sun with this delightful sunscreen!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 0
                            [dislike_count] => 0
                            [comment_count] => 0
                            [meta_keywords] => 
                            [meta_description] => 
                            [page_title] => 
                            [tagged_brands] => 32218
                            [category_id] => 7
                            [link_type] => M
                            [preview] => Array
                                (
                                    [default_icon] => 1
                                )

                        )

                )

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

)


  1. Array
(
    [30016] => Array
        (
            [product_id] => 30016
            [product] => SPF50 Sunscreen Body Lotion - 200ml
            [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
                (
                    [1309] => Array
                        (
                            [video_id] => 1309
                            [video_type] => A
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1719167400
                            [status] => A
                            [user_id] => 183433
                            [extra_params] => 
                            [community_video_id] => 0
                            [community_url] => https://www.kindlife.in/need-tan-protection-in-summers
                            [community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1309_2024-06-18_13:55:51_video_preview.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/video_library/1309_2024-06-18_13:55:51_video.mp4
                            [community_last_sync_timestamp] => 0
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Your Summer Essential
                            [description] => <p>Stay sun-kissed without the burn! Wishcare SPF50 Sunscreen Body Lotion is your perfect sunny day companion, offering high-level protection with a lightweight, non-greasy feel. It’s enriched with nourishing ingredients to keep your skin soft and hydrated while guarding against harmful UVA and UVB rays. Say hello to carefree, radiant days under the sun with this delightful sunscreen!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 0
                            [dislike_count] => 0
                            [comment_count] => 0
                            [meta_keywords] => 
                            [meta_description] => 
                            [page_title] => 
                            [tagged_brands] => 32218
                            [category_id] => 7
                            [link_type] => M
                            [preview] => Array
                                (
                                    [default_icon] => 1
                                )

                        )

                )

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

)


  2. end of fxn

  1. Array
(
    [show_master_products_only] => 
    [area] => C
    [pid] => 30016
    [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 (30016)) 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] => 30016
    [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 (30016)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products_categories.category_id IN (458, 2662, 1186, 2661, 2488, 2656, 2438, 2645, 2659, 2663, 2658, 2654, 2453, 2643, 2644, 2653, 2651, 2652, 2463, 2640, 2649, 2650, 2473, 2646, 2648, 2684, 2660, 2642, 2647, 2641, 2494, 2655, 2657, 2664, 2666, 2665, 2667, 2668, 2669, 2670, 2671, 2672, 2673, 2674, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1

  1. before end of oxn

  2. Array
(
)


  1. Array
(
)


  2. end of fxn

  1. Array
(
    [show_master_products_only] => 
    [area] => C
    [pid] => 30188
    [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 (30188)) 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] => 30188
    [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 (30188)) 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
(
    [30188] => Array
        (
            [product_id] => 30188
            [product] => Sunday everyday body sunscreen moisturiser spf 50 - 500ml
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 180
            [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
                (
                    [856] => Array
                        (
                            [video_id] => 856
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1692210600
                            [status] => A
                            [user_id] => 139224
                            [extra_params] => 
                            [community_video_id] => 907
                            [community_url] => https://www.kindlife.in/body-sunscreen-en
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/907/5c0ca277d658ef6c1dddef8cf164b2ab.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/907/07cb0047223f4d53543c2bf8ae7565df.mp4
                            [community_last_sync_timestamp] => 1713162745
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Pulp Sunday's Hydrating Sun Protection
                            [description] => <p>Introducing Pulp Sunday Everyday Body Sunscreen + Moisturiser (SPF 50), your everyday essential for sun protection and hydration. This lightweight formula combines SPF 50 protection with moisturizing benefits, keeping your skin shielded from harmful UV rays while ensuring it stays soft and nourished. Perfect for daily use, it absorbs quickly without leaving a sticky residue, making it ideal for any outdoor activity. Keep your skin healthy and protected with Pulp Sunday's multitasking sunscreen and moisturizer!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 0
                            [dislike_count] => 0
                            [comment_count] => 0
                            [meta_keywords] => 
                            [meta_description] => 
                            [page_title] => 
                            [tagged_brands] => 
                            [category_id] => 7
                            [link_type] => M
                            [preview] => Array
                                (
                                    [default_icon] => 1
                                )

                        )

                    [748] => Array
                        (
                            [video_id] => 748
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1684261800
                            [status] => A
                            [user_id] => 146299
                            [extra_params] => 
                            [community_video_id] => 775
                            [community_url] => https://www.kindlife.in/pulp-sunday-everyday-sunscreen
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/775/c1642a8243d39352dfa3fdf618ba6d24.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/775/f067bff0163f138a3db7a11038407b0c.mp4
                            [community_last_sync_timestamp] => 1713162272
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Pulp Sunday Everyday Sunscreen 
                            [description] => Pulp Sunday Everyday Sunscreen - moisturiser+ SPF. 500 ml bottle to last longer. Water resistant. Bigger bottle = less frequent repurchase, which is more sustainable.
                            [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] => Pulp
        )

)


  1. Array
(
    [30188] => Array
        (
            [product_id] => 30188
            [product] => Sunday everyday body sunscreen moisturiser spf 50 - 500ml
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 180
            [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
                (
                    [856] => Array
                        (
                            [video_id] => 856
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1692210600
                            [status] => A
                            [user_id] => 139224
                            [extra_params] => 
                            [community_video_id] => 907
                            [community_url] => https://www.kindlife.in/body-sunscreen-en
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/907/5c0ca277d658ef6c1dddef8cf164b2ab.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/907/07cb0047223f4d53543c2bf8ae7565df.mp4
                            [community_last_sync_timestamp] => 1713162745
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Pulp Sunday's Hydrating Sun Protection
                            [description] => <p>Introducing Pulp Sunday Everyday Body Sunscreen + Moisturiser (SPF 50), your everyday essential for sun protection and hydration. This lightweight formula combines SPF 50 protection with moisturizing benefits, keeping your skin shielded from harmful UV rays while ensuring it stays soft and nourished. Perfect for daily use, it absorbs quickly without leaving a sticky residue, making it ideal for any outdoor activity. Keep your skin healthy and protected with Pulp Sunday's multitasking sunscreen and moisturizer!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 0
                            [dislike_count] => 0
                            [comment_count] => 0
                            [meta_keywords] => 
                            [meta_description] => 
                            [page_title] => 
                            [tagged_brands] => 
                            [category_id] => 7
                            [link_type] => M
                            [preview] => Array
                                (
                                    [default_icon] => 1
                                )

                        )

                    [748] => Array
                        (
                            [video_id] => 748
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1684261800
                            [status] => A
                            [user_id] => 146299
                            [extra_params] => 
                            [community_video_id] => 775
                            [community_url] => https://www.kindlife.in/pulp-sunday-everyday-sunscreen
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/775/c1642a8243d39352dfa3fdf618ba6d24.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/775/f067bff0163f138a3db7a11038407b0c.mp4
                            [community_last_sync_timestamp] => 1713162272
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Pulp Sunday Everyday Sunscreen 
                            [description] => Pulp Sunday Everyday Sunscreen - moisturiser+ SPF. 500 ml bottle to last longer. Water resistant. Bigger bottle = less frequent repurchase, which is more sustainable.
                            [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] => Pulp
        )

)


  2. end of fxn

  1. Array
(
    [show_master_products_only] => 
    [area] => C
    [pid] => 30188
    [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 (30188)) 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] => 30188
    [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 (30188)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products_categories.category_id IN (458, 2662, 1186, 2661, 2488, 2656, 2438, 2645, 2659, 2663, 2658, 2654, 2453, 2643, 2644, 2653, 2651, 2652, 2463, 2640, 2649, 2650, 2473, 2646, 2648, 2684, 2660, 2642, 2647, 2641, 2494, 2655, 2657, 2664, 2666, 2665, 2667, 2668, 2669, 2670, 2671, 2672, 2673, 2674, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1

  1. before end of oxn

  2. Array
(
)


  1. Array
(
)


  2. end of fxn

  1. Array
(
    [show_master_products_only] => 
    [area] => C
    [currency] => EUR
    [sort_order] => desc
    [sl] => en
    [dispatch] => categories.view
    [category_id] => 1895
    [save_view_results] => product_id
    [items_per_page] => 24
    [sort_by] => bestsellers
    [extend] => Array
        (
            [0] => categories
            [1] => description
            [2] => description
            [3] => full_description
        )

    [subcats] => Y
    [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] => 11731,16371,24069,29531,30016,30188
                        )

                )

        )

)


  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_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 (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) AND (1 AND products.product_id IN (11731,16371,24069,29531,30016,30188)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 24

  1. before end of oxn

  2. Array
(
    [30016] => Array
        (
            [product_id] => 30016
            [product] => SPF50 Sunscreen Body Lotion - 200ml
            [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] => SPFBL200
            [hsn_code] => 3304
            [status] => A
            [list_price] => 499.00
            [amount] => 1
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1683627163
            [updated_timestamp] => 1750412913
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 474.000000
            [short_description] => Protection harmful sunrays & prevent tanning
            [full_description] => <p>WishCare SPF50 Sunscreen Body Lotion has a light, weight-less texture which performs the powerful triple action of protection from the harmful sunrays, brightening the skin and also nourishing it with intense moisturization and hydration. Regular and consistent usage of this sunscreen body lotion keeps the skin protected from UVA and UVB rays, and hence protecting the skin from photo-ageing, preventing sun spots and tanning. Enriched with Non-Comedogenic ingredients along with natural extracts of Carrot Seed and Raspberry, this body lotion keeps the skin nourished and moisturized.</p>
            [category_ids] => Array
                (
                    [0] => 1953
                    [1] => 2120
                    [2] => 2823
                    [3] => 1915
                )

            [seo_name] => spf50-sunscreen-body-lotion-200ml
            [seo_path] => 1915
            [average_rating] => 3.60
            [reviews_count] => 5
            [main_category] => 1915
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 5
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                    [1309] => Array
                        (
                            [video_id] => 1309
                            [video_type] => A
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1719167400
                            [status] => A
                            [user_id] => 183433
                            [extra_params] => 
                            [community_video_id] => 0
                            [community_url] => https://www.kindlife.in/need-tan-protection-in-summers
                            [community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1309_2024-06-18_13:55:51_video_preview.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/video_library/1309_2024-06-18_13:55:51_video.mp4
                            [community_last_sync_timestamp] => 0
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Your Summer Essential
                            [description] => <p>Stay sun-kissed without the burn! Wishcare SPF50 Sunscreen Body Lotion is your perfect sunny day companion, offering high-level protection with a lightweight, non-greasy feel. It’s enriched with nourishing ingredients to keep your skin soft and hydrated while guarding against harmful UVA and UVB rays. Say hello to carefree, radiant days under the sun with this delightful sunscreen!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 0
                            [dislike_count] => 0
                            [comment_count] => 0
                            [meta_keywords] => 
                            [meta_description] => 
                            [page_title] => 
                            [tagged_brands] => 32218
                            [category_id] => 7
                            [link_type] => M
                            [preview] => Array
                                (
                                    [default_icon] => 1
                                )

                        )

                )

            [cp_has_video] => 1
            [brand_name] => WishCare
            [ratting_count] => 5
        )

    [30188] => Array
        (
            [product_id] => 30188
            [product] => Sunday everyday body sunscreen moisturiser spf 50 - 500ml
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 180
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => 796554116167
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1800.00
            [amount] => 134
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1683884426
            [updated_timestamp] => 1750411724
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 1710.000000
            [short_description] => <p>Provides SPF 50 protection, nourishes, and hydrates.</p>
            [full_description] => <p>Sundays are for everyone with Sunday Everyday! This lightweight, non-sticky SPF 50 body sunscreen and moisturizer deeply nourishes your skin while protecting it from harmful UV rays. It combats dry elbows, sunburns, and unprotected areas. Infused with Retinal, which works 11 times faster than Retinol, it also addresses fine lines, wrinkles, and pigmentation. Water-resistant for 90 minutes, it's perfect for pool dips or beach days.</p>
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [seo_name] => sunday-everyday-body-sunscreen-moisturiser-spf-50-500ml
            [seo_path] => 2685/2705/2811
            [average_rating] => 4.85
            [reviews_count] => 13
            [main_category] => 2811
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 5
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                    [856] => Array
                        (
                            [video_id] => 856
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1692210600
                            [status] => A
                            [user_id] => 139224
                            [extra_params] => 
                            [community_video_id] => 907
                            [community_url] => https://www.kindlife.in/body-sunscreen-en
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/907/5c0ca277d658ef6c1dddef8cf164b2ab.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/907/07cb0047223f4d53543c2bf8ae7565df.mp4
                            [community_last_sync_timestamp] => 1713162745
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Pulp Sunday's Hydrating Sun Protection
                            [description] => <p>Introducing Pulp Sunday Everyday Body Sunscreen + Moisturiser (SPF 50), your everyday essential for sun protection and hydration. This lightweight formula combines SPF 50 protection with moisturizing benefits, keeping your skin shielded from harmful UV rays while ensuring it stays soft and nourished. Perfect for daily use, it absorbs quickly without leaving a sticky residue, making it ideal for any outdoor activity. Keep your skin healthy and protected with Pulp Sunday's multitasking sunscreen and moisturizer!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 0
                            [dislike_count] => 0
                            [comment_count] => 0
                            [meta_keywords] => 
                            [meta_description] => 
                            [page_title] => 
                            [tagged_brands] => 
                            [category_id] => 7
                            [link_type] => M
                            [preview] => Array
                                (
                                    [default_icon] => 1
                                )

                        )

                    [748] => Array
                        (
                            [video_id] => 748
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1684261800
                            [status] => A
                            [user_id] => 146299
                            [extra_params] => 
                            [community_video_id] => 775
                            [community_url] => https://www.kindlife.in/pulp-sunday-everyday-sunscreen
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/775/c1642a8243d39352dfa3fdf618ba6d24.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/775/f067bff0163f138a3db7a11038407b0c.mp4
                            [community_last_sync_timestamp] => 1713162272
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Pulp Sunday Everyday Sunscreen 
                            [description] => Pulp Sunday Everyday Sunscreen - moisturiser+ SPF. 500 ml bottle to last longer. Water resistant. Bigger bottle = less frequent repurchase, which is more sustainable.
                            [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] => Pulp
            [ratting_count] => 13
        )

)


  1. Array
(
    [30016] => Array
        (
            [product_id] => 30016
            [product] => SPF50 Sunscreen Body Lotion - 200ml
            [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] => SPFBL200
            [hsn_code] => 3304
            [status] => A
            [list_price] => 499.00
            [amount] => 1
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1683627163
            [updated_timestamp] => 1750412913
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 474.000000
            [short_description] => Protection harmful sunrays & prevent tanning
            [full_description] => <p>WishCare SPF50 Sunscreen Body Lotion has a light, weight-less texture which performs the powerful triple action of protection from the harmful sunrays, brightening the skin and also nourishing it with intense moisturization and hydration. Regular and consistent usage of this sunscreen body lotion keeps the skin protected from UVA and UVB rays, and hence protecting the skin from photo-ageing, preventing sun spots and tanning. Enriched with Non-Comedogenic ingredients along with natural extracts of Carrot Seed and Raspberry, this body lotion keeps the skin nourished and moisturized.</p>
            [category_ids] => Array
                (
                    [0] => 1953
                    [1] => 2120
                    [2] => 2823
                    [3] => 1915
                )

            [seo_name] => spf50-sunscreen-body-lotion-200ml
            [seo_path] => 1915
            [average_rating] => 3.60
            [reviews_count] => 5
            [main_category] => 1915
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 5
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                    [1309] => Array
                        (
                            [video_id] => 1309
                            [video_type] => A
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1719167400
                            [status] => A
                            [user_id] => 183433
                            [extra_params] => 
                            [community_video_id] => 0
                            [community_url] => https://www.kindlife.in/need-tan-protection-in-summers
                            [community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1309_2024-06-18_13:55:51_video_preview.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/video_library/1309_2024-06-18_13:55:51_video.mp4
                            [community_last_sync_timestamp] => 0
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Your Summer Essential
                            [description] => <p>Stay sun-kissed without the burn! Wishcare SPF50 Sunscreen Body Lotion is your perfect sunny day companion, offering high-level protection with a lightweight, non-greasy feel. It’s enriched with nourishing ingredients to keep your skin soft and hydrated while guarding against harmful UVA and UVB rays. Say hello to carefree, radiant days under the sun with this delightful sunscreen!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 0
                            [dislike_count] => 0
                            [comment_count] => 0
                            [meta_keywords] => 
                            [meta_description] => 
                            [page_title] => 
                            [tagged_brands] => 32218
                            [category_id] => 7
                            [link_type] => M
                            [preview] => Array
                                (
                                    [default_icon] => 1
                                )

                        )

                )

            [cp_has_video] => 1
            [brand_name] => WishCare
            [ratting_count] => 5
        )

    [30188] => Array
        (
            [product_id] => 30188
            [product] => Sunday everyday body sunscreen moisturiser spf 50 - 500ml
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 180
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => 796554116167
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1800.00
            [amount] => 134
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1683884426
            [updated_timestamp] => 1750411724
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 1710.000000
            [short_description] => <p>Provides SPF 50 protection, nourishes, and hydrates.</p>
            [full_description] => <p>Sundays are for everyone with Sunday Everyday! This lightweight, non-sticky SPF 50 body sunscreen and moisturizer deeply nourishes your skin while protecting it from harmful UV rays. It combats dry elbows, sunburns, and unprotected areas. Infused with Retinal, which works 11 times faster than Retinol, it also addresses fine lines, wrinkles, and pigmentation. Water-resistant for 90 minutes, it's perfect for pool dips or beach days.</p>
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [seo_name] => sunday-everyday-body-sunscreen-moisturiser-spf-50-500ml
            [seo_path] => 2685/2705/2811
            [average_rating] => 4.85
            [reviews_count] => 13
            [main_category] => 2811
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 5
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                    [856] => Array
                        (
                            [video_id] => 856
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1692210600
                            [status] => A
                            [user_id] => 139224
                            [extra_params] => 
                            [community_video_id] => 907
                            [community_url] => https://www.kindlife.in/body-sunscreen-en
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/907/5c0ca277d658ef6c1dddef8cf164b2ab.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/907/07cb0047223f4d53543c2bf8ae7565df.mp4
                            [community_last_sync_timestamp] => 1713162745
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Pulp Sunday's Hydrating Sun Protection
                            [description] => <p>Introducing Pulp Sunday Everyday Body Sunscreen + Moisturiser (SPF 50), your everyday essential for sun protection and hydration. This lightweight formula combines SPF 50 protection with moisturizing benefits, keeping your skin shielded from harmful UV rays while ensuring it stays soft and nourished. Perfect for daily use, it absorbs quickly without leaving a sticky residue, making it ideal for any outdoor activity. Keep your skin healthy and protected with Pulp Sunday's multitasking sunscreen and moisturizer!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 0
                            [dislike_count] => 0
                            [comment_count] => 0
                            [meta_keywords] => 
                            [meta_description] => 
                            [page_title] => 
                            [tagged_brands] => 
                            [category_id] => 7
                            [link_type] => M
                            [preview] => Array
                                (
                                    [default_icon] => 1
                                )

                        )

                    [748] => Array
                        (
                            [video_id] => 748
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1684261800
                            [status] => A
                            [user_id] => 146299
                            [extra_params] => 
                            [community_video_id] => 775
                            [community_url] => https://www.kindlife.in/pulp-sunday-everyday-sunscreen
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/775/c1642a8243d39352dfa3fdf618ba6d24.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/775/f067bff0163f138a3db7a11038407b0c.mp4
                            [community_last_sync_timestamp] => 1713162272
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Pulp Sunday Everyday Sunscreen 
                            [description] => Pulp Sunday Everyday Sunscreen - moisturiser+ SPF. 500 ml bottle to last longer. Water resistant. Bigger bottle = less frequent repurchase, which is more sustainable.
                            [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] => Pulp
            [ratting_count] => 13
        )

)


  2. end of fxn

  1. Array
(
    [show_master_products_only] => 
    [area] => C
    [for_required_product] => 30016
    [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 = 30016 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] => 30188
    [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 = 30188 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
Body Sunscreens 
  1. Array
(
    [show_master_products_only] => 
    [area] => C
    [check_location] => 1
    [process_empty_items] => 1
    [dispatch] => categories.view
    [category_id] => 1895
    [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
    [variant_filter] => 
    [features_hash] => 
    [get_conditions] => 1
    [custom_extend] => Array
        (
            [0] => categories
        )

    [subcats] => Y
    [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] => 11731,16371,24069,29531,30016,30188
                        )

                )

        )

)


  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] => 1895
    [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
    [variant_filter] => 
    [features_hash] => 
    [get_conditions] => 1
    [custom_extend] => Array
        (
            [0] => categories
        )

    [subcats] => Y
    [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] => 11731,16371,24069,29531,30016,30188
                        )

                )

        )

)


  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

Body Sunscreens

Filters

Filters
Brand
Price

€  –  €

  • ‎€6
  • ‎€23
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+

Body Sunscreens

Filters
Bestselling
5 Products Found 
  1. Array
(
    [show_master_products_only] => 
    [area] => A
    [extend] => Array
        (
            [0] => product_name
        )

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

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


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

    [custom_extend] => Array
        (
        )

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

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

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

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


  1. Advanced and feature filters

  1. before hook

  1. after hook

  2. C

  1. before 2nd hook

  1. after 2nd hook

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

  1. before end of oxn

  2. Array
(
    [30016] => Array
        (
            [product_id] => 30016
            [product] => SPF50 Sunscreen Body Lotion - 200ml
            [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] => SPFBL200
            [hsn_code] => 3304
            [status] => A
            [list_price] => 499.00
            [amount] => 1
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1683627163
            [updated_timestamp] => 1750412913
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 474.000000
            [category_ids] => Array
                (
                    [0] => 1953
                    [1] => 2120
                    [2] => 2823
                    [3] => 1915
                )

            [seo_name] => spf50-sunscreen-body-lotion-200ml
            [seo_path] => 1915
            [main_category] => 1915
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 5
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                    [1309] => Array
                        (
                            [video_id] => 1309
                            [video_type] => A
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1719167400
                            [status] => A
                            [user_id] => 183433
                            [extra_params] => 
                            [community_video_id] => 0
                            [community_url] => https://www.kindlife.in/need-tan-protection-in-summers
                            [community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1309_2024-06-18_13:55:51_video_preview.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/video_library/1309_2024-06-18_13:55:51_video.mp4
                            [community_last_sync_timestamp] => 0
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Your Summer Essential
                            [description] => <p>Stay sun-kissed without the burn! Wishcare SPF50 Sunscreen Body Lotion is your perfect sunny day companion, offering high-level protection with a lightweight, non-greasy feel. It’s enriched with nourishing ingredients to keep your skin soft and hydrated while guarding against harmful UVA and UVB rays. Say hello to carefree, radiant days under the sun with this delightful sunscreen!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 0
                            [dislike_count] => 0
                            [comment_count] => 0
                            [meta_keywords] => 
                            [meta_description] => 
                            [page_title] => 
                            [tagged_brands] => 32218
                            [category_id] => 7
                            [link_type] => M
                            [preview] => Array
                                (
                                    [default_icon] => 1
                                )

                        )

                )

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

)


  1. Array
(
    [30016] => Array
        (
            [product_id] => 30016
            [product] => SPF50 Sunscreen Body Lotion - 200ml
            [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] => SPFBL200
            [hsn_code] => 3304
            [status] => A
            [list_price] => 499.00
            [amount] => 1
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1683627163
            [updated_timestamp] => 1750412913
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 474.000000
            [category_ids] => Array
                (
                    [0] => 1953
                    [1] => 2120
                    [2] => 2823
                    [3] => 1915
                )

            [seo_name] => spf50-sunscreen-body-lotion-200ml
            [seo_path] => 1915
            [main_category] => 1915
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 5
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                    [1309] => Array
                        (
                            [video_id] => 1309
                            [video_type] => A
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1719167400
                            [status] => A
                            [user_id] => 183433
                            [extra_params] => 
                            [community_video_id] => 0
                            [community_url] => https://www.kindlife.in/need-tan-protection-in-summers
                            [community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1309_2024-06-18_13:55:51_video_preview.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/video_library/1309_2024-06-18_13:55:51_video.mp4
                            [community_last_sync_timestamp] => 0
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Your Summer Essential
                            [description] => <p>Stay sun-kissed without the burn! Wishcare SPF50 Sunscreen Body Lotion is your perfect sunny day companion, offering high-level protection with a lightweight, non-greasy feel. It’s enriched with nourishing ingredients to keep your skin soft and hydrated while guarding against harmful UVA and UVB rays. Say hello to carefree, radiant days under the sun with this delightful sunscreen!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 0
                            [dislike_count] => 0
                            [comment_count] => 0
                            [meta_keywords] => 
                            [meta_description] => 
                            [page_title] => 
                            [tagged_brands] => 32218
                            [category_id] => 7
                            [link_type] => M
                            [preview] => Array
                                (
                                    [default_icon] => 1
                                )

                        )

                )

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

)


  2. end of fxn

                


    
    
        
            WishCare: SPF50 Sunscreen Body Lotion - 200ml

        

            





                                        
                                
            

            
                                    

                        
    


    

        
                
                    
        

        
                    
                    
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            

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

                                                        
        

                                    WishCare
        


        

            

                                
    
            SPF50 Sunscreen Body Lotion - 200ml    


            


            
            

                                
            
    


            


            

                                
            


                            

                            
            



                            

        

        

        

                            


	            	                	                 

    
        
        
                                
                                    €6.32
                            

                        

	            	            
	            	            	                           
            

            
            

                            €6.65
                        

            

        
    
	            
            
	            	                
	            
	            	                
                                                                                                                                                        

	                    5%
	                

                                

                                        

                        
                        

     

                                
                                
            
            

                                    3.6

            
    



    


                 (5)                 

                                                            
            

                

                                                        
                        
 
                                                        
                            
					        
                        

                                                                    
                

                    
                    
                    
                                                                    









        
                
 

        
        
    

    





    
            
    
 
    


    
                            
                                
        
 
    








                                    

            

        

        

    

    
        







                                
                        

    
    
    
    


































        

                        
                        

 





            
        
        

            


            

                                                                                    

                                            

            

                                                                                
                                                                                                        

                        
            

            
                                    
                        
                                        

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

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

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


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

    [custom_extend] => Array
        (
        )

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

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

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

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


  1. Advanced and feature filters

  1. before hook

  1. after hook

  2. C

  1. before 2nd hook

  1. after 2nd hook

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

  1. before end of oxn

  2. Array
(
    [30188] => Array
        (
            [product_id] => 30188
            [product] => Sunday everyday body sunscreen moisturiser spf 50 - 500ml
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 180
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => 796554116167
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1800.00
            [amount] => 134
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1683884426
            [updated_timestamp] => 1750411724
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 1710.000000
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [seo_name] => sunday-everyday-body-sunscreen-moisturiser-spf-50-500ml
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 5
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                    [856] => Array
                        (
                            [video_id] => 856
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1692210600
                            [status] => A
                            [user_id] => 139224
                            [extra_params] => 
                            [community_video_id] => 907
                            [community_url] => https://www.kindlife.in/body-sunscreen-en
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/907/5c0ca277d658ef6c1dddef8cf164b2ab.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/907/07cb0047223f4d53543c2bf8ae7565df.mp4
                            [community_last_sync_timestamp] => 1713162745
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Pulp Sunday's Hydrating Sun Protection
                            [description] => <p>Introducing Pulp Sunday Everyday Body Sunscreen + Moisturiser (SPF 50), your everyday essential for sun protection and hydration. This lightweight formula combines SPF 50 protection with moisturizing benefits, keeping your skin shielded from harmful UV rays while ensuring it stays soft and nourished. Perfect for daily use, it absorbs quickly without leaving a sticky residue, making it ideal for any outdoor activity. Keep your skin healthy and protected with Pulp Sunday's multitasking sunscreen and moisturizer!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 0
                            [dislike_count] => 0
                            [comment_count] => 0
                            [meta_keywords] => 
                            [meta_description] => 
                            [page_title] => 
                            [tagged_brands] => 
                            [category_id] => 7
                            [link_type] => M
                            [preview] => Array
                                (
                                    [default_icon] => 1
                                )

                        )

                    [748] => Array
                        (
                            [video_id] => 748
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1684261800
                            [status] => A
                            [user_id] => 146299
                            [extra_params] => 
                            [community_video_id] => 775
                            [community_url] => https://www.kindlife.in/pulp-sunday-everyday-sunscreen
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/775/c1642a8243d39352dfa3fdf618ba6d24.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/775/f067bff0163f138a3db7a11038407b0c.mp4
                            [community_last_sync_timestamp] => 1713162272
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Pulp Sunday Everyday Sunscreen 
                            [description] => Pulp Sunday Everyday Sunscreen - moisturiser+ SPF. 500 ml bottle to last longer. Water resistant. Bigger bottle = less frequent repurchase, which is more sustainable.
                            [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] => Pulp
        )

)


  1. Array
(
    [30188] => Array
        (
            [product_id] => 30188
            [product] => Sunday everyday body sunscreen moisturiser spf 50 - 500ml
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 180
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => 796554116167
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1800.00
            [amount] => 134
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1683884426
            [updated_timestamp] => 1750411724
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 1710.000000
            [category_ids] => Array
                (
                    [0] => 2811
                )

            [seo_name] => sunday-everyday-body-sunscreen-moisturiser-spf-50-500ml
            [seo_path] => 2685/2705/2811
            [main_category] => 2811
            [options_type_raw] => P
            [exceptions_type_raw] => F
            [tracking_raw] => B
            [zero_price_action_raw] => R
            [min_qty_raw] => 0
            [max_qty_raw] => 5
            [qty_step_raw] => 0
            [list_qty_count_raw] => 0
            [details_layout_raw] => default
            [video_as_images] => Array
                (
                )

            [videos] => Array
                (
                    [856] => Array
                        (
                            [video_id] => 856
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1692210600
                            [status] => A
                            [user_id] => 139224
                            [extra_params] => 
                            [community_video_id] => 907
                            [community_url] => https://www.kindlife.in/body-sunscreen-en
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/907/5c0ca277d658ef6c1dddef8cf164b2ab.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/907/07cb0047223f4d53543c2bf8ae7565df.mp4
                            [community_last_sync_timestamp] => 1713162745
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Pulp Sunday's Hydrating Sun Protection
                            [description] => <p>Introducing Pulp Sunday Everyday Body Sunscreen + Moisturiser (SPF 50), your everyday essential for sun protection and hydration. This lightweight formula combines SPF 50 protection with moisturizing benefits, keeping your skin shielded from harmful UV rays while ensuring it stays soft and nourished. Perfect for daily use, it absorbs quickly without leaving a sticky residue, making it ideal for any outdoor activity. Keep your skin healthy and protected with Pulp Sunday's multitasking sunscreen and moisturizer!</p>
                            [short_description] => 
                            [privacy] => 1
                            [like_count] => 0
                            [dislike_count] => 0
                            [comment_count] => 0
                            [meta_keywords] => 
                            [meta_description] => 
                            [page_title] => 
                            [tagged_brands] => 
                            [category_id] => 7
                            [link_type] => M
                            [preview] => Array
                                (
                                    [default_icon] => 1
                                )

                        )

                    [748] => Array
                        (
                            [video_id] => 748
                            [video_type] => C
                            [company_id] => 13
                            [usergroup_ids] => 0
                            [position] => 0
                            [timestamp] => 1684261800
                            [status] => A
                            [user_id] => 146299
                            [extra_params] => 
                            [community_video_id] => 775
                            [community_url] => https://www.kindlife.in/pulp-sunday-everyday-sunscreen
                            [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/775/c1642a8243d39352dfa3fdf618ba6d24.jpg
                            [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/775/f067bff0163f138a3db7a11038407b0c.mp4
                            [community_last_sync_timestamp] => 1713162272
                            [lang_code] => en
                            [youtube_id] => 
                            [video] => Pulp Sunday Everyday Sunscreen 
                            [description] => Pulp Sunday Everyday Sunscreen - moisturiser+ SPF. 500 ml bottle to last longer. Water resistant. Bigger bottle = less frequent repurchase, which is more sustainable.
                            [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] => Pulp
        )

)


  2. end of fxn

                


    
    
        
            Pulp: Sunday everyday body sunscreen moisturiser spf 50 - 500ml

        

            





                                        
                                
            

            
                                    

                        
    


    

        
                
                    
        

        
                    
                                        
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            

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

                                    
        

                                    Pulp
        


        

            

                                
    
            Sunday everyday body sunscreen moisturiser spf 50 - 500ml    


            


            
            

                                
            
    


            


            

                                
            


                            

                            
            



                            

        

        

        

                            


	            	                	                 

    
        
        
                                
                                    €22.80
                            

                        

	            	            
	            	            	                           
            

            
            

                            €24.00
                        

            

        
    
	            
            
	            	                
	            
	            	                
                                                                                                                                                        

	                    5%
	                

                                

                                        

                        
                        

     

                                
                                
            
            

                                    4.9

            
    



    


                 (13)                 

                                                            
            

                

                                                        
                        
 
                                                        
                            
					        
                        

                                                                    
                

                    
                    
                    
                                                                    









        
                
 

        
        
    

    





    
            
    
 
    


    
                            
                                
        
 
    








                                    

            

        

        

    

    
        










    




    0 Items selected
    
        Move to Collection
    






    










            


    

    
    

























    

                            

        
                                        
            
                        

                                    






                            

        
    
        

    









            

        


        

        


        



            
    
    

    
    
    
    
    
    
    
    
    





































































































                    























    
    

    

        
                
        

        

            

            Ctrl+Alt+D - show/hide toolbar
        

        

        
    
            
  • Page generating time 1.7935 s
    • 
            
  • Memory usage 17 218.91 KB
    • 
                    

        

    

    
    

        

            
Server

            ✖
        

        

        

    


    
    

        

            
Request

            ✖
        

        

        

    


    
    

        

            
Config

            ✖
        

        

        

    


    
    

        

            
SQL

            ✖
        

        

        

    


    
    

        

            
Cache queries

            ✖
        

        

        

    


    
    

        

            
Logging

            ✖
        

        

        

    


    
    

        

            
Templates

            ✖
        

        

        

    


    
    

        

            
Blocks

            ✖