Call us : 032 2352 782

NEW ARRIVALS

REVIVE YOUR WARDROBE WITH CHIC KNITS

TUXEDO

REVIVE YOUR WARDROBE WITH CHIC KNITS

SWEATER

REVIVE YOUR WARDROBE WITH CHIC KNITS

Special Offers

Carousel Product Cart Slider

  • follow us on
  • (default) 5 queries took 3 ms
    NrQueryErrorAffectedNum. rowsTook (ms)
    1SELECT `HomeProduct`.`type` FROM `scrap_new1`.`home_products` AS `HomeProduct` WHERE 1 = 1 GROUP BY `HomeProduct`.`type` LIMIT 10110
    2SELECT `Product`.`id`, (COLUMN_JSON(`Product`.`details`)) AS `HomeProduct__product_details` FROM `scrap_new1`.`home_products` AS `HomeProduct` LEFT JOIN `scrap_new1`.`products` AS `Product` ON (`HomeProduct`.`product_id` = `Product`.`id`) WHERE `HomeProduct`.`type` = 'Featured' LIMIT 4441
    3SELECT `OfferCategory`.`name` FROM `scrap_new1`.`offer_categories` AS `OfferCategory` WHERE `OfferCategory`.`status` = '1' LIMIT 2220
    4SELECT `Offer`.`id`, `Offer`.`category`, (COLUMN_GET(`Offer`.`details`, 'title' as char(225))) AS `Offer__title`, (COLUMN_GET(`Offer`.`details`, 'description' as char(225))) AS `Offer__description`, (COLUMN_GET(`Offer`.`details`, 'url' as char(225))) AS `Offer__url`, (COLUMN_GET(`Offer`.`details`, 'imageUrl' as char(225))) AS `Offer__imageUrl`, (COLUMN_GET(`Offer`.`details`, 'imgMid' as char(225))) AS `Offer__imgMid` FROM `scrap_new1`.`offers` AS `Offer` WHERE `category` = 'automotive' LIMIT 8881
    5SELECT `Offer`.`id`, `Offer`.`category`, (COLUMN_GET(`Offer`.`details`, 'title' as char(225))) AS `Offer__title`, (COLUMN_GET(`Offer`.`details`, 'description' as char(225))) AS `Offer__description`, (COLUMN_GET(`Offer`.`details`, 'url' as char(225))) AS `Offer__url`, (COLUMN_GET(`Offer`.`details`, 'imageUrl' as char(225))) AS `Offer__imageUrl`, (COLUMN_GET(`Offer`.`details`, 'imgMid' as char(225))) AS `Offer__imgMid` FROM `scrap_new1`.`offers` AS `Offer` WHERE `category` = 'home_decor' LIMIT 8881