Category Wise Product List

Computerized 4 Thread Overlock Machine

Brand: SHUNFA

Model: F7-4D/EP/BK/B

Brief:
As a new generation of intelligent four-thread backstitching machine, it is specially designed fo...

High Speed Direct Drive 4 Thread Overlock Machine

Brand: SHUNFA

Model: F6-4D

Brief: Suitable for knitting sewing processes. This all-in-one machine redefines the combination of efficie...

Super High Speed Direct Drive Overlock Sewing Machine

Brand: SHUNFA

Model: SF 798EXT-4D

Brief:
 Shunfa brand  SF 798EXT-4D model is a super-high-speed,2 needles 4-thread direct drive...

Computerized Cylinder Bed Overlock Sewing Machine

Brand: SHUNFA

Model: SF 799EXT-4D/EP

Brief:
JAPAN TYPE HEAD specialized 2 needle 4-thread, small cylinder-bed computerized overlock sewing ma...

Super High Speed Overlock Sewing Machine With Auto Trimmer

Brand: SHUNFA

Model: SF 798EXT-4D/EP

Brief:
 Shunfa brand SF 798EXT-4D/EP model is a heavy-duty,2 needle  4-thread industrial overl...

Direct Drive High Speed Overlock Sewing Machine

Brand: SHUNFA

Model: F3-4D

Brief:
Shunfa brand  F3-4D brand  is a high-speed, 2-needle, 4-thread industrial overlock sewi...

Intelligent Overlock Sewing Machine

Brand: SHUNFA

Model: F6-4D/EP

Brief:
Shunfa brand  F6-4D/EP model is a high-speed, computerized industrial 2 needle  4-threa...

Intelligent Overlock Sewing Machine

Brand: SHUNFA

Model: F6-4D/EP/BK

Brief:
Shunfa brand,  F6-4D/EP/BK model is a high-speed, intelligent 2 needle 4-thread overlock sew...

Intelligent Overlock Sewing Machine

Brand: SHUNFA

Model: F6-4D/EP/B

Brief:
 Shunfa brand  F6-4D/EP/B model is a high-speed, intelligent 2 needle 4-thread industri...

Intelligent Overlock Sewing Machine

Brand: SHUNFA

Model: F7-4D/EP/B/Q

Brief:
JAPAN TYPE HEAD, SUPER HIGH SPEED, DIRECT DRIVE PEGASUS EX TYPE, 2 NEEDLE 5 THREAD OVERLOCK MACHI...

Direct drive super high speed cylinder bed overlock machine

Brand: SHUNFA

Model: SF 799EX-4D

Brief:
JAPAN TYPE HEAD specialized 2 needle 4-thread, small cylinder-bed computerized overlock sewing ma...

Intelligent Overlock seing machine

Brand: SHUNFA

Model: F5-4D/EP

Brief:
aShunfa brand F5-4D/EP model high-speed, 2 needle 4-thread industrial overlock sewing machine fea...

Intelligent Overlock sewing machine

Brand: SHUNFA

Model: F5

Brief: a

Computerized 4 Thread Overlock Machine

Brand: SHUNFA

Model: F7-4D/EP/BK/B

Brief:
As a new generation of intelligent four-thread backstitching machine, it is specially designed fo...

Stock Building, 125 Main Street
1st Lane, San Francisco, USA

(default) 14 queries took 2 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Config`.`key`, `Config`.`value` FROM `shunfabd_main`.`configs` AS `Config` WHERE 1 = 135350
2BEGIN000
3ROLLBACK000
4SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, COUNT(`Product`.`id`) AS total_products FROM `shunfabd_main`.`categories` AS `Category` LEFT JOIN `shunfabd_main`.`products` AS `Product` ON (`Category`.`id` = `Product`.`category_id`) WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 0 GROUP BY `Category`.`id`, `Category`.`name`, `Category`.`slug` ORDER BY `Category`.`sequence` ASC661
5SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `shunfabd_main`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 1 ORDER BY `Category`.`sequence` ASC000
6SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `shunfabd_main`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 2 ORDER BY `Category`.`sequence` ASC000
7SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `shunfabd_main`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 3 ORDER BY `Category`.`sequence` ASC000
8SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `shunfabd_main`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 4 ORDER BY `Category`.`sequence` ASC000
9SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `shunfabd_main`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 5 ORDER BY `Category`.`sequence` ASC000
10SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `shunfabd_main`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 6 ORDER BY `Category`.`sequence` ASC000
11SELECT `News`.`id`, `News`.`title`, `News`.`color_code` FROM `shunfabd_main`.`news` AS `News` WHERE `type` = '1' AND `status` = '1' ORDER BY `sequence` ASC000
12SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`spec`, `Category`.`meta_key`, `Category`.`meta_description` FROM `shunfabd_main`.`categories` AS `Category` WHERE `slug` = 'overlock-machine' LIMIT 1110
13SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`price`, `Product`.`brand_id`, `Product`.`p_price`, `Product`.`model`, `Product`.`details` FROM `shunfabd_main`.`products` AS `Product` WHERE `status` = '1' AND `category_id` = 214141
14SELECT `Brand`.`id`, `Brand`.`name` FROM `shunfabd_main`.`brands` AS `Brand` WHERE 1 = 1990