Kilage

Corporate Office: Road-03, BLock-C, Mirpur-12

Call us Sat -Thr / 10:00am - 8:00pm
01309466377

Live Chat
Chat With an Experts

(default) 52 queries took 5 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 0 ORDER BY `Category`.`sequence` ASC	34	34	0
2	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 73 ORDER BY `Category`.`sequence` ASC	0	0	0
3	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 4 ORDER BY `Category`.`sequence` ASC	10	10	0
4	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 81 ORDER BY `Category`.`sequence` ASC	0	0	0
5	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 261 ORDER BY `Category`.`sequence` ASC	7	7	0
6	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 9 ORDER BY `Category`.`sequence` ASC	5	5	0
7	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 274 ORDER BY `Category`.`sequence` ASC	19	19	0
8	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 82 ORDER BY `Category`.`sequence` ASC	14	14	0
9	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 83 ORDER BY `Category`.`sequence` ASC	12	12	0
10	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 84 ORDER BY `Category`.`sequence` ASC	9	9	0
11	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 85 ORDER BY `Category`.`sequence` ASC	10	10	0
12	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 86 ORDER BY `Category`.`sequence` ASC	10	10	0
13	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 87 ORDER BY `Category`.`sequence` ASC	10	10	0
14	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 88 ORDER BY `Category`.`sequence` ASC	10	10	0
15	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 89 ORDER BY `Category`.`sequence` ASC	9	9	0
16	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 90 ORDER BY `Category`.`sequence` ASC	10	10	0
17	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 91 ORDER BY `Category`.`sequence` ASC	10	10	0
18	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 201 ORDER BY `Category`.`sequence` ASC	9	9	0
19	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 205 ORDER BY `Category`.`sequence` ASC	18	18	0
20	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 224 ORDER BY `Category`.`sequence` ASC	4	4	0
21	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 229 ORDER BY `Category`.`sequence` ASC	4	4	0
22	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 234 ORDER BY `Category`.`sequence` ASC	4	4	0
23	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 241 ORDER BY `Category`.`sequence` ASC	6	6	0
24	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 249 ORDER BY `Category`.`sequence` ASC	4	4	0
25	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 254 ORDER BY `Category`.`sequence` ASC	6	6	0
26	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 29 ORDER BY `Category`.`sequence` ASC	2	2	0
27	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 28 ORDER BY `Category`.`sequence` ASC	4	4	0
28	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 21 ORDER BY `Category`.`sequence` ASC	4	4	0
29	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 30 ORDER BY `Category`.`sequence` ASC	8	8	0
30	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 24 ORDER BY `Category`.`sequence` ASC	5	5	0
31	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 20 ORDER BY `Category`.`sequence` ASC	2	2	0
32	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 26 ORDER BY `Category`.`sequence` ASC	0	0	0
33	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 27 ORDER BY `Category`.`sequence` ASC	0	0	0
34	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 6 ORDER BY `Category`.`sequence` ASC	0	0	0
35	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 15 ORDER BY `Category`.`sequence` ASC	0	0	0
36	SELECT `Config`.`key`, `Config`.`value` FROM `kilage_uat`.`configs` AS `Config` WHERE 1 = 1	51	51	0
37	BEGIN	0	0	0
38	ROLLBACK	0	0	0
39	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `status` = '1' AND `parent_id` = 0 ORDER BY `Category`.`sequence` ASC	34	34	0
40	SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `status` = '1' AND parent_id > 0 ORDER BY `sequence` ASC	227	227	0
41	SELECT `News`.`id`, `News`.`title`, `News`.`color_code` FROM `kilage_uat`.`news` AS `News` WHERE `type` = '1' AND `status` = '1' ORDER BY `sequence` ASC	0	0	0
42	SELECT `TrendingProduct`.`id`, `TrendingProduct`.`product_id`, `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`barcode`, `Product`.`parent_id`, `Product`.`category_id`, `Product`.`categories`, `Product`.`brand_id`, `Product`.`model`, `Product`.`specification`, `Product`.`details`, `Product`.`details_en`, `Product`.`details_bn`, `Product`.`meta_des`, `Product`.`meta_tag`, `Product`.`p_price`, `Product`.`price`, `Product`.`special_price`, `Product`.`special_pricep`, `Product`.`wholesale_price`, `Product`.`wholesale_pricep`, `Product`.`dealer_price`, `Product`.`dealer_pricep`, `Product`.`showroom_price`, `Product`.`showroom_pricep`, `Product`.`stock`, `Product`.`sold_qty`, `Product`.`unit`, `Product`.`unit_value`, `Product`.`unit_name`, `Product`.`offer_type`, `Product`.`is_corporate_porduct`, `Product`.`meta_title`, `Product`.`meta_key`, `Product`.`meta_description`, `Product`.`rating`, `Product`.`avg_rating`, `Product`.`status`, `Product`.`is_trending`, `Product`.`created`, `Product`.`modified`, `Product`.`viewtime`, `Product`.`totalview`, `Product`.`is_deal_of_the_day`, `Product`.`d_from_time`, `Product`.`d_to_time`, `Product`.`d_dis_price`, `Product`.`is_weekend_discount`, `Product`.`w_dis_price`, `Product`.`vendor_id`, (CONCAT(`Product`.`name`, " -- " , `Product`.`unit_name`)) AS `Product__label` FROM `kilage_uat`.`trending_products` AS `TrendingProduct` LEFT JOIN `kilage_uat`.`products` AS `Product` ON (`TrendingProduct`.`product_id` = `Product`.`id`) WHERE 1 = 1	2	2	1
43	SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`barcode`, `Product`.`parent_id`, `Product`.`category_id`, `Product`.`categories`, `Product`.`brand_id`, `Product`.`model`, `Product`.`specification`, `Product`.`details`, `Product`.`details_en`, `Product`.`details_bn`, `Product`.`meta_des`, `Product`.`meta_tag`, `Product`.`p_price`, `Product`.`price`, `Product`.`special_price`, `Product`.`special_pricep`, `Product`.`wholesale_price`, `Product`.`wholesale_pricep`, `Product`.`dealer_price`, `Product`.`dealer_pricep`, `Product`.`showroom_price`, `Product`.`showroom_pricep`, `Product`.`stock`, `Product`.`sold_qty`, `Product`.`unit`, `Product`.`unit_value`, `Product`.`unit_name`, `Product`.`offer_type`, `Product`.`is_corporate_porduct`, `Product`.`meta_title`, `Product`.`meta_key`, `Product`.`meta_description`, `Product`.`rating`, `Product`.`avg_rating`, `Product`.`status`, `Product`.`is_trending`, `Product`.`created`, `Product`.`modified`, `Product`.`viewtime`, `Product`.`totalview`, `Product`.`is_deal_of_the_day`, `Product`.`d_from_time`, `Product`.`d_to_time`, `Product`.`d_dis_price`, `Product`.`is_weekend_discount`, `Product`.`w_dis_price`, `Product`.`vendor_id`, (CONCAT(`Product`.`name`, " -- " , `Product`.`unit_name`)) AS `Product__label`, `Category`.`id`, `Category`.`parent_id`, `Category`.`product_id`, `Category`.`name`, `Category`.`slug`, `Category`.`icon`, `Category`.`spec`, `Category`.`sequence`, `Category`.`meta_key`, `Category`.`meta_description`, `Category`.`status`, `Category`.`is_trending`, `Category`.`created`, `Category`.`modified`, `Category`.`is_home_best_selling_grocery`, `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, `Brand`.`code`, `Brand`.`spec`, `Brand`.`sequence`, `Brand`.`meta_key`, `Brand`.`meta_description`, `Brand`.`status`, `Brand`.`created`, `Brand`.`modified` FROM `kilage_uat`.`products` AS `Product` LEFT JOIN `kilage_uat`.`categories` AS `Category` ON (`Product`.`category_id` = `Category`.`id`) LEFT JOIN `kilage_uat`.`brands` AS `Brand` ON (`Product`.`brand_id` = `Brand`.`id`) WHERE `Product`.`id` IN (1005, 1006) ORDER BY `Product`.`created` DESC LIMIT 10	2	2	0
44	SELECT `Dealerproduct`.`id`, `Dealerproduct`.`product_id`, `Dealerproduct`.`dealer_id`, `Dealerproduct`.`stock`, `Dealerproduct`.`price`, `Dealerproduct`.`d_price`, `Dealerproduct`.`t_price`, `Dealerproduct`.`d_pricep`, `Dealerproduct`.`t_pricep`, `Dealerproduct`.`status` FROM `kilage_uat`.`dealerproducts` AS `Dealerproduct` WHERE `Dealerproduct`.`product_id` IN (1006, 1005)	4	4	0
45	SELECT `Showroomproduct`.`id`, `Showroomproduct`.`product_id`, `Showroomproduct`.`showroom_id`, `Showroomproduct`.`stock`, `Showroomproduct`.`price`, `Showroomproduct`.`d_price`, `Showroomproduct`.`t_price`, `Showroomproduct`.`d_pricep`, `Showroomproduct`.`t_pricep`, `Showroomproduct`.`status` FROM `kilage_uat`.`showroomproducts` AS `Showroomproduct` WHERE `Showroomproduct`.`product_id` IN (1006, 1005)	30	30	0
46	SELECT `Dealerpurchasedetail`.`id`, `Dealerpurchasedetail`.`dealerpurchase_id`, `Dealerpurchasedetail`.`product_id`, `Dealerpurchasedetail`.`price`, `Dealerpurchasedetail`.`qty` FROM `kilage_uat`.`dealerpurchasedetails` AS `Dealerpurchasedetail` WHERE `Dealerpurchasedetail`.`product_id` IN (1006, 1005)	1	1	0
47	SELECT `OrderDetail`.`id`, `OrderDetail`.`order_id`, `OrderDetail`.`product_id`, `OrderDetail`.`price`, `OrderDetail`.`qty`, `OrderDetail`.`total_price` FROM `kilage_uat`.`order_details` AS `OrderDetail` WHERE `OrderDetail`.`product_id` IN (1006, 1005)	20	20	1
48	SELECT `ProductImg`.`id`, `ProductImg`.`product_id` FROM `kilage_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` IN (1006, 1005)	2	2	1
49	SELECT `PurchaseDetail`.`id`, `PurchaseDetail`.`purchase_id`, `PurchaseDetail`.`product_id`, `PurchaseDetail`.`p_price`, `PurchaseDetail`.`price`, `PurchaseDetail`.`qty` FROM `kilage_uat`.`purchase_details` AS `PurchaseDetail` WHERE `PurchaseDetail`.`product_id` IN (1006, 1005)	0	0	0
50	SELECT `Review`.`id`, `Review`.`product_id`, `Review`.`name`, `Review`.`summary`, `Review`.`rating`, `Review`.`email`, `Review`.`status`, `Review`.`created`, `Review`.`mobile_number` FROM `kilage_uat`.`reviews` AS `Review` WHERE `Review`.`product_id` IN (1006, 1005)	1	1	0
51	SELECT `Category`.`id`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `status` = '1'	261	261	0
52	SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`price`, `Product`.`special_price`, `Product`.`unit_name`, `Product`.`offer_type`, `Product`.`brand_id` FROM `kilage_uat`.`products` AS `Product` WHERE `Product`.`status` = '1' AND (`Product`.`is_corporate_porduct` LIKE '%3%' OR `Product`.`is_corporate_porduct` LIKE '%4%') AND offer_type >0 ORDER BY `Product`.`modified` DESC LIMIT 20	16	16	2

(default) 52 queries took 5 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 0 ORDER BY `Category`.`sequence` ASC

SELECT `Config`.`key`, `Config`.`value` FROM `kilage_uat`.`configs` AS `Config` WHERE 1 = 1

BEGIN

ROLLBACK

SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `status` = '1' AND `parent_id` = 0 ORDER BY `Category`.`sequence` ASC

SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `status` = '1' AND parent_id > 0 ORDER BY `sequence` ASC

227

SELECT `News`.`id`, `News`.`title`, `News`.`color_code` FROM `kilage_uat`.`news` AS `News` WHERE `type` = '1' AND `status` = '1' ORDER BY `sequence` ASC

SELECT `TrendingProduct`.`id`, `TrendingProduct`.`product_id`, `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`barcode`, `Product`.`parent_id`, `Product`.`category_id`, `Product`.`categories`, `Product`.`brand_id`, `Product`.`model`, `Product`.`specification`, `Product`.`details`, `Product`.`details_en`, `Product`.`details_bn`, `Product`.`meta_des`, `Product`.`meta_tag`, `Product`.`p_price`, `Product`.`price`, `Product`.`special_price`, `Product`.`special_pricep`, `Product`.`wholesale_price`, `Product`.`wholesale_pricep`, `Product`.`dealer_price`, `Product`.`dealer_pricep`, `Product`.`showroom_price`, `Product`.`showroom_pricep`, `Product`.`stock`, `Product`.`sold_qty`, `Product`.`unit`, `Product`.`unit_value`, `Product`.`unit_name`, `Product`.`offer_type`, `Product`.`is_corporate_porduct`, `Product`.`meta_title`, `Product`.`meta_key`, `Product`.`meta_description`, `Product`.`rating`, `Product`.`avg_rating`, `Product`.`status`, `Product`.`is_trending`, `Product`.`created`, `Product`.`modified`, `Product`.`viewtime`, `Product`.`totalview`, `Product`.`is_deal_of_the_day`, `Product`.`d_from_time`, `Product`.`d_to_time`, `Product`.`d_dis_price`, `Product`.`is_weekend_discount`, `Product`.`w_dis_price`, `Product`.`vendor_id`, (CONCAT(`Product`.`name`, " -- " , `Product`.`unit_name`)) AS `Product__label` FROM `kilage_uat`.`trending_products` AS `TrendingProduct` LEFT JOIN `kilage_uat`.`products` AS `Product` ON (`TrendingProduct`.`product_id` = `Product`.`id`) WHERE 1 = 1

SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`barcode`, `Product`.`parent_id`, `Product`.`category_id`, `Product`.`categories`, `Product`.`brand_id`, `Product`.`model`, `Product`.`specification`, `Product`.`details`, `Product`.`details_en`, `Product`.`details_bn`, `Product`.`meta_des`, `Product`.`meta_tag`, `Product`.`p_price`, `Product`.`price`, `Product`.`special_price`, `Product`.`special_pricep`, `Product`.`wholesale_price`, `Product`.`wholesale_pricep`, `Product`.`dealer_price`, `Product`.`dealer_pricep`, `Product`.`showroom_price`, `Product`.`showroom_pricep`, `Product`.`stock`, `Product`.`sold_qty`, `Product`.`unit`, `Product`.`unit_value`, `Product`.`unit_name`, `Product`.`offer_type`, `Product`.`is_corporate_porduct`, `Product`.`meta_title`, `Product`.`meta_key`, `Product`.`meta_description`, `Product`.`rating`, `Product`.`avg_rating`, `Product`.`status`, `Product`.`is_trending`, `Product`.`created`, `Product`.`modified`, `Product`.`viewtime`, `Product`.`totalview`, `Product`.`is_deal_of_the_day`, `Product`.`d_from_time`, `Product`.`d_to_time`, `Product`.`d_dis_price`, `Product`.`is_weekend_discount`, `Product`.`w_dis_price`, `Product`.`vendor_id`, (CONCAT(`Product`.`name`, " -- " , `Product`.`unit_name`)) AS `Product__label`, `Category`.`id`, `Category`.`parent_id`, `Category`.`product_id`, `Category`.`name`, `Category`.`slug`, `Category`.`icon`, `Category`.`spec`, `Category`.`sequence`, `Category`.`meta_key`, `Category`.`meta_description`, `Category`.`status`, `Category`.`is_trending`, `Category`.`created`, `Category`.`modified`, `Category`.`is_home_best_selling_grocery`, `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, `Brand`.`code`, `Brand`.`spec`, `Brand`.`sequence`, `Brand`.`meta_key`, `Brand`.`meta_description`, `Brand`.`status`, `Brand`.`created`, `Brand`.`modified` FROM `kilage_uat`.`products` AS `Product` LEFT JOIN `kilage_uat`.`categories` AS `Category` ON (`Product`.`category_id` = `Category`.`id`) LEFT JOIN `kilage_uat`.`brands` AS `Brand` ON (`Product`.`brand_id` = `Brand`.`id`) WHERE `Product`.`id` IN (1005, 1006) ORDER BY `Product`.`created` DESC LIMIT 10

SELECT `Dealerproduct`.`id`, `Dealerproduct`.`product_id`, `Dealerproduct`.`dealer_id`, `Dealerproduct`.`stock`, `Dealerproduct`.`price`, `Dealerproduct`.`d_price`, `Dealerproduct`.`t_price`, `Dealerproduct`.`d_pricep`, `Dealerproduct`.`t_pricep`, `Dealerproduct`.`status` FROM `kilage_uat`.`dealerproducts` AS `Dealerproduct` WHERE `Dealerproduct`.`product_id` IN (1006, 1005)

SELECT `Showroomproduct`.`id`, `Showroomproduct`.`product_id`, `Showroomproduct`.`showroom_id`, `Showroomproduct`.`stock`, `Showroomproduct`.`price`, `Showroomproduct`.`d_price`, `Showroomproduct`.`t_price`, `Showroomproduct`.`d_pricep`, `Showroomproduct`.`t_pricep`, `Showroomproduct`.`status` FROM `kilage_uat`.`showroomproducts` AS `Showroomproduct` WHERE `Showroomproduct`.`product_id` IN (1006, 1005)

SELECT `Dealerpurchasedetail`.`id`, `Dealerpurchasedetail`.`dealerpurchase_id`, `Dealerpurchasedetail`.`product_id`, `Dealerpurchasedetail`.`price`, `Dealerpurchasedetail`.`qty` FROM `kilage_uat`.`dealerpurchasedetails` AS `Dealerpurchasedetail` WHERE `Dealerpurchasedetail`.`product_id` IN (1006, 1005)

SELECT `OrderDetail`.`id`, `OrderDetail`.`order_id`, `OrderDetail`.`product_id`, `OrderDetail`.`price`, `OrderDetail`.`qty`, `OrderDetail`.`total_price` FROM `kilage_uat`.`order_details` AS `OrderDetail` WHERE `OrderDetail`.`product_id` IN (1006, 1005)

SELECT `ProductImg`.`id`, `ProductImg`.`product_id` FROM `kilage_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` IN (1006, 1005)

SELECT `PurchaseDetail`.`id`, `PurchaseDetail`.`purchase_id`, `PurchaseDetail`.`product_id`, `PurchaseDetail`.`p_price`, `PurchaseDetail`.`price`, `PurchaseDetail`.`qty` FROM `kilage_uat`.`purchase_details` AS `PurchaseDetail` WHERE `PurchaseDetail`.`product_id` IN (1006, 1005)

SELECT `Review`.`id`, `Review`.`product_id`, `Review`.`name`, `Review`.`summary`, `Review`.`rating`, `Review`.`email`, `Review`.`status`, `Review`.`created`, `Review`.`mobile_number` FROM `kilage_uat`.`reviews` AS `Review` WHERE `Review`.`product_id` IN (1006, 1005)

SELECT `Category`.`id`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `status` = '1'

261

SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`price`, `Product`.`special_price`, `Product`.`unit_name`, `Product`.`offer_type`, `Product`.`brand_id` FROM `kilage_uat`.`products` AS `Product` WHERE `Product`.`status` = '1' AND (`Product`.`is_corporate_porduct` LIKE '%3%' OR `Product`.`is_corporate_porduct` LIKE '%4%') AND offer_type >0 ORDER BY `Product`.`modified` DESC LIMIT 20

Widget Price Filter

Soya Diet (Mango Flavor)

Organic GastroGuard

Our Stores

Information

Need Help? / Contact Us