The 16pcs silverware set including 4 dinner knives, 4 dinner forks, 4 salad forks, 4 dinner spoons, and 4 tea spoons, for 4 people dining needs.
The crafted sizes to suit any occasion, ideal for home daily use and also perfect for restaurants, cafes, pubs, and hotels
This high quality cutlery set is normally produced by 18/10 ss or 18/8ss, if customer wants to change the material for better cost, pls be free to contact us.
The classic and timeless minimalist design easily matches all types of table settings and is perfect for weddings, housewarming, or Mother's Day gifts.
SHOW FULL COLUMNS FROM `fc_products` [ RunTime:0.001061s ]
SELECT p.*, pt.name AS product_type_name, pt.slug AS product_type_slug, fst.name AS set_type_name, fst.slug AS set_type_slug, COALESCE(pt.name, fst.name, "Flatware") AS category_name FROM `fc_products` `p` LEFT JOIN `fc_product_types` `pt` ON `pt`.`id`=`p`.`product_type_id` LEFT JOIN `fc_flatware_set_types` `fst` ON `fst`.`id`=`p`.`flatware_set_type_id` WHERE `p`.`slug` = 'high-quality-mirror-polish-18-10-stainless-steel-cutlery-set-for-5-star-hotel-using' AND `p`.`status` = 'published' AND `p`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000770s ]
SHOW FULL COLUMNS FROM `fc_product_images` [ RunTime:0.000799s ]
SELECT * FROM `fc_product_images` WHERE `product_id` = '23' ORDER BY `type` ASC,`sort` ASC,`id` ASC [ RunTime:0.000742s ]
SHOW FULL COLUMNS FROM `fc_product_attributes` [ RunTime:0.001010s ]
SELECT `a`.`attr_group`,`a`.`name` FROM `fc_product_attributes` `pa` INNER JOIN `fc_attributes` `a` ON `a`.`id`=`pa`.`attribute_id` WHERE `pa`.`product_id` = '23' AND `a`.`attr_group` IN ('finish','material','application') AND `a`.`status` = '1' AND `a`.`delete_time` IS NULL ORDER BY `a`.`sort` ASC,`a`.`id` ASC [ RunTime:0.000775s ]
SHOW FULL COLUMNS FROM `fc_product_collections` [ RunTime:0.000817s ]
SELECT `c`.`name` FROM `fc_product_collections` `pc` INNER JOIN `fc_collections` `c` ON `c`.`id`=`pc`.`collection_id` WHERE `pc`.`product_id` = '23' AND `c`.`status` = '1' AND `c`.`delete_time` IS NULL ORDER BY `pc`.`sort` ASC,`c`.`sort` ASC [ RunTime:0.000735s ]
SHOW FULL COLUMNS FROM `fc_flatware_set_items` [ RunTime:0.000976s ]
SELECT `item_name`,`quantity` FROM `fc_flatware_set_items` WHERE `set_product_id` = '23' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001398s ]
SELECT `p`.`id`,`p`.`name`,`p`.`slug`,`p`.`main_image` FROM `fc_products` `p` LEFT JOIN `fc_product_collections` `pc_related` ON `pc_related`.`product_id`=`p`.`id` LEFT JOIN `fc_collections` `c_related` ON `c_related`.`id`=pc_related.collection_id AND c_related.status = 1 AND c_related.delete_time IS NULL AND c_related.slug IN ('recommended', 'featured') WHERE `p`.`id` <> '23' AND `p`.`product_kind` = 'set' AND `p`.`status` = 'published' AND `p`.`delete_time` IS NULL AND `p`.`flatware_set_type_id` = '2' GROUP BY `p`.`id` ORDER BY MAX(CASE WHEN c_related.slug = 'recommended' THEN 2 WHEN c_related.slug = 'featured' THEN 1 ELSE 0 END) DESC,`p`.`sort` ASC,`p`.`id` DESC LIMIT 8 [ RunTime:0.000987s ]
SELECT * FROM `fc_product_images` WHERE `product_id` IN ('105','102','93','91','90','89') AND `type` IN ('main','gallery') ORDER BY FIELD(type, 'main', 'gallery'),`sort` ASC,`id` ASC [ RunTime:0.000837s ]
SELECT `pa`.`product_id`,`a`.`attr_group`,`a`.`name` FROM `fc_product_attributes` `pa` INNER JOIN `fc_attributes` `a` ON `a`.`id`=`pa`.`attribute_id` WHERE `pa`.`product_id` IN ('105','102','93','91','90','89') AND `a`.`attr_group` IN ('finish','material','application') AND `a`.`status` = '1' AND `a`.`delete_time` IS NULL ORDER BY `a`.`sort` ASC,`a`.`id` ASC [ RunTime:0.000953s ]
SELECT `a`.`attr_group`,`a`.`slug` FROM `fc_product_attributes` `pa` INNER JOIN `fc_attributes` `a` ON `a`.`id`=`pa`.`attribute_id` WHERE `pa`.`product_id` = '23' AND `a`.`attr_group` IN ('finish','material','application') AND `a`.`status` = '1' AND `a`.`delete_time` IS NULL [ RunTime:0.001576s ]
CREATE TABLE IF NOT EXISTS `fc_markets` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(120) NOT NULL,
`slug` VARCHAR(160) NOT NULL,
`description` TEXT NULL,
`image` VARCHAR(500) NULL,
`seo_title` VARCHAR(255) NULL,
`seo_description` VARCHAR(500) NULL,
`sort` INT UNSIGNED NOT NULL DEFAULT 100,
`status` TINYINT UNSIGNED NOT NULL DEFAULT 1,
`created_at` DATETIME NULL,
`updated_at` DATETIME NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `idx_fc_markets_slug` (`slug`),
KEY `idx_fc_markets_status_sort` (`status`, `sort`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.002923s ]
CREATE TABLE IF NOT EXISTS `fc_product_markets` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`product_id` BIGINT UNSIGNED NOT NULL,
`market_id` BIGINT UNSIGNED NOT NULL,
`sort` INT UNSIGNED NOT NULL DEFAULT 100,
`created_at` DATETIME NULL,
`updated_at` DATETIME NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `idx_fc_product_markets_product_market` (`product_id`, `market_id`),
KEY `idx_fc_product_markets_market_sort` (`market_id`, `sort`),
KEY `idx_fc_product_markets_product` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.002492s ]
SHOW FULL COLUMNS FROM `fc_markets` [ RunTime:0.000721s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'north-america' LIMIT 1 [ RunTime:0.000388s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'south-america' LIMIT 1 [ RunTime:0.000464s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'europe' LIMIT 1 [ RunTime:0.000506s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'asia' LIMIT 1 [ RunTime:0.000302s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'middle-east' LIMIT 1 [ RunTime:0.000378s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'africa' LIMIT 1 [ RunTime:0.000334s ]
SELECT `name`,`slug` FROM `fc_markets` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000501s ]
CREATE TABLE IF NOT EXISTS `fc_markets` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(120) NOT NULL,
`slug` VARCHAR(160) NOT NULL,
`description` TEXT NULL,
`image` VARCHAR(500) NULL,
`seo_title` VARCHAR(255) NULL,
`seo_description` VARCHAR(500) NULL,
`sort` INT UNSIGNED NOT NULL DEFAULT 100,
`status` TINYINT UNSIGNED NOT NULL DEFAULT 1,
`created_at` DATETIME NULL,
`updated_at` DATETIME NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `idx_fc_markets_slug` (`slug`),
KEY `idx_fc_markets_status_sort` (`status`, `sort`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.002476s ]
CREATE TABLE IF NOT EXISTS `fc_product_markets` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`product_id` BIGINT UNSIGNED NOT NULL,
`market_id` BIGINT UNSIGNED NOT NULL,
`sort` INT UNSIGNED NOT NULL DEFAULT 100,
`created_at` DATETIME NULL,
`updated_at` DATETIME NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `idx_fc_product_markets_product_market` (`product_id`, `market_id`),
KEY `idx_fc_product_markets_market_sort` (`market_id`, `sort`),
KEY `idx_fc_product_markets_product` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.002767s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'north-america' LIMIT 1 [ RunTime:0.000407s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'south-america' LIMIT 1 [ RunTime:0.000419s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'europe' LIMIT 1 [ RunTime:0.000780s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'asia' LIMIT 1 [ RunTime:0.000573s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'middle-east' LIMIT 1 [ RunTime:0.000651s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'africa' LIMIT 1 [ RunTime:0.000411s ]
SELECT `name`,`slug` FROM `fc_markets` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000515s ]