Our Website Is Under Construction

Coming Soon...

(default) 18 queries took 20 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Meta`.`id`, `Meta`.`keyword`, `Meta`.`description`, `Meta`.`created_by`, `Meta`.`created_date`, `Meta`.`updated_date` FROM `hopestud_rajmahalsilks`.`meta` AS `Meta` WHERE 1 = 1 LIMIT 1112
2SELECT `pd`.*, COUNT(`Productsales`.`product_id`) as count, `Productsales`.`id` FROM `hopestud_rajmahalsilks`.`product_sales` AS `Productsales` LEFT JOIN `hopestud_rajmahalsilks`.`product` AS `Products` ON (`Productsales`.`product_id` = `Products`.`id`) LEFT JOIN `hopestud_rajmahalsilks`.`product` AS `pd` ON (`pd`.`id` = `Productsales`.`product_id`) WHERE 1 = 1 GROUP BY `Productsales`.`product_id` ORDER BY `count` DESC LIMIT 1114
3SELECT `Salesreturn`.`id`, `Salesreturn`.`product_sales_slno`, `Salesreturn`.`product_sale_id`, `Salesreturn`.`product_id`, `Salesreturn`.`sales_date`, `Salesreturn`.`sales_order_date`, `Salesreturn`.`total_unit`, `Salesreturn`.`price_per_unit_order`, `Salesreturn`.`total_amount`, `Salesreturn`.`reason_for_return`, `Salesreturn`.`amount_returned`, `Salesreturn`.`payment_method`, `Salesreturn`.`status`, `Salesreturn`.`created_by`, `Salesreturn`.`created_date`, `Salesreturn`.`modified_date` FROM `hopestud_rajmahalsilks`.`product_sales_return` AS `Salesreturn` WHERE `Salesreturn`.`product_sale_id` = (5)001
4SELECT `Offers`.`id`, `Offers`.`name`, `Offers`.`imageurl`, `Offers`.`description`, `Offers`.`offer`, `Offers`.`viewurl`, `Offers`.`status`, `Offers`.`start_date`, `Offers`.`end_date`, `Offers`.`created_on`, `Offers`.`updated_on` FROM `hopestud_rajmahalsilks`.`offers` AS `Offers` WHERE date(`Offers`.`start_date`)<=Now() AND date(`Offers`.`end_date`)>=Now() ORDER BY `Offers`.`id` DESC LIMIT 2001
5SELECT `Sliders`.`id`, `Sliders`.`imageurl`, `Sliders`.`caption`, `Sliders`.`order`, `Sliders`.`viewurl`, `Sliders`.`status`, `Sliders`.`created_by`, `Sliders`.`created_on`, `Sliders`.`updated_on` FROM `hopestud_rajmahalsilks`.`slider` AS `Sliders` WHERE 1 = 1 ORDER BY `id` DESC881
6SELECT `Productsdiscount`.*, `pd`.`name`, `pd`.`description`, `pd`.`image_url` FROM `hopestud_rajmahalsilks`.`product_discount` AS `Productsdiscount` LEFT JOIN `hopestud_rajmahalsilks`.`product` AS `pd` ON (`pd`.`id` = `Productsdiscount`.`product_id`) WHERE `Productsdiscount`.`is_front` = 1 AND date(`Productsdiscount`.`start_date_time`) <= Now() AND date(`Productsdiscount`.`end_date_time`)>=Now() ORDER BY `Productsdiscount`.`id` DESC001
7SELECT `Products`.*, `pd`.*, `Products`.`id` FROM `hopestud_rajmahalsilks`.`product` AS `Products` LEFT JOIN `hopestud_rajmahalsilks`.`product_discount` AS `pd` ON (`pd`.`product_id` = `Products`.`id` AND date(`pd`.`start_date_time`)<=Now() AND date(`pd`.`end_date_time`)>=Now()) LEFT JOIN `hopestud_rajmahalsilks`.`product_type` AS `pt` ON (`pt`.`product_id` = `Products`.`id`) WHERE `featured` = 1 AND `pt`.`quantity` != 0 ORDER BY `Products`.`id` DESC LIMIT 8882
8SELECT `Producttype`.`id`, `Producttype`.`product_id`, `Producttype`.`size_id`, `Producttype`.`color_id`, `Producttype`.`quantity`, `Producttype`.`total_unit_purchased`, `Producttype`.`price_per_unit_order`, `Producttype`.`price_per_unit_sales`, `Producttype`.`total_amount`, `Producttype`.`total_unit_stock`, `Producttype`.`batch_no`, `Producttype`.`shwninfrnt`, `Producttype`.`stcklimit`, `Producttype`.`created_date`, `Producttype`.`updated_date` FROM `hopestud_rajmahalsilks`.`product_type` AS `Producttype` WHERE `Producttype`.`product_id` IN (160, 125, 124, 123, 122, 121, 120, 119)880
9SELECT `Productsize`.`id`, `Productsize`.`name` FROM `hopestud_rajmahalsilks`.`product_size` AS `Productsize` WHERE 1 = 112121
10SELECT `Productcolor`.`id`, `Productcolor`.`name` FROM `hopestud_rajmahalsilks`.`product_color` AS `Productcolor` WHERE 1 = 120201
11SELECT `Products`.*, `pt`.`id`, `pt`.`price_per_unit_sales`, `Products`.`id` FROM `hopestud_rajmahalsilks`.`product` AS `Products` LEFT JOIN `hopestud_rajmahalsilks`.`product_type` AS `pt` ON (`pt`.`product_id` = `Products`.`id`) WHERE `pt`.`price_per_unit_sales` != 0 AND `pt`.`quantity` != 0 ORDER BY `Products`.`id` DESC LIMIT 6661
12SELECT `Producttype`.`id`, `Producttype`.`product_id`, `Producttype`.`size_id`, `Producttype`.`color_id`, `Producttype`.`quantity`, `Producttype`.`total_unit_purchased`, `Producttype`.`price_per_unit_order`, `Producttype`.`price_per_unit_sales`, `Producttype`.`total_amount`, `Producttype`.`total_unit_stock`, `Producttype`.`batch_no`, `Producttype`.`shwninfrnt`, `Producttype`.`stcklimit`, `Producttype`.`created_date`, `Producttype`.`updated_date` FROM `hopestud_rajmahalsilks`.`product_type` AS `Producttype` WHERE `Producttype`.`product_id` IN (198, 197, 196, 195, 194, 193)660
13SELECT `Products`.`id`, `Products`.`rajmahal_id`, `Products`.`menu_id`, `Products`.`product_category_id`, `Products`.`product_subcategory_id`, `Products`.`product_brand_id`, `Products`.`name`, `Products`.`description`, `Products`.`men`, `Products`.`women`, `Products`.`kids`, `Products`.`price_type`, `Products`.`gender`, `Products`.`price`, `Products`.`meta_tag`, `Products`.`image_url`, `Products`.`image_url1`, `Products`.`image_url2`, `Products`.`image_url3`, `Products`.`image_url4`, `Products`.`ylink1`, `Products`.`status`, `Products`.`featured`, `Products`.`created_by`, `Products`.`created_date`, `Products`.`modified_date` FROM `hopestud_rajmahalsilks`.`product` AS `Products` WHERE 1 = 190901
14SELECT `Producttype`.`id`, `Producttype`.`product_id`, `Producttype`.`size_id`, `Producttype`.`color_id`, `Producttype`.`quantity`, `Producttype`.`total_unit_purchased`, `Producttype`.`price_per_unit_order`, `Producttype`.`price_per_unit_sales`, `Producttype`.`total_amount`, `Producttype`.`total_unit_stock`, `Producttype`.`batch_no`, `Producttype`.`shwninfrnt`, `Producttype`.`stcklimit`, `Producttype`.`created_date`, `Producttype`.`updated_date` FROM `hopestud_rajmahalsilks`.`product_type` AS `Producttype` WHERE `Producttype`.`product_id` IN (104, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 117, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 135, 136, 137, 138, 139, 140, 141, 142, 143, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198)89891
15SELECT `Menunew`.*, `prd`.`id` FROM `hopestud_rajmahalsilks`.`menunew` AS `Menunew` INNER JOIN `hopestud_rajmahalsilks`.`product` AS `prd` ON (`prd`.`menu_id` = `Menunew`.`id`) WHERE 1 = 1 GROUP BY `Menunew`.`name` ORDER BY `Menunew`.`display_order` ASC111
16SELECT `Productsdiscount`.`id`, `Productsdiscount`.`product_id`, `Productsdiscount`.`is_percentage`, `Productsdiscount`.`amount`, `Productsdiscount`.`percentage`, `Productsdiscount`.`is_front`, `Productsdiscount`.`start_date_time`, `Productsdiscount`.`end_date_time`, `Productsdiscount`.`status`, `Productsdiscount`.`created_by`, `Productsdiscount`.`created_date`, `Productsdiscount`.`modified_date` FROM `hopestud_rajmahalsilks`.`product_discount` AS `Productsdiscount` WHERE date(`Productsdiscount`.`start_date_time`)<=Now() AND date(`Productsdiscount`.`end_date_time`)>=Now() ORDER BY `Productsdiscount`.`id` DESC000
17SELECT `Categorynew`.*, `prd`.`id`, count(`prd`.`product_category_id`) as prdcat FROM `hopestud_rajmahalsilks`.`categorynew` AS `Categorynew` LEFT JOIN `hopestud_rajmahalsilks`.`product` AS `prd` ON (`prd`.`product_category_id` = `Categorynew`.`id`) WHERE `Categorynew`.`menu_id` = 2 GROUP BY `Categorynew`.`cat_name` ORDER BY `Categorynew`.`display_order` ASC991
18SELECT `Subcategorynew`.*, `prd`.`id`, count(`prd`.`product_subcategory_id`) as prdsubcat FROM `hopestud_rajmahalsilks`.`subcategorynew` AS `Subcategorynew` RIGHT JOIN `hopestud_rajmahalsilks`.`product` AS `prd` ON (`prd`.`product_subcategory_id` = `Subcategorynew`.`id`) WHERE `Subcategorynew`.`menu_id` = 2 AND `Subcategorynew`.`category_id` = 26 GROUP BY `Subcategorynew`.`subcategoryname` ORDER BY `Subcategorynew`.`display_order` ASC221