SHOW FULL COLUMNS FROM `fc_products` [ RunTime:0.001155s ]
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` = 'wholesale-jieyang-factory-direct-high-end-gift-86pcs-ss-flat-cutlery-set' AND `p`.`status` = 'published' AND `p`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000987s ]
SHOW FULL COLUMNS FROM `fc_product_images` [ RunTime:0.000920s ]
SELECT * FROM `fc_product_images` WHERE `product_id` = '51' ORDER BY `type` ASC,`sort` ASC,`id` ASC [ RunTime:0.000596s ]
SHOW FULL COLUMNS FROM `fc_product_attributes` [ RunTime:0.000940s ]
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` = '51' 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.000770s ]
SHOW FULL COLUMNS FROM `fc_product_collections` [ RunTime:0.000839s ]
SELECT `c`.`name` FROM `fc_product_collections` `pc` INNER JOIN `fc_collections` `c` ON `c`.`id`=`pc`.`collection_id` WHERE `pc`.`product_id` = '51' AND `c`.`status` = '1' AND `c`.`delete_time` IS NULL ORDER BY `pc`.`sort` ASC,`c`.`sort` ASC [ RunTime:0.000751s ]
SHOW FULL COLUMNS FROM `fc_flatware_set_items` [ RunTime:0.001010s ]
SELECT `item_name`,`quantity` FROM `fc_flatware_set_items` WHERE `set_product_id` = '51' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000483s ]
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` <> '51' AND `p`.`product_kind` = 'set' AND `p`.`status` = 'published' AND `p`.`delete_time` IS NULL AND `p`.`flatware_set_type_id` = '6' 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.001078s ]
SELECT * FROM `fc_product_images` WHERE `product_id` IN ('61','54','111','110','64','45','44') AND `type` IN ('main','gallery') ORDER BY FIELD(type, 'main', 'gallery'),`sort` ASC,`id` ASC [ RunTime:0.000885s ]
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 ('61','54','111','110','64','45','44') 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.000994s ]
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` = '51' AND `a`.`attr_group` IN ('finish','material','application') AND `a`.`status` = '1' AND `a`.`delete_time` IS NULL [ RunTime:0.000773s ]
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.003074s ]
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.002604s ]
SHOW FULL COLUMNS FROM `fc_markets` [ RunTime:0.001014s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'north-america' LIMIT 1 [ RunTime:0.000530s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'south-america' LIMIT 1 [ RunTime:0.000518s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'europe' LIMIT 1 [ RunTime:0.000457s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'asia' LIMIT 1 [ RunTime:0.000532s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'middle-east' LIMIT 1 [ RunTime:0.000495s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'africa' LIMIT 1 [ RunTime:0.000439s ]
SELECT `name`,`slug` FROM `fc_markets` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000560s ]
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.003101s ]
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.002954s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'north-america' LIMIT 1 [ RunTime:0.000728s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'south-america' LIMIT 1 [ RunTime:0.000554s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'europe' LIMIT 1 [ RunTime:0.000646s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'asia' LIMIT 1 [ RunTime:0.000571s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'middle-east' LIMIT 1 [ RunTime:0.000662s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'africa' LIMIT 1 [ RunTime:0.000599s ]
SELECT `name`,`slug` FROM `fc_markets` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000718s ]