Array
(
[show_master_products_only] =>
[area] => C
[for_required_product] => 12296
[include_child_variations] => 1
[group_child_variations] =>
[runtime_company_id] => 13
)
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 ?: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 ?:product_required_products.product_id = 12296 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
[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
(
[511] => 511
)
[get_amount] => 1
[runtime_company_id] => 13
)
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 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 (511) AND products.master_product_status IN ('A') GROUP BY products.product_id ORDER BY NULL asc
before end of oxn
Array
(
[12296] => Array
(
[product_id] => 12296
[amount] => 167
[product] => Superfood Plant Protein - Vanilla Caramel - 500 gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 96
[variation_group_id] => 511
[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
(
[415] => Array
(
[video_id] => 415
[video_type] => C
[company_id] => 13
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1681669800
[status] => A
[user_id] => 21551
[extra_params] =>
[community_video_id] => 397
[community_url] => https://www.kindlife.in/our-breakfast-box
[community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/397/20522b2bbcbb4ffcc0606a559806ef00.jpg
[community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/397/87cd8300e6eeac07c97e5f8779249c95.mp4
[community_last_sync_timestamp] => 1713161297
[lang_code] => en
[youtube_id] =>
[video] => Our Breakfast Box!
[description] => <p>Bypassing the greasy spoon and its tempting aromas, I reached for a vibrant burst of color instead. Fresh berries glistened like jewels, their sweet fragrance a refreshing contrast to the heavy air. Creamy yogurt swirled with nutty granola, promising a symphony of textures. A drizzle of honey added a touch of golden sweetness. This wasn't just breakfast; it was a vibrant promise of energy and a clear mind, a delicious reminder that healthy choices can be as satisfying as any indulgence.</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] => Wellbeing Nutrition
)
[12295] => Array
(
[product_id] => 12295
[amount] => 417
[product] => Special Offer -Superfood Plant Protein - Dark Chocolate Hazelnut - 500 gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 96
[variation_group_id] => 511
[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
(
[415] => Array
(
[video_id] => 415
[video_type] => C
[company_id] => 13
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1681669800
[status] => A
[user_id] => 21551
[extra_params] =>
[community_video_id] => 397
[community_url] => https://www.kindlife.in/our-breakfast-box
[community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/397/20522b2bbcbb4ffcc0606a559806ef00.jpg
[community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/397/87cd8300e6eeac07c97e5f8779249c95.mp4
[community_last_sync_timestamp] => 1713161297
[lang_code] => en
[youtube_id] =>
[video] => Our Breakfast Box!
[description] => <p>Bypassing the greasy spoon and its tempting aromas, I reached for a vibrant burst of color instead. Fresh berries glistened like jewels, their sweet fragrance a refreshing contrast to the heavy air. Creamy yogurt swirled with nutty granola, promising a symphony of textures. A drizzle of honey added a touch of golden sweetness. This wasn't just breakfast; it was a vibrant promise of energy and a clear mind, a delicious reminder that healthy choices can be as satisfying as any indulgence.</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] => Wellbeing Nutrition
)
)
Array
(
[12296] => Array
(
[product_id] => 12296
[amount] => 167
[product] => Superfood Plant Protein - Vanilla Caramel - 500 gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 96
[variation_group_id] => 511
[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
(
[415] => Array
(
[video_id] => 415
[video_type] => C
[company_id] => 13
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1681669800
[status] => A
[user_id] => 21551
[extra_params] =>
[community_video_id] => 397
[community_url] => https://www.kindlife.in/our-breakfast-box
[community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/397/20522b2bbcbb4ffcc0606a559806ef00.jpg
[community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/397/87cd8300e6eeac07c97e5f8779249c95.mp4
[community_last_sync_timestamp] => 1713161297
[lang_code] => en
[youtube_id] =>
[video] => Our Breakfast Box!
[description] => <p>Bypassing the greasy spoon and its tempting aromas, I reached for a vibrant burst of color instead. Fresh berries glistened like jewels, their sweet fragrance a refreshing contrast to the heavy air. Creamy yogurt swirled with nutty granola, promising a symphony of textures. A drizzle of honey added a touch of golden sweetness. This wasn't just breakfast; it was a vibrant promise of energy and a clear mind, a delicious reminder that healthy choices can be as satisfying as any indulgence.</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] => Wellbeing Nutrition
)
[12295] => Array
(
[product_id] => 12295
[amount] => 417
[product] => Special Offer -Superfood Plant Protein - Dark Chocolate Hazelnut - 500 gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 96
[variation_group_id] => 511
[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
(
[415] => Array
(
[video_id] => 415
[video_type] => C
[company_id] => 13
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1681669800
[status] => A
[user_id] => 21551
[extra_params] =>
[community_video_id] => 397
[community_url] => https://www.kindlife.in/our-breakfast-box
[community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/397/20522b2bbcbb4ffcc0606a559806ef00.jpg
[community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/397/87cd8300e6eeac07c97e5f8779249c95.mp4
[community_last_sync_timestamp] => 1713161297
[lang_code] => en
[youtube_id] =>
[video] => Our Breakfast Box!
[description] => <p>Bypassing the greasy spoon and its tempting aromas, I reached for a vibrant burst of color instead. Fresh berries glistened like jewels, their sweet fragrance a refreshing contrast to the heavy air. Creamy yogurt swirled with nutty granola, promising a symphony of textures. A drizzle of honey added a touch of golden sweetness. This wasn't just breakfast; it was a vibrant promise of energy and a clear mind, a delicious reminder that healthy choices can be as satisfying as any indulgence.</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] => Wellbeing Nutrition
)
)
end of fxn
Array
(
[show_master_products_only] =>
[area] => C
[pid] => 12296
[limit] => 1
[total] => 1
[custom_extend] => Array
(
[0] => product_name
[1] => categories
)
[load_products_extra_data] =>
[force_virtual] => 1
[runtime_company_id] => 13
[vr_company_id] => 0
[is_virtual] => Y
[virtual_conditions] => Array
(
[set] => all
[set_value] => 1
[conditions] => Array
(
[1] => Array
(
[operator] => in
[condition] => products
[value] => 3556,3976,14830,15216,23660,28537,32931,35638,35639,36366,37916,39004,39636,58631,63910,63916,63922,65282
)
)
)
)
Array
(
[area] => C
[use_caching] => 1
[extend] => Array
(
[0] => product_name
[1] => prices
[2] => categories
)
[custom_extend] => Array
(
)
[pname] =>
[pshort] =>
[pfull] =>
[pkeywords] =>
[feature] => Array
(
)
[type] => simple
[page] => 1
[action] =>
[filter_variants] => Array
(
)
[features_hash] =>
[limit] => 0
[bid] => 0
[match] =>
[tracking] => Array
(
)
[get_frontend_urls] =>
[items_per_page] => 1
[apply_disabled_filters] =>
[load_products_extra_data] => 1
[storefront] =>
[company_ids] =>
[product_id] =>
)
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 ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id WHERE 1 AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND ((1 AND products.product_id IN (12296)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products.product_id IN (3556,3976,14830,15216,23660,28537,32931,35638,35639,36366,37916,39004,39636,58631,63910,63916,63922,65282)) GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 0, 1
before end of oxn
Array ( )
Array ( )
end of fxn
Array
(
[show_master_products_only] =>
[area] => C
[pid] => 12296
[limit] => 1
[total] => 1
[custom_extend] => Array
(
[0] => product_name
[1] => categories
)
[load_products_extra_data] =>
[force_virtual] => 1
[runtime_company_id] => 13
[vr_company_id] => 0
[is_virtual] => Y
[virtual_conditions] => Array
(
[set] => all
[set_value] => 1
[conditions] => Array
(
[1] => Array
(
[condition_element] => 62
[operator] => nin
[condition] => feature
[value] => 49321,40971,38308
[value_name] =>
)
)
)
[include_child_variations] => 1
)
Array
(
[area] => C
[use_caching] => 1
[extend] => Array
(
[0] => product_name
[1] => prices
[2] => categories
)
[custom_extend] => Array
(
)
[pname] =>
[pshort] =>
[pfull] =>
[pkeywords] =>
[feature] => Array
(
)
[type] => simple
[page] => 1
[action] =>
[filter_variants] => Array
(
)
[features_hash] =>
[limit] => 0
[bid] => 0
[match] =>
[tracking] => Array
(
)
[get_frontend_urls] =>
[items_per_page] => 1
[apply_disabled_filters] =>
[load_products_extra_data] => 1
[storefront] =>
[company_ids] =>
[product_id] =>
)
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 ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id LEFT JOIN ?:product_features_values AS pfv_62 ON pfv_62.product_id = products.product_id AND pfv_62.feature_id = 62 WHERE 1 AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND ((1 AND products.product_id IN (12296)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND pfv_62.variant_id NOT IN (49321,40971,38308)) GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 0, 1
before end of oxn
Array
(
[12296] => Array
(
[product_id] => 12296
[product] => Superfood Plant Protein - Vanilla Caramel - 500 gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 96
[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
(
[415] => Array
(
[video_id] => 415
[video_type] => C
[company_id] => 13
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1681669800
[status] => A
[user_id] => 21551
[extra_params] =>
[community_video_id] => 397
[community_url] => https://www.kindlife.in/our-breakfast-box
[community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/397/20522b2bbcbb4ffcc0606a559806ef00.jpg
[community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/397/87cd8300e6eeac07c97e5f8779249c95.mp4
[community_last_sync_timestamp] => 1713161297
[lang_code] => en
[youtube_id] =>
[video] => Our Breakfast Box!
[description] => <p>Bypassing the greasy spoon and its tempting aromas, I reached for a vibrant burst of color instead. Fresh berries glistened like jewels, their sweet fragrance a refreshing contrast to the heavy air. Creamy yogurt swirled with nutty granola, promising a symphony of textures. A drizzle of honey added a touch of golden sweetness. This wasn't just breakfast; it was a vibrant promise of energy and a clear mind, a delicious reminder that healthy choices can be as satisfying as any indulgence.</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] => Wellbeing Nutrition
)
)
Array
(
[12296] => Array
(
[product_id] => 12296
[product] => Superfood Plant Protein - Vanilla Caramel - 500 gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 96
[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
(
[415] => Array
(
[video_id] => 415
[video_type] => C
[company_id] => 13
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1681669800
[status] => A
[user_id] => 21551
[extra_params] =>
[community_video_id] => 397
[community_url] => https://www.kindlife.in/our-breakfast-box
[community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/397/20522b2bbcbb4ffcc0606a559806ef00.jpg
[community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/397/87cd8300e6eeac07c97e5f8779249c95.mp4
[community_last_sync_timestamp] => 1713161297
[lang_code] => en
[youtube_id] =>
[video] => Our Breakfast Box!
[description] => <p>Bypassing the greasy spoon and its tempting aromas, I reached for a vibrant burst of color instead. Fresh berries glistened like jewels, their sweet fragrance a refreshing contrast to the heavy air. Creamy yogurt swirled with nutty granola, promising a symphony of textures. A drizzle of honey added a touch of golden sweetness. This wasn't just breakfast; it was a vibrant promise of energy and a clear mind, a delicious reminder that healthy choices can be as satisfying as any indulgence.</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] => Wellbeing Nutrition
)
)
end of fxn
Array
(
[show_master_products_only] =>
[area] => C
[pid] => 12296
[limit] => 1
[total] => 1
[custom_extend] => Array
(
[0] => product_name
[1] => categories
)
[load_products_extra_data] =>
[force_virtual] => 1
[runtime_company_id] => 13
[vr_company_id] => 0
[is_virtual] => Y
[virtual_conditions] => Array
(
[set] => all
[set_value] => 1
[conditions] => Array
(
[1] => Array
(
[operator] => in
[condition] => categories
[value] => 274,275,276,277,278,281,282,284,285,287,288,290,296,432,508,579,620,621,745,1011,1096,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1181,1182,1183,1184,1185,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1202,1203,1204,1205,1206,1207,1208,1209,1214,1215,1216,1217,1218,1238,1270,1364,1632,1648,1703,1704,1977,2040,2116,2117,2118,2141,2191,2242,2250,2251,2322,2366,2421,2437,2439,2440,2444,2445,2456,2457,2458,2465,2468,2469,2472,2474,2476,2477,2481,2483,2485,2486,2489,2492,2497,2498,458,1186,2438,2453,2463,2473,2488,2494,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2654,2655,2656,2657,2658,2659,2660,2661,2662,2663,2664,2665,2666,2667,2668,2669,2670,2671,2672,2673,2674,2675,2676,2677,2678,2679,2680,2681,2682,2683,2684
)
)
)
)
Array
(
[area] => C
[use_caching] => 1
[extend] => Array
(
[0] => product_name
[1] => prices
[2] => categories
)
[custom_extend] => Array
(
)
[pname] =>
[pshort] =>
[pfull] =>
[pkeywords] =>
[feature] => Array
(
)
[type] => simple
[page] => 1
[action] =>
[filter_variants] => Array
(
)
[features_hash] =>
[limit] => 0
[bid] => 0
[match] =>
[tracking] => Array
(
)
[get_frontend_urls] =>
[items_per_page] => 1
[apply_disabled_filters] =>
[load_products_extra_data] => 1
[storefront] =>
[company_ids] =>
[product_id] =>
)
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 ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id WHERE 1 AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND ((1 AND products.product_id IN (12296)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products_categories.category_id IN (458, 1648, 274, 275, 276, 277, 278, 281, 282, 284, 285, 287, 288, 290, 296, 432, 2662, 508, 579, 1632, 620, 621, 745, 1011, 1096, 1218, 1153, 1154, 1155, 1156, 1157, 1158, 1159, 1160, 1161, 1162, 1163, 1164, 1165, 1166, 1167, 1168, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1214, 1215, 1216, 1217, 1238, 1270, 1364, 1704, 1703, 1977, 2040, 2116, 2117, 2118, 2141, 2191, 2242, 2661, 2250, 2251, 2488, 2421, 2322, 2366, 2656, 2437, 2438, 2439, 2440, 2645, 2659, 2444, 2445, 2663, 2658, 2654, 2453, 2643, 2644, 2456, 2457, 2458, 2653, 2651, 2652, 2463, 2465, 2640, 2468, 2469, 2649, 2650, 2472, 2473, 2474, 2646, 2476, 2477, 2648, 2684, 2481, 2660, 2642, 2483, 2485, 2486, 2489, 2647, 2641, 2492, 2494, 2655, 2497, 2498, 2657, 2664, 2666, 2665, 2667, 2668, 2669, 2670, 2671, 2672, 2673, 2674, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683)) GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 0, 1
before end of oxn
Array
(
[12296] => Array
(
[product_id] => 12296
[product] => Superfood Plant Protein - Vanilla Caramel - 500 gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 96
[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
(
[415] => Array
(
[video_id] => 415
[video_type] => C
[company_id] => 13
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1681669800
[status] => A
[user_id] => 21551
[extra_params] =>
[community_video_id] => 397
[community_url] => https://www.kindlife.in/our-breakfast-box
[community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/397/20522b2bbcbb4ffcc0606a559806ef00.jpg
[community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/397/87cd8300e6eeac07c97e5f8779249c95.mp4
[community_last_sync_timestamp] => 1713161297
[lang_code] => en
[youtube_id] =>
[video] => Our Breakfast Box!
[description] => <p>Bypassing the greasy spoon and its tempting aromas, I reached for a vibrant burst of color instead. Fresh berries glistened like jewels, their sweet fragrance a refreshing contrast to the heavy air. Creamy yogurt swirled with nutty granola, promising a symphony of textures. A drizzle of honey added a touch of golden sweetness. This wasn't just breakfast; it was a vibrant promise of energy and a clear mind, a delicious reminder that healthy choices can be as satisfying as any indulgence.</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] => Wellbeing Nutrition
)
)
Array
(
[12296] => Array
(
[product_id] => 12296
[product] => Superfood Plant Protein - Vanilla Caramel - 500 gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 96
[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
(
[415] => Array
(
[video_id] => 415
[video_type] => C
[company_id] => 13
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1681669800
[status] => A
[user_id] => 21551
[extra_params] =>
[community_video_id] => 397
[community_url] => https://www.kindlife.in/our-breakfast-box
[community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/397/20522b2bbcbb4ffcc0606a559806ef00.jpg
[community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/397/87cd8300e6eeac07c97e5f8779249c95.mp4
[community_last_sync_timestamp] => 1713161297
[lang_code] => en
[youtube_id] =>
[video] => Our Breakfast Box!
[description] => <p>Bypassing the greasy spoon and its tempting aromas, I reached for a vibrant burst of color instead. Fresh berries glistened like jewels, their sweet fragrance a refreshing contrast to the heavy air. Creamy yogurt swirled with nutty granola, promising a symphony of textures. A drizzle of honey added a touch of golden sweetness. This wasn't just breakfast; it was a vibrant promise of energy and a clear mind, a delicious reminder that healthy choices can be as satisfying as any indulgence.</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] => Wellbeing Nutrition
)
)
end of fxn
Array
(
[show_master_products_only] =>
[area] => C
[pid] => 12296
[limit] => 1
[total] => 1
[custom_extend] => Array
(
[0] => product_name
[1] => categories
)
[load_products_extra_data] =>
[force_virtual] => 1
[runtime_company_id] => 13
[vr_company_id] => 0
[is_virtual] => Y
[virtual_conditions] => Array
(
[set] => all
[set_value] => 1
[conditions] => Array
(
[1] => Array
(
[operator] => in
[condition] => categories
[value] => 458,1186,2438,2453,2463,2473,2488,2494,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2654,2655,2656,2657,2658,2659,2660,2661,2662,2663,2664,2665,2666,2667,2668,2669,2670,2671,2672,2673,2674,2675,2676,2677,2678,2679,2680,2681,2682,2683,2684
)
)
)
)
Array
(
[area] => C
[use_caching] => 1
[extend] => Array
(
[0] => product_name
[1] => prices
[2] => categories
)
[custom_extend] => Array
(
)
[pname] =>
[pshort] =>
[pfull] =>
[pkeywords] =>
[feature] => Array
(
)
[type] => simple
[page] => 1
[action] =>
[filter_variants] => Array
(
)
[features_hash] =>
[limit] => 0
[bid] => 0
[match] =>
[tracking] => Array
(
)
[get_frontend_urls] =>
[items_per_page] => 1
[apply_disabled_filters] =>
[load_products_extra_data] => 1
[storefront] =>
[company_ids] =>
[product_id] =>
)
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 ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id WHERE 1 AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND ((1 AND products.product_id IN (12296)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products_categories.category_id IN (458, 2662, 1186, 2661, 2488, 2656, 2438, 2645, 2659, 2663, 2658, 2654, 2453, 2643, 2644, 2653, 2651, 2652, 2463, 2640, 2649, 2650, 2473, 2646, 2648, 2684, 2660, 2642, 2647, 2641, 2494, 2655, 2657, 2664, 2666, 2665, 2667, 2668, 2669, 2670, 2671, 2672, 2673, 2674, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683)) GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 0, 1
before end of oxn
Array
(
[12296] => Array
(
[product_id] => 12296
[product] => Superfood Plant Protein - Vanilla Caramel - 500 gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 96
[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
(
[415] => Array
(
[video_id] => 415
[video_type] => C
[company_id] => 13
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1681669800
[status] => A
[user_id] => 21551
[extra_params] =>
[community_video_id] => 397
[community_url] => https://www.kindlife.in/our-breakfast-box
[community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/397/20522b2bbcbb4ffcc0606a559806ef00.jpg
[community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/397/87cd8300e6eeac07c97e5f8779249c95.mp4
[community_last_sync_timestamp] => 1713161297
[lang_code] => en
[youtube_id] =>
[video] => Our Breakfast Box!
[description] => <p>Bypassing the greasy spoon and its tempting aromas, I reached for a vibrant burst of color instead. Fresh berries glistened like jewels, their sweet fragrance a refreshing contrast to the heavy air. Creamy yogurt swirled with nutty granola, promising a symphony of textures. A drizzle of honey added a touch of golden sweetness. This wasn't just breakfast; it was a vibrant promise of energy and a clear mind, a delicious reminder that healthy choices can be as satisfying as any indulgence.</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] => Wellbeing Nutrition
)
)
Array
(
[12296] => Array
(
[product_id] => 12296
[product] => Superfood Plant Protein - Vanilla Caramel - 500 gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 96
[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
(
[415] => Array
(
[video_id] => 415
[video_type] => C
[company_id] => 13
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1681669800
[status] => A
[user_id] => 21551
[extra_params] =>
[community_video_id] => 397
[community_url] => https://www.kindlife.in/our-breakfast-box
[community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/397/20522b2bbcbb4ffcc0606a559806ef00.jpg
[community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/397/87cd8300e6eeac07c97e5f8779249c95.mp4
[community_last_sync_timestamp] => 1713161297
[lang_code] => en
[youtube_id] =>
[video] => Our Breakfast Box!
[description] => <p>Bypassing the greasy spoon and its tempting aromas, I reached for a vibrant burst of color instead. Fresh berries glistened like jewels, their sweet fragrance a refreshing contrast to the heavy air. Creamy yogurt swirled with nutty granola, promising a symphony of textures. A drizzle of honey added a touch of golden sweetness. This wasn't just breakfast; it was a vibrant promise of energy and a clear mind, a delicious reminder that healthy choices can be as satisfying as any indulgence.</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] => Wellbeing Nutrition
)
)
end of fxn
Cache: can not connect to the Redis server
app/Tygh/Backend/Cache/Redis.php, line: 220
| File: | app/Tygh/Backend/Cache/Redis.php |
| Line: | 97 |
| Function: | query |
| File: | app/Tygh/Registry.php |
| Line: | 456 |
| Function: | set |
| File: | app/Tygh/Registry.php |
| Line: | 95 |
| Function: | _saveCache |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 728 |
| Function: | set |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 493 |
| Function: | renderBlockContent |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 415 |
| Function: | renderBlock |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 373 |
| Function: | renderBlocks |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 230 |
| Function: | renderGrid |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 200 |
| Function: | renderGrids |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 164 |
| Function: | _renderContainer |
| File: | app/functions/smarty_plugins/function.render_location.php |
| Line: | 52 |
| Function: | render |
| 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 |