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 ?: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 = 37997 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 ?: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 = 37997
    
  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] => 37997
        [include_child_variations] => 1
        [group_child_variations] => 
        [runtime_company_id] => 13
        [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 (37997)) 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 (37997)) 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] => 37997
        [total] => 1
        [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
                            )
    
                    )
    
            )
    
        [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
    )
    
    
Skin :: Moisturisers :: Cream moisturisers :: Super Calming Moisturiser - Well-Being made easy | Clean Beauty, Healthy Snacks, Wellness brands
  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 (3963)) 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 (3963)) 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] => 3963
        [total] => 1
        [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
                            )
    
                    )
    
            )
    
        [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
    (
    )
    
    
  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 (10098)) 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 (10098)) 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] => 10098
        [total] => 1
        [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
                            )
    
                    )
    
            )
    
        [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] => 23660
                [product] => Beta Glucan Daily Moisture Cream - 60ml
                [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
            )
    
    )
    
    
  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 (23660)) 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 (23660)) 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] => 23660
        [total] => 1
        [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
                            )
    
                    )
    
            )
    
        [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
    (
    )
    
    
  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 (13926)) 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 (13926)) 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] => 13926
        [total] => 1
        [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
                            )
    
                    )
    
            )
    
        [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
    (
    )
    
    
  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 (39129)) 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 (39129)) 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] => 39129
        [total] => 1
        [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
                            )
    
                    )
    
            )
    
        [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
    (
    )
    
    
  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 (65548)) 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 (65548)) 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] => 65548
        [total] => 1
        [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
                            )
    
                    )
    
            )
    
        [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
    (
    )
    
    
  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 (65541)) 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 (65541)) 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] => 65541
        [total] => 1
        [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
                            )
    
                    )
    
            )
    
        [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
    (
    )
    
    
  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 (3967)) 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 (3967)) 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] => 3967
        [total] => 1
        [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
                            )
    
                    )
    
            )
    
        [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
    )
    
    

Extra 5% off on all Kbeauty orders above ₹999

KLOVE

Copied

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+

  1. Array
    (
        [0] => Array
            (
                [product_id] => 37997
                [product] => Super Calming Moisturiser
                [supplier_id] => 686
                [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 (37997)) 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 (37997)) 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] => 37997
            )
    
        [group_child_variations] => 
        [skip_rating] => 1
        [sort_by] => null
        [runtime_company_id] => 13
        [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
    )
    
    
Viah: Super Calming Moisturiser
  1. Array
    (
        [0] => Array
            (
                [product_id] => 37997
                [product] => Super Calming Moisturiser
                [supplier_id] => 686
                [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 (37997)) 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 (37997)) 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] => 37997
            )
    
        [group_child_variations] => 
        [skip_rating] => 1
        [sort_by] => null
        [runtime_company_id] => 13
        [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
    )
    
    
  1. Array
    (
        [0] => Array
            (
                [product_id] => 37997
                [product] => Super Calming Moisturiser
                [supplier_id] => 686
                [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 (37997)) 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 (37997)) 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] => 37997
            )
    
        [group_child_variations] => 
        [skip_rating] => 1
        [sort_by] => null
        [runtime_company_id] => 13
        [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
    )
    
    
  1. Array
    (
        [0] => Array
            (
                [product_id] => 37997
                [product] => Super Calming Moisturiser
                [supplier_id] => 686
                [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 (37997)) 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 (37997)) 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] => 37997
            )
    
        [group_child_variations] => 
        [skip_rating] => 1
        [sort_by] => null
        [runtime_company_id] => 13
        [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
    )
    
    
  1. Array
    (
        [0] => Array
            (
                [product_id] => 37997
                [product] => Super Calming Moisturiser
                [supplier_id] => 686
                [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 (37997)) 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 (37997)) 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] => 37997
            )
    
        [group_child_variations] => 
        [skip_rating] => 1
        [sort_by] => null
        [runtime_company_id] => 13
        [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
    )
    
    
  1. Array
    (
        [0] => Array
            (
                [product_id] => 37997
                [product] => Super Calming Moisturiser
                [supplier_id] => 686
                [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 (37997)) 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 (37997)) 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] => 37997
            )
    
        [group_child_variations] => 
        [skip_rating] => 1
        [sort_by] => null
        [runtime_company_id] => 13
        [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
    )
    
    
  1. Array
    (
        [0] => Array
            (
                [product_id] => 37997
                [product] => Super Calming Moisturiser
                [supplier_id] => 686
                [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 (37997)) 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 (37997)) 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] => 37997
            )
    
        [group_child_variations] => 
        [skip_rating] => 1
        [sort_by] => null
        [runtime_company_id] => 13
        [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
    )
    
    

Super Calming Moisturiser

Provides soothing, restorative, and glowing.

Compare

Share

20.25
21.32
Save: ₹80 (5%)
i

Price details

  • Maximum retail price incl. of all taxes
    21.32
  • Total Discount 80
Special Price
20.25
46
kinders earned

Delivery

Your box of happiness will be shipped in 2-4 business days.
Cash on delivery available on orders above ₹499
100% recyclable packaging
10 Days Return Policy
Available offers
  • Use SUMVIBE10 & Get Flat 10% off on orders above Rs. 1999.
  • Use SUNKISS5 & Get Flat 5% off on orders above Rs. 999.
Details
Features
How to use
Related to watch
Reviews
kindcode

Details

This luxurious moisturizer shields against UV rays with Oubaku Liquid, while lightening acne scars and spots. Enriched with Floral Honey, it hydrates and soothes, reducing dryness and preventing wrinkles. Infused with Rose Myrtle Berry, it reinforces the skin barrier and retains texture. The formula brightens and improves skin tone, keeping your complexion glowing, supple, and well-moisturized.








Read More

Features

Brand:
Viah
Key Ingredients:
  • Australian Lime Caviar
  • Oubaku & Jiou Liquid
  • Rose Myrtle Berry
Ingredients:
  • Aqua, Propanediol, Rhodomyrtus Tomentosa Fruit Extract, Sodium Polyacrylate, C13-14 Isoparaffin, Laureth-7, Xylitylglucoside, Anhydroxylitol, Xylitol, Hamamelis Virginiana (Witch Hazel) Extract,...Read more
kindcode
:
  • Cruelty Free

Additional Information

Net Content:
Single Unit(s)
Net Weight:
238gm
Net Volume:
50ml
Expiry or Best Before Month:
24

Dimensions

Breadth:
8cm
Height:
7cm
Length:
8cm
  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 ?: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 = 37997 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 ?: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 = 37997
    
  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] => 37997
        [include_child_variations] => 1
        [group_child_variations] => 
        [runtime_company_id] => 13
        [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
    )
    
    

How to use

Cleanse: Apply the Ultra-Clarifying & Balancing Cleanser, rinse, and pat dry.Tone: Use the pH Balancing & Energising Toner on a cotton pad, gently apply to your face, and let it dry. Moisturize: Apply a coin-sized amount of Super Calming Moisturiser, massaging upward. Protect: In the morning, finish with Full Spectrum Sunscreen. For best results, use both AM and PM.

Related to watch

Reviews

No reviews found

kindcode

  • Cruelty Free

    “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.

Viah

Vegan cruelty-free beauty for conscious radiant self-care

Shop the Brand

kiki.AI

Hi, I am kiki.AI, unlock your gateway to global beauty and health with AI-powered insights.

Compare with similar items

Similar Products

Recently viewed

Server

Request

Config

SQL

Cache queries

Logging

Templates

Blocks