1. Array
(
    [0] => Array
        (
            [product_id] => 9117
            [product] => Vegan Vitamin B12 Melts - 30 Oral Strips
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 96
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
        )

)


  2. SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_features_values as var_val_73 ON var_val_73.product_id = products.product_id AND var_val_73.lang_code = 'en' AND var_val_73.feature_id = 73 LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:master_products_storefront_offers_count AS master_products_storefront_offers_count  ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  WHERE 1  AND (var_val_73.variant_id IN (20946)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.parent_product_id = 0 AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) AND (1 AND products.product_id IN (8920,8921,8922,8939,8961,8962,8964,9022,9035,9036,9037,9098,9099,9100,9101,9108,9109,9110,9111,9116,9117,9124,9125,9127,9132,9136,9142,9143,9145,9147,9148,9149,9153,9162,9163,9169,9171,9172,9174,9175,9177,9178,9179,9191,9208,9678,9754,9755,9756,9757,9759,9760,9761,9762,9807,9813,9815,9816,9820,9821,9822,10608,10612,10613,10619,10620,10638,10639,10674,10675,10680,11113,11114,11115,11116,11158,11176,11182,12086,12132,12494,12495,12496,12497,12498,12499,12500,12502,12515,12516,12518,12539,12540,12541,12542,12543,12545,12546,12548,12551,12562,12563,12698,12872,14463,15552,15554,20271,20276,21054,21780,21781,21798,21812,23623,23624,23636,23637,24440,24441,24565,24573,24576,24579,24583,24596,24597,25170,25451,25480,25775,27090,27140,27170,27171,27950,27952,27953,27954,27956,27960,27977,27978,28277,28278,28305,28318,28656,29016,29017,29018,29141,29142,29143,29481,29482,29483,31399,31464,31641,31650,31846,31847,31854,32607,32611,32619,32620,32621,32701,33398,33624,33629,33726,33743,33778,33779,33780,35442,35443,35481,35483,35485,35486,35487,35488,35489,35492,35512,35513,35629,35707,35712,35715,35733,35805,35832,35833,35847,35849,35866,35870,35872,35881,35882,35895,35896,35899,35902,36252,36253,36254,36255,36256,36257,36258,36259,36260,36261,36262,36263,36343,36344,36345,36346,36347,36348,36349,36350,36351,36352,36746,36747)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount asc, products.product_id ASC  LIMIT 0, 48

  3. SELECT COUNT(*) FROM ?:products as products  LEFT JOIN ?:product_features_values as var_val_73 ON var_val_73.product_id = products.product_id AND var_val_73.lang_code = 'en' AND var_val_73.feature_id = 73 LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:master_products_storefront_offers_count AS master_products_storefront_offers_count  ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  WHERE 1  AND (var_val_73.variant_id IN (20946)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.parent_product_id = 0 AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) AND (1 AND products.product_id IN (8920,8921,8922,8939,8961,8962,8964,9022,9035,9036,9037,9098,9099,9100,9101,9108,9109,9110,9111,9116,9117,9124,9125,9127,9132,9136,9142,9143,9145,9147,9148,9149,9153,9162,9163,9169,9171,9172,9174,9175,9177,9178,9179,9191,9208,9678,9754,9755,9756,9757,9759,9760,9761,9762,9807,9813,9815,9816,9820,9821,9822,10608,10612,10613,10619,10620,10638,10639,10674,10675,10680,11113,11114,11115,11116,11158,11176,11182,12086,12132,12494,12495,12496,12497,12498,12499,12500,12502,12515,12516,12518,12539,12540,12541,12542,12543,12545,12546,12548,12551,12562,12563,12698,12872,14463,15552,15554,20271,20276,21054,21780,21781,21798,21812,23623,23624,23636,23637,24440,24441,24565,24573,24576,24579,24583,24596,24597,25170,25451,25480,25775,27090,27140,27170,27171,27950,27952,27953,27954,27956,27960,27977,27978,28277,28278,28305,28318,28656,29016,29017,29018,29141,29142,29143,29481,29482,29483,31399,31464,31641,31650,31846,31847,31854,32607,32611,32619,32620,32621,32701,33398,33624,33629,33726,33743,33778,33779,33780,35442,35443,35481,35483,35485,35486,35487,35488,35489,35492,35512,35513,35629,35707,35712,35715,35733,35805,35832,35833,35847,35849,35866,35870,35872,35881,35882,35895,35896,35899,35902,36252,36253,36254,36255,36256,36257,36258,36259,36260,36261,36262,36263,36343,36344,36345,36346,36347,36348,36349,36350,36351,36352,36746,36747))

  4. Array
(
    [area] => C
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
            [3] => categories
            [4] => description
            [5] => description
            [6] => full_description
            [7] => categories
            [8] => sales
            [9] => companies
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 28-20946
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 48
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [product_id] => 
    [show_master_products_only] => 
    [sort_order] => asc
    [sl] => en
    [dispatch] => categories.view
    [category_id] => 2210
    [save_view_results] => product_id
    [sort_by] => bestsellers
    [subcats] => Y
    [runtime_company_id] => 0
    [vr_company_id] => 0
    [is_virtual] => Y
    [virtual_conditions] => Array
        (
            [set] => all
            [set_value] => 1
            [conditions] => Array
                (
                    [1] => Array
                        (
                            [operator] => in
                            [condition] => products
                            [value] => 8920,8921,8922,8939,8961,8962,8964,9022,9035,9036,9037,9098,9099,9100,9101,9108,9109,9110,9111,9116,9117,9124,9125,9127,9132,9136,9142,9143,9145,9147,9148,9149,9153,9162,9163,9169,9171,9172,9174,9175,9177,9178,9179,9191,9208,9678,9754,9755,9756,9757,9759,9760,9761,9762,9807,9813,9815,9816,9820,9821,9822,10608,10612,10613,10619,10620,10638,10639,10674,10675,10680,11113,11114,11115,11116,11158,11176,11182,12086,12132,12494,12495,12496,12497,12498,12499,12500,12502,12515,12516,12518,12539,12540,12541,12542,12543,12545,12546,12548,12551,12562,12563,12698,12872,14463,15552,15554,20271,20276,21054,21780,21781,21798,21812,23623,23624,23636,23637,24440,24441,24565,24573,24576,24579,24583,24596,24597,25170,25451,25480,25775,27090,27140,27170,27171,27950,27952,27953,27954,27956,27960,27977,27978,28277,28278,28305,28318,28656,29016,29017,29018,29141,29142,29143,29481,29482,29483,31399,31464,31641,31650,31846,31847,31854,32607,32611,32619,32620,32621,32701,33398,33624,33629,33726,33743,33778,33779,33780,35442,35443,35481,35483,35485,35486,35487,35488,35489,35492,35512,35513,35629,35707,35712,35715,35733,35805,35832,35833,35847,35849,35866,35870,35872,35881,35882,35895,35896,35899,35902,36252,36253,36254,36255,36256,36257,36258,36259,36260,36261,36262,36263,36343,36344,36345,36346,36347,36348,36349,36350,36351,36352,36746,36747
                        )

                )

        )

    [hide_out_of_stock_products] => 
    [for_current_storefront] => 1
    [company_status] => A
    [usergroup_ids] => Array
        (
            [0] => 0
            [1] => 1
        )

    [include_child_variations] => 
    [group_child_variations] => 
    [parent_product_id] => 0
    [sort_order_rev] => desc
    [total_items] => 1
)


  1. Array
(
)


  2. 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)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  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 (9117)) 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

  3. SELECT COUNT(*) 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)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  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 (9117)) 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))

  4. Array
(
    [area] => C
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => categories
            [2] => categories
            [3] => sales
            [4] => companies
        )

    [custom_extend] => Array
        (
            [0] => product_name
            [1] => categories
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 1
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 1
    [apply_disabled_filters] => 
    [load_products_extra_data] => 
    [storefront] => 
    [company_ids] => 
    [product_id] => 
    [show_master_products_only] => 
    [pid] => 9117
    [total] => 1
    [force_virtual] => 1
    [runtime_company_id] => 0
    [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
                        )

                )

        )

    [hide_out_of_stock_products] => 
    [sort_by] => bestsellers
    [sort_order] => desc
    [for_current_storefront] => 1
    [company_status] => A
    [usergroup_ids] => Array
        (
            [0] => 0
            [1] => 1
        )

    [include_child_variations] => 1
    [group_child_variations] => 
    [sort_order_rev] => asc
    [total_items] => 1
)


  1. Array
(
    [0] => Array
        (
            [product_id] => 9117
            [product] => Vegan Vitamin B12 Melts - 30 Oral Strips
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 96
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
        )

)


  2. SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_features_values as var_val_73 ON var_val_73.product_id = products.product_id AND var_val_73.lang_code = 'en' AND var_val_73.feature_id = 73 LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:master_products_storefront_offers_count AS master_products_storefront_offers_count  ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  WHERE 1  AND (var_val_73.variant_id IN (20946)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.parent_product_id = 0 AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) AND (1 AND products.product_id IN (8920,8921,8922,8939,8961,8962,8964,9022,9035,9036,9037,9098,9099,9100,9101,9108,9109,9110,9111,9116,9117,9124,9125,9127,9132,9136,9142,9143,9145,9147,9148,9149,9153,9162,9163,9169,9171,9172,9174,9175,9177,9178,9179,9191,9208,9678,9754,9755,9756,9757,9759,9760,9761,9762,9807,9813,9815,9816,9820,9821,9822,10608,10612,10613,10619,10620,10638,10639,10674,10675,10680,11113,11114,11115,11116,11158,11176,11182,12086,12132,12494,12495,12496,12497,12498,12499,12500,12502,12515,12516,12518,12539,12540,12541,12542,12543,12545,12546,12548,12551,12562,12563,12698,12872,14463,15552,15554,20271,20276,21054,21780,21781,21798,21812,23623,23624,23636,23637,24440,24441,24565,24573,24576,24579,24583,24596,24597,25170,25451,25480,25775,27090,27140,27170,27171,27950,27952,27953,27954,27956,27960,27977,27978,28277,28278,28305,28318,28656,29016,29017,29018,29141,29142,29143,29481,29482,29483,31399,31464,31641,31650,31846,31847,31854,32607,32611,32619,32620,32621,32701,33398,33624,33629,33726,33743,33778,33779,33780,35442,35443,35481,35483,35485,35486,35487,35488,35489,35492,35512,35513,35629,35707,35712,35715,35733,35805,35832,35833,35847,35849,35866,35870,35872,35881,35882,35895,35896,35899,35902,36252,36253,36254,36255,36256,36257,36258,36259,36260,36261,36262,36263,36343,36344,36345,36346,36347,36348,36349,36350,36351,36352,36746,36747)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount asc, products.product_id ASC  LIMIT 0, 48

  3. SELECT COUNT(*) FROM ?:products as products  LEFT JOIN ?:product_features_values as var_val_73 ON var_val_73.product_id = products.product_id AND var_val_73.lang_code = 'en' AND var_val_73.feature_id = 73 LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:master_products_storefront_offers_count AS master_products_storefront_offers_count  ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  WHERE 1  AND (var_val_73.variant_id IN (20946)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.parent_product_id = 0 AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) AND (1 AND products.product_id IN (8920,8921,8922,8939,8961,8962,8964,9022,9035,9036,9037,9098,9099,9100,9101,9108,9109,9110,9111,9116,9117,9124,9125,9127,9132,9136,9142,9143,9145,9147,9148,9149,9153,9162,9163,9169,9171,9172,9174,9175,9177,9178,9179,9191,9208,9678,9754,9755,9756,9757,9759,9760,9761,9762,9807,9813,9815,9816,9820,9821,9822,10608,10612,10613,10619,10620,10638,10639,10674,10675,10680,11113,11114,11115,11116,11158,11176,11182,12086,12132,12494,12495,12496,12497,12498,12499,12500,12502,12515,12516,12518,12539,12540,12541,12542,12543,12545,12546,12548,12551,12562,12563,12698,12872,14463,15552,15554,20271,20276,21054,21780,21781,21798,21812,23623,23624,23636,23637,24440,24441,24565,24573,24576,24579,24583,24596,24597,25170,25451,25480,25775,27090,27140,27170,27171,27950,27952,27953,27954,27956,27960,27977,27978,28277,28278,28305,28318,28656,29016,29017,29018,29141,29142,29143,29481,29482,29483,31399,31464,31641,31650,31846,31847,31854,32607,32611,32619,32620,32621,32701,33398,33624,33629,33726,33743,33778,33779,33780,35442,35443,35481,35483,35485,35486,35487,35488,35489,35492,35512,35513,35629,35707,35712,35715,35733,35805,35832,35833,35847,35849,35866,35870,35872,35881,35882,35895,35896,35899,35902,36252,36253,36254,36255,36256,36257,36258,36259,36260,36261,36262,36263,36343,36344,36345,36346,36347,36348,36349,36350,36351,36352,36746,36747))

  4. Array
(
    [area] => C
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
            [3] => categories
            [4] => description
            [5] => description
            [6] => full_description
            [7] => categories
            [8] => sales
            [9] => companies
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 28-20946
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 48
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [product_id] => 
    [show_master_products_only] => 
    [sort_order] => asc
    [sl] => en
    [dispatch] => categories.view
    [category_id] => 2210
    [save_view_results] => product_id
    [sort_by] => bestsellers
    [subcats] => Y
    [runtime_company_id] => 0
    [vr_company_id] => 0
    [is_virtual] => Y
    [virtual_conditions] => Array
        (
            [set] => all
            [set_value] => 1
            [conditions] => Array
                (
                    [1] => Array
                        (
                            [operator] => in
                            [condition] => products
                            [value] => 8920,8921,8922,8939,8961,8962,8964,9022,9035,9036,9037,9098,9099,9100,9101,9108,9109,9110,9111,9116,9117,9124,9125,9127,9132,9136,9142,9143,9145,9147,9148,9149,9153,9162,9163,9169,9171,9172,9174,9175,9177,9178,9179,9191,9208,9678,9754,9755,9756,9757,9759,9760,9761,9762,9807,9813,9815,9816,9820,9821,9822,10608,10612,10613,10619,10620,10638,10639,10674,10675,10680,11113,11114,11115,11116,11158,11176,11182,12086,12132,12494,12495,12496,12497,12498,12499,12500,12502,12515,12516,12518,12539,12540,12541,12542,12543,12545,12546,12548,12551,12562,12563,12698,12872,14463,15552,15554,20271,20276,21054,21780,21781,21798,21812,23623,23624,23636,23637,24440,24441,24565,24573,24576,24579,24583,24596,24597,25170,25451,25480,25775,27090,27140,27170,27171,27950,27952,27953,27954,27956,27960,27977,27978,28277,28278,28305,28318,28656,29016,29017,29018,29141,29142,29143,29481,29482,29483,31399,31464,31641,31650,31846,31847,31854,32607,32611,32619,32620,32621,32701,33398,33624,33629,33726,33743,33778,33779,33780,35442,35443,35481,35483,35485,35486,35487,35488,35489,35492,35512,35513,35629,35707,35712,35715,35733,35805,35832,35833,35847,35849,35866,35870,35872,35881,35882,35895,35896,35899,35902,36252,36253,36254,36255,36256,36257,36258,36259,36260,36261,36262,36263,36343,36344,36345,36346,36347,36348,36349,36350,36351,36352,36746,36747
                        )

                )

        )

    [hide_out_of_stock_products] => 
    [for_current_storefront] => 1
    [company_status] => A
    [usergroup_ids] => Array
        (
            [0] => 0
            [1] => 1
        )

    [include_child_variations] => 
    [group_child_variations] => 
    [parent_product_id] => 0
    [sort_order_rev] => desc
    [total_items] => 1
)


  1. Array
(
)


  2. 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)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:master_products_storefront_offers_count AS master_products_storefront_offers_count  ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  LEFT JOIN ?:product_required_products ON products.product_id = ?:product_required_products.required_id WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) AND ?:product_required_products.product_id = 9117 GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC 

  3. SELECT COUNT(*) 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)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:master_products_storefront_offers_count AS master_products_storefront_offers_count  ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  LEFT JOIN ?:product_required_products ON products.product_id = ?:product_required_products.required_id WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) AND ?:product_required_products.product_id = 9117

  4. Array
(
    [area] => C
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
            [3] => categories
            [4] => sales
            [5] => companies
        )

    [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] => 
    [show_master_products_only] => 
    [for_required_product] => 9117
    [include_child_variations] => 1
    [group_child_variations] => 
    [runtime_company_id] => 0
    [hide_out_of_stock_products] => 
    [sort_by] => bestsellers
    [sort_order] => desc
    [for_current_storefront] => 1
    [company_status] => A
    [usergroup_ids] => Array
        (
            [0] => 0
            [1] => 1
        )

    [sort_order_rev] => asc
    [total_items] => 0
)


  1. Array
(
)


  2. 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)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  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 (9117)) 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

  3. SELECT COUNT(*) 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)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  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 (9117)) 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))

  4. Array
(
    [area] => C
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => categories
            [2] => categories
            [3] => sales
            [4] => companies
        )

    [custom_extend] => Array
        (
            [0] => product_name
            [1] => categories
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 1
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 1
    [apply_disabled_filters] => 
    [load_products_extra_data] => 
    [storefront] => 
    [company_ids] => 
    [product_id] => 
    [show_master_products_only] => 
    [pid] => 9117
    [total] => 1
    [force_virtual] => 1
    [runtime_company_id] => 0
    [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
                        )

                )

        )

    [hide_out_of_stock_products] => 
    [sort_by] => bestsellers
    [sort_order] => desc
    [for_current_storefront] => 1
    [company_status] => A
    [usergroup_ids] => Array
        (
            [0] => 0
            [1] => 1
        )

    [include_child_variations] => 1
    [group_child_variations] => 
    [sort_order_rev] => asc
    [total_items] => 1
)
Multivitamins

Extra 5% off on all Kbeauty orders above ₹999

KLOVE

Copied

Discover with Ai
Community

Multivitamins

Filters

Filters
Brand
Price

₹  –  ₹

  • ‎₹141
  • ‎₹4050
Certification
Kind Code
Express Shipping
reset Apply

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+

Multivitamins

  • Cognitive (Brain & Neuro) Health
Filters
Bestselling: Low to High
1 Products Found 
  1. Array
(
    [0] => Array
        (
            [product_id] => 9117
            [product] => Vegan Vitamin B12 Melts - 30 Oral Strips
            [supplier_id] => 96
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
        )

)


  2. SELECT products.product_id, descr1.product as product, ?: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 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   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (9117)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc 

  3. SELECT COUNT(*) 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 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   LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (9117)) AND prices.usergroup_id IN (0))

  4. Array
(
    [area] => A
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
            [3] => product_name
        )

    [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] => 
    [show_master_products_only] => 
    [pid] => Array
        (
            [0] => 9117
        )

    [group_child_variations] => 
    [skip_rating] => 1
    [sort_by] => null
    [runtime_company_id] => 0
    [hide_out_of_stock_products] => 
    [sort_order] => asc
    [usergroup_ids] => Array
        (
            [0] => 0
            [1] => 1
        )

    [include_child_variations] => 1
    [sort_order_rev] => desc
    [total_items] => 1
)
Wellbeing Nutrition: Vegan Vitamin B12 Melts - 30 Oral Strips
Wellbeing Nutrition
Vegan Vitamin B12 Melts - 30 Oral Strips
4.7
 (3)
Out of stock
Notify me
i
We will notify you, when product is back in stock.
0 Items selected Move to Collection

Tygh\Exceptions\AException

Message

Cache: can not connect to the Redis server

Error at

app/Tygh/Backend/Cache/Redis.php, line: 220

Backtrace

File:app/Tygh/Backend/Cache/Redis.php
Line:217
Function:query
File:app/Tygh/Backend/Cache/Redis.php
Line:217
Function:query
File:app/Tygh/Backend/Cache/Redis.php
Line:217
Function:query
File:app/Tygh/Backend/Cache/Redis.php
Line:217
Function:query
File:app/Tygh/Backend/Cache/Redis.php
Line:97
Function:query
File:app/Tygh/Registry.php
Line:456
Function:set
File:app/Tygh/Registry.php
Line:95
Function:_saveCache
File:app/Tygh/Debugger.php
Line:329
Function:set
File:app/functions/fn.control.php
Line:658
Function:display
File:index.php
Line:38
Function:fn_dispatch