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 23 ms
    NrQueryErrorAffectedNum. rowsTook (ms)
    1SELECT `HomeProduct`.`type` FROM `scrap_new1`.`home_products` AS `HomeProduct` WHERE 1 = 1 GROUP BY `HomeProduct`.`type` LIMIT 10115
    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 4445
    3SELECT `OfferCategory`.`name` FROM `scrap_new1`.`offer_categories` AS `OfferCategory` WHERE `OfferCategory`.`status` = '1' LIMIT 2223
    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 8883
    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 8887