Category Wise Product List

Double Needle Three-Thread Trouser Loop Sewing Machine

Brand: SHUNFA

Model: SF 562-08CB/UT

Brief: Suitable for sewing woven and jeans loopers. The machine is equipped with a flexible rear chopper sy...

Blind Stitch Machine

Brand: SHUNFA

Model: SF 600

Brief:
Shunfa Brand japan type head  SF 600 is a professional, high-speed industrial blind stitch s...

Cloth Tape Cutting Machine Series

Brand: SHUNFA

Model: SF 801A

Brief:
Shunfa brand  semi-automatic, electric fabric strip and bias cutting machine. It is widely u...

Round Cutter Machine

Brand: SHUNFA

Model: SF 125

Brief:
Shunfa brand SF100/SF125 model Round cutting machine 125 mm (5") 40 mm 350W 110/220/240V 50/...

Auto-sharpening Cutting Machine Series

Brand: SHUNFA

Model: SF 3

Brief:
Shunfa brand SF 103 model Auto-sharpening cutting machine. Blade sizes: 6", 8", 10"...

Bag Closer Machine

Brand: SHUNFA

Model: SF 26-1A/GK9-310

Brief:
Shunfa brand SF 26-1A / GK9-310 model Bag closer machine. Needle: DNX1 25# Number of needles: 1 S...

Steam Iron/Gravity Feed Iron

Brand: SHUNFA

Model: SF 60H/SF 300L

Brief:
Shunfa Brand japan type head SF 600 model Steam iron / Gravity feed iron. Voltage 220 V Weight 2....

End Cutter Machine

Brand: SHUNFA

Model: SF 1C

Brief:
SHUNFA BRAND SF 1C MODEL End Cutter Machine  is an industrial-grade, table-mounted fabric cu...

Mini Electric Iron With Boiler

Brand: SHUNFA

Model: SF 75L

Brief:
The SF-75L  is a compact, industrial-grade steam generator iron with a separate boiler. It i...

Automatic Heating Steam Generator

Brand: SHUNFA

Model: SF DX-2

Brief:
Shunfa brand SF DX-2 model Automatic Heating Steam Generator Heating power 12 kW Normal water vol...

Vacuum Iron Table

Brand: SHUNFA

Model: SF DT

Brief:
aShunfa SF-DT is an industrial-grade vacuum ironing table designed for high-efficiency garment fa...

Clutch motor

Brand: SHUNFA

Model: SF 811

Brief:
shunfa brand SF811 model clutch motor. 400W. 2850 r/min.220V ±20% (110V ±20%).
...

Double Head Computerized Heat Transfer Machine

Brand: SHUNFA

Model: SF 4050

Brief:
Temperature and time are electronically controlled; Heating tube and heating plate are integrated...

Pneumatic Heat Press

Brand: SHUNFA

Model: SF H10

Brief:
SHUNFA BRAND SF H10 MODEL  industrial, pneumatic flat heat press designed for precision fabr...

Manual Heat Transfer Machine

Brand: SHUNFA

Model: SF B38

Brief:
Temperature and time are electronically controlled; Heating tube and heating plate are integrated...

Fusing Machine

Brand: SHUNFA

Model: SF H500

Brief:
Shunfa brand  SF-H500 is an industrial continuous-feed fusing press designed for fusing inte...

Skiving Machine

Brand: SHUNFA

Model: SF 801

Brief:
1SHUNFA BRAND JAPAN TYPE HEAD,  heavy-duty industrial leather skiving machine designed to sh...

Automatic Button Feeder

Brand: SHUNFA

Model: SF 373D-988A

Brief:
Special features: 1.Hd touch panel , PLC system, more stable of the software, more intuitive of t...

High Speed Direct Drive Button Holing Machine

Brand: SHUNFA

Model: SF 781EFS

Brief:
JUKI TYPE, JAPAN TYPE HEAD,  HIGH SPEED , DIRECT DRIVE, COMPUTERIZED SEMI-DRY HEAD, STRAIGHT...

Electronic Eyelet Button Holing Machine

Brand: SHUNFA

Model: SF 9820

Brief:
BRAND: SHUNFA MODEL: SF-9820 JAPAN TYPE HEAD, HIGH SPEED , DIRECT DRIVE, SEMIDRY HEAD, JAPAN HOOK...

Computerized Button Attach Machine

Brand: SHUNFA

Model: SF 1903

Brief:
JUKI JAPAN TYPE HEAD, HIGH SPEED , DIRECT DRIVE, SEMIDRY HEAD, ELECTRONIC COMPUTERIZED BARTACKING...

Computerized Button Attach Machine

Brand: SHUNFA

Model: SF 438D

Brief:
BRAND: SHUNFA MODEL: SF-438D BROTHER TYPE HEAD, HIGH SPEED , DIRECT DRIVE, SEMIDRY HEAD, JAPAN HO...

Computerized Bartacking Machine

Brand: SHUNFA

Model: SF 1900

Brief:
JAPAN TYPE HEAD, HIGH SPEED , DIRECT DRIVE, SEMIDRY HEAD, ELECTRONIC COMPUTERIZED BARTACKING MACH...

Computerized Bartacking Machine

Brand: SHUNFA

Model: SF 430D

Brief:
BRAND: SHUNFA MODEL: SF-430D BROTHER TYPE HEAD, HIGH SPEED , DIRECT DRIVE, SEMIDRY HEAD, JAPAN HO...

Round cutting machine

Brand: SHUNFA

Model: SF 100/125

Brief:
Shunfa brand SF100/SF125 model Round cutting machine 125 mm (5") 40 mm 350W 110/220/240V 50/...

1-4 Needles Flat-Bed Double Chain Stitch Machine With Horizontal Looper Movement Mechanism

Brand: SHUNFA

Model: SF 1508P

Brief: Product Description Lap seaming, attaching waistbands and line tapes, and inserting elastic. Major f...

High speed direct drive button holing machine

Brand: SHUNFA

Model: SF 781D

Brief:
SHUNFA BRAND SF 781D MODEL JAPAN TYPE HEAD, HIGH SPEED , DIRECT DRIVE, COMPUTERIZED SEMI-DRY HEAD...

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

(default) 14 queries took 1 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Config`.`key`, `Config`.`value` FROM `shunfabd_main`.`configs` AS `Config` WHERE 1 = 137370
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` ASC660
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` = 15 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` = 'special-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` = 427271
14SELECT `Brand`.`id`, `Brand`.`name` FROM `shunfabd_main`.`brands` AS `Brand` WHERE 1 = 1990