Array
(
[show_master_products_only] =>
[area] => C
[features_hash] => 28-34250
[sl] => en
[dispatch] => categories.view
[category_id] => 2773
[save_view_results] => product_id
[items_per_page] => 24
[sort_by] => bestsellers
[sort_order] => desc
[cid] => 2773
[extend] => Array
(
[0] => categories
[1] => description
[2] => description
[3] => full_description
)
[subcats] => Y
[runtime_company_id] => 0
)
Array
(
[area] => C
[use_caching] => 1
[extend] => Array
(
[0] => product_name
[1] => prices
[2] => categories
)
[custom_extend] => Array
(
)
[pname] =>
[pshort] =>
[pfull] =>
[pkeywords] =>
[feature] => Array
(
)
[type] => simple
[page] => 1
[action] =>
[filter_variants] => Array
(
)
[features_hash] =>
[limit] => 0
[bid] => 0
[match] =>
[tracking] => Array
(
)
[get_frontend_urls] =>
[items_per_page] => 24
[apply_disabled_filters] =>
[load_products_extra_data] => 1
[storefront] =>
[company_ids] =>
[product_id] =>
)
Advanced and feature filters
before hook
after hook
C
1
before 2nd hook
after 2nd hook
SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products LEFT JOIN ?:product_features_values as var_val_73 ON var_val_73.product_id = products.product_id AND var_val_73.lang_code = 'en' AND var_val_73.feature_id = 73 LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' LEFT JOIN ?:master_products_storefront_offers_count AS master_products_storefront_offers_count ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id WHERE 1 AND (var_val_73.variant_id IN (34250)) AND ?:categories.category_id IN (2773) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.parent_product_id = 0 AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 0, 24
before end of oxn
Array
(
[1320] => Array
(
[product_id] => 1320
[product] => PA+++ Sunscreen Lotion SPF 30 - (100 ml)
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => APSL 100
[hsn_code] => 3304
[status] => A
[list_price] => 495.00
[amount] => 0
[weight] => 100.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1614667416
[updated_timestamp] => 1750246019
[usergroup_ids] => 0
[is_edp] => N
[edp_shipping] => N
[unlimited_download] => N
[tracking] => B
[free_shipping] => N
[zero_price_action] => R
[is_pbp] => Y
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 5
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] => activity
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 470.250000
[short_description] => Broad-spectrum sun protection
[full_description] => <p><span style="color:rgb(12,12,12);"><strong></strong>This product is Dermatologically tested & specially formulated to enhance skin barrier & protect against daily pollution, smog and smoke. It provides protection and nourishment at the same time, this sunscreen spreads easily and protects completely.</span></p><p><span style="color:rgb(12,12,12);"><br /></span></p><p><span style="color:rgb(12,12,12);"><strong>How to Use:</strong></span></p><p><span style="color:rgb(12,12,12);"></span></p><ol><li><span style="color:rgb(12,12,12);">Start right by shaking the tube well.</span></li><li><span style="color:rgb(12,12,12);">Take a generous amount into your palms and apply to face and other parts of the body likely to be exposed to the sun. Massage this well into the skin.</span></li><li><span style="color:rgb(12,12,12);">Sunscreens are most effective when applied 15-30 mins prior to stepping out in the sun. This ensures that the sunscreen is well absorbed into the skin and even if you perspire it is not easily washed off.</span></li><li><span style="color:rgb(12,12,12);">In case you are out for a strenuous game or a swim you should reapply the sunscreen.</span></li></ol>
[category_ids] => Array
(
[0] => 436
[1] => 2773
)
[position] => 0
[seo_name] => pa-sunscreen-lotion-spf-30-100-ml
[seo_path] => 2768/2771/2773
[main_category] => 2773
[options_type_raw] => P
[exceptions_type_raw] => F
[tracking_raw] => B
[zero_price_action_raw] => R
[min_qty_raw] => 0
[max_qty_raw] => 5
[qty_step_raw] => 0
[list_qty_count_raw] => 0
[details_layout_raw] => default
[video_as_images] => Array
(
)
[videos] => Array
(
)
[brand_name] => Detoxie
)
[30973] => Array
(
[product_id] => 30973
[product] => Neem & Salicylic Acid Face Wash - 100gm
[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] => DSFP1140
[hsn_code] => 3304
[status] => A
[list_price] => 299.00
[amount] => 0
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1685172971
[updated_timestamp] => 1750246019
[usergroup_ids] => 0
[is_edp] => N
[edp_shipping] => N
[unlimited_download] => N
[tracking] => B
[free_shipping] => N
[zero_price_action] => R
[is_pbp] => Y
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 5
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] =>
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 284.050000
[short_description] => Deeply nourishes & remove dead skin cells
[full_description] => <p>Dr. Sheths Neem & Salicylic Acid Face Wash is an exfoliating cleanser crafted for sensitive Indian skin, keeping in mind the humid climate and various environmental stressors that may bog the skin down. Enriched with salicylic acid, neem, and tulsi extracts, the formulation dives deep into your pores and unclogs trapped debris while healing inflammation to reveal glowing, fresh skin with every use.</p>
[category_ids] => Array
(
[0] => 2773
)
[position] => 0
[seo_name] => neem-and-salicylic-acid-face-wash-100gm
[seo_path] => 2768/2771/2773
[average_rating] => 4.33
[reviews_count] => 3
[main_category] => 2773
[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
(
[735] => Array
(
[video_id] => 735
[video_type] => C
[company_id] => 13
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1684175400
[status] => A
[user_id] => 146299
[extra_params] =>
[community_video_id] => 763
[community_url] => https://www.kindlife.in/2-indian-brands-that-my-acne-prone-skin-loves
[community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/763/e09ad0633b7d04b6b01abe60cb3f6091.jpg
[community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/763/03edf1fdf4efb05d30873d781fb2acea.mp4
[community_last_sync_timestamp] => 1713162261
[lang_code] => en
[youtube_id] =>
[video] => 2 Indian Brands That My Acne-Prone Skin Loves!
[description] => <p class="MsoNormal" style="margin: 0cm; font-family: 'Times New Roman', serif;"><span style="font-size: 13.5pt; font-family: 'Segoe UI', sans-serif;">Hi everyone, I'm Anuradha and this is my very first video, so be nice, please! :)</span></p>
<p class="MsoNormal" style="margin: 0cm; font-family: 'Times New Roman', serif;"><span style="font-size: 13.5pt; font-family: 'Segoe UI', sans-serif;">I wanted to share a short video about the products from two skincare brands #drsheths and #consciouschemist that have suited my oily, acne-prone, sensitive skin with dermatitis. If our skin type matches, you may want to tey them out for yourself, too. Do read their descriptions, reviews and ratings on #kindlife to know more. All the best on your skin journey :)</span></p>
[short_description] =>
[privacy] => 1
[like_count] => 0
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] =>
[category_id] => 7
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => Dr. Sheth's
[ratting_count] => 3
)
[30981] => Array
(
[product_id] => 30981
[product] => Centella & Niacinamide Oil & Acne Control Sunscreen - 50gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => DSFP1162
[hsn_code] => 3304
[status] => A
[list_price] => 699.00
[amount] => 0
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1685172971
[updated_timestamp] => 1750246019
[usergroup_ids] => 0
[is_edp] => N
[edp_shipping] => N
[unlimited_download] => N
[tracking] => B
[free_shipping] => N
[zero_price_action] => R
[is_pbp] => Y
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 5
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] =>
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 664.050000
[short_description] => Calms irritated & soothes skin
[full_description] => <p>Shade the Sun! Dr. Sheths Centella & Niacinamide Oil & Acne Control Sunscreen is the ultimate sun protection for Oily skin. This water-resistant, silicone gel-based sunscreen has an ultra-matte texture that leaves a velvety dry finish. Active ingredients like 1% Niacinamide in the formulation controls excess sebum production, while Centella Asiatica Extract soothes & calms irritated & inflamed skin.</p>
[category_ids] => Array
(
[0] => 1952
[1] => 2773
)
[position] => 0
[seo_name] => centella-and-niacinamide-oil-and-acne-control-sunscreen-50gm
[seo_path] => 2768/2771/2773
[main_category] => 2773
[options_type_raw] => P
[exceptions_type_raw] => F
[tracking_raw] => B
[zero_price_action_raw] => R
[min_qty_raw] => 0
[max_qty_raw] => 5
[qty_step_raw] => 0
[list_qty_count_raw] => 0
[details_layout_raw] => default
[video_as_images] => Array
(
)
[videos] => Array
(
)
[brand_name] => Dr. Sheth's
)
)
Array
(
[1320] => Array
(
[product_id] => 1320
[product] => PA+++ Sunscreen Lotion SPF 30 - (100 ml)
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => APSL 100
[hsn_code] => 3304
[status] => A
[list_price] => 495.00
[amount] => 0
[weight] => 100.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1614667416
[updated_timestamp] => 1750246019
[usergroup_ids] => 0
[is_edp] => N
[edp_shipping] => N
[unlimited_download] => N
[tracking] => B
[free_shipping] => N
[zero_price_action] => R
[is_pbp] => Y
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 5
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] => activity
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 470.250000
[short_description] => Broad-spectrum sun protection
[full_description] => <p><span style="color:rgb(12,12,12);"><strong></strong>This product is Dermatologically tested & specially formulated to enhance skin barrier & protect against daily pollution, smog and smoke. It provides protection and nourishment at the same time, this sunscreen spreads easily and protects completely.</span></p><p><span style="color:rgb(12,12,12);"><br /></span></p><p><span style="color:rgb(12,12,12);"><strong>How to Use:</strong></span></p><p><span style="color:rgb(12,12,12);"></span></p><ol><li><span style="color:rgb(12,12,12);">Start right by shaking the tube well.</span></li><li><span style="color:rgb(12,12,12);">Take a generous amount into your palms and apply to face and other parts of the body likely to be exposed to the sun. Massage this well into the skin.</span></li><li><span style="color:rgb(12,12,12);">Sunscreens are most effective when applied 15-30 mins prior to stepping out in the sun. This ensures that the sunscreen is well absorbed into the skin and even if you perspire it is not easily washed off.</span></li><li><span style="color:rgb(12,12,12);">In case you are out for a strenuous game or a swim you should reapply the sunscreen.</span></li></ol>
[category_ids] => Array
(
[0] => 436
[1] => 2773
)
[position] => 0
[seo_name] => pa-sunscreen-lotion-spf-30-100-ml
[seo_path] => 2768/2771/2773
[main_category] => 2773
[options_type_raw] => P
[exceptions_type_raw] => F
[tracking_raw] => B
[zero_price_action_raw] => R
[min_qty_raw] => 0
[max_qty_raw] => 5
[qty_step_raw] => 0
[list_qty_count_raw] => 0
[details_layout_raw] => default
[video_as_images] => Array
(
)
[videos] => Array
(
)
[brand_name] => Detoxie
)
[30973] => Array
(
[product_id] => 30973
[product] => Neem & Salicylic Acid Face Wash - 100gm
[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] => DSFP1140
[hsn_code] => 3304
[status] => A
[list_price] => 299.00
[amount] => 0
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1685172971
[updated_timestamp] => 1750246019
[usergroup_ids] => 0
[is_edp] => N
[edp_shipping] => N
[unlimited_download] => N
[tracking] => B
[free_shipping] => N
[zero_price_action] => R
[is_pbp] => Y
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 5
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] =>
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 284.050000
[short_description] => Deeply nourishes & remove dead skin cells
[full_description] => <p>Dr. Sheths Neem & Salicylic Acid Face Wash is an exfoliating cleanser crafted for sensitive Indian skin, keeping in mind the humid climate and various environmental stressors that may bog the skin down. Enriched with salicylic acid, neem, and tulsi extracts, the formulation dives deep into your pores and unclogs trapped debris while healing inflammation to reveal glowing, fresh skin with every use.</p>
[category_ids] => Array
(
[0] => 2773
)
[position] => 0
[seo_name] => neem-and-salicylic-acid-face-wash-100gm
[seo_path] => 2768/2771/2773
[average_rating] => 4.33
[reviews_count] => 3
[main_category] => 2773
[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
(
[735] => Array
(
[video_id] => 735
[video_type] => C
[company_id] => 13
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1684175400
[status] => A
[user_id] => 146299
[extra_params] =>
[community_video_id] => 763
[community_url] => https://www.kindlife.in/2-indian-brands-that-my-acne-prone-skin-loves
[community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/763/e09ad0633b7d04b6b01abe60cb3f6091.jpg
[community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/763/03edf1fdf4efb05d30873d781fb2acea.mp4
[community_last_sync_timestamp] => 1713162261
[lang_code] => en
[youtube_id] =>
[video] => 2 Indian Brands That My Acne-Prone Skin Loves!
[description] => <p class="MsoNormal" style="margin: 0cm; font-family: 'Times New Roman', serif;"><span style="font-size: 13.5pt; font-family: 'Segoe UI', sans-serif;">Hi everyone, I'm Anuradha and this is my very first video, so be nice, please! :)</span></p>
<p class="MsoNormal" style="margin: 0cm; font-family: 'Times New Roman', serif;"><span style="font-size: 13.5pt; font-family: 'Segoe UI', sans-serif;">I wanted to share a short video about the products from two skincare brands #drsheths and #consciouschemist that have suited my oily, acne-prone, sensitive skin with dermatitis. If our skin type matches, you may want to tey them out for yourself, too. Do read their descriptions, reviews and ratings on #kindlife to know more. All the best on your skin journey :)</span></p>
[short_description] =>
[privacy] => 1
[like_count] => 0
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] =>
[category_id] => 7
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => Dr. Sheth's
[ratting_count] => 3
)
[30981] => Array
(
[product_id] => 30981
[product] => Centella & Niacinamide Oil & Acne Control Sunscreen - 50gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => DSFP1162
[hsn_code] => 3304
[status] => A
[list_price] => 699.00
[amount] => 0
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1685172971
[updated_timestamp] => 1750246019
[usergroup_ids] => 0
[is_edp] => N
[edp_shipping] => N
[unlimited_download] => N
[tracking] => B
[free_shipping] => N
[zero_price_action] => R
[is_pbp] => Y
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 5
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] =>
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 664.050000
[short_description] => Calms irritated & soothes skin
[full_description] => <p>Shade the Sun! Dr. Sheths Centella & Niacinamide Oil & Acne Control Sunscreen is the ultimate sun protection for Oily skin. This water-resistant, silicone gel-based sunscreen has an ultra-matte texture that leaves a velvety dry finish. Active ingredients like 1% Niacinamide in the formulation controls excess sebum production, while Centella Asiatica Extract soothes & calms irritated & inflamed skin.</p>
[category_ids] => Array
(
[0] => 1952
[1] => 2773
)
[position] => 0
[seo_name] => centella-and-niacinamide-oil-and-acne-control-sunscreen-50gm
[seo_path] => 2768/2771/2773
[main_category] => 2773
[options_type_raw] => P
[exceptions_type_raw] => F
[tracking_raw] => B
[zero_price_action_raw] => R
[min_qty_raw] => 0
[max_qty_raw] => 5
[qty_step_raw] => 0
[list_qty_count_raw] => 0
[details_layout_raw] => default
[video_as_images] => Array
(
)
[videos] => Array
(
)
[brand_name] => Dr. Sheth's
)
)
end of fxn
Array
(
[show_master_products_only] =>
[area] => C
[features_hash] => 28-34250
[sl] => en
[dispatch] => categories.view
[category_id] => 2773
[save_view_results] => product_id
[items_per_page] => 24
[sort_by] => bestsellers
[sort_order] => desc
[cid] => 2773
[extend] => Array
(
[0] => categories
[1] => description
[2] => description
[3] => full_description
)
[subcats] => Y
[runtime_company_id] => 0
)
Array
(
[area] => C
[use_caching] => 1
[extend] => Array
(
[0] => product_name
[1] => prices
[2] => categories
)
[custom_extend] => Array
(
)
[pname] =>
[pshort] =>
[pfull] =>
[pkeywords] =>
[feature] => Array
(
)
[type] => simple
[page] => 1
[action] =>
[filter_variants] => Array
(
)
[features_hash] =>
[limit] => 0
[bid] => 0
[match] =>
[tracking] => Array
(
)
[get_frontend_urls] =>
[items_per_page] => 24
[apply_disabled_filters] =>
[load_products_extra_data] => 1
[storefront] =>
[company_ids] =>
[product_id] =>
)
Advanced and feature filters
before hook
after hook
C
1
before 2nd hook
after 2nd hook
SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products LEFT JOIN ?:product_features_values as var_val_73 ON var_val_73.product_id = products.product_id AND var_val_73.lang_code = 'en' AND var_val_73.feature_id = 73 LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' LEFT JOIN ?:master_products_storefront_offers_count AS master_products_storefront_offers_count ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id WHERE 1 AND (var_val_73.variant_id IN (34250)) AND ?:categories.category_id IN (2773) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.parent_product_id = 0 AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 0, 24
before end of oxn
Array
(
[1320] => Array
(
[product_id] => 1320
[product] => PA+++ Sunscreen Lotion SPF 30 - (100 ml)
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => APSL 100
[hsn_code] => 3304
[status] => A
[list_price] => 495.00
[amount] => 0
[weight] => 100.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1614667416
[updated_timestamp] => 1750246019
[usergroup_ids] => 0
[is_edp] => N
[edp_shipping] => N
[unlimited_download] => N
[tracking] => B
[free_shipping] => N
[zero_price_action] => R
[is_pbp] => Y
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 5
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] => activity
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 470.250000
[short_description] => Broad-spectrum sun protection
[full_description] => <p><span style="color:rgb(12,12,12);"><strong></strong>This product is Dermatologically tested & specially formulated to enhance skin barrier & protect against daily pollution, smog and smoke. It provides protection and nourishment at the same time, this sunscreen spreads easily and protects completely.</span></p><p><span style="color:rgb(12,12,12);"><br /></span></p><p><span style="color:rgb(12,12,12);"><strong>How to Use:</strong></span></p><p><span style="color:rgb(12,12,12);"></span></p><ol><li><span style="color:rgb(12,12,12);">Start right by shaking the tube well.</span></li><li><span style="color:rgb(12,12,12);">Take a generous amount into your palms and apply to face and other parts of the body likely to be exposed to the sun. Massage this well into the skin.</span></li><li><span style="color:rgb(12,12,12);">Sunscreens are most effective when applied 15-30 mins prior to stepping out in the sun. This ensures that the sunscreen is well absorbed into the skin and even if you perspire it is not easily washed off.</span></li><li><span style="color:rgb(12,12,12);">In case you are out for a strenuous game or a swim you should reapply the sunscreen.</span></li></ol>
[category_ids] => Array
(
[0] => 436
[1] => 2773
)
[position] => 0
[seo_name] => pa-sunscreen-lotion-spf-30-100-ml
[seo_path] => 2768/2771/2773
[main_category] => 2773
[options_type_raw] => P
[exceptions_type_raw] => F
[tracking_raw] => B
[zero_price_action_raw] => R
[min_qty_raw] => 0
[max_qty_raw] => 5
[qty_step_raw] => 0
[list_qty_count_raw] => 0
[details_layout_raw] => default
[video_as_images] => Array
(
)
[videos] => Array
(
)
[brand_name] => Detoxie
)
[30973] => Array
(
[product_id] => 30973
[product] => Neem & Salicylic Acid Face Wash - 100gm
[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] => DSFP1140
[hsn_code] => 3304
[status] => A
[list_price] => 299.00
[amount] => 0
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1685172971
[updated_timestamp] => 1750246019
[usergroup_ids] => 0
[is_edp] => N
[edp_shipping] => N
[unlimited_download] => N
[tracking] => B
[free_shipping] => N
[zero_price_action] => R
[is_pbp] => Y
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 5
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] =>
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 284.050000
[short_description] => Deeply nourishes & remove dead skin cells
[full_description] => <p>Dr. Sheths Neem & Salicylic Acid Face Wash is an exfoliating cleanser crafted for sensitive Indian skin, keeping in mind the humid climate and various environmental stressors that may bog the skin down. Enriched with salicylic acid, neem, and tulsi extracts, the formulation dives deep into your pores and unclogs trapped debris while healing inflammation to reveal glowing, fresh skin with every use.</p>
[category_ids] => Array
(
[0] => 2773
)
[position] => 0
[seo_name] => neem-and-salicylic-acid-face-wash-100gm
[seo_path] => 2768/2771/2773
[average_rating] => 4.33
[reviews_count] => 3
[main_category] => 2773
[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
(
[735] => Array
(
[video_id] => 735
[video_type] => C
[company_id] => 13
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1684175400
[status] => A
[user_id] => 146299
[extra_params] =>
[community_video_id] => 763
[community_url] => https://www.kindlife.in/2-indian-brands-that-my-acne-prone-skin-loves
[community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/763/e09ad0633b7d04b6b01abe60cb3f6091.jpg
[community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/763/03edf1fdf4efb05d30873d781fb2acea.mp4
[community_last_sync_timestamp] => 1713162261
[lang_code] => en
[youtube_id] =>
[video] => 2 Indian Brands That My Acne-Prone Skin Loves!
[description] => <p class="MsoNormal" style="margin: 0cm; font-family: 'Times New Roman', serif;"><span style="font-size: 13.5pt; font-family: 'Segoe UI', sans-serif;">Hi everyone, I'm Anuradha and this is my very first video, so be nice, please! :)</span></p>
<p class="MsoNormal" style="margin: 0cm; font-family: 'Times New Roman', serif;"><span style="font-size: 13.5pt; font-family: 'Segoe UI', sans-serif;">I wanted to share a short video about the products from two skincare brands #drsheths and #consciouschemist that have suited my oily, acne-prone, sensitive skin with dermatitis. If our skin type matches, you may want to tey them out for yourself, too. Do read their descriptions, reviews and ratings on #kindlife to know more. All the best on your skin journey :)</span></p>
[short_description] =>
[privacy] => 1
[like_count] => 0
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] =>
[category_id] => 7
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => Dr. Sheth's
[ratting_count] => 3
)
[30981] => Array
(
[product_id] => 30981
[product] => Centella & Niacinamide Oil & Acne Control Sunscreen - 50gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => DSFP1162
[hsn_code] => 3304
[status] => A
[list_price] => 699.00
[amount] => 0
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1685172971
[updated_timestamp] => 1750246019
[usergroup_ids] => 0
[is_edp] => N
[edp_shipping] => N
[unlimited_download] => N
[tracking] => B
[free_shipping] => N
[zero_price_action] => R
[is_pbp] => Y
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 5
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] =>
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 664.050000
[short_description] => Calms irritated & soothes skin
[full_description] => <p>Shade the Sun! Dr. Sheths Centella & Niacinamide Oil & Acne Control Sunscreen is the ultimate sun protection for Oily skin. This water-resistant, silicone gel-based sunscreen has an ultra-matte texture that leaves a velvety dry finish. Active ingredients like 1% Niacinamide in the formulation controls excess sebum production, while Centella Asiatica Extract soothes & calms irritated & inflamed skin.</p>
[category_ids] => Array
(
[0] => 1952
[1] => 2773
)
[position] => 0
[seo_name] => centella-and-niacinamide-oil-and-acne-control-sunscreen-50gm
[seo_path] => 2768/2771/2773
[main_category] => 2773
[options_type_raw] => P
[exceptions_type_raw] => F
[tracking_raw] => B
[zero_price_action_raw] => R
[min_qty_raw] => 0
[max_qty_raw] => 5
[qty_step_raw] => 0
[list_qty_count_raw] => 0
[details_layout_raw] => default
[video_as_images] => Array
(
)
[videos] => Array
(
)
[brand_name] => Dr. Sheth's
)
)
Array
(
[1320] => Array
(
[product_id] => 1320
[product] => PA+++ Sunscreen Lotion SPF 30 - (100 ml)
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => APSL 100
[hsn_code] => 3304
[status] => A
[list_price] => 495.00
[amount] => 0
[weight] => 100.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1614667416
[updated_timestamp] => 1750246019
[usergroup_ids] => 0
[is_edp] => N
[edp_shipping] => N
[unlimited_download] => N
[tracking] => B
[free_shipping] => N
[zero_price_action] => R
[is_pbp] => Y
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 5
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] => activity
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 470.250000
[short_description] => Broad-spectrum sun protection
[full_description] => <p><span style="color:rgb(12,12,12);"><strong></strong>This product is Dermatologically tested & specially formulated to enhance skin barrier & protect against daily pollution, smog and smoke. It provides protection and nourishment at the same time, this sunscreen spreads easily and protects completely.</span></p><p><span style="color:rgb(12,12,12);"><br /></span></p><p><span style="color:rgb(12,12,12);"><strong>How to Use:</strong></span></p><p><span style="color:rgb(12,12,12);"></span></p><ol><li><span style="color:rgb(12,12,12);">Start right by shaking the tube well.</span></li><li><span style="color:rgb(12,12,12);">Take a generous amount into your palms and apply to face and other parts of the body likely to be exposed to the sun. Massage this well into the skin.</span></li><li><span style="color:rgb(12,12,12);">Sunscreens are most effective when applied 15-30 mins prior to stepping out in the sun. This ensures that the sunscreen is well absorbed into the skin and even if you perspire it is not easily washed off.</span></li><li><span style="color:rgb(12,12,12);">In case you are out for a strenuous game or a swim you should reapply the sunscreen.</span></li></ol>
[category_ids] => Array
(
[0] => 436
[1] => 2773
)
[position] => 0
[seo_name] => pa-sunscreen-lotion-spf-30-100-ml
[seo_path] => 2768/2771/2773
[main_category] => 2773
[options_type_raw] => P
[exceptions_type_raw] => F
[tracking_raw] => B
[zero_price_action_raw] => R
[min_qty_raw] => 0
[max_qty_raw] => 5
[qty_step_raw] => 0
[list_qty_count_raw] => 0
[details_layout_raw] => default
[video_as_images] => Array
(
)
[videos] => Array
(
)
[brand_name] => Detoxie
)
[30973] => Array
(
[product_id] => 30973
[product] => Neem & Salicylic Acid Face Wash - 100gm
[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] => DSFP1140
[hsn_code] => 3304
[status] => A
[list_price] => 299.00
[amount] => 0
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1685172971
[updated_timestamp] => 1750246019
[usergroup_ids] => 0
[is_edp] => N
[edp_shipping] => N
[unlimited_download] => N
[tracking] => B
[free_shipping] => N
[zero_price_action] => R
[is_pbp] => Y
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 5
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] =>
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 284.050000
[short_description] => Deeply nourishes & remove dead skin cells
[full_description] => <p>Dr. Sheths Neem & Salicylic Acid Face Wash is an exfoliating cleanser crafted for sensitive Indian skin, keeping in mind the humid climate and various environmental stressors that may bog the skin down. Enriched with salicylic acid, neem, and tulsi extracts, the formulation dives deep into your pores and unclogs trapped debris while healing inflammation to reveal glowing, fresh skin with every use.</p>
[category_ids] => Array
(
[0] => 2773
)
[position] => 0
[seo_name] => neem-and-salicylic-acid-face-wash-100gm
[seo_path] => 2768/2771/2773
[average_rating] => 4.33
[reviews_count] => 3
[main_category] => 2773
[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
(
[735] => Array
(
[video_id] => 735
[video_type] => C
[company_id] => 13
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1684175400
[status] => A
[user_id] => 146299
[extra_params] =>
[community_video_id] => 763
[community_url] => https://www.kindlife.in/2-indian-brands-that-my-acne-prone-skin-loves
[community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/763/e09ad0633b7d04b6b01abe60cb3f6091.jpg
[community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/763/03edf1fdf4efb05d30873d781fb2acea.mp4
[community_last_sync_timestamp] => 1713162261
[lang_code] => en
[youtube_id] =>
[video] => 2 Indian Brands That My Acne-Prone Skin Loves!
[description] => <p class="MsoNormal" style="margin: 0cm; font-family: 'Times New Roman', serif;"><span style="font-size: 13.5pt; font-family: 'Segoe UI', sans-serif;">Hi everyone, I'm Anuradha and this is my very first video, so be nice, please! :)</span></p>
<p class="MsoNormal" style="margin: 0cm; font-family: 'Times New Roman', serif;"><span style="font-size: 13.5pt; font-family: 'Segoe UI', sans-serif;">I wanted to share a short video about the products from two skincare brands #drsheths and #consciouschemist that have suited my oily, acne-prone, sensitive skin with dermatitis. If our skin type matches, you may want to tey them out for yourself, too. Do read their descriptions, reviews and ratings on #kindlife to know more. All the best on your skin journey :)</span></p>
[short_description] =>
[privacy] => 1
[like_count] => 0
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] =>
[category_id] => 7
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => Dr. Sheth's
[ratting_count] => 3
)
[30981] => Array
(
[product_id] => 30981
[product] => Centella & Niacinamide Oil & Acne Control Sunscreen - 50gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => DSFP1162
[hsn_code] => 3304
[status] => A
[list_price] => 699.00
[amount] => 0
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1685172971
[updated_timestamp] => 1750246019
[usergroup_ids] => 0
[is_edp] => N
[edp_shipping] => N
[unlimited_download] => N
[tracking] => B
[free_shipping] => N
[zero_price_action] => R
[is_pbp] => Y
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 5
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] =>
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 664.050000
[short_description] => Calms irritated & soothes skin
[full_description] => <p>Shade the Sun! Dr. Sheths Centella & Niacinamide Oil & Acne Control Sunscreen is the ultimate sun protection for Oily skin. This water-resistant, silicone gel-based sunscreen has an ultra-matte texture that leaves a velvety dry finish. Active ingredients like 1% Niacinamide in the formulation controls excess sebum production, while Centella Asiatica Extract soothes & calms irritated & inflamed skin.</p>
[category_ids] => Array
(
[0] => 1952
[1] => 2773
)
[position] => 0
[seo_name] => centella-and-niacinamide-oil-and-acne-control-sunscreen-50gm
[seo_path] => 2768/2771/2773
[main_category] => 2773
[options_type_raw] => P
[exceptions_type_raw] => F
[tracking_raw] => B
[zero_price_action_raw] => R
[min_qty_raw] => 0
[max_qty_raw] => 5
[qty_step_raw] => 0
[list_qty_count_raw] => 0
[details_layout_raw] => default
[video_as_images] => Array
(
)
[videos] => Array
(
)
[brand_name] => Dr. Sheth's
)
)
end of fxn
Array
(
[show_master_products_only] =>
[area] => C
[for_required_product] => 1320
[include_child_variations] => 1
[group_child_variations] =>
[runtime_company_id] => 0
)
Array
(
[area] => C
[use_caching] => 1
[extend] => Array
(
[0] => product_name
[1] => prices
[2] => categories
)
[custom_extend] => Array
(
)
[pname] =>
[pshort] =>
[pfull] =>
[pkeywords] =>
[feature] => Array
(
)
[type] => simple
[page] => 1
[action] =>
[filter_variants] => Array
(
)
[features_hash] =>
[limit] => 0
[bid] => 0
[match] =>
[tracking] => Array
(
)
[get_frontend_urls] =>
[items_per_page] => 0
[apply_disabled_filters] =>
[load_products_extra_data] => 1
[storefront] =>
[company_ids] =>
[product_id] =>
)
Advanced and feature filters
before hook
after hook
C
1
before 2nd hook
after 2nd hook
SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' LEFT JOIN ?:master_products_storefront_offers_count AS master_products_storefront_offers_count ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id LEFT JOIN ?:product_required_products ON products.product_id = ?:product_required_products.required_id WHERE 1 AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) AND ?:product_required_products.product_id = 1320 GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC
before end of oxn
Array ( )
Array ( )
end of fxn
Array
(
[show_master_products_only] =>
[area] => C
[for_required_product] => 30973
[include_child_variations] => 1
[group_child_variations] =>
[runtime_company_id] => 0
)
Array
(
[area] => C
[use_caching] => 1
[extend] => Array
(
[0] => product_name
[1] => prices
[2] => categories
)
[custom_extend] => Array
(
)
[pname] =>
[pshort] =>
[pfull] =>
[pkeywords] =>
[feature] => Array
(
)
[type] => simple
[page] => 1
[action] =>
[filter_variants] => Array
(
)
[features_hash] =>
[limit] => 0
[bid] => 0
[match] =>
[tracking] => Array
(
)
[get_frontend_urls] =>
[items_per_page] => 0
[apply_disabled_filters] =>
[load_products_extra_data] => 1
[storefront] =>
[company_ids] =>
[product_id] =>
)
Advanced and feature filters
before hook
after hook
C
1
before 2nd hook
after 2nd hook
SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' LEFT JOIN ?:master_products_storefront_offers_count AS master_products_storefront_offers_count ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id LEFT JOIN ?:product_required_products ON products.product_id = ?:product_required_products.required_id WHERE 1 AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) AND ?:product_required_products.product_id = 30973 GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC
before end of oxn
Array ( )
Array ( )
end of fxn
Array
(
[show_master_products_only] =>
[area] => C
[for_required_product] => 30981
[include_child_variations] => 1
[group_child_variations] =>
[runtime_company_id] => 0
)
Array
(
[area] => C
[use_caching] => 1
[extend] => Array
(
[0] => product_name
[1] => prices
[2] => categories
)
[custom_extend] => Array
(
)
[pname] =>
[pshort] =>
[pfull] =>
[pkeywords] =>
[feature] => Array
(
)
[type] => simple
[page] => 1
[action] =>
[filter_variants] => Array
(
)
[features_hash] =>
[limit] => 0
[bid] => 0
[match] =>
[tracking] => Array
(
)
[get_frontend_urls] =>
[items_per_page] => 0
[apply_disabled_filters] =>
[load_products_extra_data] => 1
[storefront] =>
[company_ids] =>
[product_id] =>
)
Advanced and feature filters
before hook
after hook
C
1
before 2nd hook
after 2nd hook
SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' LEFT JOIN ?:master_products_storefront_offers_count AS master_products_storefront_offers_count ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id LEFT JOIN ?:product_required_products ON products.product_id = ?:product_required_products.required_id WHERE 1 AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) AND ?:product_required_products.product_id = 30981 GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC
before end of oxn
Array ( )
Array ( )
end of fxn
Cannot create references to/from string offsets
app/Tygh/Registry.php, line: 221
| File: | app/Tygh/Registry.php |
| Line: | 89 |
| Function: | _varByKey |
| File: | app/addons/seo/Tygh/SeoCache.php |
| Line: | 111 |
| Function: | set |
| File: | app/addons/seo/Tygh/SeoCache.php |
| Line: | 49 |
| Function: | setStatic |
| File: | app/addons/seo/func.php |
| Line: | 1329 |
| Function: | set |
| File: | app/addons/seo/func.php |
| Line: | 1563 |
| Function: | fn_seo_get_name |
| File: | app/functions/fn.control.php |
| Line: | 123 |
| Function: | fn_seo_url_post |
| File: | app/functions/fn.common.php |
| Line: | 3921 |
| Function: | fn_set_hook |
| File: | app/Tygh/BlockManager/Container.php |
| Line: | 496 |
| Function: | fn_url |
| File: | app/Tygh/BlockManager/Container.php |
| Line: | 517 |
| Function: | getConfigurationUrl |
| File: | app/Tygh/BlockManager/Container.php |
| Line: | 120 |
| Function: | addBlockManagerProperties |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 127 |
| Function: | getListByArea |
| File: | app/functions/smarty_plugins/function.render_location.php |
| Line: | 50 |
| Function: | __construct |
| File: | var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php |
| Line: | 191 |
| Function: | smarty_function_render_location |
| File: | app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php |
| Line: | 188 |
| Function: | content_689464c1dbc0b1_26812820 |
| File: | app/Tygh/SmartyEngine/Core.php |
| Line: | 81 |
| Function: | fetch |
| File: | app/functions/fn.control.php |
| Line: | 636 |
| Function: | fetch |
| File: | index.php |
| Line: | 39 |
| Function: | fn_dispatch |