OFFER: Minimum 10% Discount On All Books. Contact Us On Whatsapp +917405479678 For Any Support

Welcome to Dhoomkharidi - Gujarat's own Web Store

Menu

For Men

Items 1 to 24 of 88 total

per page

Page:
  1. 1
  2. 2
  3. 3
  4. 4

Items 1 to 24 of 88 total

per page

Page:
  1. 1
  2. 2
  3. 3
  4. 4
Shop By

Filter

Price
  1. ₹0.00 - ₹359.99 (10)
  2. ₹390.00 - ₹390.00 (8)
  3. ₹399.00 - ₹399.00 (59)
  4. ₹400.00 and above (11)
Brand
  1. Mee Mee (1)
Theme
  1. Bikers (5)
  2. Festival (2)
  3. Filmy (7)
  4. Funky (37)
  5. Ganpati (4)
  6. GJ Series (7)
  7. Lord Shiva (7)
  8. Message (9)
  9. Nation (9)
  10. No Shave (3)
  11. Religious (16)
  12. Valentines (6)
New Products
  1. New (4)

Best Seller

Information
Customer Services
Extras
My Account
© All rights reserved Dhoomkharidi.com
Payment methods
[profiler]
Memory usage: real: 28835840, emalloc: 27522016
Code ProfilerTimeCntEmallocRealMem
Executed 514 queries in 5.7030627727509 seconds
Average query length: 0.011095452865274 seconds
Queries per second: 90.127010780222
Longest query length: 5.1965777873993
Longest query: 
SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `e`.`name`, `e`.`short_description`, `e`.`sku`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`small_image`, `e`.`thumbnail`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`status`, `e`.`url_key`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`tax_class_id`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`pages`, `e`.`author`, `e`.`author_value`, `e`.`is_pre_order`, `e`.`release_note`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`name`, `e`.`short_description`, `e`.`sku`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`cost`, `e`.`weight`, `e`.`small_image`, `e`.`thumbnail`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`status`, `e`.`url_key`, `e`.`url_path`, `e`.`is_recurring`, `e`.`recurring_profile`, `e`.`visibility`, `e`.`required_options`, `e`.`has_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`created_at`, `e`.`updated_at`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`tax_class_id`, `e`.`gift_message_available`, `e`.`price_type`, `e`.`sku_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`links_purchased_separately`, `e`.`links_title`, `e`.`links_exist`, `e`.`author`, `e`.`author_value`, `e`.`is_pre_order`, `e`.`pages`, `e`.`release_note`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `at_category_id`.`category_id`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`name`, `e`.`short_description`, `e`.`sku`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`cost`, `e`.`weight`, `e`.`small_image`, `e`.`thumbnail`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`status`, `e`.`url_key`, `e`.`url_path`, `e`.`is_recurring`, `e`.`recurring_profile`, `e`.`visibility`, `e`.`required_options`, `e`.`has_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`created_at`, `e`.`updated_at`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`tax_class_id`, `e`.`gift_message_available`, `e`.`price_type`, `e`.`sku_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`links_purchased_separately`, `e`.`links_title`, `e`.`links_exist`, `e`.`author`, `e`.`author_value`, `e`.`is_pre_order`, `e`.`pages`, `e`.`release_note`, SUM(aggregation.qty_ordered) AS `sold_quantity`, `cat_index`.`position` AS `cat_index_position` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
 LEFT JOIN `catalog_category_product` AS `at_category_id` ON (at_category_id.`product_id`=e.entity_id)
 LEFT JOIN `sales_bestsellers_aggregated_monthly` AS `aggregation` ON e.entity_id = aggregation.product_id AND aggregation.store_id=1
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '2' WHERE (e.status = 1) GROUP BY `e`.`entity_id` ORDER BY `sold_quantity` DESC, `e`.`created_at` ASC LIMIT 8