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) 43 queries took 3 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 `District`.`id`, `District`.`name`, `District`.`bn`, `District`.`status`, `District`.`created`, `District`.`modified` FROM `kilage_uat`.`districts` AS `District` WHERE `District`.`status` = '1' ORDER BY `District`.`name` ASC	65	65	1
43	SELECT `Upazila`.`id`, `Upazila`.`district_id`, `Upazila`.`name`, `Upazila`.`shipping_cost`, `Upazila`.`status`, `Upazila`.`created`, `Upazila`.`modified` FROM `kilage_uat`.`upazilas` AS `Upazila` WHERE `Upazila`.`district_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 12, 11, 65, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64)	602	602	2

(default) 43 queries took 3 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 `District`.`id`, `District`.`name`, `District`.`bn`, `District`.`status`, `District`.`created`, `District`.`modified` FROM `kilage_uat`.`districts` AS `District` WHERE `District`.`status` = '1' ORDER BY `District`.`name` ASC

SELECT `Upazila`.`id`, `Upazila`.`district_id`, `Upazila`.`name`, `Upazila`.`shipping_cost`, `Upazila`.`status`, `Upazila`.`created`, `Upazila`.`modified` FROM `kilage_uat`.`upazilas` AS `Upazila` WHERE `Upazila`.`district_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 12, 11, 65, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64)

602

Become a Seller

Upload Documents

Bagerhat

Bandarban

Barguna

Barishal

Bhola

Bogura

Brahmanbaria

Chandpur

Chattogram

Chuadanga

CoxsBazar

Cumilla

Dhaka City

Dhaka District

Dinajpur

Faridpur

Feni

Gaibandha

Gazipur

Gopalganj

Habiganj

Jaipurhat

Jamalpur

Jashore

Jhalokati

Jhenaidah

Khagrachari

Khulna

Kishoreganj

Kurigram

Kushtia

Lakshmipur

Lalmonirhat

Madaripur

Magura

Manikganj

Maulvibazar

Meherpur

Munshiganj

Mymensingh

Naogoan

Narail

Narayanganj

Narsingdi

Natore

Nawabganj

Netrokona

Nilphamari

Noakhali

Pabna

Panchagarh

Patuakhali

Pirojpur

Rajbari

Rajshahi

Rangamati

Rangpur

Satkhira

Shariatpur

Sherpur

Sirajganj

Sunamganj

Sylhet

Tangail

Thakurgaon

Our Stores

Information

Need Help? / Contact Us