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: a

Auto-sharpening Cutting Machine Series

Brand: SHUNFA

Model: SF 3

Brief:
a

Bag Closer Machine

Brand: SHUNFA

Model: SF 26-1A/GK9-310

Brief: a

Steam Iron/Gravity Feed Iron

Brand: SHUNFA

Model: SF 60H/SF 300L

Brief: a

End Cutter Machine

Brand: SHUNFA

Model: SF 1C

Brief: a

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: a

Vacuum Iron Table

Brand: SHUNFA

Model: SF DT

Brief: a

Energy Saving Motor

Brand: SHUNFA

Model: SF 811

Brief: a

Double Head Computerized Heat Transfer Machine

Brand: SHUNFA

Model: SF 4050

Brief: a

Pneumatic Heat Press

Brand: SHUNFA

Model: SF H10

Brief: a

Manual Heat Transfer Machine

Brand: SHUNFA

Model: SF B38

Brief: a

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 ...

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 ...

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 ...

Round cutting machine

Brand: SHUNFA

Model: SF 100/125

Brief: a

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: a

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

(default) 14 queries took 5 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` ASC001
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` = 'special-machine' LIMIT 1111
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 = 1991