Array
(
[show_master_products_only] =>
[area] => C
[currency] => INR
[items_per_page] => 12
[sort_order] => desc
[sl] => en
[dispatch] => product_features.view
[variant_id] => 52019
[save_view_results] => product_id
[extend] => Array
(
[0] => description
)
[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 INNER JOIN ?:product_features_values as c_var ON c_var.product_id = products.product_id AND c_var.lang_code = 'en' AND c_var.variant_id = 52019 LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' LEFT JOIN ?:master_products_storefront_offers_count AS master_products_storefront_offers_count ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id WHERE 1 AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.parent_product_id = 0 AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 0, 12
before end of oxn
Array
(
[16305] => Array
(
[product_id] => 16305
[product] => Roasted & Salted Pumpkin Seeds - 250 g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 346
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => PumpkinSeeds_bottle_250g
[hsn_code] => 3304
[status] => A
[list_price] => 385.00
[amount] => 195
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1661332182
[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] => 227.150000
[short_description] => Rich in nutrients & 100% natural
[full_description] =>
[category_ids] => Array
(
[0] => 2648
)
[seo_name] => roasted-and-salted-pumpkin-seeds-250-g
[seo_path] => 458/2646/2648
[average_rating] => 4.00
[reviews_count] => 1
[main_category] => 2648
[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] => Ambrosia
[ratting_count] => 1
)
[6763] => Array
(
[product_id] => 6763
[product] => Pumpkin Seeds 150g | Rich in Zinc & Magnesium
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 42
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => Premium_Pumpkin_32
[hsn_code] => 3304
[status] => A
[list_price] => 249.00
[amount] => 75
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1644423039
[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] => 180.000000
[short_description] => Sunflower seeds are a great snack for your hunger pangs
[full_description] =>
[category_ids] => Array
(
[0] => 2648
)
[seo_name] => premium-pumpkin-seeds-150-g
[seo_path] => 458/2646/2648
[average_rating] => 5.00
[reviews_count] => 1
[main_category] => 2648
[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
(
[414] => Array
(
[video_id] => 414
[video_type] => C
[company_id] => 13
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1681669800
[status] => A
[user_id] => 21551
[extra_params] =>
[community_video_id] => 398
[community_url] => https://www.kindlife.in/looking-for-healthy-snacking-choices
[community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/398/f0ae19d3f7141fa4bdbc2d4f9ebb834f.jpg
[community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/398/03cdda9bae17eedb1317d4953b1d287b.mp4
[community_last_sync_timestamp] => 1713161298
[lang_code] => en
[youtube_id] =>
[video] => Looking for Healthy Snacking Choices? Here's the best ones for you!
[description] => <p><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">Nuts and seeds are good sources of protein, healthy fats, fibres, vitamins, and minerals. Nuts and seeds regulate body weight as their fats are not fully absorbed, they regulate food intake, and help burn energy. It lower your LDL or "bad" cholesterol and triglyceride levels. Nuts and seeds are good sources of skin-boosting nutrients. They also nourish the scalp promoting hair growth and are also anti-ageing. Loaded with antioxidants. They help lowering the risk of lifestyle diseases.</span><br style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">Add them to you smoothies, salads, cakes or make crackers and energy balls or just have them on it's own as a snack.</span><br style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br></span></p>
[short_description] =>
[privacy] => 1
[like_count] => 2
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] =>
[category_id] => 24
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => Flyberry Gourmet
[ratting_count] => 1
)
[10005] => Array
(
[product_id] => 10005
[product] => Pumpkin Seed Oil Soft Gel - 60 Capsule
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 203
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => NUTPMKOILCP60
[hsn_code] => 3304
[status] => A
[list_price] => 551.00
[amount] => 49
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1650354387
[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] => 523.450000
[short_description] => Full of Vitamin-C & great for immunity
[full_description] =>
[category_ids] => Array
(
[0] => 2672
)
[seo_name] => pumpkin-seed-oil-soft-gel-60-capsule
[seo_path] => 2669/2670/2672
[main_category] => 2672
[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] => Nutriorg
)
)
Array
(
[16305] => Array
(
[product_id] => 16305
[product] => Roasted & Salted Pumpkin Seeds - 250 g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 346
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => PumpkinSeeds_bottle_250g
[hsn_code] => 3304
[status] => A
[list_price] => 385.00
[amount] => 195
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1661332182
[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] => 227.150000
[short_description] => Rich in nutrients & 100% natural
[full_description] =>
[category_ids] => Array
(
[0] => 2648
)
[seo_name] => roasted-and-salted-pumpkin-seeds-250-g
[seo_path] => 458/2646/2648
[average_rating] => 4.00
[reviews_count] => 1
[main_category] => 2648
[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] => Ambrosia
[ratting_count] => 1
)
[6763] => Array
(
[product_id] => 6763
[product] => Pumpkin Seeds 150g | Rich in Zinc & Magnesium
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 42
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => Premium_Pumpkin_32
[hsn_code] => 3304
[status] => A
[list_price] => 249.00
[amount] => 75
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1644423039
[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] => 180.000000
[short_description] => Sunflower seeds are a great snack for your hunger pangs
[full_description] =>
[category_ids] => Array
(
[0] => 2648
)
[seo_name] => premium-pumpkin-seeds-150-g
[seo_path] => 458/2646/2648
[average_rating] => 5.00
[reviews_count] => 1
[main_category] => 2648
[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
(
[414] => Array
(
[video_id] => 414
[video_type] => C
[company_id] => 13
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1681669800
[status] => A
[user_id] => 21551
[extra_params] =>
[community_video_id] => 398
[community_url] => https://www.kindlife.in/looking-for-healthy-snacking-choices
[community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/398/f0ae19d3f7141fa4bdbc2d4f9ebb834f.jpg
[community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/398/03cdda9bae17eedb1317d4953b1d287b.mp4
[community_last_sync_timestamp] => 1713161298
[lang_code] => en
[youtube_id] =>
[video] => Looking for Healthy Snacking Choices? Here's the best ones for you!
[description] => <p><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">Nuts and seeds are good sources of protein, healthy fats, fibres, vitamins, and minerals. Nuts and seeds regulate body weight as their fats are not fully absorbed, they regulate food intake, and help burn energy. It lower your LDL or "bad" cholesterol and triglyceride levels. Nuts and seeds are good sources of skin-boosting nutrients. They also nourish the scalp promoting hair growth and are also anti-ageing. Loaded with antioxidants. They help lowering the risk of lifestyle diseases.</span><br style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">Add them to you smoothies, salads, cakes or make crackers and energy balls or just have them on it's own as a snack.</span><br style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br></span></p>
[short_description] =>
[privacy] => 1
[like_count] => 2
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] =>
[category_id] => 24
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => Flyberry Gourmet
[ratting_count] => 1
)
[10005] => Array
(
[product_id] => 10005
[product] => Pumpkin Seed Oil Soft Gel - 60 Capsule
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 203
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => NUTPMKOILCP60
[hsn_code] => 3304
[status] => A
[list_price] => 551.00
[amount] => 49
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1650354387
[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] => 523.450000
[short_description] => Full of Vitamin-C & great for immunity
[full_description] =>
[category_ids] => Array
(
[0] => 2672
)
[seo_name] => pumpkin-seed-oil-soft-gel-60-capsule
[seo_path] => 2669/2670/2672
[main_category] => 2672
[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] => Nutriorg
)
)
end of fxn
Array
(
[show_master_products_only] =>
[area] => C
[custom_extend] => Array
(
[0] => product_name
[1] => categories
)
[group_child_variations] =>
[include_child_variations] => 1
[skip_rating] => 1
[load_products_extra_data] =>
[sort_by] => null
[variation_group_id] => Array
(
[589] => 589
[434] => 434
)
[get_amount] => 1
[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, products.amount, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, variation_group_products.group_id AS variation_group_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' INNER JOIN ?:product_variation_group_products AS variation_group_products ON variation_group_products.product_id = products.product_id 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 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 variation_group_products.group_id IN (589, 434) 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 NULL asc
before end of oxn
Array
(
[6764] => Array
(
[product_id] => 6764
[amount] => 75
[product] => Sunflower Seeds, 150g| Reduces Cholestrol | Helps Manage Diabetes
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 42
[variation_group_id] => 434
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[video_as_images] => Array
(
)
[videos] => Array
(
[414] => Array
(
[video_id] => 414
[video_type] => C
[company_id] => 13
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1681669800
[status] => A
[user_id] => 21551
[extra_params] =>
[community_video_id] => 398
[community_url] => https://www.kindlife.in/looking-for-healthy-snacking-choices
[community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/398/f0ae19d3f7141fa4bdbc2d4f9ebb834f.jpg
[community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/398/03cdda9bae17eedb1317d4953b1d287b.mp4
[community_last_sync_timestamp] => 1713161298
[lang_code] => en
[youtube_id] =>
[video] => Looking for Healthy Snacking Choices? Here's the best ones for you!
[description] => <p><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">Nuts and seeds are good sources of protein, healthy fats, fibres, vitamins, and minerals. Nuts and seeds regulate body weight as their fats are not fully absorbed, they regulate food intake, and help burn energy. It lower your LDL or "bad" cholesterol and triglyceride levels. Nuts and seeds are good sources of skin-boosting nutrients. They also nourish the scalp promoting hair growth and are also anti-ageing. Loaded with antioxidants. They help lowering the risk of lifestyle diseases.</span><br style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">Add them to you smoothies, salads, cakes or make crackers and energy balls or just have them on it's own as a snack.</span><br style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br></span></p>
[short_description] =>
[privacy] => 1
[like_count] => 2
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] =>
[category_id] => 24
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => Flyberry Gourmet
)
[6763] => Array
(
[product_id] => 6763
[amount] => 75
[product] => Pumpkin Seeds 150g | Rich in Zinc & Magnesium
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 42
[variation_group_id] => 434
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[video_as_images] => Array
(
)
[videos] => Array
(
[414] => Array
(
[video_id] => 414
[video_type] => C
[company_id] => 13
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1681669800
[status] => A
[user_id] => 21551
[extra_params] =>
[community_video_id] => 398
[community_url] => https://www.kindlife.in/looking-for-healthy-snacking-choices
[community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/398/f0ae19d3f7141fa4bdbc2d4f9ebb834f.jpg
[community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/398/03cdda9bae17eedb1317d4953b1d287b.mp4
[community_last_sync_timestamp] => 1713161298
[lang_code] => en
[youtube_id] =>
[video] => Looking for Healthy Snacking Choices? Here's the best ones for you!
[description] => <p><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">Nuts and seeds are good sources of protein, healthy fats, fibres, vitamins, and minerals. Nuts and seeds regulate body weight as their fats are not fully absorbed, they regulate food intake, and help burn energy. It lower your LDL or "bad" cholesterol and triglyceride levels. Nuts and seeds are good sources of skin-boosting nutrients. They also nourish the scalp promoting hair growth and are also anti-ageing. Loaded with antioxidants. They help lowering the risk of lifestyle diseases.</span><br style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">Add them to you smoothies, salads, cakes or make crackers and energy balls or just have them on it's own as a snack.</span><br style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br></span></p>
[short_description] =>
[privacy] => 1
[like_count] => 2
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] =>
[category_id] => 24
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => Flyberry Gourmet
)
[16305] => Array
(
[product_id] => 16305
[amount] => 195
[product] => Roasted & Salted Pumpkin Seeds - 250 g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 346
[variation_group_id] => 589
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[video_as_images] => Array
(
)
[videos] => Array
(
)
[brand_name] => Ambrosia
)
[16306] => Array
(
[product_id] => 16306
[amount] => 184
[product] => Premium Sunflower Seeds - 250 g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 346
[variation_group_id] => 589
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[video_as_images] => Array
(
)
[videos] => Array
(
)
[brand_name] => Ambrosia
)
[16307] => Array
(
[product_id] => 16307
[amount] => 195
[product] => Raw Flax Seeds - 250 g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 346
[variation_group_id] => 589
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[video_as_images] => Array
(
)
[videos] => Array
(
)
[brand_name] => Ambrosia
)
[16308] => Array
(
[product_id] => 16308
[amount] => 35
[product] => Raw Unroasted Chia Seeds - 250 g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 346
[variation_group_id] => 589
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[video_as_images] => Array
(
)
[videos] => Array
(
)
[brand_name] => Ambrosia
)
)
Array
(
[6764] => Array
(
[product_id] => 6764
[amount] => 75
[product] => Sunflower Seeds, 150g| Reduces Cholestrol | Helps Manage Diabetes
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 42
[variation_group_id] => 434
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[video_as_images] => Array
(
)
[videos] => Array
(
[414] => Array
(
[video_id] => 414
[video_type] => C
[company_id] => 13
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1681669800
[status] => A
[user_id] => 21551
[extra_params] =>
[community_video_id] => 398
[community_url] => https://www.kindlife.in/looking-for-healthy-snacking-choices
[community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/398/f0ae19d3f7141fa4bdbc2d4f9ebb834f.jpg
[community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/398/03cdda9bae17eedb1317d4953b1d287b.mp4
[community_last_sync_timestamp] => 1713161298
[lang_code] => en
[youtube_id] =>
[video] => Looking for Healthy Snacking Choices? Here's the best ones for you!
[description] => <p><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">Nuts and seeds are good sources of protein, healthy fats, fibres, vitamins, and minerals. Nuts and seeds regulate body weight as their fats are not fully absorbed, they regulate food intake, and help burn energy. It lower your LDL or "bad" cholesterol and triglyceride levels. Nuts and seeds are good sources of skin-boosting nutrients. They also nourish the scalp promoting hair growth and are also anti-ageing. Loaded with antioxidants. They help lowering the risk of lifestyle diseases.</span><br style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">Add them to you smoothies, salads, cakes or make crackers and energy balls or just have them on it's own as a snack.</span><br style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br></span></p>
[short_description] =>
[privacy] => 1
[like_count] => 2
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] =>
[category_id] => 24
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => Flyberry Gourmet
)
[6763] => Array
(
[product_id] => 6763
[amount] => 75
[product] => Pumpkin Seeds 150g | Rich in Zinc & Magnesium
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 42
[variation_group_id] => 434
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[video_as_images] => Array
(
)
[videos] => Array
(
[414] => Array
(
[video_id] => 414
[video_type] => C
[company_id] => 13
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1681669800
[status] => A
[user_id] => 21551
[extra_params] =>
[community_video_id] => 398
[community_url] => https://www.kindlife.in/looking-for-healthy-snacking-choices
[community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/398/f0ae19d3f7141fa4bdbc2d4f9ebb834f.jpg
[community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/398/03cdda9bae17eedb1317d4953b1d287b.mp4
[community_last_sync_timestamp] => 1713161298
[lang_code] => en
[youtube_id] =>
[video] => Looking for Healthy Snacking Choices? Here's the best ones for you!
[description] => <p><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">Nuts and seeds are good sources of protein, healthy fats, fibres, vitamins, and minerals. Nuts and seeds regulate body weight as their fats are not fully absorbed, they regulate food intake, and help burn energy. It lower your LDL or "bad" cholesterol and triglyceride levels. Nuts and seeds are good sources of skin-boosting nutrients. They also nourish the scalp promoting hair growth and are also anti-ageing. Loaded with antioxidants. They help lowering the risk of lifestyle diseases.</span><br style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">Add them to you smoothies, salads, cakes or make crackers and energy balls or just have them on it's own as a snack.</span><br style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br></span></p>
[short_description] =>
[privacy] => 1
[like_count] => 2
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] =>
[category_id] => 24
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => Flyberry Gourmet
)
[16305] => Array
(
[product_id] => 16305
[amount] => 195
[product] => Roasted & Salted Pumpkin Seeds - 250 g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 346
[variation_group_id] => 589
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[video_as_images] => Array
(
)
[videos] => Array
(
)
[brand_name] => Ambrosia
)
[16306] => Array
(
[product_id] => 16306
[amount] => 184
[product] => Premium Sunflower Seeds - 250 g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 346
[variation_group_id] => 589
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[video_as_images] => Array
(
)
[videos] => Array
(
)
[brand_name] => Ambrosia
)
[16307] => Array
(
[product_id] => 16307
[amount] => 195
[product] => Raw Flax Seeds - 250 g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 346
[variation_group_id] => 589
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[video_as_images] => Array
(
)
[videos] => Array
(
)
[brand_name] => Ambrosia
)
[16308] => Array
(
[product_id] => 16308
[amount] => 35
[product] => Raw Unroasted Chia Seeds - 250 g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 346
[variation_group_id] => 589
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[video_as_images] => Array
(
)
[videos] => Array
(
)
[brand_name] => Ambrosia
)
)
end of fxn
Array
(
[show_master_products_only] =>
[area] => C
[currency] => INR
[items_per_page] => 12
[sort_order] => desc
[sl] => en
[dispatch] => product_features.view
[variant_id] => 52019
[save_view_results] => product_id
[extend] => Array
(
[0] => description
)
[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 INNER JOIN ?:product_features_values as c_var ON c_var.product_id = products.product_id AND c_var.lang_code = 'en' AND c_var.variant_id = 52019 LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' LEFT JOIN ?:master_products_storefront_offers_count AS master_products_storefront_offers_count ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id WHERE 1 AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.parent_product_id = 0 AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 0, 12
before end of oxn
Array
(
[16305] => Array
(
[product_id] => 16305
[product] => Roasted & Salted Pumpkin Seeds - 250 g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 346
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => PumpkinSeeds_bottle_250g
[hsn_code] => 3304
[status] => A
[list_price] => 385.00
[amount] => 195
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1661332182
[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] => 227.150000
[short_description] => Rich in nutrients & 100% natural
[full_description] =>
[category_ids] => Array
(
[0] => 2648
)
[seo_name] => roasted-and-salted-pumpkin-seeds-250-g
[seo_path] => 458/2646/2648
[average_rating] => 4.00
[reviews_count] => 1
[main_category] => 2648
[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] => Ambrosia
[ratting_count] => 1
)
[6763] => Array
(
[product_id] => 6763
[product] => Pumpkin Seeds 150g | Rich in Zinc & Magnesium
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 42
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => Premium_Pumpkin_32
[hsn_code] => 3304
[status] => A
[list_price] => 249.00
[amount] => 75
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1644423039
[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] => 180.000000
[short_description] => Sunflower seeds are a great snack for your hunger pangs
[full_description] =>
[category_ids] => Array
(
[0] => 2648
)
[seo_name] => premium-pumpkin-seeds-150-g
[seo_path] => 458/2646/2648
[average_rating] => 5.00
[reviews_count] => 1
[main_category] => 2648
[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
(
[414] => Array
(
[video_id] => 414
[video_type] => C
[company_id] => 13
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1681669800
[status] => A
[user_id] => 21551
[extra_params] =>
[community_video_id] => 398
[community_url] => https://www.kindlife.in/looking-for-healthy-snacking-choices
[community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/398/f0ae19d3f7141fa4bdbc2d4f9ebb834f.jpg
[community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/398/03cdda9bae17eedb1317d4953b1d287b.mp4
[community_last_sync_timestamp] => 1713161298
[lang_code] => en
[youtube_id] =>
[video] => Looking for Healthy Snacking Choices? Here's the best ones for you!
[description] => <p><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">Nuts and seeds are good sources of protein, healthy fats, fibres, vitamins, and minerals. Nuts and seeds regulate body weight as their fats are not fully absorbed, they regulate food intake, and help burn energy. It lower your LDL or "bad" cholesterol and triglyceride levels. Nuts and seeds are good sources of skin-boosting nutrients. They also nourish the scalp promoting hair growth and are also anti-ageing. Loaded with antioxidants. They help lowering the risk of lifestyle diseases.</span><br style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">Add them to you smoothies, salads, cakes or make crackers and energy balls or just have them on it's own as a snack.</span><br style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br></span></p>
[short_description] =>
[privacy] => 1
[like_count] => 2
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] =>
[category_id] => 24
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => Flyberry Gourmet
[ratting_count] => 1
)
[10005] => Array
(
[product_id] => 10005
[product] => Pumpkin Seed Oil Soft Gel - 60 Capsule
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 203
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => NUTPMKOILCP60
[hsn_code] => 3304
[status] => A
[list_price] => 551.00
[amount] => 49
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1650354387
[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] => 523.450000
[short_description] => Full of Vitamin-C & great for immunity
[full_description] =>
[category_ids] => Array
(
[0] => 2672
)
[seo_name] => pumpkin-seed-oil-soft-gel-60-capsule
[seo_path] => 2669/2670/2672
[main_category] => 2672
[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] => Nutriorg
)
)
Array
(
[16305] => Array
(
[product_id] => 16305
[product] => Roasted & Salted Pumpkin Seeds - 250 g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 346
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => PumpkinSeeds_bottle_250g
[hsn_code] => 3304
[status] => A
[list_price] => 385.00
[amount] => 195
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1661332182
[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] => 227.150000
[short_description] => Rich in nutrients & 100% natural
[full_description] =>
[category_ids] => Array
(
[0] => 2648
)
[seo_name] => roasted-and-salted-pumpkin-seeds-250-g
[seo_path] => 458/2646/2648
[average_rating] => 4.00
[reviews_count] => 1
[main_category] => 2648
[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] => Ambrosia
[ratting_count] => 1
)
[6763] => Array
(
[product_id] => 6763
[product] => Pumpkin Seeds 150g | Rich in Zinc & Magnesium
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 42
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => Premium_Pumpkin_32
[hsn_code] => 3304
[status] => A
[list_price] => 249.00
[amount] => 75
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1644423039
[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] => 180.000000
[short_description] => Sunflower seeds are a great snack for your hunger pangs
[full_description] =>
[category_ids] => Array
(
[0] => 2648
)
[seo_name] => premium-pumpkin-seeds-150-g
[seo_path] => 458/2646/2648
[average_rating] => 5.00
[reviews_count] => 1
[main_category] => 2648
[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
(
[414] => Array
(
[video_id] => 414
[video_type] => C
[company_id] => 13
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1681669800
[status] => A
[user_id] => 21551
[extra_params] =>
[community_video_id] => 398
[community_url] => https://www.kindlife.in/looking-for-healthy-snacking-choices
[community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/398/f0ae19d3f7141fa4bdbc2d4f9ebb834f.jpg
[community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/398/03cdda9bae17eedb1317d4953b1d287b.mp4
[community_last_sync_timestamp] => 1713161298
[lang_code] => en
[youtube_id] =>
[video] => Looking for Healthy Snacking Choices? Here's the best ones for you!
[description] => <p><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">Nuts and seeds are good sources of protein, healthy fats, fibres, vitamins, and minerals. Nuts and seeds regulate body weight as their fats are not fully absorbed, they regulate food intake, and help burn energy. It lower your LDL or "bad" cholesterol and triglyceride levels. Nuts and seeds are good sources of skin-boosting nutrients. They also nourish the scalp promoting hair growth and are also anti-ageing. Loaded with antioxidants. They help lowering the risk of lifestyle diseases.</span><br style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">Add them to you smoothies, salads, cakes or make crackers and energy balls or just have them on it's own as a snack.</span><br style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br></span></p>
[short_description] =>
[privacy] => 1
[like_count] => 2
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] =>
[category_id] => 24
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => Flyberry Gourmet
[ratting_count] => 1
)
[10005] => Array
(
[product_id] => 10005
[product] => Pumpkin Seed Oil Soft Gel - 60 Capsule
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 203
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => NUTPMKOILCP60
[hsn_code] => 3304
[status] => A
[list_price] => 551.00
[amount] => 49
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1650354387
[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] => 523.450000
[short_description] => Full of Vitamin-C & great for immunity
[full_description] =>
[category_ids] => Array
(
[0] => 2672
)
[seo_name] => pumpkin-seed-oil-soft-gel-60-capsule
[seo_path] => 2669/2670/2672
[main_category] => 2672
[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] => Nutriorg
)
)
end of fxn
Array
(
[show_master_products_only] =>
[area] => C
[custom_extend] => Array
(
[0] => product_name
[1] => categories
)
[group_child_variations] =>
[include_child_variations] => 1
[skip_rating] => 1
[load_products_extra_data] =>
[sort_by] => null
[variation_group_id] => Array
(
[589] => 589
[434] => 434
)
[get_amount] => 1
[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, products.amount, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, variation_group_products.group_id AS variation_group_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' INNER JOIN ?:product_variation_group_products AS variation_group_products ON variation_group_products.product_id = products.product_id 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 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 variation_group_products.group_id IN (589, 434) 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 NULL asc
before end of oxn
Array
(
[6764] => Array
(
[product_id] => 6764
[amount] => 75
[product] => Sunflower Seeds, 150g| Reduces Cholestrol | Helps Manage Diabetes
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 42
[variation_group_id] => 434
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[video_as_images] => Array
(
)
[videos] => Array
(
[414] => Array
(
[video_id] => 414
[video_type] => C
[company_id] => 13
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1681669800
[status] => A
[user_id] => 21551
[extra_params] =>
[community_video_id] => 398
[community_url] => https://www.kindlife.in/looking-for-healthy-snacking-choices
[community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/398/f0ae19d3f7141fa4bdbc2d4f9ebb834f.jpg
[community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/398/03cdda9bae17eedb1317d4953b1d287b.mp4
[community_last_sync_timestamp] => 1713161298
[lang_code] => en
[youtube_id] =>
[video] => Looking for Healthy Snacking Choices? Here's the best ones for you!
[description] => <p><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">Nuts and seeds are good sources of protein, healthy fats, fibres, vitamins, and minerals. Nuts and seeds regulate body weight as their fats are not fully absorbed, they regulate food intake, and help burn energy. It lower your LDL or "bad" cholesterol and triglyceride levels. Nuts and seeds are good sources of skin-boosting nutrients. They also nourish the scalp promoting hair growth and are also anti-ageing. Loaded with antioxidants. They help lowering the risk of lifestyle diseases.</span><br style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">Add them to you smoothies, salads, cakes or make crackers and energy balls or just have them on it's own as a snack.</span><br style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br></span></p>
[short_description] =>
[privacy] => 1
[like_count] => 2
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] =>
[category_id] => 24
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => Flyberry Gourmet
)
[6763] => Array
(
[product_id] => 6763
[amount] => 75
[product] => Pumpkin Seeds 150g | Rich in Zinc & Magnesium
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 42
[variation_group_id] => 434
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[video_as_images] => Array
(
)
[videos] => Array
(
[414] => Array
(
[video_id] => 414
[video_type] => C
[company_id] => 13
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1681669800
[status] => A
[user_id] => 21551
[extra_params] =>
[community_video_id] => 398
[community_url] => https://www.kindlife.in/looking-for-healthy-snacking-choices
[community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/398/f0ae19d3f7141fa4bdbc2d4f9ebb834f.jpg
[community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/398/03cdda9bae17eedb1317d4953b1d287b.mp4
[community_last_sync_timestamp] => 1713161298
[lang_code] => en
[youtube_id] =>
[video] => Looking for Healthy Snacking Choices? Here's the best ones for you!
[description] => <p><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">Nuts and seeds are good sources of protein, healthy fats, fibres, vitamins, and minerals. Nuts and seeds regulate body weight as their fats are not fully absorbed, they regulate food intake, and help burn energy. It lower your LDL or "bad" cholesterol and triglyceride levels. Nuts and seeds are good sources of skin-boosting nutrients. They also nourish the scalp promoting hair growth and are also anti-ageing. Loaded with antioxidants. They help lowering the risk of lifestyle diseases.</span><br style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">Add them to you smoothies, salads, cakes or make crackers and energy balls or just have them on it's own as a snack.</span><br style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br></span></p>
[short_description] =>
[privacy] => 1
[like_count] => 2
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] =>
[category_id] => 24
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => Flyberry Gourmet
)
[16305] => Array
(
[product_id] => 16305
[amount] => 195
[product] => Roasted & Salted Pumpkin Seeds - 250 g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 346
[variation_group_id] => 589
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[video_as_images] => Array
(
)
[videos] => Array
(
)
[brand_name] => Ambrosia
)
[16306] => Array
(
[product_id] => 16306
[amount] => 184
[product] => Premium Sunflower Seeds - 250 g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 346
[variation_group_id] => 589
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[video_as_images] => Array
(
)
[videos] => Array
(
)
[brand_name] => Ambrosia
)
[16307] => Array
(
[product_id] => 16307
[amount] => 195
[product] => Raw Flax Seeds - 250 g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 346
[variation_group_id] => 589
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[video_as_images] => Array
(
)
[videos] => Array
(
)
[brand_name] => Ambrosia
)
[16308] => Array
(
[product_id] => 16308
[amount] => 35
[product] => Raw Unroasted Chia Seeds - 250 g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 346
[variation_group_id] => 589
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[video_as_images] => Array
(
)
[videos] => Array
(
)
[brand_name] => Ambrosia
)
)
Array
(
[6764] => Array
(
[product_id] => 6764
[amount] => 75
[product] => Sunflower Seeds, 150g| Reduces Cholestrol | Helps Manage Diabetes
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 42
[variation_group_id] => 434
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[video_as_images] => Array
(
)
[videos] => Array
(
[414] => Array
(
[video_id] => 414
[video_type] => C
[company_id] => 13
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1681669800
[status] => A
[user_id] => 21551
[extra_params] =>
[community_video_id] => 398
[community_url] => https://www.kindlife.in/looking-for-healthy-snacking-choices
[community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/398/f0ae19d3f7141fa4bdbc2d4f9ebb834f.jpg
[community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/398/03cdda9bae17eedb1317d4953b1d287b.mp4
[community_last_sync_timestamp] => 1713161298
[lang_code] => en
[youtube_id] =>
[video] => Looking for Healthy Snacking Choices? Here's the best ones for you!
[description] => <p><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">Nuts and seeds are good sources of protein, healthy fats, fibres, vitamins, and minerals. Nuts and seeds regulate body weight as their fats are not fully absorbed, they regulate food intake, and help burn energy. It lower your LDL or "bad" cholesterol and triglyceride levels. Nuts and seeds are good sources of skin-boosting nutrients. They also nourish the scalp promoting hair growth and are also anti-ageing. Loaded with antioxidants. They help lowering the risk of lifestyle diseases.</span><br style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">Add them to you smoothies, salads, cakes or make crackers and energy balls or just have them on it's own as a snack.</span><br style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br></span></p>
[short_description] =>
[privacy] => 1
[like_count] => 2
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] =>
[category_id] => 24
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => Flyberry Gourmet
)
[6763] => Array
(
[product_id] => 6763
[amount] => 75
[product] => Pumpkin Seeds 150g | Rich in Zinc & Magnesium
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 42
[variation_group_id] => 434
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[video_as_images] => Array
(
)
[videos] => Array
(
[414] => Array
(
[video_id] => 414
[video_type] => C
[company_id] => 13
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1681669800
[status] => A
[user_id] => 21551
[extra_params] =>
[community_video_id] => 398
[community_url] => https://www.kindlife.in/looking-for-healthy-snacking-choices
[community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/398/f0ae19d3f7141fa4bdbc2d4f9ebb834f.jpg
[community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/398/03cdda9bae17eedb1317d4953b1d287b.mp4
[community_last_sync_timestamp] => 1713161298
[lang_code] => en
[youtube_id] =>
[video] => Looking for Healthy Snacking Choices? Here's the best ones for you!
[description] => <p><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">Nuts and seeds are good sources of protein, healthy fats, fibres, vitamins, and minerals. Nuts and seeds regulate body weight as their fats are not fully absorbed, they regulate food intake, and help burn energy. It lower your LDL or "bad" cholesterol and triglyceride levels. Nuts and seeds are good sources of skin-boosting nutrients. They also nourish the scalp promoting hair growth and are also anti-ageing. Loaded with antioxidants. They help lowering the risk of lifestyle diseases.</span><br style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;">Add them to you smoothies, salads, cakes or make crackers and energy balls or just have them on it's own as a snack.</span><br style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><span style="color: #262626; font-family: -apple-system, 'system-ui', 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;"><br></span></p>
[short_description] =>
[privacy] => 1
[like_count] => 2
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] =>
[category_id] => 24
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => Flyberry Gourmet
)
[16305] => Array
(
[product_id] => 16305
[amount] => 195
[product] => Roasted & Salted Pumpkin Seeds - 250 g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 346
[variation_group_id] => 589
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[video_as_images] => Array
(
)
[videos] => Array
(
)
[brand_name] => Ambrosia
)
[16306] => Array
(
[product_id] => 16306
[amount] => 184
[product] => Premium Sunflower Seeds - 250 g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 346
[variation_group_id] => 589
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[video_as_images] => Array
(
)
[videos] => Array
(
)
[brand_name] => Ambrosia
)
[16307] => Array
(
[product_id] => 16307
[amount] => 195
[product] => Raw Flax Seeds - 250 g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 346
[variation_group_id] => 589
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[video_as_images] => Array
(
)
[videos] => Array
(
)
[brand_name] => Ambrosia
)
[16308] => Array
(
[product_id] => 16308
[amount] => 35
[product] => Raw Unroasted Chia Seeds - 250 g
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 346
[variation_group_id] => 589
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[video_as_images] => Array
(
)
[videos] => Array
(
)
[brand_name] => Ambrosia
)
)
end of fxn
Array
(
[show_master_products_only] =>
[area] => C
[for_required_product] => 16305
[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 = 16305 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] => 6763
[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 = 6763 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] => 10005
[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 = 10005 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: | 129 |
| 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 |