FREE delivery & 40% Discount for next 3 orders! Place your 1st order in kilage.com.

Hotline Number

01309466377

Search

(default) 43 queries took 6 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `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` ASC34340
2SELECT `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` ASC000
3SELECT `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` ASC10100
4SELECT `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` ASC000
5SELECT `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` ASC770
6SELECT `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` ASC550
7SELECT `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` ASC19190
8SELECT `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` ASC14140
9SELECT `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` ASC12120
10SELECT `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` ASC990
11SELECT `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` ASC10100
12SELECT `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` ASC10100
13SELECT `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` ASC10100
14SELECT `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` ASC10100
15SELECT `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` ASC990
16SELECT `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` ASC10100
17SELECT `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` ASC10100
18SELECT `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` ASC990
19SELECT `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` ASC18180
20SELECT `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` ASC440
21SELECT `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` ASC440
22SELECT `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` ASC440
23SELECT `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` ASC660
24SELECT `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` ASC440
25SELECT `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` ASC660
26SELECT `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` ASC220
27SELECT `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` ASC440
28SELECT `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` ASC440
29SELECT `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` ASC880
30SELECT `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` ASC550
31SELECT `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` ASC220
32SELECT `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` ASC000
33SELECT `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` ASC000
34SELECT `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` ASC000
35SELECT `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` ASC000
36SELECT `Config`.`key`, `Config`.`value` FROM `kilage_uat`.`configs` AS `Config` WHERE 1 = 151510
37BEGIN000
38ROLLBACK000
39SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `kilage_uat`.`categories` AS `Category` WHERE `status` = '1' AND `parent_id` = 0 ORDER BY `Category`.`sequence` ASC34340
40SELECT `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` ASC2272270
41SELECT `News`.`id`, `News`.`title`, `News`.`color_code` FROM `kilage_uat`.`news` AS `News` WHERE `type` = '1' AND `status` = '1' ORDER BY `sequence` ASC000
42SELECT `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 1 = 1 ORDER BY `Blog`.`created` DESC30302
43SELECT `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`.`brand_id` IN (31, 30, 28, 27, 26, 25, 24, 23, 22, 21, 20, 19, 18, 17, 16, 15, 14, 13, 12, 11, 10, 9, 8, 7, 6, 5, 4, 3, 2, 1)004