Array
(
[show_master_products_only] =>
[area] => C
[for_required_product] => 10575
[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 = 10575 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
[pid] => 10575
[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 (10575)) 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] => 10575
[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 (10575)) 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
(
[10575] => Array
(
[product_id] => 10575
[product] => Hair Gowth Serum - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[video_as_images] => Array
(
)
[videos] => Array
(
[1351] => Array
(
[video_id] => 1351
[video_type] => S
[company_id] => 0
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1720525345
[status] => A
[user_id] => 4935
[extra_params] =>
[community_video_id] => 0
[community_url] => https://www.kindlife.in/from-frazzled-to-fabulous-restore-your-hair-with-these-4-products-en
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1351_SaveInsta.App - 2964105165164035152_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1351_SaveInsta.App - 2964105165164035152.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => From Frazzled to Fabulous! Restore Your Hair with These 4 Products
[description] => Transform your hair care routine into a spa day with these must-haves:
@ashbabotanics Hydrating Shampoo - Dive into luxury with a hydrating formula that gently cleanses your hair and scalp.
@brillareindia Hair Fall Control Conditioner - Say goodbye to hair fall and thinning with this miracle worker that nourishes and strengthens your locks.
@thrivecotalks Hair Growth Serum - Experience fuller, softer hair with every drop, boosting growth and vitality effortlessly.
@truefrog_ Deep Conditioner Mask - Treat yourself to intense hydration and silky-smooth strands with this deep conditioning mask. Pamper your hair with love and care!
[short_description] =>
[privacy] => 1
[like_count] => 2
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] => 33295,10448,27488,10418
[category_id] => 23
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => Thriveco
)
)
Array
(
[10575] => Array
(
[product_id] => 10575
[product] => Hair Gowth Serum - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[video_as_images] => Array
(
)
[videos] => Array
(
[1351] => Array
(
[video_id] => 1351
[video_type] => S
[company_id] => 0
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1720525345
[status] => A
[user_id] => 4935
[extra_params] =>
[community_video_id] => 0
[community_url] => https://www.kindlife.in/from-frazzled-to-fabulous-restore-your-hair-with-these-4-products-en
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1351_SaveInsta.App - 2964105165164035152_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1351_SaveInsta.App - 2964105165164035152.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => From Frazzled to Fabulous! Restore Your Hair with These 4 Products
[description] => Transform your hair care routine into a spa day with these must-haves:
@ashbabotanics Hydrating Shampoo - Dive into luxury with a hydrating formula that gently cleanses your hair and scalp.
@brillareindia Hair Fall Control Conditioner - Say goodbye to hair fall and thinning with this miracle worker that nourishes and strengthens your locks.
@thrivecotalks Hair Growth Serum - Experience fuller, softer hair with every drop, boosting growth and vitality effortlessly.
@truefrog_ Deep Conditioner Mask - Treat yourself to intense hydration and silky-smooth strands with this deep conditioning mask. Pamper your hair with love and care!
[short_description] =>
[privacy] => 1
[like_count] => 2
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] => 33295,10448,27488,10418
[category_id] => 23
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => Thriveco
)
)
end of fxn
Array
(
[show_master_products_only] =>
[area] => C
[pid] => 10575
[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 (10575)) 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 ( )
Array ( )
end of fxn
Array
(
[show_master_products_only] =>
[area] => C
[pid] => 10575
[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 (10575)) 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 ( )
Array ( )
end of fxn
KLOVE | Extra 5% off on all Kbeauty orders above ₹999
SUMVIBE10 | Extra 10% off on orders on orders ₹1,999+
SUNKISS5 | Extra 5% off on orders ₹999+
All orders 
Array
(
[show_master_products_only] =>
[area] => A
[extend] => Array
(
[0] => product_name
)
[pid] => Array
(
[0] => 10575
)
[group_child_variations] =>
[skip_rating] => 1
[sort_by] => null
[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
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' WHERE 1 AND companies.status IN ('A') AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0) AND ((1 AND products.product_id IN (10575)) AND companies.status IN ('A') AND products.company_id IN (13, 0) AND prices.usergroup_id IN (0)) GROUP BY products.product_id ORDER BY NULL asc
before end of oxn
Array
(
[10575] => Array
(
[product_id] => 10575
[product] => Hair Gowth Serum - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => TC000000
[hsn_code] => 3304
[status] => A
[list_price] => 1299.00
[amount] => 1
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1651227508
[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] => N
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 5
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] =>
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 1299.000000
[category_ids] => Array
(
[0] => 2396
[1] => 2754
)
[seo_name] => hair-growth-serum-50-ml
[seo_path] => 2743/2753/2754
[main_category] => 2754
[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
(
[1351] => Array
(
[video_id] => 1351
[video_type] => S
[company_id] => 0
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1720525345
[status] => A
[user_id] => 4935
[extra_params] =>
[community_video_id] => 0
[community_url] => https://www.kindlife.in/from-frazzled-to-fabulous-restore-your-hair-with-these-4-products-en
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1351_SaveInsta.App - 2964105165164035152_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1351_SaveInsta.App - 2964105165164035152.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => From Frazzled to Fabulous! Restore Your Hair with These 4 Products
[description] => Transform your hair care routine into a spa day with these must-haves:
@ashbabotanics Hydrating Shampoo - Dive into luxury with a hydrating formula that gently cleanses your hair and scalp.
@brillareindia Hair Fall Control Conditioner - Say goodbye to hair fall and thinning with this miracle worker that nourishes and strengthens your locks.
@thrivecotalks Hair Growth Serum - Experience fuller, softer hair with every drop, boosting growth and vitality effortlessly.
@truefrog_ Deep Conditioner Mask - Treat yourself to intense hydration and silky-smooth strands with this deep conditioning mask. Pamper your hair with love and care!
[short_description] =>
[privacy] => 1
[like_count] => 2
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] => 33295,10448,27488,10418
[category_id] => 23
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => Thriveco
)
)
Array
(
[10575] => Array
(
[product_id] => 10575
[product] => Hair Gowth Serum - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => TC000000
[hsn_code] => 3304
[status] => A
[list_price] => 1299.00
[amount] => 1
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1651227508
[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] => N
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 5
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] =>
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 1299.000000
[category_ids] => Array
(
[0] => 2396
[1] => 2754
)
[seo_name] => hair-growth-serum-50-ml
[seo_path] => 2743/2753/2754
[main_category] => 2754
[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
(
[1351] => Array
(
[video_id] => 1351
[video_type] => S
[company_id] => 0
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1720525345
[status] => A
[user_id] => 4935
[extra_params] =>
[community_video_id] => 0
[community_url] => https://www.kindlife.in/from-frazzled-to-fabulous-restore-your-hair-with-these-4-products-en
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1351_SaveInsta.App - 2964105165164035152_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1351_SaveInsta.App - 2964105165164035152.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => From Frazzled to Fabulous! Restore Your Hair with These 4 Products
[description] => Transform your hair care routine into a spa day with these must-haves:
@ashbabotanics Hydrating Shampoo - Dive into luxury with a hydrating formula that gently cleanses your hair and scalp.
@brillareindia Hair Fall Control Conditioner - Say goodbye to hair fall and thinning with this miracle worker that nourishes and strengthens your locks.
@thrivecotalks Hair Growth Serum - Experience fuller, softer hair with every drop, boosting growth and vitality effortlessly.
@truefrog_ Deep Conditioner Mask - Treat yourself to intense hydration and silky-smooth strands with this deep conditioning mask. Pamper your hair with love and care!
[short_description] =>
[privacy] => 1
[like_count] => 2
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] => 33295,10448,27488,10418
[category_id] => 23
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => Thriveco
)
)
end of fxn
Array
(
[show_master_products_only] =>
[area] => A
[extend] => Array
(
[0] => product_name
)
[pid] => Array
(
[0] => 10575
)
[group_child_variations] =>
[skip_rating] => 1
[sort_by] => null
[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
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' WHERE 1 AND companies.status IN ('A') AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0) AND ((1 AND products.product_id IN (10575)) AND companies.status IN ('A') AND products.company_id IN (13, 0) AND prices.usergroup_id IN (0)) GROUP BY products.product_id ORDER BY NULL asc
before end of oxn
Array
(
[10575] => Array
(
[product_id] => 10575
[product] => Hair Gowth Serum - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => TC000000
[hsn_code] => 3304
[status] => A
[list_price] => 1299.00
[amount] => 1
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1651227508
[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] => N
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 5
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] =>
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 1299.000000
[category_ids] => Array
(
[0] => 2396
[1] => 2754
)
[seo_name] => hair-growth-serum-50-ml
[seo_path] => 2743/2753/2754
[main_category] => 2754
[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
(
[1351] => Array
(
[video_id] => 1351
[video_type] => S
[company_id] => 0
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1720525345
[status] => A
[user_id] => 4935
[extra_params] =>
[community_video_id] => 0
[community_url] => https://www.kindlife.in/from-frazzled-to-fabulous-restore-your-hair-with-these-4-products-en
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1351_SaveInsta.App - 2964105165164035152_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1351_SaveInsta.App - 2964105165164035152.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => From Frazzled to Fabulous! Restore Your Hair with These 4 Products
[description] => Transform your hair care routine into a spa day with these must-haves:
@ashbabotanics Hydrating Shampoo - Dive into luxury with a hydrating formula that gently cleanses your hair and scalp.
@brillareindia Hair Fall Control Conditioner - Say goodbye to hair fall and thinning with this miracle worker that nourishes and strengthens your locks.
@thrivecotalks Hair Growth Serum - Experience fuller, softer hair with every drop, boosting growth and vitality effortlessly.
@truefrog_ Deep Conditioner Mask - Treat yourself to intense hydration and silky-smooth strands with this deep conditioning mask. Pamper your hair with love and care!
[short_description] =>
[privacy] => 1
[like_count] => 2
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] => 33295,10448,27488,10418
[category_id] => 23
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => Thriveco
)
)
Array
(
[10575] => Array
(
[product_id] => 10575
[product] => Hair Gowth Serum - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => TC000000
[hsn_code] => 3304
[status] => A
[list_price] => 1299.00
[amount] => 1
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1651227508
[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] => N
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 5
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] =>
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 1299.000000
[category_ids] => Array
(
[0] => 2396
[1] => 2754
)
[seo_name] => hair-growth-serum-50-ml
[seo_path] => 2743/2753/2754
[main_category] => 2754
[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
(
[1351] => Array
(
[video_id] => 1351
[video_type] => S
[company_id] => 0
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1720525345
[status] => A
[user_id] => 4935
[extra_params] =>
[community_video_id] => 0
[community_url] => https://www.kindlife.in/from-frazzled-to-fabulous-restore-your-hair-with-these-4-products-en
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1351_SaveInsta.App - 2964105165164035152_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1351_SaveInsta.App - 2964105165164035152.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => From Frazzled to Fabulous! Restore Your Hair with These 4 Products
[description] => Transform your hair care routine into a spa day with these must-haves:
@ashbabotanics Hydrating Shampoo - Dive into luxury with a hydrating formula that gently cleanses your hair and scalp.
@brillareindia Hair Fall Control Conditioner - Say goodbye to hair fall and thinning with this miracle worker that nourishes and strengthens your locks.
@thrivecotalks Hair Growth Serum - Experience fuller, softer hair with every drop, boosting growth and vitality effortlessly.
@truefrog_ Deep Conditioner Mask - Treat yourself to intense hydration and silky-smooth strands with this deep conditioning mask. Pamper your hair with love and care!
[short_description] =>
[privacy] => 1
[like_count] => 2
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] => 33295,10448,27488,10418
[category_id] => 23
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => Thriveco
)
)
end of fxn
Array
(
[show_master_products_only] =>
[area] => A
[extend] => Array
(
[0] => product_name
)
[pid] => Array
(
[0] => 10575
)
[group_child_variations] =>
[skip_rating] => 1
[sort_by] => null
[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
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' WHERE 1 AND companies.status IN ('A') AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0) AND ((1 AND products.product_id IN (10575)) AND companies.status IN ('A') AND products.company_id IN (13, 0) AND prices.usergroup_id IN (0)) GROUP BY products.product_id ORDER BY NULL asc
before end of oxn
Array
(
[10575] => Array
(
[product_id] => 10575
[product] => Hair Gowth Serum - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => TC000000
[hsn_code] => 3304
[status] => A
[list_price] => 1299.00
[amount] => 1
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1651227508
[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] => N
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 5
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] =>
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 1299.000000
[category_ids] => Array
(
[0] => 2396
[1] => 2754
)
[seo_name] => hair-growth-serum-50-ml
[seo_path] => 2743/2753/2754
[main_category] => 2754
[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
(
[1351] => Array
(
[video_id] => 1351
[video_type] => S
[company_id] => 0
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1720525345
[status] => A
[user_id] => 4935
[extra_params] =>
[community_video_id] => 0
[community_url] => https://www.kindlife.in/from-frazzled-to-fabulous-restore-your-hair-with-these-4-products-en
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1351_SaveInsta.App - 2964105165164035152_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1351_SaveInsta.App - 2964105165164035152.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => From Frazzled to Fabulous! Restore Your Hair with These 4 Products
[description] => Transform your hair care routine into a spa day with these must-haves:
@ashbabotanics Hydrating Shampoo - Dive into luxury with a hydrating formula that gently cleanses your hair and scalp.
@brillareindia Hair Fall Control Conditioner - Say goodbye to hair fall and thinning with this miracle worker that nourishes and strengthens your locks.
@thrivecotalks Hair Growth Serum - Experience fuller, softer hair with every drop, boosting growth and vitality effortlessly.
@truefrog_ Deep Conditioner Mask - Treat yourself to intense hydration and silky-smooth strands with this deep conditioning mask. Pamper your hair with love and care!
[short_description] =>
[privacy] => 1
[like_count] => 2
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] => 33295,10448,27488,10418
[category_id] => 23
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => Thriveco
)
)
Array
(
[10575] => Array
(
[product_id] => 10575
[product] => Hair Gowth Serum - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => TC000000
[hsn_code] => 3304
[status] => A
[list_price] => 1299.00
[amount] => 1
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1651227508
[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] => N
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 5
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] =>
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 1299.000000
[category_ids] => Array
(
[0] => 2396
[1] => 2754
)
[seo_name] => hair-growth-serum-50-ml
[seo_path] => 2743/2753/2754
[main_category] => 2754
[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
(
[1351] => Array
(
[video_id] => 1351
[video_type] => S
[company_id] => 0
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1720525345
[status] => A
[user_id] => 4935
[extra_params] =>
[community_video_id] => 0
[community_url] => https://www.kindlife.in/from-frazzled-to-fabulous-restore-your-hair-with-these-4-products-en
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1351_SaveInsta.App - 2964105165164035152_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1351_SaveInsta.App - 2964105165164035152.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => From Frazzled to Fabulous! Restore Your Hair with These 4 Products
[description] => Transform your hair care routine into a spa day with these must-haves:
@ashbabotanics Hydrating Shampoo - Dive into luxury with a hydrating formula that gently cleanses your hair and scalp.
@brillareindia Hair Fall Control Conditioner - Say goodbye to hair fall and thinning with this miracle worker that nourishes and strengthens your locks.
@thrivecotalks Hair Growth Serum - Experience fuller, softer hair with every drop, boosting growth and vitality effortlessly.
@truefrog_ Deep Conditioner Mask - Treat yourself to intense hydration and silky-smooth strands with this deep conditioning mask. Pamper your hair with love and care!
[short_description] =>
[privacy] => 1
[like_count] => 2
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] => 33295,10448,27488,10418
[category_id] => 23
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => Thriveco
)
)
end of fxn
Array
(
[show_master_products_only] =>
[area] => A
[extend] => Array
(
[0] => product_name
)
[pid] => Array
(
[0] => 10575
)
[group_child_variations] =>
[skip_rating] => 1
[sort_by] => null
[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
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' WHERE 1 AND companies.status IN ('A') AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0) AND ((1 AND products.product_id IN (10575)) AND companies.status IN ('A') AND products.company_id IN (13, 0) AND prices.usergroup_id IN (0)) GROUP BY products.product_id ORDER BY NULL asc
before end of oxn
Array
(
[10575] => Array
(
[product_id] => 10575
[product] => Hair Gowth Serum - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => TC000000
[hsn_code] => 3304
[status] => A
[list_price] => 1299.00
[amount] => 1
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1651227508
[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] => N
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 5
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] =>
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 1299.000000
[category_ids] => Array
(
[0] => 2396
[1] => 2754
)
[seo_name] => hair-growth-serum-50-ml
[seo_path] => 2743/2753/2754
[main_category] => 2754
[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
(
[1351] => Array
(
[video_id] => 1351
[video_type] => S
[company_id] => 0
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1720525345
[status] => A
[user_id] => 4935
[extra_params] =>
[community_video_id] => 0
[community_url] => https://www.kindlife.in/from-frazzled-to-fabulous-restore-your-hair-with-these-4-products-en
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1351_SaveInsta.App - 2964105165164035152_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1351_SaveInsta.App - 2964105165164035152.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => From Frazzled to Fabulous! Restore Your Hair with These 4 Products
[description] => Transform your hair care routine into a spa day with these must-haves:
@ashbabotanics Hydrating Shampoo - Dive into luxury with a hydrating formula that gently cleanses your hair and scalp.
@brillareindia Hair Fall Control Conditioner - Say goodbye to hair fall and thinning with this miracle worker that nourishes and strengthens your locks.
@thrivecotalks Hair Growth Serum - Experience fuller, softer hair with every drop, boosting growth and vitality effortlessly.
@truefrog_ Deep Conditioner Mask - Treat yourself to intense hydration and silky-smooth strands with this deep conditioning mask. Pamper your hair with love and care!
[short_description] =>
[privacy] => 1
[like_count] => 2
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] => 33295,10448,27488,10418
[category_id] => 23
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => Thriveco
)
)
Array
(
[10575] => Array
(
[product_id] => 10575
[product] => Hair Gowth Serum - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => TC000000
[hsn_code] => 3304
[status] => A
[list_price] => 1299.00
[amount] => 1
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1651227508
[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] => N
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 5
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] =>
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 1299.000000
[category_ids] => Array
(
[0] => 2396
[1] => 2754
)
[seo_name] => hair-growth-serum-50-ml
[seo_path] => 2743/2753/2754
[main_category] => 2754
[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
(
[1351] => Array
(
[video_id] => 1351
[video_type] => S
[company_id] => 0
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1720525345
[status] => A
[user_id] => 4935
[extra_params] =>
[community_video_id] => 0
[community_url] => https://www.kindlife.in/from-frazzled-to-fabulous-restore-your-hair-with-these-4-products-en
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1351_SaveInsta.App - 2964105165164035152_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1351_SaveInsta.App - 2964105165164035152.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => From Frazzled to Fabulous! Restore Your Hair with These 4 Products
[description] => Transform your hair care routine into a spa day with these must-haves:
@ashbabotanics Hydrating Shampoo - Dive into luxury with a hydrating formula that gently cleanses your hair and scalp.
@brillareindia Hair Fall Control Conditioner - Say goodbye to hair fall and thinning with this miracle worker that nourishes and strengthens your locks.
@thrivecotalks Hair Growth Serum - Experience fuller, softer hair with every drop, boosting growth and vitality effortlessly.
@truefrog_ Deep Conditioner Mask - Treat yourself to intense hydration and silky-smooth strands with this deep conditioning mask. Pamper your hair with love and care!
[short_description] =>
[privacy] => 1
[like_count] => 2
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] => 33295,10448,27488,10418
[category_id] => 23
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => Thriveco
)
)
end of fxn
Array
(
[show_master_products_only] =>
[area] => A
[extend] => Array
(
[0] => product_name
)
[pid] => Array
(
[0] => 10575
)
[group_child_variations] =>
[skip_rating] => 1
[sort_by] => null
[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
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' WHERE 1 AND companies.status IN ('A') AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0) AND ((1 AND products.product_id IN (10575)) AND companies.status IN ('A') AND products.company_id IN (13, 0) AND prices.usergroup_id IN (0)) GROUP BY products.product_id ORDER BY NULL asc
before end of oxn
Array
(
[10575] => Array
(
[product_id] => 10575
[product] => Hair Gowth Serum - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => TC000000
[hsn_code] => 3304
[status] => A
[list_price] => 1299.00
[amount] => 1
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1651227508
[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] => N
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 5
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] =>
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 1299.000000
[category_ids] => Array
(
[0] => 2396
[1] => 2754
)
[seo_name] => hair-growth-serum-50-ml
[seo_path] => 2743/2753/2754
[main_category] => 2754
[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
(
[1351] => Array
(
[video_id] => 1351
[video_type] => S
[company_id] => 0
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1720525345
[status] => A
[user_id] => 4935
[extra_params] =>
[community_video_id] => 0
[community_url] => https://www.kindlife.in/from-frazzled-to-fabulous-restore-your-hair-with-these-4-products-en
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1351_SaveInsta.App - 2964105165164035152_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1351_SaveInsta.App - 2964105165164035152.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => From Frazzled to Fabulous! Restore Your Hair with These 4 Products
[description] => Transform your hair care routine into a spa day with these must-haves:
@ashbabotanics Hydrating Shampoo - Dive into luxury with a hydrating formula that gently cleanses your hair and scalp.
@brillareindia Hair Fall Control Conditioner - Say goodbye to hair fall and thinning with this miracle worker that nourishes and strengthens your locks.
@thrivecotalks Hair Growth Serum - Experience fuller, softer hair with every drop, boosting growth and vitality effortlessly.
@truefrog_ Deep Conditioner Mask - Treat yourself to intense hydration and silky-smooth strands with this deep conditioning mask. Pamper your hair with love and care!
[short_description] =>
[privacy] => 1
[like_count] => 2
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] => 33295,10448,27488,10418
[category_id] => 23
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => Thriveco
)
)
Array
(
[10575] => Array
(
[product_id] => 10575
[product] => Hair Gowth Serum - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => TC000000
[hsn_code] => 3304
[status] => A
[list_price] => 1299.00
[amount] => 1
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1651227508
[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] => N
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 5
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] =>
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 1299.000000
[category_ids] => Array
(
[0] => 2396
[1] => 2754
)
[seo_name] => hair-growth-serum-50-ml
[seo_path] => 2743/2753/2754
[main_category] => 2754
[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
(
[1351] => Array
(
[video_id] => 1351
[video_type] => S
[company_id] => 0
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1720525345
[status] => A
[user_id] => 4935
[extra_params] =>
[community_video_id] => 0
[community_url] => https://www.kindlife.in/from-frazzled-to-fabulous-restore-your-hair-with-these-4-products-en
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1351_SaveInsta.App - 2964105165164035152_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1351_SaveInsta.App - 2964105165164035152.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => From Frazzled to Fabulous! Restore Your Hair with These 4 Products
[description] => Transform your hair care routine into a spa day with these must-haves:
@ashbabotanics Hydrating Shampoo - Dive into luxury with a hydrating formula that gently cleanses your hair and scalp.
@brillareindia Hair Fall Control Conditioner - Say goodbye to hair fall and thinning with this miracle worker that nourishes and strengthens your locks.
@thrivecotalks Hair Growth Serum - Experience fuller, softer hair with every drop, boosting growth and vitality effortlessly.
@truefrog_ Deep Conditioner Mask - Treat yourself to intense hydration and silky-smooth strands with this deep conditioning mask. Pamper your hair with love and care!
[short_description] =>
[privacy] => 1
[like_count] => 2
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] => 33295,10448,27488,10418
[category_id] => 23
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => Thriveco
)
)
end of fxn
Array
(
[show_master_products_only] =>
[area] => A
[extend] => Array
(
[0] => product_name
)
[pid] => Array
(
[0] => 10575
)
[group_child_variations] =>
[skip_rating] => 1
[sort_by] => null
[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
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' WHERE 1 AND companies.status IN ('A') AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0) AND ((1 AND products.product_id IN (10575)) AND companies.status IN ('A') AND products.company_id IN (13, 0) AND prices.usergroup_id IN (0)) GROUP BY products.product_id ORDER BY NULL asc
before end of oxn
Array
(
[10575] => Array
(
[product_id] => 10575
[product] => Hair Gowth Serum - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => TC000000
[hsn_code] => 3304
[status] => A
[list_price] => 1299.00
[amount] => 1
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1651227508
[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] => N
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 5
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] =>
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 1299.000000
[category_ids] => Array
(
[0] => 2396
[1] => 2754
)
[seo_name] => hair-growth-serum-50-ml
[seo_path] => 2743/2753/2754
[main_category] => 2754
[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
(
[1351] => Array
(
[video_id] => 1351
[video_type] => S
[company_id] => 0
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1720525345
[status] => A
[user_id] => 4935
[extra_params] =>
[community_video_id] => 0
[community_url] => https://www.kindlife.in/from-frazzled-to-fabulous-restore-your-hair-with-these-4-products-en
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1351_SaveInsta.App - 2964105165164035152_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1351_SaveInsta.App - 2964105165164035152.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => From Frazzled to Fabulous! Restore Your Hair with These 4 Products
[description] => Transform your hair care routine into a spa day with these must-haves:
@ashbabotanics Hydrating Shampoo - Dive into luxury with a hydrating formula that gently cleanses your hair and scalp.
@brillareindia Hair Fall Control Conditioner - Say goodbye to hair fall and thinning with this miracle worker that nourishes and strengthens your locks.
@thrivecotalks Hair Growth Serum - Experience fuller, softer hair with every drop, boosting growth and vitality effortlessly.
@truefrog_ Deep Conditioner Mask - Treat yourself to intense hydration and silky-smooth strands with this deep conditioning mask. Pamper your hair with love and care!
[short_description] =>
[privacy] => 1
[like_count] => 2
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] => 33295,10448,27488,10418
[category_id] => 23
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => Thriveco
)
)
Array
(
[10575] => Array
(
[product_id] => 10575
[product] => Hair Gowth Serum - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => TC000000
[hsn_code] => 3304
[status] => A
[list_price] => 1299.00
[amount] => 1
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1651227508
[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] => N
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 5
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] =>
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 1299.000000
[category_ids] => Array
(
[0] => 2396
[1] => 2754
)
[seo_name] => hair-growth-serum-50-ml
[seo_path] => 2743/2753/2754
[main_category] => 2754
[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
(
[1351] => Array
(
[video_id] => 1351
[video_type] => S
[company_id] => 0
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1720525345
[status] => A
[user_id] => 4935
[extra_params] =>
[community_video_id] => 0
[community_url] => https://www.kindlife.in/from-frazzled-to-fabulous-restore-your-hair-with-these-4-products-en
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1351_SaveInsta.App - 2964105165164035152_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1351_SaveInsta.App - 2964105165164035152.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => From Frazzled to Fabulous! Restore Your Hair with These 4 Products
[description] => Transform your hair care routine into a spa day with these must-haves:
@ashbabotanics Hydrating Shampoo - Dive into luxury with a hydrating formula that gently cleanses your hair and scalp.
@brillareindia Hair Fall Control Conditioner - Say goodbye to hair fall and thinning with this miracle worker that nourishes and strengthens your locks.
@thrivecotalks Hair Growth Serum - Experience fuller, softer hair with every drop, boosting growth and vitality effortlessly.
@truefrog_ Deep Conditioner Mask - Treat yourself to intense hydration and silky-smooth strands with this deep conditioning mask. Pamper your hair with love and care!
[short_description] =>
[privacy] => 1
[like_count] => 2
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] => 33295,10448,27488,10418
[category_id] => 23
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => Thriveco
)
)
end of fxn
Array
(
[show_master_products_only] =>
[area] => A
[extend] => Array
(
[0] => product_name
)
[pid] => Array
(
[0] => 10575
)
[group_child_variations] =>
[skip_rating] => 1
[sort_by] => null
[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
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' WHERE 1 AND companies.status IN ('A') AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0) AND ((1 AND products.product_id IN (10575)) AND companies.status IN ('A') AND products.company_id IN (13, 0) AND prices.usergroup_id IN (0)) GROUP BY products.product_id ORDER BY NULL asc
before end of oxn
Array
(
[10575] => Array
(
[product_id] => 10575
[product] => Hair Gowth Serum - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => TC000000
[hsn_code] => 3304
[status] => A
[list_price] => 1299.00
[amount] => 1
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1651227508
[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] => N
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 5
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] =>
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 1299.000000
[category_ids] => Array
(
[0] => 2396
[1] => 2754
)
[seo_name] => hair-growth-serum-50-ml
[seo_path] => 2743/2753/2754
[main_category] => 2754
[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
(
[1351] => Array
(
[video_id] => 1351
[video_type] => S
[company_id] => 0
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1720525345
[status] => A
[user_id] => 4935
[extra_params] =>
[community_video_id] => 0
[community_url] => https://www.kindlife.in/from-frazzled-to-fabulous-restore-your-hair-with-these-4-products-en
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1351_SaveInsta.App - 2964105165164035152_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1351_SaveInsta.App - 2964105165164035152.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => From Frazzled to Fabulous! Restore Your Hair with These 4 Products
[description] => Transform your hair care routine into a spa day with these must-haves:
@ashbabotanics Hydrating Shampoo - Dive into luxury with a hydrating formula that gently cleanses your hair and scalp.
@brillareindia Hair Fall Control Conditioner - Say goodbye to hair fall and thinning with this miracle worker that nourishes and strengthens your locks.
@thrivecotalks Hair Growth Serum - Experience fuller, softer hair with every drop, boosting growth and vitality effortlessly.
@truefrog_ Deep Conditioner Mask - Treat yourself to intense hydration and silky-smooth strands with this deep conditioning mask. Pamper your hair with love and care!
[short_description] =>
[privacy] => 1
[like_count] => 2
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] => 33295,10448,27488,10418
[category_id] => 23
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => Thriveco
)
)
Array
(
[10575] => Array
(
[product_id] => 10575
[product] => Hair Gowth Serum - 50ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => TC000000
[hsn_code] => 3304
[status] => A
[list_price] => 1299.00
[amount] => 1
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1651227508
[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] => N
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 5
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] =>
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 1299.000000
[category_ids] => Array
(
[0] => 2396
[1] => 2754
)
[seo_name] => hair-growth-serum-50-ml
[seo_path] => 2743/2753/2754
[main_category] => 2754
[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
(
[1351] => Array
(
[video_id] => 1351
[video_type] => S
[company_id] => 0
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1720525345
[status] => A
[user_id] => 4935
[extra_params] =>
[community_video_id] => 0
[community_url] => https://www.kindlife.in/from-frazzled-to-fabulous-restore-your-hair-with-these-4-products-en
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1351_SaveInsta.App - 2964105165164035152_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1351_SaveInsta.App - 2964105165164035152.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => From Frazzled to Fabulous! Restore Your Hair with These 4 Products
[description] => Transform your hair care routine into a spa day with these must-haves:
@ashbabotanics Hydrating Shampoo - Dive into luxury with a hydrating formula that gently cleanses your hair and scalp.
@brillareindia Hair Fall Control Conditioner - Say goodbye to hair fall and thinning with this miracle worker that nourishes and strengthens your locks.
@thrivecotalks Hair Growth Serum - Experience fuller, softer hair with every drop, boosting growth and vitality effortlessly.
@truefrog_ Deep Conditioner Mask - Treat yourself to intense hydration and silky-smooth strands with this deep conditioning mask. Pamper your hair with love and care!
[short_description] =>
[privacy] => 1
[like_count] => 2
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] => 33295,10448,27488,10418
[category_id] => 23
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => Thriveco
)
)
end of fxn
Express Shipping
Express Delivery
100% recyclable packaging
10 Days Return Policy
Details
ThriveCo Hair Growth Serum - the ultimate solution for hair loss and lackluster locks. This groundbreaking formula combines award-winning ingredients like Redensyl, Anagain, and Revolutionary Procapil to reactivate stem cells, encouraging better growth for fuller, denser hair. Say goodbye to thinning strands and hello to vibrant, confident hair. With ThriveCo, maintain hair and scalp health, fighting the root cause of hair loss. Unlock the magic of revitalized tresses as this game-changing serum strengthens from root to tip.
Featured Ingredient
Low hazard
Moderate hazard
High hazard
Best
Good
Fair
Average
Limited
Pisum Sativum (Pea) Extract is an extract of the pea, Pisum sativum.
Features
Confused about what's kind on, in and around your body? We're here to decode some key terms and what it means when a brand declares them! If a brand doesn't have at least one of these codes, they won't be listed on kindlife! Know more
Array
(
[show_master_products_only] =>
[area] => C
[for_required_product] => 10575
[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 = 10575 GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC
before end of oxn
Array ( )
Array ( )
end of fxn
How to use
Apply A Generous Amount Using The Dropper Directly To Your Scalp, Focussing On The Area Of Hair Loss. Massage Into Scalp Using Fingertips. Rinse Hands After. When To Use: Every Night Before Going To Bed As That Gives The Serum Enough Time To Work As You Sleep.
Related to watch
Reviews
5.0
- Comment
5.0
- Comment
4.0
- Comment
However I think its drying out my scalp - and making it flaky - not too sure given I used it in peak winter instead of oiling my hair.
Anonymous
5.0
- Comment
5.0
- Comment
4.0
- Comment
5.0
- Comment
kindcode
“Cruelty-Free” is a PETA provided certification to brands which do not conduct product tests on animals prior to sales. Considering the vulnerability of animals and their lack of ability to give consent doesn’t make it ethical to test products meant for human use on them. Hence products that are natural or plant based could be cruelty free only if they have not been tested on animals.
Advanced hair and skin care with breakthrough actives for visible transformation
Shop the Brand
Hi, I am kiki.AI, unlock your gateway to global beauty and health with AI-powered insights.
0
4
Added To Cart
Cruelty Free
Array
(
[show_master_products_only] =>
[area] => A
[extend] => Array
(
[0] => product_name
)
[pid] => Array
(
[0] => 35142
)
[group_child_variations] =>
[skip_rating] => 1
[sort_by] => null
[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
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' WHERE 1 AND companies.status IN ('A') AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0) AND ((1 AND products.product_id IN (35142)) AND companies.status IN ('A') AND products.company_id IN (13, 0) AND prices.usergroup_id IN (0)) GROUP BY products.product_id ORDER BY NULL asc
before end of oxn
Array
(
[35142] => Array
(
[product_id] => 35142
[product] => Natural Premium California Almonds - 500gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 571
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => Fabeato_Almond_500_G
[hsn_code] => 3304
[status] => A
[list_price] => 680.00
[amount] => 9769
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1698488527
[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] => N
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 5
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] =>
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 565.000000
[category_ids] => Array
(
[0] => 2648
)
[seo_name] => natural-premium-california-almonds-500gm
[seo_path] => 458/2646/2648
[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] => Fabeato
)
)
Array
(
[35142] => Array
(
[product_id] => 35142
[product] => Natural Premium California Almonds - 500gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 571
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => Fabeato_Almond_500_G
[hsn_code] => 3304
[status] => A
[list_price] => 680.00
[amount] => 9769
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1698488527
[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] => N
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 5
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] => 13
[age_verification] => N
[age_limit] => 0
[options_type] => P
[exceptions_type] => F
[details_layout] => default
[shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
[facebook_obj_type] =>
[buy_now_url] =>
[is_stock_split_by_warehouses] => N
[master_product_status] => A
[youtube_link] =>
[show_youtube_video] => Y
[replace_main_image] =>
[position_youtube] =>
[restrict_cod] => N
[price] => 565.000000
[category_ids] => Array
(
[0] => 2648
)
[seo_name] => natural-premium-california-almonds-500gm
[seo_path] => 458/2646/2648
[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] => Fabeato
)
)
end of fxn
Array
(
[show_master_products_only] =>
[area] => A
[extend] => Array
(
[0] => product_name
)
[pid] => Array
(
[0] => 35143
)
[group_child_variations] =>
[skip_rating] => 1
[sort_by] => null
[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
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' WHERE 1 AND companies.status IN ('A') AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0) AND ((1 AND products.product_id IN (35143)) AND companies.status IN ('A') AND products.company_id IN (13, 0) AND prices.usergroup_id IN (0)) GROUP BY products.product_id ORDER BY NULL asc
before end of oxn
Array
(
[35143] => Array
(
[product_id] => 35143
[product] => Natural Premium California Almonds - 1kg
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 571
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => Fabeato_Almond_1KG
[hsn_code] => 3304
[status] => A
[list_price] => 1350.00
[amount] => 9596
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1698488527
[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] => N
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 3
[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] => 1125.000000
[category_ids] => Array
(
[0] => 2648
)
[seo_name] => natural-premium-california-almonds-1kg
[seo_path] => 458/2646/2648
[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] => 3
[qty_step_raw] => 0
[list_qty_count_raw] => 0
[details_layout_raw] => default
[video_as_images] => Array
(
)
[videos] => Array
(
)
[brand_name] => Fabeato
)
)
Array
(
[35143] => Array
(
[product_id] => 35143
[product] => Natural Premium California Almonds - 1kg
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 571
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => Fabeato_Almond_1KG
[hsn_code] => 3304
[status] => A
[list_price] => 1350.00
[amount] => 9596
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1698488527
[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] => N
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 3
[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] => 1125.000000
[category_ids] => Array
(
[0] => 2648
)
[seo_name] => natural-premium-california-almonds-1kg
[seo_path] => 458/2646/2648
[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] => 3
[qty_step_raw] => 0
[list_qty_count_raw] => 0
[details_layout_raw] => default
[video_as_images] => Array
(
)
[videos] => Array
(
)
[brand_name] => Fabeato
)
)
end of fxn
