Kilage

Weekly Best Selling Groceries

Hand Picked Products for 10% Offer

231

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

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

Live Chat
Chat With an Experts

(default) 81 queries took 2691 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	1
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	1
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	1
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 `Slider`.`id`, `Slider`.`title`, `Slider`.`color_code`, `Slider`.`content`, `Slider`.`product_id`, `Product`.`slug` FROM `kilage_uat`.`sliders` AS `Slider` LEFT JOIN `kilage_uat`.`products` AS `Product` ON (`Slider`.`product_id` = `Product`.`id`) WHERE `Slider`.`status` = '1' ORDER BY `Slider`.`sequence` ASC	2	2	1
43	SELECT `Blog`.`id`, `Blog`.`title`, `Blog`.`details`, `Blog`.`writer_name`, `Blog`.`publish_date`, `Blog`.`user_id`, `Blog`.`status`, `Blog`.`created`, `User`.`id`, `User`.`role_id`, `User`.`staff_id`, `User`.`dealer_id`, `User`.`vendor_id`, `User`.`showroom_id`, `User`.`customer_id`, `User`.`corporateclient_id`, `User`.`manager_id`, `User`.`marketingrepresentative_id`, `User`.`salesrepresentative_id`, `User`.`username`, `User`.`password`, `User`.`gitax`, `User`.`sc`, `User`.`ship`, `User`.`vat`, `User`.`status`, `User`.`created`, `User`.`modified` FROM `kilage_uat`.`blogs` AS `Blog` LEFT JOIN `kilage_uat`.`users` AS `User` ON (`Blog`.`user_id` = `User`.`id`) WHERE `Blog`.`status` = 1 ORDER BY `Blog`.`created` DESC LIMIT 4	4	4	1
44	SELECT `Section`.`id`, `Section`.`name`, `Section`.`created`, `Section`.`modified` FROM `kilage_uat`.`sections` AS `Section` WHERE 1 = 1	1	1	1
45	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`, `SectionProduct`.`id`, `SectionProduct`.`section_id`, `SectionProduct`.`product_id`, `SectionProduct`.`created`, `SectionProduct`.`modified` FROM `kilage_uat`.`products` AS `Product` JOIN `kilage_uat`.`section_products` AS `SectionProduct` ON (`SectionProduct`.`section_id` = 3 AND `SectionProduct`.`product_id` = `Product`.`id`)	6	6	3
46	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`product_id` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 0 ORDER BY `sequence` ASC	34	34	1
47	SELECT `ChildCategory`.`id`, `ChildCategory`.`name`, `ChildCategory`.`is_home_best_selling_grocery`, `ChildCategory`.`slug`, `ChildCategory`.`parent_id` FROM `kilage_uat`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (73, 4, 81, 261, 9, 274, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 201, 205, 224, 229, 234, 241, 249, 254, 29, 28, 21, 30, 24, 20, 26, 27, 6, 15)	226	226	2
48	SELECT `Product`.*, SUM(`OrderDetail`.`qty`) AS total_sold, (CONCAT(`Product`.`name`, " -- " , `Product`.`unit_name`)) AS `Product__label` FROM `kilage_uat`.`products` AS `Product` INNER JOIN `kilage_uat`.`order_details` AS `OrderDetail` ON (`OrderDetail`.`product_id` = `Product`.`id`) INNER JOIN `kilage_uat`.`orders` AS `Order` ON (`Order`.`id` = `OrderDetail`.`order_id`) WHERE `Order`.`created` >= '2026-01-24 20:09:15' AND `Product`.`categories` LIKE '%,31,%' AND `Product`.`status` = '1' GROUP BY `Product`.`id` ORDER BY `total_sold` DESC LIMIT 10	0	0	5
49	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`product_id` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`is_trending` = '1' AND `Category`.`parent_id` = 0 ORDER BY `sequence` ASC	4	4	1
50	SELECT `ChildCategory`.`id`, `ChildCategory`.`name`, `ChildCategory`.`slug`, `ChildCategory`.`parent_id` FROM `kilage_uat`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (30, 24, 20, 27)	15	15	2
51	SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`price`, `Product`.`special_price`, `Product`.`unit_name`, `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%') ORDER BY `Product`.`created` DESC LIMIT 20	20	20	4
52	SELECT `Product`.*, SUM(`OrderDetail`.`qty`) AS total_sold, (CONCAT(`Product`.`name`, " -- " , `Product`.`unit_name`)) AS `Product__label` FROM `kilage_uat`.`products` AS `Product` LEFT JOIN `kilage_uat`.`order_details` AS `OrderDetail` ON (`OrderDetail`.`product_id` = `Product`.`id`) WHERE 1 = 1 GROUP BY `Product`.`id` ORDER BY `total_sold` DESC LIMIT 5	5	5	2635
53	SELECT `Section`.`id`, `Section`.`name`, `Section`.`created`, `Section`.`modified` FROM `kilage_uat`.`sections` AS `Section` WHERE `Section`.`name` = 'Weekly Best Seller Grocery' ORDER BY `Section`.`id` DESC	1	1	1
54	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`, `SectionProduct`.`id`, `SectionProduct`.`section_id`, `SectionProduct`.`product_id`, `SectionProduct`.`created`, `SectionProduct`.`modified` FROM `kilage_uat`.`products` AS `Product` JOIN `kilage_uat`.`section_products` AS `SectionProduct` ON (`SectionProduct`.`section_id` = 3 AND `SectionProduct`.`product_id` = `Product`.`id`)	6	6	0
55	SELECT `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` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`id` = 0	0	0	1
56	SELECT `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` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`id` = 0	0	0	0
57	SELECT `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` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`id` = 0	0	0	0
58	SELECT `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` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`id` = 0	0	0	0
59	SELECT `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` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`id` = 0	0	0	0
60	SELECT `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` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`id` = 0	0	0	0
61	SELECT `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`.`brands` AS `Brand` WHERE `Brand`.`id` = 43	1	1	1
62	SELECT `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`.`brands` AS `Brand` WHERE `Brand`.`id` = 43	1	1	0
63	SELECT `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`.`brands` AS `Brand` WHERE `Brand`.`id` = 43	1	1	0
64	SELECT `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`.`brands` AS `Brand` WHERE `Brand`.`id` = 43	1	1	0
65	SELECT `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`.`brands` AS `Brand` WHERE `Brand`.`id` = 43	1	1	0
66	SELECT `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`.`brands` AS `Brand` WHERE `Brand`.`id` = 43	1	1	0
67	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 (1005, 1006, 1007, 1008, 1009, 1010)	12	12	2
68	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 (1005, 1006, 1007, 1008, 1009, 1010)	90	90	1
69	SELECT `Dealerpurchasedetail`.`id`, `Dealerpurchasedetail`.`dealerpurchase_id`, `Dealerpurchasedetail`.`product_id`, `Dealerpurchasedetail`.`price`, `Dealerpurchasedetail`.`qty` FROM `kilage_uat`.`dealerpurchasedetails` AS `Dealerpurchasedetail` WHERE `Dealerpurchasedetail`.`product_id` IN (1005, 1006, 1007, 1008, 1009, 1010)	6	6	1
70	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 (1005, 1006, 1007, 1008, 1009, 1010)	141	141	2
71	SELECT `ProductImg`.`id`, `ProductImg`.`product_id` FROM `kilage_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` IN (1005, 1006, 1007, 1008, 1009, 1010)	9	9	2
72	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 (1005, 1006, 1007, 1008, 1009, 1010)	6	6	2
73	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 (1005, 1006, 1007, 1008, 1009, 1010)	3	3	2
74	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	3
75	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` FROM `kilage_uat`.`products` AS `Product` WHERE `Product`.`is_trending` = '1' ORDER BY `Product`.`created` DESC	7	7	4
76	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` FROM `kilage_uat`.`products` AS `Product` WHERE `Product`.`is_weekend_discount` = 1 AND `Product`.`status` = '1' ORDER BY `Product`.`created` DESC	1	1	2
77	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` FROM `kilage_uat`.`products` AS `Product` WHERE `Product`.`is_deal_of_the_day` = 1 AND `Product`.`d_from_time` <= '2026-01-31 20:09:17' AND `Product`.`d_to_time` >= '2026-01-31 20:09:17' AND `Product`.`status` = '1' ORDER BY `Product`.`created` DESC	0	0	1
78	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	1
79	SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug` FROM `kilage_uat`.`brands` AS `Brand` WHERE `status` = '1'	149	149	1
80	SELECT `Flashphoto`.`id`, `Flashphoto`.`product_id`, `Flashphoto`.`title_one`, `Flashphoto`.`title_two`, `Flashphoto`.`short_txt`, `Flashphoto`.`sequence`, `Flashphoto`.`status`, `Flashphoto`.`created`, `Flashphoto`.`modified` FROM `kilage_uat`.`flashphotos` AS `Flashphoto` WHERE `status` = '1' ORDER BY `sequence` ASC LIMIT 4	4	4	3
81	SELECT `Category`.`id`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `status` = '1'	261	261	2

(default) 81 queries took 2691 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 `Slider`.`id`, `Slider`.`title`, `Slider`.`color_code`, `Slider`.`content`, `Slider`.`product_id`, `Product`.`slug` FROM `kilage_uat`.`sliders` AS `Slider` LEFT JOIN `kilage_uat`.`products` AS `Product` ON (`Slider`.`product_id` = `Product`.`id`) WHERE `Slider`.`status` = '1' ORDER BY `Slider`.`sequence` ASC

SELECT `Blog`.`id`, `Blog`.`title`, `Blog`.`details`, `Blog`.`writer_name`, `Blog`.`publish_date`, `Blog`.`user_id`, `Blog`.`status`, `Blog`.`created`, `User`.`id`, `User`.`role_id`, `User`.`staff_id`, `User`.`dealer_id`, `User`.`vendor_id`, `User`.`showroom_id`, `User`.`customer_id`, `User`.`corporateclient_id`, `User`.`manager_id`, `User`.`marketingrepresentative_id`, `User`.`salesrepresentative_id`, `User`.`username`, `User`.`password`, `User`.`gitax`, `User`.`sc`, `User`.`ship`, `User`.`vat`, `User`.`status`, `User`.`created`, `User`.`modified` FROM `kilage_uat`.`blogs` AS `Blog` LEFT JOIN `kilage_uat`.`users` AS `User` ON (`Blog`.`user_id` = `User`.`id`) WHERE `Blog`.`status` = 1 ORDER BY `Blog`.`created` DESC LIMIT 4

SELECT `Section`.`id`, `Section`.`name`, `Section`.`created`, `Section`.`modified` FROM `kilage_uat`.`sections` AS `Section` 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`, `SectionProduct`.`id`, `SectionProduct`.`section_id`, `SectionProduct`.`product_id`, `SectionProduct`.`created`, `SectionProduct`.`modified` FROM `kilage_uat`.`products` AS `Product` JOIN `kilage_uat`.`section_products` AS `SectionProduct` ON (`SectionProduct`.`section_id` = 3 AND `SectionProduct`.`product_id` = `Product`.`id`)

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

SELECT `ChildCategory`.`id`, `ChildCategory`.`name`, `ChildCategory`.`is_home_best_selling_grocery`, `ChildCategory`.`slug`, `ChildCategory`.`parent_id` FROM `kilage_uat`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (73, 4, 81, 261, 9, 274, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 201, 205, 224, 229, 234, 241, 249, 254, 29, 28, 21, 30, 24, 20, 26, 27, 6, 15)

226

SELECT `Product`.*, SUM(`OrderDetail`.`qty`) AS total_sold, (CONCAT(`Product`.`name`, " -- " , `Product`.`unit_name`)) AS `Product__label` FROM `kilage_uat`.`products` AS `Product` INNER JOIN `kilage_uat`.`order_details` AS `OrderDetail` ON (`OrderDetail`.`product_id` = `Product`.`id`) INNER JOIN `kilage_uat`.`orders` AS `Order` ON (`Order`.`id` = `OrderDetail`.`order_id`) WHERE `Order`.`created` >= '2026-01-24 20:09:15' AND `Product`.`categories` LIKE '%,31,%' AND `Product`.`status` = '1' GROUP BY `Product`.`id` ORDER BY `total_sold` DESC LIMIT 10

SELECT `ChildCategory`.`id`, `ChildCategory`.`name`, `ChildCategory`.`slug`, `ChildCategory`.`parent_id` FROM `kilage_uat`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (30, 24, 20, 27)

SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`price`, `Product`.`special_price`, `Product`.`unit_name`, `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%') ORDER BY `Product`.`created` DESC LIMIT 20

2635

SELECT `Section`.`id`, `Section`.`name`, `Section`.`created`, `Section`.`modified` FROM `kilage_uat`.`sections` AS `Section` WHERE `Section`.`name` = 'Weekly Best Seller Grocery' ORDER BY `Section`.`id` DESC

SELECT `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` FROM `kilage_uat`.`categories` AS `Category` WHERE `Category`.`id` = 0

SELECT `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`.`brands` AS `Brand` WHERE `Brand`.`id` = 43

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 (1005, 1006, 1007, 1008, 1009, 1010)

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 (1005, 1006, 1007, 1008, 1009, 1010)

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

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 (1005, 1006, 1007, 1008, 1009, 1010)

141

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

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 (1005, 1006, 1007, 1008, 1009, 1010)

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 (1005, 1006, 1007, 1008, 1009, 1010)

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` FROM `kilage_uat`.`products` AS `Product` WHERE `Product`.`is_trending` = '1' ORDER BY `Product`.`created` DESC

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` FROM `kilage_uat`.`products` AS `Product` WHERE `Product`.`is_weekend_discount` = 1 AND `Product`.`status` = '1' ORDER BY `Product`.`created` DESC

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` FROM `kilage_uat`.`products` AS `Product` WHERE `Product`.`is_deal_of_the_day` = 1 AND `Product`.`d_from_time` <= '2026-01-31 20:09:17' AND `Product`.`d_to_time` >= '2026-01-31 20:09:17' AND `Product`.`status` = '1' ORDER BY `Product`.`created` DESC

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

SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug` FROM `kilage_uat`.`brands` AS `Brand` WHERE `status` = '1'

149

SELECT `Flashphoto`.`id`, `Flashphoto`.`product_id`, `Flashphoto`.`title_one`, `Flashphoto`.`title_two`, `Flashphoto`.`short_txt`, `Flashphoto`.`sequence`, `Flashphoto`.`status`, `Flashphoto`.`created`, `Flashphoto`.`modified` FROM `kilage_uat`.`flashphotos` AS `Flashphoto` WHERE `status` = '1' ORDER BY `sequence` ASC LIMIT 4

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

261

ddsgs

dacxvx

.

.

The Best Energy Booster For You

Our Garden Fresh Vegetables

The Best Energy Booster For You

Weekly Best Seller Grocery

Organic GastroGuard

৳550.00

Soya Diet (Mango Flavor)

৳890.00

Soya Protein (Chocolate Flavor)

৳890.00

Neem Leaf Powder (নিম পাতার গুড়া)

৳85.00

Triphala Powder (ত্রিফলা গুড়া)

৳80.00

Black Seed (কালোজিরা- Kalojira)

৳95.00

Best Prices & Offers

100% Return Policy

Best Quality Assurance

Delivery Within 30 Mins

Recently Added

Heavens Spanish Extra Virgin Olive Oil

Golden Fresh Mixed Plum

Top Selling

Ashwagandha (অশ্বগন্ধা) Powder

Acure Alkushi Powder (আলকুশি গুড়া)

Top Rated

Nestle Cerelac Mixed Fruits & Wheat with Milk

Nestle Cerelac Mixed Fruits & Wheat with Milk

Deals of the day

Healthy vegetable that you deserve to eat fresh

Hand Picked Products for 10% offers

Trending items

Discover Real organic Flavors Vegetable

Psyllium Husk (Isobgul Vusi)- ইসবগুলের ভুসি

Tulsi Powder (তুলসি গুঁড়া)

Acure Mixed Flower Honey - বিশুদ্ধ মধু

Featured Grocery Best Deal

Products With Discounts

Alpro Organic Flavored Fresh Juice

$15.00

Alpro Organic Flavored Fresh Juice

$15.00

Health Care Package-1

Acure Combo Package 1

Organic GastroGuard

Allergic Care Package (এলার্জি কেয়ার প্যাকেজ)

Weekly Best Selling Groceries

Hand Picked Products for 10% Offer

Pastine Mellin Filid Angelo 100% Di Grano Tenero

Pastine Mellin Filid Angelo 100% Di Grano Tenero

Pastine Mellin Filid Angelo 100% Di Grano Tenero

Acure Alkushi Powder (আলকুশি গুড়া) 100 Gram

Top Trending Products

Psyllium Husk (Isobgul Vusi)- ইসবগুলের ভুসি

Tulsi Powder (তুলসি গুঁড়া)

Acure Mixed Flower Honey - বিশুদ্ধ মধু

Pass Detox Foot Patch

Fenugreek Seed Powder (মেথি-Methi)

Neem Leaf Powder (নিম পাতার গুড়া)

Latest Blog Post Insights

ডায়াবেটিস নিয়ন্ত্রণের জন্য প্রাকৃতিক পণ্য সেবন করুন

শারীরিক শক্তি বাড়ানোর জন্য প্রাকৃতিক পণ্য

ইফতারিতে শরবত

ত্বীন ফলের ১৩ টি গোপন রহস্য যা আমাদের সুস্থ ও সুন্দর করে তোলে:

Our Stores

Information

Need Help? / Contact Us

Discover
Real organic
Flavors Vegetable

Alpro Organic Flavored
Fresh Juice

Alpro Organic Flavored
Fresh Juice

Acure Alkushi Powder (আলকুশি গুড়া)
100 Gram