Category Wise Product List

Intelligent Button Machine

Brand: SHUNFA

Model: SF 9918

Brief: Function: Basic Surface button Deep throat (mm): 117 Buckling speed: 60 pieces/min Voltage(v): 220 P...

Intelligent Button Machine

Brand: SHUNFA

Model: SF 9815

Brief: Function: Basic Surface button Deep throat (mm): 117 Buckling speed: 60 pieces/min Voltage(v): 220 P...

Intelligent Button Machine

Brand: SHUNFA

Model: SF 9915

Brief: Function: Basic Surface button Deep throat (mm): 117 Buckling speed: 60 pieces/min Voltage(v): 220 P...

Intelligent Button Machine

Brand: SHUNFA

Model: SF 9828

Brief: Function: Basic Surface button Deep throat (mm): 117 Buckling speed: 60 pieces/min Voltage(v): 220 P...

Intelligent Button Machine

Brand: SHUNFA

Model: SF 9813

Brief: Function: Basic Surface button Deep throat (mm): 117 Buckling speed: 60 pieces/min Voltage(v): 220 P...

Intelligent Button Machine

Brand: SHUNFA

Model: SF 9816

Brief: Function: Basic Surface button Deep throat (mm): 117 Buckling speed: 60 pieces/min Voltage(v): 220 P...

BUTTON ATTACHING MACHINE

Brand: SHUNFA

Model: SF 9811

Brief: Features: Safe and efficient, like Baymax the robot, always protecting the operator. ✔ Universal m...

Direct Drive High Speed Button Attaching Machine

Brand: SHUNFA

Model: SF 1377/TY

Brief:
Shunfa brand  SF 1377/T is a single-thread, chain-stitch Direct Drive High-Speed Button Atta...

Snap button machine

Brand: SHUNFA

Model: SF 808

Brief: a

Pneumatic Button Machine

Brand: SHUNFA

Model: SF 2808

Brief: 1

Direct Drive High Speed Button Attaching Machine

Brand: SHUNFA

Model: SF 373D/SF 1377D

Brief:
aThe Shunfa SF 373D and SF 1377D are heavy-duty, industrial lockstitch button sewing machines use...

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` = 'button-attaching-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` = 511111
14SELECT `Brand`.`id`, `Brand`.`name` FROM `shunfabd_main`.`brands` AS `Brand` WHERE 1 = 1990