FREE delivery & 40% Discount for next 3 orders! Place your 1st order in kilage.com.
Discover premium quality products at Kilage.com. Designed with modern style, comfort, and durability in mind, each item is carefully selected to ensure the best experience for you. Shop now and enjoy trusted quality at the best price.
Assorted ৳ 1150Copyright 2025 ©Kilage. All rights reserved.
Download App
| Nr | Query | Error | 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 `Product`.`totalview`, `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`price`, `Product`.`categories`, `Product`.`brand_id`, `Product`.`special_price`, `Product`.`unit_name`, `Product`.`meta_title`, `Product`.`specification`, `Product`.`details_en`, `Product`.`details_bn`, `Product`.`category_id`, `Product`.`details`, `Product`.`offer_type`, `Product`.`model`, `Product`.`meta_key`, `Product`.`meta_description` FROM `kilage_uat`.`products` AS `Product` WHERE `slug` = 'captain-instant-oatmeal-1-kg' LIMIT 1 | 1 | 1 | 2 | |
| 43 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE id IN(0,4,15,24,66,23,30,60,0) | 7 | 7 | 0 | |
| 44 | BEGIN | 0 | 0 | 0 | |
| 45 | SELECT COUNT(*) AS `count` FROM `kilage_uat`.`products` AS `Product` WHERE `Product`.`id` = 2457 | 1 | 1 | 0 | |
| 46 | SELECT COUNT(*) AS `count` FROM `kilage_uat`.`products` AS `Product` WHERE `Product`.`id` = 2457 | 1 | 1 | 0 | |
| 47 | SELECT COUNT(*) AS `count` FROM `kilage_uat`.`products` AS `Product` WHERE `Product`.`id` = 2457 | 1 | 1 | 0 | |
| 48 | UPDATE `kilage_uat`.`products` SET `totalview` = 660, `id` = 2457, `name` = 'Captain Instant Oatmeal', `slug` = 'captain-instant-oatmeal-1-kg', `price` = 1150, `categories` = ',4,15,24,66,23,30,60,', `brand_id` = 107, `special_price` = 0, `unit_name` = '1 Kg', `meta_title` = NULL, `specification` = '', `details_en` = 'Quick & Easy Preparation – Ready in minutes by adding hot water or milk.\r\n\r\nRich in Dietary Fiber – Supports healthy digestion and bowel regularity.\r\n\r\nHeart Healthy – Contains beta-glucan which helps lower cholesterol.\r\n\r\nNutrient Dense – Packed with essential vitamins and minerals for daily energy.\r\n\r\nSustained Energy Release – Keeps you full and energized longer.\r\n\r\nDelicious Taste – Mild and pleasant flavor enjoyed by all ages.\r\n\r\nConvenient Packaging – Portable sachets perfect for on-the-go meals.\r\n\r\nNo Artificial Additives – Free from preservatives and artificial flavors.\r\n\r\n', `details_bn` = '১. দ্রুত ও সহজ প্রস্তুতি – গরম পানি বা দুধ মেশালে কয়েক মিনিটে তৈরি।\r\n২. অন্তর্ভুক্ত ফাইবার সমৃদ্ধ – হজম সুগম করতে ও নিয়মিত পেটের কার্যক্রম বজায় রাখতে সহায়ক।\r\n৩. হৃদয়ের জন্য ভালো – বেটা-গ্লুকান থাকে যা কোলেস্টেরল কমাতে সাহায্য করে।\r\n৪. পুষ্টি সমৃদ্ধ – দৈনন্দিন শক্তির জন্য প্রয়োজনীয় ভিটামিন ও খনিজ উপাদানসমূহ রয়েছে।\r\n৫. দীর্ঘস্থায়ী শক্তি সরবরাহ – দীর্ঘ সময় পেট ভরে রাখে ও শক্তি দেয়।\r\n৬. সুস্বাদু – সবার জন্য সহজপাচ্য ও স্বাদে মিষ্টি।\r\n৭. সুবিধাজনক প্যাকেজিং – বহনযোগ্য স্যাচেট, যেকোনো সময় খাওয়ার জন্য উপযুক্ত।\r\n৮. কোনো কৃত্রিম সংযোজক নেই – সংরক্ষণকারী বা কৃত্রিম স্বাদ নেই।\r\n\r\n', `category_id` = 0, `details` = '', `offer_type` = '', `model` = '', `meta_key` = 'Captain Instant Oatmeal, instant oatmeal, quick breakfast oats, healthy oatmeal, fiber-rich cereal, nutritious breakfast, Captain oats Bangladesh, heart-healthy oats, easy oatmeal, breakfast cereal', `meta_description` = 'Captain Instant Oatmeal is a convenient and healthy breakfast option made from premium oats. Ready to prepare in minutes, it provides essential fiber, vitamins, and minerals to fuel your day. Ideal for busy mornings, it supports digestion, heart health, and sustained energy release with a delicious taste.', `modified` = '2026-07-30 06:02:22' WHERE `kilage_uat`.`products`.`id` = 2457 | 1 | 1 | 0 | |
| 49 | COMMIT | 0 | 0 | 0 | |
| 50 | SELECT `ProductImg`.`id` FROM `kilage_uat`.`product_imgs` AS `ProductImg` WHERE `ProductImg`.`product_id` = 2457 | 1 | 1 | 1 | |
| 51 | 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`.`category_id` = 0 AND (`Product`.`is_corporate_porduct` LIKE '%3%' OR `Product`.`is_corporate_porduct` LIKE '%4%') ORDER BY `Product`.`id` DESC LIMIT 10 | 10 | 10 | 0 | |
| 52 | SELECT `Review`.* FROM `kilage_uat`.`reviews` AS `Review` WHERE `Review`.`status` = '1' AND `Review`.`product_id` = 2457 ORDER BY `Review`.`id` DESC LIMIT 10 | 0 | 0 | 0 | |
| 53 | SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug` FROM `kilage_uat`.`brands` AS `Brand` WHERE `status` = '1' | 149 | 149 | 0 | |
| 54 | SELECT `Product`.`slug`, `Tag`.`title` FROM `kilage_uat`.`tags` AS `Tag` LEFT JOIN `kilage_uat`.`products` AS `Product` ON (`Tag`.`product_id` = `Product`.`id`) WHERE `Tag`.`status` = '1' | 12 | 12 | 0 |
Reviews
There are no reviews yet.