SELECT 
  cscart_categories.category_id, 
  cscart_categories.parent_id, 
  cscart_categories.id_path, 
  cscart_category_descriptions.category, 
  cscart_categories.position, 
  cscart_categories.status, 
  cscart_categories.company_id, 
  cscart_categories.storefront_id, 
  cscart_seo_names.name as seo_name, 
  cscart_seo_names.path as seo_path, 
  cscart_categories.ab__lc_catalog_image_control 
FROM 
  cscart_categories 
  LEFT JOIN cscart_category_descriptions ON cscart_categories.category_id = cscart_category_descriptions.category_id 
  AND cscart_category_descriptions.lang_code = 'en' 
  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_categories.category_id 
  AND cscart_seo_names.type = 'c' 
  AND cscart_seo_names.dispatch = '' 
  AND cscart_seo_names.lang_code = 'en' 
WHERE 
  1 = 1 
  AND (
    cscart_categories.usergroup_ids = '' 
    OR FIND_IN_SET(
      0, cscart_categories.usergroup_ids
    ) 
    OR FIND_IN_SET(
      1, cscart_categories.usergroup_ids
    )
  ) 
  AND cscart_categories.status IN ('A') 
  AND cscart_categories.category_id != 264 
  AND cscart_categories.parent_id != 264 
  AND cscart_categories.storefront_id IN (0, 1) 
  AND cscart_categories.category_id IN(
    166, 
    167, 
    170, 
    174, 
    190, 
    203, 
    204, 
    208, 
    219, 
    228, 
    229, 
    230, 
    231, 
    234, 
    235, 
    236, 
    245, 
    250, 
    458, 
    251, 
    305, 
    308, 
    320, 
    321, 
    322, 
    323, 
    324, 
    325, 
    326, 
    328, 
    329, 
    330, 
    331, 
    332, 
    333, 
    334, 
    336, 
    337, 
    339, 
    340, 
    341, 
    342, 
    543, 
    343, 
    344, 
    346, 
    347, 
    350, 
    351, 
    352, 
    353, 
    354, 
    355, 
    356, 
    357, 
    358, 
    359, 
    360, 
    361, 
    362, 
    363, 
    364, 
    366, 
    369, 
    371, 
    372, 
    378, 
    379, 
    380, 
    381, 
    382, 
    383, 
    384, 
    385, 
    386, 
    387, 
    393, 
    394, 
    395, 
    397, 
    398, 
    399, 
    400, 
    401, 
    402, 
    404, 
    405, 
    406, 
    407, 
    408, 
    409, 
    410, 
    411, 
    412, 
    413, 
    414, 
    415, 
    416, 
    417, 
    418, 
    419, 
    420, 
    421, 
    422, 
    423, 
    424, 
    425, 
    426, 
    428, 
    429, 
    430, 
    432, 
    434, 
    435, 
    436, 
    438, 
    439, 
    440, 
    441, 
    443, 
    444, 
    446, 
    448, 
    449, 
    450, 
    451, 
    452, 
    453, 
    454, 
    455, 
    457, 
    459, 
    460, 
    461, 
    462, 
    463, 
    464, 
    566, 
    465, 
    466, 
    467, 
    468, 
    469, 
    470, 
    471, 
    577, 
    473, 
    474, 
    475, 
    476, 
    477, 
    480, 
    481, 
    482, 
    483, 
    485, 
    486, 
    487, 
    488, 
    489, 
    490, 
    491, 
    492, 
    493, 
    494, 
    496, 
    497, 
    498, 
    499, 
    500, 
    502, 
    503, 
    504, 
    505, 
    506, 
    507, 
    513, 
    514, 
    515, 
    516, 
    517, 
    518, 
    519, 
    520, 
    521, 
    522, 
    523, 
    524, 
    525, 
    526, 
    527, 
    528, 
    530, 
    531, 
    532, 
    535, 
    536, 
    537, 
    538, 
    539, 
    540, 
    472, 
    542, 
    544, 
    545, 
    546, 
    547, 
    548, 
    552, 
    549, 
    550, 
    551, 
    553, 
    554, 
    555, 
    556, 
    557, 
    559, 
    560, 
    561, 
    562, 
    563, 
    564, 
    565, 
    567, 
    568, 
    569, 
    570, 
    571, 
    572, 
    573, 
    574, 
    575, 
    576, 
    578, 
    579, 
    580, 
    581, 
    582, 
    583, 
    584, 
    585, 
    586, 
    587, 
    534, 
    588, 
    590, 
    591, 
    592, 
    593, 
    594, 
    595, 
    596, 
    597, 
    598, 
    599, 
    600, 
    601, 
    602, 
    603, 
    612, 
    613, 
    614, 
    615, 
    616, 
    617, 
    618, 
    619, 
    620, 
    621, 
    622, 
    623, 
    624, 
    625, 
    626, 
    627, 
    558, 
    628, 
    629, 
    630, 
    631, 
    632, 
    633, 
    634, 
    635, 
    636, 
    637, 
    638, 
    639, 
    640, 
    641, 
    642, 
    643, 
    644, 
    645, 
    646, 
    647, 
    648, 
    649, 
    650, 
    651, 
    652, 
    653, 
    654, 
    655, 
    656, 
    657, 
    658, 
    659, 
    660, 
    661, 
    662, 
    663, 
    664, 
    666, 
    667, 
    668, 
    669
  ) 
ORDER BY 
  cscart_categories.is_trash asc, 
  cscart_categories.position asc, 
  cscart_category_descriptions.category asc

Query time 0.00737

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "186.68"
    },
    "ordering_operation": {
      "using_temporary_table": true,
      "using_filesort": true,
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_categories",
            "access_type": "ALL",
            "possible_keys": [
              "PRIMARY",
              "c_status",
              "parent",
              "p_category_id"
            ],
            "rows_examined_per_scan": 347,
            "rows_produced_per_join": 6,
            "filtered": "1.83",
            "cost_info": {
              "read_cost": "36.91",
              "eval_cost": "0.64",
              "prefix_cost": "37.54",
              "data_read_per_join": "19K"
            },
            "used_columns": [
              "category_id",
              "parent_id",
              "id_path",
              "company_id",
              "storefront_id",
              "usergroup_ids",
              "status",
              "position",
              "is_trash",
              "ab__lc_catalog_image_control"
            ],
            "attached_condition": "(((`softwarepirmam_hewadelivard_cscart_4`.`cscart_categories`.`usergroup_ids` = '') or (0 <> find_in_set(0,`softwarepirmam_hewadelivard_cscart_4`.`cscart_categories`.`usergroup_ids`)) or (0 <> find_in_set(1,`softwarepirmam_hewadelivard_cscart_4`.`cscart_categories`.`usergroup_ids`))) and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_categories`.`status` = 'A') and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_categories`.`category_id` <> 264) and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_categories`.`parent_id` <> 264) and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_categories`.`storefront_id` in (0,1)) and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_categories`.`category_id` in (166,167,170,174,190,203,204,208,219,228,229,230,231,234,235,236,245,250,458,251,305,308,320,321,322,323,324,325,326,328,329,330,331,332,333,334,336,337,339,340,341,342,543,343,344,346,347,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,366,369,371,372,378,379,380,381,382,383,384,385,386,387,393,394,395,397,398,399,400,401,402,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,428,429,430,432,434,435,436,438,439,440,441,443,444,446,448,449,450,451,452,453,454,455,457,459,460,461,462,463,464,566,465,466,467,468,469,470,471,577,473,474,475,476,477,480,481,482,483,485,486,487,488,489,490,491,492,493,494,496,497,498,499,500,502,503,504,505,506,507,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,530,531,532,535,536,537,538,539,540,472,542,544,545,546,547,548,552,549,550,551,553,554,555,556,557,559,560,561,562,563,564,565,567,568,569,570,571,572,573,574,575,576,578,579,580,581,582,583,584,585,586,587,534,588,590,591,592,593,594,595,596,597,598,599,600,601,602,603,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,558,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,666,667,668,669)))"
          }
        },
        {
          "table": {
            "table_name": "cscart_category_descriptions",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "category_id",
              "lang_code"
            ],
            "key_length": "9",
            "ref": [
              "softwarepirmam_hewadelivard_cscart_4.cscart_categories.category_id",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 6,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "1.59",
              "eval_cost": "0.64",
              "prefix_cost": "39.77",
              "data_read_per_join": "21K"
            },
            "used_columns": [
              "category_id",
              "lang_code",
              "category"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_seo_names",
            "access_type": "ref",
            "possible_keys": [
              "PRIMARY",
              "dispatch"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "object_id",
              "type",
              "dispatch",
              "lang_code"
            ],
            "key_length": "206",
            "ref": [
              "softwarepirmam_hewadelivard_cscart_4.cscart_categories.category_id",
              "const",
              "const",
              "const"
            ],
            "rows_examined_per_scan": 66,
            "rows_produced_per_join": 419,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "104.94",
              "eval_cost": "41.98",
              "prefix_cost": "186.68",
              "data_read_per_join": "711K"
            },
            "used_columns": [
              "name",
              "object_id",
              "type",
              "dispatch",
              "path",
              "lang_code"
            ]
          }
        }
      ]
    }
  }
}

Result

category_id parent_id id_path category position status company_id storefront_id seo_name seo_path ab__lc_catalog_image_control
467 466 372/466/467 Air Fryers 10 A 0 0 air-fryers 372/466 none
462 461 372/461/462 Air Purifiers 10 A 0 0 air-purifiers 372/461 none
379 378 166/378/379 Anker 10 A 0 0 anker 166/378 none
323 322 166/322/323 Apple watch 10 A 0 0 apple-watch 166/322 none
344 329 166/329/344 Buds 10 A 0 0 airpod 166/329 none
535 522 521/522/535 Bullet 10 A 0 0 bullet 521/522 none
493 219 219/493 Business Books 10 A 0 0 business 219 none
450 424 166/423/424/450 Cables 10 A 0 0 cables 166/423/424 none
440 251 250/458/251/440 Casio 10 A 0 0 casio 250/458/251 none
522 521 521/522 CCTV Camera 10 A 0 0 cctv-camera 521 none
630 629 577/629/630 Cleaners 10 A 0 0 cleaners 577/629 none
554 553 250/553/554 Coffee Machine 10 A 0 0 coffee-machine 250/553 none
556 552 372/552/556 Coffee Machine 10 A 0 0 coffee-machine 372/552 none
381 350 166/350/381 Combo 10 A 0 0 combo 166/350 none
385 308 250/308/385 Combo 10 A 0 0 combo 250/308 none
167 166 166/167 Computers & Laptops 10 A 0 0 computers 166 none
416 332 245/332/416 Console & Controllers 10 A 0 0 console-and-controllers 245/332 none
421 334 245/334/421 Console & Controllers 10 A 0 0 console-and-controllers 245/334 none
441 336 250/336/441 deli 10 A 0 0 deli 250/336 none
166 0 166 Electronics 10 A 0 0 electronics none
568 406 250/402/406/568 Ethernet Cable 10 A 0 0 ethernet-cable 250/402/406 none
546 545 521/545/546 Ethernet Cables 10 A 0 0 ethernet-cables 521/545 none
617 616 577/616/617 Face 10 A 0 0 face 577/616 none
593 592 372/572/592/593 Freestanding Ranges 10 A 0 0 freestanding-ranges 372/572/592 none
560 557 372/552/557/560 Ground Coffee 10 A 0 0 ground-coffee 372/552/557 none
562 555 250/553/555/562 Ground Coffee 10 A 0 0 ground-coffee 250/553/555 none
474 473 577/473/474 Hair Dryer 10 A 0 0 hair-dryer 577/473 none
514 513 166/513/514 Hard Disk Drives (HDD) 10 A 0 0 hard-disk-drives-hdd 166/513 none
360 359 166/328/359/360 Indoor Access Point 10 A 0 0 indoor-access-point 166/328/359 none
412 407 250/402/407/412 Indoor Access Point 10 A 0 0 indoor-access-point 250/402/407 none
393 371 250/371/393 Inkjet Printer 10 A 0 0 inkjet-printer 250/371 none
321 320 166/320/321 iPad 10 A 0 0 ipad 166/320 none
235 234 166/234/235 iPhone 10 A 0 0 iphone 166/234 none
659 658 658/659 Laptop Bags 10 A 0 0 laptop-bags 658 none
628 558 558/628 LEGO 10 A 0 0 lego 558 none
356 167 166/167/356 Mac 10 A 0 0 mac 166/167 none
362 342 166/328/342/362 Managed Switch 10 A 0 0 managed-switch 166/328/342 none
410 405 250/402/405/410 Managed Switch 10 A 0 0 managed-switch 250/402/405 none
651 650 577/650/651 Nail Polish 10 A 0 0 nail-polish 577/650 none
542 472 472/542 Network Cables 10 A 0 0 network-cables 472 none
539 538 521/538/539 NVR 10 A 0 0 nvr 521/538 none
415 414 166/351/414/415 On-Line UPS 10 A 0 0 online-and-smart-ups 166/351/414 none
305 458 250/458/305 Paper 10 A 0 0 paper 250/458 none
330 228 228/330 Piano 10 A 0 0 piano 228 none
332 245 245/332 PlayStation 10 A 0 0 playstation 245 none
371 250 250/371 Printer 10 A 0 0 printer 250 none
601 600 166/600/601 Processors (CPU) 10 A 0 0 cpu 166/600 none
582 572 372/572/582 Refrigerator 10 A 0 0 refrigerator 372/572 none
341 328 166/328/341 Router 10 A 0 0 router 166/328 none
404 402 250/402/404 Router 10 A 0 0 router 250/402 none
588 534 521/534/588 Smart Door Handle 10 A 0 0 smart-door-handle 521/534 none
459 384 372/384/459 Smart Robot Vacuums 10 A 0 0 smart-robot-vacuums 372/384 none
549 552 372/552/549 Soda Machine 10 A 0 0 soda-machine 372/552 none
527 329 166/329/527 Sound Bars 10 A 0 0 sound-bars 166/329 none
453 372 372/453 TV & Theatre 10 A 0 0 tv-and-theatre 372 none
190 174 166/174/190 TVs 10 A 0 0 led-tvs 166/174 none
454 453 372/453/454 TVs 10 A 0 0 tvs 372/453 none
414 351 166/351/414 UPS 10 A 0 0 maxma 166/351 none
623 621 577/621/623 Women 10 A 0 0 women 577/621 none
419 333 245/333/419 XBOX Console & Controllers 10 A 0 0 console-and-controllers 245/333 none
357 170 166/170/357 Xiaomi 10 A 0 0 xiaomi 166/170 none
435 434 372/434/435 Xiaomi 10 A 0 0 xiaomi 372/434 none
436 369 203/369/436 Xiaomi 10 A 0 0 xiaomi 203/369 none
534 521 521/534 Access Control 20 A 0 0 access-control 521 none
590 534 521/534/590 Access Devices 20 A 0 0 access-devices 521/534 none
461 372 372/461 Air Care 20 A 0 0 air-care 372 none
463 461 372/461/463 Air Humidifiers 20 A 0 0 air-humidifiers 372/461 none
555 553 250/553/555 Beans & Capsules 20 A 0 0 beans-and-capsules 250/553 none
561 557 372/552/557/561 Capsules 20 A 0 0 capsules 372/552/557 none
563 555 250/553/555/563 Capsules 20 A 0 0 capsules 250/553/555 none
424 423 166/423/424 Chargers & Cables 20 A 0 0 chargers 166/423 none
494 219 219/494 Children & YA Books 20 A 0 0 children-books 219 none
569 406 250/402/406/569 Coaxial Cable 20 A 0 0 coaxial-cable 250/402/406 none
547 545 521/545/547 Coaxial Cables 20 A 0 0 coaxial-cables 521/545 none
557 552 372/552/557 Coffee Beans & Capsules 20 A 0 0 beans-and-capsules 372/552 none
594 592 372/572/592/594 Cooktops 20 A 0 0 cooktops 372/572/592 none
460 384 372/384/460 Cordless Vacuums 20 A 0 0 cordless-vacuums 372/384 none
352 167 166/167/352 Dell 20 A 0 0 dell 166/167 none
536 522 521/522/536 Dome 20 A 0 0 dome 521/522 none
540 538 521/538/540 DVR 20 A 0 0 dvr 521/538 none
618 616 577/616/618 Eyes 20 A 0 0 eyes 577/616 none
326 234 166/234/326 Galaxy 20 A 0 0 samsung 166/234 none
325 320 166/320/325 Galaxy Tab 20 A 0 0 galaxy-tab 166/320 none
324 322 166/322/324 Galaxy Watch 20 A 0 0 galaxy-watch 166/322 none
245 0 245 Gaming 20 A 0 0 video-games none
602 600 166/600/602 Graphics Cards (GPU) 20 A 0 0 graphics-cards-gpu 166/600 none
573 466 372/466/573 Grillers & Toasters 20 A 0 0 grillers-and-toasters 372/466 none
331 228 228/331 Guitar 20 A 0 0 guitar 228 none
475 473 577/473/475 Hair Straightener 20 A 0 0 hair-straightener 577/473 none
432 378 166/378/432 Hama 20 A 0 0 hama 166/378 none
394 371 250/371/394 Laser Printer 20 A 0 0 laser-printer 250/371 none
358 170 166/170/358 LG 20 A 0 0 lg 166/170 none
613 414 166/351/414/613 Line-Interactive UPS (Offline) 20 A 0 0 offline-ups 166/351/414 none
622 621 577/621/622 Men 20 A 0 0 men 577/621 none
631 629 577/629/631 Moisturizers 20 A 0 0 moisturizers 577/629 none
386 308 250/308/386 Mouse 20 A 0 0 mouse 250/308 none
382 350 166/350/382 Mouse 20 A 0 0 mouse 166/350 none
652 650 577/650/652 Nail Treatment 20 A 0 0 nail-treatment 577/650 none
422 334 245/334/422 Nintendo Games 20 A 0 0 nintendo-games 245/334 none
361 359 166/328/359/361 Outdoor Access Point 20 A 0 0 outdoor-access-point 166/328/359 none
413 407 250/402/407/413 Outdoor Access Point 20 A 0 0 outdoor-access-point 250/402/407 none
429 351 166/351/429 PDU 20 A 0 0 pdu 166/351 none
485 458 250/458/485 Pen 20 A 0 0 pen 250/458 none
418 332 245/332/418 PlayStation Games 20 A 0 0 ps-games 245/332 none
451 424 166/423/424/451 Power Adapter 20 A 0 0 power-adapter 166/423/424 none
336 250 250/336 Shredder 20 A 0 0 shredder 250 none
515 513 166/513/515 Solid State Drives (SSD) 20 A 0 0 solid-state-drives-ssd 166/513 none
337 174 166/174/337 Sound Bars 20 A 0 0 sound-bar 166/174 none
455 453 372/453/455 Sound Bars 20 A 0 0 sound-bar 372/453 none
342 328 166/328/342 Switch 20 A 0 0 switch 166/328 none
405 402 250/402/405 Switch 20 A 0 0 switch 250/402 none
550 552 372/552/550 Syrup & Flavours 20 A 0 0 syrup 372/552 none
660 658 658/660 Travel Bags 20 A 0 0 travel-bags 658 none
363 342 166/328/342/363 Unmanaged Switch 20 A 0 0 unmanaged-switch 166/328/342 none
411 405 250/402/405/411 Unmanaged Switch 20 A 0 0 unmanaged-switch 250/402/405 none
333 245 245/333 XBOX 20 A 0 0 xbox 245 none
420 333 245/333/420 XBOX Games 20 A 0 0 xbox-games 245/333 none
516 513 166/513/516 USB Flash Drives 30 A 0 0 usb-flash-drives 166/513 none
653 650 577/650/653 Accessories & Fake Nails 30 A 0 0 accessories-and-fake-nails 577/650 none
430 351 166/351/430 Batteries 30 A 0 0 batteries 166/351 none
251 458 250/458/251 calculators 30 A 0 0 calculators 250/458 none
538 521 521/538 CCTV Recorders 30 A 0 0 cctv-recorders 521 none
452 424 166/423/424/452 Charger Combo 30 A 0 0 combo 166/423/424 none
619 616 577/616/619 Cheeks 30 A 0 0 cheeks 577/616 none
551 552 372/552/551 CO2 & Accessories 30 A 0 0 co2-and-accessories 372/552 none
465 566 372/566/465 Cooling Fans 30 A 0 0 cooling-fans 372/566 none
584 572 372/572/584 Dish Washers 30 A 0 0 dish-washers 372/572 none
425 423 166/423/425 Docking Stations 30 A 0 0 docking-station 166/423 none
489 371 250/371/489 Dot Matrix Printers 30 A 0 0 dot-matrix-printers 250/371 none
343 543 166/328/543/343 Ethernet Cable 30 A 0 0 ethernet-cable 166/328/543 none
476 473 577/473/476 Hair Stylers 30 A 0 0 hair-stylers 577/473 none
598 384 372/384/598 Handheld Vacuums 30 A 0 0 handheld-vacuums 372/384 none
372 0 372 Home Appliance 30 A 0 0 home-appliance none
353 167 166/167/353 HP 30 A 0 0 hp 166/167 none
387 308 250/308/387 Keyboard 30 A 0 0 keyboard 250/308 none
383 350 166/350/383 Keyboard 30 A 0 0 keyboard 166/350 none
574 466 372/466/574 Mixers 30 A 0 0 mixers 372/466 none
234 166 166/234 Mobiles 30 A 0 0 cellphone 166 none
603 600 166/600/603 Motherboards 30 A 0 0 motherboards 166/600 none
208 204 203/204/208 Mountain Bikes 30 A 0 0 mountain-bikes 203/204 none
406 402 250/402/406 Network Cables & POE Adapters 30 A 0 0 ethernet-cable 250/402 none
334 245 245/334 Nintendo 30 A 0 0 nintendo 245 none
417 332 245/332/417 PlayStation Accessories 30 A 0 0 accessories 245/332 none
570 406 250/402/406/570 POE Adapters 30 A 0 0 poe-adapters 250/402/406 none
571 545 521/545/571 POE Adapters 30 A 0 0 poe-adapters 521/545 none
625 621 577/621/625 Unisex 30 A 0 0 unisex 577/621 none
384 372 372/384 Vacuums 30 A 0 0 vacuums 372 none
591 534 521/534/591 Video Intercom 30 A 0 0 video-intercom 521/534 none
583 372 372/583 Washing Machine and Dryers 30 A 0 0 washing-machin-and-dryers 372 none
480 333 245/333/480 XBOX Accessories 30 A 0 0 accessories 245/333 none
236 234 166/234/236 Xiaomi 30 A 0 0 xiaomi 166/234 none
443 378 166/378/443 Xiaomi 30 A 0 0 xiaomi 166/378 none
339 320 166/320/339 Xiaomi Pad 30 A 0 0 xiaomi-tablet 166/320 none
340 322 166/322/340 Xiaomi Smart Watches 30 A 0 0 xiaomi-smart-watches 166/322 none
359 328 166/328/359 Access Point 40 A 0 0 access-point 166/328 none
407 402 250/402/407 Access Point 40 A 0 0 access-point 250/402 none
595 566 372/566/595 Air Conditioners (AC) 40 A 0 0 air-conditioners-ac 372/566 none
397 371 250/371/397 Barcode Printers 40 A 0 0 barcode-printer 250/371 none
426 424 166/423/424/426 Cable Adapters 40 A 0 0 adapters 166/423/424 none
544 543 166/328/543/544 Coaxial Cable 40 A 0 0 coaxial-cable 166/328/543 none
592 572 372/572/592 Cooking Ranges 40 A 0 0 cooking-ranges 372/572 none
428 458 250/458/428 Desk & WorkSpace Organizer 40 A 0 0 desk-organizer 250/458 none
483 378 166/378/483 Dviced 40 A 0 0 dviced 166/378 none
633 629 577/629/633 Face Masks 40 A 0 0 face-masks 577/629 none
496 219 219/496 Fiction Books 40 A 0 0 fiction-books 219 none
469 320 166/320/469 Huawei Pads 40 A 0 0 huawei-pads 166/320 none
471 322 166/322/471 Huawei Watches 40 A 0 0 huawei-watches 166/322 none
575 466 372/466/575 Kettle 40 A 0 0 kettle 372/466 none
505 170 166/170/505 Lenovo 40 A 0 0 lenovo 166/170 none
354 167 166/167/354 Lenovo 40 A 0 0 lenovo 166/167 none
620 616 577/616/620 Lips 40 A 0 0 lips 577/616 none
517 513 166/513/517 Memory Cards 40 A 0 0 memory-cards 166/513 none
170 166 166/170 Monitors 40 A 0 0 monitors 166 none
559 234 166/234/559 Motorola 40 A 0 0 motorola-en 166/234 none
545 521 521/545 Network Cables & POE Adapters 40 A 0 0 network-cables 521 none
627 621 577/621/627 Niche Fragrances 40 A 0 0 niche-fragrances 577/621 none
250 0 250 Office Supplies 40 A 0 0 office-supplies none
487 453 372/453/487 Projectors 40 A 0 0 projectors 372/453 none
486 174 166/174/486 Projectors 40 A 0 0 projectors 166/174 none
526 170 166/170/526 Samsung 40 A 0 0 samsung 166/170 none
369 203 203/369 Scooter 40 A 0 0 scooter 203 none
320 166 166/320 Tablets 40 A 0 0 tablets 166 none
596 566 372/566/596 Air Coolers 50 A 0 0 air-coolers 372/566 none
355 167 166/167/355 Asus 50 A 0 0 asus 166/167 none
490 378 166/378/490 Belkin 50 A 0 0 belkin 166/378 none
219 0 219 Books 50 A 0 0 books none
626 621 577/621/626 Candles 50 A 0 0 candles 577/621 none
518 513 166/513/518 Card Readers 50 A 0 0 card-readers 166/513 none
576 466 372/466/576 Deep Fryers 50 A 0 0 deep-fryers 372/466 none
528 170 166/170/528 Dell 50 A 0 0 dell 166/170 none
364 328 166/328/364 Firewall 50 A 0 0 firewall 166/328 none
408 402 250/402/408 Firewall 50 A 0 0 firewall 250/402 none
399 329 166/329/399 Headsets 50 A 0 0 headsets 166/329 none
614 320 166/320/614 Honor Pad 50 A 0 0 honor-pad 166/320 none
470 234 166/234/470 Huawei 50 A 0 0 huawei 166/234 none
624 621 577/621/624 Kids 50 A 0 0 kids 577/621 none
398 371 250/371/398 Label Printers 50 A 0 0 label-printers 250/371 none
572 372 372/572 Major Kitchen Appliances 50 A 0 0 major-kitchen-appliances 372 none
497 219 219/497 Non-Fiction Books 50 A 0 0 non-fiction-books 219 none
567 543 166/328/543/567 POE Adapters 50 A 0 0 poe-adapters 166/328/543 none
599 572 372/572/599 Range Hoods 50 A 0 0 range-hoods 372/572 none
322 166 166/322 Smart Watches 50 A 0 0 smart-watch 166 none
446 351 166/351/446 Sockets & Wall Plugs 50 A 0 0 sockets-and-wall-plugs 166/351 none
488 458 250/458/488 Stapler 50 A 0 0 stapler 250/458 none
634 629 577/629/634 Sunscreens 50 A 0 0 sunscreens 577/629 none
174 166 166/174 TV & Theatre 50 A 0 0 tv-and-video 166 none
506 378 166/378/506 Baykron 60 A 0 0 baykron 166/378 none
648 351 166/351/648 EV Car Chargers 60 A 0 0 ev-car-chargers 166/351 none
654 572 372/572/654 Freezers 60 A 0 0 freezers 372/572 none
473 577 577/473 Hair Care 60 A 0 0 hair-care 577 none
457 329 166/329/457 Headphone 60 A 0 0 headphone 166/329 none
597 566 372/566/597 Heaters 60 A 0 0 heaters 372/566 none
444 167 166/167/444 Microsoft Surface 60 A 0 0 microsoft 166/167 none
579 466 372/466/579 Microwave & Ovens 60 A 0 0 microwave-and-ovens 372/466 none
328 166 166/328 Network 60 A 0 0 network 166 none
498 219 219/498 Philosophy Books 60 A 0 0 philosophy-books 219 none
395 371 250/371/395 Printer Supplies 60 A 0 0 printer-supplies 250/371 none
448 423 166/423/448 Screen Protectors 60 A 0 0 screen-protectors 166/423 none
466 372 372/466 Small Kitchen Appliances 60 A 0 0 kitchen-appliances 372 none
491 458 250/458/491 Staple remover 60 A 0 0 staple-remover 250/458 none
366 328 166/328/366 Wireless Access Controller (WAC) 60 A 0 0 wac 166/328 none
409 402 250/402/409 Wireless Access Controller (WAC) 60 A 0 0 wireless-access-controller-wac 250/402 none
525 167 166/167/525 Acer 65 A 0 0 acer 166/167 none
329 166 166/329 Audio 70 A 0 0 headphone-and-speakers 166 none
449 423 166/423/449 Cases & Covers 70 A 0 0 cases-and-covers 166/423 none
580 466 372/466/580 Egg Boiler 70 A 0 0 egg-boiler 372/466 none
530 170 166/170/530 HP 70 A 0 0 hp 166/170 none
636 629 577/629/636 Lip Treatments 70 A 0 0 lip-treatments 577/629 none
532 167 166/167/532 MSI 70 A 0 0 msi-en 166/167 none
499 219 219/499 Politics & Current Affairs Books 70 A 0 0 political-books 219 none
438 328 166/328/438 Range Extender 70 A 0 0 range-extender 166/328 none
439 402 250/402/439 Range Extender 70 A 0 0 range-extender 250/402 none
347 329 166/329/347 Speakers 70 A 0 0 speakers 166/329 none
477 423 166/423/477 Stylus Pens 70 A 0 0 stylus-pens 166/423 none
615 371 250/371/615 Thermal Printer 70 A 0 0 thermal-printer 250/371 none
578 577 577/578 Trimmers 70 A 0 0 trimmers 577 none
519 167 166/167/519 All in One 80 A 0 0 all-in-one 166/167 none
552 372 372/552 Coffee & Beverages 80 A 0 0 coffee 372 none
482 402 250/402/482 Fiber Splicing Machine 80 A 0 0 fiber-splicing-machine 250/402 none
481 328 166/328/481 Fiber Splicing Machine 80 A 0 0 fiber-splicing-machine 166/328 none
616 577 577/616 Make Up 80 A 0 0 make-up 577 none
581 466 372/466/581 Mini Refrigerator 80 A 0 0 mini-refrigerator 372/466 none
308 250 250/308 Mouse & Keyboard 80 A 0 0 mouse-and-keyboard 250 none
531 170 166/170/531 MSI 80 A 0 0 msi 166/170 none
500 219 219/500 Thriller Books 80 A 0 0 thriller-books 219 none
637 629 577/629/637 Treatments 80 A 0 0 treatments 577/629 none
566 372 372/566 Coolers & Heaters 90 A 0 0 coolers-and-heaters 372 none
655 466 372/466/655 Ice Maker 90 A 0 0 ice-maker 372/466 none
638 629 577/629/638 Men's Skincare 90 A 0 0 mens-skincare 577/629 none
621 577 577/621 Perfumes 90 A 0 0 perfume 577 none
565 402 250/402/565 Point to Point 90 A 0 0 point-to-point 250/402 none
492 424 166/423/424/492 Wireless Charging & Stands 90 A 0 0 wireless-charging-and-stands 166/423/424 none
464 461 372/461/464 Accessories & Filters 100 A 0 0 accessories-and-filters 372/461 none
521 0 521 CCTV & Access Control 100 A 0 0 cctv-and-access-control none
587 372 372/587 Ironing 100 A 0 0 ironing 372 none
502 219 219/502 Romance Books 100 A 0 0 romance-books 219 none
629 577 577/629 Skin Care 100 A 0 0 skin-care 577 none
520 423 166/423/520 Webcam Camera 100 A 0 0 webcam-camera 166/423 none
639 577 577/639 Body Care 110 A 0 0 body-care 577 none
380 250 250/380 Meeting Room Essentials 110 A 0 0 meeting-room-essentials 250 none
350 166 166/350 Mouse & Keyboard 110 A 0 0 mouse-and-keyboard 166 none
228 0 228 Music Instruments 110 A 0 0 music-instruments none
503 219 219/503 Self-Help & Personal Development Books 110 A 0 0 self-help-books 219 none
585 423 166/423/585 Watch Bands 110 A 0 0 watch-bands 166/423 none
640 639 577/639/640 Body Mists 120 A 0 0 body-mists 577/639 none
558 0 558 Games & Toys 120 A 0 0 games-and-toys none
524 399 166/329/399/524 Gaming Headsets 120 A 0 0 gaming-headsets 166/329/399 none
650 577 577/650 Nails 120 A 0 0 nails 577 none
543 328 166/328/543 Network Cables & POE Adapters 120 A 0 0 network-cable 166/328 none
400 250 250/400 Office Headsets 120 A 0 0 headsets 250 none
523 399 166/329/399/523 Office Headsets 120 A 0 0 office-headsets 166/329/399 none
537 522 521/522/537 PTZ 120 A 0 0 ptz 521/522 none
504 219 219/504 Science Books 120 A 0 0 science-books 219 none
586 423 166/423/586 Trackers 120 A 0 0 trackers 166/423 none
351 166 166/351 UPS & Power Units 120 A 0 0 ups 166 none
577 0 577 Beauty & Self Care 130 A 0 0 beauty-and-self-care none
641 639 577/639/641 Body Washes 130 A 0 0 body-washes 577/639 none
657 423 166/423/657 Car Phone Holders 130 A 0 0 car-phone-holders 166/423 none
662 577 577/662 Dental Care 130 A 0 0 dental-care 577 none
507 219 219/507 Mangas 130 A 0 0 mangas 219 none
564 328 166/328/564 Point to Point 130 A 0 0 point-to-point 166/328 none
378 166 166/378 Power Banks 130 A 0 0 power-banks 166 none
401 250 250/401 UPS & Power Units 130 A 0 0 ups 250 none
658 0 658 Bags 140 A 0 0 bags none
642 639 577/639/642 Body Moisturizers 140 A 0 0 body-moisturizers 577/639 none
402 250 250/402 Network 140 A 0 0 network 250 none
513 166 166/513 Storage 140 A 0 0 external-storage 166 none
423 166 166/423 Accessories 150 A 0 0 accessories 166 none
643 639 577/639/643 Deodorants 150 A 0 0 deodorants 577/639 none
661 0 661 Physical Watches 150 A 0 0 physical-watches none
458 250 250/458 Stationary 150 A 0 0 stationary 250 none
553 250 250/553 Coffee 160 A 0 0 coffee 250 none
664 0 664 Glasses 160 A 0 0 glasses none
600 166 166/600 PC Compnents 160 A 0 0 pc-compnents 166 none
644 639 577/639/644 Scrubs & Exfoliants 160 A 0 0 scrubs-and-exfoliants 577/639 none
645 639 577/639/645 Sponges & Tools 170 A 0 0 sponges-and-tools 577/639 none
646 639 577/639/646 Treatments 180 A 0 0 treatments 577/639 none
647 639 577/639/647 Men's Body Care 190 A 0 0 mens-body-care 577/639 none