Array
(
[show_master_products_only] =>
[area] => C
[features_hash] => 28-41596
[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 (41596)) 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
(
[31348] => Array
(
[product_id] => 31348
[product] => Egg White Perfect Pore Cleansing Oil - 200ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 718
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => 8809511272935
[hsn_code] => 3304
[status] => A
[list_price] => 1490.00
[amount] => 8
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1686241312
[updated_timestamp] => 1750427156
[usergroup_ids] => 0
[is_edp] => N
[edp_shipping] => N
[unlimited_download] => N
[tracking] => B
[free_shipping] => N
[zero_price_action] => R
[is_pbp] => N
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 5
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] =>
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 894.000000
[short_description] => Removes stubborn makeup & purifies pores
[full_description] => <p>A lightweight cleansing oil that effectively removes stubborn makeup and purifies pores leaving skin feeling fresh and soft. A fresh cleansing oil that neatly removes thick makeup without the stuffiness of oil, while creating smooth skin texture.</p>
[category_ids] => Array
(
[0] => 2120
[1] => 2773
)
[position] => 0
[seo_name] => egg-white-perfect-pore-cleansing-oil-200ml
[seo_path] => 2768/2771/2773
[average_rating] => 4.50
[reviews_count] => 2
[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] => Skinfood
[ratting_count] => 2
)
[25962] => Array
(
[product_id] => 25962
[product] => Tea Treat Kojic Acid and Tea Tree Oil Spot Correction Gel - 30ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 16
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => AULI300
[hsn_code] => 3304
[status] => A
[list_price] => 649.00
[amount] => 863
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1676549389
[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] => 616.550000
[short_description] => Calms redness, Prevent acne
[full_description] => <p>Tea Treat by Auli is a Tea Tree oil and Green Tea induced spot correction gel, known for its numerous benefitsmost popular ones being its anti-inflammatory and anti-mircobial properties. It calms redness, swelling and helps prevent acne, reduces acne scars; leaving you with smooth clear skin. Kojic Acid and Mulberry helps lighten sun damage, age spots and scars. Horseradish and Apple Cider Vinegar treat skin discolourations in a natural way. Green Apple and Vitamin C are rich in antioxidants which help keep your skin elastic and fight off the ageing process.</p>
[category_ids] => Array
(
[0] => 2773
)
[position] => 0
[seo_name] => tea-treat-kojic-acid-and-tea-tree-oil-spot-correction-gel-30ml
[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
(
[1311] => Array
(
[video_id] => 1311
[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/your-daily-dose-of-clear-skin
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1311_44D56517-931D-4E9E-B287-C0EB219A5A6F_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1311_44D56517-931D-4E9E-B287-C0EB219A5A6F.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => Your Daily Dose of Clear Skin
[description] => <p>Say goodbye to stubborn spots with Tea Treat Kojic Acid and Tea Tree Oil Spot Correction Gel! This powerful yet gentle gel targets blemishes and uneven skin tone, leaving your skin clear and bright. Infused with the goodness of kojic acid and tea tree oil, it works wonders on acne-prone skin. Apply a tiny dab, and watch those pesky spots vanish, revealing a smooth, flawless complexion!</p>
[short_description] =>
[privacy] => 1
[like_count] => 0
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] => 20541
[category_id] => 7
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => AULI
)
[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
)
[30980] => Array
(
[product_id] => 30980
[product] => Moringa & Vitamin C Cleansing Oil - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => DSFP1156
[hsn_code] => 3304
[status] => A
[list_price] => 549.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] => 521.550000
[short_description] => Calms irritation & fades dullness
[full_description] => <p>One swipe is all it takes! Pollution causes pigmentation & acne and results in clogged pores & dull skin. Our Moringa & Vitamin C Cleansing Oil is an antioxidant-rich oil-based cleanser that helps break down makeup, SPF & impurities easily while giving the skin a deep, gentle cleanse without stripping it of moisture. Moringa Oil in the formulation calms irritation & inflammation, while Vitamin C fades dullness & brightens for soft & refreshed skin.</p>
[category_ids] => Array
(
[0] => 850
[1] => 1477
[2] => 2773
)
[position] => 0
[seo_name] => moringa-and-vitamin-c-cleansing-oil-50ml
[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
(
[31348] => Array
(
[product_id] => 31348
[product] => Egg White Perfect Pore Cleansing Oil - 200ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 718
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => 8809511272935
[hsn_code] => 3304
[status] => A
[list_price] => 1490.00
[amount] => 8
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1686241312
[updated_timestamp] => 1750427156
[usergroup_ids] => 0
[is_edp] => N
[edp_shipping] => N
[unlimited_download] => N
[tracking] => B
[free_shipping] => N
[zero_price_action] => R
[is_pbp] => N
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 5
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] =>
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 894.000000
[short_description] => Removes stubborn makeup & purifies pores
[full_description] => <p>A lightweight cleansing oil that effectively removes stubborn makeup and purifies pores leaving skin feeling fresh and soft. A fresh cleansing oil that neatly removes thick makeup without the stuffiness of oil, while creating smooth skin texture.</p>
[category_ids] => Array
(
[0] => 2120
[1] => 2773
)
[position] => 0
[seo_name] => egg-white-perfect-pore-cleansing-oil-200ml
[seo_path] => 2768/2771/2773
[average_rating] => 4.50
[reviews_count] => 2
[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] => Skinfood
[ratting_count] => 2
)
[25962] => Array
(
[product_id] => 25962
[product] => Tea Treat Kojic Acid and Tea Tree Oil Spot Correction Gel - 30ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 16
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => AULI300
[hsn_code] => 3304
[status] => A
[list_price] => 649.00
[amount] => 863
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1676549389
[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] => 616.550000
[short_description] => Calms redness, Prevent acne
[full_description] => <p>Tea Treat by Auli is a Tea Tree oil and Green Tea induced spot correction gel, known for its numerous benefitsmost popular ones being its anti-inflammatory and anti-mircobial properties. It calms redness, swelling and helps prevent acne, reduces acne scars; leaving you with smooth clear skin. Kojic Acid and Mulberry helps lighten sun damage, age spots and scars. Horseradish and Apple Cider Vinegar treat skin discolourations in a natural way. Green Apple and Vitamin C are rich in antioxidants which help keep your skin elastic and fight off the ageing process.</p>
[category_ids] => Array
(
[0] => 2773
)
[position] => 0
[seo_name] => tea-treat-kojic-acid-and-tea-tree-oil-spot-correction-gel-30ml
[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
(
[1311] => Array
(
[video_id] => 1311
[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/your-daily-dose-of-clear-skin
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1311_44D56517-931D-4E9E-B287-C0EB219A5A6F_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1311_44D56517-931D-4E9E-B287-C0EB219A5A6F.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => Your Daily Dose of Clear Skin
[description] => <p>Say goodbye to stubborn spots with Tea Treat Kojic Acid and Tea Tree Oil Spot Correction Gel! This powerful yet gentle gel targets blemishes and uneven skin tone, leaving your skin clear and bright. Infused with the goodness of kojic acid and tea tree oil, it works wonders on acne-prone skin. Apply a tiny dab, and watch those pesky spots vanish, revealing a smooth, flawless complexion!</p>
[short_description] =>
[privacy] => 1
[like_count] => 0
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] => 20541
[category_id] => 7
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => AULI
)
[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
)
[30980] => Array
(
[product_id] => 30980
[product] => Moringa & Vitamin C Cleansing Oil - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => DSFP1156
[hsn_code] => 3304
[status] => A
[list_price] => 549.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] => 521.550000
[short_description] => Calms irritation & fades dullness
[full_description] => <p>One swipe is all it takes! Pollution causes pigmentation & acne and results in clogged pores & dull skin. Our Moringa & Vitamin C Cleansing Oil is an antioxidant-rich oil-based cleanser that helps break down makeup, SPF & impurities easily while giving the skin a deep, gentle cleanse without stripping it of moisture. Moringa Oil in the formulation calms irritation & inflammation, while Vitamin C fades dullness & brightens for soft & refreshed skin.</p>
[category_ids] => Array
(
[0] => 850
[1] => 1477
[2] => 2773
)
[position] => 0
[seo_name] => moringa-and-vitamin-c-cleansing-oil-50ml
[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-41596
[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 (41596)) 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
(
[31348] => Array
(
[product_id] => 31348
[product] => Egg White Perfect Pore Cleansing Oil - 200ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 718
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => 8809511272935
[hsn_code] => 3304
[status] => A
[list_price] => 1490.00
[amount] => 8
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1686241312
[updated_timestamp] => 1750427156
[usergroup_ids] => 0
[is_edp] => N
[edp_shipping] => N
[unlimited_download] => N
[tracking] => B
[free_shipping] => N
[zero_price_action] => R
[is_pbp] => N
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 5
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] =>
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 894.000000
[short_description] => Removes stubborn makeup & purifies pores
[full_description] => <p>A lightweight cleansing oil that effectively removes stubborn makeup and purifies pores leaving skin feeling fresh and soft. A fresh cleansing oil that neatly removes thick makeup without the stuffiness of oil, while creating smooth skin texture.</p>
[category_ids] => Array
(
[0] => 2120
[1] => 2773
)
[position] => 0
[seo_name] => egg-white-perfect-pore-cleansing-oil-200ml
[seo_path] => 2768/2771/2773
[average_rating] => 4.50
[reviews_count] => 2
[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] => Skinfood
[ratting_count] => 2
)
[25962] => Array
(
[product_id] => 25962
[product] => Tea Treat Kojic Acid and Tea Tree Oil Spot Correction Gel - 30ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 16
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => AULI300
[hsn_code] => 3304
[status] => A
[list_price] => 649.00
[amount] => 863
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1676549389
[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] => 616.550000
[short_description] => Calms redness, Prevent acne
[full_description] => <p>Tea Treat by Auli is a Tea Tree oil and Green Tea induced spot correction gel, known for its numerous benefitsmost popular ones being its anti-inflammatory and anti-mircobial properties. It calms redness, swelling and helps prevent acne, reduces acne scars; leaving you with smooth clear skin. Kojic Acid and Mulberry helps lighten sun damage, age spots and scars. Horseradish and Apple Cider Vinegar treat skin discolourations in a natural way. Green Apple and Vitamin C are rich in antioxidants which help keep your skin elastic and fight off the ageing process.</p>
[category_ids] => Array
(
[0] => 2773
)
[position] => 0
[seo_name] => tea-treat-kojic-acid-and-tea-tree-oil-spot-correction-gel-30ml
[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
(
[1311] => Array
(
[video_id] => 1311
[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/your-daily-dose-of-clear-skin
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1311_44D56517-931D-4E9E-B287-C0EB219A5A6F_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1311_44D56517-931D-4E9E-B287-C0EB219A5A6F.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => Your Daily Dose of Clear Skin
[description] => <p>Say goodbye to stubborn spots with Tea Treat Kojic Acid and Tea Tree Oil Spot Correction Gel! This powerful yet gentle gel targets blemishes and uneven skin tone, leaving your skin clear and bright. Infused with the goodness of kojic acid and tea tree oil, it works wonders on acne-prone skin. Apply a tiny dab, and watch those pesky spots vanish, revealing a smooth, flawless complexion!</p>
[short_description] =>
[privacy] => 1
[like_count] => 0
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] => 20541
[category_id] => 7
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => AULI
)
[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
)
[30980] => Array
(
[product_id] => 30980
[product] => Moringa & Vitamin C Cleansing Oil - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => DSFP1156
[hsn_code] => 3304
[status] => A
[list_price] => 549.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] => 521.550000
[short_description] => Calms irritation & fades dullness
[full_description] => <p>One swipe is all it takes! Pollution causes pigmentation & acne and results in clogged pores & dull skin. Our Moringa & Vitamin C Cleansing Oil is an antioxidant-rich oil-based cleanser that helps break down makeup, SPF & impurities easily while giving the skin a deep, gentle cleanse without stripping it of moisture. Moringa Oil in the formulation calms irritation & inflammation, while Vitamin C fades dullness & brightens for soft & refreshed skin.</p>
[category_ids] => Array
(
[0] => 850
[1] => 1477
[2] => 2773
)
[position] => 0
[seo_name] => moringa-and-vitamin-c-cleansing-oil-50ml
[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
(
[31348] => Array
(
[product_id] => 31348
[product] => Egg White Perfect Pore Cleansing Oil - 200ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 718
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => 8809511272935
[hsn_code] => 3304
[status] => A
[list_price] => 1490.00
[amount] => 8
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1686241312
[updated_timestamp] => 1750427156
[usergroup_ids] => 0
[is_edp] => N
[edp_shipping] => N
[unlimited_download] => N
[tracking] => B
[free_shipping] => N
[zero_price_action] => R
[is_pbp] => N
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 5
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] =>
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 894.000000
[short_description] => Removes stubborn makeup & purifies pores
[full_description] => <p>A lightweight cleansing oil that effectively removes stubborn makeup and purifies pores leaving skin feeling fresh and soft. A fresh cleansing oil that neatly removes thick makeup without the stuffiness of oil, while creating smooth skin texture.</p>
[category_ids] => Array
(
[0] => 2120
[1] => 2773
)
[position] => 0
[seo_name] => egg-white-perfect-pore-cleansing-oil-200ml
[seo_path] => 2768/2771/2773
[average_rating] => 4.50
[reviews_count] => 2
[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] => Skinfood
[ratting_count] => 2
)
[25962] => Array
(
[product_id] => 25962
[product] => Tea Treat Kojic Acid and Tea Tree Oil Spot Correction Gel - 30ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 16
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => AULI300
[hsn_code] => 3304
[status] => A
[list_price] => 649.00
[amount] => 863
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1676549389
[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] => 616.550000
[short_description] => Calms redness, Prevent acne
[full_description] => <p>Tea Treat by Auli is a Tea Tree oil and Green Tea induced spot correction gel, known for its numerous benefitsmost popular ones being its anti-inflammatory and anti-mircobial properties. It calms redness, swelling and helps prevent acne, reduces acne scars; leaving you with smooth clear skin. Kojic Acid and Mulberry helps lighten sun damage, age spots and scars. Horseradish and Apple Cider Vinegar treat skin discolourations in a natural way. Green Apple and Vitamin C are rich in antioxidants which help keep your skin elastic and fight off the ageing process.</p>
[category_ids] => Array
(
[0] => 2773
)
[position] => 0
[seo_name] => tea-treat-kojic-acid-and-tea-tree-oil-spot-correction-gel-30ml
[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
(
[1311] => Array
(
[video_id] => 1311
[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/your-daily-dose-of-clear-skin
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1311_44D56517-931D-4E9E-B287-C0EB219A5A6F_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1311_44D56517-931D-4E9E-B287-C0EB219A5A6F.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => Your Daily Dose of Clear Skin
[description] => <p>Say goodbye to stubborn spots with Tea Treat Kojic Acid and Tea Tree Oil Spot Correction Gel! This powerful yet gentle gel targets blemishes and uneven skin tone, leaving your skin clear and bright. Infused with the goodness of kojic acid and tea tree oil, it works wonders on acne-prone skin. Apply a tiny dab, and watch those pesky spots vanish, revealing a smooth, flawless complexion!</p>
[short_description] =>
[privacy] => 1
[like_count] => 0
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] => 20541
[category_id] => 7
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => AULI
)
[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
)
[30980] => Array
(
[product_id] => 30980
[product] => Moringa & Vitamin C Cleansing Oil - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => DSFP1156
[hsn_code] => 3304
[status] => A
[list_price] => 549.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] => 521.550000
[short_description] => Calms irritation & fades dullness
[full_description] => <p>One swipe is all it takes! Pollution causes pigmentation & acne and results in clogged pores & dull skin. Our Moringa & Vitamin C Cleansing Oil is an antioxidant-rich oil-based cleanser that helps break down makeup, SPF & impurities easily while giving the skin a deep, gentle cleanse without stripping it of moisture. Moringa Oil in the formulation calms irritation & inflammation, while Vitamin C fades dullness & brightens for soft & refreshed skin.</p>
[category_ids] => Array
(
[0] => 850
[1] => 1477
[2] => 2773
)
[position] => 0
[seo_name] => moringa-and-vitamin-c-cleansing-oil-50ml
[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] => 31348
[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 = 31348 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] => 25962
[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 = 25962 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] => 30980
[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 = 30980 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 |